hasura / hasura/graphql-engine
Identify invalid row from hasura error on bulk insert
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
I would like to be able to identify the row, that causes error on bulk insert (I'm inserting multiple objects of same type).
When inserting multiple rows to Postgres DB directly using SQL (INSERT INTO public."tableName" VALUES "row1", "row2";), I not only get an error, but also details like `DETAIL: Failing row contains "row1"`. Using details information, at least in my case, it would be possible to identify problematic row.
Contributor guide
Research direction
No implementation files or tests are named. Start by tracing how Hasura's GraphQL bulk-insert errors from Postgres are handled, then determine where the failing row detail can be exposed; done means a bulk insert error identifies the invalid row.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- graphql, postgres
- Domain
- api, backend, database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100