git.m6w6.name Git - m6w6/ext-pq/blob - tests/basic001.phpt

   1 --TEST--
   2 basic functionality
   3 --SKIPIF--
   4 <?php include "_skipif.inc"; ?>
   5 --FILE--
   6 <?php
   7 echo "Test\n";
   8
   9 include "_setup.inc";
  10
  11 $con = new pq\Connection(PQ_DSN);
  12 $res = $con->exec("SELECT 1 as one, 2 as two from generate_series(1,2)");
  13
  14 var_dump($res->status == pq\Result::TUPLES_OK);
  15 var_dump($res->numRows);
  16 var_dump($res->numCols);
  17
  18 foreach ($res as $rowNum => $rowData) {
  19         printf("%d.0 => %d\n", $rowNum, $rowData[0]);
  20         printf("%d.1 => %d\n", $rowNum, $rowData[1]);
  21 }
  22 $res->fetchType = pq\Result::FETCH_ASSOC;
  23 foreach ($res as $rowNum => $rowData) {
  24         printf("%d.0 => %d\n", $rowNum, $rowData["one"]);
  25         printf("%d.1 => %d\n", $rowNum, $rowData["two"]);
  26 }
  27 $res->fetchType = pq\Result::FETCH_OBJECT;
  28 foreach ($res as $rowNum => $rowData) {
  29         printf("%d.0 => %d\n", $rowNum, $rowData->one);
  30         printf("%d.1 => %d\n", $rowNum, $rowData->two);
  31 }
  32 ?>
  33 DONE
  34 --EXPECT--
  35 Test
  36 bool(true)
  37 int(2)
  38 int(2)
  39 0.0 => 1
  40 0.1 => 2
  41 1.0 => 1
  42 1.1 => 2
  43 0.0 => 1
  44 0.1 => 2
  45 1.0 => 1
  46 1.1 => 2
  47 0.0 => 1
  48 0.1 => 2
  49 1.0 => 1
  50 1.1 => 2
  51 DONE