phpgroupware-cvs
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] phpgwapi/inc/adodb/tests/client.php, 1.2

From: nomail
Subject: [Phpgroupware-cvs] phpgwapi/inc/adodb/tests/client.php, 1.2
Date: Thu, 30 Dec 2004 07:47:33 +0100 
Update of /phpgwapi/inc/adodb/tests
Added Files:
        Branch: 
          client.php

date: 2004/12/30 06:47:33;  author: skwashd;  state: Exp;  lines: +194 -0

Log Message:
new HEAD
=====================================================================
<html>
<body bgcolor=white>
<?php
/** 
 * V4.50 6 July 2004  (c) 2001-2002 John Lim (address@hidden). All rights 
reserved.
 * Released under both BSD license and Lesser GPL library license. 
  Whenever there is any discrepancy between the two licenses, 
  the BSD license will take precedence. 
 * 
 * set tabs to 8
 */
 
 // documentation on usage is at http://php.weblogs.com/adodb_csv
 
include('../adodb.inc.php');
include('../tohtml.inc.php');

 function &send2server($url,$sql)
 {
        $url .= '?sql='.urlencode($sql);
        print "<p>$url</p>";
        $rs = csv2rs($url,$err);
        if ($err) print $err;
        return $rs;
 }
 
 function print_pre($s)
 {
        print "<pre>";print_r($s);print "</pre>";
 }


$serverURL = 'http://localhost/php/phplens/adodb/server.php';
$testhttp = false;

$sql1 = "insertz into products (productname) values ('testprod 1')";
$sql2 = "insert into products (productname) values ('testprod 1')";
$sql3 = "insert into products (productname) values ('testprod 2')";
$sql4 = "delete from products where productid>80";
$sql5 = 'select * from products';
        
if ($testhttp) {
        print "<a href=#c>Client Driver Tests</a><p>";
        print "<h3>Test Error</h3>";
        $rs = send2server($serverURL,$sql1);
        print_pre($rs);
        print "<hr>";
        
        print "<h3>Test Insert</h3>";
        
        $rs = send2server($serverURL,$sql2);
        print_pre($rs);
        print "<hr>";
        
        print "<h3>Test Insert2</h3>";
        
        $rs = send2server($serverURL,$sql3);
        print_pre($rs);
        print "<hr>";
        
        print "<h3>Test Delete</h3>";
        
        $rs = send2server($serverURL,$sql4);
        print_pre($rs);
        print "<hr>";
        
        
        print "<h3>Test Select</h3>";
        $rs = send2server($serverURL,$sql5);
        if ($rs) rs2html($rs);
        
        print "<hr>";
}


print "<a name=c><h1>CLIENT Driver Tests</h1>";
$conn = ADONewConnection('csv');
$conn->Connect($serverURL);
$conn->debug = true;

print "<h3>Bad SQL</h3>";

$rs = $conn->Execute($sql1);

print "<h3>Insert SQL 1</h3>";
$rs = $conn->Execute($sql2);

print "<h3>Insert SQL 2</h3>";
$rs = $conn->Execute($sql3);

print "<h3>Select SQL</h3>";
$rs = $conn->Execute($sql5);
if ($rs) rs2html($rs);

print "<h3>Delete SQL</h3>";
$rs = $conn->Execute($sql4);

print "<h3>Select SQL</h3>";
$rs = $conn->Execute($sql5);
if ($rs) rs2html($rs);


/* EXPECTED RESULTS FOR HTTP TEST:

Test Insert
http://localhost/php/adodb/server.php?sql=insert+into+products+%28productname%29+values+%28%27testprod%27%29

adorecordset Object
(
        [dataProvider] => native
        [fields] => 
        [blobSize] => 64
        [canSeek] => 
        [EOF] => 1
        [emptyTimeStamp] =>  
        [emptyDate] =>  
        [debug] => 
        [timeToLive] => 0
        [bind] => 
        [_numOfRows] => -1
        [_numOfFields] => 0
        [_queryID] => 1
        [_currentRow] => -1
        [_closed] => 
        [_inited] => 
        [sql] => insert into products (productname) values ('testprod')
        [affectedrows] => 1
        [insertid] => 81
)


--------------------------------------------------------------------------------

Test Insert2
http://localhost/php/adodb/server.php?sql=insert+into+products+%28productname%29+values+%28%27testprod%27%29

adorecordset Object
(
        [dataProvider] => native
        [fields] => 
        [blobSize] => 64
        [canSeek] => 
        [EOF] => 1
        [emptyTimeStamp] =>  
        [emptyDate] =>  
        [debug] => 
        [timeToLive] => 0
        [bind] => 
        [_numOfRows] => -1
        [_numOfFields] => 0
        [_queryID] => 1
        [_currentRow] => -1
        [_closed] => 
        [_inited] => 
        [sql] => insert into products (productname) values ('testprod')
        [affectedrows] => 1
        [insertid] => 82
)


--------------------------------------------------------------------------------

Test Delete
http://localhost/php/adodb/server.php?sql=delete+from+products+where+productid%3E80

adorecordset Object
(
        [dataProvider] => native
        [fields] => 
        [blobSize] => 64
        [canSeek] => 
        [EOF] => 1
        [emptyTimeStamp] =>  
        [emptyDate] =>  
        [debug] => 
        [timeToLive] => 0
        [bind] => 
        [_numOfRows] => -1
        [_numOfFields] => 0
        [_queryID] => 1
        [_currentRow] => -1
        [_closed] => 
        [_inited] => 
        [sql] => delete from products where productid>80
        [affectedrows] => 2
        [insertid] => 0
)

[more stuff deleted]
 .
 . 
 .
*/
?>
reply via email to
[Prev in Thread] Current Thread [Next in Thread]