querySingle("SELECT Id FROM Packages WHERE Name = '$package'");
if (!$package_id) {
die("Invalid package");
}
echo "History of package \"$package\"
\n";
$result = $db->query("SELECT date(datetime(Start, 'unixepoch')) as run, ResultValues.Name FROM Runs, Results, ResultValues WHERE Runs.Id = Results.Run AND Results.Result = ResultValues.Id AND Results.Package = '$package_id' ORDER BY Start DESC");
while ($entry = $result->fetchArray(SQLITE3_ASSOC)) {
$run = $entry['run'];
$build_result = $entry['Name'];
echo "$run ";
$link_exists = false;
if ($link = glob("cauldron/*/core/$run/$package-*/")) {
# Handle the case when a package is a prefix of several packages
$p = preg_quote($package);
foreach ($link as $l) {
if (preg_match("/$p-[^-]*-[^-]*$/", $l)) {
echo "$build_result
\n";
$link_exists = true;
break;
}
}
}
if (!$link_exists) {
echo "$build_result
\n";
}
}
?>