Interface DBAdapter

Hierarchy

DBAdapter

Implemented by

Index

Properties

db

db: any

filePath

filePath: string | Buffer | Uint8Array

Methods

all

all(sql: string, params?: [] | Record<string, any>): Record<string, any>[]
Parameters
- sql: string
- Optional params: [] | Record<string, any>
Returns Record<string, any>[]
- Defined in lib/db/dbAdapter.ts:17

bindAndInsert

bindAndInsert(statement: any, params?: [] | Record<string, any>): number
Parameters
- statement: any
- Optional params: [] | Record<string, any>
Returns number
- Defined in lib/db/dbAdapter.ts:22

close

close(): void
Returns void
- Defined in lib/db/dbAdapter.ts:11

closeStatement

closeStatement(statement: any): void
Parameters
- statement: any
Returns void
- Defined in lib/db/dbAdapter.ts:23

count

count(tableName: string, where?: string, whereArgs?: [] | Record<string, any>): number
Parameters
- tableName: string
- Optional where: string
- Optional whereArgs: [] | Record<string, any>
Returns number
- Defined in lib/db/dbAdapter.ts:26

delete

delete(sql: string, params?: [] | Record<string, any>): number
Parameters
- sql: string
- Optional params: [] | Record<string, any>
Returns number
- Defined in lib/db/dbAdapter.ts:24

dropTable

dropTable(table: string): boolean
Parameters
- table: string
Returns boolean
- Defined in lib/db/dbAdapter.ts:25

each

each(sql: string, params?: [] | Record<string, any>): IterableIterator<Record<string, DBValue>>
Parameters
- sql: string
- Optional params: [] | Record<string, any>
Returns IterableIterator<Record<string, DBValue>>
- Defined in lib/db/dbAdapter.ts:18

export

export(): Promise<any>
Returns Promise<any>
- Defined in lib/db/dbAdapter.ts:13

get

get(sql: string, params?: [] | Record<string, any>): Record<string, any>
Parameters
- sql: string
- Optional params: [] | Record<string, any>
Returns Record<string, any>
- Defined in lib/db/dbAdapter.ts:15

getDBConnection

getDBConnection(): any
Returns any
- Defined in lib/db/dbAdapter.ts:12

initialize

initialize(): Promise<DBAdapter>
Returns a Promise which, when resolved, returns a DBAdapter which has connected to the GeoPackage database file

Returns Promise<DBAdapter>
- Defined in lib/db/dbAdapter.ts:10

insert

insert(sql: string, params?: [] | Record<string, any>): number
Parameters
- sql: string
- Optional params: [] | Record<string, any>
Returns number
- Defined in lib/db/dbAdapter.ts:20

isTableExists

isTableExists(tableName: string): boolean
Parameters
- tableName: string
Returns boolean
- Defined in lib/db/dbAdapter.ts:16

prepareStatement

prepareStatement(sql: string): any
Parameters
- sql: string
Returns any
- Defined in lib/db/dbAdapter.ts:21

query

query(sql: string, params: [] | Record<string, any>): ResultSet
Parameters
- sql: string
- params: [] | Record<string, any>
Returns ResultSet
- Defined in lib/db/dbAdapter.ts:30

readableSize

readableSize(): string
Returns string
- Defined in lib/db/dbAdapter.ts:29

registerFunction

registerFunction(name: string, functionDefinition: Function): DBAdapter
Parameters
- name: string
- functionDefinition: Function
Returns DBAdapter
- Defined in lib/db/dbAdapter.ts:14

run

run(sql: string, params?: [] | Record<string, any>): {
changes: number;
lastInsertRowid: number;
}
Parameters
- sql: string
- Optional params: [] | Record<string, any>
Returns {
changes: number;
lastInsertRowid: number;
}
- changes: number
- lastInsertRowid: number
- Defined in lib/db/dbAdapter.ts:19

size

size(): number
Returns number
- Defined in lib/db/dbAdapter.ts:28

transaction

transaction(func: Function): void
Parameters
- func: Function
Returns void
- Defined in lib/db/dbAdapter.ts:27

unsafe

unsafe(enabled: boolean): void
Parameters
- enabled: boolean
Returns void
- Defined in lib/db/dbAdapter.ts:31

Generated using TypeDoc