Merge pull request #17 from FxQnLr/0.3.2

0.3.2
author: FxQnLr <[email protected]> 2024-02-25 15:53:04 +0100
committer: GitHub <[email protected]> 2024-02-25 15:53:04 +0100
commit: f0dc13f907a72ffef44f89b5e197567db129b020 (patch)
tree: d560273df2eece276cbda021cb4e95c044bb19df /.sqlx
parent: c663810817183c8f92a4279236ca84d271365088 (diff)
parent: 91cd665671d564620bce13e693cd7ecaad697db9 (diff)
download: webol-f0dc13f907a72ffef44f89b5e197567db129b020.tar
webol-f0dc13f907a72ffef44f89b5e197567db129b020.tar.gz
webol-f0dc13f907a72ffef44f89b5e197567db129b020.zip
6 files changed, 120 insertions, 8 deletions
diff --git a/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json b/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json
index 33d524d..dd85eaa 100644
--- a/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json
+++ b/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json
@@ -11,7 +11,7 @@
      {
        "ordinal": 1,
        "name": "mac",
-        "type_info": "Varchar"
+        "type_info": "Macaddr"
      },
      {
        "ordinal": 2,
@@ -21,7 +21,7 @@
      {
        "ordinal": 3,
        "name": "ip",
-        "type_info": "Varchar"
+        "type_info": "Inet"
      },
      {
        "ordinal": 4,
@@ -31,9 +31,9 @@
    ],
    "parameters": {
      "Left": [
+        "Macaddr",
        "Varchar",
-        "Varchar",
+        "Inet",
-        "Varchar",
        "Text"
      ]
    },
diff --git a/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json b/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json
index 5ec47e3..905bb51 100644
--- a/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json
+++ b/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json
@@ -11,7 +11,7 @@
      {
        "ordinal": 1,
        "name": "mac",
-        "type_info": "Varchar"
+        "type_info": "Macaddr"
      },
      {
        "ordinal": 2,
@@ -21,7 +21,7 @@
      {
        "ordinal": 3,
        "name": "ip",
-        "type_info": "Varchar"
+        "type_info": "Inet"
      },
      {
        "ordinal": 4,
diff --git a/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json b/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json
new file mode 100644
index 0000000..53608ed
--- /dev/null
+++ b/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json
@@ -0,0 +1,46 @@
+{
+  "db_name": "PostgreSQL",
+  "query": "\n        SELECT id, mac, broadcast_addr, ip, times\n        FROM devices\n        WHERE id = $1;\n        ",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "id",
+        "type_info": "Varchar"
+      },
+      {
+        "ordinal": 1,
+        "name": "mac",
+        "type_info": "Macaddr"
+      },
+      {
+        "ordinal": 2,
+        "name": "broadcast_addr",
+        "type_info": "Varchar"
+      },
+      {
+        "ordinal": 3,
+        "name": "ip",
+        "type_info": "Inet"
+      },
+      {
+        "ordinal": 4,
+        "name": "times",
+        "type_info": "Int8Array"
+      }
+    ],
+    "parameters": {
+      "Left": [
+        "Text"
+      ]
+    },
+    "nullable": [
+      false,
+      false,
+      false,
+      false,
+      true
+    ]
+  },
+  "hash": "a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014"
+}
diff --git a/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json b/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json
index bc4bdd3..d25b12e 100644
--- a/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json
+++ b/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json
@@ -6,9 +6,9 @@
    "parameters": {
      "Left": [
        "Varchar",
+        "Macaddr",
        "Varchar",
-        "Varchar",
+        "Inet"
-        "Varchar"
      ]
    },
    "nullable": []
diff --git a/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json b/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json
new file mode 100644
index 0000000..75ec121
--- /dev/null
+++ b/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json
@@ -0,0 +1,49 @@
+{
+  "db_name": "PostgreSQL",
+  "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        ",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "id",
+        "type_info": "Varchar"
+      },
+      {
+        "ordinal": 1,
+        "name": "mac",
+        "type_info": "Macaddr"
+      },
+      {
+        "ordinal": 2,
+        "name": "broadcast_addr",
+        "type_info": "Varchar"
+      },
+      {
+        "ordinal": 3,
+        "name": "ip",
+        "type_info": "Inet"
+      },
+      {
+        "ordinal": 4,
+        "name": "times",
+        "type_info": "Int8Array"
+      }
+    ],
+    "parameters": {
+      "Left": [
+        "Macaddr",
+        "Varchar",
+        "Inet",
+        "Text"
+      ]
+    },
+    "nullable": [
+      false,
+      false,
+      false,
+      false,
+      true
+    ]
+  },
+  "hash": "e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359"
+}
diff --git a/.sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json b/.sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json
new file mode 100644
index 0000000..2b17c9b
--- /dev/null
+++ b/.sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json
@@ -0,0 +1,17 @@
+{
+  "db_name": "PostgreSQL",
+  "query": "\n        INSERT INTO devices (id, mac, broadcast_addr, ip)\n        VALUES ($1, $2, $3, $4);\n        ",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Left": [
+        "Varchar",
+        "Macaddr",
+        "Varchar",
+        "Inet"
+      ]
+    },
+    "nullable": []
+  },
+  "hash": "edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89"
+}
author	FxQnLr <[email protected]>	2024-02-25 15:53:04 +0100
committer	GitHub <[email protected]>	2024-02-25 15:53:04 +0100
commit	f0dc13f907a72ffef44f89b5e197567db129b020 (patch)
tree	d560273df2eece276cbda021cb4e95c044bb19df /.sqlx
parent	c663810817183c8f92a4279236ca84d271365088 (diff)
parent	91cd665671d564620bce13e693cd7ecaad697db9 (diff)
download	webol-f0dc13f907a72ffef44f89b5e197567db129b020.tar webol-f0dc13f907a72ffef44f89b5e197567db129b020.tar.gz webol-f0dc13f907a72ffef44f89b5e197567db129b020.zip

