Socket
Socket
Sign inDemoInstall

orm-model

Package Overview
Dependencies
163
Maintainers
1
Versions
11
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

Comparing version 0.0.0 to 0.0.1

.travis.yml

15

package.json
{
"name": "orm-model",
"version": "0.0.0",
"description": "orm-model =========",
"version": "0.0.1",
"description": "Unified MVC-style structure for ORM models.",
"main": "index.js",

@@ -18,3 +18,12 @@ "scripts": {

},
"homepage": "https://github.com/xpepermint/orm-model"
"homepage": "https://github.com/xpepermint/orm-model",
"dependencies": {
"lodash": "^2.4.1",
"mongoose": "^3.9.1",
"mysql": "^2.4.2",
"natural": "^0.1.28",
"pg": "^3.4.1",
"sequelize": "^2.0.0-dev12",
"sqlite3": "^2.2.7"
}
}

129

README.md

@@ -1,2 +0,127 @@

orm-model
=========
# orm-model
![Build Status](https://travis-ci.org/xpepermint/orm-model.svg?branch=master) [![NPM version](https://badge.fury.io/js/orm-model.svg)](http://badge.fury.io/js/orm-model) [![Dependency Status](https://gemnasium.com/xpepermint/orm-model.svg)](https://gemnasium.com/xpepermint/orm-model)
ORM libraries are great but they usually left you with a gigant and unstructured block of code. You have to manually figure the right way on how to split the code into multiple files and it gets event worse when you have multiple databases or even multiple ORMs.
This module brings unified MVC-style structure for models into your NodeJS project. Currently the [mongoose](http://mongoosejs.com/) and [sequelize](http://sequelizejs.com) ORMs are supported.
## Installation
Install the [npm](https://www.npmjs.org/package/orm-model) package.
```
npm install orm-model --save
```
## Setup
Let's first configure project's **database connectors**. By default the module will try to read the `config/connectors.js` configuration file so let's create it. The file content should look like the example bellow.
```js
// config/connectors.js
module.exports = {
default: {
// mongoose database connector
'mongo-db': {
orm: 'mongoose',
uris: ['mongodb://user:secret@hostname:port/database'],
options: {}
},
// sequelize database connector
'seq-db': {
orm: 'sequelize',
database: 'database',
username: 'root',
password: 'secret',
options: { dialect: 'mysql' }
}
},
production: {}
};
```
The next step is to **define models**. The module will load files found at `app/models`. Let's create two models for `mongo-db` connector and two models for `seq-db` connector (defined earlier).
```js
// app/models/animal.js (mongoose model)
module.exports = {
connector: 'mongo-db',
attributes: {
name: 'string'
},
classMethods: {},
instanceMethods: {},
plugins: [{ fn: require('mongoose-timestamp'), options: { index:true } }],
middleware: {
pre: [{ event: 'save', fn: function(next) { next() }}],
post: [{ event: 'save', fn: function(model) { }}]
},
options: { strict: true }
};
```
```js
// app/models/bird.js (mongoose discriminator of animal)
module.exports = {
connector: 'mongo-db',
extends: 'animal'
};
```
```js
// app/models/user.js (sequelize model)
module.exports = {
connector: 'seq-db',
attributes: {
name: 'STRING'
},
options: {
classMethods: {},
instanceMethods: {}
}
};
```
```js
// app/models/friend.js (sequelize model extends from user)
module.exports = {
connector: 'seq-db',
extends: 'user'
};
```
Now we only have to **load and connect** connectors and models together to make it work. We do this inside project's main file (e.g. `index.js`).
```js
var orm = require('../orm-model');
orm.connect({
connectorsPath: 'new/file/path.js', // optional
modelsPath: 'new/directory/path' // optional
});
```
## API
After the project has been setup we can access any model like this:
```js
var orm = require('orm-model');
var Bird = orm.model('bird');
Bird.create({ name: "Fluppy" }, function(err, data) {
console.log('Mongoose Fluppy bird created.');
});
```
You can also access an instance of a connector (database connection).
```js
var orm = require('orm-model');
var sequelize = orm.connection('seq-db');
sequelize.query("SELECT * FROM users").success(function(data) {
console.log('Sequelize results:', data);
});
```
SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc