Add integration tests for holdings and creator list pagination correctness and stable ordering

[Chucks1093]

Summary

Two separate pagination concerns — holdings total value accuracy across price changes and stable creator list ordering when sort values are tied — both benefit from integration test coverage. Addressing them together establishes a consistent test pattern for all paginated endpoints.

Scope

• Holdings accuracy: seed a wallet holding keys for one creator, update the price snapshot three times, assert total_value reflects the latest snapshot after each update and no previous values bleed through
• Creator list ordering: seed three creators with identical current prices, fetch all pages sorted by price, assert all three appear exactly once across pages with no duplicates or skips, assert order is consistent across two identical requests
• Both test suites should share the same database seed helper so setup is reusable

Acceptance Criteria

• Holdings total_value correct after each of three price snapshot updates
• No stale snapshot values in holdings response
• All tied-price creators appear exactly once across paginated pages
• Creator list order stable across repeated identical requests
• Shared seed helper used by both suites

ETA: 12 hours

---

Coordinate on Telegram

[charlesedeh021-cell]

Hi maintainers! I’
d love to help out with this issue. I’ve checked the current codebase/documentation and know exactly what needs to be updated to make this clearer. I will ensure everything aligns perfectly with your existing contribution guidelines.

[grantfox-oss]

🦊 GrantFox — @charlesedeh021-cell has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #596)
2. Your PR will be reviewed by the accesslayerorg maintainers

Good luck! Track your progress on GrantFox.