Class UserCustomConnection

GeoPackage User Custom Connection

Hierarchy

UserConnection<UserCustomColumn, UserCustomTable, UserCustomRow, UserCustomResultSet>
- UserCustomConnection

Index

Constructors

constructor

new UserCustomConnection(database: GeoPackageConnection): UserCustomConnection
Constructor
Parameters
- database: GeoPackageConnection
  
  database connection
Returns UserCustomConnection
Overrides UserConnection.constructor
- Defined in lib/user/custom/userCustomConnection.ts:22

Properties

`Protected` `Readonly` connection

connection: GeoPackageConnection

Connection

`Protected` table

table: UserCustomTable

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

`Protected` createResult

createResult(columns: string[], resultSet: ResultSet, sql: string, selectionArgs: string[]): UserCustomResultSet
Protected
Create the UserCustomResultSet
Parameters
- columns: string[]
- resultSet: ResultSet
- sql: string
- selectionArgs: string[]
Returns UserCustomResultSet
Overrides UserConnection.createResult
- Defined in lib/user/custom/userCustomConnection.ts:34

getConnection

getConnection(): GeoPackageConnection
Get the connection

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

getTable

getTable(): UserCustomTable
Get the table

Returns
table

Returns UserCustomTable
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): UserCustomResultSet
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 UserCustomResultSet
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: []): UserCustomResultSet
Perform raw query
Parameters
- sql: string
- selectionArgs: []
Returns UserCustomResultSet
Inherited from UserConnection.rawQuery
- Defined in lib/user/userConnection.ts:79

rawQueryWithColumns

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

setTable

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

Class UserCustomConnection

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

database: GeoPackageConnection

Returns UserCustomConnection

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

Protected createResult

Parameters

columns: string[]

resultSet: ResultSet

sql: string

selectionArgs: string[]

Returns UserCustomResultSet

getConnection

Returns GeoPackageConnection

getTable

Returns

Returns UserCustomTable

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 UserCustomResultSet

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

Parameters

`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

`Protected` createResult

`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