Class TileDao

Tile DAO for reading tile user tables

Hierarchy

UserDao<TileColumn, TileTable, TileRow, TileResultSet>
- TileDao

Index

Constructors

constructor

Properties

geoPackage projection

Methods

Constructors

constructor

new TileDao(database: string, geoPackage: GeoPackage, tileMatrixSet: TileMatrixSet, tileMatrices: TileMatrix[], table: TileTable): TileDao
Constructor
Parameters
- database: string
  
  database
- geoPackage: GeoPackage
  
  GeoPackage
- tileMatrixSet: TileMatrixSet
  
  tile matrix set
- tileMatrices: TileMatrix[]
  
  tile matrices
- table: TileTable
  
  tile table
Returns TileDao
Overrides UserDao.constructor
- Defined in lib/tiles/user/tileDao.ts:77

Properties

`Protected` `Readonly` geoPackage

geoPackage: GeoPackage

GeoPackage

`Protected` projection

projection: Projection

Projection

Methods

_buildWhereArgsWithArray

_buildWhereArgsWithArray(values: DBValue[]): DBValue[]
Builds a where args array

Returns
Parameters
- values: DBValue[]
  
  argument values to push
Returns DBValue[]
Inherited from UserDao._buildWhereArgsWithArray
- Defined in lib/user/userDao.ts:1275

_buildWhereArgsWithColumnValues

_buildWhereArgsWithColumnValues(values: FieldValues): DBValue[]
Builds a where args array

Returns
Parameters
- values: FieldValues
  
  argument values to push
Returns DBValue[]
Inherited from UserDao._buildWhereArgsWithColumnValues
- Defined in lib/user/userDao.ts:1291

addColumn

addColumn(column: TileColumn): void
Add a new column
Parameters
- column: TileColumn
  
  new column
Returns void
Inherited from UserDao.addColumn
- Defined in lib/user/userDao.ts:1607

adjustTileMatrixLengths

adjustTileMatrixLengths(): void
Adjust the tile matrix lengths if needed. Check if the tile matrix width and height need to expand to account for pixel * number of pixels fitting into the tile matrix lengths

Returns void
- Defined in lib/tiles/user/tileDao.ts:249

alterColumn

alterColumn(column: TileColumn): void
Alter a column
Parameters
- column: TileColumn
  
  column
Returns void
Inherited from UserDao.alterColumn
- Defined in lib/user/userDao.ts:1709

alterColumns

alterColumns(columns: TileColumn[]): void
Alter columns
Parameters
- columns: TileColumn[]
  
  columns
Returns void
Inherited from UserDao.alterColumns
- Defined in lib/user/userDao.ts:1717

buildLimit

buildLimit(limit: number, offset: number): string
Build a limit String with the limit and offset

Returns
limit
Parameters
- limit: number
  
  limit
- offset: number
  
  offset
Returns string
Inherited from UserDao.buildLimit
- Defined in lib/user/userDao.ts:1574

buildWhere

buildWhere(field: string, value: any): string
Build where (or selection) statement for a single field

Returns
where clause
Parameters
- field: string
  
  field name
- value: any
  
  field value
Returns string
Inherited from UserDao.buildWhere
- Defined in lib/user/userDao.ts:1228

buildWhereArgs

buildWhereArgs(values: DBValue | DBValue[] | FieldValues): DBValue[]
Build where (or selection) args for the value

Returns
where args
Parameters
- values: DBValue | DBValue[] | FieldValues
  
  value
Returns DBValue[]
Inherited from UserDao.buildWhereArgs
- Defined in lib/user/userDao.ts:1364

buildWhereArgsWithValues

buildWhereArgsWithValues(values: DBValue | DBValue[] | FieldValues): any[]
Builds a where args array

Returns
Parameters
- values: DBValue | DBValue[] | FieldValues
  
  argument values to push
Returns any[]
Inherited from UserDao.buildWhereArgsWithValues
- Defined in lib/user/userDao.ts:1256

buildWhereIn

buildWhereIn(nestedSQL: string, where: string): 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
Inherited from UserDao.buildWhereIn
- Defined in lib/user/userDao.ts:1318

buildWhereInArgs

buildWhereInArgs(nestedArgs: any[], whereArgs: any[]): any[]
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[]
Inherited from UserDao.buildWhereInArgs
- Defined in lib/user/userDao.ts:1335

buildWhereLike

buildWhereLike(field: string, value: any): string
Build where (or selection) LIKE statement for a single field

Returns
where clause
Parameters
- field: string
  
  field name
- value: any
  
  field value
Returns string
Inherited from UserDao.buildWhereLike
- Defined in lib/user/userDao.ts:1308

buildWhereWithFields

buildWhereWithFields(fields: FieldValues, operation??: string): string
Build where or selection statement for fields

Returns
where clause
Parameters
- fields: FieldValues
  
  columns and values
- Optional operation: string = 'and'
  
  AND or OR
Returns string
Inherited from UserDao.buildWhereWithFields
- Defined in lib/user/userDao.ts:1238

buildWhereWithOp

buildWhereWithOp(field: string, value: any, operation: string): 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
Inherited from UserDao.buildWhereWithOp
- Defined in lib/user/userDao.ts:1355

columnCount

columnCount(): number
Get the column count

Returns
column count

Returns number
Inherited from UserDao.columnCount
- Defined in lib/user/userDao.ts:237

count

count(where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): number
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
Inherited from UserDao.count
- Defined in lib/user/userDao.ts:899

