function insertCaseResult($newScriptResID, $crData, $srData, $dbArr, &$log)
{
$ip = '10.15.13.6';
$caseID = checkCaseExists($crData, $srData, $dbArr, $log);
$linkID = connectLGDB($dbArr[target][0], $dbArr[target][2], $dbArr[target][3], $dbArr[target][1]);
$sql = "insert into caseResults (scriptResultID,caseID,caseStatusID,published,startedCase,caseExecutionTime,caseRunComments) values (" . $newScriptResID . ", '" . $caseID . "', '" . $crData[data][caseStatusID] . "', '" . $crData[data][published] . "', '" . $crData[data][startedCase] . "', '" . $crData[data][caseExecutionTime] . "', '" . $ip . "'" . ")";
mysql_query($sql);
$log .= "INFO: CaseResult created For ScriptResultID={$newScriptResID} and caseID=<b>{$caseID}</b> in target DB.<br><br><br><br>";
mysql_close($linkID);
}
function getTestScriptResults(&$data, $condition, $limitedRunIDs = "", $lg = 0)
{
// establish connection to DB
if ($lg) {
$linkID = connectLGDB();
} else {
$linkID = connectDB();
}
$sql = "select " . "runs.runID, " . "scriptResults.scriptResultID, " . "scriptStatus.scriptStatus, " . "scripts.scriptID, " . "cases.caseID, " . "caseStatus.caseStatus, " . "caseResults.caseResultID " . "from " . "runs, " . "scriptResults, " . "caseResults, " . "runStatus, " . "scriptStatus, " . "caseStatus, " . "runPurposes, " . "versions, " . "hostnames, " . "users, " . "cases, " . "scripts " . "where " . "runs.versionID = versions.versionID AND " . "runs.runPurposeID = runPurposes.runPurposeID AND " . "runs.runStatusID = runStatus.runStatusID AND " . "runs.runner = users.userID AND " . "runs.runMachineID = hostnames.hostnameID AND " . "runs.runID = scriptResults.runID AND " . "scriptResults.scriptStatusID = scriptStatus.scriptStatusID AND " . "scriptResults.scriptResultID = caseResults.scriptResultID AND " . "caseResults.caseStatusID = caseStatus.caseStatusID AND " . "caseResults.caseID = cases.caseID AND " . "scriptResults.scriptID = scripts.scriptID and " . implode(" and ", $condition);
if ($limitedRunIDs) {
$sql .= " and runs.runID in (" . implode(",", $limitedRunIDs) . ")";
}
$result = mysql_query($sql);
if ($result) {
$xrefCount = 0;
while ($myrow = mysql_fetch_assoc($result)) {
$xrefCount++;
_setCaseResults($myrow, $xrefCount, $data);
}
}
mysql_close($linkID);
}
