"""add_twitter_metrics

Revision ID: 5e7e5cd9e560
Revises: e8c770428b8d
Create Date: 2018-02-08 22:12:49.619529

"""

# revision identifiers, used by Alembic.
revision = '5e7e5cd9e560'
down_revision = 'e8c770428b8d'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('tw_stats',
    sa.Column('as_of', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('eid', sa.Integer(), nullable=False, autoincrement=False),
    sa.Column('listed_count', sa.Integer(), server_default=sa.text('0'), autoincrement=False, nullable=False),
    sa.Column('friends_count', sa.Integer(), server_default=sa.text('0'), autoincrement=False, nullable=False),
    sa.Column('statuses_count', sa.Integer(), server_default=sa.text('0'), autoincrement=False, nullable=False),
    sa.Column('followers_count', sa.Integer(), server_default=sa.text('0'), autoincrement=False, nullable=False),
    sa.Column('favourites_count', sa.Integer(), server_default=sa.text('0'), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['eid'], ['tracked_entities.eid'], name='fk_tw_metrics_eid'),
    sa.PrimaryKeyConstraint('as_of', 'eid')
    )
    op.add_column('tracked_entities', sa.Column('twitter_metrics_last_updated', sa.DateTime(), nullable=True))
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('tracked_entities', 'twitter_metrics_last_update')
    op.drop_table('tw_stats')
    ### end Alembic commands ###