Re: [Qgis-developer] Spatialite ’select’ statement as vector layer in QGIS

[Ricardo Filipe Soares Garcia da]

Hi all
In fact, I have a plugin that allows to load custom spatialite queries
to the map canvas. I started it as a pet project, to see if I could
improve my Qt skills ;)

Currently it is really crude. I can make it available at the
experimental repository if you are interested.
My initial goal was to make something that could be made to work for
spatialite and postgis alike. Currently, only the spatialite part
works (and just barely).

I was trying to make a more stripped plugin, that I could just use to
write some SQL and see the results in 3 ways:

- directly over the map canvas, creating a temporary layer (that
cannot be edited), a la RT SQL style  <- this already works and it
seems to be what you want;
- saving a new layer to the database, based on the query, and
immediately loading it to the canvas <- not implemented (yet);
- just making a normal query, without visualizing the results in the
map canvas <- not implemented (yet).


On Wed, Dec 8, 2010 at 4:27 PM, Giuseppe Sucameli <sucameli at faunalia.it> wrote:
> Hi Noli,
>
> On Wed, Dec 8, 2010 at 11:00 AM, Noli Sicad <nsicad at gmail.com> wrote:
>>
>> Would be possible to be implemented for Spatialite Manager so it can
>> do the same thing for Spatialite (i.e. Spatialite ’select’ statement
>> as vector layer in QGIS)?
>
> in this moment the SL_manager doesn't allow to do this, but the spatialite
> provider supports it yet (see [1]).
>
>> Or is this already implemented in Spatialite Manager plugin?
>
> No, I'm sorry.
> BTW you can use the python console and the code snippet you find at the
> previous
> link, obviously after adapting it to your needs.
>
> SL_manager needs some work, it exports very few functionalities compared to
> PG_manager... But in this moment we've no time to improve it.
> If anyone want help us in developing it, i.e. providing patches, they're
> welcome.
>
> Cheers.
>
> [1] http://www.mail-archive.com/qgis-developer@lists.osgeo.org/msg00878.html
>
>> Thanks.
>>
>> Regards,
>>
>> Noli
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
>
> --
> Giuseppe Sucameli
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>



-- 
___________________________ ___ __
Ricardo Garcia Silva