Donate to e Foundation | Murena handsets with /e/OS | Own a part of Murena! Learn more

Skip to content

added spot

AVINASH GUSAIN requested to merge dev/change-name-spot into main

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

Merge request reports

Loading