Mambo > Projects > Mambo CMS > SVN

Diff of /mambo/branches/4.6/includes/database.php

-revision 385, Sun Mar 12 15:46:12 2006 UTC
+revision 417, Tue Mar 21 18:06:53 2006 UTC
 Line 30
          var $_debug=0;
          /** @var array A log of queries */
          var $_log=array();
+         /** @var string Null date */
+         var $_null_date='0000-00-00 00:00:00';
          /**
          * Database object constructor
-Line 54
+Line 56
                          include $basePath . '/../offline.php';
                          exit();
          }
+         function getNullDate () {
+             return $this->_null_date;
+         }
          /**
          * @param int
          */
-Line 217
+Line 223
                  return "<div style=\"background-color:#FFFFCC\" align=\"left\">$buf</div>";
          }
          /**
-         * @return int The number of rows returned from the most recent query.
+         * @return int The number of rows returned from the most recent query - SELECT only
          */
          function getNumRows( $cur=null ) {
                  return mysql_num_rows( $cur ? $cur : $this->_cursor );
          }
          /**
+         * @return int The number of rows affected by the most recent query - INSERT, UPDATE, DELETE
+         */
+         function getAffectedRows(  ) {
+                 return mysql_affected_rows( $this->_resource );
+         }
+         /**
          * Load an array of retrieved database objects or values
          * @param int Database cursor
          * @param string The field name of a primary key
-Line 547
+Line 560
          }
  }
  /**
- * mosDBTable Abstract Class.
+ * mosDBAbstractRow Abstract Class.
  * @abstract
  * @package Mambo
  * @subpackage Database
-Line 557
+Line 569
  * Parent classes to all database derived objects.  Customisation will generally
  * not involve tampering with this object.
  * @package Mambo
- * @author Andrew Eddie <eddieajau@users.sourceforge.net
+ * @author Martin Brampton counterpoint@mambo-foundation.org
  */
