对象封装器
批量插入数据
import * as db from 'db'; let s = db.object('Student__CST'); let records = [ {"name": "Tom","age__CST": "13"}, {"name": "Jerry","age__CST": "12"}, ]; let ids = s.batchInsert(record);
记录集
事务flag等
成功插入记录的id列表
批量更新记录
import * as db from 'db'; let s = db.object('Student__CST'); let records = [ {"id":"00da000000f2scP5Bw36", "name": "Tom_t"}, {"id":"00da000000f2scP5Bw37", "name": "Jerry_j"}, ]; let ids = s.batchUpdate(record);
string[] ids of the inserted records
批量创建父子对象组合记录
import * as db from 'db'; let s = db.object('Customer__CST'); // 父子记录需要通过关联字段关联起来,如下面的记录通过`Contacts`关联在一起,形成一条组合记录。 let records = [ { "name": "hello", "count__CST": 123, "Contacts": { "records": [ { "name": "hello_contact1" }, { "name": "hello_contact2" }] } }]; let ids = s.compositeInsert(records); console.log("id list = ", ids);
父子对象组合记录数组
事务flag
插入记录集id列表
计数满足条件记录数
import * as db from 'db'; let s = db.object('Student__CST'); let cond = { conjunction: db.Conjunction.AND, conditions: [ { field: "age__CST", "operator": db.Operator.lt, "value": 10 } ] } let num = s.count(cond);
匹配条件
满足条件的记录数
按照id删除记录
记录id
操作flag
影响的记录数
按照条件删除记录
import * as db from 'db'; let s = db.object('Student__CST'); let cond = { conjunction: db.Conjunction.AND, conditions: [ { field: "name", operator: db.Operator.eq, value: "Tom" } ] } let num = s.deleteByCondition(cond);
新增加记录
记录
新增记录id
依据id查询记录
import * as db from 'db'; let s = db.object('Student__CST'); let id = '00da000000f2scP5Bw36'; let option = { options: { fields: ["name", "age", "grade"], } }; let record = s.query(id, option);
查询选项,在按照id查询的情况,主要可以指定查询字段集,其他选项没有效果。
父子关系,如果需要级联查询出父子关系,则需要指定
按照条件查询记录, 支持限制查询返回的记录条数,通过skip值指定从第多少条开始,limit指定总共返回多少条记录。 在不指定skip, limit情况,默认值为skip=0, limit=5000,意味着查询返回结果集的前5000条。 limit最大值可设置为10000条,意味着该查询接口最多只能返回查询结果集的前10000条。
import * as db from 'db'; let s = db.object('Student__CST'); let cond = { conjunction: db.Conjunction.AND, conditions:[ { field: "age__CST", operator: db.Operator.lt, "value": 10 } ] } let records = s.queryByCondition(cond);
查询选项
父子对象关系
满足条件的记录集
按照id更新记录
需要更新的内容
按照条件更新记录
import * as db from 'db'; let s = db.object('Student__CST'); let cond = { conjunction: db.Conjunction.AND, conditions: [ { field: "name", operator: db.Operator.eq, value: "Tom" } ] } let record = { "name": "NewTom", "age__CST": "14" }; let num = s.updateByCondition(cond, record);
对象封装器