Blame alembic/versions/003fcd9e8860_add_an_origin_field_on_pr_to_issue.py

Pierre-Yves Chibon 2479ca
"""Add an origin field on pr_to_issue
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
Revision ID: 003fcd9e8860
Pierre-Yves Chibon 2479ca
Revises: 2b1743f77436
Pierre-Yves Chibon 2479ca
Create Date: 2019-03-12 14:55:59.316861
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
"""
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
from alembic import op
Pierre-Yves Chibon 2479ca
import sqlalchemy as sa
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
# revision identifiers, used by Alembic.
Pierre-Yves Chibon 2479ca
revision = '003fcd9e8860'
Pierre-Yves Chibon 2479ca
down_revision = '2b1743f77436'
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
def upgrade():
Pierre-Yves Chibon 2479ca
    ''' Add a column to record if the custom field should trigger a email
Pierre-Yves Chibon 2479ca
    notification.
Pierre-Yves Chibon 2479ca
    '''
Pierre-Yves Chibon 2479ca
    op.add_column(
Pierre-Yves Chibon 2479ca
        'pr_to_issue',
Pierre-Yves Chibon 2479ca
        sa.Column(
Pierre-Yves Chibon 2479ca
            'origin', sa.String(32), index=True
Pierre-Yves Chibon 2479ca
        )
Pierre-Yves Chibon 2479ca
    )
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
Pierre-Yves Chibon 2479ca
def downgrade():
Pierre-Yves Chibon 2479ca
    ''' Remove the key_notify column.
Pierre-Yves Chibon 2479ca
    '''
Pierre-Yves Chibon 2479ca
    op.drop_column('pr_to_issue', 'origin')