aboutsummaryrefslogtreecommitdiff
path: root/src/sqlitepp/sqlitepp_test.cc
diff options
context:
space:
mode:
authorRobin Krahl <me@robin-krahl.de>2017-03-23 23:42:57 +0100
committerRobin Krahl <me@robin-krahl.de>2017-03-23 23:42:57 +0100
commite1d6684a7adbf29130411f2a030d01b594a95ca1 (patch)
treeeda1a7fa75320f4496c36859333e29247c19cf6f /src/sqlitepp/sqlitepp_test.cc
parentcbe3dc9f40aaab8a2ff641ce824766b41d1d407c (diff)
downloadsqlitepp-e1d6684a7adbf29130411f2a030d01b594a95ca1.tar.gz
sqlitepp-e1d6684a7adbf29130411f2a030d01b594a95ca1.tar.bz2
Move sources directly to src and rename to .cpp.
Diffstat (limited to 'src/sqlitepp/sqlitepp_test.cc')
-rw-r--r--src/sqlitepp/sqlitepp_test.cc105
1 files changed, 0 insertions, 105 deletions
diff --git a/src/sqlitepp/sqlitepp_test.cc b/src/sqlitepp/sqlitepp_test.cc
deleted file mode 100644
index dfa46d4..0000000
--- a/src/sqlitepp/sqlitepp_test.cc
+++ /dev/null
@@ -1,105 +0,0 @@
-// Copyright (C) 2014--2015 Robin Krahl <robin.krahl@ireas.org>
-// MIT license -- http://opensource.org/licenses/MIT
-
-#include <stdexcept>
-#include <fstream>
-#include <iostream>
-#include "gtest/gtest.h"
-#include "sqlitepp/sqlitepp.h"
-
-TEST(Database, openClose) {
- sqlitepp::Database database;
- EXPECT_FALSE(database.isOpen());
- database.open("/tmp/test.db");
- EXPECT_TRUE(database.isOpen());
- database.close();
- EXPECT_FALSE(database.isOpen());
- database.open("/tmp/test2.db");
- EXPECT_TRUE(database.isOpen());
- database.close();
- EXPECT_FALSE(database.isOpen());
- sqlitepp::Database database2("/tmp/test.db");
- EXPECT_TRUE(database2.isOpen());
- EXPECT_THROW(database2.open("/tmp/test2.db"), std::logic_error);
- EXPECT_TRUE(database2.isOpen());
- database2.close();
- EXPECT_FALSE(database2.isOpen());
-
- std::ifstream testStream("/tmp/test.db");
- EXPECT_TRUE(testStream.good());
- testStream.close();
- testStream.open("/tmp/test2.db");
- EXPECT_TRUE(testStream.good());
- testStream.close();
-}
-
-TEST(Database, copy) {
- sqlitepp::Database database;
- // MUST NOT COMPILE:
- // sqlitepp::Database database2 = database;
- database.close();
- sqlitepp::Database database3;
- // MUST NOT COMPILE:
- // database3 = database;
- database3.close();
-}
-
-TEST(Database, prepare) {
- sqlitepp::Database database("/tmp/test.db");
- std::shared_ptr<sqlitepp::Statement> statement = database.prepare(
- "CREATE TABLE IF NOT EXISTS test (id, value);");
- EXPECT_TRUE(statement->isOpen());
- statement->close();
- EXPECT_FALSE(statement->isOpen());
- database.close();
-}
-
-TEST(Database, execute) {
- sqlitepp::Database database("/tmp/test.db");
- database.execute("CREATE TABLE IF NOT EXISTS test (id, value);");
-}
-
-TEST(Database, insert) {
- sqlitepp::Database database("/tmp/test.db");
- std::shared_ptr<sqlitepp::Statement> statement = database.prepare(
- "INSERT INTO test (id, value) VALUES (:id, ?)");
- statement->bind(":id", 1);
- statement->bind(2, "test value");
- statement->execute();
- const int rowId1 = database.lastInsertRowId();
- EXPECT_NE(0, rowId1);
- statement->reset();
- statement->bind(":id", 2);
- statement->bind(2, "other value");
- statement->execute();
- const int rowId2 = database.lastInsertRowId();
- EXPECT_NE(0, rowId2);
- EXPECT_NE(rowId1, rowId2);
-}
-
-TEST(Database, query) {
- sqlitepp::Database database("/tmp/test.db");
- std::shared_ptr<sqlitepp::Statement> statement = database.prepare(
- "SELECT id, value FROM test;");
- sqlitepp::ResultSet resultSet = statement->execute();
- EXPECT_TRUE(resultSet.canRead());
- EXPECT_EQ(2, resultSet.columnCount());
- int id = resultSet.readInt(0);
- std::string value = resultSet.readString(1);
- EXPECT_EQ(1, id);
- EXPECT_EQ("test value", value);
- EXPECT_TRUE(resultSet.next());
- EXPECT_TRUE(resultSet.canRead());
- id = resultSet.readInt(0);
- value = resultSet.readString(1);
- EXPECT_EQ(2, id);
- EXPECT_EQ("other value", value);
- EXPECT_FALSE(resultSet.next());
- EXPECT_FALSE(resultSet.canRead());
-}
-
-TEST(Database, cleanup) {
- sqlitepp::Database database("/tmp/test.db");
- database.execute("DROP TABLE test;");
- database.close();
-}