require_once 'common.php';
require_once 'functions.php';
//dashboardInit();
$queueIDform = isset($_GET['queueID']) ? $_GET['queueID'] : null;
$condition[] = "runs.queueId = {$queueIDform}";
$linkID = connectDB();
$sql = "select " . "runStatus.runStatus, " . "runs.runExecuteMethod, " . "runs.runID, " . "runs.runMachineID, " . "runPurposes.runPurpose, " . "users.NTID, " . "versions.versionDottedQuad, " . "versions.buildNum " . "from " . "runs, " . "runStatus, " . "runPurposes, " . "users, " . "hostnames, " . "versions " . "where " . "runs.versionID = versions.versionID AND " . "runs.runPurposeID = runPurposes.runPurposeID AND " . "runs.runner = users.userID AND " . "runs.runMachineID = hostnames.hostnameID AND " . "runs.runStatusID = runStatus.runStatusID and " . implode(" and ", $condition) . " " . "ORDER BY " . "runs.startedRun DESC ";
$result = mysql_query($sql);
$data = array();
$limiteRunIDs = array();
if ($result) {
while ($myrow = mysql_fetch_assoc($result)) {
$data[runID][$myrow['runID']] = $myrow;
$limitedRunIDs[] = $myrow['runID'];
if (!isset($machine[$myrow['runMachineID']])) {
list($ip, $client, $hostnameID, $hostname) = getMachineInfo($myrow['runID']);
$machine[$hostnameID][ip] = $ip;
$machine[$hostnameID][client] = $client;
$machine[$hostnameID][hostnameID] = $hostnameID;
$machine[$hostnameID][hostname] = $hostname;
}
$data[runID][$myrow['runID']][machineIPAddr] = $machine[$myrow['runMachineID']][ip];
$data[runID][$myrow['runID']][p4Client] = $machine[$myrow['runMachineID']][client];
$data[runID][$myrow['runID']][hostname] = $machine[$myrow['runMachineID']][hostname];
$data[runID][$myrow['runID']][scriptCount] = 0;
$data[runID][$myrow['runID']][caseCount] = 0;
$data[runID][$myrow['runID']][scripts][passed] = 0;
}
}
getTestScriptResults($data, $condition, $limitedRunIDs);
$smarty = new TLSmarty();
<?php
ini_set("memory_limit", "30M");
require_once 'config.php';
require_once 'common.php';
require_once 'functions.php';
dashboardInit();
$runIDform = isset($_GET['runID']) ? $_GET['runID'] : null;
list($data['host']['ip'], $data['host']['client'], $data['host']['hostnameID'], $data['host']['hostname']) = getMachineInfo($runIDform);
$sql = "select " . "runs.runID, " . "runs.runLogPath, " . "runs.runExecuteMethod, " . "runs.runComment, " . "runPurposes.runPurpose, " . "date_format(runs.startedRun, '%b %D, %Y %r'), " . "date_format(runs.finishedRun, '%b %D, %Y %r'), " . "TIMEDIFF(runs.finishedRun,runs.startedRun), " . "pataBranches.branchName, " . "pataBranches.branchDir, " . "runStatus.runStatus, " . "concat(users.first,' ',users.last) as userName, " . "versions.buildNum, " . "versions.versionDottedQuad, " . "hostnames.hostname " . "from " . "runPurposes, " . "hostnames, " . "runs, " . "runStatus, " . "users, " . "versions, " . "pataBranches " . "where " . "runs.runID = {$runIDform} and " . "runs.runPurposeID = runPurposes.runPurposeID and " . "runs.runMachineID = hostnames.hostnameID AND " . "runs.runner = users.userID and " . "runs.versionID = versions.versionID and " . "runs.pataBranchID = pataBranches.pataBranchID and " . "runs.runStatusID = runStatus.runStatusID";
list($runData['runID'], $runData['logPath'], $runData['executeMethod'], $runData['runComment'], $runData['runPurpose'], $runData['startedRun'], $runData['finishedRun'], $runData['timeToRun'], $runData['branchName'], $runData['branchDir'], $runData['runStatus'], $runData['userName'], $runData['buildNum'], $runData['version'], $runData['hostname']) = sqlSingleRow($sql);
$runData['executeMethod'] = preg_replace("/(scpFtpPassword) (.*) (-path)/", '$1 **** $3', $runData['executeMethod']);
$sql = "select " . "scriptResults.scriptResultID, " . "scriptResults.scriptCommandLine, " . "scriptResults.scriptLogLocation, " . "scriptResults.scriptLogFile, " . "scripts.script, " . "scripts.scriptSynopsis " . "from " . "runs, " . "scripts, " . "scriptResults " . "where " . "scriptResults.scriptID = scripts.scriptID and " . "scriptResults.runID = {$runIDform} and " . "runs.runID = {$runIDform} " . "ORDER BY " . "scriptResults.scriptResultID DESC";
// establish connection to DB
$linkID = connectDB();
$result = mysql_query($sql);
if ($result) {
while ($myrow = mysql_fetch_assoc($result)) {
$data[scriptIDs][$myrow['scriptResultID']][scriptResultID] = $myrow['scriptResultID'];
$data[scriptIDs][$myrow['scriptResultID']][scriptName] = $myrow['script'];
$data[scriptIDs][$myrow['scriptResultID']][scriptSynopsis] = $myrow['scriptSynopsis'];
$data[scriptIDs][$myrow['scriptResultID']][logFile] = $runData['logPath'] . "/";
if ($myrow['scriptLogLocation'] != "") {
$data[scriptIDs][$myrow['scriptResultID']][logFile] .= "/" . $myrow['scriptLogLocation'] . "/";
}
$data[scriptIDs][$myrow['scriptResultID']][logFile] .= $myrow['scriptLogFile'];
$cmdLine = preg_replace("/-testbed\\s+\\w+/", "", $myrow['scriptCommandLine']);
$cmdLine = preg_replace("/(scpFtpPassword) (.*) (-path)/", '$1 **** $3', $cmdLine);
#$cmdLine = preg_replace("/-FILE\.\w+\s+\S+/", "", $cmdLine);
#$cmdLine = preg_replace("/-PATA_IMAGE\s+\S+/", "", $cmdLine);
$data[scriptIDs][$myrow['scriptResultID']][commandLine] = $cmdLine;
