"""change_field_createa_in_user_table

Revision ID: 48fb7557822f
Revises: bfbe9c9f0423
Create Date: 2020-04-06 10:27:32.209692

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


# revision identifiers, used by Alembic.
revision = '48fb7557822f'
down_revision = 'bfbe9c9f0423'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('User',
                  sa.Column('updated_at',
                            postgresql.TIMESTAMP(timezone=True),
                            server_default=sa.func.current_timestamp(),
                            nullable=True))

    bind = op.get_bind()

    bind.execute('''
            UPDATE "User" 
            SET updated_at = updated;
            ALTER TABLE "User" 
            ALTER COLUMN updated_at SET NOT NULL,
            DROP COLUMN updated;
        ''')


def downgrade():
    op.add_column('User',
                  sa.Column('updated',
                            postgresql.TIMESTAMP(timezone=True),
                            server_default=sa.func.current_timestamp(),
                            nullable=True))

    bind = op.get_bind()

    bind.execute('''
            UPDATE "User" 
            SET updated = updated_at;
            ALTER TABLE "User" 
            ALTER COLUMN updated SET NOT NULL,
            DROP COLUMN updated_at;
        ''')