unicloud表增删改查

'use strict';
const db=uniCloud.database();
exports.main = async (event, context) => {
//event为客户端上传的参数
console.log(event.a)
//const res=[]
if(event.a==1){
//增
console.log(111)
const collection=db.collection('uni-id-users');
var res=await collection.add([
{
"_id_":2,
"username":"胖虎",
"mobile":"18253590666",
"gong":1
}
])
}
if(event.a == "2" ){
console.log(222)
//查


const collection=db.collection('uni-id-users');
//限制条数
// var res=await collection.limit(2).get()
var res=await collection.get()
/*var res=await collection.where({

gong:1
}).get()*/
//单条
// var res=await collection.doc('60ab465c3b7d3500014a294d').get()

//根据条件，倒叙，分页

var res=await collection.where({
xh: event.xh
}).orderBy("time", "desc").skip((event.page) * 20).limit(20).get()

}
if(event.a == "3" ){

//获取_id

var uid = await collection.where({
id: event.id
}).get()
var uid2=uid.data[0]["_id"]

//改
const collection=db.collection('uni-id-users');

//如果当前_id的记录不存在，那么不会更新任何数据
/*var res=await collection.doc('60ab465c3b7d3500014a294d').update({
username:'老胖虎'
})*/
//如果当前_id的记录不存在，会增加一跳数据
var res=await collection.doc('60ab465c3b7d3500014a294d').set({
username:'老胖虎'
})

 

}
if(event.a == "4" ){
console.log(222)
//删除


const collection=db.collection('uni-id-users');

var res=await collection.where({

_id:'60ab465c3b7d3500014a294d'
}).remove()
}
//返回数据给客户端
return {
code:200,
data:res,
msg:'OK'
}
};