"""create_gras_project

Revision ID: a39ddf0fb0a8
Revises: 1cde43335ff9
Create Date: 2020-07-22 09:30:32.205075

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
from sqlalchemy.dialects import postgresql

revision = 'a39ddf0fb0a8'
down_revision = '1cde43335ff9'
branch_labels = None
depends_on = None


def upgrade():
    op.create_table("RepertoireOwner",
        sa.Column('id', sa.BIGINT(), server_default=sa.text('nextval(\'"RepertoireOwner_id_seq"\'::regclass)'),
                  autoincrement=True, nullable=False),
        sa.Column('external_id', sa.String(), nullable=False),
        sa.Column('name', sa.String, nullable=False),
        sa.PrimaryKeyConstraint('id', name=op.f('pk_RepertoireOwner')),
        sa.UniqueConstraint('external_id', name=op.f('uq_RepertoireOwner_external_id')),
    )

    op.create_table('GRASProject',
        sa.Column('id', sa.BIGINT(), server_default=sa.text('nextval(\'"GRASProject_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
        sa.Column('external_id', sa.String(), nullable=False),
        sa.Column('title', sa.String, nullable=False),
        sa.Column('start_date', sa.Date(), nullable=False),
        sa.Column('repertoire_owner_id', sa.Integer(), nullable=False),
        sa.Column('is_deleted', sa.Boolean(), nullable=False, server_default='FALSE'),
        sa.Column('created_at',
                  postgresql.TIMESTAMP(timezone=True),
                  server_default=sa.func.current_timestamp(),
                  nullable=False),
        sa.Column('updated_at',
                  postgresql.TIMESTAMP(timezone=True),
                  server_default=sa.func.current_timestamp(),
                  nullable=True),
        sa.ForeignKeyConstraint(
            ['repertoire_owner_id'],
            ['RepertoireOwner.id'],
            name=op.f('fk_GRASProject_repertoire_owner_id_RepertoireOwner')
        ),
        sa.PrimaryKeyConstraint('id', name=op.f('pk_GRASProject')),
        sa.UniqueConstraint('external_id', name=op.f('uq_GRASProject_external_id')),
    )

    op.create_table('GRASProjectArtist',
        sa.Column('id', sa.BIGINT(), server_default=sa.text('nextval(\'"GRASProjectArtist_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
        sa.Column('gras_project_id', sa.BIGINT(), nullable=False),
        sa.Column('artist_id', sa.BIGINT(), nullable=False),
        sa.Column('type', sa.Integer(), nullable=False),
        sa.ForeignKeyConstraint(['artist_id'], ['Artist.id'], name=op.f('fk_GRASProjectArtist_label_id_Artist'), ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['gras_project_id'], ['GRASProject.id'], name=op.f('fk_GRASProjectArtist_gras_project_id_GRASProject'), ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id', name=op.f('pk_GRASProjectArtist'))
    )



def downgrade():
    op.drop_table('GRASProjectArtist')
    op.drop_table('GRASProject')
    op.drop_table('RepertoireOwner')