30611cbc119e_dop_add_no_sertifikat.py

"""dop add no_sertifikat

Revision ID: 30611cbc119e
Revises: 
Create Date: 2023-02-20 21:35:06.877797

"""

# revision identifiers, used by Alembic.
revision = '30611cbc119e'
down_revision = None
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('dat_objek_pajak', 'no_sertifikat', schema):
        op.add_column('dat_objek_pajak',
                      sa.Column('no_sertifikat', sa.String(32)), schema=schema)

    if not helpers.table_has_column('dat_objek_pajak', 'create_date', schema):
        op.add_column('dat_objek_pajak',
                      sa.Column('create_date', sa.TIMESTAMP(timezone=False)),
                      schema=schema)
def downgrade():
    pass