Merlijn van Deen has uploaded a new change for review.
https://gerrit.wikimedia.org/r/185644
Change subject: hacky script to dump mysql subscriptions to redis
......................................................................
hacky script to dump mysql subscriptions to redis
Change-Id: I263ae651fb52fdc26e850f9ac29cb487f2ce4c58
---
A src/clients_from_mysql.py
1 file changed, 21 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/labs/tools/gerrit-to-redis
refs/changes/44/185644/1
diff --git a/src/clients_from_mysql.py b/src/clients_from_mysql.py
new file mode 100644
index 0000000..123c375
--- /dev/null
+++ b/src/clients_from_mysql.py
@@ -0,0 +1,21 @@
+# script to dump subscriptions from mysql back to redis
+# (c) 2015 Merlijn van Deen
+# MIT licensed
+
+import MySQLdb
+
+import registrar
+s = registrar.Service('gerrit')
+clients_key = s._make_key(s.service['clients_key'])
+cur = s.db.conn.cursor(MySQLdb.cursors.DictCursor)
+cur.execute('select * from subscriptions')
+subs = cur.fetchall()
+
+pipeline = s.redis.pipeline()
+
+for sub in subs:
+ print('Adding {service} (key={queue_key})'.format(**sub))
+ pipeline.sadd(clients_key, sub['queue_key'])
+
+pipeline.save().execute()
+
--
To view, visit https://gerrit.wikimedia.org/r/185644
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I263ae651fb52fdc26e850f9ac29cb487f2ce4c58
Gerrit-PatchSet: 1
Gerrit-Project: labs/tools/gerrit-to-redis
Gerrit-Branch: master
Gerrit-Owner: Merlijn van Deen <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
