Class OINODbDataModel

constructor

• new OINODbDataModel(api: OINODbApi): OINODbDataModel

  Constructor of the data model. NOTE! OINODbDataModel.initialize must be called after constructor to populate fields.

  Parameters

  • api: OINODbApi

    api of the data model

  Returns OINODbDataModel

ReadonlydbApi

Readonlyfields

buildDeleteStatement

• buildDeleteStatement(id: string): OINODbSqlStatement

  Build a parameterized SQL DELETE statement for id. Execute with OINODb.runStatement.

  Parameters

  • id: string

    OINO ID (i.e. combined primary key values)

  Returns OINODbSqlStatement

buildInsertStatement

• buildInsertStatement(row: OINODataRow): OINODbSqlStatement

  Build a parameterized SQL INSERT statement from one data row. Execute with OINODb.runStatement.

  Parameters

  • row: OINODataRow

    one row of data in the data model

  Returns OINODbSqlStatement

buildSelectStatement

• buildSelectStatement(id: string, params: OINOQueryParams): OINODbSqlStatement

  Build a parameterized SQL SELECT statement using optional id and filter. Values are bound as parameters; execute with OINODb.runStatement.

  Parameters

  • id: string

    OINO ID (i.e. combined primary key values)
  • params: OINOQueryParams

    OINO request params

  Returns OINODbSqlStatement

buildUpdateStatement

• buildUpdateStatement(id: string, row: OINODataRow): OINODbSqlStatement

  Build a parameterized SQL UPDATE statement from one data row. Execute with OINODb.runStatement.

  Parameters

  • id: string

    OINO ID (i.e. combined primary key values)
  • row: OINODataRow

    one row of data in the data model

  Returns OINODbSqlStatement

printSqlDelete

• printSqlDelete(id: string): string

  Print SQL delete statement for id as an inline (non-parameterized) string.

  Parameters

  • id: string

    OINO ID (i.e. combined primary key values)

  Returns string

  Deprecated

  Prefer buildDeleteStatement + OINODb.runStatement.

printSqlInsert

• printSqlInsert(row: OINODataRow): string

  Print SQL insert statement from one data row as an inline (non-parameterized) string.

  Parameters

  • row: OINODataRow

    one row of data in the data model

  Returns string

  Deprecated

  Prefer buildInsertStatement + OINODb.runStatement.

printSqlSelect

• printSqlSelect(id: string, params: OINOQueryParams): string

  Print SQL select statement using optional id and filter as an inline (non-parameterized) string.

  Parameters

  • id: string

    OINO ID (i.e. combined primary key values)
  • params: OINOQueryParams

    OINO request params

  Returns string

  Deprecated

  Prefer buildSelectStatement + OINODb.runStatement, which bind user values as parameters instead of inlining escaped literals.

printSqlUpdate

• printSqlUpdate(id: string, row: OINODataRow): string

  Print SQL update statement from one data row as an inline (non-parameterized) string.

  Parameters

  • id: string

    OINO ID (i.e. combined primary key values)
  • row: OINODataRow

    one row of data in the data model

  Returns string

  Deprecated

  Prefer buildUpdateStatement + OINODb.runStatement.