pagure/alembic/versions/317a285e04a8_delete_hooks.py

"""Delete hooks

Revision ID: 317a285e04a8
Revises: 2aa7b3958bc5
Create Date: 2016-05-30 11:28:48.512577

"""

# revision identifiers, used by Alembic.
revision = '317a285e04a8'
down_revision = '2aa7b3958bc5'

from alembic import op
import sqlalchemy as sa


def upgrade():
    """ Alter the hooks table to update the foreign key to cascade on delete.
    """

    for table in [
            'hook_fedmsg', 'hook_irc', 'hook_mail',
            'hook_pagure_force_commit', 'hook_pagure', 'hook_pagure_requests',
            'hook_pagure_tickets', 'hook_pagure_unsigned_commit', 'hook_rtd',
            ]:
        op.drop_constraint(
            '%s_project_id_fkey' % table,
            table,
            type_='foreignkey')
        op. create_foreign_key(
            name='%s_project_id_fkey' % table,
            source_table=table,
            referent_table='projects',
            local_cols=['project_id'],
            remote_cols=['id'],
            onupdate='cascade',
            ondelete='cascade',
        )

    op.drop_constraint(
        'projects_groups_project_id_fkey',
        'projects_groups',
        type_='foreignkey')
    op. create_foreign_key(
        name='projects_groups_project_id_fkey',
        source_table='projects_groups',
        referent_table='projects',
        local_cols=['project_id'],
        remote_cols=['id'],
        onupdate='cascade',
        ondelete='cascade',
    )



def downgrade():
    """ Alter the hooks table to update the foreign key to undo the cascade
    on delete.
    """