sequelize.js as ORM about generator-ng-fullstack HOT 10 OPEN

'use strict';

var fs = require("fs");
var path = require("path");
var config = require('../config/environment');
var Sequelize = require("sequelize");
//var sequelize = new Sequelize(config.dbUrl);
var sequelize = new Sequelize(config.dbUrl.database, config.dbUrl.user, config.dbUrl.password, 
    { 
        host: config.dbUrl.host, 
        dialect: 'postgres', 
        sync: { force: true },
        logging: config.dbUrl.logging,
    });

var db = {};
fs
.readdirSync(__dirname)
.filter(function(file) {
  return (file.indexOf(".") !== 0) && (file.indexOf('.spec.') === -1) && (file !== "index.js");
})
.forEach(function(file) {
  var model = sequelize["import"](path.join(__dirname, file));
  db[model.name] = model;
});

Object.keys(db).forEach(function(modelName) {
if ("associate" in db[modelName]) {
  db[modelName].associate(db);
}
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

'use strict';

// Set default node environment to development
process.env.NODE_ENV = process.env.NODE_ENV || 'development';

var express = require('express');
var models = require('./models');
var config = require('./config/environment');

// Setup server
var app = express();
var server = require('http').createServer(app);
var socketio = require('socket.io')(server, {
  serveClient: (config.env === 'production') ? false : true,
  path: '/socket.io-client'
});

require('./config/socketio')(socketio);
require('./config/express')(app);
require('./routes')(app);

var forcedrop = (config.seedDB) ? true : false;

models.sequelize.sync({ force: forcedrop }).success(function () {
  // Populate DB with sample data
  if (config.seedDB) {
     require('./config/seed');
  }

});

exports = module.exports = app;

'use strict';

module.exports = function(sequelize, DataTypes) {
  var Address = sequelize.define('address', {

    lat: {
        type: DataTypes.DECIMAL(10,8),
        allowNull: true,
        defaultValue: null,
        validate: { min: -90, max: 90 }
    },
    lng: {
        type: DataTypes.DECIMAL(10,8),
        allowNull: true,
        defaultValue: null,
        validate: { min: -180, max: 180 }
    },
    customer_id: {
      type: DataTypes.INTEGER,
      allowNull: false
    }

  },{
  underscored: true,
   paranoid: true,
    validate: {

        bothCoordsOrNone: function() {
          if ((this.lat === null) === (this.lng === null)) {
            throw new Error('Require either both lat and lng or neither')
          }
        }

    },
    classMethods: {
        associate: function (models) {
          Address.belongsTo(models.customer, { foreignKey:'customer_id'})
        }
    }
  });

  return Address;
}