TASK: IGDB ETL – Game Upsert (core subset fields)

[AndersonGACFilho]

Summary

Upsert the core subset of fields for the main game records into the games table.

Details

• This is the final database step, where the main game object is saved.
• An INSERT ... ON CONFLICT DO UPDATE statement should be used to handle both new and existing games.
• Focus on a core subset of fields for Phase 1 (e.g., name, summary, cover_url, first_release_date).

Acceptance Criteria

• New games are inserted correctly.
• Existing games are updated correctly.
• Tests updated/added (unit/integration)
• No linter / build errors

Dependencies

• IGDB ETL – Dimension Upsert

Out of Scope

• Storing complex relational data like screenshots or videos.

Test Plan

• Write an integration test that provides a sample game object and verifies it is correctly inserted and then updated in the test database.

Checklist

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