Open Rubenfer opened 4 years ago
Looks like an SQLite error, this works fine with Postgres
Yes, I have other projects with Postgres and it works, but today I've tried in a SQLite project just for a quick test and it fails. This is not a critial bug for productions environmets but good to know.
As a temporary workaround, if you change the migration type to .datetime
, this then works
SQLite currently only supports storing Date
in the .datetime
data type. I've updated this issue to be a feature request for date without time support.
Vapor 4 cannot decode dates.
Steps to reproduce
Create an empty project using vapor-beta toolbox and using a SQLite database for testing purposes.
Open Todo.swift file and add a field to store a date
Todo model file looks:
Run the migrations.
Create a new Todo with ISO8601 date.
Try to get the todos. It fails.
Expected behavior
The list of todos is returned.
Actual behavior
[ ERROR ] invalid field: date type: Date error: Decoding error: Value of type 'Date' required for key ''.
Environment