Add button update wastewater symbologies and labels

[sjib]

          These 2 lines did run obviously with the import 

SELECT tww_app.wastewater_structure_update_fk_main_cover('', True);
SELECT tww_app.wastewater_structure_update_fk_main_wastewater_node('', True);

These 3 lines did not run, but must run with the import:
SELECT tww_app.update_wastewater_node_symbology(NULL, True);
SELECT tww_app.update_wastewater_structure_label(NULL, True);
SELECT tww_app.update_wn_symbology_by_overflow(NULL, True);

And additionally: the user should be able to manualy run this lines whenever he wants. -> a new button or command in the ui to start this functions.

Originally posted by @urskaufmann in #260 (comment)

[sjib]

Add code for new button to

wastewater/plugin/teksi_wastewater/teksi_wastewater_plugin.py

Line 146 in 6b2ce4b

def initGui(self):

and define new tool twwupdatewwssymbology.py in \wastewater\plugin\teksi_wastewater\tools

[sjib]

At all - are there any other requests for new buttons? Then please link to this issue.

[sjib]

These 3 lines did not run, but must run with the import:
SELECT tww_app.update_wastewater_node_symbology(NULL, True);
SELECT tww_app.update_wastewater_structure_label(NULL, True);
SELECT tww_app.update_wn_symbology_by_overflow(NULL, True);

Already added to import process - see #263

MIght have to be re-coded if new buttons exist.

[domi4484]

@sjib SELECT tww_app.update_wn_symbology_by_overflow(NULL, True); this is already done inside update_wastewater_node_symbology. Is still needed to exec it again after update_wastewater_structure_label?

[sjib]

@domi4484 The idea is to create a new button "update wastewater symbologies and labels" in the plugin to be able to run these queries not only during the import process but anytime you want to update the symbology (as we can requery the network topology):

SELECT tww_app.update_wastewater_node_symbology(NULL, True);
SELECT tww_app.update_wastewater_structure_label(NULL, True);
SELECT tww_app.update_wn_symbology_by_overflow(NULL, True);

To all: Please vote with thumbs up if you think such a button is a necessary enhancement. Vote with thumb down if you think it is not necessary.

[domi4484]

@sjib in the upper comment I meant that update_wn_symbology_by_overflow is already executed inside update_wastewater_node_symbology at this line:

wastewater/datamodel/app/symbology_functions.sql

Line 66 in e7f1ca2

EXECUTE tww_app.update_wn_symbology_by_overflow(_obj_id, _all);

It means the new button should execute only those queries i guess:

SELECT tww_app.update_wastewater_node_symbology(NULL, True);
SELECT tww_app.update_wastewater_structure_label(NULL, True);

[sjib]

@urskaufmann Is this solved with Pre-release 2024.0.2

[urskaufmann]

Button exists, but I'm not sure, if they really work.
If I disable the triggers, then a calculation is faster. If I enable the triggers, the calculation is slower. But if I disable the triggers and then change the usage_current or the function_hierarchic of a reach, then the symbol of the manhole above changes also - and this calculation is done be the triggers? Or not?

So, how can I test the update symbology-button?

[urskaufmann]

When changing a reachpoint.level, and the triggers are disabled, I can update the label of the manhole with the update button. Seems this works.

But: I run QGIS now twice in a not-responding-mode, while I did disable/enable the triggers several times.