HNumHash Class Reference

#include <datalib.h>

Inheritance diagram for HNumHash:

Public Member Functions
	HNumHash (QString sqlc, QString ex, QString tit, QString t, QString def, QStringList k, QStringList v)
	HNumHash (HNumHash *t)
	~HNumHash ()
virtual QVariant	dbValueToDispValue (QVariant v)
void	deepcopy_from (HNumHash *x)
virtual HDataField *	get_clone (void)
QString	getKeyOfValue (QString s)
virtual QString	getSQLValue (void)
virtual QString	getSQLValueAsString (void)
virtual QVariant	getValue (void)
QString	getValueOfKey (QString s)
virtual int	setDefval (QVariant v)
virtual int	setValue (QVariant v, bool sdisabled=false)
virtual QString	sqlCreateStringPart (QString switches="")
virtual QString	sqlInsertHead (void)
virtual QString	sqlInsertValue (void)
virtual QString	sqlSelectHead (void)
virtual QString	sqlUpdate (void)
Public Member Functions inherited from HDataField
	HDataField (QString _sqlColumn, QString _explain, QString tit, QString _tailstr="", bool _editable=true)
	HDataField (HDataField *t)
	~HDataField (void)
virtual bool	acceptFunction (void)
virtual bool	acceptSubselect (void)
void	addMark (QString mark)
void	addMark (QStringList pmarkers)
void	addNotValidValue (QString v)
void	addRole (HDataFieldRole role)
QStringList	allMarker (void)
HDataField *	asColored (int r, int g, int b)
HDataField *	asConstant (void)
HDataField *	asHide (void)
void	clearMarkers (void)
void	clearNotValidValues (void)
void	clearRoles (void)
void	clearSqlSynced (void)
void	deepcopy_from_hdatafield (HDataField *x)
QVariant	defvalParser (QString s)
void	delRole (QString name)
void	doSet (void)
int	editBoxMaxWidth (void)
int	getBColor (void)
QString	getDefaultValue (void)
virtual QVariant	getDispValue ()
QString	getExplainText (void)
QString	getFunction (void)
int	getGColor (void)
bool	getLastValidateStatus ()
bool	getPermanentValidateStatus ()
int	getPrintCellWidth (void)
int	getRColor (void)
QString	getSpecDisplaySortMode (void)
QString	getSubselect (void)
QString	getTailText (void)
QString	getTitleText (void)
bool	hasMark (QString mark)
bool	isEditable (void)
bool	isGuienabled (void)
bool	isLogged (void)
bool	isMeldedWithNext (void)
bool	isNoMiddleStretch (void)
bool	isPrintCellWrap (void)
bool	isReallyChanged (void)
bool	isSet (void)
bool	isShow (void)
bool	isSQLField (void)
virtual QString	lowerValidate (void)
void	meldWithNext (void)
void	noMiddleStretch (void)
void	notSet (void)
void	resetFunction (void)
void	resetLogging (void)
void	resetMeldWithNext (void)
void	resetNoMiddleStretch (void)
void	resetSubselect (void)
void	resetValidateStatus ()
int	returnToDefault (void)
void	setColor (int r, int g, int b)
void	setData (QString _sqlColumn, QString _explain, QString tit, QString _tailstr="", bool _editable=true)
void	setEditable (void)
void	setEditBoxMaxWidth (int max)
void	setExplainText (QString expl)
void	setFunction (QString func)
void	setGuidisabled (void)
void	setGuienabled (void)
void	setHide (void)
void	setLogging (void)
void	setMaulallyValidateError (QString message)
void	setNotValidValues (QStringList nvl)
void	setPrintCellNoWrap (void)
void	setPrintCellWidth (int w)
void	setPrintCellWrap (void)
void	setReadonly (void)
void	setShow (void)
void	setSpecDisplaySortMode (QString m)
void	setSubselect (QString subs)
void	setTailText (QString tail)
void	setTitleText (QString titl)
void	setValidator (QString v="")
void	sqlSynced (HDataChangeLogger *dclog=NULL, bool forcechange=false, bool forcelog=false)
void	useRole (QString name)
QString	validate (void)
virtual void	value_changed ()
Public Member Functions inherited from HSqlHandler
	HSqlHandler (void)
	~HSqlHandler (void)
