#!/usr/bin/env python3
"""
执行 OpenClaw 配置项迁移

将 add_openclaw_config.sql 中的配置项插入 system_config 表。

使用方法：
    python scripts/apply_openclaw_config.py
"""

import sys
from pathlib import Path

sys.path.append(str(Path(__file__).parent.parent))

from sqlalchemy import text
from app.database import engine

SQL_FILE = Path(__file__).parent.parent / "migrations" / "add_openclaw_config.sql"


def main():
    print("开始执行 OpenClaw 配置迁移...")

    sql = SQL_FILE.read_text(encoding="utf-8")

    # 整个文件作为一条语句执行，避免分割问题
    try:
        with engine.begin() as conn:  # begin() 会在退出时自动 commit
            print(f"执行: {sql.strip()[:80]}...")
            conn.execute(text(sql))
        print("✅ 迁移完成！已插入以下配置项：")
        print("   - enable_openclaw")
        print("   - enable_openclaw_client")
        print("   - enable_openclaw_web")
        print("   - openclaw_client_url")
    except Exception as e:
        print(f"❌ 迁移失败: {e}")
        sys.exit(1)


if __name__ == "__main__":
    main()