SqlDB::DatabaseTable Class Reference

A Database where each row has a unique id. A row is never deleted, by a new row is added where entryidcol is set to the id of the row it is replacing, and a timestamp will tell which row that is the current. More...

#include <sqldbobject.h>

Public Types
enum	TableStatus { OK , MinorError , MajorError , AccessError }

Public Member Functions
	DatabaseTable (const char *tablename)
	~DatabaseTable ()
const char *	entryIDSelectString () const
bool	fixTable (Access &, BufferString &errmsg) const
TableStatus	getTableStatus (Access &, BufferString &errmsg) const
	Checks that all columns exist and are of right type.
bool	insertRow (Access &, const BufferStringSet &cols, const BufferStringSet &vals, int entryid, int &rowid, BufferString &errmsg)
bool	parseEntryID (const QueryAccess &, int col, int &id) const
bool	parseRowID (const QueryAccess &, int col, int &id) const
bool	parseTimeStamp (const QueryAccess &, int col, time_t &) const
const char *	rowIDSelectString () const
bool	searchTable (Access &, int entryid, bool onlylatest, TypeSet< int > &rowids, BufferString &errmsg)
virtual const char *	tableName () const
const char *	timeStampSelectString () const

Protected Member Functions
TableStatus	checkTable (bool fix, Access &, BufferString &errmsg) const

Protected Attributes
ObjectSet< DatabaseColumnBase >	columns_
DatabaseColumn< int > *	entryidcolumn_
IDDatabaseColumn *	rowidcolumn_
const BufferString	tablename_
CreatedTimeStampDatabaseColumn *	timestampcolumn_

Friends
class	DatabaseColumnBase

Detailed Description

A Database where each row has a unique id. A row is never deleted, by a new row is added where entryidcol is set to the id of the row it is replacing, and a timestamp will tell which row that is the current.

<>

Member Enumeration Documentation

TableStatus

enum SqlDB::DatabaseTable::TableStatus

Enumerator
OK
MinorError
MajorError
AccessError

Constructor & Destructor Documentation

DatabaseTable()

SqlDB::DatabaseTable::DatabaseTable

(

const char *

tablename

)

~DatabaseTable()

SqlDB::DatabaseTable::~DatabaseTable

(

)

Member Function Documentation

checkTable()

TableStatus SqlDB::DatabaseTable::checkTable ( bool fix, Access & , BufferString & errmsg ) const

protected

entryIDSelectString()

const char * SqlDB::DatabaseTable::entryIDSelectString

(

)

const

fixTable()

bool SqlDB::DatabaseTable::fixTable	(	Access &	,
		BufferString &	errmsg ) const

getTableStatus()

TableStatus SqlDB::DatabaseTable::getTableStatus	(	Access &	,
		BufferString &	errmsg ) const

Checks that all columns exist and are of right type.

insertRow()

bool SqlDB::DatabaseTable::insertRow	(	Access &	,
		const BufferStringSet &	cols,
		const BufferStringSet &	vals,
		int	entryid,
		int &	rowid,
		BufferString &	errmsg )

parseEntryID()

bool SqlDB::DatabaseTable::parseEntryID	(	const QueryAccess &	,
		int	col,
		int &	id ) const

parseRowID()

bool SqlDB::DatabaseTable::parseRowID	(	const QueryAccess &	,
		int	col,
		int &	id ) const

parseTimeStamp()

bool SqlDB::DatabaseTable::parseTimeStamp	(	const QueryAccess &	,
		int	col,
		time_t &	) const

rowIDSelectString()

const char * SqlDB::DatabaseTable::rowIDSelectString

(

)

const

searchTable()

bool SqlDB::DatabaseTable::searchTable	(	Access &	,
		int	entryid,
		bool	onlylatest,
		TypeSet< int > &	rowids,
		BufferString &	errmsg )

tableName()

virtual const char * SqlDB::DatabaseTable::tableName ( ) const

inlinevirtual

timeStampSelectString()

const char * SqlDB::DatabaseTable::timeStampSelectString

(

)

const

Friends And Related Symbol Documentation

DatabaseColumnBase

friend class DatabaseColumnBase

friend

Member Data Documentation

columns_

ObjectSet<DatabaseColumnBase> SqlDB::DatabaseTable::columns_

protected

entryidcolumn_

DatabaseColumn<int>* SqlDB::DatabaseTable::entryidcolumn_

protected

rowidcolumn_

IDDatabaseColumn* SqlDB::DatabaseTable::rowidcolumn_

protected

tablename_

const BufferString SqlDB::DatabaseTable::tablename_

protected

timestampcolumn_

CreatedTimeStampDatabaseColumn* SqlDB::DatabaseTable::timestampcolumn_

protected