edisgo.io.mviews_filters

Functions

build_conv_scenario_filter(orm_table, scenario[, ...])

Build filter conditions for conventional power plants matching mview logic.

build_res_scenario_filter(orm_table, scenario[, ...])

Build filter conditions for renewable power plants matching mview logic.

Module Contents

edisgo.io.mviews_filters.build_conv_scenario_filter(orm_table, scenario, version=None, preversion='v0.3.0')

Build filter conditions for conventional power plants matching mview logic.

Parameters:
  • orm_table (SQLAlchemy Table) – The ORM table object (e.g., ego_dp_conv_powerplant)

  • scenario (str) – Scenario name (‘NEP 2035’, ‘eGo 100’, ‘Status Quo’)

  • version (str or list, optional) – Version filter. If None, uses defaults based on scenario.

  • preversion (str, default 'v0.3.0') – Preversion filter

Returns:

Combined filter matching the mview definition

Return type:

SQLAlchemy filter condition

edisgo.io.mviews_filters.build_res_scenario_filter(orm_table, scenario, version=None, preversion='v0.3.0')

Build filter conditions for renewable power plants matching mview logic.

IMPORTANT: NEP 2035 mview is a UNION of Status Quo + NEP 2035 generators! The mview definition shows that ego_dp_res_powerplant_nep2035_mview contains BOTH Status Quo (solar/wind only, excl. offshore) AND NEP 2035 generators.

Parameters:
  • orm_table (SQLAlchemy Table) – The ORM table object (e.g., ego_dp_res_powerplant)

  • scenario (str) – Scenario name (‘NEP 2035’, ‘eGo 100’, ‘Status Quo’)

  • version (str or list, optional) – Version filter. If None, uses defaults based on scenario.

  • preversion (str, default 'v0.3.0') – Preversion filter

Returns:

Combined filter matching the mview definition

Return type:

SQLAlchemy filter condition