/PHP-7.4/ext/sqlite3/tests/ |
H A D | sqlite3_31_open.phpt | 12 $db = new SQLite3(__DIR__ . '/db1.db'); 13 $db->open(__DIR__ . '/db1.db'); 20 <?php @unlink(__DIR__ . '/db1.db'); ?>
|
H A D | sqlite3_enable_exceptions.phpt | 11 $db = new SQLite3(':memory:'); 12 var_dump($db->enableExceptions(true)); 14 $db->query("SELECT * FROM non_existent_table"); 18 var_dump($db->enableExceptions(false)); 19 $db->query("SELECT * FROM non_existent_table"); 20 var_dump($db->enableExceptions("wrong_type","wrong_type")); 22 var_dump($db->close());
|
H A D | sqlite3_busyTimeout.phpt | 10 var_dump($db->busyTimeout(0)); 11 var_dump($db->busyTimeout(null)); 12 var_dump($db->busyTimeout(-1000)); 13 var_dump($db->busyTimeout(1000)); 14 $db->close();
|
H A D | sqlite3_37_createfunction_flags.phpt | 14 var_dump($db->createfunction($func, $func, 1, SQLITE3_DETERMINISTIC)); 15 var_dump($db->querySingle('SELECT strtoupper("test")')); 18 var_dump($db->createfunction($func2, $func2, 1, SQLITE3_DETERMINISTIC)); 19 var_dump($db->querySingle('SELECT strtolower("TEST")')); 21 var_dump($db->createfunction($func, $func2, 1, SQLITE3_DETERMINISTIC)); 22 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
|
H A D | sqlite3_defensive.phpt | 16 $db = new SQLite3(':memory:'); 17 var_dump($db->exec('CREATE TABLE test (a, b);')); 20 var_dump($db->exec('PRAGMA writable_schema = ON;')); 21 var_dump($db->querySingle('PRAGMA writable_schema;')); 24 var_dump($db->querySingle('SELECT COUNT(*) FROM sqlite_master;')); 27 var_dump($db->querySingle('DELETE FROM sqlite_master;')); 30 var_dump($db->querySingle('SELECT COUNT(*) FROM sqlite_master;'));
|
H A D | sqlite3_33_reset.phpt | 11 $db = new SQLite3(':memory:'); 13 $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); 14 $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); 16 $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); 21 //var_dump($db); 22 //var_dump($db->close());
|
/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_closecursor.phpt | 8 $db = MySQLPDOTest::factory(); 14 $db = MySQLPDOTest::factory(); 117 MySQLPDOTest::createTestTable($db); 118 pdo_mysql_stmt_closecursor($db); 122 MySQLPDOTest::createTestTable($db); 123 pdo_mysql_stmt_closecursor($db); 131 MySQLPDOTest::createTestTable($db); 133 pdo_mysql_stmt_closecursor($db); 138 pdo_mysql_stmt_closecursor($db); 142 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); [all …]
|
H A D | pdo_mysql_attr_oracle_nulls.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 16 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp)) 20 if (false !== @$db->setAttribute(PDO::ATTR_ORACLE_NULLS, $tmp)); 26 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 30 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 0); 34 $db->setAttribute(PDO::ATTR_ORACLE_NULLS, 1); 35 $stmt = $db->query('SELECT VERSION() as _version'); 42 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 48 $stmt = $db->prepare('CALL p()'); [all …]
|
H A D | pdo_mysql_prepare_native_clear_error.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 17 $db->exec('DROP TABLE IF EXISTS test'); 21 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 22 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 26 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')"); 44 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 45 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 66 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 74 $db = MySQLPDOTest::factory(); [all …]
|
H A D | table.inc | 2 if (!$db) { 4 $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); 6 // $db->exec('DROP TABLE IF EXISTS test'); 7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
|
H A D | pdo_mysql_attr_fetch_table_names.phpt | 12 $db = MySQLPDOTest::factory(); 13 MySQLPDOTest::createTestTable($db); 15 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 1); 16 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 20 $db->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, 0); 21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
|
H A D | mysql_pdo_test.inc | 24 $db = new $classname($dsn, $user, $pass, $attr); 25 if (!$db) { 32 return $db; 39 $db->exec('DROP TABLE IF EXISTS test'); 82 static function getClientVersion($db) { 86 static function getServerVersion($db) { 151 foreach ($db->query("SHOW ENGINES") as $row) { 169 static function dropTestTable($db = NULL) { 170 if (is_null($db)) 171 $db = self::factory(); [all …]
|
H A D | pdo_mysql_stmt_blobs.phpt | 12 $db = MySQLPDOTest::factory(); 25 function test_blob($db, $offset, $sql_type, $test_len) { 27 $db->exec('DROP TABLE IF EXISTS test'); 40 $stmt = $db->query('SELECT id, label FROM test'); 63 $stmt = $db->query('SELECT id, label FROM test'); 83 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1); 84 test_blob($db, ++$offset, $sql_type, $test_len); 85 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0); 86 test_blob($db, ++$offset, $sql_type, $test_len); 94 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_prepare_emulated_placeholder_everywhere.phpt | 13 $db = MySQLPDOTest::factory(); 17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0); 18 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 21 $db->exec('DROP TABLE IF EXISTS test'); 27 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 38 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1); 39 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY)) 42 $stmt = $db->prepare('SELECT ? FROM test WHERE ? > ?'); 52 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo())); 60 $db = MySQLPDOTest::factory(); [all …]
|
H A D | pdo_mysql_attr_server_info.phpt | 8 $db = MySQLPDOTest::factory(); 13 $db = MySQLPDOTest::factory(); 15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode())); 17 $info = $db->getAttribute(PDO::ATTR_SERVER_INFO); 22 if (false !== $db->setAttribute(PDO::ATTR_SERVER_INFO, 'new uptime: 0s')) 25 $new_info = $db->getAttribute(PDO::ATTR_SERVER_INFO); 30 if (!$stmt = $db->query("SHOW STATUS LIKE '%uptime%'")) 31 printf("[004] Cannot run SHOW STATUS, [%s]\n", $db->errorCode()); 34 printf("[005] Unable to fetch uptime, [%s]\n", $db->errorCode());
|
/PHP-7.4/ext/pdo/tests/ |
H A D | bug_34630.phpt | 15 $db = PDOTest::factory(); 17 $driver = $db->getAttribute(PDO::ATTR_DRIVER_NAME); 21 $db->exec('CREATE TABLE test (id int NOT NULL PRIMARY KEY, val BLOB)'); 23 $db->exec('CREATE TABLE test (id int NOT NULL PRIMARY KEY, val VARCHAR(256))'); 25 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 35 $db->beginTransaction(); 36 …$insert = $db->prepare("insert into test (id, val) values (1, EMPTY_BLOB()) RETURNING val INTO :bl… 38 $insert = $db->prepare("insert into test (id, val) values (1, :blob)"); 44 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 45 var_dump($db->query("SELECT * from test")->fetchAll(PDO::FETCH_ASSOC));
|
H A D | pdo_032.phpt | 15 $db = PDOTest::factory(); 17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES(1, 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C')"); 23 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER); 24 $stmt = $db->prepare('SELECT * from test'); 30 $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER); 31 $stmt = $db->prepare('SELECT * from test');
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | bug_49985.phpt | 13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->exec("CREATE TABLE test (a int PRIMARY KEY)"); 20 $db->beginTransaction(); 21 $stmt = $db->prepare("INSERT INTO test (a) VALUES (?)"); 23 $db->commit(); 26 $db->rollback();
|
/PHP-7.4/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_createfunction_with_flags.phpt | 11 $db = new PDO('sqlite::memory:'); 13 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)'); 15 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")'); 16 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")'); 19 $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); }, 1, PDO::SQLITE_DETERM… 22 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) { 26 $db->query('DROP TABLE foobar');
|
H A D | pdo_fetch_func_001.phpt | 10 $db = new PDO('sqlite::memory:'); 15 $st = $db->query('SELECT * FROM testing'); 18 $st = $db->query('SELECT name FROM testing'); 21 $st = $db->query('SELECT * FROM testing'); 24 $st = $db->query('SELECT * FROM testing'); 27 $st = $db->query('SELECT * FROM testing'); 30 $st = $db->query('SELECT * FROM testing'); 33 $st = $db->query('SELECT * FROM testing'); 42 public function __construct($db) { 60 new bar($db); [all …]
|
/PHP-7.4/ext/pdo_oci/tests/ |
H A D | bug46274.phpt | 13 $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt'); 14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 19 $db->exec("DROP TABLE test_one_blob"); 23 $db->beginTransaction(); 25 $db->query('CREATE TABLE test_one_blob (id INT NOT NULL, blob1 BLOB)'); 27 $stmt = $db->prepare("INSERT INTO test_one_blob (id, blob1) VALUES (:id, EMPTY_BLOB()) RETURNING bl… 49 $res = $db->query("SELECT blob1 from test_one_blob"); 56 $db->exec("DROP TABLE test_one_blob");
|
/PHP-7.4/ext/pgsql/tests/ |
H A D | 29nb_async_connect.phpt | 13 if (!$db = pg_connect($conn_str, PGSQL_CONNECT_ASYNC)) { 15 } elseif (pg_connection_status($db) === PGSQL_CONNECTION_BAD) { 17 } elseif ($db_socket = pg_socket($db)) { 24 switch ($status = pg_connect_poll($db)) { 39 assert(pg_connection_status($db) === PGSQL_CONNECTION_OK); 42 pg_close($db);
|
/PHP-7.4/ext/dba/tests/ |
H A D | bug72885.phpt | 13 $db = dba_open($db_filename, 'c', 'flatfile'); 14 dba_insert('foo', 'bar', $db); 15 var_dump(dba_replace('foo', 'baz', $db)); 16 var_dump(dba_fetch('foo', $db)); 17 dba_close($db);
|
/PHP-7.4/ext/pdo_dblib/tests/ |
H A D | timeout.phpt | 16 $stmt = $db->prepare($sql); 22 $db = new PDO($dsn, $user, $pass); 23 $db->setAttribute(PDO::ATTR_TIMEOUT, 1); 24 $stmt = $db->prepare($sql); 35 $db = new PDO($dsn, $user, $pass); 36 $db->setAttribute(PDO::DBLIB_ATTR_QUERY_TIMEOUT, 1); 37 $stmt = $db->prepare($sql); 48 $db = new PDO($dsn, $user, $pass, [PDO::ATTR_TIMEOUT => 1]); 49 $stmt = $db->prepare($sql); 60 $db = new PDO($dsn, $user, $pass, [PDO::DBLIB_ATTR_QUERY_TIMEOUT => 1]); [all …]
|
H A D | datetime2.phpt | 7 if (in_array($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION), ['4.2', '4.6', '5.0', '6.0', '7.0', '7… 15 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 17 $stmt = $db->query($sql); 20 $db->setAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT, 1); 21 var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 22 $stmt = $db->query($sql);
|