Class AttributesConnection

GeoPackage Attributes Connection

Hierarchy

UserConnection<AttributesColumn, AttributesTable, AttributesRow, AttributesResultSet>
- AttributesConnection

Index

Constructors

constructor

new AttributesConnection(database: GeoPackageConnection): AttributesConnection
Constructor
Parameters
- database: GeoPackageConnection
  
  GeoPackage connection
Returns AttributesConnection
Overrides UserConnection.constructor
- Defined in lib/attributes/attributesConnection.ts:22

Properties

`Protected` `Readonly` connection

connection: GeoPackageConnection

Connection

`Protected` table

table: AttributesTable

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[]): AttributesResultSet
Create a result by wrapping the ResultSet

Returns
result
Parameters
- columns: string[]
  
  result set
- resultSet: ResultSet
  
  result set
- sql: string
  
  SQL statement
- selectionArgs: string[]
  
  selection arguments
Returns AttributesResultSet
Overrides UserConnection.createResult
- Defined in lib/attributes/attributesConnection.ts:29

getConnection

getConnection(): GeoPackageConnection
Get the connection

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

getTable

getTable(): AttributesTable
Get the table

Returns
table

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

rawQueryWithColumns

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

setTable

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

Class AttributesConnection

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

database: GeoPackageConnection

Returns AttributesConnection

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

Returns

Parameters

columns: string[]

resultSet: ResultSet

sql: string

selectionArgs: string[]

Returns AttributesResultSet

getConnection

Returns GeoPackageConnection

getTable

Returns

Returns AttributesTable

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 AttributesResultSet

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

`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