- class mosDBTable {
+ class mosDBAbstractRow {
          /** @var string Name of the table in the db schema relating to child class */
          var $_tbl = '';
          /** @var string Name of the primary key field in the table */
          var $_tbl_key = '';
          /** @var string Error message */
          var $_error = '';
-         /** @var mosDatabase Database connector */
-         var $_db = null;
          /**
          *       Object constructor to set table and key field
-Line 576
+Line 586
          *       @param string $table name of the table in the db schema relating to child class
          *       @param string $key name of the primary key field in the table
          */
-         function mosDBTable( $table, $key, &$db ) {
+         function mosDBAbstractRow ($table='', $keyname='id', $db='') {
-                 $this->_tbl = $table;
+                 if ($table) $this->_tbl = $table;
-                 $this->_tbl_key = $key;
+                 else $this->_tbl = $this->tableName();
-                 $this->_db =& $db;
+                 $this->_tbl_key = $keyname;
+                 if (is_object($db)) $this->_db = $db;
+         }
+         /**
+         *       generic check method
+         *
+         *       can be overloaded/supplemented by the child class
+         *       @return boolean True if the object is ok
+         */
+         function check() {
+                 return true;
          }
          /**
+         * Checks if this object lacks the property given by the parameter
+         * @param string The name of the property
+         * @return bool
+         */
+         function lacks( $property ) {
+                 $thisclass = get_class($this);
+                 if (array_key_exists( $property, get_class_vars($thisclass) )) return false;
+                 $this->_error = T_(sprintf('WARNING: %s does not support %s.', $thisclass, $property));
+                 return true;
+         }
+         /**
+         /* Move a database row object up or down through the ordering
+         /* @param int positive to move up, negative to move down
+         /* @param string Additional conditions on the WHERE clause to limit the effect
+         */
+         function move( $direction, $where='' ) {
+                 $compops = array (-1 => '<', 0 => '=', 1 => '>');
+                 $relation = $compops[($direction>0)-($direction<0)];
+                 $ordering = ($relation == '<' ? 'DESC' : 'ASC');
+                 $k = $this->_tbl_key;
+                 $o1 = $this->ordering;
+                 $k1 = $this->$k;
+                 $database = isset($this->_db) ? $this->_db : mamboDatabase::getInstance();
+                 $sql = "SELECT $k, ordering FROM $this->_tbl WHERE ordering $relation $o1";
+                 $sql .= ($where ? "\n AND $where" : '').' ORDER BY ordering '.$ordering.' LIMIT 1';
+                 $database->setQuery( $sql );
+                 if ($database->loadObject($row)) {
+                         $o2 = $row->ordering;
+                         $k2 = $row->$k;
+                         $sql = "UPDATE $this->_tbl SET ordering = (ordering=$o1)*$o2 + (ordering=$o2)*$o1 WHERE $k = $k1 OR $k = $k2";
+                         $database->doSQL($sql);
+                 }
+         }
+         /**
+         * Compacts the ordering sequence of the selected records
+         * @param string Additional conditions on WHERE clause to limit ordering to a particular subset of records
+         */
+         function updateOrder( $where='', $cfid=null, $order=null ) {
+                 if ($this->lacks('ordering')) return false;
+                 $k = $this->_tbl_key;
+                 if ($this->_tbl == "#__content_frontpage") $order2 = ", content_id DESC";
+                 else $order2 = "";
+                 $database = isset($this->_db) ? $this->_db : mamboDatabase::getInstance();
+                 if (!is_null($cfid) AND !is_null($order)) {
+                         foreach ($cfid as $i=>$id) {
+                                 $o = intval($order[$i]);
+                                 $set[] = "(id=$id)*$o";
+                         }
+                         $sql = "UPDATE $this->_tbl SET ordering = ".implode(' + ', $set).' WHERE id IN ('.implode(',', $cfid).')';
+                         $database->doSQL($sql);
+                 }
+                 $sql = "SELECT $k, ordering FROM $this->_tbl "
+                 . ($where ? "\nWHERE $where" : '')
+                 . "\nORDER BY ordering$order2";
+                 $database->setQuery($sql);
+                 if (!$rows = $database->loadObjectList()) {
+                         $this->_error = $database->getErrorMsg();
+                         return false;
+                 }
+                 $i = 1;
+                 foreach ($rows as $row) {
+                         $sql = "UPDATE $this->_tbl SET ordering=$i WHERE $k = ".$row->$k;
+                         $database->doSQL($sql);
+                         $i++;
+                 }
+                 return true;
+         }
+ }
+ /**
+ * mosDBTable Abstract Class.
+ * @abstract
+ * @package Mambo
+ * @subpackage Database
+ *
+ * Parent classes to all database derived objects.  Customisation will generally
+ * not involve tampering with this object.
+ * @package Mambo
+ * @author Andrew Eddie <eddieajau@users.sourceforge.net
+ */
+ class mosDBTable extends mosDBAbstractRow {
+         /** @var mosDatabase Database connector */
+         var $_db = null;
+         /**
           *      @return bool True if DB query failed.  Sets the error message
           */
          function queryTestFailure () {
-Line 637
+Line 749
                  return $cache;
          }
          /**
-         * Checks if this object lacks the property given by the parameter
-         * @param string The name of the property
-         * @return bool
-         */
-         function lacks( $property ) {
-                 $thisclass = strtolower(get_class($this));
-                 if (!array_key_exists( $property, get_class_vars($thisclass) )) {
-                         $this->_error = "WARNING: $thisclass does not support $property.";
-                         return true;
-                 }
-                 return false;
-         }
-         /**
          * Set the value of the class variable
          * @param string The name of the class variable
          * @param mixed The value to assign to the variable
-Line 685
+Line 784
          }
          /**
-         *       generic check method
-         *
-         *       can be overloaded/supplemented by the child class
-         *       @return boolean True if the object is ok
-         */
-         function check() {
-                 return true;
-         }
-         /**
          * Inserts a new row if id is zero or updates an existing row in the database table
          *
          * Can be overloaded/supplemented by the child class
-Line 713
+Line 802
          }
          /**
-         */
-         function move( $direction, $where='' ) {
-                 $compops = array (-1 => '<', 0 => '=', 1 => '>');
-                 $relation = $compops[($direction>0)-($direction<0)];
-                 $ordering = $relation == '<' ? 'DESC' : 'ASC';
-                 $k = $this->_tbl_key;
-                 $o1 = $this->ordering;
-                 $k1 = $this->$k;
-                 $sql = "SELECT $k, ordering FROM $this->_tbl WHERE ordering $relation $o1";
-                 $sql .= ($where ? "\n AND $where" : '').' ORDER BY ordering '.$ordering.' LIMIT 1';
-                 $this->_db->setQuery( $sql );
-                 if ($this->_db->loadObject($row)) {
-                         $o2 = $row->ordering;
-                         $k2 = $row->$k;
-                         $sql = "UPDATE $this->_tbl SET ordering = (ordering=$o1)*$o2 + (ordering=$o2)*$o1 WHERE $k = $k1 OR $k = $k2";
-                         $this->_db->doSQL($sql);
-                 }
-         }
-         /**
-         * Compacts the ordering sequence of the selected records
-         * @param string Additional where query to limit ordering to a particular subset of records
-         */
-         function updateOrder( $where='' ) {
-                 if ($this->lacks('ordering')) return false;
-                 $k = $this->_tbl_key;
-                 if ($this->_tbl == "#__content_frontpage") $order2 = ", content_id DESC";
-                 else $order2 = "";
-                 $sql = "SELECT $k, ordering FROM $this->_tbl "
-                 . ($where ? "\nWHERE $where" : '')
-                 . "\nORDER BY ordering$order2";
-                 $this->_db->setQuery($sql);
-                 if (!$rows = $this->_db->loadObjectList()) {
-                         $this->_error = $this->_db->getErrorMsg();
-                         return false;
-                 }
-                 $i = 1;
-                 foreach ($rows as $row) {
-                         $sql = "UPDATE $this->_tbl SET ordering=$i WHERE $k = ".$row->$k;
-                         $this->_db->doSQL($sql);
-                         $i++;
-                 }
-                 return true;
-         }
-         /**
          *       Default delete method
          *
          *       can be overloaded/supplemented by the child class
-Line 894
+Line 937
  *  of a field that will have a timestamp placed in it whenever the DB is written.
  */
- class mosDBTableEntry {
+ class mosTableEntry extends mosDBAbstractRow {
-         function mosDBTableEntry () {
-                 die ('Cannot instantiate mosDBTableEntry');
-         }
          /* Stores all POST data where the name matches an object variable name */
          function addPostData () {
                  foreach (get_class_vars(get_class($this)) as $field=>$value) {
-                         if ($field!='id' AND isset($_POST[$field])) {
+                         if ($field!='id' AND $field[1] != '_' AND isset($_POST[$field])) {
                                  $this->$field = trim($_POST[$field]);
                          }
                  }
-Line 942
+Line 981
                  $sql = "UPDATE $tabname SET %s WHERE id=$this->id";
                  $exclude = $this->notSQL();
                  foreach (get_class_vars(get_class($this)) as $field=>$value) {
-                         if (!in_array($field,$exclude)) $setter[] = $field."='".$this->$field."'";
+                         if (!in_array($field,$exclude) AND $field[0] != '_') $setter[] = $field."='".$this->$field."'";
                  }
                  $timestamp = $this->timeStampField();
                  if ($timestamp) $setter[] = $timestamp."='".date('Y-m-d H:i:s')."'";
-Line 961
+Line 1000
                  $sql = "INSERT INTO $tabname (%s) VALUES (%s)";
                  $exclude = $this->notSQL();
                  foreach (get_class_vars(get_class($this)) as $field=>$value) {
-                         if (!in_array($field,$exclude)) {
+                         if (!in_array($field,$exclude) AND $field[0] != '_') {
                                  $infields[] = $field;
                                  $values[] = "'".$this->$field."'";
                          }

 Legend:



Removed from v.385
 


changed lines


 
Added in v.417
 Legend:



Removed from v.385
 


changed lines


 
Added in v.417
-Removed from v.385
+Added in v.417

	ViewVC Help
Powered by ViewVC 1.0.0

Web Hosting provided by Network Redux.

MyGforge Home

Mambo CMS

Diff of /mambo/branches/4.6/includes/database.php