[#5289] provide migration script for existing trove category data
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()