Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
LibTest.php	3.37 KB	-rw-r--r--	2023-01-22 09:53
benchmark.php	2.41 KB	-rw-r--r--	2023-01-22 09:53
pdo.php	2.4 KB	-rw-r--r--	2023-01-22 09:53
test-active-record.php	5.23 KB	-rw-r--r--	2023-01-22 09:53
test-active-recs2.php	2.12 KB	-rw-r--r--	2023-01-22 09:53
test-active-relations.php	3.67 KB	-rw-r--r--	2023-01-22 09:53
test-active-relationsx.php	25.16 KB	-rw-r--r--	2023-01-22 09:53
test-datadict.php	7.84 KB	-rw-r--r--	2023-01-22 09:53
test-perf.php	1.58 KB	-rw-r--r--	2023-01-22 09:53
test-pgblob.php	2.69 KB	-rw-r--r--	2023-01-22 09:53
test-php5.php	2.91 KB	-rw-r--r--	2023-01-22 09:53
test-xmlschema.php	1.96 KB	-rw-r--r--	2023-01-22 09:53
test.php	54.87 KB	-rw-r--r--	2023-01-22 09:53
test2.php	1.26 KB	-rw-r--r--	2023-01-22 09:53
test3.php	1.3 KB	-rw-r--r--	2023-01-22 09:53
test4.php	4.84 KB	-rw-r--r--	2023-01-22 09:53
test5.php	1.7 KB	-rw-r--r--	2023-01-22 09:53
test_mssqlnative.php	5.33 KB	-rw-r--r--	2023-01-22 09:53
test_rs_array.php	1.37 KB	-rw-r--r--	2023-01-22 09:53
testcache.php	1.14 KB	-rw-r--r--	2023-01-22 09:53
testdatabases.inc.php	17.55 KB	-rw-r--r--	2023-01-22 09:53
testgenid.php	1.41 KB	-rw-r--r--	2023-01-22 09:53
testmssql.php	2.3 KB	-rw-r--r--	2023-01-22 09:53
testoci8.php	2.67 KB	-rw-r--r--	2023-01-22 09:53
testoci8cursor.php	3.21 KB	-rw-r--r--	2023-01-22 09:53
testpaging.php	2.62 KB	-rw-r--r--	2023-01-22 09:53
testpear.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
testsessions.php	2.83 KB	-rw-r--r--	2023-01-22 09:53
time.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
tmssql.php	2.54 KB	-rw-r--r--	2023-01-22 09:53
xmlschema-mssql.xml	832 B	-rw-r--r--	2023-01-22 09:53
xmlschema.xml	961 B	-rw-r--r--	2023-01-22 09:53

Rename

<?php
/**
 * ADOdb tests.
 *
 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
 *
 * @package ADOdb
 * @link https://adodb.org Project's web site and documentation
 * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
 *
 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
 * any later version. This means you can use it in proprietary products.
 * See the LICENSE.md file distributed with this source code for details.
 * @license BSD-3-Clause
 * @license LGPL-2.1-or-later
 *
 * @copyright 2000-2013 John Lim
 * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
 */

include_once('../adodb.inc.php');
	include_once('../adodb-active-record.inc.php');

$db = NewADOConnection('mysql://root@localhost/northwind');
	$db->debug=1;
	ADOdb_Active_Record::SetDatabaseAdapter($db);

$db->Execute("CREATE TEMPORARY TABLE `persons` (
	                `id` int(10) unsigned NOT NULL auto_increment,
	                `name_first` varchar(100) NOT NULL default '',
	                `name_last` varchar(100) NOT NULL default '',
	                `favorite_color` varchar(100) NOT NULL default '',
	                PRIMARY KEY  (`id`)
	            ) ENGINE=MyISAM;
	           ");

$db->Execute("CREATE TEMPORARY TABLE `children` (
	                `id` int(10) unsigned NOT NULL auto_increment,
					`person_id` int(10) unsigned NOT NULL,
	                `name_first` varchar(100) NOT NULL default '',
	                `name_last` varchar(100) NOT NULL default '',
	                `favorite_pet` varchar(100) NOT NULL default '',
	                PRIMARY KEY  (`id`)
	            ) ENGINE=MyISAM;
	           ");

$db->Execute("insert into children (person_id,name_first,name_last) values (1,'Jill','Lim')");
	$db->Execute("insert into children (person_id,name_first,name_last) values (1,'Joan','Lim')");
	$db->Execute("insert into children (person_id,name_first,name_last) values (1,'JAMIE','Lim')");

ADODB_Active_Record::TableHasMany('persons', 'children','person_id');
	class person extends ADOdb_Active_Record{}

$person = new person();
#	$person->HasMany('children','person_id');  ## this is affects all other instances of Person

$person->name_first     = 'John';
	$person->name_last      = 'Lim';
	$person->favorite_color = 'lavender';
	$person->save(); // this save will perform an INSERT successfully

$person2 = new person();
	$person2->Load('id=1');

$c = $person2->children;
	if (is_array($c) && sizeof($c) == 3 && $c[0]->name_first=='Jill' && $c[1]->name_first=='Joan'
		&& $c[2]->name_first == 'JAMIE') echo "OK Loaded HasMany";
	else {
		var_dump($c);
		echo "error loading hasMany should have 3 array elements Jill Joan Jamie ";
	}

class child extends ADOdb_Active_Record{};
	ADODB_Active_Record::TableBelongsTo('children','person','person_id','id');
	$ch = new Child('children',array('id'));

$ch->Load('id=1');
	if ($ch->name_first !== 'Jill') echo "error in Loading Child ";

$p = $ch->person;
	if (!$p || $p->name_first != 'John') echo "Error loading belongsTo ";
	else echo "OK loading BelongTo ";

if ($p) {
		#$p->HasMany('children','person_id'); ## this is affects all other instances of Person
		$p->LoadRelations('children', 'order by id',1,2);
		if (sizeof($p->children) == 2 && $p->children[1]->name_first == 'JAMIE') echo "OK LoadRelations ";
		else {
		 	var_dump($p->children);
			echo "error LoadRelations ";
		}

unset($p->children);
		$p->LoadRelations('children', " name_first like 'J%' order by id",1,2);
	}
	if ($p)
	foreach($p->children as $c) {
		echo " Saving $c->name_first ";
		$c->name_first .= ' K.';
		$c->Save();
	}