TASK: IGDB ETL – Dimension Upsert (Genre/Theme/Platform minimal)

[AndersonGACFilho]

Summary

From the fetched game records, extract and upsert the minimal dimension data for genres, themes, and platforms into their respective tables.

Details

• This involves iterating through the related fields in the game data (e.g., genres, themes) and performing an INSERT ... ON CONFLICT DO UPDATE operation for each dimension.

Acceptance Criteria

• New genres, themes, and platforms are correctly inserted into the database.
• Existing dimensions are correctly updated.
• Tests updated/added (unit/integration)
• No linter / build errors

Dependencies

• IGDB ETL – Batch Fetch Full Records

Out of Scope

• Upserting the main game record itself.

Test Plan

• Write an integration test with a test database. Provide sample game data and verify that the dimension tables are populated correctly.

Checklist

• Labels added (task, component/igdb-etl)
• CHANGELOG updated if user-visible
• No secrets committed