From 56b56f46f13a7838e113b529a75771a9fb07bdf7 Mon Sep 17 00:00:00 2001 From: Robin Krahl Date: Sat, 18 Jul 2015 23:30:42 +0200 Subject: Refactoring and update. --- src/sqlitepptest.cpp | 108 --------------------------------------------------- 1 file changed, 108 deletions(-) delete mode 100644 src/sqlitepptest.cpp (limited to 'src/sqlitepptest.cpp') diff --git a/src/sqlitepptest.cpp b/src/sqlitepptest.cpp deleted file mode 100644 index 7974eae..0000000 --- a/src/sqlitepptest.cpp +++ /dev/null @@ -1,108 +0,0 @@ -/* - * (C) 2014 Robin Krahl - * MIT license -- http://opensource.org/licenses/MIT - */ - -#include "sqlitepp.h" - -#define BOOST_TEST_DYN_LINK -#define BOOST_TEST_MODULE SQLitePPTest -#include - -#include -#include -#include - -BOOST_AUTO_TEST_CASE(openClose) { - sqlitepp::Database database; - BOOST_CHECK(!database.isOpen()); - database.open("/tmp/test.db"); - BOOST_CHECK(database.isOpen()); - database.close(); - BOOST_CHECK(!database.isOpen()); - database.open("/tmp/test2.db"); - BOOST_CHECK(database.isOpen()); - database.close(); - BOOST_CHECK(!database.isOpen()); - sqlitepp::Database database2("/tmp/test.db"); - BOOST_CHECK(database2.isOpen()); - try { - database2.open("/tmp/test2.db"); - BOOST_ERROR("Calling open() to an open database does not throw an exception."); - } catch (std::logic_error &) { - // everything fine - } - BOOST_CHECK(database2.isOpen()); - database2.close(); - BOOST_CHECK(!database2.isOpen()); - - std::ifstream testStream("/tmp/test.db"); - BOOST_CHECK(testStream.good()); - testStream.close(); - testStream.open("/tmp/test2.db"); - BOOST_CHECK(testStream.good()); - testStream.close(); -} - -BOOST_AUTO_TEST_CASE(copy) { - sqlitepp::Database database; - // MUST NOT COMPILE: - // sqlitepp::Database database2 = database; - database.close(); - sqlitepp::Database database3; - // MUST NOT COMPILE: - // database3 = database; - database3.close(); -} - -BOOST_AUTO_TEST_CASE(prepare) { - sqlitepp::Database database("/tmp/test.db"); - sqlitepp::Statement statement(database, "CREATE TABLE IF NOT EXISTS test (id, value);"); - // TODO check std::logic_error - BOOST_CHECK(statement.isOpen()); - statement.finalize(); - BOOST_CHECK(!statement.isOpen()); - database.close(); -} - -BOOST_AUTO_TEST_CASE(execute) { - sqlitepp::Database database("/tmp/test.db"); - database.execute("CREATE TABLE IF NOT EXISTS test (id, value);"); - sqlitepp::Statement statement(database, "INSERT INTO test (id, value) VALUES (:id, ?)"); - statement.bindInt(":id", 1); - statement.bindString(2, "test value"); - statement.step(); - statement.reset(); - statement.bindInt(":id", 2); - statement.bindString(2, "other value"); - statement.step(); - statement.finalize(); -} - -BOOST_AUTO_TEST_CASE(query) { - sqlitepp::Database database("/tmp/test.db"); - sqlitepp::Statement statement(database, "SELECT id, value FROM test;"); - bool hasNext = statement.step(); - BOOST_CHECK(hasNext); - BOOST_CHECK_EQUAL(statement.columnCount(), 2); - int id = statement.readInt(0); - std::string value = statement.readString(1); - BOOST_CHECK_EQUAL(id, 1); - BOOST_CHECK_EQUAL(value, "test value"); - hasNext = statement.step(); - BOOST_CHECK(hasNext); - id = statement.readInt(0); - value = statement.readString(1); - BOOST_CHECK_EQUAL(id, 2); - BOOST_CHECK_EQUAL(value, "other value"); - hasNext = statement.step(); - BOOST_CHECK(!hasNext); - statement.finalize(); - database.close(); -} - -BOOST_AUTO_TEST_CASE(cleanup) { - sqlitepp::Database database("/tmp/test.db"); - database.execute("DROP TABLE test;"); - database.close(); -} \ No newline at end of file -- cgit v1.2.1