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
|
#include <iostream>
#include "test_helpers.hxx"
using namespace PGSTD;
using namespace pqxx;
// Simple test program for libpqxx. Open connection to database, start
// a dummy transaction to gain nontransactional access, and perform a query.
namespace
{
class ReadTables : public transactor<nontransaction>
{
result m_Result;
public:
ReadTables() : transactor<nontransaction>("ReadTables") {}
void operator()(argument_type &T)
{
m_Result = T.exec("SELECT * FROM pg_tables");
}
void on_commit()
{
for (result::const_iterator c = m_Result.begin(); c != m_Result.end(); ++c)
{
string N;
c[0].to(N);
cout << '\t' << to_string(c.num()) << '\t' << N << endl;
}
}
};
void test_015(transaction_base &orgT)
{
connection_base &C(orgT.conn());
orgT.abort();
// See if deactivate() behaves...
C.deactivate();
C.perform(ReadTables());
}
} // namespace
PQXX_REGISTER_TEST_T(test_015, nontransaction)
|
