Produced by Siminov Software Solution LLP

siminov.orm.database.impl
Interface IGroupConcat

All Known Implementing Classes:
Select

public interface IGroupConcat

Exposes API's to get group concat that returns a string which is the concatenation of all non-NULL values of X. If parameter Y is present then it is used as the separator between instances of X. A comma (",") is used as the separator if Y is omitted. The order of the concatenated elements is arbitrary.


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

delimiter

IGroupConcat delimiter(java.lang.String delimiter)
Used to specify separator if Y is omitted.

Parameters:
delimiter - Delimiter.
Returns:
IGroupConcat Interface.

where

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

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

whereClause

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

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

and

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

or

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

groupBy

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

having

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

havingClause

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

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

column

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

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

execute

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

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

Apache License 2.0

Copyright 2013