aDataTable Class Reference

#include <asqltable.h>

Inheritance diagram for aDataTable:

Public Member Functions
	aSQLTable (aCfgItem context, aDatabase *adb)
	aSQLTable (const QString &tname, aDatabase *adb)
void	init (aCfgItem context, aDatabase *adb)
void	setObject (aCfgItem context)
void	appendField (aSQLField *fieldinfo)
void	insertField (int pos, aSQLField *fieldinfo)
void	removeField (int pos)
void	clearFields ()
bool	checkStructure (bool update)
long	getMdObjId ()
Q_ULLONG	getIdd ()
void	printRecord ()
virtual QVariant	value (int i)
virtual QVariant	value (const QString &name)
virtual void	setValue (int i, QVariant value)
virtual bool	setValue (const QString &name, QVariant value)
virtual QVariant	sysValue (const QString &name)
virtual void	setSysValue (const QString &name, QVariant value)
virtual bool	sysFieldExists (const QString &name)
virtual QSqlRecord *	primeInsert ()
virtual bool	select (const QString &filter="", bool usefltr=true)
virtual bool	select (Q_ULLONG id)
virtual void	clearFilter ()
virtual bool	setFilter (const QString &name, const QVariant &value)
virtual void	setFilter (const QString &)
virtual QString	getFilter ()
virtual QString	getNFilter ()
virtual bool	exec (QString query)
virtual QStringList	getUserFields ()
virtual ERR_Code	setMarkDeleted (bool Deleted)
virtual bool	isMarkDeleted ()
QString	sqlFieldName (const QString &userFieldName) const
virtual bool	New ()
virtual bool	Copy ()
virtual bool	Delete ()
virtual bool	Update ()
virtual bool	seek (int i, bool relative=FALSE)
virtual bool	next ()
virtual bool	prev ()
virtual bool	first ()
virtual bool	last ()

Public Attributes
aDatabase *	db
QString	tableName
bool	selected

Protected Member Functions
QVariant	calcFieldValue (const QString &name)
virtual QVariant	calculateField (const QString &name)
virtual QVariant	calc_obj (int fid, Q_ULLONG idd)
virtual QVariant	calc_rem (int fid, Q_ULLONG id)
void	insertFieldInfo (aCfgItem cobj, bool calculated=true)

Protected Attributes
long	mdobjId

Detailed Description

Provides browsing and editing Ananas's sql tables mantained by Ananas.Designer.

Member Function Documentation

appendField()

void aDataTable::appendField

(

aSQLField *

fieldinfo

)

Stub.

calcFieldValue()

QVariant aDataTable::calcFieldValue ( const QString &  name )

protected

Calculate value object type fields.

References sysFieldExists(), and sysValue().

Referenced by sysValue().

calculateField()

QVariant aDataTable::calculateField ( const QString &  name )

protectedvirtual

Calculate value object type fields.

checkStructure()

bool aDataTable::checkStructure

(

bool

update

)

Stub.

clearFields()

void aDataTable::clearFields

(

)

Stub.

clearFilter()

void aDataTable::clearFilter ( )

virtual

References aLog::print().

Referenced by aObjectList::ClearFilter(), and aObject::clearTFilter().

Copy()

bool aDataTable::Copy ( )

virtual

References setValue().

Referenced by aObject::Copy().

exec()

bool aDataTable::exec ( QString  query )

virtual

Referenced by aDocument::Copy(), and aDocument::New().

getFilter()

QString aDataTable::getFilter ( )

virtual

References aCfg::attr(), and aCfg::find().

Referenced by setFilter().

getIdd()

Q_ULLONG aDataTable::getIdd

(

void

)

Gets metadata object.

getNFilter()

QString aDataTable::getNFilter ( )

virtual

References aCfg::attr(), and aCfg::find().

getUserFields()

QStringList aDataTable::getUserFields ( )

virtual

Gets list of user and calculation fields.

init()

void aDataTable::init	(	aCfgItem	context,
		aDatabase *	adb
	)

