library/adodb/adodb-active-recordx.inc.php

   1 <?php
   2 /*
   3
   4 @version V5.06 29 Sept 2008   (c) 2000-2011 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)>1 &&
 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 ?>