Public Member Functions

Wt::Dbo::backend::Postgres Class Reference
[Database Objects (Dbo)]

A PostgreSQL connection. More...

#include <Wt/Dbo/backend/Postgres>

Inheritance diagram for Wt::Dbo::backend::Postgres:
Inheritance graph
[legend]

List of all members.

Public Member Functions

 Postgres ()
 Creates new PostgreSQL backend connection.
 Postgres (const std::string &db)
 Opens a new PostgreSQL backend connection.
 Postgres (const Postgres &other)
 Copies a PostgreSQL connection.
 ~Postgres ()
 Destructor.
virtual Postgresclone () const
 Clones the connection.
bool connect (const std::string &db)
 Tries to connect.
PGconn * connection ()
 Returns the underlying connection.
virtual void executeSql (const std::string &sql)
 Executes an SQL statement.
virtual void startTransaction ()
 Starts a transaction.
virtual void commitTransaction ()
 Commits a transaction.
virtual void rollbackTransaction ()
 Rolls back a transaction.
virtual SqlStatementprepareStatement (const std::string &sql)
 Prepares a statement.
Methods that return dialect information
virtual std::string autoincrementSql () const
 Returns the 'autoincrement' SQL type modifier.
virtual std::string autoincrementType () const
 Returns the 'autoincrement' SQL type.
virtual std::string autoincrementInsertSuffix () const
 Returns the suffix for an 'autoincrement' insert statement.
virtual const char * dateTimeType (SqlDateTimeType type) const
 Returns the date/time type.
virtual const char * blobType () const
 Returns the blob type.

Detailed Description

A PostgreSQL connection.

This class provides the backend implementation for PostgreSQL databases.


Constructor & Destructor Documentation

Wt::Dbo::backend::Postgres::Postgres (  )

Creates new PostgreSQL backend connection.

The connection is not yet open, and requires a connect() before it can be used.

Wt::Dbo::backend::Postgres::Postgres ( const std::string &  db )

Opens a new PostgreSQL backend connection.

The db may be any of the values supported by PQconnectdb().

Wt::Dbo::backend::Postgres::~Postgres (  )

Destructor.

Closes the connection.


Member Function Documentation

std::string Wt::Dbo::backend::Postgres::autoincrementInsertSuffix (  ) const [virtual]

Returns the suffix for an 'autoincrement' insert statement.

This is appended to the insert statement, since some back-ends need to be indicated that they should return the autoincrement id.

Implements Wt::Dbo::SqlConnection.

std::string Wt::Dbo::backend::Postgres::autoincrementSql (  ) const [virtual]

Returns the 'autoincrement' SQL type modifier.

This is used by Session::createTables() to create the id column.

Implements Wt::Dbo::SqlConnection.

std::string Wt::Dbo::backend::Postgres::autoincrementType (  ) const [virtual]

Returns the 'autoincrement' SQL type.

This is used by Session::createTables() to create the id column.

Implements Wt::Dbo::SqlConnection.

const char * Wt::Dbo::backend::Postgres::blobType (  ) const [virtual]
Postgres * Wt::Dbo::backend::Postgres::clone (  ) const [virtual]

Clones the connection.

Returns a new connection object that is configured like this object. This is used by connection pool implementations to create its connections.

Implements Wt::Dbo::SqlConnection.

void Wt::Dbo::backend::Postgres::commitTransaction (  ) [virtual]

Commits a transaction.

This function commits a transaction.

Implements Wt::Dbo::SqlConnection.

bool Wt::Dbo::backend::Postgres::connect ( const std::string &  db )

Tries to connect.

Throws an exception if there was a problem, otherwise true.

const char * Wt::Dbo::backend::Postgres::dateTimeType ( SqlDateTimeType  type ) const [virtual]
void Wt::Dbo::backend::Postgres::executeSql ( const std::string &  sql ) [virtual]

Executes an SQL statement.

This is a convenience method for preparing a statement, executing it, and deleting it.

Reimplemented from Wt::Dbo::SqlConnection.

SqlStatement * Wt::Dbo::backend::Postgres::prepareStatement ( const std::string &  sql ) [virtual]

Prepares a statement.

Returns the prepared statement.

Implements Wt::Dbo::SqlConnection.

void Wt::Dbo::backend::Postgres::rollbackTransaction (  ) [virtual]

Rolls back a transaction.

This function rolls back a transaction.

Implements Wt::Dbo::SqlConnection.

void Wt::Dbo::backend::Postgres::startTransaction (  ) [virtual]

Starts a transaction.

This function starts a transaction.

Implements Wt::Dbo::SqlConnection.

 All Classes Namespaces Functions Variables Typedefs Enumerations Enumerator

Generated on Fri Feb 4 2011 for the C++ Web Toolkit (Wt) by doxygen 1.7.2