api封装

const sql={

    insert: function(collection,insertData){
       return new Promise(function(resolve,reject){
        collection.insertMany(insertData,(err,data)=>{
            if(err) throw err;
            resolve(data)
    })

       })
    },
    
    // find (collection,whereObj,showObj){
    //     collection.find(whereObj,showObj).exec((err,data)=>{
    //         if (err) throw err;
    //         console.log(data);
    //     })
    // }
    find(collection,whereObj,showObj){

        return new Promise(function(resolve,reject){

            collection.find(whereObj,showObj).exec((err,data)=>{
                if(err)throw err;
                resolve(data);
                
            })


        })
    },






    update (collection,whereObj,updateObj,updateType){

        updateType=updateType||'updateOne'

        return new Promise((resolve,reject)=>{
            collection[updateType](whereObj,updateObj,(err,data)=>{
                if (err) throw err;
                resolve(data)
            })
        })

    },
    sort: function * (Collection, whereObj, showObj, sortObj) {
        return new Promise(function (resolve, reject) {
          Collection.find(whereObj, showObj).sort(sortObj).exec((err, data) => {
            if (err) throw err;
            resolve(data)
          })
        })
      },
    
// 分页方法
      paging: function(Collection, whereObj, showObj,count,pageNum) {   //查询 find().limit().skip()
        return new Promise(function (resolve, reject) {
          Collection.find(whereObj, showObj).limit(count).skip((pageNum - 1)*count).exec((err, data) => {
            if (err) throw err;
            resolve(data)
          })
        })
      },



    
      delete (collection,whereObj,deleteType){
        
        return new Promise((resolve,reject)=>{
            
            deleteType=deleteType||'deleteOne';
            
            collection[deleteType](whereObj,(err,data)=>{ //注意 collection.deleeOne(deleteMany)()
                if(err) throw err;
               resolve(data);
                
            })
        })

    }


    
}

module.exports=sql;
posted @ 2019-08-23 09:25  des雷锋  阅读(177)  评论(0编辑  收藏  举报