"""Update RTD table

Revision ID: 22fb5256f555

Revises: 5affe6f5d94f

Create Date: 2018-03-07 15:46:26.478238

"""

# revision identifiers, used by Alembic.

revision = '22fb5256f555'

down_revision = '5affe6f5d94f'

from alembic import op

import sqlalchemy as sa

def upgrade():

    ''' Update the hook_rtd table for the new data structure it should use.

    '''

    op.add_column(

        'hook_rtd',

        sa.Column('api_url', sa.Text, nullable=True)

    )

    op.add_column(

        'hook_rtd',

        sa.Column('api_token', sa.Text, nullable=True)

    )

    op.drop_column('hook_rtd', 'project_name')

def downgrade():

    ''' Downgrade the structure of the hook_rtd table.

    '''

    op.drop_column('hook_rtd', 'api_url')

    op.drop_column('hook_rtd', 'api_token')

    op.add_column(

        'hook_rtd',

        sa.Column('project_name', sa.Text, nullable=True)

    )