From 08e46e6de0f98764641b99bcc4f8d2501e1cdf0d Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Sat, 26 Oct 2002 17:59:35 +0000
Subject: [PATCH] road to 1.3.2 Thesaurus / authorities support. db schema
 update

---
 updater/thesaurus_create.pl | 80 +++++++++++++++++++++++--------------
 1 file changed, 50 insertions(+), 30 deletions(-)

diff --git a/updater/thesaurus_create.pl b/updater/thesaurus_create.pl
index 8fd3ceb851..6337d3e815 100755
--- a/updater/thesaurus_create.pl
+++ b/updater/thesaurus_create.pl
@@ -25,8 +25,6 @@ use strict;
 use C4::Context;
 use C4::Catalogue;
 use DBI;
-use C4::Acquisitions;
-use C4::Output;
 
 my $dbh = C4::Context->dbh;
 
@@ -48,33 +46,55 @@ while (my ($table) = $sth->fetchrow) {
 #    print "table $table\n";
 }
 
-print "creating thesaurus...\n";
-dosql($dbh,"CREATE TABLE bibliothesaurus (code BIGINT not null AUTO_INCREMENT, freelib CHAR (255) not null , stdlib CHAR (255) not null , type CHAR (80) not null , PRIMARY KEY (code), INDEX (freelib),index(stdlib),index(type))");
-	my $sti=$dbh->prepare("select count(*) as tot from bibliosubject");
-	$sti->execute;
-	my $total = $sti->fetchrow_hashref;
-	# FIXME - There's already a $sti in this scope.
-	my $sti=$dbh->prepare("select subject from bibliosubject");
-	$sti->execute;
-	my $i;
-	while (my $line =$sti->fetchrow_hashref) {
-		$i++;
-		if ($i % 1000==0) {
-			print "$i / $total->{'tot'}\n";
-		}
-#		print "$i $line->{'subject'}\n";
-		my $sti2=$dbh->prepare("select count(*) as t from bibliothesaurus where freelib=".$dbh->quote($line->{'subject'}));
-		$sti2->execute;
-		if ($sti2->err) {
-			print "error : ".$sti2->errstr."\n";
-			die;
-		}
-		my $line2=$sti2->fetchrow_hashref;
-		if ($line2->{'t'} ==0) {
-			dosql($dbh,"insert into bibliothesaurus (freelib,stdlib) values (".$dbh->quote($line->{'subject'}).",".$dbh->quote($line->{'subject'}).")");
-#		} else {
-#			print "pas ecriture pour : $line->{'subject'}\n";
+#print "creating thesaurus...\n";
+#dosql($dbh,"CREATE TABLE bibliothesaurus (code BIGINT not null AUTO_INCREMENT, freelib CHAR (255) not null , stdlib CHAR (255) not null , type CHAR (80) not null , PRIMARY KEY (code), INDEX (freelib),index(stdlib),index(type))");
+$dbh->do("delete from bibliothesaurus");
+my $sti=$dbh->prepare("select count(*) from bibliosubject");
+$sti->execute;
+my ($total) = $sti->fetchrow_array;
+$sti=$dbh->prepare("select subject from bibliosubject");
+$sti->execute;
+my $i;
+my $search_sth = $dbh->prepare("select id,level,hierarchy from bibliothesaurus where stdlib=?");
+my $insert_sth = $dbh->prepare("insert into bibliothesaurus (freelib,stdlib,category,level,hierarchy) values (?,?,?,?,?)");
+while (my $line =$sti->fetchrow_hashref) {
+	$i++;
+	if ($i % 1000==0) {
+		print "$i / $total\n";
+	}
+	my @hierarchy = split / - /,$line->{'subject'};
+	my $rebuild = "";
+	my $top_hierarchy = "";
+	#---- if not a main authority field, search where to link
+	for (my $hier=0; $hier<$#hierarchy+1 ; $hier++) {
+		$rebuild .=$hierarchy[$hier];
+		$search_sth->execute($rebuild);
+		my ($id,$level,$hierarchy) = $search_sth->fetchrow_array;
+#		warn "/($line->{'subject'}) : $rebuild/";
+# if father not found, create father and son
+		if (!$id) {
+			$insert_sth->execute($rebuild,$rebuild,"",$hier,"$top_hierarchy");
+			# search again, to find $id and buiild $top_hierarchy
+			$search_sth->execute($rebuild);
+			my ($id,$level,$hierarchy) = $search_sth->fetchrow_array;
+			$top_hierarchy .="|" if ($top_hierarchy);
+			$top_hierarchy .= "$id";
+# else create only son
+		} else {
+			$top_hierarchy .="|" if ($top_hierarchy);
+			$top_hierarchy .= "$id";
+#			$insert_sth->execute($rebuild,$rebuild,"",$hier,"$top_hierarchy");
 		}
-
+		$rebuild .=" - ";
 	}
-
+#	my $sti2=$dbh->prepare("select count(*) as t from bibliothesaurus where freelib=".$dbh->quote($line->{'subject'}));
+#	$sti2->execute;
+#	if ($sti2->err) {
+#		print "error : ".$sti2->errstr."\n";
+#		die;
+#	}
+#	my $line2=$sti2->fetchrow_hashref;
+#	if ($line2->{'t'} ==0) {
+#		dosql($dbh,"insert into bibliothesaurus (freelib,stdlib,category) values (".$dbh->quote($line->{'subject'}).",".$dbh->quote($line->{'subject'}).")");
+#	}
+}
-- 
2.39.5