scripts/build-slaves.php


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

<html><head><title>list of build slaves</title></head><body>
<?php

  $conn = new mysqli("localhost","webserver","empty","buildmaster");
  if ($conn->connect_error) {
    die("Connection to mysql database failed: " . $conn->connect_error);
  }

  if (!$result =
    $conn->query(
      "SELECT" .
      " `build_slaves`.`name`," .
      "`build_slaves`.`operator`," .
      "`package_sources`.`pkgbase`," .
      "`build_slaves`.`last_connection`," .
      "`build_slaves`.`logged_lines`," .
      "`build_slaves`.`last_action`" .
      " FROM `build_slaves`" .
      " LEFT JOIN `build_assignments` ON" .
      " `build_slaves`.`currently_building`=`build_assignments`.`id`" .
      " LEFT JOIN `package_sources` ON" .
      " `build_assignments`.`package_source`=`package_sources`.`id`" .
      " ORDER BY `build_slaves`.`last_connection`"
    ))
    die($conn->error);

  print "<table border=1>\n";
  if ($result->num_rows > 0) {
    print "<tr><th>name</th><th>operator</th><th>currently building</th><th>last connection</th><th>logged lines</th><th>last action</th></tr>\n";
    while ($row = $result -> fetch_assoc()) {
      foreach ($row as $key => $value) {
        if ($value=="") {
          $row[$key]="&nbsp;";
        }
      }
      print "<tr>";
      print "<td>".$row["name"]."</td>";
      print "<td>".$row["operator"]."</td>";
      print "<td>".$row["pkgbase"]."</td>";
      print "<td>".$row["last_connection"]."</td>";
      print "<td>".$row["logged_lines"]."</td>";
      print "<td>".$row["last_action"]."</td>";
      print "</tr>\n";
    }
  }
  print "</table>\n";

?>
</body></html>