kde_cpi.series.views module

Utilities for building CPI series detail views in PostgreSQL.

class kde_cpi.series.views.SeriesViewManager(dsn=None, schema='public', connection_kwargs=NOTHING, selectable_only=True)[source]

Bases: object

Create CPI detail views grouped by item metadata.

Parameters:
async close()[source]

Close the open connection, if any.

Return type:

None

async connect(**overrides)[source]

Establish the asyncpg connection, reusing it when possible.

Return type:

Connection

Parameters:

overrides (object)

connection_kwargs: dict[str, Any]
async create_view_for_display_level(level, *, view_name=None, selectable_only=None)[source]

Create (or replace) a view filtered by item display level.

Return type:

str

Parameters:

  • level (int)

  • view_name (str | None)

  • selectable_only (bool | None)

async create_view_for_item_code_length(code_length, *, view_name=None, selectable_only=None)[source]

Create (or replace) a view filtered by item code length.

Return type:

str

Parameters:

  • code_length (int)

  • view_name (str | None)

  • selectable_only (bool | None)

dsn: str | None
schema: str
selectable_only: bool
kde_cpi.series.views.build_series_view_sql(view_name, *, schema='public', filter_condition, selectable_only=True)[source]

Produce CREATE OR REPLACE VIEW SQL for CPI series detail views.

Return type:

str

Parameters:

  • view_name (str)

  • schema (str)

  • filter_condition (str)

  • selectable_only (bool)