Noodles Practicing Medicine

    orm-model

    0.1.1 • Public • Published

    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);
    });

    Install

    npm i orm-model

    DownloadsWeekly Downloads

    1

    Version

    0.1.1

    License

    MIT

    Last publish

    Collaborators

    • xpepermint