Class OINODbAbstract

constructor

• new OINODb(params: OINODbParams): OINODb

  Constructor for OINODb.

  Parameters

  • params: OINODbParams

    database parameters

  Returns OINODb

Readonlyname

Abstractconnect

• connect(): Promise<OINOResult>

  Connect to database.

  Returns Promise<OINOResult>

AbstractinitializeApiDatamodel

• 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>

AbstractparseSqlValueAsCell

• 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

AbstractprintCellAsSqlValue

• 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

AbstractprintSqlColumnname

• printSqlColumnname(sqlColumn: string): string

  Print a column name with correct SQL escaping.

  Parameters

  • sqlColumn: string

    name of the column

  Returns string

printSqlSelect

• printSqlSelect(
      tableName: string,
      columnNames: string,
      whereCondition: string,
      orderCondition: string,
      limitCondition: string,
      groupByCondition: string,
  ): string

  Print SQL select statement with DB specific formatting.

  Parameters

  • tableName: string

    The name of the table to select from.
  • columnNames: string

    The columns to be selected.
  • whereCondition: string

    The WHERE clause to filter the results.
  • orderCondition: string

    The ORDER BY clause to sort the results.
  • limitCondition: string

    The LIMIT clause to limit the number of results.
  • groupByCondition: string

    The GROUP BY clause to group the results.

  Returns string

AbstractprintSqlString

• printSqlString(sqlString: string): string

  Print a single string value as valid sql literal

  Parameters

  • sqlString: string

    string value

  Returns string

AbstractprintSqlTablename

• printSqlTablename(sqlTable: string): string

  Print a table name using database specific SQL escaping.

  Parameters

  • sqlTable: string

    name of the table

  Returns string

AbstractsqlExec

• sqlExec(sql: string): Promise<OINODbDataSet>

  Execute other sql operations.

  Parameters

  • sql: string

    SQL statement.

  Returns Promise<OINODbDataSet>

AbstractsqlSelect

• sqlSelect(sql: string): Promise<OINODbDataSet>

  Execute a select operation.

  Parameters

  • sql: string

    SQL statement.

  Returns Promise<OINODbDataSet>

Abstractvalidate

• validate(): Promise<OINOResult>

  Validate connection to database is working.

  Returns Promise<OINOResult>