#!/usr/bin/env python3
import sqlite3
import json
from datetime import datetime

def ts2str(ts):
    if ts is None:
        return "None"
    try:
        return datetime.utcfromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S')
    except:
        return str(ts)

conn = sqlite3.connect('/home/hermes/.hermes/project_management.db')
conn.row_factory = sqlite3.Row
cursor = conn.cursor()

print("=== MANAGEMENT PROJECTS ===")
cursor.execute("SELECT * FROM management_projects")
for row in cursor.fetchall():
    print(json.dumps(dict(row), default=str))

print("\n=== PROJECT BOARDS ===")
cursor.execute("SELECT * FROM project_boards")
for row in cursor.fetchall():
    print(json.dumps(dict(row), default=str))

print("\n=== STRUCTURE NODES ===")
cursor.execute("SELECT * FROM project_structure_nodes ORDER BY management_project_id, sort_order")
for row in cursor.fetchall():
    print(json.dumps(dict(row), default=str))

print("\n=== TASK PLACEMENTS (all 16) ===")
cursor.execute("SELECT * FROM project_task_placements ORDER BY management_project_id, sort_order")
for row in cursor.fetchall():
    print(json.dumps(dict(row), default=str))

conn.close()