QSqlQuery *	allocateQSqlQuery (void)
void	cloneSqlSettingsFrom (HSqlHandler *other)
void	commit (void)
bool	errorStatus (void)
void	rollback (void)
bool	submit0ResultQuery (QString q, QString err, bool tdisabled=false)
QVariant	submit1ResultQuery (QString q, QString err, bool tdisabled=false)
HPlainDataMatrix *	submitNResultQuery (int N, QString q, QString err, bool tdisabled=false)
void	transaction (void)
QSqlDatabase	workDB (void)
Public Member Functions inherited from HSqlInterface
	HSqlInterface ()
	~HSqlInterface ()
void	cloneSqlInterfaceSettingsFrom (HSqlInterface *other)
HSqlSingleInterface *	myInterface (void)
QString	sqlConcatenateToLocal (QString string)
QString	sqlConcatenateToLocal (QStringList fields)
Public Member Functions inherited from HBase
	HBase (void)
	~HBase (void)
QString	getWhoami (void)

Public Attributes
QStringList	keys
QStringList	values
Public Attributes inherited from HDataField
QString	conn_sqlTable
bool	connected

Protected Attributes
int	value
Protected Attributes inherited from HDataField
int	color_b
int	color_g
int	color_r
QString	defval
QString	derived
bool	editable
int	editboxmaxwidth
QString	explain
QString	function
bool	guienabled
bool	lastvalidate_result
bool	logged
QString	manual_validate_error
QStringList	markers
bool	meldwithnext
bool	nomiddlestretch
QStringList	notvalid
bool	permanentvalidate_result
QList< HDataFieldRole >	roles
int	set
bool	show
QString	spec_disp_sort
bool	sql
QString	sqlColumn
bool	sync_valueInSql
QString	tailstr
QString	title
QString	valid
QString	valueInSql
bool	wcell_print
int	wcellw_print
Protected Attributes inherited from HSqlHandler
bool	query_error_occured
Protected Attributes inherited from HBase
QString	whoami

Additional Inherited Members
Public Slots inherited from HDataField
void	disableControlSlot (void)
void	enableControlSlot (void)
Signals inherited from HDataField
void	dataChanged (void)
void	disableControl (void)
void	enableControl (void)
void	updateStaticDisplayElementsSignal (void)
Signals inherited from HSqlHandler
void	errorSignal (QString err)
Static Public Member Functions inherited from HSqlHandler
static void	setCustomSqlDatabase (QString databaseName, QString sqlinterfacename="")
static void	setDefaultSqlDatabase (void)
Static Public Member Functions inherited from HSqlInterface
static HSqlSingleInterface *	currentDefaultSqlInterface (void)
static HSqlSingleInterface *	getSqlInterface (QString interfacename)
static void	setSqlMode (QString modename)
static void	setSqlModeBackToFirst (void)
Static Public Attributes inherited from HSqlHandler
static int	trans = 0

Detailed Description

This is a field type class.
HNumHash holds one value of list of acceptable values. This represent as a numeric value in the sql database. You have to define key-value pairs of the selectable items. The user will see only the values in the gui, but the database will contain only the correspondig numeric key value.
For example the key - pair values can be:

• "1" - "Animals"
• "2" - "Plants"
• "3" - "Objects"
  
  Gui appearance: Combobox, which shows the values, and you can select what you like. (QComboBox)

Definition at line 2844 of file datalib.h.

Constructor & Destructor Documentation

HNumHash::HNumHash	(	QString	sqlc,
		QString	ex,
		QString	tit,
		QString	t,
		QString	def,
		QStringList	k,
		QStringList	v
	)

Creates a HNumHash field.

Parameters

sqlc	the sql name of the field
ex	the explain text of the field
tit	the title text of the field
t	the tail string of the field
def	the default text of the field
k	the keys of the numhash Have to be numeric values. (Can convert to int) "1"
v	the values of the numhash

