$mysqli = mysqli_connect(ini_get("mysqli.default_host"), 'updatescriptuser', 'NOT_THE_REAL_PASSWORD');
$mysqli->select_db('system_genomics');
$probes = array();
$probeIDQuery = "SELECT ID FROM probeTest;";
$probeResult = $mysqli->query($probeIDQuery);
if ($probeResult == null) {
echo "Query failed near line " . __LINE__ . ": {$probeIDQuery}";
echo "<br />Error is " . $mysqli->error;
exit;
}
while ($row = $probeResult->fetch_assoc()) {
$probes[] = $row["ID"];
}
$numProbes = count($probes);
echo "Number of probes is {$numProbes}.\n";
$correlationEngine = new CorrelationEngine();
for ($i = 0; $i < $numProbes; $i++) {
echo "probeID " . $probes[$i] . "\n";
$set1 = array();
$set1Query = "SELECT effect FROM individualEffect WHERE probeID = '" . $probes[$i] . "' ORDER BY individualID";
$set1Result = $mysqli->query($set1Query);
if ($set1Result == null) {
echo "Query failed near line " . __LINE__ . ": {$set1Query}";
echo "<br />Error is " . $mysqli->error;
exit;
}
while ($row = $set1Result->fetch_assoc()) {
$set1[] = $row['effect'];
}
// $set1 = $set1Result->fetch_array(MYSQLI_NUM);
// echo "<pre>"; print_r($set1); echo "</pre>"; die();
if ($row = $lastProbeResult->fetch_assoc()) {
$lastProbe = $row["staticCorrelationProbeID"];
}
$probeIDQuery = "SELECT p.ID FROM probe p WHERE p.ID > {$lastProbe};";
$probeResult = $mysqli->query($probeIDQuery);
if ($probeResult == null) {
echo "Query failed near line " . __LINE__ . ": {$probeIDQuery}";
echo "<br />Error is " . $mysqli->error;
exit;
}
while ($row = $probeResult->fetch_assoc()) {
$probes[] = $row["ID"];
}
$numProbes = count($probes) + $lastProbe;
echo "Number of probes is {$numProbes}.\n";
$correlationEngine = new CorrelationEngine();
for ($i = $lastProbe + 1; $i <= $numProbes; $i++) {
echo "probeID is {$i}\n";
// Truncate the correlation memory table
$truncateCorrelationMemQuery = "TRUNCATE TABLE staticCorrelation_MEM;";
$truncateResult = $mysqli->query($truncateCorrelationMemQuery);
if ($truncateResult == null || $mysqli->error) {
echo "Query failed near line " . __LINE__ . ": {$truncateCorrelationMemQuery}";
echo "<br />Error is " . $mysqli->error;
exit;
}
$set1 = array();
$set1Query = "SELECT effect FROM individualEffect_MEM WHERE probeID = {$i} ORDER BY individualID";
$set1Result = $mysqli->query($set1Query);
if ($set1Result == null) {
echo "Query failed near line " . __LINE__ . ": {$set1Query}";
$mysqli = mysqli_connect(ini_get("mysqli.default_host"), 'updatescriptuser', 'NOT_THE_REAL_PASSWORD');
$mysqli->select_db('system_genomics');
$probes = array();
$probeIDQuery = "SELECT ID, indMean, indSSMeanDevn FROM probeTest;";
$probeResult = $mysqli->query($probeIDQuery);
if ($probeResult == null) {
echo "Query failed near line " . __LINE__ . ": {$probeIDQuery}";
echo "<br />Error is " . $mysqli->error;
exit;
}
while ($row = $probeResult->fetch_assoc()) {
$probes[] = $row;
}
$numProbes = count($probes);
echo "Number of probes is {$numProbes}.\n";
$correlationEngine = new CorrelationEngine();
for ($i = 0; $i < $numProbes; $i++) {
echo "probeID " . $probes[$i]['ID'] . "\n";
$set1 = array();
$set1Query = "SELECT effect FROM individualEffect WHERE probeID = '" . $probes[$i]['ID'] . "' ORDER BY individualID";
$set1Result = $mysqli->query($set1Query);
if ($set1Result == null) {
echo "Query failed near line " . __LINE__ . ": {$set1Query}";
echo "<br />Error is " . $mysqli->error;
exit;
}
while ($row = $set1Result->fetch_assoc()) {
$set1[] = $row['effect'];
}
$updateCorrelationQuery = "UPDATE staticCorrelationTest SET correlation = 1 WHERE probe1ID = " . $probes[$i]['ID'] . " AND probe2ID = " . $probes[$i]['ID'] . ";";
$updateResult = $mysqli->query($updateCorrelationQuery);
