"""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.

    """