| 1234567891011121314151617181920212223242526272829 |
- const dbConfig = require("../../config/db.config.js");
- const Sequelize = require("sequelize");
- const sequelize = new Sequelize(
- dbConfig.DB, dbConfig.USER, dbConfig.PASSWORD,
- {
- host: dbConfig.HOST, dialect: dbConfig.dialect, operationAliases: false, pool: {
- max: dbConfig.pool.max, min: dbConfig.pool.min,
- acquire: dbConfig.pool.acquire, idle: dbConfig.pool.idle
- }
- }
- );
- const db = {};
- db.Sequelize = Sequelize;
- db.sequelize = sequelize;
- //
- db.langs = require("./lang.model.js")(sequelize, Sequelize);
- db.texts = require("./text.model.js")(sequelize, Sequelize);
- db.licenses = require("./license.model.js")(sequelize, Sequelize);
- db.projects = require("./project.model.js")(sequelize, Sequelize);
- //db.projects.hasMany(db.texts, {foreignkey: "title", as: "titles" });
- //db.projects.hasOne(db.licenses, {foreignkey: "license", as: "licens" });
- //db.licenses.belongsTo(db.projects, {foreignkey: "license"});
- db.projects.belongsTo(db.licenses, {foreignKey: 'licenseId', as: "license"});
- db.licenses.hasMany(db.projects);
- module.exports = db;
|