[QGIS-Developer] Create plain table (without geometry) in gpkg?

[Even Rouault]

On mardi 23 juin 2020 15:34:58 CEST Raymond Nijssen wrote:
> My python plugin should create a table without geometry in a gpkg to
> store some additional (meta) info about the layers. I could use python
> bindings for sqlite of course, but the plugin users might not have that
> installed.
> 
> What are the options from within qgis? Is python-sqlite available, or
> can I run sql queries in antother way? Or can I create a table similar
> to creating a new maplayer?
> 
> My (ugly) solution would be creating a point layer and use that
> attribute table and storing POINT(0 0) as geometries.
> Or even worse, creating a .csv sidecar file for my gpkg.
> 
> Hope anyone here knows a better solution!

Raymond,

You should be able to just use the normal QGIS vector API for that. For example 
QgsVectorFileWriter.create() with geometryType = NoGeometry

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200623/480431c1/attachment.html>