@tick-core/mysql v0.1.2

tick-core-mysql: mysql client

下载

npm install @tick-core/mysql --save
npm install sequelize --save
npm install sequelize-typescript --save

创建mysql持久连接【单数据库模式】

import {
  initMysql,
  MysqlConf,
  Sequelize,
} from '@tick-core/mysql'

const mysqlConf: MysqlConf = {
  host: 'xxxxx',
  port: 3307,
  database: 'xxxxx',
  username: 'xxxxx',
  password: 'xxxxx',
}

const sequelize: Sequelize =  initMysql(mysqlConf)
sequelize.authenticate().then(() => {
  console.log('initMysql success')
}).catch(error => {
  console.log(error)
})

创建mysql持久连接【多数据库模式】

import {
  InitMysqlMulti,
  MysqlConf,
  MysqlMultiSchemaConf,
} from '@tick-core/mysql'

const mysqlConf: MysqlConf = {
  host: 'xxxxx',
  port: 3307,
  database: 'xxxxx',
  username: 'xxxxx',
  password: 'xxxxx',
}
const mysqlMultiSchemaConf: MysqlMultiSchemaConf = {
  test: mysqlConf
}

const sequelizes =  new InitMysqlMulti(mysqlMultiSchemaConf)
sequelizes.getClient('test').authenticate().then(() => {
  console.log('initMysql success')
}).catch(error => {
  console.log(error)
})

创建mysql单次连接

import {
  MysqlSingleConf,
  MysqlBaseSingleConf,
  SingleClient,
} from '@tick-core/mysql'

const mysqlConf: MysqlBaseSingleConf = {
  host: 'xxxxx',
  port: 3307,
  database: 'xxxxx',
  username: 'xxxxx',
  password: 'xxxxx',
}
const mysqlMultiSchemaConf: MysqlSingleConf = {
  test: mysqlConf
}

const sequelizes = new SingleClient(mysqlMultiSchemaConf)
sequelizes.getClient('test').authenticate().then(() => {
  console.log('initMysql success')
}).catch(error => {
  console.log(error)
})