code-e21c7fe0b57a/tools/base640000755000000000000000000000022114427224005014154 0ustar 00000000000000#!/usr/bin/env python from __future__ import print_function import zlib, base64, sys print(base64.encodestring(zlib.compress(sys.stdin.read()))) code-e21c7fe0b57a/tools/fixroles.py0000644000000000000000000000227414427224005015361 0ustar 00000000000000import sys from roundup import admin class AdminTool(admin.AdminTool): def __init__(self): self.commands = admin.CommandDict() for k in AdminTool.__dict__.keys(): if k[:3] == 'do_': self.commands[k[3:]] = getattr(self, k) self.help = {} for k in AdminTool.__dict__.keys(): if k[:5] == 'help_': self.help[k[5:]] = getattr(self, k) self.instance_home = '' self.db = None def do_fixroles(self, args): '''Usage: fixroles Set the roles property for all users to reasonable defaults. The admin user gets "Admin", the anonymous user gets "Anonymous" and all other users get "User". ''' # get the user class cl = self.get_class('user') for userid in cl.list(): username = cl.get(userid, 'username') if username == 'admin': roles = 'Admin' elif username == 'anonymous': roles = 'Anonymous' else: roles = 'User' cl.set(userid, roles=roles) return 0 if __name__ == '__main__': tool = AdminTool() sys.exit(tool.main()) code-e21c7fe0b57a/tools/load_tracker.py0000755000000000000000000000525714427224005016167 0ustar 00000000000000#! /usr/bin/env python ''' Usage: %s Load up the indicated tracker with N issues and N/100 users. ''' from __future__ import print_function import sys, os, random from roundup import instance # open the instance if len(sys.argv) < 2: print("Error: Not enough arguments") print(__doc__.strip()%(sys.argv[0])) sys.exit(1) tracker_home = sys.argv[1] N = int(sys.argv[2]) # open the tracker tracker = instance.open(tracker_home) db = tracker.open('admin') db.tx_Source = "cli" priorities = db.priority.list() statuses = db.status.list() resolved_id = db.status.lookup('resolved') statuses.remove(resolved_id) names = ['alpha', 'beta', 'gamma', 'delta', 'epsilon', 'zeta', 'eta', 'theta', 'iota', 'kappa', 'lambda', 'mu', 'nu', 'xi', 'omicron', 'pi', 'rho'] titles = '''Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis nibh purus, bibendum sed, condimentum ut, bibendum ut, risus. Fusce pede enim, nonummy sit amet, dapibus a, blandit eget, metus. Nulla risus. Vivamus tincidunt. Donec consequat convallis quam. Sed convallis vehicula felis. Aliquam laoreet, dui quis pharetra vehicula, magna justo. Euismod felis, eu adipiscing eros metus id tortor. Suspendisse et turpis. Aenean non felis. Nam egestas eros. Integer tellus quam, mattis ac, vestibulum sed, egestas quis, mauris. Nulla tincidunt diam sit amet dui. Nam odio mauris, dignissim vitae, eleifend eu, consectetuer id, risus. Suspendisse potenti. Donec tincidunt. Vestibulum gravida. Fusce luctus, neque id mattis fringilla, purus pede sodales pede. Quis ultricies urna odio sed orci.'''.splitlines() try: try: db.user.lookup('alpha0') except: # add some users M = N//100 for i in range(M): print('\ruser', i, ' ', end=' ') sys.stdout.flush() if i//17 == 0: db.user.create(username=names[i%17]) else: db.user.create(username=names[i%17]+str(i//17)) # assignable user list users = db.user.list() users.remove(db.user.lookup('anonymous')) print() # now create the issues for i in range(N): print('\rissue', i, ' ', end=' ') sys.stdout.flush() # in practise, about 90% of issues are resolved if random.random() > .9: status = random.choice(statuses) else: status = resolved_id db.issue.create( title=random.choice(titles), priority=random.choice(priorities), status=status, assignedto=random.choice(users)) if not i%1000: db.commit() print() db.commit() finally: db.close() # vim: set filetype=python ts=4 sw=4 et si code-e21c7fe0b57a/tools/migrate-queries.py0000644000000000000000000000241314427224005016624 0ustar 00000000000000#! /usr/bin/env python ''' migrate-queries [ *] Migrate old queries in the specified instances to Roundup 0.6.0+ by removing the leading ? from their URLs. 0.6.0+ queries do not carry a leading ?; it is added by the 0.6.0 templating, so old queries lead to query URLs with a double leading ?? and a consequent 404 Not Found. ''' from __future__ import print_function __author__ = 'James Kew ' import sys import roundup.instance if len(sys.argv) == 1: print(__doc__) sys.exit(1) # Iterate over all instance homes specified in argv. for home in sys.argv[1:]: # Do some basic exception handling to catch bad arguments. try: instance = roundup.instance.open(home) except: print('Cannot open instance home directory %s!' % home) continue db = instance.open('admin') db.tx_Source = "cli" print('Migrating active queries in %s (%s):'%( instance.config.TRACKER_NAME, home)) for query in db.query.list(): url = db.query.get(query, 'url') if url[0] == '?': url = url[1:] print(' Migrating query%s (%s)'%(query, db.query.get(query, 'name'))) db.query.set(query, url=url) db.commit() db.close() code-e21c7fe0b57a/tools/roundup.public.pgp.key0000644000000000000000000001156114427224005017423 0ustar 00000000000000This is the public PGP/GPG key used to sign Roundup distributions. It is used starting with the 1.6.0 release. (Note in this file the @ sign in emails have been replaced with the word "at".) Key info: Roundup Team (signing key for roundup releases) RSA key ID: 756A76D8 Expires: 2028-07-17 Key fingerprint = 411E 354B 5D1A F261 25D6 2122 1F2D D0CB 756A 76D8 Import the key in this file using: gpg --import roundup.public.pgp.key Then you can use it to verify a downloaded Roundup release from pypi. Get the url of the release from: https://pypi.org/project/roundup Example (note there is no 1.5.7 release): https://files.pythonhosted.org/packages/bf/14/d61fac5ed2aaca8c720ac4d4077428b8fdafa356089516ba9ee630975d2a/roundup-1.5.7.tar.gz download the file then download: https://files.pythonhosted.org/packages/bf/14/d61fac5ed2aaca8c720ac4d4077428b8fdafa356089516ba9ee630975d2a/roundup-1.5.7.tar.gz.asc (same url as the file with .asc added at the end). To verify the tar file run: gpg --verify roundup-1.5.7.tar.gz.asc roundup-1.5.7.tar.gz and you should see: gpg: Signature made Wed 11 Jul 2018 08:40:06 PM EDT using RSA key ID 756A76D8 gpg: checking the trustdb [...] gpg: Good signature from "Roundup Team (signing key for roundup releases) " [...] which verifies the tarball integrity. If something is wrong you will see: gpg: Signature made Wed 11 Jul 2018 08:40:06 PM EDT using RSA key ID 756A76D8 gpg: BAD signature from "Roundup Team (signing key for roundup releases) " *do not use* the tarball if the signature is BAD. Email the roundup-devel mailing list if there is a problem. -----BEGIN PGP PUBLIC KEY BLOCK----- mQINBFtGmH4BEADSLfyuTuAMhaTpNkndkkaQTa5CYIS3QMTO5fsk1+EiRe8BlIZO GbBYjs9eLn48SLHl+TyM2pNo/9Yr5Jh3/frbARAOg4wwZLagG5w4KKVY2oxxbJla dkhnjaf5u6S+ufTnCXmj4ANcntmOXQTEL9tI9mlKc8yB1ZeBrP9mdrELz/Kasxfx MMsQqtuHc4xazNN8xI5St+MAP9B1Hos6QRjMiT5CiyAob2UvSoPoG5FkypoNWioF E1ZyHSHVgahSyo2y3w8hqmQoHxWV/VWlU+P5sRdqK0wEucB5B7JbKX+kGLkNoSPS TgsgOnS59FhGTXB0ZORZUiAP0eaCka/LMGqZYYZW8ILPSb4sZUJONS8147fsxA1p uHAOp4TEaGucVX+YUMBrKm33M8tzpSQ4ljKmywuohiK2a/p3aoGq792QoSFCEwTn DvZBJwBXxS5sNWYz4nYXtm8H9thqh+0KvsNl/ai8FcQwiEY07Xi0PB3IU0iWCMul TXvBR4u0LZ7pg0D5qwQuj52EJCecPp2S1hynbprA6Nql+0PLkE082p+gvk+7bH0O x8fERUNuio7TAzvWbs5c41Hf9b4raSeI8vlQc62xfWRkVC6FeNB0qYgTHWEn9gZR PYChgwDWlLqIoxrAgTK2XcxptzzZZ0Gmfbw3hjjrO9rq0/7VYDSu00woAQARAQAB tFVSb3VuZHVwIFRlYW0gKHNpZ25pbmcga2V5IGZvciByb3VuZHVwIHJlbGVhc2Vz KSA8cm91bmR1cC1kZXZlbEBsaXN0cy5zb3VyY2Vmb3JnZS5uZXQ+iQJVBBMBAgA/ AhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgBYhBEEeNUtdGvJhJdYhIh8t0Mt1 anbYBQJkE2bjBQkS15tlAAoJEB8t0Mt1anbY+psQAJOCCWZPqN3pckEu9ZVdvZ04 3JmhhTjl7YlUrBC8SdSHON/hpm41foS5Aj083p9yTAfJFPfPAD6JoYDsGRdinhy5 I2tplKU5tVv508DigbH6snaNVSAmsecp6HTm6M35e3CZtZpWDtooFI4YeyygN9Hm wo95SRs1HRKeA2nD4w3I5beKo74s3qfBviM1qg7gmk8kWhI6fkhlr0VFc1Bzyq9u egp2a1WqsDJJzPpTUJI5wYshOdIHcX8xsJ788iE9vsRu4Dp4AQDtyAgkNd8SkzQ+ rcNI+O+dqCwMfdESaNN8ql2/go5Y2fGPm/gqHQQTWW+R9qgitkFSJfCgdhf9DhJx 5uvXi31zxITuW7B2c3Pg81oc9iJI0jdC19IZvqzFsBT6/cbGQHvaNe+6ow24LShP YKbjXM4XK/A/5o3AmGKiZKXa+NDNeVNBFB4+v8BWBuElBbOLVeKDaDsvUB5B7lbD WdlFaYIO9lEBuwXyjs4Kwx34emrm2VrYqlPTofEwfNeNsUJ51kLXq+pnc7hOLlE1 DCuRXWcsmXak5Ti0YCO9/XaBOhnmQwTQWAvPBjJZB/qUORDdm/fRkrcgDur4L3Pm N9gtogMkn9N7VOZUeSHGtfMRStbLES3kzYjQkCWoJ1IOsGSxBAJ3HIeyZRhkXaMp 8km/HszWFudWlnClRG6RuQINBFtGmH4BEACs3nbnyJu9/zW33o/ZnsGs6Rgq/wjU OXOfA1F2oJ4zryRxy7Y3OUgiLakaLJ9WjPxB7ryCBWdUKQAZx1Qfai+mkQVJNjui Ilo7QYuY20pPQ/vS45oCNKPYhgPEuYmo5gRmxX5v+hBYo3zLl1/pt4t8dOFUNuQj CKuVH3e/Qt+ecq74DmVmVQOFdftFHve0qTBvIP7Yc775lH9pwsekE2UVJtnVRSzI KKnxD4xYxBFooE4BsL2wLp1y2xwh7aF99rlKYYtUHvtJAfMnk4PbPnUw45AdUIZf S7h3Rt3Cu6IGuq8qZZLa53EN2nlRJh1fdeMH7oN3BJ5p/HYWd+nJ9PtTpgJ1V2o3 faBSGdmjRWDfapVuxlRf3J3/9Jf9le7dS2D6lCd4ihVzBKPkQemmEck1HwVq3rGF vexqEu8CEHOUOq9WEO0qwtoJqyJ0uVoYGqCXOYkjpTs2SI67sYnUi9BJCvdmlOW2 j9lxbKBU6AOhqYKCLQ0KO9YjwwioKFF1JGjlJtNnNp69l33V1q2u/5ITZAapi//h roNAMOo5W9HUPDmcw2WheRGc4rYlOPT5KTdUIyIxhcav3f4mjfJc4sYPTYk7ucvB ypSCctvVFAo+8Xjyw5zxO7AlPCnoMJdwMh8tZ2TOnL3vEaVwX2gSEWV1nW24kcia kTHCKbJ7LOTKtwARAQABiQI8BBgBAgAmAhsMFiEEQR41S10a8mEl1iEiHy3Qy3Vq dtgFAmQTawwFCRLXn44ACgkQHy3Qy3VqdtidLQ//dir7iKXBQ7HCwbenhQM686Ux uMOo+K0D6HCBQK6z5iHWrqUeUUjIvZJOYGizW4kZ12RCBtzxouaw8L2BihrxatSO GkBt3jkaJ/d52gCZhwPRriwPQuc5VvF0vbNYlzzsrxWNk+Jdp4I9qzEeBP1Zzji2 eXr7jey69e+rJraXa7w0wPLT4/arx56AFPOChiLoXbAop8Pr/VkvJ6cvN/Epb+DK ZG4ibhDaAkFTzAT9lpi2gy55r021NIvChYZWm0fsGiNy538PMKGc2laSZfEn4FvB bk0tyooAF1bISG7UfUT7burl35IgI6OqyLwCwA91rz5vAoq5c23vy9eUnPxKWVRl fcFq05M/X4O/aL7o+LyA0QbBYQLp0Sw13WkGssuAA31W678XEnWFmMD7l0FAn9vc 7seyVklDg1YTqGCztiQJqF0wpfvxeyBqLl4xDHVCaClbi5ZB9DFDidCAphl7/b5X DpjGKgSUZDn3rfPtIpemVRf87EK0rcmG4PFvmz7Z6C9zqamVMa8scuRN5sRR5WOC N/tsktLI+anOBAqOSIqoNS68h94HRIU/RZMS2/6jWonygi1qvsykJinW0Y+/P3qd SkU2x8Gh43K/hkK3AmpnFxzdXLw8YbgAbePVhBE9foXvC9oP0Wv7v+1RLReI0qH9 fJ6edN5eeKJuB9zvi+g= =GaWC -----END PGP PUBLIC KEY BLOCK-----