"""commit flag

Revision ID: 2b626a16542e
Revises: 2fb229dac744
Create Date: 2017-11-15 10:06:55.088665

"""

import datetime

from alembic import op
import sqlalchemy as sa

# revision identifiers, used by Alembic.
revision = '2b626a16542e'
down_revision = '2fb229dac744'


def upgrade():
    ''' Create the commit_flags table. '''

    op.create_table(
        'commit_flags',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('uid', sa.String(32), unique=True, nullable=False),
        sa.Column('commit_hash', sa.String(40), index=True, nullable=False),
        sa.Column(
            'token_id', sa.String(64),
            sa.ForeignKey('tokens.id'), nullable=False),
        sa.Column(
            'project_id',
            sa.Integer,
            sa.ForeignKey(
                'projects.id', onupdate='CASCADE', ondelete='CASCADE',
            ),
            nullable=False, index=True),
        sa.Column(
            'user_id', sa.Integer,
            sa.ForeignKey('users.id', onupdate='CASCADE'),
            nullable=False, index=True),
        sa.Column('status', sa.String(32), nullable=False),
        sa.Column('username', sa.Text(), nullable=False),
        sa.Column('percent', sa.Integer(), nullable=True),
        sa.Column('comment', sa.Text(), nullable=False),
        sa.Column('url', sa.Text(), nullable=False),
        sa.Column(
            'date_created', sa.DateTime, nullable=False,
            default=datetime.datetime.utcnow),
    )

    op.create_unique_constraint(
        "commit_flags_uid_commit_hash_key",
        'commit_flags',
        ["uid", "commit_hash"]
    )


def downgrade():
    ''' Drop the commit_flags table. '''

    op.drop_table('commit_flags')