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
|
#!/usr/bin/python -S
#
# Copyright 2009 Canonical Ltd. This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).
import _pythonpath
import sys
from canonical.lp import initZopeless
from canonical.database import postgresql
from canonical.database.sqlbase import cursor
from canonical.launchpad.database import Person, TeamParticipation
person_handle = sys.argv[1]
txn = initZopeless()
try:
int(person_handle)
except ValueError:
if "@" in person_handle:
person = Person.selectOne("EmailAddress.person = Person.id AND "
"emailaddress.email = %s" % person_handle)
else:
person = Person.selectOneBy(name=person_handle)
else:
person = Person.selectOneBy(id=person_handle)
if person is None:
print "Person %s not found" % person_handle
sys.exit(1)
skip = []
cur = cursor()
references = list(postgresql.listReferences(cur, 'person', 'id'))
print ("Listing references for %s (ID %s, preferred email %s):\n" %
(person.name, person.id,
person.preferredemail and person.preferredemail.email))
for src_tab, src_col, ref_tab, ref_col, updact, delact in references:
if (src_tab, src_col) in skip:
continue
query = "SELECT id FROM %s WHERE %s=%s" % (src_tab, src_col, person.id)
cur.execute(query)
rows = cur.fetchall()
for row in rows:
if src_tab.lower() == 'teamparticipation':
tp = TeamParticipation.selectOneBy(
personID=person.id, teamID=person.id)
if tp.id == row[0]:
# Every person has a teamparticipation entry for itself,
# and we already know this. No need to output it, then.
continue
print ("\tColumn %s of table %s with id %s points to this "
"person." % (src_col, src_tab, row[0]))
print
|