Example #1
0
function imm_prev_suite_test($breakdown_id)
{
    $query = mysql_query("SELECT mode_id, machine, sort_order, suite_test_id\n                          FROM `awfy_breakdown`\n                          LEFT JOIN awfy_score ON awfy_score.id = score_id\n                          LEFT JOIN awfy_build ON awfy_build.id = awfy_score.build_id\n                          LEFT JOIN awfy_run ON awfy_run.id = run_id\n                          WHERE awfy_breakdown.id = " . $breakdown_id) or die(mysql_error());
    $data = mysql_fetch_assoc($query);
    $prev = prev_suite_test($data["sort_order"], $data["machine"], $data["mode_id"], $data["suite_test_id"]);
    if (count($prev) == 1) {
        return $prev[0]["id"];
    }
    return 0;
}
    $machine = get("run", $run_id, "machine");
    $mode_id = get("build", $build_id, "mode_id");
    if ($request->type == "prev") {
        $prev = prev_($stamp, $machine, $mode_id, $suite_version_id, (int) $request->amount);
        $last = array_pop($prev);
    } else {
        $next = next_($stamp, $machine, $mode_id, $suite_version_id, (int) $request->amount);
        $last = array_pop($next);
    }
    $build_id = get("score", $last["id"], "build_id");
} else {
    $suite_test_id = get("breakdown", (int) $request->breakdown_id, "suite_test_id");
    $score_id = get("breakdown", (int) $request->breakdown_id, "score_id");
    $build_id = get("score", (int) $score_id, "build_id");
    $run_id = get("build", $build_id, "run_id");
    $stamp = get("run", $run_id, "stamp");
    $machine = get("run", $run_id, "machine");
    $mode_id = get("build", $build_id, "mode_id");
    if ($request->type == "prev") {
        $prev = prev_suite_test($stamp, $machine, $mode_id, $suite_test_id, (int) $request->amount);
        $last = array_pop($prev);
    } else {
        $next = next_suite_test($stamp, $machine, $mode_id, $suite_test_id, (int) $request->amount);
        $last = array_pop($next);
    }
    $score_id = get("breakdown", $last["id"], "score_id");
    $build_id = get("score", $score_id, "build_id");
}
$run_id = get("build", $build_id, "run_id");
$stamp = get("run", $run_id, "stamp");
echo $stamp;
Example #3
0
/* This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
require_once "../internals.php";
require_once "data-func.php";
init_database();
$postdata = file_get_contents("php://input");
$request = json_decode($postdata);
$request->id = (int) $request->id;
if (!isset($request->subtest)) {
    $request->subtest = false;
}
if ($request->subtest == 1 || $request->subtest == 'true') {
    $query = mysql_query("SELECT mode_id, machine, finish_stamp as stamp, awfy_breakdown.score, suite_test_id, sort_order\n                          FROM `awfy_breakdown`\n                          LEFT JOIN awfy_score ON awfy_score.id = score_id\n                          LEFT JOIN awfy_build ON awfy_build.id = awfy_score.build_id\n                          LEFT JOIN awfy_run ON awfy_run.id = run_id\n                          WHERE awfy_breakdown.id = " . $request->id) or die(mysql_error());
    $data = mysql_fetch_assoc($query);
    $prev = prev_suite_test($data["sort_order"], $data["machine"], $data["mode_id"], $data["suite_test_id"]);
    if (count($prev) == 1) {
        $data["prev_score"] = $prev[0]["score"];
    }
    $data["suite_version_id"] = get("suite_test", $data["suite_test_id"], "suite_version_id");
    $data["suite_test"] = get("suite_test", $data["suite_test_id"], "name");
    die(json_encode($data));
} else {
    $query = mysql_query("SELECT mode_id, machine, finish_stamp as stamp, score, suite_version_id, sort_order\n                          FROM `awfy_score`\n                          LEFT JOIN awfy_build ON awfy_build.id = build_id\n                          LEFT JOIN awfy_run ON awfy_run.id = run_id\n                          WHERE awfy_score.id = " . $request->id) or die(mysql_error());
    $data = mysql_fetch_assoc($query);
    $prev = prev_($data["sort_order"], $data["machine"], $data["mode_id"], $data["suite_version_id"]);
    if (count($prev) == 1) {
        $data["prev_score"] = $prev[0]["score"];
    }
    die(json_encode($data));
}
Example #4
0
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
require_once "../internals.php";
require_once "data-func.php";
init_database();
$postdata = file_get_contents("php://input");
$request = json_decode($postdata);
$request->id = (int) $request->id;
if (!isset($request->subtest)) {
    $request->subtest = false;
}
$prev_build_id = 0;
if ($request->subtest == 1 || $request->subtest == 'true') {
    $query = mysql_query("SELECT mode_id, machine, stamp, awfy_breakdown.score, suite_test_id, build_id\n                          FROM `awfy_breakdown`\n                          LEFT JOIN awfy_score ON awfy_score.id = score_id\n                          LEFT JOIN awfy_build ON awfy_build.id = awfy_score.build_id\n                          LEFT JOIN awfy_run ON awfy_run.id = run_id\n                          WHERE awfy_breakdown.id = " . $request->id) or die(mysql_error());
    $data = mysql_fetch_assoc($query);
    $prev = prev_suite_test($data["stamp"], $data["machine"], $data["mode_id"], $data["suite_test_id"]);
    if (count($prev) == 1) {
        $prev_breakdown_id = $prev[0]["id"];
        $prev_score_id = get("breakdown", $prev_breakdown_id, "score_id");
        $prev_build_id = get("score", $prev_score_id, "build_id");
    }
    $build_id = $data["build_id"];
} else {
    $query = mysql_query("SELECT mode_id, machine, stamp, score, suite_version_id, build_id\n                          FROM `awfy_score`\n                          LEFT JOIN awfy_build ON awfy_build.id = build_id\n                          LEFT JOIN awfy_run ON awfy_run.id = run_id\n                          WHERE awfy_score.id = " . $request->id) or die(mysql_error());
    $data = mysql_fetch_assoc($query);
    $prev = prev_($data["stamp"], $data["machine"], $data["mode_id"], $data["suite_version_id"]);
    if (count($prev) == 1) {
        $prev_score_id = $prev[0]["id"];
        $prev_build_id = get("score", $prev_score_id, "build_id");
    }
    $build_id = $data["build_id"];