Definition at line 6149 of file datalib.cpp.

HNumHash::~HNumHash

(

void

)

Destructor

Definition at line 6163 of file datalib.cpp.

HNumHash::HNumHash

(

HNumHash *

t

)

Deepcopy constructor

Definition at line 6168 of file datalib.cpp.

Member Function Documentation

QVariant HNumHash::dbValueToDispValue ( QVariant  v )

virtual

Converting function, you can give a HDataFiled(or descendant) value to this function, and you get the corresponding sql value of the given value.
This function usally redefined in descendats!
In simple typed fields this function do a trivial conversion for example a text field do "text"->"'text'" conversion. Other cases where the field is more complex (HSqlChoose for example) this conversion can be more complex.

In HSqlChoose can be:
"Joe Black" -> "id_0123"
"Little Richard" -> "id_03453"
"John Wayne" -> "id_0197"
etc...


In a HCharHash the result can be:
"Animal" -> "a"
"Plant" -> "p"
"Objects" -> "o"
etc...

Reimplemented from HDataField.

Definition at line 6186 of file datalib.cpp.

void HNumHash::deepcopy_from

(

HNumHash *

x

)

Deepcopy from the given parameter

Definition at line 6174 of file datalib.cpp.

HDataField * HNumHash::get_clone ( void  )

virtual

Returns a clone of this field

Reimplemented from HDataField.

Definition at line 6181 of file datalib.cpp.

QString HNumHash::getKeyOfValue

(

QString

s

)

Returns the correspond key of a given value.

Definition at line 6191 of file datalib.cpp.

QString HNumHash::getSQLValue ( void  )

virtual

Returns the value of the field in that format which accepted by the sql database.

Reimplemented from HDataField.

Definition at line 6223 of file datalib.cpp.

QString HNumHash::getSQLValueAsString ( void  )

virtual

Returns string format of the field's value. Very similar to getSQLValue() but the result is always acceptable in an sql varchar field. (Mostly used by the logger system, when every kind of values are stored in varchar. The gsafe try to keep the value as close to the original sql database value as possible)

Reimplemented from HDataField.

Definition at line 6228 of file datalib.cpp.

QVariant HNumHash::getValue ( void  )

virtual

Returns the value of the field.

Reimplemented from HDataField.

Definition at line 6218 of file datalib.cpp.

QString HNumHash::getValueOfKey

(

QString

s

)

Returns the correspond value of a given value.

Definition at line 6196 of file datalib.cpp.

int HNumHash::setDefval ( QVariant  v )

virtual

Sets the default value of the field.

Returns

0 if success.

Reimplemented from HDataField.

Definition at line 6211 of file datalib.cpp.

int HNumHash::setValue ( QVariant  v, bool  sdisabled = false  )

virtual

Sets the value of the field.

Parameters

sdisabled

if this parameter is true the dataChanged() signal is disabled

Returns

0 if success.

Reimplemented from HDataField.

Definition at line 6201 of file datalib.cpp.

QString HNumHash::sqlCreateStringPart ( QString  switches = "" )

virtual

Returns the part of the CREATE TABLE sql command which creates this field

Reimplemented from HDataField.

Definition at line 6256 of file datalib.cpp.

QString HNumHash::sqlInsertHead ( void  )

virtual

Returns the sql name of the field (in insert) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6233 of file datalib.cpp.

QString HNumHash::sqlInsertValue ( void  )

virtual

Returns the sql value of the field (in insert) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6238 of file datalib.cpp.

QString HNumHash::sqlSelectHead ( void  )

virtual

Returns the sql name of the field (in select) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6250 of file datalib.cpp.

QString HNumHash::sqlUpdate ( void  )

virtual

Returns the sql update part of the field ( name='VALUE' ) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6243 of file datalib.cpp.

Member Data Documentation

QStringList HNumHash::keys

The keys of the HNumHash. Have to be numeric values. (Can convert to int) "1"

Definition at line 2853 of file datalib.h.

QStringList HNumHash::values

The values of the HNumHash

Definition at line 2855 of file datalib.h.

---

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

• datalib.h
• datalib.cpp