def query_question_list(self, question_id_list): raw_question_list = DB.query_all( u'select * from Question where question_id in ({question_id_list})'.format(question_id_list=','.join(question_id_list))) question_list = [] for raw_question in raw_question_list: question_list.append(self.format_question(raw_question)) return question_list
def query_answer_list_by_question_id(self, question_id): raw_answer_list = DB.query_all( u'select * from Answer where question_id="{question_id}" {order_by} '.format(question_id=question_id, order_by=Config.answer_order_by)) answer_list = [] for raw_answer in raw_answer_list: answer_list.append(self.format_answer(raw_answer)) return answer_list
def query_article_list_by_column_id(self, column_id): # 根据发表时间正序获取文章列表,方便浏览 raw_article_list = DB.query_all(u'select * from Article where column_id="{column_id}" {order_by}'.format(column_id=column_id, order_by=Config.article_order_by)) article_list = [] for raw_article in raw_article_list: article = self.format_article(raw_article) article_list.append(article) return article_list
def query_article_list_by_column_id(self, column_id): # 根据发表时间正序获取文章列表,方便浏览 print u'select * from Article where column_id = "{column_id}" {order_by}'.format(column_id=column_id, order_by=Config.article_order_by) raw_article_list = DB.query_all(u'select * from Article where column_id = "{column_id}" {order_by}'.format(column_id=column_id, order_by=Config.article_order_by)) article_list = [] for raw_article in raw_article_list: article = self.format_article(raw_article) article_list.append(article) return article_list
def query_answer_list_by_author_page_id(self, author_page_id): # 需要先查出来对应的author_id author_info = DB.query_row(u'select author_id from Author where author_page_id="{author_page_id}"'.format(author_page_id=author_page_id)) author_id = author_info[u'author_id'] raw_answer_list = DB.query_all(u'select * from Answer where author_id="{author_id}" {order_by} '.format(author_id=author_id, order_by=Config.answer_order_by)) answer_list = [] for raw_answer in raw_answer_list: answer_list.append(self.format_answer(raw_answer)) return answer_list
def query_answer_list(self, answer_id_list): raw_answer_list = DB.query_all(u'select * from Answer where answer_id in ({answer_id_list}) {order_by} '.format(answer_id_list=','.join(answer_id_list), order_by=Config.topic_or_collection_answer_order_by)) answer_list = [] for raw_answer in raw_answer_list: answer_list.append(self.format_answer(raw_answer)) return answer_list