graph LR
pokedex_db_tables["pokedex.db.tables"]
pokedex_db_util["pokedex.db.util"]
pokedex_db_dependencies["pokedex.db.dependencies"]
pokedex_db_load["pokedex.db.load"]
pokedex_db_multilang["pokedex.db.multilang"]
pokedex_db_markdown["pokedex.db.markdown"]
pokedex_db_translations["pokedex.db.translations"]
pokedex_db_tables -- "provides schema to" --> pokedex_db_util
pokedex_db_tables -- "provides schema to" --> pokedex_db_dependencies
pokedex_db_tables -- "provides schema to" --> pokedex_db_load
pokedex_db_tables -- "extended by" --> pokedex_db_multilang
pokedex_db_tables -- "extended by" --> pokedex_db_markdown
pokedex_db_util -- "uses" --> pokedex_db_tables
pokedex_db_util -- "utilized by" --> pokedex_db_load
pokedex_db_util -- "utilized by" --> pokedex_db_translations
pokedex_db_dependencies -- "relies on" --> pokedex_db_tables
pokedex_db_dependencies -- "informs" --> pokedex_db_load
pokedex_db_load -- "uses" --> pokedex_db_tables
pokedex_db_load -- "uses" --> pokedex_db_dependencies
pokedex_db_load -- "utilizes" --> pokedex_db_util
pokedex_db_multilang -- "extends" --> pokedex_db_tables
pokedex_db_markdown -- "extends" --> pokedex_db_tables
pokedex_db_translations -- "leverages" --> pokedex_db_multilang
pokedex_db_translations -- "utilizes" --> pokedex_db_util
The Database Core Layer is the central component for data persistence, schema definition, and database session management using SQLAlchemy. It serves as the authoritative source for all Pokedex data, acting as the primary interface for data storage and retrieval, and supporting the ETL process.
The foundational component defining the entire database schema (tables, columns, relationships) using SQLAlchemy ORM models. It is the blueprint for all Pokedex data, ensuring data structure and integrity.
Related Classes/Methods:
Provides essential generic utility functions for common database operations, including session management, querying, filtering, and data retrieval. It acts as the primary operational interface to the database, abstracting direct SQLAlchemy interactions.
Related Classes/Methods:
Manages and resolves dependencies between database tables. This is crucial for maintaining schema integrity and ensuring the correct data loading order, especially vital for complex ETL processes where data must be inserted in a specific sequence.
Related Classes/Methods:
Responsible for orchestrating and executing data loading operations into the Pokedex database. It utilizes the defined schema and dependency information to correctly populate the database.
Related Classes/Methods:
Extends the core database schema defined in pokedex.db.tables to incorporate multi-language support for various data fields. This component enables the storage and retrieval of localized content.
Related Classes/Methods:
Extends the core database schema defined in pokedex.db.tables to support markdown field types. This allows for the storage of rich text content that can be rendered as markdown.
Related Classes/Methods:
Manages the specific data related to translations within the Pokedex database, leveraging the multi-language schema extensions. It handles the storage and retrieval of translated text.
Related Classes/Methods: