Simulates basic functionality of database with xlsx files. All xlsx files referenced must already exist. Recommended for prototyping and personal projects where a database is needed but only basic I/O functionality is required.

$ npm install xlsx-db

import xlsxdb from 'xlsx-db'

Gets a record by id from a file that already exists.

xlsxdb.FindById(<id>, <X>)

Where <id> (int) is the id of the file (zero indexed) and <X> (string) is the filepath.

Gets all records from a file that already exists.

xlsxdb.Find(<X>)

Where <X> (string) is the filepath.

Removes a record by id from a file that already exists.

xlsxdb.Remove(<id>, <X>)

Where <id> (int) is the id of the record and <X> (string) is the filepath.

Adds a record to a file that already exists. Ids are generated automatically using the getLowestIntNotIn algorithm..

xlsxdb.Post(<record>, <X>)

Where <record> (object) is the record and <X> (string) is th filepath.

Edits a record by id in a file that alread exists. Must pass in a record that includes the <id> (int) field.

xlsxdb.Patch(<record>, <X>)

Where <record> (object) is the record with updated fields and id, and <X> (string) is the filepath.

Fills a file with array of data specified by the user.

xlsxdb.Populate(<data>, <X>)

Where <data> (array) is an array of json objects and <X> (string) is the filepath.

Completely deletes all data in a file including keys.

xlsxdb.Clear(<X>)

Where <X> (string) is the filepath.