[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: salsa irker bot moved to ssl

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.

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/

Attachment: signature.asc
Description: PGP signature

Reply to: