aboutsummaryrefslogtreecommitdiff
path: root/src/sqlitepptest.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'src/sqlitepptest.cpp')
-rw-r--r--src/sqlitepptest.cpp108
1 files changed, 0 insertions, 108 deletions
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 <boost/test/unit_test.hpp>
-
-#include <fstream>
-#include <iostream>
-#include <stdexcept>
-
-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