chore(payment_methods_v2): fingerprint changes for card

[su-shivanshmathur]

Type of Change

• [ ] Bugfix
• [ ] New feature
• [x] Enhancement
• [ ] Refactoring
• [ ] Dependency updates
• [ ] Documentation
• [ ] CI/CD

Description

We were creating fingerprint on vault side for a card based on card number and expire data , issue was arriving when same card number was there but different expire information for the same customer , now a new fingerprint ID was getting generated. Hence was being added as a new payment method in database for the same card number but changed metadata ( exp month, exp year )

To handle this , a new field is being added as seconday_fingerprint_id for maintaining the fingerprint based on card number and handle the updation of the metadata information based on the field

We can check for both the primary and secondary fingerprint and based on the result of both the fingerprint can create a new Payment Method ID or update an already existing one.

Additional Changes

• [ ] This PR modifies the API contract
• [x] This PR modifies the database schema
• [ ] This PR modifies application configuration/environment variables

Motivation and Context

How did you test it?

Checklist

• [ ] I formatted the code cargo +nightly fmt --all
• [ ] I addressed lints thrown by cargo clippy
• [ ] I reviewed the submitted code
• [ ] I added unit tests for my changes where possible

[semanticdiff-com[bot]]

Review changes with  

Changed Files

File	Status
crates/diesel_models/src/payment_method.rs	0% smaller
crates/diesel_models/src/schema_v2.rs	0% smaller
crates/hyperswitch_domain_models/src/payment_methods.rs	0% smaller
crates/router/src/core/payment_methods.rs	0% smaller
v2_migrations/2025-04-02-071223_secondary_fingerprint_id_for_card/down.sql	Unsupported file format
v2_migrations/2025-04-02-071223_secondary_fingerprint_id_for_card/up.sql	Unsupported file format

[Narayanbhat166]

@ShivanshMathurJuspay , can you add a clear description as to why this change is required? you can update the content in motivation and context subheading.

[su-shivanshmathur]

@ShivanshMathurJuspay , can you add a clear description as to why this change is required? you can update the content in motivation and context subheading.

@Narayanbhat166 have added the context of the change in the issue attached to the PR.

[prasunna09]

Looks good overall.

I am not able to figure out when it will be set and how are we planning to use it.

Specifically the motivation for this.

@NishantJoshi00 , Currently the fingerprint is generated in card number + expiry. this secondary fingerprint is generated only on card number. So if there is any change in expiry for same card number, secondary finger print will be same and primary fingerprint will be modified, this way the deduplication logic is handled by application.