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
|
#include <iostream>
#include <set>
#include <vector>
// Get some information about our libpq version
#include <pqxx/config-internal-libpq.h>
#include "test_helpers.hxx"
#include <pqxx/config-internal-libpq.h>
using namespace PGSTD;
using namespace pqxx;
// Test program for libpqxx. Test querying of result column origins.
namespace
{
void test_093(transaction_base &T)
{
result R, X;
{
T.exec("CREATE TEMP TABLE pqxxfoo (x varchar, y integer, z integer)");
T.exec("INSERT INTO pqxxfoo VALUES ('xx', 1, 2)");
R = T.exec("SELECT z,y,x FROM pqxxfoo");
X = T.exec("SELECT x,y,z,99 FROM pqxxfoo");
if (!T.conn().supports(connection_base::cap_table_column))
{
cout << "No support for querying table columns. Skipping." << endl;
return;
}
// T and connection are closed here; result objects remain
}
pqxx::tuple::size_type
x = R.table_column(2),
y = R.table_column(1),
z = R.table_column(int(0));
PQXX_CHECK_EQUAL(x, 0u, "Wrong column number.");
PQXX_CHECK_EQUAL(y, 1u, "Wrong column number.");
PQXX_CHECK_EQUAL(z, 2u, "Wrong column number.");
x = R.table_column("x");
y = R.table_column("y");
z = R.table_column("z");
PQXX_CHECK_EQUAL(x, 0u, "Wrong number for named column.");
PQXX_CHECK_EQUAL(y, 1u, "Wrong number for named column.");
PQXX_CHECK_EQUAL(z, 2u, "Wrong number for named column.");
pqxx::tuple::size_type
xx = X[0].table_column(int(0)),
yx = X[0].table_column(pqxx::tuple::size_type(1)),
zx = X[0].table_column("z");
PQXX_CHECK_EQUAL(xx, 0u, "Bad result from table_column(int).");
PQXX_CHECK_EQUAL(yx, 1u, "Bad result from table_column(size_type).");
PQXX_CHECK_EQUAL(zx, 2u, "Bad result from table_column(string).");
for (pqxx::tuple::size_type i=0; i<R[0].size(); ++i)
PQXX_CHECK_EQUAL(
R[0][i].table_column(),
R.table_column(i),
"Bad result from column_table().");
PQXX_CHECK_THROWS(
R.table_column(3),
exception,
"table_column() with invalid index didn't fail.");
PQXX_CHECK_THROWS(
R.table_column("nonexistent"),
exception,
"table_column() with invalid column name didn't fail.");
PQXX_CHECK_THROWS(
X.table_column(3),
exception,
"table_column() on non-table didn't fail.");
}
} // namespace
PQXX_REGISTER_TEST(test_093)
|
