Synor Database MySQL

Synor Database Engine - MySQL

Installation

``sh


using yarn:

yarn add @synor/database-mysql mysql2

using npm:

npm install --save @synor/database-mysql mysql2
`

URI

Format: mysql://[user[:password]@][hostname][:port]/database[?param=value&...]

Params:

| Name | Description | Default Value |
| ------------------------------ | ----------------------------------------------------------------------------- | ------------------------ |
| ssl | MySQL SSL Options | undefined |
| synor_migration_record_table | Name for Migration Record Table | synor_migration_record |

Examples:

- mysql://root:root@127.0.0.1:3306/synor?synor_migration_record_table=migration_record

`js
// SSL Example

const ssl = JSON.stringify({
ca: '',
cert: '',
ciphers: '',
key: '',
passphrase: '',
rejectUnauthorized: '',
}) // 'Amazon RDS'

const uri = mysql://root:root@127.0.0.1:3306/synor?ssl=${encodeURIComponent(
ssl
)}
``

License

Licensed under the MIT License. Check the LICENSE file for details.