hasura / hasura/graphql-engine
[FR] Support Increment/Decrement on Date/Time/Timestamp Fields
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
```
UPDATE table SET date_field = date_field + interval '1 year'
```
All these three can also be considered as numeric types, and postgres supports such operations, so why not
Currently I can only write a function and then the custom trackable function,
Or query before mutate,
it's a bit of ugly.
Contributor guide
Research direction
No files or tests are named. Start by tracing how update mutations represent field changes and how PostgreSQL date, time, and timestamp values are validated, then review the existing custom-function and query-before-mutate paths. Done means the requested increment and decrement behavior is defined, implemented, and covered for the three temporal field types.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- graphql, postgres
- Domain
- api, database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100