void PgReader::CursorSetup() { std::ostringstream oss; oss << "DECLARE cur CURSOR FOR " << getDataQuery(); pg_begin(m_session); pg_execute(m_session, oss.str()); log()->get(LogLevel::Debug) << "SQL cursor prepared: " << oss.str() << std::endl; }
void PgReader::CursorTeardown() { pg_execute(m_session, "CLOSE cur"); pg_commit(m_session); log()->get(LogLevel::Debug) << "SQL cursor closed." << std::endl; }
inline void pg_begin(PGconn* session) { std::string sql = "BEGIN"; pg_execute(session, sql); }
inline void pg_commit(PGconn* session) { std::string sql = "COMMIT"; pg_execute(session, sql); }