summaryrefslogtreecommitdiffstats
path: root/clerk
diff options
context:
space:
mode:
authorRasmus Steinke <rasi@xssn.at>2014-08-25 01:46:34 +0200
committerRasmus Steinke <rasi@xssn.at>2014-08-25 01:46:34 +0200
commit7eb9a074e544186c2889b5880e1521b9c9e03fc0 (patch)
treee538aaa1d54d2254e8940a8bf8d52d275552c961 /clerk
parent5546d6bc6a2fe5661b8525a98355e1dc07ef60b8 (diff)
downloadperl-app-clerk-7eb9a074e544186c2889b5880e1521b9c9e03fc0.tar.gz
perl-app-clerk-7eb9a074e544186c2889b5880e1521b9c9e03fc0.tar.xz
fix for duplicates
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