Package ch.pschatzmann.edgar.reporting

Automatic generation of SQL request in order to provide the data based on the user selection. We also provide all the necessary information to build the data selection which consists of the value field, columns and rows.

Author:

pschatzmann

Interface Summary

Interface	Description
ISQLModel	Interface which allows for the implementation of different models to implement the construction of the SQL command

Class Summary

Class	Description
AbstractModel	We can define the row fields, column fields and the value field.
DateTable	Scenario1: select only 1 quarter values Scenario2: select 1,2,3,4 Q values (max Q)
DBField	Represents a single Table field.
DBMS	Access to database.
DBRelation	Defines the relationship between tables.
DBTable	Model for a single SQL database table which contains fields and which has relationships to other tables.
EdgarModel	Implementation of the abstract Model for the Edgar database
JoinCondition	Defines the joins relationships on the field level and is used to generate the join statement.
NavigationField	Field information which contains enough context information so that we are able to generate the complete SQL command: The relation information is necessary so that we know on which join path the field is located.
PostgresSQLModel	Implementation which provides the join logic.
PostgresSQLModelExt	Implementation which supports the proper handling of alternative parameter names as specified by priority in the SQL mapping table
PostgresSQLModelPriorities	Implementation which supports the proper handling of alternative parameter names
Table	Table representation of data where the numerical values are split up in columns and rows.
TableFormatterSQL	Provides the SQL query which is used to create the table
ValueField	The value field which is not grouped needs to have an aggregate function defined.

Enum Summary

Enum	Description
DateTable.Type