const cache = require('cache-database');
const collection = cache.create('collection');
//Return Promise.
collection.create({a: 1, b: 2, c: 3})
.then(() => console.log('ok'))
.catch(error => console.log(error))
//Find all documents
collection.find()
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find for documents where a == 1;
collection.find({a: 1})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find for documents where a == 1, b == 2
collection.find({a: 1, b: 2})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find for documents where a == 1, a == 2, a == 3
collection.find({a: {$in: [1,2,3]}})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find for documents where a >= 1 and a <= 4
collection.find({a: {$gte: 1, $lte:4}})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find for documents where a > 1 and a < 4
collection.find({a: {$gt: 1, $lt:4}})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find all documents and skip fields b in documents
collection.find({}, {b: 0})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find all documents and sorting field a
collection.find({}, {}, {a: 1})
.then(data => console.log(data))
.catch(err => console.log(err));
//AND REVERSE
collection.find({}, {}, {}, {a: -1})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find for documents starting at 30 and limit output to 10 documents
collection.find({}, {}, 30, 10)
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document search
collection.search('test')
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document search where a == 1
collection.search('test', {a: 1})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document search where a == 1, a == 2, a == 3
collection.search('test', {a: {$in: [1,2,3]}})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document search where a >= 1 and a <= 4
collection.search('test', {a: {$gte: 1, $lte:4}})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document search where a > 1 and a < 4
collection.search('test', {a: {$gt: 1, $lt:4}})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document search and skip fields b in documents
collection.search('test', {}, {b: 0})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document search and sorting field a
collection.search('test', {}, {}, {a: 1})
.then(data => console.log(data))
.catch(err => console.log(err));
//AND REVERSE
collection.search('test', {}, {}, {a: -1})
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Full-text document starting at 30 and limit output to 10 documents
collection.search('test', {}, {}, 30, 10)
.then(data => console.log(data))
.catch(err => console.log(err));
/*
Return Promise. Resolve return Object, type:
{
data: Array,
search: Array,
skip: Array,
sort: Array,
records: {
all: Number,
skip: Number || null,
limit: Number || null,
},
}
*/
//Find document where a == 1;
//Return Promise. Resolve return document
collection.findOne({a: 1})
.then(data => console.log(data))
.catch(err => console.log(err));
//Find document where a == 1, b == 2
//Return Promise. Resolve return document
collection.findOne({a: 1, b: 2})
.then(data => console.log(data))
.catch(err => console.log(err));
//Find document where a == 1, a == 2, a == 3
//Return Promise. Resolve return document
collection.findOne({a: {$in: [1,2,3]}})
.then(data => console.log(data))
.catch(err => console.log(err));
//Find document where a >= 1 and a <= 4
//Return Promise. Resolve return document
collection.findOne({a: {$gte: 1, $lte:4}})
.then(data => console.log(data))
.catch(err => console.log(err));
//Find document where a > 1 and a < 4
//Return Promise. Resolve return document
collection.findOne({a: {$gt: 1, $lt:4}})
.then(data => console.log(data))
.catch(err => console.log(err));
//Find document and skip fields b in documents
//Return Promise. Resolve return document
collection.find({}, {b: 0})
.then(data => console.log(data))
.catch(err => console.log(err));
//Return Promise.
collection.findAndUpdate({a: 1}, {x: 10})
.then(() => console.log('ok'))
.catch(err => console.log(err));
//Return Promise.
collection.findAndDelete({a: 1})
.then(() => console.log('ok'))
.catch(err => console.log(err));