cc2e4a0aad1e_upgrade_sspd.py

"""upgrade sspd

Revision ID: cc2e4a0aad1e
Revises: 64ae5cad07e0
Create Date: 2024-11-15 16:09:33.392335

"""

# revision identifiers, used by Alembic.
revision = 'cc2e4a0aad1e'
down_revision = '64ae5cad07e0'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    schema = 'pad'
    context = op.get_context()
    helpers = context.opts['helpers']
    if not helpers.table_has_column('pad_sspd', 'posted', schema):
        op.add_column('pad_sspd',
                      sa.Column('posted', sa.SmallInteger), schema=schema)
    if not helpers.table_has_column('pad_sspd', 'posting_simda_penetapan', schema):
        op.add_column('pad_sspd',
                      sa.Column('posting_simda_penetapan', sa.SmallInteger), schema=schema)

    if not helpers.table_has_column('pad_sspd', 'posting_simda_non_penetapan', schema):
        op.add_column('pad_sspd',
                      sa.Column('posting_simda_non_penetapan', sa.SmallInteger), schema=schema)


def downgrade():
    pass