om

orm-model

Unified MVC-style structure for ORM models.

Showing:

Popularity

Downloads/wk

1

GitHub Stars

4

Maintenance

Last Commit

7yrs ago

Contributors

1

Package

Dependencies

6

Size (min+gzip)

168.8KB

License

MIT

Type Definitions

Tree-Shakeable

No?

Categories

Readme

orm-model

Build Status NPM version Dependency Status

ORM libraries are great but they usually left you with a gigantic 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 and sequelize ORMs are supported.

Installation

Install the npm package.

npm install orm-model --save

Setup

Let's first configure project's database connectors (connections). 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.

// 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: {}
    }
  },

  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).

// app/models/animal.js (mongoose model)
module.exports = {
  connector: 'mongo-db',
  attributes: {
    name: 'string'
  },
  classMethods: {},
  instanceMethods: {},
  plugins: [],
  middleware: {},
  options: {}
};
// app/models/bird.js (mongoose discriminator of animal)
module.exports = {
  connector: 'mongo-db',
  extends: 'animal'
};
// app/models/user.js (sequelize model)
module.exports = {
  connector: 'seq-db',
  attributes: {
    name: 'STRING'
  },
  options: {
    classMethods: {},
    instanceMethods: {}
  }
};
// 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).

var orm = require('../orm-model');
orm.connect();

Configuration

The module can be configured by sending options to the orm.connect method. See the list of available options bellow.

orm.connect({

  // Path to a file where database connectors are defined.
  connectorsPath: 'new/file/path.js',

  // Path to a directory with models files.
  modelsPath: 'new/directory/path',

  // Custom logger function (set to `false` by default).
  logger: winston.info
  // Custom logger function per ORM
  logger: {
    mongoose: require('common-log').fn({ level: debug, language: 'sql' }),
    sequelize: winston.info
  }

});

API

After the project has been setup we can access any model like this:

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).

var orm = require('orm-model');
var sequelize = orm.connection('seq-db');

sequelize.query("SELECT * FROM users").success(function(data) {
  console.log('Sequelize results:', data);
});

Rate & Review

Great Documentation0
Easy to Use0
Performant0
Highly Customizable0
Bleeding Edge0
Responsive Maintainers0
Poor Documentation0
Hard to Use0
Slow0
Buggy0
Abandoned0
Unwelcoming Community0
100
No reviews found
Be the first to rate

Alternatives

No alternatives found

Tutorials

No tutorials found
Add a tutorial