python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_merge -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +\%Y-\%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_merge ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-09 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (1, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_merge"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 ! 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! 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 ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier WARNING mismatch dashboard_places_from_datou and dashboard_places are different Fonction SLA_MENSUEL nb_day : (1, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_merge"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 ! 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! 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 ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier WARNING mismatch dashboard_places_from_datou and dashboard_places are different place_id : 234 month : 09 mtr_id : dashboard_places : SCCU_merge date : 2026-09 year : 2026 raspi : 0 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 = 'SCCU_merge' and date like '%2026-09%') and created_at like '%2026-09%'))); nb_day : (1, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 234 and month(ded.date) = 09 and year(ded.date) = 2026 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), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 234 and month(ded.date) = 09 and year(ded.date) = 2026 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 = 234 and mp.name like '%092026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-09-01 : dt_date_just_month_year : 2026-09-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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! 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 ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! 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= "SCCU_merge" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-09-01" AND ded.date <= "2026-09-30" 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 (3010498) 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', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01846320529506142, 'nb_photo': 1267, 'list_port_cont': '31240304,31240340,31240403,31240447,31240498,31240526,31240567,31240616,31240665,31240742,31240777,31240820,31240937,31241265,31241308,31241362,31241808,31241851,31242216,31242261,31242577,31242723,31242880,31243020', 'assoc_port': '31240063:31240304,31240064:31240340,31240065:31240403,31240066:31240567,31240067:31240447,31240068:31240498,31240069:31240526,31240070:31240665,31240071:31240777,31240072:31240616,31240073:31240742,31240074:31240937,31240075:31240820,31240811:31241265,31240812:31241308,31240813:31241362,31241342:31241808,31241343:31241851,31241924:31242261,31241925:31242216,31242256:31243020,31242257:31242577,31242525:31242723,31242566:31242880', 'assoc_mat': '31240063:autre:4230:31240304,31240064:autre:4230:31240340,31240065:autre:4230:31240403,31240066:autre:4230:31240567,31240067:autre:4230:31240447,31240068:autre:4230:31240498,31240069:autre:4230:31240526,31240070:autre:4230:31240665,31240071:autre:4230:31240777,31240072:autre:4230:31240616,31240073:autre:4230:31240742,31240074:autre:4230:31240937,31240075:autre:4230:31240820,31240811:autre:4230:31241265,31240812:autre:4230:31241308,31240813:autre:4230:31241362,31241342:autre:4230:31241808,31241343:autre:4230:31241851,31241924:autre:4230:31242261,31241925:autre:4230:31242216,31242256:autre:4230:31243020,31242257:autre:4230:31242577,31242525:autre:4230:31242723,31242566:autre:4230:31242880'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.057628344583609846, 'nb_photo': 7195, 'list_port_cont': '31240313,31240353,31240398,31240454,31240499,31240533,31240574,31240614,31240657,31240737,31240785,31240834,31240945,31241272,31241321,31241352,31241805,31241846,31242231,31242268,31242586,31242715,31242881,31243016', 'assoc_port': '31240063:31240313,31240064:31240353,31240065:31240398,31240066:31240574,31240067:31240454,31240068:31240499,31240069:31240533,31240070:31240657,31240071:31240785,31240072:31240614,31240073:31240737,31240074:31240945,31240075:31240834,31240811:31241272,31240812:31241321,31240813:31241352,31241342:31241805,31241343:31241846,31241924:31242268,31241925:31242231,31242256:31243016,31242257:31242586,31242525:31242715,31242566:31242881', 'assoc_mat': '31240063:carton:4230:31240313,31240064:carton:4230:31240353,31240065:carton:4230:31240398,31240066:carton:4230:31240574,31240067:carton:4230:31240454,31240068:carton:4230:31240499,31240069:carton:4230:31240533,31240070:carton:4230:31240657,31240071:carton:4230:31240785,31240072:carton:4230:31240614,31240073:carton:4230:31240737,31240074:carton:4230:31240945,31240075:carton:4230:31240834,31240811:carton:4230:31241272,31240812:carton:4230:31241321,31240813:carton:4230:31241352,31241342:carton:4230:31241805,31241343:carton:4230:31241846,31241924:carton:4230:31242268,31241925:carton:4230:31242231,31242256:carton:4230:31243016,31242257:carton:4230:31242586,31242525:carton:4230:31242715,31242566:carton:4230:31242881'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010899545800943154, 'nb_photo': 133, 'list_port_cont': '31240305,31240341,31240401,31240441,31240497,31240530,31240573,31240652,31240734,31240772,31240829,31240947,31241271,31241316,31241358,31241801,31241841,31242228,31242262,31242572,31242719,31242884,31243026', 'assoc_port': '31240063:31240305,31240064:31240341,31240065:31240401,31240066:31240573,31240067:31240441,31240068:31240497,31240069:31240530,31240070:31240652,31240071:31240772,31240073:31240734,31240074:31240947,31240075:31240829,31240811:31241271,31240812:31241316,31240813:31241358,31241342:31241801,31241343:31241841,31241924:31242262,31241925:31242228,31242256:31243026,31242257:31242572,31242525:31242719,31242566:31242884', 'assoc_mat': '31240063:metal:4230:31240305,31240064:metal:4230:31240341,31240065:metal:4230:31240401,31240066:metal:4230:31240573,31240067:metal:4230:31240441,31240068:metal:4230:31240497,31240069:metal:4230:31240530,31240070:metal:4230:31240652,31240071:metal:4230:31240772,31240073:metal:4230:31240734,31240074:metal:4230:31240947,31240075:metal:4230:31240829,31240811:metal:4230:31241271,31240812:metal:4230:31241316,31240813:metal:4230:31241358,31241342:metal:4230:31241801,31241343:metal:4230:31241841,31241924:metal:4230:31242262,31241925:metal:4230:31242228,31242256:metal:4230:31243026,31242257:metal:4230:31242572,31242525:metal:4230:31242719,31242566:metal:4230:31242884'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24433801917277248, 'nb_photo': 29755, 'list_port_cont': '31240307,31240354,31240404,31240448,31240494,31240528,31240582,31240619,31240668,31240731,31240780,31240835,31240949,31241269,31241318,31241363,31241803,31241855,31242230,31242275,31242584,31242720,31242883,31243024', 'assoc_port': '31240063:31240307,31240064:31240354,31240065:31240404,31240066:31240582,31240067:31240448,31240068:31240494,31240069:31240528,31240070:31240668,31240071:31240780,31240072:31240619,31240073:31240731,31240074:31240949,31240075:31240835,31240811:31241269,31240812:31241318,31240813:31241363,31241342:31241803,31241343:31241855,31241924:31242275,31241925:31242230,31242256:31243024,31242257:31242584,31242525:31242720,31242566:31242883', 'assoc_mat': '31240063:papier:4230:31240307,31240064:papier:4230:31240354,31240065:papier:4230:31240404,31240066:papier:4230:31240582,31240067:papier:4230:31240448,31240068:papier:4230:31240494,31240069:papier:4230:31240528,31240070:papier:4230:31240668,31240071:papier:4230:31240780,31240072:papier:4230:31240619,31240073:papier:4230:31240731,31240074:papier:4230:31240949,31240075:papier:4230:31240835,31240811:papier:4230:31241269,31240812:papier:4230:31241318,31240813:papier:4230:31241363,31241342:papier:4230:31241803,31241343:papier:4230:31241855,31241924:papier:4230:31242275,31241925:papier:4230:31242230,31242256:papier:4230:31243024,31242257:papier:4230:31242584,31242525:papier:4230:31242720,31242566:papier:4230:31242883'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027688616326449916, 'nb_photo': 221, 'list_port_cont': '31240314,31240345,31240408,31240453,31240488,31240535,31240576,31240618,31240662,31240741,31240783,31240831,31240943,31241268,31241317,31241354,31241798,31241849,31242227,31242272,31242585,31242716,31242886,31243025', 'assoc_port': '31240063:31240314,31240064:31240345,31240065:31240408,31240066:31240576,31240067:31240453,31240068:31240488,31240069:31240535,31240070:31240662,31240071:31240783,31240072:31240618,31240073:31240741,31240074:31240943,31240075:31240831,31240811:31241268,31240812:31241317,31240813:31241354,31241342:31241798,31241343:31241849,31241924:31242272,31241925:31242227,31242256:31243025,31242257:31242585,31242525:31242716,31242566:31242886', 'assoc_mat': '31240063:pehd:4230:31240314,31240064:pehd:4230:31240345,31240065:pehd:4230:31240408,31240066:pehd:4230:31240576,31240067:pehd:4230:31240453,31240068:pehd:4230:31240488,31240069:pehd:4230:31240535,31240070:pehd:4230:31240662,31240071:pehd:4230:31240783,31240072:pehd:4230:31240618,31240073:pehd:4230:31240741,31240074:pehd:4230:31240943,31240075:pehd:4230:31240831,31240811:pehd:4230:31241268,31240812:pehd:4230:31241317,31240813:pehd:4230:31241354,31241342:pehd:4230:31241798,31241343:pehd:4230:31241849,31241924:pehd:4230:31242272,31241925:pehd:4230:31242227,31242256:pehd:4230:31243025,31242257:pehd:4230:31242585,31242525:pehd:4230:31242716,31242566:pehd:4230:31242886'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020382837207027223, 'nb_photo': 1898, 'list_port_cont': '31240316,31240346,31240414,31240449,31240492,31240527,31240583,31240611,31240659,31240735,31240786,31240827,31240948,31241270,31241323,31241366,31241800,31241842,31242232,31242276,31242583,31242726,31242885,31243022', 'assoc_port': '31240063:31240316,31240064:31240346,31240065:31240414,31240066:31240583,31240067:31240449,31240068:31240492,31240069:31240527,31240070:31240659,31240071:31240786,31240072:31240611,31240073:31240735,31240074:31240948,31240075:31240827,31240811:31241270,31240812:31241323,31240813:31241366,31241342:31241800,31241343:31241842,31241924:31242276,31241925:31242232,31242256:31243022,31242257:31242583,31242525:31242726,31242566:31242885', 'assoc_mat': '31240063:pet_clair:4230:31240316,31240064:pet_clair:4230:31240346,31240065:pet_clair:4230:31240414,31240066:pet_clair:4230:31240583,31240067:pet_clair:4230:31240449,31240068:pet_clair:4230:31240492,31240069:pet_clair:4230:31240527,31240070:pet_clair:4230:31240659,31240071:pet_clair:4230:31240786,31240072:pet_clair:4230:31240611,31240073:pet_clair:4230:31240735,31240074:pet_clair:4230:31240948,31240075:pet_clair:4230:31240827,31240811:pet_clair:4230:31241270,31240812:pet_clair:4230:31241323,31240813:pet_clair:4230:31241366,31241342:pet_clair:4230:31241800,31241343:pet_clair:4230:31241842,31241924:pet_clair:4230:31242276,31241925:pet_clair:4230:31242232,31242256:pet_clair:4230:31243022,31242257:pet_clair:4230:31242583,31242525:pet_clair:4230:31242726,31242566:pet_clair:4230:31242885'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002996113085482889, 'nb_photo': 86, 'list_port_cont': '31240312,31240343,31240405,31240489,31240532,31240579,31240617,31240661,31240743,31240788,31240833,31240950,31241267,31241320,31241364,31241802,31242223,31242273,31242587,31242718,31242891,31243017', 'assoc_port': '31240063:31240312,31240064:31240343,31240065:31240405,31240066:31240579,31240068:31240489,31240069:31240532,31240070:31240661,31240071:31240788,31240072:31240617,31240073:31240743,31240074:31240950,31240075:31240833,31240811:31241267,31240812:31241320,31240813:31241364,31241342:31241802,31241924:31242273,31241925:31242223,31242256:31243017,31242257:31242587,31242525:31242718,31242566:31242891', 'assoc_mat': '31240063:pet_fonce:4230:31240312,31240064:pet_fonce:4230:31240343,31240065:pet_fonce:4230:31240405,31240066:pet_fonce:4230:31240579,31240068:pet_fonce:4230:31240489,31240069:pet_fonce:4230:31240532,31240070:pet_fonce:4230:31240661,31240071:pet_fonce:4230:31240788,31240072:pet_fonce:4230:31240617,31240073:pet_fonce:4230:31240743,31240074:pet_fonce:4230:31240950,31240075:pet_fonce:4230:31240833,31240811:pet_fonce:4230:31241267,31240812:pet_fonce:4230:31241320,31240813:pet_fonce:4230:31241364,31241342:pet_fonce:4230:31241802,31241924:pet_fonce:4230:31242273,31241925:pet_fonce:4230:31242223,31242256:pet_fonce:4230:31243017,31242257:pet_fonce:4230:31242587,31242525:pet_fonce:4230:31242718,31242566:pet_fonce:4230:31242891'}) 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(3010498)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31249399, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31240304,31240340,31240403,31240447,31240498,31240526,31240567,31240616,31240665,31240742,31240777,31240820,31240937,31241265,31241308,31241362,31241808,31241851,31242216,31242261,31242577,31242723,31242880,31243020 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31249400, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31240313,31240353,31240398,31240454,31240499,31240533,31240574,31240614,31240657,31240737,31240785,31240834,31240945,31241272,31241321,31241352,31241805,31241846,31242231,31242268,31242586,31242715,31242881,31243016 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31249401, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31240305,31240341,31240401,31240441,31240497,31240530,31240573,31240652,31240734,31240772,31240829,31240947,31241271,31241316,31241358,31241801,31241841,31242228,31242262,31242572,31242719,31242884,31243026 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31249402, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31240307,31240354,31240404,31240448,31240494,31240528,31240582,31240619,31240668,31240731,31240780,31240835,31240949,31241269,31241318,31241363,31241803,31241855,31242230,31242275,31242584,31242720,31242883,31243024 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31249403, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31240314,31240345,31240408,31240453,31240488,31240535,31240576,31240618,31240662,31240741,31240783,31240831,31240943,31241268,31241317,31241354,31241798,31241849,31242227,31242272,31242585,31242716,31242886,31243025 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31249404, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31240316,31240346,31240414,31240449,31240492,31240527,31240583,31240611,31240659,31240735,31240786,31240827,31240948,31241270,31241323,31241366,31241800,31241842,31242232,31242276,31242583,31242726,31242885,31243022 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31249405, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31240312,31240343,31240405,31240489,31240532,31240579,31240617,31240661,31240743,31240788,31240833,31240950,31241267,31241320,31241364,31241802,31242223,31242273,31242587,31242718,31242891,31243017 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31249399,31249400,31249401,31249402,31249403,31249404,31249405?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=234 and date >='2026-09-01' and date <= '2026-09-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((111,),), 'unwanted_material_monthly_percentage': ((0.6733106589126548,),), 'material_repartition': (('incineration', 111),), 'material_dict': {'incineration': 111}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 30), 0.6733106589126548, 4),), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 30), 0.6733106589126548, 4),)}, 'quality_array': [['-7.922462788404748', '30092026']], 'number_of_batch': ((24,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01846320529506142, 'nb_photo': 1267, 'list_port_cont': '31240304,31240340,31240403,31240447,31240498,31240526,31240567,31240616,31240665,31240742,31240777,31240820,31240937,31241265,31241308,31241362,31241808,31241851,31242216,31242261,31242577,31242723,31242880,31243020', 'assoc_port': '31240063:31240304,31240064:31240340,31240065:31240403,31240066:31240567,31240067:31240447,31240068:31240498,31240069:31240526,31240070:31240665,31240071:31240777,31240072:31240616,31240073:31240742,31240074:31240937,31240075:31240820,31240811:31241265,31240812:31241308,31240813:31241362,31241342:31241808,31241343:31241851,31241924:31242261,31241925:31242216,31242256:31243020,31242257:31242577,31242525:31242723,31242566:31242880', 'assoc_mat': '31240063:autre:4230:31240304,31240064:autre:4230:31240340,31240065:autre:4230:31240403,31240066:autre:4230:31240567,31240067:autre:4230:31240447,31240068:autre:4230:31240498,31240069:autre:4230:31240526,31240070:autre:4230:31240665,31240071:autre:4230:31240777,31240072:autre:4230:31240616,31240073:autre:4230:31240742,31240074:autre:4230:31240937,31240075:autre:4230:31240820,31240811:autre:4230:31241265,31240812:autre:4230:31241308,31240813:autre:4230:31241362,31241342:autre:4230:31241808,31241343:autre:4230:31241851,31241924:autre:4230:31242261,31241925:autre:4230:31242216,31242256:autre:4230:31243020,31242257:autre:4230:31242577,31242525:autre:4230:31242723,31242566:autre:4230:31242880'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.057628344583609846, 'nb_photo': 7195, 'list_port_cont': '31240313,31240353,31240398,31240454,31240499,31240533,31240574,31240614,31240657,31240737,31240785,31240834,31240945,31241272,31241321,31241352,31241805,31241846,31242231,31242268,31242586,31242715,31242881,31243016', 'assoc_port': '31240063:31240313,31240064:31240353,31240065:31240398,31240066:31240574,31240067:31240454,31240068:31240499,31240069:31240533,31240070:31240657,31240071:31240785,31240072:31240614,31240073:31240737,31240074:31240945,31240075:31240834,31240811:31241272,31240812:31241321,31240813:31241352,31241342:31241805,31241343:31241846,31241924:31242268,31241925:31242231,31242256:31243016,31242257:31242586,31242525:31242715,31242566:31242881', 'assoc_mat': '31240063:carton:4230:31240313,31240064:carton:4230:31240353,31240065:carton:4230:31240398,31240066:carton:4230:31240574,31240067:carton:4230:31240454,31240068:carton:4230:31240499,31240069:carton:4230:31240533,31240070:carton:4230:31240657,31240071:carton:4230:31240785,31240072:carton:4230:31240614,31240073:carton:4230:31240737,31240074:carton:4230:31240945,31240075:carton:4230:31240834,31240811:carton:4230:31241272,31240812:carton:4230:31241321,31240813:carton:4230:31241352,31241342:carton:4230:31241805,31241343:carton:4230:31241846,31241924:carton:4230:31242268,31241925:carton:4230:31242231,31242256:carton:4230:31243016,31242257:carton:4230:31242586,31242525:carton:4230:31242715,31242566:carton:4230:31242881'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010899545800943154, 'nb_photo': 133, 'list_port_cont': '31240305,31240341,31240401,31240441,31240497,31240530,31240573,31240652,31240734,31240772,31240829,31240947,31241271,31241316,31241358,31241801,31241841,31242228,31242262,31242572,31242719,31242884,31243026', 'assoc_port': '31240063:31240305,31240064:31240341,31240065:31240401,31240066:31240573,31240067:31240441,31240068:31240497,31240069:31240530,31240070:31240652,31240071:31240772,31240073:31240734,31240074:31240947,31240075:31240829,31240811:31241271,31240812:31241316,31240813:31241358,31241342:31241801,31241343:31241841,31241924:31242262,31241925:31242228,31242256:31243026,31242257:31242572,31242525:31242719,31242566:31242884', 'assoc_mat': '31240063:metal:4230:31240305,31240064:metal:4230:31240341,31240065:metal:4230:31240401,31240066:metal:4230:31240573,31240067:metal:4230:31240441,31240068:metal:4230:31240497,31240069:metal:4230:31240530,31240070:metal:4230:31240652,31240071:metal:4230:31240772,31240073:metal:4230:31240734,31240074:metal:4230:31240947,31240075:metal:4230:31240829,31240811:metal:4230:31241271,31240812:metal:4230:31241316,31240813:metal:4230:31241358,31241342:metal:4230:31241801,31241343:metal:4230:31241841,31241924:metal:4230:31242262,31241925:metal:4230:31242228,31242256:metal:4230:31243026,31242257:metal:4230:31242572,31242525:metal:4230:31242719,31242566:metal:4230:31242884'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24433801917277248, 'nb_photo': 29755, 'list_port_cont': '31240307,31240354,31240404,31240448,31240494,31240528,31240582,31240619,31240668,31240731,31240780,31240835,31240949,31241269,31241318,31241363,31241803,31241855,31242230,31242275,31242584,31242720,31242883,31243024', 'assoc_port': '31240063:31240307,31240064:31240354,31240065:31240404,31240066:31240582,31240067:31240448,31240068:31240494,31240069:31240528,31240070:31240668,31240071:31240780,31240072:31240619,31240073:31240731,31240074:31240949,31240075:31240835,31240811:31241269,31240812:31241318,31240813:31241363,31241342:31241803,31241343:31241855,31241924:31242275,31241925:31242230,31242256:31243024,31242257:31242584,31242525:31242720,31242566:31242883', 'assoc_mat': '31240063:papier:4230:31240307,31240064:papier:4230:31240354,31240065:papier:4230:31240404,31240066:papier:4230:31240582,31240067:papier:4230:31240448,31240068:papier:4230:31240494,31240069:papier:4230:31240528,31240070:papier:4230:31240668,31240071:papier:4230:31240780,31240072:papier:4230:31240619,31240073:papier:4230:31240731,31240074:papier:4230:31240949,31240075:papier:4230:31240835,31240811:papier:4230:31241269,31240812:papier:4230:31241318,31240813:papier:4230:31241363,31241342:papier:4230:31241803,31241343:papier:4230:31241855,31241924:papier:4230:31242275,31241925:papier:4230:31242230,31242256:papier:4230:31243024,31242257:papier:4230:31242584,31242525:papier:4230:31242720,31242566:papier:4230:31242883'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027688616326449916, 'nb_photo': 221, 'list_port_cont': '31240314,31240345,31240408,31240453,31240488,31240535,31240576,31240618,31240662,31240741,31240783,31240831,31240943,31241268,31241317,31241354,31241798,31241849,31242227,31242272,31242585,31242716,31242886,31243025', 'assoc_port': '31240063:31240314,31240064:31240345,31240065:31240408,31240066:31240576,31240067:31240453,31240068:31240488,31240069:31240535,31240070:31240662,31240071:31240783,31240072:31240618,31240073:31240741,31240074:31240943,31240075:31240831,31240811:31241268,31240812:31241317,31240813:31241354,31241342:31241798,31241343:31241849,31241924:31242272,31241925:31242227,31242256:31243025,31242257:31242585,31242525:31242716,31242566:31242886', 'assoc_mat': '31240063:pehd:4230:31240314,31240064:pehd:4230:31240345,31240065:pehd:4230:31240408,31240066:pehd:4230:31240576,31240067:pehd:4230:31240453,31240068:pehd:4230:31240488,31240069:pehd:4230:31240535,31240070:pehd:4230:31240662,31240071:pehd:4230:31240783,31240072:pehd:4230:31240618,31240073:pehd:4230:31240741,31240074:pehd:4230:31240943,31240075:pehd:4230:31240831,31240811:pehd:4230:31241268,31240812:pehd:4230:31241317,31240813:pehd:4230:31241354,31241342:pehd:4230:31241798,31241343:pehd:4230:31241849,31241924:pehd:4230:31242272,31241925:pehd:4230:31242227,31242256:pehd:4230:31243025,31242257:pehd:4230:31242585,31242525:pehd:4230:31242716,31242566:pehd:4230:31242886'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020382837207027223, 'nb_photo': 1898, 'list_port_cont': '31240316,31240346,31240414,31240449,31240492,31240527,31240583,31240611,31240659,31240735,31240786,31240827,31240948,31241270,31241323,31241366,31241800,31241842,31242232,31242276,31242583,31242726,31242885,31243022', 'assoc_port': '31240063:31240316,31240064:31240346,31240065:31240414,31240066:31240583,31240067:31240449,31240068:31240492,31240069:31240527,31240070:31240659,31240071:31240786,31240072:31240611,31240073:31240735,31240074:31240948,31240075:31240827,31240811:31241270,31240812:31241323,31240813:31241366,31241342:31241800,31241343:31241842,31241924:31242276,31241925:31242232,31242256:31243022,31242257:31242583,31242525:31242726,31242566:31242885', 'assoc_mat': '31240063:pet_clair:4230:31240316,31240064:pet_clair:4230:31240346,31240065:pet_clair:4230:31240414,31240066:pet_clair:4230:31240583,31240067:pet_clair:4230:31240449,31240068:pet_clair:4230:31240492,31240069:pet_clair:4230:31240527,31240070:pet_clair:4230:31240659,31240071:pet_clair:4230:31240786,31240072:pet_clair:4230:31240611,31240073:pet_clair:4230:31240735,31240074:pet_clair:4230:31240948,31240075:pet_clair:4230:31240827,31240811:pet_clair:4230:31241270,31240812:pet_clair:4230:31241323,31240813:pet_clair:4230:31241366,31241342:pet_clair:4230:31241800,31241343:pet_clair:4230:31241842,31241924:pet_clair:4230:31242276,31241925:pet_clair:4230:31242232,31242256:pet_clair:4230:31243022,31242257:pet_clair:4230:31242583,31242525:pet_clair:4230:31242726,31242566:pet_clair:4230:31242885'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002996113085482889, 'nb_photo': 86, 'list_port_cont': '31240312,31240343,31240405,31240489,31240532,31240579,31240617,31240661,31240743,31240788,31240833,31240950,31241267,31241320,31241364,31241802,31242223,31242273,31242587,31242718,31242891,31243017', 'assoc_port': '31240063:31240312,31240064:31240343,31240065:31240405,31240066:31240579,31240068:31240489,31240069:31240532,31240070:31240661,31240071:31240788,31240072:31240617,31240073:31240743,31240074:31240950,31240075:31240833,31240811:31241267,31240812:31241320,31240813:31241364,31241342:31241802,31241924:31242273,31241925:31242223,31242256:31243017,31242257:31242587,31242525:31242718,31242566:31242891', 'assoc_mat': '31240063:pet_fonce:4230:31240312,31240064:pet_fonce:4230:31240343,31240065:pet_fonce:4230:31240405,31240066:pet_fonce:4230:31240579,31240068:pet_fonce:4230:31240489,31240069:pet_fonce:4230:31240532,31240070:pet_fonce:4230:31240661,31240071:pet_fonce:4230:31240788,31240072:pet_fonce:4230:31240617,31240073:pet_fonce:4230:31240743,31240074:pet_fonce:4230:31240950,31240075:pet_fonce:4230:31240833,31240811:pet_fonce:4230:31241267,31240812:pet_fonce:4230:31241320,31240813:pet_fonce:4230:31241364,31241342:pet_fonce:4230:31241802,31241924:pet_fonce:4230:31242273,31241925:pet_fonce:4230:31242223,31242256:pet_fonce:4230:31243017,31242257:pet_fonce:4230:31242587,31242525:pet_fonce:4230:31242718,31242566:pet_fonce:4230:31242891'}), 'main_stat': {'nb_photos': 111}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31249399,31249400,31249401,31249402,31249403,31249404,31249405?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.6733106589126548),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_merge"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 ! 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! 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 ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier WARNING mismatch dashboard_places_from_datou and dashboard_places are different {'number_of_analysed_photos': ((111,),), 'unwanted_material_monthly_percentage': ((0.6733106589126548,),), 'material_repartition': (('incineration', 111),), 'material_dict': {'incineration': 111}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 30), 0.6733106589126548, 4),), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 30), 0.6733106589126548, 4),)}, 'quality_array': [['-7.922462788404748', '30092026']], 'number_of_batch': ((24,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01846320529506142, 'nb_photo': 1267, 'list_port_cont': '31240304,31240340,31240403,31240447,31240498,31240526,31240567,31240616,31240665,31240742,31240777,31240820,31240937,31241265,31241308,31241362,31241808,31241851,31242216,31242261,31242577,31242723,31242880,31243020', 'assoc_port': '31240063:31240304,31240064:31240340,31240065:31240403,31240066:31240567,31240067:31240447,31240068:31240498,31240069:31240526,31240070:31240665,31240071:31240777,31240072:31240616,31240073:31240742,31240074:31240937,31240075:31240820,31240811:31241265,31240812:31241308,31240813:31241362,31241342:31241808,31241343:31241851,31241924:31242261,31241925:31242216,31242256:31243020,31242257:31242577,31242525:31242723,31242566:31242880', 'assoc_mat': '31240063:autre:4230:31240304,31240064:autre:4230:31240340,31240065:autre:4230:31240403,31240066:autre:4230:31240567,31240067:autre:4230:31240447,31240068:autre:4230:31240498,31240069:autre:4230:31240526,31240070:autre:4230:31240665,31240071:autre:4230:31240777,31240072:autre:4230:31240616,31240073:autre:4230:31240742,31240074:autre:4230:31240937,31240075:autre:4230:31240820,31240811:autre:4230:31241265,31240812:autre:4230:31241308,31240813:autre:4230:31241362,31241342:autre:4230:31241808,31241343:autre:4230:31241851,31241924:autre:4230:31242261,31241925:autre:4230:31242216,31242256:autre:4230:31243020,31242257:autre:4230:31242577,31242525:autre:4230:31242723,31242566:autre:4230:31242880'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.057628344583609846, 'nb_photo': 7195, 'list_port_cont': '31240313,31240353,31240398,31240454,31240499,31240533,31240574,31240614,31240657,31240737,31240785,31240834,31240945,31241272,31241321,31241352,31241805,31241846,31242231,31242268,31242586,31242715,31242881,31243016', 'assoc_port': '31240063:31240313,31240064:31240353,31240065:31240398,31240066:31240574,31240067:31240454,31240068:31240499,31240069:31240533,31240070:31240657,31240071:31240785,31240072:31240614,31240073:31240737,31240074:31240945,31240075:31240834,31240811:31241272,31240812:31241321,31240813:31241352,31241342:31241805,31241343:31241846,31241924:31242268,31241925:31242231,31242256:31243016,31242257:31242586,31242525:31242715,31242566:31242881', 'assoc_mat': '31240063:carton:4230:31240313,31240064:carton:4230:31240353,31240065:carton:4230:31240398,31240066:carton:4230:31240574,31240067:carton:4230:31240454,31240068:carton:4230:31240499,31240069:carton:4230:31240533,31240070:carton:4230:31240657,31240071:carton:4230:31240785,31240072:carton:4230:31240614,31240073:carton:4230:31240737,31240074:carton:4230:31240945,31240075:carton:4230:31240834,31240811:carton:4230:31241272,31240812:carton:4230:31241321,31240813:carton:4230:31241352,31241342:carton:4230:31241805,31241343:carton:4230:31241846,31241924:carton:4230:31242268,31241925:carton:4230:31242231,31242256:carton:4230:31243016,31242257:carton:4230:31242586,31242525:carton:4230:31242715,31242566:carton:4230:31242881'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010899545800943154, 'nb_photo': 133, 'list_port_cont': '31240305,31240341,31240401,31240441,31240497,31240530,31240573,31240652,31240734,31240772,31240829,31240947,31241271,31241316,31241358,31241801,31241841,31242228,31242262,31242572,31242719,31242884,31243026', 'assoc_port': '31240063:31240305,31240064:31240341,31240065:31240401,31240066:31240573,31240067:31240441,31240068:31240497,31240069:31240530,31240070:31240652,31240071:31240772,31240073:31240734,31240074:31240947,31240075:31240829,31240811:31241271,31240812:31241316,31240813:31241358,31241342:31241801,31241343:31241841,31241924:31242262,31241925:31242228,31242256:31243026,31242257:31242572,31242525:31242719,31242566:31242884', 'assoc_mat': '31240063:metal:4230:31240305,31240064:metal:4230:31240341,31240065:metal:4230:31240401,31240066:metal:4230:31240573,31240067:metal:4230:31240441,31240068:metal:4230:31240497,31240069:metal:4230:31240530,31240070:metal:4230:31240652,31240071:metal:4230:31240772,31240073:metal:4230:31240734,31240074:metal:4230:31240947,31240075:metal:4230:31240829,31240811:metal:4230:31241271,31240812:metal:4230:31241316,31240813:metal:4230:31241358,31241342:metal:4230:31241801,31241343:metal:4230:31241841,31241924:metal:4230:31242262,31241925:metal:4230:31242228,31242256:metal:4230:31243026,31242257:metal:4230:31242572,31242525:metal:4230:31242719,31242566:metal:4230:31242884'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24433801917277248, 'nb_photo': 29755, 'list_port_cont': '31240307,31240354,31240404,31240448,31240494,31240528,31240582,31240619,31240668,31240731,31240780,31240835,31240949,31241269,31241318,31241363,31241803,31241855,31242230,31242275,31242584,31242720,31242883,31243024', 'assoc_port': '31240063:31240307,31240064:31240354,31240065:31240404,31240066:31240582,31240067:31240448,31240068:31240494,31240069:31240528,31240070:31240668,31240071:31240780,31240072:31240619,31240073:31240731,31240074:31240949,31240075:31240835,31240811:31241269,31240812:31241318,31240813:31241363,31241342:31241803,31241343:31241855,31241924:31242275,31241925:31242230,31242256:31243024,31242257:31242584,31242525:31242720,31242566:31242883', 'assoc_mat': '31240063:papier:4230:31240307,31240064:papier:4230:31240354,31240065:papier:4230:31240404,31240066:papier:4230:31240582,31240067:papier:4230:31240448,31240068:papier:4230:31240494,31240069:papier:4230:31240528,31240070:papier:4230:31240668,31240071:papier:4230:31240780,31240072:papier:4230:31240619,31240073:papier:4230:31240731,31240074:papier:4230:31240949,31240075:papier:4230:31240835,31240811:papier:4230:31241269,31240812:papier:4230:31241318,31240813:papier:4230:31241363,31241342:papier:4230:31241803,31241343:papier:4230:31241855,31241924:papier:4230:31242275,31241925:papier:4230:31242230,31242256:papier:4230:31243024,31242257:papier:4230:31242584,31242525:papier:4230:31242720,31242566:papier:4230:31242883'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027688616326449916, 'nb_photo': 221, 'list_port_cont': '31240314,31240345,31240408,31240453,31240488,31240535,31240576,31240618,31240662,31240741,31240783,31240831,31240943,31241268,31241317,31241354,31241798,31241849,31242227,31242272,31242585,31242716,31242886,31243025', 'assoc_port': '31240063:31240314,31240064:31240345,31240065:31240408,31240066:31240576,31240067:31240453,31240068:31240488,31240069:31240535,31240070:31240662,31240071:31240783,31240072:31240618,31240073:31240741,31240074:31240943,31240075:31240831,31240811:31241268,31240812:31241317,31240813:31241354,31241342:31241798,31241343:31241849,31241924:31242272,31241925:31242227,31242256:31243025,31242257:31242585,31242525:31242716,31242566:31242886', 'assoc_mat': '31240063:pehd:4230:31240314,31240064:pehd:4230:31240345,31240065:pehd:4230:31240408,31240066:pehd:4230:31240576,31240067:pehd:4230:31240453,31240068:pehd:4230:31240488,31240069:pehd:4230:31240535,31240070:pehd:4230:31240662,31240071:pehd:4230:31240783,31240072:pehd:4230:31240618,31240073:pehd:4230:31240741,31240074:pehd:4230:31240943,31240075:pehd:4230:31240831,31240811:pehd:4230:31241268,31240812:pehd:4230:31241317,31240813:pehd:4230:31241354,31241342:pehd:4230:31241798,31241343:pehd:4230:31241849,31241924:pehd:4230:31242272,31241925:pehd:4230:31242227,31242256:pehd:4230:31243025,31242257:pehd:4230:31242585,31242525:pehd:4230:31242716,31242566:pehd:4230:31242886'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020382837207027223, 'nb_photo': 1898, 'list_port_cont': '31240316,31240346,31240414,31240449,31240492,31240527,31240583,31240611,31240659,31240735,31240786,31240827,31240948,31241270,31241323,31241366,31241800,31241842,31242232,31242276,31242583,31242726,31242885,31243022', 'assoc_port': '31240063:31240316,31240064:31240346,31240065:31240414,31240066:31240583,31240067:31240449,31240068:31240492,31240069:31240527,31240070:31240659,31240071:31240786,31240072:31240611,31240073:31240735,31240074:31240948,31240075:31240827,31240811:31241270,31240812:31241323,31240813:31241366,31241342:31241800,31241343:31241842,31241924:31242276,31241925:31242232,31242256:31243022,31242257:31242583,31242525:31242726,31242566:31242885', 'assoc_mat': '31240063:pet_clair:4230:31240316,31240064:pet_clair:4230:31240346,31240065:pet_clair:4230:31240414,31240066:pet_clair:4230:31240583,31240067:pet_clair:4230:31240449,31240068:pet_clair:4230:31240492,31240069:pet_clair:4230:31240527,31240070:pet_clair:4230:31240659,31240071:pet_clair:4230:31240786,31240072:pet_clair:4230:31240611,31240073:pet_clair:4230:31240735,31240074:pet_clair:4230:31240948,31240075:pet_clair:4230:31240827,31240811:pet_clair:4230:31241270,31240812:pet_clair:4230:31241323,31240813:pet_clair:4230:31241366,31241342:pet_clair:4230:31241800,31241343:pet_clair:4230:31241842,31241924:pet_clair:4230:31242276,31241925:pet_clair:4230:31242232,31242256:pet_clair:4230:31243022,31242257:pet_clair:4230:31242583,31242525:pet_clair:4230:31242726,31242566:pet_clair:4230:31242885'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002996113085482889, 'nb_photo': 86, 'list_port_cont': '31240312,31240343,31240405,31240489,31240532,31240579,31240617,31240661,31240743,31240788,31240833,31240950,31241267,31241320,31241364,31241802,31242223,31242273,31242587,31242718,31242891,31243017', 'assoc_port': '31240063:31240312,31240064:31240343,31240065:31240405,31240066:31240579,31240068:31240489,31240069:31240532,31240070:31240661,31240071:31240788,31240072:31240617,31240073:31240743,31240074:31240950,31240075:31240833,31240811:31241267,31240812:31241320,31240813:31241364,31241342:31241802,31241924:31242273,31241925:31242223,31242256:31243017,31242257:31242587,31242525:31242718,31242566:31242891', 'assoc_mat': '31240063:pet_fonce:4230:31240312,31240064:pet_fonce:4230:31240343,31240065:pet_fonce:4230:31240405,31240066:pet_fonce:4230:31240579,31240068:pet_fonce:4230:31240489,31240069:pet_fonce:4230:31240532,31240070:pet_fonce:4230:31240661,31240071:pet_fonce:4230:31240788,31240072:pet_fonce:4230:31240617,31240073:pet_fonce:4230:31240743,31240074:pet_fonce:4230:31240950,31240075:pet_fonce:4230:31240833,31240811:pet_fonce:4230:31241267,31240812:pet_fonce:4230:31241320,31240813:pet_fonce:4230:31241364,31241342:pet_fonce:4230:31241802,31241924:pet_fonce:4230:31242273,31241925:pet_fonce:4230:31242223,31242256:pet_fonce:4230:31243017,31242257:pet_fonce:4230:31242587,31242525:pet_fonce:4230:31242718,31242566:pet_fonce:4230:31242891'}), 'main_stat': {'nb_photos': 111}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31249399,31249400,31249401,31249402,31249403,31249404,31249405?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.6733106589126548),)]} filepath : /data_4/data_log/job/memo/SCCU_merge/sla_mensuel_SCCU_merge_mois_09_annee_2026.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 {'incineration': {'autre': ['autre', '1.85%', 1267], 'carton': ['carton', '5.76%', 7195], 'metal': ['metal', '0.11%', 133], 'papier': ['papier', '24.43%', 29755], 'pehd': ['pehd', '0.28%', 221], 'pet_clair': ['pet_clair', '2.04%', 1898], 'pet_fonce': ['pet_fonce', '0.3%', 86]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_merge/sla_mensuel_SCCU_merge_mois_09_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_merge 2.47user 2.96system 0:04.84elapsed 112%CPU (0avgtext+0avgdata 191184maxresident)k 4024inputs+192outputs (38major+52509minor)pagefaults 0swaps