soul-mongo v3.0.0

node封装mysql

安装

npm i -S soul-mongo

初始化

const { Mongoose } = require('soul-mongo')

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

const mongoose = new Mongoose(config)

添加数据

const add = async ()=>{
   const results = await mongoose.table('test').tableStructure({ id:Number,age:Number }).add({id:1,age:10})
   console.log(results)
}
add()

删除数据

const delete_item = async ()=>{
    const results = await mongoose.table('test').tableStructure({id:Number,age:Number}).delete({id:1})
    return results
}
delete_item()

修改数据

const update_item = async ()=>{
    const results = await mongoose.table('test').tableStructure({id:Number,age:Number})
    .update({ data:79878 },{ id:33 })
    return results
}
update_item()
//update(update_data,update_condition)

获取数据

const get = async ()=>{
   const results = await mongoose.table('test').tableStructure({id:Number,age:Number}).
   page(1).num(100).like({cmd:'282'}).term({id:96}).get()
   return results
}
get()

//order(data)		排序，data = {age:'desc'},desc降序，asc升序
//page() 			页数
//num()	 			每页条数
//like() 			模糊匹配
//term()			精准匹配