From a66e14645c986ef58e01298b3461eeddd8dc16ac Mon Sep 17 00:00:00 2001
From: Marcus Boerger <helly@php.net>
Date: Mon, 21 Mar 2005 00:29:25 +0000
Subject: [PATCH] - Add new tests

---
 ext/pdo/tests/pdo_023.inc         | 26 +++++++++++++
 ext/pdo/tests/pdo_023_def.inc     | 52 ++++++++++++++++++++++++++
 ext/pdo_mysql/tests/pdo_023.phpt  | 61 +++++++++++++++++++++++++++++++
 ext/pdo_pgsql/tests/pdo_023.phpt  | 61 +++++++++++++++++++++++++++++++
 ext/pdo_sqlite/tests/pdo_023.phpt | 61 +++++++++++++++++++++++++++++++
 ext/sqlite/tests/pdo/pdo_023.phpt | 61 +++++++++++++++++++++++++++++++
 6 files changed, 322 insertions(+)
 create mode 100755 ext/pdo/tests/pdo_023.inc
 create mode 100755 ext/pdo/tests/pdo_023_def.inc
 create mode 100755 ext/pdo_mysql/tests/pdo_023.phpt
 create mode 100755 ext/pdo_pgsql/tests/pdo_023.phpt
 create mode 100755 ext/pdo_sqlite/tests/pdo_023.phpt
 create mode 100755 ext/sqlite/tests/pdo/pdo_023.phpt

