Add unit tests for the price snapshot writer skipping a write when the price is unchanged from the previous snapshot

[Chucks1093]

Summary

Recording a price snapshot when the price has not changed wastes storage and pollutes the price history chart. The snapshot writer should skip the write if the new price equals the most recent stored snapshot for that creator.

Scope

• Test a new price equal to the previous snapshot results in no database write
• Test a new price different from the previous snapshot results in a write
• Test the first snapshot for a creator is always written (no previous to compare)

Acceptance Criteria

• Unchanged price skips the write
• Changed price triggers the write
• First snapshot always written

ETA: 12 hours

---

Coordinate on Telegram

[brodapeethar]

@brodapeethar has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Focused on building trust through consistent, meaningful contributions. I approach every issue with curiosity, attention to detail, and a commitment to delivering clean, maintainable, and well-tested solutions. Driven by impact, not just commits, I value clear communication, effective collaboration with maintainers, continuous learning, and delivering meaningful value to every project I contribute to.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @brodapeethar to this issue.

[attyolu]

@attyolu has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello maintainer. I can resolve this issue quickly. Please assign to me. Thank you

ℹ️ Repo Maintainers: To accept this application, review their application or assign @attyolu to this issue.

[d1a-m3n]

@d1a-m3n has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I’d like to work on this issue to contribute to the project. I’ll review the requirements, implement the necessary changes, test them properly, and ensure everything works as expected.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @d1a-m3n to this issue.

[wenxiaojie1]

@wenxiaojie1 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I’d like to add focused Jest coverage around upsertPriceSnapshot: unchanged prices should cause zero writes, while changed and first snapshots still write. I’ll verify both snapshot and history calls so the idempotency guard is explicit.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @wenxiaojie1 to this issue.

[Bogunrot]

@Bogunrot has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I'd like to work on this issue. I've reviewed the requirements and have a clear implementation plan. If assigned, I'll submit a high-quality PR that follows the project's guidelines.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Bogunrot to this issue.

[339mon]

@339mon has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello Maintainer, I’d be happy to take ownership of this issue and deliver a quality pull request once completed.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @339mon to this issue.

[Akinsuyiphilip]

@Akinsuyiphilip has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

i would love to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Akinsuyiphilip to this issue.

[TheDEV111]

@TheDEV111 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi pls can I work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @TheDEV111 to this issue.

[AbuJulaybeeb]

@AbuJulaybeeb has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

hi maintainer, i am a Full-Stack and web3 Developer, with 4+ years of experience. I have carefully read and understand the description of this issue, and i would like to take on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @AbuJulaybeeb to this issue.

[drips-wave]

Congratulations, @Akinsuyiphilip! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @Akinsuyiphilip: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