tntdb::Statement Class Reference

This class represents a sql-statement. More...

#include <statement.h>

List of all members.

Public Types

typedef IStatement::size_type size_type

Public Member Functions

 Statement (IStatement *stmt_=0)
Statementclear ()
 Sets all hostvariables to NULL.
StatementsetNull (const std::string &col)
 Sets the hostvariable with the given name to NULL.
StatementsetBool (const std::string &col, bool data)
 Sets the hostvariable with the given name to a boolean value.
StatementsetInt (const std::string &col, int data)
 Sets the hostvariable with the given name to a int value.
StatementsetUnsigned (const std::string &col, unsigned data)
 Sets the hostvariable with the given name to a unsigned value.
StatementsetInt32 (const std::string &col, int32_t data)
 Sets the hostvariable with the given name to a int32_t value.
StatementsetUnsigned32 (const std::string &col, uint32_t data)
 Sets the hostvariable with the given name to a uint32_t value.
StatementsetInt64 (const std::string &col, int64_t data)
 Sets the hostvariable with the given name to a int64_t value.
StatementsetUnsigned64 (const std::string &col, uint64_t data)
 Sets the hostvariable with the given name to a uint64_t value.
StatementsetDecimal (const std::string &col, const Decimal &data)
 Sets the hostvariable with the given name to a Decimal.
StatementsetFloat (const std::string &col, float data)
 Sets the hostvariable with the given name to a float value.
StatementsetDouble (const std::string &col, double data)
 Sets the hostvariable with the given name to a double value.
StatementsetChar (const std::string &col, char data)
 Sets the hostvariable with the given name to a char value.
StatementsetString (const std::string &col, const std::string &data)
 Sets the hostvariable with the given name to a string value.
StatementsetString (const std::string &col, const char *data)
 Sets the hostvariable with the given name to a string value or null, if passing null-pointer.
StatementsetBlob (const std::string &col, const Blob &data)
StatementsetDate (const std::string &col, const Date &data)
 Sets the hostvariable with the given name to a date value.
StatementsetTime (const std::string &col, const Time &data)
 Sets the hostvariable with the given name to a time value.
StatementsetDatetime (const std::string &col, const Datetime &data)
 Sets the hostvariable with the given name to a datetime value.
size_type execute ()
 statement-execution-methods
Result select ()
 Executes a query, which returns a resultset, with the current parameters.
Row selectRow ()
 Executes a query, which returns a row, with the current parameters.
Value selectValue ()
 Executes a query, which returns a single value, with the current parameters.
const_iterator begin (unsigned fetchsize=100) const
 This methods creates a cursor and fetches the first row.
const_iterator end () const
 A empty iterator is returned.
bool operator! () const
 Returns true, if this class is not connected to a actual statement.
const IStatement * getImpl () const
 Returns the actual implementation-class.
Statementset (const std::string &col, bool data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, int data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, unsigned data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, float data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, double data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, char data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, const char *data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, const std::string &data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, const Date &data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, const Time &data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, const Datetime &data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, const Decimal &data)
 Set the hostvariable with the given name to the passed value.
Statementset (const std::string &col, const Blob &data)
 Set the hostvariable with the given name to the passed value.

Classes

class  const_iterator
 This class represents a database-cursor. More...


Detailed Description

This class represents a sql-statement.

A statement can have parameters, which are referenced by name, called hostvariables. They are prefixed with a colon followed by a name. A name starts with a letter followed by alphanumeric characters or underscore. Hostvariables are not searched in strings (between apostrophes, quotation marks or backticks). The backslash prevents the interpretation of a special meaning of the following character.


Member Function Documentation

Statement& tntdb::Statement::clear (  )  [inline]

Sets all hostvariables to NULL.

Statement& tntdb::Statement::setNull ( const std::string &  col  )  [inline]

Sets the hostvariable with the given name to NULL.

Statement& tntdb::Statement::setBool ( const std::string &  col,
bool  data 
) [inline]

Sets the hostvariable with the given name to a boolean value.

Statement& tntdb::Statement::setInt ( const std::string &  col,
int  data 
) [inline]

