User Mapping DAO for reading user mapping data tables

Hierarchy

Constructors

Properties

Methods

_buildWhereArgsWithArray _buildWhereArgsWithColumnValues addColumn alterColumn alterColumns buildLimit buildWhere buildWhereArgs buildWhereArgsWithValues buildWhereIn buildWhereInArgs buildWhereLike buildWhereWithFields buildWhereWithOp columnCount count countByBaseId countByBaseIdWithUserMappingRow countByIds countByIdsWithUserMappingRow countByRelatedId countByRelatedIdWithUserMappingRow countColumn countColumnIn countForEq countForFieldValues countIn countInWithColumn countInWithDistinct countInWithDistinctAndColumn countOfResultSet countWithColumns countWithDistinct countWithDistinctAndColumns create createObject delete deleteAll deleteByBaseId deleteByBaseIdWithUserMappingRow deleteById deleteByIds deleteByIdsWithUserMappingRow deleteByRelatedId deleteByRelatedIdWithUserMappingRow deleteRow deleteWithFieldValues dropColumn dropColumnIndexes dropColumnNames dropColumnWithIndex dropColumnWithName dropColumns dropTable getBoundingBox getBoundingBoxInProjection getBoundingBoxWithProjection getColumnNames getColumns getContents getCount getCountWithColumns getCountWithDistinct getCountWithDistinctAndColumns getDatabase getDb getGeoPackage getPkColumn getPkColumnIndex getPkColumnName getPkWhere getPkWhereArgs getProjection getRow getRowWithUserCustomRow getTable getTableName getUserDb getZoomLevelForBoundingBox hasPkColumn insert insertOrThrow insertWithContentValues isPkModifiable isTableExists isValueValidation max min newRow prepareResult projectBoundingBox query queryByBaseId queryByBaseIdWithUserMappingRow queryByIds queryByIdsWithUserMappingRow queryByRelatedId queryByRelatedIdWithUserMappingRow queryForAll queryForChunk queryForChunkWithColumns queryForChunkWithDistinct queryForChunkWithDistinctAndColumns queryForEq queryForEqWithColumns queryForEqWithDistinct queryForEqWithDistinctAndColumns queryForEqWithFieldAndValue queryForFieldValues queryForFieldValuesWithColumns queryForFieldValuesWithDistinct queryForFieldValuesWithDistinctAndColumns queryForId queryForIdRow queryForIdRows queryForLike queryIdsSQL queryIn queryInForChunk queryInForChunkWithColumns queryInForChunkWithDistinct queryInForChunkWithDistinctAndColumns queryInWithColumns queryInWithDistinct queryInWithDistinctAndColumns querySQL querySingleColumnTypedResults querySingleColumnTypedResultsWithColumnIndex querySingleResult queryWithColumns queryWithDistinct queryWithDistinctAndColumns rawQueryWithArgs rawQueryWithColumns renameColumn renameColumnWithIndex renameColumnWithName renameTableColumn setPkModifiable setValueValidation uniqueBaseIds uniqueRelatedIds update updateWithContentValues readTable

Constructors

Properties

geoPackage: GeoPackage

GeoPackage

projection: Projection

Projection