countAtZoomLevel

countAtZoomLevel(zoomLevel: number): number
Count of Tiles at a zoom level

Returns
count
Parameters
- zoomLevel: number
  
  zoom level
Returns number
- Defined in lib/tiles/user/tileDao.ts:589

countColumn

countColumn(distinct: boolean, column: string, where: string, whereArgs: any[]): number
Get a count of results
Parameters
- distinct: boolean
- column: string
- where: string
- whereArgs: any[]
Returns number
Inherited from UserDao.countColumn
- Defined in lib/user/userDao.ts:735

countColumnIn

countColumnIn(column: string, nestedSQL: string): number
Get the count in the nested SQL query

Returns
count
Parameters
- column: string
  
  count column name
- nestedSQL: string
  
  nested SQL
Returns number
Inherited from UserDao.countColumnIn
- Defined in lib/user/userDao.ts:1043

countForEq

countForEq(fieldName: string, value: any, distinct?: boolean, columns?: string[], groupBy?: string, having?: string, orderBy?: string): 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
Inherited from UserDao.countForEq
- Defined in lib/user/userDao.ts:1433

countForFieldValues

countForFieldValues(fieldValues: FieldValues): number
Count where all fields match their values

Returns
count
Parameters
- fieldValues: FieldValues
  
  field values
Returns number
Inherited from UserDao.countForFieldValues
- Defined in lib/user/userDao.ts:1417

countIn

countIn(nestedSQL?: string, nestedArgs?: string[], where?: string, whereArgs?: string[]): 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
Inherited from UserDao.countIn
- Defined in lib/user/userDao.ts:1055

countInWithColumn

countInWithColumn(column?: string, nestedSQL?: string, nestedArgs?: string[], where?: string, whereArgs?: string[]): 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
Inherited from UserDao.countInWithColumn
- Defined in lib/user/userDao.ts:1087

countInWithDistinct

countInWithDistinct(distinct?: boolean, nestedSQL?: string, nestedArgs?: string[], where?: string, whereArgs?: string[]): 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
Inherited from UserDao.countInWithDistinct
- Defined in lib/user/userDao.ts:1068

countInWithDistinctAndColumn

countInWithDistinctAndColumn(distinct?: boolean, column?: string, nestedSQL?: string, nestedArgs?: string[], where?: string, whereArgs?: string[]): 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
Inherited from UserDao.countInWithDistinctAndColumn
- Defined in lib/user/userDao.ts:1107

countWithColumns

countWithColumns(columns?: string[], where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): 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
Inherited from UserDao.countWithColumns
- Defined in lib/user/userDao.ts:972

countWithDistinct

countWithDistinct(distinct?: boolean, where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): 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
Inherited from UserDao.countWithDistinct
- Defined in lib/user/userDao.ts:935

countWithDistinctAndColumns

countWithDistinctAndColumns(distinct?: boolean, columns?: string[], where?: string, whereArgs?: any[] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): 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
Inherited from UserDao.countWithDistinctAndColumns
- Defined in lib/user/userDao.ts:1010

create

create(row: TileRow): number
Parameters
- row: TileRow
Returns number
Inherited from UserDao.create
- Defined in lib/user/userDao.ts:1837

delete

delete(whereClause?: string, whereArgs?: any[]): number
Delete rows matching the where clause

Returns
deleted count
Parameters
- Optional whereClause: string
  
  where clause
- Optional whereArgs: any[]
  
  where arguments
Returns number
Inherited from UserDao.delete
- Defined in lib/user/userDao.ts:1734

deleteAll

deleteAll(): number
Delete all rows

Returns
deleted count

Returns number
Inherited from UserDao.deleteAll
- Defined in lib/user/userDao.ts:1742

deleteById

deleteById(id: number): number
Delete a row by id

Returns
number of rows affected, should be 0 or 1
Parameters
- id: number
  
  id
Returns number
Inherited from UserDao.deleteById
- Defined in lib/user/userDao.ts:1753

deleteRow

deleteRow(row: TileRow): number
Delete the row passed in
Parameters
- row: TileRow
Returns number
Inherited from UserDao.deleteRow
- Defined in lib/user/userDao.ts:1724

deleteTile

deleteTile(column: number, row: number, zoomLevel: number): number
Delete a Tile

Returns
number deleted, should be 0 or 1
Parameters
- column: number
  
  column
- row: number
  
  row
- zoomLevel: number
  
  zoom level
Returns number
- Defined in lib/tiles/user/tileDao.ts:571

deleteWithFieldValues

deleteWithFieldValues(fieldValues: FieldValues): number
Delete rows matching the field values

Returns
deleted count
Parameters
- fieldValues: FieldValues
  
  field values
Returns number
Inherited from UserDao.deleteWithFieldValues
- Defined in lib/user/userDao.ts:1762

determineGeoPackageZoomLevel

determineGeoPackageZoomLevel(zoom: number): number
Parameters
- zoom: number
Returns number
- Defined in lib/tiles/user/tileDao.ts:159

dropColumn

dropColumn(column: TileColumn): void
Drop a column
Parameters
- column: TileColumn
  
  column
Returns void
Inherited from UserDao.dropColumn
- Defined in lib/user/userDao.ts:1653

dropColumnIndexes

dropColumnIndexes(indexes: number[]): void
Drop columns
Parameters
- indexes: number[]
  
  column indexes
Returns void
Inherited from UserDao.dropColumnIndexes
- Defined in lib/user/userDao.ts:1689

