SuperAGI
65 строк · 2.1 Кб
1"""add api_key and web_hook
2
3Revision ID: 446884dcae58
4Revises: 71e3980d55f5
5Create Date: 2023-07-29 10:55:21.714245
6
7"""
8from alembic import op
9import sqlalchemy as sa
10
11
12# revision identifiers, used by Alembic.
13revision = '446884dcae58'
14down_revision = '2fbd6472112c'
15branch_labels = None
16depends_on = None
17
18
19def upgrade() -> None:
20# ### commands auto generated by Alembic - please adjust! ###
21op.create_table('api_keys',
22sa.Column('id', sa.Integer(), nullable=False),
23sa.Column('org_id', sa.Integer(), nullable=True),
24sa.Column('name', sa.String(), nullable=True),
25sa.Column('key', sa.String(), nullable=True),
26sa.Column('created_at', sa.DateTime(), nullable=True),
27sa.Column('updated_at', sa.DateTime(), nullable=True),
28sa.Column('is_expired',sa.Boolean(),nullable=True,default=False),
29sa.PrimaryKeyConstraint('id')
30)
31op.create_table('webhooks',
32sa.Column('id', sa.Integer(), nullable=False),
33sa.Column('name', sa.String(), nullable=True),
34sa.Column('org_id', sa.Integer(), nullable=True),
35sa.Column('url', sa.String(), nullable=True),
36sa.Column('headers', sa.JSON(), nullable=True),
37sa.Column('created_at', sa.DateTime(), nullable=True),
38sa.Column('updated_at', sa.DateTime(), nullable=True),
39sa.Column('is_deleted',sa.Boolean(),nullable=True),
40sa.PrimaryKeyConstraint('id')
41)
42op.create_table('webhook_events',
43sa.Column('id', sa.Integer(), nullable=False),
44sa.Column('agent_id', sa.Integer(), nullable=True),
45sa.Column('run_id', sa.Integer(), nullable=True),
46sa.Column('event', sa.String(), nullable=True),
47sa.Column('status', sa.String(), nullable=True),
48sa.Column('errors', sa.Text(), nullable=True),
49sa.Column('created_at', sa.DateTime(), nullable=True),
50sa.Column('updated_at', sa.DateTime(), nullable=True),
51sa.PrimaryKeyConstraint('id')
52)
53
54#add index *********************
55# ### end Alembic commands ###
56
57
58def downgrade() -> None:
59# ### commands auto generated by Alembic - please adjust! ###
60
61op.drop_table('webhooks')
62op.drop_table('api_keys')
63op.drop_table('webhook_events')
64
65# ### end Alembic commands ###
66