## [](https://travis-ci.org/e-oj/Fawn) [](https://www.npmjs.com/package/fawn) [](https://www.npmjs.com/package/fawn) [](https://www.npmjs.com/package/fawn)
# Fawn
## Promise based Library for transactions in MongoDB
Fawn provides the ability to carry out edits on a mongoDB database as a series of steps. If an error occurs on any of the steps, the database is returned to its initial state (its state before the transaction started). It's based on the two phase commit system described in the [MongoDB docs](https://docs.mongodb.com/manual/tutorial/perform-two-phase-commits/). Check out [this Medium article](https://codeburst.io/fawn-transactions-in-mongodb-988d8646e564) for a more detailed look.
**View on GitHub**
- [Getting Started](#getting_started)
- [Usage](#usage)
- [API](#api)
- [Misc.](#misc)
- [Test](#test)
## Getting Started:
Install [node.js](https://nodejs.org) and [mongoDB](https://www.mongodb.com/download-center)
Start mongoDB in a terminal: ```mongod```
Then:
```npm install fawn```
## Usage:
```javascript
var Fawn = require("fawn");
Fawn.init("mongodb://127.0.0.1:27017/testDB");
```
or
```javascript
var mongoose = require("mongoose");
mongoose.connect("mongodb://127.0.0.1:27017/testDB");
Fawn.init(mongoose);
```
### Examples
Say you have two bank accounts, one belongs to John Smith and the other belongs to Broke Ass. You would like to transfer $20 from John Smith to Broke Ass. Assuming all first name and last name pairs are unique, this might look like:
```javascript
var task = Fawn.Task();
//assuming "Accounts" is the Accounts collection
task.update("Accounts", {firstName: "John", lastName: "Smith"}, {$inc: {balance: -20}})
.update("Accounts", {firstName: "Broke", lastName: "Ass"}, {$inc: {balance: 20}})
.run()
.then(function(results){
// task is complete
// result from first operation
var firstUpdateResult = results[0];
// result from second operation
var secondUpdateResult = results[1];
})
.catch(function(err){
// Everything has been rolled back.
// log the error which caused the failure
console.log(err);
});
```
[GridFS]:
Files can be saved to and removed from [GridFS][]. Here's how you might update a user's profile image:
```javascript
var newImageId = someMongoDbId;
task.saveFile("/path/to/new/profile/img", {_id: newImageId, filename: "profile.png"})
.removeFile({_id: oldImageId})
.update("users", {_id: userId}, {profileImageId: newImageId})
.run()
.then(function(results){
var newImgFile = results[0];
console.log(newImgFile.filename) // profile.png
})
.catch(function(err){
// Everything has been rolled back.
// log the error which caused the failure
console.log(err);
});
```
By default, tasks run using the native driver but you can opt for mongoose. If you prefer not to chain function calls, you don't have to:
```javascript
task.update("Accounts", {firstName: "Broke", lastName: "Ass"}, {$inc: {balance: -20}})
task.update("Accounts", {firstName: "The", lastName: "Plug"}, {$inc: {balance: 20}})
task.run({useMongoose: true})
.then(function(){
// update is complete
})
.catch(function(err){
// Everything has been rolled back.
// log the error which caused the failure
console.log(err);
});
```
The server could crash before a task is complete, You can use the Roller to rollback all incomplete transactions before starting your server:
```javascript
// assuming Fawn has been initialized. See Fawn.init below
var roller = Fawn.Roller();
roller.roll()
.then(function(){
// start server
});
```
## API
- [Fawn.init](#fawn_init)
- [Fawn.Task](#fawn_task)
- [task.initmodel](#task_initmodel)
- [task.save](#task_save)
- [task.update](#task_update)
- [task.options](#task_options)
- [task.remove](#task_remove)
- [task.saveFile](#task_savefile)
- [task.removeFile](#task_removefile)
- [task.run](#task_run)
- [Fawn.Roller](#fawn_roller)
- [Roller.roll](#roller_roll)
### Fawn.init(db, _collection, options): Initialize Fawn
> db (required): [mongoose](https://github.com/Automattic/mongoose) instance or [connection string](https://docs.mongodb.com/manual/reference/connection-string/)
> _collection (optional): Name of collection used internally by Fawn to store transactions
> options (optional. lol): Connection options. Same as [mongoose connection options](http://mongoosejs.com/docs/connections.html#options)
**Note: if you're running multiple apps connected to the same db, provide a string value for _collection that's unique to each app. Do this to avoid a situation where one app rolls back the unfinished transaction(s) of another app.**
If you're using mongoose in your project initialize Fawn with mongoose:
```javascript
var mongoose = require("mongoose");
mongoose.connect("mongodb://127.0.0.1:27017/testDB");
// remember, _collection is optional
Fawn.init(mongoose, "Fawn_collection_name_if_you_want_to_specify");
```
Without mongoose, Initialize Fawn like so:
```javascript
// options object (http://mongoosejs.com/docs/connections.html#options)
var options = {
user: "teh_huose_kat",
pass: "teh_Kitti_passwrod"
};
var collection = "Fawn_collection_name_if_you_want_to_specify";
// remember, _collection and options are optional
Fawn.init("mongodb://127.0.0.1:27017/testDB", collection || null, options || null);
```
### Fawn.Task(): Create a Fawn task
> returns: A new task
After intitializing Fawn, create a task like so:
```javascript
var task = Fawn.Task();
```
### task.initModel(modelName, schema): To initialize a model with a Schema.
> modelName (required): Name of the collection associated with this model
> schema (optional): Same as object passed to [mongoose Schema](http://mongoosejs.com/docs/guide.html#definition). Also see [validation](http://mongoosejs.com/docs/validation.html)
*Note: For model validation to work, run task with useMongoose set to true*
Initalizes a mongoose model with the provided schema. If you're using mongoose, define your models with mongoose wherever possible. If the model has been defined by mongoose before this function is called, mongoose will throw an OverwriteModelError and if it was defined by Fawn, Fawn will throw an Error. Models can be defined only once.
```javascript
var schema = {
name: {type: String, required: true}
, specials: [{title: String, year: Number}]
};
task.initModel("comedians", schema)
.save("comedians", {name: "Kevin Hart", specials: [{title: "What Now", year: 2016}]})
.run({useMongoose: true})
.then(function(results){
console.log(results);
});
```
Save operations to the "comedians" model will validate against the schema;
### task.save(model, doc): To save a document
> model (required): Name of the collection we're saving to or a mongoose model or a mongoose document
> doc (optional): Object to save or a mongoose document
these are all valid:
```javascript
var Cars = mongoose.model("cars", new Schema({make: String, year: Number}));
var toyota = new Cars({make: "Toyota", year: 2015});
task.save("cars", {make: "Toyota", year: 2015});
task.save(Cars, {make: "Toyota", year: 2015});
task.save("cars", toyota);
task.save(Cars, toyota);
task.save(toyota);
```
*Note: No changes will be made to to your database until you call task.run()*
[mongoose]:
[mongodb]:
### task.update(model, condition, data): To update a document
> model (required): Name of the collection we're updating or a mongoose model or a mongoose document
> condition (required): Same as in [mongoose][] and [mongodb][]
> data (optional): Data to update with same as in [mongoose][] and [mongodb](https://docs.mongodb.com/manual/reference/method/db.collection.update/#update-parameter)
These are all valid
```javascript
var Cars = mongoose.model("cars", new Schema({make: String, year: Number}));
task.update("cars", {make: "Toyota"}, {year: 2016});
task.update(Cars, {make: "Toyota"}, {year: 2016});
Cars.findOne({make: "Toyota"}, function(toyota){
task.update(toyota, {year: 2016});
});
```
*Note: No changes will be made to to your database until you call task.run()*
### task.options(options): Add options to an update task.
> options (required): Update options = [mongoose][] options + {viaSave: Boolean}
Attach to update call as shown
```javascript
task.update("cars", {make: "Toyota"}, {year: 2016})
.options({multi: true});
// Also valid
task.update("cars", {make: "Ford"}, {year: 2016});
task.options({multi: true});
```
The viaSave option allows you update a mongoose document using the save function. It's useful if you want to trigger mongoose pre save hooks. For this option to work you must run the task using mongoose
with mongoose:
```javascript
var doc = someMongooseDocument;
doc.someProperty = newValue;
doc.save().then(console.log);
```
with Fawn:
```javascript
var doc = someMongooseDocument;
var newDoc = doc.toObject();
newDoc.someProperty = newValue
task.update(doc, newDoc)
.options({viaSave: true})
.run({useMongoose: true})
.then(console.log);
```
*Note: No changes will be made to to your database until you call task.run()*
### task.remove(model, condition): Remove document(s) from a collection
> model (required): Name of the collection we're deleting from or a mongoose model or a mongoose document
> condition (optional): Same as in [mongoose](http://mongoosejs.com/docs/api.html#query_Query-remove)
These are all valid
```javascript
var Cars = mongoose.model("cars", new Schema({make: String, year: Number}));
// removes all cars with year === 2015
task.remove("cars", {year: 2015});
task.remove(Cars, {year: 2015});
Cars.findOne({year: 2015}, function(car){
// remove just this car
task.remove(car);
});
```
*Note: No changes will be made to to your database until you call task.run()*
### task.saveFile(filePath, options): Save a file to the db via [GridFS][]
> filePath (required): Path to the file
> options (optional): Same as [GridStore options][]
[GridStore options]:
Saves the file at "filePath" to the database using GridFS. The result of this operation is the saved file's object. See [File object](https://docs.mongodb.com/manual/core/gridfs/#the-files-collection)
```javascript
task.saveFile("path/to/some/file", {filename: "a_string_filename.ext"})
.update("SomeCollection", updateConditions, updateData)
.run()
.then(function(results){
var file = results[0];
console.log(file.filename); // a_string_filename.ext
}).catch(function(err){
// Everything has been rolled back.
//log the error which caused the failure
console.log(err);
});
```
*Note: No changes will be made to to your database until you call task.run()*
### task.removeFile(options): Remove a file from the db via [GridFS][]
> options (required): Same as [GridStore options][]
Removes a file that matches "options" from the database using GridFS. The result of this operation is a GridStore instance (can be ignored). See [GridStore]
[GridStore]:
```javascript
task.removeFile({_id: fileId})
.update("SomeCollection", updateConditions, updateData)
.run()
.then(function(results){
// if you need the gridStore instance
var gridStore = results[0];
})
.catch(function(err){
// Everything has been rolled back.
//log the error which caused the failure
console.log(err);
});
```
*Note: No changes will be made to to your database until you call task.run()*
### task.run(options): Run a task.
> options: {useMongoose: Boolean}
> returns: Promise
For the database changes to occur, you must call task.run(). This function returns a promise. On success, the promise is resolved with an array containing the [node-mongodb-native](http://mongodb.github.io/node-mongodb-native/2.2/api/Collection.html) or [mongoose](http://mongoosejs.com/docs/api.html) result of each operation in sequence. If an error occurs, the promise is rejected with the error that caused the failure.
```javascript
task.update("Accounts", {firstName: "John", lastName: "Smith"}, {$inc: {balance: -20}})
.update("Accounts", {firstName: "Broke", lastName: "Ass"}, {$inc: {balance: 20}})
.run() // or run({useMongoose: true});
.then(function(results){
//task is complete
//result from first operation
var firstUpdateResult = results[0];
//result from second operation
var secondUpdateResult = results[1];
})
.catch(function(err){
// Everything has been rolled back.
//log the error which caused the failure
console.log(err);
});
```
Results Reference:
- the result of save is, [insertOneWriteOpResult](http://mongodb.github.io/node-mongodb-native/2.2/api/Collection.html#~insertOneWriteOpResult) for mongodb native, and the saved doc for mongoose
- the result of remove is, [deleteWriteOpResult](http://mongodb.github.io/node-mongodb-native/2.2/api/Collection.html#~deleteWriteOpResult) for mongodb native, and [writeOpResult](http://mongodb.github.io/node-mongodb-native/2.2/api/Collection.html#~WriteOpResult) for mongoose
- the result of update is, [updateWriteOpResult](http://mongodb.github.io/node-mongodb-native/2.2/api/Collection.html#~updateWriteOpResult) for mongodb native, and the [mongodb update output](https://docs.mongodb.com/v2.6/reference/command/update/#output) for mongoose
- the result of saveFile is the saved file object
- the result of removeFile is a [GridStore][] instance
### Fawn.Roller(): Get the Roller object.
> returns: The Roller object
After initializing Fawn, get the Roller like so:
```javascript
var Roller = Fawn.Roller();
```
### Roller.roll(): Roll back all incomplete transcations
In case of a server crash or any other fatal error, use the roller to return all the documents affected by incomplete transactions to their original state. Should only be used when no tasks are in progress, usually on server startup.
```javascript
var roller = Fawn.Roller();
roller.roll()
.then(function(){
// start server
});
```
## Miscellaneous
### Using the result of previous steps in subsequent steps
You might want to use the result of a previous step in a subsequent step. You can do this using a template object with the key "$ojFuture". Syntax: {$ojFuture: "indexOfStep.resultProperty1.property2.-----.propertyN"}. Here's how:
```javascript
task.save("Kids", {name: {full: "Brody Obi"}}) //result will be {_id: someMongoId, name: {full: "Brody Obi"}}
.update("Parents", {_id: parentId}, {firstChild: {id: {$ojFuture: "0._id"} , fullName: {$ojFuture: "0.name.full"}})
.run({useMongoose: true})
.then(function(){
// task is complete
})
.catch(function(err){
// Everything has been rolled back.
//log the error which caused the failure
console.log(err);
});
```
To use this feature you need to know the exact format of the step's result. For Reference: [Results](#task_run_results)
## Test
To test this module, start mongodb in a terminal
```
mongod
```
Then cd to the project directory and run
```
npm test
```