dropColumnNames

dropColumnNames(columnNames: string[]): void
Drop columns
Parameters
- columnNames: string[]
  
  column names
Returns void
Inherited from UserDao.dropColumnNames
- Defined in lib/user/userDao.ts:1701

dropColumnWithIndex

dropColumnWithIndex(index: number): void
Drop a column
Parameters
- index: number
  
  column index
Returns void
Inherited from UserDao.dropColumnWithIndex
- Defined in lib/user/userDao.ts:1661

dropColumnWithName

dropColumnWithName(columnName: string): void
Drop a column
Parameters
- columnName: string
  
  column name
Returns void
Inherited from UserDao.dropColumnWithName
- Defined in lib/user/userDao.ts:1669

dropColumns

dropColumns(columns: TileColumn[]): void
Drop columns
Parameters
- columns: TileColumn[]
  
  columns
Returns void
Inherited from UserDao.dropColumns
- Defined in lib/user/userDao.ts:1677

dropTable

dropTable(): void
Drop the user table

Returns void
Inherited from UserDao.dropTable
- Defined in lib/user/userDao.ts:299

getApproximateZoomLevel

getApproximateZoomLevel(length: number): number
Get the approximate zoom level for the provided length in the default units. Tiles may or may not exist for the returned zoom level. The approximate zoom level is determined using a factor of 2 from the zoom levels with tiles.

Returns
approximate zoom level
Parameters
- length: number
  
  length in default units
Returns number
- Defined in lib/tiles/user/tileDao.ts:476

getApproximateZoomLevelForWidthAndHeight

getApproximateZoomLevelForWidthAndHeight(width: number, height: number): number
Get the approximate zoom level for the provided width and height in the default units. Tiles may or may not exist for the returned zoom level. The approximate zoom level is determined using a factor of 2 from the zoom levels with tiles.

Returns
approximate zoom level
Parameters
- width: number
  
  width in default units
- height: number
  
  height in default units
Returns number
- Defined in lib/tiles/user/tileDao.ts:489

getBoundingBox

getBoundingBox(): BoundingBox
Get the bounding box of the user table data

Returns
bounding box of user table data

Returns BoundingBox
Overrides UserDao.getBoundingBox
- Defined in lib/tiles/user/tileDao.ts:166

getBoundingBoxAtZoomLevel

getBoundingBoxAtZoomLevel(zoomLevel: any): BoundingBox
Get the bounding box of tiles

Returns
bounding box of zoom level, or null if no tiles
Parameters
- zoomLevel: any
  
  zoom level
Returns BoundingBox
- Defined in lib/tiles/user/tileDao.ts:196

getBoundingBoxAtZoomLevelWithProjection

getBoundingBoxAtZoomLevelWithProjection(zoomLevel: number, projection: Projection): BoundingBox
Get the bounding box of tiles at the zoom level

Returns
bounding box of zoom level, or nil if no tiles
Parameters
- zoomLevel: number
  
  zoom level
- projection: Projection
  
  desired projection
Returns BoundingBox
- Defined in lib/tiles/user/tileDao.ts:219

getBoundingBoxWithProjection

getBoundingBoxWithProjection(projection: Projection): BoundingBox
Get the bounding box of the user table data

Returns
bounding box of user table data
Parameters
- projection: Projection
  
  desired projection
Returns BoundingBox
Overrides UserDao.getBoundingBoxWithProjection
- Defined in lib/tiles/user/tileDao.ts:173

getClosestZoomLevel

getClosestZoomLevel(length: number): number
Get the closest zoom level for the provided width and height in the default units

Returns
zoom level
Parameters
- length: number
  
  in default units
Returns number
- Defined in lib/tiles/user/tileDao.ts:446

getClosestZoomLevelForWidthAndHeight

getClosestZoomLevelForWidthAndHeight(width: number, height: number): number
Get the closest zoom level for the provided width and height in the default units

Returns
zoom level
Parameters
- width: number
  
  in default units
- height: number
  
  in default units
Returns number
- Defined in lib/tiles/user/tileDao.ts:458

getColumnNames

getColumnNames(): string[]
Get the table column names

Returns
column names

Returns string[]
Inherited from UserDao.getColumnNames
- Defined in lib/user/userDao.ts:228

getColumns

getColumns(): TileColumn[]
Get the table columns

Returns
columns

Returns TileColumn[]
Inherited from UserDao.getColumns
- Defined in lib/user/userDao.ts:219

getContents

getContents(): Contents
Get the contents

Returns
contents

Returns Contents
Inherited from UserDao.getContents
- Defined in lib/user/userDao.ts:246

getCount

getCount(where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): 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
Inherited from UserDao.getCount
- Defined in lib/user/userDao.ts:750

getCountWithColumns

getCountWithColumns(columns?: string[], where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): 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
Inherited from UserDao.getCountWithColumns
- Defined in lib/user/userDao.ts:823

getCountWithDistinct

getCountWithDistinct(distinct?: boolean, where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): 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
Inherited from UserDao.getCountWithDistinct
- Defined in lib/user/userDao.ts:786

getCountWithDistinctAndColumns

getCountWithDistinctAndColumns(distinct?: boolean, columns?: string[], where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): 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
Inherited from UserDao.getCountWithDistinctAndColumns
- Defined in lib/user/userDao.ts:861

getDatabase

getDatabase(): string
Get the database

Returns
database

Returns string
Inherited from UserDao.getDatabase
- Defined in lib/user/userDao.ts:132

