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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
|
# Copyright 2009 Canonical Ltd. This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).
# pylint: disable-msg=E0611,W0212
__metaclass__ = type
__all__ = [
'SourcePackageName',
'SourcePackageNameSet',
'getSourcePackageDescriptions',
]
from sqlobject import (
SQLMultipleJoin,
SQLObjectNotFound,
StringCol,
)
from zope.interface import implements
from lp.app.errors import NotFoundError
from lp.app.validators.name import valid_name
from lp.registry.errors import (
InvalidName,
NoSuchSourcePackageName,
)
from lp.registry.interfaces.sourcepackagename import (
ISourcePackageName,
ISourcePackageNameSet,
)
from lp.services.database.sqlbase import (
cursor,
quote_like,
SQLBase,
sqlvalues,
)
from lp.services.helpers import ensure_unicode
class SourcePackageName(SQLBase):
implements(ISourcePackageName)
_table = 'SourcePackageName'
name = StringCol(dbName='name', notNull=True, unique=True,
alternateID=True)
potemplates = SQLMultipleJoin(
'POTemplate', joinColumn='sourcepackagename')
packagings = SQLMultipleJoin(
'Packaging', joinColumn='sourcepackagename', orderBy='Packaging.id')
def __unicode__(self):
return self.name
def __repr__(self):
return "<%s '%s'>" % (self.__class__.__name__, self.name)
def ensure(klass, name):
try:
return klass.byName(name)
except SQLObjectNotFound:
return klass(name=name)
ensure = classmethod(ensure)
class SourcePackageNameSet:
implements(ISourcePackageNameSet)
def __getitem__(self, name):
"""See `ISourcePackageNameSet`."""
name = ensure_unicode(name)
try:
return SourcePackageName.byName(name)
except SQLObjectNotFound:
raise NoSuchSourcePackageName(name)
def get(self, sourcepackagenameid):
"""See `ISourcePackageNameSet`."""
try:
return SourcePackageName.get(sourcepackagenameid)
except SQLObjectNotFound:
raise NotFoundError(sourcepackagenameid)
def getAll(self):
"""See `ISourcePackageNameSet`."""
return SourcePackageName.select()
def findByName(self, name):
"""Find sourcepackagenames by its name or part of it."""
query = "name ILIKE '%%' || %s || '%%'" % quote_like(name)
return SourcePackageName.select(query)
def queryByName(self, name):
"""See `ISourcePackageNameSet`."""
return SourcePackageName.selectOneBy(name=name)
def new(self, name):
if not valid_name(name):
raise InvalidName(
"%s is not a valid name for a source package." % name)
return SourcePackageName(name=name)
def getOrCreateByName(self, name):
try:
return self[name]
except NotFoundError:
return self.new(name)
def getSourcePackageDescriptions(
results, use_names=False, max_title_length=50):
"""Return a dictionary with descriptions keyed on source package names.
Takes an ISelectResults of a *PackageName query. The use_names
flag is a hack that allows this method to work for the
BinaryAndSourcePackageName view, which lacks IDs.
WARNING: this function assumes that there is little overlap and much
coherence in how package names are used, in particular across
distributions if derivation is implemented. IOW, it does not make a
promise to provide The Correct Description, but a pretty good guess
at what the description should be.
"""
# XXX: kiko, 2007-01-17:
# Use_names could be removed if we instead added IDs to the
# BinaryAndSourcePackageName view, but we'd still need to find
# out how to specify the attribute, since it would be
# sourcepackagename_id and binarypackagename_id depending on
# whether the row represented one or both of those cases.
if use_names:
clause = ("SourcePackageName.name in %s" %
sqlvalues([pn.name for pn in results]))
else:
clause = ("SourcePackageName.id in %s" %
sqlvalues([spn.id for spn in results]))
cur = cursor()
cur.execute("""SELECT DISTINCT BinaryPackageName.name,
SourcePackageName.name
FROM BinaryPackageRelease, SourcePackageName,
BinaryPackageBuild, SourcePackageRelease,
BinaryPackageName
WHERE
BinaryPackageName.id =
BinaryPackageRelease.binarypackagename AND
BinaryPackageRelease.build = BinaryPackageBuild.id AND
SourcePackageRelease.sourcepackagename =
SourcePackageName.id AND
BinaryPackageBuild.source_package_release =
SourcePackageRelease.id AND
%s
ORDER BY BinaryPackageName.name,
SourcePackageName.name"""
% clause)
descriptions = {}
for binarypackagename, sourcepackagename in cur.fetchall():
if not sourcepackagename in descriptions:
descriptions[sourcepackagename] = (
"Source of: %s" % binarypackagename)
else:
if len(descriptions[sourcepackagename]) > max_title_length:
description = "..."
else:
description = ", %s" % binarypackagename
descriptions[sourcepackagename] += description
return descriptions
|