d0105ef47fd1_pjdl_daftar.py
3.97 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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
"""pjdl daftar
Revision ID: d0105ef47fd1
Revises: 6584ec93814b
Create Date: 2024-11-22 19:06:50.336660
"""
# revision identifiers, used by Alembic.
revision = 'd0105ef47fd1'
down_revision = '6584ec93814b'
branch_labels = None
depends_on = None
import sqlalchemy as sa
from alembic import op
def upgrade():
context = op.get_context()
helpers = context.opts['helpers']
helpers.fields_update("pad_daftar", "kd_park_roda2_luas", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda2_jumlah", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda2_tarif1", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda2_tarif2", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda2_tarif3", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda4_luas", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda4_jumlah", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda4_tarif1", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda4_tarif2", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_roda4_tarif3", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_rodax_luas", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_rodax_jumlah", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_rodax_tarif1", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_rodax_tarif2", sa.Integer)
helpers.fields_update("pad_daftar", "kd_park_rodax_tarif3", sa.Integer)
helpers.fields_update("pad_daftar", "ijin1file", sa.String(50))
helpers.fields_update("pad_daftar", "ijin2file", sa.String(50))
helpers.fields_update("pad_daftar", "ijin3file", sa.String(50))
helpers.fields_update("pad_daftar", "ijin4file", sa.String(50))
helpers.fields_update("pad_daftar", "status_id", sa.Integer)
# ,)
# sa.ForeignKey(f"{schema}.pad_daftar.id", ondelete="RESTRICT"))
helpers.fields_update("pad_daftar", "cu_id", sa.Integer)
helpers.fields_update("pad_daftar", "ijin1", sa.String(100))
helpers.fields_update("pad_daftar", "ijin1no", sa.String(100))
helpers.fields_update("pad_daftar", "ijin1tgl", sa.DateTime)
helpers.fields_update("pad_daftar", "ijin1tglakhir", sa.DateTime)
helpers.fields_update("pad_daftar", "ijin2", sa.String(100))
helpers.fields_update("pad_daftar", "ijin2no", sa.String(100))
helpers.fields_update("pad_daftar", "ijin2tgl", sa.DateTime)
helpers.fields_update("pad_daftar", "ijin2tglakhir", sa.DateTime)
helpers.fields_update("pad_daftar", "ijin3", sa.String(100))
helpers.fields_update("pad_daftar", "ijin3no", sa.String(100))
helpers.fields_update("pad_daftar", "ijin3tgl", sa.DateTime)
helpers.fields_update("pad_daftar", "ijin3tglakhir", sa.DateTime)
helpers.fields_update("pad_daftar", "ijin4", sa.String(100))
helpers.fields_update("pad_daftar", "ijin4no", sa.String(100))
helpers.fields_update("pad_daftar", "ijin4tgl", sa.DateTime)
helpers.fields_update("pad_daftar", "ijin4tglakhir", sa.DateTime)
helpers.fields_update("pad_daftar", "kd_restojmlmeja", sa.Integer)
helpers.fields_update("pad_daftar", "kd_restojmlkursi", sa.Integer)
helpers.fields_update("pad_daftar", "kd_restojmltamu", sa.Integer)
helpers.fields_update("pad_daftar", "kd_filmkursi", sa.Integer)
helpers.fields_update("pad_daftar", "kd_filmpertunjukan", sa.Integer)
helpers.fields_update("pad_daftar", "kd_filmtarif", sa.Float(53))
helpers.fields_update("pad_daftar", "kd_bilyarmeja", sa.Integer)
helpers.fields_update("pad_daftar", "kd_bilyartarif", sa.Float(53))
helpers.fields_update("pad_daftar", "kd_bilyarkegiatan", sa.Integer)
helpers.fields_update("pad_daftar", "kd_diskopengunjung", sa.Integer)
helpers.fields_update("pad_daftar", "kd_diskotarif", sa.Float(53))
helpers.fields_update("pad_daftar", "kd_waletvolume", sa.Integer)
statement = "alter table pad.pad_daftar alter column cu_id type bigint"
op.execute(statement)
def downgrade():
pass