summaryrefslogtreecommitdiffstats
path: root/clerk
diff options
context:
space:
mode:
Diffstat (limited to 'clerk')
-rw-r--r--clerk2
1 files changed, 1 insertions, 1 deletions
diff --git a/clerk b/clerk
index da650b4..0f0c1a8 100644
--- a/clerk
+++ b/clerk
@@ -237,7 +237,7 @@ updateDB () {
directory=${directory//\'/\\\'}
title=${title//\'\\\'}
rating=${rating//\'/\\\'}
- sqlite3 ../ratings.db "insert into tracks (date, artist, album, directory, rating) values ('$date', '$artist', '$album', '$directory/$title', '$rating')"
+ sqlite3 ../ratings.db "insert or replace into tracks (date, artist, album, directory, rating) values ('$date', '$artist', '$album', '$directory/$title', '$rating')"
done
done
ratingPrompt