com.technia.tvc.core.table

Class TableUtils

java.lang.Object

com.technia.tvc.core.table.TableUtils

public abstract class TableUtils
extends java.lang.Object

Table related utilities

Since:

5.0

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	TableUtils.TableDataCollector Collects affected table data rows.

Constructor Summary

Constructors

Constructor and Description
TableUtils()

Method Summary

Modifier and Type	Method and Description
static java.util.List<StructureBeanNode>	appendNode(StructureBean structure, java.lang.String parentId, java.lang.String relId, java.lang.String childId, boolean isFrom) Returns list of nodes appended to matching parent node.
static StructureBeanNode	appendNode(StructureBean structure, StructureBeanNode node, java.lang.String relId, java.lang.String childId, boolean isFrom) Returns node appended to parent node.
static void	applySame(TableBean<?> origin, TableBean<?> target) Applies the same GUI settings, applied to one table onto another table.
static java.util.List<TableData>	connectNode(TableBean<?> table, java.lang.String parentId, java.lang.String relId, java.lang.String childId, boolean isFrom) Connect the node to the Table (including original tables)
static <T extends TableData> void	ensureAllRowsValidated(TableBean<T> input) Ensures that all rows are validated, e.g.
static <T extends TableData> TableBean<T>	ensureNotPaginated(TableBean<T> input) Returns a TableBean instance that is NOT paginated.
static void	ensureUniqueRowsOnly(TableBean<?> table, boolean ignoreConnectionId) Ensures that there is only one row in the table representing an object OR an object and connection.
static <T extends TableData> void	ensureVisibleRowsValidated(TableBean<T> input)
static void	exportToCSV(TableBean<? extends TableData> table, java.io.Writer writer) Convenience method for exporting a TableBean to the "standard" CSV format.
static void	exportToCSV(TableBean<? extends TableData> table, java.io.Writer writer, char fieldSeparator) Convenience method for exporting a TableBean to the "standard" CSV format.
static java.lang.Object	getAttribute(TableBean<?> table, java.lang.String attributeName)
static java.util.List<java.lang.String>	getAvailableTableNames() Returns an array of available tables, both system tables in the database and tables available as so called resources.
static java.lang.Boolean	getBooleanValue(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.util.List<java.lang.Boolean>	getBooleanValues(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.util.Date	getDateValue(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.util.List<java.util.Date>	getDateValues(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.lang.String[]	getDisplayNames(java.util.Locale locale, java.lang.String[] tableNames) Returns the display names for all the tables.
static java.lang.String[]	getDisplayNames(TableFactory tableFactory, java.util.Locale locale, java.lang.String[] tableNames) Returns the display names for all the tables.
static java.util.List<java.lang.String>	getExistingTableNames(java.lang.String[] tableNames) This method returns the a List containing the table names supplied in the arguments, minus the tables that doesn't exist.
static int	getFixedColumnCount(TableBean<? extends TableData> table) Count number of fixed column among the visible columns
static java.util.Set<java.lang.String>	getIds(TableBean<?> t, boolean objectId) Returns a (unique) set of ID's from a table bean.
static int	getIndexForColumn(Table table, java.lang.String expression, boolean usesBusinessObject)
static java.lang.String	getLabelOrAlt(Column col)
static java.lang.String	getLabelOrAlt(Column col, java.lang.String defaultValue)
static java.lang.Number	getNumberValue(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.util.List<java.lang.Number>	getNumberValues(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.lang.String	getObjectIdForHeader(Environment env) Returns objectId for Header
static java.lang.String[]	getObjectIds(TableBean<?> t) Returns the (unique) object-ids from the TableBean.
static TableBean<?>	getOriginalTable(TableBean<?> table) Deprecated. Use TableBean.getParent()
static java.lang.String[]	getRelationshipIds(TableBean<?> t) Returns the (unique) relationship-ids from the TableBean.
static TableBean<?>	getRootTable(TableBean<?> table)
static java.lang.String	getStringValue(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.util.List<java.lang.String>	getStringValues(TableBean<?> tableBean, TableData tableData, java.lang.String columnName)
static java.util.Iterator<? extends TableData>	getTableData(TableBean<? extends TableData> table, long[] dataIDs) Returns an iterator containing all TableDatas that whose ID is in the specified array.
static java.util.Iterator<? extends TableData>	getTableData(TableBean<? extends TableData> table, java.lang.Long[] dataIDs) Returns an iterator containing all TableDatas that whose ID is in the specified array.
static java.util.Iterator<? extends TableData>	getTableData(TableBean<? extends TableData> table, java.lang.String[] relId, java.lang.String[] objId)
static java.util.Iterator<? extends TableData>	getTableData(TableBean<? extends TableData> table, TableRowIdParam param)
static boolean	hasHiddenColumn(TableBean<? extends TableData> t) Returns true if there is at least one column, which is not visible.
static boolean	hasOriginalTable(TableBean<?> table) Deprecated. Use TableBean.getHasParent()
static boolean	isHTMLCell(Cell cell) Returns true if the cell contains HTML data.
static void	loadInto(TableBean<?> sourceTableBean, TableBean<?> targetTableBean) A utility method for loading data from one tablebean into another.
static void	loadPaginationSettings(PaginatedTableBean<? extends TableData> ptb)
static TableBean<?>	navigate(TableBean<?> original, Environment newEnv, TableData data)
static TableBean<? extends TableData>	newTableBean(com.technia.tvc.core.db.inquiry.Inquiry inquiry, java.lang.String viewName, Environment env, boolean navigate) Evaluate the inquiry into a TableBean and apply the specified view.
static TableBean<? extends TableData>	newTableBean(com.technia.tvc.core.db.inquiry.Inquiry inquiry, View view, Environment env, boolean navigate) Evaluate the inquiry into a TableBean and apply the specified view.
static TableBean<? extends TableData>	newTableBean(com.technia.tvc.core.db.inquiry.Inquiry inquiry, View view, Environment env, boolean navigate, boolean validate) Evaluate the inquiry into a TableBean and apply the specified view.
static TableBean<? extends TableData>	newTableBean(Query query, java.lang.String view, Environment env, boolean navigate) Evaluate the query into a TableBean and apply the specified view.
static TableBean<? extends TableData>	newTableBean(Query query, View view, Environment env, boolean navigate) Evaluate the query into a TableBean and apply the specified view.
static int	remove(TableBean<?> table, java.lang.String objectId)
static int	remove(TableBean<?> table, java.lang.String relationshipId, java.lang.String objectId)
static java.lang.Object	removeAttribute(TableBean<?> table, java.lang.String attributeName)
static java.util.List<TableData>	removeNodes(TableBean<?> table, java.util.Collection<java.lang.String> relIds, java.util.Collection<java.lang.String> objectIds) Removes matching nodes (including original tables)
static void	removeOriginalTable(TableBean<?> table) Deprecated. Use TableBean.removeParent()
static void	removeRootNodes(StructureBean source, CompositeStructureBean target)
static void	removeRows(TableBean<? extends TableData> table) Sets the Row on each TableData to null.
static java.lang.Object	setAttribute(TableBean<?> table, java.lang.String attributeName, java.lang.Object value)
static void	setEvaluationRequired(TableBean<? extends TableData> table, java.lang.String objectId)
static void	setEvaluationRequired(TableBean<? extends TableData> table, java.lang.String[] objectIds)
static void	setEvaluationRequired(TableBean<? extends TableData> table, java.lang.String relationshipId, java.lang.String objectId)
static void	setEvaluationRequired(TableBean<? extends TableData> table, TableRowIdParam param) Set a flag that indicates that these rows will be reloaded the next time the TableBean is evaluated.
static void	setExpandable(StructureBean str, boolean expandable)
static void	setExpandable(StructureBeanNode node, boolean expandable, boolean deep)
static void	setHighlighted(java.util.Iterator<? extends TableData> dataItr, boolean highlight) Highlights or UnHighlights Nodes
static void	setHighlighted(TableBean<? extends TableData> table, java.lang.String objectId) Set the highlighted flag on the rows having the object id
static void	setHighlighted(TableBean<? extends TableData> table, TableRowIdParam param) Set the highlighted flag on these rows.
static void	setOriginalTable(TableBean<?> table, TableBean<?> original) Deprecated. Use TableBean.setParent(TableBean)
static void	setSelected(TableBean<? extends TableData> table, TableRowIdParam param) Set the selected flag on these rows.
static void	setStructureValid(java.util.Iterator<StructureBeanNode> nodes, boolean structureValid) Sets whether the structure below the node(s) is valid or not.
static void	setTableDataFlags(java.util.Iterator<? extends TableData> tableData, boolean evaluationRequired, boolean selected, boolean highlighted) Set the flags that are true.
static void	setTableDataFlags(TableBean<? extends TableData> table, java.lang.String relId, java.lang.String objectId, boolean evaluationRequired, boolean selected, boolean highlighted) Set the flags that are true.
static void	setTableDataFlags(TableBean<? extends TableData> table, TableRowIdParam param, boolean evaluationRequired, boolean selected, boolean highlighted) Set the flags that are true.
static StructureBean	toStructureBean(TableBean<? extends TableData> table) Converts a table into a structure
static void	unsetHighlighted(EditableTableBean<?> t) Unsets the highlighted flag on all rows.
static void	unsetHighlighted(TableBean<? extends TableData> table, TableRowIdParam param) Unset the highlighted flag on these rows.
static void	unsetSelected(TableBean<? extends TableData> table, TableRowIdParam param) Unset the selected flag on these rows.
static void	unsetSelectedAndHighlighted(TableBean<? extends TableData> table, TableRowIdParam param) Unset the selected and the highlighted flag on these rows.
static void	unsetTableDataFlags(TableBean<? extends TableData> table, TableRowIdParam param, boolean evaluationRequired, boolean selected, boolean highlighted) Unset the flags that are true.
static java.util.List<TableData>	updateNodes(TableBean<?> table, java.util.Collection<java.lang.String> relIds, java.util.Collection<java.lang.String> objectIds) Updates matching nodes (including original tables)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TableUtils

public TableUtils()

Method Detail

setOriginalTable

@Deprecated
public static void setOriginalTable(TableBean<?> table,
                                                TableBean<?> original)

Deprecated. Use TableBean.setParent(TableBean)

Parameters:

table -

original -

See Also:

TableBean.setParent(TableBean)

getOriginalTable

@Deprecated
public static TableBean<?> getOriginalTable(TableBean<?> table)

Deprecated. Use TableBean.getParent()

Parameters:

table -

Returns:

The parent/original table

See Also:

TableBean.getParent()

hasOriginalTable

@Deprecated
public static boolean hasOriginalTable(TableBean<?> table)

Deprecated. Use TableBean.getHasParent()

Parameters:

table -

Returns:

True if the table has a parent/original tablebean set.

See Also:

TableBean.getHasParent()

removeOriginalTable

@Deprecated
public static void removeOriginalTable(TableBean<?> table)

Deprecated. Use TableBean.removeParent()

Parameters:

table -

See Also:

TableBean.removeParent()

getRootTable

public static TableBean<?> getRootTable(TableBean<?> table)

loadPaginationSettings

public static void loadPaginationSettings(PaginatedTableBean<? extends TableData> ptb)

applySame

public static void applySame(TableBean<?> origin,
                             TableBean<?> target)
                      throws TVCException

Applies the same GUI settings, applied to one table onto another table.

The following properties that are copied:

• environment
• choosable views
• menubar

Parameters:

origin - The original tablebean

target - The target tablebean

Throws:

TVCException

getAttribute

public static java.lang.Object getAttribute(TableBean<?> table,
                                            java.lang.String attributeName)

removeAttribute

public static java.lang.Object removeAttribute(TableBean<?> table,
                                               java.lang.String attributeName)

setAttribute

public static java.lang.Object setAttribute(TableBean<?> table,
                                            java.lang.String attributeName,
                                            java.lang.Object value)

getAvailableTableNames

public static java.util.List<java.lang.String> getAvailableTableNames()
                                                               throws TVCException

Returns an array of available tables, both system tables in the database and tables available as so called resources.

Returns:

a string array containing the names of all available system tables.

Throws:

TVCException

getExistingTableNames

public static java.util.List<java.lang.String> getExistingTableNames(java.lang.String[] tableNames)
                                                              throws TVCException

This method returns the a List containing the table names supplied in the arguments, minus the tables that doesn't exist.

Parameters:

tableNames - the table names.

Returns:

a list containing the table names supplied in the arguments, minus the tables that doesn't exist.

Throws:

TVCException

getDisplayNames

public static java.lang.String[] getDisplayNames(java.util.Locale locale,
                                                 java.lang.String[] tableNames)

Returns the display names for all the tables.

Parameters:

locale - The locale of the display names.

tableNames - The actual names of the tables.

Returns:

Returns the display names for the specified tables.

getDisplayNames

public static java.lang.String[] getDisplayNames(TableFactory tableFactory,
                                                 java.util.Locale locale,
                                                 java.lang.String[] tableNames)

Returns the display names for all the tables.

Parameters:

tableFactory - The table factory that will be queried for the display names.

locale - The locale of the display names.

tableNames - The actual names of the tables.

Returns:

Returns the display names for the specified tables.

Since:

6.1.5

exportToCSV

public static void exportToCSV(TableBean<? extends TableData> table,
                               java.io.Writer writer)
                        throws java.io.IOException

Convenience method for exporting a TableBean to the "standard" CSV format. The field separator will be a comma.

Parameters:

table - The table.

writer - The writer to which the CSV file will be written.

Throws:

java.io.IOException - If unable to write the CSV file.

Since:

5.1.1

exportToCSV

public static void exportToCSV(TableBean<? extends TableData> table,
                               java.io.Writer writer,
                               char fieldSeparator)
                        throws java.io.IOException

Convenience method for exporting a TableBean to the "standard" CSV format.

Parameters:

table - The table.

writer - The writer to which the CSV file will be written.

fieldSeparator - The separator char to use between fields (e.g., comma, semi-colon, horizontal-tab).

Throws:

java.io.IOException - If unable to write the CSV file.

Since:

5.1.1

newTableBean

public static TableBean<? extends TableData> newTableBean(Query query,
                                                          java.lang.String view,
                                                          Environment env,
                                                          boolean navigate)
                                                   throws TVCException

Evaluate the query into a TableBean and apply the specified view.

Parameters:

query - The query to execute.

view - The name of the view.

env - The environment.

navigate - Whether to load the result as root nodes into a StructureBean.

Returns:

Returns a TableBean.

Throws:

TVCException - If unable to perform the operation.

Since:

5.2

newTableBean

public static TableBean<? extends TableData> newTableBean(com.technia.tvc.core.db.inquiry.Inquiry inquiry,
                                                          java.lang.String viewName,
                                                          Environment env,
                                                          boolean navigate)
                                                   throws TVCException

Evaluate the inquiry into a TableBean and apply the specified view.

Parameters:

inquiry - The inquiry to execute.

viewName - The name of the view.

env - The environment.

navigate - Whether to load the result as root nodes into a StructureBean.

Returns:

Returns a TableBean.

Throws:

TVCException - If unable to perform the operation.

Since:

5.2

newTableBean

public static TableBean<? extends TableData> newTableBean(Query query,
                                                          View view,
                                                          Environment env,
                                                          boolean navigate)
                                                   throws TVCException

Evaluate the query into a TableBean and apply the specified view.

Parameters:

query - The query to execute.

view - The view.

env - The environment.

navigate - Whether to load the result as root nodes into a StructureBean.

Returns:

Returns a TableBean.

Throws:

TVCException - If unable to perform the operation.

Since:

5.2

newTableBean

public static TableBean<? extends TableData> newTableBean(com.technia.tvc.core.db.inquiry.Inquiry inquiry,
                                                          View view,
                                                          Environment env,
                                                          boolean navigate)
                                                   throws TVCException

Evaluate the inquiry into a TableBean and apply the specified view.

Parameters:

inquiry - The inquiry to execute.

view - The view.

env - The environment.

navigate - Whether to load the result as root nodes into a StructureBean.

Returns:

Returns a TableBean.

Throws:

TVCException - If unable to perform the operation.

Since:

5.2

newTableBean

public static TableBean<? extends TableData> newTableBean(com.technia.tvc.core.db.inquiry.Inquiry inquiry,
                                                          View view,
                                                          Environment env,
                                                          boolean navigate,
                                                          boolean validate)
                                                   throws TVCException

Evaluate the inquiry into a TableBean and apply the specified view.

Parameters:

inquiry - The inquiry to execute.

view - The view.

env - The environment.

navigate - Whether to load the result as root nodes into a StructureBean.

validate - Whether to validate the TableBean.

Returns:

Returns a TableBean.

Throws:

TVCException - If unable to perform the operation.

Since:

5.2

getTableData

public static java.util.Iterator<? extends TableData> getTableData(TableBean<? extends TableData> table,
                                                                   TableRowIdParam param)

Parameters:

table - The table.

param - The row params.

Returns:

The TableData that match the row params.

Since:

5.2

getTableData

public static java.util.Iterator<? extends TableData> getTableData(TableBean<? extends TableData> table,
                                                                   java.lang.String[] relId,
                                                                   java.lang.String[] objId)

Parameters:

table - The table.

relId - The relationship IDs.

objId - The object IDs.

Returns:

The TableData that match the relationship and object IDs.

Since:

5.2

getTableData

public static java.util.Iterator<? extends TableData> getTableData(TableBean<? extends TableData> table,
                                                                   long[] dataIDs)

Returns an iterator containing all TableDatas that whose ID is in the specified array.

Parameters:

table - A table bean.

dataIDs - The data IDs.

Returns:

An iterator with TableDatas.

Since:

2009.1

getTableData

public static java.util.Iterator<? extends TableData> getTableData(TableBean<? extends TableData> table,
                                                                   java.lang.Long[] dataIDs)

Returns an iterator containing all TableDatas that whose ID is in the specified array.

Parameters:

table - A table bean.

dataIDs - The data IDs.

Returns:

An iterator with TableDatas.

Since:

2014.1.0

setEvaluationRequired

public static void setEvaluationRequired(TableBean<? extends TableData> table,
                                         TableRowIdParam param)

Set a flag that indicates that these rows will be reloaded the next time the TableBean is evaluated.

Parameters:

table - The table.

param - The row params.

Since:

5.2

setSelected

public static void setSelected(TableBean<? extends TableData> table,
                               TableRowIdParam param)

Set the selected flag on these rows.

Parameters:

table - The table.

param - The row params.

Since:

5.2

setHighlighted

public static void setHighlighted(java.util.Iterator<? extends TableData> dataItr,
                                  boolean highlight)

Highlights or UnHighlights Nodes

Parameters:

dataItr -

highlight -

Since:

2014.2

setHighlighted

public static void setHighlighted(TableBean<? extends TableData> table,
                                  TableRowIdParam param)

Set the highlighted flag on these rows.

Parameters:

table - The table.

param - The row params.

Since:

5.2

setHighlighted

public static void setHighlighted(TableBean<? extends TableData> table,
                                  java.lang.String objectId)

Set the highlighted flag on the rows having the object id

Parameters:

table -

objectId -

Since:

6.4.0

unsetSelected

public static void unsetSelected(TableBean<? extends TableData> table,
                                 TableRowIdParam param)

Unset the selected flag on these rows.

Parameters:

table - The table.

param - The row params.

Since:

5.2

unsetHighlighted

public static void unsetHighlighted(EditableTableBean<?> t)

Unsets the highlighted flag on all rows.

Parameters:

t - The tablebean

Since:

2011.2.0

unsetHighlighted

public static void unsetHighlighted(TableBean<? extends TableData> table,
                                    TableRowIdParam param)

Unset the highlighted flag on these rows.

Parameters:

table - The table.

param - The row params.

Since:

5.2

unsetSelectedAndHighlighted

public static void unsetSelectedAndHighlighted(TableBean<? extends TableData> table,
                                               TableRowIdParam param)

Unset the selected and the highlighted flag on these rows.

Parameters:

table - The table.

param - The row params.

Since:

5.2

setTableDataFlags

public static void setTableDataFlags(TableBean<? extends TableData> table,
                                     TableRowIdParam param,
                                     boolean evaluationRequired,
                                     boolean selected,
                                     boolean highlighted)

Set the flags that are true.

Parameters:

table - The table.

param - The row params.

evaluationRequired - Whether to set this flag.

selected - Whether to set this flag.

highlighted - Whether to set this flag.

Since:

5.2

setTableDataFlags

public static void setTableDataFlags(TableBean<? extends TableData> table,
                                     java.lang.String relId,
                                     java.lang.String objectId,
                                     boolean evaluationRequired,
                                     boolean selected,
                                     boolean highlighted)

Set the flags that are true.

Parameters:

table - The table

relId - The rel id

objectId - The object id

evaluationRequired - Whether to set this flag.

selected - Whether to set this flag.

highlighted - Whether to set this flag.

Since:

6.4.1

unsetTableDataFlags

public static void unsetTableDataFlags(TableBean<? extends TableData> table,
                                       TableRowIdParam param,
                                       boolean evaluationRequired,
                                       boolean selected,
                                       boolean highlighted)

Unset the flags that are true.

Parameters:

table - The table.

param - The row params.

evaluationRequired - Whether to unset this flag.

selected - Whether to unset this flag.

highlighted - Whether to unset this flag.

Since:

5.2

setTableDataFlags

public static void setTableDataFlags(java.util.Iterator<? extends TableData> tableData,
                                     boolean evaluationRequired,
                                     boolean selected,
                                     boolean highlighted)

Set the flags that are true.

Parameters:

tableData - items

evaluationRequired - Whether to set this flag.

selected - Whether to set this flag.

highlighted - Whether to set this flag.

Since:

6.4.1

getIndexForColumn

public static int getIndexForColumn(Table table,
                                    java.lang.String expression,
                                    boolean usesBusinessObject)

getFixedColumnCount

public static int getFixedColumnCount(TableBean<? extends TableData> table)

Count number of fixed column among the visible columns

setEvaluationRequired

public static void setEvaluationRequired(TableBean<? extends TableData> table,
                                         java.lang.String objectId)

Parameters:

table -

objectId -

Since:

6.0.0

setEvaluationRequired

public static void setEvaluationRequired(TableBean<? extends TableData> table,
                                         java.lang.String[] objectIds)

Parameters:

table -

objectIds -

Since:

6.0.1

setEvaluationRequired

public static void setEvaluationRequired(TableBean<? extends TableData> table,
                                         java.lang.String relationshipId,
                                         java.lang.String objectId)

Parameters:

table -

relationshipId -

objectId -

Since:

6.0.0

setExpandable

public static void setExpandable(StructureBean str,
                                 boolean expandable)

Parameters:

str - The structure

expandable - False for making all nodes un-expandable

Since:

6.3.0

setExpandable

public static void setExpandable(StructureBeanNode node,
                                 boolean expandable,
                                 boolean deep)

Parameters:

node - The node

expandable - False for making the node unexpandable/uncollapsable

deep - True if to set the flag on all descendant child nodes.

Since:

6.3.0

setStructureValid

public static void setStructureValid(java.util.Iterator<StructureBeanNode> nodes,
                                     boolean structureValid)

Sets whether the structure below the node(s) is valid or not.

Parameters:

nodes - The StructureBeanNodes.

structureValid - The structureValid boolean.

Since:

2017.4.0

getLabelOrAlt

public static java.lang.String getLabelOrAlt(Column col)

Parameters:

col - The column

Returns:

The label of the column, or, if the label is empty, the alt text.

Since:

6.1.6

getLabelOrAlt

public static java.lang.String getLabelOrAlt(Column col,
                                             java.lang.String defaultValue)

hasHiddenColumn

public static boolean hasHiddenColumn(TableBean<? extends TableData> t)

Returns true if there is at least one column, which is not visible.

E.g. if the Column.isVisible() returns false.

Parameters:

t - The tablebean

Returns:

True if one column is not visible

Since:

6.2.1

ensureVisibleRowsValidated

public static <T extends TableData> void ensureVisibleRowsValidated(TableBean<T> input)
                                                             throws TVCException

Throws:

TVCException

ensureAllRowsValidated

public static <T extends TableData> void ensureAllRowsValidated(TableBean<T> input)
                                                         throws TVCException

Ensures that all rows are validated, e.g. the data is retrieved for the rows from the database.

Parameters:

input -

Throws:

TVCException

Since:

6.3.0

ensureNotPaginated

public static <T extends TableData> TableBean<T> ensureNotPaginated(TableBean<T> input)

Returns a TableBean instance that is NOT paginated.

Parameters:

input -

Returns:

A TableBean instance that is NOT paginated.

Since:

2014.4.0

removeRows

public static void removeRows(TableBean<? extends TableData> table)

Sets the Row on each TableData to null.

Parameters:

table - The tablebean

Since:

6.4.0

toStructureBean

public static StructureBean toStructureBean(TableBean<? extends TableData> table)
                                     throws TVCException

Converts a table into a structure

The visible table-data instances are represented as root-nodes in the new structure.

Parameters:

table - The TableBean to convert

Returns:

A StructureBean

Throws:

TVCException

Since:

6.4.0

getObjectIds

public static java.lang.String[] getObjectIds(TableBean<?> t)

Returns the (unique) object-ids from the TableBean.

Parameters:

t - The TableBean to get the ids from.

Returns:

An array of object-ids (never null)

Since:

2009.1.0

getRelationshipIds

public static java.lang.String[] getRelationshipIds(TableBean<?> t)

Returns the (unique) relationship-ids from the TableBean.

Parameters:

t - The TableBean to get the ids from.

Returns:

An array of relationship-ids (never null)

Since:

2012.1.0

isHTMLCell

public static boolean isHTMLCell(Cell cell)

Returns true if the cell contains HTML data.

Parameters:

cell - The cell

Returns:

True if so

Since:

2009.1.2

getBooleanValue

public static java.lang.Boolean getBooleanValue(TableBean<?> tableBean,
                                                TableData tableData,
                                                java.lang.String columnName)

Parameters:

tableBean - The current table bean

tableData - The current table data instance

columnName - The name of the column

Returns:

Get a boolean value from the specified node using a name of a column

getBooleanValues

public static java.util.List<java.lang.Boolean> getBooleanValues(TableBean<?> tableBean,
                                                                 TableData tableData,
                                                                 java.lang.String columnName)

Parameters:

tableBean -

tableData -

columnName -

Returns:

Get boolean values from the specified node using a name of a column

getDateValue

public static java.util.Date getDateValue(TableBean<?> tableBean,
                                          TableData tableData,
                                          java.lang.String columnName)

Parameters:

tableBean -

tableData -

columnName -

Returns:

Get a date value from the specified node using a name of a column

getDateValues

public static java.util.List<java.util.Date> getDateValues(TableBean<?> tableBean,
                                                           TableData tableData,
                                                           java.lang.String columnName)

Parameters:

tableBean -

tableData -

columnName -

Returns:

Get date values from the specified node using a name of a column

getStringValue

public static java.lang.String getStringValue(TableBean<?> tableBean,
                                              TableData tableData,
                                              java.lang.String columnName)

Parameters:

tableBean -

tableData -

columnName -

Returns:

Get a String value from the specified node using a name of a column

getStringValues

public static java.util.List<java.lang.String> getStringValues(TableBean<?> tableBean,
                                                               TableData tableData,
                                                               java.lang.String columnName)

Parameters:

tableBean -

tableData -

columnName -

Returns:

Get String values from the specified node using a name of a column

getNumberValue

public static java.lang.Number getNumberValue(TableBean<?> tableBean,
                                              TableData tableData,
                                              java.lang.String columnName)

Parameters:

tableBean -

tableData -

columnName -

Returns:

Get a Number value from the specified node using a name of a column

getNumberValues

public static java.util.List<java.lang.Number> getNumberValues(TableBean<?> tableBean,
                                                               TableData tableData,
                                                               java.lang.String columnName)

Parameters:

tableBean -

tableData -

columnName -

Returns:

Get Number values from the specified node using a name of a column

ensureUniqueRowsOnly

public static void ensureUniqueRowsOnly(TableBean<?> table,
                                        boolean ignoreConnectionId)

Ensures that there is only one row in the table representing an object OR an object and connection.

Note: If the table is a structure bean, only the root nodes will be processed.

Parameters:

table - The table to process

ignoreConnectionId - If true, only the object-id will be used to determine the uniqueness of a row. Otherwise, the combination of connection-id and object-id will be used.

Since:

2011.2.0

loadInto

public static void loadInto(TableBean<?> sourceTableBean,
                            TableBean<?> targetTableBean)
                     throws TVCException

A utility method for loading data from one tablebean into another.

Please note that if the sourceTableBean is of a different type than the targetTableBean, then the data structure will be converted according to the table below.

Possible scenarios:

Source Type	Target Type	Conversion
FlatTableBean	FlatTableBean	none
CompositeStructureBean	CompositeStructureBean	none
StructureBean	StructureBean	none
StructureBean	CompositeStructureBean	none
FlatTableBean	CompositeStructureBean	The rows from the loaded table bean becomes root nodes in the target structure
FlatTableBean	StructureBean	The first row from the loaded table bean becomes root node in the target structure.
CompositeStructureBean	FlatTableBean	The nodes in the loaded table becomes rows without hierarchy information in the target table
CompositeStructureBean	StructureBean	The first root node and all it's child nodes ends up in the target structure
StructureBean	FlatTableBean	The nodes in the loaded table becomes rows without hierarchy information in the target table

Parameters:

sourceTableBean - The source table bean

targetTableBean - The target table bean

Throws:

TVCException

Since:

2011.2.0

removeRootNodes

public static void removeRootNodes(StructureBean source,
                                   CompositeStructureBean target)
                            throws TVCException

Throws:

TVCException

remove

public static int remove(TableBean<?> table,
                         java.lang.String objectId)

remove

public static int remove(TableBean<?> table,
                         java.lang.String relationshipId,
                         java.lang.String objectId)

getIds

public static java.util.Set<java.lang.String> getIds(TableBean<?> t,
                                                     boolean objectId)

Returns a (unique) set of ID's from a table bean.

Parameters:

t - The tablebean

objectId - True to get the object id's, false to get the relationship id's.

Since:

2012.3.0

connectNode

public static java.util.List<TableData> connectNode(TableBean<?> table,
                                                    java.lang.String parentId,
                                                    java.lang.String relId,
                                                    java.lang.String childId,
                                                    boolean isFrom)
                                             throws TVCException

Connect the node to the Table (including original tables)

Parameters:

table - The TableBean

parentId - objectId of the parent

relId - relationshipId of the node to be appended

childId - objectId of the node to be appended

isFrom - direction of the connection

Throws:

TVCException

Since:

2014.2.0

removeNodes

public static java.util.List<TableData> removeNodes(TableBean<?> table,
                                                    java.util.Collection<java.lang.String> relIds,
                                                    java.util.Collection<java.lang.String> objectIds)
                                             throws TVCException

Removes matching nodes (including original tables)

Parameters:

table - The TableBean

relIds - String[] relationshipIds of the nodes to be deleted

objectIds - String[] objectIds of the nodes to be deleted

Throws:

TVCException

Since:

2014.2.0

updateNodes

public static java.util.List<TableData> updateNodes(TableBean<?> table,
                                                    java.util.Collection<java.lang.String> relIds,
                                                    java.util.Collection<java.lang.String> objectIds)
                                             throws TVCException

Updates matching nodes (including original tables)

Parameters:

table - The TableBean

relIds - String[] relationshipIds of the nodes to be updated

objectIds - String[] objectIds of the nodes to be updated

Throws:

TVCException

Since:

2014.2.0

appendNode

public static java.util.List<StructureBeanNode> appendNode(StructureBean structure,
                                                           java.lang.String parentId,
                                                           java.lang.String relId,
                                                           java.lang.String childId,
                                                           boolean isFrom)
                                                    throws TVCException

Returns list of nodes appended to matching parent node.

Parameters:

structure - The StructureBean

parentId - objectId of the parent

relId - relationshipId of the node to be appended

childId - objectId of the node to be appended

isFrom - direction of the connection

Throws:

TVCException

Since:

2014.2.0

appendNode

public static StructureBeanNode appendNode(StructureBean structure,
                                           StructureBeanNode node,
                                           java.lang.String relId,
                                           java.lang.String childId,
                                           boolean isFrom)
                                    throws TVCException

Returns node appended to parent node.

Parameters:

structure - The StructureBean

node - parent node

relId - relationshipId of the node to be appended

childId - objectId of the node to be appended

isFrom - direction of the connection

Throws:

TVCException

Since:

2014.2.0

navigate

public static TableBean<?> navigate(TableBean<?> original,
                                    Environment newEnv,
                                    TableData data)
                             throws TVCException

Throws:

TVCException

getObjectIdForHeader

public static java.lang.String getObjectIdForHeader(Environment env)

Returns objectId for Header

Parameters:

env - The current environment.

Since:

2016.3.0