Feature DAO for reading feature user data tables

Hierarchy

Constructors

Properties

Methods

_buildWhereArgsWithArray _buildWhereArgsWithColumnValues addColumn alterColumn alterColumns buildLimit buildWhere buildWhereArgs buildWhereArgsWithValues buildWhereIn buildWhereInArgs buildWhereLike buildWhereWithFields buildWhereWithOp columnCount count countColumn countColumnIn countForEq countForFieldValues countIn countInWithColumn countInWithDistinct countInWithDistinctAndColumn countWithColumns countWithDistinct countWithDistinctAndColumns create delete deleteAll deleteById deleteRow deleteWithFieldValues dropColumn dropColumnIndexes dropColumnNames dropColumnWithIndex dropColumnWithName dropColumns dropTable getBoundingBox getBoundingBoxWithProjection getColumnNames getColumns getContents getCount getCountWithColumns getCountWithDistinct getCountWithDistinctAndColumns getDatabase getDb getFeatureDb getGeoPackage getGeometryColumnName getGeometryColumns getGeometryType getIdAndGeometryColumnNames getIdColumn getIdColumnName getPkColumn getPkColumnIndex getPkColumnName getPkWhere getPkWhereArgs getProjection getSrs getSrsId getTable getTableName getUserDb getZoomLevelForBoundingBox hasPkColumn insert insertOrThrow insertWithContentValues isPkModifiable isTableExists isValueValidation max min newRow prepareResult projectBoundingBox query 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 update updateWithContentValues

Constructors

Properties

featureTableIndex: FeatureTableIndex
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

  • 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 a row by id

    Returns

    number of rows affected, should be 0 or 1

    Parameters

    • id: number

      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 primary key where clause

    Returns

    primary key where clause

    Parameters

    • id: number

      id

    Returns string

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • Query for the row where the field equals the value

    Parameters

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

    Returns FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • 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 FeatureResultSet

  • Rename column

    Parameters

    • columnName: string

      column name

    • newColumnName: string

      new column name

    Returns void

  • Rename a table column

    Parameters

    • columnName: string

      column name

    • newColumnName: string

      new column name

    Returns void

  • Set if the primary key can be modified

    Parameters

    • pkModifiable: boolean

      primary key modifiable flag

    Returns void

  • Set if values should validated against column types

    Parameters

    • valueValidation: boolean

      value validation flag

    Returns void

  • Update all rows matching the where clause with the provided values

    Returns

    updated count

    Parameters

    • values: ContentValues

      content values

    • Optional whereClause: string

      where clause

    • Optional whereArgs: []

      where arguments

    Returns number

Generated using TypeDoc