Blame alembic/versions/eab41ce5f92a_add_active_commit_attribute_to_the_hook_.py
|
Clement Verna |
44c44e |
"""add active_commit attribute to the hook_pagure_ci table
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
Revision ID: eab41ce5f92a
|
|
Clement Verna |
44c44e |
Revises: e18d5b78d782
|
|
Clement Verna |
44c44e |
Create Date: 2018-03-21 13:37:24.117434
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
"""
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
# revision identifiers, used by Alembic.
|
|
Clement Verna |
44c44e |
revision = 'eab41ce5f92a'
|
|
Clement Verna |
44c44e |
down_revision = 'e18d5b78d782'
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
from alembic import op
|
|
Clement Verna |
44c44e |
import sqlalchemy as sa
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
def upgrade():
|
|
Clement Verna |
44c44e |
''' Add active_commit column to hook_pagure_ci table'''
|
|
Clement Verna |
44c44e |
op.add_column(
|
|
Clement Verna |
44c44e |
'hook_pagure_ci',
|
|
Clement Verna |
44c44e |
sa.Column('active_commit', sa.Boolean, nullable=True, default=False)
|
|
Clement Verna |
44c44e |
)
|
|
Clement Verna |
44c44e |
op.add_column(
|
|
Clement Verna |
44c44e |
'hook_pagure_ci',
|
|
Clement Verna |
44c44e |
sa.Column('active_pr', sa.Boolean, nullable=True, default=False)
|
|
Clement Verna |
44c44e |
)
|
|
Clement Verna |
dd6f03 |
op.execute('UPDATE hook_pagure_ci SET active_pr=active')
|
|
Clement Verna |
dd6f03 |
op.execute('UPDATE hook_pagure_ci SET active_commit=False')
|
|
Clement Verna |
dd6f03 |
op.alter_column(
|
|
Clement Verna |
dd6f03 |
'hook_pagure_ci', 'active_pr',
|
|
Clement Verna |
dd6f03 |
nullable=False, existing_nullable=True)
|
|
Clement Verna |
dd6f03 |
op.alter_column(
|
|
Clement Verna |
dd6f03 |
'hook_pagure_ci', 'active_commit',
|
|
Clement Verna |
dd6f03 |
nullable=False, existing_nullable=True)
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
|
|
Clement Verna |
44c44e |
def downgrade():
|
|
Clement Verna |
44c44e |
''' Revert the active_commit column added'''
|
|
Clement Verna |
dd6f03 |
|
|
Clement Verna |
dd6f03 |
op.execute('UPDATE hook_pagure_ci SET active=active_pr')
|
|
Clement Verna |
44c44e |
op.drop_column('hook_pagure_ci', 'active_commit')
|
|
Clement Verna |
dd6f03 |
op.drop_column('hook_pagure_ci', 'active_pr')
|