[Qgis-developer] Improve server-side compiled expressions for PostGreSQL

[Matthias Kuhn]

Hi Michaël,

No functions are compiled so far (afaik).

One will need to implement this in qgssqlexpressioncompiler or
qgspostgresexpressioncompiler for all the functions involved (I'm not
sure if / to what degree these functions are compatible between
different sql dialects).

Also make sure that any new function which is compiled is unit tested
(providertestbase.py) to make sure it behaves exactly the same when
executed locally and server side - across all providers.

It's a long-standing plan of mine but I haven't found the time (or
contract) for this yet...

Matthias

On 11/15/2016 11:01 AM, kimaidou wrote:
> Hi all,
> 
> I usually work with PostgreSQL data in QGIS.
> I would like to have a guidance on how to improve the set of compiled
> expressions for PostgreSQL. My goal is to propose a PR for some spatial
> function.
> 
> I think the files are here
> src/providers/postgres/qgspostgresexpressioncompiler.cpp
> src/providers/postgres/qgspostgresfeatureiterator.cpp
> 
> For example, I would like the following expression to be compiled server
> side:
> 
>     intersects(
>         $geometry,
>         geom_from_gml(
>            
> '<gml:Polygon+xmlns:gml="http://www.opengis.net/gml"><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates+decimal="."+cs=","+ts="+">MY_GML_COORDINATES</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon>'
>         )
>     )
> 
> where MY_GML_COORDINATES is the GML version of a polygon ring coords.
> 
> What are the required steps to do so, and where ? The result would be
> 
> 
>     ST_Intersects(
>         geom,
>         ST_GeomFromGml( 'the long GML polygon representation')
>     )
> 
> Regards,
> Michaël
> 
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>