index.js 1.0 KB

1234567891011121314151617181920212223242526272829
  1. const dbConfig = require("../../config/db.config.js");
  2. const Sequelize = require("sequelize");
  3. const sequelize = new Sequelize(
  4. dbConfig.DB, dbConfig.USER, dbConfig.PASSWORD,
  5. {
  6. host: dbConfig.HOST, dialect: dbConfig.dialect, operationAliases: false, pool: {
  7. max: dbConfig.pool.max, min: dbConfig.pool.min,
  8. acquire: dbConfig.pool.acquire, idle: dbConfig.pool.idle
  9. }
  10. }
  11. );
  12. const db = {};
  13. db.Sequelize = Sequelize;
  14. db.sequelize = sequelize;
  15. //
  16. db.langs = require("./lang.model.js")(sequelize, Sequelize);
  17. db.texts = require("./text.model.js")(sequelize, Sequelize);
  18. db.licenses = require("./license.model.js")(sequelize, Sequelize);
  19. db.projects = require("./project.model.js")(sequelize, Sequelize);
  20. //db.projects.hasMany(db.texts, {foreignkey: "title", as: "titles" });
  21. //db.projects.hasOne(db.licenses, {foreignkey: "license", as: "licens" });
  22. //db.licenses.belongsTo(db.projects, {foreignkey: "license"});
  23. db.projects.belongsTo(db.licenses, {foreignKey: 'licenseId', as: "license"});
  24. db.licenses.hasMany(db.projects);
  25. module.exports = db;