External module "helpers/mysql"

Index

Variables

pool

Functions

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>

- Defined in helpers/mysql.ts:152
Parameters
- email: Email
Returns Promise<Email>

Const addIsPrimaryToEmails

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

- Defined in helpers/mysql.ts:141
Parameters
- emails: Email[]
Returns Promise<Email[]>

Const cleanValues

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

- Defined in helpers/mysql.ts:97
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)[]): Promise<Object>

- Defined in helpers/mysql.ts:30
Return the results of a MySQL query

Parameters
- queryString: string
- Optional values: (undefined | string | number | false | true | Date)[]
Returns Promise<Object>

Const removeReadOnlyValues

removeReadOnlyValues(object: KeyValue): KeyValue

- Defined in helpers/mysql.ts:134
Remove any read-only values like createdAt from an object

Parameters
- object: KeyValue
Returns KeyValue

Const setValues

setValues(object: KeyValue): string

- Defined in helpers/mysql.ts:123
Replace any object values with question marks to prevent injection

Parameters
- object: KeyValue
Returns string

Const tableValues

tableValues(object: User | BackupCode | Event | Email | Membership | Organization): string

- Defined in helpers/mysql.ts:49
Convert an object to MySQL-style (column) VALUES (values)

Parameters
- object: User | BackupCode | Event | Email | Membership | Organization
Returns string

Const uncleanValues

uncleanValues(data: (Organization | User | BackupCode | Event | Email | Membership)[]): (Organization | User | BackupCode | Event | Email | Membership)[]

- Defined in helpers/mysql.ts:62
Convert MySQL output to stronger types, like binary to boolean and datetime to JS Date

Parameters
- data: (Organization | User | BackupCode | Event | Email | Membership)[]
Returns (Organization | User | BackupCode | Event | Email | Membership)[]

Generated using TypeDoc