conditional/migrations/versions/e38beaf3e875_update_db.py at 0d00fd2e7f87887844369969288af6d509fd4d55 · ComputerScienceHouse/conditional · GitHub

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
95
96
97
98
99
100
101
"""update db

Revision ID: e38beaf3e875
Revises: 757e18146d16
Create Date: 2026-02-03 12:12:11.451367

"""

# revision identifiers, used by Alembic.
revision = 'e38beaf3e875'
down_revision = '757e18146d16'

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('freshman_accounts', 'onfloor_status',
               existing_type=sa.BOOLEAN(),
               nullable=True)
    op.alter_column('freshman_accounts', 'rit_username',
               existing_type=sa.VARCHAR(length=10),
               nullable=True)
    op.alter_column('freshman_hm_attendance', 'attendance_status',
               existing_type=postgresql.ENUM('Attended', 'Excused', 'Absent', name='attendance_enum'),
               nullable=True)
    op.alter_column('member_hm_attendance', 'attendance_status',
               existing_type=postgresql.ENUM('Attended', 'Excused', 'Absent', name='attendance_enum'),
               nullable=True)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('member_hm_attendance', 'attendance_status',
               existing_type=postgresql.ENUM('Attended', 'Excused', 'Absent', name='attendance_enum'),
               nullable=False)
    op.alter_column('freshman_hm_attendance', 'attendance_status',
               existing_type=postgresql.ENUM('Attended', 'Excused', 'Absent', name='attendance_enum'),
               nullable=False)
    op.alter_column('freshman_accounts', 'rit_username',
               existing_type=sa.VARCHAR(length=10),
               nullable=False)
    op.alter_column('freshman_accounts', 'onfloor_status',
               existing_type=sa.BOOLEAN(),
               nullable=False)
    op.create_table('batch_conditions',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('value', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('condition', postgresql.ENUM('packet', 'seminar', 'committee', 'house', name='batch_ctype_enum'), autoincrement=False, nullable=False),
    sa.Column('comparison', postgresql.ENUM('less', 'equal', 'greater', name='batch_comparison'), autoincrement=False, nullable=False),
    sa.Column('batch_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['batch_id'], ['batch.id'], name='batch_conditions_fk'),
    sa.PrimaryKeyConstraint('id', name='batch_conditions_pkey')
    )
    op.create_table('freshman_batch_users',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('fid', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('batch_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['batch_id'], ['batch.id'], name='freshman_batch_users_fk'),
    sa.ForeignKeyConstraint(['fid'], ['freshman_accounts.id'], name='freshman_batch_users_fk_1'),
    sa.PrimaryKeyConstraint('id', name='freshman_batch_users_pkey')
    )
    op.create_index('freshman_batch_users_id_pkey', 'freshman_batch_users', ['id'], unique=True)
    op.create_table('batch',
    sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('batch_id_seq'::regclass)"), autoincrement=True, nullable=False),
    sa.Column('name', sa.TEXT(), autoincrement=False, nullable=False),
    sa.Column('uid', sa.VARCHAR(length=32), autoincrement=False, nullable=False),
    sa.Column('approved', sa.BOOLEAN(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name='batch_pkey'),
    postgresql_ignore_search_path=False
    )
    op.create_table('member_batch_pulls',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('uid', sa.VARCHAR(length=32), autoincrement=False, nullable=False),
    sa.Column('approved', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False),
    sa.Column('reason', sa.TEXT(), server_default=sa.text("''::text"), autoincrement=False, nullable=False),
    sa.Column('puller', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name='member_batch_pulls_pkey')
    )
    op.create_index('member_batch_pulls_id_idx', 'member_batch_pulls', ['id'], unique=True)
    op.create_table('freshman_batch_pulls',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('fid', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('approved', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False),
    sa.Column('reason', sa.TEXT(), server_default=sa.text("''::text"), autoincrement=False, nullable=False),
    sa.Column('puller', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['fid'], ['freshman_accounts.id'], name='freshman_batch_pulls_fk_1'),
    sa.PrimaryKeyConstraint('id', name='freshman_batch_pulls_pkey')
    )
    op.create_index('freshman_batch_pulls_id_idx', 'freshman_batch_pulls', ['id'], unique=True)
    op.create_table('member_batch_users',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('uid', sa.VARCHAR(length=32), autoincrement=False, nullable=False),
    sa.Column('batch_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['batch_id'], ['batch.id'], name='member_batch_users_fk'),
    sa.PrimaryKeyConstraint('id', name='member_batch_users_pkey')
    )
    op.create_index('member_batch_users_id_idx', 'member_batch_users', ['id'], unique=False)
    # ### end Alembic commands ###