const Sequelize = require("sequelize");
const common = require("../tool/common");
let models = common.mapFiles("../api/model/");
const db = require("./db");
models["Sequelize"] = Sequelize;
models["op"] = Sequelize.Op;
models["sys_user"].belongsTo(models["sys_role"], { foreignKey: "roleId", targetKey: "id", as: "role" });

models["sys_form"].belongsTo(models["sys_model"], { foreignKey: "model_id", targetKey: "id", as: "model" });

models["sys_form_field"].belongsTo(models["sys_model_field"], { foreignKey: "model_field_id", targetKey: "id", as: "field" });

models.querySql = async (sql) => {
  return await db.sequelize.query(sql, { type: Sequelize.QueryTypes.SELECT });
};

module.exports = models;