Determine correct data type to use for Shifts.startTime

Allen-ISD-Computer-Science / IRL_DutySchedule_2024

Other

3 stars 0 forks source link

Determine correct data type to use for Shifts.startTime #9

Closed CSAllenISD closed 1 year ago

CSAllenISD commented 1 year ago

According to the documentation Date should be used, but this results in the following error: [ WARNING ] invalid field: 'startTime', type: Date, error: Swift.DecodingError.typeMismatch(Foundation.Date, Swift.DecodingError.Context(codingPath: [], debugDescription: "Could not convert MySQL data to Date: ", underlyingError: nil))

CSAllenISD commented 1 year ago

It is currently not possible to directly use the Time type per https://discordapp.com/channels/431917998102675485/684159753189982218/1166740910554501172

CSAllenISD commented 1 year ago

Fixed in commit 66e36f1b2264b3ac0ccc2c8daa4ff42062218ec8 Fields now use type CHAR(8)