const Sequelize = require('sequelize');
const db = {};

const config = require('../config/config.json')['development'];
const sequelize = new Sequelize(config.database, config.username, config.password, config);

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

db.UserComputer = require('./usercomputer')(sequelize, Sequelize) // 유저의 컴퓨터
db.Mouse = require('./mouse')(sequelize, Sequelize) // 마우스
db.UsbDrive = require('./usbdrive')(sequelize, Sequelize) // USB 드라이브
db.ServerComputer = require('./servercomputer')(sequelize, Sequelize) // 서버 컴퓨터

const hasConnected = db.sequelize.define('hasConnected', {
    connectionPriority: db.Sequelize.INTEGER
})

db.HasConnected = hasConnected

db.UserComputer.hasOne(db.Mouse)
db.Mouse.belongsTo(db.UserComputer)

db.UserComputer.hasMany(db.UsbDrive)
db.UsbDrive.belongsTo(db.UserComputer)

db.UserComputer.belongsToMany(db.ServerComputer, {
    through: db.HasConnected
})
db.ServerComputer.belongsToMany(db.UserComputer, {
    through: db.HasConnected
})

module.exports = db