chesscom-mxcp

mxcp: 1 resource: name: cached_games description: Cached chess games for a player uri: "chess://games/{username}/{year}/{month}" parameters: - name: username type: string description: The Chess.com username pattern: "^[a-zA-Z0-9_-]+$" - name: year type: integer description: Year minimum: 2007 - name: month type: integer description: Month (1-12) minimum: 1 maximum: 12 source: code: | SELECT game_id, game_data, pgn_data, cached_at FROM chess_games_cache WHERE username = $username AND year = $year AND month = $month ORDER BY game_data->>'end_time' DESC