From 90c3eba635f31472ca4fb5ebec5910a41221dbbf Mon Sep 17 00:00:00 2001
From: lshprung <lshprung@yahoo.com>
Date: Sun, 26 Sep 2021 16:58:31 -0700
Subject: Added debug mode, fixed bug in checking for duplicate files

---
 build_db.plx | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'build_db.plx')

diff --git a/build_db.plx b/build_db.plx
index 1b01b58..4f5bcad 100755
--- a/build_db.plx
+++ b/build_db.plx
@@ -23,6 +23,7 @@ our %extensions;
 # Keep track of options that have been set
 our %options = (
 	append => 0,
+	debug  => 0,
 	output => 0,
 	quiet  => 0
 );
@@ -98,6 +99,7 @@ Generate a database for audio files in DIRECTORY (by default ~/Music).
 
 Options:
   -a, --append			append to database file, instead of overwriting it
+  -d, --debug           print additional output for debugging purposes
   -e, --extension EXTENSIONS	Set file extensions to look for, separated by commas (default is flac,mp3,ogg)
   -h, --help			display this help and exit
   -o, --output FILE		specify output file for database (default is library.db at the root of DIRECTORY)
@@ -113,6 +115,10 @@ for (my $i = 0; $i <= $#ARGV; $i++){
 		$options{append} = 1;
 	}
 
+	if ($ARGV[$i] =~ /-d|--debug/){
+		$options{debug} = 1;
+	}
+
 	elsif ($ARGV[$i] =~ /-e|--extension/){
 		$i++;
 		$extensions_list = $ARGV[$i];
@@ -231,7 +237,7 @@ $statement = "INSERT INTO $table_name(PATH)
 VALUES";
 for my $file (@file_list){
 	# Skip existing files
-	@db_output = flatten_array(db_cmd($dbh, "SELECT count(*) FROM $table_name WHERE PATH='$file';"));
+	@db_output = flatten_array(db_cmd($dbh, "SELECT count(*) FROM $table_name WHERE PATH=\"$file\";")); #FIXME this can break if there is a '"' character in a filename
 
 	if(!$db_output[0]){
 		$statement = $statement . "(\"$file\"),";
-- 
cgit