Methods

  • Build a limit String with the limit and offset

    Returns

    limit

    Parameters

    • limit: number

      limit

    • offset: number

      offset

    Returns string

  • Build where (or selection) statement for a single field

    Returns

    where clause

    Parameters

    • field: string

      field name

    • value: any

      field value

    Returns string

  • Build where statement for ids in the nested SQL query

    Returns

    where clause

    Parameters

    • nestedSQL: string

      nested SQL

    • where: string

      where clause

    Returns string

  • Build where args for ids in the nested SQL query

    Returns

    where args

    Parameters

    • nestedArgs: any[]

      nested SQL args

    • whereArgs: any[]

      where arguments

    Returns any[]

  • Build where (or selection) LIKE statement for a single field

    Returns

    where clause

    Parameters

    • field: string

      field name

    • value: any

      field value

    Returns string

  • Build where (or selection) statement for a single field using the provided operation

    Returns

    where clause

    Parameters

    • field: string

      field

    • value: any

      value

    • operation: string

      operation

    Returns string

  • Count

    Parameters

    • Optional where: string
    • Optional whereArgs: [] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Count by both base id and related id

    Returns

    count

    Parameters

    • baseId: number

      base id

    • relatedId: number

      related id

    Returns number

  • Get a count of results

    Parameters

    • distinct: boolean
    • column: string
    • where: string
    • whereArgs: any[]

    Returns number

  • Get the count in the nested SQL query

    Returns

    count

    Parameters

    • column: string

      count column name

    • nestedSQL: string

      nested SQL

    Returns number

  • Query for the row where the field equals the value

    Parameters

    • fieldName: string
    • value: any
    • distinct: boolean = false
    • columns: string[] = ...
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string

    Returns number

  • Get the count in the nested SQL query

    Returns

    count

    Parameters

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: string[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: string[]

      where arguments

    Returns number

  • Get the count in the nested SQL query

    Returns

    count

    Parameters

    • Optional column: string

      count column name

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: string[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: string[]

      where arguments

    Returns number

  • Get the count in the nested SQL query

    Returns

    count

    Parameters

    • Optional distinct: boolean

      distinct column values

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: string[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: string[]

      where arguments

    Returns number

  • Get the count in the nested SQL query

    Returns

    count

    Parameters

    • Optional distinct: boolean

      distinct column values

    • Optional column: string

      count column name

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: string[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: string[]

      where arguments

    Returns number

  • Count

    Parameters

    • columns: string[] = ...
    • Optional where: string
    • Optional whereArgs: [] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Count

    Parameters

    • distinct: boolean = false
    • Optional where: string
    • Optional whereArgs: [] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Count

    Parameters

    • distinct: boolean = false
    • columns: string[] = ...
    • Optional where: string
    • Optional whereArgs: any[] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Delete rows matching the where clause

    Returns

    deleted count

    Parameters

    • Optional whereClause: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    Returns number

  • Delete user mappings by both base id and related id

    Returns

    rows deleted

    Parameters

    • baseId: number

      base id

    • relatedId: number

      related id

    Returns number

  • Gets the count

    Parameters

    • Optional where: string
    • Optional whereArgs: [] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Gets the count

    Parameters

    • columns: string[] = ...
    • Optional where: string
    • Optional whereArgs: [] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Gets the count

    Parameters

    • distinct: boolean = false
    • Optional where: string
    • Optional whereArgs: [] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Gets the count

    Parameters

    • distinct: boolean = false
    • columns: string[] = ...
    • Optional where: string
    • Optional whereArgs: [] | DBValue[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns number

  • Get the max result of the column

    Returns

    max or null

    Parameters

    • column: string

      column name

    • Optional where: string

      where clause

    • Optional args: any

      where arugments

    Returns number

  • Get the min result of the column

    Returns

    min or null

    Parameters

    • column: string

      column name

    • Optional where: string

      where clause

    • Optional args: any

      where arugments

    Returns number

  • Query

    Parameters

    • Optional where: string
    • Optional whereArgs: any[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

  • Query for ordered rows starting at the offset and returning no more than the limit.

    Parameters

    • Optional where: string
    • Optional whereArgs: any[]
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

  • Query for ordered rows starting at the offset and returning no more than the limit.

    Parameters

    • columns: string[] = ...
    • Optional where: string
    • Optional whereArgs: any[]
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

  • Query for ordered rows starting at the offset and returning no more than the limit.

    Parameters

    • distinct: boolean = false
    • Optional where: string
    • Optional whereArgs: any[]
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

  • Query for ordered rows starting at the offset and returning no more than the limit.

    Parameters

    • distinct: boolean = false
    • columns: string[] = ...
    • Optional where: string
    • Optional whereArgs: any[]
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

  • Query for the row where all fields match their values

    Returns

    result

    Parameters

    • property: string

      property name

    • value: any

      property value

    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string

    Returns UserCustomResultSet

  • Query for the row where all fields match their values

    Returns

    result

    Parameters

    • columns: string[] = ...

      columns

    • property: string

      property name

    • value: any

      property value

    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string

    Returns UserCustomResultSet

  • Query for the row where all fields match their values

    Returns

    result

    Parameters

    • distinct: boolean = false

      distinct rows

    • property: string

      property name

    • value: any

      property value

    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string

    Returns UserCustomResultSet

  • Query SQL for all row ids

    Returns

    SQL

    Parameters

    • distinct: boolean = false

      distinct rows

    • Optional where: string

      where

    Returns string

  • Query for rows by ids in the nested SQL query

    Returns

    result

    Parameters

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    Returns UserCustomResultSet

  • Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.

    Returns

    result

    Parameters

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    • Optional groupBy: string

      group by

    • Optional having: string

      having

    • Optional orderBy: string

      order by

    • Optional limit: number

      chunk limit

    • Optional offset: number

      chunk offset

    Returns UserCustomResultSet

  • Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.

    Returns

    result

    Parameters

    • columns: string[]

      columns

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    • Optional groupBy: string

      group by

    • Optional having: string

      having

    • Optional orderBy: string

      order by

    • Optional limit: number

      chunk limit

    • Optional offset: number

      chunk offset

    Returns UserCustomResultSet

  • Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.

    Returns

    result

    Parameters

    • distinct: boolean

      distinct rows

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    • Optional groupBy: string

      group by

    • Optional having: string

      having

    • Optional orderBy: string

      order by

    • Optional limit: number

      chunk limit

    • Optional offset: number

      chunk offset

    Returns UserCustomResultSet

  • Query for ordered rows by ids in the nested SQL query, starting at the offset and returning no more than the limit.

    Returns

    result

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    • Optional groupBy: string

      group by

    • Optional having: string

      having

    • Optional orderBy: string

      order by

    • Optional limit: number

      chunk limit

    • Optional offset: number

      chunk offset

    Returns UserCustomResultSet

  • Query for rows by ids in the nested SQL query

    Returns

    result

    Parameters

    • columns: string[]

      columns

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    Returns UserCustomResultSet

  • Query for rows by ids in the nested SQL query

    Returns

    result

    Parameters

    • distinct: boolean

      distinct rows

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    Returns UserCustomResultSet

  • Query for rows by ids in the nested SQL query

    Returns

    result

    Parameters

    • Optional distinct: boolean

      distinct rows

    • Optional columns: string[]

      columns

    • Optional nestedSQL: string

      nested SQL

    • Optional nestedArgs: any[]

      nested SQL args

    • Optional where: string

      where clause

    • Optional whereArgs: any[]

      where arguments

    Returns UserCustomResultSet

  • Query SQL for all rows

    Returns

    SQL

    Parameters

    • distinct: boolean

      distinct rows

    • columns: string[]

      columns

    • Optional where: string

      where

    Returns string

  • Query for typed values from the first column

    Returns

    single column values

    Parameters

    • sql: string

      sql statement

    • args: string[]

      sql arguments

    • columnName: string
    • Optional limit: number

    Returns any[]

  • Query for typed values from the first column

    Returns

    single column values

    Parameters

    • sql: string

      sql statement

    • args: string[]

      sql arguments

    • columnIndex: number = 0
    • Optional limit: number

    Returns any[]

  • Query the SQL for a single result object in the first column

    Returns

    single result object

    Parameters

    • sql: string

      sql statement

    • args: string[]

      sql arguments

    Returns any

  • Query

    Parameters

    • columns: string[]
    • Optional where: string
    • Optional whereArgs: any[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

  • Query

    Parameters

    • distinct: boolean
    • Optional where: string
    • Optional whereArgs: any[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

  • Query

    Parameters

    • distinct: boolean = false
    • columns: string[] = ...
    • Optional where: string
    • Optional whereArgs: any[]
    • Optional join: string
    • Optional groupBy: string
    • Optional having: string
    • Optional orderBy: string
    • Optional limit: number
    • Optional offset: number

    Returns UserCustomResultSet

Generated using TypeDoc