diff options
Diffstat (limited to '.sqlx')
-rw-r--r-- | .sqlx/query-3ed66b56b7e78a6b6bad9d49c49607520a8d09f902b996467dddf58737a3757f.json | 16 | ||||
-rw-r--r-- | .sqlx/query-6a81887a8b44b527ad04c8963d5186b764ec9125d597f9fba566e280bd09d352.json | 36 | ||||
-rw-r--r-- | .sqlx/query-bb9c6a42084b92c339a85f9b1c094959a49c6b7383f1a0b49df242e2720a9185.json (renamed from .sqlx/query-035eea2a3ffbc6fcf5e1646f4e13e879b6e13325e38cd10d5ee160c5aded2caf.json) | 16 |
3 files changed, 61 insertions, 7 deletions
diff --git a/.sqlx/query-3ed66b56b7e78a6b6bad9d49c49607520a8d09f902b996467dddf58737a3757f.json b/.sqlx/query-3ed66b56b7e78a6b6bad9d49c49607520a8d09f902b996467dddf58737a3757f.json new file mode 100644 index 0000000..feedac8 --- /dev/null +++ b/.sqlx/query-3ed66b56b7e78a6b6bad9d49c49607520a8d09f902b996467dddf58737a3757f.json | |||
@@ -0,0 +1,16 @@ | |||
1 | { | ||
2 | "db_name": "PostgreSQL", | ||
3 | "query": "\n INSERT INTO devices (id, mac, broadcast_addr)\n VALUES ($1, $2, $3);\n ", | ||
4 | "describe": { | ||
5 | "columns": [], | ||
6 | "parameters": { | ||
7 | "Left": [ | ||
8 | "Text", | ||
9 | "Text", | ||
10 | "Text" | ||
11 | ] | ||
12 | }, | ||
13 | "nullable": [] | ||
14 | }, | ||
15 | "hash": "3ed66b56b7e78a6b6bad9d49c49607520a8d09f902b996467dddf58737a3757f" | ||
16 | } | ||
diff --git a/.sqlx/query-6a81887a8b44b527ad04c8963d5186b764ec9125d597f9fba566e280bd09d352.json b/.sqlx/query-6a81887a8b44b527ad04c8963d5186b764ec9125d597f9fba566e280bd09d352.json new file mode 100644 index 0000000..89f6bbe --- /dev/null +++ b/.sqlx/query-6a81887a8b44b527ad04c8963d5186b764ec9125d597f9fba566e280bd09d352.json | |||
@@ -0,0 +1,36 @@ | |||
1 | { | ||
2 | "db_name": "PostgreSQL", | ||
3 | "query": "\n UPDATE devices\n SET mac = $1, broadcast_addr = $2 WHERE id = $3\n RETURNING id, mac, broadcast_addr;\n ", | ||
4 | "describe": { | ||
5 | "columns": [ | ||
6 | { | ||
7 | "ordinal": 0, | ||
8 | "name": "id", | ||
9 | "type_info": "Text" | ||
10 | }, | ||
11 | { | ||
12 | "ordinal": 1, | ||
13 | "name": "mac", | ||
14 | "type_info": "Text" | ||
15 | }, | ||
16 | { | ||
17 | "ordinal": 2, | ||
18 | "name": "broadcast_addr", | ||
19 | "type_info": "Text" | ||
20 | } | ||
21 | ], | ||
22 | "parameters": { | ||
23 | "Left": [ | ||
24 | "Text", | ||
25 | "Text", | ||
26 | "Text" | ||
27 | ] | ||
28 | }, | ||
29 | "nullable": [ | ||
30 | false, | ||
31 | false, | ||
32 | false | ||
33 | ] | ||
34 | }, | ||
35 | "hash": "6a81887a8b44b527ad04c8963d5186b764ec9125d597f9fba566e280bd09d352" | ||
36 | } | ||
diff --git a/.sqlx/query-035eea2a3ffbc6fcf5e1646f4e13e879b6e13325e38cd10d5ee160c5aded2caf.json b/.sqlx/query-bb9c6a42084b92c339a85f9b1c094959a49c6b7383f1a0b49df242e2720a9185.json index b1e99f6..efd2830 100644 --- a/.sqlx/query-035eea2a3ffbc6fcf5e1646f4e13e879b6e13325e38cd10d5ee160c5aded2caf.json +++ b/.sqlx/query-bb9c6a42084b92c339a85f9b1c094959a49c6b7383f1a0b49df242e2720a9185.json | |||
@@ -1,26 +1,28 @@ | |||
1 | { | 1 | { |
2 | "db_name": "SQLite", | 2 | "db_name": "PostgreSQL", |
3 | "query": "\n SELECT id, mac, broadcast_addr\n FROM devices\n WHERE id = ?1;\n ", | 3 | "query": "\n SELECT id, mac, broadcast_addr\n FROM devices\n WHERE id = $1;\n ", |
4 | "describe": { | 4 | "describe": { |
5 | "columns": [ | 5 | "columns": [ |
6 | { | 6 | { |
7 | "name": "id", | ||
8 | "ordinal": 0, | 7 | "ordinal": 0, |
8 | "name": "id", | ||
9 | "type_info": "Text" | 9 | "type_info": "Text" |
10 | }, | 10 | }, |
11 | { | 11 | { |
12 | "name": "mac", | ||
13 | "ordinal": 1, | 12 | "ordinal": 1, |
13 | "name": "mac", | ||
14 | "type_info": "Text" | 14 | "type_info": "Text" |
15 | }, | 15 | }, |
16 | { | 16 | { |
17 | "name": "broadcast_addr", | ||
18 | "ordinal": 2, | 17 | "ordinal": 2, |
18 | "name": "broadcast_addr", | ||
19 | "type_info": "Text" | 19 | "type_info": "Text" |
20 | } | 20 | } |
21 | ], | 21 | ], |
22 | "parameters": { | 22 | "parameters": { |
23 | "Right": 1 | 23 | "Left": [ |
24 | "Text" | ||
25 | ] | ||
24 | }, | 26 | }, |
25 | "nullable": [ | 27 | "nullable": [ |
26 | false, | 28 | false, |
@@ -28,5 +30,5 @@ | |||
28 | false | 30 | false |
29 | ] | 31 | ] |
30 | }, | 32 | }, |
31 | "hash": "035eea2a3ffbc6fcf5e1646f4e13e879b6e13325e38cd10d5ee160c5aded2caf" | 33 | "hash": "bb9c6a42084b92c339a85f9b1c094959a49c6b7383f1a0b49df242e2720a9185" |
32 | } | 34 | } |