Hi,
For some times some people are reporting that plugins using pyspatialite are
not working anymore with the KyngChaos packaging for OSX (2.14 or 2.18)
The error is usually:
OperationalError('no such module: VirtualSpatialIndex',)
when trying to référence SpatialIndex in spatial requests.
After investigation it appears that errors occurs when trying to use spatialite
functions…
The fact is, when using pyspatialite directly from python: the spatialite
extension is not loaded.
cur.execute('SELECT spatialite_version()')
> OperationalError: no such function: spatialite_version
and so on for any SELECT involving spatialite functions.
This can be explained easily has the pyspatialite python package is only a link
to the pysqlite2 python package, and thus, do not load the the spatialite
module.
Furthemore loading extension is disabled in the KyngChaos sqlite3 package, so
we are stuck in that the pyspatialite provided by KyngChaos is useless as
standalone library and do not enable plugins to make direct calls to
spatialite.
Is there any reason for this situation or this should be considered as a bug ??
Actually, the native OSX sqlite3 python binding do not enable leading
extensions, this was preventing using spatialite from python. This constraint
has been removed recently in Macport, which now enables to use spatialite with
python without relying on pyspatialite.
David.
_______________________________________________
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
