@vzdigitalmedia/mongodal-lib
v2.4.2
Published
A light wrapper for MongoDB
Downloads
10
Readme
Abstraction Layer for MongoDB
We wanted to be able to provide a common interface to different databases.
- MongoDB
- RethinkDB
- Direct File System
The second-thought module from Rob Conery provided a nice simple way to do this. So assuming that no lower level data was made out of the abstraction one could replace the Abstraction and switch databases. This code base then is a direct adaption of his code and ideas. Since RethinkDB uses 'id' and Mongo uses '_id' the code ensures that 'id' is available.
Functionality:
- Query, which returns an array
- First, Exists
- Save, which upserts a record
- Automatic table/db config
- DB Manipulation (Create/Drop)
Usage
This package is npm scoped to vzdigitalmedia which means you must be logged into npm and be a collaborator on the project. Install using
npm install @vzdigitalmedia/mongodal.lib
To use this in your code, just configure what you need:
var db = require("mongoDAL");
db.connect({db : "test"}, function(err,db){
//you now have access to all of your tables as properties on your db variable:
//so, assume there's a table called "foo" in your db...
db.foo.save({name : "Mike"}, function(err,saved){
//output the generated ID
console.log(saved.id);
});
});
Each table on your DB object is a full-blown Mongo collection, so you can step outside the abstraction at any point:
db.openConnection(function(err,conn){
//this is a ReQL query
db.foo.eqJoin('bar_id', db.bar).run(conn, function(err,cursor){
//run the joined action and do something interesting
cursor.toArray(function(err,array){
//use the array...
//be sure to close the connection!
conn.close();
});
});
});
In addition you can do all kinds of fun things, like...
//installation of the DB and tables
db.connect({db : "test"}, function(err, db){
db.install(['foo', 'bar'], function(err,result){
//tables should be installed now...
});
});
//add a secondary index
db.connect({db : "test"}, function(err,db){
db.foo.index("email", function(err, indexed){
//indexed == true;
});
});
Basic Queries
db.connect({db : "test", function(err,db){
db.foo.query({category : "beer"}, function(err,beers){
//beers is an array, so have at it
});
db.foo.first({email : "[email protected]"}, function(err,rob){
//hi John
});
db.foo.exists({name : "bill"}, function(err, exists){
//exists will tell you if it's there
});
db.foo.destroy({id : "some-id"}, function(err,destroyed){
//destroyed will be true if something was deleted
});
db.foo.destroyAll(function(err,destroyed){
//destroyed is the count of records whacked
});
db.foo.updateOnly({name : "Stevie"}, "some-id", function(err,result){
//save will do a full swap of the document, updateOnly will partially update
//a document so you need to pass the id along
//result will be true if an update happened
});
});
Have a look at the tests to see a bit more
License
BSD © Daniel Scholl