launchpad-reviewers team mailing list archive

[Gavin Panella <gavin.panella@xxxxxxxxxxxxx>]

Gavin Panella has proposed merging lp:~allenap/launchpad/wipe-precise-translations into lp:launchpad.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~allenap/launchpad/wipe-precise-translations/+merge/82422

Script to wipe Precise's translations in production so that we can reattempt the opening (see https://wiki.canonical.com/Launchpad/Translations/UbuntuOpenings).

This will just be run once and not landed.

-- 
https://code.launchpad.net/~allenap/launchpad/wipe-precise-translations/+merge/82422
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~allenap/launchpad/wipe-precise-translations into lp:launchpad.

=== added file 'wipeprecisetrans.py'
--- wipeprecisetrans.py	1970-01-01 00:00:00 +0000
+++ wipeprecisetrans.py	2011-11-16 16:19:25 +0000
@@ -0,0 +1,104 @@
+#!/usr/bin/python2.6 -S
+
+__metaclass__ = type
+
+import _pythonpath
+
+from zope.component import getUtility
+from zope.interface import implements
+
+from canonical.launchpad.interfaces.looptuner import ITunableLoop
+from canonical.launchpad.utilities.looptuner import DBLoopTuner
+from canonical.launchpad.webapp.interfaces import (
+    IStoreSelector,
+    MAIN_STORE,
+    MASTER_FLAVOR,
+    )
+from lp.services.scripts.base import LaunchpadScript
+
+
+select_precise = """\
+SELECT DistroSeries.id
+  FROM DistroSeries
+  JOIN Distribution ON
+           Distribution.id = DistroSeries.distribution
+ WHERE Distribution.name = 'ubuntu'
+   AND DistroSeries.name = 'precise'
+"""
+
+delete_pofiletranslator = """\
+DELETE FROM POFileTranslator
+ WHERE POFileTranslator.pofile IN (
+    SELECT POFile.id
+      FROM POFile, POTemplate
+     WHERE POFile.potemplate = POTemplate.id
+       AND POTemplate.distroseries = (%s)
+     LIMIT ?)
+""" % select_precise
+
+delete_pofile = """\
+DELETE FROM POFile
+ WHERE POFile.potemplate IN (
+    SELECT POTemplate.id
+      FROM POTemplate
+     WHERE POTemplate.distroseries = (%s)
+     LIMIT ?)
+""" % select_precise
+
+delete_translationtemplateitem = """\
+DELETE FROM TranslationTemplateItem
+ WHERE TranslationTemplateItem.potemplate IN (
+    SELECT POTemplate.id
+      FROM POTemplate
+     WHERE POTemplate.distroseries = (%s)
+     LIMIT ?)
+""" % select_precise
+
+delete_potemplate = """\
+DELETE FROM POTemplate
+ WHERE POTemplate.id IN (
+    SELECT POTemplate.id
+      FROM POTemplate
+     WHERE POTemplate.distroseries = (%s)
+     LIMIT ?)
+""" % select_precise
+
+statements = [
+    delete_pofiletranslator,
+    delete_pofile,
+    delete_translationtemplateitem,
+    delete_potemplate,
+    ]
+
+
+class ExecuteLoop:
+
+    implements(ITunableLoop)
+
+    def __init__(self, statement):
+        self.statement = statement
+        self.done = False
+
+    def isDone(self):
+        return self.done
+
+    def __call__(self, chunk_size):
+        store = getUtility(IStoreSelector).get(MAIN_STORE, MASTER_FLAVOR)
+        result = store.execute(self.statement, (chunk_size,))
+        self.done = (result.rowcount == 0)
+        store.commit()
+
+
+class WipePreciseTranslationsScript(LaunchpadScript):
+
+    description = "Wipe Ubuntu Precise's translations."
+
+    def main(self):
+        for statement in statements:
+            delete = ExecuteLoop(statement)
+            tuner = DBLoopTuner(delete, 2.0, maximum_chunk_size=5000)
+            tuner.run()
+
+
+if __name__ == '__main__':
+    WipePreciseTranslationsScript(dbuser='rosettaadmin').run()