wx-cloud-db-falsework

a falsework for weixin miniProgram cloud database
微信小程序云开发数据库脚手架

 

 Install

npm install wx-cloud-db-falsework

 

 Quick Start

import { DB, Model } from 'path/wx-cloud-db-falsework.min'

class Order extends Model {
  constructor(o) {
    let t = super(o)
    return t
  }
}

// collectionName 默认为model名，如Order默认为order
// collectionKey  默认_id
// cloud 小程序端传 wx.cloud, 云函数端传require('wx-server-sdk')
const Odr = Order.init({ env: '环境ID', cloud, [, collectionName = '集合名称', collectionKey = '主键字段名'] })

let row = await Odr.doc('xxxx').get()
let row = await Odr.find('xxxx')
let row = await Odr.where({_id: 'xxxx'}).get()
let row = await Odr.find(`{_id: this._.eq('xxxx')}`)
let row = await Odr.find({_id: Odr._.eq('xxxx')})

if(row instanceof DB.DbError){

    console.log('error', row)

}else if(row instanceof DB.DbRes){

    console.log('execed sql ==> ', row.sql)

    if(row instanceof DB.DbResultJson){

        console.log('DbResultJson ==> ', row)

    }else {

        // row instanceof DB.DbResultArray
        console.log('DbResultArray ==> ', row)

    }

    // update
    let back = await row.update({
        abc: 888
    }) ==> // { updated:Number }

    // remove
    let back = await row.remove() ==> // { removed:Number }
}

Other Demo

await Odr.add({_id: 'xxxx', abc: 123})

await Odr.add(`{_id: 'xxxx'}`)

await Odr.add({ data:{_id: 'xxxx'}, success(res){}, fail(res){}, complete(res){} })

await Odr.update({abc: 456}, {_id: 'xxxx'})

await Odr.where({_id: 'xxxx'}).update({abc: 456})

await Odr.doc('xxxx').update({abc: 456})

await Odr.doc('xxxx').update({ data: {abc: 456}, success(res){}, fail(res){}, complete(res){} })

await Odr.aggregate().match({abc: 456}).end()

await Odr.doc('xxxx').remove()

await Odr.where({_id: 'xxxx'}).remove()

await Odr.remove({_id: 'xxxx'})

await Odr.remove({ where: {_id: 'xxxx'}, success(res){}, fail(res){}, complete(res){} })

await Odr.remove(`{_id: 'xxxx', abc: this._.eq(456)}`)

await Odr.remove({_id: 'xxxx', abc: Odr_.eq(456)})