17c4fdf1729d_upgrade_pst_permohonan.py

"""upgrade pst_permohonan

Revision ID: 17c4fdf1729d
Revises: 8d76ed25a315
Create Date: 2023-02-28 10:22:41.685259

"""

# revision identifiers, used by Alembic.
revision = '17c4fdf1729d'
down_revision = '8d76ed25a315'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    schema = 'pbb'
    context = op.get_context()
    helpers = context.opts['helpers']
    if not helpers.table_has_column('pst_permohonan', 'email_pemohon', schema):
        op.add_column('pst_permohonan',
                      sa.Column('email_pemohon', sa.String(256)), schema=schema)
    if not helpers.table_has_column('pst_permohonan', 'no_hp_pemohon', schema):
        op.add_column('pst_permohonan',
                      sa.Column('no_hp_pemohon', sa.String(16)), schema=schema)


def downgrade():
    pass