Source for file StorableInteger.class.php

<?php
 
/**
 * This is the {@link StorablePrimitive} equivalent of {@link Integer}.
 *
 * @package harmoni.datamanager.storableprimitives
 * 
 * @copyright Copyright &copy; 2005, Middlebury College
 * @license http://www.gnu.org/copyleft/gpl.html GNU General Public License (GPL)
 *
 * @version $Id: StorableInteger.class.php,v 1.14 2007/09/04 20:25:33 adamfranco Exp $
 */
class StorableInteger 
    extends Integer 
    /* implements StorablePrimitive */ 
{
 
/*******************************************************
 * Class Methods
 *********************************************************/
 
 
     /**
     * Takes a single database row, which would contain the columns added by alterQuery()
     * and extracts the values to setup the object with the appropriate data.
     * @param array $dbRow 
     * @access public
     * @return object StorableInteger 
     * @static
     */
    function createAndPopulate( $dbRow ) {
        $integer = new StorableInteger;
        $integer->_setValue($dbRow["integer_data"]);
        return $integer;
    }
    
    /**
     * Returns a string that could be inserted into an SQL query's WHERE clause, based on the
     * {@link Primitive} value that is passed. It is used when searching for datasets that contain a certain
     * field=value pair.
     * @param ref object $value The {@link Primitive} object to search for.
     * @param int $searchType One of the SEARCH_TYPE_* constants, defining what type of search this should be (ie, equals,
     *  contains, greater than, less than, etc)
     * @return string or NULL if no searching is allowed.
     * @static
     */
    function makeSearchString($value, $searchType = SEARCH_TYPE_EQUALS) {
        switch ($searchType) {
            case SEARCH_TYPE_EQUALS:
                return "dm_integer.data = ".$value->asString();
            case SEARCH_TYPE_GREATER_THAN:
                return "dm_integer.data > ".$value->asString();
            case SEARCH_TYPE_LESS_THAN:
                return "dm_integer.data < ".$value->asString();
            case SEARCH_TYPE_GREATER_THAN_OR_EQUALS:
                return "dm_integer.data >= ".$value->asString();
            case SEARCH_TYPE_LESS_THAN_OR_EQUALS:
                return "dm_integer.data <= ".$value->asString();
            case SEARCH_TYPE_IN_LIST:
                $string = "dm_integer.data IN (";
                while ($value->hasNext()) {
                    $valueObj =$value->next();
                    $string .= $valueObj->asString();
                    if ($value->hasNext())
                        $string .= ", ";
                }
                $string .= ")";
                return $string;
            case SEARCH_TYPE_NOT_IN_LIST:
                $string = "dm_integer.data NOT IN (";
                while ($value->hasNext()) {
                    $valueObj =$value->next();
                    $string .= $valueObj->asString();
                    if ($value->hasNext())
                        $string .= ", ";
                }
                $string .= ")";
                return $string;
        }
        return null;
    }
 
 /*******************************************************
  * Instance Methods
  *********************************************************/
 
      
      /**
     * Set the value
     * 
     * @param $value 
     * @return void 
     * @access private
     * @since 7/13/05
     */
    function _setValue ($value) {
        $this->_value = (integer) $value;
    }
    
    /**
     * Inserts a new row into the Database with the data contained in the object.
     * @param integer $dbID The {@link DBHandler} database ID to query.
     * @access public
     * @return integer Returns the new ID of the data stored.
     */
    function insert($dbID) {
        $idManager = Services::getService("Id");
        $newID =$idManager->createId();
        
        $query = new InsertQuery();
        $query->setTable("dm_integer");
        $query->setColumns(array("id","data"));
        
        $query->addRowOfValues(array("'".addslashes($newID->getIdString())."'", $this->value()));
        
        $dbHandler = Services::getService("DatabaseManager");
        $result =$dbHandler->query($query, $dbID);
        if (!$result || $result->getNumberOfRows() != 1) {
            throwError( new UnknownDBError("Storable") );
            return false;
        }
        
        return $newID->getIdString();
    }
    
    /**
     * Uses the ID passed and updates the database row with
     * new data.
     * @param integer $dbID The {@link DBHandler} database ID to query.
     * @param integer $dataID The ID in the database of the data to be updated.
     * @access public
     * @return void 
     */
    function update($dbID, $dataID) {
        if (!$dataID) return false;
        
        $query = new UpdateQuery();
        $query->setTable("dm_integer");
        $query->setColumns(array("data"));
        $query->setWhere("id='".addslashes($dataID)."'");
        
        $query->setValues(array($this->value()));
        
        $dbHandler = Services::getService("DatabaseManager");
        $result =$dbHandler->query($query, $dbID);
        
        if (!$result) {
            throwError( new UnknownDBError("Storable") );
            return false;
        }
        return true;
    }
    
    /**
     * Takes an existing {@link SelectQuery} and adds a table join and some columns so that
     * when it is executed the actual data can be retrieved from the row. The join condition must
     * be "fk_data = data_id_field", since the field "fk_data" is already part of the DataManager's
     * table structure.
     * @access public
     * @return void 
     */
    function alterQuery( $query ) {
        $query->addTable("dm_integer",LEFT_JOIN,"dm_integer.id = fk_data");
        $query->addColumn("data","integer_data","dm_integer");
    }
    
    /**
     * Deletes the data row from the appropriate table.
     * @param integer $dbID The {@link DBHandler} database ID to query.
     * @param integer $dataID The ID in the database of the data to be deleted.
     * @access public
     * @return void 
     */
    function prune($dbID, $dataID) {
        if (!$dataID) return;
        // delete ourselves from our data table
        $table = "dm_integer";
        
        $query = new DeleteQuery;
        $query->setTable($table);
        $query->setWhere("id='".addslashes($dataID)."'");
        
        $dbHandler = Services::getService("DatabaseManager");
        $res =$dbHandler->query($query, $dbID);
        
        if (!$res) throwError( new UnknownDBError("StorablePrimitive"));
    }
    
}