diff options
Diffstat (limited to '.sqlx')
| -rw-r--r-- | .sqlx/query-2310fe5b8e88e314eb200d8f227b09c3e4b0c9c0202c7cbe3fba93213ea100cf.json | 44 | ||||
| -rw-r--r-- | .sqlx/query-54fe04ade0a01cfd0f3ddbedfa884d8a00f692eba656d3daa8119011b703cfcd.json | 20 | ||||
| -rw-r--r-- | .sqlx/query-760d3532e1613fd9f79ac98cb132479c6e7a2301d576af298da570f3effdc106.json (renamed from .sqlx/query-f29a6accbc6b4cca6a3b5702d475d33061ffc50b6bd65ac9a950ad6d715ba0bc.json) | 18 | ||||
| -rw-r--r-- | .sqlx/query-aeb970faead693939834df3be4c1f4499b6caf8d556050fca8036326f904e36e.json | 38 |
4 files changed, 76 insertions, 44 deletions
diff --git a/.sqlx/query-2310fe5b8e88e314eb200d8f227b09c3e4b0c9c0202c7cbe3fba93213ea100cf.json b/.sqlx/query-2310fe5b8e88e314eb200d8f227b09c3e4b0c9c0202c7cbe3fba93213ea100cf.json new file mode 100644 index 0000000..1bd4116 --- /dev/null +++ b/.sqlx/query-2310fe5b8e88e314eb200d8f227b09c3e4b0c9c0202c7cbe3fba93213ea100cf.json @@ -0,0 +1,44 @@ +{ + "db_name": "SQLite", + "query": "\n\t\t\t\tinsert into message\n\t\t\t\t\t(id, channel, sequence, sender, body, sent_at)\n\t\t\t\tvalues ($1, $2, $3, $4, $5, $6)\n\t\t\t\treturning\n\t\t\t\t\tid as \"id: message::Id\",\n sequence as \"sequence: Sequence\",\n\t\t\t\t\tsender as \"sender: login::Id\",\n\t\t\t\t\tbody,\n\t\t\t\t\tsent_at as \"sent_at: DateTime\"\n\t\t\t", + "describe": { + "columns": [ + { + "name": "id: message::Id", + "ordinal": 0, + "type_info": "Text" + }, + { + "name": "sequence: Sequence", + "ordinal": 1, + "type_info": "Integer" + }, + { + "name": "sender: login::Id", + "ordinal": 2, + "type_info": "Text" + }, + { + "name": "body", + "ordinal": 3, + "type_info": "Text" + }, + { + "name": "sent_at: DateTime", + "ordinal": 4, + "type_info": "Text" + } + ], + "parameters": { + "Right": 6 + }, + "nullable": [ + false, + false, + false, + false, + false + ] + }, + "hash": "2310fe5b8e88e314eb200d8f227b09c3e4b0c9c0202c7cbe3fba93213ea100cf" +} diff --git a/.sqlx/query-54fe04ade0a01cfd0f3ddbedfa884d8a00f692eba656d3daa8119011b703cfcd.json b/.sqlx/query-54fe04ade0a01cfd0f3ddbedfa884d8a00f692eba656d3daa8119011b703cfcd.json new file mode 100644 index 0000000..a739207 --- /dev/null +++ b/.sqlx/query-54fe04ade0a01cfd0f3ddbedfa884d8a00f692eba656d3daa8119011b703cfcd.json @@ -0,0 +1,20 @@ +{ + "db_name": "SQLite", + "query": "\n -- `max` never returns null, but sqlx can't detect that\n select max(sequence) as \"sequence!: Sequence\"\n from message\n where channel = $1\n ", + "describe": { + "columns": [ + { + "name": "sequence!: Sequence", + "ordinal": 0, + "type_info": "Null" + } + ], + "parameters": { + "Right": 1 + }, + "nullable": [ + true + ] + }, + "hash": "54fe04ade0a01cfd0f3ddbedfa884d8a00f692eba656d3daa8119011b703cfcd" +} diff --git a/.sqlx/query-f29a6accbc6b4cca6a3b5702d475d33061ffc50b6bd65ac9a950ad6d715ba0bc.json b/.sqlx/query-760d3532e1613fd9f79ac98cb132479c6e7a2301d576af298da570f3effdc106.json index e2b6d74..beb9234 100644 --- a/.sqlx/query-f29a6accbc6b4cca6a3b5702d475d33061ffc50b6bd65ac9a950ad6d715ba0bc.json +++ b/.sqlx/query-760d3532e1613fd9f79ac98cb132479c6e7a2301d576af298da570f3effdc106.json @@ -1,6 +1,6 @@ { "db_name": "SQLite", - "query": "\n\t\t\t\tselect\n\t\t\t\t\tmessage.id as \"id: message::Id\",\n\t\t\t\t\tlogin.id as \"sender_id: login::Id\",\n\t\t\t\t\tlogin.name as sender_name,\n\t\t\t\t\tmessage.body,\n\t\t\t\t\tmessage.sent_at as \"sent_at: DateTime\"\n\t\t\t\tfrom message\n\t\t\t\t\tjoin login on message.sender = login.id\n\t\t\t\twhere channel = $1\n\t\t\t\t\tand coalesce(sent_at > $2, true)\n\t\t\t\torder by sent_at asc\n\t\t\t", + "query": "\n\t\t\t\tselect\n\t\t\t\t\tmessage.id as \"id: message::Id\",\n sequence as \"sequence: Sequence\",\n\t\t\t\t\tlogin.id as \"sender_id: login::Id\",\n\t\t\t\t\tlogin.name as sender_name,\n\t\t\t\t\tmessage.body,\n\t\t\t\t\tmessage.sent_at as \"sent_at: DateTime\"\n\t\t\t\tfrom message\n\t\t\t\t\tjoin login on message.sender = login.id\n\t\t\t\twhere channel = $1\n\t\t\t\t\tand coalesce(sequence > $2, true)\n\t\t\t\torder by sequence asc\n\t\t\t", "describe": { "columns": [ { @@ -9,23 +9,28 @@ "type_info": "Text" }, { - "name": "sender_id: login::Id", + "name": "sequence: Sequence", "ordinal": 1, + "type_info": "Integer" + }, + { + "name": "sender_id: login::Id", + "ordinal": 2, "type_info": "Text" }, { "name": "sender_name", - "ordinal": 2, + "ordinal": 3, "type_info": "Text" }, { "name": "body", - "ordinal": 3, + "ordinal": 4, "type_info": "Text" }, { "name": "sent_at: DateTime", - "ordinal": 4, + "ordinal": 5, "type_info": "Text" } ], @@ -37,8 +42,9 @@ false, false, false, + false, false ] }, - "hash": "f29a6accbc6b4cca6a3b5702d475d33061ffc50b6bd65ac9a950ad6d715ba0bc" + "hash": "760d3532e1613fd9f79ac98cb132479c6e7a2301d576af298da570f3effdc106" } diff --git a/.sqlx/query-aeb970faead693939834df3be4c1f4499b6caf8d556050fca8036326f904e36e.json b/.sqlx/query-aeb970faead693939834df3be4c1f4499b6caf8d556050fca8036326f904e36e.json deleted file mode 100644 index 9234a9b..0000000 --- a/.sqlx/query-aeb970faead693939834df3be4c1f4499b6caf8d556050fca8036326f904e36e.json +++ /dev/null @@ -1,38 +0,0 @@ -{ - "db_name": "SQLite", - "query": "\n\t\t\t\tinsert into message\n\t\t\t\t\t(id, sender, channel, body, sent_at)\n\t\t\t\tvalues ($1, $2, $3, $4, $5)\n\t\t\t\treturning\n\t\t\t\t\tid as \"id: message::Id\",\n\t\t\t\t\tsender as \"sender: login::Id\",\n\t\t\t\t\tbody,\n\t\t\t\t\tsent_at as \"sent_at: DateTime\"\n\t\t\t", - "describe": { - "columns": [ - { - "name": "id: message::Id", - "ordinal": 0, - "type_info": "Text" - }, - { - "name": "sender: login::Id", - "ordinal": 1, - "type_info": "Text" - }, - { - "name": "body", - "ordinal": 2, - "type_info": "Text" - }, - { - "name": "sent_at: DateTime", - "ordinal": 3, - "type_info": "Text" - } - ], - "parameters": { - "Right": 5 - }, - "nullable": [ - false, - false, - false, - false - ] - }, - "hash": "aeb970faead693939834df3be4c1f4499b6caf8d556050fca8036326f904e36e" -} |