← Back to branch summary

~paul-citrusdb/citrusdb/3.x

« back to all changes in this revision

Viewing changes to include/adodb/tests/test-active-record.php

  • Committer: Paul Yasi
  • Date: 2011-05-05 18:35:24 UTC
  • Revision ID: paul@citrusdb.org-20110505183524-datljne6094fq5po
adding customer history controller, view, and methods to ticket model

Show diffs side-by-side

added added

removed removed

Lines of Context:
include/adodb/tests/test-active-record.php
1
 
<?php
2
 
 
3
 
        include_once('../adodb.inc.php');
4
 
        include_once('../adodb-active-record.inc.php');
5
 
        
6
 
        // uncomment the following if you want to test exceptions
7
 
        if (@$_GET['except']) {
8
 
                if (PHP_VERSION >= 5) {
9
 
                        include('../adodb-exceptions.inc.php');
10
 
                        echo "<h3>Exceptions included</h3>";
11
 
                }
12
 
        }
13
 
 
14
 
        $db = NewADOConnection('mysql://root@localhost/northwind?persist');
15
 
        $db->debug=1;
16
 
        ADOdb_Active_Record::SetDatabaseAdapter($db);
17
 
 
18
 
        
19
 
        $db->Execute("CREATE TEMPORARY TABLE `persons` (
20
 
                        `id` int(10) unsigned NOT NULL auto_increment,
21
 
                        `name_first` varchar(100) NOT NULL default '',
22
 
                        `name_last` varchar(100) NOT NULL default '',
23
 
                        `favorite_color` varchar(100) NOT NULL default '',
24
 
                        PRIMARY KEY  (`id`)
25
 
                    ) ENGINE=MyISAM;
26
 
                   ");
27
 
                           
28
 
        $db->Execute("CREATE TEMPORARY TABLE `children` (
29
 
                        `id` int(10) unsigned NOT NULL auto_increment,
30
 
                                        `person_id` int(10) unsigned NOT NULL,
31
 
                        `name_first` varchar(100) NOT NULL default '',
32
 
                        `name_last` varchar(100) NOT NULL default '',
33
 
                        `favorite_pet` varchar(100) NOT NULL default '',
34
 
                        PRIMARY KEY  (`id`)
35
 
                    ) ENGINE=MyISAM;
36
 
                   ");
37
 
                           
38
 
        class Person extends ADOdb_Active_Record{ function ret($v) {return $v;} }
39
 
        $person = new Person();
40
 
        ADOdb_Active_Record::$_quoteNames = '111';
41
 
        
42
 
        echo "<p>Output of getAttributeNames: ";
43
 
        var_dump($person->getAttributeNames());
44
 
        
45
 
        /**
46
 
         * Outputs the following:
47
 
         * array(4) {
48
 
         *    [0]=>
49
 
         *    string(2) "id"
50
 
         *    [1]=>
51
 
         *    string(9) "name_first"
52
 
         *    [2]=>
53
 
         *    string(8) "name_last"
54
 
         *    [3]=>
55
 
         *    string(13) "favorite_color"
56
 
         *  }
57
 
         */
58
 
        
59
 
        $person = new Person();
60
 
        $person->name_first = 'Andi';
61
 
        $person->name_last  = 'Gutmans';
62
 
        $person->save(); // this save() will fail on INSERT as favorite_color is a must fill...
63
 
        
64
 
        
65
 
        $person = new Person();
66
 
        $person->name_first     = 'Andi';
67
 
        $person->name_last      = 'Gutmans';
68
 
        $person->favorite_color = 'blue';
69
 
        $person->save(); // this save will perform an INSERT successfully
70
 
        
71
 
        echo "<p>The Insert ID generated:"; print_r($person->id);
72
 
        
73
 
        $person->favorite_color = 'red';
74
 
        $person->save(); // this save() will perform an UPDATE
75
 
        
76
 
        $person = new Person();
77
 
        $person->name_first     = 'John';
78
 
        $person->name_last      = 'Lim';
79
 
        $person->favorite_color = 'lavender';
80
 
        $person->save(); // this save will perform an INSERT successfully
81
 
        
82
 
        // load record where id=2 into a new ADOdb_Active_Record
83
 
        $person2 = new Person();
84
 
        $person2->Load('id=2');
85
 
        
86
 
        $activeArr = $db->GetActiveRecordsClass($class = "Person",$table = "Persons","id=".$db->Param(0),array(2));
87
 
        $person2 = $activeArr[0];
88
 
        echo "<p>Name (should be John): ",$person->name_first, " <br> Class (should be Person): ",get_class($person2),"<br>";   
89
 
        
90
 
        $db->Execute("insert into children (person_id,name_first,name_last) values (2,'Jill','Lim')");
91
 
        $db->Execute("insert into children (person_id,name_first,name_last) values (2,'Joan','Lim')");
92
 
        $db->Execute("insert into children (person_id,name_first,name_last) values (2,'JAMIE','Lim')");
93
 
        
94
 
        $newperson2 = new Person();
95
 
        $person2->HasMany('children','person_id');
96
 
        $person2->Load('id=2');
97
 
        $person2->name_last='green';
98
 
        $c = $person2->children;
99
 
        $person2->save();
100
 
 
101
 
        if (is_array($c) && sizeof($c) == 3 && $c[0]->name_first=='Jill' && $c[1]->name_first=='Joan'
102
 
                && $c[2]->name_first == 'JAMIE') echo "OK Loaded HasMany</br>";
103
 
        else {
104
 
                var_dump($c);
105
 
                echo "error loading hasMany should have 3 array elements Jill Joan Jamie<br>";
106
 
        }
107
 
        
108
 
        class Child extends ADOdb_Active_Record{};
109
 
        $ch = new Child('children',array('id'));
110
 
        $ch->BelongsTo('person','person_id','id');
111
 
        $ch->Load('id=1');
112
 
        if ($ch->name_first !== 'Jill') echo "error in Loading Child<br>";
113
 
        
114
 
        $p = $ch->person;
115
 
        if ($p->name_first != 'John') echo "Error loading belongsTo<br>";
116
 
        else echo "OK loading BelongTo<br>";
117
 
 
118
 
        $p->hasMany('children','person_id');
119
 
        $p->LoadRelations('children', " Name_first like 'J%' order by id",1,2);
120
 
        if (sizeof($p->children) == 2 && $p->children[1]->name_first == 'JAMIE') echo "OK LoadRelations<br>";
121
 
        else echo "error LoadRelations<br>";
122
 
        
123
 
                $db->Execute("CREATE TEMPORARY TABLE `persons2` (
124
 
                        `id` int(10) unsigned NOT NULL auto_increment,
125
 
                        `name_first` varchar(100) NOT NULL default '',
126
 
                        `name_last` varchar(100) NOT NULL default '',
127
 
                        `favorite_color` varchar(100) default '',
128
 
                        PRIMARY KEY  (`id`)
129
 
                    ) ENGINE=MyISAM;
130
 
                   ");
131
 
        
132
 
        $p = new adodb_active_record('persons2');
133
 
        $p->name_first = 'James';
134
 
        
135
 
        $p->name_last = 'James';
136
 
        
137
 
        $p->HasMany('children','person_id');
138
 
        $p->children;
139
 
        var_dump($p);
140
 
        $p->Save();
141
 
?>
 
 
b'\\ No newline at end of file'