fmatituy/selectospromanager
0
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 