1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
#!/usr/bin/python -S
#
# Copyright 2009-2011 Canonical Ltd. This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).
# pylint: disable-msg=C0103,W0403
"""Check for invalid/missing TeamParticipation entries.
Invalid TP entries are the ones for which there are no active TeamMemberships
leading to.
This script is usually run on staging to find discrepancies between the
TeamMembership and TeamParticipation tables which are a good indication of
bugs in the code which maintains the TeamParticipation table.
Ideally there should be database constraints to prevent this sort of
situation, but that's not a simple thing and this should do for now.
"""
import _pythonpath
from lp.registry.scripts.teamparticipation import (
check_teamparticipation_circular,
check_teamparticipation_consistency,
fetch_team_participation_info,
fix_teamparticipation_consistency,
)
from lp.services.scripts.base import LaunchpadScript
from lp.services.utils import (
load_bz2_pickle,
save_bz2_pickle,
)
class CheckTeamParticipationScript(LaunchpadScript):
description = "Check for invalid/missing TeamParticipation entries."
def add_my_options(self):
self.parser.add_option(
"--load-participation-info",
dest="load_info", metavar="FILE", help=(
"File from which to load participation information "
"instead of going to the database."))
self.parser.add_option(
"--save-participation-info",
dest="save_info", metavar="FILE", help=(
"File in which to save participation information, for "
"later processing with --load-participation-info."))
def main(self):
"""Perform various checks on the `TeamParticipation` table."""
if self.options.load_info:
participation_info = load_bz2_pickle(self.options.load_info)
else:
check_teamparticipation_circular(self.logger)
participation_info = fetch_team_participation_info(self.logger)
if self.options.save_info:
save_bz2_pickle(participation_info, self.options.save_info)
else:
errors = check_teamparticipation_consistency(
self.logger, participation_info)
fix_teamparticipation_consistency(self.logger, errors)
if __name__ == '__main__':
CheckTeamParticipationScript("check-teamparticipation").run()
|