diff --git a/ext/pdo/tests/pdo_023.inc b/ext/pdo/tests/pdo_023.inc
new file mode 100755
index 0000000000..d42ccc7438
--- /dev/null
+++ b/ext/pdo/tests/pdo_023.inc
@@ -0,0 +1,26 @@
+<?php # vim:ft=php
+
+require_once('pdo.inc');
+
+set_sql('create1', 'CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
+set_sql('insert1', 'INSERT INTO test VALUES(0, \'A\')');
+set_sql('insert2', 'INSERT INTO test VALUES(1, \'B\')');
+set_sql('select1', 'SELECT val, id FROM test');
+
+$DB->test();
+
+var_dump($DB);
+
+$DB->query($SQL['create1']);
+$DB->query($SQL['insert1']);
+$DB->query($SQL['insert2']);
+
+$stmt = $DB->query($SQL['select1']);
+
+var_dump($stmt);
+var_dump($stmt->fetchAll(PDO_FETCH_COLUMN|PDO_FETCH_UNIQUE));
+
+$stmt = NULL;
+$DB = NULL;
+
+?>
diff --git a/ext/pdo/tests/pdo_023_def.inc b/ext/pdo/tests/pdo_023_def.inc
new file mode 100755
index 0000000000..62a5d21313
--- /dev/null
+++ b/ext/pdo/tests/pdo_023_def.inc
@@ -0,0 +1,52 @@
+<?php
+
+class PDOStatementX extends PDOStatement
+{
+    public $test1 = 1;
+    
+    protected function __construct()
+    {
+    	$this->test2 = 2;
+    	$this->test2 = 22;
+    	echo __METHOD__ . "()\n";
+    }
+    
+    function __destruct()
+    {
+    	echo __METHOD__ . "()\n";
+    }
+}
+
+class PDODatabaseX extends PDO
+{
+    public $test1 = 1;
+    
+    function __construct($connect)
+    {
+    	echo __METHOD__ . "()\n";
+    	parent::__construct($connect);
+    }
+    
+    function __destruct()
+    {
+    	echo __METHOD__ . "()\n";
+    }
+    
+    function test()
+    {
+    	$this->test2 = 2;
+        var_dump($this->test1);
+        var_dump($this->test2);
+    	$this->test2 = 22;
+    }
+    
+    function query($sql)
+    {
+    	echo __METHOD__ . "()\n";
+    	$stmt = parent::prepare($sql, array(PDO_ATTR_STATEMENT_CLASS=>array('PDOStatementx')));
+    	$stmt->execute();
+    	return $stmt;
+    }
+}
+
+?>
diff --git a/ext/pdo_mysql/tests/pdo_023.phpt b/ext/pdo_mysql/tests/pdo_023.phpt
new file mode 100755
index 0000000000..50db082a3b
--- /dev/null
+++ b/ext/pdo_mysql/tests/pdo_023.phpt
@@ -0,0 +1,61 @@
+--TEST--
+PDO_MySQL: Overloading
+--SKIPIF--
+<?php # vim:ft=php
+require_once('skipif.inc'); ?>
+--FILE--
+<?php
+
+require_once('connection.inc');
+require_once('prepare.inc');
+
+require_once($PDO_TESTS . 'pdo_023_def.inc');
+
+$DB = NULL;
+
+$DB = new PDODatabaseX($CONNECTION);
+$DB->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
+
+require_once($PDO_TESTS . 'pdo_023.inc');
+
+?>
+===DONE===
+<?php exit(0); ?>
+--EXPECTF--
+PDODatabaseX::__construct()
+int(1)
+int(2)
+object(PDODatabaseX)#%d (2) {
+  ["test1"]=>
+  int(1)
+  ["test2"]=>
+  int(22)
+}
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+object(PDOStatementX)#%d (3) {
+  ["test1"]=>
+  int(1)
+  ["queryString"]=>
+  string(24) "SELECT val, id FROM test"
+  ["test2"]=>
+  int(22)
+}
+array(2) {
+  ["A"]=>
+  string(1) "0"
+  ["B"]=>
+  string(1) "1"
+}
+PDOStatementX::__destruct()
+PDODatabaseX::__destruct()
+===DONE===
diff --git a/ext/pdo_pgsql/tests/pdo_023.phpt b/ext/pdo_pgsql/tests/pdo_023.phpt
new file mode 100755
index 0000000000..df6d8ed988
--- /dev/null
+++ b/ext/pdo_pgsql/tests/pdo_023.phpt
@@ -0,0 +1,61 @@
+--TEST--
+PDO_PGSQL: Overloading
+--SKIPIF--
+<?php # vim:ft=php
+require_once('skipif.inc'); ?>
+--FILE--
+<?php
+
+require_once('connection.inc');
+require_once('prepare.inc');
+
+require_once($PDO_TESTS . 'pdo_023_def.inc');
+
+$DB = NULL;
+
+$DB = new PDODatabaseX($CONNECTION);
+$DB->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
+
+require_once($PDO_TESTS . 'pdo_023.inc');
+
+?>
+===DONE===
+<?php exit(0); ?>
+--EXPECTF--
+PDODatabaseX::__construct()
+int(1)
+int(2)
+object(PDODatabaseX)#%d (2) {
+  ["test1"]=>
+  int(1)
+  ["test2"]=>
+  int(22)
+}
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+object(PDOStatementX)#%d (3) {
+  ["test1"]=>
+  int(1)
+  ["queryString"]=>
+  string(24) "SELECT val, id FROM test"
+  ["test2"]=>
+  int(22)
+}
+array(2) {
+  ["A"]=>
+  int(0)
+  ["B"]=>
+  int(1)
+}
+PDOStatementX::__destruct()
+PDODatabaseX::__destruct()
+===DONE===
diff --git a/ext/pdo_sqlite/tests/pdo_023.phpt b/ext/pdo_sqlite/tests/pdo_023.phpt
new file mode 100755
index 0000000000..2db35289cf
--- /dev/null
+++ b/ext/pdo_sqlite/tests/pdo_023.phpt
@@ -0,0 +1,61 @@
+--TEST--
+PDO_SQLite: Overloading
+--SKIPIF--
+<?php # vim:ft=php
+require_once('skipif.inc'); ?>
+--FILE--
+<?php
+
+require_once('connection.inc');
+require_once('prepare.inc');
+
+require_once($PDO_TESTS . 'pdo_023_def.inc');
+
+$DB = NULL;
+
+$DB = new PDODatabaseX('sqlite::memory:');
+$DB->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
+
+require_once($PDO_TESTS . 'pdo_023.inc');
+
+?>
+===DONE===
+<?php exit(0); ?>
+--EXPECTF--
+PDODatabaseX::__construct()
+int(1)
+int(2)
+object(PDODatabaseX)#%d (2) {
+  ["test1"]=>
+  int(1)
+  ["test2"]=>
+  int(22)
+}
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+object(PDOStatementX)#%d (3) {
+  ["test1"]=>
+  int(1)
+  ["queryString"]=>
+  string(24) "SELECT val, id FROM test"
+  ["test2"]=>
+  int(22)
+}
+array(2) {
+  ["A"]=>
+  string(1) "0"
+  ["B"]=>
+  string(1) "1"
+}
+PDOStatementX::__destruct()
+PDODatabaseX::__destruct()
+===DONE===
diff --git a/ext/sqlite/tests/pdo/pdo_023.phpt b/ext/sqlite/tests/pdo/pdo_023.phpt
new file mode 100755
index 0000000000..1bdc853e8f
--- /dev/null
+++ b/ext/sqlite/tests/pdo/pdo_023.phpt
@@ -0,0 +1,61 @@
+--TEST--
+PDO_SQLite2: Overloading
+--SKIPIF--
+<?php # vim:ft=php
+require_once('skipif.inc'); ?>
+--FILE--
+<?php
+
+require_once('connection.inc');
+require_once('prepare.inc');
+
+require_once($PDO_TESTS . 'pdo_023_def.inc');
+
+$DB = NULL;
+
+$DB = new PDODatabaseX($CONNECTION);
+$DB->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
+
+require_once($PDO_TESTS . 'pdo_023.inc');
+
+?>
+===DONE===
+<?php exit(0); ?>
+--EXPECTF--
+PDODatabaseX::__construct()
+int(1)
+int(2)
+object(PDODatabaseX)#%d (2) {
+  ["test1"]=>
+  int(1)
+  ["test2"]=>
+  int(22)
+}
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+PDOStatementX::__destruct()
+PDODatabaseX::query()
+PDOStatementX::__construct()
+object(PDOStatementX)#%d (3) {
+  ["test1"]=>
+  int(1)
+  ["queryString"]=>
+  string(24) "SELECT val, id FROM test"
+  ["test2"]=>
+  int(22)
+}
+array(2) {
+  ["A"]=>
+  string(1) "0"
+  ["B"]=>
+  string(1) "1"
+}
+PDOStatementX::__destruct()
+PDODatabaseX::__destruct()
+===DONE===
-- 
2.40.0