| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- """
- 将 coordinate 项目的本地 JSON 配置文件批量导入到 webapp 的数据库中。
- 用法示例:
- python3 scripts/import_coordinate_configs.py --sentinel /Users/hujiarui/workspace/coordinate/config/config_sentinel.json
- python3 scripts/import_coordinate_configs.py --booker /Users/hujiarui/workspace/coordinate/config/config_booker.json
- python3 scripts/import_coordinate_configs.py --standalone /Users/hujiarui/workspace/coordinate/config/config_standalone.json
- """
- import os
- import sys
- import json
- import asyncio
- import argparse
- sys.path.insert(0, os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
- from app.core.database import AsyncSessionLocal
- from app.services.configuration_service import ConfigurationService
- from app.schemas.configuration import ConfigurationCreate, ConfigurationUpdate
- async def import_configs(sentinel_file=None, booker_file=None, standalone_file=None, node_id=None):
- async with AsyncSessionLocal() as db:
- items = [
- (sentinel_file, f"sentinel_config:{node_id}" if node_id else "sentinel_config", "Sentinel 哨兵组配置"),
- (booker_file, f"booker_config:{node_id}" if node_id else "booker_config", "Booker 预约组配置"),
- (standalone_file, f"standalone_config:{node_id}" if node_id else "standalone_config", "Standalone Booker 配置"),
- ]
- for file_path, key, desc in items:
- if file_path and os.path.exists(file_path):
- with open(file_path, "r", encoding="utf-8") as f:
- data = json.load(f)
- val_str = json.dumps(data, ensure_ascii=False, indent=2)
- try:
- await ConfigurationService.create(
- db,
- ConfigurationCreate(
- config_key=key,
- config_value=val_str,
- description=desc,
- type="json"
- )
- )
- except Exception:
- await ConfigurationService.update_by_key(
- db,
- key,
- ConfigurationUpdate(
- config_value=val_str,
- description=desc,
- type="json"
- )
- )
- print(f"✅ Successfully imported config for key '{key}'.")
- if __name__ == '__main__':
- parser = argparse.ArgumentParser(description="Import coordinate JSON configs to webapp DB")
- parser.add_argument("--sentinel", type=str, help="Path to config_sentinel.json")
- parser.add_argument("--booker", type=str, help="Path to config_booker.json")
- parser.add_argument("--standalone", type=str, help="Path to config_standalone.json")
- parser.add_argument("--node-id", type=str, help="Target node ID (optional)")
- args = parser.parse_args()
- asyncio.run(import_configs(args.sentinel, args.booker, args.standalone, args.node_id))
|