o LNhy@s<ddlZddlZddlZddZddZd defddZdS) NcCs|dr |dS|S)NScala) startswith)valueunitr$/var/www/html/ai_worker/benchmark.pyscalesr c Cstc}|}|d|f|}|s WddSz$t|d}|dd}|dkr:WWddS|WWdStyf}zt d|d|WYd}~WddSd}~ww1sjwYdS)Nz+SELECT dati FROM survey_users WHERE id = %sunknownrsrv_settore_appartenenzaAltrou-⚠️ Errore nel parsing JSON per answer_id=z: ) dbconncursorexecutefetchonejsonloadsget Exceptionprint) answer_id connectionrrowdatarawerrrget_sector_from_answers,      rsectorc st|s gS|durt|}ddD}t}|}|d|ffdd|D}Wdn1s;wYg}D]}|\}} } } } ||| | t| ||dqD|S)NcSs(i|]}|dtt|d|dqS)rr float).0rrrr "(zcompute..z SELECT factor_id, AVG(best_value) FROM case_study_kpi WHERE sector = %s OR sector = 'multi' GROUP BY factor_id cs(i|]\}}|tt|ddqS)rr r!)r#fidavgrowsrrr%-r&) factor_idlabelrcompany benchmark) r fetch_case_valuesrrrrappendr"r) rruserrrbenchtabler$r'r,r_rrr)rcomputes0    r5)N)r numpynprr rstrr5rrrrs