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