Produced by Siminov Software Solution LLP

siminov.orm.database.impl
Interface ISum

All Known Implementing Classes:
Select

public interface ISum

Exposes API's to return sum of all non-NULL values in the group. If there are no non-NULL input rows then sum() returns NULL but total() returns 0.0. NULL is not normally a helpful result for the sum of no rows but the SQL standard requires it and most other SQL database engines implement sum() that way so SQLite does it in the same way in order to be compatible. The result of sum() is an integer value if all non-NULL inputs are integers.


Field Summary
static java.lang.String INTERFACE_NAME
           
 
Method Summary
 ISumClause and(java.lang.String column)
          Used to specify AND condition between where clause.
 ISum column(java.lang.String column)
          Used to provide name of column for which sum will be calculated.
 java.lang.Object execute()
          Used to get sum, this method should be called in last to calculate sum.
 ISum groupBy(java.lang.String... columns)
          Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.
 ISumClause having(java.lang.String column)
          Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
 ISum havingClause(java.lang.String havingClause)
          Used to provide manually created Where clause, instead of using API's.
 ISumClause or(java.lang.String column)
          Used to specify OR condition between where clause.
 ISumClause where(java.lang.String column)
          Column name of which condition will be specified.
 ISum whereClause(java.lang.String whereClause)
          Used to provide manually created Where clause, instead of using API's.
 

Field Detail

INTERFACE_NAME

static final java.lang.String INTERFACE_NAME
Method Detail

where

ISumClause where(java.lang.String column)
Column name of which condition will be specified.

Parameters:
column - Name of column.
Returns:
ISumClause Interface.

whereClause

ISum whereClause(java.lang.String whereClause)
Used to provide manually created Where clause, instead of using API's.

Parameters:
whereClause - Manually created where clause.
Returns:
ISum Interface.

and

ISumClause and(java.lang.String column)
Used to specify AND condition between where clause.

Parameters:
column - Name of column on which condition need to be specified.
Returns:
ISumClause Interface.

or

ISumClause or(java.lang.String column)
Used to specify OR condition between where clause.

Parameters:
column - Name of column on which condition need to be specified.
Returns:
ISumClause Interface.

groupBy

ISum groupBy(java.lang.String... columns)
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.

Parameters:
columns - Name of columns.
Returns:
ISum Interface.

having

ISumClause having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.

Parameters:
column - Name of column on which condition need to be applied.
Returns:
ISumClause Interface.

havingClause

ISum havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's.

Parameters:
havingClause - Where clause.
Returns:
ISum Interface.

column

ISum column(java.lang.String column)
Used to provide name of column for which sum will be calculated.

Parameters:
column - Name of column.
Returns:
ISum Interface.

execute

java.lang.Object execute()
                         throws DatabaseException
Used to get sum, this method should be called in last to calculate sum.

Returns:
Return sum.
Throws:
DatabaseException - Throws exception if any error occur while calculating sum.

Apache License 2.0

Copyright 2013