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

   1 --TEST--
   2 fetch type
   3 --SKIPIF--
   4 <?php include "_skipif.inc"; ?>
   5 --FILE--
   6 <?php
   7 echo "Test\n";
   8
   9 include "_setup.inc";
  10
  11 $c = new pq\Connection(PQ_DSN);
  12 $r = $c->exec("SELECT a,b, NULL as c from generate_series(1,2) a, generate_series(2,4) b");
  13
  14 $r->fetchType = pq\Result::FETCH_ARRAY;
  15 foreach ($r as $k => $v) {
  16         printf("%s => %s,%s,%s\n", $k, $v[0], $v[1], $v[2]);
  17         $r->fetchType = (string) $r->fetchType;
  18 }
  19
  20 $r->fetchType = pq\Result::FETCH_ASSOC;
  21 foreach ($r as $k => $v) {
  22         printf("%s => %s,%s,%s\n", $k, $v["a"], $v["b"], $v["c"]);
  23         $r->fetchType = (string) $r->fetchType;
  24 }
  25
  26 $r->fetchType = pq\Result::FETCH_OBJECT;
  27 foreach ($r as $k => $v) {
  28         printf("%s => %s,%s,%s\n", $k, $v->a, $v->b, $v->c);
  29         $r->fetchType = (string) $r->fetchType;
  30 }
  31
  32 ?>
  33 DONE
  34 --EXPECT--
  35 Test
  36 0 => 1,2,
  37 1 => 1,3,
  38 2 => 1,4,
  39 3 => 2,2,
  40 4 => 2,3,
  41 5 => 2,4,
  42 0 => 1,2,
  43 1 => 1,3,
  44 2 => 1,4,
  45 3 => 2,2,
  46 4 => 2,3,
  47 5 => 2,4,
  48 0 => 1,2,
  49 1 => 1,3,
  50 2 => 1,4,
  51 3 => 2,2,
  52 4 => 2,3,
  53 5 => 2,4,
  54 DONE