Methods
Optional xBegin
- xBegin(pVTab: number): number
xClose
- xClose(pCursor: number): number
xColumn
- xColumn(pCursor: number, pContext: number, iCol: number): number
Parameters
pCursor: number
pContext: number
iCol: number
Returns number
Optional xCommit
- xCommit(pVTab: number): number
xConnect
- xConnect(db: number, appData: any, argv: string[], pVTab: number, pzErr: DataView): number
Parameters
db: number
appData: any
argv: string[]
pVTab: number
pzErr: DataView
Returns number
Optional xCreate
- xCreate(db: number, appData: any, argv: string[], pVTab: number, pzErr: DataView): number
Parameters
db: number
appData: any
argv: string[]
pVTab: number
pzErr: DataView
Returns number
xDestroy
- xDestroy(pVTab: number): number
xDisconnect
- xDisconnect(pVTab: number): number
xEof
- xEof(pCursor: number): number
xFilter
- xFilter(pCursor: number, idxNum: number, idxString: string, values: number[]): number
Parameters
pCursor: number
idxNum: number
idxString: string
values: number[]
Returns number
xNext
- xNext(pCursor: number): number
xOpen
- xOpen(pVTab: number, pCursor: number): number
Parameters
pVTab: number
pCursor: number
Returns number
Optional xRename
- xRename(pVTab: number, zNew: string): number
Parameters
pVTab: number
zNew: string
Returns number
Optional xRollback
- xRollback(pVTab: number): number
xRowid
- xRowid(pCursor: number, pRowid: DataView): number
Parameters
pCursor: number
pRowid: DataView
Returns number
Optional xSync
- xSync(pVTab: number): number
Optional xUpdate
- xUpdate(pVTab: number, values: number[], pRowId: DataView): number
Parameters
pVTab: number
values: number[]
pRowId: DataView
Returns number
SQLite Module object
Objects with this interface can be passed to SQLiteAPI.create_module to define a module for virtual tables.
There is an example ArrayModule.js that allows a virtual table to reference a Javascript array.
https://sqlite.org/vtab.html