We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12500 doesn't seem to be define in the database( WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12499 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 12496 have datatype=10 whereas input 3 of step 12498 have datatype=6 WARNING : type of input 5 of step 12498 doesn't seem to be define in the database( WARNING : output 0 of step 12501 have datatype=11 whereas input 5 of step 12498 have datatype=None WARNING : output 0 of step 12496 have datatype=10 whereas input 0 of step 12501 have datatype=18 WARNING : type of input 2 of step 12502 doesn't seem to be define in the database( WARNING : output 1 of step 12494 have datatype=7 whereas input 2 of step 12502 have datatype=None WARNING : type of output 3 of step 12502 doesn't seem to be define in the database( WARNING : type of input 2 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12499 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : type of output 1 of step 12500 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : output 0 of step 12493 have datatype=1 whereas input 0 of step 12494 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier', 'hashtag_weights': {'Carton_brun': 3, 'Carton_gris': 3, 'Teint_Dans_La_Masse': 2, 'autre_refus': 3, 'cartonnette': 2, 'kraft': 3, 'metal': 6, 'plastique': 2}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 134 month : 05 mtr_id : 1053 dashboard_places : Perlen_convoyeur date : 2025-05 year : 2025 raspi : 20095 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'Perlen_convoyeur' and date like '%2025-05%') and created_at like '%2025-05%'))); nb_day : (3, 31) after unwanted_material_data nb_day : (3, 31) SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%20095%' AND ms.result_str like '%2025/05%'ORDER BY ms.id desc LIMIT 0, 1000000; Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-05-01 00:00:00,2025-05-02 00:00:00,2025-05-05 00:00:00,2025-05-06 00:00:00,2025-05-07 00:00:00,2025-05-08 00:00:00,2025-05-09 00:00:00,2025-05-12 00:00:00,2025-05-13 00:00:00,2025-05-14 00:00:00,2025-05-15 00:00:00,2025-05-16 00:00:00,2025-05-19 00:00:00,2025-05-20 00:00:00,2025-05-21 00:00:00,2025-05-22 00:00:00,2025-05-23 00:00:00,2025-05-26 00:00:00,2025-05-27 00:00:00,2025-05-28 00:00:00,2025-05-29 00:00:00,2025-05-30 00:00:00 after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 134 and month(ded.date) = 05 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______JRM' and ded.dashboard_place_id = 134 and month(ded.date) = 05 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 134 and mp.name like '%052025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-05-01 : dt_date_just_month_year : 2025-05-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "Perlen_convoyeur" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-05-01" AND ded.date <= "2025-05-31" apple3 {'JRM': {'mat': 'JRM', 'pht': 3726, 'datou_carac_id': 4433, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'papier'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1778301,1785758,1789723,1794064,1797891,1812207,1823620,1823629,1812180,1823642,1823635,1823631) AND dr.mtr_portfolio_id=ptp.mtr_portfolio_id_1 AND dr.qualite >= 0 AND mpp.mtr_portfolio_id=ptp.mtr_portfolio_id_2 AND pcr.portfolio_id=ptp.mtr_portfolio_id_1 AND h.hashtag_id = pcr.hashtag_id AND ptp.type = pcr.hashtag_type AND mpp.hide_status = 0 AND ptp.hashtag_id=h.hashtag_id group by h.hashtag, dr.hashtag, ptp.type; VR TODO TO BETTER PARSE ! ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013823027794378025, 'nb_photo': 325, 'list_port_cont': '22583613,22584649,22584714,22585008,22585100,22585247,22595692,22599905,22607548,22610091,22627800,22668719,22669756,22670178,22678924,22679945,22684565,22684637,22686787,22712923,22713225,22713388,22720528,22758696,22758858,22762206,22762650,22764583,22765497,22767858,22771283,22772578,22772963,22773470,22798320,22799902,22800788,22816659,22825368,22832278,22852250,22853105,22884657,22885585,22893724,22899650,22912799,22924149,22945748,22950934,22951322,22960523,22968373,22987426,22988446,22988740,23010855,23056983,23092500', 'assoc_port': '22582984:22584649,22583527:22584714,22583528:22583613,22584923:22585247,22584924:22585008,22585030:22585100,22595186:22595692,22598633:22607548,22599709:22627800,22599710:22599905,22605005:22610091,22667421:22668719,22668675:22669756,22668677:22670178,22676494:22678924,22676496:22686787,22677962:22684565,22677963:22684637,22679587:22679945,22712645:22712923,22712993:22713388,22712994:22713225,22717086:22720528,22757064:22758696,22757065:22758858,22757078:22764583,22757079:22762206,22760774:22762650,22761800:22767858,22761801:22765497,22769104:22772963,22771034:22771283,22771035:22773470,22772397:22772578,22798151:22798320,22799698:22799902,22800712:22800788,22814936:22816659,22818333:22832278,22822061:22853105,22824972:22825368,22830229:22852250,22875682:22899650,22881703:22885585,22882837:22884657,22885040:22893724,22912347:22912799,22916830:22924149,22918969:22968373,22923181:22945748,22950584:22988740,22950748:22950934,22950920:22951322,22960331:22960523,22963243:22987426,22967391:22988446,23004700:2301085', 'assoc_mat': '22582984:autre_refus:3726:22584649,22583527:autre_refus:3726:22584714,22583528:autre_refus:3726:22583613,22584923:autre_refus:3726:22585247,22584924:autre_refus:3726:22585008,22585030:autre_refus:3726:22585100,22595186:autre_refus:3726:22595692,22598633:autre_refus:3726:22607548,22599709:autre_refus:3726:22627800,22599710:autre_refus:3726:22599905,22605005:autre_refus:3726:22610091,22667421:autre_refus:3726:22668719,22668675:autre_refus:3726:22669756,22668677:autre_refus:3726:22670178,22676494:autre_refus:3726:22678924,22676496:autre_refus:3726:22686787,22677962:autre_refus:3726:22684565,22677963:autre_refus:3726:22684637,22679587:autre_refus:3726:22679945,22712645:autre_refus:3726:22712923,22712993:autre_refus:3726:22713388,22712994:autre_refus:3726:22713225,22717086:autre_refus:3726:22720528,22757064:autre_refus:3726:22758696,22757065:autre_refus:3726:22758858,22757078:autre_refus:3726:22764583,22757079:autre_refus:3726:22762206,22760774:autre_refus:3726:22762650,22761800:autre_refus:3726:22767858,22761801:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01343687579743514, 'nb_photo': 1069, 'list_port_cont': '22583617,22584644,22584718,22585005,22585107,22585249,22595688,22599903,22607552,22610098,22627791,22636555,22668725,22669752,22670181,22678925,22679940,22684561,22684636,22686792,22712926,22713215,22713378,22720525,22758697,22758866,22762205,22764580,22765500,22767855,22771290,22772585,22772965,22773102,22773461,22798323,22799909,22800783,22816657,22825362,22832282,22852257,22853110,22884661,22885584,22893723,22899645,22912797,22924148,22945745,22950927,22951321,22960530,22968370,22987434,22988438,22988741,23056979,23092499', 'assoc_port': '22582984:22584644,22583527:22584718,22583528:22583617,22584923:22585249,22584924:22585005,22585030:22585107,22595185:22636555,22595186:22595688,22598633:22607552,22599709:22627791,22599710:22599903,22605005:22610098,22667421:22668725,22668675:22669752,22668677:22670181,22676494:22678925,22676496:22686792,22677962:22684561,22677963:22684636,22679587:22679940,22712645:22712926,22712993:22713378,22712994:22713215,22717086:22720525,22757064:22758697,22757065:22758866,22757078:22764580,22757079:22762205,22761800:22767855,22761801:22765500,22769104:22772965,22769105:22773102,22771034:22771290,22771035:22773461,22772397:22772585,22798151:22798323,22799698:22799909,22800712:22800783,22814936:22816657,22818333:22832282,22822061:22853110,22824972:22825362,22830229:22852257,22875682:22899645,22881703:22885584,22882837:22884661,22885040:22893723,22912347:22912797,22916830:22924148,22918969:22968370,22923181:22945745,22950584:22988741,22950748:22950927,22950920:22951321,22960331:22960530,22963243:22987434,22967391:2298843', 'assoc_mat': '22582984:cartonnette:3726:22584644,22583527:cartonnette:3726:22584718,22583528:cartonnette:3726:22583617,22584923:cartonnette:3726:22585249,22584924:cartonnette:3726:22585005,22585030:cartonnette:3726:22585107,22595185:cartonnette:3726:22636555,22595186:cartonnette:3726:22595688,22598633:cartonnette:3726:22607552,22599709:cartonnette:3726:22627791,22599710:cartonnette:3726:22599903,22605005:cartonnette:3726:22610098,22667421:cartonnette:3726:22668725,22668675:cartonnette:3726:22669752,22668677:cartonnette:3726:22670181,22676494:cartonnette:3726:22678925,22676496:cartonnette:3726:22686792,22677962:cartonnette:3726:22684561,22677963:cartonnette:3726:22684636,22679587:cartonnette:3726:22679940,22712645:cartonnette:3726:22712926,22712993:cartonnette:3726:22713378,22712994:cartonnette:3726:22713215,22717086:cartonnette:3726:22720525,22757064:cartonnette:3726:22758697,22757065:cartonnette:3726:22758866,22757078:cartonnette:3726:22764580,22757079:cartonnette:3726:22762205,22761800:cartonnette:3726:22767855,22761801:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.058304873854653674, 'nb_photo': 4613, 'list_port_cont': '22583620,22584641,22584724,22585011,22585099,22585251,22595687,22599909,22607542,22610100,22627797,22636559,22668726,22669749,22670180,22678928,22679944,22684558,22684635,22686793,22712927,22713217,22713380,22720526,22758700,22758864,22762202,22762649,22764579,22765494,22767860,22771282,22772583,22772961,22773103,22773465,22798325,22799912,22800780,22816658,22825365,22832285,22852253,22853115,22884658,22885587,22893719,22899648,22912805,22924153,22945738,22950923,22951320,22960519,22968364,22987430,22988445,22988738,23010858,23056974,23092494', 'assoc_port': '22582984:22584641,22583527:22584724,22583528:22583620,22584923:22585251,22584924:22585011,22585030:22585099,22595185:22636559,22595186:22595687,22598633:22607542,22599709:22627797,22599710:22599909,22605005:22610100,22667421:22668726,22668675:22669749,22668677:22670180,22676494:22678928,22676496:22686793,22677962:22684558,22677963:22684635,22679587:22679944,22712645:22712927,22712993:22713380,22712994:22713217,22717086:22720526,22757064:22758700,22757065:22758864,22757078:22764579,22757079:22762202,22760774:22762649,22761800:22767860,22761801:22765494,22769104:22772961,22769105:22773103,22771034:22771282,22771035:22773465,22772397:22772583,22798151:22798325,22799698:22799912,22800712:22800780,22814936:22816658,22818333:22832285,22822061:22853115,22824972:22825365,22830229:22852253,22875682:22899648,22881703:22885587,22882837:22884658,22885040:22893719,22912347:22912805,22916830:22924153,22918969:22968364,22923181:22945738,22950584:22988738,22950748:22950923,22950920:22951320,22960331:22960519,22963243:2298743', 'assoc_mat': '22582984:Carton_brun:3726:22584641,22583527:Carton_brun:3726:22584724,22583528:Carton_brun:3726:22583620,22584923:Carton_brun:3726:22585251,22584924:Carton_brun:3726:22585011,22585030:Carton_brun:3726:22585099,22595185:Carton_brun:3726:22636559,22595186:Carton_brun:3726:22595687,22598633:Carton_brun:3726:22607542,22599709:Carton_brun:3726:22627797,22599710:Carton_brun:3726:22599909,22605005:Carton_brun:3726:22610100,22667421:Carton_brun:3726:22668726,22668675:Carton_brun:3726:22669749,22668677:Carton_brun:3726:22670180,22676494:Carton_brun:3726:22678928,22676496:Carton_brun:3726:22686793,22677962:Carton_brun:3726:22684558,22677963:Carton_brun:3726:22684635,22679587:Carton_brun:3726:22679944,22712645:Carton_brun:3726:22712927,22712993:Carton_brun:3726:22713380,22712994:Carton_brun:3726:22713217,22717086:Carton_brun:3726:22720526,22757064:Carton_brun:3726:22758700,22757065:Carton_brun:3726:22758864,22757078:Carton_brun:3726:22764579,22757079:Carton_brun:3726:22762202,22760774:Carton_brun:3726:22762649,22761800:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005785069070925026, 'nb_photo': 125, 'list_port_cont': '22583624,22585108,22585243,22595697,22599900,22607544,22610102,22627796,22636554,22669748,22679951,22684566,22684638,22712928,22713214,22713379,22720521,22758702,22758863,22762207,22764588,22765495,22767850,22771288,22772579,22772970,22800790,22816656,22825363,22832280,22853108,22884654,22885586,22893728,22899649,22912804,22924152,22945746,22950932,22951331,22960525,22987427,22988435,22988744', 'assoc_port': '22583528:22583624,22584923:22585243,22585030:22585108,22595185:22636554,22595186:22595697,22598633:22607544,22599709:22627796,22599710:22599900,22605005:22610102,22668675:22669748,22677962:22684566,22677963:22684638,22679587:22679951,22712645:22712928,22712993:22713379,22712994:22713214,22717086:22720521,22757064:22758702,22757065:22758863,22757078:22764588,22757079:22762207,22761800:22767850,22761801:22765495,22769104:22772970,22771034:22771288,22772397:22772579,22800712:22800790,22814936:22816656,22818333:22832280,22822061:22853108,22824972:22825363,22875682:22899649,22881703:22885586,22882837:22884654,22885040:22893728,22912347:22912804,22916830:22924152,22923181:22945746,22950584:22988744,22950748:22950932,22950920:22951331,22960331:22960525,22963243:22987427,22967391:22988435', 'assoc_mat': '22583528:Carton_gris:3726:22583624,22584923:Carton_gris:3726:22585243,22585030:Carton_gris:3726:22585108,22595185:Carton_gris:3726:22636554,22595186:Carton_gris:3726:22595697,22598633:Carton_gris:3726:22607544,22599709:Carton_gris:3726:22627796,22599710:Carton_gris:3726:22599900,22605005:Carton_gris:3726:22610102,22668675:Carton_gris:3726:22669748,22677962:Carton_gris:3726:22684566,22677963:Carton_gris:3726:22684638,22679587:Carton_gris:3726:22679951,22712645:Carton_gris:3726:22712928,22712993:Carton_gris:3726:22713379,22712994:Carton_gris:3726:22713214,22717086:Carton_gris:3726:22720521,22757064:Carton_gris:3726:22758702,22757065:Carton_gris:3726:22758863,22757078:Carton_gris:3726:22764588,22757079:Carton_gris:3726:22762207,22761800:Carton_gris:3726:22767850,22761801:Carton_gris:3726:22765495,22769104:Carton_gris:3726:22772970,22771034:Carton_gris:3726:22771288,22772397:Carton_gris:3726:22772579,22800712:Carton_gris:3726:22800790,22814936:Carton_gris:3726:22816656,22818333:Carton_gris:3726:22832280,22822061:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.003445660143613432, 'nb_photo': 61, 'list_port_cont': '22595693,22599904,22610099,22636553,22669757,22679943,22684644,22686786,22712929,22713223,22720522,22758698,22758859,22762200,22764581,22765502,22772966,22825364,22832274,22852259,22853109,22884652,22885582,22893725,22899647,22912800,22945739,22988441,22988739', 'assoc_port': '22595185:22636553,22595186:22595693,22599710:22599904,22605005:22610099,22668675:22669757,22676496:22686786,22677963:22684644,22679587:22679943,22712645:22712929,22712994:22713223,22717086:22720522,22757064:22758698,22757065:22758859,22757078:22764581,22757079:22762200,22761801:22765502,22769104:22772966,22818333:22832274,22822061:22853109,22824972:22825364,22830229:22852259,22875682:22899647,22881703:22885582,22882837:22884652,22885040:22893725,22912347:22912800,22923181:22945739,22950584:22988739,22967391:22988441', 'assoc_mat': '22595185:kraft:3726:22636553,22595186:kraft:3726:22595693,22599710:kraft:3726:22599904,22605005:kraft:3726:22610099,22668675:kraft:3726:22669757,22676496:kraft:3726:22686786,22677963:kraft:3726:22684644,22679587:kraft:3726:22679943,22712645:kraft:3726:22712929,22712994:kraft:3726:22713223,22717086:kraft:3726:22720522,22757064:kraft:3726:22758698,22757065:kraft:3726:22758859,22757078:kraft:3726:22764581,22757079:kraft:3726:22762200,22761801:kraft:3726:22765502,22769104:kraft:3726:22772966,22818333:kraft:3726:22832274,22822061:kraft:3726:22853109,22824972:kraft:3726:22825364,22830229:kraft:3726:22852259,22875682:kraft:3726:22899647,22881703:kraft:3726:22885582,22882837:kraft:3726:22884652,22885040:kraft:3726:22893725,22912347:kraft:3726:22912800,22923181:kraft:3726:22945739,22950584:kraft:3726:22988739,22967391:kraft:3726:22988441'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0009623972505245186, 'nb_photo': 14, 'list_port_cont': '22610095,22684634,22767853,22772584,22773459,22832277,22885583,22899643,22912803,22950931,22968374', 'assoc_port': '22605005:22610095,22677963:22684634,22761800:22767853,22771035:22773459,22772397:22772584,22818333:22832277,22875682:22899643,22881703:22885583,22912347:22912803,22918969:22968374,22950748:22950931', 'assoc_mat': '22605005:metal:3726:22610095,22677963:metal:3726:22684634,22761800:metal:3726:22767853,22771035:metal:3726:22773459,22772397:metal:3726:22772584,22818333:metal:3726:22832277,22875682:metal:3726:22899643,22881703:metal:3726:22885583,22912347:metal:3726:22912803,22918969:metal:3726:22968374,22950748:metal:3726:22950931'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009413774349794228, 'nb_photo': 703, 'list_port_cont': '22583615,22584651,22584722,22585010,22585106,22585242,22595689,22599901,22607547,22610092,22627801,22636560,22668720,22669750,22670176,22678918,22679942,22684564,22684645,22686789,22712933,22713222,22713383,22720527,22758695,22758862,22762210,22764578,22765499,22767857,22771284,22772587,22772971,22773105,22773469,22798326,22799907,22800784,22816665,22825366,22832281,22852262,22853111,22884653,22885590,22893718,22899644,22912806,22924147,22945749,22950933,22951328,22960520,22968367,22987428,22988442,22988737,23010852,23056978,23092495', 'assoc_port': '22582984:22584651,22583527:22584722,22583528:22583615,22584923:22585242,22584924:22585010,22585030:22585106,22595185:22636560,22595186:22595689,22598633:22607547,22599709:22627801,22599710:22599901,22605005:22610092,22667421:22668720,22668675:22669750,22668677:22670176,22676494:22678918,22676496:22686789,22677962:22684564,22677963:22684645,22679587:22679942,22712645:22712933,22712993:22713383,22712994:22713222,22717086:22720527,22757064:22758695,22757065:22758862,22757078:22764578,22757079:22762210,22761800:22767857,22761801:22765499,22769104:22772971,22769105:22773105,22771034:22771284,22771035:22773469,22772397:22772587,22798151:22798326,22799698:22799907,22800712:22800784,22814936:22816665,22818333:22832281,22822061:22853111,22824972:22825366,22830229:22852262,22875682:22899644,22881703:22885590,22882837:22884653,22885040:22893718,22912347:22912806,22916830:22924147,22918969:22968367,22923181:22945749,22950584:22988737,22950748:22950933,22950920:22951328,22960331:22960520,22963243:22987428,22967391:2298844', 'assoc_mat': '22582984:plastique:3726:22584651,22583527:plastique:3726:22584722,22583528:plastique:3726:22583615,22584923:plastique:3726:22585242,22584924:plastique:3726:22585010,22585030:plastique:3726:22585106,22595185:plastique:3726:22636560,22595186:plastique:3726:22595689,22598633:plastique:3726:22607547,22599709:plastique:3726:22627801,22599710:plastique:3726:22599901,22605005:plastique:3726:22610092,22667421:plastique:3726:22668720,22668675:plastique:3726:22669750,22668677:plastique:3726:22670176,22676494:plastique:3726:22678918,22676496:plastique:3726:22686789,22677962:plastique:3726:22684564,22677963:plastique:3726:22684645,22679587:plastique:3726:22679942,22712645:plastique:3726:22712933,22712993:plastique:3726:22713383,22712994:plastique:3726:22713222,22717086:plastique:3726:22720527,22757064:plastique:3726:22758695,22757065:plastique:3726:22758862,22757078:plastique:3726:22764578,22757079:plastique:3726:22762210,22761800:plastique:3726:22767857,22761801:plastique:3726:22765499,22769104:plastique:3726:22772971,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01925182829516749, 'nb_photo': 2467, 'list_port_cont': '22583623,22584647,22584719,22585002,22585103,22585250,22595696,22599911,22607546,22610097,22627798,22636558,22668724,22669754,22670187,22678917,22679947,22684562,22684640,22686785,22712930,22713224,22713389,22720523,22758704,22758861,22762203,22764582,22765504,22767856,22771281,22772588,22772962,22773463,22798327,22799903,22800789,22816662,22825359,22832284,22852261,22853112,22884650,22885581,22893726,22899652,22912801,22924150,22945742,22950926,22951326,22960529,22968369,22987432,22988444,22988742,23010860,23056975,23092496', 'assoc_port': '22582984:22584647,22583527:22584719,22583528:22583623,22584923:22585250,22584924:22585002,22585030:22585103,22595185:22636558,22595186:22595696,22598633:22607546,22599709:22627798,22599710:22599911,22605005:22610097,22667421:22668724,22668675:22669754,22668677:22670187,22676494:22678917,22676496:22686785,22677962:22684562,22677963:22684640,22679587:22679947,22712645:22712930,22712993:22713389,22712994:22713224,22717086:22720523,22757064:22758704,22757065:22758861,22757078:22764582,22757079:22762203,22761800:22767856,22761801:22765504,22769104:22772962,22771034:22771281,22771035:22773463,22772397:22772588,22798151:22798327,22799698:22799903,22800712:22800789,22814936:22816662,22818333:22832284,22822061:22853112,22824972:22825359,22830229:22852261,22875682:22899652,22881703:22885581,22882837:22884650,22885040:22893726,22912347:22912801,22916830:22924150,22918969:22968369,22923181:22945742,22950584:22988742,22950748:22950926,22950920:22951326,22960331:22960529,22963243:22987432,22967391:22988444,23004700:2301086', 'assoc_mat': '22582984:Teint_Dans_La_Masse:3726:22584647,22583527:Teint_Dans_La_Masse:3726:22584719,22583528:Teint_Dans_La_Masse:3726:22583623,22584923:Teint_Dans_La_Masse:3726:22585250,22584924:Teint_Dans_La_Masse:3726:22585002,22585030:Teint_Dans_La_Masse:3726:22585103,22595185:Teint_Dans_La_Masse:3726:22636558,22595186:Teint_Dans_La_Masse:3726:22595696,22598633:Teint_Dans_La_Masse:3726:22607546,22599709:Teint_Dans_La_Masse:3726:22627798,22599710:Teint_Dans_La_Masse:3726:22599911,22605005:Teint_Dans_La_Masse:3726:22610097,22667421:Teint_Dans_La_Masse:3726:22668724,22668675:Teint_Dans_La_Masse:3726:22669754,22668677:Teint_Dans_La_Masse:3726:22670187,22676494:Teint_Dans_La_Masse:3726:22678917,22676496:Teint_Dans_La_Masse:3726:22686785,22677962:Teint_Dans_La_Masse:3726:22684562,22677963:Teint_Dans_La_Masse:3726:22684640,22679587:Teint_Dans_La_Masse:3726:22679947,22712645:Teint_Dans_La_Masse:3726:22712930,22712993:Teint_Dans_La_Masse:3726:22713389,22712994:Teint_Dans_La_Masse:3726:22713224,22717086:Teint_Dans_La_Masse:3726:2'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(1778301,1785758,1789723,1794064,1797891,1812207,1823620,1823629,1812180,1823642,1823635,1823631)); after get_hostname_from_raspi SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______JRM' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=1053) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=134 and date >='2025-05-01' and date <= '2025-05-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((4570,),), 'unwanted_material_monthly_percentage': ((0.11109912758471957,),), 'material_repartition': (('JRM', 4201),), 'material_dict': {'JRM': 4201}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.10610611764158913, 515), (datetime.date(2025, 5, 2), 0.0917253050648306, 268), (datetime.date(2025, 5, 5), 0.11049041950651484, 576), (datetime.date(2025, 5, 6), 0.10196982014937608, 515), (datetime.date(2025, 5, 7), 0.0884568680996595, 530), (datetime.date(2025, 5, 8), 0.11283863183046854, 529), (datetime.date(2025, 5, 9), 0.11210230035324012, 306), (datetime.date(2025, 5, 12), 0.13519027299831843, 186), (datetime.date(2025, 5, 13), 0.11230624589943562, 278), (datetime.date(2025, 5, 14), 0.1137553944289977, 225), (datetime.date(2025, 5, 15), 0.17641183948752232, 184), (datetime.date(2025, 5, 16), 0.16812255895905698, 89)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 5, 1), 0.10610611764158913, 515), (datetime.date(2025, 5, 2), 0.0917253050648306, 268), (datetime.date(2025, 5, 5), 0.11049041950651484, 576), (datetime.date(2025, 5, 6), 0.10196982014937608, 515), (datetime.date(2025, 5, 7), 0.0884568680996595, 530), (datetime.date(2025, 5, 8), 0.11283863183046854, 529), (datetime.date(2025, 5, 9), 0.11210230035324012, 306), (datetime.date(2025, 5, 12), 0.13519027299831843, 186), (datetime.date(2025, 5, 13), 0.11230624589943562, 278), (datetime.date(2025, 5, 14), 0.1137553944289977, 225), (datetime.date(2025, 5, 15), 0.17641183948752232, 184), (datetime.date(2025, 5, 16), 0.16812255895905698, 89))}, 'quality_array': [['-0.17207893431992538', '01052025'], ['-0.012526711033691343', '02052025'], ['0.04402754502770893', '05052025'], ['-0.13410122379806966', '06052025'], ['-0.021466665304821615', '07052025'], ['-0.10733567373144835', '08052025'], ['0.14185743674460247', '09052025'], ['-0.19163959805211606', '12052025'], ['0.025740344056238502', '13052025'], ['-0.13116295181502619', '14052025'], ['-0.4313004312095373', '15052025'], ['-0.061160687434141665', '16052025']], 'number_of_batch': ((67,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013823027794378025, 'nb_photo': 325, 'list_port_cont': '22583613,22584649,22584714,22585008,22585100,22585247,22595692,22599905,22607548,22610091,22627800,22668719,22669756,22670178,22678924,22679945,22684565,22684637,22686787,22712923,22713225,22713388,22720528,22758696,22758858,22762206,22762650,22764583,22765497,22767858,22771283,22772578,22772963,22773470,22798320,22799902,22800788,22816659,22825368,22832278,22852250,22853105,22884657,22885585,22893724,22899650,22912799,22924149,22945748,22950934,22951322,22960523,22968373,22987426,22988446,22988740,23010855,23056983,23092500', 'assoc_port': '22582984:22584649,22583527:22584714,22583528:22583613,22584923:22585247,22584924:22585008,22585030:22585100,22595186:22595692,22598633:22607548,22599709:22627800,22599710:22599905,22605005:22610091,22667421:22668719,22668675:22669756,22668677:22670178,22676494:22678924,22676496:22686787,22677962:22684565,22677963:22684637,22679587:22679945,22712645:22712923,22712993:22713388,22712994:22713225,22717086:22720528,22757064:22758696,22757065:22758858,22757078:22764583,22757079:22762206,22760774:22762650,22761800:22767858,22761801:22765497,22769104:22772963,22771034:22771283,22771035:22773470,22772397:22772578,22798151:22798320,22799698:22799902,22800712:22800788,22814936:22816659,22818333:22832278,22822061:22853105,22824972:22825368,22830229:22852250,22875682:22899650,22881703:22885585,22882837:22884657,22885040:22893724,22912347:22912799,22916830:22924149,22918969:22968373,22923181:22945748,22950584:22988740,22950748:22950934,22950920:22951322,22960331:22960523,22963243:22987426,22967391:22988446,23004700:2301085', 'assoc_mat': '22582984:autre_refus:3726:22584649,22583527:autre_refus:3726:22584714,22583528:autre_refus:3726:22583613,22584923:autre_refus:3726:22585247,22584924:autre_refus:3726:22585008,22585030:autre_refus:3726:22585100,22595186:autre_refus:3726:22595692,22598633:autre_refus:3726:22607548,22599709:autre_refus:3726:22627800,22599710:autre_refus:3726:22599905,22605005:autre_refus:3726:22610091,22667421:autre_refus:3726:22668719,22668675:autre_refus:3726:22669756,22668677:autre_refus:3726:22670178,22676494:autre_refus:3726:22678924,22676496:autre_refus:3726:22686787,22677962:autre_refus:3726:22684565,22677963:autre_refus:3726:22684637,22679587:autre_refus:3726:22679945,22712645:autre_refus:3726:22712923,22712993:autre_refus:3726:22713388,22712994:autre_refus:3726:22713225,22717086:autre_refus:3726:22720528,22757064:autre_refus:3726:22758696,22757065:autre_refus:3726:22758858,22757078:autre_refus:3726:22764583,22757079:autre_refus:3726:22762206,22760774:autre_refus:3726:22762650,22761800:autre_refus:3726:22767858,22761801:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01343687579743514, 'nb_photo': 1069, 'list_port_cont': '22583617,22584644,22584718,22585005,22585107,22585249,22595688,22599903,22607552,22610098,22627791,22636555,22668725,22669752,22670181,22678925,22679940,22684561,22684636,22686792,22712926,22713215,22713378,22720525,22758697,22758866,22762205,22764580,22765500,22767855,22771290,22772585,22772965,22773102,22773461,22798323,22799909,22800783,22816657,22825362,22832282,22852257,22853110,22884661,22885584,22893723,22899645,22912797,22924148,22945745,22950927,22951321,22960530,22968370,22987434,22988438,22988741,23056979,23092499', 'assoc_port': '22582984:22584644,22583527:22584718,22583528:22583617,22584923:22585249,22584924:22585005,22585030:22585107,22595185:22636555,22595186:22595688,22598633:22607552,22599709:22627791,22599710:22599903,22605005:22610098,22667421:22668725,22668675:22669752,22668677:22670181,22676494:22678925,22676496:22686792,22677962:22684561,22677963:22684636,22679587:22679940,22712645:22712926,22712993:22713378,22712994:22713215,22717086:22720525,22757064:22758697,22757065:22758866,22757078:22764580,22757079:22762205,22761800:22767855,22761801:22765500,22769104:22772965,22769105:22773102,22771034:22771290,22771035:22773461,22772397:22772585,22798151:22798323,22799698:22799909,22800712:22800783,22814936:22816657,22818333:22832282,22822061:22853110,22824972:22825362,22830229:22852257,22875682:22899645,22881703:22885584,22882837:22884661,22885040:22893723,22912347:22912797,22916830:22924148,22918969:22968370,22923181:22945745,22950584:22988741,22950748:22950927,22950920:22951321,22960331:22960530,22963243:22987434,22967391:2298843', 'assoc_mat': '22582984:cartonnette:3726:22584644,22583527:cartonnette:3726:22584718,22583528:cartonnette:3726:22583617,22584923:cartonnette:3726:22585249,22584924:cartonnette:3726:22585005,22585030:cartonnette:3726:22585107,22595185:cartonnette:3726:22636555,22595186:cartonnette:3726:22595688,22598633:cartonnette:3726:22607552,22599709:cartonnette:3726:22627791,22599710:cartonnette:3726:22599903,22605005:cartonnette:3726:22610098,22667421:cartonnette:3726:22668725,22668675:cartonnette:3726:22669752,22668677:cartonnette:3726:22670181,22676494:cartonnette:3726:22678925,22676496:cartonnette:3726:22686792,22677962:cartonnette:3726:22684561,22677963:cartonnette:3726:22684636,22679587:cartonnette:3726:22679940,22712645:cartonnette:3726:22712926,22712993:cartonnette:3726:22713378,22712994:cartonnette:3726:22713215,22717086:cartonnette:3726:22720525,22757064:cartonnette:3726:22758697,22757065:cartonnette:3726:22758866,22757078:cartonnette:3726:22764580,22757079:cartonnette:3726:22762205,22761800:cartonnette:3726:22767855,22761801:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.058304873854653674, 'nb_photo': 4613, 'list_port_cont': '22583620,22584641,22584724,22585011,22585099,22585251,22595687,22599909,22607542,22610100,22627797,22636559,22668726,22669749,22670180,22678928,22679944,22684558,22684635,22686793,22712927,22713217,22713380,22720526,22758700,22758864,22762202,22762649,22764579,22765494,22767860,22771282,22772583,22772961,22773103,22773465,22798325,22799912,22800780,22816658,22825365,22832285,22852253,22853115,22884658,22885587,22893719,22899648,22912805,22924153,22945738,22950923,22951320,22960519,22968364,22987430,22988445,22988738,23010858,23056974,23092494', 'assoc_port': '22582984:22584641,22583527:22584724,22583528:22583620,22584923:22585251,22584924:22585011,22585030:22585099,22595185:22636559,22595186:22595687,22598633:22607542,22599709:22627797,22599710:22599909,22605005:22610100,22667421:22668726,22668675:22669749,22668677:22670180,22676494:22678928,22676496:22686793,22677962:22684558,22677963:22684635,22679587:22679944,22712645:22712927,22712993:22713380,22712994:22713217,22717086:22720526,22757064:22758700,22757065:22758864,22757078:22764579,22757079:22762202,22760774:22762649,22761800:22767860,22761801:22765494,22769104:22772961,22769105:22773103,22771034:22771282,22771035:22773465,22772397:22772583,22798151:22798325,22799698:22799912,22800712:22800780,22814936:22816658,22818333:22832285,22822061:22853115,22824972:22825365,22830229:22852253,22875682:22899648,22881703:22885587,22882837:22884658,22885040:22893719,22912347:22912805,22916830:22924153,22918969:22968364,22923181:22945738,22950584:22988738,22950748:22950923,22950920:22951320,22960331:22960519,22963243:2298743', 'assoc_mat': '22582984:Carton_brun:3726:22584641,22583527:Carton_brun:3726:22584724,22583528:Carton_brun:3726:22583620,22584923:Carton_brun:3726:22585251,22584924:Carton_brun:3726:22585011,22585030:Carton_brun:3726:22585099,22595185:Carton_brun:3726:22636559,22595186:Carton_brun:3726:22595687,22598633:Carton_brun:3726:22607542,22599709:Carton_brun:3726:22627797,22599710:Carton_brun:3726:22599909,22605005:Carton_brun:3726:22610100,22667421:Carton_brun:3726:22668726,22668675:Carton_brun:3726:22669749,22668677:Carton_brun:3726:22670180,22676494:Carton_brun:3726:22678928,22676496:Carton_brun:3726:22686793,22677962:Carton_brun:3726:22684558,22677963:Carton_brun:3726:22684635,22679587:Carton_brun:3726:22679944,22712645:Carton_brun:3726:22712927,22712993:Carton_brun:3726:22713380,22712994:Carton_brun:3726:22713217,22717086:Carton_brun:3726:22720526,22757064:Carton_brun:3726:22758700,22757065:Carton_brun:3726:22758864,22757078:Carton_brun:3726:22764579,22757079:Carton_brun:3726:22762202,22760774:Carton_brun:3726:22762649,22761800:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005785069070925026, 'nb_photo': 125, 'list_port_cont': '22583624,22585108,22585243,22595697,22599900,22607544,22610102,22627796,22636554,22669748,22679951,22684566,22684638,22712928,22713214,22713379,22720521,22758702,22758863,22762207,22764588,22765495,22767850,22771288,22772579,22772970,22800790,22816656,22825363,22832280,22853108,22884654,22885586,22893728,22899649,22912804,22924152,22945746,22950932,22951331,22960525,22987427,22988435,22988744', 'assoc_port': '22583528:22583624,22584923:22585243,22585030:22585108,22595185:22636554,22595186:22595697,22598633:22607544,22599709:22627796,22599710:22599900,22605005:22610102,22668675:22669748,22677962:22684566,22677963:22684638,22679587:22679951,22712645:22712928,22712993:22713379,22712994:22713214,22717086:22720521,22757064:22758702,22757065:22758863,22757078:22764588,22757079:22762207,22761800:22767850,22761801:22765495,22769104:22772970,22771034:22771288,22772397:22772579,22800712:22800790,22814936:22816656,22818333:22832280,22822061:22853108,22824972:22825363,22875682:22899649,22881703:22885586,22882837:22884654,22885040:22893728,22912347:22912804,22916830:22924152,22923181:22945746,22950584:22988744,22950748:22950932,22950920:22951331,22960331:22960525,22963243:22987427,22967391:22988435', 'assoc_mat': '22583528:Carton_gris:3726:22583624,22584923:Carton_gris:3726:22585243,22585030:Carton_gris:3726:22585108,22595185:Carton_gris:3726:22636554,22595186:Carton_gris:3726:22595697,22598633:Carton_gris:3726:22607544,22599709:Carton_gris:3726:22627796,22599710:Carton_gris:3726:22599900,22605005:Carton_gris:3726:22610102,22668675:Carton_gris:3726:22669748,22677962:Carton_gris:3726:22684566,22677963:Carton_gris:3726:22684638,22679587:Carton_gris:3726:22679951,22712645:Carton_gris:3726:22712928,22712993:Carton_gris:3726:22713379,22712994:Carton_gris:3726:22713214,22717086:Carton_gris:3726:22720521,22757064:Carton_gris:3726:22758702,22757065:Carton_gris:3726:22758863,22757078:Carton_gris:3726:22764588,22757079:Carton_gris:3726:22762207,22761800:Carton_gris:3726:22767850,22761801:Carton_gris:3726:22765495,22769104:Carton_gris:3726:22772970,22771034:Carton_gris:3726:22771288,22772397:Carton_gris:3726:22772579,22800712:Carton_gris:3726:22800790,22814936:Carton_gris:3726:22816656,22818333:Carton_gris:3726:22832280,22822061:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.003445660143613432, 'nb_photo': 61, 'list_port_cont': '22595693,22599904,22610099,22636553,22669757,22679943,22684644,22686786,22712929,22713223,22720522,22758698,22758859,22762200,22764581,22765502,22772966,22825364,22832274,22852259,22853109,22884652,22885582,22893725,22899647,22912800,22945739,22988441,22988739', 'assoc_port': '22595185:22636553,22595186:22595693,22599710:22599904,22605005:22610099,22668675:22669757,22676496:22686786,22677963:22684644,22679587:22679943,22712645:22712929,22712994:22713223,22717086:22720522,22757064:22758698,22757065:22758859,22757078:22764581,22757079:22762200,22761801:22765502,22769104:22772966,22818333:22832274,22822061:22853109,22824972:22825364,22830229:22852259,22875682:22899647,22881703:22885582,22882837:22884652,22885040:22893725,22912347:22912800,22923181:22945739,22950584:22988739,22967391:22988441', 'assoc_mat': '22595185:kraft:3726:22636553,22595186:kraft:3726:22595693,22599710:kraft:3726:22599904,22605005:kraft:3726:22610099,22668675:kraft:3726:22669757,22676496:kraft:3726:22686786,22677963:kraft:3726:22684644,22679587:kraft:3726:22679943,22712645:kraft:3726:22712929,22712994:kraft:3726:22713223,22717086:kraft:3726:22720522,22757064:kraft:3726:22758698,22757065:kraft:3726:22758859,22757078:kraft:3726:22764581,22757079:kraft:3726:22762200,22761801:kraft:3726:22765502,22769104:kraft:3726:22772966,22818333:kraft:3726:22832274,22822061:kraft:3726:22853109,22824972:kraft:3726:22825364,22830229:kraft:3726:22852259,22875682:kraft:3726:22899647,22881703:kraft:3726:22885582,22882837:kraft:3726:22884652,22885040:kraft:3726:22893725,22912347:kraft:3726:22912800,22923181:kraft:3726:22945739,22950584:kraft:3726:22988739,22967391:kraft:3726:22988441'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0009623972505245186, 'nb_photo': 14, 'list_port_cont': '22610095,22684634,22767853,22772584,22773459,22832277,22885583,22899643,22912803,22950931,22968374', 'assoc_port': '22605005:22610095,22677963:22684634,22761800:22767853,22771035:22773459,22772397:22772584,22818333:22832277,22875682:22899643,22881703:22885583,22912347:22912803,22918969:22968374,22950748:22950931', 'assoc_mat': '22605005:metal:3726:22610095,22677963:metal:3726:22684634,22761800:metal:3726:22767853,22771035:metal:3726:22773459,22772397:metal:3726:22772584,22818333:metal:3726:22832277,22875682:metal:3726:22899643,22881703:metal:3726:22885583,22912347:metal:3726:22912803,22918969:metal:3726:22968374,22950748:metal:3726:22950931'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009413774349794228, 'nb_photo': 703, 'list_port_cont': '22583615,22584651,22584722,22585010,22585106,22585242,22595689,22599901,22607547,22610092,22627801,22636560,22668720,22669750,22670176,22678918,22679942,22684564,22684645,22686789,22712933,22713222,22713383,22720527,22758695,22758862,22762210,22764578,22765499,22767857,22771284,22772587,22772971,22773105,22773469,22798326,22799907,22800784,22816665,22825366,22832281,22852262,22853111,22884653,22885590,22893718,22899644,22912806,22924147,22945749,22950933,22951328,22960520,22968367,22987428,22988442,22988737,23010852,23056978,23092495', 'assoc_port': '22582984:22584651,22583527:22584722,22583528:22583615,22584923:22585242,22584924:22585010,22585030:22585106,22595185:22636560,22595186:22595689,22598633:22607547,22599709:22627801,22599710:22599901,22605005:22610092,22667421:22668720,22668675:22669750,22668677:22670176,22676494:22678918,22676496:22686789,22677962:22684564,22677963:22684645,22679587:22679942,22712645:22712933,22712993:22713383,22712994:22713222,22717086:22720527,22757064:22758695,22757065:22758862,22757078:22764578,22757079:22762210,22761800:22767857,22761801:22765499,22769104:22772971,22769105:22773105,22771034:22771284,22771035:22773469,22772397:22772587,22798151:22798326,22799698:22799907,22800712:22800784,22814936:22816665,22818333:22832281,22822061:22853111,22824972:22825366,22830229:22852262,22875682:22899644,22881703:22885590,22882837:22884653,22885040:22893718,22912347:22912806,22916830:22924147,22918969:22968367,22923181:22945749,22950584:22988737,22950748:22950933,22950920:22951328,22960331:22960520,22963243:22987428,22967391:2298844', 'assoc_mat': '22582984:plastique:3726:22584651,22583527:plastique:3726:22584722,22583528:plastique:3726:22583615,22584923:plastique:3726:22585242,22584924:plastique:3726:22585010,22585030:plastique:3726:22585106,22595185:plastique:3726:22636560,22595186:plastique:3726:22595689,22598633:plastique:3726:22607547,22599709:plastique:3726:22627801,22599710:plastique:3726:22599901,22605005:plastique:3726:22610092,22667421:plastique:3726:22668720,22668675:plastique:3726:22669750,22668677:plastique:3726:22670176,22676494:plastique:3726:22678918,22676496:plastique:3726:22686789,22677962:plastique:3726:22684564,22677963:plastique:3726:22684645,22679587:plastique:3726:22679942,22712645:plastique:3726:22712933,22712993:plastique:3726:22713383,22712994:plastique:3726:22713222,22717086:plastique:3726:22720527,22757064:plastique:3726:22758695,22757065:plastique:3726:22758862,22757078:plastique:3726:22764578,22757079:plastique:3726:22762210,22761800:plastique:3726:22767857,22761801:plastique:3726:22765499,22769104:plastique:3726:22772971,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01925182829516749, 'nb_photo': 2467, 'list_port_cont': '22583623,22584647,22584719,22585002,22585103,22585250,22595696,22599911,22607546,22610097,22627798,22636558,22668724,22669754,22670187,22678917,22679947,22684562,22684640,22686785,22712930,22713224,22713389,22720523,22758704,22758861,22762203,22764582,22765504,22767856,22771281,22772588,22772962,22773463,22798327,22799903,22800789,22816662,22825359,22832284,22852261,22853112,22884650,22885581,22893726,22899652,22912801,22924150,22945742,22950926,22951326,22960529,22968369,22987432,22988444,22988742,23010860,23056975,23092496', 'assoc_port': '22582984:22584647,22583527:22584719,22583528:22583623,22584923:22585250,22584924:22585002,22585030:22585103,22595185:22636558,22595186:22595696,22598633:22607546,22599709:22627798,22599710:22599911,22605005:22610097,22667421:22668724,22668675:22669754,22668677:22670187,22676494:22678917,22676496:22686785,22677962:22684562,22677963:22684640,22679587:22679947,22712645:22712930,22712993:22713389,22712994:22713224,22717086:22720523,22757064:22758704,22757065:22758861,22757078:22764582,22757079:22762203,22761800:22767856,22761801:22765504,22769104:22772962,22771034:22771281,22771035:22773463,22772397:22772588,22798151:22798327,22799698:22799903,22800712:22800789,22814936:22816662,22818333:22832284,22822061:22853112,22824972:22825359,22830229:22852261,22875682:22899652,22881703:22885581,22882837:22884650,22885040:22893726,22912347:22912801,22916830:22924150,22918969:22968369,22923181:22945742,22950584:22988742,22950748:22950926,22950920:22951326,22960331:22960529,22963243:22987432,22967391:22988444,23004700:2301086', 'assoc_mat': '22582984:Teint_Dans_La_Masse:3726:22584647,22583527:Teint_Dans_La_Masse:3726:22584719,22583528:Teint_Dans_La_Masse:3726:22583623,22584923:Teint_Dans_La_Masse:3726:22585250,22584924:Teint_Dans_La_Masse:3726:22585002,22585030:Teint_Dans_La_Masse:3726:22585103,22595185:Teint_Dans_La_Masse:3726:22636558,22595186:Teint_Dans_La_Masse:3726:22595696,22598633:Teint_Dans_La_Masse:3726:22607546,22599709:Teint_Dans_La_Masse:3726:22627798,22599710:Teint_Dans_La_Masse:3726:22599911,22605005:Teint_Dans_La_Masse:3726:22610097,22667421:Teint_Dans_La_Masse:3726:22668724,22668675:Teint_Dans_La_Masse:3726:22669754,22668677:Teint_Dans_La_Masse:3726:22670187,22676494:Teint_Dans_La_Masse:3726:22678917,22676496:Teint_Dans_La_Masse:3726:22686785,22677962:Teint_Dans_La_Masse:3726:22684562,22677963:Teint_Dans_La_Masse:3726:22684640,22679587:Teint_Dans_La_Masse:3726:22679947,22712645:Teint_Dans_La_Masse:3726:22712930,22712993:Teint_Dans_La_Masse:3726:22713389,22712994:Teint_Dans_La_Masse:3726:22713224,22717086:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 4570}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2025-05', 0.11109912758471957),)]} VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4189 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4189 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4189 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4189 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4433 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4433 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4433 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4433 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 12489 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 12499 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12500 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 12492 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 12492 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! WARNING : number of outputs for step 12493 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 12502 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 12502 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 12495 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 12495 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 2 of step 12492 doesn't seem to be define in the database( WARNING : output 1 of step 12489 have datatype=2 whereas input 1 of step 12493 have datatype=7 WARNING : type of output 2 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12494 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12496 doesn't seem to be define in the database( WARNING : type of input 3 of step 12495 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12500 doesn't seem to be define in the database( WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12499 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 12496 have datatype=10 whereas input 3 of step 12498 have datatype=6 WARNING : type of input 5 of step 12498 doesn't seem to be define in the database( WARNING : output 0 of step 12501 have datatype=11 whereas input 5 of step 12498 have datatype=None WARNING : output 0 of step 12496 have datatype=10 whereas input 0 of step 12501 have datatype=18 WARNING : type of input 2 of step 12502 doesn't seem to be define in the database( WARNING : output 1 of step 12494 have datatype=7 whereas input 2 of step 12502 have datatype=None WARNING : type of output 3 of step 12502 doesn't seem to be define in the database( WARNING : type of input 2 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12499 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : type of output 1 of step 12500 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : output 0 of step 12493 have datatype=1 whereas input 0 of step 12494 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier', 'hashtag_weights': {'Carton_brun': 3, 'Carton_gris': 3, 'Teint_Dans_La_Masse': 2, 'autre_refus': 3, 'cartonnette': 2, 'kraft': 3, 'metal': 6, 'plastique': 2}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="Perlen_convoyeur"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4189 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4189 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4189 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4189 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4433 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4433 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4433 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4433 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 12489 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 12499 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12500 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 12492 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 12492 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! WARNING : number of outputs for step 12493 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 12502 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 12502 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 12495 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 12495 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 2 of step 12492 doesn't seem to be define in the database( WARNING : output 1 of step 12489 have datatype=2 whereas input 1 of step 12493 have datatype=7 WARNING : type of output 2 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12494 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12496 doesn't seem to be define in the database( WARNING : type of input 3 of step 12495 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12500 doesn't seem to be define in the database( WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12499 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 12496 have datatype=10 whereas input 3 of step 12498 have datatype=6 WARNING : type of input 5 of step 12498 doesn't seem to be define in the database( WARNING : output 0 of step 12501 have datatype=11 whereas input 5 of step 12498 have datatype=None WARNING : output 0 of step 12496 have datatype=10 whereas input 0 of step 12501 have datatype=18 WARNING : type of input 2 of step 12502 doesn't seem to be define in the database( WARNING : output 1 of step 12494 have datatype=7 whereas input 2 of step 12502 have datatype=None WARNING : type of output 3 of step 12502 doesn't seem to be define in the database( WARNING : type of input 2 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12499 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : type of output 1 of step 12500 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : output 0 of step 12493 have datatype=1 whereas input 0 of step 12494 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier', 'hashtag_weights': {'Carton_brun': 3, 'Carton_gris': 3, 'Teint_Dans_La_Masse': 2, 'autre_refus': 3, 'cartonnette': 2, 'kraft': 3, 'metal': 6, 'plastique': 2}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((4570,),), 'unwanted_material_monthly_percentage': ((0.11109912758471957,),), 'material_repartition': (('JRM', 4201),), 'material_dict': {'JRM': 4201}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.10610611764158913, 515), (datetime.date(2025, 5, 2), 0.0917253050648306, 268), (datetime.date(2025, 5, 5), 0.11049041950651484, 576), (datetime.date(2025, 5, 6), 0.10196982014937608, 515), (datetime.date(2025, 5, 7), 0.0884568680996595, 530), (datetime.date(2025, 5, 8), 0.11283863183046854, 529), (datetime.date(2025, 5, 9), 0.11210230035324012, 306), (datetime.date(2025, 5, 12), 0.13519027299831843, 186), (datetime.date(2025, 5, 13), 0.11230624589943562, 278), (datetime.date(2025, 5, 14), 0.1137553944289977, 225), (datetime.date(2025, 5, 15), 0.17641183948752232, 184), (datetime.date(2025, 5, 16), 0.16812255895905698, 89)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 5, 1), 0.10610611764158913, 515), (datetime.date(2025, 5, 2), 0.0917253050648306, 268), (datetime.date(2025, 5, 5), 0.11049041950651484, 576), (datetime.date(2025, 5, 6), 0.10196982014937608, 515), (datetime.date(2025, 5, 7), 0.0884568680996595, 530), (datetime.date(2025, 5, 8), 0.11283863183046854, 529), (datetime.date(2025, 5, 9), 0.11210230035324012, 306), (datetime.date(2025, 5, 12), 0.13519027299831843, 186), (datetime.date(2025, 5, 13), 0.11230624589943562, 278), (datetime.date(2025, 5, 14), 0.1137553944289977, 225), (datetime.date(2025, 5, 15), 0.17641183948752232, 184), (datetime.date(2025, 5, 16), 0.16812255895905698, 89))}, 'quality_array': [['-0.17207893431992538', '01052025'], ['-0.012526711033691343', '02052025'], ['0.04402754502770893', '05052025'], ['-0.13410122379806966', '06052025'], ['-0.021466665304821615', '07052025'], ['-0.10733567373144835', '08052025'], ['0.14185743674460247', '09052025'], ['-0.19163959805211606', '12052025'], ['0.025740344056238502', '13052025'], ['-0.13116295181502619', '14052025'], ['-0.4313004312095373', '15052025'], ['-0.061160687434141665', '16052025']], 'number_of_batch': ((67,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013823027794378025, 'nb_photo': 325, 'list_port_cont': '22583613,22584649,22584714,22585008,22585100,22585247,22595692,22599905,22607548,22610091,22627800,22668719,22669756,22670178,22678924,22679945,22684565,22684637,22686787,22712923,22713225,22713388,22720528,22758696,22758858,22762206,22762650,22764583,22765497,22767858,22771283,22772578,22772963,22773470,22798320,22799902,22800788,22816659,22825368,22832278,22852250,22853105,22884657,22885585,22893724,22899650,22912799,22924149,22945748,22950934,22951322,22960523,22968373,22987426,22988446,22988740,23010855,23056983,23092500', 'assoc_port': '22582984:22584649,22583527:22584714,22583528:22583613,22584923:22585247,22584924:22585008,22585030:22585100,22595186:22595692,22598633:22607548,22599709:22627800,22599710:22599905,22605005:22610091,22667421:22668719,22668675:22669756,22668677:22670178,22676494:22678924,22676496:22686787,22677962:22684565,22677963:22684637,22679587:22679945,22712645:22712923,22712993:22713388,22712994:22713225,22717086:22720528,22757064:22758696,22757065:22758858,22757078:22764583,22757079:22762206,22760774:22762650,22761800:22767858,22761801:22765497,22769104:22772963,22771034:22771283,22771035:22773470,22772397:22772578,22798151:22798320,22799698:22799902,22800712:22800788,22814936:22816659,22818333:22832278,22822061:22853105,22824972:22825368,22830229:22852250,22875682:22899650,22881703:22885585,22882837:22884657,22885040:22893724,22912347:22912799,22916830:22924149,22918969:22968373,22923181:22945748,22950584:22988740,22950748:22950934,22950920:22951322,22960331:22960523,22963243:22987426,22967391:22988446,23004700:2301085', 'assoc_mat': '22582984:autre_refus:3726:22584649,22583527:autre_refus:3726:22584714,22583528:autre_refus:3726:22583613,22584923:autre_refus:3726:22585247,22584924:autre_refus:3726:22585008,22585030:autre_refus:3726:22585100,22595186:autre_refus:3726:22595692,22598633:autre_refus:3726:22607548,22599709:autre_refus:3726:22627800,22599710:autre_refus:3726:22599905,22605005:autre_refus:3726:22610091,22667421:autre_refus:3726:22668719,22668675:autre_refus:3726:22669756,22668677:autre_refus:3726:22670178,22676494:autre_refus:3726:22678924,22676496:autre_refus:3726:22686787,22677962:autre_refus:3726:22684565,22677963:autre_refus:3726:22684637,22679587:autre_refus:3726:22679945,22712645:autre_refus:3726:22712923,22712993:autre_refus:3726:22713388,22712994:autre_refus:3726:22713225,22717086:autre_refus:3726:22720528,22757064:autre_refus:3726:22758696,22757065:autre_refus:3726:22758858,22757078:autre_refus:3726:22764583,22757079:autre_refus:3726:22762206,22760774:autre_refus:3726:22762650,22761800:autre_refus:3726:22767858,22761801:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01343687579743514, 'nb_photo': 1069, 'list_port_cont': '22583617,22584644,22584718,22585005,22585107,22585249,22595688,22599903,22607552,22610098,22627791,22636555,22668725,22669752,22670181,22678925,22679940,22684561,22684636,22686792,22712926,22713215,22713378,22720525,22758697,22758866,22762205,22764580,22765500,22767855,22771290,22772585,22772965,22773102,22773461,22798323,22799909,22800783,22816657,22825362,22832282,22852257,22853110,22884661,22885584,22893723,22899645,22912797,22924148,22945745,22950927,22951321,22960530,22968370,22987434,22988438,22988741,23056979,23092499', 'assoc_port': '22582984:22584644,22583527:22584718,22583528:22583617,22584923:22585249,22584924:22585005,22585030:22585107,22595185:22636555,22595186:22595688,22598633:22607552,22599709:22627791,22599710:22599903,22605005:22610098,22667421:22668725,22668675:22669752,22668677:22670181,22676494:22678925,22676496:22686792,22677962:22684561,22677963:22684636,22679587:22679940,22712645:22712926,22712993:22713378,22712994:22713215,22717086:22720525,22757064:22758697,22757065:22758866,22757078:22764580,22757079:22762205,22761800:22767855,22761801:22765500,22769104:22772965,22769105:22773102,22771034:22771290,22771035:22773461,22772397:22772585,22798151:22798323,22799698:22799909,22800712:22800783,22814936:22816657,22818333:22832282,22822061:22853110,22824972:22825362,22830229:22852257,22875682:22899645,22881703:22885584,22882837:22884661,22885040:22893723,22912347:22912797,22916830:22924148,22918969:22968370,22923181:22945745,22950584:22988741,22950748:22950927,22950920:22951321,22960331:22960530,22963243:22987434,22967391:2298843', 'assoc_mat': '22582984:cartonnette:3726:22584644,22583527:cartonnette:3726:22584718,22583528:cartonnette:3726:22583617,22584923:cartonnette:3726:22585249,22584924:cartonnette:3726:22585005,22585030:cartonnette:3726:22585107,22595185:cartonnette:3726:22636555,22595186:cartonnette:3726:22595688,22598633:cartonnette:3726:22607552,22599709:cartonnette:3726:22627791,22599710:cartonnette:3726:22599903,22605005:cartonnette:3726:22610098,22667421:cartonnette:3726:22668725,22668675:cartonnette:3726:22669752,22668677:cartonnette:3726:22670181,22676494:cartonnette:3726:22678925,22676496:cartonnette:3726:22686792,22677962:cartonnette:3726:22684561,22677963:cartonnette:3726:22684636,22679587:cartonnette:3726:22679940,22712645:cartonnette:3726:22712926,22712993:cartonnette:3726:22713378,22712994:cartonnette:3726:22713215,22717086:cartonnette:3726:22720525,22757064:cartonnette:3726:22758697,22757065:cartonnette:3726:22758866,22757078:cartonnette:3726:22764580,22757079:cartonnette:3726:22762205,22761800:cartonnette:3726:22767855,22761801:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.058304873854653674, 'nb_photo': 4613, 'list_port_cont': '22583620,22584641,22584724,22585011,22585099,22585251,22595687,22599909,22607542,22610100,22627797,22636559,22668726,22669749,22670180,22678928,22679944,22684558,22684635,22686793,22712927,22713217,22713380,22720526,22758700,22758864,22762202,22762649,22764579,22765494,22767860,22771282,22772583,22772961,22773103,22773465,22798325,22799912,22800780,22816658,22825365,22832285,22852253,22853115,22884658,22885587,22893719,22899648,22912805,22924153,22945738,22950923,22951320,22960519,22968364,22987430,22988445,22988738,23010858,23056974,23092494', 'assoc_port': '22582984:22584641,22583527:22584724,22583528:22583620,22584923:22585251,22584924:22585011,22585030:22585099,22595185:22636559,22595186:22595687,22598633:22607542,22599709:22627797,22599710:22599909,22605005:22610100,22667421:22668726,22668675:22669749,22668677:22670180,22676494:22678928,22676496:22686793,22677962:22684558,22677963:22684635,22679587:22679944,22712645:22712927,22712993:22713380,22712994:22713217,22717086:22720526,22757064:22758700,22757065:22758864,22757078:22764579,22757079:22762202,22760774:22762649,22761800:22767860,22761801:22765494,22769104:22772961,22769105:22773103,22771034:22771282,22771035:22773465,22772397:22772583,22798151:22798325,22799698:22799912,22800712:22800780,22814936:22816658,22818333:22832285,22822061:22853115,22824972:22825365,22830229:22852253,22875682:22899648,22881703:22885587,22882837:22884658,22885040:22893719,22912347:22912805,22916830:22924153,22918969:22968364,22923181:22945738,22950584:22988738,22950748:22950923,22950920:22951320,22960331:22960519,22963243:2298743', 'assoc_mat': '22582984:Carton_brun:3726:22584641,22583527:Carton_brun:3726:22584724,22583528:Carton_brun:3726:22583620,22584923:Carton_brun:3726:22585251,22584924:Carton_brun:3726:22585011,22585030:Carton_brun:3726:22585099,22595185:Carton_brun:3726:22636559,22595186:Carton_brun:3726:22595687,22598633:Carton_brun:3726:22607542,22599709:Carton_brun:3726:22627797,22599710:Carton_brun:3726:22599909,22605005:Carton_brun:3726:22610100,22667421:Carton_brun:3726:22668726,22668675:Carton_brun:3726:22669749,22668677:Carton_brun:3726:22670180,22676494:Carton_brun:3726:22678928,22676496:Carton_brun:3726:22686793,22677962:Carton_brun:3726:22684558,22677963:Carton_brun:3726:22684635,22679587:Carton_brun:3726:22679944,22712645:Carton_brun:3726:22712927,22712993:Carton_brun:3726:22713380,22712994:Carton_brun:3726:22713217,22717086:Carton_brun:3726:22720526,22757064:Carton_brun:3726:22758700,22757065:Carton_brun:3726:22758864,22757078:Carton_brun:3726:22764579,22757079:Carton_brun:3726:22762202,22760774:Carton_brun:3726:22762649,22761800:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005785069070925026, 'nb_photo': 125, 'list_port_cont': '22583624,22585108,22585243,22595697,22599900,22607544,22610102,22627796,22636554,22669748,22679951,22684566,22684638,22712928,22713214,22713379,22720521,22758702,22758863,22762207,22764588,22765495,22767850,22771288,22772579,22772970,22800790,22816656,22825363,22832280,22853108,22884654,22885586,22893728,22899649,22912804,22924152,22945746,22950932,22951331,22960525,22987427,22988435,22988744', 'assoc_port': '22583528:22583624,22584923:22585243,22585030:22585108,22595185:22636554,22595186:22595697,22598633:22607544,22599709:22627796,22599710:22599900,22605005:22610102,22668675:22669748,22677962:22684566,22677963:22684638,22679587:22679951,22712645:22712928,22712993:22713379,22712994:22713214,22717086:22720521,22757064:22758702,22757065:22758863,22757078:22764588,22757079:22762207,22761800:22767850,22761801:22765495,22769104:22772970,22771034:22771288,22772397:22772579,22800712:22800790,22814936:22816656,22818333:22832280,22822061:22853108,22824972:22825363,22875682:22899649,22881703:22885586,22882837:22884654,22885040:22893728,22912347:22912804,22916830:22924152,22923181:22945746,22950584:22988744,22950748:22950932,22950920:22951331,22960331:22960525,22963243:22987427,22967391:22988435', 'assoc_mat': '22583528:Carton_gris:3726:22583624,22584923:Carton_gris:3726:22585243,22585030:Carton_gris:3726:22585108,22595185:Carton_gris:3726:22636554,22595186:Carton_gris:3726:22595697,22598633:Carton_gris:3726:22607544,22599709:Carton_gris:3726:22627796,22599710:Carton_gris:3726:22599900,22605005:Carton_gris:3726:22610102,22668675:Carton_gris:3726:22669748,22677962:Carton_gris:3726:22684566,22677963:Carton_gris:3726:22684638,22679587:Carton_gris:3726:22679951,22712645:Carton_gris:3726:22712928,22712993:Carton_gris:3726:22713379,22712994:Carton_gris:3726:22713214,22717086:Carton_gris:3726:22720521,22757064:Carton_gris:3726:22758702,22757065:Carton_gris:3726:22758863,22757078:Carton_gris:3726:22764588,22757079:Carton_gris:3726:22762207,22761800:Carton_gris:3726:22767850,22761801:Carton_gris:3726:22765495,22769104:Carton_gris:3726:22772970,22771034:Carton_gris:3726:22771288,22772397:Carton_gris:3726:22772579,22800712:Carton_gris:3726:22800790,22814936:Carton_gris:3726:22816656,22818333:Carton_gris:3726:22832280,22822061:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.003445660143613432, 'nb_photo': 61, 'list_port_cont': '22595693,22599904,22610099,22636553,22669757,22679943,22684644,22686786,22712929,22713223,22720522,22758698,22758859,22762200,22764581,22765502,22772966,22825364,22832274,22852259,22853109,22884652,22885582,22893725,22899647,22912800,22945739,22988441,22988739', 'assoc_port': '22595185:22636553,22595186:22595693,22599710:22599904,22605005:22610099,22668675:22669757,22676496:22686786,22677963:22684644,22679587:22679943,22712645:22712929,22712994:22713223,22717086:22720522,22757064:22758698,22757065:22758859,22757078:22764581,22757079:22762200,22761801:22765502,22769104:22772966,22818333:22832274,22822061:22853109,22824972:22825364,22830229:22852259,22875682:22899647,22881703:22885582,22882837:22884652,22885040:22893725,22912347:22912800,22923181:22945739,22950584:22988739,22967391:22988441', 'assoc_mat': '22595185:kraft:3726:22636553,22595186:kraft:3726:22595693,22599710:kraft:3726:22599904,22605005:kraft:3726:22610099,22668675:kraft:3726:22669757,22676496:kraft:3726:22686786,22677963:kraft:3726:22684644,22679587:kraft:3726:22679943,22712645:kraft:3726:22712929,22712994:kraft:3726:22713223,22717086:kraft:3726:22720522,22757064:kraft:3726:22758698,22757065:kraft:3726:22758859,22757078:kraft:3726:22764581,22757079:kraft:3726:22762200,22761801:kraft:3726:22765502,22769104:kraft:3726:22772966,22818333:kraft:3726:22832274,22822061:kraft:3726:22853109,22824972:kraft:3726:22825364,22830229:kraft:3726:22852259,22875682:kraft:3726:22899647,22881703:kraft:3726:22885582,22882837:kraft:3726:22884652,22885040:kraft:3726:22893725,22912347:kraft:3726:22912800,22923181:kraft:3726:22945739,22950584:kraft:3726:22988739,22967391:kraft:3726:22988441'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0009623972505245186, 'nb_photo': 14, 'list_port_cont': '22610095,22684634,22767853,22772584,22773459,22832277,22885583,22899643,22912803,22950931,22968374', 'assoc_port': '22605005:22610095,22677963:22684634,22761800:22767853,22771035:22773459,22772397:22772584,22818333:22832277,22875682:22899643,22881703:22885583,22912347:22912803,22918969:22968374,22950748:22950931', 'assoc_mat': '22605005:metal:3726:22610095,22677963:metal:3726:22684634,22761800:metal:3726:22767853,22771035:metal:3726:22773459,22772397:metal:3726:22772584,22818333:metal:3726:22832277,22875682:metal:3726:22899643,22881703:metal:3726:22885583,22912347:metal:3726:22912803,22918969:metal:3726:22968374,22950748:metal:3726:22950931'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009413774349794228, 'nb_photo': 703, 'list_port_cont': '22583615,22584651,22584722,22585010,22585106,22585242,22595689,22599901,22607547,22610092,22627801,22636560,22668720,22669750,22670176,22678918,22679942,22684564,22684645,22686789,22712933,22713222,22713383,22720527,22758695,22758862,22762210,22764578,22765499,22767857,22771284,22772587,22772971,22773105,22773469,22798326,22799907,22800784,22816665,22825366,22832281,22852262,22853111,22884653,22885590,22893718,22899644,22912806,22924147,22945749,22950933,22951328,22960520,22968367,22987428,22988442,22988737,23010852,23056978,23092495', 'assoc_port': '22582984:22584651,22583527:22584722,22583528:22583615,22584923:22585242,22584924:22585010,22585030:22585106,22595185:22636560,22595186:22595689,22598633:22607547,22599709:22627801,22599710:22599901,22605005:22610092,22667421:22668720,22668675:22669750,22668677:22670176,22676494:22678918,22676496:22686789,22677962:22684564,22677963:22684645,22679587:22679942,22712645:22712933,22712993:22713383,22712994:22713222,22717086:22720527,22757064:22758695,22757065:22758862,22757078:22764578,22757079:22762210,22761800:22767857,22761801:22765499,22769104:22772971,22769105:22773105,22771034:22771284,22771035:22773469,22772397:22772587,22798151:22798326,22799698:22799907,22800712:22800784,22814936:22816665,22818333:22832281,22822061:22853111,22824972:22825366,22830229:22852262,22875682:22899644,22881703:22885590,22882837:22884653,22885040:22893718,22912347:22912806,22916830:22924147,22918969:22968367,22923181:22945749,22950584:22988737,22950748:22950933,22950920:22951328,22960331:22960520,22963243:22987428,22967391:2298844', 'assoc_mat': '22582984:plastique:3726:22584651,22583527:plastique:3726:22584722,22583528:plastique:3726:22583615,22584923:plastique:3726:22585242,22584924:plastique:3726:22585010,22585030:plastique:3726:22585106,22595185:plastique:3726:22636560,22595186:plastique:3726:22595689,22598633:plastique:3726:22607547,22599709:plastique:3726:22627801,22599710:plastique:3726:22599901,22605005:plastique:3726:22610092,22667421:plastique:3726:22668720,22668675:plastique:3726:22669750,22668677:plastique:3726:22670176,22676494:plastique:3726:22678918,22676496:plastique:3726:22686789,22677962:plastique:3726:22684564,22677963:plastique:3726:22684645,22679587:plastique:3726:22679942,22712645:plastique:3726:22712933,22712993:plastique:3726:22713383,22712994:plastique:3726:22713222,22717086:plastique:3726:22720527,22757064:plastique:3726:22758695,22757065:plastique:3726:22758862,22757078:plastique:3726:22764578,22757079:plastique:3726:22762210,22761800:plastique:3726:22767857,22761801:plastique:3726:22765499,22769104:plastique:3726:22772971,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01925182829516749, 'nb_photo': 2467, 'list_port_cont': '22583623,22584647,22584719,22585002,22585103,22585250,22595696,22599911,22607546,22610097,22627798,22636558,22668724,22669754,22670187,22678917,22679947,22684562,22684640,22686785,22712930,22713224,22713389,22720523,22758704,22758861,22762203,22764582,22765504,22767856,22771281,22772588,22772962,22773463,22798327,22799903,22800789,22816662,22825359,22832284,22852261,22853112,22884650,22885581,22893726,22899652,22912801,22924150,22945742,22950926,22951326,22960529,22968369,22987432,22988444,22988742,23010860,23056975,23092496', 'assoc_port': '22582984:22584647,22583527:22584719,22583528:22583623,22584923:22585250,22584924:22585002,22585030:22585103,22595185:22636558,22595186:22595696,22598633:22607546,22599709:22627798,22599710:22599911,22605005:22610097,22667421:22668724,22668675:22669754,22668677:22670187,22676494:22678917,22676496:22686785,22677962:22684562,22677963:22684640,22679587:22679947,22712645:22712930,22712993:22713389,22712994:22713224,22717086:22720523,22757064:22758704,22757065:22758861,22757078:22764582,22757079:22762203,22761800:22767856,22761801:22765504,22769104:22772962,22771034:22771281,22771035:22773463,22772397:22772588,22798151:22798327,22799698:22799903,22800712:22800789,22814936:22816662,22818333:22832284,22822061:22853112,22824972:22825359,22830229:22852261,22875682:22899652,22881703:22885581,22882837:22884650,22885040:22893726,22912347:22912801,22916830:22924150,22918969:22968369,22923181:22945742,22950584:22988742,22950748:22950926,22950920:22951326,22960331:22960529,22963243:22987432,22967391:22988444,23004700:2301086', 'assoc_mat': '22582984:Teint_Dans_La_Masse:3726:22584647,22583527:Teint_Dans_La_Masse:3726:22584719,22583528:Teint_Dans_La_Masse:3726:22583623,22584923:Teint_Dans_La_Masse:3726:22585250,22584924:Teint_Dans_La_Masse:3726:22585002,22585030:Teint_Dans_La_Masse:3726:22585103,22595185:Teint_Dans_La_Masse:3726:22636558,22595186:Teint_Dans_La_Masse:3726:22595696,22598633:Teint_Dans_La_Masse:3726:22607546,22599709:Teint_Dans_La_Masse:3726:22627798,22599710:Teint_Dans_La_Masse:3726:22599911,22605005:Teint_Dans_La_Masse:3726:22610097,22667421:Teint_Dans_La_Masse:3726:22668724,22668675:Teint_Dans_La_Masse:3726:22669754,22668677:Teint_Dans_La_Masse:3726:22670187,22676494:Teint_Dans_La_Masse:3726:22678917,22676496:Teint_Dans_La_Masse:3726:22686785,22677962:Teint_Dans_La_Masse:3726:22684562,22677963:Teint_Dans_La_Masse:3726:22684640,22679587:Teint_Dans_La_Masse:3726:22679947,22712645:Teint_Dans_La_Masse:3726:22712930,22712993:Teint_Dans_La_Masse:3726:22713389,22712994:Teint_Dans_La_Masse:3726:22713224,22717086:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 4570}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2025-05', 0.11109912758471957),)]} filepath : /data_2/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_05_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'JRM': {'autre_refus': ['autre_refus', '1.38%', 325], 'cartonnette': ['cartonnette', '1.34%', 1069], 'Carton_brun': ['Carton_brun', '5.83%', 4613], 'Carton_gris': ['Carton_gris', '0.58%', 125], 'kraft': ['kraft', '0.34%', 61], 'metal': ['metal', '0.1%', 14], 'plastique': ['plastique', '0.94%', 703], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '1.93%', 2467]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_05_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/Perlen_convoyeur 3.08user 2.00system 0:13.01elapsed 39%CPU (0avgtext+0avgdata 192656maxresident)k 33744inputs+312outputs (195major+82862minor)pagefaults 0swaps