Siminov Hybrid Siminov Hybrid

  • API Docs for Version: 2.0

    • APIs

    Show:

    ISum Class

    Defined in: /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:55
    Module: Impl
    Parent Module: Database

    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.

    Methods

    and

    (
    • column
    )
    ISumClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:98

    Used to specify AND condition between where clause.

    Parameters:

    • column Column

      Name of column on which condition need to be specified.

    Returns:

    ISumClause:

    ISumClause Interface.

    column

    (
    • column
    )
    ISum

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:148

    Used to provide name of column for which sum will be calculated.

    Parameters:

    • column String

      Name of column.

    Returns:

    ISum:

    ISum Interface.

    execute

    () Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:158

    Used to get sum, this method should be called in last to calculate sum.

    Returns:

    Object:

    Return sum.

    executeAsync

    (
    • callback
    )

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:168

    Used to get sum asynchronous, this method should be called in last to calculate sum.

    Parameters:

    • callback Callback

      Request Callback.

    groupBy

    (
    • columns
    )
    ISum

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:118

    Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.

    Parameters:

    • columns Array

      Name of columns.

    Returns:

    ISum:

    ISum Interface.

    having

    (
    • column
    )
    ISumClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:128

    Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.

    Parameters:

    • column String

      Name of column on which condition need to be applied.

    Returns:

    ISumClause:

    ISumClause Interface.

    havingClause

    (
    • havingClause
    )
    ISum

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:138

    Used to provide manually created Where clause, instead of using API's.

    Parameters:

    • havingClause String

      Where clause.

    Returns:

    ISum:

    ISum Interface.

    or

    (
    • column
    )
    ISumClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:108

    Used to specify OR condition between where clause.

    Parameters:

    • column Column

      Name of column on which condition need to be specified.

    Returns:

    ISumClause:

    ISumClause Interface.

    where

    (
    • column
    )
    ISumClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:78

    Column name of which condition will be specified.

    Parameters:

    • column String

      Name of column.

    Returns:

    ISumClause:

    ISumClause Interface.

    whereClause

    (
    • whereClause
    )
    ISum

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/ISum.js:88

    Used to provide manually created Where clause, instead of using API's.

    Parameters:

    • whereClause String

      Manually created where clause.

    Returns:

    ISum:

    ISum Interface.