Annotation of embedaddon/php/ext/sqlite3/tests/sqlite3_02_create.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: SQLite3::query CREATE tests
3: --SKIPIF--
4: <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
5: --FILE--
6: <?php
7:
8: require_once(dirname(__FILE__) . '/new_db.inc');
9:
10: echo "Creating Table\n";
11: var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
12:
13: echo "Creating Same Table Again\n";
14: var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)'));
15:
16: echo "Dropping database\n";
17: var_dump($db->exec('DROP TABLE test'));
18:
19: echo "Closing database\n";
20: var_dump($db->close());
21: echo "Done\n";
22: ?>
23: --EXPECTF--
24: Creating Table
25: bool(true)
26: Creating Same Table Again
27:
28: Warning: SQLite3::exec(): table test already exists in %s on line %d
29: bool(false)
30: Dropping database
31: bool(true)
32: Closing database
33: bool(true)
34: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>