SqlDB::QueryAccess Class Reference

Execution of SQL Query. More...

#include <sqldbaccess.h>

Inheritance diagram for SqlDB::QueryAccess:

Public Member Functions
virtual	~QueryAccess ()
bool	commit ()
virtual BufferString	data (int) const =0
bool	deleteInfo (const char *tablenm, const char *fldnm, int id)
virtual double	dValue (int) const =0
virtual BufferString	errMsg () const =0
virtual bool	execute (const char *)=0
virtual void	finish () const =0
virtual float	fValue (int) const =0
virtual bool	getAllRows (IOPar &) const
BufferString	getCurrentDateTime ()
BufferString	getUpdateString (const BufferStringSet &colnms, const BufferStringSet &values, const BufferString &tablenm, int bugid) const
virtual od_int64	i64Value (int) const =0
bool	insert (const BufferStringSet &colnms, const BufferStringSet &values, const BufferString &tablenm)
virtual bool	isActive () const =0
virtual bool	isNull (int) const =0
virtual bool	isOK () const
virtual bool	isTrue (int) const =0
virtual int	iValue (int) const =0
virtual bool	next () const =0
bool	rollback ()
virtual int	size () const =0
bool	startTransaction ()
virtual od_uint64	ui64Value (int) const =0
virtual unsigned int	uiValue (int) const =0
bool	update (const BufferStringSet &colnms, const BufferStringSet &values, const BufferString &tablenm, int bugid)

Static Public Member Functions
static int	addToColList (BufferStringSet &columns, const char *)
	Returns the column index in the list.
static BufferString	getInsertString (const BufferStringSet &colnms, const BufferStringSet &values, const BufferString &tablenm)
static BufferString	select (const BufferStringSet &colnms, const BufferString &tablenm, const char *condstr)

Protected Member Functions
	QueryAccess ()

Detailed Description

Execution of SQL Query.

<>

Constructor & Destructor Documentation

~QueryAccess()

virtual SqlDB::QueryAccess::~QueryAccess ( )

virtual

QueryAccess()

SqlDB::QueryAccess::QueryAccess ( )

protected

Member Function Documentation

addToColList()

static int SqlDB::QueryAccess::addToColList ( BufferStringSet & columns, const char *  )

static

Returns the column index in the list.

commit()

bool SqlDB::QueryAccess::commit

(

)

data()

virtual BufferString SqlDB::QueryAccess::data ( int ) const

pure virtual

Implemented in SqlDB::Query.

deleteInfo()

bool SqlDB::QueryAccess::deleteInfo	(	const char *	tablenm,
		const char *	fldnm,
		int	id )

dValue()

virtual double SqlDB::QueryAccess::dValue ( int ) const

pure virtual

Implemented in SqlDB::Query.

errMsg()

virtual BufferString SqlDB::QueryAccess::errMsg ( ) const

pure virtual

Implemented in SqlDB::Query.

execute()

virtual bool SqlDB::QueryAccess::execute ( const char * )

pure virtual

Implemented in SqlDB::Query.

finish()

virtual void SqlDB::QueryAccess::finish ( ) const

pure virtual

Implemented in SqlDB::Query.

fValue()

virtual float SqlDB::QueryAccess::fValue ( int ) const

pure virtual

Implemented in SqlDB::Query.

getAllRows()

virtual bool SqlDB::QueryAccess::getAllRows ( IOPar & ) const

inlinevirtual

getCurrentDateTime()

BufferString SqlDB::QueryAccess::getCurrentDateTime

(

)

getInsertString()

static BufferString SqlDB::QueryAccess::getInsertString ( const BufferStringSet & colnms, const BufferStringSet & values, const BufferString & tablenm )

static

getUpdateString()

BufferString SqlDB::QueryAccess::getUpdateString	(	const BufferStringSet &	colnms,
		const BufferStringSet &	values,
		const BufferString &	tablenm,
		int	bugid ) const

i64Value()

virtual od_int64 SqlDB::QueryAccess::i64Value ( int ) const

pure virtual

Implemented in SqlDB::Query.

insert()

bool SqlDB::QueryAccess::insert	(	const BufferStringSet &	colnms,
		const BufferStringSet &	values,
		const BufferString &	tablenm )

isActive()

virtual bool SqlDB::QueryAccess::isActive ( ) const

pure virtual

Implemented in SqlDB::Query.

isNull()

virtual bool SqlDB::QueryAccess::isNull ( int ) const

pure virtual

Implemented in SqlDB::Query.

isOK()

virtual bool SqlDB::QueryAccess::isOK ( ) const

inlinevirtual

Reimplemented in SqlDB::Query.

isTrue()

virtual bool SqlDB::QueryAccess::isTrue ( int ) const

pure virtual

Implemented in SqlDB::Query.

iValue()

virtual int SqlDB::QueryAccess::iValue ( int ) const

pure virtual

Implemented in SqlDB::Query.

next()

virtual bool SqlDB::QueryAccess::next ( ) const

pure virtual

Implemented in SqlDB::Query.

rollback()

bool SqlDB::QueryAccess::rollback

(

)

select()

static BufferString SqlDB::QueryAccess::select ( const BufferStringSet & colnms, const BufferString & tablenm, const char * condstr )

static

size()

virtual int SqlDB::QueryAccess::size ( ) const

pure virtual

Implemented in SqlDB::Query.

startTransaction()

bool SqlDB::QueryAccess::startTransaction

(

)

ui64Value()

virtual od_uint64 SqlDB::QueryAccess::ui64Value ( int ) const

pure virtual

Implemented in SqlDB::Query.

uiValue()

virtual unsigned int SqlDB::QueryAccess::uiValue ( int ) const

pure virtual

Implemented in SqlDB::Query.

update()

bool SqlDB::QueryAccess::update	(	const BufferStringSet &	colnms,
		const BufferStringSet &	values,
		const BufferString &	tablenm,
		int	bugid )