Iin.SrSSKJr SSKJrJrJr SSKJr \(a SSK J r SSK J r \"S S 55r "S S 5r\"S S55r"SS5rg)z Stats helper utilities for leaderboards and player ratings. Provides: - LeaderboardHelper: Build leaderboards from game results - RatingHelper: Track player skill ratings using OpenSkill (Plackett-Luce model) ) dataclass)AnyCallable TYPE_CHECKING) PlackettLuce) GameResult)DatabasecH\rSrSr%Sr\\S'\\S'\\-\S'\\S'Sr g) LeaderboardEntryzEntry in a leaderboard. Attributes: player_id: Player UUID. player_name: Display name. value: Aggregated metric value. rank: 1-based rank. player_id player_namevaluerankN) __name__ __module__ __qualname____firstlineno____doc__str__annotations__intfloat__static_attributes__r>c:\Users\dbart\PlayPalace11\server\game_utils\stats_helpers.pyr r s#N ; Irr c \rSrSrSr\S S\SS\S\/\ \ -S-4S\S\\ 4S jj5r \SS\SS \S/\S-4S\\ 4S jj5r S rg)LeaderboardHelper$zBuild leaderboards from game results. Supports aggregation modes (sum, max, avg, count) and custom score extraction functions. resultsr score_extractorN aggregatereturnc $0n0nUHnURHnUR(aUR(dM'U"XVR5nUcM>URU;a&/X6R'URXFR'X6RR U5 M M 0nUR 5HzupUS:Xa[U 5X'MUS:Xa[U 5X'M/US:Xa$U (a[U 5[U 5- OSX'MYUS:Xa[U 5X'Mn[SU35e [UR 5SSS 9n /n [U S 5H%un upU R [U XIUU S 95 M' U $) ao Build a leaderboard from game results. Args: results: List of game results to aggregate score_extractor: Function that extracts a score for a player from a result. Takes (result, player_id) and returns score or None. aggregate: Aggregation mode - "sum", "max", "avg", or "count" Returns: Sorted list of LeaderboardEntry (highest first) Example: # Total points scored across all Pig games leaderboard = LeaderboardHelper.build_from_results( results, score_extractor=lambda r, pid: r.custom_data.get("final_scores", {}).get(pid), aggregate="sum" ) summaxavgrcountzUnknown aggregate mode: c US$)Nrr)xs r6LeaderboardHelper.build_from_results..ds!A$rT)keyreverser)rrrr)player_resultsis_botis_virtual_botrrappenditemsr(r)len ValueErrorsorted enumerater )r#r$r% player_scores player_namesresultplayerscore aggregatedrscoressorted_playersentriesrrs rbuild_from_results$LeaderboardHelper.build_from_results+s679 ') F //==)>)>'0@0@A$''}<:< &6&679?9K9K %5%56!"2"23::5A0.0 !.!4!4!6 IE!(+F %e#(+F %e#EKF c&k(AQR %g%(+F % #;I;!GHH"7 0 0 2PTU(1.!(D $D$9 NN ' , 7  )Erwinner_extractorc^TcSSS[S-4SjmSSS[S[S-4U4Sjjn[RXS S 9$) a' Build a leaderboard based on win count. Args: results: List of game results winner_extractor: Function to extract winner player_id from result. Defaults to checking custom_data["winner_name"]. Returns: Sorted list of LeaderboardEntry by wins (highest first) Nrr r&cURRS5nU(a1URH!nURU:XdMURs $ g)z-Extract winner player_id from the GameResult. winner_nameN) custom_datagetr2rr)rHrJps rrFBLeaderboardHelper.build_wins_leaderboard..winner_extractorsDmm// > --==K7#$;;..rr=rc">T"U5nX!:Xagg)z;Return 1 for wins, 0 otherwise for leaderboard aggregation.rrr)r=r winner_idrFs rr$ALeaderboardHelper.build_wins_leaderboard..score_extractors(0I%rr()r%)rrr!rD)r#rFr$s ` rbuild_wins_leaderboard(LeaderboardHelper.build_wins_leaderboardssY  # L S4Z  L S S4Z !33GX]3^^rr)r(N)rrrrr staticmethodlistrrrrr rDrRrrrrr!r!$s El#E!<"5sU{T7I"IJEE   EENBF!_l#!_"L>3:#=>!_  !_!_rr!c^\rSrSr%Sr\\S'\\S'\\S'\S\4Sj5r S\4Sjr S r g ) PlayerRatingzPlayer skill rating values. Attributes: player_id: Player UUID. mu: Mean skill estimate. sigma: Uncertainty (standard deviation). rmusigmar&c:URSUR-- $)z+Conservative skill estimate (mu - 3*sigma).rZr[selfs rordinalPlayerRating.ordinalswwTZZ''rc<URSSURS3$)z!Return a formatted rating string.z.1fu ± r^r_s r__str__PlayerRating.__str__s ''#d4::c"233rrN) rrrrrrrrpropertyrardrrrrrXrXs=N I L (((44rrXc \rSrSrSrSrSrSSS\4SjrS \S \ 4S jr S \ \S \ \\ 44S jr S\ \ \S \ \\ 44SjrSSSS\S/\ \ \4S-S \ \\ 44SjjrSS\S \ \ 4SjjrS\S\S \4SjrSrg) RatingHelperzTrack player ratings using OpenSkill (Plackett-Luce). Supports multi-player games, teams, and ties. Ratings are persisted per game type and updated after each completed game. g9@g @dbr game_typec:XlX l[5Ulg)z Create a rating helper for a specific game type. Args: db: Database connection for persistence game_type: The game type these ratings are for N)rjrkrmodel)r`rjrks r__init__RatingHelper.__init__s"!^ rrr&cURRXR5nU(aUup4[XUS9$[UURUR S9$)zY Get a player's current rating. Returns default rating if player has no rating history. rrZr[)rjget_player_ratingrkrX DEFAULT_MU DEFAULT_SIGMA)r`rr=rZr[s r get_ratingRatingHelper.get_ratingsS **9nnE IB)%H H$$  r player_idscPUVs0sHo"URU5_M sn$s snf)z!Get ratings for multiple players.)ru)r`rwpids r get_ratingsRatingHelper.get_ratingss&5?@ZcT__S))Z@@@s#rankingsc UVVs/sH o"Ho3PM M nnnURU5n/nUH`n/nUHDnXSnURURRURUR S95 MF URU5 Mb URR U5n 0n [U5H|up[U5HhupXU n URRX0RU RU R 5 [UU RU R S9X'Mj M~ U $s snnf)a Update ratings based on game outcome. Args: rankings: Ordered list of player groups by placement. First group = 1st place, second = 2nd place, etc. Players in same group = tie for that position. Returns: Dictionary of updated ratings for all players. Example: # Alice won, Bob and Charlie tied for 2nd helper.update_ratings([["alice_id"], ["bob_id", "charlie_id"]]) # Free-for-all: Alice 1st, Bob 2nd, Charlie 3rd helper.update_ratings([["alice"], ["bob"], ["charlie"]]) r^rq) rzr5rmratingrZr[rater:rjset_player_ratingrkrX)r`r|groupry all_playerscurrent_ratingsteams team_ratingsrH new_teamsupdated_ratings group_idx player_idx new_ratings rupdate_ratingsRatingHelper.update_ratingss/.)1BuESsEs B**;7EL#(##DJJ$5$5QWW$5$MN LL & JJOOE* 46 )( 3 I#,U#3 &1*= ))#~~z}}jN^N^_'3!!}}$**($$4!4=CsENr=r ranking_extractorcUcSSS[[[4SjnU"U5nU(d0$URU5$)z Update ratings from a GameResult. Args: result: The game result ranking_extractor: Function to extract rankings from result. Defaults to simple winner-vs-rest extraction. Returns: Dictionary of updated ratings. rHr r&cURRS5nURVs/sH(o"R(aUR(dM&UPM* nnU(d/$U(a]Sn/nUH<nUR U:XaUR nM!URUR 5 M> U(aU(aU/U/$U//$UVs/sHo"R PM sn/$s snfs snf)z0Build winner-vs-rest rankings from a GameResult.rJN)rKrLr2r3r4rrr5)rHrJrM human_playersrPotherss rr:RatingHelper.update_from_result..ranking_extractor$smm// > ,-,<,< a,\ >d49o >4%V,I""8,,rlimitc URRURU5nUVVVs/sHup4n[X4US9PM snnn$s snnnf)zr Get the rating leaderboard for this game type. Returns players sorted by ordinal (conservative skill estimate). rq)rjget_rating_leaderboardrkrX)r`rrowsryrZr[s rget_leaderboardRatingHelper.get_leaderboardDsC ww--dnneDVZ[VZNCU s?VZ[[[sA  player1_id player2_idcBURU5nURU5nURRURURS9nURRURURS9nURR U/U//5S$)zW Predict the probability that player1 beats player2. Returns a value between 0 and 1. r^r)rurmr~rZr[ predict_win)r`rrr1r2rating1rating2s rpredict_win_probability$RatingHelper.predict_win_probabilityMs __Z ( __Z (**##ruuBHH#=**##ruuBHH#=zz%%y7)&<=a@@r)rjrkrmrT) )rrrrrrsrtrrnrXrurVdictrzrrrrrrrrrrrrhrhs JM $: $# $ C L Ad3iADl9J4KA5tCy/5 c< 5tOS0-0-$\NDcO$CDtK0- c< 0-d\S\$|2D\ A# A3 A5 ArrhN)r dataclassesrtypingrrropenskill.modelsr game_resultr persistence.databaser r r!rXrhrrrrsp"//)'/      q_q_h 44 4.jAjAr