src.plantuml_er_parse_sql Namespace Reference

Classes
class	Column
class	Function
class	Index
class	ParseResult
class	Relationship
class	SQLParser
class	Table
class	View
class	Warning

Functions
	main ()

Variables
dict	COMPONENT_PREFIXES
str	SCHEMA_PATTERN = r'(?:public)'
dict	FK_COLUMNS
dict	FK_TARGET_TABLES
dict	TABLE_STYLES

Detailed Description

PlantUML ER Diagram - SQL Parser

Parses SQL CREATE/DROP statements to generate a JSON model for ER diagram
generation. Validates SQL against conventions defined in SKILL.org.

Variable Documentation

COMPONENT_PREFIXES

dict COMPONENT_PREFIXES

Initial value:

=  {
    'ores_iam_': {'name': 'iam', 'description': 'Identity & Access Management', 'schema': 'public', 'color': '#E8F4FD', 'order': 1},
    'ores_assets_': {'name': 'assets', 'description': 'Digital Assets', 'schema': 'public', 'color': '#F3E5F5', 'order': 2},
    'ores_refdata_': {'name': 'refdata', 'description': 'Reference Data', 'schema': 'public', 'color': '#FFF3E0', 'order': 3},
    'ores_dq_': {'name': 'dq', 'description': 'Data Quality', 'schema': 'public', 'color': '#E1F5FE', 'order': 4},
    'ores_variability_': {'name': 'variability', 'description': 'Feature Flags', 'schema': 'public', 'color': '#E8F5E9', 'order': 5},
    'ores_telemetry_': {'name': 'telemetry', 'description': 'Telemetry & Logging', 'schema': 'public', 'color': '#FCE4EC', 'order': 6},
    'ores_geo_': {'name': 'geo', 'description': 'Geolocation', 'schema': 'public', 'color': '#FFF9C4', 'order': 7},
    'ores_dq_fsm_': {'name': 'dq_fsm', 'description': 'FSM (Data Quality)', 'schema': 'public', 'color': '#E8EAF6', 'order': 8},
    'ores_trading_': {'name': 'trading', 'description': 'Trading & Lifecycle', 'schema': 'public', 'color': '#E8F5E9', 'order': 9},
    'ores_mq_': {'name': 'mq', 'description': 'Message Queue (pgmq)', 'schema': 'public', 'color': '#FBE9E7', 'order': 10},
    'ores_scheduler_': {'name': 'scheduler', 'description': 'Job Scheduler (pg_cron)', 'schema': 'public', 'color': '#F1F8E9', 'order': 11},
    'ores_reporting_': {'name': 'reporting', 'description': 'Reporting & Analytics', 'schema': 'public', 'color': '#E0F7FA', 'order': 12},
    'ores_compute_': {'name': 'compute', 'description': 'Distributed Compute Grid (BOINC)', 'schema': 'public', 'color': '#EDE7F6', 'order': 13},
    'ores_utility_': {'name': 'utility', 'description': 'Utility Functions', 'schema': 'public', 'color': '#ECEFF1', 'order': 14},
    'ores_seed_': {'name': 'seed', 'description': 'Seed Functions', 'schema': 'public', 'color': '#ECEFF1', 'order': 15},
    'ores_database_': {'name': 'database', 'description': 'Database Infrastructure', 'schema': 'public', 'color': '#EFEBE9', 'order': 16},
}

FK_COLUMNS

dict FK_COLUMNS

Initial value:

=  {
    'change_reason_code',  # References change reason codes
    'coding_scheme_code',  # References coding schemes
    'category_code',       # References change reason categories
    'account_id',          # References iam_accounts_tbl
    'role_id',             # References iam_roles_tbl
    'permission_id',       # References iam_permissions_tbl
    'image_id',            # References assets_images_tbl
    'tag_id',              # References assets_tags_tbl
    'dataset_id',          # References dq_datasets_tbl
    'methodology_id',      # References dq_methodologies_tbl
    'authority_type',      # References dq_coding_scheme_authority_types_tbl
    'nature_code',         # References dq_nature_dimensions_tbl
    'origin_code',         # References dq_origin_dimensions_tbl
    'treatment_code',      # References dq_treatment_dimensions_tbl
    'country_code',        # References refdata_countries_tbl
    'currency_code',       # References refdata_currencies_tbl
}

FK_TARGET_TABLES

dict FK_TARGET_TABLES

Initial value:

=  {
    # IAM
    'account_id': 'iam_accounts_tbl',
    'role_id': 'iam_roles_tbl',
    'permission_id': 'iam_permissions_tbl',
    'session_id': 'iam_sessions_tbl',
    # Assets
    'image_id': 'assets_images_tbl',
    'tag_id': 'assets_tags_tbl',
    # Data Quality - Core
    'dataset_id': 'dq_datasets_tbl',
    'coding_scheme_code': 'dq_coding_schemes_tbl',
    'change_reason_code': 'dq_change_reasons_tbl',
    'category_code': 'dq_change_reason_categories_tbl',
    'catalog_name': 'dq_catalogs_tbl',
    'domain_name': 'dq_data_domains_tbl',
    'subject_area_name': 'dq_subject_areas_tbl',
    'methodology_id': 'dq_methodologies_tbl',
    'authority_type': 'dq_coding_scheme_authority_types_tbl',
    # Data Quality - Dimensions
    'nature_code': 'dq_nature_dimensions_tbl',
    'origin_code': 'dq_origin_dimensions_tbl',
    'treatment_code': 'dq_treatment_dimensions_tbl',
    # Dataset derivation (self-reference)
    'upstream_derivation_id': 'dq_datasets_tbl',
    # Reference data
    'country_code': 'refdata_countries_tbl',
    'currency_code': 'refdata_currencies_tbl',
}

TABLE_STYLES

dict TABLE_STYLES

Initial value:

=  {
    'temporal': {'stereotype': '<<temporal>>', 'color': '#C6F0D8'},
    'artefact': {'stereotype': '', 'color': '#F7E5FF'},
    'junction': {'stereotype': '<<junction>>', 'color': '#ECECEC'},
    'current_state': {'stereotype': '', 'color': '#F7E5FF'},
}