Documentation

Class: MySQLClient

arpen/services/mysql~ MySQLClient

MySQL client

new MySQLClient(service, client, done)

Create MySQL client
Parameters:
Name Type Description
service MySQL MySQL service instance
client object Connected PG client
done function Client termination function
Properties:
Name Type Default Description
client object mysql client
maxTransactionRetries number 59 Max number of transaction retries on serialization failures
minTransactionDelay number 100 Minimum time to wait before retrying transaction
maxTransactionDelay number 1000 Maximum time to wait before retrying transaction

Methods

done()

Client termination

<async> query(sql [, params])

Run MySQL query
Date/Moment params are converted to strings in UTC timezone.
Parameters:
Name Type Argument Description
sql string SQL query string
params Array <optional>
 Query parameters
Returns:
Resolves to query result
Type
Promise

<async> transaction( [params], cb)

Run a transaction
Parameters:
Name Type Argument Description
params object <optional>
Properties
Name Type Argument Default Description
name string <optional>
 Transaction name for debugging
isolation string <optional>
 'serializable' Isolation level
cb MySQLTransaction The transaction
Returns:
Resolves to transaction result
Type
Promise