"""Add user reactions

Revision ID: a414cdc8ae2c
Revises: b56c2c7ac8a4
Create Date: 2017-01-29 21:09:34.501284

"""

# revision identifiers, used by Alembic.
revision = 'a414cdc8ae2c'
down_revision = 'b56c2c7ac8a4'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('user_reactions',
    sa.Column('user_id', sa.String(), nullable=False),
    sa.Column('track_id', sa.String(), nullable=False),
    sa.Column('reaction', sa.String(), nullable=False),
    sa.Column('created', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.PrimaryKeyConstraint('user_id', 'track_id', 'reaction')
    )
    op.create_index(op.f('ix_user_reactions_created'), 'user_reactions', ['created'], unique=False)

    op.execute("""
    insert into user_reactions (user_id, track_id, reaction)
    select user_id, track_id, 'liked' from user_likes on conflict do nothing
    """)
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_user_reactions_created'), table_name='user_reactions')
    op.drop_table('user_reactions')
    ### end Alembic commands ###