ratings:import
Imports the latest ratings data from itch.io for all tracked games.
Overview
This command fetches current ratings information from itch.io and updates the local database with the latest user ratings, scores, and review counts. It ensures the ratings data stays synchronized with itch.io's current state.
Key Features: Automatic discovery, incremental updates, data validation, comprehensive logging.
Usage
Options
This command has no specific options - it automatically imports ratings for all tracked games using configured settings.
Import Process
The command follows this workflow:
Identifies games requiring ratings updates
Fetches ratings data from itch.io API
Validates data integrity before import
Updates database records with new ratings
Calculates aggregate scores and statistics
Reports import statistics for monitoring
Examples
Imports latest ratings for all tracked games.
Shows detailed import progress and statistics.
Only shows errors, useful for automated execution.
When to Use
Recommended Usage Scenarios
Scheduled execution (daily or weekly) for regular updates
Manual execution after discovering rating discrepancies
Initial import for newly added games
Recovery after extended downtime
Data Imported
The command imports comprehensive ratings information:
Individual Ratings
User Scores: Numerical ratings from individual users
Review Text: Written reviews and comments
Rating Dates: When ratings were submitted
User Information: Anonymized user identifiers
Aggregate Data
Average Scores: Calculated average ratings
Rating Counts: Total number of ratings
Score Distribution: Breakdown by rating value
Trend Information: Rating changes over time
Data Validation
The import process includes validation:
Source Validation
API Response: Ensures valid JSON from itch.io
Data Completeness: Verifies required fields are present
Format Consistency: Validates data types and ranges
Content Validation
Score Ranges: Ensures ratings are within valid ranges
Date Validation: Verifies rating timestamps are reasonable
Duplicate Detection: Prevents duplicate rating imports
Performance Optimization
The command is optimized for efficiency:
Incremental Updates: Only imports changed ratings
Batch Processing: Groups API calls for efficiency
Database Optimization: Uses efficient queries and indexes
Memory Management: Handles large datasets without memory issues
Error Handling
Comprehensive error handling includes:
API Failures: Retry logic for temporary network issues
Rate Limiting: Automatic backoff for API limits
Data Corruption: Validation and rollback for invalid data
Partial Failures: Continues processing despite individual errors
Monitoring
Track these metrics during import:
Games Processed: Number of games with updated ratings
Ratings Imported: Total new or updated ratings
API Calls Made: Number of requests to itch.io
Processing Time: Time taken for complete import
Error Rate: Failed imports requiring attention
Integration
The ratings import integrates with other systems:
Game Refresh: Triggered during comprehensive game updates
Feed Processing: Updates ratings when games are updated
User Interface: Provides fresh data for game displays
Analytics: Feeds rating trends and statistics
Related Commands
ratings:backfill - Fill gaps in historical ratings data
games:refresh - Comprehensive game data updates including ratings