0.0.4 • Published 2 years ago

@tiny-apps/nosql-db v0.0.4

Weekly downloads
-
License
MIT
Repository
github
Last release
2 years ago

Installation

Go to the root of your project and run

npm install -D @tiny-apps/nosql-db

And it to .gitignore

node_modules/
dist/
...
.storage/

Usage

Import the server and start it.

import nosqlServer from '@tiny-apps/nosql-server'

const server = nosqlServer()

Then set the database to use

const db = server.use('test_database')

And just choose a collection and run any method on it

db.test_people.insertOne({
  name: 'John',
  surname: 'Dow',
  age: 31,
})

Here is the complete example

import nosqlServer from '@tiny-apps/nosql-server'

const server = nosqlServer()
const db = server.use('test_database')

db.test_people.insertOne({
  name: 'John',
  surname: 'Dow',
  age: 31,
})
// returns { ok: true, _id: xxx, count: 1 }

db.test_people.find({
  age: 31,
})
// returns [{ _id: xxx, name: 'John', surname: 'Dow', age: 31 }]

Custom folder or name

You can change the default storage folder or name by passing them as named arguments in server creation

import nosqlServer from '@tiny-apps/nosql-server'

const server = nosqlServer({
  name: 'Main Db Server',
  path: './custom-storage'
})

Special operators

Special operators are reserved keys that allow build complex queries. All special operators starts with and underscore.

const discountedUsers = db.test_people.find({
  _or: [
    { age: { _lt: 18 } },
    { age: { _gt: 65 } },
  ]
})

Available operators

Comparation operators

  • _eq. Filter where field is equal to value
  • _neq. Filter where field is not equal to value
  • _gt. Filter where field greater than value
  • _gte. Filter where field greater or equal than value
  • _lt. Filter where field lower than value
  • _lte. Filter where field lower or equal than value
  • _in. Filter where field is in value array
  • _nin. Filter where field is not in value array

Logical operators

  • _and. Filter where all condition array items matches
  • _or. Filter where at leats one condition array item matches
  • _nor. Filter where none condition array item matches
  • _not. Filter where condition not matches

Available methods

Server

  • use(_dbName). Sets the current database to _dbName
  • listDatabases(). Return an array of all databases of the server
  • createDatabase(_name). Creates a database (implicit in use())
  • dropDatabase(_name). Deletes a database

Database

  • collection(_name) o db_name. Sets the current collection to _name
  • listCollections(). Return an array of all collections of the database
  • createCollection(_name). Creates a collection (implicit in db._name)
  • dropCollection(_name). Deletes a collection

Collection

  • find(_filter). Query the collection and returns matched records
  • findOne(_filter). Returns a record if only one matches
  • count(_filter). Count the records mathed on a query
  • distinct(_field). Return distinct values of _field in a collection
  • insertOne(_record). Insert a record
  • insertMany(_recordList). Insert a list of records
  • updateOne(_filter, _record). Update a record if only one matches
  • updateMany(_filter, _record). Update records that matches
  • deleteOne(_filter). Delete a record if only one matches
  • deleteMany(_filter). Delete records that matches

Next Features

  • More query and update special operators
0.0.4

2 years ago

0.0.3

2 years ago

0.0.2

2 years ago

0.0.1

2 years ago