Class OINODbAbstract

constructor

• new OINODb(params: OINODbParams): OINODb

  Constructor for OINODb.

  Parameters

  • params: OINODbParams

    database parameters

  Returns OINODb

isConnected

isValidated

Readonlyname

printSqlInsert

• printSqlInsert(
      tableName: string,
      columns: string,
      values: string,
      returnIdFields?: string[],
  ): string

  Print SQL select statement with DB specific formatting.

  Parameters

  • tableName: string

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

    The columns to be selected.
  • values: string

    The values to be inserted.
  • OptionalreturnIdFields: string[]

    the id fields to return if returnIds is true (if supported by the database)

  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

AbstractsqlExec

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

  Execute other sql operations.

  Parameters

  • sql: string

    SQL statement.

  Returns Promise<OINODataSet>

AbstractsqlSelect

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

  Execute a select operation.

  Parameters

  • sql: string

    SQL statement.

  Returns Promise<OINODataSet>