From 3428a637ce420baef9aa9f9803e71bd587867005 Mon Sep 17 00:00:00 2001 From: FxQnLr Date: Wed, 10 Apr 2024 00:16:55 +0200 Subject: Closes #24. Changed postgres to json directory storage --- ...f32262fd643b452aacca373ee527c978e816115de6.json | 49 ---------------------- ...ce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json | 15 ------- ...ce2248cb3a734074014a493a7aad6fa03bb1286dc8.json | 49 ---------------------- ...c09e37b14c828c4ee44b696d83f87f739022be6948.json | 20 --------- ...f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json | 46 -------------------- ...1cbd787a2f2a30efc581ea075b7e86ae75458c9014.json | 46 -------------------- ...b8cf06394a302d288e91f5eedde65db6630021f737.json | 17 -------- ...248493f4458a532eee554d57438ef7849758238185.json | 15 ------- ...86cffd2b4739d88b3061931562e07c3e8dd24e6359.json | 49 ---------------------- ...1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json | 17 -------- 10 files changed, 323 deletions(-) delete mode 100644 .sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json delete mode 100644 .sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json delete mode 100644 .sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json delete mode 100644 .sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json delete mode 100644 .sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json delete mode 100644 .sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json delete mode 100644 .sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json delete mode 100644 .sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.json delete mode 100644 .sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json delete mode 100644 .sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json (limited to '.sqlx') diff --git a/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json b/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json deleted file mode 100644 index dd85eaa..0000000 --- a/.sqlx/query-1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6.json +++ /dev/null @@ -1,49 +0,0 @@ -{ - "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": "1dc5f44967ffdee882f4cef32262fd643b452aacca373ee527c978e816115de6" -} diff --git a/.sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json b/.sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json deleted file mode 100644 index 71438e3..0000000 --- a/.sqlx/query-25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a.json +++ /dev/null @@ -1,15 +0,0 @@ -{ - "db_name": "PostgreSQL", - "query": "\n UPDATE devices\n SET times = array_append(times, $1)\n WHERE id = $2;\n ", - "describe": { - "columns": [], - "parameters": { - "Left": [ - "Int8", - "Text" - ] - }, - "nullable": [] - }, - "hash": "25ab5caa92ff80ef3f85ddce1174021ce0fb896a818a6deee291a1eb85ae2a8a" -} diff --git a/.sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json b/.sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json deleted file mode 100644 index 735c3bb..0000000 --- a/.sqlx/query-566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8.json +++ /dev/null @@ -1,49 +0,0 @@ -{ - "db_name": "PostgreSQL", - "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 ", - "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": [ - "Varchar", - "Macaddr", - "Varchar", - "Inet" - ] - }, - "nullable": [ - false, - false, - false, - false, - true - ] - }, - "hash": "566c84386614590144dfebce2248cb3a734074014a493a7aad6fa03bb1286dc8" -} diff --git a/.sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json b/.sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json deleted file mode 100644 index c385101..0000000 --- a/.sqlx/query-5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948.json +++ /dev/null @@ -1,20 +0,0 @@ -{ - "db_name": "PostgreSQL", - "query": "SELECT times FROM devices;", - "describe": { - "columns": [ - { - "ordinal": 0, - "name": "times", - "type_info": "Int8Array" - } - ], - "parameters": { - "Left": [] - }, - "nullable": [ - true - ] - }, - "hash": "5ac2b9a76338dd1342938cc09e37b14c828c4ee44b696d83f87f739022be6948" -} diff --git a/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json b/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json deleted file mode 100644 index 905bb51..0000000 --- a/.sqlx/query-62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744.json +++ /dev/null @@ -1,46 +0,0 @@ -{ - "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": "62c84231c7e9c85dc91d71f6b4f7ee6dae2130c2109fb6f1e47e0990ec395744" -} diff --git a/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json b/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json deleted file mode 100644 index 53608ed..0000000 --- a/.sqlx/query-a1114f47abaa2ace231ef61cbd787a2f2a30efc581ea075b7e86ae75458c9014.json +++ /dev/null @@ -1,46 +0,0 @@ -{ - "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 deleted file mode 100644 index d25b12e..0000000 --- a/.sqlx/query-adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737.json +++ /dev/null @@ -1,17 +0,0 @@ -{ - "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": "adead45e1a6b02d5eabd68b8cf06394a302d288e91f5eedde65db6630021f737" -} diff --git a/.sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.json b/.sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.json deleted file mode 100644 index e448b24..0000000 --- a/.sqlx/query-df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185.json +++ /dev/null @@ -1,15 +0,0 @@ -{ - "db_name": "PostgreSQL", - "query": "\n UPDATE devices\n SET times = array_append(times, $1)\n WHERE id = $2;\n ", - "describe": { - "columns": [], - "parameters": { - "Left": [ - "Int8", - "Text" - ] - }, - "nullable": [] - }, - "hash": "df462bb016e2d258de146e248493f4458a532eee554d57438ef7849758238185" -} diff --git a/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json b/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json deleted file mode 100644 index 75ec121..0000000 --- a/.sqlx/query-e452c5ed8bdaec2011d78386cffd2b4739d88b3061931562e07c3e8dd24e6359.json +++ /dev/null @@ -1,49 +0,0 @@ -{ - "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 deleted file mode 100644 index 2b17c9b..0000000 --- a/.sqlx/query-edc4ecf39512caec1076be1b2849b2530be7bcdcbe14362077b3fd47cd711c89.json +++ /dev/null @@ -1,17 +0,0 @@ -{ - "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" -} -- cgit v1.2.3