6fb950081135_upgrade_reklame_v1.py
1.81 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
"""upgrade reklame v1
Revision ID: 6fb950081135
Revises: 7813ffa5eba8
Create Date: 2025-02-10 15:09:17.461632
"""
# revision identifiers, used by Alembic.
from opensipkd.models.alembic import helpers
import sqlalchemy as sa
from alembic import op
revision = '6fb950081135'
down_revision = '7813ffa5eba8'
branch_labels = None
depends_on = None
def upgrade():
# context = op.get_context()
# helpers = context.opts['helpers']
table_name = 'pad_customer_usaha'
schema = "pad"
helpers.fields_update(table_name, "r_panjang", sa.Float, schema=schema)
helpers.fields_update(table_name, "r_lebar", sa.Float, schema=schema)
helpers.fields_update(table_name, "r_luas", sa.Float, schema=schema)
helpers.fields_update(table_name, "r_tinggi", sa.Float, schema=schema)
helpers.fields_update(table_name, "r_muka", sa.Integer, schema=schema)
helpers.fields_update(table_name, "r_banyak", sa.Integer, schema=schema)
helpers.fields_update(table_name, "r_nsr_id", sa.Integer, schema=schema)
helpers.fields_update(table_name, "r_jalanklas_id",
sa.Integer, schema=schema)
helpers.fields_update(table_name, "r_jalan_id", sa.Integer, schema=schema)
helpers.fields_update(table_name, "r_lokasi_pasang_id",
sa.Integer, schema=schema)
helpers.fields_update(table_name, "r_sudut_pandang_id",
sa.Integer, schema=schema)
helpers.fields_update(table_name, "r_judul", sa.String(254), schema=schema)
helpers.fields_update(
table_name, "r_jenis_produk_reklame_id", sa.Integer, schema=schema)
helpers.fields_update(
table_name, "r_letak_reklame_id", sa.Integer, schema=schema)
table_name = "pad_spt"
helpers.fields_update(table_name, "r_judul", sa.String(254), schema=schema)
def downgrade():
pass