Hi Matteo,

https://api.qgis.org/api/master/classQgsDatabaseQueryLog.html does have appropriate signals (queryFinished and queryStarted, both include the query) but it looks like they are not documented in the Python API https://qgis.org/pyqgis/master/core/QgsDatabaseQueryLog.html

It *looks* like they are exposed though. So try


def do_something_with(query):
  ...
query_log = QgsApplication.databaseQueryLog()
query_log.queryFinished.connect(do_something_with)


If that does not work, maybe the debugging panel itself has a signal you can connect to as a hacky workaround.

Cheers, Hannes

On 04.03.24 17:54, Matteo Ghetta via QGIS-Developer wrote:
Hi devs,

I'm looking for a way in pyqgis to catch the (raw) queries that QGIS is sending to the PostgreSQL provider when a table is edited: for example the raw "INSERT ... INTO ...", "UPDATE ...".

Basically what the Development Panel is listing when enabled. Is there a way in pyqgis?

Cheers and thanks for any suggestion!

Matteo

_______________________________________________
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

--
Johannes Kröger / GIS-Entwickler/-Berater

*********************************************
FOSSGIS Konferenz
20.-23. März 2024 in Hamburg
https://www.fossgis-konferenz.de/2024/

WhereGroup-Beiträge auf der FOSSGIS
https://wheregroup.com/unternehmen/aktuelles/
*********************************************

WhereGroup GmbH
c/o KK03 GmbH
Lange Reihe 29
20099 Hamburg
Germany

Tel: +49 (0)228 / 90 90 38 - 36
Fax: +49 (0)228 / 90 90 38 - 11

johannes.kroe...@wheregroup.com
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------

_______________________________________________
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Reply via email to