Rev 51 | Rev 53 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line | 
|---|---|---|---|
| 27 | PointedEar | 1 | <?php | 
        
| 2 | |||
| 52 | PointedEar | 3 | namespace PointedEars\PHPX;  | 
        
| 29 | PointedEar | 4 | |
| 27 | PointedEar | 5 | /** | 
        
| 51 | PointedEar | 6 | * Abstract model class for Object-Relational Mapping | 
        
| 27 | PointedEar | 7 | * | 
        
| 51 | PointedEar | 8 | * Provides simple mapping of a model object to records of | 
        
| 9 | * a table of a relational database. | 
        ||
| 27 | PointedEar | 10 | * | 
        
| 11 | * @author Thomas Lahn | 
        ||
| 12 | */ | 
        ||
| 52 | PointedEar | 13 | abstract class Model extends \PointedEars\PHPX\AbstractModel  | 
        
| 27 | PointedEar | 14 | { | 
        
| 15 |   /** | 
        ||
| 51 | PointedEar | 16 |    * The <code>Table</code> for instances of this model | 
        
| 17 |    * | 
        ||
| 18 |    * @type Table|string | 
        ||
| 27 | PointedEar | 19 |    */ | 
        
| 51 | PointedEar | 20 | protected $_persistentTable;  | 
        
| 21 | |||
| 27 | PointedEar | 22 |   /** | 
        
| 51 | PointedEar | 23 |    * The name(s) of the property or properties whose value(s) | 
        
| 24 |    * identify this object in the <code>Table</code>.  They are | 
        ||
| 25 |    * used for comparing against the primary key column(s) of | 
        ||
| 26 |    * the <code>Table</code>. | 
        ||
| 27 |    * | 
        ||
| 28 |    * @type string|array[string] | 
        ||
| 29 |    */ | 
        ||
| 30 | protected $_persistentId = 'id';  | 
        ||
| 31 | |||
| 32 |   /** | 
        ||
| 33 |    * The names of the properties that should be used in database | 
        ||
| 34 |    * queries, and their mapping to the columns of | 
        ||
| 35 |    * the <code>Table</code>, if specified (keys are property names, | 
        ||
| 36 |    * values are column names, or both if the key is numeric). | 
        ||
| 37 |    * | 
        ||
| 38 |    * @type array | 
        ||
| 39 |    */ | 
        ||
| 40 | protected $_persistentProperties = array('id');  | 
        ||
| 41 | |||
| 42 |         /** | 
        ||
| 27 | PointedEar | 43 |    * Creates a new model object | 
        
| 44 |    * | 
        ||
| 51 | PointedEar | 45 |    * @see AbstractModel::__construct() | 
        
| 27 | PointedEar | 46 |    */ | 
        
| 51 | PointedEar | 47 | public function __construct (array $data = null, array $mapping = null)  | 
        
| 27 | PointedEar | 48 |   { | 
        
| 49 | parent::__construct($data, $mapping);  | 
        ||
| 50 |   } | 
        ||
| 51 | PointedEar | 51 | |
| 52 | public function getPersistentTable ()  | 
        ||
| 53 |   { | 
        ||
| 54 | if (is_string($this->_persistentTable))  | 
        ||
| 55 |         { | 
        ||
| 56 |                 /* Call setter to convert to Table */ | 
        ||
| 57 | $this->persistentTable = $this->_persistentTable;  | 
        ||
| 58 |         } | 
        ||
| 59 | |||
| 60 | return $this->_persistentTable;  | 
        ||
| 61 |   } | 
        ||
| 62 | |||
| 63 | public function setPersistentTable ($value)  | 
        ||
| 64 |   { | 
        ||
| 65 | if ($value instanceof Table)  | 
        ||
| 66 |         { | 
        ||
| 67 | $this->_persistentTable = $value;  | 
        ||
| 68 |         } | 
        ||
| 69 |         else | 
        ||
| 70 |         { | 
        ||
| 71 | $table = new $value();  | 
        ||
| 52 | PointedEar | 72 | if (!($table instanceof Db\Table))  | 
        
| 51 | PointedEar | 73 |                 { | 
        
| 74 | throw new \InvalidArgumentException(  | 
        ||
| 52 | PointedEar | 75 |                                 'Parameter does not specify a subclass of \\PointedEars\\PHPX\\Table: ' | 
        
| 76 | . $value  | 
        ||
| 51 | PointedEar | 77 | );  | 
        
| 78 |                 } | 
        ||
| 79 | |||
| 80 | $this->_persistentTable = $table;  | 
        ||
| 81 |         } | 
        ||
| 82 |   } | 
        ||
| 83 | |||
| 27 | PointedEar | 84 |   /** | 
        
| 51 | PointedEar | 85 |    * Returns an array for database queries containing the | 
        
| 86 |    * property values of this object, using the specified | 
        ||
| 87 |    * property-to-column mapping. | 
        ||
| 88 |    * | 
        ||
| 89 |    * @param array $propertyNames = null | 
        ||
| 90 |    *   Names of the properties that should be included. | 
        ||
| 91 |    *   The default is to include all persistent properties. | 
        ||
| 92 |    * @return array | 
        ||
| 27 | PointedEar | 93 |    */ | 
        
| 51 | PointedEar | 94 | public function getPropertyArray (array $propertyNames = null)  | 
        
| 27 | PointedEar | 95 |   { | 
        
| 51 | PointedEar | 96 | $a = array();  | 
        
| 97 | |||
| 98 | if ($propertyNames === null)  | 
        ||
| 99 |         { | 
        ||
| 100 | $propertyNames = $this->_persistentProperties;  | 
        ||
| 101 |         } | 
        ||
| 102 | |||
| 103 | foreach ($propertyNames as $propertyName => $columnName)  | 
        ||
| 104 |         { | 
        ||
| 105 | if (is_numeric($propertyName))  | 
        ||
| 106 |                 { | 
        ||
| 107 | $propertyName = $columnName;  | 
        ||
| 108 |                 } | 
        ||
| 109 | |||
| 110 | $a[$columnName] = $this->$propertyName;  | 
        ||
| 111 |         } | 
        ||
| 112 | |||
| 113 | return $a;  | 
        ||
| 27 | PointedEar | 114 |   } | 
        
| 51 | PointedEar | 115 | |
| 116 |   /** | 
        ||
| 117 |    * Finds the record for the model object in a database, fills | 
        ||
| 118 |    * the object with missing data, and returns the result. | 
        ||
| 119 |    * | 
        ||
| 120 |    * @see Table::find(Model) | 
        ||
| 121 |    * @return Model|null | 
        ||
| 122 |    *   This object filled with missing data, or <code>null</code> | 
        ||
| 123 |    *   if there is no data for this object | 
        ||
| 124 |    */ | 
        ||
| 125 | public function find ()  | 
        ||
| 126 |   { | 
        ||
| 127 | $result = $this->persistentTable->find(  | 
        ||
| 52 | PointedEar | 128 | $this->{$this->_persistentId});  | 
        
| 51 | PointedEar | 129 | if ($result)  | 
        
| 130 |     { | 
        ||
| 131 | return $this->map($result);  | 
        ||
| 132 |     } | 
        ||
| 133 | |||
| 134 | return null;  | 
        ||
| 135 |   } | 
        ||
| 136 | |||
| 137 |   /** | 
        ||
| 138 |    * Saves a model object in the <code>Table</code> | 
        ||
| 139 |    * | 
        ||
| 140 |    * @param array $propertyNames = null | 
        ||
| 141 |    *   Names of the properties whose values should be saved | 
        ||
| 142 |    *   in the database.  The default is to save the values | 
        ||
| 143 |    *   of all persistent properties. | 
        ||
| 144 |    * @return boolean | 
        ||
| 145 |    * @see Model::getPropertyArray() | 
        ||
| 146 |    * @see Table::updateOrInsert() | 
        ||
| 147 |    */ | 
        ||
| 148 | public function save (array $propertyNames = null)  | 
        ||
| 149 |   { | 
        ||
| 150 | return $this->persistentTable->updateOrInsert(  | 
        ||
| 151 | $this->getPropertyArray($propertyNames), array(  | 
        ||
| 152 | $this->persistentTable->id => $this->{$this->_persistentId}  | 
        ||
| 153 |                 ) | 
        ||
| 154 | );  | 
        ||
| 155 |   } | 
        ||
| 156 | |||
| 157 |   /** | 
        ||
| 158 |    * Deletes a model object from the <code>Table</code> | 
        ||
| 159 |    * | 
        ||
| 160 |    * @return bool | 
        ||
| 161 |    * @see Table::delete() | 
        ||
| 162 |    */ | 
        ||
| 163 | public function delete ()  | 
        ||
| 164 |   { | 
        ||
| 165 | return $this->persistentTable->delete($this->{$this->_persistentId});  | 
        ||
| 166 |   } | 
        ||
| 27 | PointedEar | 167 | } |