Subversion Repositories locum

Compare Revisions

Ignore whitespace Rev 151 → Rev 152

/trunk/tools/upgrades/1.1/upgrade.php
New file
0,0 → 1,35
#!/usr/bin/php5 -q
<?php
 
// You may want/need to change this
ini_set('memory_limit', '400M');
 
// Where is Locum?
$locum_lib_dir = '/usr/local/lib/locum';
 
// Include Locum libraries
require_once($locum_lib_dir . '/locum-server.php');
 
// Fire it up
$locum = new locum_server;
 
// Force all records to be updated
$db = $locum->db_query("UPDATE locum_bib_items SET bib_last_update = '1970-01-01' WHERE active = '1'");
 
// Rebuild Facet Heap - first pass
$locum->rebuild_facet_heap();
 
// Data maintenance
$locum->verify_bibs();
$locum->new_bib_scan();
$locum->rebuild_holds_cache();
 
// Rebuild Facet Heap - second pass
$locum->rebuild_facet_heap();
 
// Restart services, reindex, etc.
$locum->index();
 
// This can all be done in situ
$locum->verify_status();
$locum->verify_syndetics();
/trunk/tools/maint.php
6,9 → 6,6
 
// Init scripts, library locations, and binaries
$locum_lib_dir = '/usr/local/lib/locum';
$mysql_init_script = '/etc/init.d/mysql';
$sphinx_init_script = '/etc/init.d/sphinx';
$sphinx_indexer = '/usr/local/sphinx/bin/indexer';
 
// Include Locum libraries
require_once($locum_lib_dir . '/locum-server.php');
21,6 → 18,9
$locum->new_bib_scan();
$locum->rebuild_holds_cache();
 
// Rebuild Facet Heap
$locum->rebuild_facet_heap();
 
// Restart services, reindex, etc.
$locum->index();
 
/trunk/locum.php
99,6 → 99,35
return $cleaned;
}
public function db_query($query, $query_only = TRUE, $return_type = 'all', $assoc = TRUE) {
$db =& MDB2::connect($this->dsn);
$db_result =& $db->query($query);
if ($query_only) {
return TRUE;
} else {
switch (trim(strtolower($return_type))) {
case 'row':
if ($assoc) {
return $db_result->fetchRow(MDB2_FETCHMODE_ASSOC);
} else {
return $db_result->fetchRow();
}
break;
case 'col':
return $db_result->fetchCol();
break;
case 'all':
default:
if ($assoc) {
return $db_result->fetchAll(MDB2_FETCHMODE_ASSOC);
} else {
return $db_result->fetchAll();
}
break;
}
}
}
/**
* Checks $query_value against $ini_value to see a) if its a regex or csv match.
* It will then return TRUE if it is a match or FALSE if not.
/trunk/locum-server.php
180,7 → 180,7
$bib_values['subjects_ser'] = serialize($subj);
$types = array('date', 'date', 'date', 'integer', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'integer', 'text', 'text', 'integer', 'text', 'text', 'text', 'integer', 'text');
$types = array('date', 'date', 'date', 'integer', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'integer', 'text', 'text', 'integer', 'text', 'text', 'text', 'text');
$setlist =
"bib_created = :bib_created, " .
398,7 → 398,7
parent::putlog("Collecting current data keys ..");
$db = MDB2::connect($this->dsn);
$sql = "SELECT bnum, bib_lastupdate FROM locum_facet_heap ORDER BY bnum LIMIT $limit";
$sql = "SELECT bnum, bib_lastupdate FROM locum_bib_items WHERE active = '1' ORDER BY bnum LIMIT $limit";
$init_result = $db->query($sql);
$init_bib_arr = $init_result->fetchAll(MDB2_FETCHMODE_ASSOC);
458,7 → 458,7
$offset = $offset + $limit;
parent::putlog("Collecting current data keys starting at $offset");
$db = MDB2::connect($this->dsn);
$sql = "SELECT bnum, bib_lastupdate FROM locum_facet_heap ORDER BY bnum LIMIT $limit OFFSET $offset";
$sql = "SELECT bnum, bib_lastupdate FROM locum_bib_items WHERE active = '1' ORDER BY bnum LIMIT $limit OFFSET $offset";
$init_result = $db->query($sql);
$init_bib_arr = $init_result->fetchAll(MDB2_FETCHMODE_ASSOC);
}
482,7 → 482,7
 
parent::putlog("Collecting current data keys ..");
$db = MDB2::connect($this->dsn);
$sql = "SELECT bnum, bib_lastupdate FROM locum_facet_heap ORDER BY bnum LIMIT $limit";
$sql = "SELECT bnum, bib_lastupdate FROM locum_bib_items WHERE active = '1' ORDER BY bnum LIMIT $limit";
$init_result = $db->query($sql);
$init_bib_arr = $init_result->fetchAll(MDB2_FETCHMODE_ASSOC);
$locumclient = new locum_client;
542,7 → 542,7
$offset = $offset + $limit;
parent::putlog("Collecting current data keys starting at $offset");
$db = MDB2::connect($this->dsn);
$sql = "SELECT bnum, bib_lastupdate FROM locum_facet_heap ORDER BY bnum LIMIT $limit OFFSET $offset";
$sql = "SELECT bnum, bib_lastupdate FROM locum_bib_items WHERE active = '1' ORDER BY bnum LIMIT $limit OFFSET $offset";
$init_result = $db->query($sql);
$init_bib_arr = $init_result->fetchAll(MDB2_FETCHMODE_ASSOC);
}