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)