python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --job=sla_mensuel --raspi=20095 --dashboard_places=Perlen_convoyeur --rootfolder_sla=/data_4/data_log/job/memo/Perlen_convoyeur -v --mtr_id=1053 --date=`date -d"$nowdate 15 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : 20095, Date : 2025-06 _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 : (6, 30) 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 ! 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 Fonction SLA_MENSUEL nb_day : (6, 30) 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 ! 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 place_id : 134 month : 06 mtr_id : 1053 dashboard_places : Perlen_convoyeur date : 2025-06 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-06%') and created_at like '%2025-06%'))); nb_day : (6, 30) after unwanted_material_data nb_day : (6, 30) 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/06%'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 ! We will need to call the sla_per_day for these missing days : 2025-06-02 00:00:00,2025-06-03 00:00:00,2025-06-04 00:00:00,2025-06-05 00:00:00,2025-06-06 00:00:00,2025-06-09 00:00:00,2025-06-10 00:00:00,2025-06-11 00:00:00,2025-06-12 00:00:00,2025-06-13 00:00:00,2025-06-16 00:00:00,2025-06-17 00:00:00,2025-06-18 00:00:00,2025-06-19 00:00:00,2025-06-20 00:00:00,2025-06-23 00:00:00,2025-06-24 00:00:00,2025-06-25 00:00:00,2025-06-26 00:00:00,2025-06-27 00:00:00,2025-06-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) = 06 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) = 06 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 '%062025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-06-01 : dt_date_just_month_year : 2025-06-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 ! 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-06-01" AND ded.date <= "2025-06-30" 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 (1874630,1878084,1882339,1901058,1930546,1947402,1947390,1952825,1952852,1952841,1959613,1959598,1959578,1927243,1930341,1930524,1941208,1946847) 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.012247428172804865, 'nb_photo': 598, 'list_port_cont': '23545830,23547202,23573176,23574687,23574866,23575178,23582042,23582324,23584247,23589348,23591591,23592595,23595698,23602644,23602874,23674971,23698449,23730844,23731847,23731905,23737983,23744410,23744827,23748198,23748491,23748571,23813040,23849287,23934981,24038480,24167011,24175423,24191306,24210387,24232295,24232607,24259237,24259734,24261024,24269724,24271501,24273069,24298411,24298519,24298789,24309734,24309931,24310528,24338959,24339366,24339465,24340975,24341003,24389391,24420597,24433670,24434012,24436581,24449735,24452295,24491411,24491451,24491483,24491503,24491526,24491555,24491631,24491651,24491678,24505534,24510526,24541333,24541389,24541961,24542191,24542702,24543184,24543842,24544062,24544448,24544821,24545205,24545358,24545676,24545782,24553027,24577389,24577953,24578379,24610058,24610501,24610811,24611116,24611682,24612145,24612332,24612648,24615322,24616451,24624717,24625048,24632443', 'assoc_port': '23536623:23591591,23537859:23573176,23537860:23584247,23545582:23574687,23545583:23545830,23546914:23574866,23546917:23547202,23548810:23575178,23581987:23582042,23582159:23582324,23582160:23592595,23586389:23595698,23587638:23602644,23587640:23602874,23589204:23589348,23674635:23674971,23674636:23698449,23707529:23730844,23708171:23731847,23708188:23731905,23708519:23737983,23740008:23748198,23740009:23748491,23740010:23748571,23740011:23744827,23740012:23744410,23812872:23813040,23848986:23849287,23934175:24038480,23934529:23934981,24048013:24167011,24057973:24175423,24089862:24191306,24099617:24210387,24123785:24269724,24132642:24232295,24134842:24232607,24160460:24273069,24206279:24261024,24234490:24271501,24258451:24259734,24258949:24259237,24293759:24389391,24293760:24309734,24293763:24309931,24293764:24310528,24296609:24338959,24296616:24339366,24296618:24339465,24297931:24340975,24297932:24341003,24297948:24298519,24297952:24298411,24298468:24298789,24417729:24420597,24427488:24433670,24427507:2443401', 'assoc_mat': '23536623:autre_refus:3726:23591591,23537859:autre_refus:3726:23573176,23537860:autre_refus:3726:23584247,23545582:autre_refus:3726:23574687,23545583:autre_refus:3726:23545830,23546914:autre_refus:3726:23574866,23546917:autre_refus:3726:23547202,23548810:autre_refus:3726:23575178,23581987:autre_refus:3726:23582042,23582159:autre_refus:3726:23582324,23582160:autre_refus:3726:23592595,23586389:autre_refus:3726:23595698,23587638:autre_refus:3726:23602644,23587640:autre_refus:3726:23602874,23589204:autre_refus:3726:23589348,23674635:autre_refus:3726:23674971,23674636:autre_refus:3726:23698449,23707529:autre_refus:3726:23730844,23708171:autre_refus:3726:23731847,23708188:autre_refus:3726:23731905,23708519:autre_refus:3726:23737983,23740008:autre_refus:3726:23748198,23740009:autre_refus:3726:23748491,23740010:autre_refus:3726:23748571,23740011:autre_refus:3726:23744827,23740012:autre_refus:3726:23744410,23812872:autre_refus:3726:23813040,23848986:autre_refus:3726:23849287,23934175:autre_refus:3726:24038480,23934529:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01543467342213529, 'nb_photo': 2205, 'list_port_cont': '23545827,23547200,23573181,23574685,23574861,23575183,23582037,23582323,23584243,23589357,23591594,23592589,23595694,23595943,23602652,23602873,23674977,23696656,23698447,23730852,23731845,23731906,23737981,23744408,23744825,23748208,23748488,23748564,23813039,23849280,23934984,24038482,24167009,24175427,24191295,24210379,24232296,24232601,24259240,24259735,24260855,24261023,24269729,24271499,24273066,24298414,24298527,24298781,24309729,24309926,24310526,24338955,24339361,24339463,24340972,24341005,24389399,24420590,24433673,24434009,24436574,24449736,24452297,24491408,24491457,24491482,24491498,24491523,24491552,24491626,24491650,24491681,24505544,24510523,24541322,24541390,24541952,24542201,24542708,24543186,24543838,24544060,24544439,24544824,24545197,24545367,24545667,24545781,24553030,24577387,24577951,24578351,24578383,24610066,24610499,24610815,24611114,24611687,24612142,24612328,24612639,24615320,24616452,24624711,24625059,24632440', 'assoc_port': '23536623:23591594,23537859:23573181,23537860:23584243,23545582:23574685,23545583:23545827,23546914:23574861,23546917:23547200,23548810:23575183,23581987:23582037,23582159:23582323,23582160:23592589,23586389:23595694,23586392:23595943,23587638:23602652,23587640:23602873,23589204:23589357,23673266:23696656,23674635:23674977,23674636:23698447,23707529:23730852,23708171:23731845,23708188:23731906,23708519:23737981,23740008:23748208,23740009:23748488,23740010:23748564,23740011:23744825,23740012:23744408,23812872:23813039,23848986:23849280,23934175:24038482,23934529:23934984,24048013:24167009,24057973:24175427,24089862:24191295,24099617:24210379,24123785:24269729,24132642:24232296,24134842:24232601,24160460:24273066,24206279:24261023,24234490:24271499,24258451:24259735,24258949:24259240,24259897:24260855,24293759:24389399,24293760:24309729,24293763:24309926,24293764:24310526,24296609:24338955,24296616:24339361,24296618:24339463,24297931:24340972,24297932:24341005,24297948:24298527,24297952:24298414,24298468:2429878', 'assoc_mat': '23536623:cartonnette:3726:23591594,23537859:cartonnette:3726:23573181,23537860:cartonnette:3726:23584243,23545582:cartonnette:3726:23574685,23545583:cartonnette:3726:23545827,23546914:cartonnette:3726:23574861,23546917:cartonnette:3726:23547200,23548810:cartonnette:3726:23575183,23581987:cartonnette:3726:23582037,23582159:cartonnette:3726:23582323,23582160:cartonnette:3726:23592589,23586389:cartonnette:3726:23595694,23586392:cartonnette:3726:23595943,23587638:cartonnette:3726:23602652,23587640:cartonnette:3726:23602873,23589204:cartonnette:3726:23589357,23673266:cartonnette:3726:23696656,23674635:cartonnette:3726:23674977,23674636:cartonnette:3726:23698447,23707529:cartonnette:3726:23730852,23708171:cartonnette:3726:23731845,23708188:cartonnette:3726:23731906,23708519:cartonnette:3726:23737981,23740008:cartonnette:3726:23748208,23740009:cartonnette:3726:23748488,23740010:cartonnette:3726:23748564,23740011:cartonnette:3726:23744825,23740012:cartonnette:3726:23744408,23812872:cartonnette:3726:23813039,23848986:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.06774612787116356, 'nb_photo': 10693, 'list_port_cont': '23545831,23547198,23573186,23574676,23574858,23575182,23582047,23582317,23584239,23589347,23591581,23592594,23595702,23595944,23602655,23602871,23674970,23696664,23698453,23730842,23731850,23731895,23737982,23744405,23744831,23748205,23748485,23748565,23813046,23849278,23934980,24038485,24167020,24175432,24191297,24210383,24232292,24232602,24259244,24259740,24260853,24261026,24269721,24271493,24273063,24298409,24298525,24298796,24309739,24309927,24310525,24338958,24339355,24339468,24340974,24341008,24389394,24420588,24433665,24434006,24436578,24449738,24452293,24491409,24491452,24491472,24491504,24491530,24491550,24491622,24491656,24491677,24505542,24510521,24541327,24541392,24541959,24542195,24542703,24543187,24543835,24544066,24544447,24544818,24545198,24545368,24545679,24545775,24553029,24577388,24577954,24578360,24578384,24610064,24610498,24610812,24611111,24611690,24612146,24612333,24612650,24615316,24616461,24624714,24625053,24632450', 'assoc_port': '23536623:23591581,23537859:23573186,23537860:23584239,23545582:23574676,23545583:23545831,23546914:23574858,23546917:23547198,23548810:23575182,23581987:23582047,23582159:23582317,23582160:23592594,23586389:23595702,23586392:23595944,23587638:23602655,23587640:23602871,23589204:23589347,23673266:23696664,23674635:23674970,23674636:23698453,23707529:23730842,23708171:23731850,23708188:23731895,23708519:23737982,23740008:23748205,23740009:23748485,23740010:23748565,23740011:23744831,23740012:23744405,23812872:23813046,23848986:23849278,23934175:24038485,23934529:23934980,24048013:24167020,24057973:24175432,24089862:24191297,24099617:24210383,24123785:24269721,24132642:24232292,24134842:24232602,24160460:24273063,24206279:24261026,24234490:24271493,24258451:24259740,24258949:24259244,24259897:24260853,24293759:24389394,24293760:24309739,24293763:24309927,24293764:24310525,24296609:24338958,24296616:24339355,24296618:24339468,24297931:24340974,24297932:24341008,24297948:24298525,24297952:24298409,24298468:2429879', 'assoc_mat': '23536623:Carton_brun:3726:23591581,23537859:Carton_brun:3726:23573186,23537860:Carton_brun:3726:23584239,23545582:Carton_brun:3726:23574676,23545583:Carton_brun:3726:23545831,23546914:Carton_brun:3726:23574858,23546917:Carton_brun:3726:23547198,23548810:Carton_brun:3726:23575182,23581987:Carton_brun:3726:23582047,23582159:Carton_brun:3726:23582317,23582160:Carton_brun:3726:23592594,23586389:Carton_brun:3726:23595702,23586392:Carton_brun:3726:23595944,23587638:Carton_brun:3726:23602655,23587640:Carton_brun:3726:23602871,23589204:Carton_brun:3726:23589347,23673266:Carton_brun:3726:23696664,23674635:Carton_brun:3726:23674970,23674636:Carton_brun:3726:23698453,23707529:Carton_brun:3726:23730842,23708171:Carton_brun:3726:23731850,23708188:Carton_brun:3726:23731895,23708519:Carton_brun:3726:23737982,23740008:Carton_brun:3726:23748205,23740009:Carton_brun:3726:23748485,23740010:Carton_brun:3726:23748565,23740011:Carton_brun:3726:23744831,23740012:Carton_brun:3726:23744405,23812872:Carton_brun:3726:23813046,23848986:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005269957693145747, 'nb_photo': 311, 'list_port_cont': '23545821,23547195,23573180,23574678,23574860,23575177,23582038,23582322,23584242,23589349,23592593,23595699,23602646,23602868,23674968,23696665,23698451,23731856,23731898,23744412,23744833,23748206,23748566,23849283,23934975,24038483,24167019,24175421,24210382,24232298,24232598,24259241,24259732,24261027,24271497,24273070,24298408,24298516,24298785,24309733,24309924,24310520,24339359,24339467,24340969,24340998,24389400,24433669,24434001,24436572,24449744,24452298,24491405,24491448,24491475,24491525,24491623,24491646,24505536,24510524,24541332,24541386,24541950,24542198,24542701,24543193,24544065,24544820,24545204,24545359,24545681,24545778,24553020,24577385,24577960,24578361,24578378,24610062,24610504,24610806,24611117,24612325,24612644,24615327,24616458,24624719,24625052,24632447', 'assoc_port': '23537859:23573180,23537860:23584242,23545582:23574678,23545583:23545821,23546914:23574860,23546917:23547195,23548810:23575177,23581987:23582038,23582159:23582322,23582160:23592593,23586389:23595699,23587638:23602646,23587640:23602868,23589204:23589349,23673266:23696665,23674635:23674968,23674636:23698451,23708171:23731856,23708188:23731898,23740008:23748206,23740010:23748566,23740011:23744833,23740012:23744412,23848986:23849283,23934175:24038483,23934529:23934975,24048013:24167019,24057973:24175421,24099617:24210382,24132642:24232298,24134842:24232598,24160460:24273070,24206279:24261027,24234490:24271497,24258451:24259732,24258949:24259241,24293759:24389400,24293760:24309733,24293763:24309924,24293764:24310520,24296616:24339359,24296618:24339467,24297931:24340969,24297932:24340998,24297948:24298516,24297952:24298408,24298468:24298785,24427488:24433669,24427507:24434001,24427560:24510524,24430292:24436572,24434159:24449744,24452070:24452298,24453777:24491623,24453779:24491646,24453783:24491525,24453786:2449144', 'assoc_mat': '23537859:Carton_gris:3726:23573180,23537860:Carton_gris:3726:23584242,23545582:Carton_gris:3726:23574678,23545583:Carton_gris:3726:23545821,23546914:Carton_gris:3726:23574860,23546917:Carton_gris:3726:23547195,23548810:Carton_gris:3726:23575177,23581987:Carton_gris:3726:23582038,23582159:Carton_gris:3726:23582322,23582160:Carton_gris:3726:23592593,23586389:Carton_gris:3726:23595699,23587638:Carton_gris:3726:23602646,23587640:Carton_gris:3726:23602868,23589204:Carton_gris:3726:23589349,23673266:Carton_gris:3726:23696665,23674635:Carton_gris:3726:23674968,23674636:Carton_gris:3726:23698451,23708171:Carton_gris:3726:23731856,23708188:Carton_gris:3726:23731898,23740008:Carton_gris:3726:23748206,23740010:Carton_gris:3726:23748566,23740011:Carton_gris:3726:23744833,23740012:Carton_gris:3726:23744412,23848986:Carton_gris:3726:23849283,23934175:Carton_gris:3726:24038483,23934529:Carton_gris:3726:23934975,24048013:Carton_gris:3726:24167019,24057973:Carton_gris:3726:24175421,24099617:Carton_gris:3726:24210382,24132642:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0035761438605576876, 'nb_photo': 192, 'list_port_cont': '23545824,23547196,23573178,23574681,23574867,23582046,23582315,23584248,23589353,23592599,23595693,23595941,23602649,23602867,23696660,23698448,23730850,23731897,23737984,23744406,23744832,23748202,23748484,23748567,23849288,24038481,24167016,24175422,24232291,24232606,24269730,24271498,24273071,24298520,24309735,24309930,24310522,24338951,24339363,24339458,24341007,24420587,24433666,24434005,24436575,24449740,24452299,24491407,24491459,24491481,24491531,24491632,24491657,24491680,24505540,24542710,24543833,24544070,24544441,24544827,24545200,24545360,24545672,24545783,24553023,24577391,24577952,24578358,24578376,24610807,24611112,24612153,24612640,24615326,24616454,24624712,24625051,24632448', 'assoc_port': '23537859:23573178,23537860:23584248,23545582:23574681,23545583:23545824,23546914:23574867,23546917:23547196,23581987:23582046,23582159:23582315,23582160:23592599,23586389:23595693,23586392:23595941,23587638:23602649,23587640:23602867,23589204:23589353,23673266:23696660,23674636:23698448,23707529:23730850,23708188:23731897,23708519:23737984,23740008:23748202,23740009:23748484,23740010:23748567,23740011:23744832,23740012:23744406,23848986:23849288,23934175:24038481,24048013:24167016,24057973:24175422,24123785:24269730,24132642:24232291,24134842:24232606,24160460:24273071,24234490:24271498,24293760:24309735,24293763:24309930,24293764:24310522,24296609:24338951,24296616:24339363,24296618:24339458,24297932:24341007,24297948:24298520,24417729:24420587,24427488:24433666,24427507:24434005,24430292:24436575,24434159:24449740,24452070:24452299,24453777:24491632,24453779:24491657,24453783:24491531,24453786:24491459,24453789:24491481,24453791:24491680,24453847:24491407,24505106:24578358,24505109:24578376,24505238:2457739', 'assoc_mat': '23537859:kraft:3726:23573178,23537860:kraft:3726:23584248,23545582:kraft:3726:23574681,23545583:kraft:3726:23545824,23546914:kraft:3726:23574867,23546917:kraft:3726:23547196,23581987:kraft:3726:23582046,23582159:kraft:3726:23582315,23582160:kraft:3726:23592599,23586389:kraft:3726:23595693,23586392:kraft:3726:23595941,23587638:kraft:3726:23602649,23587640:kraft:3726:23602867,23589204:kraft:3726:23589353,23673266:kraft:3726:23696660,23674636:kraft:3726:23698448,23707529:kraft:3726:23730850,23708188:kraft:3726:23731897,23708519:kraft:3726:23737984,23740008:kraft:3726:23748202,23740009:kraft:3726:23748484,23740010:kraft:3726:23748567,23740011:kraft:3726:23744832,23740012:kraft:3726:23744406,23848986:kraft:3726:23849288,23934175:kraft:3726:24038481,24048013:kraft:3726:24167016,24057973:kraft:3726:24175422,24123785:kraft:3726:24269730,24132642:kraft:3726:24232291,24134842:kraft:3726:24232606,24160460:kraft:3726:24273071,24234490:kraft:3726:24271498,24293760:kraft:3726:24309735,24293763:kraft:3726:24309930,24293764:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0011831639144853807, 'nb_photo': 21, 'list_port_cont': '23545826,23731902,23737985,23748561,23849285,24259741,24261025,24298415,24298798,24389402,24542196,24544061,24544822,24553025,24577957,24610813', 'assoc_port': '23545583:23545826,23708188:23731902,23708519:23737985,23740010:23748561,23848986:23849285,24206279:24261025,24258451:24259741,24293759:24389402,24297952:24298415,24298468:24298798,24505111:24542196,24505242:24544061,24505244:24553025,24505366:24577957,24505374:24544822,24593565:24610813', 'assoc_mat': '23545583:metal:3726:23545826,23708188:metal:3726:23731902,23708519:metal:3726:23737985,23740010:metal:3726:23748561,23848986:metal:3726:23849285,24206279:metal:3726:24261025,24258451:metal:3726:24259741,24293759:metal:3726:24389402,24297952:metal:3726:24298415,24298468:metal:3726:24298798,24505111:metal:3726:24542196,24505242:metal:3726:24544061,24505244:metal:3726:24553025,24505366:metal:3726:24577957,24505374:metal:3726:24544822,24593565:metal:3726:24610813'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009650803438459225, 'nb_photo': 1406, 'list_port_cont': '23545820,23547192,23573184,23574686,23574864,23575179,23582045,23582320,23584240,23589355,23591588,23592596,23595696,23595945,23602651,23602864,23674976,23696663,23698443,23730847,23731853,23731899,23737990,23744413,23744828,23748199,23748487,23748569,23813047,23849286,23934985,24038487,24167014,24175430,24191296,24210386,24232290,24232603,24259245,24259737,24260858,24261028,24269722,24271494,24273068,24298413,24298514,24298783,24309738,24309935,24310529,24338957,24339365,24339466,24340976,24341001,24389395,24420595,24433672,24434000,24436571,24449737,24452304,24491404,24491455,24491476,24491502,24491522,24491547,24491625,24491649,24491674,24505541,24510527,24541329,24541388,24541953,24542200,24542706,24543182,24543841,24544064,24544445,24544817,24545196,24545363,24545673,24545773,24553026,24577384,24577958,24578353,24578387,24610059,24610500,24610816,24611113,24611689,24612147,24612335,24612643,24615323,24616457,24624709,24625056,24632446', 'assoc_port': '23536623:23591588,23537859:23573184,23537860:23584240,23545582:23574686,23545583:23545820,23546914:23574864,23546917:23547192,23548810:23575179,23581987:23582045,23582159:23582320,23582160:23592596,23586389:23595696,23586392:23595945,23587638:23602651,23587640:23602864,23589204:23589355,23673266:23696663,23674635:23674976,23674636:23698443,23707529:23730847,23708171:23731853,23708188:23731899,23708519:23737990,23740008:23748199,23740009:23748487,23740010:23748569,23740011:23744828,23740012:23744413,23812872:23813047,23848986:23849286,23934175:24038487,23934529:23934985,24048013:24167014,24057973:24175430,24089862:24191296,24099617:24210386,24123785:24269722,24132642:24232290,24134842:24232603,24160460:24273068,24206279:24261028,24234490:24271494,24258451:24259737,24258949:24259245,24259897:24260858,24293759:24389395,24293760:24309738,24293763:24309935,24293764:24310529,24296609:24338957,24296616:24339365,24296618:24339466,24297931:24340976,24297932:24341001,24297948:24298514,24297952:24298413,24298468:2429878', 'assoc_mat': '23536623:plastique:3726:23591588,23537859:plastique:3726:23573184,23537860:plastique:3726:23584240,23545582:plastique:3726:23574686,23545583:plastique:3726:23545820,23546914:plastique:3726:23574864,23546917:plastique:3726:23547192,23548810:plastique:3726:23575179,23581987:plastique:3726:23582045,23582159:plastique:3726:23582320,23582160:plastique:3726:23592596,23586389:plastique:3726:23595696,23586392:plastique:3726:23595945,23587638:plastique:3726:23602651,23587640:plastique:3726:23602864,23589204:plastique:3726:23589355,23673266:plastique:3726:23696663,23674635:plastique:3726:23674976,23674636:plastique:3726:23698443,23707529:plastique:3726:23730847,23708171:plastique:3726:23731853,23708188:plastique:3726:23731899,23708519:plastique:3726:23737990,23740008:plastique:3726:23748199,23740009:plastique:3726:23748487,23740010:plastique:3726:23748569,23740011:plastique:3726:23744828,23740012:plastique:3726:23744413,23812872:plastique:3726:23813047,23848986:plastique:3726:23849286,23934175:plastique:3726:24038487,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01975335961692814, 'nb_photo': 5287, 'list_port_cont': '23545828,23547197,23573177,23574683,23574865,23575176,23582040,23582316,23584246,23589350,23591585,23592598,23595701,23595942,23602653,23602869,23674973,23696662,23698445,23730848,23731854,23731901,23737988,23744403,23744829,23748201,23748489,23748560,23813050,23849284,23934978,24038488,24167013,24175428,24191303,24210378,24232301,24232604,24236502,24259239,24259730,24260854,24261029,24269726,24271496,24273064,24298404,24298517,24298791,24309731,24309933,24310527,24338960,24339360,24339464,24340968,24341004,24389390,24420589,24433667,24434017,24436580,24449734,24452294,24491403,24491456,24491474,24491507,24491521,24491551,24491628,24491654,24491672,24505539,24510522,24541328,24541397,24541960,24542194,24542711,24543183,24543844,24544067,24544442,24544826,24545203,24545361,24545671,24545784,24553019,24577386,24577955,24578359,24578380,24610056,24610497,24610805,24611115,24611688,24612148,24612326,24612646,24615321,24616455,24624716,24625057,24632444', 'assoc_port': '23536623:23591585,23537859:23573177,23537860:23584246,23545582:23574683,23545583:23545828,23546914:23574865,23546917:23547197,23548810:23575176,23581987:23582040,23582159:23582316,23582160:23592598,23586389:23595701,23586392:23595942,23587638:23602653,23587640:23602869,23589204:23589350,23673266:23696662,23674635:23674973,23674636:23698445,23707529:23730848,23708171:23731854,23708188:23731901,23708519:23737988,23740008:23748201,23740009:23748489,23740010:23748560,23740011:23744829,23740012:23744403,23812872:23813050,23848986:23849284,23934175:24038488,23934529:23934978,24048013:24167013,24057973:24175428,24089862:24191303,24099617:24210378,24123785:24269726,24132642:24232301,24134842:24232604,24160460:24273064,24167716:24236502,24206279:24261029,24234490:24271496,24258451:24259730,24258949:24259239,24259897:24260854,24293759:24389390,24293760:24309731,24293763:24309933,24293764:24310527,24296609:24338960,24296616:24339360,24296618:24339464,24297931:24340968,24297932:24341004,24297948:24298517,24297952:2429840', 'assoc_mat': '23536623:Teint_Dans_La_Masse:3726:23591585,23537859:Teint_Dans_La_Masse:3726:23573177,23537860:Teint_Dans_La_Masse:3726:23584246,23545582:Teint_Dans_La_Masse:3726:23574683,23545583:Teint_Dans_La_Masse:3726:23545828,23546914:Teint_Dans_La_Masse:3726:23574865,23546917:Teint_Dans_La_Masse:3726:23547197,23548810:Teint_Dans_La_Masse:3726:23575176,23581987:Teint_Dans_La_Masse:3726:23582040,23582159:Teint_Dans_La_Masse:3726:23582316,23582160:Teint_Dans_La_Masse:3726:23592598,23586389:Teint_Dans_La_Masse:3726:23595701,23586392:Teint_Dans_La_Masse:3726:23595942,23587638:Teint_Dans_La_Masse:3726:23602653,23587640:Teint_Dans_La_Masse:3726:23602869,23589204:Teint_Dans_La_Masse:3726:23589350,23673266:Teint_Dans_La_Masse:3726:23696662,23674635:Teint_Dans_La_Masse:3726:23674973,23674636:Teint_Dans_La_Masse:3726:23698445,23707529:Teint_Dans_La_Masse:3726:23730848,23708171:Teint_Dans_La_Masse:3726:23731854,23708188:Teint_Dans_La_Masse:3726:23731901,23708519:Teint_Dans_La_Masse:3726:23737988,23740008: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(1874630,1878084,1882339,1901058,1930546,1947402,1947390,1952825,1952852,1952841,1959613,1959598,1959578,1927243,1930341,1930524,1941208,1946847)); 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-06-01' and date <= '2025-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((7809,),), 'unwanted_material_monthly_percentage': ((0.12367236403719307,),), 'material_repartition': (('JRM', 3261),), 'material_dict': {'JRM': 3261}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 2), 0.13231014718934425, 520), (datetime.date(2025, 6, 3), 0.14967003680071786, 542), (datetime.date(2025, 6, 5), 0.11953419333008454, 544), (datetime.date(2025, 6, 6), 0.11899838238784874, 298), (datetime.date(2025, 6, 10), 0.11353106247399555, 669), (datetime.date(2025, 6, 11), 0.12298648519873823, 640), (datetime.date(2025, 6, 12), 0.1146780972029024, 723), (datetime.date(2025, 6, 13), 0.12258881257060208, 306), (datetime.date(2025, 6, 16), 0.10421189017595531, 619), (datetime.date(2025, 6, 17), 0.14068105321958926, 634), (datetime.date(2025, 6, 18), 0.11552783374688068, 590), (datetime.date(2025, 6, 19), 0.13009630930994687, 542), (datetime.date(2025, 6, 20), 0.10627272254292765, 222), (datetime.date(2025, 6, 23), 0.1342112796729472, 155), (datetime.date(2025, 6, 24), 0.12430631145328166, 258), (datetime.date(2025, 6, 25), 0.13391292739800428, 258), (datetime.date(2025, 6, 27), 0.12455169223594413, 17), (datetime.date(2025, 6, 30), 0.13570763393612642, 272)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 6, 2), 0.13231014718934425, 520), (datetime.date(2025, 6, 3), 0.14967003680071786, 542), (datetime.date(2025, 6, 5), 0.11953419333008454, 544), (datetime.date(2025, 6, 6), 0.11899838238784874, 298), (datetime.date(2025, 6, 10), 0.11353106247399555, 669), (datetime.date(2025, 6, 11), 0.12298648519873823, 640), (datetime.date(2025, 6, 12), 0.1146780972029024, 723), (datetime.date(2025, 6, 13), 0.12258881257060208, 306), (datetime.date(2025, 6, 16), 0.10421189017595531, 619), (datetime.date(2025, 6, 17), 0.14068105321958926, 634), (datetime.date(2025, 6, 18), 0.11552783374688068, 590), (datetime.date(2025, 6, 19), 0.13009630930994687, 542), (datetime.date(2025, 6, 20), 0.10627272254292765, 222), (datetime.date(2025, 6, 23), 0.1342112796729472, 155), (datetime.date(2025, 6, 24), 0.12430631145328166, 258), (datetime.date(2025, 6, 25), 0.13391292739800428, 258), (datetime.date(2025, 6, 27), 0.12455169223594413, 17), (datetime.date(2025, 6, 30), 0.13570763393612642, 272))}, 'quality_array': [['-0.29450224427712784', '02062025'], ['-0.03609146561571846', '03062025'], ['-0.09867621622217751', '05062025'], ['-0.20442755882771213', '06062025'], ['-0.2033616771393547', '10062025'], ['-0.07383410013056581', '11062025'], ['-0.26262949917898', '12062025'], ['-0.39976066065298194', '13062025'], ['-0.3447706681429767', '16062025'], ['-0.3123801679128725', '17062025'], ['-0.02615728228916765', '18062025'], ['-0.065130033231122', '19062025'], ['-0.06647919603152895', '20062025'], ['0.7437384084700723', '23062025'], ['-0.0014128920077251471', '24062025'], ['0.10856361752272176', '25062025'], ['-0.2806602513337429', '27062025'], ['-0.15025045563611916', '30062025']], 'number_of_batch': ((107,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.012247428172804865, 'nb_photo': 598, 'list_port_cont': '23545830,23547202,23573176,23574687,23574866,23575178,23582042,23582324,23584247,23589348,23591591,23592595,23595698,23602644,23602874,23674971,23698449,23730844,23731847,23731905,23737983,23744410,23744827,23748198,23748491,23748571,23813040,23849287,23934981,24038480,24167011,24175423,24191306,24210387,24232295,24232607,24259237,24259734,24261024,24269724,24271501,24273069,24298411,24298519,24298789,24309734,24309931,24310528,24338959,24339366,24339465,24340975,24341003,24389391,24420597,24433670,24434012,24436581,24449735,24452295,24491411,24491451,24491483,24491503,24491526,24491555,24491631,24491651,24491678,24505534,24510526,24541333,24541389,24541961,24542191,24542702,24543184,24543842,24544062,24544448,24544821,24545205,24545358,24545676,24545782,24553027,24577389,24577953,24578379,24610058,24610501,24610811,24611116,24611682,24612145,24612332,24612648,24615322,24616451,24624717,24625048,24632443', 'assoc_port': '23536623:23591591,23537859:23573176,23537860:23584247,23545582:23574687,23545583:23545830,23546914:23574866,23546917:23547202,23548810:23575178,23581987:23582042,23582159:23582324,23582160:23592595,23586389:23595698,23587638:23602644,23587640:23602874,23589204:23589348,23674635:23674971,23674636:23698449,23707529:23730844,23708171:23731847,23708188:23731905,23708519:23737983,23740008:23748198,23740009:23748491,23740010:23748571,23740011:23744827,23740012:23744410,23812872:23813040,23848986:23849287,23934175:24038480,23934529:23934981,24048013:24167011,24057973:24175423,24089862:24191306,24099617:24210387,24123785:24269724,24132642:24232295,24134842:24232607,24160460:24273069,24206279:24261024,24234490:24271501,24258451:24259734,24258949:24259237,24293759:24389391,24293760:24309734,24293763:24309931,24293764:24310528,24296609:24338959,24296616:24339366,24296618:24339465,24297931:24340975,24297932:24341003,24297948:24298519,24297952:24298411,24298468:24298789,24417729:24420597,24427488:24433670,24427507:2443401', 'assoc_mat': '23536623:autre_refus:3726:23591591,23537859:autre_refus:3726:23573176,23537860:autre_refus:3726:23584247,23545582:autre_refus:3726:23574687,23545583:autre_refus:3726:23545830,23546914:autre_refus:3726:23574866,23546917:autre_refus:3726:23547202,23548810:autre_refus:3726:23575178,23581987:autre_refus:3726:23582042,23582159:autre_refus:3726:23582324,23582160:autre_refus:3726:23592595,23586389:autre_refus:3726:23595698,23587638:autre_refus:3726:23602644,23587640:autre_refus:3726:23602874,23589204:autre_refus:3726:23589348,23674635:autre_refus:3726:23674971,23674636:autre_refus:3726:23698449,23707529:autre_refus:3726:23730844,23708171:autre_refus:3726:23731847,23708188:autre_refus:3726:23731905,23708519:autre_refus:3726:23737983,23740008:autre_refus:3726:23748198,23740009:autre_refus:3726:23748491,23740010:autre_refus:3726:23748571,23740011:autre_refus:3726:23744827,23740012:autre_refus:3726:23744410,23812872:autre_refus:3726:23813040,23848986:autre_refus:3726:23849287,23934175:autre_refus:3726:24038480,23934529:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01543467342213529, 'nb_photo': 2205, 'list_port_cont': '23545827,23547200,23573181,23574685,23574861,23575183,23582037,23582323,23584243,23589357,23591594,23592589,23595694,23595943,23602652,23602873,23674977,23696656,23698447,23730852,23731845,23731906,23737981,23744408,23744825,23748208,23748488,23748564,23813039,23849280,23934984,24038482,24167009,24175427,24191295,24210379,24232296,24232601,24259240,24259735,24260855,24261023,24269729,24271499,24273066,24298414,24298527,24298781,24309729,24309926,24310526,24338955,24339361,24339463,24340972,24341005,24389399,24420590,24433673,24434009,24436574,24449736,24452297,24491408,24491457,24491482,24491498,24491523,24491552,24491626,24491650,24491681,24505544,24510523,24541322,24541390,24541952,24542201,24542708,24543186,24543838,24544060,24544439,24544824,24545197,24545367,24545667,24545781,24553030,24577387,24577951,24578351,24578383,24610066,24610499,24610815,24611114,24611687,24612142,24612328,24612639,24615320,24616452,24624711,24625059,24632440', 'assoc_port': '23536623:23591594,23537859:23573181,23537860:23584243,23545582:23574685,23545583:23545827,23546914:23574861,23546917:23547200,23548810:23575183,23581987:23582037,23582159:23582323,23582160:23592589,23586389:23595694,23586392:23595943,23587638:23602652,23587640:23602873,23589204:23589357,23673266:23696656,23674635:23674977,23674636:23698447,23707529:23730852,23708171:23731845,23708188:23731906,23708519:23737981,23740008:23748208,23740009:23748488,23740010:23748564,23740011:23744825,23740012:23744408,23812872:23813039,23848986:23849280,23934175:24038482,23934529:23934984,24048013:24167009,24057973:24175427,24089862:24191295,24099617:24210379,24123785:24269729,24132642:24232296,24134842:24232601,24160460:24273066,24206279:24261023,24234490:24271499,24258451:24259735,24258949:24259240,24259897:24260855,24293759:24389399,24293760:24309729,24293763:24309926,24293764:24310526,24296609:24338955,24296616:24339361,24296618:24339463,24297931:24340972,24297932:24341005,24297948:24298527,24297952:24298414,24298468:2429878', 'assoc_mat': '23536623:cartonnette:3726:23591594,23537859:cartonnette:3726:23573181,23537860:cartonnette:3726:23584243,23545582:cartonnette:3726:23574685,23545583:cartonnette:3726:23545827,23546914:cartonnette:3726:23574861,23546917:cartonnette:3726:23547200,23548810:cartonnette:3726:23575183,23581987:cartonnette:3726:23582037,23582159:cartonnette:3726:23582323,23582160:cartonnette:3726:23592589,23586389:cartonnette:3726:23595694,23586392:cartonnette:3726:23595943,23587638:cartonnette:3726:23602652,23587640:cartonnette:3726:23602873,23589204:cartonnette:3726:23589357,23673266:cartonnette:3726:23696656,23674635:cartonnette:3726:23674977,23674636:cartonnette:3726:23698447,23707529:cartonnette:3726:23730852,23708171:cartonnette:3726:23731845,23708188:cartonnette:3726:23731906,23708519:cartonnette:3726:23737981,23740008:cartonnette:3726:23748208,23740009:cartonnette:3726:23748488,23740010:cartonnette:3726:23748564,23740011:cartonnette:3726:23744825,23740012:cartonnette:3726:23744408,23812872:cartonnette:3726:23813039,23848986:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.06774612787116356, 'nb_photo': 10693, 'list_port_cont': '23545831,23547198,23573186,23574676,23574858,23575182,23582047,23582317,23584239,23589347,23591581,23592594,23595702,23595944,23602655,23602871,23674970,23696664,23698453,23730842,23731850,23731895,23737982,23744405,23744831,23748205,23748485,23748565,23813046,23849278,23934980,24038485,24167020,24175432,24191297,24210383,24232292,24232602,24259244,24259740,24260853,24261026,24269721,24271493,24273063,24298409,24298525,24298796,24309739,24309927,24310525,24338958,24339355,24339468,24340974,24341008,24389394,24420588,24433665,24434006,24436578,24449738,24452293,24491409,24491452,24491472,24491504,24491530,24491550,24491622,24491656,24491677,24505542,24510521,24541327,24541392,24541959,24542195,24542703,24543187,24543835,24544066,24544447,24544818,24545198,24545368,24545679,24545775,24553029,24577388,24577954,24578360,24578384,24610064,24610498,24610812,24611111,24611690,24612146,24612333,24612650,24615316,24616461,24624714,24625053,24632450', 'assoc_port': '23536623:23591581,23537859:23573186,23537860:23584239,23545582:23574676,23545583:23545831,23546914:23574858,23546917:23547198,23548810:23575182,23581987:23582047,23582159:23582317,23582160:23592594,23586389:23595702,23586392:23595944,23587638:23602655,23587640:23602871,23589204:23589347,23673266:23696664,23674635:23674970,23674636:23698453,23707529:23730842,23708171:23731850,23708188:23731895,23708519:23737982,23740008:23748205,23740009:23748485,23740010:23748565,23740011:23744831,23740012:23744405,23812872:23813046,23848986:23849278,23934175:24038485,23934529:23934980,24048013:24167020,24057973:24175432,24089862:24191297,24099617:24210383,24123785:24269721,24132642:24232292,24134842:24232602,24160460:24273063,24206279:24261026,24234490:24271493,24258451:24259740,24258949:24259244,24259897:24260853,24293759:24389394,24293760:24309739,24293763:24309927,24293764:24310525,24296609:24338958,24296616:24339355,24296618:24339468,24297931:24340974,24297932:24341008,24297948:24298525,24297952:24298409,24298468:2429879', 'assoc_mat': '23536623:Carton_brun:3726:23591581,23537859:Carton_brun:3726:23573186,23537860:Carton_brun:3726:23584239,23545582:Carton_brun:3726:23574676,23545583:Carton_brun:3726:23545831,23546914:Carton_brun:3726:23574858,23546917:Carton_brun:3726:23547198,23548810:Carton_brun:3726:23575182,23581987:Carton_brun:3726:23582047,23582159:Carton_brun:3726:23582317,23582160:Carton_brun:3726:23592594,23586389:Carton_brun:3726:23595702,23586392:Carton_brun:3726:23595944,23587638:Carton_brun:3726:23602655,23587640:Carton_brun:3726:23602871,23589204:Carton_brun:3726:23589347,23673266:Carton_brun:3726:23696664,23674635:Carton_brun:3726:23674970,23674636:Carton_brun:3726:23698453,23707529:Carton_brun:3726:23730842,23708171:Carton_brun:3726:23731850,23708188:Carton_brun:3726:23731895,23708519:Carton_brun:3726:23737982,23740008:Carton_brun:3726:23748205,23740009:Carton_brun:3726:23748485,23740010:Carton_brun:3726:23748565,23740011:Carton_brun:3726:23744831,23740012:Carton_brun:3726:23744405,23812872:Carton_brun:3726:23813046,23848986:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005269957693145747, 'nb_photo': 311, 'list_port_cont': '23545821,23547195,23573180,23574678,23574860,23575177,23582038,23582322,23584242,23589349,23592593,23595699,23602646,23602868,23674968,23696665,23698451,23731856,23731898,23744412,23744833,23748206,23748566,23849283,23934975,24038483,24167019,24175421,24210382,24232298,24232598,24259241,24259732,24261027,24271497,24273070,24298408,24298516,24298785,24309733,24309924,24310520,24339359,24339467,24340969,24340998,24389400,24433669,24434001,24436572,24449744,24452298,24491405,24491448,24491475,24491525,24491623,24491646,24505536,24510524,24541332,24541386,24541950,24542198,24542701,24543193,24544065,24544820,24545204,24545359,24545681,24545778,24553020,24577385,24577960,24578361,24578378,24610062,24610504,24610806,24611117,24612325,24612644,24615327,24616458,24624719,24625052,24632447', 'assoc_port': '23537859:23573180,23537860:23584242,23545582:23574678,23545583:23545821,23546914:23574860,23546917:23547195,23548810:23575177,23581987:23582038,23582159:23582322,23582160:23592593,23586389:23595699,23587638:23602646,23587640:23602868,23589204:23589349,23673266:23696665,23674635:23674968,23674636:23698451,23708171:23731856,23708188:23731898,23740008:23748206,23740010:23748566,23740011:23744833,23740012:23744412,23848986:23849283,23934175:24038483,23934529:23934975,24048013:24167019,24057973:24175421,24099617:24210382,24132642:24232298,24134842:24232598,24160460:24273070,24206279:24261027,24234490:24271497,24258451:24259732,24258949:24259241,24293759:24389400,24293760:24309733,24293763:24309924,24293764:24310520,24296616:24339359,24296618:24339467,24297931:24340969,24297932:24340998,24297948:24298516,24297952:24298408,24298468:24298785,24427488:24433669,24427507:24434001,24427560:24510524,24430292:24436572,24434159:24449744,24452070:24452298,24453777:24491623,24453779:24491646,24453783:24491525,24453786:2449144', 'assoc_mat': '23537859:Carton_gris:3726:23573180,23537860:Carton_gris:3726:23584242,23545582:Carton_gris:3726:23574678,23545583:Carton_gris:3726:23545821,23546914:Carton_gris:3726:23574860,23546917:Carton_gris:3726:23547195,23548810:Carton_gris:3726:23575177,23581987:Carton_gris:3726:23582038,23582159:Carton_gris:3726:23582322,23582160:Carton_gris:3726:23592593,23586389:Carton_gris:3726:23595699,23587638:Carton_gris:3726:23602646,23587640:Carton_gris:3726:23602868,23589204:Carton_gris:3726:23589349,23673266:Carton_gris:3726:23696665,23674635:Carton_gris:3726:23674968,23674636:Carton_gris:3726:23698451,23708171:Carton_gris:3726:23731856,23708188:Carton_gris:3726:23731898,23740008:Carton_gris:3726:23748206,23740010:Carton_gris:3726:23748566,23740011:Carton_gris:3726:23744833,23740012:Carton_gris:3726:23744412,23848986:Carton_gris:3726:23849283,23934175:Carton_gris:3726:24038483,23934529:Carton_gris:3726:23934975,24048013:Carton_gris:3726:24167019,24057973:Carton_gris:3726:24175421,24099617:Carton_gris:3726:24210382,24132642:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0035761438605576876, 'nb_photo': 192, 'list_port_cont': '23545824,23547196,23573178,23574681,23574867,23582046,23582315,23584248,23589353,23592599,23595693,23595941,23602649,23602867,23696660,23698448,23730850,23731897,23737984,23744406,23744832,23748202,23748484,23748567,23849288,24038481,24167016,24175422,24232291,24232606,24269730,24271498,24273071,24298520,24309735,24309930,24310522,24338951,24339363,24339458,24341007,24420587,24433666,24434005,24436575,24449740,24452299,24491407,24491459,24491481,24491531,24491632,24491657,24491680,24505540,24542710,24543833,24544070,24544441,24544827,24545200,24545360,24545672,24545783,24553023,24577391,24577952,24578358,24578376,24610807,24611112,24612153,24612640,24615326,24616454,24624712,24625051,24632448', 'assoc_port': '23537859:23573178,23537860:23584248,23545582:23574681,23545583:23545824,23546914:23574867,23546917:23547196,23581987:23582046,23582159:23582315,23582160:23592599,23586389:23595693,23586392:23595941,23587638:23602649,23587640:23602867,23589204:23589353,23673266:23696660,23674636:23698448,23707529:23730850,23708188:23731897,23708519:23737984,23740008:23748202,23740009:23748484,23740010:23748567,23740011:23744832,23740012:23744406,23848986:23849288,23934175:24038481,24048013:24167016,24057973:24175422,24123785:24269730,24132642:24232291,24134842:24232606,24160460:24273071,24234490:24271498,24293760:24309735,24293763:24309930,24293764:24310522,24296609:24338951,24296616:24339363,24296618:24339458,24297932:24341007,24297948:24298520,24417729:24420587,24427488:24433666,24427507:24434005,24430292:24436575,24434159:24449740,24452070:24452299,24453777:24491632,24453779:24491657,24453783:24491531,24453786:24491459,24453789:24491481,24453791:24491680,24453847:24491407,24505106:24578358,24505109:24578376,24505238:2457739', 'assoc_mat': '23537859:kraft:3726:23573178,23537860:kraft:3726:23584248,23545582:kraft:3726:23574681,23545583:kraft:3726:23545824,23546914:kraft:3726:23574867,23546917:kraft:3726:23547196,23581987:kraft:3726:23582046,23582159:kraft:3726:23582315,23582160:kraft:3726:23592599,23586389:kraft:3726:23595693,23586392:kraft:3726:23595941,23587638:kraft:3726:23602649,23587640:kraft:3726:23602867,23589204:kraft:3726:23589353,23673266:kraft:3726:23696660,23674636:kraft:3726:23698448,23707529:kraft:3726:23730850,23708188:kraft:3726:23731897,23708519:kraft:3726:23737984,23740008:kraft:3726:23748202,23740009:kraft:3726:23748484,23740010:kraft:3726:23748567,23740011:kraft:3726:23744832,23740012:kraft:3726:23744406,23848986:kraft:3726:23849288,23934175:kraft:3726:24038481,24048013:kraft:3726:24167016,24057973:kraft:3726:24175422,24123785:kraft:3726:24269730,24132642:kraft:3726:24232291,24134842:kraft:3726:24232606,24160460:kraft:3726:24273071,24234490:kraft:3726:24271498,24293760:kraft:3726:24309735,24293763:kraft:3726:24309930,24293764:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0011831639144853807, 'nb_photo': 21, 'list_port_cont': '23545826,23731902,23737985,23748561,23849285,24259741,24261025,24298415,24298798,24389402,24542196,24544061,24544822,24553025,24577957,24610813', 'assoc_port': '23545583:23545826,23708188:23731902,23708519:23737985,23740010:23748561,23848986:23849285,24206279:24261025,24258451:24259741,24293759:24389402,24297952:24298415,24298468:24298798,24505111:24542196,24505242:24544061,24505244:24553025,24505366:24577957,24505374:24544822,24593565:24610813', 'assoc_mat': '23545583:metal:3726:23545826,23708188:metal:3726:23731902,23708519:metal:3726:23737985,23740010:metal:3726:23748561,23848986:metal:3726:23849285,24206279:metal:3726:24261025,24258451:metal:3726:24259741,24293759:metal:3726:24389402,24297952:metal:3726:24298415,24298468:metal:3726:24298798,24505111:metal:3726:24542196,24505242:metal:3726:24544061,24505244:metal:3726:24553025,24505366:metal:3726:24577957,24505374:metal:3726:24544822,24593565:metal:3726:24610813'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009650803438459225, 'nb_photo': 1406, 'list_port_cont': '23545820,23547192,23573184,23574686,23574864,23575179,23582045,23582320,23584240,23589355,23591588,23592596,23595696,23595945,23602651,23602864,23674976,23696663,23698443,23730847,23731853,23731899,23737990,23744413,23744828,23748199,23748487,23748569,23813047,23849286,23934985,24038487,24167014,24175430,24191296,24210386,24232290,24232603,24259245,24259737,24260858,24261028,24269722,24271494,24273068,24298413,24298514,24298783,24309738,24309935,24310529,24338957,24339365,24339466,24340976,24341001,24389395,24420595,24433672,24434000,24436571,24449737,24452304,24491404,24491455,24491476,24491502,24491522,24491547,24491625,24491649,24491674,24505541,24510527,24541329,24541388,24541953,24542200,24542706,24543182,24543841,24544064,24544445,24544817,24545196,24545363,24545673,24545773,24553026,24577384,24577958,24578353,24578387,24610059,24610500,24610816,24611113,24611689,24612147,24612335,24612643,24615323,24616457,24624709,24625056,24632446', 'assoc_port': '23536623:23591588,23537859:23573184,23537860:23584240,23545582:23574686,23545583:23545820,23546914:23574864,23546917:23547192,23548810:23575179,23581987:23582045,23582159:23582320,23582160:23592596,23586389:23595696,23586392:23595945,23587638:23602651,23587640:23602864,23589204:23589355,23673266:23696663,23674635:23674976,23674636:23698443,23707529:23730847,23708171:23731853,23708188:23731899,23708519:23737990,23740008:23748199,23740009:23748487,23740010:23748569,23740011:23744828,23740012:23744413,23812872:23813047,23848986:23849286,23934175:24038487,23934529:23934985,24048013:24167014,24057973:24175430,24089862:24191296,24099617:24210386,24123785:24269722,24132642:24232290,24134842:24232603,24160460:24273068,24206279:24261028,24234490:24271494,24258451:24259737,24258949:24259245,24259897:24260858,24293759:24389395,24293760:24309738,24293763:24309935,24293764:24310529,24296609:24338957,24296616:24339365,24296618:24339466,24297931:24340976,24297932:24341001,24297948:24298514,24297952:24298413,24298468:2429878', 'assoc_mat': '23536623:plastique:3726:23591588,23537859:plastique:3726:23573184,23537860:plastique:3726:23584240,23545582:plastique:3726:23574686,23545583:plastique:3726:23545820,23546914:plastique:3726:23574864,23546917:plastique:3726:23547192,23548810:plastique:3726:23575179,23581987:plastique:3726:23582045,23582159:plastique:3726:23582320,23582160:plastique:3726:23592596,23586389:plastique:3726:23595696,23586392:plastique:3726:23595945,23587638:plastique:3726:23602651,23587640:plastique:3726:23602864,23589204:plastique:3726:23589355,23673266:plastique:3726:23696663,23674635:plastique:3726:23674976,23674636:plastique:3726:23698443,23707529:plastique:3726:23730847,23708171:plastique:3726:23731853,23708188:plastique:3726:23731899,23708519:plastique:3726:23737990,23740008:plastique:3726:23748199,23740009:plastique:3726:23748487,23740010:plastique:3726:23748569,23740011:plastique:3726:23744828,23740012:plastique:3726:23744413,23812872:plastique:3726:23813047,23848986:plastique:3726:23849286,23934175:plastique:3726:24038487,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01975335961692814, 'nb_photo': 5287, 'list_port_cont': '23545828,23547197,23573177,23574683,23574865,23575176,23582040,23582316,23584246,23589350,23591585,23592598,23595701,23595942,23602653,23602869,23674973,23696662,23698445,23730848,23731854,23731901,23737988,23744403,23744829,23748201,23748489,23748560,23813050,23849284,23934978,24038488,24167013,24175428,24191303,24210378,24232301,24232604,24236502,24259239,24259730,24260854,24261029,24269726,24271496,24273064,24298404,24298517,24298791,24309731,24309933,24310527,24338960,24339360,24339464,24340968,24341004,24389390,24420589,24433667,24434017,24436580,24449734,24452294,24491403,24491456,24491474,24491507,24491521,24491551,24491628,24491654,24491672,24505539,24510522,24541328,24541397,24541960,24542194,24542711,24543183,24543844,24544067,24544442,24544826,24545203,24545361,24545671,24545784,24553019,24577386,24577955,24578359,24578380,24610056,24610497,24610805,24611115,24611688,24612148,24612326,24612646,24615321,24616455,24624716,24625057,24632444', 'assoc_port': '23536623:23591585,23537859:23573177,23537860:23584246,23545582:23574683,23545583:23545828,23546914:23574865,23546917:23547197,23548810:23575176,23581987:23582040,23582159:23582316,23582160:23592598,23586389:23595701,23586392:23595942,23587638:23602653,23587640:23602869,23589204:23589350,23673266:23696662,23674635:23674973,23674636:23698445,23707529:23730848,23708171:23731854,23708188:23731901,23708519:23737988,23740008:23748201,23740009:23748489,23740010:23748560,23740011:23744829,23740012:23744403,23812872:23813050,23848986:23849284,23934175:24038488,23934529:23934978,24048013:24167013,24057973:24175428,24089862:24191303,24099617:24210378,24123785:24269726,24132642:24232301,24134842:24232604,24160460:24273064,24167716:24236502,24206279:24261029,24234490:24271496,24258451:24259730,24258949:24259239,24259897:24260854,24293759:24389390,24293760:24309731,24293763:24309933,24293764:24310527,24296609:24338960,24296616:24339360,24296618:24339464,24297931:24340968,24297932:24341004,24297948:24298517,24297952:2429840', 'assoc_mat': '23536623:Teint_Dans_La_Masse:3726:23591585,23537859:Teint_Dans_La_Masse:3726:23573177,23537860:Teint_Dans_La_Masse:3726:23584246,23545582:Teint_Dans_La_Masse:3726:23574683,23545583:Teint_Dans_La_Masse:3726:23545828,23546914:Teint_Dans_La_Masse:3726:23574865,23546917:Teint_Dans_La_Masse:3726:23547197,23548810:Teint_Dans_La_Masse:3726:23575176,23581987:Teint_Dans_La_Masse:3726:23582040,23582159:Teint_Dans_La_Masse:3726:23582316,23582160:Teint_Dans_La_Masse:3726:23592598,23586389:Teint_Dans_La_Masse:3726:23595701,23586392:Teint_Dans_La_Masse:3726:23595942,23587638:Teint_Dans_La_Masse:3726:23602653,23587640:Teint_Dans_La_Masse:3726:23602869,23589204:Teint_Dans_La_Masse:3726:23589350,23673266:Teint_Dans_La_Masse:3726:23696662,23674635:Teint_Dans_La_Masse:3726:23674973,23674636:Teint_Dans_La_Masse:3726:23698445,23707529:Teint_Dans_La_Masse:3726:23730848,23708171:Teint_Dans_La_Masse:3726:23731854,23708188:Teint_Dans_La_Masse:3726:23731901,23708519:Teint_Dans_La_Masse:3726:23737988,23740008:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 7809}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2025-06', 0.12367236403719307),)]} 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 ! 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': ((7809,),), 'unwanted_material_monthly_percentage': ((0.12367236403719307,),), 'material_repartition': (('JRM', 3261),), 'material_dict': {'JRM': 3261}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 2), 0.13231014718934425, 520), (datetime.date(2025, 6, 3), 0.14967003680071786, 542), (datetime.date(2025, 6, 5), 0.11953419333008454, 544), (datetime.date(2025, 6, 6), 0.11899838238784874, 298), (datetime.date(2025, 6, 10), 0.11353106247399555, 669), (datetime.date(2025, 6, 11), 0.12298648519873823, 640), (datetime.date(2025, 6, 12), 0.1146780972029024, 723), (datetime.date(2025, 6, 13), 0.12258881257060208, 306), (datetime.date(2025, 6, 16), 0.10421189017595531, 619), (datetime.date(2025, 6, 17), 0.14068105321958926, 634), (datetime.date(2025, 6, 18), 0.11552783374688068, 590), (datetime.date(2025, 6, 19), 0.13009630930994687, 542), (datetime.date(2025, 6, 20), 0.10627272254292765, 222), (datetime.date(2025, 6, 23), 0.1342112796729472, 155), (datetime.date(2025, 6, 24), 0.12430631145328166, 258), (datetime.date(2025, 6, 25), 0.13391292739800428, 258), (datetime.date(2025, 6, 27), 0.12455169223594413, 17), (datetime.date(2025, 6, 30), 0.13570763393612642, 272)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 6, 2), 0.13231014718934425, 520), (datetime.date(2025, 6, 3), 0.14967003680071786, 542), (datetime.date(2025, 6, 5), 0.11953419333008454, 544), (datetime.date(2025, 6, 6), 0.11899838238784874, 298), (datetime.date(2025, 6, 10), 0.11353106247399555, 669), (datetime.date(2025, 6, 11), 0.12298648519873823, 640), (datetime.date(2025, 6, 12), 0.1146780972029024, 723), (datetime.date(2025, 6, 13), 0.12258881257060208, 306), (datetime.date(2025, 6, 16), 0.10421189017595531, 619), (datetime.date(2025, 6, 17), 0.14068105321958926, 634), (datetime.date(2025, 6, 18), 0.11552783374688068, 590), (datetime.date(2025, 6, 19), 0.13009630930994687, 542), (datetime.date(2025, 6, 20), 0.10627272254292765, 222), (datetime.date(2025, 6, 23), 0.1342112796729472, 155), (datetime.date(2025, 6, 24), 0.12430631145328166, 258), (datetime.date(2025, 6, 25), 0.13391292739800428, 258), (datetime.date(2025, 6, 27), 0.12455169223594413, 17), (datetime.date(2025, 6, 30), 0.13570763393612642, 272))}, 'quality_array': [['-0.29450224427712784', '02062025'], ['-0.03609146561571846', '03062025'], ['-0.09867621622217751', '05062025'], ['-0.20442755882771213', '06062025'], ['-0.2033616771393547', '10062025'], ['-0.07383410013056581', '11062025'], ['-0.26262949917898', '12062025'], ['-0.39976066065298194', '13062025'], ['-0.3447706681429767', '16062025'], ['-0.3123801679128725', '17062025'], ['-0.02615728228916765', '18062025'], ['-0.065130033231122', '19062025'], ['-0.06647919603152895', '20062025'], ['0.7437384084700723', '23062025'], ['-0.0014128920077251471', '24062025'], ['0.10856361752272176', '25062025'], ['-0.2806602513337429', '27062025'], ['-0.15025045563611916', '30062025']], 'number_of_batch': ((107,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.012247428172804865, 'nb_photo': 598, 'list_port_cont': '23545830,23547202,23573176,23574687,23574866,23575178,23582042,23582324,23584247,23589348,23591591,23592595,23595698,23602644,23602874,23674971,23698449,23730844,23731847,23731905,23737983,23744410,23744827,23748198,23748491,23748571,23813040,23849287,23934981,24038480,24167011,24175423,24191306,24210387,24232295,24232607,24259237,24259734,24261024,24269724,24271501,24273069,24298411,24298519,24298789,24309734,24309931,24310528,24338959,24339366,24339465,24340975,24341003,24389391,24420597,24433670,24434012,24436581,24449735,24452295,24491411,24491451,24491483,24491503,24491526,24491555,24491631,24491651,24491678,24505534,24510526,24541333,24541389,24541961,24542191,24542702,24543184,24543842,24544062,24544448,24544821,24545205,24545358,24545676,24545782,24553027,24577389,24577953,24578379,24610058,24610501,24610811,24611116,24611682,24612145,24612332,24612648,24615322,24616451,24624717,24625048,24632443', 'assoc_port': '23536623:23591591,23537859:23573176,23537860:23584247,23545582:23574687,23545583:23545830,23546914:23574866,23546917:23547202,23548810:23575178,23581987:23582042,23582159:23582324,23582160:23592595,23586389:23595698,23587638:23602644,23587640:23602874,23589204:23589348,23674635:23674971,23674636:23698449,23707529:23730844,23708171:23731847,23708188:23731905,23708519:23737983,23740008:23748198,23740009:23748491,23740010:23748571,23740011:23744827,23740012:23744410,23812872:23813040,23848986:23849287,23934175:24038480,23934529:23934981,24048013:24167011,24057973:24175423,24089862:24191306,24099617:24210387,24123785:24269724,24132642:24232295,24134842:24232607,24160460:24273069,24206279:24261024,24234490:24271501,24258451:24259734,24258949:24259237,24293759:24389391,24293760:24309734,24293763:24309931,24293764:24310528,24296609:24338959,24296616:24339366,24296618:24339465,24297931:24340975,24297932:24341003,24297948:24298519,24297952:24298411,24298468:24298789,24417729:24420597,24427488:24433670,24427507:2443401', 'assoc_mat': '23536623:autre_refus:3726:23591591,23537859:autre_refus:3726:23573176,23537860:autre_refus:3726:23584247,23545582:autre_refus:3726:23574687,23545583:autre_refus:3726:23545830,23546914:autre_refus:3726:23574866,23546917:autre_refus:3726:23547202,23548810:autre_refus:3726:23575178,23581987:autre_refus:3726:23582042,23582159:autre_refus:3726:23582324,23582160:autre_refus:3726:23592595,23586389:autre_refus:3726:23595698,23587638:autre_refus:3726:23602644,23587640:autre_refus:3726:23602874,23589204:autre_refus:3726:23589348,23674635:autre_refus:3726:23674971,23674636:autre_refus:3726:23698449,23707529:autre_refus:3726:23730844,23708171:autre_refus:3726:23731847,23708188:autre_refus:3726:23731905,23708519:autre_refus:3726:23737983,23740008:autre_refus:3726:23748198,23740009:autre_refus:3726:23748491,23740010:autre_refus:3726:23748571,23740011:autre_refus:3726:23744827,23740012:autre_refus:3726:23744410,23812872:autre_refus:3726:23813040,23848986:autre_refus:3726:23849287,23934175:autre_refus:3726:24038480,23934529:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01543467342213529, 'nb_photo': 2205, 'list_port_cont': '23545827,23547200,23573181,23574685,23574861,23575183,23582037,23582323,23584243,23589357,23591594,23592589,23595694,23595943,23602652,23602873,23674977,23696656,23698447,23730852,23731845,23731906,23737981,23744408,23744825,23748208,23748488,23748564,23813039,23849280,23934984,24038482,24167009,24175427,24191295,24210379,24232296,24232601,24259240,24259735,24260855,24261023,24269729,24271499,24273066,24298414,24298527,24298781,24309729,24309926,24310526,24338955,24339361,24339463,24340972,24341005,24389399,24420590,24433673,24434009,24436574,24449736,24452297,24491408,24491457,24491482,24491498,24491523,24491552,24491626,24491650,24491681,24505544,24510523,24541322,24541390,24541952,24542201,24542708,24543186,24543838,24544060,24544439,24544824,24545197,24545367,24545667,24545781,24553030,24577387,24577951,24578351,24578383,24610066,24610499,24610815,24611114,24611687,24612142,24612328,24612639,24615320,24616452,24624711,24625059,24632440', 'assoc_port': '23536623:23591594,23537859:23573181,23537860:23584243,23545582:23574685,23545583:23545827,23546914:23574861,23546917:23547200,23548810:23575183,23581987:23582037,23582159:23582323,23582160:23592589,23586389:23595694,23586392:23595943,23587638:23602652,23587640:23602873,23589204:23589357,23673266:23696656,23674635:23674977,23674636:23698447,23707529:23730852,23708171:23731845,23708188:23731906,23708519:23737981,23740008:23748208,23740009:23748488,23740010:23748564,23740011:23744825,23740012:23744408,23812872:23813039,23848986:23849280,23934175:24038482,23934529:23934984,24048013:24167009,24057973:24175427,24089862:24191295,24099617:24210379,24123785:24269729,24132642:24232296,24134842:24232601,24160460:24273066,24206279:24261023,24234490:24271499,24258451:24259735,24258949:24259240,24259897:24260855,24293759:24389399,24293760:24309729,24293763:24309926,24293764:24310526,24296609:24338955,24296616:24339361,24296618:24339463,24297931:24340972,24297932:24341005,24297948:24298527,24297952:24298414,24298468:2429878', 'assoc_mat': '23536623:cartonnette:3726:23591594,23537859:cartonnette:3726:23573181,23537860:cartonnette:3726:23584243,23545582:cartonnette:3726:23574685,23545583:cartonnette:3726:23545827,23546914:cartonnette:3726:23574861,23546917:cartonnette:3726:23547200,23548810:cartonnette:3726:23575183,23581987:cartonnette:3726:23582037,23582159:cartonnette:3726:23582323,23582160:cartonnette:3726:23592589,23586389:cartonnette:3726:23595694,23586392:cartonnette:3726:23595943,23587638:cartonnette:3726:23602652,23587640:cartonnette:3726:23602873,23589204:cartonnette:3726:23589357,23673266:cartonnette:3726:23696656,23674635:cartonnette:3726:23674977,23674636:cartonnette:3726:23698447,23707529:cartonnette:3726:23730852,23708171:cartonnette:3726:23731845,23708188:cartonnette:3726:23731906,23708519:cartonnette:3726:23737981,23740008:cartonnette:3726:23748208,23740009:cartonnette:3726:23748488,23740010:cartonnette:3726:23748564,23740011:cartonnette:3726:23744825,23740012:cartonnette:3726:23744408,23812872:cartonnette:3726:23813039,23848986:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.06774612787116356, 'nb_photo': 10693, 'list_port_cont': '23545831,23547198,23573186,23574676,23574858,23575182,23582047,23582317,23584239,23589347,23591581,23592594,23595702,23595944,23602655,23602871,23674970,23696664,23698453,23730842,23731850,23731895,23737982,23744405,23744831,23748205,23748485,23748565,23813046,23849278,23934980,24038485,24167020,24175432,24191297,24210383,24232292,24232602,24259244,24259740,24260853,24261026,24269721,24271493,24273063,24298409,24298525,24298796,24309739,24309927,24310525,24338958,24339355,24339468,24340974,24341008,24389394,24420588,24433665,24434006,24436578,24449738,24452293,24491409,24491452,24491472,24491504,24491530,24491550,24491622,24491656,24491677,24505542,24510521,24541327,24541392,24541959,24542195,24542703,24543187,24543835,24544066,24544447,24544818,24545198,24545368,24545679,24545775,24553029,24577388,24577954,24578360,24578384,24610064,24610498,24610812,24611111,24611690,24612146,24612333,24612650,24615316,24616461,24624714,24625053,24632450', 'assoc_port': '23536623:23591581,23537859:23573186,23537860:23584239,23545582:23574676,23545583:23545831,23546914:23574858,23546917:23547198,23548810:23575182,23581987:23582047,23582159:23582317,23582160:23592594,23586389:23595702,23586392:23595944,23587638:23602655,23587640:23602871,23589204:23589347,23673266:23696664,23674635:23674970,23674636:23698453,23707529:23730842,23708171:23731850,23708188:23731895,23708519:23737982,23740008:23748205,23740009:23748485,23740010:23748565,23740011:23744831,23740012:23744405,23812872:23813046,23848986:23849278,23934175:24038485,23934529:23934980,24048013:24167020,24057973:24175432,24089862:24191297,24099617:24210383,24123785:24269721,24132642:24232292,24134842:24232602,24160460:24273063,24206279:24261026,24234490:24271493,24258451:24259740,24258949:24259244,24259897:24260853,24293759:24389394,24293760:24309739,24293763:24309927,24293764:24310525,24296609:24338958,24296616:24339355,24296618:24339468,24297931:24340974,24297932:24341008,24297948:24298525,24297952:24298409,24298468:2429879', 'assoc_mat': '23536623:Carton_brun:3726:23591581,23537859:Carton_brun:3726:23573186,23537860:Carton_brun:3726:23584239,23545582:Carton_brun:3726:23574676,23545583:Carton_brun:3726:23545831,23546914:Carton_brun:3726:23574858,23546917:Carton_brun:3726:23547198,23548810:Carton_brun:3726:23575182,23581987:Carton_brun:3726:23582047,23582159:Carton_brun:3726:23582317,23582160:Carton_brun:3726:23592594,23586389:Carton_brun:3726:23595702,23586392:Carton_brun:3726:23595944,23587638:Carton_brun:3726:23602655,23587640:Carton_brun:3726:23602871,23589204:Carton_brun:3726:23589347,23673266:Carton_brun:3726:23696664,23674635:Carton_brun:3726:23674970,23674636:Carton_brun:3726:23698453,23707529:Carton_brun:3726:23730842,23708171:Carton_brun:3726:23731850,23708188:Carton_brun:3726:23731895,23708519:Carton_brun:3726:23737982,23740008:Carton_brun:3726:23748205,23740009:Carton_brun:3726:23748485,23740010:Carton_brun:3726:23748565,23740011:Carton_brun:3726:23744831,23740012:Carton_brun:3726:23744405,23812872:Carton_brun:3726:23813046,23848986:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005269957693145747, 'nb_photo': 311, 'list_port_cont': '23545821,23547195,23573180,23574678,23574860,23575177,23582038,23582322,23584242,23589349,23592593,23595699,23602646,23602868,23674968,23696665,23698451,23731856,23731898,23744412,23744833,23748206,23748566,23849283,23934975,24038483,24167019,24175421,24210382,24232298,24232598,24259241,24259732,24261027,24271497,24273070,24298408,24298516,24298785,24309733,24309924,24310520,24339359,24339467,24340969,24340998,24389400,24433669,24434001,24436572,24449744,24452298,24491405,24491448,24491475,24491525,24491623,24491646,24505536,24510524,24541332,24541386,24541950,24542198,24542701,24543193,24544065,24544820,24545204,24545359,24545681,24545778,24553020,24577385,24577960,24578361,24578378,24610062,24610504,24610806,24611117,24612325,24612644,24615327,24616458,24624719,24625052,24632447', 'assoc_port': '23537859:23573180,23537860:23584242,23545582:23574678,23545583:23545821,23546914:23574860,23546917:23547195,23548810:23575177,23581987:23582038,23582159:23582322,23582160:23592593,23586389:23595699,23587638:23602646,23587640:23602868,23589204:23589349,23673266:23696665,23674635:23674968,23674636:23698451,23708171:23731856,23708188:23731898,23740008:23748206,23740010:23748566,23740011:23744833,23740012:23744412,23848986:23849283,23934175:24038483,23934529:23934975,24048013:24167019,24057973:24175421,24099617:24210382,24132642:24232298,24134842:24232598,24160460:24273070,24206279:24261027,24234490:24271497,24258451:24259732,24258949:24259241,24293759:24389400,24293760:24309733,24293763:24309924,24293764:24310520,24296616:24339359,24296618:24339467,24297931:24340969,24297932:24340998,24297948:24298516,24297952:24298408,24298468:24298785,24427488:24433669,24427507:24434001,24427560:24510524,24430292:24436572,24434159:24449744,24452070:24452298,24453777:24491623,24453779:24491646,24453783:24491525,24453786:2449144', 'assoc_mat': '23537859:Carton_gris:3726:23573180,23537860:Carton_gris:3726:23584242,23545582:Carton_gris:3726:23574678,23545583:Carton_gris:3726:23545821,23546914:Carton_gris:3726:23574860,23546917:Carton_gris:3726:23547195,23548810:Carton_gris:3726:23575177,23581987:Carton_gris:3726:23582038,23582159:Carton_gris:3726:23582322,23582160:Carton_gris:3726:23592593,23586389:Carton_gris:3726:23595699,23587638:Carton_gris:3726:23602646,23587640:Carton_gris:3726:23602868,23589204:Carton_gris:3726:23589349,23673266:Carton_gris:3726:23696665,23674635:Carton_gris:3726:23674968,23674636:Carton_gris:3726:23698451,23708171:Carton_gris:3726:23731856,23708188:Carton_gris:3726:23731898,23740008:Carton_gris:3726:23748206,23740010:Carton_gris:3726:23748566,23740011:Carton_gris:3726:23744833,23740012:Carton_gris:3726:23744412,23848986:Carton_gris:3726:23849283,23934175:Carton_gris:3726:24038483,23934529:Carton_gris:3726:23934975,24048013:Carton_gris:3726:24167019,24057973:Carton_gris:3726:24175421,24099617:Carton_gris:3726:24210382,24132642:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0035761438605576876, 'nb_photo': 192, 'list_port_cont': '23545824,23547196,23573178,23574681,23574867,23582046,23582315,23584248,23589353,23592599,23595693,23595941,23602649,23602867,23696660,23698448,23730850,23731897,23737984,23744406,23744832,23748202,23748484,23748567,23849288,24038481,24167016,24175422,24232291,24232606,24269730,24271498,24273071,24298520,24309735,24309930,24310522,24338951,24339363,24339458,24341007,24420587,24433666,24434005,24436575,24449740,24452299,24491407,24491459,24491481,24491531,24491632,24491657,24491680,24505540,24542710,24543833,24544070,24544441,24544827,24545200,24545360,24545672,24545783,24553023,24577391,24577952,24578358,24578376,24610807,24611112,24612153,24612640,24615326,24616454,24624712,24625051,24632448', 'assoc_port': '23537859:23573178,23537860:23584248,23545582:23574681,23545583:23545824,23546914:23574867,23546917:23547196,23581987:23582046,23582159:23582315,23582160:23592599,23586389:23595693,23586392:23595941,23587638:23602649,23587640:23602867,23589204:23589353,23673266:23696660,23674636:23698448,23707529:23730850,23708188:23731897,23708519:23737984,23740008:23748202,23740009:23748484,23740010:23748567,23740011:23744832,23740012:23744406,23848986:23849288,23934175:24038481,24048013:24167016,24057973:24175422,24123785:24269730,24132642:24232291,24134842:24232606,24160460:24273071,24234490:24271498,24293760:24309735,24293763:24309930,24293764:24310522,24296609:24338951,24296616:24339363,24296618:24339458,24297932:24341007,24297948:24298520,24417729:24420587,24427488:24433666,24427507:24434005,24430292:24436575,24434159:24449740,24452070:24452299,24453777:24491632,24453779:24491657,24453783:24491531,24453786:24491459,24453789:24491481,24453791:24491680,24453847:24491407,24505106:24578358,24505109:24578376,24505238:2457739', 'assoc_mat': '23537859:kraft:3726:23573178,23537860:kraft:3726:23584248,23545582:kraft:3726:23574681,23545583:kraft:3726:23545824,23546914:kraft:3726:23574867,23546917:kraft:3726:23547196,23581987:kraft:3726:23582046,23582159:kraft:3726:23582315,23582160:kraft:3726:23592599,23586389:kraft:3726:23595693,23586392:kraft:3726:23595941,23587638:kraft:3726:23602649,23587640:kraft:3726:23602867,23589204:kraft:3726:23589353,23673266:kraft:3726:23696660,23674636:kraft:3726:23698448,23707529:kraft:3726:23730850,23708188:kraft:3726:23731897,23708519:kraft:3726:23737984,23740008:kraft:3726:23748202,23740009:kraft:3726:23748484,23740010:kraft:3726:23748567,23740011:kraft:3726:23744832,23740012:kraft:3726:23744406,23848986:kraft:3726:23849288,23934175:kraft:3726:24038481,24048013:kraft:3726:24167016,24057973:kraft:3726:24175422,24123785:kraft:3726:24269730,24132642:kraft:3726:24232291,24134842:kraft:3726:24232606,24160460:kraft:3726:24273071,24234490:kraft:3726:24271498,24293760:kraft:3726:24309735,24293763:kraft:3726:24309930,24293764:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0011831639144853807, 'nb_photo': 21, 'list_port_cont': '23545826,23731902,23737985,23748561,23849285,24259741,24261025,24298415,24298798,24389402,24542196,24544061,24544822,24553025,24577957,24610813', 'assoc_port': '23545583:23545826,23708188:23731902,23708519:23737985,23740010:23748561,23848986:23849285,24206279:24261025,24258451:24259741,24293759:24389402,24297952:24298415,24298468:24298798,24505111:24542196,24505242:24544061,24505244:24553025,24505366:24577957,24505374:24544822,24593565:24610813', 'assoc_mat': '23545583:metal:3726:23545826,23708188:metal:3726:23731902,23708519:metal:3726:23737985,23740010:metal:3726:23748561,23848986:metal:3726:23849285,24206279:metal:3726:24261025,24258451:metal:3726:24259741,24293759:metal:3726:24389402,24297952:metal:3726:24298415,24298468:metal:3726:24298798,24505111:metal:3726:24542196,24505242:metal:3726:24544061,24505244:metal:3726:24553025,24505366:metal:3726:24577957,24505374:metal:3726:24544822,24593565:metal:3726:24610813'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009650803438459225, 'nb_photo': 1406, 'list_port_cont': '23545820,23547192,23573184,23574686,23574864,23575179,23582045,23582320,23584240,23589355,23591588,23592596,23595696,23595945,23602651,23602864,23674976,23696663,23698443,23730847,23731853,23731899,23737990,23744413,23744828,23748199,23748487,23748569,23813047,23849286,23934985,24038487,24167014,24175430,24191296,24210386,24232290,24232603,24259245,24259737,24260858,24261028,24269722,24271494,24273068,24298413,24298514,24298783,24309738,24309935,24310529,24338957,24339365,24339466,24340976,24341001,24389395,24420595,24433672,24434000,24436571,24449737,24452304,24491404,24491455,24491476,24491502,24491522,24491547,24491625,24491649,24491674,24505541,24510527,24541329,24541388,24541953,24542200,24542706,24543182,24543841,24544064,24544445,24544817,24545196,24545363,24545673,24545773,24553026,24577384,24577958,24578353,24578387,24610059,24610500,24610816,24611113,24611689,24612147,24612335,24612643,24615323,24616457,24624709,24625056,24632446', 'assoc_port': '23536623:23591588,23537859:23573184,23537860:23584240,23545582:23574686,23545583:23545820,23546914:23574864,23546917:23547192,23548810:23575179,23581987:23582045,23582159:23582320,23582160:23592596,23586389:23595696,23586392:23595945,23587638:23602651,23587640:23602864,23589204:23589355,23673266:23696663,23674635:23674976,23674636:23698443,23707529:23730847,23708171:23731853,23708188:23731899,23708519:23737990,23740008:23748199,23740009:23748487,23740010:23748569,23740011:23744828,23740012:23744413,23812872:23813047,23848986:23849286,23934175:24038487,23934529:23934985,24048013:24167014,24057973:24175430,24089862:24191296,24099617:24210386,24123785:24269722,24132642:24232290,24134842:24232603,24160460:24273068,24206279:24261028,24234490:24271494,24258451:24259737,24258949:24259245,24259897:24260858,24293759:24389395,24293760:24309738,24293763:24309935,24293764:24310529,24296609:24338957,24296616:24339365,24296618:24339466,24297931:24340976,24297932:24341001,24297948:24298514,24297952:24298413,24298468:2429878', 'assoc_mat': '23536623:plastique:3726:23591588,23537859:plastique:3726:23573184,23537860:plastique:3726:23584240,23545582:plastique:3726:23574686,23545583:plastique:3726:23545820,23546914:plastique:3726:23574864,23546917:plastique:3726:23547192,23548810:plastique:3726:23575179,23581987:plastique:3726:23582045,23582159:plastique:3726:23582320,23582160:plastique:3726:23592596,23586389:plastique:3726:23595696,23586392:plastique:3726:23595945,23587638:plastique:3726:23602651,23587640:plastique:3726:23602864,23589204:plastique:3726:23589355,23673266:plastique:3726:23696663,23674635:plastique:3726:23674976,23674636:plastique:3726:23698443,23707529:plastique:3726:23730847,23708171:plastique:3726:23731853,23708188:plastique:3726:23731899,23708519:plastique:3726:23737990,23740008:plastique:3726:23748199,23740009:plastique:3726:23748487,23740010:plastique:3726:23748569,23740011:plastique:3726:23744828,23740012:plastique:3726:23744413,23812872:plastique:3726:23813047,23848986:plastique:3726:23849286,23934175:plastique:3726:24038487,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01975335961692814, 'nb_photo': 5287, 'list_port_cont': '23545828,23547197,23573177,23574683,23574865,23575176,23582040,23582316,23584246,23589350,23591585,23592598,23595701,23595942,23602653,23602869,23674973,23696662,23698445,23730848,23731854,23731901,23737988,23744403,23744829,23748201,23748489,23748560,23813050,23849284,23934978,24038488,24167013,24175428,24191303,24210378,24232301,24232604,24236502,24259239,24259730,24260854,24261029,24269726,24271496,24273064,24298404,24298517,24298791,24309731,24309933,24310527,24338960,24339360,24339464,24340968,24341004,24389390,24420589,24433667,24434017,24436580,24449734,24452294,24491403,24491456,24491474,24491507,24491521,24491551,24491628,24491654,24491672,24505539,24510522,24541328,24541397,24541960,24542194,24542711,24543183,24543844,24544067,24544442,24544826,24545203,24545361,24545671,24545784,24553019,24577386,24577955,24578359,24578380,24610056,24610497,24610805,24611115,24611688,24612148,24612326,24612646,24615321,24616455,24624716,24625057,24632444', 'assoc_port': '23536623:23591585,23537859:23573177,23537860:23584246,23545582:23574683,23545583:23545828,23546914:23574865,23546917:23547197,23548810:23575176,23581987:23582040,23582159:23582316,23582160:23592598,23586389:23595701,23586392:23595942,23587638:23602653,23587640:23602869,23589204:23589350,23673266:23696662,23674635:23674973,23674636:23698445,23707529:23730848,23708171:23731854,23708188:23731901,23708519:23737988,23740008:23748201,23740009:23748489,23740010:23748560,23740011:23744829,23740012:23744403,23812872:23813050,23848986:23849284,23934175:24038488,23934529:23934978,24048013:24167013,24057973:24175428,24089862:24191303,24099617:24210378,24123785:24269726,24132642:24232301,24134842:24232604,24160460:24273064,24167716:24236502,24206279:24261029,24234490:24271496,24258451:24259730,24258949:24259239,24259897:24260854,24293759:24389390,24293760:24309731,24293763:24309933,24293764:24310527,24296609:24338960,24296616:24339360,24296618:24339464,24297931:24340968,24297932:24341004,24297948:24298517,24297952:2429840', 'assoc_mat': '23536623:Teint_Dans_La_Masse:3726:23591585,23537859:Teint_Dans_La_Masse:3726:23573177,23537860:Teint_Dans_La_Masse:3726:23584246,23545582:Teint_Dans_La_Masse:3726:23574683,23545583:Teint_Dans_La_Masse:3726:23545828,23546914:Teint_Dans_La_Masse:3726:23574865,23546917:Teint_Dans_La_Masse:3726:23547197,23548810:Teint_Dans_La_Masse:3726:23575176,23581987:Teint_Dans_La_Masse:3726:23582040,23582159:Teint_Dans_La_Masse:3726:23582316,23582160:Teint_Dans_La_Masse:3726:23592598,23586389:Teint_Dans_La_Masse:3726:23595701,23586392:Teint_Dans_La_Masse:3726:23595942,23587638:Teint_Dans_La_Masse:3726:23602653,23587640:Teint_Dans_La_Masse:3726:23602869,23589204:Teint_Dans_La_Masse:3726:23589350,23673266:Teint_Dans_La_Masse:3726:23696662,23674635:Teint_Dans_La_Masse:3726:23674973,23674636:Teint_Dans_La_Masse:3726:23698445,23707529:Teint_Dans_La_Masse:3726:23730848,23708171:Teint_Dans_La_Masse:3726:23731854,23708188:Teint_Dans_La_Masse:3726:23731901,23708519:Teint_Dans_La_Masse:3726:23737988,23740008:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 7809}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2025-06', 0.12367236403719307),)]} filepath : /data_4/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_06_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.22%', 598], 'cartonnette': ['cartonnette', '1.54%', 2205], 'Carton_brun': ['Carton_brun', '6.77%', 10693], 'Carton_gris': ['Carton_gris', '0.53%', 311], 'kraft': ['kraft', '0.36%', 192], 'metal': ['metal', '0.12%', 21], 'plastique': ['plastique', '0.97%', 1406], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '1.98%', 5287]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_06_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/Perlen_convoyeur 2.93user 2.69system 0:07.20elapsed 78%CPU (0avgtext+0avgdata 194828maxresident)k 9336inputs+336outputs (3major+58611minor)pagefaults 0swaps