diff --git a/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json b/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json index 33d524d..dd85eaa 100644 --- a/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json +++ b/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json
@@ -11,7 +11,7 @@
11	{	11	{
12	"ordinal": 1,	12	"ordinal": 1,
13	"name": "mac",	13	"name": "mac",
14	"type_info": "Varchar"	14	"type_info": "Macaddr"
15	},	15	},
16	{	16	{
17	"ordinal": 2,	17	"ordinal": 2,
@@ -21,7 +21,7 @@
21	{	21	{
22	"ordinal": 3,	22	"ordinal": 3,
23	"name": "ip",	23	"name": "ip",
24	"type_info": "Varchar"	24	"type_info": "Inet"
25	},	25	},
26	{	26	{
27	"ordinal": 4,	27	"ordinal": 4,
@@ -31,9 +31,9 @@
31	],	31	],
32	"parameters": {	32	"parameters": {
33	"Left": [	33	"Left": [
		34	"Macaddr",
34	"Varchar",	35	"Varchar",
35	"Varchar",	36	"Inet",
36	"Varchar",
37	"Text"	37	"Text"
38	]	38	]
39	},	39	},


diff --git a/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json b/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json index 5ec47e3..905bb51 100644 --- a/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json +++ b/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json
@@ -11,7 +11,7 @@
11	{	11	{
12	"ordinal": 1,	12	"ordinal": 1,
13	"name": "mac",	13	"name": "mac",
14	"type_info": "Varchar"	14	"type_info": "Macaddr"
15	},	15	},
16	{	16	{
17	"ordinal": 2,	17	"ordinal": 2,
@@ -21,7 +21,7 @@
21	{	21	{
22	"ordinal": 3,	22	"ordinal": 3,
23	"name": "ip",	23	"name": "ip",
24	"type_info": "Varchar"	24	"type_info": "Inet"
25	},	25	},
26	{	26	{
27	"ordinal": 4,	27	"ordinal": 4,


diff --git a/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json b/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json new file mode 100644 index 0000000..53608ed --- /dev/null +++ b/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json
@@ -0,0 +1,46 @@
		1	{
		2	"db_name": "PostgreSQL",
		3	"query": "\n SELECT id, mac, broadcast_addr, ip, times\n FROM devices\n WHERE id = $1;\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	"Text"
		35	]
		36	},
		37	"nullable": [
		38	false,
		39	false,
		40	false,
		41	false,
		42	true
		43	]
		44	},
		45	"hash": "a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014"
		46	}


diff --git a/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json b/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json index bc4bdd3..d25b12e 100644 --- a/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json +++ b/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json
@@ -6,9 +6,9 @@
6	"parameters": {	6	"parameters": {
7	"Left": [	7	"Left": [
8	"Varchar",	8	"Varchar",
		9	"Macaddr",
9	"Varchar",	10	"Varchar",
10	"Varchar",	11	"Inet"
11	"Varchar"
12	]	12	]
13	},	13	},
14	"nullable": []	14	"nullable": []


diff --git a/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json b/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json new file mode 100644 index 0000000..75ec121 --- /dev/null +++ b/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json
@@ -0,0 +1,49 @@
		1	{
		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, 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	"Macaddr",
		35	"Varchar",
		36	"Inet",
		37	"Text"
		38	]
		39	},
		40	"nullable": [
		41	false,
		42	false,
		43	false,
		44	false,
		45	true
		46	]
		47	},
		48	"hash": "e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359"
		49	}


diff --git a/.sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json b/.sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json new file mode 100644 index 0000000..2b17c9b --- /dev/null +++ b/.sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json
@@ -0,0 +1,17 @@
		1	{
		2	"db_name": "PostgreSQL",
		3	"query": "\n INSERT INTO devices (id, mac, broadcast_addr, ip)\n VALUES ($1, $2, $3, $4);\n ",
		4	"describe": {
		5	"columns": [],
		6	"parameters": {
		7	"Left": [
		8	"Varchar",
		9	"Macaddr",
		10	"Varchar",
		11	"Inet"
		12	]
		13	},
		14	"nullable": []
		15	},
		16	"hash": "edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89"
		17	}