Sets the hostvariable with the given name to a int value.

Statement& tntdb::Statement::setUnsigned ( const std::string &  col,
unsigned  data 
) [inline]

Sets the hostvariable with the given name to a unsigned value.

Statement& tntdb::Statement::setInt32 ( const std::string &  col,
int32_t  data 
) [inline]

Sets the hostvariable with the given name to a int32_t value.

Statement& tntdb::Statement::setUnsigned32 ( const std::string &  col,
uint32_t  data 
) [inline]

Sets the hostvariable with the given name to a uint32_t value.

Statement& tntdb::Statement::setInt64 ( const std::string &  col,
int64_t  data 
) [inline]

Sets the hostvariable with the given name to a int64_t value.

Statement& tntdb::Statement::setUnsigned64 ( const std::string &  col,
uint64_t  data 
) [inline]

Sets the hostvariable with the given name to a uint64_t value.

Statement& tntdb::Statement::setDecimal ( const std::string &  col,
const Decimal data 
) [inline]

Sets the hostvariable with the given name to a Decimal.

Statement& tntdb::Statement::setFloat ( const std::string &  col,
float  data 
) [inline]

Sets the hostvariable with the given name to a float value.

Statement& tntdb::Statement::setDouble ( const std::string &  col,
double  data 
) [inline]

Sets the hostvariable with the given name to a double value.

Statement& tntdb::Statement::setChar ( const std::string &  col,
char  data 
) [inline]

Sets the hostvariable with the given name to a char value.

Statement& tntdb::Statement::setString ( const std::string &  col,
const std::string &  data 
) [inline]

Sets the hostvariable with the given name to a string value.

Statement& tntdb::Statement::setString ( const std::string &  col,
const char *  data 
) [inline]

Sets the hostvariable with the given name to a string value or null, if passing null-pointer.

Statement& tntdb::Statement::setDate ( const std::string &  col,
const Date data 
) [inline]

Sets the hostvariable with the given name to a date value.

Statement& tntdb::Statement::setTime ( const std::string &  col,
const Time data 
) [inline]

Sets the hostvariable with the given name to a time value.

Statement& tntdb::Statement::setDatetime ( const std::string &  col,
const Datetime data 
) [inline]

Sets the hostvariable with the given name to a datetime value.

Statement& tntdb::Statement::set ( const std::string &  col,
bool  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
int  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
unsigned  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
float  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
double  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
char  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
const char *  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
const std::string &  data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
const Date data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
const Time data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
const Datetime data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
const Decimal data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

Statement& tntdb::Statement::set ( const std::string &  col,
const Blob data 
) [inline]

Set the hostvariable with the given name to the passed value.

These set-methods choose the right bound type by parametertype.

size_type tntdb::Statement::execute (  ) 

statement-execution-methods

Executes a query with the current parameters. The query should not return results. This method is normally used with INSERT-, UPDATE- or DELETE-statements.

Result tntdb::Statement::select (  ) 

Executes a query, which returns a resultset, with the current parameters.

The query is normally a SELECT-statement.

Row tntdb::Statement::selectRow (  ) 

Executes a query, which returns a row, with the current parameters.

If the query return no rows, a exception of type tntdb::NotFound is thrown. When the query returns more than one row, additional rows are discarded.

Value tntdb::Statement::selectValue (  ) 

Executes a query, which returns a single value, with the current parameters.

If the query return no rows, a exception of type tntdb::NotFound is thrown. Only the first value of the first row is returned.

const_iterator tntdb::Statement::begin ( unsigned  fetchsize = 100  )  const

This methods creates a cursor and fetches the first row.

const_iterator tntdb::Statement::end (  )  const

A empty iterator is returned.

Every const_iterator, which reaches the end is equal with this.

bool tntdb::Statement::operator! (  )  const [inline]

Returns true, if this class is not connected to a actual statement.

const IStatement* tntdb::Statement::getImpl (  )  const [inline]

Returns the actual implementation-class.


The documentation for this class was generated from the following file:

Generated on Mon Jun 16 10:08:35 2008 for tntdb by  doxygen 1.5.6