def global_search_content(self, user_id: str, search_info: str, page: int): try: # 判断是否存在用户 id # 判断是否存在用户 id if not self.user_id_exist(user_id): return error.error_non_exist_user_id_when_search(user_id) # 查询 # # 先找出这家店的book_id cursor = self.conn.cursor() query = "SELECT DISTINCT book_id FROM \"store\" " # global 的时候去掉where cursor.execute(query) book_id = [] rows = cursor.fetchall() for row in rows: book_id.append(row[0]) _content_search = search.Search(search_info, page, book_id) # 实例化一个search类 book_list = _content_search.search_bookid_content( ) # !!!!!调用函数,得到返回结果 返回得到相关列表 if len(book_list) == 0: return error.error_page_out_of_range(user_id) except (Exception, psycopg2.DatabaseError) as e: logging.info("528, {}".format(str(e))) return 528, "{}".format(str(e)), " " except BaseException as e: logging.info("530, {}".format(str(e))) return 530, "{}".format(str(e)), " " return 200, "ok", book_list
def global_search_tag(self, user_id: str, search_info: str, page: int): try: # 判断是否存在用户 id if not self.user_id_exist(user_id): return error.error_non_exist_user_id_when_search(user_id) # 进行查询 cursor = self.conn.cursor() # query = cursor.execute("SELECT DISTINCT book_id FROM \"store\" ") book_id = [] rows = cursor.fetchall() for row in rows: book_id.append(row[0]) title_search = search.Search(search_info, page, book_id) # 考虑到用户会输入多个 tag 的情况,选出覆盖全部 tag 的 bookid tag_search = search_info.split(" ") # 获得用户输入的多个 tag book_list = title_search.search_bookid_tag(tag_search) if len(book_list) == 0: return error.error_page_out_of_range(user_id) except (Exception, psycopg2.DatabaseError) as e: logging.info("528, {}".format(str(e))) return 528, "{}".format(str(e)), " " except BaseException as e: logging.info("530, {}".format(str(e))) return 530, "{}".format(str(e)), " " return 200, "ok", book_list
def store_search_book_intro(self, user_id: str, store_id: str, search_info: str, page: int): try: # 判断是否存在用户 id if not self.user_id_exist(user_id): return error.error_non_exist_user_id_when_search(user_id) # 查询 ## 先找出这家店的book_id cursor = self.conn.cursor() # query = #global 的时候去掉where cursor.execute( "SELECT DISTINCT book_id FROM \"store\" WHERE store_id = %s", (store_id, )) book_id = [] rows = cursor.fetchall() for row in rows: book_id.append(row[0]) book_intro_search = search.Search(search_info, page, book_id) #实例化一个search类 book_list = book_intro_search.search_bookid_book_intro( ) # !!!!!调用函数,得到返回结果 if len(book_list) == 0: return error.error_page_out_of_range(user_id) except (Exception, psycopg2.DatabaseError) as e: logging.log(logging.CRITICAL, "*****" + store_id + "*******") traceback.print_exc() logging.info("528, {}".format(str(e))) return 528, "{}".format(str(e)), " " except BaseException as e: logging.info("530, {}".format(str(e))) return 530, "{}".format(str(e)), " " return 200, "ok", book_list
def get_store_id(self, user_id: str, book_id): try: # 判断是否存在用户 id if not self.user_id_exist(user_id): return error.error_non_exist_user_id_when_search(user_id) cursor = self.conn.cursor() cursor.execute( "SELECT DISTINCT store_id FROM \"store\" WHERE book_id = (%s)", (book_id, )) rows = cursor.fetchall() store_id_list = "" #store_id_list = [] for row in rows: store_id_list = store_id_list + " " + row[0] #store_id_list.append(row[0]) return 200, "ok", store_id_list except (Exception, psycopg2.DatabaseError) as e: logging.info("528, {}".format(str(e))) return 528, "{}".format(str(e)), "" except BaseException as e: logging.info("530, {}".format(str(e))) return 530, "{}".format(str(e)), ""