Track rooms that are 'out'

[geerlingguy]

Each round, we need to know how many people are in the round, so we can calculate how big to make bubbles, how long to make bar graphs, etc. For the first round, it's easy... there are 100!

But each round after, we need to have a way to identify how many people are still in it.

I'm thinking for simplicity's sake, we add a column to the rooms table, to track if a room is active. Maybe? Something like that...

This will also need to be done for the-button game app...

[geerlingguy]

@kamranpirwani mentioned he'd need this data—so for now we could maybe just throw out a 100 for his mockup purposes (so he can program using a live field in the output), and then we could backfill that with actual data later.

[geerlingguy]

For now I threw in"total_participants": 100 so the data is there (just not yet correct):

{
  "close_time": null,
  "is_accepting_votes": 1,
  "is_allowing_multiple_votes": 1,
  "is_current": 1,
  "round_id": 9,
  "start_time": null,
  "total_participants": 100,
  "value_0": "John",
  "value_1": "Doe",
  "value_2": "Says"
}

[geerlingguy]

So, now the output looks like:

{
  "close_time": null,
  "is_accepting_votes": 1,
  "is_allowing_multiple_votes": 1,
  "live": 1,
  "round_id": 3,
  "start_time": "2023-03-10 03:05:f",
  "total_participants": 79,
  "value_0": "Chicken",
  "value_1": "Steak",
  "value_2": "Oatmeal"
}