juspay/hyperswitch

[FEATURE] add `upsert` endpoint to `cards_info` table

Open

#994 opened on Apr 26, 2023

View on GitHub
 (10 comments) (0 reactions) (1 assignee)Rust (42,690 stars) (4,676 forks)batch import
C-featureE-mediumP-lowgood first issuehelp wanted

Description

Feature Description

Currently there is only read endpoint available for cards_info table. It would be useful to add a upsert endpoint which would

  • Insert the row if the card_iin is not present
  • Update the fields if card_iin is already present

Possible Implementation

Similar to the get endpoint.

Have you spent some time to check if this feature request has been raised before?

  • I checked and didn't find similar issue

Have you read the Contributing Guidelines?

Are you willing to submit a PR?

No, but I'm happy to collaborate on a PR with someone else

Contributor guide

Tech stack
rustpostgresqlrest api
Domain
backendapidatabase
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
blocked
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
RustSQLREST APIs
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50
Research direction
Start by examining the existing `get` endpoint for `cards info` table in the codebase, likely in a file such as `crates/router/src/routes/cards info.rs`. Understand the database schema and the `storage` module to see how inserts and updates are handled. Check if there are any existing database functions or queries that perform upsert operations. Review any linked PRs or comments for further context on implementation details.