php-src/ext/pdo_sqlite/tests/subclasses/pdo_sqlite_getsetattr_explain.phpt

--TEST--
Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT usage
--EXTENSIONS--
pdo_sqlite
--SKIPIF--
<?php
if (PHP_OS_FAMILY === "Darwin") die("skip on darwin for now");
if (!defined('Pdo\Sqlite::EXPLAIN_MODE_EXPLAIN')) die('skip system sqlite does not support EXPLAIN mode');
?>
--FILE--
<?php

$db = new Pdo\Sqlite('sqlite::memory:');

$db->query('CREATE TABLE test_explain (a string);');
$stmt = $db->prepare('INSERT INTO test_explain VALUES ("first insert"), ("second_insert")');
$stmt->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, Pdo\Sqlite::EXPLAIN_MODE_EXPLAIN);
var_dump($stmt->getAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT) == Pdo\Sqlite::EXPLAIN_MODE_EXPLAIN);
$r = $stmt->execute();
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
$stmts = $db->prepare('SELECT * FROM test_explain');
$stmts->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, Pdo\Sqlite::EXPLAIN_MODE_EXPLAIN_QUERY_PLAN);
var_dump($stmt->getAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT) == Pdo\Sqlite::EXPLAIN_MODE_EXPLAIN_QUERY_PLAN);
$r = $stmts->execute();
var_dump($stmts->fetchAll(PDO::FETCH_ASSOC));

$stmt = $db->prepare('INSERT INTO test_explain VALUES ("first insert"), ("second_insert")');
$stmt->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, Pdo\Sqlite::EXPLAIN_MODE_PREPARED);
$stmt->execute();
$stmts->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, Pdo\Sqlite::EXPLAIN_MODE_PREPARED);
$r = $stmts->execute();
var_dump($stmts->fetchAll(PDO::FETCH_ASSOC));

class Duh {}

try {
    $stmts->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, "EXPLAIN");
} catch (\TypeError $e) {
    echo $e->getMessage(), PHP_EOL;
}

try {
    $stmts->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, new Duh());
} catch (\TypeError $e) {
    echo $e->getMessage(), PHP_EOL;
}

try {
    $stmts->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, -1);
} catch (\ValueError $e) {
    echo $e->getMessage(), PHP_EOL;
}

try {
    $stmts->setAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT, 256);
} catch (\ValueError $e) {
    echo $e->getMessage(), PHP_EOL;
}

var_dump($stmts->getAttribute(Pdo\Sqlite::ATTR_EXPLAIN_STATEMENT) == Pdo\Sqlite::EXPLAIN_MODE_PREPARED);
?>
--EXPECTF--
bool(true)
array(%d) {
  [0]=>
  array(8) {
    ["addr"]=>
    int(0)
    ["opcode"]=>
    string(4) "Init"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(%d)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [1]=>
  array(8) {
    ["addr"]=>
    int(1)
    ["opcode"]=>
    string(13) "InitCoroutine"
    ["p1"]=>
    int(3)
    ["p2"]=>
    int(%d)
    ["p3"]=>
    int(2)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  %A
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(7) "String8"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(2)
    ["p3"]=>
    int(0)
    ["p4"]=>
    string(12) "first insert"
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  %A
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(5) "Yield"
    ["p1"]=>
    int(3)
    ["p2"]=>
    int(0)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  %A
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(7) "String8"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(2)
    ["p3"]=>
    int(0)
    ["p4"]=>
    string(13) "second_insert"
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(5) "Yield"
    ["p1"]=>
    int(3)
    ["p2"]=>
    int(0)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(12) "EndCoroutine"
    ["p1"]=>
    int(3)
    ["p2"]=>
    int(0)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(9) "OpenWrite"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(2)
    ["p3"]=>
    int(0)
    ["p4"]=>
    string(1) "1"
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(5) "Yield"
    ["p1"]=>
    int(3)
    ["p2"]=>
    int(%d)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(8) "NewRowid"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(1)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(10) "MakeRecord"
    ["p1"]=>
    int(2)
    ["p2"]=>
    int(1)
    ["p3"]=>
    int(4)
    ["p4"]=>
    string(1) "C"
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(6) "Insert"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(4)
    ["p3"]=>
    int(1)
    ["p4"]=>
    string(12) "test_explain"
    ["p5"]=>
    int(57)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(4) "Goto"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(%d)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(4) "Halt"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(0)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(11) "Transaction"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(1)
    ["p3"]=>
    int(1)
    ["p4"]=>
    string(1) "0"
    ["p5"]=>
    int(1)
    ["comment"]=>
    %a
  }
  [%d]=>
  array(8) {
    ["addr"]=>
    int(%d)
    ["opcode"]=>
    string(4) "Goto"
    ["p1"]=>
    int(0)
    ["p2"]=>
    int(1)
    ["p3"]=>
    int(0)
    ["p4"]=>
    NULL
    ["p5"]=>
    int(0)
    ["comment"]=>
    %a
  }
}
bool(false)
array(1) {
  [0]=>
  array(4) {
    ["id"]=>
    int(2)
    ["parent"]=>
    int(0)
    ["notused"]=>
    int(%d)
    ["detail"]=>
    string(17) "SCAN test_explain"
  }
}
array(2) {
  [0]=>
  array(1) {
    ["a"]=>
    string(12) "first insert"
  }
  [1]=>
  array(1) {
    ["a"]=>
    string(13) "second_insert"
  }
}
explain mode must be of type int, string given
explain mode must be of type int, Duh given
explain mode must be one of the Pdo\Sqlite::EXPLAIN_MODE_* constants
explain mode must be one of the Pdo\Sqlite::EXPLAIN_MODE_* constants
bool(true)