Improvement INTERLIS export (selection)

[sjib]

Add missing re_tables in configuration (database tables exist already)

• [ ] re_maintenance_event_wastewater_structure
• [ ] re_building_group_disposal - see https://github.com/teksi/wastewater/issues/307

[sjib]

export selection dss: what to do here? gesamteinzugsgebiet.fk_einleitstelle is MANDATORY, but this Einleitstelle might not be in selection

• [ ] add einleitstelle to selection? Would need new functionality see also https://github.com/teksi/wastewater/pull/266#issuecomment-2197134561

[sjib]

• [ ] Why do we still have this logger.warning? - see https://github.com/teksi/wastewater/pull/266#issuecomment-2203378834

[sjib]

• [ ] Check if filter for param_ca_general and param_ca_mouse1 can be linked with catchment_area filter successfully

Currentyl: query = query.filter( self.model_classes_tww_od.param_ca_general.objid.in(self.subset_ids)

query = query.filter( self.model_classes_tww_od.param_ca_mouse1.objid.in(self.subset_ids)

Tried version: https://github.com/teksi/wastewater/pull/266#issuecomment-2207063078

        query = query.join(
            self.model_classes_tww_od.catchment_area,
            self.model_classes_tww_od.wastewater_networkelement,
            or_(
                self.model_classes_tww_od.wastewater_networkelement.obj_id
                == self.model_classes_tww_od.catchment_area.fk_wastewater_networkelement_rw_planned,
                self.model_classes_tww_od.wastewater_networkelement.obj_id
                == self.model_classes_tww_od.catchment_area.fk_wastewater_networkelement_rw_current,
                self.model_classes_tww_od.wastewater_networkelement.obj_id
                == self.model_classes_tww_od.catchment_area.fk_wastewater_networkelement_ww_planned,
                self.model_classes_tww_od.wastewater_networkelement.obj_id
                == self.model_classes_tww_od.catchment_area.fk_wastewater_networkelement_ww_current,
            ),
        ).filter(
            self.model_classes_tww_od.wastewater_networkelement.obj_id.in_(self.subset_ids)
        )

E sqlalchemy.exc.AmbiguousForeignKeysError: Can't determine join between 'Join object on Join object on surface_runoff_parameters(139990536639488) and param_ca_general(139990536638672)(139990553374128) and catchment_area(139990536642368)' and 'wastewater_networkelement'; tables have more than one foreign key constraint relationship between them. Please specify the 'onclause' of this join explicitly.

[sjib]

Test if filter with union work better using this structure:

• [ ] _export_measuring_point

union: q3 = q1.union(q2) instead of query = query.union(query1, query2) see https://docs.sqlalchemy.org/en/14/orm/query.html#sqlalchemy.orm.Query.union