def author(self, text):
s = '''fuzzy(lng) LIKE ? ESCAPE "|"'''
text = asm_araby.fuzzy(text)
self.search_tokens = asm_araby.tokenize_search(text)
l = list(map(lambda s: '%'+s.replace('|', '||').replace('%', '|%')+'%', self.search_tokens))
if len(l) < 1: return []
condition = ' AND '.join([s]*len(l))
self.cur.execute("""SELECT authid, auth FROM auth WHERE {}""".format(condition), l)
authors = self.cur.fetchall()
return authors
def tardjma(self, text):
s = '''fuzzy(name) LIKE ? ESCAPE "|"'''
text = asm_araby.fuzzy(text)
self.search_tokens = asm_araby.tokenize_search(text)
l = list(map(lambda s: '%'+s.replace('|', '||').replace('%', '|%')+'%', self.search_tokens))
if len(l) < 1: return []
condition = ' AND '.join([s]*len(l))
self.cur.execute("""SELECT id, name FROM rewat WHERE {}""".format(condition), l)
tarjama = self.cur.fetchall()
return tarjama
def search(self, text):
s = '''fuzzy(imlai) LIKE ? ESCAPE "|"'''
text=asm_araby.fuzzy(text)
self.search_tokens=asm_araby.tokenize_search(text)
l = list(map(lambda s: '%'+s.replace('|', '||').replace('%', '|%')+'%', self.search_tokens))
if len(l) < 1: return []
condition = ' AND '.join([s]*len(l))
self.cur.execute("""SELECT sura, aya, page, othmani, imlai, id_binary FROM Quran WHERE {} LIMIT 50""".format(condition, ), l)
ayat = self.cur.fetchall()
return ayat
def search_on_active(self, text):
if text == '': return
self.store_search.clear()
self.scroll_index.hide()
self.scroll_search.show_all()
phrase = '''fuzzy(nass) LIKE ? ESCAPE "|"'''
text = asm_araby.fuzzy(text)
self.search_tokens = asm_araby.tokenize_search(text)
phrase2 = list(map(lambda phrase: '%'+phrase.replace('|','||').replace('%','|%')+'%', self.search_tokens))
if len(phrase2) < 1: return []
condition = ' AND '.join([phrase]*len(phrase2))
self.db.search(text, self.store_search, condition, phrase2)
if len(self.store_search) == 0:
self.hide_search()
asm_customs.erro(self.parent, 'لا يوجد نتائج')
return
self.hp.set_position(200)
