#include <connection.h>
Public Member Functions | |
Connection (const PGSTD::string &ConnInfo, bool Immediate=true) | |
Constructor. Sets up connection based on PostgreSQL connection string. | |
Connection (const char ConnInfo[], bool Immediate=true) | |
Constructor. Sets up connection based on PostgreSQL connection string. | |
~Connection () | |
Destructor. Implicitly closes the connection. | |
void | Disconnect () const throw () |
Explicitly close connection. | |
bool | is_open () const |
Is this connection open? | |
bool | IsOpen () const |
Is this connection open? | |
template<typename TRANSACTOR> void | Perform (const TRANSACTOR &T, int Attempts=3) |
Perform the transaction defined by a Transactor-based object. | |
NoticeProcessor | SetNoticeProcessor (NoticeProcessor, void *arg) |
Set callback method for postgresql status output. | |
std::auto_ptr< Noticer > | SetNoticer (std::auto_ptr< Noticer > N) |
Set handler for postgresql errors or warning messages. | |
Noticer * | GetNoticer () const throw () |
void | ProcessNotice (const char[]) throw () |
Invoke notice processor function. The message should end in newline. | |
void | ProcessNotice (const PGSTD::string &msg) throw () |
Invoke notice processor function. The message should end in newline. | |
void | Trace (FILE *) |
Enable tracing to a given output stream, or NULL to disable. | |
void | Untrace () |
Disable tracing. | |
void | GetNotifs () |
Check for pending trigger notifications and take appropriate action. | |
const char * | DbName () const throw () |
Name of database we're connected to, if any. | |
const char * | UserName () const throw () |
Database user ID we're connected under, if any. | |
const char * | HostName () const throw () |
Address of server (NULL for local connections). | |
const char * | Port () const throw () |
Server port number we're connected to. | |
const char * | Options () const throw () |
Full connection string as used to set up this connection. | |
int | BackendPID () const |
Process ID for backend process. | |
void | Activate () const |
Explicitly activate deferred or deactivated connection. | |
void | Deactivate () const |
Explicitly deactivate connection. | |
Friends | |
class | TransactionItf |
class | Trigger |
This is the first class to look at when you wish to work with a database through libpqxx. It is automatically opened by its constructor, and automatically closed upon destruction, if it hasn't already been closed manually. To query or manipulate the database once connected, use one of the Transaction classes (see pqxx/transactionitf.h) or preferably the Transactor framework (see pqxx/transactor.h).
|
Constructor. Sets up connection based on PostgreSQL connection string.
|
|
Constructor. Sets up connection based on PostgreSQL connection string.
|
|
Destructor. Implicitly closes the connection.
|
|
Explicitly activate deferred or deactivated connection. Use of this method is entirely optional. Whenever a Connection is used while in a deferred or deactivated state, it will transparently try to bring itself into an actiaveted state. This function is best viewed as an explicit hint to the Connection that "if you're not in an active state, now would be a good time to get into one." Whether a Connection is currently in an active state or not makes no real difference to its functionality. There is also no particular need to match calls to Activate() with calls to Deactivate(). A good time to call Activate() might be just before you first open a transaction on a lazy connection. |
|
Process ID for backend process. Use with care: connections may be lost and automatically re-established without your knowledge, in which case this process ID may no longer be correct. You may, however, assume that this number remains constant and reliable within the span of a successful backend transaction. If the transaction fails, which may be due to a lost connection, then this number will have become invalid at some point within the transaction. |
|
Name of database we're connected to, if any.
|
|
Explicitly deactivate connection. Like its counterpart Activate(), this method is entirely optional. Calling this function really only makes sense if you won't be using this Connection for a while and want to reduce the number of open connections on the database server. There is no particular need to match or pair calls to Deactivate() with calls to Activate(), but calling Deactivate() during a transaction is an error. |
|
Explicitly close connection.
|
|
|
|
Check for pending trigger notifications and take appropriate action.
|
|
Address of server (NULL for local connections).
|
|
Is this connection open?
|
|
Is this connection open?
|
|
Full connection string as used to set up this connection.
|
|
Perform the transaction defined by a Transactor-based object. The function may create and execute several copies of the Transactor before it succeeds. If there is any doubt over whether it succeeded (this can happen if the connection is lost just before the backend can confirm success), it is no longer retried and an error message is generated.
|
|
Server port number we're connected to.
|
|
Invoke notice processor function. The message should end in newline.
|
|
Invoke notice processor function. The message should end in newline.
|
|
Set callback method for postgresql status output. return value is the previous handler. Passing a NULL callback pointer simply returns the existing callback. The callback must have C linkage. |
|
Set handler for postgresql errors or warning messages. Return value is the previous handler. Must not be NULL.
|
|
Enable tracing to a given output stream, or NULL to disable.
|
|
Disable tracing.
|
|
Database user ID we're connected under, if any.
|
|
|
|
|