from django.db import migrations

VIEW_SQL = """
DROP VIEW IF EXISTS emx_tt_activity_staff_view;

CREATE VIEW emx_tt_activity_staff_view AS
SELECT
    a.code AS activity_code,
    s.code AS staff_code
FROM tt_activity_staff ast
LEFT JOIN tt_activity a ON a.id = ast.activity_id
LEFT JOIN tt_staff s ON s.id = ast.staff_id
WHERE a.is_booking = 0
  AND a.scheduled = 1;
"""

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

class Migration(migrations.Migration):

    dependencies = [
        ("api", "0080_emxttactivitystafffinal_emxttactivitystaffhistory_and_more"),
    ]

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