"""insert_or_update_new_taxonomy

Revision ID: 5a422097ee8b
Revises: 132a25208482
Create Date: 2020-11-17 11:25:18.826155

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

# revision identifiers, used by Alembic.
revision = '5a422097ee8b'
down_revision = '50b5bb27d424'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    meta = sa.MetaData(bind=bind)
    meta.reflect()

    vals = [
        {"id":206, "name": 'Audience Network', "group_number": 1, "index": 5, "category_id":10},
        {"id":207, "name": 'Messenger', "group_number":1, "index":25, "category_id":10}
    ]
    for val in vals:
        insert_table = insert(meta.tables["CampaignTypeValue"]).values(**val)
        op.execute(insert_table.on_conflict_do_nothing())

    insert_objective_table = insert(meta.tables["CampaignObjective"]).values(
        id=18,
        name='Event Responses',
        goal_id=3

    )
    op.execute(
        insert_objective_table.on_conflict_do_nothing()
    )