[Sommaire] [Imprimer]

   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  ?>