diff options
Diffstat (limited to 'build_db.plx')
| -rwxr-xr-x | build_db.plx | 8 |
1 files changed, 7 insertions, 1 deletions
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\"),"; |