Return to sqlite_oo_021.phpt CVS log

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

Annotation of embedaddon/php/ext/sqlite/tests/sqlite_oo_021.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: sqlite-oo: single query
                      3: --SKIPIF--
                      4: <?php # vim:ft=php
                      5: if (!extension_loaded("sqlite")) print "skip"; ?>
                      6: --FILE--
                      7: <?php 
                      8: include "blankdb_oo.inc";
                      9: 
                     10: $db->query("CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )");
                     11: for ($i = 0; $i < 10; $i++) {
                     12:        $db->query("INSERT INTO test_db (data) VALUES('{$i}data')");
                     13: }
                     14: $db->query("INSERT INTO test_db (data) VALUES(NULL)");
                     15: 
                     16: var_dump($db->singleQuery("SELECT id FROM test_db WHERE id=5"));
                     17: var_dump($db->singleQuery("SELECT * FROM test_db WHERE id=4"));
                     18: var_dump($db->singleQuery("SELECT data FROM test_db WHERE id=6"));
                     19: var_dump($db->singleQuery("SELECT * FROM test_db WHERE id < 5"));
                     20: var_dump($db->singleQuery("SELECT * FROM test db WHERE id < 4"));
                     21: var_dump($db->singleQuery("SELECT * FROM test_db WHERE id=999999"));
                     22: var_dump($db->singleQuery("SELECT id FROM test_db WHERE id=5", FALSE));
                     23: 
                     24: echo "DONE!\n";
                     25: ?>
                     26: --EXPECTF--
                     27: string(1) "5"
                     28: string(1) "4"
                     29: string(5) "5data"
                     30: array(4) {
                     31:   [0]=>
                     32:   string(1) "1"
                     33:   [1]=>
                     34:   string(1) "2"
                     35:   [2]=>
                     36:   string(1) "3"
                     37:   [3]=>
                     38:   string(1) "4"
                     39: }
                     40: 
                     41: Warning: SQLiteDatabase::singleQuery(): no such table: test in %s on line %d
                     42: bool(false)
                     43: NULL
                     44: array(1) {
                     45:   [0]=>
                     46:   string(1) "5"
                     47: }
                     48: DONE!