Hi Stefan, Better read this one (below) to fix some of the problems you mentioned.
http://www.gaia-gis.it/spatialite-2.4.0-4/splite-python.html Please note on this caveat found in the document above. "Caveat The most recent QGIS versions (1.6 / 1.7 trunk) are actually using SpatiaLite v.2.4.0 so any Python plugin using the previous v.2.3.1 can easily cause conflicts due to version incompatilibiles. And this fully accounts for any issue noticed by QGIS users". Noli On 4/29/11, Stefan Keller <sfkel...@gmail.com> wrote: > Hello, > > We are currently developing a Python Plugin for QGIS. We use > SpatiaLite to manage some data. What we want to do is, querying a > SpatiaLite database from a Python Plugin. We were able to get it to > work with SQLite, using the following code: > > self.db = QSqlDatabase.addDatabase("QSQLITE") > self.db.setDatabaseName("path.to.db.file") > if self.db.open() == False: > raise "Connection Error!" > query = QSqlQuery(self.db) > query.exec_("SELECT sqlite_version()") > if query.isActive(): > print str(query.value(0).toString()) # > else: > raise str(query.lastError().databaseText ()) > query.finish() > > But when we try using a spatialite-function, like "SELECT > spatialite_version()", the query fails with "no such function: > spatialite_version". We tried to load the spatialite-Extension > manually, using "SELECT load_extension('libspatialite-2.dll');", but > that resulted in an exception "not authorized". > > Our question is: What has to be done to use spatialite in a python-plugin? > > There is pyspatialite(http://code.google.com/p/pyspatialite/), but we > would prefer using libraries already included in QGIS. > Thanks for your help. > > Yours, Stefan and Tobias > _______________________________________________ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer > _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer