From ec07b105fed222b737ba2a69d380c3adb841e0cf Mon Sep 17 00:00:00 2001
From: lshprung <lshprung@yahoo.com>
Date: Wed, 15 Sep 2021 17:23:38 -0700
Subject: PATH column is unique

---
 build_db.plx | 10 +++++++---
 1 file changed, 7 insertions(+), 3 deletions(-)

(limited to 'build_db.plx')

diff --git a/build_db.plx b/build_db.plx
index 7bb6072..1b01b58 100755
--- a/build_db.plx
+++ b/build_db.plx
@@ -205,7 +205,7 @@ if (!$options{append}){
 	# Need to create additional columns for ID and PATH
 	$statement = "CREATE TABLE $table_name 
 	(ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
-	PATH TEXT NOT NULL";
+	PATH TEXT NOT NULL UNIQUE";
 	for my $i (sort(keys %columns)){
 		$statement = $statement . ",
 		\"$i\" TEXT";
@@ -215,7 +215,6 @@ if (!$options{append}){
 }
 
 # If appending, add columns where necessary
-# FIXME add check to avoid duplicate rows with the same PATH
 else {
 	for my $i (sort(keys %columns)){
 		$statement = "SELECT COUNT(*) AS CNTREC FROM pragma_table_info('$table_name') WHERE name='$i';";
@@ -231,7 +230,12 @@ else {
 $statement = "INSERT INTO $table_name(PATH)
 VALUES";
 for my $file (@file_list){
-	$statement = $statement . "(\"$file\"),";
+	# Skip existing files
+	@db_output = flatten_array(db_cmd($dbh, "SELECT count(*) FROM $table_name WHERE PATH='$file';"));
+
+	if(!$db_output[0]){
+		$statement = $statement . "(\"$file\"),";
+	}
 }
 $statement =~ s/[,]$/;/g;
 db_cmd($dbh, $statement);
-- 
cgit