End-to-end integration tests against the live contract (post -> index -> query)

[BigBen-7]

GistPin — GrantFox bounty issue. Reviewed against the acceptance criteria below. Read contracts/README.md first — it has the full ABI, event schema, and error codes for the deployed contract.

Context

The backend has unit tests (mocked) and a DB-integration suite
(*.integration-spec.ts, needs Postgres). Neither exercises the real,
live Soroban path end-to-end — everything Soroban-related is currently
tested against mocks only.

Problem

This is the last mile of Wave 2: proving the whole pipeline actually works
together against the real, deployed contract — post via the API, indexed by
the poller, queryable via the API, filtered correctly by expiry/hidden state.

Scope

In scope:

• A new integration spec (follow the *.integration-spec.ts naming
  convention so it's excluded from the fast unit run) that, against the live
  testnet contract (CCOVX5S3SYHVKUKM3NUXLH6COIYLV5BL3XD6HPFLLR4VLQEQGINJMDRV) and a real Postgres:
  1. POST /v1/gists (anonymous) → confirm a real tx lands
  2. Wait for/trigger an indexer poll → confirm the row appears via
     GET /v1/gists
  3. Report the gist → confirm the count updates
  4. (If merged) have the moderator hide it directly via the contract CLI →
     confirm it disappears from GET /v1/gists after the next poll
• Document how to run it (npm run test:integration plus whatever env vars
  are needed) in Backend/README.md.

Acceptance Criteria

• The full post → index → query round-trip is covered against the real
  contract, not mocks
• Expiry and hidden-state filtering are covered against real on-chain
  data
• The suite is clearly documented as requiring live network access +
  Postgres, and is not part of the fast CI unit run
• Test run is reproducible from a clean checkout following your
  documented steps

How to verify your own work

Follow the setup steps you write in Backend/README.md from a clean
checkout, top to bottom, and confirm they actually work.

Depends on: the ABI-update, exit-mock-mode, and event-persistence issues
— this is the capstone test that proves they all work together. Coordinate
timing with whoever picks those up, or expect to wait on them.
Estimated effort: Medium-Large (2-3 days). Best suited to a contributor
who has already worked on (or closely read) the issues it depends on.

[BigBen-7]

🟢 Partially unblocked — #1032 has merged. Still waiting on #1034 and #1036 before this one can be fully worked. Still unassigned, tagging for visibility.

[wrvnnull]

hello maintainer, can i please tackle #1042 up? i've already forked the repo (wrvnnull/GistPin) and reviewed the code, so i can implement and open a PR quickly once assigned. please assign me, thanks!

[mxllv]

I’d like to take this integration testing issue on. I can build the live end-to-end test against the deployed Soroban contract and Postgres, covering the full post → index → query → report flow, including expiry and hidden-state filtering. I’ll also document the required environment setup and integration test workflow so it can be reproduced from a clean checkout.

[grantfox-oss]

🦊 GrantFox — @mxllv has been assigned to this issue as part of the Third Campaign campaign!

Next steps:

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

Good luck! Track your progress on GrantFox.