PHP Classes
Icontem

File: DATA/MySQL5/PrimaryKeyIndexingStrategy.php


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Martin Alterisio  >  DATA  >  DATA/MySQL5/PrimaryKeyIndexingStrategy.php  
File: DATA/MySQL5/PrimaryKeyIndexingStrategy.php
Role: Class source
Content type: text/plain
Description: Strategy for mapping array offsets to primary key values.
Class: DATA
Access data stored in MySQL tables like arrays
 

Contents

Class file image Download
<?php
/**
 * @package DATA_MySQL5
 */

/**
 * Strategy for mapping array offsets to primary key values.
 */
class DATA_MySQL5_PrimaryKeyIndexingStrategy implements DATA_AssociativeIndexingStrategy {
    /**
     * Stores table name on construction for future operations.
     * @var string
     */
    protected $table;
    
    /**
     * Constructor.
     * 
     * @param string $table The table name.
     */
    public function __construct($table) {
        $this->table = $table;
    }
    
    public function isSingleRowIndexing() {
        return true;
    }
    
    protected function getIndexField() {
        $keys = DATA_MySQL5_Schema::getPrimaryKey($this->table);
        return $keys[0];
    }
    
    public function inboxRowOffset($row) {
        $indexField = $this->getIndexField();
        try {
            return DATA_MySQL5_Schema::getSQLTypeFactory($this->table, $indexField)->inbox($row);
        } catch (DATA_SQLTypeConstraintFailed $exception) {
            $exception->setTable($this->table);
            $exception->setField($indexField);
            throw $exception;
        }
    }
    
    public function buildWhereConditions($row) {
        $indexField = $this->getIndexField();
        return "`{$indexField}` = " . DATA_MySQL5_Access::prepareData($row);
    }
    
    public function getAdditionalInsertFields($row) {
        return array(
            $this->getIndexField() => $row
        );
    }
}
?>

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products