+ Ki cs^RIt^RIt^RIHt^RIHt^RIHt^RIH t ^RI H t /t Rs RRltR tR tR tR tR tRRltRtRtRtRtRtRtRtRtRtRtRtR#)iN)chain)settings)sql)logger)slugifyFc sR\P!\PRWW#R7#)gamesZsearchesfiltersZexcludesZsorts)rZfiltered_queryrDB_PATHrs&&&&:/usr/lib/python3.14/site-packages/lutris/database/games.py get_gamesr s%   'HPX c sTRp.p.pVP4EFwrEVPR4vrFV'Ed`V^,pVR8Xd2VPRPV44VPV4VR8Xd+TPRPYE'dRMR44VR8Xd2VPR PV44VPV4VR 8Xd\ VR 4'g\ R V,4h\ V4R 8d \ R4hV'dbTPRPTRPR\ V4,4;'gR44\\W544pEKzEK}EKVPRPV44VPV4EK RPV4pV'dRPW34pM.#\P!\PV\V44#)a& Query games table based on conditions Args: conditions (dict): named arguments with each field matches its desired value. Special values for field names can be used: __lessthan will return rows where `field` is less than the value __isnull will return rows where `field` is NULL if the value is True __not will invert the condition using `!=` instead of `=` __in will match rows for every value of `value`, which should be an iterable Returns: list: Rows matching the query zselect * from gamesZ__Zlessthanz{} < ?Zisnullz {} is {} nullZZnotz{} != ?ZinZ__iter__z&Value should be an iterable (%s given)z.SQLite limited to a maximum of 999 parameters.z {} in ({})z, Z?z{} = ?z AND z WHERE )ZitemsZsplitZappendZformatZhasattr ValueErrorlenZjoinlistrrZdb_queryrrZtuple) Z conditionsqueryZcondition_fieldsZcondition_valuesfieldvalueZextra_conditionsZextra_condition conditions , r get_games_wherers "E"((* #(;;t#4   .q1O*, ''(>? ''.(* ''(>(>uEbW\(]^%' '' (8(8(?@ ''.$&uj11$%MPU%UVVu:#$%UVV$++L,?,?tyyQTWZ[`WaQaGbGhGhfh,ij'+E2B,J'K$ '  # #HOOE$: ;  # #E *-+. -.I12 <<((%7G1H IIr c sRp\\P!\\P !\ V4V, 44Uu.uF.p\\V4W!,W!,V,R7NK0 up44#uupi)r )Zid__in)rrZ from_iterableZrangemathZceilrr)Zgame_idsZsizeZpage& r get_games_by_idsrHsw D  "$))CMD,@"AB BD tH~dkDKRVDV'WXB    s 4B cspVR8Xd\VRR7#\RVRV/R7pV'd V^,#R#)lutrisslug)r service_idservicerN)get_game_by_fieldr )rZappidZexisting_games&& r get_game_for_servicerVs=( f55 eY'PQNa  r csVR8Xd(\R^/R7pVUu/uF q"R,VbK up#\RVR^/R7pVUu/uF q"R,VbK up#uupiuupi)r installedrrrr)r )rZdb_gamesZgrr "get_all_installed_game_for_servicer!_sm(k1%56&./h& 1 h//)Wk1!EFH(0 11lOQ  110 2s AAcs\;'g^p\P!4sV\9g\V, ^8dmVR8Xd9\RR/R7Uu.uF q"R,NK up\V&\V,#\RVRR/R7Uu.uF q"R,NK up\V&\V,#uupiuupi)z4Return the list of all installed games for a servicerr Z1rrrr)_SERVICE_CACHE_ACCESSEDtime_SERVICE_CACHEr )rZprevious_cache_accessedgamerr get_service_gamesr&hs6::"iikn$(?BY(Y\](] h @IS^`cRd@e&f@eF||@e&fN7 # ' ""09)WVacfAg/h'/ht\""/h'N7 # ' "" 'g's B<CcsVR9d\RV,4h\P!\PRW3R7pV'd V^,#/#)z&Query a game based on a database fieldzCan't query by field '%s'rr)rZinstaller_slugid configpathname)r r db_selectrr)rrZ game_resultrr rrwsH JJ4u<==-- 0 0'e^TK1~ Ir cT\P!\PRRV3R7#)z(Return all games using a specific runnerrrunnerr'rr+rr)r-&r get_games_by_runnerr0s ==))7x>P QQr cr,)z&Return all games using a specific slugrrr'r.rr/r get_games_by_slugr2s ==))7vtn MMr c s\\P!44VR&RV9d\VR,4VR&\P!\ P RV4#)zAdd a game to the database.Z installed_atrr*r)Zintr#rr db_insertrr)Z game_datas,r add_gamer4sL #DIIK 0In Y#If$56 & ==))7I >>r csxVUu.uF)p\P!\PRV4NK+ up#uupi)z Add a list of games to the database. The dicts must have an identical set of keys. Args: games (list): list of games in dict format Returns: list: List of inserted game ids r)rr3rr)rr%s& r add_games_bulkr5s1HM MutCMM(**GT :u MM Ms/7c sB\R/VBpV'dV#\R/VB#)zAdd a game to the database or update an existing one If an 'id' is provided in the parameters then it will try to match it, otherwise it will try matching by slug, creating one when possible. )update_existingr4paramsgame_id, r add_or_updater<s'''G  f r c s\V4pV'd0WR&\P!\PRVRV/4V#R#)zyUpdates a game, but do not add one. If the game exists, this returns its ID; if not it returns None and makes no changes.r(rN)get_matching_gamerZ db_updaterrr8r;r r7r7s< 'Gt  h&&$I r cs|VPR4'dC\VR,R4pV'd VR,#\P!RVR,4VPR4;'g\ VPR44pV'g \ R4h\ V4FpVR,'d+VR,VPR48Xd VR,u#K<VR,VPR48Xg,\VPR4VR,.4'dKVR,u# R #) z5Tries to match given parameters with an existing gamer(z+Game ID %s provided but couldn't be matchedrr*z)Can't add or update without an identifierr r)r-N)ZgetrrZwarningrr r2Zall)r9r%rrr r=r=szz$ t4 : DfTlS ::f  < <F);!H~H!55S&**XBVX\]eXfAg=h=hDz! ( r csT\P!\PRRV4R#)zDelete a game from the PGA.rr(N)rZ db_deleterr)r:r/r delete_gamer>sMM(""GT7;r c4\P!\P4;_uu_4pRpVP V4pVP 4pRRR4XUu.uFqD^,'gKV^,NK up# +'giL9;iuupi)z7Return a list of the runners in use by installed games.zJselect distinct runner from games where runner is not null order by runnerNrZ db_cursorrrZexecuteZfetchallZcursorrZrowsZresultsZresult r get_used_runnersrCsn x'' ( (F\~~e$--/ )%, 9G&ayyIF1IIG 99 ) ( :$BB2 B B cr?)z+Return a list of platforms currently in usezgselect distinct platform from games where platform is not null and platform is not '' order by platformNr@rArBr get_used_platformsrEss x'' ( (F u ~~e$--/ ) %, 9G&ayyIF1IIG 99 ) ( :rDcs\P!\PRRW3R7pV'dV^,R,#R#)r COUNT(id))ZfieldsrN)rFr.)ZparamrZresrr get_game_countrGs7 --(('.UZTb cC 1vk"" r )NNNNr1) rr#Z itertoolsrrrZlutris.databaserZlutris.util.logrZlutris.util.stringsrr$r"r rrrr!r&rr0r2r4r5r<r7r=r>rCrErGr6r r rHs "' 1Jh !2 #R N ? N *< ::#r