summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDennis Kobert <dennis@kobert.dev>2020-03-02 17:48:55 +0100
committerDennis Kobert <dennis@kobert.dev>2020-03-02 17:48:55 +0100
commitaee5ff0b295b3af68dfd0b78643ab5b7f41429a7 (patch)
tree60976212c9fce022799aaa4e7ae9ea8021a8cc1a
parent2960453939aec628556579fb07553e9f7157cf38 (diff)
send ids
-rw-r--r--src/serve.rs7
1 files 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()
{