dellweb3's picture
Work OS validated demo local-v0.8 (part 2)
daa4d56 verified
Raw History Blame Contribute Delete
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)