<?php |
<?php |
|
|
include_once ("../lib/common.inc.php"); |
include_once ("../lib/common.inc.php"); |
$heuristics = Array(); |
$heuristics = Array(); |
//each heuristic adds self to description array |
//each heuristic adds self to description array |
include ("dateHeuristics.php"); |
include ("dateHeuristics.php"); |
include ("historyHeuristics.php"); |
include ("historyHeuristics.php"); |
|
|
//include ("metadataHeuristics.php"); |
//include ("metadataHeuristics.php"); |
//include ("valueHeuristics.php"); |
//include ("valueHeuristics.php"); |
function runHeuristic($heuristicName, $cn) |
function runHeuristic($heuristicName, $cn) { |
{ |
|
global $conn; |
global $conn; |
// check if already ran |
// check if already ran |
$query = "select count(*) from heuristic_results where heuristic_name = '$heuristicName' and \"CNID\" = '{$cn['CNID']}'"; |
$query = "select count(*) from heuristic_results where heuristic_name = '$heuristicName' and \"CNID\" = '{$cn['CNID']}'"; |
$result = $conn->query($query); |
$result = $conn->query($query); |
databaseError($conn->errorInfo()); |
databaseError($conn->errorInfo()); |
$r = $result->fetch(PDO::FETCH_BOTH); |
$r = $result->fetch(PDO::FETCH_BOTH); |
if ($r[0] == 0) { |
if ($r[0] == 0) { |
// if not, run now |
// if not, run now |
$hresults = call_user_func($heuristicName, $cn); |
$hresults = call_user_func($heuristicName, $cn); |
if (!isset($hresults["heuristic_value"]) || !isset($hresults["raw_value"]) || !isset($hresults["mean"]) || !isset($hresults["stddev"])) { |
if (!isset($hresults["heuristic_value"]) || !isset($hresults["raw_value"]) || !isset($hresults["mean"]) || !isset($hresults["stddev"])) { |
print_r($hresults); |
print_r($hresults); |
die("Missing field in heurtistic $heuristicName result"); |
die("Missing field in heurtistic $heuristicName result"); |
} |
} |
$query = "insert into heuristic_results values('$heuristicName', |
$query = "insert into heuristic_results values('$heuristicName', |
'{$hresults["heuristic_value"]}', |
'{$hresults["heuristic_value"]}', |
'{$hresults["raw_value"]}', |
'{$hresults["raw_value"]}', |
'{$hresults["mean"]}', |
'{$hresults["mean"]}', |
'{$hresults["stddev"]}', |
'{$hresults["stddev"]}', |
'{$cn["CNID"]}', |
'{$cn["CNID"]}', |
NOW(), |
NOW(), |
'{$cn["publishDate"]}', |
'{$cn["publishDate"]}'," |
'{$cn["agencyABN"]}', |
//."'{$cn["agencyABN"]}', |
'{$cn["supplierID"]}' |
."0,'{$cn["supplierID"]}' |
)"; |
)"; |
// save value and cn data via sql |
// save value and cn data via sql |
$result = $conn->query($query); |
$result = $conn->query($query); |
$errors = $conn->errorInfo(); |
$errors = $conn->errorInfo(); |
if ($errors[2] == "") echo "Saved $heuristicName for {$cn["CNID"]} <br>\n"; |
if ($errors[2] == "") |
elseif (strpos($errors[2] , "Duplicate entry") === false) echo $hresults . " failed insert.<br>" . print_r($errors,true) . " <br> $query <br><br>\n"; |
echo "Saved $heuristicName for {$cn["CNID"]} <br>\n"; |
} |
elseif (strpos($errors[2], "Duplicate entry") === false) |
|
echo $hresults . " failed insert.<br>" . print_r($errors, true) . " <br> $query <br><br>\n"; |
|
} |
} |
} |
|
|
?> |
?> |
|
|