tntdb::Statement Class Reference

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

#include <statement.h>

Classes
class	const_iterator
	This class represents a database-cursor. More...
Public Types
typedef IStatement::size_type	size_type
Public Member Functions
	Statement (IStatement *stmt_=0)
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 &	setInt32 (const std::string &col, int32_t data)
	Sets the hostvariable with the given name to a int32_t value.
Statement &	setUnsigned32 (const std::string &col, uint32_t data)
	Sets the hostvariable with the given name to a uint32_t value.
Statement &	setInt64 (const std::string &col, int64_t data)
	Sets the hostvariable with the given name to a int64_t value.
Statement &	setUnsigned64 (const std::string &col, uint64_t data)
	Sets the hostvariable with the given name to a uint64_t value.
Statement &	setDecimal (const std::string &col, const Decimal &data)
	Sets the hostvariable with the given name to a Decimal.
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 &	setBlob (const std::string &col, const Blob &data)
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 ()
	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.


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.
Statement &	set (const std::string &col, const Decimal &data)
	Set the hostvariable with the given name to the passed value.
Statement &	set (const std::string &col, const Blob &data)
	Set the hostvariable with the given name to the passed value.

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

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

This methods creates a cursor and fetches the first row.

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

Sets all hostvariables to NULL.

const_iterator tntdb::Statement::end ( ) const

A empty iterator is returned.

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

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.

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

Returns the actual implementation-class.

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

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

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.

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

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