diff options
author | James Moger <james.moger@gitblit.com> | 2015-04-30 12:04:02 -0400 |
---|---|---|
committer | James Moger <james.moger@gitblit.com> | 2015-04-30 13:53:58 -0400 |
commit | 3b421139610d0df38b12694e4291b64bb8738c8e (patch) | |
tree | 1421c320b6223154ae728f8f4a544fab2a4d04bc /src/test | |
parent | 23eaf92995f7e2b087db19e03feffb733c0fd8f8 (diff) | |
download | iciql-3b421139610d0df38b12694e4291b64bb8738c8e.tar.gz iciql-3b421139610d0df38b12694e4291b64bb8738c8e.zip |
Update to SQLite-jdbc 3.8.9 and improve the testsuite
Diffstat (limited to 'src/test')
-rw-r--r-- | src/test/java/com/iciql/test/IciqlSuite.java | 39 |
1 files changed, 36 insertions, 3 deletions
diff --git a/src/test/java/com/iciql/test/IciqlSuite.java b/src/test/java/com/iciql/test/IciqlSuite.java index 19b3d60..f30caf6 100644 --- a/src/test/java/com/iciql/test/IciqlSuite.java +++ b/src/test/java/com/iciql/test/IciqlSuite.java @@ -114,9 +114,42 @@ public class IciqlSuite { new TestDb("Derby", "tcp", "jdbc:derby://localhost:1527/testdbs/derby/iciql;create=true", "sa", "sa"), new TestDb("MySQL", "tcp", "jdbc:mysql://localhost:3306/iciql", "sa", "sa"), new TestDb("PostgreSQL", "tcp", "jdbc:postgresql://localhost:5432/iciql", "sa", "sa"), - new TestDb("SQLite", "memory", "jdbc:sqlite:file:iciql?mode=memory&cache=shared"), - new TestDb("SQLite", "delete,full sync", "jdbc:sqlite:" - + new File(baseFolder, "/sqlite/iciql.db").getAbsolutePath()) + + // + // SQLite Memory + // + new TestDb("SQLite", "memory", "jdbc:sqlite:file::memory:?cache=shared&foreign_keys=ON"), + + // + // SQLite DELETE rollback journal (default) + // + new TestDb("SQLite", "delete,full_sync", "jdbc:sqlite:" + + new File(baseFolder, "/sqlite/iciql.db").getAbsolutePath() + + "?foreign_keys=ON&journal_mode=DELETE&synchronous=FULL"), + + new TestDb("SQLite", "delete,norm_sync", "jdbc:sqlite:" + + new File(baseFolder, "/sqlite/iciql.db").getAbsolutePath() + + "?foreign_keys=ON&journal_mode=DELETE&synchronous=NORMAL"), + + new TestDb("SQLite", "delete,no_sync", "jdbc:sqlite:" + + new File(baseFolder, "/sqlite/iciql.db").getAbsolutePath() + + "?foreign_keys=ON&journal_mode=DELETE&synchronous=OFF"), + + // + // SQLite WAL + // + new TestDb("SQLite", "wal,full_sync", "jdbc:sqlite:" + + new File(baseFolder, "/sqlite/iciql.db").getAbsolutePath() + + "?foreign_keys=ON&journal_mode=WAL&synchronous=FULL"), + + new TestDb("SQLite", "wal,norm_sync", "jdbc:sqlite:" + + new File(baseFolder, "/sqlite/iciql.db").getAbsolutePath() + + "?foreign_keys=ON&journal_mode=WAL&synchronous=NORMAL"), + + new TestDb("SQLite", "wal,no_sync", "jdbc:sqlite:" + + new File(baseFolder, "/sqlite/iciql.db").getAbsolutePath() + + "?foreign_keys=ON&journal_mode=WAL&synchronous=OFF"), + }; private static final TestDb DEFAULT_TEST_DB = TEST_DBS[0]; |