pipe_section : cascading values for value lists

[jpdupuy]

Whenever the end user introduces data in the pipe_section form, there is no control on the inner, outer, nominal diameter which are allowed with the previously selected pipe material (pipeline_quality).
This issue has been raised by the initiators of the TDH module during the presentation I gave.

This mechanism exist in the TWW and TWA module, and should be implemented in the TDH module.
The development guide should also explain how to handle this issue (both datamodel and QGIS form side)

Reference pipe material catalog : https://github.com/qwat/qwat-data-model/blob/master/value_lists/vl_pipe_material.sql

[sjib]

• ajouter catalogue @jpdupuy

[sjib]

• check on qwat how this is implemented
• check if this is a good way how to implement this kind of catalogue on all TEKSI module
• implement in tdh
• document in Developers how to implement this in a QGIS project

[jpdupuy]

Please find the catalog (ref page 209)
13.4 Dimensions et rejets de chaleur spéc. pour tubes pré-isolés en métal, tubes médians en métal et tubes médians en plastique
GdP-CAD_V1.0.pdf

Please find the xls file I have built to load and test in the tdh_vl schema
TDH_pipe_material_dn_catalog.xlsx