classes/site/VersionDAO.inc.php

<?php

// $Id: VersionDAO.inc.php,v 1.14 2008/07/01 01:16:10 asmecher Exp $


import('site.Version');

class VersionDAO extends DAO {
   function &getCurrentVersion() {
      $result = &$this->retrieve(
         'SELECT * FROM versions WHERE current = 1'
      );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = &$this->_returnVersionFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $returner;
   }

   function &getVersionHistory() {
      $versions = array();

      $result = &$this->retrieve(
         'SELECT * FROM versions ORDER BY date_installed DESC'
      );

      while (!$result->EOF) {
         $versions[] = $this->_returnVersionFromRow($result->GetRowAssoc(false));
         $result->MoveNext();
      }

      $result->Close();
      unset($result);

      return $versions;
   }

   function &_returnVersionFromRow(&$row) {
      $version = &new Version();
      $version->setMajor($row['major']);
      $version->setMinor($row['minor']);
      $version->setRevision($row['revision']);
      $version->setBuild($row['build']);
      $version->setDateInstalled($this->datetimeFromDB($row['date_installed']));
      $version->setCurrent($row['current']);

      HookRegistry::call('VersionDAO::_returnVersionFromRow', array(&$version, &$row));

      return $version;
   }

   function insertVersion(&$version) {
      if ($version->getCurrent()) {
         // Version to insert is the new current, reset old current
         $this->update('UPDATE versions SET current = 0 WHERE current = 1');
      }
      if ($version->getDateInstalled() == null) {
         $version->setDateInstalled(Core::getCurrentDate());
      }

      return $this->update(
         sprintf('INSERT INTO versions
            (major, minor, revision, build, date_installed, current)
            VALUES
            (?, ?, ?, ?, %s, ?)',
            $this->datetimeToDB($version->getDateInstalled())),
         array(
            $version->getMajor(),
            $version->getMinor(),
            $version->getRevision(),
            $version->getBuild(),
            $version->getCurrent()
         )
      );
   }
}

?>

---