Module de903581465c_create_table_for_upvoting_and_
[hide private]
[frames] | no frames]

Source Code for Module de903581465c_create_table_for_upvoting_and_

 1  """ 
 2  Create table for upvoting and downvoting projects 
 3   
 4  Revision ID: de903581465c 
 5  Revises: 484a1d4dd424 
 6  Create Date: 2020-07-26 19:36:51.199148 
 7  """ 
 8   
 9  import sqlalchemy as sa 
10  from alembic import op 
11   
12   
13  revision = 'de903581465c' 
14  down_revision = '484a1d4dd424' 
15   
16 -def upgrade():
17 op.create_table( 18 'copr_score', 19 sa.Column('id', sa.Integer(), nullable=False), 20 sa.Column('copr_id', sa.Integer(), nullable=False), 21 sa.Column('user_id', sa.Integer(), nullable=False), 22 sa.Column('score', sa.Integer(), nullable=False), 23 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 24 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), 25 sa.PrimaryKeyConstraint('id') 26 ) 27 op.create_index(op.f('ix_copr_score_copr_id'), 'copr_score', ['copr_id'], unique=False) 28 op.create_unique_constraint('copr_score_copr_id_user_id_uniq', 'copr_score', ['copr_id', 'user_id'])
29 30
31 -def downgrade():
32 op.drop_constraint('copr_score_copr_id_user_id_uniq', 'copr_score', type_='unique') 33 op.drop_index(op.f('ix_copr_score_copr_id'), table_name='copr_score') 34 op.drop_table('copr_score')
35