Changeset 34 for trunk/phpgwapi/inc/adodb/tests/test-php5.php

Timestamp:

06/29/07 15:17:46 (17 years ago)

Author:

niltonneto

Message:

Versão nova do ADODB (4.5 para 4.95)

File:

• trunk/phpgwapi/inc/adodb/tests/test-php5.php (modified) (6 diffs)

trunk/phpgwapi/inc/adodb/tests/test-php5.php

@@ -1 +1 @@
 <?php
 /*
-  V4.51 29 July 2004  (c) 2000-2004 John Lim (jlim@natsoft.com.my). All rights reserved.
+  V4.81 3 May 2006  (c) 2000-2007 John Lim (jlim#natsoft.com.my). All rights reserved.
   Released under both BSD license and Lesser GPL library license. 
   Whenever there is any discrepancy between the two licenses, 
@@ -19 +19 @@
 try {
 
-$dbt = 'oci8po';
+$dbt = 'mysql';
 
+try {
 switch($dbt) {
 case 'oci8po':
         $db = NewADOConnection("oci8po");
+        
         $db->Connect('','scott','natsoft');
         break;
@@ -29 +31 @@
 case 'mysql':
         $db = NewADOConnection("mysql");
-        $db->Connect('localhost','root','','test');
+        $db->Connect('localhost','root','','northwind');
         break;
         
 case 'mysqli':
-        $db = NewADOConnection("mysqli://root:@localhost/test");
+        $db = NewADOConnection("mysqli://root:@localhost/northwind");
         //$db->Connect('localhost','root','','test');
         break;
+}
+} catch (exception $e){
+        echo "Connect Failed";
+        adodb_pr($e);
+        die();
 }
 
@@ -45 +52 @@
 $rs = $db->Execute($stmt,array(10,20));
 
+echo  "<hr /> Foreach Iterator Test (rand=".rand().")<hr />";
 $i = 0;
-foreach($rs as  $v) {
+foreach($rs as $v) {
         $i += 1;
-        echo "rec $i: "; adodb_pr($v); adodb_pr($rs->fields);
+        echo "rec $i: "; $s1 = adodb_pr($v,true); $s2 = adodb_pr($rs->fields,true);
+        if ($s1 != $s2 && !empty($v)) {adodb_pr($s1); adodb_pr($s2);}
+        else echo "passed<br>";
         flush();
 }
@@ -54 +64 @@
 
 if ($i != $cnt) die("actual cnt is $i, cnt should be $cnt\n");
-
+else echo "Count $i is correct<br>";
 
 $rs = $db->Execute("select bad from badder");
@@ -65 +75 @@
 
 $rs = $db->Execute("select distinct id, firstname,lastname from adoxyz order by id");
-echo "Result=\n",$rs;
+echo "Result=\n",$rs,"</p>";
+
+echo "<h3>Active Record</h3>";
+try {
+        include_once("../adodb-active-record.inc.php");
+        class City extends ADOdb_Active_Record{};
+        $a = new City();
+
+} catch(exception $e){
+        echo $e->getMessage();
+}
+
+try {
+        
+        ADOdb_Active_Record::SetDatabaseAdapter($db);
+        $a = new City();
+        
+        echo "<p>Successfully created City()<br>";
+        var_dump($a->GetPrimaryKeys());
+        $a->city = 'Kuala Lumpur';
+        $a->Save();
+        $a->Update();
+        $a->SetPrimaryKeys(array('city'));      
+        $a->country = "M'sia";
+        $a->save();
+        $a->Delete();
+} catch(exception $e){
+        echo $e->getMessage();
+}
+
+include_once("test-active-record.php");
 ?>