git.cweiske.de
/
paste
/
664.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
61aaf09
)
(no commit message)
master
author
Christian Weiske
<cweiske@cweiske.de>
Wed, 5 Feb 2020 15:08:41 +0000
(16:08 +0100)
committer
www-cweiske
<www-cweiske@ahso3>
Wed, 5 Feb 2020 15:08:41 +0000
(16:08 +0100)
1-add.sql
patch
|
blob
|
history
diff --git
a/1-add.sql
b/1-add.sql
index 126b4cc281b1ce08c81d11dc8ef68161c590ba1e..f1c502b0bc9d0cd6c9478363fbacf57dc58363c8 100644
(file)
--- a/
1-add.sql
+++ b/
1-add.sql
@@
-1,3
+1,4
@@
+-- make "external" an JSON object if null
\r
UPDATE node_data
\r
JOIN nodes ON nodes.id = node_data.node_id
\r
SET external = "{}"
\r
UPDATE node_data
\r
JOIN nodes ON nodes.id = node_data.node_id
\r
SET external = "{}"
\r
@@
-5,6
+6,7
@@
WHERE
node_data.external IS NULL
\r
AND nodes.available_for_rent = 1;
\r
\r
node_data.external IS NULL
\r
AND nodes.available_for_rent = 1;
\r
\r
+-- add "export_portals" array to "external" if it does not exist
\r
UPDATE node_data
\r
JOIN nodes ON nodes.id = node_data.node_id
\r
SET external = JSON_SET(external, '$.export_portals', JSON_ARRAY())
\r
UPDATE node_data
\r
JOIN nodes ON nodes.id = node_data.node_id
\r
SET external = JSON_SET(external, '$.export_portals', JSON_ARRAY())
\r
@@
-12,6
+14,7
@@
WHERE
NOT JSON_CONTAINS_PATH(external, 'all', '$.export_portals')
\r
AND nodes.available_for_rent = 1;
\r
\r
NOT JSON_CONTAINS_PATH(external, 'all', '$.export_portals')
\r
AND nodes.available_for_rent = 1;
\r
\r
+-- add "hpm-api" value to external.export_portals
\r
UPDATE node_data
\r
JOIN nodes ON nodes.id = node_data.node_id
\r
SET external = JSON_ARRAY_APPEND(external, '$.export_portals', 'hpm-api')
\r
UPDATE node_data
\r
JOIN nodes ON nodes.id = node_data.node_id
\r
SET external = JSON_ARRAY_APPEND(external, '$.export_portals', 'hpm-api')
\r