Add genre-based song browsing endpoint

[Akatenvictor]

What

Add a genre-based browsing endpoint that returns songs filtered by genre with pagination and sorting options.

Why

Discoverability is critical for an audio platform. Users need to browse content by genre to find music they enjoy, and the current API provides no genre-based filtering.

Scope

• In: New GET /api/genres/:id/songs endpoint, genre listing endpoint, pagination support
• Out: Genre recommendation engine, sub-genre taxonomy, mood-based tagging

Acceptance Criteria

• GET /api/genres returns all available genres with song counts
• GET /api/genres/:id/songs returns songs in that genre with pagination
• Supports sort by: newest, most played, alphabetical
• Pagination via query params: page, limit (default 20, max 100)
• Response includes total count for client-side pagination
• Genre entity properly linked to Song entity via foreign key

Technical Context

• Genre entity exists in src/entities/Genre
• Song entity should have genre_id foreign key
• SongService can be extended with genre filtering
• SongController needs the genre-based methods
• SongRoutes needs the new routes

[nonchalanttee22-lgtm]

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

hello maintainer may i work on this issue?
ill submit PR within 1-3 days

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

[Onis2254]

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

Hello, this issue fits well with my background and I’m confident I can resolve it properly — I’d appreciate being assigned to it.

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

[M2u0i0z]

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

I understand the expected outcome and would love to work on this. I'll provide a solution that satisfies the acceptance criteria.

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

[Davichi-1]

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

Please assign maintainer. I will get the issue solved asap.

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

[macbrown27]

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

I’ve investigated the problem and have a clear view of what needs to change. My aim would be to keep the fix focused while making sure the important cases are covered.

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

[achiever2110]

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

pls assign to me

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

[drips-wave]

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

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

[drips-wave]

This issue has been completed by @achiever2110 as part of the Stellar Wave Program's 8th Wave 🥳

😎 @achiever2110: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.