f950bfaaead1_upgrade_kohir.py
1.31 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
"""upgrade kohir
Revision ID: f950bfaaead1
Revises: b8b271617f7c
Create Date: 2025-01-15 23:15:04.426337
"""
# revision identifiers, used by Alembic.
import sqlalchemy as sa
from alembic import op
revision = 'f950bfaaead1'
down_revision = 'b8b271617f7c'
branch_labels = None
depends_on = None
def upgrade():
schema = 'pad'
context = op.get_context()
helpers = context.opts['helpers']
helpers.fields_update("pad_kohir", "spt_id", sa.Integer, schema=schema)
helpers.fields_update("pad_kohir", "sptpd_id", sa.Integer, schema=schema)
helpers.fields_update("pad_kohir", "is_cancel",
sa.Integer, default="0", schema=schema)
helpers.fields_update("pad_kohir", "bap_no",
sa.String(256), schema=schema)
helpers.fields_update("pad_kohir", "bap_date",
sa.DateTime, schema=schema)
helpers.fields_update("pad_kohir", "cancel_no",
sa.BigInteger, schema=schema)
helpers.fields_update("pad_kohir", "cancel_date",
sa.DateTime, schema=schema)
helpers.fields_update("pad_kohir", "cancel_thn",
sa.Integer, schema=schema)
helpers.fields_update("pad_kohir", "cancel_uid",
sa.Integer, schema=schema)
def downgrade():
pass