[V6] "code": "E_INVALID_DATE_COLUMN_VALUE"

[tavaresgerson]

Hello everyone!

There is always an error when data is intermediated by a validator that has data, as in the example below:

birth: vine.date({ formats: ['YYYY-MM-DD'] })

This ends up throwing the following error:

[00:04:27.657] ERROR (137702): Invalid value for "MyNiceEntityHere.birth". The value must be an instance of "luxon.DateTime"
    request_id: "sh9wuti21z2ihp7onang6v8i"
    x-request-id: "sh9wuti21z2ihp7onang6v8i"
    err: {
      "type": "",
      "message": "Invalid value for \"MyNiceEntityHere.birth\". The value must be an instance of \"luxon.DateTime\"",
      "stack":
              Exception: Invalid value for "MyNiceEntityHere.birth". The value must be an instance of "luxon.DateTime"
              at Object.prepareDateColumn [as prepare] (file:///home/tavares/hello-world/node_modules/@adonisjs/lucid/build/src/orm/decorators/date.js:39:11)
              at file:///home/tavares/hello-world/node_modules/@adonisjs/lucid/build/src/orm/base_model/index.js:813:26
              at Array.reduce (<anonymous>)
              at Proxy.prepareForAdapter (file:///home/tavares/hello-world/node_modules/@adonisjs/lucid/build/src/orm/base_model/index.js:810:40)
              at Proxy.save (file:///home/tavares/hello-world/node_modules/@adonisjs/lucid/build/src/orm/base_model/index.js:1392:36)
              at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
              at X.update (/home/tavares/hello-world/app/models/x.ts:93:12)
              at X.update (/home/tavares/hello-world/app/x.ts:50:5)
      "name": "Exception",
      "status": 500,
      "code": "E_INVALID_DATE_COLUMN_VALUE"
    }

To get around this, I'm using the entity hook (I don't think it makes any sense, since in V5 this was never a problem, due to the automatic parsing for the DateTime), however I hope this helps someone in the future:

 @beforeSave()
 static async save(entity: YourEntityHere) {
    if (entity.$dirty.birth) {
      entity.birth = DateTime.fromJSDate(entity.$dirty.birth)
    }
}

Thank you and stay well!