I have a Spatialite database with a table called
spatialite_objects, with spatial and non-spatial data.
Another layer is an Oracle Spatial Layer (id, geom) with 2 table joins (based on 2 csv files) called
I use the DB Manager to import this layer to my Spatialite database, successfully.
Now, I want to do this with a QGIS Plugin using Python.
I know to create tables and doing queries with the pyspatialite library (
from pyspatialite import dbapi2 as db). I think about to query the Oracle layer and to fill up the Spatialite table.
Is this the same way the DB Manager does the import? Are there more "direct" commands to import a layer from the Canvas directly to a Spatialite database?