"""add_sequance_to_project_target_item_id

Revision ID: 3ceec8e52ef1
Revises: f871431ac640
Create Date: 2020-05-26 09:01:51.987892

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '3ceec8e52ef1'
down_revision = 'f871431ac640'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()

    bind.execute(
        """
            CREATE SEQUENCE public."ProjectTargetItem_id_seq"
            AS integer
            START WITH 1
            INCREMENT BY 1
            NO MINVALUE
            NO MAXVALUE
            CACHE 1;
            ALTER TABLE "ProjectTargetItem" ALTER COLUMN id SET DEFAULT nextval('public."ProjectTargetItem_id_seq"'::regclass);
            UPDATE "ProjectTargetItem" SET id = nextval('public."ProjectTargetItem_id_seq"'::regclass);
        """
    )


def downgrade():
    bind = op.get_bind()
    bind.execute("DROP SEQUENCE ProjectTargetItem_id_seq;")
    op.alter_column('ProjectTargetItem', 'id',
               existing_type=sa.BIGINT(),
               type_=sa.Integer())