#include <statement.h>
Public Member Functions | |
Statement & | clear () |
Sets all hostvariables to NULL. | |
Statement & | setNull (const std::string &col) |
Sets the hostvariable with the given name to NULL. | |
Statement & | setBool (const std::string &col, bool data) |
Sets the hostvariable with the given name to a boolean value. | |
Statement & | setInt (const std::string &col, int data) |
Sets the hostvariable with the given name to a int value. | |
Statement & | setUnsigned (const std::string &col, unsigned data) |
Sets the hostvariable with the given name to a unsigned value. | |
Statement & | setFloat (const std::string &col, float data) |
Sets the hostvariable with the given name to a float value. | |
Statement & | setDouble (const std::string &col, double data) |
Sets the hostvariable with the given name to a double value. | |
Statement & | setChar (const std::string &col, char data) |
Sets the hostvariable with the given name to a char value. | |
Statement & | setString (const std::string &col, const std::string &data) |
Sets the hostvariable with the given name to a string value. | |
Statement & | setString (const std::string &col, const char *data) |
Sets the hostvariable with the given name to a string value or null, if passing null-pointer. | |
Statement & | setDate (const std::string &col, const Date &data) |
Sets the hostvariable with the given name to a date value. | |
Statement & | setTime (const std::string &col, const Time &data) |
Sets the hostvariable with the given name to a time value. | |
Statement & | setDatetime (const std::string &col, const Datetime &data) |
Sets the hostvariable with the given name to a datetime value. | |
size_type | execute () |
Executes a query with the current parameters. | |
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. | |
Statement & | set (const std::string &col, bool data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, int data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, unsigned data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, float data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, double data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, char data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, const char *data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, const std::string &data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, const Date &data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, const Time &data) |
Set the hostvariable with the given name to the passed value. | |
Statement & | set (const std::string &col, const Datetime &data) |
Set the hostvariable with the given name to the passed value. | |
Classes | |
class | const_iterator |
This class represents a database-cursor. More... |
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.
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::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.
Sets the hostvariable with the given name to a date value.
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.
Set the hostvariable with the given name to the passed value.
These set-methods choose the right bound type by parametertype.
Set the hostvariable with the given name to the passed value.
These set-methods choose the right bound type by parametertype.
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 | ( | ) |
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.