Implement RecognitionTierRepository
epic-achievement-badges-foundation-task-005 — Implement RecognitionTierRepository Dart class providing read and write access to the recognition_tiers table. Expose methods: fetchAllTiers, fetchTierById, createTier, updateTier. Tiers are organisation-scoped. Ensure ordering by threshold value is supported. Repository should return strongly typed RecognitionTier domain models with fields for name, threshold, icon reference, and colour token.
Acceptance Criteria
Technical Requirements
Execution Context
Tier 2 - 518 tasks
Can start after Tier 1 completes
Implementation Notes
This is the simplest of the three repositories. Follow the exact same pattern as BadgeRepository for consistency — same exception hierarchy, same interface pattern, same Riverpod provider registration. The `colourToken` field should be a validated string matching the project's design token naming convention (e.g., 'tier_bronze', 'tier_silver', 'tier_gold') — consider defining a `TierColourToken` enum or constant class rather than accepting arbitrary strings. For `updateTier`, construct the update map by only including non-null fields from `UpdateTierParams` to avoid overwriting fields the caller did not intend to change.
Use a `toUpdateJson()` method on `UpdateTierParams` that returns `Map
Testing Requirements
Unit tests with mocked SupabaseClient: (1) fetchAllTiers returns list sorted by threshold ascending from mock data, (2) fetchAllTiers returns empty list when Supabase returns empty array, (3) fetchTierById returns null when not found, (4) createTier with threshold < 0 throws InvalidTierException before calling Supabase, (5) updateTier sends only non-null fields to Supabase update, (6) Supabase PostgrestException is wrapped in TierRepositoryException. Integration test verifying create → fetch → update cycle against local Supabase. Minimum 85% line coverage.
Badge criteria are stored as structured JSON in badge_definitions. If the JSON schema for criteria (threshold counts, streak lengths, training completion flags) is not well-defined upfront, the evaluation service will be built against a moving target, requiring costly migrations and refactors.
Mitigation & Contingency
Mitigation: Define and document the criteria JSON schema in a shared type file before any repository code is written. Review the schema with all three organisations' badge requirements — especially Blindeforbundet's honorar thresholds — and version the JSON schema using a 'criteria_version' field from day one.
Contingency: If the criteria schema must change after services are built, write a Supabase migration to backfill existing rows and add a migration version column. Keep the evaluation service criteria parser isolated behind an interface so only one function needs updating.
Badge icon assets may not yet exist or may fail WCAG 2.2 AA contrast validation (minimum 3:1 for graphical objects) when rendered over design-token backgrounds. Missing or non-compliant icons could block UI epic delivery for Blindeforbundet, for whom screen reader and visual accessibility is non-negotiable.
Mitigation & Contingency
Mitigation: During this epic, implement the contrast-ratio validator in badge-icon-asset-manager and run it as a Flutter test against all candidate icon assets early. Coordinate with the design team to provide WCAG-compliant SVG icons in both locked and unlocked variants before the UI epic begins.
Contingency: If assets are late or fail contrast checks, ship placeholder icons that are guaranteed compliant (solid design-token colour fills with text labels) and swap in final assets post-QA without requiring a code change.