Spaces:
Sleeping
Sleeping
Download WorkspaceService/migrations/versions/0002_agent_runtime.py from dellweb3/workos-office: direct link, hf CLI and curl.
- Browser
- Download file 3.01 kB
-
https://huggingface.co/spaces/dellweb3/workos-office/resolve/main/WorkspaceService/migrations/versions/0002_agent_runtime.py
- Command line
-
hf download hf://spaces/dellweb3/workos-office/WorkspaceService/migrations/versions/0002_agent_runtime.py
-
curl -L -o 0002_agent_runtime.py https://huggingface.co/spaces/dellweb3/workos-office/resolve/main/WorkspaceService/migrations/versions/0002_agent_runtime.py
3.01 kB
| """Workspace workflow binding + Agent Runtime durable catalog and execution. | |
| Revision ID: 0002 | |
| Revises: 0001 | |
| Frozen schema; independent of future ORM changes. | |
| """ | |
| from alembic import op | |
| import sqlalchemy as sa | |
| revision='0002' | |
| down_revision='0001' | |
| branch_labels=None | |
| depends_on=None | |
| def upgrade(): | |
| op.create_table('ws_runtime_binding',sa.Column('workspace_id',sa.String(80),sa.ForeignKey('ws_matter.id'),primary_key=True),sa.Column('tenant_id',sa.String(80),nullable=False),sa.Column('workflow_id',sa.String(80),nullable=False),sa.Column('workflow_version',sa.Integer(),nullable=False),sa.Column('base_ids',sa.JSON(),nullable=False),sa.Column('version',sa.Integer(),nullable=False)) | |
| op.create_index('ix_ws_runtime_binding_tenant_id','ws_runtime_binding',['tenant_id']) | |
| op.create_table('ar_definition',sa.Column('tenant',sa.String(80),primary_key=True),sa.Column('kind',sa.String(24),primary_key=True),sa.Column('id',sa.String(80),primary_key=True),sa.Column('revision',sa.Integer(),nullable=False),sa.Column('body',sa.JSON(),nullable=False),sa.Column('updated_at',sa.String(40),nullable=False)) | |
| op.create_table('ar_published',sa.Column('tenant',sa.String(80),primary_key=True),sa.Column('workflow_id',sa.String(80),primary_key=True),sa.Column('version',sa.Integer(),primary_key=True),sa.Column('body',sa.JSON(),nullable=False),sa.Column('created_at',sa.String(40),nullable=False)) | |
| op.create_table('ar_run',sa.Column('id',sa.String(80),primary_key=True),sa.Column('tenant',sa.String(80),nullable=False),sa.Column('owner',sa.String(80),nullable=False),sa.Column('workspace',sa.String(80),nullable=False),sa.Column('active_scope',sa.String(200),nullable=True),sa.Column('status',sa.String(32),nullable=False),sa.Column('revision',sa.Integer(),nullable=False),sa.Column('body',sa.JSON(),nullable=False),sa.UniqueConstraint('active_scope')) | |
| for col in ('tenant','owner','workspace','status'):op.create_index('ix_ar_run_'+col,'ar_run',[col]) | |
| op.create_table('ar_event',sa.Column('run_id',sa.String(80),primary_key=True),sa.Column('sequence',sa.Integer(),primary_key=True),sa.Column('body',sa.JSON(),nullable=False)) | |
| op.create_table('ar_command',sa.Column('tenant',sa.String(80),primary_key=True),sa.Column('owner',sa.String(80),primary_key=True),sa.Column('scope',sa.String(200),primary_key=True),sa.Column('key',sa.String(128),primary_key=True),sa.Column('fingerprint',sa.String(64),nullable=False),sa.Column('response',sa.JSON(),nullable=False)) | |
| op.create_table('ar_audit',sa.Column('id',sa.String(80),primary_key=True),sa.Column('tenant',sa.String(80),nullable=False),sa.Column('actor',sa.String(80),nullable=False),sa.Column('action',sa.String(80),nullable=False),sa.Column('resource',sa.String(80),nullable=False),sa.Column('at',sa.String(40),nullable=False)) | |
| op.create_index('ix_ar_audit_tenant','ar_audit',['tenant']) | |
| def downgrade(): | |
| for table in ('ar_audit','ar_command','ar_event','ar_run','ar_published','ar_definition','ws_runtime_binding'):op.drop_table(table) | |