soul-mysql v2.0.0

node封装mysql

安装

npm i -S soul-mysql

初始化

const {
    createConnection,
    createPool,
    createPoolCluster,
    createQuery,
    escape,
    escapeId,
    format,
    raw,
    Mysql
} = require('soul-mysql')

const config ={
    connectionLimit : 10,
    port: port,
    host: host,
    user: user,
    password: password,
    database: database
}

const mysql = new Mysql(config)

//soul-mysql继承mysql，并在基础上封装了Mysql类

添加数据

const add = async ()=>{
   const results = await mysql.table('test').add({
       id:(Math.random() * 90).toFixed(0),
       count:(Math.random() * 200).toFixed(0)
   })
   console.log(results)
}
add()
//table()		为选择表名
//add(data) 	data为新增的数据，data为对象

删除数据

const delete_item = async ()=>{
    const results = await mysql.table('test').delete({id:3})
    console.log(results)
    return results
}
delete_item()

修改数据

const update_item = async ()=>{
    const results = await mysql.table('test').update({count:900},{id:80}) 
    console.log(results)
    return results
}
update_item()

//此处例子，update_data为{count:900}，update_condition为id = 80
//update(update_data,update_condition) update_data为更新数据，update_condition为更新条件

获取数据

const get = async ()=>{
   const results = await mysql.table('test').
   page(1).num(100).like({cmd:'282'}).selectField(['id']).
   term({id:96}).get()
   console.log(results)
   return results
}
get()

//page() 			页数
//num()	 			每页条数
//like() 			模糊匹配
//term()			精准匹配
//selectField()		选择返回的字段，参数值为[],数组元素为字符串