From b9606de0d8801f37edb289ad3733b96e557dea3e Mon Sep 17 00:00:00 2001
From: Dennis Kobert <dennis@kobert.dev>
Date: Tue, 11 Feb 2020 21:47:40 +0000
Subject: Fix result query

---
 src/serve.rs | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/src/serve.rs b/src/serve.rs
index 7c15b03..bc13b86 100644
--- a/src/serve.rs
+++ b/src/serve.rs
@@ -34,6 +34,9 @@ pub fn get_tracks(name: String, url: String) -> String {
         )
         .unwrap();
     let uid = get_uid(user_id.as_ref(), &mut client);
+    client
+    .execute("DELETE FROM user_track WHERE user_id = $1;", &[&uid])
+    .unwrap();
     drop(client);
     let chunk_size = 50;
     let mut playlist_index = 0;
@@ -184,10 +187,11 @@ pub fn match_users(name1: String, name2: String) -> Result<String, status::Custo
         let tid: i32 = row.get(0);
         let song = &client
             .query(
-                "SELECT name artist popularity FROM track where track_id = $1",
+                "SELECT name, artist FROM track where track_id = $1",
                 &[&tid],
             )
             .unwrap()[0];
+        println!("{:?}", song.columns());
         let name: String = song.get(0);
         let artist: String = song.get(1);
         songs = format!("{}{} by {}\n", songs, name, artist);
-- 
cgit v1.2.3-54-g00ecf