cache-database

Connection

  const cache = require('cache-database');

Collections

Create

  const collection = cache.create('collection');

Documents

Create

  //Return Promise.
  collection.create({a: 1, b: 2, c: 3})
    .then(() => console.log('ok'))
    .catch(error => console.log(error))

Find

• Find all

  //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 params

  //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,
      },
    }
  */

Search

  //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 One

  //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));

Update

  //Return Promise.
  collection.findAndUpdate({a: 1}, {x: 10})
    .then(() => console.log('ok'))
    .catch(err => console.log(err));

Delete

  //Return Promise.
  collection.findAndDelete({a: 1})
    .then(() => console.log('ok'))
    .catch(err => console.log(err));