[EPIC] Create Game Round Flow

[robert-damoc]

This will represent each round of the game. Feel free to create 2 branches/PRs if you need, 1 for table, and 1 for model.

Table

• game_id FK
• player_id FK
• round_type - string enum
• position - int
• scores - jsonb

Unique validation for (game_id, player_id, round_type), which means that in a game, a player can play a type of round just once (e.g. You can only choose King of Hearts just once)

The game_id will be the game where this round was played The player_id will be the player that chooses this round The round_type will be a string value from a pre-defined enum The scores will hold all the scores of the playing players. E.g. { marius: -100, robert: -300 } for queens, or { marius: 0, robert: -400 } for king of hearts

Model

• Validate the uniqueness of (game_id, player_id, round_type)
• Define the round_type enum, as
  • Feel free to change the enum with the desired values (e.g. you can remove levate/whist/totale/renta, and add totale_minus, totale_plus, rentz_minue, rentz_plus)

    enum round: {
    king: king,
    queens: queens,
    diamonds: diamonds,
    levate: levate,
    rentz: rentz,
    whist: whist,
    ten: ten,
    totals: totals
    }

• Define a constant for max scores and how to compute them
  • the :constant type is the easiest - it will always be that score
  • the :per_player type means the total score should be score * players.count * 2
  • 3 players for diamonds will be -50 * 3 * 2 => -300
  • 4 players for whist will be 50 * 4 * 2 => 400
  • the :predefined will be the trickiest, as we need to define it specifically
  • for rentz, for 3 players you might defined the total as 1200 (800/400/0), while for 4 players you might want a different value
  • for totale, you want kind + queens + diamons + levate (which is 50 players.count 2)... and so on

    MAX_SCORES = {
    king: { score: -400, compute: :constant },
    queens: { score: -400, compute: :constant },
    diamonds: { score: -50, compute: :per_player },
    levate: { score: -50, compute: :per_player },
    rentz: { score: 1200, compute: :predefined },
    whist: { score: 50, compute: :per_player },
    ten: { score: 400, compute: :constant },
    totals: { score: -1500, compute: :predefined }
    }

• Validate that you can create/update game_rounds only if the game is in_progress
• Validate that before you save/create a game_round, the total number of points satisfies the max score for that specific round