Implementing user combination gathering in SQL.

1 files changed, 12 insertions, 0 deletions

diff --git a/db/analyse.py b/db/analyse.py
index 612f637..c958cc1 100644
--- a/db/analyse.py
+++ b/db/analyse.py
@@ -38,3 +38,15 @@ class DBAnalyse:
             } ).scalar()
         
         
+    def combinations(self, quiz_id):
+        sql = "SELECT u1.id, u2.id \
+                FROM questionaires quiz \
+                JOIN answers a1 ON a1.question_id = quiz.questionset[1] \
+                JOIN answers a2 ON a2.question_id = quiz.questionset[1] \
+                JOIN users u1 ON u1.id = a1.user_id \
+                JOIN users u2 ON u2.id = a2.user_id \
+                WHERE quiz.id = (:quiz_id) AND u1.id > u2.id;"
+        return self.db.session.execute( text(sql), { 
+                'quiz_id': quiz_id
+                } ).fetchall()
+