# model
# 方法
create(name, options)
参数名称 | 类型 | 描述 |
---|---|---|
name | string | model 名称 |
options | object | 配置参数 columns: 列定义 checks: 列定义 indices: 列定义 uniques: 列定义 |
返回值 Model 类实例
import { app, model } from "kidi";
let testModel = model.create("testModel", {
columns: {
id: {
primary: true,
type: "int",
generated: "increment"
},
firstName: {
type: String,
length: 30
},
lastName: {
type: String,
length: 50,
nullable: false
},
age: {
type: Number,
nullable: false
}
},
checks: [
{ expression: `"firstName" <> 'John' AND "lastName" <> 'Doe'` },
{ expression: `"age" > 18` }
],
indices: [
{
name: "IDX_TEST",
unique: true,
columns: [
"firstName",
"lastName"
]
}
],
uniques: [
{
name: "UNIQUE_TEST",
columns: [
"firstName",
"lastName"
]
}
]
});
# Model 类
方法名称 | 描述 | 默认 |
---|---|---|
add(obj) | 添加 | 无 |
remove(obj) | 删除实例 | false |
delete(where) | 按条件删除 | 无 |
merge(old, data) | 更新 | 无 |
update(where, data) | 更新 | true |
count(where) | 查询个数 | true |
find(where) | 查询结果 | true |
findAndCount(where) | 查询结果并返回个数 | true |
findOne(where) | 查询并返回命中的一个 | true |
创建 model
import { app, model } from "kidi";
let userModel = model.create("userModel", {
id: {
type: Number,
primary: true,
generated: "increment",
},
name: {
type: String,
}, //资源配置
});
add(obj)
let ins = await userModel.add({ name: "kidi22" });
console.log(ins);
remove(obj)
let user = await userModel.findOne({ name: "kidi22" });
await userModel.remove(user);
delete(where)
userModel.delete({ name: "kidi22" });
merge(old, data)
let user = await userModel.findOne({ name: "kidi44" });
await userModel.merge(user, { name: "kidi55" });
update(where, data)
await userModel.update({ name: "kidi44" }, { name: "kidi55" });
count(where)
let count = await userModel.count({ name: "kidi33" });
console.log(count);
find(where)
let list = await userModel.find();
console.log(list);
findAndCount(where)
let [list, length] = await userModel.findAndCount({ name: "kidi33" });
console.log(list, length);
findOne(where)
let user = await userModel.findOne({ name: "kidi33" });
console.log(user);