Keystone js database shortcuts.
var db = require('keystone-db-shortcuts');
`
db.schema
db.schema
`
var schema=db.schema(model_name);
`
db.model
db.model
`
var model=db.model(model_name);
`
db.one
$3
`
db.one({
model: 'ModelName',
find: { _id: _id }
},function(err,res){
// do something
});
`
db.count
$3
`
db.count({
model: 'ModelName',
where: { ... }
},function(err,res){
// do something
});
`
$3
`
db.count({
model: 'ModelName',
find: { _id: _id }
},function(err,res){
// do something
});
`
db.exists
$3
`
db.exists({
model: 'ModelName',
where: { _id: _id }
},function(err,res){
// do something
});
`
$3
`
db.exists({
model: 'ModelName',
find: { _id: _id }
},function(err,res){
// do something
});
`
db.get
$3
`
var _q={
model: 'Papers',
where: {
$or: [
{_id: { $in: [0,1,2,3,4,5] }},
{numbers: { $in: [0,1,2,3,4,5]}}
]
},
populate: 'cover',
select: 'cover name cont',
limit: 10
};
db.get(_q,function(err,papers){
if(err) done(true,err);
else{
done(null,papers);
}
});
`
db.get as find
$3
`
var query = {
model:'modelName'
};
db.get(query, callback(err, res){
// do something
});
`
db.get as findById
$3
`
var query = {
model:'modelName',
id: modelID
};
db.get(query, callback(err, res){
// do something
});
`
db.get - Find by multiple ids.
id accepts an Array of values.
$3
`
var query = {
model:'modelName',
where: { _id : { $in : [...] } }
};
db.get(query, callback(err, res){
// do something
});
`
db.get as find (passing a where option.)
`
var query = {
model:'modelName',
where: { ... } // list of columns
};
db.get(query, callback(err, res){
// do something
});
`
db.create
`
var _q = {
model:'Papers',
body: {
name:'Important paper.',
cont:'...'
}
};
db.get(_q, callback(err, res){
// do something
});
`
db.update (it's like using get.)
`
var _q={
model: 'Papers',
where: { name: 'Unnamed paper.' },
body:{
name: 'Important paper.'
},
limit: 10
};
db.update(_q,function(err,affected){
done(err,affected);
});
`
db.update
$3
`
var _q={
model: 'Papers',
where: { _id: _id },
body:function(model,opts,cb){
// model - the model.
// opts - this same _q object.
// cb - callback for complete.
// this - model schema.
model.update({
// update 1
},{
// update 2
});
}
};
db.update(_q,function(err,affected){
done(err,affected);
});
`
db.destroy (it's like using get.)
`
var query = {
model: 'modelName',
where: { _id: _id }
};
db.destroy(query, callback(err, res){
// do something
});
``