百度智能小程序 Database

Database.collection

解释：获取云数据库指定名称的集合对象

参数

返回值：Collection

代码示例

const cloud = require('swan-server-sdk')

exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  const coll = db.collection('articles')
}

Database.command

云数据库操作指令对象，包含相关数据库文档操作指令构造方法

指令列表

代码示例

const cloud = require('swan-server-sdk')

exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  const cmd = db.command
  try {
    return await db.collection('userList').where({
      age: cmd.gt(18)
    })
  }
  catch(err) {
      console.log(err)
  }
}

Database.createCollection

在云数据库中新增集合

参数

返回值 Promise

resolve 结果：

reject 结果：

代码示例

const cloud = require('swan-server-sdk')

exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  try {
    await db.createCollection('articles')
  }
  catch(err) {
    console.log(err)
  }
}

Database.Geo

云数据库地理对象，包含相关地理位置信息构造接口

类型列表

代码示例 1 - Point

const cloud = require('swan-server-sdk')

exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  const Geo = db.Geo
  try {
    return await db.collection('poiList').add({
        name: '天安门',
        location: Geo.Point(116.4074, 39.9042)
    })
  }
  catch(err) {
      console.log(err)
  }
}

代码示例 2 - LineString

const cloud = require('swan-server-sdk')

exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  const Geo = db.Geo
  try {
    return await db.collection('poiList').add({
        name: '天安门',
        location: Geo.LineString([
          Geo.Point(113, 23),
          Geo.Point(120, 50),
          // ... 可选更多点
        ])
    })
  }
  catch(err) {
      console.log(err)
  }
}

Database.serverDate

创建云数据库的服务端时间对象

参数

返回值ServerDate

代码示例

const cloud = require('swan-server-sdk')
exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()

  try {
      return await db.collection('articles').add({
        title: 'baidu cbd tutorial',
        status: 0,
        visits: 0,
        createDate: new Date({
            offset: 1000
        }),
    })
  }
  catch(err) {
    console.log(err)
  }
}

Database.RegExp

创建云数据库的相关指令所需的正则表达式对象

参数

返回值

RegExp

代码示例 1

const cloud = require('swan-server-sdk')
exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  try {
      return await db.collection('articles').where({
        title: /miniprogram/i,
    })
  }
  catch(err) {
    console.log(err)
  }
}

代码示例 2

const cloud = require('swan-server-sdk')
exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  try {
      return await db.collection('articles').where({
        title: db.RegExp({
            regexp: '^baidu',
            options: 'i',
        }),
    })
  }
  catch(err) {
    console.log(err)
  }
}

代码示例 3

const cloud = require('swan-server-sdk')
exports.main = async (event, context) => {
  cloud.init(context)
  const db = cloud.database()
  try {
      return await db.collection('articles').where({
        title: new db.RegExp({
            regexp: '^baidu',
            options: 'i',
        }),
    })
  }
  catch(err) {
    console.log(err)
  }
}