from django.db import migrations

VIEW_SQL = """
DROP VIEW IF EXISTS emx_tt_activity_location_view;

CREATE VIEW emx_tt_activity_location_view AS
SELECT
    a.code AS activity_code,
    l.code AS location_code
FROM tt_activity_location al
LEFT JOIN tt_activity a ON a.id = al.activity_id
LEFT JOIN tt_location l ON l.id = al.location_id
WHERE a.is_booking = 0
  AND a.scheduled = 1;
"""

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

class Migration(migrations.Migration):

    dependencies = [
        ("api", "0078_emxttactivitylocationfinal_and_more"),
    ]

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