20230912 웹소켓(model>index.js) 백업용

[fun1ty]

"use strict";

const fs = require("fs");
const path = require("path");
const Sequelize = require("sequelize");
const process = require("process");
const basename = path.basename(__filename);
const env = process.env.NODE_ENV || "development";
const config = require(__dirname + "/../config/config.js")[env];
const db = {};

let sequelize;
if (config.use_env_variable) {
sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
sequelize = new Sequelize(
config.database,
config.username,
config.password,
config
);
}

fs.readdirSync(__dirname)
.filter((file) => {
return (
file.indexOf(".") !== 0 &&
file !== basename &&
file.slice(-3) === ".js" &&
file.indexOf(".test.js") === -1
);
})
.forEach((file) => {
const model = require(path.join(__dirname, file))(
sequelize,
Sequelize.DataTypes
);
db[model.name] = model;
});

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

//db 테이블 생성
db.PublicParking = require("./PublicParking")(sequelize);
db.OperationTime = require("./OperationTime")(sequelize);
db.Price = require("./Price")(sequelize);
db.User = require("./User")(sequelize);
db.Chat = require("./chat")(sequelize);
db.ChatRoom = require("./ChatRoom")(sequelize);
db.ChatUser = require("./ChatUser")(sequelize);
db.ShareParking = require("./ShareParking")(sequelize);
db.ParkingReview = require("./ParkingReview")(sequelize);
db.Cleaning = require("./Cleaning")(sequelize);

//연관관계 설정
db.PublicParking.hasOne(db.OperationTime, {
foreignKey: "publicparking_id",
sourceKey: "id",
});
db.OperationTime.belongsTo(db.PublicParking, {
foreignKey: "publicparking_id",
targetKey: "id",
});
db.PublicParking.hasOne(db.Price, {
foreignKey: "publicparking_id",
sourceKey: "id",
});
db.Price.belongsTo(db.PublicParking, {
foreignKey: "publicparking_id",
targetKey: "id",
});
db.User.hasMany(db.ParkingReview, { foreignKey: "user_id", sourceKey: "id" });
db.ParkingReview.belongsTo(db.User, { foreignKey: "user_id", sourceKey: "id" });
db.User.hasMany(db.ShareParking, { foreignKey: "user_id", sourceKey: "id" });
db.ShareParking.belongsTo(db.User, { foreignKey: "user_id", sourceKey: "id" });

db.ShareParking.hasOne(db.Cleaning, {
foreignKey: "shareparking_id",
sourceKey: "id",
});
db.Cleaning.belongsTo(db.ShareParking, {
foreignKey: "shareparking_id",
sourceKey: "id",
});
db.User.hasMany(db.Cleaning, { foreignKey: "user_id", sourceKey: "id" });
db.Cleaning.belongsTo(db.User, { foreignKey: "user_id", sourceKey: "id" });

//채팅방-채팅방유저
db.ChatRoom.hasMany(db.ChatUser, { foreignKey: "roomid" });
db.ChatUser.belongsTo(db.ChatRoom, { foreignKey: "roomid" });

//채팅-회원
db.User.hasMany(db.Chat, { foreignKey: "userid" });
db.Chat.belongsTo(db.User, {
foreignKey: "userid",
});

//채팅방-채팅대화
db.ChatRoom.hasMany(db.Chat, { foreignKey: "roomid" });
db.Chat.belongsTo(db.ChatRoom, {
foreignKey: "roomid",
});

//채팅방유저-회원
db.User.hasMany(db.ChatUser, { foreignKey: "userid" });
db.ChatUser.belongsTo(db.User, {
foreignKey: "userid",
});

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

module.exports = db;