From abe3fdc85df13a0287db56e614617a65c1ddff2c Mon Sep 17 00:00:00 2001 From: Rasmus Steinke Date: Mon, 25 Aug 2014 01:14:56 +0200 Subject: first try of fixing on updates --- clerk | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) (limited to 'clerk') diff --git a/clerk b/clerk index 1e73b70..37e34f0 100644 --- a/clerk +++ b/clerk @@ -198,8 +198,11 @@ ratingPrompt () { updateDB () { cd $HOME/.config/clerk/ratings - rm -f ../ratings.db - sqlite3 ../ratings.db < /usr/share/doc/clerk/create_rating.sql + if [[ -a ../ratings.db ]]; then + echo "database exists. using it" + else + sqlite3 ../ratings.db < /usr/share/doc/clerk/create_rating.sql + fi for line in *.ratings; do artist=$(grep "^artist=" "$line" | cut -d '=' -f2- ) date=$(grep "^date=" "$line" | cut -d '=' -f2-) @@ -214,7 +217,8 @@ updateDB () { album=${album//\'/\\\'} directory=${directory//\'/\\\'} rating=${rating//\'/\\\'} - sqlite3 ../ratings.db "insert into albums (date, artist, album, directory, rating) values ('$date', '$artist', '$album', '$directory', '$rating')" + sqlite3 ../ratings.db "insert or replace into albums (date, artist, album, directory, rating) values ('$date', '$artist', '$album', '$directory', '$rating')" + #sqlite3 ../ratings.db "insert into albums (date, artist, album, directory, rating) values ('$date', '$artist', '$album', '$directory', '$rating')" done done for line in *.ratings; do -- cgit v1.2.3-24-g4f1b