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 var_dump(count($res) == $res->count(), $res->numRows == count($res));
  18
  19 foreach ($res as $rowNum => $rowData) {
  20         printf("%d.0 => %d\n", $rowNum, $rowData[0]);
  21         printf("%d.1 => %d\n", $rowNum, $rowData[1]);
  22 }
  23 $res->fetchType = pq\Result::FETCH_ASSOC;
  24 foreach ($res as $rowNum => $rowData) {
  25         printf("%d.0 => %d\n", $rowNum, $rowData["one"]);
  26         printf("%d.1 => %d\n", $rowNum, $rowData["two"]);
  27 }
  28 $res->fetchType = pq\Result::FETCH_OBJECT;
  29 foreach ($res as $rowNum => $rowData) {
  30         printf("%d.0 => %d\n", $rowNum, $rowData->one);
  31         printf("%d.1 => %d\n", $rowNum, $rowData->two);
  32 }
  33 ?>
  34 DONE
  35 --EXPECT--
  36 Test
  37 bool(true)
  38 int(2)
  39 int(2)
  40 bool(true)
  41 bool(true)
  42 0.0 => 1
  43 0.1 => 2
  44 1.0 => 1
  45 1.1 => 2
  46 0.0 => 1
  47 0.1 => 2
  48 1.0 => 1
  49 1.1 => 2
  50 0.0 => 1
  51 0.1 => 2
  52 1.0 => 1
  53 1.1 => 2
  54 DONE