summaryrefslogtreecommitdiff
path: root/libpqpp/pq-cursorselectcommand.cpp
blob: 54b843f197dcc2e4034f4f7c7d0bcb1832750345 (plain)
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
#include "pq-cursorselectcommand.h"
#include "pq-connection.h"
#include "pq-error.h"
#include <compileTimeFormatter.h>

AdHocFormatter(PQCursorSelectDeclare, "DECLARE %? CURSOR FOR ");
AdHocFormatter(PQCursorSelectFetch, "FETCH %? IN %?");
AdHocFormatter(PQCursorSelectClose, "CLOSE %?");

PQ::CursorSelectCommand::CursorSelectCommand(Connection * conn, const std::string & sql, const PQ::CommandOptions * pqco, const DB::CommandOptions * opts) :
	DB::Command(sql),
	PQ::SelectBase(sql),
	PQ::Command(conn, sql, opts),
	executed(false),
	txOpened(false),
	fTuples(pqco ? pqco->fetchTuples : 35),
	s_fetch(PQCursorSelectFetch::get(fTuples, stmntName)),
	s_close(PQCursorSelectClose::get(stmntName))
{
}

PQ::CursorSelectCommand::~CursorSelectCommand()
{
	if (executed && PQtransactionStatus(c->conn) != PQTRANS_INERROR) {
		c->checkResultFree((PQexec(c->conn, s_close.c_str())), PGRES_COMMAND_OK);
	}
	if (txOpened) {
		c->commitTx();
	}
}

std::string
PQ::CursorSelectCommand::mkdeclare() const
{
	std::stringstream psql;
	PQCursorSelectDeclare::write(psql, stmntName);
	prepareSql(psql, sql);
	return psql.str();
}

void
PQ::CursorSelectCommand::execute()
{
	if (!executed) {
		if (!c->inTx()) {
			c->beginTx();
			txOpened = true;
		}
		if (s_declare.empty()) {
			s_declare = mkdeclare();
		}
		c->checkResultFree(
				PQexecParams(c->conn, s_declare.c_str(), values.size(), NULL, &values.front(), &lengths.front(), &formats.front(), 0),
				PGRES_COMMAND_OK);
		fetchTuples();
		createColumns(execRes);
		executed = true;
	}
}

void
PQ::CursorSelectCommand::fetchTuples()
{
	execRes = c->checkResult(PQexec(c->conn, s_fetch.c_str()), PGRES_TUPLES_OK);
	nTuples = PQntuples(execRes);
	tuple = -1;
}

bool
PQ::CursorSelectCommand::fetch()
{
	execute();
	if ((tuple >= (nTuples - 1)) && (nTuples == fTuples)) {
		// Delete the previous result set
		PQclear(execRes);
		execRes = NULL;
		fetchTuples();
	}
	if (tuple++ < (nTuples - 1)) {
		return true;
	}
	else {
		PQclear(PQexec(c->conn, s_close.c_str()));
		PQclear(execRes);
		execRes = NULL;
		executed = false;
		return false;
	}
}