getDb

getDb(): GeoPackageConnection
Get the database connection

Returns
database connection

Returns GeoPackageConnection
Inherited from UserDao.getDb
- Defined in lib/user/userDao.ts:148

getGeoPackage

getGeoPackage(): GeoPackage
Get the GeoPackage

Returns GeoPackage
Inherited from UserDao.getGeoPackage
- Defined in lib/user/userDao.ts:139

getMapMaxZoom

getMapMaxZoom(): number
Get the map max zoom level

Returns
map max zoom level

Returns number
- Defined in lib/tiles/user/tileDao.ts:654

getMapMinZoom

getMapMinZoom(): number
Get the map min zoom level

Returns
map min zoom level

Returns number
- Defined in lib/tiles/user/tileDao.ts:645

getMapZoom

getMapZoom(zoomLevel: number): number
Get the map zoom level from the tile matrix zoom level

Returns
map zoom level
Parameters
- zoomLevel: number
  
  tile matrix zoom level
Returns number
- Defined in lib/tiles/user/tileDao.ts:674

getMapZoomRange

getMapZoomRange(): number[]
Get the map zoom level range

Returns
map zoom level range, min at index 0, max at index 1

Returns number[]
- Defined in lib/tiles/user/tileDao.ts:636

getMapZoomWithTileMatrix

getMapZoomWithTileMatrix(tileMatrix: TileMatrix): number
Get the map zoom level from the tile matrix

Returns
map zoom level
Parameters
- tileMatrix: TileMatrix
  
  tile matrix
Returns number
- Defined in lib/tiles/user/tileDao.ts:664

getMaxLength

getMaxLength(): number
Get the max length in default units that contains tiles

Returns
max distance length with tiles

Returns number
- Defined in lib/tiles/user/tileDao.ts:503

getMaxZoom

getMaxZoom(): number
Get the max zoom

Returns
max zoom

Returns number
- Defined in lib/tiles/user/tileDao.ts:344

getMinLength

getMinLength(): number
Get the min length in default units that contains tiles

Returns
min distance length with tiles

Returns number
- Defined in lib/tiles/user/tileDao.ts:511

getMinZoom

getMinZoom(): number
Get the min zoom

Returns
min zoom

Returns number
- Defined in lib/tiles/user/tileDao.ts:336

getPkColumn

getPkColumn(): TileColumn
Get the primary key column

Returns
primary key column

Returns TileColumn
Inherited from UserDao.getPkColumn
- Defined in lib/user/userDao.ts:202

getPkColumnIndex

getPkColumnIndex(): number
Get the primary key column index

Returns
primary key column index

Returns number
Inherited from UserDao.getPkColumnIndex
- Defined in lib/user/userDao.ts:193

getPkColumnName

getPkColumnName(): string
Get the primary key column name

Returns
primary key column name

Returns string
Inherited from UserDao.getPkColumnName
- Defined in lib/user/userDao.ts:211

`Protected` getPkWhere

getPkWhere(id: number): string
Get the primary key where clause

Returns
primary key where clause
Parameters
- id: number
  
  id
Returns string
Inherited from UserDao.getPkWhere
- Defined in lib/user/userDao.ts:1209

`Protected` getPkWhereArgs

getPkWhereArgs(id: number): DBValue[]
Get the primary key where args

Returns
primary key where args
Parameters
- id: number
  
  id
Returns DBValue[]
Inherited from UserDao.getPkWhereArgs
- Defined in lib/user/userDao.ts:1218

getProjection

getProjection(): Projection
Get the projection

Returns
projection

Returns Projection
Inherited from UserDao.getProjection
- Defined in lib/user/userDao.ts:255

getSrs

getSrs(): SpatialReferenceSystem
Get the Spatial Reference System

Returns
srs

Returns SpatialReferenceSystem
- Defined in lib/tiles/user/tileDao.ts:320

getSrsId

getSrsId(): number
Get the Spatial Reference System id

Returns
srs id

Returns number
- Defined in lib/tiles/user/tileDao.ts:328

getTable

getTable(): TileTable
Get the table

Returns
table

Returns TileTable
Inherited from UserDao.getTable
- Defined in lib/user/userDao.ts:175

getTableName

getTableName(): string
Get the table name

Returns
table name

Returns string
Inherited from UserDao.getTableName
- Defined in lib/user/userDao.ts:166

getTileDb

getTileDb(): TileConnection
Get the Tile connection

Returns
tile connection

Returns TileConnection
- Defined in lib/tiles/user/tileDao.ts:264

getTileGrid

getTileGrid(zoomLevel: number): TileGrid
Get the tile grid of the zoom level

Returns
tile grid at zoom level, null if not tile matrix at zoom level
Parameters
- zoomLevel: number
  
  zoom level
Returns TileGrid
- Defined in lib/tiles/user/tileDao.ts:235

getTileGridWithZoomLevel

getTileGridWithZoomLevel(zoomLevel: number): TileGrid
Get the tile grid of the zoom level

Returns
tile grid at zoom level, null if no tile matrix at zoom level
Parameters
- zoomLevel: number
  
  zoom level
Returns TileGrid
- Defined in lib/tiles/user/tileDao.ts:182

getTileMatrices

getTileMatrices(): TileMatrix[]
Get the tile matrices

Returns
tile matrices

Returns TileMatrix[]
- Defined in lib/tiles/user/tileDao.ts:282

getTileMatrix

