From 477410a6c033a0cbd8b07fae123a1e9386488ba6 Mon Sep 17 00:00:00 2001
From: Jesse Antti Matikainen <jmatikai@local>
Date: Sun, 3 Dec 2023 14:48:30 +0200
Subject: Implementing user combination gathering in SQL.

---
 db/analyse.py | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'db')

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()
+
-- 
cgit v1.2.3