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
|
#include "pq-mock.h"
#include "pq-connection.h"
#include <compileTimeFormatter.h>
#include <modifycommand.h>
#include <selectcommand.h>
#include <selectcommandUtil.impl.h>
#include <boost/algorithm/string.hpp>
NAMEDFACTORY("postgresql", PQ::Mock, DB::MockDatabaseFactory);
namespace PQ {
Mock::Mock(const std::string & masterdb, const std::string & name, const std::vector<std::filesystem::path> & ss) :
MockServerDatabase(masterdb, name, "postgresql"),
tablespacePath(std::filesystem::temp_directory_path() / testDbName),
serverVersion(std::static_pointer_cast<Connection>(master)->serverVersion())
{
try {
CreateNewDatabase();
PlaySchemaScripts(ss);
SetTablesToUnlogged();
}
catch (...) {
DropDatabase();
throw;
}
}
AdHocFormatter(MockConnStr, "user=postgres dbname=%?");
DB::ConnectionPtr
Mock::openConnection() const
{
return std::make_shared<Connection>(MockConnStr::get(boost::algorithm::to_lower_copy(testDbName)));
}
AdHocFormatter(MockSetUnlogged, "ALTER TABLE %?.%? SET UNLOGGED");
void
Mock::SetTablesToUnlogged() const
{
if (!hasUnloggedTables()) {
return;
}
auto s = master->select(R"SQL(
SELECT n.nspname, c.relname
FROM pg_class c, pg_namespace n
WHERE c.relkind = 'r'
AND n.nspname not in (?, ?)
AND c.relpersistence = 'p'
AND NOT EXISTS (
SELECT from pg_constraint fk, pg_class ck
WHERE fk.contype = 'f'
AND fk.confrelid = c.oid
AND fk.conrelid = ck.oid
AND ck.oid != c.oid
AND ck.relpersistence = 'p')
AND n.oid = c.relnamespace
ORDER BY 1, 2)SQL");
s->bindParamS(0, "pg_catalog");
s->bindParamS(1, "information_schema");
unsigned int n = 0;
do {
n = 0;
for (const auto [ nspname, relname ] : s->as<std::string, std::string>()) {
master->execute(MockSetUnlogged::get(nspname, relname));
n += 1;
}
} while(n);
}
Mock::~Mock()
{
Mock::DropDatabase();
}
bool
Mock::hasUnloggedTables() const
{
// v9.5 server required for unlogged tables
return (serverVersion >= 90500);
}
bool
Mock::hasCopyToProgram() const
{
// v9.3 server required to use COPY ... TO PROGRAM ...
return (serverVersion >= 90300);
}
AdHocFormatter(MockCreateTablespaceDir, "COPY (SELECT '%?') TO PROGRAM 'xargs mkdir -p'");
AdHocFormatter(MockCreateTablespace, "CREATE TABLESPACE %? LOCATION '%?'");
AdHocFormatter(MockCreateDatabase, "CREATE DATABASE %? TABLESPACE %?");
AdHocFormatter(MockDropTablespace, "DROP TABLESPACE IF EXISTS %?");
AdHocFormatter(MockDropTablespaceDir, "COPY (SELECT '%?') TO PROGRAM 'xargs rm -rf'");
void
Mock::CreateNewDatabase() const
{
if (hasCopyToProgram()) {
DropDatabase();
master->execute(MockCreateTablespaceDir::get(tablespacePath));
master->execute(MockCreateTablespace::get(testDbName, tablespacePath.string()));
master->execute(MockCreateDatabase::get(testDbName, testDbName));
}
else {
MockServerDatabase::CreateNewDatabase();
}
}
void
Mock::DropDatabase() const
{
auto t = master->modify("SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE LOWER(datname) = LOWER(?)");
t->bindParamS(0, testDbName);
t->execute();
MockServerDatabase::DropDatabase();
if (hasCopyToProgram()) {
master->execute(MockDropTablespace::get(testDbName));
master->execute(MockDropTablespaceDir::get(tablespacePath));
}
}
}
|
