drizzle-team / drizzle-team/drizzle-orm
[BUG]: update timestamp field (using AWS Data API)
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
### What version of `drizzle-orm` are you using?
0.27.2
### What version of `drizzle-kit` are you using?
0.19.5
### Describe the Bug
I'm trying drizzle-orm (with sst) and aurora pg thru aws data api, when trying to insert (or update) a Date value in a column (timestamp with timezone), I'm getting this error.
I wonder if the problem is the way Date is being serialized (looks like something is using a `toString` instead of using ISO date string?)
this shows the response coming from aws-data-api
```
{
"errorType": "BadRequestException",
"errorMessage": "Cannot parse date or time \"Sat, 15 Jul 2023 05:58:12 GMT\"",
"name": "BadRequestException",
"$fault": "client",
"$metadata": {
"httpStatusCode": 400,
"requestId": "ef9415d4.......64414",
"attempts": 1,
"totalRetryDelay": 0
},
"stack": [
"BadRequestException: Cannot parse date or time \"Sat, 15 Jul 2023 05:58:12 GMT\"",
" at de_BadRequestExceptionRes (file:///var/task/packages/functions/src/auth.mjs:32546:21)",
" at de_ExecuteStatementCommandError (file:///var/task/packages/functions/src/auth.mjs:32452:19)",
" at processTicksAndRejections (node:internal/process/task_queues:96:5)",
" at async file:///var/task/packages/functions/src/auth.mjs:26732:20",
" at async file:///var/task/packages/functions/src/auth.mjs:25599:18",
" at async file:///var/task/packages/functions/src/auth.mjs:27222:38",
" at async file:///var/task/packages/functions/src/auth.mjs:24576:22",
" at async AwsDataApiPreparedQuery.values (file:///var/task/packages/functions/src/auth.mjs:33520:20)",
" at async AwsDataApiPreparedQuery.execute (file:///var/task/packages/functions/src/auth.mjs:33499:18)",
" at async upsertUser (file:///var/task/packages/functions/src/auth.mjs:38670:18)"
]
}
```
### Expected behavior
row is updated with the provided `Date` object value
### Environment & setup
AWS aurora postgres, AWS Data API
Contributor guide
Assessment
This issue has not been assessed yet.