- add index

[projects/buildlogs.git] / pld-buildlogs / scripts / migration.php

#!/usr/bin/php.cli
<?php
// $Revision: 1.3 $, $Date: 2009/01/20 07:49:34 $
/*
$root_directory = '/home/services/ftp/pub/pld-buildlogs';
$database = 'sqlite:/home/services/httpd/html/pld-buildlogs/db/buildlogs2.db';
// $root_directory and $database are taken from buildlogs.inc
*/
include('buildlogs.inc');

if (file_exists($database_file)) {
	unlink($database_file);
}

$query = " CREATE TABLE LOGS(log_id INTEGER PRIMARY KEY, dist TEXT, arch TEXT, ok INTEGER, name TEXT, "
	. "size INTEGER, mtime INTEGER, id TEXT DEFAULT ''); CREATE INDEX IF NOT EXISTS dao_index ON LOGS(dist, arch, ok);";
try {
	$dbhandle = new PDO("$database");
} catch (PDOException $e) {
	die("new PDO: ". $e->getMessage());
}

$result = array("FAIL", "OK");

$dh = opendir($root_directory);
if (!$dh) {
	die("opendir $root_directory");
}
while ($dist = readdir($dh)) {
	if ($dist[0] == '.') continue;
	if (!is_dir("$root_directory/$dist")) continue;
	$ah = opendir("$root_directory/$dist");
	if (!$ah) die("opendir $dist");
	while ($arch = readdir($ah)) {
		if ($arch[0] == '.') continue;
		if (!is_dir("$root_directory/$dist/$arch")) continue;
		for ($ok = 0; $ok < 2; $ok++) {
			$directory = "$root_directory/$dist/$arch/" . $result[$ok];
			$sh = opendir($directory);
			if (!$sh) continue;
			while ($file = readdir($sh)) {
				if (preg_match("/^(.*)\.bz2$/", $file, $match)) {
					if (preg_match("/(.*),(.*)/", $match[1], $m2)) {
						$name = $m2[1];
						$id = $m2[2];
					} else {
						$name = $match[1];
						$id = "";
					}
					$f = "$directory/" . $match[0];
					$size = filesize($f);
					$mtime = filemtime($f);
$query .= " INSERT INTO logs(dist, arch, ok, name, size, mtime, id) "
. "VALUES('$dist', '$arch', $ok, '$name', $size, $mtime, '$id');";
				}
				
			}
			closedir($sh);
		}
	}
	closedir($ah);
}
closedir($dh);

$dbhandle->beginTransaction();
$dbhandle->exec("$query");
$dbhandle->commit();
?>