getTileMatrix(zoomLevel: number): TileMatrix
Get the tile matrix at the zoom level

Returns
tile matrix
Parameters
- zoomLevel: number
  
  zoom level
Returns TileMatrix
- Defined in lib/tiles/user/tileDao.ts:299

getTileMatrixAtMinZoom

getTileMatrixAtMinZoom(): TileMatrix
Get the tile matrix at the min (first) zoom

Returns
tile matrix

Returns TileMatrix
- Defined in lib/tiles/user/tileDao.ts:311

getTileMatrixDao

getTileMatrixDao(): TileMatrixDao
Get a tile matrix DAO

Returns
tile matrix DAO

Returns TileMatrixDao
- Defined in lib/tiles/user/tileDao.ts:691

getTileMatrixSet

getTileMatrixSet(): TileMatrixSet
Get the tile matrix set

Returns
tile matrix set

Returns TileMatrixSet
- Defined in lib/tiles/user/tileDao.ts:273

getTileMatrixSetDao

getTileMatrixSetDao(): TileMatrixSetDao
Get a tile matrix set DAO

Returns
tile matrix set DAO

Returns TileMatrixSetDao
- Defined in lib/tiles/user/tileDao.ts:682

getUserDb

getUserDb(): UserConnection<TileColumn, TileTable, TileRow, TileResultSet>
Get the user database connection

Returns
user database connection

Returns UserConnection<TileColumn, TileTable, TileRow, TileResultSet>
Inherited from UserDao.getUserDb
- Defined in lib/user/userDao.ts:157

getZoomLevel

getZoomLevel(length: number): number
Get the zoom level for the provided width and height in the default units

Returns
zoom level
Parameters
- length: number
  
  in default units
Returns number
- Defined in lib/tiles/user/tileDao.ts:425

getZoomLevelForBoundingBox

getZoomLevelForBoundingBox(): number
Get the approximate zoom level of where the bounding box of the user data fits into the world

Returns
zoom level

Returns number
Inherited from UserDao.getZoomLevelForBoundingBox
- Defined in lib/user/userDao.ts:1384

getZoomLevelForWidthAndHeight

getZoomLevelForWidthAndHeight(width: number, height: number): number
Get the zoom level for the provided width and height in the default units

Returns
zoom level
Parameters
- width: number
  
  in default units
- height: number
  
  in default units
Returns number
- Defined in lib/tiles/user/tileDao.ts:436

getZoomLevels

getZoomLevels(): number[]
Get the zoom levels

Returns
zoom level set

Returns number[]
- Defined in lib/tiles/user/tileDao.ts:290

hasPkColumn

hasPkColumn(): boolean
Check if the table has a primary key column

Returns
true if has a primary key

Returns boolean
Inherited from UserDao.hasPkColumn
- Defined in lib/user/userDao.ts:184

insert

insert(row: TileRow): number
Inherit Doc
Parameters
- row: TileRow
Returns number
Inherited from UserDao.insert
- Defined in lib/user/userDao.ts:1844

insertOrThrow

insertOrThrow(values: ContentValues): number
Inserts a new row

Returns
row id
Parameters
- values: ContentValues
  
  content values
Returns number
Inherited from UserDao.insertOrThrow
- Defined in lib/user/userDao.ts:1870

insertWithContentValues

insertWithContentValues(values: ContentValues): number
Inserts a new row

Returns
row id, -1 on error
Parameters
- values: ContentValues
  
  content values
Returns number
Inherited from UserDao.insertWithContentValues
- Defined in lib/user/userDao.ts:1859

isPkModifiable

isPkModifiable(): boolean
Is the primary key modifiable

Returns
true if the primary key is modifiable

Returns boolean
Inherited from UserDao.isPkModifiable
- Defined in lib/user/userDao.ts:264

isTableExists

isTableExists(): boolean
Checks if the table exists

Returns boolean
Inherited from UserDao.isTableExists
- Defined in lib/user/userDao.ts:2061

isValueValidation

isValueValidation(): boolean
Is value validation against column types enabled

Returns
true if values are validated against column types

Returns boolean
Inherited from UserDao.isValueValidation
- Defined in lib/user/userDao.ts:282

isXYZTiles

isXYZTiles(): boolean
Determine if the tiles are in the XYZ tile coordinate format

Returns
true if XYZ tile format

Returns boolean
- Defined in lib/tiles/user/tileDao.ts:600

max

max(column: string, where?: string, args?: any): 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
Inherited from UserDao.max
- Defined in lib/user/userDao.ts:1892

min

min(column: string, where?: string, args?: any): 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
Inherited from UserDao.min
- Defined in lib/user/userDao.ts:1881

newRow

newRow(): TileRow
Get a new empty row

Returns
row

Returns TileRow
Overrides UserDao.newRow
- Defined in lib/tiles/user/tileDao.ts:256

`Protected` prepareResult

prepareResult(result: TileResultSet): TileResultSet
Prepare the result before returning

Returns
prepared result
Parameters
- result: TileResultSet
  
  result
Returns TileResultSet
Inherited from UserDao.prepareResult
- Defined in lib/user/userDao.ts:123

projectBoundingBox

projectBoundingBox(boundingBox: BoundingBox, projection: Projection): BoundingBox
Project the provided bounding box in the declared projection to the user DAO projection

Returns
projected bounding box
Parameters
- boundingBox: BoundingBox
  
  bounding box
- projection: Projection
  
  projection
Returns BoundingBox
Inherited from UserDao.projectBoundingBox
- Defined in lib/user/userDao.ts:107

