array(
"name" => "arch",
"title" => "CPU architecture",
"label" => "Arch",
"source_table" => "architectures",
"query_pre" => "`ba_q`.`arch` IN (",
"query_in_pre" => "\"",
"query_in_post" => "\",",
"query_post" => "\"\")",
"values" => array()
),
"repo" => array(
"name" => "repo",
"title" => "Repository",
"label" => "Repo",
"source_table" => "upstream_repositories",
"query_pre" => "`ba_q`.`package_repository` IN (",
"query_in_pre" => "\"",
"query_in_post" => "\",",
"query_post" => "\"\")",
"values" => array()
),
"failures" => array(
"name" => "failures",
"title" => "Fail Reasons",
"label" => "Failures",
"source_table" => "fail_reasons",
"query_pre" => "(0",
"query_in_pre" => " OR `fr_q`.`fail_reasons_raw` LIKE \"%,",
"query_in_post" => ",%\"",
"query_post" => ")",
"values" => array()
)
);
foreach ( $multi_select_search_criteria as $criterium => $content ) {
$result = mysql_run_query(
"SELECT `name` FROM `" . $content["source_table"] . "` ORDER BY `name`"
);
while ($row = $result -> fetch_assoc())
$multi_select_search_criteria[$criterium]["values"][] = $row["name"];
}
foreach ( $multi_select_search_criteria as $criterium ) {
if (array_key_exists($criterium['name'], $_GET)) {
$filter .= " AND " . $criterium["query_pre"];
foreach ($criterium["values"] as $value)
if (strpos("&" . $_SERVER["QUERY_STRING"] . "&", "&" . $criterium["name"] . "=" . urlencode($value) . "&") !== false)
$filter .= $criterium["query_in_pre"] . $value . $criterium["query_in_post"];
$filter .= $criterium["query_post"];
}
}
$single_select_search_criteria = array(
"broken" => array(
"name" => "broken",
"label" => "Is Broken",
"title" => "is broken",
"options" => array(
"All" => "1",
"Broken" => "(`ba_q`.`is_broken` OR `ba_q`.`is_blocked` IS NOT NULL)",
"Not Broken" => "NOT (`ba_q`.`is_broken` OR `ba_q`.`is_blocked` IS NOT NULL)"
)
),
"next" => array(
"name" => "next",
"label" => "Can Be Built",
"title" => "can be built",
"options" => array(
"All" => "1",
// "Can" => "(`l_q`.`loops` IS NOT NULL OR (`rd_q`.`run_dependencies_pending` IS NULL AND `md_q`.`make_dependencies_pending` IS NULL))",
"Can" => "(`l_q`.`loops` IS NOT NULL OR `rd_q`.`run_dependencies_pending` IS NULL)",
// "Can't" => "NOT (`l_q`.`loops` IS NOT NULL OR (`rd_q`.`run_dependencies_pending` IS NULL AND `md_q`.`make_dependencies_pending` IS NULL))"
"Can't" => "NOT (`l_q`.`loops` IS NOT NULL OR `rd_q`.`run_dependencies_pending` IS NULL)"
)
)
);
foreach ($single_select_search_criteria as $criterium)
if (isset($_GET[$criterium["name"]]) &&
isset($criterium["options"][$_GET[$criterium["name"]]]))
$filter .= " AND " . $criterium["options"][$_GET[$criterium["name"]]];
$columns = array(
"priority" => array(
"label" => "Priority",
"mysql_name" => "priority",
"mysql_query" => "`ba_q`.`priority`",
"sort" => "priority",
"title" => "priority"
),
"deps" => array(
"label" => "Deps",
"mysql_name" => "dependencies_pending",
// "mysql_query" => "IFNULL(`rd_q`.`run_dependencies_pending`,0)+IFNULL(`md_q`.`make_dependencies_pending`,0)",
"mysql_query" => "IFNULL(`rd_q`.`run_dependencies_pending`,0)",
"sort" => "deps",
"title" => "number of dependencies on the build-list"
),
"blocks" => array(
"label" => "Blocks",
"mysql_name" => "dependending_blocked",
"mysql_query" => "IFNULL(`ba_q`.`currently_blocking`,0)",
"sort" => "blocks",
"sort_reverse" => true,
"title" => "number of dependending build orders on the build-list"
),
"arch" => array(
"label" => "Arch",
"mysql_name" => "arch",
"mysql_query" => "`ba_q`.`arch`",
"sort" => "arch",
"title" => "arch"
),
"pkgbase" => array(
"label" => "Package",
"mysql_name" => "pkgbase_print",
"mysql_query" =>
"CONCAT(" .
"\"\"," .
"`ba_q`.`pkgbase`," .
"\"\"" .
")",
"sort" => "pkgbase",
"title" => "package"
),
"git_rev" => array(
"label" => "Git Revision",
"mysql_name" => "git_revision_print",
"mysql_query" =>
"IF(`ba_q`.`uses_upstream`," .
"CONCAT(" .
"\"\"," .
"`ba_q`.`git_revision`," .
"\"\"" .
")," .
"`ba_q`.`git_revision`" .
")",
"sort" => "git_rev",
"title" => "revision hash of upstream git repository"
),
"mod_git_rev" => array(
"label" => "Modification Git Revision",
"mysql_name" => "mod_git_revision_print",
"mysql_query" =>
"IF(`ba_q`.`uses_modification`," .
"CONCAT(" .
"\"\"," .
"`ba_q`.`mod_git_revision`," .
"\"\"" .
")," .
"`ba_q`.`mod_git_revision`" .
")" ,
"sort" => "mod_git_rev",
"title" => "revision hash of modification git repository"
),
"repo" => array(
"label" => "Repository",
"mysql_name" => "package_repository",
"mysql_query" => "`ba_q`.`package_repository`",
"sort" => "repo",
"title" => "package repository"
),
"commit_time" => array(
"label" => "Commit Time",
"mysql_name" => "commit_time",
"mysql_query" => "`ba_q`.`commit_time`",
"sort" => "commit_time",
"title" => "commit time of the source"
),
"trials" => array(
"label" => "Compilations",
"mysql_name" => "trials",
"mysql_query" => "IFNULL(`t_q`.`trials`,0)",
"sort" => "trials",
"title" => "number of compilations"
),
"loops" => array(
"label" => "Loops",
"mysql_name" => "loops",
"mysql_query" => "IFNULL(`l_q`.`loops`,0)",
"sort" => "loops",
"title" => "number of loops"
),
"failure" => array(
"label" => "Failures",
"mysql_name" => "fail_reasons",
"mysql_query" => "`fr_q`.`fail_reasons_print`",
"sort" => "failure",
"title" => "reason of build failure"
),
"blocked" => array(
"label" => "Blocked",
"mysql_name" => "is_blocked",
"mysql_query" => "`ba_q`.`is_blocked`",
"sort" => "blocked",
"title" => "block reason"
),
"upstream_flag_date" => array(
"label" => "Upstream Flag Date",
"mysql_name" => "upstream_flag_date",
"mysql_query" => "IF(`ba_q`.`upstream_flag_date`=\"0000-00-00 00:00:00\",NULL,`ba_q`.`upstream_flag_date`)",
"sort" => "blocked",
"title" => "block reason"
),
"build_slave" => array(
"label" => "Build Slave",
"mysql_name" => "build_slave",
"mysql_query" => "`bs_q`.`build_slave`",
"sort" => "build_slave",
"title" => "whom it is handed out to"
)
);
if (!array_key_exists("sort", $_GET))
$_GET["sort"] = "blocks";
if (substr($_GET["sort"],0,1) == "-") {
$direction = " DESC";
$sort = substr($_GET["sort"],1);
} else {
$direction = " ASC";
$sort = $_GET["sort"];
}
if (isset($columns[$sort]))
$order = "IFNULL(" . $columns[$sort]["mysql_name"] . ",0) " . $direction . ",";
if (array_key_exists("sort_reverse", $columns[$sort]))
$order = "-" . $order;
else
$order = "";
function combine_fields($cln) {
return $cln["mysql_query"] . " AS `" . $cln["mysql_name"] . "`";
}
mysql_run_query(
'CREATE TEMPORARY TABLE `ba_q`(' .
'`id` BIGINT,' .
'`is_blocked` VARCHAR(128),' .
'`is_broken` BIT,' .
'`priority` SMALLINT,' .
'`currently_blocking` MEDIUMINT,' .
'`pkgbase` VARCHAR(64),' .
'`git_revision` VARCHAR(40),' .
'`mod_git_revision` VARCHAR(40),' .
'`uses_upstream` BIT,' .
'`uses_modification` BIT,' .
'`commit_time` TIMESTAMP,' .
'`upstream_flag_date` TIMESTAMP,' .
'`package_repository` VARCHAR(64),' .
'`git_repository` VARCHAR(64),' .
'`arch` VARCHAR(16),' .
'PRIMARY KEY `id`(`id`)' .
')'
);
mysql_run_query(
'INSERT INTO `ba_q`' .
' SELECT DISTINCT' .
' `build_assignments`.`id`,' .
'`build_assignments`.`is_blocked`,' .
'`build_assignments`.`is_broken`,' .
'`build_assignments`.`priority`,' .
'`build_assignments`.`currently_blocking`,' .
'`package_sources`.`pkgbase`,' .
'`package_sources`.`git_revision`,' .
'`package_sources`.`mod_git_revision`,' .
'`package_sources`.`uses_upstream`,' .
'`package_sources`.`uses_modification`,' .
'`package_sources`.`commit_time`,' .
'`package_sources`.`upstream_flag_date`,' .
'`upstream_repositories`.`name`,' .
'`git_repositories`.`name`,' .
'`architectures`.`name`' .
' FROM `build_assignments`' .
mysql_join_build_assignments_architectures() .
mysql_join_build_assignments_package_sources() .
mysql_join_package_sources_upstream_repositories() .
mysql_join_upstream_repositories_git_repositories() .
mysql_join_build_assignments_binary_packages() .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
' WHERE `repositories`.`name`="build-list"'
);
mysql_run_query(
'CREATE TEMPORARY TABLE `rd_q`(' .
'`build_assignment` BIGINT,' .
'`run_dependencies_pending` MEDIUMINT,' .
'PRIMARY KEY `build_assignment`(`build_assignment`)' .
')'
);
mysql_run_query(
'INSERT INTO `rd_q`' .
'SELECT' .
' `dependent_bp`.`build_assignment`,' .
'COUNT(DISTINCT `dependency_bp`.`build_assignment`)' .
' FROM `binary_packages` AS `dependent_bp`' .
// only consider ba_q build assignments!
mysql_join_binary_packages_build_assignments('dependent_bp','ba_q') .
mysql_join_binary_packages_dependencies('dependent_bp') .
mysql_join_dependencies_dependency_types() .
mysql_join_dependencies_install_target_providers() .
mysql_join_install_target_providers_binary_packages('','dependency_bp') .
mysql_join_binary_packages_binary_packages_in_repositories('dependency_bp') .
mysql_join_binary_packages_build_assignments('dependent_bp','dependent_ba') .
mysql_join_binary_packages_build_assignments('dependency_bp','dependency_ba') .
' JOIN `architecture_compatibilities` AS `ac_a`'.
' ON `ac_a`.`fully_compatible`'.
' AND `ac_a`.`built_for`=`dependency_ba`.`architecture`'.
' JOIN `architecture_compatibilities` AS `ac_b`'.
' ON `ac_b`.`fully_compatible`'.
' AND `ac_b`.`built_for`=`dependent_ba`.`architecture`'.
' AND `ac_b`.`runs_on`=`ac_a`.`runs_on`'.
mysql_join_binary_packages_in_repositories_repositories() .
' WHERE `dependency_bp`.`build_assignment` != `dependent_bp`.`build_assignment`' .
' AND `dependency_types`.`relevant_for_building`' .
' AND `dependency_types`.`relevant_for_binary_packages`' .
' AND `repositories`.`name`="build-list"' .
' GROUP BY `dependent_bp`.`build_assignment`'
);
/*
mysql_run_query(
'CREATE TEMPORARY TABLE `md_q`(' .
'`build_assignment` BIGINT,' .
'`make_dependencies_pending` MEDIUMINT,' .
'PRIMARY KEY `build_assignment`(`build_assignment`)' .
')'
);
mysql_run_query(
'INSERT INTO `md_q`' .
' SELECT' .
' `dependent_bp`.`build_assignment`,' .
'COUNT(DISTINCT `dependencies`.`id`)' .
' FROM `binary_packages` AS `dependent_bp`' .
// only consider ba_q build assignments!
mysql_join_binary_packages_build_assignments('dependent_bp','ba_q') .
mysql_join_binary_packages_dependencies('dependent_bp') .
mysql_join_dependencies_dependency_types() .
mysql_join_binary_packages_build_assignments('dependent_bp','dependent_ba') .
' JOIN `architecture_compatibilities` AS `ac_b`' .
' ON `ac_b`.`fully_compatible`' .
' AND `ac_b`.`built_for`=`dependent_ba`.`architecture`' .
' WHERE NOT EXISTS(' .
'SELECT 1 FROM `install_target_providers`' .
mysql_join_install_target_providers_binary_packages('','dependency_bp') .
mysql_join_binary_packages_binary_packages_in_repositories('dependency_bp','dependency_bpir') .
mysql_join_binary_packages_in_repositories_repositories('dependency_bpir') .
mysql_join_binary_packages_build_assignments('dependency_bp','dependency_ba') .
' JOIN `architecture_compatibilities` AS `ac_a`' .
' ON `ac_a`.`fully_compatible`' .
' AND `ac_a`.`built_for`=`dependency_ba`.`architecture`' .
' WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`' .
' AND `repositories`.`is_on_master_mirror`' .
' AND `ac_b`.`runs_on`=`ac_a`.`runs_on`' .
')' .
' AND `dependency_types`.`relevant_for_building`' .
' AND NOT `dependency_types`.`relevant_for_binary_packages`' .
' GROUP BY `dependent_bp`.`build_assignment`'
);
*/
mysql_run_query(
'CREATE TEMPORARY TABLE `l_q`(' .
'`build_assignment` BIGINT,' .
'`loops` MEDIUMINT,' .
'PRIMARY KEY `build_assignment`(`build_assignment`)' .
')'
);
mysql_run_query(
'INSERT INTO `l_q`' .
' SELECT' .
' `build_dependency_loops`.`build_assignment`,' .
'COUNT(1)' .
' FROM `build_dependency_loops`' .
// no need to filter for ba_q build assignments: only *those* can be in loops anyways
' GROUP BY `build_dependency_loops`.`build_assignment`'
);
mysql_run_query(
'CREATE TEMPORARY TABLE `fr_q`(' .
'`build_assignment` BIGINT,' .
'`fail_reasons_print` TEXT,' .
'`fail_reasons_raw` TEXT,' .
'PRIMARY KEY `build_assignment`(`build_assignment`)' .
')'
);
mysql_run_query(
'INSERT INTO `fr_q`' .
' SELECT' .
' `rfb`.`build_assignment`,' .
'GROUP_CONCAT(' .
'CONCAT(' .
'"",' .
'`fail_reasons`.`name`,' .
'""' .
')' .
' ORDER BY `fail_reasons`.`name`' .
'),' .
'CONCAT(' .
'",",' .
'GROUP_CONCAT(' .
'`fail_reasons`.`name`' .
'),' .
'","' .
')' .
' FROM (' .
'SELECT ' .
'`failed_builds`.`build_assignment`,' .
'`failed_builds`.`reason`,' .
'MAX(`failed_builds`.`date`) AS `max_date`' .
' FROM `failed_builds`' .
// no need to filter for ba_q build assignments: only *those* can be failed anyways
' GROUP BY `failed_builds`.`build_assignment`,`failed_builds`.`reason`' .
') AS `cfb`' .
' JOIN' .
' (' .
'SELECT DISTINCT ' .
'`failed_builds`.*' .
' FROM `failed_builds`' .
' GROUP BY `failed_builds`.`build_assignment`,`failed_builds`.`reason`,`failed_builds`.`date`' .
') AS `rfb`' .
' ON `cfb`.`build_assignment`=`rfb`.`build_assignment`' .
' AND `cfb`.`reason`=`rfb`.`reason`' .
' AND `cfb`.`max_date`=`rfb`.`date`' .
mysql_join_failed_builds_fail_reasons('rfb') .
' GROUP BY `rfb`.`build_assignment`'
);
mysql_run_query(
'CREATE TEMPORARY TABLE `t_q`(' .
'`build_assignment` BIGINT,' .
'`trials` MEDIUMINT,' .
'PRIMARY KEY `build_assignment`(`build_assignment`)' .
')'
);
mysql_run_query(
'INSERT INTO `t_q`' .
' SELECT' .
' `failed_builds`.`build_assignment`,' .
'COUNT(`failed_builds`.`id`)' .
' FROM `failed_builds`' .
// no need to filter for ba_q build assignments: only *those* can be failed anyways
' GROUP BY `failed_builds`.`build_assignment`'
);
mysql_run_query(
'CREATE TEMPORARY TABLE `bs_q` (' .
'`currently_building` BIGINT,' .
'`build_slave` VARCHAR(32),' .
'PRIMARY KEY `currently_building`(`currently_building`)' .
')'
);
mysql_run_query(
'INSERT INTO `bs_q`' .
' SELECT' .
' `build_slaves`.`currently_building`,' .
'GROUP_CONCAT(`build_slaves`.`name`) AS `build_slave`' .
' FROM `build_slaves`' .
' WHERE NOT `build_slaves`.`currently_building` IS NULL' .
' GROUP BY `build_slaves`.`currently_building`'
);
$result = mysql_run_query(
'SELECT ' .
implode(',', array_map('combine_fields', $columns)) .
' FROM `ba_q`'.
' LEFT JOIN `rd_q`' .
' ON `rd_q`.`build_assignment`=`ba_q`.`id`' .
// ' LEFT JOIN `md_q`' .
// ' ON `md_q`.`build_assignment`=`ba_q`.`id`' .
' LEFT JOIN `l_q`' .
' ON `l_q`.`build_assignment`=`ba_q`.`id`' .
' LEFT JOIN `fr_q`' .
' ON `fr_q`.`build_assignment`=`ba_q`.`id`' .
' LEFT JOIN `t_q`' .
' ON `t_q`.`build_assignment`=`ba_q`.`id`' .
' LEFT JOIN `bs_q`' .
' ON `bs_q`.`currently_building`=`ba_q`.`id`' .
$filter .
" ORDER BY " . $order . "`trials` " . $direction . ",`dependencies_pending` " . $direction . ",`is_blocked` " . $direction . ",`pkgbase` " . $direction
);
$count = 0;
while($row = $result->fetch_assoc()) {
foreach ($row as $name => $value) {
if (!isset($row[$name]))
$rows[$count][$name] = " ";
elseif ($name == "is_blocked")
$rows[$count][$name] = preg_replace(
array (
"/FS32#(\\d+)/",
"/FS#(\\d+)/"
),
array (
"$0",
"$0"
),
$value
);
else
$rows[$count][$name] = $value;
}
$count++;
}
print_header("List of Package Builds");
?>
build logs
\n";
}
?>
/>
>
invert match
\n";
print " \n";
print " \n";
}
?>
0) {
?>
\n";
print " \n";
print " " . $column["label"] . "\n";
print " \n";
print " \n";
}
?>
\n";
foreach ($columns as $column) {
print " \n";
print " " . $row[$column["mysql_name"]] . "\n";
print " | \n";
}
print " \n";
if ($oddity == "odd" )
$oddity = "even";
else
$oddity = "odd";
}
?>