Uses of Class
proper.relaggs.RelaggsTable

Packages that use RelaggsTable

proper.relaggs

contains the core classes of RELAGGS, without the GUI components

Uses of RelaggsTable in proper.relaggs

Methods in proper.relaggs that return RelaggsTable

RelaggsTable

SqlEngine.getTable(java.lang.String name) Creates a RelaggsTable object containing the table information (attributes, primary keys).

Methods in proper.relaggs with parameters of type RelaggsTable

void	SqlEngine.addAggregatedAttributes(RelaggsTable dest_table, RelaggsTable source_table, RelaggsStructure struct, Join join) Adds the aggregated attributes to the relaggs table. FracPete: - introduced HashSet to skip duplicate columns and also that there are not too many columns inserted - ADD COLUMN split into single statements (necessary for ANSI SQL!)
void	RelaggsTable.addForeignKey(RelaggsTable ref_table) Adds the foreign keys to the given table (if exist) to the table.
java.lang.String	SqlEngine.aggregateAttributes(RelaggsTable main, RelaggsTable aggr, Join join, int number) Combines two tables 'main' and 'aggr' by adding the aggregated columns of table 'aggr' to table main. FracPete: can perform LEFT OUTER JOIN, CREATE TABLE statement now more ANSI compliant
java.lang.String	RelaggsStructure.getAlterTableColumns(RelaggsTable source_table) Returns the columns part for an ALTER TABLE statement containing the new columns for the aggregated values. FracPete: changed sql from type String to StringBuffer for performance reasons introduced a HashSet to identify duplicate columns changed data types to ANSI types: INT, DOUBLE PRECISION
RelaggsStructure	SqlEngine.getAttributes(RelaggsTable table, RelaggsAttribute attribute) Reads the attributes of the given table into the RelaggsStructure.
java.sql.PreparedStatement	RelaggsStructure.getUpdateQuery(java.lang.Object key, RelaggsTable source, RelaggsTable dest, Join join) Returns an PreparedStatement containing the UPDATE query with the aggregated values for a key value.
boolean	RelaggsTable.hasForeignKey(RelaggsTable ref_table) Returns whether the table references the given table by foreign key or not.
void	SqlEngine.setColumns(RelaggsTable table) sets the columns in this table