Blame alembic/versions/131ad2dc5bbd_table_for_no_new_branches_hook.py
|
Slavek Kabrda |
5afad4 |
"""Table for no new branches hook
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
Revision ID: 131ad2dc5bbd
|
|
Pierre-Yves Chibon |
c02205 |
Revises: 5bb80aeb238d
|
|
Slavek Kabrda |
5afad4 |
Create Date: 2018-05-11 10:52:05.088806
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
"""
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
# revision identifiers, used by Alembic.
|
|
Slavek Kabrda |
5afad4 |
revision = '131ad2dc5bbd'
|
|
Pierre-Yves Chibon |
c02205 |
down_revision = '5bb80aeb238d'
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
from alembic import op
|
|
Slavek Kabrda |
5afad4 |
import sqlalchemy as sa
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
def upgrade():
|
|
Slavek Kabrda |
5afad4 |
""" Create table for PagureNoNewBranchesHook. """
|
|
Slavek Kabrda |
5afad4 |
op.create_table(
|
|
Slavek Kabrda |
5afad4 |
'hook_pagure_no_new_branches',
|
|
Slavek Kabrda |
5afad4 |
sa.Column('id', sa.INTEGER(), nullable=False),
|
|
Slavek Kabrda |
5afad4 |
sa.Column('project_id', sa.INTEGER(), nullable=False),
|
|
Slavek Kabrda |
5afad4 |
sa.Column('active', sa.BOOLEAN(), nullable=False),
|
|
Slavek Kabrda |
5afad4 |
sa.ForeignKeyConstraint(
|
|
Slavek Kabrda |
5afad4 |
['project_id'],
|
|
Slavek Kabrda |
5afad4 |
[u'projects.id'],
|
|
Slavek Kabrda |
5afad4 |
name=u'hook_pagure_no_new_branches_project_id_fkey',
|
|
Slavek Kabrda |
5afad4 |
onupdate=u'CASCADE',
|
|
Slavek Kabrda |
5afad4 |
ondelete=u'CASCADE'
|
|
Slavek Kabrda |
5afad4 |
),
|
|
Slavek Kabrda |
5afad4 |
sa.PrimaryKeyConstraint('id', name=u'hook_pagure_no_new_branches_pkey')
|
|
Slavek Kabrda |
5afad4 |
)
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
|
|
Slavek Kabrda |
5afad4 |
def downgrade():
|
|
Slavek Kabrda |
5afad4 |
""" Remove table for PagureNoNewBranchesHook. """
|
|
Slavek Kabrda |
5afad4 |
op.drop_table('hook_pagure_no_new_branches')
|