CoolFace
Apppublic

fmatituy/selectospromanager

sourceHugging Faceupdated 6mo agoView on Hugging Face
0likes
check_schema.py18 linesDownload Raw Back to database
1import sqlite32import os3 4DB_PATH = 'src/database/pro_manager.db'5 6def check_table_info(table_name):7    conn = sqlite3.connect(DB_PATH)8    cursor = conn.cursor()9    cursor.execute(f"PRAGMA table_info({table_name});")10    columns = cursor.fetchall()11    print(f"Total columns for {table_name}: {len(columns)}")12    for col in columns:13        print(f"ColID: {col[0]}, Name: {col[1]}, Type: {col[2]}")14    conn.close()15 16if __name__ == "__main__":17    check_table_info('inventario_herramientas')18