lib/WikiDB/adodb/tests/test-active-relations.php

   1 <?php
   2
   3         include_once('../adodb.inc.php');
   4         include_once('../adodb-active-record.inc.php');
   5
   6
   7         $db = NewADOConnection('mysql://root@localhost/northwind');
   8         $db->debug=1;
   9         ADOdb_Active_Record::SetDatabaseAdapter($db);
  10
  11         $db->Execute("CREATE TEMPORARY TABLE `persons` (
  12                         `id` int(10) unsigned NOT NULL auto_increment,
  13                         `name_first` varchar(100) NOT NULL default '',
  14                         `name_last` varchar(100) NOT NULL default '',
  15                         `favorite_color` varchar(100) NOT NULL default '',
  16                         PRIMARY KEY  (`id`)
  17                     ) ENGINE=MyISAM;
  18                    ");
  19
  20         $db->Execute("CREATE TEMPORARY TABLE `children` (
  21                         `id` int(10) unsigned NOT NULL auto_increment,
  22                                         `person_id` int(10) unsigned NOT NULL,
  23                         `name_first` varchar(100) NOT NULL default '',
  24                         `name_last` varchar(100) NOT NULL default '',
  25                         `favorite_pet` varchar(100) NOT NULL default '',
  26                         PRIMARY KEY  (`id`)
  27                     ) ENGINE=MyISAM;
  28                    ");
  29
  30
  31         $db->Execute("insert into children (person_id,name_first,name_last) values (1,'Jill','Lim')");
  32         $db->Execute("insert into children (person_id,name_first,name_last) values (1,'Joan','Lim')");
  33         $db->Execute("insert into children (person_id,name_first,name_last) values (1,'JAMIE','Lim')");
  34
  35         ADODB_Active_Record::TableHasMany('persons', 'children','person_id');
  36         class person extends ADOdb_Active_Record{}
  37
  38         $person = new person();
  39 #       $person->HasMany('children','person_id');  ## this is affects all other instances of Person
  40
  41         $person->name_first     = 'John';
  42         $person->name_last      = 'Lim';
  43         $person->favorite_color = 'lavender';
  44         $person->save(); // this save will perform an INSERT successfully
  45
  46         $person2 = new person();
  47         $person2->Load('id=1');
  48
  49         $c = $person2->children;
  50         if (is_array($c) && sizeof($c) == 3 && $c[0]->name_first=='Jill' && $c[1]->name_first=='Joan'
  51                 && $c[2]->name_first == 'JAMIE') echo "OK Loaded HasMany</br>";
  52         else {
  53                 var_dump($c);
  54                 echo "error loading hasMany should have 3 array elements Jill Joan Jamie<br>";
  55         }
  56
  57         class child extends ADOdb_Active_Record{};
  58         ADODB_Active_Record::TableBelongsTo('children','person','person_id','id');
  59         $ch = new Child('children',array('id'));
  60
  61         $ch->Load('id=1');
  62         if ($ch->name_first !== 'Jill') echo "error in Loading Child<br>";
  63
  64         $p = $ch->person;
  65         if (!$p || $p->name_first != 'John') echo "Error loading belongsTo<br>";
  66         else echo "OK loading BelongTo<br>";
  67
  68         if ($p) {
  69                 #$p->HasMany('children','person_id');  ## this is affects all other instances of Person
  70                 $p->LoadRelations('children', 'order by id',1,2);
  71                 if (sizeof($p->children) == 2 && $p->children[1]->name_first == 'JAMIE') echo "OK LoadRelations<br>";
  72                 else {
  73                         var_dump($p->children);
  74                         echo "error LoadRelations<br>";
  75                 }
  76
  77                 unset($p->children);
  78                 $p->LoadRelations('children', " name_first like 'J%' order by id",1,2);
  79         }
  80         if ($p)
  81         foreach($p->children as $c) {
  82                 echo " Saving $c->name_first <br>";
  83                 $c->name_first .= ' K.';
  84                 $c->Save();
  85         }
  86
  87 ?>