radionica3d/scratch/check_db_schema.py

import sys
import os

# Add backend to path
sys.path.append(os.path.join(os.getcwd(), 'backend'))

import db

def check_columns():
    try:
        results = db.execute_query("SHOW COLUMNS FROM orders")
        print("Columns in 'orders' table:")
        for row in results:
            print(f"- {row['Field']} ({row['Type']})")
    except Exception as e:
        print(f"Error: {e}")

if __name__ == "__main__":
    check_columns()