db_query / queries /ciq_2g_schema_loader.py
DavMelchi's picture
Align 2G CIQ output with final schema
824d7bb
import json
from pathlib import Path
_SCHEMA_PATH = Path(__file__).with_name("ciq_2g_final_schema.json")
def _load_schema() -> dict[str, dict[str, object]]:
return json.loads(_SCHEMA_PATH.read_text(encoding="utf-8"))
_SCHEMA = _load_schema()
BTS_FINAL_COLUMNS = _SCHEMA["BTS"]["columns"]
BTS_FINAL_DEFAULTS = _SCHEMA["BTS"]["defaults"]
BTS_FINAL_FORMULAS = _SCHEMA["BTS"]["formulas"]
BTS_GPRS_FINAL_COLUMNS = _SCHEMA["BTS_GPRS"]["columns"]
BTS_GPRS_FINAL_DEFAULTS = _SCHEMA["BTS_GPRS"]["defaults"]
BTS_GPRS_FINAL_FORMULAS = _SCHEMA["BTS_GPRS"]["formulas"]
BTS_AMR_FINAL_COLUMNS = _SCHEMA["BTS_AMR"]["columns"]
BTS_AMR_FINAL_DEFAULTS = _SCHEMA["BTS_AMR"]["defaults"]
BTS_AMR_FINAL_FORMULAS = _SCHEMA["BTS_AMR"]["formulas"]
HOC_FINAL_COLUMNS = _SCHEMA["HOC"]["columns"]
HOC_FINAL_DEFAULTS = _SCHEMA["HOC"]["defaults"]
HOC_FINAL_FORMULAS = _SCHEMA["HOC"]["formulas"]
POC_FINAL_COLUMNS = _SCHEMA["POC"]["columns"]
POC_FINAL_DEFAULTS = _SCHEMA["POC"]["defaults"]
POC_FINAL_FORMULAS = _SCHEMA["POC"]["formulas"]