#!/usr/bin/env python3
import sqlite3, json, os, time

DB_PATH = '/root/.hermes/kanban/boards/research-hub/kanban.db'
TS = int(time.time())
project_path = "/opt/ai-os/products/ceo/content/research/educational_planning_positions"

conn = sqlite3.connect(DB_PATH)
c = conn.cursor()

tasks = [
    {
        "id": f"ep_p1a_{TS}",
        "title": "[Phase 1a] Khao sat & Kham pha -- Xac dinh danh sach truong, methodology",
        "assignee": "r-and-d",
        "status": "ready",
        "skills": json.dumps(["web_search", "paper_search_mcp"]),
        "body": f"""[CONTEXT]
Day la Phase 1a cua pipeline nghien cuu "Vi tri Hoach dinh Giao duc tai Dai hoc & Sau Dai hoc".
Thu muc du an: {project_path}
Luan de trung tam: Cac vi tri hoach dinh giao duc bac dai hoc/sau dai hoc duoc thiet ke ra sao de phuc vu muc tieu chien luoc cua tung truong? Su khac biet ve ten goi, JD, va cau truc to chuc giua My, Anh, va Trung Quoc phan anh dieu gi ve triet ly giao duc cua moi quoc gia?

[MUC TIEU]
1. Tim kiem va xac dinh cac truong dai hoc/sau dai hoc tai My, Anh, Trung Quoc co cac vi tri/van phong/phong ban lien quan den hoach dinh giao duc, chien luoc giao duc, quan tri giao duc. Cac vi tri nay co the mang nhieu ten goi khac nhau:
   - Educational Strategist / Academic Strategist
   - Brand Manager / Corporate Brand Manager (trong context giao duc)
   - Institutional Researcher / Analyst
   - Director of Strategic Planning (Education)
   - Vice-Provost (Education / Strategy)
   - Education Policy Advisor / Planner
   - Program / Curriculum Planner
   - University Development Planner
   - Trung Quoc: phat trien quy hoach xu, chien luoc quy hoach ban cong xu, giao vu xu, v.v.

2. Kham pha them cac vi tri khac ngoai danh sach tren.

3. De xuat danh sach truong cu the cho tung quoc gia (du kien ~8-15 truong/quoc gia).

4. Xac dinh phuong phap nghien cuu phu hop.

[CONG CU]
- web_search, paper_search_mcp, web_extract
- delegate_task de chia nho research theo quoc gia (toi da 3 subagent song song)

[OUTPUT]
Ghi ket qua vao file: {project_path}/research_plan.md (ghi de)
File phai bao gom: luan de, danh sach truong cho tung quoc gia (kem link nguon), phuong phap nghien cuu, cau truc pipeline, Expected TOC cho cac phase 2-4

[MANUAL GATE]
Sau khi hoan thanh:
1. Ghi output vao research_plan.md
2. Ghi comment tom tat + link Funnel
3. Danh dau 'done'
4. DUNG LAI. CHO USER DUYET."""
    },
    {
        "id": f"ep_p1b_{TS}",
        "title": "[Phase 1b] Xay dung Research Output Template",
        "assignee": "r-and-d",
        "status": "todo",
        "skills": json.dumps([]),
        "body": f"""[CONTEXT]
Phase 1b. DOC research_plan.md truoc khi chay.
Thu muc du an: {project_path}

[MUC TIEU]
Thiet ke template chuan (research_output_template.md) cho cac bao cao Phase 2, 3, 4.

[CAU TRUC TEMPLATE - can tinh chinh]
1. Tong quan he thong giao duc dai hoc quoc gia
2. Muc tieu giao duc chien luoc cua tung truong
3. Co cau to chuc & governance
4. Danh sach vi tri hoach dinh giao duc theo tung truong
   - Ten goi chinh xac
   - Phong ban truc thuoc
   - JD mo ta cong viec
   - Yeu cau tuyen dung
   - Ly do hinh thanh
5. So sanh noi bo trong quoc gia
6. Nhan xet so bo

[OUTPUT]
1. Cap nhat research_plan.md (bo sung phan TOC chuan)
2. Tao file: {project_path}/research_output_template.md

[MANUAL GATE]
Ghi output -> comment -> done -> DUNG."""
    },
    {
        "id": f"ep_p2_{TS}",
        "title": "[Phase 2] Deep Research -- My",
        "assignee": "r-and-d",
        "status": "todo",
        "skills": json.dumps(["web_search", "notebooklm-research", "paper_search_mcp"]),
        "body": f"""[CONTEXT]
Phase 2. DOC KY research_plan.md VA research_output_template.md.
Thu muc du an: {project_path}

[MUC TIEU]
Nghien cuu cac truong My trong danh sach Phase 1a.
Output phai tuan thu research_output_template.md.
Tung truong: muc tieu giao duc, vi tri hoach dinh (ten, phong ban, bao cao ai, JD, ly do hinh thanh).

[CONG CU]
- delegate_task (3 subagent song song, moi agent 3-5 truong)
- web_search, web_extract, paper_search_mcp, notebooklm-research

[OUTPUT]
File: {project_path}/master_reports/educational_planning_us.md

[MANUAL GATE]
Ghi output -> comment -> done -> DUNG."""
    },
    {
        "id": f"ep_p3_{TS}",
        "title": "[Phase 3] Deep Research -- Anh",
        "assignee": "r-and-d",
        "status": "todo",
        "skills": json.dumps(["web_search", "notebooklm-research", "paper_search_mcp"]),
        "body": f"""[CONTEXT]
Phase 3. DOC KY research_plan.md VA research_output_template.md.
Thu muc du an: {project_path}

[MUC TIEU]
Nghien cuu cac truong Anh trong danh sach Phase 1a.
Output tuan thu research_output_template.md (cau truc GIONG Phase 2).
Luu y: UK hay dung PVC, Education Strategy teams.

[CONG CU]
- delegate_task (3 subagent song song)
- web_search, web_extract, paper_search_mcp, notebooklm-research

[OUTPUT]
File: {project_path}/master_reports/educational_planning_uk.md

[MANUAL GATE]
Ghi output -> comment -> done -> DUNG."""
    },
    {
        "id": f"ep_p4_{TS}",
        "title": "[Phase 4] Deep Research -- Trung Quoc",
        "assignee": "r-and-d",
        "status": "todo",
        "skills": json.dumps(["web_search", "notebooklm-research"]),
        "body": f"""[CONTEXT]
Phase 4. DOC KY research_plan.md VA research_output_template.md.
Thu muc du an: {project_path}

[MUC TIEU]
Nghien cuu cac truong Trung Quoc trong danh sach Phase 1a.
Luu y ten goi: phat trien quy hoach xu, chien luoc quy hoach ban cong xu, giao vu xu, cao dang giao duc nghien cuu voi, chinh sach nghien cuu thi, v.v.

Tung truong: muc tieu giao duc, vi tri hoach dinh (ten TIENG TRUNG + dich nghia), truc thuoc, JD, ly do hinh thanh.

[CONG CU]
- web_search query tieng Trung + tieng Anh
- web_extract (co the can dich)
- delegate_task, notebooklm-research

[OUTPUT]
File: {project_path}/master_reports/educational_planning_china.md

[MANUAL GATE]
Ghi output -> comment -> done -> DUNG."""
    },
    {
        "id": f"ep_p5_{TS}",
        "title": "[Phase 5] Tong hop & So sanh + Index",
        "assignee": "writers",
        "status": "todo",
        "skills": json.dumps(["research-critism"]),
        "body": f"""[CONTEXT]
Phase 5. DOC TOAN BO:
- research_plan.md, educational_planning_us.md, educational_planning_uk.md, educational_planning_china.md
Thu muc du an: {project_path}

[MUC TIEU]
1. Ma tran doi sanh 3 quoc gia: muc tieu giao duc, ten goi vi tri, cap bac, JD, ly do hinh thanh, muc do tap trung.
2. Phan tich: vi sao khac biet? (van hoa, lich su, chinh sach). Xuan huong chung? Ham y cho thiet ke to chuc.
3. Phan bien: dung research-critism, chi ra khoang trong du lieu, de xuat huong nghien cuu tiep.
4. Cap nhat index.md.

[CONG CU]
- research-critism (skill)
- delegate_task cho cac phan so sanh

[OUTPUT]
1. {project_path}/master_reports/comparative_analysis.md
2. {project_path}/index.md

[MANUAL GATE]
Ghi output -> comment -> done -> DUNG."""
    }
]

for t in tasks:
    c.execute("""
        INSERT INTO tasks (id, title, assignee, status, body, skills, created_at, goal_mode)
        VALUES (?, ?, ?, ?, ?, ?, ?, 1)
    """, (t["id"], t["title"], t["assignee"], t["status"], t["body"], t.get("skills", None), TS))

conn.commit()
conn.close()
print("6 tasks created successfully!")