forked from fnc12/sqlite_orm
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathstorage_tests.cpp
More file actions
124 lines (111 loc) · 5.06 KB
/
storage_tests.cpp
File metadata and controls
124 lines (111 loc) · 5.06 KB
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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
#include <sqlite_orm/sqlite_orm.h>
#include <catch2/catch.hpp>
using namespace sqlite_orm;
TEST_CASE("busy handler") {
auto storage = make_storage({});
storage.busy_handler([](int /*timesCount*/) {
return 0;
});
}
TEST_CASE("drop table") {
struct User {
int id = 0;
std::string name;
};
struct Visit {
int id = 0;
std::string date;
};
const std::string usersTableName = "users";
const std::string visitsTableName = "visits";
auto storage = make_storage(
{},
make_table(usersTableName, make_column("id", &User::id, primary_key()), make_column("name", &User::name)),
make_table(visitsTableName, make_column("id", &Visit::id, primary_key()), make_column("date", &Visit::date)));
REQUIRE(!storage.table_exists(usersTableName));
REQUIRE(!storage.table_exists(visitsTableName));
storage.sync_schema();
REQUIRE(storage.table_exists(usersTableName));
REQUIRE(storage.table_exists(visitsTableName));
storage.drop_table(usersTableName);
REQUIRE(!storage.table_exists(usersTableName));
REQUIRE(storage.table_exists(visitsTableName));
storage.drop_table(visitsTableName);
REQUIRE(!storage.table_exists(usersTableName));
REQUIRE(!storage.table_exists(visitsTableName));
}
TEST_CASE("rename table") {
struct User {
int id = 0;
std::string name;
};
struct Visit {
int id = 0;
std::string date;
};
const std::string usersTableName = "users";
const std::string userNewTableName = "users_new";
const std::string visitsTableName = "visits";
const std::string visitsNewTableName = "visits_new";
auto storage = make_storage(
{},
make_table(usersTableName, make_column("id", &User::id, primary_key()), make_column("name", &User::name)),
make_table(visitsTableName, make_column("id", &Visit::id, primary_key()), make_column("date", &Visit::date)));
REQUIRE(!storage.table_exists(usersTableName));
REQUIRE(!storage.table_exists(userNewTableName));
REQUIRE(!storage.table_exists(visitsTableName));
REQUIRE(!storage.table_exists(visitsNewTableName));
REQUIRE(storage.tablename<User>() == usersTableName);
REQUIRE(storage.tablename<User>() != userNewTableName);
REQUIRE(storage.tablename<Visit>() == visitsTableName);
REQUIRE(storage.tablename<Visit>() != visitsNewTableName);
storage.sync_schema();
REQUIRE(storage.table_exists(usersTableName));
REQUIRE(!storage.table_exists(userNewTableName));
REQUIRE(storage.table_exists(visitsTableName));
REQUIRE(!storage.table_exists(visitsNewTableName));
REQUIRE(storage.tablename<User>() == usersTableName);
REQUIRE(storage.tablename<User>() != userNewTableName);
REQUIRE(storage.tablename<Visit>() == visitsTableName);
REQUIRE(storage.tablename<Visit>() != visitsNewTableName);
SECTION("with 1 argument") {
storage.rename_table<User>(userNewTableName);
REQUIRE(storage.table_exists(usersTableName));
REQUIRE(!storage.table_exists(userNewTableName));
REQUIRE(storage.table_exists(visitsTableName));
REQUIRE(!storage.table_exists(visitsNewTableName));
REQUIRE(storage.tablename<User>() != usersTableName);
REQUIRE(storage.tablename<User>() == userNewTableName);
REQUIRE(storage.tablename<Visit>() == visitsTableName);
REQUIRE(storage.tablename<Visit>() != visitsNewTableName);
storage.rename_table<Visit>(visitsNewTableName);
REQUIRE(storage.table_exists(usersTableName));
REQUIRE(!storage.table_exists(userNewTableName));
REQUIRE(storage.table_exists(visitsTableName));
REQUIRE(!storage.table_exists(visitsNewTableName));
REQUIRE(storage.tablename<User>() != usersTableName);
REQUIRE(storage.tablename<User>() == userNewTableName);
REQUIRE(storage.tablename<Visit>() != visitsTableName);
REQUIRE(storage.tablename<Visit>() == visitsNewTableName);
}
SECTION("with 2 arguments") {
storage.rename_table(usersTableName, userNewTableName);
REQUIRE(!storage.table_exists(usersTableName));
REQUIRE(storage.table_exists(userNewTableName));
REQUIRE(storage.table_exists(visitsTableName));
REQUIRE(!storage.table_exists(visitsNewTableName));
REQUIRE(storage.tablename<User>() == usersTableName);
REQUIRE(storage.tablename<User>() != userNewTableName);
REQUIRE(storage.tablename<Visit>() == visitsTableName);
REQUIRE(storage.tablename<Visit>() != visitsNewTableName);
storage.rename_table(visitsTableName, visitsNewTableName);
REQUIRE(!storage.table_exists(usersTableName));
REQUIRE(storage.table_exists(userNewTableName));
REQUIRE(!storage.table_exists(visitsTableName));
REQUIRE(storage.table_exists(visitsNewTableName));
REQUIRE(storage.tablename<User>() == usersTableName);
REQUIRE(storage.tablename<User>() != userNewTableName);
REQUIRE(storage.tablename<Visit>() == visitsTableName);
REQUIRE(storage.tablename<Visit>() != visitsNewTableName);
}
}