blob: d14220c92c799c57c8a5c70f6b01542c6e423f37 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
#include <gtest/gtest.h>
#include <filesystem>
#include <memory>
#include <string>
#include <system_error>
#include "libreichwein/file.h"
#include "config.h"
#include "storage.h"
#include "whiteboard.h"
namespace fs = std::filesystem;
namespace {
const std::string testDbFilename{"./whiteboard.db3"};
}
class CompiledSQLTest: public ::testing::Test
{
protected:
CompiledSQLTest(){
}
~CompiledSQLTest() override{
}
void SetUp() override
{
std::error_code ec;
fs::remove(testDbFilename, ec);
}
void TearDown() override
{
std::error_code ec;
fs::remove(testDbFilename, ec);
}
};
TEST_F(CompiledSQLTest, create)
{
SQLite::Database db{testDbFilename, SQLite::OPEN_READWRITE | SQLite::OPEN_CREATE};
{
CompiledSQL stmt1{db, "CREATE TABLE documents (id VARCHAR(16) PRIMARY KEY)"};
CompiledSQL::Guard g{stmt1};
stmt1.execute();
}
{
CompiledSQL stmt2{db, "INSERT INTO documents (id) values (?)"};
CompiledSQL::Guard g{stmt2};
stmt2.bind(1, "abc");
ASSERT_TRUE(stmt2.execute());
}
{
CompiledSQL stmt3{db, "SELECT id FROM documents WHERE id = ?"};
CompiledSQL::Guard g{stmt3};
stmt3.bind(1, "abc");
ASSERT_TRUE(stmt3.execute());
EXPECT_EQ(stmt3.getColumn<std::string>(0), "abc");
}
{
CompiledSQL stmt4{db, "SELECT id FROM documents WHERE id = ?"};
CompiledSQL::Guard g{stmt4};
stmt4.bind(1, "def");
ASSERT_FALSE(stmt4.execute());
}
EXPECT_TRUE(fs::exists(testDbFilename));
}
|
