From aee5ff0b295b3af68dfd0b78643ab5b7f41429a7 Mon Sep 17 00:00:00 2001
From: Dennis Kobert <dennis@kobert.dev>
Date: Mon, 2 Mar 2020 17:48:55 +0100
Subject: send ids

---
 src/serve.rs | 7 +++----
 1 file changed, 3 insertions(+), 4 deletions(-)

diff --git a/src/serve.rs b/src/serve.rs
index d2794f8..95ce9b1 100644
--- a/src/serve.rs
+++ b/src/serve.rs
@@ -204,9 +204,8 @@ pub fn match_users(name1: String, name2: String) -> Result<String, status::NotFo
 			
 			        ($1), ($2)
 			
-			    ) AS _ (user_name)
+			    ) AS _ (user_id)
 			)
-			--SELECT track_id, SUM(score) / (SELECT COUNT(*) FROM users) AS score
 			SELECT track_id, name, artist
 			FROM track
 			JOIN (
@@ -214,14 +213,14 @@ pub fn match_users(name1: String, name2: String) -> Result<String, status::NotFo
 			FROM user_track
 			JOIN suser USING (user_id)
 			JOIN track USING (track_id)
-			WHERE suser.user_name IN (SELECT * FROM users)
+			WHERE suser.user_id IN (SELECT * FROM users)
 			GROUP BY track_id
 			HAVING COUNT(track_id) = (SELECT COUNT(*) FROM users)
 			ORDER BY SUM(score) DESC
 			) AS _ USING (track_id)
 			;
             ",
-            &[name1.as_ref(), name2.as_ref()],
+            &[&uid1, &uid2],
         )
         .unwrap()
     {
-- 
cgit v1.2.3