diff options
author | FxQnLr <[email protected]> | 2024-03-05 13:16:18 +0100 |
---|---|---|
committer | GitHub <[email protected]> | 2024-03-05 13:16:18 +0100 |
commit | 8dca7e83519b6c3531653cdedf60b2a14e1035b7 (patch) | |
tree | 0180a452dd354b067470618e6dbdc330649287cb /.sqlx | |
parent | f0dc13f907a72ffef44f89b5e197567db129b020 (diff) | |
parent | 85c63c2ca8448428e2db93cb9d4f284a4e314ed7 (diff) | |
download | webol-8dca7e83519b6c3531653cdedf60b2a14e1035b7.tar webol-8dca7e83519b6c3531653cdedf60b2a14e1035b7.tar.gz webol-8dca7e83519b6c3531653cdedf60b2a14e1035b7.zip |
Merge pull request #22 from FxQnLr/0.3.3
0.3.3
Diffstat (limited to '.sqlx')
-rw-r--r-- | .sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json | 49 | ||||
-rw-r--r-- | .sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.json | 15 |
2 files changed, 64 insertions, 0 deletions
diff --git a/.sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json b/.sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json new file mode 100644 index 0000000..735c3bb --- /dev/null +++ b/.sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json | |||
@@ -0,0 +1,49 @@ | |||
1 | { | ||
2 | "db_name": "PostgreSQL", | ||
3 | "query": "\n INSERT INTO devices (id, mac, broadcast_addr, ip)\n VALUES ($1, $2, $3, $4)\n RETURNING id, mac, broadcast_addr, ip, times;\n ", | ||
4 | "describe": { | ||
5 | "columns": [ | ||
6 | { | ||
7 | "ordinal": 0, | ||
8 | "name": "id", | ||
9 | "type_info": "Varchar" | ||
10 | }, | ||
11 | { | ||
12 | "ordinal": 1, | ||
13 | "name": "mac", | ||
14 | "type_info": "Macaddr" | ||
15 | }, | ||
16 | { | ||
17 | "ordinal": 2, | ||
18 | "name": "broadcast_addr", | ||
19 | "type_info": "Varchar" | ||
20 | }, | ||
21 | { | ||
22 | "ordinal": 3, | ||
23 | "name": "ip", | ||
24 | "type_info": "Inet" | ||
25 | }, | ||
26 | { | ||
27 | "ordinal": 4, | ||
28 | "name": "times", | ||
29 | "type_info": "Int8Array" | ||
30 | } | ||
31 | ], | ||
32 | "parameters": { | ||
33 | "Left": [ | ||
34 | "Varchar", | ||
35 | "Macaddr", | ||
36 | "Varchar", | ||
37 | "Inet" | ||
38 | ] | ||
39 | }, | ||
40 | "nullable": [ | ||
41 | false, | ||
42 | false, | ||
43 | false, | ||
44 | false, | ||
45 | true | ||
46 | ] | ||
47 | }, | ||
48 | "hash": "566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8" | ||
49 | } | ||
diff --git a/.sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.json b/.sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.json new file mode 100644 index 0000000..e448b24 --- /dev/null +++ b/.sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.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": "df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185" | ||
15 | } | ||