d45090cbb003_upgrade_opsen.py
4.23 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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
"""upgrade opsen
Revision ID: d45090cbb003
Revises: d0105ef47fd1
Create Date: 2024-12-31 10:37:14.204146
"""
# revision identifiers, used by Alembic.
import sqlalchemy as sa
from alembic import op
revision = 'd45090cbb003'
down_revision = 'd0105ef47fd1'
branch_labels = None
depends_on = None
def upgrade():
context = op.get_context()
helpers = context.opts['helpers']
schema = "pad"
helpers.fields_update("pad_pajak_tarif", "opsen_tarif", sa.Float, default=0,
nullable=False, schema=schema)
table = "pad_spt"
helpers.fields_update(table, "pokok", sa.Float,
default='dasar*tarif', nullable=False, schema=schema)
helpers.fields_update(table, "pokok_pajak", sa.Float,
default='pokok+denda+kenaikan+lain2-kompensasi-setoran',
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_tarif", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_pokok", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_denda", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_setoran", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_pokok_pajak", sa.Float,
default="opsen_pokok+opsen_denda-opsen_setoran",
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_bunga", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_terhutang", sa.Float,
default="opsen_pokok_pajak+opsen_bunga",
nullable=False, schema=schema)
helpers.fields_update(table, "pajak_yg_hrs_dibayar", sa.Float,
default="pajak_terhutang+opsen_terhutang",
nullable=False, schema=schema)
table = "pad_sptpd"
helpers.fields_update(table, "opsen_tarif", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_pokok", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_denda", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_pokok_pajak", sa.Float,
default="opsen_pokok+opsen_denda",
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_bunga", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_terhutang", sa.Float,
default="opsen_pokok_pajak+opsen_bunga",
nullable=False, schema=schema)
helpers.fields_update(table, "pajak_yg_hrs_dibayar", sa.Float,
default="pajak_terhutang+opsen_terhutang",
nullable=False, schema=schema)
table = "pad_sspd"
helpers.fields_update(table, "opsen_bayar", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_denda", sa.Float, default=0,
nullable=False, schema=schema)
helpers.fields_update(table, "opsen_bunga", sa.Float, default=0,
nullable=False, schema=schema)
table = "pad_spt_type"
helpers.fields_update(table, "persen_denda", sa.Float,
default=0, nullable=False)
helpers.fields_update(table, "is_hari_kerja",
sa.Boolean, default=False, nullable=False)
helpers.fields_update(table, "denda", sa.BigInteger,
default=0, nullable=False)
helpers.fields_update(table, "denda_badan", sa.BigInteger,
default=0, nullable=False)
helpers.fields_update(table, "max_day", sa.Integer,
default=0, nullable=False)
helpers.fields_update(table, "max_denda", sa.Integer,
default=0, nullable=False)
def downgrade():
pass