| # Licensed to the Apache Software Foundation (ASF) under one |
| # or more contributor license agreements. See the NOTICE file |
| # distributed with this work for additional information |
| # regarding copyright ownership. The ASF licenses this file |
| # to you under the Apache License, Version 2.0 (the |
| # "License"); you may not use this file except in compliance |
| # with the License. You may obtain a copy of the License at |
| # |
| # http://www.apache.org/licenses/LICENSE-2.0 |
| # |
| # Unless required by applicable law or agreed to in writing, |
| # software distributed under the License is distributed on an |
| # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| # KIND, either express or implied. See the License for the |
| # specific language governing permissions and limitations |
| # under the License. |
| |
| import sys |
| import logging |
| import re |
| from itertools import groupby |
| |
| import pymongo |
| from ming.orm import ThreadLocalORMSession |
| |
| from allura import model as M |
| |
| log = logging.getLogger(__name__) |
| |
| # Given a list of subscriptions, try to find one with a proper artifact_url, and delete the rest |
| # If none of them have artifact_urls, delete them all |
| |
| |
| def trim_subs(subs, test): |
| prime = False |
| |
| print "Found %d '%s' subs with for user '%s'" % (len(subs), subs[0].artifact_title, str(subs[0].user_id)) |
| for sub in subs: |
| if sub.artifact_url and not prime: |
| prime = True |
| print " Keeping good subscription with a URL of '%s'" % sub.artifact_url |
| else: |
| if not sub.artifact_url: |
| print " Found subscription with no artifact URL, deleting." |
| else: |
| print " Subscription has URL, but is a duplicate, deleting." |
| if not test: |
| sub.delete() |
| |
| |
| def main(): |
| test = sys.argv[-1] == 'test' |
| title = re.compile('Ticket .*') |
| all_subscriptions = M.Mailbox.query.find(dict(artifact_title=title, type='direct')).sort( |
| [('artifact_title', pymongo.ASCENDING), ('user_id', pymongo.DESCENDING)]).all() |
| log.info('Fixing duplicate tracker subscriptions') |
| |
| for (key, group) in groupby( |
| all_subscriptions, |
| key=lambda sub: (sub.artifact_title, sub.user_id)): |
| group = list(group) |
| if group: |
| trim_subs(group, test) |
| if not test: |
| ThreadLocalORMSession.flush_all() |
| |
| |
| if __name__ == '__main__': |
| main() |