Siminov Hybrid Siminov Hybrid

  • API Docs for Version: 2.0

    • APIs

    Show:

    Select Class

    Defined in: /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:51
    Module: Database

    Exposes API to deal with conditions and other constraints used in query.

    Methods

    and

    (
    • column
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:122

    Used to specify AND condition between where clause.

    Parameters:

    • column String

      Name of column on which condition need to be specified.

    Returns:

    Object:

    Clause Interface Implementation.

    ascendingOrderBy

    (
    • columns
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:161

    Used to specify ORDER BY ASC keyword to sort the result-set in ascending order.

    Parameters:

    • columns String

      Name of columns which need to be sorted.

    Returns:

    Object:

    Select Interface Implementation.

    column

    (
    • column
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:245

    Used to provide name of column only for which data will be fetched.

    Parameters:

    • column String

      Name of column.

    Returns:

    Object:

    Select Interface Implementation.

    columns

    (
    • column
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:258

    Used to provide name of columns only for which data will be fetched.

    Parameters:

    • column Array

      Name of columns.

    Returns:

    Object:

    Select Interface Implementation.

    delimiter

    (
    • val
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:271

    Used to provide delimiter

    Parameters:

    • val String

      Value of delimiter

    Returns:

    Object:

    Select Interface Implementation

    descendingOrderBy

    (
    • columns
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:176

    Used to specify ORDER BY DESC keyword to sort the result-set in descending order.

    Parameters:

    • columns String

      Name of columns which need to be sorted.

    Returns:

    Object:

    Select Interface Implementation.

    distinct

    () Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:81

    Used to specify DISTINCT condition.

    Returns:

    Object:

    Select Interface Implementation.

    execute

    ()

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:293

    Process the request specified by application.

    executeAsync

    ()

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:283

    Process the request asynchronous specified by application.

    groupBy

    (
    • columns
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:204

    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:

    Object:

    Select Interface Implementation.

    having

    (
    • column
    )
    Clause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:217

    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:

    Clause:

    Clause Interface Implementation.

    havingClause

    (
    • havingClause
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:232

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

    Parameters:

    • havingClause String

      Where clause.

    Returns:

    Object:

    Select Interface Implementation.

    limit

    (
    • limit
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:191

    Used to specify the range of data need to fetch from table.

    Parameters:

    Returns:

    Object:

    Select Interface Implementation.

    or

    (
    • column
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:135

    Used to specify OR condition between where clause.

    Parameters:

    • column String

      Name of column on which condition need to be specified.

    Returns:

    Object:

    Clause Interface Implementation.

    orderBy

    (
    • columns
    )
    OBJECT

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

    Used to specify ORDER BY keyword to sort the result-set.

    Parameters:

    • columns String

      Name of columns which need to be sorted.

    Returns:

    OBJECT:

    Select Interface Implementation.

    where

    (
    • column
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:94

    Column name of which condition will be specified.

    Parameters:

    • column String

      Name of column.

    Returns:

    Object:

    Clause Interface Implementation.

    whereClause

    (
    • whereClause
    )
    Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Select.js:109

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

    Parameters:

    • whereClause String

      Manually created where clause.

    Returns:

    Object:

    Select Interface Implementation.