+ def search(self,dbname):
+ table = self.application.db.table(dbname)
+ element = self.word.split()
+ if len(element) == 0:
+ element = ['']
+ while len(element) < 3:
+ element.append(element[0])
+ if self.radiobox == 'comment':
+ query = (Query().raw.search(element[0])) | (Query().raw.search(element[1])) | (Query().raw.search(element[2]))
+ else:
+ query = (Query().name == element[0]) | (Query().name == element[1]) | (Query().name == element[2])
+ if self.radiobox == 'comment':
+ for x in table.search(query):
+ com = ''
+ for text in x['raw'].splitlines(True):
+ for word in self.word.split():
+ if text.find(word) > -1:
+ com = com +'<p style=background-color:yellow>'+text+'<br></p>'
+ break
+ else:
+ com = com+'<p>'+text+'<br></p>'
+ x['comment'] = com
+ yield x
+ else:
+ for x in table.search(query):
+ yield x
+