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'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" ), "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" ), "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` BIT,' . '`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,' . '`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`,' . '`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 " \n"; if ($oddity == "odd" ) $oddity = "even"; else $oddity = "odd"; } ?>
\n"; print " " . $row[$column["mysql_name"]] . "\n"; print "