Hello, I’m trying to update to the latest version of forest, but I don’t know how to include the update of objectMapping and connections on my file /services/sequelize.
Here is my initialisation in index.js:
const { objectMapping, connections } = require(`${process.env.PWD}/api/services/sequelize`);
async function forestInitialization (app) {
app.use(await Liana.init({
envSecret: process.env.FOREST_ENV_SECRET,
authSecret: process.env.FOREST_AUTH_SECRET,
objectMapping,
connections
}))
}
module.exports = forestInitialization(app)
Here is my file /api/services/sequelize:
const Sequelize = require ('sequelize')
const config = require (`${process.env.PWD}/config/sequelize`)
const db = {}
// ---
const databasesConfiguration = require('../../config/databases');
const connections = {};
// ----
global.Model = Sequelize.Model
global.Op = Sequelize.Op
Sequelize.DataTypes.postgres.DECIMAL.parse = parseFloat
config.logging = config.logging && (message => {
if (message.includes ('CREATE')) {
console.info (message.green)
} else if (message.includes ('DELETE')) {
console.info (message.red)
} else if (message.includes ('UPDATE')) {
console.info (message.blue)
} else if (message.includes ('INSERT')) {
console.info (message.green)
} else {
console.info (message.grey)
}
}) || false
const namespace = require ('cls-hooked').createNamespace ('transaction_namespace')
Sequelize.useCLS (namespace)
const sequelize = new Sequelize (config.database, config.username, config.password, {
...config,
define: {
underscored: true,
paranoid: true,
deletedAt: 'deleted_at',
updatedAt: 'updated_at',
createdAt: 'created_at',
...(config.define || { }),
hooks: {
beforeCreate: async function (instance, { transaction }) { },
afterCreate: async function (instance, { transaction }) { },
beforeUpdate: async function (instance, { transaction }) { },
afterUpdate: async function (instance, { transaction }) { }
}
}
})
sequelize.beforeDefine (function (attributes) {
attributes.remarks = {
type: data_type.JSON
}
})
global.data_type = Sequelize
global.Sequelize = Sequelize
global.sequelize = sequelize
fs.readdirSync (`${process.env.PWD}/api/models`).filter (file => /^[a-z_]*.js/.test (file) ).map (file => {
db[file.replace (/\.js$/, '')] = require (`${process.env.PWD}/api/models/${file}`).init (sequelize, Sequelize)
})
for (let model_name of Object.keys (db).filter (model_name => db[model_name].associate)) {
db[model_name].associate (db)
Object.keys (db[model_name].prototype).map (key => {
if (typeof db[model_name].prototype[key] === 'function') {
db[model_name].prototype[key.decamelized] = db[model_name].prototype[key]
}
})
}
try {
sequelize.sync ({
force: config.force,
logging: config.logging
}).catch (error => {
console.error (error)
})
} catch (error) {
console.error (error)
}
sequelize.query = function () {
let args = arguments
return Sequelize.prototype.query.apply (this, arguments).catch (function (error) {
throw console.error ({
sql: (args[0].sql && args[0].sql.query || args[0].query || '').replace (/\$[0-9]+/g, pattern_found => {
let element = args[0].bind[pattern_found.replace ('$', '') / 1 - 1]
return typeof element === 'string' && `'${element}'` || element
}) || args[0].sql || args[0],
stack: (error.stack || '').split ('\n')[0],
hint: arguments[0].original.hint
})
})
}
Model.prototype.add_remark = async function ({ remark, remarks = [] } = { }, { user = '' } = { }) {
console.function_called (`[${this[this.constructor.primaryKeyAttributes[0]]}]`)
await this.update ({
remarks: {
...[...remarks, remark].filter (Boolean).reduce ((result, remark) => {
result[now_minimal ()] = `${user && `[${user}] ` || ''}${remark}`
return result
}, { }),
...this.remarks
}
})
}
Sequelize.models = db
db.sequelize = sequelize
db.Sequelize = Sequelize
global.namespace = namespace
global.models = db
//----
db.objectMapping = Sequelize;
db.connections = connections;
//----
module.exports = db
Thank you for your help.
welcome to our community.
