StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POActiveRecord Logic Challenge - Smart Ways to Use AR Timestamp
text
Body
copied!<p>My question is somewhat specific to my app's issue, but the answer should be instructive in terms of use cases for association logic and the record timestamp.</p> <p>I have an NBA pick 'em game where I want to award badges for picking x number of games in a row correctly -- 10, 20, 30.</p> <p>Here are the models, attributes, and associations in-play:</p> <pre><code>User id Pick id result # (values can be 'W', 'L', 'T', or nil. nil means hasn't resolved yet.) resolved # (values can be true, false, or nil.) game_time created_at </code></pre> <p>*Note: There are cases where a pick's result field and resolved field will always be nil. Perhaps the game was cancelled.</p> <pre><code>Badge id Award id user_id badge_id created_at </code></pre> <ul> <li>User has many awards.</li> <li>User has many picks.</li> <li>Pick belongs to user.</li> <li>Badge has many awards.</li> <li>Award belongs to user.</li> <li>Award belongs to badge.</li> </ul> <p>One of the important rules here to capture in the code is that while a user can be awarded multiple streak badges (e.g., a user can win multiple 10-streak badges), the user CAN'T be awarded another badge for consecutive winning picks that were previously granted an award badge. One way to think of this is that all the dates of the winning picks must come after the date that the streak badge was awarded. For example, let's pretend that a user made 13 winning picks from May 5 to May 8, with the 10th winning pick occurring on May 7, and the last 3 on May 8. The user would be awarded a 10-streak badge on May 7. Now if the user makes another winning pick on May 9, the code must recognize that the user only has a streak of 4 winning picks, not 14, because the user already received an award for the first 10.</p> <p>Now let's assume that the user makes 6 more winning picks. In this case, the code must recognize that all winning picks since May 5 are eligible for a 20-streak badge award, and make the award.</p> <p>Another important rule is that when looking at a winning streak, we don't care about the game time, but rather when the pick was made (created_at). For example, let's say that Team A plays Team B on Sun. And Team C plays Team D on Sat. If the user picks Team C to beat Team D on Thurs, and Team A to beat Team B on Fri, and Team C wins on Sat, but Team A loses on Sun, then the user has a winning streak of 1. Team C was picked first.</p> <p>So when must the streak-check kick-in? As soon as a pick is a win. If it's a loss or tie, no point in checking.</p> <p>One more note: if the pick is not resolved (false) and the result is nil, that means the game was postponed and must be factored out.</p> <p>With all that said, what is the most efficient, effective and lean way to determine whether a user has a 10-, 20- or 30-win streak?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload