Options
All
  • Public
  • Public/Protected
  • All
Menu

Interface Connection

Hierarchy

Index

Properties

_connection: mariadb.Connection
_instanceBuildmsqlMeta: UpsertResult | UpsertResult[]
info: null | ConnectionInfo

Connection information

threadId: null | number

Alias of info.threadId for compatibility

Methods

  • [captureRejectionSymbol]<K>(error: Error, event: string | symbol, ...args: AnyRest): void
  • Type Parameters

    • K

    Parameters

    • error: Error
    • event: string | symbol
    • Rest ...args: AnyRest

    Returns void

  • addListener<K>(eventName: string | symbol, listener: ((...args: any[]) => void)): Connection
  • Alias for emitter.on(eventName, listener).

    since

    v0.1.26

    Type Parameters

    • K

    Parameters

    • eventName: string | symbol
    • listener: ((...args: any[]) => void)
        • (...args: any[]): void
        • Parameters

          • Rest ...args: any[]

          Returns void

    Returns Connection

  • affectedRows(): number
  • beginTransaction(): Promise<void>
  • Permit changing user during connection. All user variables will be reset, Prepare commands will be released. !!! mysql has a bug when CONNECT_ATTRS capability is set, that is default !!!!

    Parameters

    Returns Promise<void>

  • close(): Promise<void>
  • deprecated

    alias for end().

    Returns Promise<void>

  • commit(): Promise<void>
  • Commit a transaction.

    Returns Promise<void>

  • debug(value: boolean): void
  • Change option "debug" during connection.

    Parameters

    • value: boolean

    Returns void

  • debugCompress(value: boolean): void
  • Change option "debugCompress" during connection.

    Parameters

    • value: boolean

    Returns void

  • destroy(): void
  • Force connection termination by closing the underlying socket and killing a server process if any.

    Returns void

  • emit<K>(eventName: string | symbol, ...args: AnyRest): boolean
  • Synchronously calls each of the listeners registered for the event named eventName, in the order they were registered, passing the supplied arguments to each.

    Returns true if the event had listeners, false otherwise.

    import { EventEmitter } from 'node:events';
    const myEmitter = new EventEmitter();

    // First listener
    myEmitter.on('event', function firstListener() {
    console.log('Helloooo! first listener');
    });
    // Second listener
    myEmitter.on('event', function secondListener(arg1, arg2) {
    console.log(`event with parameters ${arg1}, ${arg2} in second listener`);
    });
    // Third listener
    myEmitter.on('event', function thirdListener(...args) {
    const parameters = args.join(', ');
    console.log(`event with parameters ${parameters} in third listener`);
    });

    console.log(myEmitter.listeners('event'));

    myEmitter.emit('event', 1, 2, 3, 4, 5);

    // Prints:
    // [
    // [Function: firstListener],
    // [Function: secondListener],
    // [Function: thirdListener]
    // ]
    // Helloooo! first listener
    // event with parameters 1, 2 in second listener
    // event with parameters 1, 2, 3, 4, 5 in third listener
    since

    v0.1.26

    Type Parameters

    • K

    Parameters

    • eventName: string | symbol
    • Rest ...args: AnyRest

    Returns boolean

  • end(): Promise<void>
  • Terminate connection gracefully.

    Returns Promise<void>

  • escape(value: any): string
  • This function permits escaping a parameter properly, according to a parameter type, to avoid injection.

    Parameters

    • value: any

      parameter

    Returns string

  • escapeId(identifier: string): string
  • This function permits escaping an Identifier properly. See Identifier Names for escaping. Value will be enclosed by '' character if content doesn't satisfy: <OL> <LI>ASCII: [0-9,a-z,A-Z$_] (numerals 0-9, basic Latin letters, both lowercase and uppercase, dollar sign, underscore)</LI> <LI>Extended: U+0080 .. U+FFFF and escaping '' character if needed.

Parameters

Returns string

Generated using TypeDoc