"""Alembic environment for the frozen Workspace schema revisions.""" from __future__ import annotations import os, sys from pathlib import Path sys.path.insert(0,str(Path(__file__).resolve().parents[2])) from logging.config import fileConfig from alembic import context from sqlalchemy import create_engine, pool from workspace_service.service import Base from AgentRuntime.models import Base as RuntimeBase from KnowledgeService.models import Base as KnowledgeBase from LLMGateway.service import Base as LLMBase from OfficeService.service import BusinessRecord, MeetingAction import ContextService.models, CollaborationService.models, ToolGateway.models, PlatformService.models, KnowledgeService.lab config=context.config if config.config_file_name: fileConfig(config.config_file_name) target_metadata=[Base.metadata,RuntimeBase.metadata,KnowledgeBase.metadata,LLMBase.metadata] url=os.getenv("WORKOS_WORKSPACE_DB_URL") or config.get_main_option("sqlalchemy.url") def run_migrations_offline(): context.configure(url=url,target_metadata=target_metadata,literal_binds=True,dialect_opts={"paramstyle":"named"}) with context.begin_transaction():context.run_migrations() def run_migrations_online(): engine=create_engine(url,poolclass=pool.NullPool) with engine.connect() as connection: context.configure(connection=connection,target_metadata=target_metadata,compare_type=True) with context.begin_transaction():context.run_migrations() engine.dispose() if context.is_offline_mode():run_migrations_offline() else:run_migrations_online()