From dca2aa983bf2d3f0e98c37f65517449bf12773bc Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Mon, 23 Jan 2006 05:38:13 +0000 Subject: [PATCH] Added command-line rebuilder. This needs some security. --- rebuild.sh.php | 76 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 76 insertions(+) create mode 100644 rebuild.sh.php diff --git a/rebuild.sh.php b/rebuild.sh.php new file mode 100644 index 0000000..db4427a --- /dev/null +++ b/rebuild.sh.php @@ -0,0 +1,76 @@ +#!/usr/bin/php +query("SHOW TABLES"); +while ($table = $db->fetch_array($tables)) +{ + $value = array_values($table); + $tablelist[] = $value[0]; +} + +foreach ($viewsvn->repos->fetch_list() AS $repos) +{ + if (!in_array('c' . ($hash = md5($viewsvn->repos->fetch_path($repos))) . '_revs', $tablelist)) + { + $viewsvn->debug("creating new cacheV: $repos"); + $db->query(" + CREATE TABLE c{$hash}_revs + ( + revision INT(20) UNSIGNED NOT NULL DEFAULT 0, + author VARCHAR(255) NOT NULL DEFAULT '', + dateline VARCHAR(100) NOT NULL DEFAULT '', + files MEDIUMTEXT NOT NULL DEFAULT '', + message MEDIUMTEXT NOT NULL DEFAULT '', + PRIMARY KEY (revision) + )" + ); + + $db->query(" + CREATE TABLE c{$hash}_nodes + ( + name VARCHAR(255) NOT NULL DEFAULT '', + node VARCHAR(50) NOT NULL DEFAULT '', + revision INT(20) UNSIGNED NOT NULL DEFAULT 0, + history MEDIUMTEXT NOT NULL DEFAULT '', + properties MEDIUMTEXT NOT NULL DEFAULT '', + PRIMARY KEY (name) + )" + ); + } + + $controller = new Controller($repos); + $controller->cachev->build(null); +} + +/*=====================================================================*\ +|| ################################################################### +|| # $HeadURL$ +|| # $Id$ +|| ################################################################### +\*=====================================================================*/ +?> \ No newline at end of file -- 2.22.5