Hi all, this morning Sandro Furieri applied my patch and now it's in trunk. See [1]. Cheers.
[1] https://trac.osgeo.org/qgis/changeset/14435 On Thu, Oct 21, 2010 at 11:35 PM, Giuseppe Sucameli <sucam...@faunalia.it>wrote: > Hi devs, > > a few days ago I wrote a patch to load a spatialite layer using a custom > query. > It works in the same manner as it was done for the postgres provider. > > Here the ticket [1]. > > I know that Nov 23 starts the feature freeze, but I hope we can include it > in QGis1.6. > I did many tests and seems it works fine. > > The following is a python code snippet of its usage: > > sql = "SELECT t.PK_UID, t.Name, (t.Peoples/1000) AS KPeoples, t.Geometry > FROM Towns AS t, Regions AS r WHERE r.Name = 'TOSCANA' AND t.Peoples > > 10000 AND Contains(r.Geometry, t.Geometry)", > uri = QgsDataSourceURI() > > uri.setDatabase('/home/brushtyler/Projects/Work/Faunalia/spatialite/test-2.3.sqlite') > uri.setDataSource('', '(%s)' % sql, 'Geometry', '', 'PK_UID') > qgis.utils.iface.addVectorLayer(uri.uri(), "Towns in RT", 'spatialite') > > > Cheers. > > [1] https://trac.osgeo.org/qgis/ticket/3139 > > -- > Giuseppe Sucameli > > -- Giuseppe Sucameli
_______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
