alembic_init_migration_script_create_table_example.py

1# 1. Install Alembic via terminal:
2# pip install alembic
3
4# 2. Initialize the migration environment in your project directory:
5# alembic init migrations
6
7# 3. Typical 'alembic.ini' configuration (edit the file created by 'init'):
8# sqlalchemy.url = driver://user:pass@localhost/dbname
9
10# 4. Example of a generated migration script (found in migrations/versions/):
11"""create account table
12
13Revision ID: e939823521d6
14Revises: 
15Create Date: 2023-10-27 12:00:00.000000
16
17"""
18from alembic import op
19import sqlalchemy as sa
20
21# revision identifiers, used by Alembic.
22revision = 'e939823521d6'
23down_revision = None
24branch_labels = None
25depends_on = None
26
27def upgrade():
28    op.create_table(
29        'account',
30        sa.Column('id', sa.Integer, primary_key=True),
31        sa.Column('name', sa.String(50), nullable=False),
32        sa.Column('description', sa.Unicode(200)),
33    )
34
35def downgrade():
36    op.drop_table('account')
37
38# 5. To apply the migration to the database, run:
39# alembic upgrade head