mysql-router

0.0.1
Need help reading this?

Mysql

[Mysql description]

new Mysql()

StartPool

This starts up the Pool of Connections ready for Plugins and Files to access.

StartPool(options: [type])
Parameters
options ([type]) This is the Same Official Options as the mysql Node Module.

Query

Query will execute a Mysql Statement from the connection pool, then release the connection automatically saving memory.

Query(sql: [type], data: Array): Promise
Parameters
sql ([type]) This is the Sql. Normal Mysql.
data (Array) Data is a Array associated to the Sql, this can be Empty.
Returns
Promise: Returns a Promise that contains the Response for the Queried Data.

setDate

Provide the Time in a ISO 8601 Format for Mysql.

setDate(d: [type]): string
Parameters
d ([type]) (Optional) If given it will convert it to a ISO 8601 Format for mysql, if left blank it will use the Current Time.
Returns
string: Returns Date/Time to a ISO 8601 usable by Mysql.

getDate

Provide the Time in a Human Readable Format.

getDate(d: [type]): string
Parameters
d ([type]) (Optional) If given it will conver it to a Human Readable Format, if left blank it will use the Current Time.
Returns
string: Returns ISO 8601 to a Human Readable Format.