added spot
https://gitlab.e.foundation/e/infra/backlog/-/issues/4048
Also run these update query on staging
SELECT userid, configvalue FROM oc_preferences WHERE appid = 'murena_launcher' AND configkey = 'order' limit 10;
UPDATE oc_preferences
SET configvalue = JSON_REMOVE(
configvalue,
JSON_UNQUOTE(JSON_SEARCH(configvalue, 'one', 'https://spot.murena.io'))
)
WHERE appid = 'murena_launcher'
AND configkey = 'order'
AND JSON_TYPE(configvalue) = 'ARRAY'
AND JSON_SEARCH(configvalue, 'one', 'https://spot.murena.io') IS NOT NULL
;
// below query can be ignored and then need to add `AND configvalue NOT LIKE '%https://murena.qwant.com%'` on
2nd query
UPDATE oc_preferences
SET configvalue = JSON_REMOVE(
configvalue,
JSON_UNQUOTE(JSON_SEARCH(configvalue, 'one', 'https://murena.qwant.com'))
)
WHERE appid = 'murena_launcher'
AND configkey = 'order'
AND JSON_TYPE(configvalue) = 'ARRAY'
AND JSON_SEARCH(configvalue, 'one', 'https://murena.qwant.com') IS NOT NULL;
UPDATE oc_preferences
SET configvalue = JSON_ARRAY_INSERT(configvalue, '$[13]', 'https://murena.qwant.com')
WHERE appid = 'murena_launcher'
AND configkey = 'order'
AND JSON_TYPE(configvalue) = 'ARRAY'
AND JSON_SEARCH(configvalue, 'one', 'https://murena.qwant.com') IS NULL;
Edited by AVINASH GUSAIN