Options
All
  • Public
  • Public/Protected
  • All
Menu

Class DBConnection

Control the database through a single connection.

Hierarchy

  • DBConnection

Constructors

Properties

Methods

Constructors

constructor

  • new DBConnection(connection: PoolConnection): DBConnection

  • Database connection constructor.

    Parameters

    • connection: PoolConnection

      The database connection.

    Returns DBConnection

    The database connection object.

Properties

Private closed

closed: boolean = false

Private conn

conn: PoolConnection

Connection object.

Methods

close

  • close(): void

  • Close the connection.

    Returns void

commit

  • commit(): Promise<void>

  • Commit a transaction.

    Returns Promise<void>

execute

  • execute(stmt: string, params?: any[]): Promise<any>

  • Execute a SQL query.

    Parameters

    • stmt: string

      SQL statement.

    • params: any[] = ...

      Values to be inserted into the statement.

    Returns Promise<any>

    Query results.

executeMany

  • executeMany(stmts: string[], params?: any[][]): Promise<any[][]>

  • Execute multiple SQL queries, each one right after the last

    Parameters

    • stmts: string[]

      SQL statement.

    • params: any[][] = ...

      Values to be inserted into the statement.

    Returns Promise<any[][]>

    Results of all queries.

rollback

  • rollback(): Promise<void>

  • Rollback a transaction.

    Returns Promise<void>

startTransaction

  • startTransaction(): Promise<void>

  • Start a transaction.

    Returns Promise<void>

Generated using TypeDoc