diff options
| author | Nikita Popov <nikita.ppv@gmail.com> | 2020-02-03 22:52:20 +0100 |
|---|---|---|
| committer | Nikita Popov <nikita.ppv@gmail.com> | 2020-02-03 22:52:20 +0100 |
| commit | f8d795820e780a6322e054c26c581570613c14f0 (patch) | |
| tree | 99d3ae01ce564752807341c5743863b4c92513f8 /ext/sqlite3 | |
| parent | d2cb200e10ada6fa44c54a29292bb4665728fff0 (diff) | |
| download | php-git-f8d795820e780a6322e054c26c581570613c14f0.tar.gz | |
Reindent phpt files
Diffstat (limited to 'ext/sqlite3')
33 files changed, 134 insertions, 134 deletions
diff --git a/ext/sqlite3/tests/bug45798.phpt b/ext/sqlite3/tests/bug45798.phpt index 9637c1fc9b..7184d58d54 100644 --- a/ext/sqlite3/tests/bug45798.phpt +++ b/ext/sqlite3/tests/bug45798.phpt @@ -18,7 +18,7 @@ $stmt->bindParam(1, $foo, SQLITE3_TEXT); $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/bug68760.phpt b/ext/sqlite3/tests/bug68760.phpt index 7eb97ee013..7cc646780b 100644 --- a/ext/sqlite3/tests/bug68760.phpt +++ b/ext/sqlite3/tests/bug68760.phpt @@ -7,8 +7,8 @@ if (!extension_loaded('sqlite3')) die('skip'); --FILE-- <?php function oopsFunction($a, $b) { - echo "callback".PHP_EOL; - throw new \Exception("oops"); + echo "callback".PHP_EOL; + throw new \Exception("oops"); } $db = new SQLite3(":memory:"); diff --git a/ext/sqlite3/tests/bug72668.phpt b/ext/sqlite3/tests/bug72668.phpt index 2845fa0a7c..6f566d2df1 100644 --- a/ext/sqlite3/tests/bug72668.phpt +++ b/ext/sqlite3/tests/bug72668.phpt @@ -6,33 +6,33 @@ if (!extension_loaded('sqlite3')) die('skip'); ?> --FILE-- <?php function my_udf_md5($string) { - throw new \Exception("test exception\n"); + throw new \Exception("test exception\n"); } $db = new SQLite3(':memory:'); $db->createFunction('my_udf_md5', 'my_udf_md5'); try { - $result = $db->query('SELECT my_udf_md5("test")'); - var_dump($result); + $result = $db->query('SELECT my_udf_md5("test")'); + var_dump($result); } catch(\Exception $e) { - echo "Exception: ".$e->getMessage(); + echo "Exception: ".$e->getMessage(); } try { - $result = $db->querySingle('SELECT my_udf_md5("test")'); - var_dump($result); + $result = $db->querySingle('SELECT my_udf_md5("test")'); + var_dump($result); } catch(\Exception $e) { - echo "Exception: ".$e->getMessage(); + echo "Exception: ".$e->getMessage(); } $statement = $db->prepare('SELECT my_udf_md5("test")'); try { - $result = $statement->execute(); - var_dump($result); + $result = $statement->execute(); + var_dump($result); } catch(\Exception $e) { - echo "Exception: ".$e->getMessage(); + echo "Exception: ".$e->getMessage(); } ?> --EXPECT-- diff --git a/ext/sqlite3/tests/skipif.inc b/ext/sqlite3/tests/skipif.inc index 9614e679b9..0f930332ea 100644 --- a/ext/sqlite3/tests/skipif.inc +++ b/ext/sqlite3/tests/skipif.inc @@ -1,7 +1,7 @@ <?php if (!extension_loaded('sqlite3')) { - die("skip sqlite3 extension not loaded"); + die("skip sqlite3 extension not loaded"); } ?> diff --git a/ext/sqlite3/tests/sqlite3_03_insert.phpt b/ext/sqlite3/tests/sqlite3_03_insert.phpt index 1a0690a000..60880de880 100644 --- a/ext/sqlite3/tests/sqlite3_03_insert.phpt +++ b/ext/sqlite3/tests/sqlite3_03_insert.phpt @@ -19,7 +19,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_04_update.phpt b/ext/sqlite3/tests/sqlite3_04_update.phpt index 3ce7d9cf8b..fe55464ef6 100644 --- a/ext/sqlite3/tests/sqlite3_04_update.phpt +++ b/ext/sqlite3/tests/sqlite3_04_update.phpt @@ -19,7 +19,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); @@ -30,7 +30,7 @@ echo "Checking results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_05_delete.phpt b/ext/sqlite3/tests/sqlite3_05_delete.phpt index 9ce50c4789..8768d0b575 100644 --- a/ext/sqlite3/tests/sqlite3_05_delete.phpt +++ b/ext/sqlite3/tests/sqlite3_05_delete.phpt @@ -19,7 +19,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); @@ -30,7 +30,7 @@ echo "Checking results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_06_prepared_stmt.phpt b/ext/sqlite3/tests/sqlite3_06_prepared_stmt.phpt index 710813e8f5..28fd2d264a 100644 --- a/ext/sqlite3/tests/sqlite3_06_prepared_stmt.phpt +++ b/ext/sqlite3/tests/sqlite3_06_prepared_stmt.phpt @@ -24,7 +24,7 @@ $foo = 'a'; $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_07_prepared_stmt.phpt b/ext/sqlite3/tests/sqlite3_07_prepared_stmt.phpt index d9a2408123..393386fead 100644 --- a/ext/sqlite3/tests/sqlite3_07_prepared_stmt.phpt +++ b/ext/sqlite3/tests/sqlite3_07_prepared_stmt.phpt @@ -23,7 +23,7 @@ var_dump($stmt->bindValue(1, $foo, SQLITE3_TEXT)); $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_08_udf.phpt b/ext/sqlite3/tests/sqlite3_08_udf.phpt index 7f00dbb1c4..24862ddda8 100644 --- a/ext/sqlite3/tests/sqlite3_08_udf.phpt +++ b/ext/sqlite3/tests/sqlite3_08_udf.phpt @@ -7,7 +7,7 @@ SQLite3::createFunction function my_udf_md5($foo) { - return md5($foo); + return md5($foo); } require_once(__DIR__ . '/new_db.inc'); @@ -27,7 +27,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT my_udf_md5(id) FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_09_blob_bound_param.phpt b/ext/sqlite3/tests/sqlite3_09_blob_bound_param.phpt index 994503dd03..27497f7448 100644 --- a/ext/sqlite3/tests/sqlite3_09_blob_bound_param.phpt +++ b/ext/sqlite3/tests/sqlite3_09_blob_bound_param.phpt @@ -30,7 +30,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT id, quote(data) AS data FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_10_bound_value_name.phpt b/ext/sqlite3/tests/sqlite3_10_bound_value_name.phpt index 712ad2e539..f7bd34f388 100644 --- a/ext/sqlite3/tests/sqlite3_10_bound_value_name.phpt +++ b/ext/sqlite3/tests/sqlite3_10_bound_value_name.phpt @@ -25,7 +25,7 @@ var_dump($stmt->bindValue('id', $foo, SQLITE3_TEXT)); $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt b/ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt index eac5a59a8a..e3e67f1ff4 100644 --- a/ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt +++ b/ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt @@ -19,9 +19,9 @@ echo "SELECTING results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); - /* Only read one row and break */ - break; + var_dump($result); + /* Only read one row and break */ + break; } echo "Closing database\n"; diff --git a/ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt b/ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt index daeacc0832..0bced8c19a 100644 --- a/ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt +++ b/ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt @@ -19,7 +19,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } echo "Done\n"; ?> diff --git a/ext/sqlite3/tests/sqlite3_15_open_error-win.phpt b/ext/sqlite3/tests/sqlite3_15_open_error-win.phpt index d9c7e2fa41..4b75b3b28f 100644 --- a/ext/sqlite3/tests/sqlite3_15_open_error-win.phpt +++ b/ext/sqlite3/tests/sqlite3_15_open_error-win.phpt @@ -19,9 +19,9 @@ $cmd = $icacls . ' ' . $unreadable . ' /inheritance:r /deny ' . $user . ':(F,M,R exec($cmd); try { - $db = new SQLite3($unreadable); + $db = new SQLite3($unreadable); } catch (Exception $e) { - echo $e . "\n"; + echo $e . "\n"; } echo "Done\n"; diff --git a/ext/sqlite3/tests/sqlite3_15_open_error.phpt b/ext/sqlite3/tests/sqlite3_15_open_error.phpt index 74bcc920d0..0c3e9537db 100644 --- a/ext/sqlite3/tests/sqlite3_15_open_error.phpt +++ b/ext/sqlite3/tests/sqlite3_15_open_error.phpt @@ -16,9 +16,9 @@ $unreadable = __DIR__ . '/unreadable.db'; touch($unreadable); chmod($unreadable, 0200); try { - $db = new SQLite3($unreadable); + $db = new SQLite3($unreadable); } catch (Exception $e) { - echo $e . "\n"; + echo $e . "\n"; } echo "Done\n"; unlink($unreadable); diff --git a/ext/sqlite3/tests/sqlite3_16_select_no_results.phpt b/ext/sqlite3/tests/sqlite3_16_select_no_results.phpt index 91875b68ad..08fe5eeb24 100644 --- a/ext/sqlite3/tests/sqlite3_16_select_no_results.phpt +++ b/ext/sqlite3/tests/sqlite3_16_select_no_results.phpt @@ -15,7 +15,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_19_columninfo.phpt b/ext/sqlite3/tests/sqlite3_19_columninfo.phpt index 2395c75399..51017bb0bc 100644 --- a/ext/sqlite3/tests/sqlite3_19_columninfo.phpt +++ b/ext/sqlite3/tests/sqlite3_19_columninfo.phpt @@ -18,10 +18,10 @@ var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")) echo "SELECTING results\n"; $result = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($row = $result->fetchArray(SQLITE3_NUM)) { - $totalColumns = $result->numColumns(); - for ($i = 0; $i < $totalColumns; $i++) { - echo "Name: " . $result->columnName($i) . " - Type: " . $result->columnType($i) . "\n"; - } + $totalColumns = $result->numColumns(); + for ($i = 0; $i < $totalColumns; $i++) { + echo "Name: " . $result->columnName($i) . " - Type: " . $result->columnType($i) . "\n"; + } } $result->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_20_error.phpt b/ext/sqlite3/tests/sqlite3_20_error.phpt index a9324c3999..9b1579a83e 100644 --- a/ext/sqlite3/tests/sqlite3_20_error.phpt +++ b/ext/sqlite3/tests/sqlite3_20_error.phpt @@ -10,8 +10,8 @@ require_once(__DIR__ . '/new_db.inc'); echo "SELECTING from invalid table\n"; $result = $db->query("SELECT * FROM non_existent_table"); if (!$result) { - echo "Error Code: " . $db->lastErrorCode() . "\n"; - echo "Error Msg: " . $db->lastErrorMsg() . "\n"; + echo "Error Code: " . $db->lastErrorCode() . "\n"; + echo "Error Msg: " . $db->lastErrorMsg() . "\n"; } echo "Closing database\n"; var_dump($db->close()); diff --git a/ext/sqlite3/tests/sqlite3_21_security.phpt b/ext/sqlite3/tests/sqlite3_21_security.phpt index 5221807cd5..407869b3f8 100644 --- a/ext/sqlite3/tests/sqlite3_21_security.phpt +++ b/ext/sqlite3/tests/sqlite3_21_security.phpt @@ -19,9 +19,9 @@ unlink($directory . $file); echo "Above test directory\n"; try { - $db = new SQLite3('../bad' . $file); + $db = new SQLite3('../bad' . $file); } catch (Exception $e) { - echo $e . "\n"; + echo $e . "\n"; } echo "Done\n"; diff --git a/ext/sqlite3/tests/sqlite3_23_escape_string.phpt b/ext/sqlite3/tests/sqlite3_23_escape_string.phpt index 6552c222a7..f91213ae64 100644 --- a/ext/sqlite3/tests/sqlite3_23_escape_string.phpt +++ b/ext/sqlite3/tests/sqlite3_23_escape_string.phpt @@ -19,7 +19,7 @@ echo "SELECTING results\n"; $results = $db->query("SELECT * FROM test ORDER BY id ASC"); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_25_create_aggregate.phpt b/ext/sqlite3/tests/sqlite3_25_create_aggregate.phpt index 84993571ec..c8a033e738 100644 --- a/ext/sqlite3/tests/sqlite3_25_create_aggregate.phpt +++ b/ext/sqlite3/tests/sqlite3_25_create_aggregate.phpt @@ -8,17 +8,17 @@ SQLite3::createAggregate() test require_once(__DIR__ . '/new_db.inc'); function sum_list_step($context, $rows, $string) { - if (empty($context)) - { - $context = array('total' => 0, 'values' => array()); - } - $context['total'] += intval($string); - $context['values'][] = $context['total']; - return $context; + if (empty($context)) + { + $context = array('total' => 0, 'values' => array()); + } + $context['total'] += intval($string); + $context['values'][] = $context['total']; + return $context; } function sum_list_finalize($context) { - return implode(',', $context['values']); + return implode(',', $context['values']); } echo "Creating Table\n"; diff --git a/ext/sqlite3/tests/sqlite3_26_reset_prepared_stmt.phpt b/ext/sqlite3/tests/sqlite3_26_reset_prepared_stmt.phpt index ffd05d3329..39e9e48676 100644 --- a/ext/sqlite3/tests/sqlite3_26_reset_prepared_stmt.phpt +++ b/ext/sqlite3/tests/sqlite3_26_reset_prepared_stmt.phpt @@ -23,11 +23,11 @@ var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT)); $foo = 'a'; $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $stmt->reset(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_27_reset_prepared_stmt_result.phpt b/ext/sqlite3/tests/sqlite3_27_reset_prepared_stmt_result.phpt index 646cb473f3..6257d6483c 100644 --- a/ext/sqlite3/tests/sqlite3_27_reset_prepared_stmt_result.phpt +++ b/ext/sqlite3/tests/sqlite3_27_reset_prepared_stmt_result.phpt @@ -23,11 +23,11 @@ var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT)); $foo = 'a'; $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->reset(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_28_clear_bindings.phpt b/ext/sqlite3/tests/sqlite3_28_clear_bindings.phpt index a17e1fb3f1..4472b878bc 100644 --- a/ext/sqlite3/tests/sqlite3_28_clear_bindings.phpt +++ b/ext/sqlite3/tests/sqlite3_28_clear_bindings.phpt @@ -23,14 +23,14 @@ var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT)); $foo = 'a'; $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $stmt->reset(); $stmt->clear(); var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT)); $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_36_create_collation.phpt b/ext/sqlite3/tests/sqlite3_36_create_collation.phpt index 90fbd9d37b..644ceb02c6 100644 --- a/ext/sqlite3/tests/sqlite3_36_create_collation.phpt +++ b/ext/sqlite3/tests/sqlite3_36_create_collation.phpt @@ -13,8 +13,8 @@ $db->exec('CREATE TABLE t (s varchar(4))'); $stmt = $db->prepare('INSERT INTO t VALUES (?)'); foreach(array('a1', 'a10', 'a2') as $s){ - $stmt->bindParam(1, $s); - $stmt->execute(); + $stmt->bindParam(1, $s); + $stmt->execute(); } $defaultSort = $db->query('SELECT s FROM t ORDER BY s'); //memcmp() sort @@ -22,12 +22,12 @@ $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp echo "default\n"; while ($row = $defaultSort->fetchArray()){ - echo $row['s'], "\n"; + echo $row['s'], "\n"; } echo "natural\n"; while ($row = $naturalSort->fetchArray()){ - echo $row['s'], "\n"; + echo $row['s'], "\n"; } $db->close(); diff --git a/ext/sqlite3/tests/sqlite3_40_setauthorizer.phpt b/ext/sqlite3/tests/sqlite3_40_setauthorizer.phpt index 57f05216df..994c67e0c3 100644 --- a/ext/sqlite3/tests/sqlite3_40_setauthorizer.phpt +++ b/ext/sqlite3/tests/sqlite3_40_setauthorizer.phpt @@ -9,21 +9,21 @@ $db = new SQLite3(':memory:'); $db->enableExceptions(true); $db->setAuthorizer(function (int $action) { - if ($action == SQLite3::SELECT) { - return SQLite3::OK; - } + if ($action == SQLite3::SELECT) { + return SQLite3::OK; + } - return SQLite3::DENY; + return SQLite3::DENY; }); // This query should be accepted var_dump($db->querySingle('SELECT 1;')); try { - // This one should fail - var_dump($db->querySingle('CREATE TABLE test (a, b);')); + // This one should fail + var_dump($db->querySingle('CREATE TABLE test (a, b);')); } catch (\Exception $e) { - echo $e->getMessage() . "\n"; + echo $e->getMessage() . "\n"; } // Test disabling the authorizer @@ -35,11 +35,11 @@ var_dump($db->querySingle('SELECT a FROM test;')); // Test if we are getting the correct arguments $db->setAuthorizer(function (int $action) { - $constants = (new ReflectionClass('SQLite3'))->getConstants(); - $constants = array_flip($constants); + $constants = (new ReflectionClass('SQLite3'))->getConstants(); + $constants = array_flip($constants); - var_dump($constants[$action], implode(',', array_slice(func_get_args(), 1))); - return SQLITE3::OK; + var_dump($constants[$action], implode(',', array_slice(func_get_args(), 1))); + return SQLITE3::OK; }); var_dump($db->exec('SELECT * FROM test WHERE a = 42;')); @@ -47,25 +47,25 @@ var_dump($db->exec('DROP TABLE test;')); // Try to return something invalid from the authorizer $db->setAuthorizer(function () { - return 'FAIL'; + return 'FAIL'; }); try { - var_dump($db->querySingle('SELECT 1;')); + var_dump($db->querySingle('SELECT 1;')); } catch (\Exception $e) { - echo $e->getMessage() . "\n"; - echo $e->getPrevious()->getMessage() . "\n"; + echo $e->getMessage() . "\n"; + echo $e->getPrevious()->getMessage() . "\n"; } $db->setAuthorizer(function () { - return 4200; + return 4200; }); try { - var_dump($db->querySingle('SELECT 1;')); + var_dump($db->querySingle('SELECT 1;')); } catch (\Exception $e) { - echo $e->getMessage() . "\n"; - echo $e->getPrevious()->getMessage() . "\n"; + echo $e->getMessage() . "\n"; + echo $e->getPrevious()->getMessage() . "\n"; } ?> diff --git a/ext/sqlite3/tests/sqlite3_bind_bug68849.phpt b/ext/sqlite3/tests/sqlite3_bind_bug68849.phpt index 9b6e3ae29a..179e04d35d 100644 --- a/ext/sqlite3/tests/sqlite3_bind_bug68849.phpt +++ b/ext/sqlite3/tests/sqlite3_bind_bug68849.phpt @@ -8,9 +8,9 @@ Bug #68849 bindValue is not using the right data type $db = new SQLite3(':memory:'); $db->exec("CREATE TABLE test (a INTEGER, b TEXT, c REAL);" . - "INSERT INTO test VALUES (1, 'hello', 3.14);" . - "INSERT INTO test VALUES (3, 'world', 3.15);" . - "INSERT INTO test VALUES (0, '42', 0.42);" + "INSERT INTO test VALUES (1, 'hello', 3.14);" . + "INSERT INTO test VALUES (3, 'world', 3.15);" . + "INSERT INTO test VALUES (0, '42', 0.42);" ); $s = $db->prepare('SELECT * FROM test WHERE (a+2) = ?;'); diff --git a/ext/sqlite3/tests/sqlite3_blob_bind_resource.phpt b/ext/sqlite3/tests/sqlite3_blob_bind_resource.phpt index c35af945db..de7edfbbac 100644 --- a/ext/sqlite3/tests/sqlite3_blob_bind_resource.phpt +++ b/ext/sqlite3/tests/sqlite3_blob_bind_resource.phpt @@ -13,10 +13,10 @@ $insert_stmt = $db->prepare("INSERT INTO test (id, data) VALUES (1, ?)"); class HelloWrapper { - public function stream_open() { return true; } - public function stream_eof() { return true; } - public function stream_read() { return NULL; } - public function stream_stat() { return array(); } + public function stream_open() { return true; } + public function stream_eof() { return true; } + public function stream_read() { return NULL; } + public function stream_stat() { return array(); } } stream_wrapper_register("hello", "HelloWrapper"); diff --git a/ext/sqlite3/tests/sqlite3_bound_value_at_name.phpt b/ext/sqlite3/tests/sqlite3_bound_value_at_name.phpt index d0eec87a2f..c441b1bc4a 100644 --- a/ext/sqlite3/tests/sqlite3_bound_value_at_name.phpt +++ b/ext/sqlite3/tests/sqlite3_bound_value_at_name.phpt @@ -23,7 +23,7 @@ var_dump($stmt->bindValue('@id', $foo, SQLITE3_TEXT)); $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { - var_dump($result); + var_dump($result); } $results->finalize(); diff --git a/ext/sqlite3/tests/sqlite3_prepare_001.phpt b/ext/sqlite3/tests/sqlite3_prepare_001.phpt index 5142081b3a..f97eaab021 100644 --- a/ext/sqlite3/tests/sqlite3_prepare_001.phpt +++ b/ext/sqlite3/tests/sqlite3_prepare_001.phpt @@ -6,8 +6,8 @@ SQLite3 - memory leak on SQLite3Result and SQLite3Stmt <?php function test(&$x) { - $class = new SQLite3(':memory:'); - $x = $class->prepare('SELECT 1'); + $class = new SQLite3(':memory:'); + $x = $class->prepare('SELECT 1'); } test($foo); diff --git a/ext/sqlite3/tests/sqlite3stmt_paramCount_basic.phpt b/ext/sqlite3/tests/sqlite3stmt_paramCount_basic.phpt index a520f5715b..81eae9e566 100644 --- a/ext/sqlite3/tests/sqlite3stmt_paramCount_basic.phpt +++ b/ext/sqlite3/tests/sqlite3stmt_paramCount_basic.phpt @@ -16,21 +16,21 @@ var_dump($db->exec("INSERT INTO foobar (id, name, city) VALUES (2, 'doe', 'SF')" $queryArray = array( - "SELECT * FROM foobar WHERE id = ? ORDER BY id ASC", - "SELECT * FROM foobar WHERE id = 2 ORDER BY id ASC", - "SELECT * FROM foobar WHERE id = :id AND name = :name ORDER BY id ASC", - "SELECT * FROM foobar WHERE id = 1 AND name = :name ORDER BY id ASC", + "SELECT * FROM foobar WHERE id = ? ORDER BY id ASC", + "SELECT * FROM foobar WHERE id = 2 ORDER BY id ASC", + "SELECT * FROM foobar WHERE id = :id AND name = :name ORDER BY id ASC", + "SELECT * FROM foobar WHERE id = 1 AND name = :name ORDER BY id ASC", ); echo "SELECTING results\n"; foreach($queryArray as $key => $query) { - $stmt = $db->prepare($query); + $stmt = $db->prepare($query); - echo 'Param count for query ' . ($key + 1) . ":\n"; - var_dump($stmt->paramCount()); + echo 'Param count for query ' . ($key + 1) . ":\n"; + var_dump($stmt->paramCount()); - $result = $stmt->execute(); + $result = $stmt->execute(); } echo "Closing database\n"; diff --git a/ext/sqlite3/tests/stream_test.inc b/ext/sqlite3/tests/stream_test.inc index 13fd6f89f9..0d53d0f7be 100644 --- a/ext/sqlite3/tests/stream_test.inc +++ b/ext/sqlite3/tests/stream_test.inc @@ -2,42 +2,42 @@ class SQLite3_Test_Stream { - private $position; - public static $string_length = 10; - public static $string = "abcdefg\0hi"; - - public function stream_open($path, $mode, $options, &$opened_path) - { - $this->position = 0; - return true; - } - - public function stream_read($count) - { - $ret = substr(self::$string, $this->position, $count); - $this->position += strlen($ret); - return $ret; - } - - public function stream_write($data) - { - return 0; - } - - public function stream_stat() - { - return array('size' => self::$string_length); - } - - public function stream_tell() - { - return $this->position; - } - - public function stream_eof() - { - return ($this->position >= self::$string_length); - } + private $position; + public static $string_length = 10; + public static $string = "abcdefg\0hi"; + + public function stream_open($path, $mode, $options, &$opened_path) + { + $this->position = 0; + return true; + } + + public function stream_read($count) + { + $ret = substr(self::$string, $this->position, $count); + $this->position += strlen($ret); + return $ret; + } + + public function stream_write($data) + { + return 0; + } + + public function stream_stat() + { + return array('size' => self::$string_length); + } + + public function stream_tell() + { + return $this->position; + } + + public function stream_eof() + { + return ($this->position >= self::$string_length); + } } stream_wrapper_register('sqliteBlobTest', "SQLite3_Test_Stream") or die("Unable to register sqliteBlobTest stream"); |
