[QGIS-Developer] Removal of PostGISExecuteSQL.py in 3.14

[Nyall Dawson]

On Tue, 14 Jul 2020 at 05:16, Nils Nolde <nilsnolde at gmail.com> wrote:
>
> Thanks for the heads up Etienne! That’s great:)

Just to add to Etienne's answer: if you don't have the time to port
the plugin to the new database connector API, you can grab a copy of
the old (internal) processing class from the 3.12 source and just add
that file to your plugin. It's totally self-contained:

https://github.com/qgis/QGIS/blob/release-3_12/python/plugins/processing/tools/postgis.py

Nyall

>
> On 13. Jul 2020, at 18:02, Etienne Trimaille <etienne.trimaille at gmail.com> wrote:
>
> 
> Le lun. 13 juil. 2020 à 15:59, Nils Nolde <nilsnolde at gmail.com> a écrit :
>>
>> Hi,
>>
>> I just realized that the processing algo PostGISExecuteSQL.py was
>> removed for the 3.14 release.
>
>
> The algorithm has been ported to C++, so yes the python version has been removed.
> https://github.com/qgis/QGIS/blob/master/src/analysis/processing/qgsalgorithmexecutepostgisquery.cpp
> Even calling it from Python will work using the old previous Python processing provider because the compatibility is maintained.
>
>>
>> Some time after processing.tools.postgis
>> module was removed (as the only module using it was PostGISExecuteSQL,
>> but still, it's a public API protected by backwards compatibility right?)
>
>
> Code in plugins (such as Processing or DB Manager) is not considered stable.
> You should use the public API, when it's starting with "from qgis." core, gui, analysis, processing etc
> You should use the new database API.
>
>>
>>
>> Was that a mistake?
>>
>> Cheers
>> Nils
>>
>> _______________________________________________
>> QGIS-Developer mailing list
>> QGIS-Developer at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer