[PHP-CVS] cvs: php-src /ext/sqlite/tests/pdo pdo_023.phpt pecl/pdo/tests pdo_023.inc pdo_023_def.inc pecl/pdo_mysql/tests pdo_023.phpt pecl/pdo_pgsql/tests pdo_023.phpt pecl/pdo_sqlite/tests pdo_023.phpt

[Marcus Boerger]

helly           Sun Mar 20 19:29:25 2005 EDT

  Added files:                 
    /pecl/pdo/tests     pdo_023.inc pdo_023_def.inc 
    /pecl/pdo_mysql/tests       pdo_023.phpt 
    /pecl/pdo_pgsql/tests       pdo_023.phpt 
    /pecl/pdo_sqlite/tests      pdo_023.phpt 
    /php-src/ext/sqlite/tests/pdo       pdo_023.phpt 
  Log:
  - Add new tests
  

http://cvs.php.net/co.php/pecl/pdo/tests/pdo_023.inc?r=1.1&p=1
Index: pecl/pdo/tests/pdo_023.inc
+++ pecl/pdo/tests/pdo_023.inc
<?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;

?>

http://cvs.php.net/co.php/pecl/pdo/tests/pdo_023_def.inc?r=1.1&p=1
Index: pecl/pdo/tests/pdo_023_def.inc
+++ pecl/pdo/tests/pdo_023_def.inc
<?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;
    }
}

?>

http://cvs.php.net/co.php/pecl/pdo_mysql/tests/pdo_023.phpt?r=1.1&p=1
Index: pecl/pdo_mysql/tests/pdo_023.phpt
+++ pecl/pdo_mysql/tests/pdo_023.phpt
--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===

http://cvs.php.net/co.php/pecl/pdo_pgsql/tests/pdo_023.phpt?r=1.1&p=1
Index: pecl/pdo_pgsql/tests/pdo_023.phpt
+++ pecl/pdo_pgsql/tests/pdo_023.phpt
--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===

http://cvs.php.net/co.php/pecl/pdo_sqlite/tests/pdo_023.phpt?r=1.1&p=1
Index: pecl/pdo_sqlite/tests/pdo_023.phpt
+++ pecl/pdo_sqlite/tests/pdo_023.phpt
--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===

http://cvs.php.net/co.php/php-src/ext/sqlite/tests/pdo/pdo_023.phpt?r=1.1&p=1
Index: php-src/ext/sqlite/tests/pdo/pdo_023.phpt
+++ php-src/ext/sqlite/tests/pdo/pdo_023.phpt
--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===

-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php