Merge lp:~danilo/launchpad/bug-125225 into lp:launchpad/db-devel

[Данило Шеган]

Provide and use a separate DB user for copy-translations-from-parent script.

= Bug 125225 =

Provide and use a separate DB user for copy-translations-from-parent script: use the same permissions it used to use already by "inheriting" poimport permissions.

= Tests =

bin/test -vvct distroseries-translations-copy

= Demo & QA =

On your local installation try ./scripts/copy-translations-from-parent.py -d ubuntu -s breezy-autotest -vvv -f

Similar for testing on staging, though we'll probably need to create a new distroseries that has parent_series set to one of existing Ubuntu distroseries.

[Eleanor Berger (intellectronica)]

review: Approve

=== modified file 'database/schema/security.cfg'
--- database/schema/security.cfg	2010-05-03 06:59:06 +0000
+++ database/schema/security.cfg	2010-05-10 11:32:33 +0000
@@ -427,6 +427,10 @@
 public.validpersoncache                 = SELECT
 public.validpersonorteamcache           = SELECT
 
+[translations_distroseries_copy]
+type=user
+groups=poimport
+
 [translations_import_queue_gardener]
 # Translations import queue management
 type=user
 
=== modified file 'scripts/copy-translations-from-parent.py'
--- scripts/copy-translations-from-parent.py	2010-04-22 17:30:35 +0000
+++ scripts/copy-translations-from-parent.py	2010-05-10 11:32:33 +0000
@@ -98,7 +98,7 @@
 if __name__ == '__main__':
 
     script = TranslationsCopier(
-        'copy-missing-translations', dbuser=config.poimport.dbuser)
+        'copy-missing-translations', dbuser='translations_distroseries_copy')
 
     script.lock_and_run()