+ Kics4^RIHt^RIHt^RIHtRRRRRR R /RRRR /RR RR /RR RR /RRRR /RRRR /RRRR /RRRR /RRRR /RRRR /RRRR/RRRR/RRRR/RRRR/RRRR/RRRR /RRRR/RRRR/RRRR/RRRR/RR RR /RR!RR /RR"RR /.R#RRRRR R /RR RR /RR$RR /RRRR /RR RR /RR%RR /RR&RR /RR'RR /RR(RR /RR)RR /. R*RRRRR R /RR+RR,/.R-RRRRR R /RRRR R.R /.R/RR0RRR R1/RR2RRR R1/.R3RRRRR R /RRRR R.R /RR4RR R.R1/./tR5tR;R6ltR7t R8t R9t R:#)>%(113CAACF3q63q6 E MM% 4 ) M ) ( Ms A'B)) B: cs\V: RV: 2pV'd VR, pV'd VR, pV#)z>Converts a python based table definition to it's SQL statementZ z PRIMARY KEYz UNIQUE)rrrrZ field_querys&&&& rfield_to_stringr^s,!4(K~%  y c s\RPVUu.uFp\R/VBNK up4pRV: RV: R2p\P!RV4\P !\ P4;_uu_4pVPV4RRR4R#uupi +'giR#;i)z#Creates a new table in the databasez, zCREATE TABLE IF NOT EXISTS z (Z)z [Query] %sNr) ZjoinrrZdebugrrrrr )rschemaZfZfieldsr r s&& r create_tablerhs{ YYf=f,!,f= >F48& AE LLu% x'' ( (Fu ) (> ) ( (sB9B B+ csj\V4p.pV'dVUu.uF qDR,NK ppVFnpVR,V9gK\P!RWR,4VPVR,4\P !\ PW4Kp V#\W4V#uupi)aNCompare a database table with the reference model and make necessary changes This is very basic and only the needed features have been implemented (adding columns) Args: table (str): Name of the table to migrate schema (dict): Reference schema for the table Returns: list: The list of column names that have been added rzMigrating %s field %s) rrZinfor rZ add_fieldrrr)ZtablerZexisting_schemaZmigrated_fieldsZcolZcolumnsr s&& rmigraterqs!'OO*9:/3v;;/:EV}G+ 3U&MJ&&uV}5 h..=   U# ;sB0csV\P4Fwr\W4K R#)zaUpdate the database to the current version, making necessary changes for backwards compatibility.N)DATABASEZitemsr)Z table_nameZ table_datas rsyncdbrs #+.."2  '#3rN)rFF) ZlutrisrZlutris.databaserZlutris.util.logrrrrrrrrrrrs" vy)T: ( J F  ( !662 / VV, 66* vv. ff- FJ/ vy1 fi0 3 + vv. $fi8 "FI6 *FI> VV, FF+ vv. L F 5> vy)T: FF+ &&) ( ( ( ( ' FF+ /  vy)T:  . vy)T: 48 FIy%@  9eD vy)T: 48 668U;q= @26(r