FastApi

1
"""Initial
2

3
Revision ID: 885f57519cdf
4
Revises: 
5
Create Date: 2022-12-29 20:02:03.506811
6

7
"""
8
import sqlalchemy as sa
9
from alembic import op
10

11
# revision identifiers, used by Alembic.
12
revision = '885f57519cdf'
13
down_revision = None
14
branch_labels = None
15
depends_on = None
16

17

18
def upgrade() -> None:
19
    # ### commands auto generated by Alembic - please adjust! ###
20
    op.create_table('role',
21
    sa.Column('id', sa.Integer(), nullable=False),
22
    sa.Column('name', sa.String(), nullable=False),
23
    sa.Column('permissions', sa.JSON(), nullable=True),
24
    sa.PrimaryKeyConstraint('id')
25
    )
26
    op.create_table('user',
27
    sa.Column('id', sa.Integer(), nullable=False),
28
    sa.Column('email', sa.String(), nullable=False),
29
    sa.Column('username', sa.String(), nullable=False),
30
    sa.Column('registered_at', sa.TIMESTAMP(), nullable=True),
31
    sa.Column('role_id', sa.Integer(), nullable=True),
32
    sa.Column('hashed_password', sa.String(), nullable=False),
33
    sa.Column('is_active', sa.Boolean(), nullable=False),
34
    sa.Column('is_superuser', sa.Boolean(), nullable=False),
35
    sa.Column('is_verified', sa.Boolean(), nullable=False),
36
    sa.ForeignKeyConstraint(['role_id'], ['role.id'], ),
37
    sa.PrimaryKeyConstraint('id')
38
    )
39
    # ### end Alembic commands ###
40

41

42
def downgrade() -> None:
43
    # ### commands auto generated by Alembic - please adjust! ###
44
    op.drop_table('user')
45
    op.drop_table('role')
46
    # ### end Alembic commands ###
47