unicloud云开发---uniapp云开发(三)---云数据库基础(超详细)

const db = uniCloud.database();
db.createCollection("xxxx")

const db = uniCloud.database();
// 获取 `xxx` 集合的引用
const collection = db.collection('xxx');

let res = await collection.add({username:"dmhsq"})
console.log(res)

let res = await collection.count()
console.log(res)

let res = await collection.get()
console.log(res)

let res = await collection.doc("28ee4e3e602fb13c064475431a7966e7")
console.log(res)

let res = await collection.doc("28ee4e3e602fb13c064475431a7966e7").get()
console.log(res)

collection.where({
	username: "匹配的值"  可以使用> < 什么的
})

const dbCmd = db.command
let res = await collection.where({
	username:dbCmd.eq("匹配的值")
}).get()

collection.where({userename:"dmhsq"})
或者 指令方式
const dbCmd = db.command
let res = await collection.where({
	username:dbCmd.eq("dmhsq")
})

let res = await collection.where({userename:"dmhsq"}).get()
或者
const dbCmd = db.command
let res = await collection.where({
	username:dbCmd.eq("dmhsq")
}).get()
console.log(res)

collection.skip(num)

let res = await collection.skip(0).get()
console.log(res)

let res = await collection.skip(1).get()
console.log(res)

collection.limit(num)

let res = await collection.limit(2).get()
console.log(res)

let pages = event.p; //页数
let nums = event.n; //每页个数
let res = await collection.skip((pages-1)*nums).limit(nums).get()
console.log("当前页数为"+pages)
console.log(res)

// 本文件中的json内容将在云函数【运行】时作为参数传给云函数。

// 配置教程参考：https://uniapp.dcloud.net.cn/uniCloud/quickstart?id=runparam

{
	"p":1,
	"n":2
}

collection.orderBy("字段名","升序/降序").get()
升序为asc
降序desc

collection.orderBy("username","asc").get()

collection.orderBy("username","desc").get()

collection.field({"_id":true})

let res = await collection.field({"_id":true}).get()
console.log(res)

collection.where({username:"我是4"})

collection.where({username:"我是4"}).update({username:"我是猪"})

collection.doc('_id字段的值').set({username:"我是4"})

collection.doc('_id字段的值')
collection.where(字段名:'字段的值')

collection.where({xxxx:5}).remove()

const db = uniCloud.database()
let res = db.collection('xxx').get().then(res => {
	console.log(res)
})

const db = uniCloud.database()
let res = db.collection('xxx').add({
	username: "我是dmhsq"
}).then(res => {
	console.log(res)
})

const db = uniCloud.database()
let res = db.collection('xxx').count().then(res => {
	console.log(res)
})

const db = uniCloud.database()
let res = db.collection('xxx').where({
	username: "我是1"
}).update({
	username: "小可爱1"
}).then(res => {
	console.log(res)
})

const db = uniCloud.database()
let res = db.collection('xxx').where({
	username: "小可爱1"
}).remove().then(res => {
	console.log(res)
})