README
ai-mysql-client
A mysql client tools for nodejs and want to look for a girlfriend...
Installation
$ npm i ai-mysql-client
Example
import createMySQLClient from 'ai-mysql-client'
// https://www.npmjs.com/package/@blued-core/qconf
qconf.flag: isLocalPro ? 'production' : '',
const mysqlClient = key => {
return createMySQLClient({
key,
option: qconf,
connections: 20,
time: 60,
})()
// or
return createMySQLClient({
master: ['127.0.0.1:3306'],
slave: ['127.0.0.1:3306', '127.0.0.1:3306', '127.0.0.1:3306'],
username: 'root',
password: 'your@123',
database: 'test',
time: 60,
connections: 20,
}, key)()
}
async function getTest() {
const defaultMySQL = mysqlClient('default')
const sql = 'SELECT * FROM test_user LIMIT 0,10'
const res = await defaultMySQL.query(sql).catch(err => {
console.error(err, { tips: 'query error' })
})
console.log(res)
return res
}
Options
// options
interface Config {
key?: string
option: any
connections?: number
time?: number
}
// or
interface MySQL {
master: Array<string>
slave: Array<string>
username: string
password: string
database: string
connections?: number
time?: number
}