Initial anwsering form and related

1 files changed, 11 insertions, 0 deletions

diff --git a/db_actions.py b/db_actions.py
index b604870..5a76b00 100644
--- a/db_actions.py
+++ b/db_actions.py
@@ -85,4 +85,15 @@ def get_questions(quiz_id):
             WHERE a.question_id = q.id AND quiz.id = (:quiz_id);"
     return db.session.execute( text(sql), { "quiz_id":quiz_id } ).fetchall()
 
+
+def get_user_answer(user_id, question_id):
+    sql = "SELECT answer \
+            FROM answers \
+            WHERE question_id = (:question_id)  AND user_id = (:user_id);"
+    result = db.session.execute( text(sql), { 
+            'question_id': question_id,
+            'user_id': user_id 
+            } ).fetchone()
+    return result[0] if result else result
+
     
\ No newline at end of file