from django.db import migrations

VIEW_SQL = """
DROP VIEW IF EXISTS emx_tt_activity_jta_variant_view;

CREATE VIEW emx_tt_activity_jta_variant_view AS
SELECT
    a.code AS parent_activity_code,
    jp.code AS child_activity_code
FROM tt_activity a
INNER JOIN tt_activity jp
    ON jp.id = a.jta_parent_id
WHERE a.jta_parent_id IS NOT NULL AND a.is_booking = 0

UNION ALL

SELECT
    vp.code AS parent_activity_code,
    a.code AS child_activity_code
FROM tt_activity a
INNER JOIN tt_activity vp
    ON vp.id = a.variant_parent_id
WHERE a.variant_parent_id IS NOT NULL AND a.is_booking = 0;
"""

REVERSE_SQL = """
DROP VIEW IF EXISTS emx_tt_activity_jta_variant_view;
"""

class Migration(migrations.Migration):

    dependencies = [
        ("api", "0076_emxttactivityjtavariantfinal_and_more"),
    ]

    operations = [
        migrations.RunSQL(
            sql=VIEW_SQL,
            reverse_sql=REVERSE_SQL,
        ),
    ]