annotate zopeSolr.py @ 10:74a9661e4e9f

sorting added
author dwinter
date Thu, 27 Jun 2013 08:28:45 +0200
parents a8f16569d1a6
children f7fe88804cb8
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
834706423ac1 initial
dwinter
parents:
diff changeset
1 # -*- coding: utf-8 -*-
834706423ac1 initial
dwinter
parents:
diff changeset
2
834706423ac1 initial
dwinter
parents:
diff changeset
3 #Verbindet Zope mit solr. Vorraussetzung ist das Paket sunburnt, @see http://opensource.timetric.com/sunburnt/
834706423ac1 initial
dwinter
parents:
diff changeset
4
834706423ac1 initial
dwinter
parents:
diff changeset
5
834706423ac1 initial
dwinter
parents:
diff changeset
6 from OFS.SimpleItem import SimpleItem
834706423ac1 initial
dwinter
parents:
diff changeset
7 from Products.PageTemplates.PageTemplateFile import PageTemplateFile
834706423ac1 initial
dwinter
parents:
diff changeset
8 import os.path
834706423ac1 initial
dwinter
parents:
diff changeset
9 import sunburnt
834706423ac1 initial
dwinter
parents:
diff changeset
10 from Globals import package_home
834706423ac1 initial
dwinter
parents:
diff changeset
11 import httplib2
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
12 import urlparse
0
834706423ac1 initial
dwinter
parents:
diff changeset
13 import urllib
834706423ac1 initial
dwinter
parents:
diff changeset
14 import re
834706423ac1 initial
dwinter
parents:
diff changeset
15 import xml.etree.ElementTree as ET
834706423ac1 initial
dwinter
parents:
diff changeset
16 import json
6
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
17 import random
0
834706423ac1 initial
dwinter
parents:
diff changeset
18
834706423ac1 initial
dwinter
parents:
diff changeset
19 #Worte die nicht in der Termliste angezeigt werden sollen #TODO: make this configurable
834706423ac1 initial
dwinter
parents:
diff changeset
20
834706423ac1 initial
dwinter
parents:
diff changeset
21 STOPLIST={'main_content':['forward','drucken','history','science','part','publications','projects',
834706423ac1 initial
dwinter
parents:
diff changeset
22 'project','new','geschichte','institute','related','boltzmannstraße','14195'],
834706423ac1 initial
dwinter
parents:
diff changeset
23
834706423ac1 initial
dwinter
parents:
diff changeset
24 'title':['bd','10','11','12','18','19','20','abt','ad','di','history','geschichte','science']
834706423ac1 initial
dwinter
parents:
diff changeset
25 }
834706423ac1 initial
dwinter
parents:
diff changeset
26
834706423ac1 initial
dwinter
parents:
diff changeset
27
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
28 PURLSERVER="http://md.mpiwg-berlin.mpg.de/purls/"
10733d367831 date ranges
dwinter
parents: 3
diff changeset
29
10733d367831 date ranges
dwinter
parents: 3
diff changeset
30 #TODO: only needed for getTermsAsJSON, solle irgendwie aus dem sunburnt kommen
10733d367831 date ranges
dwinter
parents: 3
diff changeset
31 SOLRSERVER="/select?q=%s:%s&wt=xml&tv=on&qt=tvrh&fl=%s&tv.tf=true"
0
834706423ac1 initial
dwinter
parents:
diff changeset
32
834706423ac1 initial
dwinter
parents:
diff changeset
33 def zptFile(self, path, orphaned=False):
834706423ac1 initial
dwinter
parents:
diff changeset
34 """returns a page template file from the product"""
834706423ac1 initial
dwinter
parents:
diff changeset
35 if orphaned:
834706423ac1 initial
dwinter
parents:
diff changeset
36 # unusual case
834706423ac1 initial
dwinter
parents:
diff changeset
37 pt=PageTemplateFile(os.path.join(package_home(globals()), path))
834706423ac1 initial
dwinter
parents:
diff changeset
38 else:
834706423ac1 initial
dwinter
parents:
diff changeset
39
834706423ac1 initial
dwinter
parents:
diff changeset
40 pt=PageTemplateFile(os.path.join(package_home(globals()), path)).__of__(self)
834706423ac1 initial
dwinter
parents:
diff changeset
41 return pt
834706423ac1 initial
dwinter
parents:
diff changeset
42
834706423ac1 initial
dwinter
parents:
diff changeset
43
834706423ac1 initial
dwinter
parents:
diff changeset
44
834706423ac1 initial
dwinter
parents:
diff changeset
45 class ZopeSolr(SimpleItem):
6
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
46
0
834706423ac1 initial
dwinter
parents:
diff changeset
47
834706423ac1 initial
dwinter
parents:
diff changeset
48 meta_type="ZopeSolr"
834706423ac1 initial
dwinter
parents:
diff changeset
49
834706423ac1 initial
dwinter
parents:
diff changeset
50 manage_options= ({'label':'Main Config','action': 'changeMain'},) + SimpleItem.manage_options
834706423ac1 initial
dwinter
parents:
diff changeset
51
834706423ac1 initial
dwinter
parents:
diff changeset
52 def __init__(self,id,title,solrURL):
834706423ac1 initial
dwinter
parents:
diff changeset
53 self.id=id
834706423ac1 initial
dwinter
parents:
diff changeset
54 self.title=title
834706423ac1 initial
dwinter
parents:
diff changeset
55 self.solrURL=solrURL #URL einer solr instance bzw. einer collection, falls nicht die default collection benutzt werden soll
834706423ac1 initial
dwinter
parents:
diff changeset
56
834706423ac1 initial
dwinter
parents:
diff changeset
57
834706423ac1 initial
dwinter
parents:
diff changeset
58 #Verbinde mit der solt Instance
834706423ac1 initial
dwinter
parents:
diff changeset
59
834706423ac1 initial
dwinter
parents:
diff changeset
60 def connect(self):
834706423ac1 initial
dwinter
parents:
diff changeset
61 self._v_solr=sunburnt.SolrInterface(url=self.solrURL)
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
62
10733d367831 date ranges
dwinter
parents: 3
diff changeset
63
6
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
64 def getRandom(self,number=3,field="title_s"):
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
65
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
66 """hole zufaellige eintraege"""
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
67
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
68
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
69 if not getattr(self,'_v_solr_',None):
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
70 self.connect()
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
71
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
72 #http://localhost:8983/solr/mpiwgSources/select/?q=*:*&sort=random_12xs34%20desc&rows=1&facet=false
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
73
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
74
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
75 random.seed()
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
76 rand = random.randrange(300000)
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
77
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
78 results = self._v_solr.query("*.*").sort_by("-random_%s"%rand).paginate(start=0, rows=number).execute()
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
79
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
80 return results
c97b5cbcda52 random search in solr
dwinter
parents: 5
diff changeset
81
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
82 #erzeuge den link auf die fulltext display version des bildviewers
10733d367831 date ranges
dwinter
parents: 3
diff changeset
83 def createFullTextLink(self,page,facetSerch,search):
10733d367831 date ranges
dwinter
parents: 3
diff changeset
84
10733d367831 date ranges
dwinter
parents: 3
diff changeset
85 fqs=[]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
86 for key in facetSerch.keys():
10733d367831 date ranges
dwinter
parents: 3
diff changeset
87 values = self.getList(facetSerch.get(key))
10733d367831 date ranges
dwinter
parents: 3
diff changeset
88 for value in values:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
89 if value!="*":
10733d367831 date ranges
dwinter
parents: 3
diff changeset
90 fqs.append("%s=%s"%(key,urllib.quote(value)));
10733d367831 date ranges
dwinter
parents: 3
diff changeset
91
10733d367831 date ranges
dwinter
parents: 3
diff changeset
92 ret="pf=%s"%page
10733d367831 date ranges
dwinter
parents: 3
diff changeset
93 ret+="&query=("
10733d367831 date ranges
dwinter
parents: 3
diff changeset
94
10733d367831 date ranges
dwinter
parents: 3
diff changeset
95
10733d367831 date ranges
dwinter
parents: 3
diff changeset
96
10733d367831 date ranges
dwinter
parents: 3
diff changeset
97 ret+=" OR ".join(fqs)
10733d367831 date ranges
dwinter
parents: 3
diff changeset
98 #if len(fqs)>0 and len(qs)>0 and qs[0]!="":
10733d367831 date ranges
dwinter
parents: 3
diff changeset
99 if len(fqs)>0 and len(search)>0: #TODO das muss noch geandert werden, wenn das der normale suchstring nach feldern müssen alle "AND" in "OR" getauscht werden
10733d367831 date ranges
dwinter
parents: 3
diff changeset
100 #da ja in der volltext-line die Zeile gedunfen werden soll wenn eines der Worte drin ist, vorher wurd eventuell und über die ganee seite gesucht
10733d367831 date ranges
dwinter
parents: 3
diff changeset
101 #die worte müssen aber nicht in einer zeile sein und werden jetzt nicht gefunden
10733d367831 date ranges
dwinter
parents: 3
diff changeset
102 ret+=" OR "
10733d367831 date ranges
dwinter
parents: 3
diff changeset
103
10733d367831 date ranges
dwinter
parents: 3
diff changeset
104
10733d367831 date ranges
dwinter
parents: 3
diff changeset
105
10733d367831 date ranges
dwinter
parents: 3
diff changeset
106 ret+="("+search+")"
10733d367831 date ranges
dwinter
parents: 3
diff changeset
107
10733d367831 date ranges
dwinter
parents: 3
diff changeset
108 ret+=")&viewLayer=search"
10733d367831 date ranges
dwinter
parents: 3
diff changeset
109
10733d367831 date ranges
dwinter
parents: 3
diff changeset
110 return ret
10733d367831 date ranges
dwinter
parents: 3
diff changeset
111
0
834706423ac1 initial
dwinter
parents:
diff changeset
112 #erzeuge einen Link, insbesonder für faceted suche
834706423ac1 initial
dwinter
parents:
diff changeset
113 #@param search: ist suchparameter, wird einfach als search=%s weitergereicht
834706423ac1 initial
dwinter
parents:
diff changeset
114 #@param facetSearch: bekommt einen hash (feldname, liste der suchworte)
834706423ac1 initial
dwinter
parents:
diff changeset
115
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
116 def generateLink(self,search,facetSearch={},ranges={},dateranges={},args={}):
0
834706423ac1 initial
dwinter
parents:
diff changeset
117 ret="?search=%s"%search
834706423ac1 initial
dwinter
parents:
diff changeset
118
834706423ac1 initial
dwinter
parents:
diff changeset
119 for facet in facetSearch.keys():
834706423ac1 initial
dwinter
parents:
diff changeset
120
834706423ac1 initial
dwinter
parents:
diff changeset
121 searchTerms = facetSearch[facet]
834706423ac1 initial
dwinter
parents:
diff changeset
122
834706423ac1 initial
dwinter
parents:
diff changeset
123 if isinstance(searchTerms, basestring):
834706423ac1 initial
dwinter
parents:
diff changeset
124 searchTerms=[searchTerms]
834706423ac1 initial
dwinter
parents:
diff changeset
125
834706423ac1 initial
dwinter
parents:
diff changeset
126 for searchTerm in searchTerms:
834706423ac1 initial
dwinter
parents:
diff changeset
127 try:
834706423ac1 initial
dwinter
parents:
diff changeset
128 ret+="&%s_fc=%s"%(facet,searchTerm.encode('utf-8'))
834706423ac1 initial
dwinter
parents:
diff changeset
129 except:
834706423ac1 initial
dwinter
parents:
diff changeset
130 ret+="&%s_fc=%s"%(facet,searchTerm)
834706423ac1 initial
dwinter
parents:
diff changeset
131
834706423ac1 initial
dwinter
parents:
diff changeset
132 for key,values in ranges.items():
834706423ac1 initial
dwinter
parents:
diff changeset
133
834706423ac1 initial
dwinter
parents:
diff changeset
134 if isinstance(values, basestring):
834706423ac1 initial
dwinter
parents:
diff changeset
135 values=[values]
834706423ac1 initial
dwinter
parents:
diff changeset
136
834706423ac1 initial
dwinter
parents:
diff changeset
137 for value in values:
834706423ac1 initial
dwinter
parents:
diff changeset
138 ret+="&%s_rg=%s"%(key,value)
834706423ac1 initial
dwinter
parents:
diff changeset
139
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
140 for key,values in dateranges.items():
10733d367831 date ranges
dwinter
parents: 3
diff changeset
141
10733d367831 date ranges
dwinter
parents: 3
diff changeset
142 if isinstance(values, basestring):
10733d367831 date ranges
dwinter
parents: 3
diff changeset
143 values=[values]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
144
10733d367831 date ranges
dwinter
parents: 3
diff changeset
145 for value in values:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
146 ret+="&%s_drg=%s"%(key,value)
10733d367831 date ranges
dwinter
parents: 3
diff changeset
147
0
834706423ac1 initial
dwinter
parents:
diff changeset
148
1
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
149 for key,value in args.items():
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
150
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
151 if isinstance(value, basestring):
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
152 value=[value]
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
153
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
154 for val in value:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
155 ret+="&%s=%s"%(key,val)
0
834706423ac1 initial
dwinter
parents:
diff changeset
156 return ret
834706423ac1 initial
dwinter
parents:
diff changeset
157
834706423ac1 initial
dwinter
parents:
diff changeset
158 #hilfsmethode erzeuget immer eine liste von einträgen
834706423ac1 initial
dwinter
parents:
diff changeset
159 def getList(self,param):
834706423ac1 initial
dwinter
parents:
diff changeset
160 if isinstance(param, basestring):
834706423ac1 initial
dwinter
parents:
diff changeset
161 param=[param]
834706423ac1 initial
dwinter
parents:
diff changeset
162
834706423ac1 initial
dwinter
parents:
diff changeset
163 return param
834706423ac1 initial
dwinter
parents:
diff changeset
164
834706423ac1 initial
dwinter
parents:
diff changeset
165 #erzeugt analog zu den Ranges in Velocity für ein numerisches Feld die Suche in ranges
834706423ac1 initial
dwinter
parents:
diff changeset
166 #@param field:ist der name des Feldes in dem in Ranges gesucht werden soll
834706423ac1 initial
dwinter
parents:
diff changeset
167 #@param begin anfang der ranges
834706423ac1 initial
dwinter
parents:
diff changeset
168 #@param end ende der Raanges
834706423ac1 initial
dwinter
parents:
diff changeset
169 #@param increment größe eines ranges
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
170 #@param date wenn wahr, dann ist field ein Datumsfeld, begin, end,increment sind trotzdem zur Zeit, dan Integer für Jahre !!, d.h. zur Zeit sind nur JAhre als Schritte möglich
0
834706423ac1 initial
dwinter
parents:
diff changeset
171 # für alle andere paramter @see prepareSearch
834706423ac1 initial
dwinter
parents:
diff changeset
172 #@return gibt ein hash: mit range -> anzahl der Treffer in dem Ranage. e.g 1921-1950 -> 21
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
173
10733d367831 date ranges
dwinter
parents: 3
diff changeset
174 def ranges(self,field,begin,end,increment,solrQuery="",facetFields=[],start=0,rows=10,facetSearch=None,sortFacets=True,date=False,storeFields=False):
0
834706423ac1 initial
dwinter
parents:
diff changeset
175
834706423ac1 initial
dwinter
parents:
diff changeset
176 q=self.prepareSearch(solrQuery,facetFields,start,rows,facetSearch,sortFacets)
834706423ac1 initial
dwinter
parents:
diff changeset
177
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
178 res={} #speiceher abzahl
10733d367831 date ranges
dwinter
parents: 3
diff changeset
179
10733d367831 date ranges
dwinter
parents: 3
diff changeset
180 fls={} #speichere felder
10733d367831 date ranges
dwinter
parents: 3
diff changeset
181
10733d367831 date ranges
dwinter
parents: 3
diff changeset
182 #for fl in storeFields: #initialisiere den hash
10733d367831 date ranges
dwinter
parents: 3
diff changeset
183 # fls[fl]={}
10733d367831 date ranges
dwinter
parents: 3
diff changeset
184
0
834706423ac1 initial
dwinter
parents:
diff changeset
185 if not getattr(self,'_v_solr_',None):
834706423ac1 initial
dwinter
parents:
diff changeset
186 self.connect()
834706423ac1 initial
dwinter
parents:
diff changeset
187
834706423ac1 initial
dwinter
parents:
diff changeset
188
834706423ac1 initial
dwinter
parents:
diff changeset
189
834706423ac1 initial
dwinter
parents:
diff changeset
190 for x in range(begin,end,increment):
834706423ac1 initial
dwinter
parents:
diff changeset
191 query={}
834706423ac1 initial
dwinter
parents:
diff changeset
192 #query["%s__gt"%field]=x
834706423ac1 initial
dwinter
parents:
diff changeset
193 #TODO __gt scheint nicht zu funktionieren wird zu gte (???)
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
194
10733d367831 date ranges
dwinter
parents: 3
diff changeset
195 if not date:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
196 query["%s__gte"%field]=int(x)+1
10733d367831 date ranges
dwinter
parents: 3
diff changeset
197
10733d367831 date ranges
dwinter
parents: 3
diff changeset
198 query["%s__lte"%field]=x+increment
10733d367831 date ranges
dwinter
parents: 3
diff changeset
199
10733d367831 date ranges
dwinter
parents: 3
diff changeset
200 key="%s-%s"%(x,x+increment)
0
834706423ac1 initial
dwinter
parents:
diff changeset
201
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
202 else:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
203 year="%s-01-01T00:00:00Z"
10733d367831 date ranges
dwinter
parents: 3
diff changeset
204 query["%s__gte"%field]=year%(int(x))
10733d367831 date ranges
dwinter
parents: 3
diff changeset
205
10733d367831 date ranges
dwinter
parents: 3
diff changeset
206 query["%s__lte"%field]=year%(x+increment)
10733d367831 date ranges
dwinter
parents: 3
diff changeset
207
10733d367831 date ranges
dwinter
parents: 3
diff changeset
208 key="%s@%s"%(year%(int(x)),year%(x+increment))
10733d367831 date ranges
dwinter
parents: 3
diff changeset
209
10733d367831 date ranges
dwinter
parents: 3
diff changeset
210 result = q.query(**query).highlight("text_german").execute()
0
834706423ac1 initial
dwinter
parents:
diff changeset
211
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
212 res[key]=result.result.numFound
10733d367831 date ranges
dwinter
parents: 3
diff changeset
213
10733d367831 date ranges
dwinter
parents: 3
diff changeset
214 if storeFields:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
215 fls[key] = result.highlighting;
10733d367831 date ranges
dwinter
parents: 3
diff changeset
216
0
834706423ac1 initial
dwinter
parents:
diff changeset
217
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
218
10733d367831 date ranges
dwinter
parents: 3
diff changeset
219 if storeFields:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
220 return res,fls
10733d367831 date ranges
dwinter
parents: 3
diff changeset
221
10733d367831 date ranges
dwinter
parents: 3
diff changeset
222 else:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
223 return res
0
834706423ac1 initial
dwinter
parents:
diff changeset
224
834706423ac1 initial
dwinter
parents:
diff changeset
225
834706423ac1 initial
dwinter
parents:
diff changeset
226 #prepareSearch erzeugt die Suchabfrage
834706423ac1 initial
dwinter
parents:
diff changeset
227
834706423ac1 initial
dwinter
parents:
diff changeset
228 #solrQuery sucht im in schema.xml bzw. solrconfig.xml festgelegt generischen Feld, hierbei werden mit blanks getrennte eintrage in "AND" zerlegt.
834706423ac1 initial
dwinter
parents:
diff changeset
229 #TODO: erlaube auch suche nach phrasen mit ""
834706423ac1 initial
dwinter
parents:
diff changeset
230 #facetFields:Liste der Felder, nach denen facitiert werden sollen, wirdn in facet_by in solrburn uebersetzt.
834706423ac1 initial
dwinter
parents:
diff changeset
231 #start: Erste Eintrag für paginierung, anzahl der Treffer
834706423ac1 initial
dwinter
parents:
diff changeset
232 #rows: anzahl der Treffer
834706423ac1 initial
dwinter
parents:
diff changeset
233 #facetSearch: Hash mit Feldnamen: suchwort oder Feldname: liste von Suchworten, hast wird direkt an query von solrburnt weitergegeben,
834706423ac1 initial
dwinter
parents:
diff changeset
234 #sortfacets: if true, dann werden die Ergebnisse der facetierten suche alphabetisch sortiert, ACHTUNG: das ist nicht gleich der Funktion in solr die Liste
834706423ac1 initial
dwinter
parents:
diff changeset
235 #direkt sortiert zurückzubekommen, hier werden die haufigsten Werte genommen (einstellt in solrconfig.xml) und dann nur diese sortiert!
834706423ac1 initial
dwinter
parents:
diff changeset
236 #ausserdem werden beim sortieren, die stopworte gefiltert!
834706423ac1 initial
dwinter
parents:
diff changeset
237 #
834706423ac1 initial
dwinter
parents:
diff changeset
238 #neben den direkten parameter koennen auch parameter fuer die facetierte Suche über FORM im REQUEST übergeben werden, diese Felder müssen dann
834706423ac1 initial
dwinter
parents:
diff changeset
239 #mit "_fc" enden.
834706423ac1 initial
dwinter
parents:
diff changeset
240 # gibt als ergebnis den folgenden Hash, so wie in http://opensource.timetric.com/sunburnt/queryingsolr.html#executing-queries-and-interpreting-the-response,
834706423ac1 initial
dwinter
parents:
diff changeset
241 # http://opensource.timetric.com/sunburnt/queryingsolr.html#highlighting
834706423ac1 initial
dwinter
parents:
diff changeset
242 # und http://opensource.timetric.com/sunburnt/queryingsolr.html#faceting
834706423ac1 initial
dwinter
parents:
diff changeset
243 #dokumentiert. Highlighting selbst wird in sorlconfig.xml konfiguriert.
834706423ac1 initial
dwinter
parents:
diff changeset
244 #return ein Queryobjet, zur eigentlichen Suche muss darauf noch execute ausgeführt werden.
834706423ac1 initial
dwinter
parents:
diff changeset
245
10
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
246 def prepareSearch(self,solrQuery,facetFields=[],start=0,rows=10,facetSearch=None,sortFacets=True,orSearch=None,sorting=None):
0
834706423ac1 initial
dwinter
parents:
diff changeset
247 "search solr"
834706423ac1 initial
dwinter
parents:
diff changeset
248
834706423ac1 initial
dwinter
parents:
diff changeset
249
834706423ac1 initial
dwinter
parents:
diff changeset
250 ranges={}
834706423ac1 initial
dwinter
parents:
diff changeset
251 ## deal with a form
834706423ac1 initial
dwinter
parents:
diff changeset
252 if self.REQUEST:
834706423ac1 initial
dwinter
parents:
diff changeset
253 constr = self.REQUEST.form
3
156c1db5a701 print statements deleted
dwinter
parents: 2
diff changeset
254
0
834706423ac1 initial
dwinter
parents:
diff changeset
255 for field in constr.keys():
834706423ac1 initial
dwinter
parents:
diff changeset
256
834706423ac1 initial
dwinter
parents:
diff changeset
257 #facetes
834706423ac1 initial
dwinter
parents:
diff changeset
258 if field.endswith("_fc"):
834706423ac1 initial
dwinter
parents:
diff changeset
259 if facetSearch is None:
834706423ac1 initial
dwinter
parents:
diff changeset
260 facetSearch={}
834706423ac1 initial
dwinter
parents:
diff changeset
261
834706423ac1 initial
dwinter
parents:
diff changeset
262 vals = constr[field]
834706423ac1 initial
dwinter
parents:
diff changeset
263 if not isinstance(vals,basestring):
834706423ac1 initial
dwinter
parents:
diff changeset
264
834706423ac1 initial
dwinter
parents:
diff changeset
265 vals=[x.decode('utf-8') for x in vals]
834706423ac1 initial
dwinter
parents:
diff changeset
266 else:
834706423ac1 initial
dwinter
parents:
diff changeset
267 vals=vals.decode('utf-8')
1
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
268
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
269
0
834706423ac1 initial
dwinter
parents:
diff changeset
270 facetSearch[field.replace("_fc",'')]=vals
834706423ac1 initial
dwinter
parents:
diff changeset
271 #ranges form a-b
834706423ac1 initial
dwinter
parents:
diff changeset
272
1
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
273
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
274 if field.endswith("_or"):
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
275 if orSearch is None:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
276 orSearch={}
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
277
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
278 vals = constr[field]
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
279 if not isinstance(vals,basestring):
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
280
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
281 vals=[x.decode('utf-8') for x in vals]
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
282 else:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
283 vals=vals.decode('utf-8')
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
284
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
285
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
286 orSearch[field.replace("_or",'')]=vals
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
287 #ranges form a-b
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
288
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
289
0
834706423ac1 initial
dwinter
parents:
diff changeset
290
834706423ac1 initial
dwinter
parents:
diff changeset
291 if field.endswith("_rg"):
834706423ac1 initial
dwinter
parents:
diff changeset
292
834706423ac1 initial
dwinter
parents:
diff changeset
293
834706423ac1 initial
dwinter
parents:
diff changeset
294 splitted = "_".split(field)
834706423ac1 initial
dwinter
parents:
diff changeset
295 if len(splitted)==2:
834706423ac1 initial
dwinter
parents:
diff changeset
296 #ranges[field.replace("_rg","__gt")]=splitted[0]
834706423ac1 initial
dwinter
parents:
diff changeset
297 #TODO __gt scheint nicht zu funktionieren wird zu gte (???)
834706423ac1 initial
dwinter
parents:
diff changeset
298 ranges[field.replace("_rg","__gte")]=int(splitted[0])+1
834706423ac1 initial
dwinter
parents:
diff changeset
299 ranges[field.replace("_rg","__lte")]=splitted[1]
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
300
10733d367831 date ranges
dwinter
parents: 3
diff changeset
301 elif field.endswith("_drg"):
10733d367831 date ranges
dwinter
parents: 3
diff changeset
302 splitted = "@".split(field)
10733d367831 date ranges
dwinter
parents: 3
diff changeset
303 if len(splitted)==2:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
304 #ranges[field.replace("_rg","__gt")]=splitted[0]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
305 #TODO __gt scheint nicht zu funktionieren wird zu gte (???)
10733d367831 date ranges
dwinter
parents: 3
diff changeset
306 ranges[field.replace("_drg","__gte")]=splitted[0]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
307 ranges[field.replace("_drg","__lte")]=splitted[1]
0
834706423ac1 initial
dwinter
parents:
diff changeset
308
834706423ac1 initial
dwinter
parents:
diff changeset
309
834706423ac1 initial
dwinter
parents:
diff changeset
310 #teste verbindung zu solr
834706423ac1 initial
dwinter
parents:
diff changeset
311 if not getattr(self,'_v_solr_',None):
834706423ac1 initial
dwinter
parents:
diff changeset
312 self.connect()
834706423ac1 initial
dwinter
parents:
diff changeset
313
834706423ac1 initial
dwinter
parents:
diff changeset
314
834706423ac1 initial
dwinter
parents:
diff changeset
315
834706423ac1 initial
dwinter
parents:
diff changeset
316 solrQuery = solrQuery.decode('utf-8')
834706423ac1 initial
dwinter
parents:
diff changeset
317
834706423ac1 initial
dwinter
parents:
diff changeset
318 #teile die suche nach " " daraus wird dann eine AND suche
834706423ac1 initial
dwinter
parents:
diff changeset
319 #TODO: sollte flexibler sein. insbesondere phrasen
834706423ac1 initial
dwinter
parents:
diff changeset
320 splitted= solrQuery.split(" ")
834706423ac1 initial
dwinter
parents:
diff changeset
321
834706423ac1 initial
dwinter
parents:
diff changeset
322 res = self._v_solr
834706423ac1 initial
dwinter
parents:
diff changeset
323
834706423ac1 initial
dwinter
parents:
diff changeset
324
834706423ac1 initial
dwinter
parents:
diff changeset
325
834706423ac1 initial
dwinter
parents:
diff changeset
326
834706423ac1 initial
dwinter
parents:
diff changeset
327 res=res.query(splitted)
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
328
0
834706423ac1 initial
dwinter
parents:
diff changeset
329 if len(ranges.keys())>0:
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
330
10733d367831 date ranges
dwinter
parents: 3
diff changeset
331
0
834706423ac1 initial
dwinter
parents:
diff changeset
332 res=res.query(ranges)
834706423ac1 initial
dwinter
parents:
diff changeset
333
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
334
0
834706423ac1 initial
dwinter
parents:
diff changeset
335 #ubergebe alle weiteren feld an die suche.
834706423ac1 initial
dwinter
parents:
diff changeset
336 if facetSearch:
834706423ac1 initial
dwinter
parents:
diff changeset
337 for key,vals in facetSearch.items():
834706423ac1 initial
dwinter
parents:
diff changeset
338
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
339 if key.endswith("_rg"): #range
0
834706423ac1 initial
dwinter
parents:
diff changeset
340
834706423ac1 initial
dwinter
parents:
diff changeset
341 if not isinstance(vals,basestring):
834706423ac1 initial
dwinter
parents:
diff changeset
342
834706423ac1 initial
dwinter
parents:
diff changeset
343 vals=[x.decode('utf-8') for x in vals]
834706423ac1 initial
dwinter
parents:
diff changeset
344 else:
834706423ac1 initial
dwinter
parents:
diff changeset
345 vals=[vals.decode('utf-8')]
834706423ac1 initial
dwinter
parents:
diff changeset
346
834706423ac1 initial
dwinter
parents:
diff changeset
347 for val in vals:
834706423ac1 initial
dwinter
parents:
diff changeset
348
834706423ac1 initial
dwinter
parents:
diff changeset
349 splitted = val.split("-")
3
156c1db5a701 print statements deleted
dwinter
parents: 2
diff changeset
350
0
834706423ac1 initial
dwinter
parents:
diff changeset
351 if len(splitted)==2:
834706423ac1 initial
dwinter
parents:
diff changeset
352 #TODO __gt scheint nicht zu funktionieren wird zu gte (???)
834706423ac1 initial
dwinter
parents:
diff changeset
353 facetSearch[key.replace("_rg","__gte")]=int(splitted[0])+1
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
354 facetSearch[key.replace("_rg","__lte")]=int(splitted[1])
3
156c1db5a701 print statements deleted
dwinter
parents: 2
diff changeset
355
0
834706423ac1 initial
dwinter
parents:
diff changeset
356 del facetSearch[key] # loesche das urspuerngliche feld
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
357
10733d367831 date ranges
dwinter
parents: 3
diff changeset
358 elif key.endswith("_drg"): #daterange
10733d367831 date ranges
dwinter
parents: 3
diff changeset
359
10733d367831 date ranges
dwinter
parents: 3
diff changeset
360 if not isinstance(vals,basestring):
10733d367831 date ranges
dwinter
parents: 3
diff changeset
361
10733d367831 date ranges
dwinter
parents: 3
diff changeset
362 vals=[x.decode('utf-8') for x in vals]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
363 else:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
364 vals=[vals.decode('utf-8')]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
365
10733d367831 date ranges
dwinter
parents: 3
diff changeset
366 for val in vals:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
367
10733d367831 date ranges
dwinter
parents: 3
diff changeset
368 splitted = val.split("@")
10733d367831 date ranges
dwinter
parents: 3
diff changeset
369
10733d367831 date ranges
dwinter
parents: 3
diff changeset
370 if len(splitted)==2:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
371 #TODO __gt scheint nicht zu funktionieren wird zu gte (???)
10733d367831 date ranges
dwinter
parents: 3
diff changeset
372 facetSearch[key.replace("_drg","__gte")]=splitted[0]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
373 facetSearch[key.replace("_drg","__lte")]=splitted[1]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
374
10733d367831 date ranges
dwinter
parents: 3
diff changeset
375 del facetSearch[key] # loesche das urspuerngliche feld
10733d367831 date ranges
dwinter
parents: 3
diff changeset
376
0
834706423ac1 initial
dwinter
parents:
diff changeset
377
834706423ac1 initial
dwinter
parents:
diff changeset
378 else:
1
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
379 if not isinstance(vals, basestring):
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
380 val = [x for x in vals if x!="*"] #siehe oben
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
381 else:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
382 val = [vals]
0
834706423ac1 initial
dwinter
parents:
diff changeset
383 facetSearch[key]=val
834706423ac1 initial
dwinter
parents:
diff changeset
384
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
385
0
834706423ac1 initial
dwinter
parents:
diff changeset
386 res=res.query(**facetSearch)
1
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
387
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
388
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
389 #felder mit ODER-Suche
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
390 if orSearch:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
391
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
392 for key,vals in orSearch.items():
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
393 qr = None
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
394 if not "*" in vals: #dann ohne einschränkung (key:*) sucht nur nach eintragen in denen etwas im feld steht, wir wollen aber alle
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
395 if isinstance(vals, basestring):
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
396 vals = [vals]
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
397
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
398
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
399 for val in vals:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
400 if not qr:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
401 qr=self._v_solr.Q(**{key:val})
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
402
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
403 else:
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
404 qr=qr|self._v_solr.Q(**{key:val})
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
405
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
406
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
407 res=res.query(qr)
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
408
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
409
0
834706423ac1 initial
dwinter
parents:
diff changeset
410
834706423ac1 initial
dwinter
parents:
diff changeset
411 #wenn facetField existieren dann rufe facetierung auf
834706423ac1 initial
dwinter
parents:
diff changeset
412 if len(facetFields)>0:
834706423ac1 initial
dwinter
parents:
diff changeset
413 #for facet in facetFields:
834706423ac1 initial
dwinter
parents:
diff changeset
414
834706423ac1 initial
dwinter
parents:
diff changeset
415 # res = res.facet_by(facet)
5
f695be8f4f34 Incomplete - # 77: Sources: Cloud
dwinter
parents: 4
diff changeset
416
7
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
417
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
418 res = res.facet_by(facetFields)
0
834706423ac1 initial
dwinter
parents:
diff changeset
419
834706423ac1 initial
dwinter
parents:
diff changeset
420 #res=res.paginate(start=start, rows=rows).highlight("main_content")
834706423ac1 initial
dwinter
parents:
diff changeset
421
834706423ac1 initial
dwinter
parents:
diff changeset
422 res=res.paginate(start=start, rows=rows)
834706423ac1 initial
dwinter
parents:
diff changeset
423
834706423ac1 initial
dwinter
parents:
diff changeset
424
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
425 #only highlighting if not searhc for only "*" - avoid max clause error
2
de6b7ed0c34d highlighting only enabled if not search for "*".
dwinter
parents: 1
diff changeset
426 if solrQuery=="*":
3
156c1db5a701 print statements deleted
dwinter
parents: 2
diff changeset
427
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
428
2
de6b7ed0c34d highlighting only enabled if not search for "*".
dwinter
parents: 1
diff changeset
429 res=res.paginate(start=start, rows=rows)
de6b7ed0c34d highlighting only enabled if not search for "*".
dwinter
parents: 1
diff changeset
430 else:
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
431
2
de6b7ed0c34d highlighting only enabled if not search for "*".
dwinter
parents: 1
diff changeset
432 res=res.paginate(start=start, rows=rows).highlight(usePhraseHighlighter=True)
0
834706423ac1 initial
dwinter
parents:
diff changeset
433
10
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
434
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
435 if sorting is not None:
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
436 for sort in sorting:
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
437 res=res.sort_by(sort);
0
834706423ac1 initial
dwinter
parents:
diff changeset
438 return res
834706423ac1 initial
dwinter
parents:
diff changeset
439
834706423ac1 initial
dwinter
parents:
diff changeset
440
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
441 def replaceParameter(self,paramsNeu,queryString,ignore=[]):
10733d367831 date ranges
dwinter
parents: 3
diff changeset
442 params=urlparse.parse_qs(queryString);
10733d367831 date ranges
dwinter
parents: 3
diff changeset
443
10733d367831 date ranges
dwinter
parents: 3
diff changeset
444 for key in paramsNeu.keys():
10733d367831 date ranges
dwinter
parents: 3
diff changeset
445
10733d367831 date ranges
dwinter
parents: 3
diff changeset
446 params[key]=paramsNeu[key]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
447
10733d367831 date ranges
dwinter
parents: 3
diff changeset
448 for key in ignore:
10733d367831 date ranges
dwinter
parents: 3
diff changeset
449 del params[key]
10733d367831 date ranges
dwinter
parents: 3
diff changeset
450
10733d367831 date ranges
dwinter
parents: 3
diff changeset
451 retArray = []
10733d367831 date ranges
dwinter
parents: 3
diff changeset
452 for x in params.keys():
10733d367831 date ranges
dwinter
parents: 3
diff changeset
453 for y in self.getList(params[x]):
10733d367831 date ranges
dwinter
parents: 3
diff changeset
454 retArray.append("%s=%s"%(x,urllib.quote(y)))
10733d367831 date ranges
dwinter
parents: 3
diff changeset
455
10733d367831 date ranges
dwinter
parents: 3
diff changeset
456 print retArray
10733d367831 date ranges
dwinter
parents: 3
diff changeset
457 return "&".join(retArray);
0
834706423ac1 initial
dwinter
parents:
diff changeset
458 #für die parameter @see prepareSearch
834706423ac1 initial
dwinter
parents:
diff changeset
459 #erzeugt eine Suchabfrage und führt diese aus.
834706423ac1 initial
dwinter
parents:
diff changeset
460 #return {"result":response.result, "hl":response.highlighting,"facetFields":facetedFields}
834706423ac1 initial
dwinter
parents:
diff changeset
461
10
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
462 def search(self,solrQuery,facetFields=[],start=0,rows=10,facetSearch=None,sortFacets=True,orSearch=None,facetFields_limit=None,trunc=False,sorting=None):
8
a8f16569d1a6 trunkierte suche als options
dwinter
parents: 7
diff changeset
463
a8f16569d1a6 trunkierte suche als options
dwinter
parents: 7
diff changeset
464
a8f16569d1a6 trunkierte suche als options
dwinter
parents: 7
diff changeset
465 print trunc
a8f16569d1a6 trunkierte suche als options
dwinter
parents: 7
diff changeset
466 if trunc:
a8f16569d1a6 trunkierte suche als options
dwinter
parents: 7
diff changeset
467 if not solrQuery.endswith("*"):
a8f16569d1a6 trunkierte suche als options
dwinter
parents: 7
diff changeset
468 solrQuery+="*"
0
834706423ac1 initial
dwinter
parents:
diff changeset
469
10
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
470 res=self.prepareSearch(solrQuery,facetFields,start,rows,facetSearch,sortFacets,orSearch=orSearch,sorting=sorting)
7
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
471 #response= res.execute()
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
472
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
473 opt = res.options();
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
474
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
475
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
476
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
477 if facetFields_limit:
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
478
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
479
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
480 for field,limit in facetFields_limit.items():
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
481 opt["f.%s.facet.limit"%field]=limit
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
482
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
483
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
484 response= self._v_solr.search( **opt)
3cb69c6820bd bug in query fixed for limits
dwinter
parents: 6
diff changeset
485
0
834706423ac1 initial
dwinter
parents:
diff changeset
486 #speichere faceted fields
834706423ac1 initial
dwinter
parents:
diff changeset
487 if len(facetFields)>0:
834706423ac1 initial
dwinter
parents:
diff changeset
488 facetedFields=response.facet_counts.facet_fields
834706423ac1 initial
dwinter
parents:
diff changeset
489
834706423ac1 initial
dwinter
parents:
diff changeset
490 if sortFacets:
834706423ac1 initial
dwinter
parents:
diff changeset
491 facetedFields=self.sortFacetedFields(facetedFields)
834706423ac1 initial
dwinter
parents:
diff changeset
492
834706423ac1 initial
dwinter
parents:
diff changeset
493 else:
834706423ac1 initial
dwinter
parents:
diff changeset
494 facetedFields={}
834706423ac1 initial
dwinter
parents:
diff changeset
495
834706423ac1 initial
dwinter
parents:
diff changeset
496
834706423ac1 initial
dwinter
parents:
diff changeset
497
834706423ac1 initial
dwinter
parents:
diff changeset
498
834706423ac1 initial
dwinter
parents:
diff changeset
499 return {"result":response.result, "hl":response.highlighting,"facetFields":facetedFields}
834706423ac1 initial
dwinter
parents:
diff changeset
500
834706423ac1 initial
dwinter
parents:
diff changeset
501
834706423ac1 initial
dwinter
parents:
diff changeset
502
10
74a9661e4e9f sorting added
dwinter
parents: 8
diff changeset
503 #hilfsmethode zum <eren über der ranges
0
834706423ac1 initial
dwinter
parents:
diff changeset
504 def sortRanges(self,ranges):
834706423ac1 initial
dwinter
parents:
diff changeset
505 x=list(ranges)
834706423ac1 initial
dwinter
parents:
diff changeset
506 x.sort()
834706423ac1 initial
dwinter
parents:
diff changeset
507 return x
834706423ac1 initial
dwinter
parents:
diff changeset
508
834706423ac1 initial
dwinter
parents:
diff changeset
509 #sortiert die Werte der FacetedFields
834706423ac1 initial
dwinter
parents:
diff changeset
510 #(facetedFields ist ein hast mit feldname -> liste der (wert für das feld, anzahl der treffer für den wert)
834706423ac1 initial
dwinter
parents:
diff changeset
511 #ausserdem werden die werte gemäß des angegebenen Filter gefiltert.
834706423ac1 initial
dwinter
parents:
diff changeset
512
834706423ac1 initial
dwinter
parents:
diff changeset
513 def sortFacetedFields(self, facetedFields,filter=STOPLIST):
834706423ac1 initial
dwinter
parents:
diff changeset
514 ret={}
834706423ac1 initial
dwinter
parents:
diff changeset
515
834706423ac1 initial
dwinter
parents:
diff changeset
516 def cmpTuple(x,y):
834706423ac1 initial
dwinter
parents:
diff changeset
517 return cmp(x[0],y[0])
834706423ac1 initial
dwinter
parents:
diff changeset
518
834706423ac1 initial
dwinter
parents:
diff changeset
519
834706423ac1 initial
dwinter
parents:
diff changeset
520 for key in facetedFields.keys():
834706423ac1 initial
dwinter
parents:
diff changeset
521 ls = facetedFields[key]
834706423ac1 initial
dwinter
parents:
diff changeset
522 ls.sort(cmpTuple)
834706423ac1 initial
dwinter
parents:
diff changeset
523 ret[key]=ls
834706423ac1 initial
dwinter
parents:
diff changeset
524
834706423ac1 initial
dwinter
parents:
diff changeset
525 if filter.get(key,None):
834706423ac1 initial
dwinter
parents:
diff changeset
526 ls2=[]
834706423ac1 initial
dwinter
parents:
diff changeset
527 for x in ls:
834706423ac1 initial
dwinter
parents:
diff changeset
528 if x[0].encode('utf-8') not in filter[key]:
834706423ac1 initial
dwinter
parents:
diff changeset
529 ls2.append(x)
834706423ac1 initial
dwinter
parents:
diff changeset
530 ret[key]=ls2
834706423ac1 initial
dwinter
parents:
diff changeset
531
834706423ac1 initial
dwinter
parents:
diff changeset
532
834706423ac1 initial
dwinter
parents:
diff changeset
533 ret[key]=[x for x in ret[key] if x[1]!=0]
834706423ac1 initial
dwinter
parents:
diff changeset
534 return ret
834706423ac1 initial
dwinter
parents:
diff changeset
535
834706423ac1 initial
dwinter
parents:
diff changeset
536 def changeMain(self,solrURL=None,title=None,REQUEST=None,RESPONSE=None):
834706423ac1 initial
dwinter
parents:
diff changeset
537 """change main settings"""
834706423ac1 initial
dwinter
parents:
diff changeset
538 if solrURL:
834706423ac1 initial
dwinter
parents:
diff changeset
539 self.solrURL=solrURL
834706423ac1 initial
dwinter
parents:
diff changeset
540 self.title=title
834706423ac1 initial
dwinter
parents:
diff changeset
541 self._v_solr=sunburnt.SolrInterface(url=solrURL)
834706423ac1 initial
dwinter
parents:
diff changeset
542
834706423ac1 initial
dwinter
parents:
diff changeset
543 if RESPONSE is not None:
834706423ac1 initial
dwinter
parents:
diff changeset
544 RESPONSE.redirect('manage_main')
834706423ac1 initial
dwinter
parents:
diff changeset
545
834706423ac1 initial
dwinter
parents:
diff changeset
546
834706423ac1 initial
dwinter
parents:
diff changeset
547 else:
834706423ac1 initial
dwinter
parents:
diff changeset
548 pt=zptFile(self, 'zpt/ChangeZopeSolr.zpt')
834706423ac1 initial
dwinter
parents:
diff changeset
549 return pt()
834706423ac1 initial
dwinter
parents:
diff changeset
550
834706423ac1 initial
dwinter
parents:
diff changeset
551 #sucht die je nach einsteillung in solrconfig.xml Werte mit den häufigsten Treffern oder alphabetisch sortiert zu einem
834706423ac1 initial
dwinter
parents:
diff changeset
552 #bestimmten eintrag aus solr
834706423ac1 initial
dwinter
parents:
diff changeset
553 #gedacht ist die methoden für die Anwendung nach dem Harvesten einer Website, es wird daher davon ausgegangen, dass sie hinter der
834706423ac1 initial
dwinter
parents:
diff changeset
554 #idfield eine url steht. Wir es z.b. bei Nutch passiert. index.htm/index_html als Teil der url wird dabei unterdrückt (analog zu den harbest einstellunge für
834706423ac1 initial
dwinter
parents:
diff changeset
555 # nutch für zope webseiten.
834706423ac1 initial
dwinter
parents:
diff changeset
556 #@param @idfield is hierbei der Name des Feldes, das in solrschema als id defniert wurde
834706423ac1 initial
dwinter
parents:
diff changeset
557 #field der Feldname von dem die Treffer gesurcht wernde sollen
834706423ac1 initial
dwinter
parents:
diff changeset
558 #url die url des textes
834706423ac1 initial
dwinter
parents:
diff changeset
559
834706423ac1 initial
dwinter
parents:
diff changeset
560 def getTermsAsJSON(self,idfield,field,url):
834706423ac1 initial
dwinter
parents:
diff changeset
561 """getTerms"""
834706423ac1 initial
dwinter
parents:
diff changeset
562
834706423ac1 initial
dwinter
parents:
diff changeset
563 ret=[]
834706423ac1 initial
dwinter
parents:
diff changeset
564 h = httplib2.Http()
834706423ac1 initial
dwinter
parents:
diff changeset
565 url = url.replace("/index.html","").replace("/index_html","")
834706423ac1 initial
dwinter
parents:
diff changeset
566 if url[-1]=="/":
834706423ac1 initial
dwinter
parents:
diff changeset
567 url=url[0:-1]
834706423ac1 initial
dwinter
parents:
diff changeset
568
834706423ac1 initial
dwinter
parents:
diff changeset
569 urlq=url.replace(":","\:")
834706423ac1 initial
dwinter
parents:
diff changeset
570 urlq=urlq.replace("/","\/")
834706423ac1 initial
dwinter
parents:
diff changeset
571
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
572 #q ="http://localhost:8983/solr/mpiwgweb/select?q=%s:%s&wt=xml&tv=on&qt=tvrh&fl=%s&tv.tf=true"%(idfield,urlq,field)
10733d367831 date ranges
dwinter
parents: 3
diff changeset
573 q =self.solrURL+SOLRSERVER%(idfield,urlq,field)
0
834706423ac1 initial
dwinter
parents:
diff changeset
574
834706423ac1 initial
dwinter
parents:
diff changeset
575 resp, content = h.request(q)
834706423ac1 initial
dwinter
parents:
diff changeset
576
834706423ac1 initial
dwinter
parents:
diff changeset
577 root = ET.fromstring(content)
834706423ac1 initial
dwinter
parents:
diff changeset
578 #uri = "http://127.0.0.1:18080/www_neu/de/aktuelles/features/feature28"
834706423ac1 initial
dwinter
parents:
diff changeset
579
834706423ac1 initial
dwinter
parents:
diff changeset
580 xpstr = ".//lst[@name='termVectors']/lst[@name='%s']/lst[@name='%s']/lst"%(url,field)
834706423ac1 initial
dwinter
parents:
diff changeset
581
834706423ac1 initial
dwinter
parents:
diff changeset
582
834706423ac1 initial
dwinter
parents:
diff changeset
583 tvs = root.findall(xpstr)
834706423ac1 initial
dwinter
parents:
diff changeset
584
834706423ac1 initial
dwinter
parents:
diff changeset
585 for tv in tvs:
834706423ac1 initial
dwinter
parents:
diff changeset
586 wd = tv.attrib['name']
834706423ac1 initial
dwinter
parents:
diff changeset
587 for f in tv.findall("./int[@name='tf']"):
834706423ac1 initial
dwinter
parents:
diff changeset
588 fre = f.text
834706423ac1 initial
dwinter
parents:
diff changeset
589
834706423ac1 initial
dwinter
parents:
diff changeset
590
834706423ac1 initial
dwinter
parents:
diff changeset
591 if int(fre)>2:
834706423ac1 initial
dwinter
parents:
diff changeset
592
834706423ac1 initial
dwinter
parents:
diff changeset
593 ret.append('{"text":"%s","size":%s}'%(wd,fre))
834706423ac1 initial
dwinter
parents:
diff changeset
594
834706423ac1 initial
dwinter
parents:
diff changeset
595 retStr="["+",".join(ret)+"]"
834706423ac1 initial
dwinter
parents:
diff changeset
596
834706423ac1 initial
dwinter
parents:
diff changeset
597 return retStr
834706423ac1 initial
dwinter
parents:
diff changeset
598
834706423ac1 initial
dwinter
parents:
diff changeset
599 #tauscht im request die in neewparams angegeben parameter aus.
834706423ac1 initial
dwinter
parents:
diff changeset
600 def replaceParam(self, newparams):
834706423ac1 initial
dwinter
parents:
diff changeset
601 x = self.REQUEST.form.copy()
834706423ac1 initial
dwinter
parents:
diff changeset
602
834706423ac1 initial
dwinter
parents:
diff changeset
603 for key,value in newparams.items():
834706423ac1 initial
dwinter
parents:
diff changeset
604 x[key]=value
834706423ac1 initial
dwinter
parents:
diff changeset
605
834706423ac1 initial
dwinter
parents:
diff changeset
606
834706423ac1 initial
dwinter
parents:
diff changeset
607 retls=[]
834706423ac1 initial
dwinter
parents:
diff changeset
608 for k,v in x.items():
834706423ac1 initial
dwinter
parents:
diff changeset
609 if not isinstance(v,basestring):
834706423ac1 initial
dwinter
parents:
diff changeset
610 for y in v:
834706423ac1 initial
dwinter
parents:
diff changeset
611 retls.append((k,y))
834706423ac1 initial
dwinter
parents:
diff changeset
612 else:
834706423ac1 initial
dwinter
parents:
diff changeset
613 retls.append((k,v))
834706423ac1 initial
dwinter
parents:
diff changeset
614
834706423ac1 initial
dwinter
parents:
diff changeset
615 return "?"+"&".join(["%s=%s"%(k,urllib.quote_plus(v,'/')) for (k, v) in retls])
834706423ac1 initial
dwinter
parents:
diff changeset
616
834706423ac1 initial
dwinter
parents:
diff changeset
617
834706423ac1 initial
dwinter
parents:
diff changeset
618
834706423ac1 initial
dwinter
parents:
diff changeset
619
834706423ac1 initial
dwinter
parents:
diff changeset
620 #ruft @set ranges aus, gibt das ergebnis als json zurück
834706423ac1 initial
dwinter
parents:
diff changeset
621 def getRangesAsJSON(self,field,begin,end,increment):
834706423ac1 initial
dwinter
parents:
diff changeset
622 """ getRangesAsJSON"""
834706423ac1 initial
dwinter
parents:
diff changeset
623 res = self.ranges(field, int(begin), int(end), int(increment))
834706423ac1 initial
dwinter
parents:
diff changeset
624 return json.dumps(res)
834706423ac1 initial
dwinter
parents:
diff changeset
625
834706423ac1 initial
dwinter
parents:
diff changeset
626
834706423ac1 initial
dwinter
parents:
diff changeset
627 #return only the values of resultList whicht start with startLetter or if starLetterNonAscii all values which
834706423ac1 initial
dwinter
parents:
diff changeset
628 #start with an non ascii character
834706423ac1 initial
dwinter
parents:
diff changeset
629 def filter (self,resultList,startLetter=None,startLetterNonAscii=0):
1
9c356845613a improvements for the search or search fields added
dwinter
parents: 0
diff changeset
630 ls=[]
0
834706423ac1 initial
dwinter
parents:
diff changeset
631 if startLetter:
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
632 startLetter=startLetter.lower()
0
834706423ac1 initial
dwinter
parents:
diff changeset
633
834706423ac1 initial
dwinter
parents:
diff changeset
634 matchStr = "[\[\]'\"]*"+startLetter
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
635 ls = [x for x in resultList if re.match(matchStr,x[0].lower())]
0
834706423ac1 initial
dwinter
parents:
diff changeset
636
834706423ac1 initial
dwinter
parents:
diff changeset
637 if startLetterNonAscii ==1:
834706423ac1 initial
dwinter
parents:
diff changeset
638
834706423ac1 initial
dwinter
parents:
diff changeset
639 ls = [x for x in resultList if not re.match("[\[\]'\"a-zA-Z].*",x[0])]
834706423ac1 initial
dwinter
parents:
diff changeset
640 return ls
834706423ac1 initial
dwinter
parents:
diff changeset
641
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
642
10733d367831 date ranges
dwinter
parents: 3
diff changeset
643
0
834706423ac1 initial
dwinter
parents:
diff changeset
644 def manage_addZopeSolrForm(self):
834706423ac1 initial
dwinter
parents:
diff changeset
645 """Form for external Links"""
834706423ac1 initial
dwinter
parents:
diff changeset
646 pt=zptFile(self, 'zpt/AddZopeSolr.zpt')
834706423ac1 initial
dwinter
parents:
diff changeset
647 return pt()
834706423ac1 initial
dwinter
parents:
diff changeset
648
834706423ac1 initial
dwinter
parents:
diff changeset
649
834706423ac1 initial
dwinter
parents:
diff changeset
650 def manage_addZopeSolr(self,id,title,solrURL,RESPONSE=None):
834706423ac1 initial
dwinter
parents:
diff changeset
651 """Add an external Link"""
834706423ac1 initial
dwinter
parents:
diff changeset
652
834706423ac1 initial
dwinter
parents:
diff changeset
653 newObj=ZopeSolr(id,title,solrURL)
834706423ac1 initial
dwinter
parents:
diff changeset
654
834706423ac1 initial
dwinter
parents:
diff changeset
655 self._setObject(id,newObj)
834706423ac1 initial
dwinter
parents:
diff changeset
656
834706423ac1 initial
dwinter
parents:
diff changeset
657
834706423ac1 initial
dwinter
parents:
diff changeset
658 if RESPONSE is not None:
834706423ac1 initial
dwinter
parents:
diff changeset
659 RESPONSE.redirect('manage_main')
4
10733d367831 date ranges
dwinter
parents: 3
diff changeset
660