2b7248c8df70_upgrade_sppt.py

"""Upgrade SPPT

Revision ID: 2b7248c8df70
Revises: 17c4fdf1729d
Create Date: 2024-12-12 03:22:18.146849

"""

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

import sqlalchemy as sa
from alembic import op


def upgrade():
    schema = 'pbb'
    context = op.get_context()
    helpers = context.opts['helpers']
    helpers.fields_update("sppt", "denda_status", sa.String(1), schema)
    helpers.fields_update("sppt", "denda_pbb", sa.Numeric(15, 0), schema)
    helpers.fields_update("sppt", "njkp_pct", sa.Numeric(4, 3), schema)
    helpers.fields_update("sppt", "njkp_sppt", sa.Numeric(15, 0), schema)
    helpers.fields_update("sppt", "tarif_pct", sa.Numeric(4, 3), schema)
    helpers.fields_update("sppt", "denda_pct", sa.Numeric(4, 3), schema)


def downgrade():
    pass