const manager = require('lite-web-db');
manager.STORAGE_PATH = "/path/to/files";

const db = manager.startup('database-name');

manager.saveToDisk(db);

manager.shutdown(db);        // shutdown with AutoSave
manager.shutdown(db, false); // shutdown and do not save

const table = db.getTable('table-name');

const search = { key: "index", is: 1 };
var matchingRows = table.query(search);

const search = { key: "index", includes: [1,4] };
var matchingRows = table.query(search);

const search = { key: "index", predicate: function (value) {
  return (val % 2 == 0); // Returns true if value is odd
}};
var matchingRows = table.query(search);

const search = { key: "index", is: 1, not: true };
var matchingRows = table.query(search);

var allRows = table.query();

// insert one row
const newRow = { number: 1, english: "one", spanish: "uno" };
table.insert(newRow);

// insert multiple rows
const moreRows = [
  { number: 2, english: "two",   spanish: "dos"    },
  { number: 3, english: "three", spanish: "tres"   },
  { number: 4, english: "four",  spanish: "quatro" }
];
table.insert(moreRows);

table.query(); /* RETURNS ===> [
  { index: 1, number: 1, english: "one",   spanish: "uno"    },
  { index: 2, number: 2, english: "two",   spanish: "dos"    },
  { index: 3, number: 3, english: "three", spanish: "tres"   },
  { index: 4, number: 4, english: "four",  spanish: "quatro" }
] */

const test = { key: "index", is: 4 };
const newData = { english: "FOUR" };
table.update(newData, test);

var toUpper = function (value) {
  return value.toUpperCase();
};
table.update({ english: toUpper, french: toUpper });

// delete matching rows
const removeSearch = { key: "index", is: 4 };
table.delete(removeSearch);

// delete all the data in the table
table.delete();  

table.restoreLastDeletion();