DB::Query Class Reference

#include <db.h>

List of all members.

Public Member Functions
	Query (Connection &conn)
	~Query ()
ACE_INLINE Query &	operator<< (const char *sql)
ACE_INLINE Query &	operator<< (const int val)
ACE_INLINE Query &	operator<< (const long val)
ACE_INLINE Query &	operator<< (const double val)
ACE_INLINE Query &	operator<< (const float val)
ACE_INLINE Query &	operator<< (const short val)
ACE_INLINE Query &	operator<< (const unsigned char *sql)
ACE_INLINE Query &	operator<< (const unsigned int val)
ACE_INLINE Query &	operator<< (const unsigned long val)
ACE_INLINE Query &	operator<< (const unsigned short val)
ACE_INLINE const char *	str (void)
Private Attributes
Connection &	conn_
std::ostrstream	sql_
Friends
Query &	unixtime_impl (Query &Out, const time_t ut)
Query &	qstr_impl (Query &Out, const char *str)

---

Detailed Description

The Query object allows for portable SQL query generation by allowing abstract usage of escaping and date manipulations in addition to easier SQL query generation by the user. An example of usage is:

Query q(connection); // Connection is a pointer

q << "SELECT fld FROM table WHERE fld=" << qstr("rand'data");

std::cout << "SQL: " << q.str() << std::endl;

Definition at line 283 of file db.h.

---

Constructor & Destructor Documentation

DB::Query::Query

(

Connection &

conn

)

[inline]

Buffer used to store the SQL query

Definition at line 290 of file db.h.

: conn_(conn) {}

DB::Query::~Query

(

)

[inline]

Definition at line 291 of file db.h.

References sql_.

{ sql_.freeze(false); }

---

Member Function Documentation

ACE_INLINE Query& DB::Query::operator<<

(

const unsigned short

val

)

[inline]

Definition at line 347 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const unsigned long

val

)

[inline]

Definition at line 341 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const unsigned int

val

)

[inline]

Definition at line 335 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const unsigned char *

sql

)

[inline]

Definition at line 329 of file db.h.

References sql_.

        {
            sql_ << sql;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const short

val

)

[inline]

Definition at line 323 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const float

val

)

[inline]

Definition at line 317 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const double

val

)

[inline]

Definition at line 311 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const long

val

)

[inline]

Definition at line 305 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const int

val

)

[inline]

Definition at line 299 of file db.h.

References sql_.

        {
            sql_ << val;
            return (*this);
        }

ACE_INLINE Query& DB::Query::operator<<

(

const char *

sql

)

[inline]

Definition at line 293 of file db.h.

References sql_.

        {
            sql_ << sql;
            return (*this);
        }

ACE_INLINE const char* DB::Query::str

(

void

)

[inline]

Get the SQL statement string

Returns:

const char*

Definition at line 358 of file db.h.

References sql_.

        {
            sql_ << std::ends;
            return (sql_.str());
        }

---

Friends And Related Function Documentation

Query& qstr_impl	(	Query &	Out,
		const char *	str
	)			[friend]

Definition at line 377 of file db.h.

    {
        const char *buf = Out.conn_.escape(str);
        Out << buf;
        delete [] buf;
        return (Out);
    }

Query& unixtime_impl	(	Query &	Out,
		const time_t	ut
	)			[friend]

Definition at line 369 of file db.h.

    {
        const char *buf = Out.conn_.unixtimeToSql(ut);
        Out << buf;
        delete [] buf;
        return (Out);
    }

---

Member Data Documentation

Connection& DB::Query::conn_ [private]

Definition at line 286 of file db.h.

Referenced by DB::qstr_impl(), and DB::unixtime_impl().

std::ostrstream DB::Query::sql_ [private]

Internal connection object reference

Definition at line 287 of file db.h.

Referenced by operator<<(), str(), and ~Query().

---

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

• db.h

---