- show error when the query fails.

[projects/buildlogs.git] / obsolete / buildlogs.sql / addlog.php

#!/usr/bin/php.cli
<?php
// $Revision: 1.4 $, $Date: 2007-11-24 17:00:46 $
$database = 'sqlite:/home/services/ftp/buildlogs.db';
$root_directory = '/home/services/ftp/pub/pld-buildlogs';
// $database and $root_directory are taken from buildlogs.inc .
include_once('buildlogs.inc');
// parameter: argv[1] - full path to the log file.
// Keep in sync with database
$result = array("FAIL" => 0, "OK" => 1);
$arch = array(
	"th/SRPMS" => 1,
	"th/i486" => 2,
	"th/i686" => 3,
	"th/athlon" => 4,
	"th/x86_64" => 5,
	"th/ia64" => 6,
	"th/alpha" => 7,
	"th/ppc" => 8,
	"th/sparc" => 9,
	"ac/SRPMS" => 10,
	"ac/i386" => 11,
	"ac/i586" => 12,
	"ac/i686" => 13,
	"ac/athlon" => 14,
	"ac/amd64" => 15,
	"ac/alpha" => 16,
	"ac/ppc" => 17,
	"ac/sparc" => 18,
	"ac/sparc64" => 19
);

if (!isset($argv[1])) {
	die("Usage: $argv[0] full_path_to_the_log\n");
}
preg_match("|$root_directory/(.*/.*)/(.*)/(.*)\.bz2|", $argv[1], $matches);

$arch_name = $matches[1];
if (!array_key_exists($arch_name, $arch)) {
	die("$argv[1]: Nieznana architektura \"$arch_name\"\n");
}
else $arch_id = $arch[$arch_name];

$result_name = $matches[2];
if (!array_key_exists($result_name, $result)) {
	die("$argv[1]: Nieznany resultat \"$result_name\"\n");
}
else $result_id = $result[$result_name];

$spec_name = $matches[3];
if ($spec_name == '') {
	die("$argv[1]: Brak nazwy speca.\n");
}

$spec_name = addslashes($spec_name);
$size = filesize($argv[1]);
$mtime = filemtime($argv[1]);

try {
	$dbh = new PDO("$database");
} catch (PDOException $e) {
	die ($e->getMessage());
}
$result = $dbh->query("SELECT log_id FROM logs WHERE spec = '$spec_name' AND arch_id = $arch_id AND result = $result_id LIMIT 1")->fetchAll();
if (count($result) == 1) {
	foreach ($result as $row) {
		$query = "UPDATE logs SET result = $result_id, size = $size, mtime = $mtime WHERE log_id = $row[log_id]";
		break;
	}
} else {
	$query = "INSERT INTO logs(arch_id, result, size, mtime, spec) VALUES($arch_id, $result_id, $size, $mtime, '$spec_name')";
}

$ile = $dbh->exec("$query");
if ($ile != 1) {
	print_r($dbh->errorInfo());
}
?>