Hi Raymond, your code looks good.
Can you provide a test file? There are some test in core here: https://github.com/qgis/QGIS/blob/master/tests/src/python/test_qgsproviderconnection_ogr_gpkg.py On Thu, Mar 31, 2022 at 6:09 PM Raymond Nijssen via QGIS-Developer < qgis-developer@lists.osgeo.org> wrote: > Hi devs, > > I'm working on a plugin that connects to a custom table (without > geometry) in a GPKG. When I'm sending queries to it, I keep on getting > unexpected results. Somehow the id field is missing, sometimes it > appears twice (!). And this seems to be different between QGIS 3.10 and > 3.25. (I think it changed since 3.22). > > Here is a piece of my code: > > > fn = '/path/to/test.gpkg' > md = QgsProviderRegistry.instance().providerMetadata('ogr') > conn = md.createConnection(fn, {}) > > q = 'select * from test_table;' > qr = conn.executeSql(q) > print(qr) # No id field in result > > > > Before diving into the QGIS code I'd like to check if this is the way to > go. Or should i use another way to query that GPKG (SQLite) db? > > > Kind regards, > Raymond > _______________________________________________ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer > -- Alessandro Pasotti QCooperative: www.qcooperative.net ItOpen: www.itopen.it
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
