Return to bug62479.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_pgsql/tests/bug62479.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO PgSQL Bug #62479 (PDO-psql cannot connect if password contains spaces)
        !             3: --SKIPIF--
        !             4: <?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: if (!isset($conf['ENV']['PDOTEST_DSN'])) die('no dsn found in env');
        !            10: $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
        !            11: $rand = rand(5, 5);
        !            12: 
        !            13: // Assume that if we can't create a user, this test needs to be skipped
        !            14: $testQuery = "CREATE USER pdo_$rand WITH PASSWORD 'testpass'";
        !            15: $db->query($testQuery);
        !            16: $testQuery = "DROP USER pdo_$rand";
        !            17: $db->query($testQuery);
        !            18: ?>
        !            19: --FILE--
        !            20: <?php
        !            21: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
        !            22: $pdo = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
        !            23: $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
        !            24: $rand = rand(5, 400);
        !            25: $user = "pdo_$rand";
        !            26: $template = "CREATE USER $user WITH PASSWORD '%s'";
        !            27: $dropUser = "DROP USER $user";
        !            28: $testQuery = 'SELECT 1 as verification';
        !            29: 
        !            30: // Create temp user with space in password
        !            31: $sql = sprintf($template, 'my password');
        !            32: $pdo->query($sql);
        !            33: $testConn = new PDO($conf['ENV']['PDOTEST_DSN'], $user, "my password");
        !            34: $result = $testConn->query($testQuery)->fetch();
        !            35: $check = $result[0];
        !            36: var_dump($check);
        !            37: 
        !            38: // Remove the user
        !            39: $pdo->query($dropUser);
        !            40: 
        !            41: // Create a user with a space and single quote
        !            42: $sql = sprintf($template, "my pass''word");
        !            43: $pdo->query($sql);
        !            44: 
        !            45: $testConn = new PDO($conf['ENV']['PDOTEST_DSN'], $user, "my pass'word");
        !            46: $result = $testConn->query($testQuery)->fetch();
        !            47: $check = $result[0];
        !            48: var_dump($check);
        !            49: 
        !            50: // Remove the user
        !            51: $pdo->query($dropUser);
        !            52: ?>
        !            53: --EXPECT--
        !            54: int(1)
        !            55: int(1)
        !            56: