百度智能小程序 Database

Database.collection

解釋：獲取云數(shù)據(jù)庫(kù)指定名稱的集合對(duì)象

參數(shù)

返回值：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

云數(shù)據(jù)庫(kù)操作指令對(duì)象，包含相關(guān)數(shù)據(jù)庫(kù)文檔操作指令構(gòu)造方法

指令列表

代碼示例

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

在云數(shù)據(jù)庫(kù)中新增集合

參數(shù)

返回值 Promise

resolve 結(jié)果：

reject 結(jié)果：

代碼示例

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

云數(shù)據(jù)庫(kù)地理對(duì)象，包含相關(guān)地理位置信息構(gòu)造接口

類型列表

代碼示例 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),
          // ... 可選更多點(diǎn)
        ])
    })
  }
  catch(err) {
      console.log(err)
  }
}

Database.serverDate

創(chuàng)建云數(shù)據(jù)庫(kù)的服務(wù)端時(shí)間對(duì)象

參數(shù)

返回值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

創(chuàng)建云數(shù)據(jù)庫(kù)的相關(guān)指令所需的正則表達(dá)式對(duì)象

參數(shù)

返回值

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)
  }
}