/php-src/ext/pdo_sqlite/tests/subclasses/ |
H A D | pdosqlite_006.phpt | 10 $db = MyPdoSqlite::connect('sqlite::memory:'); 11 if (!$db instanceof MyPdoSqlite) { 12 echo "Wrong class type. Should be MyPdoSqlite but is " . get_class($db) . "\n";
|
H A D | pdosqlite_load_extension_failure.phpt | 14 $db = PdoSqlite::connect('sqlite::memory:'); 15 if (!$db instanceof PdoSqlite) { 16 echo "Wrong class type. Should be PdoSqlite but is " . get_class($db) . "\n"; 21 $result = $db->loadExtension("/this/does/not_exist"); 30 $result = $db->loadExtension(__FILE__);
|
H A D | pdo_sqlite_createaggregate_trampoline.phpt | 8 $db = new PdoSqlite('sqlite::memory:'); 10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate_trampoline (a INTEGER, b INTEGER)'); 12 $stmt = $db->query('INSERT INTO test_pdo_sqlite_createaggregate_trampoline VALUES (1, -1), (2, -2),… 30 var_dump($db->createAggregate('S', [new TrampolineTest(), 'step'], [new TrampolineTest(), 'finalize… 32 foreach ($db->query('SELECT S(a), S(b) FROM test_pdo_sqlite_createaggregate_trampoline') as $row) {
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_createaggregate.phpt | 8 $db = new PDO('sqlite::memory:'); 10 $db->query('CREATE TABLE test_pdo_sqlite_createaggregate (id INT AUTO INCREMENT, name TEXT)'); 12 $db->query('INSERT INTO test_pdo_sqlite_createaggregate VALUES (NULL, "PHP"), (NULL, "PHP6")'); 14 $db->sqliteCreateAggregate('testing', function(&$a, $b) { $a .= $b; return $a; }, function(&$v) { r… 17 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createaggregate') as $row) {
|
H A D | pdo_sqlite_createcollation.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 11 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)'); 13 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10… 15 $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); }); 17 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL… 22 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
|
H A D | pdo_sqlite_createfunction_with_flags.phpt | 12 $db = new PDO('sqlite::memory:'); 14 $db->query('CREATE TABLE test_pdo_sqlite_createfunction_with_flags (id INT AUTO INCREMENT, name TEX… 16 $db->query('INSERT INTO test_pdo_sqlite_createfunction_with_flags VALUES (NULL, "PHP"), (NULL, "PHP… 19 $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); }, 1, PDO::SQLITE_DETERM… 22 foreach ($db->query('SELECT testing(name) FROM test_pdo_sqlite_createfunction_with_flags') as $row)…
|
H A D | pdo_sqlite_transaction.phpt | 8 $db = new PDO('sqlite::memory:'); 9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 11 $db->beginTransaction(); 13 $db->query('CREATE TABLE test_pdo_sqlite_transaction (id INT AUTO INCREMENT, name TEXT)'); 14 $db->commit(); 16 $db->beginTransaction(); 17 $db->query('INSERT INTO test_pdo_sqlite_transaction VALUES (NULL, "PHP"), (NULL, "PHP6")'); 18 $db->rollback(); 20 $r = $db->query('SELECT COUNT(*) FROM test_pdo_sqlite_transaction'); 23 $db->query('DROP TABLE test_pdo_sqlite_transaction');
|
/php-src/ext/pdo_odbc/tests/ |
H A D | pdoodbc_001.phpt | 15 $db = new PdoOdbc($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV']['PD… 17 $db->query("CREATE TABLE pdoodbc_001 (id INT, name TEXT)"); 18 $db->query("INSERT INTO pdoodbc_001 VALUES (NULL, 'PHP'), (NULL, 'PHP6')"); 20 foreach ($db->query('SELECT name FROM pdoodbc_001') as $row) { 29 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 30 $db->exec("DROP TABLE IF EXISTS pdoodbc_001");
|
H A D | pdoodbc_002.phpt | 15 $db = PdoOdbc::connect($config['ENV']['PDOTEST_DSN'], $config['ENV']['PDOTEST_USER'], $config['ENV'… 16 if (!$db instanceof PdoOdbc) { 17 echo "Wrong class type. Should be PdoOdbc but is " . get_class($db) . "\n"; 20 $db->exec('CREATE TABLE pdoodbc_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))'); 21 $db->exec("INSERT INTO pdoodbc_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')"); 23 foreach ($db->query('SELECT name FROM pdoodbc_002') as $row) { 32 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 33 $db->exec("DROP TABLE IF EXISTS pdoodbc_002");
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | pdopgsql_001.phpt | 17 $db = new PdoPgsql($config['ENV']['PDOTEST_DSN']); 19 $db->query('CREATE TABLE pdopgsql_001 (id INT, name TEXT)'); 20 $db->query("INSERT INTO pdopgsql_001 VALUES (NULL, 'PHP'), (NULL, 'PHP6')"); 22 foreach ($db->query('SELECT name FROM pdopgsql_001') as $row) {
|
/php-src/ext/pdo_mysql/tests/inc/ |
H A D | mysql_pdo_test.inc | 23 $db = new $classname($dsn, $user, $pass, $attr); 24 if (!$db) { 31 return $db; 42 $db->exec("DROP TABLE IF EXISTS {$table}"); 84 static function getClientVersion($db) { 88 static function getServerVersion($db) { 146 foreach ($db->query("SHOW ENGINES") as $row) { 166 $db = self::factory(); 173 $db = self::factory(); 187 $db = self::factory(); [all …]
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_interface.phpt | 13 $db = MySQLPDOTest::factory(); 33 $classname = get_class($db);
|
H A D | pdomysql_001.phpt | 15 $db = MySQLPDOTest::factory(PdoMysql::class); 17 $db->query('CREATE TABLE pdomysql_001 (id INT, name TEXT)'); 19 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP")'); 20 $db->query('INSERT INTO pdomysql_001 VALUES (NULL, "PHP6")'); 22 foreach ($db->query('SELECT name FROM pdomysql_001') as $row) { 31 $db = MySQLPDOTest::factory(); 32 $db->exec('DROP TABLE IF EXISTS pdomysql_001');
|
H A D | pdomysql_002.phpt | 15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 16 if (!$db instanceof PdoMysql) { 17 echo "Wrong class type. Should be PdoMysql but is " . get_class($db) . "\n"; 20 $db->exec('CREATE TABLE pdomysql_002(id INT NOT NULL PRIMARY KEY, name VARCHAR(10))'); 21 $db->exec("INSERT INTO pdomysql_002 VALUES(1, 'A'), (2, 'B'), (3, 'C')"); 23 foreach ($db->query('SELECT name FROM pdomysql_002') as $row) { 32 $db = MySQLPDOTest::factory(); 33 $db->query('DROP TABLE pdomysql_002');
|
H A D | pdomysql_003.phpt | 15 $db = Pdo::connect(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS); 16 if (!$db instanceof PdoMysql) { 17 echo "Wrong class type. Should be PdoMysql but is " . get_class($db) . "\n"; 20 $assertWarnings = function ($db, $q, $count) { 21 $db->query($q); 22 printf("Query %s produced %d warnings\n", $q, $db->getWarningCount()); 24 $assertWarnings($db, 'SELECT 1 = 1', 0); 25 $assertWarnings($db, 'SELECT 1 = "A"', 1);
|
/php-src/ext/pdo_dblib/tests/ |
H A D | timeout.phpt | 15 $db = getDbConnection(); 20 $db = getDbConnection(); 21 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 22 $db->setAttribute(PDO::ATTR_TIMEOUT, 1); 23 $stmt = $db->prepare($sql); 34 $db = getDbConnection(); 35 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); 36 $db->setAttribute(PDO::DBLIB_ATTR_QUERY_TIMEOUT, 1); 37 $stmt = $db->prepare($sql); 49 $stmt = $db->prepare($sql); [all …]
|
H A D | types.phpt | 14 $db = getDbConnection(); 17 global $db; 19 switch ($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION)) { 44 $stmt = $db->query($sql); 56 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 57 $stmt = $db->query($sql);
|
H A D | dbtds.phpt | 14 $db = getDbConnection(); 16 $version = $db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION);
|
H A D | dbversion.phpt | 14 $db = getDbConnection(); 16 $version = $db->getAttribute(PDO::DBLIB_ATTR_VERSION);
|
H A D | pdo_dblib_param_str_natl.phpt | 14 $db = getDbConnection(); 16 $stmt = $db->prepare('SELECT :value');
|
H A D | pdo_dblib_quote.phpt | 13 $db = getDbConnection(); 14 var_dump($db->quote(true, PDO::PARAM_BOOL)); 15 var_dump($db->quote(false, PDO::PARAM_BOOL)); 16 var_dump($db->quote(42, PDO::PARAM_INT)); 17 var_dump($db->quote(null, PDO::PARAM_NULL)); 18 var_dump($db->quote('\'', PDO::PARAM_STR)); 19 var_dump($db->quote('foo', PDO::PARAM_STR)); 20 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR)); 21 var_dump($db->quote('über', PDO::PARAM_STR | PDO::PARAM_STR_NATL)); 27 var_dump($db->quote('foo', PDO::PARAM_STR | PDO::PARAM_STR_CHAR)); [all …]
|
H A D | pdodblib_001.phpt | 14 $db = getDbConnection(PdoDblib::class); 16 $db->query("CREATE TABLE #pdo_dblib_001(name VARCHAR(32)); "); 17 $db->query("INSERT INTO #pdo_dblib_001 VALUES('PHP'), ('PHP6');"); 19 foreach ($db->query('SELECT name FROM #pdo_dblib_001') as $row) { 28 $db = getDbConnection(); 29 $db->query('DROP TABLE IF EXISTS #pdo_dblib_001');
|
H A D | pdodblib_002.phpt | 15 $db = connectToDb(); 16 if (!$db instanceof PdoDblib) { 17 echo "Wrong class type. Should be PdoDblib but is " . get_class($db) . "\n"; 20 $db->query("CREATE TABLE #pdo_dblib_002(name VARCHAR(32))"); 21 $db->query("INSERT INTO #pdo_dblib_002 VALUES('PHP'), ('PHP6')"); 23 foreach ($db->query('SELECT name FROM #pdo_dblib_002') as $row) { 32 $db = getDbConnection(); 33 $db->query('DROP TABLE IF EXISTS #pdo_dblib_002');
|
H A D | stringify_uniqueidentifier.phpt | 8 $db = getDbConnection(); 15 $db = getDbConnection(); 25 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true); 26 var_dump(true === $db->getAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER)); 27 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, false); 34 $stmt = $db->query($sql); 43 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 44 $stmt = $db->query($sql); 46 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 57 $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true); [all …]
|
H A D | batch_stmt_ins_up.phpt | 8 $db = getDbConnection(); 9 if (!driver_supports_batch_statements_without_select($db)) die('xfail test will fail with this vers… 15 $db = getDbConnection(); 16 $stmt = $db->query(
|