[2/8] git commit: [#5289] provide migration script for existing trove category data

[br...@apache.org]

[#5289] provide migration script for existing trove category data


Project: http://git-wip-us.apache.org/repos/asf/incubator-allura/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-allura/commit/f88d2936
Tree: http://git-wip-us.apache.org/repos/asf/incubator-allura/tree/f88d2936
Diff: http://git-wip-us.apache.org/repos/asf/incubator-allura/diff/f88d2936

Branch: refs/heads/db/5289
Commit: f88d2936933181f6f74f9a33e04bb00acdd06e77
Parents: dc391b6
Author: Dave Brondsema <db...@geek.net>
Authored: Mon Dec 3 22:04:55 2012 +0000
Committer: Dave Brondsema <db...@geek.net>
Committed: Mon Dec 3 22:06:20 2012 +0000

----------------------------------------------------------------------
 scripts/migrations/030-set-trove-show_as_skill.py |   21 ++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-allura/blob/f88d2936/scripts/migrations/030-set-trove-show_as_skill.py
----------------------------------------------------------------------
diff --git a/scripts/migrations/030-set-trove-show_as_skill.py b/scripts/migrations/030-set-trove-show_as_skill.py
new file mode 100644
index 0000000..b95e99a
--- /dev/null
+++ b/scripts/migrations/030-set-trove-show_as_skill.py
@@ -0,0 +1,21 @@
+import re
+
+from allura import model as M
+
+
+def main():
+    categories_regex = '|'.join([
+        'Translations',
+        'Programming Language',
+        'User Interface',
+        'Database Environment',
+        'Operating System',
+        'Topic',
+    ])
+    M.TroveCategory.query.update(
+        {'fullname': re.compile(r'^(%s)' % categories_regex)},
+        {'$set': {'show_as_skill': True}},
+        multi=True)
+
+if __name__ == '__main__':
+    main()