Return to copy_to.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_pgsql / tests

Annotation of embedaddon/php/ext/pdo_pgsql/tests/copy_to.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: PDO PgSQL pgsqlCopyToArray and pgsqlCopyToFile
                      3: --SKIPIF--
                      4: <?php # vim:se ft=php:
                      5: if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
                      6: require dirname(__FILE__) . '/config.inc';
                      7: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                      8: PDOTest::skip();
                      9: ?>
                     10: --FILE--
                     11: <?php
                     12: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                     13: $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
                     14: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                     15: $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
                     16: 
                     17: $db->exec('CREATE TABLE test (a integer not null primary key, b text, c integer)');
                     18: 
                     19: $db->beginTransaction();
                     20: try {
                     21: 
                     22: echo "Preparing test table for CopyTo tests\n";
                     23: $stmt = $db->prepare("INSERT INTO test (a, b, c) values (?, ?, ?)");
                     24: 
                     25: for($i=0;$i<3;$i++) {
                     26:        $firstParameter = $i;
                     27:        $secondParameter = "test insert {$i}";
                     28:        $thirdParameter = NULL;
                     29:        $stmt->bindValue(1, $firstParameter);
                     30:        $stmt->bindValue(2, $secondParameter);
                     31:        $stmt->bindValue(3, $thirdParameter);
                     32:        $stmt->execute();
                     33: }
                     34: 
                     35: $db->commit();
                     36: 
                     37: echo "Testing pgsqlCopyToArray() with default parameters\n";
                     38: var_dump($db->pgsqlCopyToArray('test'));
                     39: echo "Testing pgsqlCopyToArray() with different field separator and not null indicator\n";
                     40: var_dump($db->pgsqlCopyToArray('test',";","NULL"));
                     41: echo "Testing pgsqlCopyToArray() with only selected fields\n";
                     42: var_dump($db->pgsqlCopyToArray('test',";","NULL",'a,c'));
                     43: 
                     44: echo "Testing pgsqlCopyToArray() with error\n";
                     45: var_dump($db->pgsqlCopyToArray('test_error'));
                     46: 
                     47: 
                     48: echo "Testing pgsqlCopyToFile() with default parameters\n";
                     49: 
                     50: $filename="test_pgsqlCopyToFile.csv";
                     51: var_dump($db->pgsqlCopyToFile('test',$filename));
                     52: echo file_get_contents($filename);
                     53: echo "Testing pgsqlCopyToFile() with different field separator and not null indicator\n";
                     54: var_dump($db->pgsqlCopyToFile('test',$filename,";","NULL"));
                     55: echo file_get_contents($filename);
                     56: echo "Testing pgsqlCopyToFile() with only selected fields\n";
                     57: var_dump($db->pgsqlCopyToFile('test',$filename,";","NULL",'a,c'));
                     58: echo file_get_contents($filename);
                     59: 
                     60: echo "Testing pgsqlCopyToFile() with error\n";
                     61: var_dump($db->pgsqlCopyToFile('test_error',$filename));
                     62: 
                     63: 
                     64: } catch (Exception $e) {
                     65:        /* catch exceptions so that we can show the relative error */
                     66:        echo "Exception! at line ", $e->getLine(), "\n";
                     67:        var_dump($e->getMessage());
                     68: }
                     69: if(isset($filename)) {
                     70:        @unlink($filename);
                     71: }
                     72: ?>
                     73: --EXPECT--
                     74: Preparing test table for CopyTo tests
                     75: Testing pgsqlCopyToArray() with default parameters
                     76: array(3) {
                     77:   [0]=>
                     78:   string(19) "0        test insert 0   \N
                     79: "
                     80:   [1]=>
                     81:   string(19) "1        test insert 1   \N
                     82: "
                     83:   [2]=>
                     84:   string(19) "2        test insert 2   \N
                     85: "
                     86: }
                     87: Testing pgsqlCopyToArray() with different field separator and not null indicator
                     88: array(3) {
                     89:   [0]=>
                     90:   string(21) "0;test insert 0;NULL
                     91: "
                     92:   [1]=>
                     93:   string(21) "1;test insert 1;NULL
                     94: "
                     95:   [2]=>
                     96:   string(21) "2;test insert 2;NULL
                     97: "
                     98: }
                     99: Testing pgsqlCopyToArray() with only selected fields
                    100: array(3) {
                    101:   [0]=>
                    102:   string(7) "0;NULL
                    103: "
                    104:   [1]=>
                    105:   string(7) "1;NULL
                    106: "
                    107:   [2]=>
                    108:   string(7) "2;NULL
                    109: "
                    110: }
                    111: Testing pgsqlCopyToArray() with error
                    112: bool(false)
                    113: Testing pgsqlCopyToFile() with default parameters
                    114: bool(true)
                    115: 0      test insert 0   \N
                    116: 1      test insert 1   \N
                    117: 2      test insert 2   \N
                    118: Testing pgsqlCopyToFile() with different field separator and not null indicator
                    119: bool(true)
                    120: 0;test insert 0;NULL
                    121: 1;test insert 1;NULL
                    122: 2;test insert 2;NULL
                    123: Testing pgsqlCopyToFile() with only selected fields
                    124: bool(true)
                    125: 0;NULL
                    126: 1;NULL
                    127: 2;NULL
                    128: Testing pgsqlCopyToFile() with error
                    129: bool(false)