Advertisement
Daniel_leinaD

3

Mar 4th, 2023
222
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. def get_question_after(question_id = 0, quiz_id=1):
  2. ''' возвращает следующий вопрос после вопроса с переданным id
  3. для первого вопроса передаётся значение по умолчанию '''
  4. open()
  5. query = '''
  6. SELECT quiz_content.id, question.question, question.answer, question.wrong1, question.wrong2, question.wrong3
  7. FROM question, quiz_content
  8. WHERE quiz_content.question_id == question.id
  9. AND quiz_content.id > ? AND quiz_content.quiz_id == ?
  10. ORDER BY quiz_content.id '''
  11. cursor.execute(query, [question_id, quiz_id] )
  12. result = cursor.fetchone()
  13. close()
  14. return result
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement