class Definition(mb.MistralSecureModelBase):
__abstract__ = True
id = mb.id_column()
name = sa.Column(sa.String(255))
definition = sa.Column(st.MediumText(), nullable=True)
spec = sa.Column(st.JsonMediumDictType())
tags = sa.Column(st.JsonListType())
is_system = sa.Column(sa.Boolean())
def upgrade():
op.create_table(
'action_executions_v2',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('scope', sa.String(length=80), nullable=True),
sa.Column('project_id', sa.String(length=80), nullable=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('description', sa.String(length=255), nullable=True),
sa.Column('workflow_name', sa.String(length=255), nullable=True),
sa.Column('workflow_id', sa.String(length=80), nullable=True),
sa.Column('spec', st.JsonMediumDictType(), nullable=True),
sa.Column('state', sa.String(length=20), nullable=True),
sa.Column('state_info', sa.TEXT(), nullable=True),
sa.Column('tags', st.JsonListType(), nullable=True),
sa.Column('runtime_context', st.JsonLongDictType(), nullable=True),
sa.Column('accepted', sa.Boolean(), nullable=True),
sa.Column('input', st.JsonLongDictType(), nullable=True),
sa.Column('output', st.JsonLongDictType(), nullable=True),
sa.Column('task_execution_id', sa.String(length=36), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.Index(
'action_executions_v2_project_id',
'project_id'
),
sa.Index(
'action_executions_v2_scope',
'scope'
),
sa.Index(
'action_executions_v2_state',
'state'
),
sa.Index(
'action_executions_v2_updated_at',
'updated_at'
),
)
op.create_table(
'workflow_executions_v2',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('scope', sa.String(length=80), nullable=True),
sa.Column('project_id', sa.String(length=80), nullable=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('description', sa.String(length=255), nullable=True),
sa.Column('workflow_name', sa.String(length=255), nullable=True),
sa.Column('workflow_id', sa.String(length=80), nullable=True),
sa.Column('spec', st.JsonMediumDictType(), nullable=True),
sa.Column('state', sa.String(length=20), nullable=True),
sa.Column('state_info', sa.TEXT(), nullable=True),
sa.Column('tags', st.JsonListType(), nullable=True),
sa.Column('runtime_context', st.JsonLongDictType(), nullable=True),
sa.Column('accepted', sa.Boolean(), nullable=True),
sa.Column('input', st.JsonLongDictType(), nullable=True),
sa.Column('output', st.JsonLongDictType(), nullable=True),
sa.Column('params', st.JsonLongDictType(), nullable=True),
sa.Column('context', st.JsonLongDictType(), nullable=True),
sa.Column('task_execution_id', sa.String(length=36), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.Index(
'workflow_executions_v2_project_id',
'project_id'
),
sa.Index(
'workflow_executions_v2_scope',
'scope'
),
sa.Index(
'workflow_executions_v2_state',
'state'
),
sa.Index(
'workflow_executions_v2_updated_at',
'updated_at'
),
)
op.create_table(
'task_executions_v2',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('scope', sa.String(length=80), nullable=True),
sa.Column('project_id', sa.String(length=80), nullable=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('description', sa.String(length=255), nullable=True),
sa.Column('workflow_name', sa.String(length=255), nullable=True),
sa.Column('workflow_id', sa.String(length=80), nullable=True),
sa.Column('spec', st.JsonMediumDictType(), nullable=True),
sa.Column('state', sa.String(length=20), nullable=True),
sa.Column('state_info', sa.TEXT(), nullable=True),
sa.Column('tags', st.JsonListType(), nullable=True),
sa.Column('runtime_context', st.JsonLongDictType(), nullable=True),
sa.Column('action_spec', st.JsonLongDictType(), nullable=True),
sa.Column('processed', sa.Boolean(), nullable=True),
sa.Column('in_context', st.JsonLongDictType(), nullable=True),
sa.Column('published', st.JsonLongDictType(), nullable=True),
sa.Column(
'workflow_execution_id',
sa.String(length=36),
nullable=True
),
sa.PrimaryKeyConstraint('id'),
sa.Index(
'task_executions_v2_project_id',
'project_id'
),
sa.Index(
'task_executions_v2_scope',
'scope'
),
sa.Index(
'task_executions_v2_state',
'state'
),
sa.Index(
'task_executions_v2_updated_at',
'updated_at'
),
sa.Index(
'task_executions_v2_workflow_execution_id',
'workflow_execution_id'
),
sa.ForeignKeyConstraint(
['workflow_execution_id'],
[u'workflow_executions_v2.id'],
ondelete='CASCADE'
),
)
# 2 foreign keys are added here because all 3 tables are dependent.
op.create_foreign_key(
None,
'action_executions_v2',
'task_executions_v2',
['task_execution_id'],
['id'],
ondelete='CASCADE'
)
op.create_foreign_key(
None,
'workflow_executions_v2',
'task_executions_v2',
['task_execution_id'],
['id'],
ondelete='CASCADE'
)
op.alter_column(
'workbooks_v2',
'name',
type_=sa.String(length=255)
)
op.alter_column(
'workbooks_v2',
'definition',
type_=st.MediumText()
)
op.alter_column(
'workbooks_v2',
'spec',
type_=st.JsonMediumDictType()
)
op.alter_column(
'workflow_definitions_v2',
'name',
type_=sa.String(length=255)
)
op.alter_column(
'workflow_definitions_v2',
'definition',
type_=st.MediumText()
)
op.alter_column(
'workflow_definitions_v2',
'spec',
type_=st.JsonMediumDictType()
)
op.alter_column(
'action_definitions_v2',
'name',
type_=sa.String(length=255)
)
op.alter_column(
'action_definitions_v2',
'definition',
type_=st.MediumText()
)
op.alter_column(
'action_definitions_v2',
'spec',
type_=st.JsonMediumDictType()
)
op.alter_column(
'cron_triggers_v2',
'workflow_name',
type_=sa.String(length=255)
)