1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
|
<?php
require_once "../init.php";
require_once BASE . "/lib/mysql.php";
$match = "";
function dependency_arch_join($name) {
if (array_key_exists("ba_a", $_GET)) {
return
" JOIN `architecture_compatibilities`" .
" ON `architecture_compatibilities`.`fully_compatible`" .
" AND `architecture_compatibilities`.`built_for`=`" . $name . "`.`architecture`" .
" JOIN `architectures` AS `ba_a`" .
" ON `architecture_compatibilities`.`runs_on`=`ba_a`.`id`" .
" AND `ba_a`.`name`=from_base64(\"" . base64_encode($_GET["ba_a"]) . "\")";
} elseif (array_key_exists("a", $_GET)) {
return
" JOIN `architecture_compatibilities` AS `ac_1`" .
" ON `ac_1`.`fully_compatible`" .
" AND `ac_1`.`built_for`=`" . $name . "`.`architecture`" .
" JOIN `architecture_compatibilities` AS `ac_2`" .
" ON `ac_2`.`fully_compatible`" .
" AND `ac_1`.`runs_on`=`ac_2`.`runs_on`" .
" AND `ac_2`.`built_for`=`architectures`.`id`";
} else
return "";
}
if (array_key_exists("a", $_GET))
$match .= " AND `architectures`.`name`=from_base64(\"" . base64_encode($_GET["a"]) . "\")";
if (array_key_exists("b", $_GET))
$match .= " AND `package_sources`.`pkgbase`=from_base64(\"" . base64_encode($_GET["b"]) . "\")";
if (array_key_exists("p", $_GET))
$match .= " AND `binary_packages`.`pkgname`=from_base64(\"" . base64_encode($_GET["p"]) . "\")";
if (array_key_exists("r", $_GET))
$match .= " AND `repositories`.`name`=from_base64(\"" . base64_encode($_GET["r"]) . "\")";
$ignore_install_targets = " AND NOT `install_targets`.`name` IN (\"base\",\"base-devel\")";
$colors["stable"]="#000000";
$colors["testing"]="#008000";
$colors["staging"]="#00ff00";
$colors["standalone"]="#000000";
$colors["unbuilt"]="#ff0000";
$colors["forbidden"]="#808080";
$colors["virtual"]="#800080";
$limit=200;
mysql_run_query(
"CREATE TEMPORARY TABLE `cons` (" .
"`dep` BIGINT, " .
"`itp` BIGINT, " .
"UNIQUE KEY `content` (`dep`,`itp`)" .
")"
);
mysql_run_query(
"INSERT IGNORE INTO `cons` (`dep`,`itp`)" .
" SELECT `dependencies`.`id`,`install_target_providers`.`id`".
" FROM `binary_packages`" .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
mysql_join_repositories_repository_stabilities() .
mysql_join_binary_packages_architectures() .
mysql_join_binary_packages_build_assignments() .
mysql_join_build_assignments_package_sources() .
$match .
mysql_join_binary_packages_dependencies() .
mysql_join_dependencies_dependency_types() .
mysql_join_dependencies_install_targets() .
$ignore_install_targets .
mysql_join_dependencies_install_target_providers() .
mysql_join_install_target_providers_binary_packages('','itp_bp') .
dependency_arch_join('itp_bp') .
" WHERE (`dependency_types`.`relevant_for_binary_packages` OR `repository_stabilities`.`name`=\"unbuilt\")" .
" LIMIT " . $limit
);
mysql_run_query(
"INSERT IGNORE INTO `cons` (`dep`,`itp`)" .
" SELECT `dependencies`.`id`,`install_target_providers`.`id`".
" FROM `binary_packages`" .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
mysql_join_binary_packages_architectures() .
mysql_join_binary_packages_build_assignments() .
mysql_join_build_assignments_package_sources() .
$match .
mysql_join_binary_packages_install_target_providers() .
mysql_join_install_target_providers_dependencies() .
mysql_join_dependencies_binary_packages('','d_bp') .
dependency_arch_join('d_bp') .
mysql_join_binary_packages_binary_packages_in_repositories('d_bp','d_bpir') .
mysql_join_binary_packages_in_repositories_repositories('d_bpir','d_r') .
mysql_join_repositories_repository_stabilities('d_r','d_rs') .
mysql_join_dependencies_dependency_types() .
" WHERE (`dependency_types`.`relevant_for_binary_packages` OR `d_rs`.`name`=\"unbuilt\")" .
" LIMIT " . $limit
);
$edges = "";
$knots = "";
$result = mysql_run_query(
"SELECT DISTINCT `install_target_providers`.`install_target`,`install_target_providers`.`package`" .
" FROM `cons`" .
" JOIN `install_target_providers` ON `cons`.`itp`=`install_target_providers`.`id`"
);
while ($row = $result->fetch_assoc())
$edges .= "\"p" . $row["package"] . "\" -> \"i" . $row["install_target"] . "\" [color = \"#000080\"];\n";
$result = mysql_run_query(
"SELECT DISTINCT `dependencies`.`dependent`,`dependencies`.`depending_on`,`dependency_types`.`name`" .
" FROM `cons`" .
" JOIN `dependencies` ON `cons`.`dep`=`dependencies`.`id`" .
mysql_join_dependencies_dependency_types()
);
while ($row = $result->fetch_assoc())
$edges .= "\"i" . $row["depending_on"] . "\" -> \"p" . $row["dependent"] . "\" [taillabel = \"" . $row["name"] . "\"];\n";
$result = mysql_run_query(
"SELECT DISTINCT `install_targets`.`id`,`install_targets`.`name`" .
" FROM `cons`" .
" JOIN `dependencies` ON `cons`.`dep`=`dependencies`.`id`" .
mysql_join_dependencies_install_targets()
);
while ($row = $result->fetch_assoc())
$knots .= "\"i" . $row["id"] . "\" [label = \"" . $row["name"] . "\", fontcolor = \"#000080\"];\n";
$pkgfile_query =
"CONCAT(".
"`repositories`.`name`,\"/\"," .
"`binary_packages`.`pkgname`,\"-\"," .
mysql_query_package_version("binary_packages") .
",\"-\"," .
"`architectures`.`name`" .
") AS `filename`";
$result = mysql_run_query(
"SELECT DISTINCT " .
"`binary_packages`.`id`," .
"`repository_stabilities`.`name` AS `stability`," .
$pkgfile_query .
" FROM `cons`" .
" JOIN `dependencies` ON `cons`.`dep`=`dependencies`.`id`" .
mysql_join_dependencies_binary_packages() .
mysql_join_binary_packages_architectures() .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
mysql_join_repositories_repository_stabilities()
);
while ($row = $result->fetch_assoc())
$knots .= "\"p" . $row["id"] . "\" [label = \"" . $row["filename"] . "\", fontcolor = \"" . $colors[$row["stability"]] . "\"];\n";
$result = mysql_run_query(
"SELECT DISTINCT " .
"`binary_packages`.`id`," .
"`repository_stabilities`.`name` AS `stability`," .
$pkgfile_query .
" FROM `cons`" .
" JOIN `install_target_providers` ON `cons`.`itp`=`install_target_providers`.`id`" .
mysql_join_install_target_providers_binary_packages() .
mysql_join_binary_packages_architectures() .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
mysql_join_repositories_repository_stabilities()
);
while ($row = $result->fetch_assoc())
$knots .= "\"p" . $row["id"] . "\" [label = \"" . $row["filename"] . "\", fontcolor = \"" . $colors[$row["stability"]] . "\"];\n";
$knots = str_replace("\$","\\\$",$knots);
$edges = str_replace("\$","\\\$",$edges);
header ("Content-type: image/png");
passthru(
"timeout 30 dot -Tpng -o/dev/stdout /dev/stdin <<EOF\n" .
"digraph dependencies {\n" .
"rankdir=LR;\n" .
"fontname=dejavu;\n" .
$knots .
$edges .
"}\n" .
"EOF\n"
);
|