summaryrefslogtreecommitdiff
path: root/buildmaster/dependencies.php
blob: c513f2d27989a163b44aab706be9c226e865fac7 (plain)
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"
);