Add integration test for creator list returning empty array when no creators exist

[Chucks1093]

Summary

The creator list endpoint should return an empty array with correct metadata when the database has no creator records, not a 404 or an error.

Scope

• Call GET /creators against an empty database
• Assert response status is 200
• Assert data is an empty array
• Assert meta.total is 0 and meta.hasMore is false

Acceptance Criteria

• Returns 200 with empty data array
• meta.total is 0
• meta.hasMore is false

ETA: 12 hours

---

Coordinate on Telegram

[dhareymu]

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

Hi maintainer,

Please, I would love to work on this project to fix the issues for you. I promise to work on it swiftly and create a PR for it in no time.

I look forward to working with you. Thank you.

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

[Okorie2000-code]

@Okorie2000-code has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi maintainer, can I work on this?

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

[veemakama]

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

Hi, i would love to work on this please

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

[chizzy192]

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

Hi please assign this issue to me. Thank you

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

[teethaking]

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

Hey maintainer! I'd love to take care of this issue and add the integration test for the creator list endpoint when the database is empty.
Here is how I plan to implement it:

1. Create the Integration Test Case

I will add a new test case targeting the GET /creators endpoint. I'll ensure it runs against a clean or completely cleared database state so no creator records exist during execution.

2. Assert Status and Body Structure

The test will verify that the endpoint handles an empty database gracefully by checking the exact response layout outlined in the scope:

• Status Code: Assert that it returns a 200 OK rather than a 404 Not Found or an unexpected server error.
• Data Payload: Assert that the primary data field resolves to an empty array [].
• Metadata: Assert that the pagination/metadata fields return meta.total === 0 and meta.hasMore === false.

3. Ensure Clean State Isolation

I will make sure the test properly cleans up after itself (or uses isolated transactions/database sweeping) so it doesn't interfere with other tests in the suite.
I can knock this out well within the 12-hour ETA. Please feel free to assign it to me!

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

[grantfox-oss]

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

Next steps:

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

Good luck! Track your progress on GrantFox.

[drips-wave]

Congratulations, @chizzy192! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @chizzy192: 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 🌊