diff options
author | FxQnLr <[email protected]> | 2023-11-17 11:19:43 +0100 |
---|---|---|
committer | GitHub <[email protected]> | 2023-11-17 11:19:43 +0100 |
commit | da6367885d31698464e1bec122e3e673974427c6 (patch) | |
tree | b7ee38cc5a247151d99f0fbb75a529e5b07718e9 /.sqlx | |
parent | 4f124e6ba636e6191c2960d96d0057f3061988fc (diff) | |
parent | 075b0bdc47713e303f9954556fa4b4bb472b441a (diff) | |
download | webol-da6367885d31698464e1bec122e3e673974427c6.tar webol-da6367885d31698464e1bec122e3e673974427c6.tar.gz webol-da6367885d31698464e1bec122e3e673974427c6.zip |
Merge pull request #8 from FxQnLr/eta
Eta
Diffstat (limited to '.sqlx')
-rw-r--r-- | .sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json (renamed from .sqlx/query-f179f38584f97842cd41159dd2293fa19e5f1975ea8810526924e77683ba92c4.json) | 12 | ||||
-rw-r--r-- | .sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json | 15 | ||||
-rw-r--r-- | .sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json | 20 | ||||
-rw-r--r-- | .sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json (renamed from .sqlx/query-82c11b5a47389884e4ed945b87dfcee9067933c4df892609700c0766c20fc5c5.json) | 12 |
4 files changed, 53 insertions, 6 deletions
diff --git a/.sqlx/query-f179f38584f97842cd41159dd2293fa19e5f1975ea8810526924e77683ba92c4.json b/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json index 322db91..33d524d 100644 --- a/.sqlx/query-f179f38584f97842cd41159dd2293fa19e5f1975ea8810526924e77683ba92c4.json +++ b/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json | |||
@@ -1,6 +1,6 @@ | |||
1 | { | 1 | { |
2 | "db_name": "PostgreSQL", | 2 | "db_name": "PostgreSQL", |
3 | "query": "\n UPDATE devices\n SET mac = $1, broadcast_addr = $2, ip = $3 WHERE id = $4\n RETURNING id, mac, broadcast_addr, ip;\n ", | 3 | "query": "\n UPDATE devices\n SET mac = $1, broadcast_addr = $2, ip = $3 WHERE id = $4\n RETURNING id, mac, broadcast_addr, ip, times;\n ", |
4 | "describe": { | 4 | "describe": { |
5 | "columns": [ | 5 | "columns": [ |
6 | { | 6 | { |
@@ -22,6 +22,11 @@ | |||
22 | "ordinal": 3, | 22 | "ordinal": 3, |
23 | "name": "ip", | 23 | "name": "ip", |
24 | "type_info": "Varchar" | 24 | "type_info": "Varchar" |
25 | }, | ||
26 | { | ||
27 | "ordinal": 4, | ||
28 | "name": "times", | ||
29 | "type_info": "Int8Array" | ||
25 | } | 30 | } |
26 | ], | 31 | ], |
27 | "parameters": { | 32 | "parameters": { |
@@ -36,8 +41,9 @@ | |||
36 | false, | 41 | false, |
37 | false, | 42 | false, |
38 | false, | 43 | false, |
39 | false | 44 | false, |
45 | true | ||
40 | ] | 46 | ] |
41 | }, | 47 | }, |
42 | "hash": "f179f38584f97842cd41159dd2293fa19e5f1975ea8810526924e77683ba92c4" | 48 | "hash": "1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6" |
43 | } | 49 | } |
diff --git a/.sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json b/.sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json new file mode 100644 index 0000000..71438e3 --- /dev/null +++ b/.sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json | |||
@@ -0,0 +1,15 @@ | |||
1 | { | ||
2 | "db_name": "PostgreSQL", | ||
3 | "query": "\n UPDATE devices\n SET times = array_append(times, $1)\n WHERE id = $2;\n ", | ||
4 | "describe": { | ||
5 | "columns": [], | ||
6 | "parameters": { | ||
7 | "Left": [ | ||
8 | "Int8", | ||
9 | "Text" | ||
10 | ] | ||
11 | }, | ||
12 | "nullable": [] | ||
13 | }, | ||
14 | "hash": "25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a" | ||
15 | } | ||
diff --git a/.sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json b/.sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json new file mode 100644 index 0000000..c385101 --- /dev/null +++ b/.sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json | |||
@@ -0,0 +1,20 @@ | |||
1 | { | ||
2 | "db_name": "PostgreSQL", | ||
3 | "query": "SELECT times FROM devices;", | ||
4 | "describe": { | ||
5 | "columns": [ | ||
6 | { | ||
7 | "ordinal": 0, | ||
8 | "name": "times", | ||
9 | "type_info": "Int8Array" | ||
10 | } | ||
11 | ], | ||
12 | "parameters": { | ||
13 | "Left": [] | ||
14 | }, | ||
15 | "nullable": [ | ||
16 | true | ||
17 | ] | ||
18 | }, | ||
19 | "hash": "5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948" | ||
20 | } | ||
diff --git a/.sqlx/query-82c11b5a47389884e4ed945b87dfcee9067933c4df892609700c0766c20fc5c5.json b/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json index c0a933d..5ec47e3 100644 --- a/.sqlx/query-82c11b5a47389884e4ed945b87dfcee9067933c4df892609700c0766c20fc5c5.json +++ b/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json | |||
@@ -1,6 +1,6 @@ | |||
1 | { | 1 | { |
2 | "db_name": "PostgreSQL", | 2 | "db_name": "PostgreSQL", |
3 | "query": "\n SELECT id, mac, broadcast_addr, ip\n FROM devices\n WHERE id = $1;\n ", | 3 | "query": "\n SELECT id, mac, broadcast_addr, ip, times\n FROM devices\n WHERE id = $1;\n ", |
4 | "describe": { | 4 | "describe": { |
5 | "columns": [ | 5 | "columns": [ |
6 | { | 6 | { |
@@ -22,6 +22,11 @@ | |||
22 | "ordinal": 3, | 22 | "ordinal": 3, |
23 | "name": "ip", | 23 | "name": "ip", |
24 | "type_info": "Varchar" | 24 | "type_info": "Varchar" |
25 | }, | ||
26 | { | ||
27 | "ordinal": 4, | ||
28 | "name": "times", | ||
29 | "type_info": "Int8Array" | ||
25 | } | 30 | } |
26 | ], | 31 | ], |
27 | "parameters": { | 32 | "parameters": { |
@@ -33,8 +38,9 @@ | |||
33 | false, | 38 | false, |
34 | false, | 39 | false, |
35 | false, | 40 | false, |
36 | false | 41 | false, |
42 | true | ||
37 | ] | 43 | ] |
38 | }, | 44 | }, |
39 | "hash": "82c11b5a47389884e4ed945b87dfcee9067933c4df892609700c0766c20fc5c5" | 45 | "hash": "62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744" |
40 | } | 46 | } |