import sqlite3
import json

conn = sqlite3.connect('backend/vfx_project_management.db')
cursor = conn.cursor()
cursor.execute('SELECT id, custom_asset_task_types, custom_shot_task_types FROM projects')
for row in cursor.fetchall():
    asset_types = json.loads(row[1]) if row[1] else []
    shot_types = json.loads(row[2]) if row[2] else []
    print(f'Project {row[0]}: Asset={asset_types}, Shot={shot_types}')
conn.close()
