Options
All
  • Public
  • Public/Protected
  • All
Menu

External module "src/helpers/mysql"

Index

Variables

Const pool

pool: Pool = createPool({host: DB_HOST,port: DB_PORT,user: DB_USERNAME,password: DB_PASSWORD,database: DB_DATABASE})

Functions

Const addIsPrimaryToEmail

  • addIsPrimaryToEmail(email: Email): Promise<Email>
  • Parameters

    Returns Promise<Email>

Const addIsPrimaryToEmails

  • addIsPrimaryToEmails(emails: Email[]): Promise<Email[]>
  • Parameters

    Returns Promise<Email[]>

Const cleanValues

  • cleanValues(values: (undefined | string | number | false | true | Date)[]): (undefined | string | number | false | true | Date)[]
  • Convert object values to MySQL-compatible types

    Parameters

    • values: (undefined | string | number | false | true | Date)[]

    Returns (undefined | string | number | false | true | Date)[]

Const query

  • query(queryString: string, values?: (undefined | string | number | false | true | Date)[]): InsertResult | any
  • Return the results of a MySQL query

    Parameters

    • queryString: string
    • Optional values: (undefined | string | number | false | true | Date)[]

    Returns InsertResult | any

Const removeReadOnlyValues

  • Remove any read-only values like createdAt from an object

    Parameters

    Returns KeyValue

Const setValues

  • Replace any object values with question marks to prevent injection

    Parameters

    Returns string

Const tableName

  • tableName(name: string): string
  • Parameters

    • name: string

    Returns string

Const tableValues

Const uncleanValues

Generated using TypeDoc