Class TileConnection

GeoPackage Tile Connection

Hierarchy

UserConnection<TileColumn, TileTable, TileRow, TileResultSet>
- TileConnection

Index

Constructors

constructor

new TileConnection(database: GeoPackageConnection): TileConnection
Constructor
Parameters
- database: GeoPackageConnection
  
  GeoPackage connection
Returns TileConnection
Overrides UserConnection.constructor
- Defined in lib/tiles/user/tileConnection.ts:17

Properties

`Protected` `Readonly` connection

connection: GeoPackageConnection

Connection

`Protected` table

table: TileTable

Table

Methods

count

count(distinct: boolean, tables: string, columns?: string[], where?: string, whereArgs?: [] | DBValue[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): number
Perform query
Parameters
- distinct: boolean
- tables: string
- Optional 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 UserConnection.count
- Defined in lib/user/userConnection.ts:141

countColumn

countColumn(table: string, distinct: boolean, column: string, where: string, args: any[]): number
Get a count of results

Returns
count
Parameters
- table: string
  
  table name
- distinct: boolean
  
  distinct column flag
- column: string
  
  column name
- where: string
  
  where clause
- args: any[]
  
  arguments
Returns number
Inherited from UserConnection.countColumn
- Defined in lib/user/userConnection.ts:172

createResult

createResult(columns: string[], resultSet: ResultSet, sql: string, selectionArgs: any[]): TileResultSet
Create a result by wrapping the ResultSet

Returns
result
Parameters
- columns: string[]
  
  result set
- resultSet: ResultSet
  
  result set
- sql: string
  
  SQL statement
- selectionArgs: any[]
  
  selection arguments
Returns TileResultSet
Overrides UserConnection.createResult
- Defined in lib/tiles/user/tileConnection.ts:24

getConnection

getConnection(): GeoPackageConnection
Get the connection

Returns GeoPackageConnection
Inherited from UserConnection.getConnection
- Defined in lib/user/userConnection.ts:213

getTable

getTable(): TileTable
Get the table

Returns
table

Returns TileTable
Inherited from UserConnection.getTable
- Defined in lib/user/userConnection.ts:47

query

query(distinct: boolean, tables: string, columns?: string[], where?: string, whereArgs?: any[], join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): TileResultSet
Perform query
Parameters
- distinct: boolean
- tables: string
- Optional 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 UserConnection.query
- Defined in lib/user/userConnection.ts:109

querySQL

querySQL(distinct: boolean, tables: string, columns?: string[], where?: string, join?: string, groupBy?: string, having?: string, orderBy?: string, limit?: number, offset?: number): string
Inherit Doc
Parameters
- distinct: boolean
- tables: string
- Optional columns: string[]
- Optional where: string
- Optional join: string
- Optional groupBy: string
- Optional having: string
- Optional orderBy: string
- Optional limit: number
- Optional offset: number
Returns string
Inherited from UserConnection.querySQL
- Defined in lib/user/userConnection.ts:184

rawQuery

rawQuery(sql: string, selectionArgs: []): TileResultSet
Perform raw query
Parameters
- sql: string
- selectionArgs: []
Returns TileResultSet
Inherited from UserConnection.rawQuery
- Defined in lib/user/userConnection.ts:79

rawQueryWithColumns

rawQueryWithColumns(sql: string, columns: string[], selectionArgs: any[]): TileResultSet
Perform raw query with specified columns
Parameters
- sql: string
- columns: string[]
- selectionArgs: any[]
Returns TileResultSet
Inherited from UserConnection.rawQueryWithColumns
- Defined in lib/user/userConnection.ts:90

setTable

setTable(table: TileTable): void
Set the table
Parameters
- table: TileTable
  
  table
Returns void
Inherited from UserConnection.setTable
- Defined in lib/user/userConnection.ts:55

Class TileConnection

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

database: GeoPackageConnection

Returns TileConnection

Properties

Protected Readonly connection

Protected table

Methods

count

Parameters

distinct: boolean

tables: string

Optional 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

countColumn

Returns

Parameters

table: string

distinct: boolean

column: string

where: string

args: any[]

Returns number

createResult

Returns

Parameters

columns: string[]

resultSet: ResultSet

sql: string

selectionArgs: any[]

Returns TileResultSet

getConnection

Returns GeoPackageConnection

getTable

Returns

Returns TileTable

query

Parameters

distinct: boolean

tables: string

Optional 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

querySQL

Inherit Doc

Parameters

distinct: boolean

tables: string

Optional columns: string[]

Optional where: string

Optional join: string

Optional groupBy: string

Optional having: string

Optional orderBy: string

Optional limit: number

Optional offset: number

Returns string

rawQuery

`Protected` `Readonly` connection

`Protected` table

`Optional` 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

`Optional` 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

`Optional` columns: string[]

`Optional` where: string

`Optional` join: string

`Optional` groupBy: string

`Optional` having: string

`Optional` orderBy: string

`Optional` limit: number

`Optional` offset: number