Annotation of embedaddon/php/ext/sqlite3/tests/sqlite3_35_stmt_readonly.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: SQLite3_stmt::readOnly check
3: --SKIPIF--
4: <?php require_once(dirname(__FILE__) . '/skipif.inc');
5: $version = SQLite3::version();
6: if ($version['versionNumber'] < 3007004) {
7: die("skip");
8: }
9: ?>
10: --FILE--
11: <?php
12:
13: require_once(dirname(__FILE__) . '/new_db.inc');
14: define('TIMENOW', time());
15:
16: echo "Creating Table\n";
17: var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
18:
19: echo "INSERT into table\n";
20: var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')"));
21: var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
22:
23: echo "Checking select statement\n";
24: $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
25: var_dump($stmt->readOnly());
26:
27: echo "Checking update statement\n";
28: $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?");
29: var_dump($stmt->readOnly());
30:
31: echo "Checking delete statement\n";
32: $stmt = $db->prepare("DELETE FROM test");
33: var_dump($stmt->readOnly());
34:
35: echo "Closing database\n";
36: var_dump($db->close());
37: echo "Done\n";
38: ?>
39: --EXPECTF--
40: Creating Table
41: bool(true)
42: INSERT into table
43: bool(true)
44: bool(true)
45: Checking select statement
46: bool(true)
47: Checking update statement
48: bool(false)
49: Checking delete statement
50: bool(false)
51: Closing database
52: bool(true)
53: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>