Class OINODbBunSqlite

Implementation of BunSqlite-database.

Hierarchy

OINODb
- OINODbBunSqlite

Index

Constructors

Methods

connect initializeApiDatamodel parseSqlValueAsCell printCellAsSqlValue printSqlColumnname printSqlString printSqlTablename sqlExec sqlSelect validate

Constructors

constructor

new OINODbBunSqlite(params: OINODbParams): OINODbBunSqlite
OINODbBunSqlite constructor
Parameters
- params: OINODbParams
  database parameters
Returns OINODbBunSqlite
Overrides OINODb.constructor
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:37

Methods

connect

connect(): Promise<OINOResult>
Connect to database.

Returns Promise<OINOResult>
Overrides OINODb.connect
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:162

initializeApiDatamodel

initializeApiDatamodel(api: OINODbApi): Promise<void>
Initialize a data model by getting the SQL schema and populating OINODbDataFields of the model.
Parameters
- api: OINODbApi
  api which data model to initialize.
Returns Promise<void>
Overrides OINODb.initializeApiDatamodel
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:262

parseSqlValueAsCell

parseSqlValueAsCell(sqlValue: OINODataCell, sqlType: string): OINODataCell
Parse a single SQL result value for serialization using the context of the native data type.
Parameters
- sqlValue: OINODataCell
  data from serialization
- sqlType: string
  native type name for table column
Returns OINODataCell
Overrides OINODb.parseSqlValueAsCell
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:132

printCellAsSqlValue

printCellAsSqlValue(cellValue: OINODataCell, sqlType: string): string
Print a single data value from serialization using the context of the native data type with the correct SQL escaping.
Parameters
- cellValue: OINODataCell
  data from sql results
- sqlType: string
  native type name for table column
Returns string
Overrides OINODb.printCellAsSqlValue
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:87

printSqlColumnname

printSqlColumnname(sqlColumn: string): string
Print a column name with correct SQL escaping.
Parameters
- sqlColumn: string
  name of the column
Returns string
Overrides OINODb.printSqlColumnname
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:75

printSqlString

printSqlString(sqlString: string): string
Print a single string value as valid sql literal
Parameters
- sqlString: string
  string value
Returns string
Overrides OINODb.printSqlString
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:120

printSqlTablename

printSqlTablename(sqlTable: string): string
Print a table name using database specific SQL escaping.
Parameters
- sqlTable: string
  name of the table
Returns string
Overrides OINODb.printSqlTablename
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:65

sqlExec

sqlExec(sql: string): Promise<OINODbDataSet>
Execute other sql operations.
Parameters
- sql: string
  SQL statement.
Returns Promise<OINODbDataSet>
Overrides OINODb.sqlExec
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:231

sqlSelect

sqlSelect(sql: string): Promise<OINODbDataSet>
Execute a select operation.
Parameters
- sql: string
  SQL statement.
Returns Promise<OINODbDataSet>
Overrides OINODb.sqlSelect
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:212

validate

validate(): Promise<OINOResult>
Validate connection to database is working.

Returns Promise<OINOResult>
Overrides OINODb.validate
- Defined in db-bunsqlite/src/OINODbBunSqlite.ts:181