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
{
void test_016(transaction_base &T)
{
result R( T.exec("SELECT * FROM pg_tables") );
result::const_iterator c;
for (c = R.begin(); c != R.end(); ++c)
{
string N;
c[0].to(N);
cout << '\t' << to_string(c.num()) << '\t' << N << endl;
}
// See if back() and tuple comparison work properly
PQXX_CHECK(R.size() >= 2, "Not enough rows in pg_tables to test, sorry!");
--c;
PQXX_CHECK_EQUAL(
c->size(),
R.back().size(),
"Size mismatch between pqxx::tuple iterator and back().");
const string nullstr;
for (pqxx::tuple::size_type i = 0; i < c->size(); ++i)
PQXX_CHECK_EQUAL(
c[i].as(nullstr),
R.back()[i].as(nullstr),
"Value mismatch in back().");
PQXX_CHECK(c == R.back(), "Tuple equality is broken.");
PQXX_CHECK(!(c != R.back()), "Tuple inequality is broken.");
// "Commit" the non-transaction. This doesn't really do anything since
// NonTransaction doesn't start a backend transaction.
T.commit();
}
} // namespace
PQXX_REGISTER_TEST_T(test_016, robusttransaction<>)
|
