From 08e46e6de0f98764641b99bcc4f8d2501e1cdf0d Mon Sep 17 00:00:00 2001 From: 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