1 | <?php |
---|
2 | |
---|
3 | function getmicrotime() |
---|
4 | { |
---|
5 | $t = microtime(); |
---|
6 | $t = explode(' ',$t); |
---|
7 | return (float)$t[1]+ (float)$t[0]; |
---|
8 | } |
---|
9 | |
---|
10 | function doloop() |
---|
11 | { |
---|
12 | global $db,$MAX; |
---|
13 | |
---|
14 | $sql = "select id,firstname,lastname from adoxyz where |
---|
15 | firstname not like ? and lastname not like ? and id=?"; |
---|
16 | $offset = 0; |
---|
17 | /*$sql = "select * from juris9.employee join juris9.emp_perf_plan on epp_empkey = emp_id |
---|
18 | where emp_name not like ? and emp_name not like ? and emp_id=28000+?"; |
---|
19 | $offset = 28000;*/ |
---|
20 | for ($i=1; $i <= $MAX; $i++) { |
---|
21 | $db->Param(false); |
---|
22 | $x = (rand() % 10) + 1; |
---|
23 | $db->debug= ($i==1); |
---|
24 | $id = $db->GetOne($sql, |
---|
25 | array('Z%','Z%',$x)); |
---|
26 | if($id != $offset+$x) { |
---|
27 | print "<p>Error at $x"; |
---|
28 | break; |
---|
29 | } |
---|
30 | } |
---|
31 | } |
---|
32 | |
---|
33 | include_once('../adodb.inc.php'); |
---|
34 | $db = NewADOConnection('postgres7'); |
---|
35 | $db->PConnect('localhost','tester','test','test') || die("failed connection"); |
---|
36 | |
---|
37 | $enc = "GIF89a%01%00%01%00%80%FF%00%C0%C0%C0%00%00%00%21%F9%04%01%00%00%00%00%2C%00%00%00%00%01%00%01%00%00%01%012%00%3Bt_clear.gif%0D"; |
---|
38 | $val = rawurldecode($enc); |
---|
39 | |
---|
40 | $MAX = 1000; |
---|
41 | |
---|
42 | adodb_pr($db->ServerInfo()); |
---|
43 | |
---|
44 | echo "<h4>Testing PREPARE/EXECUTE PLAN</h4>"; |
---|
45 | |
---|
46 | |
---|
47 | $db->_bindInputArray = true; // requires postgresql 7.3+ and ability to modify database |
---|
48 | $t = getmicrotime(); |
---|
49 | doloop(); |
---|
50 | echo '<p>',$MAX,' times, with plan=',getmicrotime() - $t,'</p>'; |
---|
51 | |
---|
52 | |
---|
53 | $db->_bindInputArray = false; |
---|
54 | $t = getmicrotime(); |
---|
55 | doloop(); |
---|
56 | echo '<p>',$MAX,' times, no plan=',getmicrotime() - $t,'</p>'; |
---|
57 | |
---|
58 | |
---|
59 | |
---|
60 | echo "<h4>Testing UPDATEBLOB</h4>"; |
---|
61 | $db->debug=1; |
---|
62 | |
---|
63 | ### TEST BEGINS |
---|
64 | |
---|
65 | $db->Execute("insert into photos (id,name) values(9999,'dot.gif')"); |
---|
66 | $db->UpdateBlob('photos','photo',$val,'id=9999'); |
---|
67 | $v = $db->GetOne('select photo from photos where id=9999'); |
---|
68 | |
---|
69 | |
---|
70 | ### CLEANUP |
---|
71 | |
---|
72 | $db->Execute("delete from photos where id=9999"); |
---|
73 | |
---|
74 | ### VALIDATION |
---|
75 | |
---|
76 | if ($v !== $val) echo "<b>*** ERROR: Inserted value does not match downloaded val<b>"; |
---|
77 | else echo "<b>*** OK: Passed</b>"; |
---|
78 | |
---|
79 | echo "<pre>"; |
---|
80 | echo "INSERTED: ", $enc; |
---|
81 | echo "<hr />"; |
---|
82 | echo"RETURNED: ", rawurlencode($v); |
---|
83 | echo "<hr /><p>"; |
---|
84 | echo "INSERTED: ", $val; |
---|
85 | echo "<hr />"; |
---|
86 | echo "RETURNED: ", $v; |
---|
87 | |
---|
88 | ?> |
---|