[Patch] Custom query for the spatialite provider

[brushtyler]

This patch enhances the spatialite provider capabilities allowing users to load a spatialite layer using a custom query (as the one previously developed for the postgres provider).

[brushtyler]

patch

[esseffe]

I've applied the patch suggested by brushtyler Committed in r.14435

[lmotta]

When in select statement have only the pkuid's column, the attributes's table didn't showed the values of pkuid. Obs: The identify is OK. The problem is the table of layer Otherwise (have others columns) all attributes showed in table

Example with error(only pkuid): sql = "select t.id as pkuid,t.the_geom as geometry from test t limit 10" uri = QgsDataSourceURI() uri.setDatabase('/home/lmotta/bd_gis/spatialite/gis.sqlite') uri.setDataSource(, '(%s)' % sql, 'geometry', , 'pkuid') qgis.utils.iface.addVectorLayer(uri.uri(), "Select", 'spatialite')

Example correct (more columns): sql = "select t.id as pkuid, t.name, t.the_geom as geometry from test t limit 10" ...

[brushtyler]

The one you talk about it's a bug. Why did you re-open a closed patch ticket about a different problem?

Indeed the patch improved QGis adding a missing feature. You should open a proper ticket, a bug ticket.

[brushtyler]

Replying to brushtyler:

Replying to lmotta:

When in select statement have only the pkuid's column, the attributes's table didn't showed the values of pkuid.

Why did you re-open a closed patch ticket about a different problem? You should open a proper ticket, a bug ticket.

I close this ticket. See #3356, the ticket related to the bug you had reported.

[lmotta]

Sorry reopen this ticket and thanks, twice, explained how make ticket about bug in this feature and make the fix the ticket 3356