How to pass in transaction object in custom validation?

[rbudiharso]

How to pass in transaction object to be use in custom validation/model validation? hooks can access it via options object

sequelize.define('Model', {
  username: {
    type: DataType.STRING,
    validate: {
      customValidation: function(value) {
        // how to get transaction object here?
        // someQuery
      }
    }
  }
}, {
hooks: {
  beforeCreate: function(instance, options, fn) {
    // here we got options.transaction <== like this
  }
});

[janmeier]

Hmm, I honestly don't think you should be able to access options in the validator for a single attribute. If you need to do any validations that are more involved I'd recommend before/afterValidate hooks

[rnemec]

I don't think running an additional query in a validator is involved.

[guisehn]

Although there's no way to access the transaction inside an attribute validator function, you can transform your validation into a model-wide validation -- which has access to the instance -- and then inject the transaction object into your instance during the beforeValidate hook.

I made a blog post describing how I did that and it worked: https://blog.guisehn.com/access-sequelize-transaction-model-validator/