def _updateQuestionStatistics(self, ztm):
self.update('question_count', Question.select().count())
ztm.commit()
self.update(
'answered_question_count',
Question.select(
'status = %s' % sqlvalues(QuestionStatus.ANSWERED)).count())
ztm.commit()
self.update(
'solved_question_count',
Question.select(
'status = %s' % sqlvalues(QuestionStatus.SOLVED)).count())
ztm.commit()
cur = cursor()
cur.execute(
"SELECT COUNT(DISTINCT product) + COUNT(DISTINCT distribution) "
"FROM Question")
self.update("projects_with_questions_count", cur.fetchone()[0] or 0)
ztm.commit()
def _updateQuestionStatistics(self, ztm):
self.update('question_count', Question.select().count())
ztm.commit()
self.update(
'answered_question_count',
Question.select(
'status = %s' % sqlvalues(QuestionStatus.ANSWERED)).count())
ztm.commit()
self.update(
'solved_question_count',
Question.select(
'status = %s' % sqlvalues(QuestionStatus.SOLVED)).count())
ztm.commit()
cur = cursor()
cur.execute(
"SELECT COUNT(DISTINCT product) + COUNT(DISTINCT distribution) "
"FROM Question")
self.update("projects_with_questions_count", cur.fetchone()[0] or 0)
ztm.commit()
