diff options
| author | Damien Regad <dregad@mantisbt.org> | 2013-08-05 13:56:24 +0200 |
|---|---|---|
| committer | Damien Regad <dregad@mantisbt.org> | 2013-08-05 13:56:24 +0200 |
| commit | 53010b5ceb548968e93c752defec085e7c508f4a (patch) | |
| tree | 332484926a4f961b6a12ca522f437e25bcace741 /tests/client.php | |
| parent | 212c76c103997ef3aeb539517899ed42ddffdae4 (diff) | |
| download | adodb-53010b5ceb548968e93c752defec085e7c508f4a.tar.gz adodb-53010b5ceb548968e93c752defec085e7c508f4a.tar.bz2 adodb-53010b5ceb548968e93c752defec085e7c508f4a.zip | |
Reorg: ADOdb5 (master) branch
- Move all files in adodb5/ to root
- Remove adodb-for-php4/ directory
Diffstat (limited to 'tests/client.php')
| -rw-r--r-- | tests/client.php | 198 |
1 files changed, 198 insertions, 0 deletions
diff --git a/tests/client.php b/tests/client.php new file mode 100644 index 00000000..b5215901 --- /dev/null +++ b/tests/client.php @@ -0,0 +1,198 @@ +<html> +<body bgcolor=white> +<?php +/** + * V4.50 6 July 2004 (c) 2001-2002 John Lim (jlim#natsoft.com). 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 + + echo PHP_VERSION,'<br>'; + var_dump(parse_url('odbc_mssql://userserver/')); + die(); + +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] + . + . + . +*/ +?> |