add view
authorRadek Czajka <rczajka@rczajka.pl>
Fri, 28 Aug 2026 12:59:04 +0000 (14:59 +0200)
committerRadek Czajka <rczajka@rczajka.pl>
Fri, 28 Aug 2026 12:59:04 +0000 (14:59 +0200)
src/emails/migrations/0005_create_view.py [new file with mode: 0644]

diff --git a/src/emails/migrations/0005_create_view.py b/src/emails/migrations/0005_create_view.py
new file mode 100644 (file)
index 0000000..485df4e
--- /dev/null
@@ -0,0 +1,27 @@
+# Generated by Django 4.2.16 on 2026-08-28 12:48
+
+from django.db import migrations
+
+
+CREATE_VIEW = """
+CREATE VIEW emails_sharedmailbox_v AS
+SELECT
+    sm.name     AS from_user,
+    u.username  AS to_user
+FROM emails_sharedmailbox_users g
+JOIN auth_user u ON u.id = g.user_id
+JOIN emails_sharedmailbox sm  ON sm.id = g.sharedmailbox_id;
+"""
+
+DROP_VIEW = "DROP VIEW IF EXISTS emails_sharedmailbox_v;"
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('emails', '0004_sharedmailbox'),
+    ]
+
+    operations = [
+        migrations.RunSQL(CREATE_VIEW, reverse_sql=DROP_VIEW),
+    ]