index.js 581 B

1234567891011121314151617181920212223242526272829
  1. const
  2. fs = require('fs'),
  3. Sequelize = require('sequelize');
  4. // create Sequelize instance
  5. const sequelize = new Sequelize('w4a', 'w4a', 'w4aw4aw4a', {
  6. host: 'localhost',
  7. port: 3306,
  8. dialect: 'mysql',
  9. dialectOptions: { decimalNumbers: true }
  10. // logging: false
  11. });
  12. const db = {};
  13. fs.readdirSync(__dirname)
  14. .filter((filename) => filename !== 'index.js')
  15. .forEach((filename) => {
  16. const model = require('./' + filename)(sequelize);
  17. db[model.name] = model;
  18. });
  19. Object.keys(db).forEach((modelName) => {
  20. db[modelName].associate(db);
  21. });
  22. sequelize.sync();
  23. module.exports = db;