"""add_CMG_label

Revision ID: 1e747b52a328
Revises: eeb45cac0d8b
Create Date: 2021-02-15 15:21:51.469405

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '1e747b52a328'
down_revision = '4aae9b1ffcbe'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    bind.execute('''INSERT INTO "Label" (id, name, external_id, external_name) VALUES (44, 'Commercial Music Group', 'G079', 'Commercial Music Group')''')


def downgrade():
    bind = op.get_bind()
    bind.execute('''DELETE FROM "Label" WHERE id = 44 ''')