30177a0d2c18_upgrade_spt_field.py

"""upgrade spt field

Revision ID: 30177a0d2c18
Revises: 6fb950081135
Create Date: 2025-02-18 13:10:21.857387

"""

# revision identifiers, used by Alembic.
from opensipkd.models.alembic import helpers
import sqlalchemy as sa
from deform import schema
from alembic import op
revision = '30177a0d2c18'
down_revision = '6fb950081135'
branch_labels = None
depends_on = None


def upgrade():
    table_name = "pad_spt"
    schema = 'pad'
    helpers.fields_update(table_name, "air_jenis_sumber_id", sa.Integer, default=0,
                          nullable=False, schema=schema)
    helpers.fields_update(table_name, "air_kualitas_id", sa.Integer, default=0,
                          nullable=False, schema=schema)


def downgrade():
    pass