| index : flyspray | |
| Archlinux32 customized Flyspray installation | gitolite user |
| summaryrefslogtreecommitdiff |
| -rw-r--r-- | vendor/adodb/adodb-php/tests/client.php | 199 |
diff --git a/vendor/adodb/adodb-php/tests/client.php b/vendor/adodb/adodb-php/tests/client.php new file mode 100644 index 0000000..3e63a31 --- /dev/null +++ b/vendor/adodb/adodb-php/tests/client.php @@ -0,0 +1,199 @@ +<html> +<body bgcolor=white> +<?php +/** + * @version v5.20.14 06-Jan-2019 + * @copyright (c) 2001-2013 John Lim (jlim#natsoft.com). All rights reserved. + * @copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community + * 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://adodb.org/dokuwiki/doku.php?id=v5:proxy:proxy_index + + 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] + . + . + . +*/ |