On Thu, 23 Aug 2018, Alexander Wirt wrote: > > A simple SQL update query would save us a lot of time. Thank you for > > considering it. > Sure, do you have the query? And please ensure not to affect bots > running on other networks.
I don't have any gitlab instance where to make test so this is untested and based on some output provided by Pierre-Elliot Bécue. But I believe that this should do the trick. UPDATE services SET properties = REPLACE(properties, 'irc://irc.oftc.net:6697', 'ircs://irc.oftc.net:6697') WHERE properties LIKE '%ruprecht.snow-crash.org%' and type = 'IrkerService'; Run it in a transaction and check the result on some sample entries before and after the update command and commit if you are happy. properties seems to be JSON data in a text field and it contains the IRC URI multiple times. Cheers, -- Raphaël Hertzog ◈ Debian Developer Support Debian LTS: https://www.freexian.com/services/debian-lts.html Learn to master Debian: https://debian-handbook.info/get/
signature.asc
Description: PGP signature