Schneider connectivity #485

New Issue

mpeltriaux · 2025-10-03T13:12:17+02:00

mpeltriaux commented

2025-10-03 13:12:17 +02:00

Status quo

OEK, KOM, EMA, EIV are not available for intersection via schneider since they are not transmitted into the central odatx database. For the new MAUS application intersectons with this data is needed.

ToDo

Schneider has it's own issue for providing the needed data. However, the konova database needs some tweaking before this can work as expected:

All of these steps are only database related. There are no changes to be made on the code:

Create a new schema "verschneidungstool". Name is the same as on odatx database to reduce complexity
Create materialized views for all four data types (oek, kom, ema, eiv)
Create a cron job that updates the materialized views once a day (e.g. somewhere in the night)

# Status quo OEK, KOM, EMA, EIV are not available for intersection via schneider since they are not transmitted into the central odatx database. For the new MAUS application intersectons with this data is needed. # ToDo Schneider has [it's own issue](https://git.naturschutz.rlp.de/IT-Naturschutz/schneider/issues/102) for providing the needed data. However, the konova database needs some tweaking before this can work as expected: All of these steps are *only* database related. There are no changes to be made on the code: * Create a new schema "verschneidungstool". Name is the same as on odatx database to reduce complexity * Create materialized views for all four data types (oek, kom, ema, eiv) * Create a cron job that updates the materialized views once a day (e.g. somewhere in the night)

mpeltriaux added the

feature

label 2025-10-03 13:12:17 +02:00

mpeltriaux self-assigned this 2025-10-03 13:12:17 +02:00

mpeltriaux commented

2025-10-03 13:48:37 +02:00

New schema verschneidungstool has been created in database konova.
New materialized views have been created:

intervention_all --> all EIVs
intervention_recorded --> only recorded EIVs
compensation_all --> all KOMs
compensation_recorded --> only recorded KOMs
ecoaccount_all --> all OEKs
ecoaccount_recorded --> only recorded OEKs
ema_all --> all EMAs
ema_recorded --> only recorded EMAs

User postgres on database server now has a new cron job which runs every night at 01:00 am and refreshs all materialized views in the new schema.

New schema `verschneidungstool` has been created in database `konova`. New materialized views have been created: * `intervention_all` --> all EIVs * `intervention_recorded` --> only recorded EIVs * `compensation_all` --> all KOMs * `compensation_recorded` --> only recorded KOMs * `ecoaccount_all` --> all OEKs * `ecoaccount_recorded` --> only recorded OEKs * `ema_all` --> all EMAs * `ema_recorded` --> only recorded EMAs User postgres on database server now has a new cron job which runs every night at 01:00 am and refreshs all materialized views in the new schema.

mpeltriaux closed this issue

2025-10-03 13:48:37 +02:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: IT-Naturschutz/konova#485