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 (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.
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 ( 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

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::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.

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

Starts a transaction.

This function starts a transaction.

Implements Wt::Dbo::SqlConnection.

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

Commits a transaction.

This function commits a transaction.

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.

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

Prepares a statement.

Returns the prepared statement.

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.

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.

const char * Wt::Dbo::backend::Postgres::dateTimeType ( SqlDateTimeType  type  )  const [virtual]

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


Generated on Thu May 20 18:14:52 2010 for Wt by doxygen 1.5.6