import_coordinate_configs.py 3.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. """
  2. 将 coordinate 项目的本地 JSON 配置文件批量导入到 webapp 的数据库中。
  3. 用法示例:
  4. python3 scripts/import_coordinate_configs.py --sentinel /Users/hujiarui/workspace/coordinate/config/config_sentinel.json
  5. python3 scripts/import_coordinate_configs.py --booker /Users/hujiarui/workspace/coordinate/config/config_booker.json
  6. python3 scripts/import_coordinate_configs.py --standalone /Users/hujiarui/workspace/coordinate/config/config_standalone.json
  7. """
  8. import os
  9. import sys
  10. import json
  11. import asyncio
  12. import argparse
  13. sys.path.insert(0, os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
  14. from app.core.database import AsyncSessionLocal
  15. from app.services.configuration_service import ConfigurationService
  16. from app.schemas.configuration import ConfigurationCreate, ConfigurationUpdate
  17. async def import_configs(sentinel_file=None, booker_file=None, standalone_file=None, node_id=None):
  18. async with AsyncSessionLocal() as db:
  19. items = [
  20. (sentinel_file, f"sentinel_config:{node_id}" if node_id else "sentinel_config", "Sentinel 哨兵组配置"),
  21. (booker_file, f"booker_config:{node_id}" if node_id else "booker_config", "Booker 预约组配置"),
  22. (standalone_file, f"standalone_config:{node_id}" if node_id else "standalone_config", "Standalone Booker 配置"),
  23. ]
  24. for file_path, key, desc in items:
  25. if file_path and os.path.exists(file_path):
  26. with open(file_path, "r", encoding="utf-8") as f:
  27. data = json.load(f)
  28. val_str = json.dumps(data, ensure_ascii=False, indent=2)
  29. try:
  30. await ConfigurationService.create(
  31. db,
  32. ConfigurationCreate(
  33. config_key=key,
  34. config_value=val_str,
  35. description=desc,
  36. type="json"
  37. )
  38. )
  39. except Exception:
  40. await ConfigurationService.update_by_key(
  41. db,
  42. key,
  43. ConfigurationUpdate(
  44. config_value=val_str,
  45. description=desc,
  46. type="json"
  47. )
  48. )
  49. print(f"✅ Successfully imported config for key '{key}'.")
  50. if __name__ == '__main__':
  51. parser = argparse.ArgumentParser(description="Import coordinate JSON configs to webapp DB")
  52. parser.add_argument("--sentinel", type=str, help="Path to config_sentinel.json")
  53. parser.add_argument("--booker", type=str, help="Path to config_booker.json")
  54. parser.add_argument("--standalone", type=str, help="Path to config_standalone.json")
  55. parser.add_argument("--node-id", type=str, help="Target node ID (optional)")
  56. args = parser.parse_args()
  57. asyncio.run(import_configs(args.sentinel, args.booker, args.standalone, args.node_id))