diff options
Diffstat (limited to 'ext/sqlite')
-rw-r--r-- | ext/sqlite/CREDITS | 2 | ||||
-rw-r--r-- | ext/sqlite/README | 14 | ||||
-rw-r--r-- | ext/sqlite/TODO | 22 | ||||
-rw-r--r-- | ext/sqlite/libsqlite/README | 37 | ||||
-rw-r--r-- | ext/sqlite/libsqlite/src/sqlite_config.w32.h | 8 | ||||
-rw-r--r-- | ext/sqlite/sqlite.php | 33 | ||||
-rw-r--r-- | ext/sqlite/tests/blankdb.inc | 11 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_001.phpt | 17 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_002.phpt | 31 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_003.phpt | 51 | ||||
-rw-r--r-- | ext/sqlite/tests/sqlite_004.phpt | 46 | ||||
-rw-r--r-- | ext/sqlite/tests/sqlite_005.phpt | 47 | ||||
-rw-r--r-- | ext/sqlite/tests/sqlite_006.phpt | 52 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_007.phpt | 51 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_008.phpt | 43 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_009.phpt | 43 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_010.phpt | 78 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_011.phpt | 27 | ||||
-rwxr-xr-x | ext/sqlite/tests/sqlite_012.phpt | 35 |
19 files changed, 0 insertions, 648 deletions
diff --git a/ext/sqlite/CREDITS b/ext/sqlite/CREDITS deleted file mode 100644 index 87f769b6f9..0000000000 --- a/ext/sqlite/CREDITS +++ /dev/null @@ -1,2 +0,0 @@ -sqlite -Wez Furlong, Tal Peer, Marcus Börger diff --git a/ext/sqlite/README b/ext/sqlite/README deleted file mode 100644 index 2f6cbb0f87..0000000000 --- a/ext/sqlite/README +++ /dev/null @@ -1,14 +0,0 @@ -This is an extension for the SQLite Embeddable SQL Database Engine. -http://www.sqlite.org/ - -SQLite is a C library that implements an embeddable SQL database engine. -Programs that link with the SQLite library can have SQL database access -without running a separate RDBMS process. - -SQLite is not a client library used to connect to a big database server. -SQLite is the server. The SQLite library reads and writes directly to and from -the database files on disk - - - -vim:tw=78:et diff --git a/ext/sqlite/TODO b/ext/sqlite/TODO deleted file mode 100644 index b3e5594450..0000000000 --- a/ext/sqlite/TODO +++ /dev/null @@ -1,22 +0,0 @@ -- Transparent binary encoding of return values from PHP callback functions. - -- Add user-space callback for the authorizer function (this is potentially - very slow, so it needs to be implemented carefully). - -- Add user-space callback to handle busy databases. - -- Test-suite - - o Test how robust we are when a user-space function is registered as - a callback for a persistent connection in script A, then script B is - called that doesn't register the callback but does make use of the - function in an SQL query. - --> Our test suite doesn't allow us to test persistent connections - at this time :/ - -- If building a ZTS build, -DTHREADSAFE while compiling libsqlite - -- If building a non-debug build, -DNDEBUG will disable the expensive - asserts in the inner loop. (and double performance) - -vim:tw=78 diff --git a/ext/sqlite/libsqlite/README b/ext/sqlite/libsqlite/README deleted file mode 100644 index 326f3aa1ac..0000000000 --- a/ext/sqlite/libsqlite/README +++ /dev/null @@ -1,37 +0,0 @@ -This directory contains source code to - - SQLite: An Embeddable SQL Database Engine - -To compile the project, first create a directory in which to place -the build products. It is recommended, but not required, that the -build directory be separate from the source directory. Cd into the -build directory and then from the build directory run the configure -script found at the root of the source tree. Then run "make". - -For example: - - tar xzf sqlite.tar.gz ;# Unpack the source tree into "sqlite" - mkdir bld ;# Build will occur in a sibling directory - cd bld ;# Change to the build directory - ../sqlite/configure ;# Run the configure script - make ;# Run the makefile. - -The configure script uses autoconf 2.50 and libtool. If the configure -script does not work out for you, there is a generic makefile named -"Makefile.linux-gcc" in the top directory of the source tree that you -can copy and edit to suite your needs. Comments on the generic makefile -show what changes are needed. - -The linux binaries on the website are created using the generic makefile, -not the configure script. The configure script is unmaintained. (You -can volunteer to take over maintenance of the configure script, if you want!) -The windows binaries on the website are created using MinGW32 configured -as a cross-compiler running under Linux. For details, see the ./publish.sh -script at the top-level of the source tree. - -Contacts: - - http://www.sqlite.org/ - http://www.hwaci.com/sw/sqlite/ - http://groups.yahoo.com/group/sqlite/ - drh@hwaci.com diff --git a/ext/sqlite/libsqlite/src/sqlite_config.w32.h b/ext/sqlite/libsqlite/src/sqlite_config.w32.h deleted file mode 100644 index 3903ffe95e..0000000000 --- a/ext/sqlite/libsqlite/src/sqlite_config.w32.h +++ /dev/null @@ -1,8 +0,0 @@ -#include "config.w32.h" -#if ZTS -# define THREADSAFE 1 -#endif -#if !ZEND_DEBUG && !defined(NDEBUG) -# define NDEBUG -#endif -#define SQLITE_PTR_SZ 4
\ No newline at end of file diff --git a/ext/sqlite/sqlite.php b/ext/sqlite/sqlite.php deleted file mode 100644 index d1fefb4503..0000000000 --- a/ext/sqlite/sqlite.php +++ /dev/null @@ -1,33 +0,0 @@ -<?php -if (!extension_loaded("sqlite")) { - dl("sqlite.so"); -} - -debug_zval_dump(sqlite_libversion()); -debug_zval_dump(sqlite_libencoding()); - -$s = sqlite_open("weztest.sqlite", 0666, $err); - -debug_zval_dump($err); -debug_zval_dump($s); - -$r = sqlite_query("create table foo (a INTEGER PRIMARY KEY, b INTEGER )", $s); -debug_zval_dump(sqlite_last_error($s)); -debug_zval_dump(sqlite_error_string(sqlite_last_error($s))); - -$r = sqlite_query("select *, php('md5', sql) as o from sqlite_master", $s); -debug_zval_dump($r); -debug_zval_dump(sqlite_num_rows($r)); -debug_zval_dump(sqlite_num_fields($r)); - -for ($j = 0; $j < sqlite_num_fields($r); $j++) { - echo "Field $j is " . sqlite_field_name($r, $j) . "\n"; -} - -while ($row = sqlite_fetch_array($r, SQLITE_ASSOC)) { - print_r($row); -} - -sqlite_close($s); - -?> diff --git a/ext/sqlite/tests/blankdb.inc b/ext/sqlite/tests/blankdb.inc deleted file mode 100644 index 085d3b2b51..0000000000 --- a/ext/sqlite/tests/blankdb.inc +++ /dev/null @@ -1,11 +0,0 @@ -<?php #vim:ft=php -$dbname = tempnam(dirname(__FILE__), "phpsql"); -function cleanup() { - if ($GLOBALS['db']) { - sqlite_close($GLOBALS['db']); - } - unlink($GLOBALS['dbname']); -} -register_shutdown_function("cleanup"); -$db = sqlite_open($dbname); -?> diff --git a/ext/sqlite/tests/sqlite_001.phpt b/ext/sqlite/tests/sqlite_001.phpt deleted file mode 100755 index 70059a3e59..0000000000 --- a/ext/sqlite/tests/sqlite_001.phpt +++ /dev/null @@ -1,17 +0,0 @@ ---TEST-- -sqlite: sqlite_open/close ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -require_once('blankdb.inc'); -echo "$db\n"; -sqlite_close($db); -$db = NULL; -echo "Done\n"; -?> ---EXPECTF-- -Resource id #%d -Done diff --git a/ext/sqlite/tests/sqlite_002.phpt b/ext/sqlite/tests/sqlite_002.phpt deleted file mode 100755 index d76b61687d..0000000000 --- a/ext/sqlite/tests/sqlite_002.phpt +++ /dev/null @@ -1,31 +0,0 @@ ---TEST-- -sqlite: Simple insert/select ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); -sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r)); -?> ---EXPECT-- -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_003.phpt b/ext/sqlite/tests/sqlite_003.phpt deleted file mode 100755 index 3e6cb3f04e..0000000000 --- a/ext/sqlite/tests/sqlite_003.phpt +++ /dev/null @@ -1,51 +0,0 @@ ---TEST-- -sqlite: Simple insert/select, different result represenatation ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); -sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_BOTH)); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_NUM)); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_ASSOC)); -?> ---EXPECT-- -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} -array(3) { - [0]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - [2]=> - NULL -} -array(3) { - ["c1"]=> - string(10) "2002-01-02" - ["c2"]=> - string(8) "12:49:00" - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_004.phpt b/ext/sqlite/tests/sqlite_004.phpt deleted file mode 100644 index 4005fc9030..0000000000 --- a/ext/sqlite/tests/sqlite_004.phpt +++ /dev/null @@ -1,46 +0,0 @@ ---TEST-- -sqlite: binary encoding ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$strings = array( - "hello", - "hello\x01o", - "\x01hello there", - "hello\x00there", - "" -); - -sqlite_query("CREATE TABLE strings(a)", $db); - -foreach ($strings as $str) { - sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($str) . "')", $db); -} - -$i = 0; -$r = sqlite_query("SELECT * from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - if ($row[0] !== $strings[$i]) { - echo "FAIL!\n"; - var_dump($row[0]); - var_dump($strings[$i]); - } else { - echo "OK!\n"; - } - $i++; -} -echo "DONE!\n"; -?> ---EXPECT-- -OK! -OK! -OK! -OK! -OK! -DONE! diff --git a/ext/sqlite/tests/sqlite_005.phpt b/ext/sqlite/tests/sqlite_005.phpt deleted file mode 100644 index 70a8232630..0000000000 --- a/ext/sqlite/tests/sqlite_005.phpt +++ /dev/null @@ -1,47 +0,0 @@ ---TEST-- -sqlite: aggregate functions ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($str) . "')", $db); -} - -function cat_step(&$context, $string) -{ - $context .= $string; -} - -function cat_fin(&$context) -{ - return $context; -} - -sqlite_create_aggregate($db, "cat", "cat_step", "cat_fin"); - -$r = sqlite_query("SELECT cat(a) from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(11) "onetwothree" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_006.phpt b/ext/sqlite/tests/sqlite_006.phpt deleted file mode 100644 index b839a6e5c6..0000000000 --- a/ext/sqlite/tests/sqlite_006.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -sqlite: regular functions ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - array("one", "uno"), - array("two", "dos"), - array("three", "tres"), - ); - -sqlite_query("CREATE TABLE strings(a,b)", $db); - -function implode_args() -{ - $args = func_get_args(); - $sep = array_shift($args); - return implode($sep, $args); -} - -foreach ($data as $row) { - sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($row[0]) . "','" . sqlite_escape_string($row[1]) . "')", $db); -} - -sqlite_create_function($db, "implode", "implode_args"); - -$r = sqlite_query("SELECT implode('-', a, b) from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(7) "one-uno" -} -array(1) { - [0]=> - string(7) "two-dos" -} -array(1) { - [0]=> - string(10) "three-tres" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_007.phpt b/ext/sqlite/tests/sqlite_007.phpt deleted file mode 100755 index c68e165a0c..0000000000 --- a/ext/sqlite/tests/sqlite_007.phpt +++ /dev/null @@ -1,51 +0,0 @@ ---TEST-- -sqlite: Simple insert/select (unbuffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); -sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); -$r = sqlite_unbuffered_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_BOTH)); -$r = sqlite_unbuffered_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_NUM)); -$r = sqlite_unbuffered_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_ASSOC)); -?> ---EXPECT-- -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} -array(3) { - [0]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - [2]=> - NULL -} -array(3) { - ["c1"]=> - string(10) "2002-01-02" - ["c2"]=> - string(8) "12:49:00" - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_008.phpt b/ext/sqlite/tests/sqlite_008.phpt deleted file mode 100755 index 5886e8f73a..0000000000 --- a/ext/sqlite/tests/sqlite_008.phpt +++ /dev/null @@ -1,43 +0,0 @@ ---TEST-- -sqlite: fetch all (buffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_query("SELECT a from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_009.phpt b/ext/sqlite/tests/sqlite_009.phpt deleted file mode 100755 index 990b6c68f3..0000000000 --- a/ext/sqlite/tests/sqlite_009.phpt +++ /dev/null @@ -1,43 +0,0 @@ ---TEST-- -sqlite: fetch all (unbuffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_unbuffered_query("SELECT a from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_010.phpt b/ext/sqlite/tests/sqlite_010.phpt deleted file mode 100755 index 3715747072..0000000000 --- a/ext/sqlite/tests/sqlite_010.phpt +++ /dev/null @@ -1,78 +0,0 @@ ---TEST-- -sqlite: fetch all (iterator) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_unbuffered_query("SELECT a from strings", $db); -while (sqlite_has_more($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - sqlite_next($r); -} -$r = sqlite_query("SELECT a from strings", $db); -while (sqlite_has_more($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - sqlite_next($r); -} -sqlite_rewind($r); -while (sqlite_has_more($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - sqlite_next($r); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_011.phpt b/ext/sqlite/tests/sqlite_011.phpt deleted file mode 100755 index 1aa6704249..0000000000 --- a/ext/sqlite/tests/sqlite_011.phpt +++ /dev/null @@ -1,27 +0,0 @@ ---TEST-- -sqlite: returned associative column names ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo (c1 char, c2 char, c3 char)", $db); -sqlite_query("CREATE TABLE bar (c1 char, c2 char, c3 char)", $db); -sqlite_query("INSERT INTO foo VALUES ('1', '2', '3')", $db); -sqlite_query("INSERT INTO bar VALUES ('4', '5', '6')", $db); -$r = sqlite_query("SELECT * from foo, bar", $db, SQLITE_ASSOC); -var_dump(sqlite_fetch_array($r)); -?> ---EXPECT-- -array(3) { - ["c1"]=> - string(1) "4" - ["c2"]=> - string(1) "5" - ["c3"]=> - string(1) "6" -} diff --git a/ext/sqlite/tests/sqlite_012.phpt b/ext/sqlite/tests/sqlite_012.phpt deleted file mode 100755 index 531bf8055b..0000000000 --- a/ext/sqlite/tests/sqlite_012.phpt +++ /dev/null @@ -1,35 +0,0 @@ ---TEST-- -sqlite: read field names ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)", $db); - -echo "Buffered\n"; -$r = sqlite_query("SELECT * from strings", $db); -for($i=0; $i<sqlite_num_fields($r); $i++) { - var_dump(sqlite_field_name($r, $i)); -} -echo "Unbuffered\n"; -$r = sqlite_unbuffered_query("SELECT * from strings", $db); -for($i=0; $i<sqlite_num_fields($r); $i++) { - var_dump(sqlite_field_name($r, $i)); -} -echo "DONE!\n"; -?> ---EXPECT-- -Buffered -string(3) "foo" -string(3) "bar" -string(3) "baz" -Unbuffered -string(3) "foo" -string(3) "bar" -string(3) "baz" -DONE! |