Research result data set

JakubLinhart / Mmai

Match-match Animal Individuals

MIT License

0 stars 1 forks source link

Research result data set #6

Closed JakubLinhart closed 6 years ago

JakubLinhart commented 6 years ago

Similar to /api/games table but:

group games per player and sort them chronologically, so it is obvious what games are finished/unfinished and in which order the player have played them
show all game events as one string
include unfinished games - it is not possible to measure total elapsed game time for unfinished games, or it has to be defined very strictly

Maybe merge it to /api/games table.

JakubLinhart commented 6 years ago

@pygmy83 why serialize all game events to one string? What information is important for the game event? Event kind and time since last event?

pygmy83 commented 6 years ago

@JakubLinhart GAME SEQUENCE: I did not realize the sequence of turns is already in Event table. Add there which card is played in a single additional column into Events log, e.g. "R1C4" to each event. This will allow to reconstruct the game plan for more detail analyses of player behaviour.

pygmy83 commented 6 years ago

@JakubLinhart UNFINISHED GAMES: it can be just number of turns or time to the last turned card

JakubLinhart commented 6 years ago

fixed match/finish game event duplication - only finish event recorded
only games started after this fix will be ordered by time
games started but not finished doesn't have values in Duration and MovesCount columns
Row and Column are zero based