checkliveness.phpt 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. --TEST--
  2. PDO OCI checkliveness (code coverage)
  3. --EXTENSIONS--
  4. pdo
  5. pdo_oci
  6. --SKIPIF--
  7. <?php
  8. require __DIR__.'/../../pdo/tests/pdo_test.inc';
  9. PDOTest::skip();
  10. ?>
  11. --FILE--
  12. <?php
  13. require 'ext/pdo/tests/pdo_test.inc';
  14. $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
  15. $dsn = getenv('PDOTEST_DSN');
  16. $user = getenv('PDOTEST_USER');
  17. $pass = getenv('PDOTEST_PASS');
  18. $attr = getenv('PDOTEST_ATTR');
  19. try {
  20. $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_PERSISTENT => true));
  21. }
  22. catch (PDOException $e) {
  23. echo 'Connection failed: ' . $e->getMessage();
  24. exit;
  25. }
  26. // This triggers the call to check liveness
  27. try {
  28. $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_PERSISTENT => true));
  29. }
  30. catch (PDOException $e) {
  31. echo 'Connection failed: ' . $e->getMessage();
  32. exit;
  33. }
  34. $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  35. try {
  36. $stmt = $db->prepare('SELECT * FROM dual');
  37. $stmt->execute();
  38. $row = $stmt->fetch();
  39. var_dump($row);
  40. } catch (PDOException $e) {
  41. print $e->getMessage();
  42. }
  43. $db = null;
  44. ?>
  45. --EXPECT--
  46. array(2) {
  47. ["DUMMY"]=>
  48. string(1) "X"
  49. [0]=>
  50. string(1) "X"
  51. }