edisgo.io.mviews_replacement.MviewsReplacement

class edisgo.io.mviews_replacement.MviewsReplacement(engine)

Replacement class for loading data from deprecated mviews.

This class provides methods to query base tables directly instead of using materialized views, applying the same filter logic as the original mview definitions.

engine
get_conv_powerplant(scenario, version=None, preversion='v0.3.0', schema='data', table_name='ego_dp_conv_powerplant')

Load conventional power plant data (replaces ego_dp_conv_powerplant_*_mview).

This function replicates the logic from: - mviews.ego_dp_conv_powerplant_ego100_mview - mviews.ego_dp_conv_powerplant_nep2035_mview - mviews.ego_supply_conv_powerplant_ego100_mview - mviews.ego_supply_conv_powerplant_nep2035_mview

Parameters:

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

  • version (str, optional) – Version string(s). If None, uses default versions for the scenario.

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

  • schema (str, default 'data') – Database schema name (‘data’ or ‘model_draft’)

  • table_name (str, default 'ego_dp_conv_powerplant') – Base table name (ego_dp_conv_powerplant or ego_dp_supply_conv_powerplant)

Returns:

Conventional power plant data matching the mview criteria

Return type:

pd.DataFrame

get_res_powerplant(scenario, version=None, preversion='v0.3.0', schema='data', table_name='ego_dp_res_powerplant')

Load renewable power plant data (replaces ego_dp_res_powerplant_*_mview).

This function replicates the logic from: - mviews.ego_dp_res_powerplant_ego100_mview - mviews.ego_dp_res_powerplant_nep2035_mview - mviews.ego_supply_res_powerplant_ego100_mview - mviews.ego_supply_res_powerplant_nep2035_mview

Parameters:

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

  • version (str, optional) – Version string(s). If None, uses default versions.

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

  • schema (str, default 'data') – Database schema name

  • table_name (str, default 'ego_dp_res_powerplant') – Base table name (ego_dp_res_powerplant or ego_dp_supply_res_powerplant)

Returns:

Renewable power plant data matching the mview criteria

Return type:

pd.DataFrame

get_loadarea(version='v0.4.5', schema='data', table_name='ego_dp_loadarea')

Load load area data (replaces ego_dp_loadarea_*_mview).

This function replicates the logic from: - mviews.ego_dp_loadarea_v0_4_3_mview - mviews.ego_dp_loadarea_v0_4_5_mview

Parameters:

  • version (str, default 'v0.4.5') – Version string

  • schema (str, default 'data') – Database schema name

  • table_name (str, default 'ego_dp_loadarea') – Base table name

Returns:

Load area data

Return type:

pd.DataFrame

get_mv_griddistrict(version='v0.4.5', schema='data', table_name='ego_dp_mv_griddistrict')

Load MV grid district data (replaces ego_dp_mv_griddistrict_*_mview).

This function replicates the logic from: - mviews.ego_dp_mv_griddistrict_v0_4_3_mview - mviews.ego_dp_mv_griddistrict_v0_4_5_mview

Parameters:

  • version (str, default 'v0.4.5') – Version string

  • schema (str, default 'data') – Database schema name

  • table_name (str, default 'ego_dp_mv_griddistrict') – Base table name

Returns:

MV grid district data

Return type:

pd.DataFrame

load_mview_replacement(mview_name, scenario=None, version=None, **kwargs)

Generic mview replacement loader based on mview name.

This is a convenience function that automatically routes to the appropriate specific function based on the mview name pattern.

Parameters:

  • mview_name (str) – Name of the mview to replace (e.g., ‘ego_dp_conv_powerplant_nep2035_mview’)

  • scenario (str, optional) – Scenario name (extracted from mview_name if not provided)

  • version (str, optional) – Version string

  • **kwargs – Additional arguments passed to specific functions

Returns:

Data from the appropriate base table

Return type:

pd.DataFrame

Raises:

ValueError – If the mview_name pattern is not recognized

Examples

>>> replacer = MviewsReplacement(engine)
>>> data = replacer.load_mview_replacement(
...     'ego_dp_conv_powerplant_nep2035_mview')
>>> data = replacer.load_mview_replacement(
...     'ego_supply_res_powerplant_ego100_mview')