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
|
# Copyright (C) 2011 Luke Macken <lmacken@redhat.com>
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as
# published by the Free Software Foundation, either version 3 of the
# License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
from sqlalchemy.orm.exc import NoResultFound
from models import DBSession, Root, initialize_sql
import models
import sqlalchemy
class SearchHandler(object):
def search(self, term, cats):
# Don't do any search if the term is too short
if len(term) < 2:
return {'data':[]}
attrs = {
'Category' : {
'search_on' : ['name', 'description'],
},
'Group' : {
'search_on' : ['name', 'description'],
},
'Package' : {
'search_on' : ['name'],
}
}
srch = '%%%s%%' % term
cats = cats.split(',')
results = []
for cat in cats:
if not cat in attrs.keys():
raise ValueError, "'%s' is a disallowed category." % cat
cls = getattr(models, cat)
entries = cls.query.filter(sqlalchemy.or_(
*[getattr(cls, srch_attr).like(srch)
for srch_attr in attrs[cat]['search_on']]
))
results += [[unicode(e), e.id, cat] for e in entries]
data = {
'data' : [
{
'label' : label,
'value' : value,
'category' : category }
for label, value, category in results
]
}
return data
class MyApp(object):
__name__ = None
__parent__ = None
def __getitem__(self, key):
session = DBSession()
if key == 'search':
handler = SearchHandler()
handler.__name__ = key
handler.__parent__ = self
return handler
try:
id = int(key)
except (ValueError, TypeError):
raise KeyError(key)
query = session.query(Root).filter_by(id=id)
try:
item = query.one()
item.__parent__ = self
item.__name__ = key
return item
except NoResultFound:
raise KeyError(key)
def get(self, key, default=None):
try:
item = self.__getitem__(key)
except KeyError:
item = default
return item
def __iter__(self):
session= DBSession()
query = session.query(Root)
return iter(query)
root = MyApp()
def default_get_root(request):
return root
def appmaker(engine):
initialize_sql(engine)
return default_get_root
|