Why a cover added after the manhole creation is not visible in vw_qgep_wastewater_structure

[rbovard]

Imagine I delete a cover related to a manhole, I want to recreate it specifing its fk_wastewater_structure.

But in this case, even I have only one cover related to this manhole, it doesen't appear in vw_qgep_wastewater_structure (empty co_obj_id).

Cover created at the same time as the manhole

Cover created after the manhole

So how can I specify my unique cover as main cover?

[sjib]

You have to manually set the fk_main_cover in class wastewater_structure. There is no UI face yet for that.

[rbovard]

Okay I see, thanks.

But can't we imagine to add a mechanism to get the FK if there is only 1 cover?

[sjib]

It already exists:

wastewater/datamodel/app/symbology_functions.sql

Line 290 in 93f00d1

-- UPDATE wastewater structure fk_main_cover

You can run that tww_app.wastewater_structure_update_fk_main_cover manually

_all is a bool variable. The function can be called tww_app.wastewater_structure_update_fk_main_cover (NULL, True) to update all or tww_app.wastewater_structure_update_fk_main_cover (obj_id) to update a specific entry.

See also #264

[rbovard]

Thanks! That was exactly what I was looking for, I've added that in my nightly cron.