Package ch.pschatzmann.edgar.reporting

Class PostgresSQLModel

java.lang.Object

ch.pschatzmann.edgar.reporting.PostgresSQLModel

All Implemented Interfaces:

ISQLModel

Direct Known Subclasses:

PostgresSQLModelExt

public class PostgresSQLModel
extends java.lang.Object
implements ISQLModel

Implementation which provides the join logic. Reporting data is usually represented as star model which a central fact table. This implementation is assuming that the relationships are a hierarchical tree structure starting from a central fact table. We only generate the join conditins which are necessary for the selected fields

Author:

pschatzmann

Constructor Summary

Constructors

Constructor	Description
PostgresSQLModel(AbstractModel edgarModel)	Default Constructor

Method Summary

Modifier and Type	Method	Description
java.lang.String	toSQL(ch.pschatzmann.common.table.ITable itable)	Gemerate SQL command based on the selected rows, column and value field

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgresSQLModel

public PostgresSQLModel(AbstractModel edgarModel)

Default Constructor

Method Detail

toSQL

public java.lang.String toSQL(ch.pschatzmann.common.table.ITable itable)
                       throws DataException

Gemerate SQL command based on the selected rows, column and value field

Specified by:

toSQL in interface ISQLModel

Returns:

Throws:

DataException