Inits table object.

References setObject().

insertField()

void aDataTable::insertField	(	int	pos,
		aSQLField *	fieldinfo
	)

Stub.

isMarkDeleted()

bool aDataTable::isMarkDeleted ( )

virtual

References sysFieldExists(), and sysValue().

primeInsert()

QSqlRecord * aDataTable::primeInsert ( )

virtual

References sysFieldExists(), and aDatabase::uid().

Referenced by aDocJournal::New().

printRecord()

void aDataTable::printRecord

(

)

References value().

removeField()

void aDataTable::removeField

(

int

pos

)

Stub.

select()

bool aDataTable::select ( Q_ULLONG  id )

virtual

setFilter() [1/2]

bool aDataTable::setFilter ( const QString &  name, const QVariant &  value  )

virtual

References getFilter(), aLog::print(), and value().

Referenced by aObjectList::SetFilter(), and aObject::setTFilter().

setFilter() [2/2]

void aDataTable::setFilter ( const QString &  newFilter )

virtual

setMarkDeleted()

ERR_Code aDataTable::setMarkDeleted ( bool  Deleted )

virtual

References setSysValue(), and sysFieldExists().

setObject()

void aDataTable::setObject

(

aCfgItem

context

)

Sets md object to table.

References aCfg::count(), aCfg::find(), aCfg::id(), aCfg::objClass(), aCfg::parent(), and aLog::print().

Referenced by init(), and aObject::tableInsert().

setSysValue()

void aDataTable::setSysValue ( const QString &  name, QVariant  value  )

virtual

References aLog::print(), and value().

Referenced by aObjectList::SetMarkDeleted(), setMarkDeleted(), aObject::SetMarkDeleted(), aObjectList::SetMarked(), aObject::SetMarked(), and aObject::setSysValue().

setValue() [1/2]

void aDataTable::setValue ( int  i, QVariant  value  )

virtual

Set value of the column of the database table.

References value().

Referenced by Copy(), aObject::setTValue(), aObjectList::SetValue(), and aObject::SetValue().

setValue() [2/2]

bool aDataTable::setValue ( const QString &  name, QVariant  value  )

virtual

References value().

sqlFieldName()

QString aDataTable::sqlFieldName

(

const QString &

userFieldName

)

const

Referenced by aExtSQL::SqlFieldName().

sysFieldExists()

bool aDataTable::sysFieldExists ( const QString &  name )

virtual

Return true if column name exists in database table.

Check field existing.

Referenced by calcFieldValue(), aObjectList::IsMarkDeleted(), isMarkDeleted(), aObject::IsMarkDeleted(), aObjectList::IsMarked(), aObject::IsMarked(), primeInsert(), aObjectList::SetMarkDeleted(), setMarkDeleted(), aObject::SetMarkDeleted(), aObjectList::SetMarked(), aObject::SetMarked(), and aObject::sysValue().

sysValue()

QVariant aDataTable::sysValue ( const QString &  name )

virtual

Return value of the column of the database table.

References calcFieldValue().

Referenced by calcFieldValue(), aObjectList::displayString(), aObject::displayString(), aDocJournal::docId(), aDocJournal::findDoc(), aIRegister::GetDocument(), aObjectList::getUid(), aObject::getUid(), aObjectList::IsMarkDeleted(), isMarkDeleted(), aObject::IsMarkDeleted(), aObjectList::IsMarked(), aObject::IsMarked(), aCatGroup::parentUid(), aCatalogue::setMarkDeletedElement(), aObject::sysValue(), aDocument::TableValue(), and value().

value() [1/2]

QVariant aDataTable::value ( int  i )

virtual

Return field falue.

References sysValue().

Referenced by printRecord(), setFilter(), setSysValue(), setValue(), aObject::tValue(), aObjectList::Value(), and aObject::Value().

value() [2/2]

QVariant aDataTable::value ( const QString &  name )

virtual

Return field falue.

References aLog::print(), and sysValue().

---

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

• asqltable.h
• asqltable.cpp