[8222] | 1 | <?php |
---|
| 2 | /* |
---|
| 3 | |
---|
| 4 | @version V5.06 29 Sept 2008 (c) 2000-2012 John Lim (jlim#natsoft.com). All rights reserved. |
---|
| 5 | Latest version is available at http://adodb.sourceforge.net |
---|
| 6 | |
---|
| 7 | Released under both BSD license and Lesser GPL library license. |
---|
| 8 | Whenever there is any discrepancy between the two licenses, |
---|
| 9 | the BSD license will take precedence. |
---|
| 10 | |
---|
| 11 | Active Record implementation. Superset of Zend Framework's. |
---|
| 12 | |
---|
| 13 | This is "Active Record eXtended" to support JOIN, WORK and LAZY mode by Chris Ravenscroft chris#voilaweb.com |
---|
| 14 | |
---|
| 15 | Version 0.9 |
---|
| 16 | |
---|
| 17 | See http://www-128.ibm.com/developerworks/java/library/j-cb03076/?ca=dgr-lnxw01ActiveRecord |
---|
| 18 | for info on Ruby on Rails Active Record implementation |
---|
| 19 | */ |
---|
| 20 | |
---|
| 21 | |
---|
| 22 | // CFR: Active Records Definitions |
---|
| 23 | define('ADODB_JOIN_AR', 0x01); |
---|
| 24 | define('ADODB_WORK_AR', 0x02); |
---|
| 25 | define('ADODB_LAZY_AR', 0x03); |
---|
| 26 | |
---|
| 27 | |
---|
| 28 | global $_ADODB_ACTIVE_DBS; |
---|
| 29 | global $ADODB_ACTIVE_CACHESECS; // set to true to enable caching of metadata such as field info |
---|
| 30 | global $ACTIVE_RECORD_SAFETY; // set to false to disable safety checks |
---|
| 31 | global $ADODB_ACTIVE_DEFVALS; // use default values of table definition when creating new active record. |
---|
| 32 | |
---|
| 33 | // array of ADODB_Active_DB's, indexed by ADODB_Active_Record->_dbat |
---|
| 34 | $_ADODB_ACTIVE_DBS = array(); |
---|
| 35 | $ACTIVE_RECORD_SAFETY = true; // CFR: disabled while playing with relations |
---|
| 36 | $ADODB_ACTIVE_DEFVALS = false; |
---|
| 37 | |
---|
| 38 | class ADODB_Active_DB { |
---|
| 39 | var $db; // ADOConnection |
---|
| 40 | var $tables; // assoc array of ADODB_Active_Table objects, indexed by tablename |
---|
| 41 | } |
---|
| 42 | |
---|
| 43 | class ADODB_Active_Table { |
---|
| 44 | var $name; // table name |
---|
| 45 | var $flds; // assoc array of adofieldobjs, indexed by fieldname |
---|
| 46 | var $keys; // assoc array of primary keys, indexed by fieldname |
---|
| 47 | var $_created; // only used when stored as a cached file |
---|
| 48 | var $_belongsTo = array(); |
---|
| 49 | var $_hasMany = array(); |
---|
| 50 | var $_colsCount; // total columns count, including relations |
---|
| 51 | |
---|
| 52 | function updateColsCount() |
---|
| 53 | { |
---|
| 54 | $this->_colsCount = sizeof($this->flds); |
---|
| 55 | foreach($this->_belongsTo as $foreignTable) |
---|
| 56 | $this->_colsCount += sizeof($foreignTable->TableInfo()->flds); |
---|
| 57 | foreach($this->_hasMany as $foreignTable) |
---|
| 58 | $this->_colsCount += sizeof($foreignTable->TableInfo()->flds); |
---|
| 59 | } |
---|
| 60 | } |
---|
| 61 | |
---|
| 62 | // returns index into $_ADODB_ACTIVE_DBS |
---|
| 63 | function ADODB_SetDatabaseAdapter(&$db) |
---|
| 64 | { |
---|
| 65 | global $_ADODB_ACTIVE_DBS; |
---|
| 66 | |
---|
| 67 | foreach($_ADODB_ACTIVE_DBS as $k => $d) { |
---|
| 68 | if (PHP_VERSION >= 5) { |
---|
| 69 | if ($d->db === $db) return $k; |
---|
| 70 | } else { |
---|
| 71 | if ($d->db->_connectionID === $db->_connectionID && $db->database == $d->db->database) |
---|
| 72 | return $k; |
---|
| 73 | } |
---|
| 74 | } |
---|
| 75 | |
---|
| 76 | $obj = new ADODB_Active_DB(); |
---|
| 77 | $obj->db = $db; |
---|
| 78 | $obj->tables = array(); |
---|
| 79 | |
---|
| 80 | $_ADODB_ACTIVE_DBS[] = $obj; |
---|
| 81 | |
---|
| 82 | return sizeof($_ADODB_ACTIVE_DBS)-1; |
---|
| 83 | } |
---|
| 84 | |
---|
| 85 | |
---|
| 86 | class ADODB_Active_Record { |
---|
| 87 | static $_changeNames = true; // dynamically pluralize table names |
---|
| 88 | static $_foreignSuffix = '_id'; // |
---|
| 89 | var $_dbat; // associative index pointing to ADODB_Active_DB eg. $ADODB_Active_DBS[_dbat] |
---|
| 90 | var $_table; // tablename, if set in class definition then use it as table name |
---|
| 91 | var $_sTable; // singularized table name |
---|
| 92 | var $_pTable; // pluralized table name |
---|
| 93 | var $_tableat; // associative index pointing to ADODB_Active_Table, eg $ADODB_Active_DBS[_dbat]->tables[$this->_tableat] |
---|
| 94 | var $_where; // where clause set in Load() |
---|
| 95 | var $_saved = false; // indicates whether data is already inserted. |
---|
| 96 | var $_lasterr = false; // last error message |
---|
| 97 | var $_original = false; // the original values loaded or inserted, refreshed on update |
---|
| 98 | |
---|
| 99 | var $foreignName; // CFR: class name when in a relationship |
---|
| 100 | |
---|
| 101 | static function UseDefaultValues($bool=null) |
---|
| 102 | { |
---|
| 103 | global $ADODB_ACTIVE_DEFVALS; |
---|
| 104 | if (isset($bool)) $ADODB_ACTIVE_DEFVALS = $bool; |
---|
| 105 | return $ADODB_ACTIVE_DEFVALS; |
---|
| 106 | } |
---|
| 107 | |
---|
| 108 | // should be static |
---|
| 109 | static function SetDatabaseAdapter(&$db) |
---|
| 110 | { |
---|
| 111 | return ADODB_SetDatabaseAdapter($db); |
---|
| 112 | } |
---|
| 113 | |
---|
| 114 | |
---|
| 115 | public function __set($name, $value) |
---|
| 116 | { |
---|
| 117 | $name = str_replace(' ', '_', $name); |
---|
| 118 | $this->$name = $value; |
---|
| 119 | } |
---|
| 120 | |
---|
| 121 | // php5 constructor |
---|
| 122 | // Note: if $table is defined, then we will use it as our table name |
---|
| 123 | // Otherwise we will use our classname... |
---|
| 124 | // In our database, table names are pluralized (because there can be |
---|
| 125 | // more than one row!) |
---|
| 126 | // Similarly, if $table is defined here, it has to be plural form. |
---|
| 127 | // |
---|
| 128 | // $options is an array that allows us to tweak the constructor's behaviour |
---|
| 129 | // if $options['refresh'] is true, we re-scan our metadata information |
---|
| 130 | // if $options['new'] is true, we forget all relations |
---|
| 131 | function __construct($table = false, $pkeyarr=false, $db=false, $options=array()) |
---|
| 132 | { |
---|
| 133 | global $ADODB_ASSOC_CASE,$_ADODB_ACTIVE_DBS; |
---|
| 134 | |
---|
| 135 | if ($db == false && is_object($pkeyarr)) { |
---|
| 136 | $db = $pkeyarr; |
---|
| 137 | $pkeyarr = false; |
---|
| 138 | } |
---|
| 139 | |
---|
| 140 | if($table) |
---|
| 141 | { |
---|
| 142 | // table argument exists. It is expected to be |
---|
| 143 | // already plural form. |
---|
| 144 | $this->_pTable = $table; |
---|
| 145 | $this->_sTable = $this->_singularize($this->_pTable); |
---|
| 146 | } |
---|
| 147 | else |
---|
| 148 | { |
---|
| 149 | // We will use current classname as table name. |
---|
| 150 | // We need to pluralize it for the real table name. |
---|
| 151 | $this->_sTable = strtolower(get_class($this)); |
---|
| 152 | $this->_pTable = $this->_pluralize($this->_sTable); |
---|
| 153 | } |
---|
| 154 | $this->_table = &$this->_pTable; |
---|
| 155 | |
---|
| 156 | $this->foreignName = $this->_sTable; // CFR: default foreign name (singular) |
---|
| 157 | |
---|
| 158 | if ($db) { |
---|
| 159 | $this->_dbat = ADODB_Active_Record::SetDatabaseAdapter($db); |
---|
| 160 | } else |
---|
| 161 | $this->_dbat = sizeof($_ADODB_ACTIVE_DBS)-1; |
---|
| 162 | |
---|
| 163 | |
---|
| 164 | if ($this->_dbat < 0) $this->Error("No database connection set; use ADOdb_Active_Record::SetDatabaseAdapter(\$db)",'ADODB_Active_Record::__constructor'); |
---|
| 165 | |
---|
| 166 | $this->_tableat = $this->_table; # reserved for setting the assoc value to a non-table name, eg. the sql string in future |
---|
| 167 | |
---|
| 168 | // CFR: Just added this option because UpdateActiveTable() can refresh its information |
---|
| 169 | // but there was no way to ask it to do that. |
---|
| 170 | $forceUpdate = (isset($options['refresh']) && true === $options['refresh']); |
---|
| 171 | $this->UpdateActiveTable($pkeyarr, $forceUpdate); |
---|
| 172 | if(isset($options['new']) && true === $options['new']) |
---|
| 173 | { |
---|
| 174 | $table =& $this->TableInfo(); |
---|
| 175 | unset($table->_hasMany); |
---|
| 176 | unset($table->_belongsTo); |
---|
| 177 | $table->_hasMany = array(); |
---|
| 178 | $table->_belongsTo = array(); |
---|
| 179 | } |
---|
| 180 | } |
---|
| 181 | |
---|
| 182 | function __wakeup() |
---|
| 183 | { |
---|
| 184 | $class = get_class($this); |
---|
| 185 | new $class; |
---|
| 186 | } |
---|
| 187 | |
---|
| 188 | // CFR: Constants found in Rails |
---|
| 189 | static $IrregularP = array( |
---|
| 190 | 'PERSON' => 'people', |
---|
| 191 | 'MAN' => 'men', |
---|
| 192 | 'WOMAN' => 'women', |
---|
| 193 | 'CHILD' => 'children', |
---|
| 194 | 'COW' => 'kine', |
---|
| 195 | ); |
---|
| 196 | |
---|
| 197 | static $IrregularS = array( |
---|
| 198 | 'PEOPLE' => 'PERSON', |
---|
| 199 | 'MEN' => 'man', |
---|
| 200 | 'WOMEN' => 'woman', |
---|
| 201 | 'CHILDREN' => 'child', |
---|
| 202 | 'KINE' => 'cow', |
---|
| 203 | ); |
---|
| 204 | |
---|
| 205 | static $WeIsI = array( |
---|
| 206 | 'EQUIPMENT' => true, |
---|
| 207 | 'INFORMATION' => true, |
---|
| 208 | 'RICE' => true, |
---|
| 209 | 'MONEY' => true, |
---|
| 210 | 'SPECIES' => true, |
---|
| 211 | 'SERIES' => true, |
---|
| 212 | 'FISH' => true, |
---|
| 213 | 'SHEEP' => true, |
---|
| 214 | ); |
---|
| 215 | |
---|
| 216 | function _pluralize($table) |
---|
| 217 | { |
---|
| 218 | if (!ADODB_Active_Record::$_changeNames) return $table; |
---|
| 219 | |
---|
| 220 | $ut = strtoupper($table); |
---|
| 221 | if(isset(self::$WeIsI[$ut])) |
---|
| 222 | { |
---|
| 223 | return $table; |
---|
| 224 | } |
---|
| 225 | if(isset(self::$IrregularP[$ut])) |
---|
| 226 | { |
---|
| 227 | return self::$IrregularP[$ut]; |
---|
| 228 | } |
---|
| 229 | $len = strlen($table); |
---|
| 230 | $lastc = $ut[$len-1]; |
---|
| 231 | $lastc2 = substr($ut,$len-2); |
---|
| 232 | switch ($lastc) { |
---|
| 233 | case 'S': |
---|
| 234 | return $table.'es'; |
---|
| 235 | case 'Y': |
---|
| 236 | return substr($table,0,$len-1).'ies'; |
---|
| 237 | case 'X': |
---|
| 238 | return $table.'es'; |
---|
| 239 | case 'H': |
---|
| 240 | if ($lastc2 == 'CH' || $lastc2 == 'SH') |
---|
| 241 | return $table.'es'; |
---|
| 242 | default: |
---|
| 243 | return $table.'s'; |
---|
| 244 | } |
---|
| 245 | } |
---|
| 246 | |
---|
| 247 | // CFR Lamest singular inflector ever - @todo Make it real! |
---|
| 248 | // Note: There is an assumption here...and it is that the argument's length >= 4 |
---|
| 249 | function _singularize($table) |
---|
| 250 | { |
---|
| 251 | |
---|
| 252 | if (!ADODB_Active_Record::$_changeNames) return $table; |
---|
| 253 | |
---|
| 254 | $ut = strtoupper($table); |
---|
| 255 | if(isset(self::$WeIsI[$ut])) |
---|
| 256 | { |
---|
| 257 | return $table; |
---|
| 258 | } |
---|
| 259 | if(isset(self::$IrregularS[$ut])) |
---|
| 260 | { |
---|
| 261 | return self::$IrregularS[$ut]; |
---|
| 262 | } |
---|
| 263 | $len = strlen($table); |
---|
| 264 | if($ut[$len-1] != 'S') |
---|
| 265 | return $table; // I know...forget oxen |
---|
| 266 | if($ut[$len-2] != 'E') |
---|
| 267 | return substr($table, 0, $len-1); |
---|
| 268 | switch($ut[$len-3]) |
---|
| 269 | { |
---|
| 270 | case 'S': |
---|
| 271 | case 'X': |
---|
| 272 | return substr($table, 0, $len-2); |
---|
| 273 | case 'I': |
---|
| 274 | return substr($table, 0, $len-3) . 'y'; |
---|
| 275 | case 'H'; |
---|
| 276 | if($ut[$len-4] == 'C' || $ut[$len-4] == 'S') |
---|
| 277 | return substr($table, 0, $len-2); |
---|
| 278 | default: |
---|
| 279 | return substr($table, 0, $len-1); // ? |
---|
| 280 | } |
---|
| 281 | } |
---|
| 282 | |
---|
| 283 | /* |
---|
| 284 | * ar->foreignName will contain the name of the tables associated with this table because |
---|
| 285 | * these other tables' rows may also be referenced by this table using theirname_id or the provided |
---|
| 286 | * foreign keys (this index name is stored in ar->foreignKey) |
---|
| 287 | * |
---|
| 288 | * this-table.id = other-table-#1.this-table_id |
---|
| 289 | * = other-table-#2.this-table_id |
---|
| 290 | */ |
---|
| 291 | function hasMany($foreignRef,$foreignKey=false) |
---|
| 292 | { |
---|
| 293 | $ar = new ADODB_Active_Record($foreignRef); |
---|
| 294 | $ar->foreignName = $foreignRef; |
---|
| 295 | $ar->UpdateActiveTable(); |
---|
| 296 | $ar->foreignKey = ($foreignKey) ? $foreignKey : strtolower(get_class($this)) . self::$_foreignSuffix; |
---|
| 297 | |
---|
| 298 | $table =& $this->TableInfo(); |
---|
| 299 | if(!isset($table->_hasMany[$foreignRef])) |
---|
| 300 | { |
---|
| 301 | $table->_hasMany[$foreignRef] = $ar; |
---|
| 302 | $table->updateColsCount(); |
---|
| 303 | } |
---|
| 304 | # @todo Can I make this guy be lazy? |
---|
| 305 | $this->$foreignRef = $table->_hasMany[$foreignRef]; // WATCHME Removed assignment by ref. to please __get() |
---|
| 306 | } |
---|
| 307 | |
---|
| 308 | /** |
---|
| 309 | * ar->foreignName will contain the name of the tables associated with this table because |
---|
| 310 | * this table's rows may also be referenced by those tables using thistable_id or the provided |
---|
| 311 | * foreign keys (this index name is stored in ar->foreignKey) |
---|
| 312 | * |
---|
| 313 | * this-table.other-table_id = other-table.id |
---|
| 314 | */ |
---|
| 315 | function belongsTo($foreignRef,$foreignKey=false) |
---|
| 316 | { |
---|
| 317 | global $inflector; |
---|
| 318 | |
---|
| 319 | $ar = new ADODB_Active_Record($this->_pluralize($foreignRef)); |
---|
| 320 | $ar->foreignName = $foreignRef; |
---|
| 321 | $ar->UpdateActiveTable(); |
---|
| 322 | $ar->foreignKey = ($foreignKey) ? $foreignKey : $ar->foreignName . self::$_foreignSuffix; |
---|
| 323 | |
---|
| 324 | $table =& $this->TableInfo(); |
---|
| 325 | if(!isset($table->_belongsTo[$foreignRef])) |
---|
| 326 | { |
---|
| 327 | $table->_belongsTo[$foreignRef] = $ar; |
---|
| 328 | $table->updateColsCount(); |
---|
| 329 | } |
---|
| 330 | $this->$foreignRef = $table->_belongsTo[$foreignRef]; |
---|
| 331 | } |
---|
| 332 | |
---|
| 333 | /** |
---|
| 334 | * __get Access properties - used for lazy loading |
---|
| 335 | * |
---|
| 336 | * @param mixed $name |
---|
| 337 | * @access protected |
---|
| 338 | * @return void |
---|
| 339 | */ |
---|
| 340 | function __get($name) |
---|
| 341 | { |
---|
| 342 | return $this->LoadRelations($name, '', -1. -1); |
---|
| 343 | } |
---|
| 344 | |
---|
| 345 | function LoadRelations($name, $whereOrderBy, $offset=-1, $limit=-1) |
---|
| 346 | { |
---|
| 347 | $extras = array(); |
---|
| 348 | if($offset >= 0) $extras['offset'] = $offset; |
---|
| 349 | if($limit >= 0) $extras['limit'] = $limit; |
---|
| 350 | $table =& $this->TableInfo(); |
---|
| 351 | |
---|
| 352 | if (strlen($whereOrderBy)) |
---|
| 353 | if (!preg_match('/^[ \n\r]*AND/i',$whereOrderBy)) |
---|
| 354 | if (!preg_match('/^[ \n\r]*ORDER[ \n\r]/i',$whereOrderBy)) |
---|
| 355 | $whereOrderBy = 'AND '.$whereOrderBy; |
---|
| 356 | |
---|
| 357 | if(!empty($table->_belongsTo[$name])) |
---|
| 358 | { |
---|
| 359 | $obj = $table->_belongsTo[$name]; |
---|
| 360 | $columnName = $obj->foreignKey; |
---|
| 361 | if(empty($this->$columnName)) |
---|
| 362 | $this->$name = null; |
---|
| 363 | else |
---|
| 364 | { |
---|
| 365 | if(($k = reset($obj->TableInfo()->keys))) |
---|
| 366 | $belongsToId = $k; |
---|
| 367 | else |
---|
| 368 | $belongsToId = 'id'; |
---|
| 369 | |
---|
| 370 | $arrayOfOne = |
---|
| 371 | $obj->Find( |
---|
| 372 | $belongsToId.'='.$this->$columnName.' '.$whereOrderBy, false, false, $extras); |
---|
| 373 | $this->$name = $arrayOfOne[0]; |
---|
| 374 | } |
---|
| 375 | return $this->$name; |
---|
| 376 | } |
---|
| 377 | if(!empty($table->_hasMany[$name])) |
---|
| 378 | { |
---|
| 379 | $obj = $table->_hasMany[$name]; |
---|
| 380 | if(($k = reset($table->keys))) |
---|
| 381 | $hasManyId = $k; |
---|
| 382 | else |
---|
| 383 | $hasManyId = 'id'; |
---|
| 384 | |
---|
| 385 | $this->$name = |
---|
| 386 | $obj->Find( |
---|
| 387 | $obj->foreignKey.'='.$this->$hasManyId.' '.$whereOrderBy, false, false, $extras); |
---|
| 388 | return $this->$name; |
---|
| 389 | } |
---|
| 390 | } |
---|
| 391 | ////////////////////////////////// |
---|
| 392 | |
---|
| 393 | // update metadata |
---|
| 394 | function UpdateActiveTable($pkeys=false,$forceUpdate=false) |
---|
| 395 | { |
---|
| 396 | global $ADODB_ASSOC_CASE,$_ADODB_ACTIVE_DBS , $ADODB_CACHE_DIR, $ADODB_ACTIVE_CACHESECS; |
---|
| 397 | global $ADODB_ACTIVE_DEFVALS, $ADODB_FETCH_MODE; |
---|
| 398 | |
---|
| 399 | $activedb = $_ADODB_ACTIVE_DBS[$this->_dbat]; |
---|
| 400 | |
---|
| 401 | $table = $this->_table; |
---|
| 402 | $tables = $activedb->tables; |
---|
| 403 | $tableat = $this->_tableat; |
---|
| 404 | if (!$forceUpdate && !empty($tables[$tableat])) { |
---|
| 405 | |
---|
| 406 | $tobj = $tables[$tableat]; |
---|
| 407 | foreach($tobj->flds as $name => $fld) { |
---|
| 408 | if ($ADODB_ACTIVE_DEFVALS && isset($fld->default_value)) |
---|
| 409 | $this->$name = $fld->default_value; |
---|
| 410 | else |
---|
| 411 | $this->$name = null; |
---|
| 412 | } |
---|
| 413 | return; |
---|
| 414 | } |
---|
| 415 | |
---|
| 416 | $db = $activedb->db; |
---|
| 417 | $fname = $ADODB_CACHE_DIR . '/adodb_' . $db->databaseType . '_active_'. $table . '.cache'; |
---|
| 418 | if (!$forceUpdate && $ADODB_ACTIVE_CACHESECS && $ADODB_CACHE_DIR && file_exists($fname)) { |
---|
| 419 | $fp = fopen($fname,'r'); |
---|
| 420 | @flock($fp, LOCK_SH); |
---|
| 421 | $acttab = unserialize(fread($fp,100000)); |
---|
| 422 | fclose($fp); |
---|
| 423 | if ($acttab->_created + $ADODB_ACTIVE_CACHESECS - (abs(rand()) % 16) > time()) { |
---|
| 424 | // abs(rand()) randomizes deletion, reducing contention to delete/refresh file |
---|
| 425 | // ideally, you should cache at least 32 secs |
---|
| 426 | $activedb->tables[$table] = $acttab; |
---|
| 427 | |
---|
| 428 | //if ($db->debug) ADOConnection::outp("Reading cached active record file: $fname"); |
---|
| 429 | return; |
---|
| 430 | } else if ($db->debug) { |
---|
| 431 | ADOConnection::outp("Refreshing cached active record file: $fname"); |
---|
| 432 | } |
---|
| 433 | } |
---|
| 434 | $activetab = new ADODB_Active_Table(); |
---|
| 435 | $activetab->name = $table; |
---|
| 436 | |
---|
| 437 | $save = $ADODB_FETCH_MODE; |
---|
| 438 | $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; |
---|
| 439 | if ($db->fetchMode !== false) $savem = $db->SetFetchMode(false); |
---|
| 440 | |
---|
| 441 | $cols = $db->MetaColumns($table); |
---|
| 442 | |
---|
| 443 | if (isset($savem)) $db->SetFetchMode($savem); |
---|
| 444 | $ADODB_FETCH_MODE = $save; |
---|
| 445 | |
---|
| 446 | if (!$cols) { |
---|
| 447 | $this->Error("Invalid table name: $table",'UpdateActiveTable'); |
---|
| 448 | return false; |
---|
| 449 | } |
---|
| 450 | $fld = reset($cols); |
---|
| 451 | if (!$pkeys) { |
---|
| 452 | if (isset($fld->primary_key)) { |
---|
| 453 | $pkeys = array(); |
---|
| 454 | foreach($cols as $name => $fld) { |
---|
| 455 | if (!empty($fld->primary_key)) $pkeys[] = $name; |
---|
| 456 | } |
---|
| 457 | } else |
---|
| 458 | $pkeys = $this->GetPrimaryKeys($db, $table); |
---|
| 459 | } |
---|
| 460 | if (empty($pkeys)) { |
---|
| 461 | $this->Error("No primary key found for table $table",'UpdateActiveTable'); |
---|
| 462 | return false; |
---|
| 463 | } |
---|
| 464 | |
---|
| 465 | $attr = array(); |
---|
| 466 | $keys = array(); |
---|
| 467 | |
---|
| 468 | switch($ADODB_ASSOC_CASE) { |
---|
| 469 | case 0: |
---|
| 470 | foreach($cols as $name => $fldobj) { |
---|
| 471 | $name = strtolower($name); |
---|
| 472 | if ($ADODB_ACTIVE_DEFVALS && isset($fldobj->default_value)) |
---|
| 473 | $this->$name = $fldobj->default_value; |
---|
| 474 | else |
---|
| 475 | $this->$name = null; |
---|
| 476 | $attr[$name] = $fldobj; |
---|
| 477 | } |
---|
| 478 | foreach($pkeys as $k => $name) { |
---|
| 479 | $keys[strtolower($name)] = strtolower($name); |
---|
| 480 | } |
---|
| 481 | break; |
---|
| 482 | |
---|
| 483 | case 1: |
---|
| 484 | foreach($cols as $name => $fldobj) { |
---|
| 485 | $name = strtoupper($name); |
---|
| 486 | |
---|
| 487 | if ($ADODB_ACTIVE_DEFVALS && isset($fldobj->default_value)) |
---|
| 488 | $this->$name = $fldobj->default_value; |
---|
| 489 | else |
---|
| 490 | $this->$name = null; |
---|
| 491 | $attr[$name] = $fldobj; |
---|
| 492 | } |
---|
| 493 | |
---|
| 494 | foreach($pkeys as $k => $name) { |
---|
| 495 | $keys[strtoupper($name)] = strtoupper($name); |
---|
| 496 | } |
---|
| 497 | break; |
---|
| 498 | default: |
---|
| 499 | foreach($cols as $name => $fldobj) { |
---|
| 500 | $name = ($fldobj->name); |
---|
| 501 | |
---|
| 502 | if ($ADODB_ACTIVE_DEFVALS && isset($fldobj->default_value)) |
---|
| 503 | $this->$name = $fldobj->default_value; |
---|
| 504 | else |
---|
| 505 | $this->$name = null; |
---|
| 506 | $attr[$name] = $fldobj; |
---|
| 507 | } |
---|
| 508 | foreach($pkeys as $k => $name) { |
---|
| 509 | $keys[$name] = $cols[$name]->name; |
---|
| 510 | } |
---|
| 511 | break; |
---|
| 512 | } |
---|
| 513 | |
---|
| 514 | $activetab->keys = $keys; |
---|
| 515 | $activetab->flds = $attr; |
---|
| 516 | $activetab->updateColsCount(); |
---|
| 517 | |
---|
| 518 | if ($ADODB_ACTIVE_CACHESECS && $ADODB_CACHE_DIR) { |
---|
| 519 | $activetab->_created = time(); |
---|
| 520 | $s = serialize($activetab); |
---|
| 521 | if (!function_exists('adodb_write_file')) include(ADODB_DIR.'/adodb-csvlib.inc.php'); |
---|
| 522 | adodb_write_file($fname,$s); |
---|
| 523 | } |
---|
| 524 | if (isset($activedb->tables[$table])) { |
---|
| 525 | $oldtab = $activedb->tables[$table]; |
---|
| 526 | |
---|
| 527 | if ($oldtab) $activetab->_belongsTo = $oldtab->_belongsTo; |
---|
| 528 | if ($oldtab) $activetab->_hasMany = $oldtab->_hasMany; |
---|
| 529 | } |
---|
| 530 | $activedb->tables[$table] = $activetab; |
---|
| 531 | } |
---|
| 532 | |
---|
| 533 | function GetPrimaryKeys(&$db, $table) |
---|
| 534 | { |
---|
| 535 | return $db->MetaPrimaryKeys($table); |
---|
| 536 | } |
---|
| 537 | |
---|
| 538 | // error handler for both PHP4+5. |
---|
| 539 | function Error($err,$fn) |
---|
| 540 | { |
---|
| 541 | global $_ADODB_ACTIVE_DBS; |
---|
| 542 | |
---|
| 543 | $fn = get_class($this).'::'.$fn; |
---|
| 544 | $this->_lasterr = $fn.': '.$err; |
---|
| 545 | |
---|
| 546 | if ($this->_dbat < 0) $db = false; |
---|
| 547 | else { |
---|
| 548 | $activedb = $_ADODB_ACTIVE_DBS[$this->_dbat]; |
---|
| 549 | $db = $activedb->db; |
---|
| 550 | } |
---|
| 551 | |
---|
| 552 | if (function_exists('adodb_throw')) { |
---|
| 553 | if (!$db) adodb_throw('ADOdb_Active_Record', $fn, -1, $err, 0, 0, false); |
---|
| 554 | else adodb_throw($db->databaseType, $fn, -1, $err, 0, 0, $db); |
---|
| 555 | } else |
---|
| 556 | if (!$db || $db->debug) ADOConnection::outp($this->_lasterr); |
---|
| 557 | |
---|
| 558 | } |
---|
| 559 | |
---|
| 560 | // return last error message |
---|
| 561 | function ErrorMsg() |
---|
| 562 | { |
---|
| 563 | if (!function_exists('adodb_throw')) { |
---|
| 564 | if ($this->_dbat < 0) $db = false; |
---|
| 565 | else $db = $this->DB(); |
---|
| 566 | |
---|
| 567 | // last error could be database error too |
---|
| 568 | if ($db && $db->ErrorMsg()) return $db->ErrorMsg(); |
---|
| 569 | } |
---|
| 570 | return $this->_lasterr; |
---|
| 571 | } |
---|
| 572 | |
---|
| 573 | function ErrorNo() |
---|
| 574 | { |
---|
| 575 | if ($this->_dbat < 0) return -9999; // no database connection... |
---|
| 576 | $db = $this->DB(); |
---|
| 577 | |
---|
| 578 | return (int) $db->ErrorNo(); |
---|
| 579 | } |
---|
| 580 | |
---|
| 581 | |
---|
| 582 | // retrieve ADOConnection from _ADODB_Active_DBs |
---|
| 583 | function DB() |
---|
| 584 | { |
---|
| 585 | global $_ADODB_ACTIVE_DBS; |
---|
| 586 | |
---|
| 587 | if ($this->_dbat < 0) { |
---|
| 588 | $false = false; |
---|
| 589 | $this->Error("No database connection set: use ADOdb_Active_Record::SetDatabaseAdaptor(\$db)", "DB"); |
---|
| 590 | return $false; |
---|
| 591 | } |
---|
| 592 | $activedb = $_ADODB_ACTIVE_DBS[$this->_dbat]; |
---|
| 593 | $db = $activedb->db; |
---|
| 594 | return $db; |
---|
| 595 | } |
---|
| 596 | |
---|
| 597 | // retrieve ADODB_Active_Table |
---|
| 598 | function &TableInfo() |
---|
| 599 | { |
---|
| 600 | global $_ADODB_ACTIVE_DBS; |
---|
| 601 | |
---|
| 602 | $activedb = $_ADODB_ACTIVE_DBS[$this->_dbat]; |
---|
| 603 | $table = $activedb->tables[$this->_tableat]; |
---|
| 604 | return $table; |
---|
| 605 | } |
---|
| 606 | |
---|
| 607 | |
---|
| 608 | // I have an ON INSERT trigger on a table that sets other columns in the table. |
---|
| 609 | // So, I find that for myTable, I want to reload an active record after saving it. -- Malcolm Cook |
---|
| 610 | function Reload() |
---|
| 611 | { |
---|
| 612 | $db =& $this->DB(); if (!$db) return false; |
---|
| 613 | $table =& $this->TableInfo(); |
---|
| 614 | $where = $this->GenWhere($db, $table); |
---|
| 615 | return($this->Load($where)); |
---|
| 616 | } |
---|
| 617 | |
---|
| 618 | |
---|
| 619 | // set a numeric array (using natural table field ordering) as object properties |
---|
| 620 | function Set(&$row) |
---|
| 621 | { |
---|
| 622 | global $ACTIVE_RECORD_SAFETY; |
---|
| 623 | |
---|
| 624 | $db = $this->DB(); |
---|
| 625 | |
---|
| 626 | if (!$row) { |
---|
| 627 | $this->_saved = false; |
---|
| 628 | return false; |
---|
| 629 | } |
---|
| 630 | |
---|
| 631 | $this->_saved = true; |
---|
| 632 | |
---|
| 633 | $table = $this->TableInfo(); |
---|
| 634 | $sizeofFlds = sizeof($table->flds); |
---|
| 635 | $sizeofRow = sizeof($row); |
---|
| 636 | if ($ACTIVE_RECORD_SAFETY && $table->_colsCount != $sizeofRow && $sizeofFlds != $sizeofRow) { |
---|
| 637 | # <AP> |
---|
| 638 | $bad_size = TRUE; |
---|
| 639 | if($sizeofRow == 2 * $table->_colsCount || $sizeofRow == 2 * $sizeofFlds) { |
---|
| 640 | // Only keep string keys |
---|
| 641 | $keys = array_filter(array_keys($row), 'is_string'); |
---|
| 642 | if (sizeof($keys) == sizeof($table->flds)) |
---|
| 643 | $bad_size = FALSE; |
---|
| 644 | } |
---|
| 645 | if ($bad_size) { |
---|
| 646 | $this->Error("Table structure of $this->_table has changed","Load"); |
---|
| 647 | return false; |
---|
| 648 | } |
---|
| 649 | # </AP> |
---|
| 650 | } |
---|
| 651 | else |
---|
| 652 | $keys = array_keys($row); |
---|
| 653 | # <AP> |
---|
| 654 | reset($keys); |
---|
| 655 | $this->_original = array(); |
---|
| 656 | foreach($table->flds as $name=>$fld) |
---|
| 657 | { |
---|
| 658 | $value = $row[current($keys)]; |
---|
| 659 | $this->$name = $value; |
---|
| 660 | $this->_original[] = $value; |
---|
| 661 | if(!next($keys)) break; |
---|
| 662 | } |
---|
| 663 | $table =& $this->TableInfo(); |
---|
| 664 | foreach($table->_belongsTo as $foreignTable) |
---|
| 665 | { |
---|
| 666 | $ft = $foreignTable->TableInfo(); |
---|
| 667 | $propertyName = $ft->name; |
---|
| 668 | foreach($ft->flds as $name=>$fld) |
---|
| 669 | { |
---|
| 670 | $value = $row[current($keys)]; |
---|
| 671 | $foreignTable->$name = $value; |
---|
| 672 | $foreignTable->_original[] = $value; |
---|
| 673 | if(!next($keys)) break; |
---|
| 674 | } |
---|
| 675 | } |
---|
| 676 | foreach($table->_hasMany as $foreignTable) |
---|
| 677 | { |
---|
| 678 | $ft = $foreignTable->TableInfo(); |
---|
| 679 | foreach($ft->flds as $name=>$fld) |
---|
| 680 | { |
---|
| 681 | $value = $row[current($keys)]; |
---|
| 682 | $foreignTable->$name = $value; |
---|
| 683 | $foreignTable->_original[] = $value; |
---|
| 684 | if(!next($keys)) break; |
---|
| 685 | } |
---|
| 686 | } |
---|
| 687 | # </AP> |
---|
| 688 | return true; |
---|
| 689 | } |
---|
| 690 | |
---|
| 691 | // get last inserted id for INSERT |
---|
| 692 | function LastInsertID(&$db,$fieldname) |
---|
| 693 | { |
---|
| 694 | if ($db->hasInsertID) |
---|
| 695 | $val = $db->Insert_ID($this->_table,$fieldname); |
---|
| 696 | else |
---|
| 697 | $val = false; |
---|
| 698 | |
---|
| 699 | if (is_null($val) || $val === false) { |
---|
| 700 | // this might not work reliably in multi-user environment |
---|
| 701 | return $db->GetOne("select max(".$fieldname.") from ".$this->_table); |
---|
| 702 | } |
---|
| 703 | return $val; |
---|
| 704 | } |
---|
| 705 | |
---|
| 706 | // quote data in where clause |
---|
| 707 | function doquote(&$db, $val,$t) |
---|
| 708 | { |
---|
| 709 | switch($t) { |
---|
| 710 | case 'D': |
---|
| 711 | case 'T': |
---|
| 712 | if (empty($val)) return 'null'; |
---|
| 713 | |
---|
| 714 | case 'C': |
---|
| 715 | case 'X': |
---|
| 716 | if (is_null($val)) return 'null'; |
---|
| 717 | |
---|
| 718 | if (strlen($val)>0 && |
---|
| 719 | (strncmp($val,"'",1) != 0 || substr($val,strlen($val)-1,1) != "'")) { |
---|
| 720 | return $db->qstr($val); |
---|
| 721 | break; |
---|
| 722 | } |
---|
| 723 | default: |
---|
| 724 | return $val; |
---|
| 725 | break; |
---|
| 726 | } |
---|
| 727 | } |
---|
| 728 | |
---|
| 729 | // generate where clause for an UPDATE/SELECT |
---|
| 730 | function GenWhere(&$db, &$table) |
---|
| 731 | { |
---|
| 732 | $keys = $table->keys; |
---|
| 733 | $parr = array(); |
---|
| 734 | |
---|
| 735 | foreach($keys as $k) { |
---|
| 736 | $f = $table->flds[$k]; |
---|
| 737 | if ($f) { |
---|
| 738 | $parr[] = $k.' = '.$this->doquote($db,$this->$k,$db->MetaType($f->type)); |
---|
| 739 | } |
---|
| 740 | } |
---|
| 741 | return implode(' and ', $parr); |
---|
| 742 | } |
---|
| 743 | |
---|
| 744 | |
---|
| 745 | //------------------------------------------------------------ Public functions below |
---|
| 746 | |
---|
| 747 | function Load($where=null,$bindarr=false) |
---|
| 748 | { |
---|
| 749 | $db = $this->DB(); if (!$db) return false; |
---|
| 750 | $this->_where = $where; |
---|
| 751 | |
---|
| 752 | $save = $db->SetFetchMode(ADODB_FETCH_NUM); |
---|
| 753 | $qry = "select * from ".$this->_table; |
---|
| 754 | $table =& $this->TableInfo(); |
---|
| 755 | |
---|
| 756 | if(($k = reset($table->keys))) |
---|
| 757 | $hasManyId = $k; |
---|
| 758 | else |
---|
| 759 | $hasManyId = 'id'; |
---|
| 760 | |
---|
| 761 | foreach($table->_belongsTo as $foreignTable) |
---|
| 762 | { |
---|
| 763 | if(($k = reset($foreignTable->TableInfo()->keys))) |
---|
| 764 | { |
---|
| 765 | $belongsToId = $k; |
---|
| 766 | } |
---|
| 767 | else |
---|
| 768 | { |
---|
| 769 | $belongsToId = 'id'; |
---|
| 770 | } |
---|
| 771 | $qry .= ' LEFT JOIN '.$foreignTable->_table.' ON '. |
---|
| 772 | $this->_table.'.'.$foreignTable->foreignKey.'='. |
---|
| 773 | $foreignTable->_table.'.'.$belongsToId; |
---|
| 774 | } |
---|
| 775 | foreach($table->_hasMany as $foreignTable) |
---|
| 776 | { |
---|
| 777 | $qry .= ' LEFT JOIN '.$foreignTable->_table.' ON '. |
---|
| 778 | $this->_table.'.'.$hasManyId.'='. |
---|
| 779 | $foreignTable->_table.'.'.$foreignTable->foreignKey; |
---|
| 780 | } |
---|
| 781 | if($where) |
---|
| 782 | $qry .= ' WHERE '.$where; |
---|
| 783 | |
---|
| 784 | // Simple case: no relations. Load row and return. |
---|
| 785 | if((count($table->_hasMany) + count($table->_belongsTo)) < 1) |
---|
| 786 | { |
---|
| 787 | $row = $db->GetRow($qry,$bindarr); |
---|
| 788 | if(!$row) |
---|
| 789 | return false; |
---|
| 790 | $db->SetFetchMode($save); |
---|
| 791 | return $this->Set($row); |
---|
| 792 | } |
---|
| 793 | |
---|
| 794 | // More complex case when relations have to be collated |
---|
| 795 | $rows = $db->GetAll($qry,$bindarr); |
---|
| 796 | if(!$rows) |
---|
| 797 | return false; |
---|
| 798 | $db->SetFetchMode($save); |
---|
| 799 | if(count($rows) < 1) |
---|
| 800 | return false; |
---|
| 801 | $class = get_class($this); |
---|
| 802 | $isFirstRow = true; |
---|
| 803 | |
---|
| 804 | if(($k = reset($this->TableInfo()->keys))) |
---|
| 805 | $myId = $k; |
---|
| 806 | else |
---|
| 807 | $myId = 'id'; |
---|
| 808 | $index = 0; $found = false; |
---|
| 809 | /** @todo Improve by storing once and for all in table metadata */ |
---|
| 810 | /** @todo Also re-use info for hasManyId */ |
---|
| 811 | foreach($this->TableInfo()->flds as $fld) |
---|
| 812 | { |
---|
| 813 | if($fld->name == $myId) |
---|
| 814 | { |
---|
| 815 | $found = true; |
---|
| 816 | break; |
---|
| 817 | } |
---|
| 818 | $index++; |
---|
| 819 | } |
---|
| 820 | if(!$found) |
---|
| 821 | $this->outp_throw("Unable to locate key $myId for $class in Load()",'Load'); |
---|
| 822 | |
---|
| 823 | foreach($rows as $row) |
---|
| 824 | { |
---|
| 825 | $rowId = intval($row[$index]); |
---|
| 826 | if($rowId > 0) |
---|
| 827 | { |
---|
| 828 | if($isFirstRow) |
---|
| 829 | { |
---|
| 830 | $isFirstRow = false; |
---|
| 831 | if(!$this->Set($row)) |
---|
| 832 | return false; |
---|
| 833 | } |
---|
| 834 | $obj = new $class($table,false,$db); |
---|
| 835 | $obj->Set($row); |
---|
| 836 | // TODO Copy/paste code below: bad! |
---|
| 837 | if(count($table->_hasMany) > 0) |
---|
| 838 | { |
---|
| 839 | foreach($table->_hasMany as $foreignTable) |
---|
| 840 | { |
---|
| 841 | $foreignName = $foreignTable->foreignName; |
---|
| 842 | if(!empty($obj->$foreignName)) |
---|
| 843 | { |
---|
| 844 | if(!is_array($this->$foreignName)) |
---|
| 845 | { |
---|
| 846 | $foreignObj = $this->$foreignName; |
---|
| 847 | $this->$foreignName = array(clone($foreignObj)); |
---|
| 848 | } |
---|
| 849 | else |
---|
| 850 | { |
---|
| 851 | $foreignObj = $obj->$foreignName; |
---|
| 852 | array_push($this->$foreignName, clone($foreignObj)); |
---|
| 853 | } |
---|
| 854 | } |
---|
| 855 | } |
---|
| 856 | } |
---|
| 857 | if(count($table->_belongsTo) > 0) |
---|
| 858 | { |
---|
| 859 | foreach($table->_belongsTo as $foreignTable) |
---|
| 860 | { |
---|
| 861 | $foreignName = $foreignTable->foreignName; |
---|
| 862 | if(!empty($obj->$foreignName)) |
---|
| 863 | { |
---|
| 864 | if(!is_array($this->$foreignName)) |
---|
| 865 | { |
---|
| 866 | $foreignObj = $this->$foreignName; |
---|
| 867 | $this->$foreignName = array(clone($foreignObj)); |
---|
| 868 | } |
---|
| 869 | else |
---|
| 870 | { |
---|
| 871 | $foreignObj = $obj->$foreignName; |
---|
| 872 | array_push($this->$foreignName, clone($foreignObj)); |
---|
| 873 | } |
---|
| 874 | } |
---|
| 875 | } |
---|
| 876 | } |
---|
| 877 | } |
---|
| 878 | } |
---|
| 879 | return true; |
---|
| 880 | } |
---|
| 881 | |
---|
| 882 | // false on error |
---|
| 883 | function Save() |
---|
| 884 | { |
---|
| 885 | if ($this->_saved) $ok = $this->Update(); |
---|
| 886 | else $ok = $this->Insert(); |
---|
| 887 | |
---|
| 888 | return $ok; |
---|
| 889 | } |
---|
| 890 | |
---|
| 891 | // CFR: Sometimes we may wish to consider that an object is not to be replaced but inserted. |
---|
| 892 | // Sample use case: an 'undo' command object (after a delete()) |
---|
| 893 | function Dirty() |
---|
| 894 | { |
---|
| 895 | $this->_saved = false; |
---|
| 896 | } |
---|
| 897 | |
---|
| 898 | // false on error |
---|
| 899 | function Insert() |
---|
| 900 | { |
---|
| 901 | $db = $this->DB(); if (!$db) return false; |
---|
| 902 | $cnt = 0; |
---|
| 903 | $table = $this->TableInfo(); |
---|
| 904 | |
---|
| 905 | $valarr = array(); |
---|
| 906 | $names = array(); |
---|
| 907 | $valstr = array(); |
---|
| 908 | |
---|
| 909 | foreach($table->flds as $name=>$fld) { |
---|
| 910 | $val = $this->$name; |
---|
| 911 | if(!is_null($val) || !array_key_exists($name, $table->keys)) { |
---|
| 912 | $valarr[] = $val; |
---|
| 913 | $names[] = $name; |
---|
| 914 | $valstr[] = $db->Param($cnt); |
---|
| 915 | $cnt += 1; |
---|
| 916 | } |
---|
| 917 | } |
---|
| 918 | |
---|
| 919 | if (empty($names)){ |
---|
| 920 | foreach($table->flds as $name=>$fld) { |
---|
| 921 | $valarr[] = null; |
---|
| 922 | $names[] = $name; |
---|
| 923 | $valstr[] = $db->Param($cnt); |
---|
| 924 | $cnt += 1; |
---|
| 925 | } |
---|
| 926 | } |
---|
| 927 | $sql = 'INSERT INTO '.$this->_table."(".implode(',',$names).') VALUES ('.implode(',',$valstr).')'; |
---|
| 928 | $ok = $db->Execute($sql,$valarr); |
---|
| 929 | |
---|
| 930 | if ($ok) { |
---|
| 931 | $this->_saved = true; |
---|
| 932 | $autoinc = false; |
---|
| 933 | foreach($table->keys as $k) { |
---|
| 934 | if (is_null($this->$k)) { |
---|
| 935 | $autoinc = true; |
---|
| 936 | break; |
---|
| 937 | } |
---|
| 938 | } |
---|
| 939 | if ($autoinc && sizeof($table->keys) == 1) { |
---|
| 940 | $k = reset($table->keys); |
---|
| 941 | $this->$k = $this->LastInsertID($db,$k); |
---|
| 942 | } |
---|
| 943 | } |
---|
| 944 | |
---|
| 945 | $this->_original = $valarr; |
---|
| 946 | return !empty($ok); |
---|
| 947 | } |
---|
| 948 | |
---|
| 949 | function Delete() |
---|
| 950 | { |
---|
| 951 | $db = $this->DB(); if (!$db) return false; |
---|
| 952 | $table = $this->TableInfo(); |
---|
| 953 | |
---|
| 954 | $where = $this->GenWhere($db,$table); |
---|
| 955 | $sql = 'DELETE FROM '.$this->_table.' WHERE '.$where; |
---|
| 956 | $ok = $db->Execute($sql); |
---|
| 957 | |
---|
| 958 | return $ok ? true : false; |
---|
| 959 | } |
---|
| 960 | |
---|
| 961 | // returns an array of active record objects |
---|
| 962 | function Find($whereOrderBy,$bindarr=false,$pkeysArr=false,$extra=array()) |
---|
| 963 | { |
---|
| 964 | $db = $this->DB(); if (!$db || empty($this->_table)) return false; |
---|
| 965 | $table =& $this->TableInfo(); |
---|
| 966 | $arr = $db->GetActiveRecordsClass(get_class($this),$this, $whereOrderBy,$bindarr,$pkeysArr,$extra, |
---|
| 967 | array('foreignName'=>$this->foreignName, 'belongsTo'=>$table->_belongsTo, 'hasMany'=>$table->_hasMany)); |
---|
| 968 | return $arr; |
---|
| 969 | } |
---|
| 970 | |
---|
| 971 | // CFR: In introduced this method to ensure that inner workings are not disturbed by |
---|
| 972 | // subclasses...for instance when GetActiveRecordsClass invokes Find() |
---|
| 973 | // Why am I not invoking parent::Find? |
---|
| 974 | // Shockingly because I want to preserve PHP4 compatibility. |
---|
| 975 | function packageFind($whereOrderBy,$bindarr=false,$pkeysArr=false,$extra=array()) |
---|
| 976 | { |
---|
| 977 | $db = $this->DB(); if (!$db || empty($this->_table)) return false; |
---|
| 978 | $table =& $this->TableInfo(); |
---|
| 979 | $arr = $db->GetActiveRecordsClass(get_class($this),$this, $whereOrderBy,$bindarr,$pkeysArr,$extra, |
---|
| 980 | array('foreignName'=>$this->foreignName, 'belongsTo'=>$table->_belongsTo, 'hasMany'=>$table->_hasMany)); |
---|
| 981 | return $arr; |
---|
| 982 | } |
---|
| 983 | |
---|
| 984 | // returns 0 on error, 1 on update, 2 on insert |
---|
| 985 | function Replace() |
---|
| 986 | { |
---|
| 987 | global $ADODB_ASSOC_CASE; |
---|
| 988 | |
---|
| 989 | $db = $this->DB(); if (!$db) return false; |
---|
| 990 | $table = $this->TableInfo(); |
---|
| 991 | |
---|
| 992 | $pkey = $table->keys; |
---|
| 993 | |
---|
| 994 | foreach($table->flds as $name=>$fld) { |
---|
| 995 | $val = $this->$name; |
---|
| 996 | /* |
---|
| 997 | if (is_null($val)) { |
---|
| 998 | if (isset($fld->not_null) && $fld->not_null) { |
---|
| 999 | if (isset($fld->default_value) && strlen($fld->default_value)) continue; |
---|
| 1000 | else { |
---|
| 1001 | $this->Error("Cannot update null into $name","Replace"); |
---|
| 1002 | return false; |
---|
| 1003 | } |
---|
| 1004 | } |
---|
| 1005 | }*/ |
---|
| 1006 | if (is_null($val) && !empty($fld->auto_increment)) { |
---|
| 1007 | continue; |
---|
| 1008 | } |
---|
| 1009 | $t = $db->MetaType($fld->type); |
---|
| 1010 | $arr[$name] = $this->doquote($db,$val,$t); |
---|
| 1011 | $valarr[] = $val; |
---|
| 1012 | } |
---|
| 1013 | |
---|
| 1014 | if (!is_array($pkey)) $pkey = array($pkey); |
---|
| 1015 | |
---|
| 1016 | |
---|
| 1017 | if ($ADODB_ASSOC_CASE == 0) |
---|
| 1018 | foreach($pkey as $k => $v) |
---|
| 1019 | $pkey[$k] = strtolower($v); |
---|
| 1020 | elseif ($ADODB_ASSOC_CASE == 1) |
---|
| 1021 | foreach($pkey as $k => $v) |
---|
| 1022 | $pkey[$k] = strtoupper($v); |
---|
| 1023 | |
---|
| 1024 | $ok = $db->Replace($this->_table,$arr,$pkey); |
---|
| 1025 | if ($ok) { |
---|
| 1026 | $this->_saved = true; // 1= update 2=insert |
---|
| 1027 | if ($ok == 2) { |
---|
| 1028 | $autoinc = false; |
---|
| 1029 | foreach($table->keys as $k) { |
---|
| 1030 | if (is_null($this->$k)) { |
---|
| 1031 | $autoinc = true; |
---|
| 1032 | break; |
---|
| 1033 | } |
---|
| 1034 | } |
---|
| 1035 | if ($autoinc && sizeof($table->keys) == 1) { |
---|
| 1036 | $k = reset($table->keys); |
---|
| 1037 | $this->$k = $this->LastInsertID($db,$k); |
---|
| 1038 | } |
---|
| 1039 | } |
---|
| 1040 | |
---|
| 1041 | $this->_original = $valarr; |
---|
| 1042 | } |
---|
| 1043 | return $ok; |
---|
| 1044 | } |
---|
| 1045 | |
---|
| 1046 | // returns 0 on error, 1 on update, -1 if no change in data (no update) |
---|
| 1047 | function Update() |
---|
| 1048 | { |
---|
| 1049 | $db = $this->DB(); if (!$db) return false; |
---|
| 1050 | $table = $this->TableInfo(); |
---|
| 1051 | |
---|
| 1052 | $where = $this->GenWhere($db, $table); |
---|
| 1053 | |
---|
| 1054 | if (!$where) { |
---|
| 1055 | $this->error("Where missing for table $table", "Update"); |
---|
| 1056 | return false; |
---|
| 1057 | } |
---|
| 1058 | $valarr = array(); |
---|
| 1059 | $neworig = array(); |
---|
| 1060 | $pairs = array(); |
---|
| 1061 | $i = -1; |
---|
| 1062 | $cnt = 0; |
---|
| 1063 | foreach($table->flds as $name=>$fld) { |
---|
| 1064 | $i += 1; |
---|
| 1065 | $val = $this->$name; |
---|
| 1066 | $neworig[] = $val; |
---|
| 1067 | |
---|
| 1068 | if (isset($table->keys[$name])) { |
---|
| 1069 | continue; |
---|
| 1070 | } |
---|
| 1071 | |
---|
| 1072 | if (is_null($val)) { |
---|
| 1073 | if (isset($fld->not_null) && $fld->not_null) { |
---|
| 1074 | if (isset($fld->default_value) && strlen($fld->default_value)) continue; |
---|
| 1075 | else { |
---|
| 1076 | $this->Error("Cannot set field $name to NULL","Update"); |
---|
| 1077 | return false; |
---|
| 1078 | } |
---|
| 1079 | } |
---|
| 1080 | } |
---|
| 1081 | |
---|
| 1082 | if (isset($this->_original[$i]) && $val == $this->_original[$i]) { |
---|
| 1083 | continue; |
---|
| 1084 | } |
---|
| 1085 | $valarr[] = $val; |
---|
| 1086 | $pairs[] = $name.'='.$db->Param($cnt); |
---|
| 1087 | $cnt += 1; |
---|
| 1088 | } |
---|
| 1089 | |
---|
| 1090 | |
---|
| 1091 | if (!$cnt) return -1; |
---|
| 1092 | $sql = 'UPDATE '.$this->_table." SET ".implode(",",$pairs)." WHERE ".$where; |
---|
| 1093 | $ok = $db->Execute($sql,$valarr); |
---|
| 1094 | if ($ok) { |
---|
| 1095 | $this->_original = $neworig; |
---|
| 1096 | return 1; |
---|
| 1097 | } |
---|
| 1098 | return 0; |
---|
| 1099 | } |
---|
| 1100 | |
---|
| 1101 | function GetAttributeNames() |
---|
| 1102 | { |
---|
| 1103 | $table = $this->TableInfo(); |
---|
| 1104 | if (!$table) return false; |
---|
| 1105 | return array_keys($table->flds); |
---|
| 1106 | } |
---|
| 1107 | |
---|
| 1108 | }; |
---|
| 1109 | |
---|
| 1110 | function adodb_GetActiveRecordsClass(&$db, $class, $tableObj,$whereOrderBy,$bindarr, $primkeyArr, |
---|
| 1111 | $extra, $relations) |
---|
| 1112 | { |
---|
| 1113 | global $_ADODB_ACTIVE_DBS; |
---|
| 1114 | |
---|
| 1115 | if (empty($extra['loading'])) $extra['loading'] = ADODB_LAZY_AR; |
---|
| 1116 | |
---|
| 1117 | $save = $db->SetFetchMode(ADODB_FETCH_NUM); |
---|
| 1118 | $table = &$tableObj->_table; |
---|
| 1119 | $tableInfo =& $tableObj->TableInfo(); |
---|
| 1120 | if(($k = reset($tableInfo->keys))) |
---|
| 1121 | $myId = $k; |
---|
| 1122 | else |
---|
| 1123 | $myId = 'id'; |
---|
| 1124 | $index = 0; $found = false; |
---|
| 1125 | /** @todo Improve by storing once and for all in table metadata */ |
---|
| 1126 | /** @todo Also re-use info for hasManyId */ |
---|
| 1127 | foreach($tableInfo->flds as $fld) |
---|
| 1128 | { |
---|
| 1129 | if($fld->name == $myId) |
---|
| 1130 | { |
---|
| 1131 | $found = true; |
---|
| 1132 | break; |
---|
| 1133 | } |
---|
| 1134 | $index++; |
---|
| 1135 | } |
---|
| 1136 | if(!$found) |
---|
| 1137 | $db->outp_throw("Unable to locate key $myId for $class in GetActiveRecordsClass()",'GetActiveRecordsClass'); |
---|
| 1138 | |
---|
| 1139 | $qry = "select * from ".$table; |
---|
| 1140 | if(ADODB_JOIN_AR == $extra['loading']) |
---|
| 1141 | { |
---|
| 1142 | if(!empty($relations['belongsTo'])) |
---|
| 1143 | { |
---|
| 1144 | foreach($relations['belongsTo'] as $foreignTable) |
---|
| 1145 | { |
---|
| 1146 | if(($k = reset($foreignTable->TableInfo()->keys))) |
---|
| 1147 | { |
---|
| 1148 | $belongsToId = $k; |
---|
| 1149 | } |
---|
| 1150 | else |
---|
| 1151 | { |
---|
| 1152 | $belongsToId = 'id'; |
---|
| 1153 | } |
---|
| 1154 | |
---|
| 1155 | $qry .= ' LEFT JOIN '.$foreignTable->_table.' ON '. |
---|
| 1156 | $table.'.'.$foreignTable->foreignKey.'='. |
---|
| 1157 | $foreignTable->_table.'.'.$belongsToId; |
---|
| 1158 | } |
---|
| 1159 | } |
---|
| 1160 | if(!empty($relations['hasMany'])) |
---|
| 1161 | { |
---|
| 1162 | if(empty($relations['foreignName'])) |
---|
| 1163 | $db->outp_throw("Missing foreignName is relation specification in GetActiveRecordsClass()",'GetActiveRecordsClass'); |
---|
| 1164 | if(($k = reset($tableInfo->keys))) |
---|
| 1165 | $hasManyId = $k; |
---|
| 1166 | else |
---|
| 1167 | $hasManyId = 'id'; |
---|
| 1168 | |
---|
| 1169 | foreach($relations['hasMany'] as $foreignTable) |
---|
| 1170 | { |
---|
| 1171 | $qry .= ' LEFT JOIN '.$foreignTable->_table.' ON '. |
---|
| 1172 | $table.'.'.$hasManyId.'='. |
---|
| 1173 | $foreignTable->_table.'.'.$foreignTable->foreignKey; |
---|
| 1174 | } |
---|
| 1175 | } |
---|
| 1176 | } |
---|
| 1177 | if (!empty($whereOrderBy)) |
---|
| 1178 | $qry .= ' WHERE '.$whereOrderBy; |
---|
| 1179 | if(isset($extra['limit'])) |
---|
| 1180 | { |
---|
| 1181 | $rows = false; |
---|
| 1182 | if(isset($extra['offset'])) { |
---|
| 1183 | $rs = $db->SelectLimit($qry, $extra['limit'], $extra['offset']); |
---|
| 1184 | } else { |
---|
| 1185 | $rs = $db->SelectLimit($qry, $extra['limit']); |
---|
| 1186 | } |
---|
| 1187 | if ($rs) { |
---|
| 1188 | while (!$rs->EOF) { |
---|
| 1189 | $rows[] = $rs->fields; |
---|
| 1190 | $rs->MoveNext(); |
---|
| 1191 | } |
---|
| 1192 | } |
---|
| 1193 | } else |
---|
| 1194 | $rows = $db->GetAll($qry,$bindarr); |
---|
| 1195 | |
---|
| 1196 | $db->SetFetchMode($save); |
---|
| 1197 | |
---|
| 1198 | $false = false; |
---|
| 1199 | |
---|
| 1200 | if ($rows === false) { |
---|
| 1201 | return $false; |
---|
| 1202 | } |
---|
| 1203 | |
---|
| 1204 | |
---|
| 1205 | if (!isset($_ADODB_ACTIVE_DBS)) { |
---|
| 1206 | include(ADODB_DIR.'/adodb-active-record.inc.php'); |
---|
| 1207 | } |
---|
| 1208 | if (!class_exists($class)) { |
---|
| 1209 | $db->outp_throw("Unknown class $class in GetActiveRecordsClass()",'GetActiveRecordsClass'); |
---|
| 1210 | return $false; |
---|
| 1211 | } |
---|
| 1212 | $uniqArr = array(); // CFR Keep track of records for relations |
---|
| 1213 | $arr = array(); |
---|
| 1214 | // arrRef will be the structure that knows about our objects. |
---|
| 1215 | // It is an associative array. |
---|
| 1216 | // We will, however, return arr, preserving regular 0.. order so that |
---|
| 1217 | // obj[0] can be used by app developpers. |
---|
| 1218 | $arrRef = array(); |
---|
| 1219 | $bTos = array(); // Will store belongTo's indices if any |
---|
| 1220 | foreach($rows as $row) { |
---|
| 1221 | |
---|
| 1222 | $obj = new $class($table,$primkeyArr,$db); |
---|
| 1223 | if ($obj->ErrorNo()){ |
---|
| 1224 | $db->_errorMsg = $obj->ErrorMsg(); |
---|
| 1225 | return $false; |
---|
| 1226 | } |
---|
| 1227 | $obj->Set($row); |
---|
| 1228 | // CFR: FIXME: Insane assumption here: |
---|
| 1229 | // If the first column returned is an integer, then it's a 'id' field |
---|
| 1230 | // And to make things a bit worse, I use intval() rather than is_int() because, in fact, |
---|
| 1231 | // $row[0] is not an integer. |
---|
| 1232 | // |
---|
| 1233 | // So, what does this whole block do? |
---|
| 1234 | // When relationships are found, we perform JOINs. This is fast. But not accurate: |
---|
| 1235 | // instead of returning n objects with their n' associated cousins, |
---|
| 1236 | // we get n*n' objects. This code fixes this. |
---|
| 1237 | // Note: to-many relationships mess around with the 'limit' parameter |
---|
| 1238 | $rowId = intval($row[$index]); |
---|
| 1239 | |
---|
| 1240 | if(ADODB_WORK_AR == $extra['loading']) |
---|
| 1241 | { |
---|
| 1242 | $arrRef[$rowId] = $obj; |
---|
| 1243 | $arr[] = &$arrRef[$rowId]; |
---|
| 1244 | if(!isset($indices)) |
---|
| 1245 | $indices = $rowId; |
---|
| 1246 | else |
---|
| 1247 | $indices .= ','.$rowId; |
---|
| 1248 | if(!empty($relations['belongsTo'])) |
---|
| 1249 | { |
---|
| 1250 | foreach($relations['belongsTo'] as $foreignTable) |
---|
| 1251 | { |
---|
| 1252 | $foreignTableRef = $foreignTable->foreignKey; |
---|
| 1253 | // First array: list of foreign ids we are looking for |
---|
| 1254 | if(empty($bTos[$foreignTableRef])) |
---|
| 1255 | $bTos[$foreignTableRef] = array(); |
---|
| 1256 | // Second array: list of ids found |
---|
| 1257 | if(empty($obj->$foreignTableRef)) |
---|
| 1258 | continue; |
---|
| 1259 | if(empty($bTos[$foreignTableRef][$obj->$foreignTableRef])) |
---|
| 1260 | $bTos[$foreignTableRef][$obj->$foreignTableRef] = array(); |
---|
| 1261 | $bTos[$foreignTableRef][$obj->$foreignTableRef][] = $obj; |
---|
| 1262 | } |
---|
| 1263 | } |
---|
| 1264 | continue; |
---|
| 1265 | } |
---|
| 1266 | |
---|
| 1267 | if($rowId>0) |
---|
| 1268 | { |
---|
| 1269 | if(ADODB_JOIN_AR == $extra['loading']) |
---|
| 1270 | { |
---|
| 1271 | $isNewObj = !isset($uniqArr['_'.$row[0]]); |
---|
| 1272 | if($isNewObj) |
---|
| 1273 | $uniqArr['_'.$row[0]] = $obj; |
---|
| 1274 | |
---|
| 1275 | // TODO Copy/paste code below: bad! |
---|
| 1276 | if(!empty($relations['hasMany'])) |
---|
| 1277 | { |
---|
| 1278 | foreach($relations['hasMany'] as $foreignTable) |
---|
| 1279 | { |
---|
| 1280 | $foreignName = $foreignTable->foreignName; |
---|
| 1281 | if(!empty($obj->$foreignName)) |
---|
| 1282 | { |
---|
| 1283 | $masterObj = &$uniqArr['_'.$row[0]]; |
---|
| 1284 | // Assumption: this property exists in every object since they are instances of the same class |
---|
| 1285 | if(!is_array($masterObj->$foreignName)) |
---|
| 1286 | { |
---|
| 1287 | // Pluck! |
---|
| 1288 | $foreignObj = $masterObj->$foreignName; |
---|
| 1289 | $masterObj->$foreignName = array(clone($foreignObj)); |
---|
| 1290 | } |
---|
| 1291 | else |
---|
| 1292 | { |
---|
| 1293 | // Pluck pluck! |
---|
| 1294 | $foreignObj = $obj->$foreignName; |
---|
| 1295 | array_push($masterObj->$foreignName, clone($foreignObj)); |
---|
| 1296 | } |
---|
| 1297 | } |
---|
| 1298 | } |
---|
| 1299 | } |
---|
| 1300 | if(!empty($relations['belongsTo'])) |
---|
| 1301 | { |
---|
| 1302 | foreach($relations['belongsTo'] as $foreignTable) |
---|
| 1303 | { |
---|
| 1304 | $foreignName = $foreignTable->foreignName; |
---|
| 1305 | if(!empty($obj->$foreignName)) |
---|
| 1306 | { |
---|
| 1307 | $masterObj = &$uniqArr['_'.$row[0]]; |
---|
| 1308 | // Assumption: this property exists in every object since they are instances of the same class |
---|
| 1309 | if(!is_array($masterObj->$foreignName)) |
---|
| 1310 | { |
---|
| 1311 | // Pluck! |
---|
| 1312 | $foreignObj = $masterObj->$foreignName; |
---|
| 1313 | $masterObj->$foreignName = array(clone($foreignObj)); |
---|
| 1314 | } |
---|
| 1315 | else |
---|
| 1316 | { |
---|
| 1317 | // Pluck pluck! |
---|
| 1318 | $foreignObj = $obj->$foreignName; |
---|
| 1319 | array_push($masterObj->$foreignName, clone($foreignObj)); |
---|
| 1320 | } |
---|
| 1321 | } |
---|
| 1322 | } |
---|
| 1323 | } |
---|
| 1324 | if(!$isNewObj) |
---|
| 1325 | unset($obj); // We do not need this object itself anymore and do not want it re-added to the main array |
---|
| 1326 | } |
---|
| 1327 | else if(ADODB_LAZY_AR == $extra['loading']) |
---|
| 1328 | { |
---|
| 1329 | // Lazy loading: we need to give AdoDb a hint that we have not really loaded |
---|
| 1330 | // anything, all the while keeping enough information on what we wish to load. |
---|
| 1331 | // Let's do this by keeping the relevant info in our relationship arrays |
---|
| 1332 | // but get rid of the actual properties. |
---|
| 1333 | // We will then use PHP's __get to load these properties on-demand. |
---|
| 1334 | if(!empty($relations['hasMany'])) |
---|
| 1335 | { |
---|
| 1336 | foreach($relations['hasMany'] as $foreignTable) |
---|
| 1337 | { |
---|
| 1338 | $foreignName = $foreignTable->foreignName; |
---|
| 1339 | if(!empty($obj->$foreignName)) |
---|
| 1340 | { |
---|
| 1341 | unset($obj->$foreignName); |
---|
| 1342 | } |
---|
| 1343 | } |
---|
| 1344 | } |
---|
| 1345 | if(!empty($relations['belongsTo'])) |
---|
| 1346 | { |
---|
| 1347 | foreach($relations['belongsTo'] as $foreignTable) |
---|
| 1348 | { |
---|
| 1349 | $foreignName = $foreignTable->foreignName; |
---|
| 1350 | if(!empty($obj->$foreignName)) |
---|
| 1351 | { |
---|
| 1352 | unset($obj->$foreignName); |
---|
| 1353 | } |
---|
| 1354 | } |
---|
| 1355 | } |
---|
| 1356 | } |
---|
| 1357 | } |
---|
| 1358 | |
---|
| 1359 | if(isset($obj)) |
---|
| 1360 | $arr[] = $obj; |
---|
| 1361 | } |
---|
| 1362 | |
---|
| 1363 | if(ADODB_WORK_AR == $extra['loading']) |
---|
| 1364 | { |
---|
| 1365 | // The best of both worlds? |
---|
| 1366 | // Here, the number of queries is constant: 1 + n*relationship. |
---|
| 1367 | // The second query will allow us to perform a good join |
---|
| 1368 | // while preserving LIMIT etc. |
---|
| 1369 | if(!empty($relations['hasMany'])) |
---|
| 1370 | { |
---|
| 1371 | foreach($relations['hasMany'] as $foreignTable) |
---|
| 1372 | { |
---|
| 1373 | $foreignName = $foreignTable->foreignName; |
---|
| 1374 | $className = ucfirst($foreignTable->_singularize($foreignName)); |
---|
| 1375 | $obj = new $className(); |
---|
| 1376 | $dbClassRef = $foreignTable->foreignKey; |
---|
| 1377 | $objs = $obj->packageFind($dbClassRef.' IN ('.$indices.')'); |
---|
| 1378 | foreach($objs as $obj) |
---|
| 1379 | { |
---|
| 1380 | if(!is_array($arrRef[$obj->$dbClassRef]->$foreignName)) |
---|
| 1381 | $arrRef[$obj->$dbClassRef]->$foreignName = array(); |
---|
| 1382 | array_push($arrRef[$obj->$dbClassRef]->$foreignName, $obj); |
---|
| 1383 | } |
---|
| 1384 | } |
---|
| 1385 | |
---|
| 1386 | } |
---|
| 1387 | if(!empty($relations['belongsTo'])) |
---|
| 1388 | { |
---|
| 1389 | foreach($relations['belongsTo'] as $foreignTable) |
---|
| 1390 | { |
---|
| 1391 | $foreignTableRef = $foreignTable->foreignKey; |
---|
| 1392 | if(empty($bTos[$foreignTableRef])) |
---|
| 1393 | continue; |
---|
| 1394 | if(($k = reset($foreignTable->TableInfo()->keys))) |
---|
| 1395 | { |
---|
| 1396 | $belongsToId = $k; |
---|
| 1397 | } |
---|
| 1398 | else |
---|
| 1399 | { |
---|
| 1400 | $belongsToId = 'id'; |
---|
| 1401 | } |
---|
| 1402 | $origObjsArr = $bTos[$foreignTableRef]; |
---|
| 1403 | $bTosString = implode(',', array_keys($bTos[$foreignTableRef])); |
---|
| 1404 | $foreignName = $foreignTable->foreignName; |
---|
| 1405 | $className = ucfirst($foreignTable->_singularize($foreignName)); |
---|
| 1406 | $obj = new $className(); |
---|
| 1407 | $objs = $obj->packageFind($belongsToId.' IN ('.$bTosString.')'); |
---|
| 1408 | foreach($objs as $obj) |
---|
| 1409 | { |
---|
| 1410 | foreach($origObjsArr[$obj->$belongsToId] as $idx=>$origObj) |
---|
| 1411 | { |
---|
| 1412 | $origObj->$foreignName = $obj; |
---|
| 1413 | } |
---|
| 1414 | } |
---|
| 1415 | } |
---|
| 1416 | } |
---|
| 1417 | } |
---|
| 1418 | |
---|
| 1419 | return $arr; |
---|
| 1420 | } |
---|
| 1421 | ?> |
---|