#$dbh->{mysql_enable_utf8mb4} = 1;
$dbh->do('SET NAMES utf8mb4');
-#to do check for array passed and if not present then use tags
+my $mig_path = abs_path($0);
+$mig_path =~ s|[^/]+$||;
my @taglist = @ARGV;
my $arg_list_length = scalar @taglist;
-if($arg_list_length < 1) { @taglist = ("authorisedvalues","borrowerattributes","calendar","circrules","itemtypes","libraries","patrontypes","preferences","reports","smsproviders"); }
+if($arg_list_length < 1) { @taglist = ("authorisedvalues","booksellers","borrowerattributes","budgets","calendar","circrules","itemtypes","letters","libraries","patrontypes","preferences","reports","smsproviders"); }
$MIGGITDIR =~ s/\/\//\//;
+my @errors;
+
foreach my $restore (@taglist) {
my $restorefile;
if ($restore eq 'authorisedvalues') {
print "Restoring from $restorefile ... \n";
if ($restorefile) { restore_authorisedvalues($dbh,$restorefile); }
}
+ if ($restore eq 'booksellers') {
+ my $timestamp = most_recent_single($MIGGITDIR,'booksellers');
+ if ($timestamp) { $restorefile = $MIGGITDIR . 'booksellers' . '.' . $timestamp . '.xml'; }
+ print "Restoring from $restorefile ... \n";
+ if ($restorefile) { restore_booksellers($dbh,$restorefile); }
+ }
if ($restore eq 'borrowerattributes') {
my $timestamp = most_recent_single($MIGGITDIR,'borrowerattributes');
if ($timestamp) { $restorefile = $MIGGITDIR . 'borrowerattributes' . '.' . $timestamp . '.xml'; }
print "Restoring from $restorefile ... \n";
if ($restorefile) { restore_borrowerattributes($dbh,$restorefile); }
}
+ if ($restore eq 'budgets') {
+ my $timestamp = most_recent_single($MIGGITDIR,'budgets');
+ if ($timestamp) { $restorefile = $MIGGITDIR . 'budgets' . '.' . $timestamp . '.xml'; }
+ print "Restoring from $restorefile ... \n";
+ if ($restorefile) { restore_budgets($dbh,$restorefile); }
+ }
if ($restore eq 'calendar') {
my $timestamp = most_recent_single($MIGGITDIR,'calendar');
if ($timestamp) { $restorefile = $MIGGITDIR . 'calendar' . '.' . $timestamp . '.xml'; }
my $timestamp = most_recent_single($MIGGITDIR,'circrules');
if ($timestamp) { $restorefile = $MIGGITDIR . 'circrules' . '.' . $timestamp . '.xml'; }
print "Restoring from $restorefile ... \n";
- if ($restorefile) { restore_circrules($dbh,$restorefile); }
+ if ($restorefile) { @errors = restore_circrules($dbh,$restorefile,@errors); }
}
if ($restore eq 'itemtypes') {
my $timestamp = most_recent_single($MIGGITDIR,'itemtypes');
if ($timestamp) { $restorefile = $MIGGITDIR . 'itemtypes' . '.' . $timestamp . '.xml'; }
print "Restoring from $restorefile ... \n";
- if ($restorefile) { restore_itemtypes($dbh,$restorefile); }
+ if ($restorefile) { @errors = restore_itemtypes($dbh,$restorefile,@errors); }
+ }
+ if ($restore eq 'letters') {
+ my $timestamp = most_recent_single($MIGGITDIR,'letters');
+ if ($timestamp) { $restorefile = $MIGGITDIR . 'letters' . '.' . $timestamp . '.xml'; }
+ print "Restoring from $restorefile ... \n";
+ if ($restorefile) { restore_letters($dbh,$restorefile); }
}
if ($restore eq 'libraries') {
my $timestamp = most_recent_single($MIGGITDIR,'libraries');
if ($timestamp) { $restorefile = $MIGGITDIR . 'systempreferences' . '.' . $timestamp . '.xml'; }
print "Restoring from $restorefile ... \n";
if ($restorefile) { restore_preferences($dbh,$restorefile); }
- print "IMPORTANT : if you are changing system preferences you may need to run 'sudo systemctl restart apache2 memcached'\n\n";
+ print "IMPORTANT : if you are changing system preferences you may need to run 'sudo systemctl restart memcached'\n\n";
}
if ($restore eq 'reports') {
my $timestamp = most_recent_single($MIGGITDIR,'reports');
my $timestamp = most_recent_single($MIGGITDIR,'smsproviders');
if ($timestamp) { $restorefile = $MIGGITDIR . 'smsproviders' . '.' . $timestamp . '.xml'; }
print "Restoring from $restorefile ... \n";
- if ($restorefile) { restore_smsproviders($dbh,$restorefile); }
+ if ($restorefile) { restore_smsproviders($dbh,$restorefile,$mig_path); }
}
}
print "Done.\n";
+foreach my $e (@errors) { print "$e\n"; }
+
+# ---------------------------
+
+sub check_category {
+ my $dbh = shift;
+ my $value = shift;
+ my $query;
+
+ if ($value and $value ne 'NULL') {
+ $query = "SELECT EXISTS(SELECT 1 FROM categories WHERE categorycode = $value)";
+ } else {
+ return 1;
+ }
+ print "$query\n";
+ my $sth = $dbh->prepare($query);
+ $sth->execute();
+ my @sqlresult = $sth->fetchrow_array;
+ my $result = pop @sqlresult;
+ return $result;
+}
+
+sub check_itemtype {
+ my $dbh = shift;
+ my $value = shift;
+ my $query;
+ if ($value and $value ne 'NULL') {
+ $query = "SELECT EXISTS(SELECT 1 FROM itemtypes WHERE itemtype = $value)";
+ } else {
+ return 1;
+ }
+ my $sth = $dbh->prepare($query);
+ $sth->execute();
+ my @sqlresult = $sth->fetchrow_array;
+ my $result = pop @sqlresult;
+ return $result;
+}
sub most_recent_single {
my $MGIGITDIR = shift;
my $query = "DELETE FROM authorised_values WHERE category != 'ITEMTYPECAT'";
my $sth = $dbh->prepare($query);
- $sth->execute();
+ print "$query\n";
+ #$sth->execute();
- foreach my $node ($dom->findnodes('//value')) {
+ $query = "DELETE FROM authorised_value_categories WHERE category_name != 'ITEMTYPECAT'";
+ $sth = $dbh->prepare($query);
+ print "$query\n";
+ #$sth->execute();
+
+ foreach my $node ($dom->findnodes('/document/categories/value')) {
+ my $name = sql_str_not_null($node->findvalue('./name'));
+ $query = "INSERT INTO authorised_value_categories (category_name) VALUES ($name)";
+ $sth = $dbh->prepare($query);
+ print "$query\n";
+ #$sth->execute();
+ }
+
+ foreach my $node ($dom->findnodes('/document/authorisedvalues/value')) {
my $category = sql_str($node->findvalue('./category'));
my $authorised_value = sql_str($node->findvalue('./authorised_value'));
my $lib = sql_str($node->findvalue('./lib'));
my $imageurl = sql_str($node->findvalue('./imageurl'));
$query = "INSERT INTO authorised_values (category,authorised_value,lib,lib_opac,imageurl) VALUES ($category,$authorised_value,$lib,$lib_opac,$imageurl)";
$sth = $dbh->prepare($query);
- $sth->execute();
+ print "$query\n";
+ #$sth->execute();
}
return;
}
+sub restore_booksellers {
+ my $dbh = shift;
+ my $restore_file = shift;
+ my $parser = XML::LibXML->new();
+ my $dom = $parser->parse_file($restore_file);
+
+ my $query = "DELETE FROM aqbooksellers WHERE 1 = 1";
+ my $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ foreach my $node ($dom->findnodes('/booksellers/value')) {
+ my $name = sql_str($node->findvalue('./name'));
+ my $address1 = sql_str($node->findvalue('./address1'));
+ my $address2 = sql_str($node->findvalue('./address2'));
+ my $address3 = sql_str($node->findvalue('./address3'));
+ my $address4 = sql_str($node->findvalue('./address4'));
+ my $phone = sql_str($node->findvalue('./phone'));
+ my $accountnumber = sql_str($node->findvalue('./accountnumber'));
+ my $othersupplier = sql_str($node->findvalue('./othersupplier'));
+ my $currency = sql_str_not_null($node->findvalue('./currency'));
+ my $booksellerfax = sql_str($node->findvalue('./booksellerfax'));
+ my $notes = sql_str($node->findvalue('./notes'));
+ my $bookselleremail = sql_str($node->findvalue('./bookselleremail'));
+ my $booksellerurl = sql_str($node->findvalue('./booksellerurl'));
+ my $postal = sql_str($node->findvalue('./postal'));
+ my $url = sql_str($node->findvalue('./url'));
+ my $active = sql_str($node->findvalue('./active'));
+ my $listprice = sql_str($node->findvalue('./listprice'));
+ my $invoiceprice = sql_str($node->findvalue('./invoiceprice'));
+ my $gstreg = sql_num($node->findvalue('./gstreg'));
+ my $listincgst = sql_num($node->findvalue('./listincgst'));
+ my $invoiceincgst = sql_num($node->findvalue('./invoiceincgst'));
+ my $tax_rate = sql_num($node->findvalue('./tax_rate'));
+ my $discount = sql_num($node->findvalue('./discount'));
+ my $fax = sql_str($node->findvalue('./fax'));
+ my $deliverytime = sql_num($node->findvalue('./deliverytime'));
+ $query = "INSERT INTO aqbooksellers (name,address1,address2,address3,address4,phone,accountnumber,othersupplier,currency,booksellerfax,notes,bookselleremail,booksellerurl,postal,url,active,listprice,invoiceprice,gstreg,listincgst,invoiceincgst,tax_rate,discount,fax,deliverytime) VALUES ($name,$address1,$address2,$address3,$address4,$phone,$accountnumber,$othersupplier,$currency,$booksellerfax,$notes,$bookselleremail,$booksellerurl,$postal,$url,$active,$listprice,$invoiceprice,$gstreg,$listincgst,$invoiceincgst,$tax_rate,$discount,$fax,$deliverytime)";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+ }
+
+ return;
+}
sub restore_borrowerattributes {
my $dbh = shift;
return;
}
+sub restore_budgets {
+ my $dbh = shift;
+ my $restore_file = shift;
+ my $parser = XML::LibXML->new();
+ my $dom = $parser->parse_file($restore_file);
+
+ my $query = "DELETE FROM aqbudgets WHERE 1 = 1";
+ my $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ $query = "DELETE FROM aqbudgetperiods WHERE 1 = 1";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ my $budget_ai;
+ my $budgetperiod_ai;
+
+ foreach my $node ($dom->findnodes('/document/budgets')) {
+ $budget_ai = sql_num($node->findvalue('./autoincrement'));
+ }
+
+ foreach my $node ($dom->findnodes('/document/budgetperiods')) {
+ $budgetperiod_ai = sql_num($node->findvalue('./autoincrement'));
+ }
+
+ $query = "ALTER TABLE aqbudgets AUTO_INCREMENT = $budget_ai";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ $query = "ALTER TABLE aqbudgetperiods AUTO_INCREMENT = $budgetperiod_ai";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ foreach my $node ($dom->findnodes('/document/budgetperiods/value')) {
+ my $budget_period_id = sql_num($node->findvalue('./budget_period_id'));
+ my $budget_period_startdate = sql_str($node->findvalue('./budget_period_startdate'));
+ my $budget_period_enddate = sql_str($node->findvalue('./budget_period_enddate'));
+ my $budget_period_active = sql_str($node->findvalue('./budget_period_active'));
+ my $budget_period_description = sql_str($node->findvalue('./budget_period_description'));
+ my $budget_period_total = sql_num($node->findvalue('./budget_period_total'));
+ my $budget_period_locked = sql_num($node->findvalue('./budget_period_locked'));
+ my $sort1_authcat = sql_str($node->findvalue('./sort1_authcat'));
+ my $sort2_authcat = sql_str($node->findvalue('./sort2_authcat'));
+ $query = "INSERT INTO aqbudgetperiods (budget_period_id,budget_period_startdate,budget_period_enddate,budget_period_active,budget_period_description,budget_period_total,budget_period_locked,sort1_authcat,sort2_authcat) VALUES ($budget_period_id,$budget_period_startdate,$budget_period_enddate,$budget_period_active,$budget_period_description,$budget_period_total,$budget_period_locked,$sort1_authcat,$sort2_authcat)";
+ print "$query\n";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+ }
+
+ #note that at this point we are not loading the budget owner, it's nullable and not 100% clear that it's the borrower
+ #and nothing to test with in initial sample
+ foreach my $node ($dom->findnodes('/document/budgets/value')) {
+ my $budget_id = sql_num($node->findvalue('./budget_id'));
+ my $budget_parent_id = sql_num($node->findvalue('./budget_parent_id'));
+ my $budget_code = sql_str($node->findvalue('./budget_code'));
+ my $budget_name = sql_str($node->findvalue('./budget_name'));
+ my $budget_branchcode = sql_str_not_null($node->findvalue('./budget_branchcode'));
+ my $budget_amount = sql_num($node->findvalue('./budget_amount'));
+ my $budget_encumb = sql_num($node->findvalue('./budget_encumb'));
+ my $budget_expend = sql_num($node->findvalue('./budget_expend'));
+ my $budget_notes = sql_str_not_null($node->findvalue('./budget_notes'));
+ my $timestamp = sql_str($node->findvalue('./timestamp'));
+ my $budget_period_id = sql_num($node->findvalue('./budget_period_id'));
+ my $sort1_authcat = sql_str_not_null($node->findvalue('./sort1_authcat'));
+ my $sort2_authcat = sql_str_not_null($node->findvalue('./sort2_authcat'));
+ my $budget_permission = sql_num($node->findvalue('./budget_permission'));
+ $query = "INSERT INTO aqbudgets (budget_id,budget_parent_id,budget_code,budget_name,budget_branchcode,budget_amount,budget_encumb,budget_expend,budget_notes,timestamp,budget_period_id,sort1_authcat,sort2_authcat,budget_permission) VALUES ($budget_id,$budget_parent_id,$budget_code,$budget_name,$budget_branchcode,$budget_amount,$budget_encumb,$budget_expend,$budget_notes,$timestamp,$budget_period_id,$sort1_authcat,$sort2_authcat,$budget_permission)";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+ }
+
+ return;
+}
sub restore_calendar {
my $dbh = shift;
sub restore_circrules {
my $dbh = shift;
my $restore_file = shift;
+ my @errors = shift;
my $parser = XML::LibXML->new();
my $dom = $parser->parse_file($restore_file);
-
+ my $error;
+ my $check;
#order of operations - clean out circ_rules, then issuingrules; restore issuingrules then circ_rules
my $query = "DELETE FROM circulation_rules WHERE 1 = 1";
my $opacitemholds = sql_str($node->findvalue('./opacitemholds'));
my $article_requests = sql_str($node->findvalue('./article_requests'));
my $note = sql_str($node->findvalue('./note'));
+ $check = check_itemtype($dbh,$itemtype);
+ if ($check == 0 ) {
+ $error = "restore_circrules: issing rules rules itemtype $itemtype was not valid";
+ push @errors, $error;
+ next;
+ }
+ $check = check_category($dbh,$categorycode);
+ if ($check == 0 ) {
+ $error = "restore_circrules: issuing rules rules category $categorycode was not valid";
+ push @errors, $error;
+ next;
+ }
$query = "INSERT INTO issuingrules (categorycode,itemtype,restrictedtype,rentaldiscount,reservecharge,fine,finedays,maxsuspensiondays,suspension_chargeperiod,firstremind,chargeperiod,chargeperiod_charge_at,accountsent,issuelength,lengthunit,hardduedate,hardduedatecompare,renewalsallowed,renewalperiod,norenewalbefore,auto_renew,no_auto_renewal_after,no_auto_renewal_after_hard_limit,reservesallowed,holds_per_record,holds_per_day,branchcode,overduefinescap,cap_fine_to_replacement_price,onshelfholds,opacitemholds,article_requests,note) VALUES ($categorycode,$itemtype,$restrictedtype,$rentaldiscount,$reservecharge,$fine,$finedays,$maxsuspensiondays,$suspension_chargeperiod,$firstremind,$chargeperiod,$chargeperiod_charge_at,$accountsent,$issuelength,$lengthunit,$hardduedate,$hardduedatecompare,$renewalsallowed,$renewalperiod,$norenewalbefore,$auto_renew,$no_auto_renewal_after,$no_auto_renewal_after_hard_limit,$reservesallowed,$holds_per_record,$holds_per_day,$branchcode,$overduefinescap,$cap_fine_to_replacement_price,$onshelfholds,$opacitemholds,$article_requests,$note)";
$sth = $dbh->prepare($query);
$sth->execute();
my $itemtype = sql_str($node->findvalue('./itemtype'));
my $rule_name = sql_str($node->findvalue('./rule_name'));
my $rule_value = sql_str($node->findvalue('./rule_value'));
+
+ $check = check_itemtype($dbh,$itemtype);
+ if ($check == 0 ) {
+ $error = "restore_circrules: circulation rules rules itemtype $itemtype was not valid";
+ push @errors, $error;
+ next;
+ }
+ $check = check_category($dbh,$categorycode);
+ if ($check == 0 ) {
+ $error = "restore_circrules: circulation rules rules category $categorycode was not valid";
+ push @errors, $error;
+ next;
+ }
+
$query = "INSERT INTO circulation_rules (branchcode,categorycode,itemtype,rule_name,rule_value) VALUES ($branchcode,$categorycode,$itemtype,$rule_name,$rule_value)";
$sth = $dbh->prepare($query);
$sth->execute();
}
-
- return;
+
+ return @errors;
}
sub restore_itemtypes {
my $dbh = shift;
my $restorefile = shift;
+ my @errors = shift;
my $parser = XML::LibXML->new();
my $dom = $parser->parse_file($restorefile);
+ my $check;
my $query = "UPDATE itemtypes SET searchcategory = NULL";
my $sth = $dbh->prepare($query);
$sth = $dbh->prepare($query);
$sth->execute();
- foreach my $node ($dom->findnodes('/authorised_values/value')) {
+ $query = "DELETE FROM itemtypes WHERE 1 = 1";
+ $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ foreach my $node ($dom->findnodes('/document/authorised_values/value')) {
my $category = sql_str($node->findvalue('./category'));
my $authvalue = sql_str($node->findvalue('./authvalue'));
my $lib = sql_str($node->findvalue('./lib'));
$sth->execute();
}
- foreach my $node ($dom->findnodes('/itemtypes/value')) {
+ foreach my $node ($dom->findnodes('/document/itemtypes/value')) {
my $itemtype = sql_str($node->findvalue('./itemtype'));
my $description = sql_str($node->findvalue('./description'));
my $rentalcharge = sql_str($node->findvalue('./rentalcharge'));
my $sip_media_type = sql_str($node->findvalue('./sip_media_type'));
my $hideinopac = sql_str($node->findvalue('./hideinopac'));
my $searchcategory = sql_str($node->findvalue('./searchcategory'));
- $query = "SELECT itemtype FROM itemtypes WHERE itemtype = $itemtype";
- $sth = $dbh->prepare($query);
- $sth->execute();
- my $answer;
- while (my @row = $sth->fetchrow_array) { $answer = sql_str($row[0]); }
- if (!defined $answer or $answer ne $itemtype) {
+
+ $check = check_itemtype($dbh,$itemtype);
+ if ($check == 0) {
$query = "INSERT INTO itemtypes (itemtype,description,rentalcharge,rentalcharge_daily,rentalcharge_hourly,defaultreplacecost,processfee,notforloan,imageurl,summary,checkinmsg,sip_media_type,hideinopac,searchcategory)
VALUES ($itemtype,$description,$rentalcharge,$rentalcharge_daily,$rentalcharge_hourly,$defaultreplacecost,$processfee,$notforloan,$imageurl,$summary,$checkinmsg,$sip_media_type,$hideinopac,$searchcategory)";
$sth = $dbh->prepare($query);
my $translation = sql_str($node->findvalue('./translation'));
my $query = "INSERT INTO localization (entity,code,lang,translation) VALUES ($entity,$code,$lang,$translation)";
$sth = $dbh->prepare($query);
- print "$query\n";
+ $sth->execute();
+ }
+
+ return;
+}
+
+sub restore_letters {
+ my $dbh = shift;
+ my $restore_file = shift;
+ my $parser = XML::LibXML->new();
+ my $dom = $parser->parse_file($restore_file);
+
+ my $query = "DELETE FROM letter WHERE 1 = 1";
+ my $sth = $dbh->prepare($query);
+ $sth->execute();
+
+ foreach my $node ($dom->findnodes('/letters/letter')) {
+ my $module = sql_str($node->findvalue('./module'));
+ my $code = sql_str($node->findvalue('./code'));
+ my $branchcode = sql_str_not_null($node->findvalue('./branchcode'));
+ my $name = sql_str($node->findvalue('./name'));
+ my $is_html = sql_num($node->findvalue('./is_html'));
+ my $title = sql_str($node->findvalue('./title'));
+ my $content = sql_str($node->findvalue('./content'));
+ my $message_transport_type = sql_str($node->findvalue('./message_transport_type'));
+ my $lang = sql_str($node->findvalue('./lang'));
+ $query = "INSERT INTO letter (module,code,branchcode,name,is_html,title,content,message_transport_type,lang) VALUES ($module,$code,$branchcode,$name,$is_html,$title,$content,$message_transport_type,$lang)";
+ $sth = $dbh->prepare($query);
$sth->execute();
}
my $dom = $parser->parse_file($restore_file);
foreach my $node ($dom->findnodes('//pref')) {
- my $variable = domain_shift(sql_str($node->findvalue('./variable')));
- my $value = domain_shift(sql_str($node->findvalue('./value')));
+ my $variable = domain_shift(sql_str_not_null($node->findvalue('./variable')));
+ my $value = domain_shift(sql_str_not_null($node->findvalue('./value')));
my $query = "UPDATE systempreferences SET value = $value WHERE variable = $variable";
my $sth = $dbh->prepare($query);
$sth->execute();
sub restore_smsproviders {
my $dbh = shift;
my $restore_file = shift;
+ my $migpath = shift;
my $parser = XML::LibXML->new();
my $dom = $parser->parse_file($restore_file);
my $sth = $dbh->prepare($query);
$sth->execute();
+ my $p = 0;
+ foreach my $node ($dom->findnodes('//provider')) { $p++; }
+
+ if ($p == 0) {
+ my $failover_file = find_xml('smsproviders.xml',$migpath);
+ $dom = $parser->parse_file($failover_file);
+ }
+
foreach my $node ($dom->findnodes('//provider')) {
my $name = sql_str($node->findvalue('./name'));
my $domain = sql_str($node->findvalue('./domain'));
return $str;
}
+sub sql_str_not_null {
+ my $str = shift;
+ $str = sql_str($str);
+ if (!defined $str or $str eq 'NULL') { return "''"; }
+ return $str;
+}
+
sub sql_num {
my $str = shift;
if (!defined $str or $str eq '') { return 'NULL'; } else { return $str; }
exit 1;
}
+sub find_xml {
+ my $reports_xml = shift;
+ my $mig_path = shift;
+
+ if ($reports_xml =~ m/\//) { return $reports_xml; }
+
+ my $mig_test_file = $mig_path . '/../xml/' . $reports_xml;
+ my $working_test_dir = getcwd();
+ my $working_test_file = $working_test_dir . '/' . $reports_xml;
+
+ if (-e $mig_test_file) { return $mig_test_file; }
+ if (-e $working_test_file) { return $working_test_file; }
+
+ return undef;
+}
+
sub print_usage {
print <<_USAGE_;
projects / migration-tools.git / blobdiff