db5fafdd9835_penambahan_field_kohir.py

"""penambahan field kohir

Revision ID: db5fafdd9835
Revises: ec4a35aa58ec
Create Date: 2023-10-17 11:24:50.283094

"""

# revision identifiers, used by Alembic.
import sqlalchemy as sa
from alembic import op
revision = 'db5fafdd9835'
down_revision = 'ec4a35aa58ec'
branch_labels = None
depends_on = None


def upgrade():
    schema = 'pad'
    context = op.get_context()
    helpers = context.opts['helpers']
    if not helpers.table_has_column('pad_kohir', 'spt_id', schema):
        op.add_column('pad_kohir',
                      sa.Column('spt_id', sa.Integer), schema=schema)
    stmt = "alter table pad.pad_kohir alter column sptpd_id drop not null"
    op.execute(stmt)


def downgrade():
    pass