#!/usr/bin/php.cli
<?php
// $Revision: 1.3 $, $Date: 2009/01/20 07:37:40 $
/*
$database = 'sqlite:/home/services/httpd/html/pld-buildlogs/db/buildlogs2.db';
$root_directory = '/home/services/ftp/pub/pld-buildlogs';
// $database and $root_directory are taken from buildlogs.inc .
// parameter: argv[1] - full path to the log file.
*/

$result = array("FAIL" => 0, "OK" => 1);
include('buildlogs.inc');

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

if (preg_match("/^(.*),(.*)$/", $matches[4], $m2)) {
    $name = $m2[1];
    $id = $m2[2];
} else {
    $name = $matches[4];
    $id = "";
}
$dist = $matches[1];
$arch = $matches[2];
$ok = $result[$matches[3]];
$size = filesize($argv[1]);
$mtime = filemtime($argv[1]);

#print "name $name, id $id, dist $dist, arch $arch, ok $ok, size, $size, mtime $mtime\n";

try {
	$dbh = new PDO("$database");
} catch (PDOException $e) {
	die ($e->getMessage());
}
$result = $dbh->query("SELECT log_id FROM logs WHERE dist = '$dist' AND arch = '$arch' AND name = '$name'"
." AND id = '$id' LIMIT 1")->fetchAll();
if (count($result) == 1) {
	foreach ($result as $row) {
		$query = "UPDATE logs SET ok = $ok, size = $size, mtime = $mtime WHERE log_id = $row[log_id]";
		break;
	}
} else {
	$query = "INSERT INTO logs(dist, arch, ok, name, size, mtime, id) "
	. "VALUES('$dist', '$arch', $ok, '$name', $size, $mtime, '$id')";
}
$ile = $dbh->exec("$query");
if ($ile != 1) {
	print_r($dbh->errorInfo());
}
?>