query

query(where?: string, whereArgs?: any[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.query
- Defined in lib/user/userDao.ts:588

queryByTileGrid

queryByTileGrid(tileGrid: TileGrid, zoomLevel: number, orderBy?: string): TileResultSet
Query by tile grid and zoom level

Returns
result set from query or null if the zoom level tile ranges do not overlap the bounding box
Parameters
- tileGrid: TileGrid
  
  tile grid
- zoomLevel: number
  
  zoom level
- Optional orderBy: string
  
  order by
Returns TileResultSet
- Defined in lib/tiles/user/tileDao.ts:522

queryForAll

queryForAll(): TileResultSet
Query for all rows

Returns
result

Returns TileResultSet
Inherited from UserDao.queryForAll
- Defined in lib/user/userDao.ts:328

queryForChunk

queryForChunk(where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForChunk
- Defined in lib/user/userDao.ts:1468

queryForChunkWithColumns

queryForChunkWithColumns(columns?: string[], where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForChunkWithColumns
- Defined in lib/user/userDao.ts:1517

queryForChunkWithDistinct

queryForChunkWithDistinct(distinct?: boolean, where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForChunkWithDistinct
- Defined in lib/user/userDao.ts:1492

queryForChunkWithDistinctAndColumns

queryForChunkWithDistinctAndColumns(distinct?: boolean, columns?: string[], where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForChunkWithDistinctAndColumns
- Defined in lib/user/userDao.ts:1543

queryForEq

queryForEq(property: string, value: any, groupBy?: string, having?: string, orderBy?: string): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForEq
- Defined in lib/user/userDao.ts:1976

queryForEqWithColumns

queryForEqWithColumns(columns?: string[], property: string, value: any, groupBy?: string, having?: string, orderBy?: string): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForEqWithColumns
- Defined in lib/user/userDao.ts:2011

queryForEqWithDistinct

queryForEqWithDistinct(distinct?: boolean, property: string, value: any, groupBy?: string, having?: string, orderBy?: string): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForEqWithDistinct
- Defined in lib/user/userDao.ts:1990

queryForEqWithDistinctAndColumns

queryForEqWithDistinctAndColumns(distinct?: boolean, columns?: string[], fieldName: string, value: any, groupBy?: string, having?: string, orderBy?: string): TileResultSet
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 TileResultSet
Inherited from UserDao.queryForEqWithDistinctAndColumns
- Defined in lib/user/userDao.ts:2032

queryForEqWithFieldAndValue

queryForEqWithFieldAndValue(fieldName: string, value: any): TileResultSet
Query for the row where the field equals the value

Returns
result
Parameters
- fieldName: string
  
  field name
- value: any
  
  value
Returns TileResultSet
Inherited from UserDao.queryForEqWithFieldAndValue
- Defined in lib/user/userDao.ts:1408

queryForFieldValues

queryForFieldValues(fieldValues: FieldValues): TileResultSet
Query for the row where all fields match their values

Returns
result
Parameters
- fieldValues: FieldValues
  
  field values
Returns TileResultSet
Inherited from UserDao.queryForFieldValues
- Defined in lib/user/userDao.ts:1901

queryForFieldValuesWithColumns

queryForFieldValuesWithColumns(columns?: string[], fieldValues: FieldValues): TileResultSet
Query for the row where all fields match their values

Returns
result
Parameters
- columns: string[] = ...
  
  columns
- fieldValues: FieldValues
  
  field values
Returns TileResultSet
Inherited from UserDao.queryForFieldValuesWithColumns
- Defined in lib/user/userDao.ts:1921

queryForFieldValuesWithDistinct

queryForFieldValuesWithDistinct(distinct?: boolean, fieldValues: FieldValues): TileResultSet
Query for the row where all fields match their values

Returns
result
Parameters
- distinct: boolean = false
  
  distinct rows
- fieldValues: FieldValues
  
  field values
Returns TileResultSet
Inherited from UserDao.queryForFieldValuesWithDistinct
- Defined in lib/user/userDao.ts:1911

queryForFieldValuesWithDistinctAndColumns

queryForFieldValuesWithDistinctAndColumns(distinct?: boolean, columns?: string[], fieldValues: FieldValues): TileResultSet
Query for the row where all fields match their values

Returns
result
Parameters
- distinct: boolean = false
  
  distinct rows
- columns: string[] = ...
  
  columns
- fieldValues: FieldValues
  
  field values
Returns TileResultSet
Inherited from UserDao.queryForFieldValuesWithDistinctAndColumns
- Defined in lib/user/userDao.ts:1935

queryForId

queryForId(id: number): TileResultSet
Query for the row with the provided id

Returns
row
Parameters
- id: number
  
  id
Returns TileResultSet
Inherited from UserDao.queryForId
- Defined in lib/user/userDao.ts:1156

queryForIdRow

queryForIdRow(id: number): TileRow
Query for the row with the provided id

Returns
row
Parameters
- id: number
  
  id
Returns TileRow
Inherited from UserDao.queryForIdRow
- Defined in lib/user/userDao.ts:1141

queryForIdRows

queryForIdRows(ids: number[]): TileRow[]
Gets the rows in this table by id

Returns
rows array
Parameters
- ids: number[]
  
  ids to query for
Returns TileRow[]
Inherited from UserDao.queryForIdRows
- Defined in lib/user/userDao.ts:1125

queryForLike

queryForLike(field: string, value: any): TileResultSet
Query for the rows that are like the column

Returns
result
Parameters
- field: string
- value: any
Returns TileResultSet
Inherited from UserDao.queryForLike
- Defined in lib/user/userDao.ts:1953

queryForTile

queryForTile(column: number, row: number, zoomLevel: number): TileRow
Query for a Tile

Returns
tile row
Parameters
- column: number
  
  column
- row: number
  
  row
- zoomLevel: number
  
  zoom level
Returns TileRow
- Defined in lib/tiles/user/tileDao.ts:355

queryForTileGrid

queryForTileGrid(zoomLevel: number): TileGrid
Query for the bounding

Returns
tile grid of tiles at the zoom level
Parameters
- zoomLevel: number
  
  zoom level
Returns TileGrid
- Defined in lib/tiles/user/tileDao.ts:547

queryForTiles

queryForTiles(zoomLevel: number): TileResultSet
Query for Tiles at a zoom level

Returns
tile result set, should be closed
Parameters
- zoomLevel: number
  
  zoom level
Returns TileResultSet
- Defined in lib/tiles/user/tileDao.ts:374

queryForTilesDescending

queryForTilesDescending(zoomLevel: number): TileResultSet
Query for Tiles at a zoom level in descending row and column order

Returns
tile result set, should be closed
Parameters
- zoomLevel: number
  
  zoom level
Returns TileResultSet
- Defined in lib/tiles/user/tileDao.ts:383

queryForTilesInColumn

queryForTilesInColumn(column: number, zoomLevel: number): TileResultSet
Query for Tiles at a zoom level and column

Returns
tile result set
Parameters
- column: number
  
  column
- zoomLevel: number
  
  zoom level
Returns TileResultSet
- Defined in lib/tiles/user/tileDao.ts:399

queryForTilesInRow

queryForTilesInRow(row: number, zoomLevel: number): TileResultSet
Query for Tiles at a zoom level and row

Returns
tile result set
Parameters
- row: number
  
  row
- zoomLevel: number
  
  zoom level
Returns TileResultSet
- Defined in lib/tiles/user/tileDao.ts:413

queryIdsSQL

queryIdsSQL(distinct?: boolean, where?: string): string
Query SQL for all row ids

Returns
SQL
Parameters
- distinct: boolean = false
  
  distinct rows
- Optional where: string
  
  where
Returns string
Inherited from UserDao.queryIdsSQL
- Defined in lib/user/userDao.ts:1188

queryIn

queryIn(nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[]): TileResultSet
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 TileResultSet
Inherited from UserDao.queryIn
- Defined in lib/user/userDao.ts:341

queryInForChunk

queryInForChunk(nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryInForChunk
- Defined in lib/user/userDao.ts:423

queryInForChunkWithColumns

queryInForChunkWithColumns(columns: string[], nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryInForChunkWithColumns
- Defined in lib/user/userDao.ts:506

queryInForChunkWithDistinct

queryInForChunkWithDistinct(distinct: boolean, nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryInForChunkWithDistinct
- Defined in lib/user/userDao.ts:464

queryInForChunkWithDistinctAndColumns

queryInForChunkWithDistinctAndColumns(distinct: boolean, columns: string[], nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[], groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryInForChunkWithDistinctAndColumns
- Defined in lib/user/userDao.ts:549

queryInWithColumns

queryInWithColumns(columns: string[], nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[]): TileResultSet
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 TileResultSet
Inherited from UserDao.queryInWithColumns
- Defined in lib/user/userDao.ts:375

queryInWithDistinct

queryInWithDistinct(distinct: boolean, nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[]): TileResultSet
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 TileResultSet
Inherited from UserDao.queryInWithDistinct
- Defined in lib/user/userDao.ts:355

queryInWithDistinctAndColumns

queryInWithDistinctAndColumns(distinct?: boolean, columns?: string[], nestedSQL?: string, nestedArgs?: any[], where?: string, whereArgs?: any[]): TileResultSet
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 TileResultSet
Inherited from UserDao.queryInWithDistinctAndColumns
- Defined in lib/user/userDao.ts:396

querySQL

querySQL(distinct: boolean, columns: string[], where?: string): string
Query SQL for all rows

Returns
SQL
Parameters
- distinct: boolean
  
  distinct rows
- columns: string[]
  
  columns
- Optional where: string
  
  where
Returns string
Inherited from UserDao.querySQL
- Defined in lib/user/userDao.ts:1200

querySingleColumnTypedResults

querySingleColumnTypedResults(sql: string, args: string[], columnName: string, limit?: number): any[]
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[]
Inherited from UserDao.querySingleColumnTypedResults
- Defined in lib/user/userDao.ts:1776

querySingleColumnTypedResultsWithColumnIndex

querySingleColumnTypedResultsWithColumnIndex(sql: string, args: string[], columnIndex?: number, limit?: number): 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[]
Inherited from UserDao.querySingleColumnTypedResultsWithColumnIndex
- Defined in lib/user/userDao.ts:1791

querySingleResult

querySingleResult(sql: string, args: string[]): 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
Inherited from UserDao.querySingleResult
- Defined in lib/user/userDao.ts:1170

queryWithColumns

queryWithColumns(columns: string[], where?: string, whereArgs?: any[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryWithColumns
- Defined in lib/user/userDao.ts:661

queryWithDistinct

queryWithDistinct(distinct: boolean, where?: string, whereArgs?: any[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryWithDistinct
- Defined in lib/user/userDao.ts:624

queryWithDistinctAndColumns

queryWithDistinctAndColumns(distinct?: boolean, columns?: string[], where?: string, whereArgs?: any[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
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 TileResultSet
Inherited from UserDao.queryWithDistinctAndColumns
- Defined in lib/user/userDao.ts:699

rawQueryWithArgs

rawQueryWithArgs(sql: string, selectionArgs?: []): TileResultSet
Raw query

Returns
result
Parameters
- sql: string
  
  SQL
- Optional selectionArgs: []
  
  selection args
Returns TileResultSet
Inherited from UserDao.rawQueryWithArgs
- Defined in lib/user/userDao.ts:309

rawQueryWithColumns

rawQueryWithColumns(sql: string, columns: string[], selectionArgs: any[]): TileResultSet
Raw query

Returns
result
Parameters
- sql: string
  
  SQL
- columns: string[]
  
  subset of table columns defined in the SQL
- selectionArgs: any[]
  
  selection args
Returns TileResultSet
Inherited from UserDao.rawQueryWithColumns
- Defined in lib/user/userDao.ts:320

renameColumn

renameColumn(column: TileColumn, newColumnName: string): void
Rename column
Parameters
- column: TileColumn
  
  column
- newColumnName: string
  
  new column name
Returns void
Inherited from UserDao.renameColumn
- Defined in lib/user/userDao.ts:1617

renameColumnWithIndex

renameColumnWithIndex(index: number, newColumnName: string): void
Rename column
Parameters
- index: number
  
  column index
- newColumnName: string
  
  new column name
Returns void
Inherited from UserDao.renameColumnWithIndex
- Defined in lib/user/userDao.ts:1635

renameColumnWithName

renameColumnWithName(columnName: string, newColumnName: string): void
Rename column
Parameters
- columnName: string
  
  column name
- newColumnName: string
  
  new column name
Returns void
Inherited from UserDao.renameColumnWithName
- Defined in lib/user/userDao.ts:1626

`Protected` renameTableColumn

renameTableColumn(columnName: string, newColumnName: string): void
Rename a table column
Parameters
- columnName: string
  
  column name
- newColumnName: string
  
  new column name
Returns void
Inherited from UserDao.renameTableColumn
- Defined in lib/user/userDao.ts:1644

setPkModifiable

setPkModifiable(pkModifiable: boolean): void
Set if the primary key can be modified
Parameters
- pkModifiable: boolean
  
  primary key modifiable flag
Returns void
Inherited from UserDao.setPkModifiable
- Defined in lib/user/userDao.ts:273

setValueValidation

setValueValidation(valueValidation: boolean): void
Set if values should validated against column types
Parameters
- valueValidation: boolean
  
  value validation flag
Returns void
Inherited from UserDao.setValueValidation
- Defined in lib/user/userDao.ts:292

setWebMapZoomLevels

setWebMapZoomLevels(): void
Returns void
- Defined in lib/tiles/user/tileDao.ts:127

update

update(row: TileRow): number
Updates a row
Parameters
- row: TileRow
Returns number
Inherited from UserDao.update
- Defined in lib/user/userDao.ts:1810

updateWithContentValues

updateWithContentValues(values: ContentValues, whereClause?: string, whereArgs?: []): number
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
Inherited from UserDao.updateWithContentValues
- Defined in lib/user/userDao.ts:1833

webZoomToGeoPackageZoom

webZoomToGeoPackageZoom(webZoom: number): number
Parameters
- webZoom: number
Returns number
- Defined in lib/tiles/user/tileDao.ts:123

Class TileDao

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

database: string

geoPackage: GeoPackage

tileMatrixSet: TileMatrixSet

tileMatrices: TileMatrix[]

table: TileTable

Returns TileDao

Properties

Protected Readonly geoPackage

Protected projection

Methods

_buildWhereArgsWithArray

Returns

Parameters

values: DBValue[]

Returns DBValue[]

_buildWhereArgsWithColumnValues

Returns

Parameters

values: FieldValues

Returns DBValue[]

addColumn

Parameters

column: TileColumn

Returns void

adjustTileMatrixLengths

Returns void

alterColumn

Parameters

column: TileColumn

Returns void

alterColumns

Parameters

columns: TileColumn[]

Returns void

buildLimit

Returns

Parameters

limit: number

offset: number

Returns string

buildWhere

Returns

Parameters

field: string

value: any

Returns string

buildWhereArgs

Returns

Parameters

values: DBValue | DBValue[] | FieldValues

Returns DBValue[]

buildWhereArgsWithValues

Returns

Parameters

values: DBValue | DBValue[] | FieldValues

Returns any[]

buildWhereIn

Returns

Parameters

nestedSQL: string

where: string

Returns string

buildWhereInArgs

Returns

Parameters

nestedArgs: any[]

whereArgs: any[]

Returns any[]

buildWhereLike

Returns

Parameters

`Protected` `Readonly` geoPackage

`Protected` projection

`Optional` operation: string = 'and'

`Optional` where: string

`Optional` whereArgs: [] | DBValue[]

`Optional` join: string

`Optional` groupBy: string

`Optional` having: string

`Optional` orderBy: string

`Optional` limit: number

`Optional` offset: number

`Optional` groupBy: string

`Optional` having: string

`Optional` orderBy: string

`Optional` nestedSQL: string

`Optional` nestedArgs: string[]

`Optional` where: string

`Optional` whereArgs: string[]