f7b069984d27_penambahan_field_airtanah.py
1.77 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
"""penambahan field airtanah
Revision ID: f7b069984d27
Revises: db5fafdd9835
Create Date: 2023-11-28 11:12:37.568577
"""
# revision identifiers, used by Alembic.
revision = 'f7b069984d27'
down_revision = 'db5fafdd9835'
branch_labels = None
depends_on = None
from alembic import op
import sqlalchemy as sa
def upgrade():
schema = 'pad'
context = op.get_context()
helpers = context.opts['helpers']
if not helpers.table_has_column('pad_at_jenis_manfaat', 'bobot', schema):
op.add_column('pad_at_jenis_manfaat',
sa.Column('bobot', sa.Float), schema=schema)
if not helpers.table_has_column('pad_at_komponen_pemulihan', 'bobot', schema):
op.add_column('pad_at_komponen_pemulihan',
sa.Column('bobot', sa.Float), schema=schema)
if not helpers.table_has_column('pad_at_komponen_pemulihan', 'nilai_komponen', schema):
op.add_column('pad_at_komponen_pemulihan',
sa.Column('nilai_komponen', sa.Float), schema=schema)
if not helpers.table_has_column('pad_at_kualitas', 'kualitas', schema):
op.add_column('pad_at_kualitas',
sa.Column('kualitas', sa.Integer), schema=schema)
if not helpers.table_has_column('pad_at_kualitas', 'alternatif', schema):
op.add_column('pad_at_kualitas',
sa.Column('alternatif', sa.Integer), schema=schema)
if not helpers.table_has_column('pad_at_kualitas', 'bobot', schema):
op.add_column('pad_at_kualitas',
sa.Column('bobot', sa.Float), schema=schema)
if not helpers.table_has_column('pad_at_kualitas', 'komponen_sda', schema):
op.add_column('pad_at_kualitas',
sa.Column('komponen_sda', sa.Float), schema=schema)
def downgrade():
pass