includes/cachev.php

   1 <?php
   2 /*=====================================================================*\
   3 || ###################################################################
   4 || # ViewSVN [#]version[#]
   5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
   6 || #
   7 || # This program is free software; you can redistribute it and/or modify
   8 || # it under the terms of the GNU General Public License as published by
   9 || # the Free Software Foundation; version [#]gpl[#] of the License.
  10 || #
  11 || # This program is distributed in the hope that it will be useful, but
  12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
  13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
  14 || # more details.
  15 || #
  16 || # You should have received a copy of the GNU General Public License along
  17 || # with this program; if not, write to the Free Software Foundation, Inc.,
  18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
  19 || ###################################################################
  20 \*=====================================================================*/
  21
  22 /**
  23 * File container for cacheV class
  24 *
  25 * @package      ViewSVN
  26 */
  27
  28 /**
  29 * cacheV
  30 *
  31 * This class is responsible for interacting with a given cacheV table.
  32 * It controls rebuilding from scratch, updates, and querying the cache.
  33 *
  34 * @author               Iris Studios, Inc.
  35 * @copyright    Copyright ©2002 - [#]year[#], Iris Studios, Inc.
  36 * @version              $Revision$
  37 * @package              ViewSVN
  38 *
  39 */
  40 class cacheV
  41 {
  42         /**
  43         * The registry
  44         * @var  object
  45         */
  46         var $registry = null;
  47
  48         /**
  49         * cacheV hash
  50         * @var  string
  51         */
  52         var $hash;
  53
  54         /**
  55         * Record count - the number of records in cacheV
  56         * @var  integer
  57         */
  58         var $count;
  59
  60         /**
  61         * Memcache for all fetched revisions so we don't have to query-dupe
  62         * @var  array
  63         */
  64         var $memcache = array();
  65
  66         // ###################################################################
  67         /**
  68         * Constructor: initialies the registry
  69         */
  70         function cacheV()
  71         {
  72                 global $viewsvn;
  73                 $this->registry =& $viewsvn;
  74         }
  75
  76         // ###################################################################
  77         /**
  78         * Sets the hash so we know what table we're dealing with
  79         *
  80         * @access       public
  81         */
  82         function set_hash()
  83         {
  84                 $this->hash = md5($this->registry->repos->fetch_path($this->registry->paths->repos));
  85         }
  86
  87         // ###################################################################
  88         /**
  89         * Returns a node string that has the beginning and ending slashes
  90         * removed to allow it to match to the _nodes cacheV table
  91         *
  92         * @access       public
  93         *
  94         * @param        string  Original string
  95         *
  96         * @return       string  Matchable string
  97         */
  98         function fetch_node_string($node)
  99         {
 100                 return preg_replace('#(^/|/$)#', '', $node);
 101         }
 102
 103         // ###################################################################
 104         /**
 105         * Returns a specific log entry
 106         *
 107         * @access       public
 108         *
 109         * @param        integer Revision number
 110         *
 111         * @return       array   Complete revision/commit entry
 112         */
 113         function fetch_revision($revision)
 114         {
 115                 $revision = $this->registry->clean($revision, TYPE_UINT);
 116
 117                 if (!isset($this->memcache['revs']["$revision"]))
 118                 {
 119                         $this->memcache['revs']["$revision"] = $this->registry->db->query_first("SELECT * FROM {$this->hash}_revs " . ($revision == 0 ? " ORDER BY revision DESC LIMIT 1" : "WHERE revision = $revision"));
 120                         $this->memcache['revs']["$revision"]['files'] = unserialize($this->memcache['revs']["$revision"]['files']);
 121                 }
 122
 123                 return $this->memcache['revs']["$revision"];
 124         }
 125
 126         // ###################################################################
 127         /**
 128         * Returns the revision entry before the specified one
 129         *
 130         * @access       public
 131         *
 132         * @param        integer Revision number
 133         *
 134         * @return       array   Complete revision/commit entry
 135         */
 136         function fetch_prev_revision($revision)
 137         {
 138                 static $prevrevs;
 139
 140                 $revision = $this->registry->clean($revision, TYPE_UINT);
 141
 142                 if (!isset($prevrevs["$revision"]))
 143                 {
 144                         $result = $this->registry->db->query_first("SELECT * FROM {$this->hash}_revs ORDER BY revision DESC LIMIT 1 WHERE revision < $revision");
 145                         $revision = $result['revision'];
 146                         $this->memcache['revs']["$revision"] = $result;
 147                         $this->memcache['revs']["$revision"]['files'] = unserialize($this->memcache['revs']["$revision"]['files']);
 148                 }
 149                 else
 150                 {
 151                         $revision = $prevrevs["$revision"];
 152                 }
 153
 154                 return $this->memcache['revs']["$revision"];
 155         }
 156
 157         // ###################################################################
 158         /**
 159         * Fetches the latest revision for a given path
 160         *
 161         * @access       public
 162         *
 163         * @param        string  Node path
 164         *
 165         * @return       integer Latest revision; FALSE if none (not in HEAD)
 166         */
 167         function fetch_node($node)
 168         {
 169                 $node = $this->fetch_node_string($node);
 170                 if (!isset($this->memcache['nodes']["$node"]))
 171                 {
 172                         $this->memcache['nodes']["$node"] = $this->registry->db->query_first("SELECT * FROM {$this->hash}_nodes WHERE name = '" . $this->registry->escape($node) . "'");
 173                 }
 174
 175                 return $this->memcache['nodes']["$node"];
 176         }
 177
 178         // ###################################################################
 179         /**
 180         * Checks to see if a given node is a directory. Returns TRUE if so.
 181         *
 182         * @access       public
 183         *
 184         * @param        string  Node path
 185         *
 186         * @return       bool    TRUE if directory, FALSE if not
 187         */
 188         function isdir($node)
 189         {
 190                 $node = $this->fetch_node($node);
 191                 if ($node['node'] == 'dir')
 192                 {
 193                         return true;
 194                 }
 195
 196                 return false;
 197         }
 198
 199         // ###################################################################
 200         /**
 201         * Checks to see if it's necessary to rebuild the cacheV table for the
 202         * current repository. This is done by making sure $count > 0. If not,
 203         * then rebuild() is run. This also checks against the cacheV table
 204         * to make sure that it's up-to-date against the root repository.
 205         *
 206         * @access       public
 207         */
 208         function exec_build()
 209         {
 210                 $result = $this->registry->db->query_first("SELECT MAX(revision) AS max FROM {$this->hash}_revs");
 211                 $this->count = $result['max'];
 212
 213                 // time to go from the start
 214                 if ($this->count == 0)
 215                 {
 216                         $this->build(null);
 217                 }
 218                 else
 219                 {
 220                         // send an Xquery to SVN to see if we need to update
 221                         $query = $this->registry->svn->svn('info --xml ' . $this->registry->repos->fetch_path($this->registry->paths->repos));
 222                         $query = implode("\n", $query);
 223
 224                         $tree = $this->registry->xml->parse($query);
 225
 226                         if ($tree['info']['entry']['revision'] != $this->count)
 227                         {
 228                                 $this->build($this->count);
 229                         }
 230                 }
 231         }
 232
 233         // ###################################################################
 234         /**
 235         * Builds the cacheV table. This can be used to build only part of the
 236         * cache or the entire thing, if the revision is set to NULL.
 237         *
 238         * @access       public
 239         *
 240         * @param        integer Lower (current) revision
 241         */
 242         function build($revision)
 243         {
 244                 $start = microtime();
 245
 246                 // get _revs
 247                 $output = $this->registry->svn->svn('log --xml -v ' . ($revision !== null ? '-r' . $revision . ':HEAD ' : '') . $this->registry->repos->fetch_path($this->registry->paths->repos));
 248                 $output = implode("\n", $output);
 249                 $tree = $this->registry->xml->parse($output);
 250
 251                 // get _nodes
 252                 $output = $this->registry->svn->svn('info --xml -R ' . ($revision !== null ? '-r' . $revision . ':HEAD ' : '') . $this->registry->repos->fetch_path($this->registry->paths->repos));
 253                 $output = implode("\n", $output);
 254                 $infolist = $this->registry->xml->parse($output);
 255
 256                 // other part of _nodes: properties
 257                 $output = $this->registry->svn->svn('proplist -v -R ' . ($revision !== null ? ' -r' . $revision . ':HEAD ' : '') . $this->registry->repos->fetch_path($this->registry->paths->repos));
 258                 foreach ($output AS $line)
 259                 {
 260                         if (preg_match('#^Properties on \'(.*?)\':$#', $line, $bits))
 261                         {
 262                                 $proplist["$index"]["$curprop"] = trim($proplist["$index"]["$curprop"]);
 263                                 $index = str_replace($this->registry->repos->fetch_path($this->registry->paths->repos), '', $bits[1]);
 264                                 $capture = false;
 265                         }
 266                         else
 267                         {
 268                                 if (preg_match('#^\s+(.*)\s:\s(.*)#', $line, $matches))
 269                                 {
 270                                         $curprop = $matches[1];
 271                                         $proplist["$index"]["$curprop"] = $matches[2] . "\n";
 272                                         $capture = true;
 273                                 }
 274                                 else if ($capture == true)
 275                                 {
 276                                         $proplist["$index"]["$curprop"] .= $line . "\n";
 277                                 }
 278                         }
 279                 }
 280
 281                 // construct _revs inserts and the list of add revisions
 282                 foreach ($tree['log']['logentry'] AS $log)
 283                 {
 284                         $this->registry->xml->unify_node($log['paths']['path']);
 285
 286                         $inserts['revs'][] = "($log[revision], '{$log['author']['value']}', '{$log['date']['value']}', '" . $this->registry->escape($log['msg']['value']) . "', '" . $this->registry->escape(serialize($log['paths']['path'])) . "')";
 287
 288                         foreach ($log['paths']['path'] AS $path)
 289                         {
 290                                 if (trim($path['action']) == 'A')
 291                                 {
 292                                         $path['value'] = preg_replace('#^/#', '', $path['value']);
 293                                         $addlist["$path[value]"] = $log['revision'];
 294                                 }
 295                         }
 296                 }
 297
 298                 // construct list of HEAD nodes for _nodes
 299                 foreach ($infolist['info']['entry'] AS $node)
 300                 {
 301                         $history = $this->registry->svn->svn('log --xml ' . $node['url']['value']);
 302                         $history = implode("\n", $history);
 303                         $history = $this->registry->xml->parse($history);
 304
 305                         $loglist = array();
 306                         $latestrev = -1;
 307                         foreach ($history['log']['logentry'] AS $log)
 308                         {
 309                                 $latestrev = ($log['revision'] > $latestrev ? $log['revision'] : $latestrev);
 310                                 $loglist["$log[revision]"] = array(
 311                                         'revision'      => $log['revision'],
 312                                         'author'        => $log['author']['value'],
 313                                         'date'          => $log['date']['value'],
 314                                         'message'       => $log['msg']['value']
 315                                 );
 316                         }
 317
 318                         $inserts['nodes'][] = "('$node[path]', '" . $node['kind'] . "', $latestrev, '" . $this->registry->escape(serialize($loglist)) . "', '" . $this->registry->escape(serialize($proplist["$node[path]"])) . "')";
 319                 }
 320
 321                 // insert _revs
 322                 $this->registry->db->query("
 323                         REPLACE INTO {$this->hash}_revs
 324                                 (revision, author, dateline, message, files)
 325                         VALUES
 326                                 " . implode(",\n", $inserts['revs'])
 327                 );
 328
 329                 // insert _nodes
 330                 $this->registry->db->query("
 331                         REPLACE INTO {$this->hash}_nodes
 332                                 (name, node, revision, history, properties)
 333                         VALUES
 334                                 " . implode(",\n", $inserts['nodes'])
 335                 );
 336
 337                 $this->registry->debug("TIME TO (RE)BUILD: " . $this->registry->funct->fetch_microtime_diff($start));
 338         }
 339 }
 340
 341 /*=====================================================================*\
 342 || ###################################################################
 343 || # $HeadURL$
 344 || # $Id$
 345 || ###################################################################
 346 \*=====================================================================*/
 347 ?>