Force a delete rule for views

1 files changed, 32 insertions, 0 deletions

diff --git a/chimere/migrations/0016_aggregated_delete_rules.py b/chimere/migrations/0016_aggregated_delete_rules.py
new file mode 100644
index 0000000..b511b3a
--- /dev/null
+++ b/chimere/migrations/0016_aggregated_delete_rules.py
@@ -0,0 +1,32 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.11.5 on 2018-03-17 12:42
+from __future__ import unicode_literals
+
+from django.db import migrations
+
+
+SQL_ROUTE = """
+CREATE RULE agg_route_delete AS ON DELETE TO chimere_aggregated_routes
+DO INSTEAD(
+    DELETE FROM django_migrations where id=id + 1;
+);
+"""
+
+SQL_POLY = """
+CREATE RULE agg_poly_delete AS ON DELETE TO chimere_aggregated_polygons
+DO INSTEAD(
+    DELETE FROM django_migrations where id=id + 1;
+);
+"""
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('chimere', '0015_force_creation_of_aggregated'),
+    ]
+
+    operations = [
+        migrations.RunSQL(SQL_POLY),
+        migrations.RunSQL(SQL_ROUTE),
+    ]