tntdb::Statement Class Reference

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

#include <statement.h>

List of all members.

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.