Produced by Siminov Software Solution LLP

siminov.orm.database.impl
Interface ICount

All Known Implementing Classes:
Select

public interface ICount

Exposes API's to get count of the number of times that X is not NULL in a group. The count(*) function (with no arguments) returns the total number of rows in the group.


Field Summary
static java.lang.String INTERFACE_NAME
           
 
Method Summary
 ICountClause and(java.lang.String column)
          Used to specify AND condition between where clause.
 ICount column(java.lang.String column)
          Used to provide name of column for which count will be calculated.
 ICount distinct()
          Used to specify DISTINCT condition.
 java.lang.Object execute()
          Used to get count, this method should be called in last to calculate count.
 ICount 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.
 ICountClause having(java.lang.String column)
          Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
 ICount havingClause(java.lang.String havingClause)
          Used to provide manually created Where clause, instead of using API's.
 ICountClause or(java.lang.String column)
          Used to specify OR condition between where clause.
 ICountClause where(java.lang.String column)
          Column name of which condition will be specified.
 ICount 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

distinct

ICount distinct()
Used to specify DISTINCT condition.

Returns:
ICount Interface.

where

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

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

whereClause

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

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

and

ICountClause 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:
ICountClause Interface.

or

ICountClause 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:
ICountClause Interface.

groupBy

ICount 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:
ICount Interface.

having

ICountClause 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:
ICountClause Interface.

havingClause

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

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

column

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

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

execute

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

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

Apache License 2.0

Copyright 2013