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 (isset($_GET[$criterium["name"]])) { $filter .= " AND " . $criterium["query_pre"]; foreach ($criterium["values"] as $value) if (strpos("&" . $_SERVER["QUERY_STRING"] . "&", "&" . $criterium["name"] . "=" . $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't" => "NOT (`l_q`.`loops` IS NOT NULL OR (`rd_q`.`run_dependencies_pending` IS NULL AND `md_q`.`make_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)", "sort" => "deps", "title" => "number of dependencies 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" ), "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 (!isset($_GET["sort"])) $_GET["sort"]="trials"; 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 . ","; else $order = ""; function combine_fields($cln) { return $cln["mysql_query"] . " AS `" . $cln["mysql_name"] . "`"; } $result = mysql_run_query( "SELECT " . implode(",",array_map("combine_fields",$columns)) . " FROM" . " (" . "SELECT DISTINCT " . "`build_assignments`.`id`," . "`build_assignments`.`is_blocked`," . "`build_assignments`.`is_broken`," . "`build_assignments`.`priority`," . "`package_sources`.`pkgbase`," . "`package_sources`.`git_revision`," . "`package_sources`.`mod_git_revision`," . "`package_sources`.`uses_upstream`," . "`package_sources`.`uses_modification`," . "`package_sources`.`commit_time`," . "`upstream_repositories`.`name` AS `package_repository`," . "`git_repositories`.`name` AS `git_repository`," . "`architectures`.`name` AS `arch`" . " FROM `build_assignments`" . " JOIN `architectures` ON `build_assignments`.`architecture` = `architectures`.`id`" . " JOIN `package_sources` ON `build_assignments`.`package_source` = `package_sources`.`id`" . " JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository` = `upstream_repositories`.`id`" . " JOIN `git_repositories` ON `upstream_repositories`.`git_repository`=`git_repositories`.`id`" . " JOIN `binary_packages` ON `binary_packages`.`build_assignment` = `build_assignments`.`id`" . " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id` = `binary_packages_in_repositories`.`package`" . " JOIN `repositories` ON `binary_packages_in_repositories`.`repository` = `repositories`.`id`" . " WHERE `repositories`.`name`=\"build-list\"" . ") AS `ba_q`". " LEFT JOIN" . " (" . "SELECT " . "`dependent_bp`.`build_assignment`," . "COUNT(DISTINCT `dependency_bp`.`build_assignment`) AS `run_dependencies_pending`" . " FROM `binary_packages` AS `dependent_bp`" . " JOIN `dependencies` ON `dependencies`.`dependent` = `dependent_bp`.`id`" . " JOIN `dependency_types` ON `dependencies`.`dependency_type` = `dependency_types`.`id`" . " JOIN `install_target_providers` ON `install_target_providers`.`install_target` = `dependencies`.`depending_on`" . " JOIN `binary_packages` AS `dependency_bp` ON `dependency_bp`.`id` = `install_target_providers`.`package`" . " JOIN `binary_packages_in_repositories` ON `dependency_bp`.`id` = `binary_packages_in_repositories`.`package`" . " JOIN `repositories` ON `binary_packages_in_repositories`.`repository` = `repositories`.`id`" . " 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`" . ") AS `rd_q` ON `rd_q`.`build_assignment`=`ba_q`.`id`" . " LEFT JOIN" . " (" . "SELECT " . "`dependent_bp`.`build_assignment`," . "COUNT(DISTINCT `dependencies`.`id`) AS `make_dependencies_pending`" . " FROM `binary_packages` AS `dependent_bp`" . " JOIN `dependencies` ON `dependencies`.`dependent` = `dependent_bp`.`id`" . " JOIN `dependency_types` ON `dependencies`.`dependency_type` = `dependency_types`.`id`" . " WHERE NOT EXISTS(" . "SELECT 1 FROM `install_target_providers`" . " JOIN `binary_packages` AS `dependency_bp` ON `dependency_bp`.`id` = `install_target_providers`.`package`" . " JOIN `binary_packages_in_repositories` ON `dependency_bp`.`id` = `binary_packages_in_repositories`.`package`" . " JOIN `repositories` ON `binary_packages_in_repositories`.`repository` = `repositories`.`id`" . " WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`" . " AND `repositories`.`is_on_master_mirror`" . ")" . " AND `dependency_types`.`relevant_for_building`" . " AND NOT `dependency_types`.`relevant_for_binary_packages`" . " GROUP BY `dependent_bp`.`build_assignment`" . ") AS `md_q` ON `md_q`.`build_assignment`=`ba_q`.`id`" . " LEFT JOIN" . " (" . "SELECT " . "`build_dependency_loops`.`build_assignment`," . "COUNT(1) AS `loops`" . " FROM `build_dependency_loops`" . " GROUP BY `build_dependency_loops`.`build_assignment`" . ") AS `l_q` ON `l_q`.`build_assignment`=`ba_q`.`id`" . " LEFT JOIN" . " (" . "SELECT " . "`rfb`.`build_assignment`," . "GROUP_CONCAT(" . "CONCAT(" . "\"\"," . "`fail_reasons`.`name`," . "\"\"" . ")" . " ORDER BY `fail_reasons`.`name`" . ") AS `fail_reasons_print`," . "CONCAT(" . "\",\"," . "GROUP_CONCAT(" . "`fail_reasons`.`name`" . ")," . "\",\"" . ") AS `fail_reasons_raw`" . " FROM (" . "SELECT " . "`failed_builds`.`build_assignment`," . "`failed_builds`.`reason`," . "MAX(`failed_builds`.`date`) AS `max_date`" . " FROM `failed_builds`" . " 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`" . " JOIN `fail_reasons` ON `rfb`.`reason`=`fail_reasons`.`id`" . " GROUP BY `rfb`.`build_assignment`" . ") AS `fr_q` ON `fr_q`.`build_assignment`=`ba_q`.`id`" . " LEFT JOIN" . " (" . "SELECT " . "`failed_builds`.`build_assignment`," . "COUNT(`failed_builds`.`id`) AS `trials`" . " FROM `failed_builds`" . " GROUP BY `failed_builds`.`build_assignment`" . ") AS `t_q` ON `t_q`.`build_assignment`=`ba_q`.`id`" . " LEFT JOIN" . " (" . "SELECT " . "`build_slaves`.`currently_building`," . "GROUP_CONCAT(`build_slaves`.`name`) AS `build_slave`" . " FROM `build_slaves`" . " GROUP BY `build_slaves`.`currently_building`" . ") AS `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 " \n"; if ($oddity == "odd" ) $oddity = "even"; else $oddity = "odd"; } ?>
\n"; print " " . $row[$column["mysql_name"]] . "\n"; print "