show_mapping.py

"""
Data mapping visualization script
Shows how Excel columns map to database tables
"""
from config import Config

def show_data_mapping():
    """Display the mapping between Excel columns and database tables"""
    print("Excel to Database Data Mapping")
    print("=" * 50)
    
    print("\n📊 Excel Column Mapping:")
    mappings = Config.COLUMN_MAPPINGS
    for key, column in mappings.items():
        print(f"  {key:<25} ← {column}")
    
    print("\n🗃️ Database Table Structure:")
    print("  tb_area")
    print("    ├── area_id (UUID, PK)")
    print("    ├── nome (varchar(100)) ← Area")
    print("    ├── status (varchar(50)) = 'ATIVO'")
    print("    └── dt_criacao, criado_por, etc.")
    
    print("\n  tb_questao_base")
    print("    ├── questao_base_id (UUID, PK)")
    print("    ├── area_id (UUID, FK) → tb_area")
    print("    ├── titulo (varchar(200)) ← Questao Abreviada")
    print("    ├── descricao (TEXT) ← Questao")
    print("    ├── tipo_base (varchar(50)) = 'KATRU'")
    print("    └── dt_criacao, criado_por, etc.")
    
    print("\n  tb_item_base")
    print("    ├── item_base_id (UUID, PK)")
    print("    ├── questao_base_id (UUID, FK) → tb_questao_base")
    print("    ├── titulo (varchar(200)) ← Item Verificacao Abreviada")
    print("    ├── descricao (TEXT) ← Item Verificacao")
    print("    ├── tipo_base (varchar(50)) = 'KATRU'")
    print("    └── dt_criacao, criado_por, etc.")
    
    print("\n  tb_acao_base")
    print("    ├── acao_base_id (UUID, PK)")
    print("    ├── item_base_id (UUID, FK) → tb_item_base")
    print("    ├── titulo (varchar(200)) ← Questao Auxiliar (truncated)")
    print("    ├── descricao (TEXT) ← Questao Auxiliar")
    print("    ├── tipo_base (varchar(50)) = 'KATRU'")
    print("    └── dt_criacao, criado_por, etc.")
    
    print("\n🔄 Data Flow:")
    print("  Excel Row → Area → Question → Item → Action")
    print("  Each level creates a record if it doesn't exist")
    print("  Foreign keys link the hierarchy together")
    
    print("\n📋 Default Values:")
    print("  • status = 'ATIVO' (for areas)")
    print("  • tipo_base = 'KATRU' (for questions, items, actions)")
    print("  • dt_criacao = now() (automatic timestamp)")
    print("  • UUIDs are auto-generated for all primary keys")

if __name__ == "__main__":
    show_data_mapping()