Generate the required structure for broadcasting from a join, not from O(n) queries.

3 files changed, 48 insertions, 48 deletions

diff --git a/.sqlx/query-43c6f8d2fba6620d5ef64ca26494cfd46365670959cd33e1fd52bca46b0fdc20.json b/.sqlx/query-43c6f8d2fba6620d5ef64ca26494cfd46365670959cd33e1fd52bca46b0fdc20.json
deleted file mode 100644
index 6368a4a..0000000
--- a/.sqlx/query-43c6f8d2fba6620d5ef64ca26494cfd46365670959cd33e1fd52bca46b0fdc20.json
+++ /dev/null
@@ -1,38 +0,0 @@
-{
-  "db_name": "SQLite",
-  "query": "\n                select\n                    id as \"id: Id\",\n                    sender as \"sender: LoginId\",\n                    -- channel as \"channel: ChannelId\",\n                    body,\n                    sent_at as \"sent_at: DateTime\"\n                from message\n                where channel = $1\n                order by sent_at asc\n            ",
-  "describe": {
-    "columns": [
-      {
-        "name": "id: Id",
-        "ordinal": 0,
-        "type_info": "Text"
-      },
-      {
-        "name": "sender: LoginId",
-        "ordinal": 1,
-        "type_info": "Text"
-      },
-      {
-        "name": "body",
-        "ordinal": 2,
-        "type_info": "Text"
-      },
-      {
-        "name": "sent_at: DateTime",
-        "ordinal": 3,
-        "type_info": "Text"
-      }
-    ],
-    "parameters": {
-      "Right": 1
-    },
-    "nullable": [
-      false,
-      false,
-      false,
-      false
-    ]
-  },
-  "hash": "43c6f8d2fba6620d5ef64ca26494cfd46365670959cd33e1fd52bca46b0fdc20"
-}
diff --git a/.sqlx/query-959ae6e1e8653e33c26ed4320cea93631841fe57e5be0a207bd24ae1dadd3bad.json b/.sqlx/query-5df9d6889d5e057c3260d4956cdb313786b458082db232919de1a5e5195df7ee.json
index 06c5e53..7fd7ae3 100644
--- a/.sqlx/query-959ae6e1e8653e33c26ed4320cea93631841fe57e5be0a207bd24ae1dadd3bad.json
+++ b/.sqlx/query-5df9d6889d5e057c3260d4956cdb313786b458082db232919de1a5e5195df7ee.json
@@ -1,6 +1,6 @@
 {
   "db_name": "SQLite",
-  "query": "\n                insert into message\n                    (id, sender, channel, body, sent_at)\n                values ($1, $2, $3, $4, $5)\n                returning\n                    id as \"id: Id\",\n                    sender as \"sender: LoginId\",\n                    -- channel as \"channel: ChannelId\",\n                    body,\n                    sent_at as \"sent_at: DateTime\"\n            ",
+  "query": "\n                insert into message\n                    (id, sender, channel, body, sent_at)\n                values ($1, $2, $3, $4, $5)\n                returning\n                    id as \"id: Id\",\n                    body,\n                    sent_at as \"sent_at: DateTime\"\n            ",
   "describe": {
     "columns": [
       {
@@ -9,18 +9,13 @@
         "type_info": "Text"
       },
       {
-        "name": "sender: LoginId",
-        "ordinal": 1,
-        "type_info": "Text"
-      },
-      {
         "name": "body",
-        "ordinal": 2,
+        "ordinal": 1,
         "type_info": "Text"
       },
       {
         "name": "sent_at: DateTime",
-        "ordinal": 3,
+        "ordinal": 2,
         "type_info": "Text"
       }
     ],
@@ -30,9 +25,8 @@
     "nullable": [
       false,
       false,
-      false,
       false
     ]
   },
-  "hash": "959ae6e1e8653e33c26ed4320cea93631841fe57e5be0a207bd24ae1dadd3bad"
+  "hash": "5df9d6889d5e057c3260d4956cdb313786b458082db232919de1a5e5195df7ee"
 }
diff --git a/.sqlx/query-d4a496f6348550cd2c94c2235d82b01b29f864f64daf1bcb19162b1eb26df597.json b/.sqlx/query-d4a496f6348550cd2c94c2235d82b01b29f864f64daf1bcb19162b1eb26df597.json
new file mode 100644
index 0000000..e5c0eae
--- /dev/null
+++ b/.sqlx/query-d4a496f6348550cd2c94c2235d82b01b29f864f64daf1bcb19162b1eb26df597.json
@@ -0,0 +1,44 @@
+{
+  "db_name": "SQLite",
+  "query": "\n                select\n                    message.id as \"id: Id\",\n                    login.id as \"sender_id: LoginId\",\n                    login.name as sender_name,\n                    message.body,\n                    message.sent_at as \"sent_at: DateTime\"\n                from message\n                    join login on message.sender = login.id\n                where channel = $1\n                order by sent_at asc\n            ",
+  "describe": {
+    "columns": [
+      {
+        "name": "id: Id",
+        "ordinal": 0,
+        "type_info": "Text"
+      },
+      {
+        "name": "sender_id: LoginId",
+        "ordinal": 1,
+        "type_info": "Text"
+      },
+      {
+        "name": "sender_name",
+        "ordinal": 2,
+        "type_info": "Text"
+      },
+      {
+        "name": "body",
+        "ordinal": 3,
+        "type_info": "Text"
+      },
+      {
+        "name": "sent_at: DateTime",
+        "ordinal": 4,
+        "type_info": "Text"
+      }
+    ],
+    "parameters": {
+      "Right": 1
+    },
+    "nullable": [
+      false,
+      false,
+      false,
+      false,
+      false
+    ]
+  },
+  "hash": "d4a496f6348550cd2c94c2235d82b01b29f864f64daf1bcb19162b1eb26df597"
+}