Class FeatureConnection

GeoPackage Feature Connection

Hierarchy

UserConnection<FeatureColumn, FeatureTable, FeatureRow, FeatureResultSet>
- FeatureConnection

Index

Constructors

constructor

new FeatureConnection(database: GeoPackageConnection): FeatureConnection
Constructor
Parameters
- database: GeoPackageConnection
  
  GeoPackage connection
Returns FeatureConnection
Overrides UserConnection.constructor
- Defined in lib/features/user/featureConnection.ts:17

Properties

`Protected` `Readonly` connection

connection: GeoPackageConnection

Connection

`Protected` table

table: FeatureTable

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: string[]): FeatureResultSet
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 FeatureResultSet
Overrides UserConnection.createResult
- Defined in lib/features/user/featureConnection.ts:24

getConnection

getConnection(): GeoPackageConnection
Get the connection

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

getTable

getTable(): FeatureTable
Get the table

Returns
table

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

rawQueryWithColumns

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

setTable

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

Class FeatureConnection

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

database: GeoPackageConnection

Returns FeatureConnection

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: string[]

Returns FeatureResultSet

getConnection

Returns GeoPackageConnection

getTable

Returns

Returns FeatureTable

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 FeatureResultSet

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