def getByOrigin(self, originId, providerId, isEnglish):
if originId and providerId and isEnglish:
sql = (
"select id,title,content,origin_id,provider_id,isEnglish,ex_expert_question_id,update_time from ex_expert_answers where origin_id='%s' and provider_id=%s and isEnglish='%s';"
% (originId, providerId, isEnglish)
)
try:
self.cursor_stg.execute(sql)
row = self.cursor_stg.fetchone()
if row:
article = Article()
article.id = row[0]
article.title = row[1]
article.content = row[2]
article.originId = row[3]
article.providerId = row[4]
article.isEnglish = row[5]
article.questionId = row[6]
article.proDate = row[7]
article.contentType = Article.CONTENT_TYPE_MODULEQA
return article
else:
raise Exception(
"No question answer with origin id:%s,provider id:%s,isEnglish:%s was found"
% (originId, providerId, isEnglish)
)
except Exception, e:
self.log.error(e)
self.log.error(sql)
def getAll(self):
sql = """
select id,title,content,origin_id,provider_id,isEnglish,ex_expert_question_id from ex_expert_answers where isEnglish='Y' and is_display=1
"""
try:
self.cursor_stg.execute(sql)
for row in self.cursor_stg.fetchall():
article = Article()
article.id = row[0]
article.title = row[1]
article.content = row[2]
article.originId = row[3]
article.providerId = row[4]
article.isEnglish = row[5]
article.questionId = row[6]
article.contentType = Article.CONTENT_TYPE_MODULEQA
yield article
except Exception, e:
self.log.error(e)
self.log.error(sql)
self.log.error("Exception occured in getAll() of ModuleQADAO.py")
