Loading layer from SpatiaLite database, using PyQGIS

Question

I'm new to SpatiaLite and PyQGIS.

I would like to upload a layer from SpatiaLite database. To do this, I tried with this code:

database = r"C:\sqlite\db.sqlite"
uri = QgsDataSourceUri()
uri.setDatabase(database)
schema = ''
table = 'table_name'
geom_column = 'point'
uri.setDataSource(schema, table, geom_column)
display_name = 'table_name'
vlayer = QgsVectorLayer(uri.uri(), display_name, 'spatialite')
QgsProject.instance().addMapLayer(vlayer)

But this doesn't work, the program says:

Unavailable layer! Layer datasource could not be found

I think the problem may be the value of "geom_column". The table has a column called "the_geo", where the row values are POINT(x_value, y_value).

Can you help me?

Did you change geom_column = 'point' with geom_column = 'the_geo' ? — ThomasG77
– ThomasG77, Commented May 17, 2020 at 1:07

MrXsquared · Accepted Answer · 2021-06-21 09:16:29Z

-2

int result;
    QString sql = QStringLiteral("select table_name, type, label_field from kt_master");
    sqlite3_statement_unique_ptr preparedStatement = mDatabase.prepare(sql, result);

QMap<QString, QList<QString>> masterInfo;
masterInfo.clear();

while (preparedStatement.step() == SQLITE_ROW)
{
    QgsDataSourceUri uri = QgsDataSourceUri();
    uri.setDatabase(mFilePath);
    uri.setDataSource("", preparedStatement.columnAsText(0), "geom");

edited Jun 21, 2021 at 9:16

MrXsquared

36.3k22 gold badges79 silver badges128 bronze badges

answered Jun 21, 2021 at 8:58

LCC

1

Add a comment |

Stack Exchange Network

Loading layer from SpatiaLite database, using PyQGIS

1 Answer 1

Your Answer

Hot Network Questions

Loading layer from SpatiaLite database, using PyQGIS

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions