com.hume.datahub

Class HubTableRow

Object

HubTableRow

All Implemented Interfaces:

Cloneable, Comparable<HubTableRow>

Direct Known Subclasses:

TableRowSchema, TableRowSub

public abstract class HubTableRow
extends Object
implements Cloneable, Comparable<HubTableRow>

HubTableRow is the base class for Datahub table rows.

Specific table row classes are generated based on the table schema specified in the SQL create statement.

A java user can extend a specific table row class with his own data items and his own methods. The specific table row classes are NOT declared final.

Field Summary

Fields

Modifier and Type	Field and Description
static char	keySep The separation character for composite key values.

Constructor Summary

Constructors

Constructor and Description
HubTableRow()

Method Summary

Methods

Modifier and Type	Method and Description
HubTableRow	clone() The table needs to create rows without coding with the class name.
int	compareTo(HubTableRow o) compareTo gets replaced in derived classes.
String	csvFieldValue(HubTableColumn tc) obtain a value for Comma Separated Value (CSV) export
boolean	fieldCompare(HubTableColumn tc, HubTableRow row) Compare a column value in this row to the value in another row
String	fieldValue(HubTableColumn tc, boolean quotedStrings) SQL scripting method used to obtain a value
abstract HubTableColumn[]	getCols() obtain the columns of the table
abstract String	getKey() obtain the primary composite key (PCK) value
abstract HubTableColumn[]	getKeyCols() obtain the key columns of the table
String	getStringAt(int col) Obtain a field value.
Object	getValueAt(int col) Obtain a field value.
String	getWhereClause() a where clause for this row
void	lappend(ListBuilder list, HubTableColumn tc) A value access method used to append a value to a value list
boolean	setValueAt(HubTableColumn htc, String value) Set a field value.
boolean	setValueAt(int col, String value) Set a field value.
String	toCsv() the Comma Separated Value of this row
String	toString() A simple name=value[, name=value]* display useful for logging and debugging
static String	varchar(String s, int maxlen) Used to truncate string values to the declared field length

Methods inherited from class Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

keySep

public static final char keySep

The separation character for composite key values. The key value for a row is formed by concatenating each key field value in sequence with this character between the field values.

See Also:

Constant Field Values

Constructor Detail

HubTableRow

public HubTableRow()

Method Detail

clone

public HubTableRow clone()

The table needs to create rows without coding with the class name. New rows for the table are created by cloning.

A java user can pass a row for inserting or update which may not have proper values so we are filtering.

Overrides:

clone in class Object

compareTo

public int compareTo(HubTableRow o)

compareTo gets replaced in derived classes.

Selection results are returned in natural sorted order without explicit sorting. However, the natural sorted order has numeric values sorted as text.

A selection result can be explicitly sorted to fix the text sorting of numeric values; (1,10,2,20) becomes (1,2,10,20).

Specified by:

compareTo in interface Comparable<HubTableRow>

csvFieldValue

public String csvFieldValue(HubTableColumn tc)

obtain a value for Comma Separated Value (CSV) export

fieldCompare

public boolean fieldCompare(HubTableColumn tc,
                   HubTableRow row)

Compare a column value in this row to the value in another row

Parameters:

tc - column

row -

Returns:

true if the field value of this row differs from the value in the row argument

fieldValue

public String fieldValue(HubTableColumn tc,
                boolean quotedStrings)

SQL scripting method used to obtain a value

getCols

public abstract HubTableColumn[] getCols()

obtain the columns of the table

getKey

public abstract String getKey()

obtain the primary composite key (PCK) value

getKeyCols

public abstract HubTableColumn[] getKeyCols()

obtain the key columns of the table

getStringAt

public String getStringAt(int col)

Obtain a field value.

Parameters:

col - column index starting from 0

Returns:

field value

getValueAt

public Object getValueAt(int col)

Obtain a field value.

Parameters:

col - column index starting from 0

Returns:

field value as an untyped object

getWhereClause

public String getWhereClause()

a where clause for this row

Returns:

a where clause for this row

lappend

public void lappend(ListBuilder list,
           HubTableColumn tc)

A value access method used to append a value to a value list

setValueAt

public boolean setValueAt(HubTableColumn htc,
                 String value)

Set a field value. The method supports editing dialogs where the values are edited as strings.

Parameters:

htc - column

value - assignment value

Returns:

true for success

setValueAt

public boolean setValueAt(int col,
                 String value)

Set a field value. The method supports editing dialogs where the values are edited as strings.

Parameters:

col - column index starting from 0

value - assignment value

Returns:

true for success

toCsv

public String toCsv()

the Comma Separated Value of this row

Returns:

the Comma Separated Value of this row

toString

public String toString()

A simple name=value[, name=value]* display useful for logging and debugging

Overrides:

toString in class Object

varchar

public static String varchar(String s,
             int maxlen)

Used to truncate string values to the declared field length