summaryrefslogblamecommitdiffstats
path: root/server/lib/sequelize.js
blob: 5c22bffe06eb3c3589dbad73ebfc5507f3734e42 (plain) (tree)
1
2
3
4
5
6
7
8
9
                     
            
 


                                    
                                                               
           
 


                                                                                  

                          

                       

  
                                                  
                    


                                                                             


                                      
                               
   
  
 

                        
          
 
                   
/* global __appdir */
'use strict'

var fs = require('fs')
var path = require('path')
var Sequelize = require('sequelize')
var config = require(path.join(__appdir, 'config', 'database'))
var db = {}

var sequelize = new Sequelize(config.database, config.username, config.password, {
  host: config.host,
  dialect: config.dialect,
  operatorsAliases: false,
  logging: false
})
const Op = Sequelize.Op

fs
  .readdirSync(path.join(__dirname, '/../models'))
  .forEach(file => {
    var model = sequelize['import'](path.join(__dirname, '/../models', file))
    db[model.name] = model
  })

Object.keys(db).forEach(modelName => {
  if (db[modelName].associate) {
    db[modelName].associate(db)
  }
})

db.sequelize = sequelize
db.Sequelize = Sequelize
db.Op = Op

module.exports = db