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_2/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-01 _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 : (2, 31) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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 : (2, 31) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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 : 01 mtr_id : 1053 dashboard_places : Perlen_convoyeur date : 2025-01 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-01%') and created_at like '%2025-01%'))); nb_day : (2, 31) after unwanted_material_data nb_day : (2, 31) SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%20095%' AND ms.result_str like '%2025/01%'ORDER BY ms.id desc LIMIT 0, 1000000; Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-01-01 00:00:00,2025-01-02 00:00:00,2025-01-03 00:00:00,2025-01-06 00:00:00,2025-01-07 00:00:00,2025-01-08 00:00:00,2025-01-09 00:00:00,2025-01-10 00:00:00,2025-01-13 00:00:00,2025-01-14 00:00:00,2025-01-15 00:00:00,2025-01-16 00:00:00,2025-01-17 00:00:00,2025-01-20 00:00:00,2025-01-21 00:00:00,2025-01-22 00:00:00,2025-01-23 00:00:00,2025-01-24 00:00:00,2025-01-27 00:00:00,2025-01-28 00:00:00,2025-01-29 00:00:00,2025-01-30 00:00:00,2025-01-31 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) = 01 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) = 01 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 '%012025%' and cps.thcl = 1533 GROUP BY sbstr ; Erreur dans le nom de portfolio du batch invalid literal for int() with base 10: 'perlen' after number_of_batch date_start : 2025-01-01 : dt_date_just_month_year : 2025-01-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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-01-01" AND ded.date <= "2025-01-31" apple3 {'JRM': {'mat': 'JRM', 'pht': 3726, 'datou_carac_id': 4433, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'papier'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1519152,1523882,1524075,1526633,1529070,1532150,1535643,1539385,1542847,1543558,1548496,1552617,1557333,1557334,1563548,1569785,1570362,1573239,1576226,1576903) 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.026165055963399166, 'nb_photo': 4443, 'list_port_cont': '19394783,19395205,19397264,19432135,19433608,19433730,19435008,19435610,19435948,19436076,19436365,19436468,19455247,19455960,19458280,19459574,19468010,19468618,19468693,19468924,19473299,19476271,19482330,19482521,19491756,19491993,19494063,19496297,19499242,19499605,19500462,19503075,19503914,19508160,19508881,19510403,19544769,19545585,19548868,19550021,19553999,19554912,19556331,19557998,19572287,19573095,19577890,19580397,19590159,19638076,19646002,19646210,19654378,19674785,19677763,19678334,19686780,19695473,19697436,19700102,19701945,19704689,19713331,19713695,19714143,19717370,19722357,19726466,19726491,19728103,19755354,19764020,19765822,19766191,19768406,19775127,19781361,19792024,19811713,19821604,19823106,19824828,19839372,19839799,19843228,19846397,19864052,19870575,19878796,19886704,19887621,19887752,19890512,19910124,19912320,19913267,19915313,19962503,19976641,19978679,19984679,19991252,20004601,20014975,20019633,20020480,20024729,20029254,20029281,20031722,20032810,20038101,20040655,2004117', 'assoc_port': '19394637:19394783,19395020:19397264,19395021:19395205,19431274:19432135,19431673:19433608,19431676:19433730,19434392:19435948,19434394:19436076,19434805:19436365,19434806:19436468,19434807:19435008,19435271:19435610,19454851:19455247,19455181:19459574,19455593:19458280,19455595:19455960,19467829:19468010,19468128:19468924,19468179:19468618,19468462:19468693,19471096:19482521,19471097:19494063,19472287:19476271,19472288:19482330,19472289:19473299,19488299:19496297,19488789:19491756,19488792:19491993,19499059:19510403,19499060:19508160,19499061:19508881,19499062:19499242,19499063:19499605,19500297:19500462,19500635:19503075,19503772:19503914,19544320:19544769,19544738:19548868,19545173:19545585,19545199:19550021,19550530:19556331,19551458:19557998,19551461:19553999,19554721:19554912,19571837:19572287,19572356:19590159,19572957:19573095,19576282:19577890,19577718:19580397,19632894:19686780,19634656:19678334,19634684:19677763,19636036:19638076,19644474:19646002,19644475:19674785,19645782:19654378,19645783:1964621', 'assoc_mat': '19394637:autre_refus:3726:19394783,19395020:autre_refus:3726:19397264,19395021:autre_refus:3726:19395205,19431274:autre_refus:3726:19432135,19431673:autre_refus:3726:19433608,19431676:autre_refus:3726:19433730,19434392:autre_refus:3726:19435948,19434394:autre_refus:3726:19436076,19434805:autre_refus:3726:19436365,19434806:autre_refus:3726:19436468,19434807:autre_refus:3726:19435008,19435271:autre_refus:3726:19435610,19454851:autre_refus:3726:19455247,19455181:autre_refus:3726:19459574,19455593:autre_refus:3726:19458280,19455595:autre_refus:3726:19455960,19467829:autre_refus:3726:19468010,19468128:autre_refus:3726:19468924,19468179:autre_refus:3726:19468618,19468462:autre_refus:3726:19468693,19471096:autre_refus:3726:19482521,19471097:autre_refus:3726:19494063,19472287:autre_refus:3726:19476271,19472288:autre_refus:3726:19482330,19472289:autre_refus:3726:19473299,19488299:autre_refus:3726:19496297,19488789:autre_refus:3726:19491756,19488792:autre_refus:3726:19491993,19499059:autre_refus:3726:19510403,19499060:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.04053457020100825, 'nb_photo': 15143, 'list_port_cont': '19394782,19395210,19397270,19432136,19433617,19433726,19434999,19435609,19435953,19436072,19436367,19436469,19455251,19455954,19458277,19459575,19468007,19468620,19468700,19468922,19473302,19476268,19482323,19482522,19491751,19491997,19494059,19496292,19499239,19499612,19500454,19503078,19503915,19508167,19508891,19510397,19544770,19545587,19548870,19550019,19553990,19554916,19556332,19558006,19572298,19573091,19577879,19580407,19590168,19638072,19646006,19646212,19654383,19674768,19677771,19678331,19686790,19695474,19697440,19700108,19701941,19704683,19713329,19713696,19714145,19717359,19722354,19726464,19726488,19728110,19755359,19764015,19765827,19766183,19768413,19775130,19781368,19792026,19811706,19821607,19823107,19824825,19839371,19839794,19843230,19846404,19864054,19870580,19878797,19886708,19887620,19887757,19890517,19910129,19912328,19913268,19915312,19962494,19976633,19978678,19984683,19991262,20004593,20014984,20019632,20020487,20024732,20029251,20029280,20031723,20032808,20038096,20040657,2004118', 'assoc_port': '19394637:19394782,19395020:19397270,19395021:19395210,19431274:19432136,19431673:19433617,19431676:19433726,19434392:19435953,19434394:19436072,19434805:19436367,19434806:19436469,19434807:19434999,19435271:19435609,19454851:19455251,19455181:19459575,19455593:19458277,19455595:19455954,19467829:19468007,19468128:19468922,19468179:19468620,19468462:19468700,19471096:19482522,19471097:19494059,19472287:19476268,19472288:19482323,19472289:19473302,19488299:19496292,19488789:19491751,19488792:19491997,19499059:19510397,19499060:19508167,19499061:19508891,19499062:19499239,19499063:19499612,19500297:19500454,19500635:19503078,19503772:19503915,19544320:19544770,19544738:19548870,19545173:19545587,19545199:19550019,19550530:19556332,19551458:19558006,19551461:19553990,19554721:19554916,19571837:19572298,19572356:19590168,19572957:19573091,19576282:19577879,19577718:19580407,19632894:19686790,19634656:19678331,19634684:19677771,19636036:19638072,19644474:19646006,19644475:19674768,19645782:19654383,19645783:1964621', 'assoc_mat': '19394637:cartonnette:3726:19394782,19395020:cartonnette:3726:19397270,19395021:cartonnette:3726:19395210,19431274:cartonnette:3726:19432136,19431673:cartonnette:3726:19433617,19431676:cartonnette:3726:19433726,19434392:cartonnette:3726:19435953,19434394:cartonnette:3726:19436072,19434805:cartonnette:3726:19436367,19434806:cartonnette:3726:19436469,19434807:cartonnette:3726:19434999,19435271:cartonnette:3726:19435609,19454851:cartonnette:3726:19455251,19455181:cartonnette:3726:19459575,19455593:cartonnette:3726:19458277,19455595:cartonnette:3726:19455954,19467829:cartonnette:3726:19468007,19468128:cartonnette:3726:19468922,19468179:cartonnette:3726:19468620,19468462:cartonnette:3726:19468700,19471096:cartonnette:3726:19482522,19471097:cartonnette:3726:19494059,19472287:cartonnette:3726:19476268,19472288:cartonnette:3726:19482323,19472289:cartonnette:3726:19473302,19488299:cartonnette:3726:19496292,19488789:cartonnette:3726:19491751,19488792:cartonnette:3726:19491997,19499059:cartonnette:3726:19510397,19499060:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.025757001049856752, 'nb_photo': 14297, 'list_port_cont': '19394781,19395204,19397269,19432131,19433618,19433734,19435005,19435608,19435951,19436066,19436375,19436466,19455246,19455955,19458272,19459580,19468011,19468624,19468696,19468917,19473298,19476277,19482329,19482519,19491752,19492002,19494054,19496291,19499241,19499609,19500461,19503073,19503912,19508165,19508889,19510405,19544774,19545594,19548875,19550015,19553997,19554908,19556335,19558001,19572289,19573094,19577886,19580406,19590163,19638070,19646009,19646216,19654376,19674790,19677761,19678330,19686786,19695479,19697432,19700106,19701944,19704688,19713335,19713694,19714150,19717365,19722359,19726457,19726489,19728108,19755362,19764022,19765828,19766187,19768407,19775124,19781367,19792029,19811707,19821597,19823111,19824823,19839370,19839798,19843239,19846399,19864050,19870573,19878802,19886703,19887612,19887761,19890509,19910127,19912329,19913277,19915317,19962497,19976642,19978677,19984681,19991257,20004603,20014980,20019636,20020485,20024730,20029250,20029283,20031721,20032812,20038092,20040665,2004117', 'assoc_port': '19394637:19394781,19395020:19397269,19395021:19395204,19431274:19432131,19431673:19433618,19431676:19433734,19434392:19435951,19434394:19436066,19434805:19436375,19434806:19436466,19434807:19435005,19435271:19435608,19454851:19455246,19455181:19459580,19455593:19458272,19455595:19455955,19467829:19468011,19468128:19468917,19468179:19468624,19468462:19468696,19471096:19482519,19471097:19494054,19472287:19476277,19472288:19482329,19472289:19473298,19488299:19496291,19488789:19491752,19488792:19492002,19499059:19510405,19499060:19508165,19499061:19508889,19499062:19499241,19499063:19499609,19500297:19500461,19500635:19503073,19503772:19503912,19544320:19544774,19544738:19548875,19545173:19545594,19545199:19550015,19550530:19556335,19551458:19558001,19551461:19553997,19554721:19554908,19571837:19572289,19572356:19590163,19572957:19573094,19576282:19577886,19577718:19580406,19632894:19686786,19634656:19678330,19634684:19677761,19636036:19638070,19644474:19646009,19644475:19674790,19645782:19654376,19645783:1964621', 'assoc_mat': '19394637:Carton_brun:3726:19394781,19395020:Carton_brun:3726:19397269,19395021:Carton_brun:3726:19395204,19431274:Carton_brun:3726:19432131,19431673:Carton_brun:3726:19433618,19431676:Carton_brun:3726:19433734,19434392:Carton_brun:3726:19435951,19434394:Carton_brun:3726:19436066,19434805:Carton_brun:3726:19436375,19434806:Carton_brun:3726:19436466,19434807:Carton_brun:3726:19435005,19435271:Carton_brun:3726:19435608,19454851:Carton_brun:3726:19455246,19455181:Carton_brun:3726:19459580,19455593:Carton_brun:3726:19458272,19455595:Carton_brun:3726:19455955,19467829:Carton_brun:3726:19468011,19468128:Carton_brun:3726:19468917,19468179:Carton_brun:3726:19468624,19468462:Carton_brun:3726:19468696,19471096:Carton_brun:3726:19482519,19471097:Carton_brun:3726:19494054,19472287:Carton_brun:3726:19476277,19472288:Carton_brun:3726:19482329,19472289:Carton_brun:3726:19473298,19488299:Carton_brun:3726:19496291,19488789:Carton_brun:3726:19491752,19488792:Carton_brun:3726:19492002,19499059:Carton_brun:3726:19510405,19499060:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01592542784980838, 'nb_photo': 3345, 'list_port_cont': '19394784,19395201,19397265,19432133,19433611,19433725,19435003,19435615,19435955,19436067,19436369,19436463,19455249,19455959,19458274,19459577,19468018,19468625,19468691,19468921,19473300,19476274,19482321,19482523,19491757,19491992,19494056,19496289,19499233,19499614,19500460,19503081,19503906,19508163,19508882,19510406,19544771,19545586,19548871,19550020,19553992,19554910,19556338,19558005,19572290,19573092,19577884,19580404,19590165,19638068,19646013,19646211,19654377,19674791,19677767,19678327,19686781,19695475,19697438,19700101,19701943,19704686,19713338,19713702,19714144,19717366,19722355,19726460,19726481,19728111,19755355,19764018,19765826,19766189,19768411,19775128,19781365,19792025,19811709,19821601,19823103,19824827,19839362,19839800,19843234,19846402,19864053,19870578,19878800,19886699,19887622,19887750,19890520,19910123,19912324,19913275,19915308,19962495,19976637,19978683,19984684,19991258,20004596,20014985,20019627,20020484,20024738,20029246,20029276,20031720,20032805,20038095,20040658,2004118', 'assoc_port': '19394637:19394784,19395020:19397265,19395021:19395201,19431274:19432133,19431673:19433611,19431676:19433725,19434392:19435955,19434394:19436067,19434805:19436369,19434806:19436463,19434807:19435003,19435271:19435615,19454851:19455249,19455181:19459577,19455593:19458274,19455595:19455959,19467829:19468018,19468128:19468921,19468179:19468625,19468462:19468691,19471096:19482523,19471097:19494056,19472287:19476274,19472288:19482321,19472289:19473300,19488299:19496289,19488789:19491757,19488792:19491992,19499059:19510406,19499060:19508163,19499061:19508882,19499062:19499233,19499063:19499614,19500297:19500460,19500635:19503081,19503772:19503906,19544320:19544771,19544738:19548871,19545173:19545586,19545199:19550020,19550530:19556338,19551458:19558005,19551461:19553992,19554721:19554910,19571837:19572290,19572356:19590165,19572957:19573092,19576282:19577884,19577718:19580404,19632894:19686781,19634656:19678327,19634684:19677767,19636036:19638068,19644474:19646013,19644475:19674791,19645782:19654377,19645783:1964621', 'assoc_mat': '19394637:Carton_gris:3726:19394784,19395020:Carton_gris:3726:19397265,19395021:Carton_gris:3726:19395201,19431274:Carton_gris:3726:19432133,19431673:Carton_gris:3726:19433611,19431676:Carton_gris:3726:19433725,19434392:Carton_gris:3726:19435955,19434394:Carton_gris:3726:19436067,19434805:Carton_gris:3726:19436369,19434806:Carton_gris:3726:19436463,19434807:Carton_gris:3726:19435003,19435271:Carton_gris:3726:19435615,19454851:Carton_gris:3726:19455249,19455181:Carton_gris:3726:19459577,19455593:Carton_gris:3726:19458274,19455595:Carton_gris:3726:19455959,19467829:Carton_gris:3726:19468018,19468128:Carton_gris:3726:19468921,19468179:Carton_gris:3726:19468625,19468462:Carton_gris:3726:19468691,19471096:Carton_gris:3726:19482523,19471097:Carton_gris:3726:19494056,19472287:Carton_gris:3726:19476274,19472288:Carton_gris:3726:19482321,19472289:Carton_gris:3726:19473300,19488299:Carton_gris:3726:19496289,19488789:Carton_gris:3726:19491757,19488792:Carton_gris:3726:19491992,19499059:Carton_gris:3726:19510406,19499060:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0009941089364134004, 'nb_photo': 313, 'list_port_cont': '19394788,19395199,19397272,19432127,19433609,19433736,19434997,19435614,19435946,19436070,19436464,19455244,19455956,19458270,19468016,19468621,19468695,19476270,19482322,19482526,19491754,19491994,19494057,19496295,19499244,19499610,19500457,19503071,19503910,19508887,19510401,19545593,19548865,19550023,19554913,19556337,19558000,19573089,19577885,19580398,19590161,19646217,19677766,19686791,19697441,19700100,19701951,19704691,19713336,19713698,19714147,19717361,19722350,19726468,19728106,19755363,19765823,19766180,19768416,19775126,19781360,19792033,19811712,19821605,19823102,19824822,19839804,19843238,19864060,19870574,19887613,19887754,19890518,19910119,19912327,19913272,19962501,19976638,19978680,19984676,19991260,20004599,20020489,20024736,20029278,20038094,20040656,20041183,20043556,20045589,20047269,20070809,20071112,20115718,20117135', 'assoc_port': '19394637:19394788,19395020:19397272,19395021:19395199,19431274:19432127,19431673:19433609,19431676:19433736,19434392:19435946,19434394:19436070,19434806:19436464,19434807:19434997,19435271:19435614,19454851:19455244,19455593:19458270,19455595:19455956,19467829:19468016,19468179:19468621,19468462:19468695,19471096:19482526,19471097:19494057,19472287:19476270,19472288:19482322,19488299:19496295,19488789:19491754,19488792:19491994,19499059:19510401,19499061:19508887,19499062:19499244,19499063:19499610,19500297:19500457,19500635:19503071,19503772:19503910,19544738:19548865,19545173:19545593,19545199:19550023,19550530:19556337,19551458:19558000,19554721:19554913,19572356:19590161,19572957:19573089,19576282:19577885,19577718:19580398,19632894:19686791,19634684:19677766,19645783:19646217,19695255:19713336,19695257:19713698,19695260:19714147,19696779:19726468,19697087:19728106,19697089:19700100,19697090:19697441,19700500:19717361,19700501:19722350,19701318:19701951,19704030:19704691,19753347:19755363,19754721:1976582', 'assoc_mat': '19394637:kraft:3726:19394788,19395020:kraft:3726:19397272,19395021:kraft:3726:19395199,19431274:kraft:3726:19432127,19431673:kraft:3726:19433609,19431676:kraft:3726:19433736,19434392:kraft:3726:19435946,19434394:kraft:3726:19436070,19434806:kraft:3726:19436464,19434807:kraft:3726:19434997,19435271:kraft:3726:19435614,19454851:kraft:3726:19455244,19455593:kraft:3726:19458270,19455595:kraft:3726:19455956,19467829:kraft:3726:19468016,19468179:kraft:3726:19468621,19468462:kraft:3726:19468695,19471096:kraft:3726:19482526,19471097:kraft:3726:19494057,19472287:kraft:3726:19476270,19472288:kraft:3726:19482322,19488299:kraft:3726:19496295,19488789:kraft:3726:19491754,19488792:kraft:3726:19491994,19499059:kraft:3726:19510401,19499061:kraft:3726:19508887,19499062:kraft:3726:19499244,19499063:kraft:3726:19499610,19500297:kraft:3726:19500457,19500635:kraft:3726:19503071,19503772:kraft:3726:19503910,19544738:kraft:3726:19548865,19545173:kraft:3726:19545593,19545199:kraft:3726:19550023,19550530:kraft:3726:19556337,19551458:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.027262644683406362, 'nb_photo': 5557, 'list_port_cont': '19394778,19395209,19397267,19432129,19433615,19433733,19435001,19435607,19435956,19436073,19436376,19436467,19455250,19455961,19458279,19459582,19468012,19468619,19468698,19468919,19473296,19476269,19482328,19482515,19491749,19491999,19494062,19496298,19499235,19499603,19500452,19503080,19503908,19508168,19508884,19510395,19544765,19545589,19548873,19550018,19553994,19554915,19556341,19558004,19572291,19573087,19577881,19580399,19590167,19638073,19646003,19646213,19654373,19674777,19677764,19678329,19686784,19695481,19697433,19700107,19701946,19704685,19713328,19713699,19714148,19717362,19722351,19726462,19726492,19728105,19755353,19764025,19765821,19766184,19768415,19775131,19781366,19792035,19811710,19821598,19823101,19824820,19839365,19839793,19843231,19846394,19864056,19870572,19878799,19886707,19887614,19887760,19890516,19910128,19912321,19913270,19915315,19962502,19976634,19978681,19984682,19991255,20004602,20014978,20019635,20020483,20024737,20029252,20029277,20031719,20032802,20038091,20040661,2004117', 'assoc_port': '19394637:19394778,19395020:19397267,19395021:19395209,19431274:19432129,19431673:19433615,19431676:19433733,19434392:19435956,19434394:19436073,19434805:19436376,19434806:19436467,19434807:19435001,19435271:19435607,19454851:19455250,19455181:19459582,19455593:19458279,19455595:19455961,19467829:19468012,19468128:19468919,19468179:19468619,19468462:19468698,19471096:19482515,19471097:19494062,19472287:19476269,19472288:19482328,19472289:19473296,19488299:19496298,19488789:19491749,19488792:19491999,19499059:19510395,19499060:19508168,19499061:19508884,19499062:19499235,19499063:19499603,19500297:19500452,19500635:19503080,19503772:19503908,19544320:19544765,19544738:19548873,19545173:19545589,19545199:19550018,19550530:19556341,19551458:19558004,19551461:19553994,19554721:19554915,19571837:19572291,19572356:19590167,19572957:19573087,19576282:19577881,19577718:19580399,19632894:19686784,19634656:19678329,19634684:19677764,19636036:19638073,19644474:19646003,19644475:19674777,19645782:19654373,19645783:1964621', 'assoc_mat': '19394637:plastique:3726:19394778,19395020:plastique:3726:19397267,19395021:plastique:3726:19395209,19431274:plastique:3726:19432129,19431673:plastique:3726:19433615,19431676:plastique:3726:19433733,19434392:plastique:3726:19435956,19434394:plastique:3726:19436073,19434805:plastique:3726:19436376,19434806:plastique:3726:19436467,19434807:plastique:3726:19435001,19435271:plastique:3726:19435607,19454851:plastique:3726:19455250,19455181:plastique:3726:19459582,19455593:plastique:3726:19458279,19455595:plastique:3726:19455961,19467829:plastique:3726:19468012,19468128:plastique:3726:19468919,19468179:plastique:3726:19468619,19468462:plastique:3726:19468698,19471096:plastique:3726:19482515,19471097:plastique:3726:19494062,19472287:plastique:3726:19476269,19472288:plastique:3726:19482328,19472289:plastique:3726:19473296,19488299:plastique:3726:19496298,19488789:plastique:3726:19491749,19488792:plastique:3726:19491999,19499059:plastique:3726:19510395,19499060:plastique:3726:19508168,19499061:plastique:3726:19508884,1'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.021254624915112017, 'nb_photo': 8369, 'list_port_cont': '19394779,19395202,19397268,19432125,19433612,19433728,19435002,19435612,19435950,19436074,19436374,19436470,19455241,19455951,19458275,19459581,19468008,19468623,19468697,19468928,19473294,19476272,19482319,19482525,19491755,19491998,19494061,19496294,19499237,19499611,19500456,19503070,19503907,19508164,19508886,19510399,19544766,19545590,19548866,19550025,19553989,19554917,19556339,19558007,19572295,19573090,19577887,19580403,19590160,19638069,19646005,19646206,19654384,19674783,19677772,19678328,19686787,19695478,19697434,19700104,19701949,19704690,19713332,19713703,19714140,19717369,19722353,19726463,19726484,19728107,19755364,19764024,19765819,19766185,19768410,19775125,19781362,19792028,19811705,19821603,19823105,19824826,19839361,19839795,19843235,19846403,19864057,19870579,19878801,19886709,19887611,19887755,19890515,19910120,19912323,19913276,19915311,19962505,19976632,19978682,19984678,19991254,20004597,20014977,20019619,20020481,20024739,20029256,20029282,20031725,20032809,20038093,20040659,2004117', 'assoc_port': '19394637:19394779,19395020:19397268,19395021:19395202,19431274:19432125,19431673:19433612,19431676:19433728,19434392:19435950,19434394:19436074,19434805:19436374,19434806:19436470,19434807:19435002,19435271:19435612,19454851:19455241,19455181:19459581,19455593:19458275,19455595:19455951,19467829:19468008,19468128:19468928,19468179:19468623,19468462:19468697,19471096:19482525,19471097:19494061,19472287:19476272,19472288:19482319,19472289:19473294,19488299:19496294,19488789:19491755,19488792:19491998,19499059:19510399,19499060:19508164,19499061:19508886,19499062:19499237,19499063:19499611,19500297:19500456,19500635:19503070,19503772:19503907,19544320:19544766,19544738:19548866,19545173:19545590,19545199:19550025,19550530:19556339,19551458:19558007,19551461:19553989,19554721:19554917,19571837:19572295,19572356:19590160,19572957:19573090,19576282:19577887,19577718:19580403,19632894:19686787,19634656:19678328,19634684:19677772,19636036:19638069,19644474:19646005,19644475:19674783,19645782:19654384,19645783:1964620', 'assoc_mat': '19394637:Teint_Dans_La_Masse:3726:19394779,19395020:Teint_Dans_La_Masse:3726:19397268,19395021:Teint_Dans_La_Masse:3726:19395202,19431274:Teint_Dans_La_Masse:3726:19432125,19431673:Teint_Dans_La_Masse:3726:19433612,19431676:Teint_Dans_La_Masse:3726:19433728,19434392:Teint_Dans_La_Masse:3726:19435950,19434394:Teint_Dans_La_Masse:3726:19436074,19434805:Teint_Dans_La_Masse:3726:19436374,19434806:Teint_Dans_La_Masse:3726:19436470,19434807:Teint_Dans_La_Masse:3726:19435002,19435271:Teint_Dans_La_Masse:3726:19435612,19454851:Teint_Dans_La_Masse:3726:19455241,19455181:Teint_Dans_La_Masse:3726:19459581,19455593:Teint_Dans_La_Masse:3726:19458275,19455595:Teint_Dans_La_Masse:3726:19455951,19467829:Teint_Dans_La_Masse:3726:19468008,19468128:Teint_Dans_La_Masse:3726:19468928,19468179:Teint_Dans_La_Masse:3726:19468623,19468462:Teint_Dans_La_Masse:3726:19468697,19471096:Teint_Dans_La_Masse:3726:19482525,19471097:Teint_Dans_La_Masse:3726:19494061,19472287:Teint_Dans_La_Masse:3726:19476272,19472288:Teint_Dans_La_Masse:3726:1'}) 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(1519152,1523882,1524075,1526633,1529070,1532150,1535643,1539385,1542847,1543558,1548496,1552617,1557333,1557334,1563548,1569785,1570362,1573239,1576226,1576903)); 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-01-01' and date <= '2025-01-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((8667,),), 'unwanted_material_monthly_percentage': ((0.13595897162329176,),), 'material_repartition': (('JRM', 8667),), 'material_dict': {'JRM': 8667}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 1, 3), 0.04907321841328218, 288), (datetime.date(2025, 1, 6), 0.040134053960125315, 531), (datetime.date(2025, 1, 7), 0.18315196439745712, 283), (datetime.date(2025, 1, 8), 0.13048497663506636, 614), (datetime.date(2025, 1, 9), 0.13473864931194962, 532), (datetime.date(2025, 1, 10), 0.1894067954200693, 235), (datetime.date(2025, 1, 13), 0.12938004056078953, 616), (datetime.date(2025, 1, 14), 0.15819673479147872, 315), (datetime.date(2025, 1, 15), 0.15836835321056597, 560), (datetime.date(2025, 1, 16), 0.13275932432633594, 587), (datetime.date(2025, 1, 17), 0.10535333722984483, 309), (datetime.date(2025, 1, 20), 0.17741051573109973, 545), (datetime.date(2025, 1, 22), 0.1479127540808, 508), (datetime.date(2025, 1, 23), 0.1562433521320552, 581), (datetime.date(2025, 1, 24), 0.13146133344409378, 281), (datetime.date(2025, 1, 27), 0.12609188240367877, 491), (datetime.date(2025, 1, 28), 0.15789654977785797, 486), (datetime.date(2025, 1, 29), 0.1579324844324773, 585), (datetime.date(2025, 1, 30), 0.20504672488504902, 30), (datetime.date(2025, 1, 31), 0.1268512627463249, 290)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 1, 3), 0.04907321841328218, 288), (datetime.date(2025, 1, 6), 0.040134053960125315, 531), (datetime.date(2025, 1, 7), 0.18315196439745712, 283), (datetime.date(2025, 1, 8), 0.13048497663506636, 614), (datetime.date(2025, 1, 9), 0.13473864931194962, 532), (datetime.date(2025, 1, 10), 0.1894067954200693, 235), (datetime.date(2025, 1, 13), 0.12938004056078953, 616), (datetime.date(2025, 1, 14), 0.15819673479147872, 315), (datetime.date(2025, 1, 15), 0.15836835321056597, 560), (datetime.date(2025, 1, 16), 0.13275932432633594, 587), (datetime.date(2025, 1, 17), 0.10535333722984483, 309), (datetime.date(2025, 1, 20), 0.17741051573109973, 545), (datetime.date(2025, 1, 22), 0.1479127540808, 508), (datetime.date(2025, 1, 23), 0.1562433521320552, 581), (datetime.date(2025, 1, 24), 0.13146133344409378, 281), (datetime.date(2025, 1, 27), 0.12609188240367877, 491), (datetime.date(2025, 1, 28), 0.15789654977785797, 486), (datetime.date(2025, 1, 29), 0.1579324844324773, 585), (datetime.date(2025, 1, 30), 0.20504672488504902, 30), (datetime.date(2025, 1, 31), 0.1268512627463249, 290))}, 'quality_array': [['0.6784785437463524', '03012025'], ['0.4876419485593672', '06012025'], ['0.060611871519429046', '07012025'], ['0.6690403600870028', '08012025'], ['0.3478461936828805', '09012025'], ['0.4952687225121936', '10012025'], ['0.6874503737366016', '13012025'], ['0.7716467717387825', '14012025'], ['0.5391753491894069', '15012025'], ['0.6696237180439134', '16012025'], ['0.7603496560958662', '17012025'], ['0.6306837496519877', '20012025'], ['0.7357941185119705', '22012025'], ['1.0233687033844272', '23012025'], ['0.7037121508584268', '24012025'], ['0.5635079487338653', '27012025'], ['0.7956590449610412', '28012025'], ['0.6772887036423657', '29012025'], ['0.7347631145126714', '30012025'], ['0.8715396631763487', '31012025']], 'number_of_batch': ((125,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.026165055963399166, 'nb_photo': 4443, 'list_port_cont': '19394783,19395205,19397264,19432135,19433608,19433730,19435008,19435610,19435948,19436076,19436365,19436468,19455247,19455960,19458280,19459574,19468010,19468618,19468693,19468924,19473299,19476271,19482330,19482521,19491756,19491993,19494063,19496297,19499242,19499605,19500462,19503075,19503914,19508160,19508881,19510403,19544769,19545585,19548868,19550021,19553999,19554912,19556331,19557998,19572287,19573095,19577890,19580397,19590159,19638076,19646002,19646210,19654378,19674785,19677763,19678334,19686780,19695473,19697436,19700102,19701945,19704689,19713331,19713695,19714143,19717370,19722357,19726466,19726491,19728103,19755354,19764020,19765822,19766191,19768406,19775127,19781361,19792024,19811713,19821604,19823106,19824828,19839372,19839799,19843228,19846397,19864052,19870575,19878796,19886704,19887621,19887752,19890512,19910124,19912320,19913267,19915313,19962503,19976641,19978679,19984679,19991252,20004601,20014975,20019633,20020480,20024729,20029254,20029281,20031722,20032810,20038101,20040655,2004117', 'assoc_port': '19394637:19394783,19395020:19397264,19395021:19395205,19431274:19432135,19431673:19433608,19431676:19433730,19434392:19435948,19434394:19436076,19434805:19436365,19434806:19436468,19434807:19435008,19435271:19435610,19454851:19455247,19455181:19459574,19455593:19458280,19455595:19455960,19467829:19468010,19468128:19468924,19468179:19468618,19468462:19468693,19471096:19482521,19471097:19494063,19472287:19476271,19472288:19482330,19472289:19473299,19488299:19496297,19488789:19491756,19488792:19491993,19499059:19510403,19499060:19508160,19499061:19508881,19499062:19499242,19499063:19499605,19500297:19500462,19500635:19503075,19503772:19503914,19544320:19544769,19544738:19548868,19545173:19545585,19545199:19550021,19550530:19556331,19551458:19557998,19551461:19553999,19554721:19554912,19571837:19572287,19572356:19590159,19572957:19573095,19576282:19577890,19577718:19580397,19632894:19686780,19634656:19678334,19634684:19677763,19636036:19638076,19644474:19646002,19644475:19674785,19645782:19654378,19645783:1964621', 'assoc_mat': '19394637:autre_refus:3726:19394783,19395020:autre_refus:3726:19397264,19395021:autre_refus:3726:19395205,19431274:autre_refus:3726:19432135,19431673:autre_refus:3726:19433608,19431676:autre_refus:3726:19433730,19434392:autre_refus:3726:19435948,19434394:autre_refus:3726:19436076,19434805:autre_refus:3726:19436365,19434806:autre_refus:3726:19436468,19434807:autre_refus:3726:19435008,19435271:autre_refus:3726:19435610,19454851:autre_refus:3726:19455247,19455181:autre_refus:3726:19459574,19455593:autre_refus:3726:19458280,19455595:autre_refus:3726:19455960,19467829:autre_refus:3726:19468010,19468128:autre_refus:3726:19468924,19468179:autre_refus:3726:19468618,19468462:autre_refus:3726:19468693,19471096:autre_refus:3726:19482521,19471097:autre_refus:3726:19494063,19472287:autre_refus:3726:19476271,19472288:autre_refus:3726:19482330,19472289:autre_refus:3726:19473299,19488299:autre_refus:3726:19496297,19488789:autre_refus:3726:19491756,19488792:autre_refus:3726:19491993,19499059:autre_refus:3726:19510403,19499060:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.04053457020100825, 'nb_photo': 15143, 'list_port_cont': '19394782,19395210,19397270,19432136,19433617,19433726,19434999,19435609,19435953,19436072,19436367,19436469,19455251,19455954,19458277,19459575,19468007,19468620,19468700,19468922,19473302,19476268,19482323,19482522,19491751,19491997,19494059,19496292,19499239,19499612,19500454,19503078,19503915,19508167,19508891,19510397,19544770,19545587,19548870,19550019,19553990,19554916,19556332,19558006,19572298,19573091,19577879,19580407,19590168,19638072,19646006,19646212,19654383,19674768,19677771,19678331,19686790,19695474,19697440,19700108,19701941,19704683,19713329,19713696,19714145,19717359,19722354,19726464,19726488,19728110,19755359,19764015,19765827,19766183,19768413,19775130,19781368,19792026,19811706,19821607,19823107,19824825,19839371,19839794,19843230,19846404,19864054,19870580,19878797,19886708,19887620,19887757,19890517,19910129,19912328,19913268,19915312,19962494,19976633,19978678,19984683,19991262,20004593,20014984,20019632,20020487,20024732,20029251,20029280,20031723,20032808,20038096,20040657,2004118', 'assoc_port': '19394637:19394782,19395020:19397270,19395021:19395210,19431274:19432136,19431673:19433617,19431676:19433726,19434392:19435953,19434394:19436072,19434805:19436367,19434806:19436469,19434807:19434999,19435271:19435609,19454851:19455251,19455181:19459575,19455593:19458277,19455595:19455954,19467829:19468007,19468128:19468922,19468179:19468620,19468462:19468700,19471096:19482522,19471097:19494059,19472287:19476268,19472288:19482323,19472289:19473302,19488299:19496292,19488789:19491751,19488792:19491997,19499059:19510397,19499060:19508167,19499061:19508891,19499062:19499239,19499063:19499612,19500297:19500454,19500635:19503078,19503772:19503915,19544320:19544770,19544738:19548870,19545173:19545587,19545199:19550019,19550530:19556332,19551458:19558006,19551461:19553990,19554721:19554916,19571837:19572298,19572356:19590168,19572957:19573091,19576282:19577879,19577718:19580407,19632894:19686790,19634656:19678331,19634684:19677771,19636036:19638072,19644474:19646006,19644475:19674768,19645782:19654383,19645783:1964621', 'assoc_mat': '19394637:cartonnette:3726:19394782,19395020:cartonnette:3726:19397270,19395021:cartonnette:3726:19395210,19431274:cartonnette:3726:19432136,19431673:cartonnette:3726:19433617,19431676:cartonnette:3726:19433726,19434392:cartonnette:3726:19435953,19434394:cartonnette:3726:19436072,19434805:cartonnette:3726:19436367,19434806:cartonnette:3726:19436469,19434807:cartonnette:3726:19434999,19435271:cartonnette:3726:19435609,19454851:cartonnette:3726:19455251,19455181:cartonnette:3726:19459575,19455593:cartonnette:3726:19458277,19455595:cartonnette:3726:19455954,19467829:cartonnette:3726:19468007,19468128:cartonnette:3726:19468922,19468179:cartonnette:3726:19468620,19468462:cartonnette:3726:19468700,19471096:cartonnette:3726:19482522,19471097:cartonnette:3726:19494059,19472287:cartonnette:3726:19476268,19472288:cartonnette:3726:19482323,19472289:cartonnette:3726:19473302,19488299:cartonnette:3726:19496292,19488789:cartonnette:3726:19491751,19488792:cartonnette:3726:19491997,19499059:cartonnette:3726:19510397,19499060:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.025757001049856752, 'nb_photo': 14297, 'list_port_cont': '19394781,19395204,19397269,19432131,19433618,19433734,19435005,19435608,19435951,19436066,19436375,19436466,19455246,19455955,19458272,19459580,19468011,19468624,19468696,19468917,19473298,19476277,19482329,19482519,19491752,19492002,19494054,19496291,19499241,19499609,19500461,19503073,19503912,19508165,19508889,19510405,19544774,19545594,19548875,19550015,19553997,19554908,19556335,19558001,19572289,19573094,19577886,19580406,19590163,19638070,19646009,19646216,19654376,19674790,19677761,19678330,19686786,19695479,19697432,19700106,19701944,19704688,19713335,19713694,19714150,19717365,19722359,19726457,19726489,19728108,19755362,19764022,19765828,19766187,19768407,19775124,19781367,19792029,19811707,19821597,19823111,19824823,19839370,19839798,19843239,19846399,19864050,19870573,19878802,19886703,19887612,19887761,19890509,19910127,19912329,19913277,19915317,19962497,19976642,19978677,19984681,19991257,20004603,20014980,20019636,20020485,20024730,20029250,20029283,20031721,20032812,20038092,20040665,2004117', 'assoc_port': '19394637:19394781,19395020:19397269,19395021:19395204,19431274:19432131,19431673:19433618,19431676:19433734,19434392:19435951,19434394:19436066,19434805:19436375,19434806:19436466,19434807:19435005,19435271:19435608,19454851:19455246,19455181:19459580,19455593:19458272,19455595:19455955,19467829:19468011,19468128:19468917,19468179:19468624,19468462:19468696,19471096:19482519,19471097:19494054,19472287:19476277,19472288:19482329,19472289:19473298,19488299:19496291,19488789:19491752,19488792:19492002,19499059:19510405,19499060:19508165,19499061:19508889,19499062:19499241,19499063:19499609,19500297:19500461,19500635:19503073,19503772:19503912,19544320:19544774,19544738:19548875,19545173:19545594,19545199:19550015,19550530:19556335,19551458:19558001,19551461:19553997,19554721:19554908,19571837:19572289,19572356:19590163,19572957:19573094,19576282:19577886,19577718:19580406,19632894:19686786,19634656:19678330,19634684:19677761,19636036:19638070,19644474:19646009,19644475:19674790,19645782:19654376,19645783:1964621', 'assoc_mat': '19394637:Carton_brun:3726:19394781,19395020:Carton_brun:3726:19397269,19395021:Carton_brun:3726:19395204,19431274:Carton_brun:3726:19432131,19431673:Carton_brun:3726:19433618,19431676:Carton_brun:3726:19433734,19434392:Carton_brun:3726:19435951,19434394:Carton_brun:3726:19436066,19434805:Carton_brun:3726:19436375,19434806:Carton_brun:3726:19436466,19434807:Carton_brun:3726:19435005,19435271:Carton_brun:3726:19435608,19454851:Carton_brun:3726:19455246,19455181:Carton_brun:3726:19459580,19455593:Carton_brun:3726:19458272,19455595:Carton_brun:3726:19455955,19467829:Carton_brun:3726:19468011,19468128:Carton_brun:3726:19468917,19468179:Carton_brun:3726:19468624,19468462:Carton_brun:3726:19468696,19471096:Carton_brun:3726:19482519,19471097:Carton_brun:3726:19494054,19472287:Carton_brun:3726:19476277,19472288:Carton_brun:3726:19482329,19472289:Carton_brun:3726:19473298,19488299:Carton_brun:3726:19496291,19488789:Carton_brun:3726:19491752,19488792:Carton_brun:3726:19492002,19499059:Carton_brun:3726:19510405,19499060:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01592542784980838, 'nb_photo': 3345, 'list_port_cont': '19394784,19395201,19397265,19432133,19433611,19433725,19435003,19435615,19435955,19436067,19436369,19436463,19455249,19455959,19458274,19459577,19468018,19468625,19468691,19468921,19473300,19476274,19482321,19482523,19491757,19491992,19494056,19496289,19499233,19499614,19500460,19503081,19503906,19508163,19508882,19510406,19544771,19545586,19548871,19550020,19553992,19554910,19556338,19558005,19572290,19573092,19577884,19580404,19590165,19638068,19646013,19646211,19654377,19674791,19677767,19678327,19686781,19695475,19697438,19700101,19701943,19704686,19713338,19713702,19714144,19717366,19722355,19726460,19726481,19728111,19755355,19764018,19765826,19766189,19768411,19775128,19781365,19792025,19811709,19821601,19823103,19824827,19839362,19839800,19843234,19846402,19864053,19870578,19878800,19886699,19887622,19887750,19890520,19910123,19912324,19913275,19915308,19962495,19976637,19978683,19984684,19991258,20004596,20014985,20019627,20020484,20024738,20029246,20029276,20031720,20032805,20038095,20040658,2004118', 'assoc_port': '19394637:19394784,19395020:19397265,19395021:19395201,19431274:19432133,19431673:19433611,19431676:19433725,19434392:19435955,19434394:19436067,19434805:19436369,19434806:19436463,19434807:19435003,19435271:19435615,19454851:19455249,19455181:19459577,19455593:19458274,19455595:19455959,19467829:19468018,19468128:19468921,19468179:19468625,19468462:19468691,19471096:19482523,19471097:19494056,19472287:19476274,19472288:19482321,19472289:19473300,19488299:19496289,19488789:19491757,19488792:19491992,19499059:19510406,19499060:19508163,19499061:19508882,19499062:19499233,19499063:19499614,19500297:19500460,19500635:19503081,19503772:19503906,19544320:19544771,19544738:19548871,19545173:19545586,19545199:19550020,19550530:19556338,19551458:19558005,19551461:19553992,19554721:19554910,19571837:19572290,19572356:19590165,19572957:19573092,19576282:19577884,19577718:19580404,19632894:19686781,19634656:19678327,19634684:19677767,19636036:19638068,19644474:19646013,19644475:19674791,19645782:19654377,19645783:1964621', 'assoc_mat': '19394637:Carton_gris:3726:19394784,19395020:Carton_gris:3726:19397265,19395021:Carton_gris:3726:19395201,19431274:Carton_gris:3726:19432133,19431673:Carton_gris:3726:19433611,19431676:Carton_gris:3726:19433725,19434392:Carton_gris:3726:19435955,19434394:Carton_gris:3726:19436067,19434805:Carton_gris:3726:19436369,19434806:Carton_gris:3726:19436463,19434807:Carton_gris:3726:19435003,19435271:Carton_gris:3726:19435615,19454851:Carton_gris:3726:19455249,19455181:Carton_gris:3726:19459577,19455593:Carton_gris:3726:19458274,19455595:Carton_gris:3726:19455959,19467829:Carton_gris:3726:19468018,19468128:Carton_gris:3726:19468921,19468179:Carton_gris:3726:19468625,19468462:Carton_gris:3726:19468691,19471096:Carton_gris:3726:19482523,19471097:Carton_gris:3726:19494056,19472287:Carton_gris:3726:19476274,19472288:Carton_gris:3726:19482321,19472289:Carton_gris:3726:19473300,19488299:Carton_gris:3726:19496289,19488789:Carton_gris:3726:19491757,19488792:Carton_gris:3726:19491992,19499059:Carton_gris:3726:19510406,19499060:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0009941089364134004, 'nb_photo': 313, 'list_port_cont': '19394788,19395199,19397272,19432127,19433609,19433736,19434997,19435614,19435946,19436070,19436464,19455244,19455956,19458270,19468016,19468621,19468695,19476270,19482322,19482526,19491754,19491994,19494057,19496295,19499244,19499610,19500457,19503071,19503910,19508887,19510401,19545593,19548865,19550023,19554913,19556337,19558000,19573089,19577885,19580398,19590161,19646217,19677766,19686791,19697441,19700100,19701951,19704691,19713336,19713698,19714147,19717361,19722350,19726468,19728106,19755363,19765823,19766180,19768416,19775126,19781360,19792033,19811712,19821605,19823102,19824822,19839804,19843238,19864060,19870574,19887613,19887754,19890518,19910119,19912327,19913272,19962501,19976638,19978680,19984676,19991260,20004599,20020489,20024736,20029278,20038094,20040656,20041183,20043556,20045589,20047269,20070809,20071112,20115718,20117135', 'assoc_port': '19394637:19394788,19395020:19397272,19395021:19395199,19431274:19432127,19431673:19433609,19431676:19433736,19434392:19435946,19434394:19436070,19434806:19436464,19434807:19434997,19435271:19435614,19454851:19455244,19455593:19458270,19455595:19455956,19467829:19468016,19468179:19468621,19468462:19468695,19471096:19482526,19471097:19494057,19472287:19476270,19472288:19482322,19488299:19496295,19488789:19491754,19488792:19491994,19499059:19510401,19499061:19508887,19499062:19499244,19499063:19499610,19500297:19500457,19500635:19503071,19503772:19503910,19544738:19548865,19545173:19545593,19545199:19550023,19550530:19556337,19551458:19558000,19554721:19554913,19572356:19590161,19572957:19573089,19576282:19577885,19577718:19580398,19632894:19686791,19634684:19677766,19645783:19646217,19695255:19713336,19695257:19713698,19695260:19714147,19696779:19726468,19697087:19728106,19697089:19700100,19697090:19697441,19700500:19717361,19700501:19722350,19701318:19701951,19704030:19704691,19753347:19755363,19754721:1976582', 'assoc_mat': '19394637:kraft:3726:19394788,19395020:kraft:3726:19397272,19395021:kraft:3726:19395199,19431274:kraft:3726:19432127,19431673:kraft:3726:19433609,19431676:kraft:3726:19433736,19434392:kraft:3726:19435946,19434394:kraft:3726:19436070,19434806:kraft:3726:19436464,19434807:kraft:3726:19434997,19435271:kraft:3726:19435614,19454851:kraft:3726:19455244,19455593:kraft:3726:19458270,19455595:kraft:3726:19455956,19467829:kraft:3726:19468016,19468179:kraft:3726:19468621,19468462:kraft:3726:19468695,19471096:kraft:3726:19482526,19471097:kraft:3726:19494057,19472287:kraft:3726:19476270,19472288:kraft:3726:19482322,19488299:kraft:3726:19496295,19488789:kraft:3726:19491754,19488792:kraft:3726:19491994,19499059:kraft:3726:19510401,19499061:kraft:3726:19508887,19499062:kraft:3726:19499244,19499063:kraft:3726:19499610,19500297:kraft:3726:19500457,19500635:kraft:3726:19503071,19503772:kraft:3726:19503910,19544738:kraft:3726:19548865,19545173:kraft:3726:19545593,19545199:kraft:3726:19550023,19550530:kraft:3726:19556337,19551458:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.027262644683406362, 'nb_photo': 5557, 'list_port_cont': '19394778,19395209,19397267,19432129,19433615,19433733,19435001,19435607,19435956,19436073,19436376,19436467,19455250,19455961,19458279,19459582,19468012,19468619,19468698,19468919,19473296,19476269,19482328,19482515,19491749,19491999,19494062,19496298,19499235,19499603,19500452,19503080,19503908,19508168,19508884,19510395,19544765,19545589,19548873,19550018,19553994,19554915,19556341,19558004,19572291,19573087,19577881,19580399,19590167,19638073,19646003,19646213,19654373,19674777,19677764,19678329,19686784,19695481,19697433,19700107,19701946,19704685,19713328,19713699,19714148,19717362,19722351,19726462,19726492,19728105,19755353,19764025,19765821,19766184,19768415,19775131,19781366,19792035,19811710,19821598,19823101,19824820,19839365,19839793,19843231,19846394,19864056,19870572,19878799,19886707,19887614,19887760,19890516,19910128,19912321,19913270,19915315,19962502,19976634,19978681,19984682,19991255,20004602,20014978,20019635,20020483,20024737,20029252,20029277,20031719,20032802,20038091,20040661,2004117', 'assoc_port': '19394637:19394778,19395020:19397267,19395021:19395209,19431274:19432129,19431673:19433615,19431676:19433733,19434392:19435956,19434394:19436073,19434805:19436376,19434806:19436467,19434807:19435001,19435271:19435607,19454851:19455250,19455181:19459582,19455593:19458279,19455595:19455961,19467829:19468012,19468128:19468919,19468179:19468619,19468462:19468698,19471096:19482515,19471097:19494062,19472287:19476269,19472288:19482328,19472289:19473296,19488299:19496298,19488789:19491749,19488792:19491999,19499059:19510395,19499060:19508168,19499061:19508884,19499062:19499235,19499063:19499603,19500297:19500452,19500635:19503080,19503772:19503908,19544320:19544765,19544738:19548873,19545173:19545589,19545199:19550018,19550530:19556341,19551458:19558004,19551461:19553994,19554721:19554915,19571837:19572291,19572356:19590167,19572957:19573087,19576282:19577881,19577718:19580399,19632894:19686784,19634656:19678329,19634684:19677764,19636036:19638073,19644474:19646003,19644475:19674777,19645782:19654373,19645783:1964621', 'assoc_mat': '19394637:plastique:3726:19394778,19395020:plastique:3726:19397267,19395021:plastique:3726:19395209,19431274:plastique:3726:19432129,19431673:plastique:3726:19433615,19431676:plastique:3726:19433733,19434392:plastique:3726:19435956,19434394:plastique:3726:19436073,19434805:plastique:3726:19436376,19434806:plastique:3726:19436467,19434807:plastique:3726:19435001,19435271:plastique:3726:19435607,19454851:plastique:3726:19455250,19455181:plastique:3726:19459582,19455593:plastique:3726:19458279,19455595:plastique:3726:19455961,19467829:plastique:3726:19468012,19468128:plastique:3726:19468919,19468179:plastique:3726:19468619,19468462:plastique:3726:19468698,19471096:plastique:3726:19482515,19471097:plastique:3726:19494062,19472287:plastique:3726:19476269,19472288:plastique:3726:19482328,19472289:plastique:3726:19473296,19488299:plastique:3726:19496298,19488789:plastique:3726:19491749,19488792:plastique:3726:19491999,19499059:plastique:3726:19510395,19499060:plastique:3726:19508168,19499061:plastique:3726:19508884,1'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.021254624915112017, 'nb_photo': 8369, 'list_port_cont': '19394779,19395202,19397268,19432125,19433612,19433728,19435002,19435612,19435950,19436074,19436374,19436470,19455241,19455951,19458275,19459581,19468008,19468623,19468697,19468928,19473294,19476272,19482319,19482525,19491755,19491998,19494061,19496294,19499237,19499611,19500456,19503070,19503907,19508164,19508886,19510399,19544766,19545590,19548866,19550025,19553989,19554917,19556339,19558007,19572295,19573090,19577887,19580403,19590160,19638069,19646005,19646206,19654384,19674783,19677772,19678328,19686787,19695478,19697434,19700104,19701949,19704690,19713332,19713703,19714140,19717369,19722353,19726463,19726484,19728107,19755364,19764024,19765819,19766185,19768410,19775125,19781362,19792028,19811705,19821603,19823105,19824826,19839361,19839795,19843235,19846403,19864057,19870579,19878801,19886709,19887611,19887755,19890515,19910120,19912323,19913276,19915311,19962505,19976632,19978682,19984678,19991254,20004597,20014977,20019619,20020481,20024739,20029256,20029282,20031725,20032809,20038093,20040659,2004117', 'assoc_port': '19394637:19394779,19395020:19397268,19395021:19395202,19431274:19432125,19431673:19433612,19431676:19433728,19434392:19435950,19434394:19436074,19434805:19436374,19434806:19436470,19434807:19435002,19435271:19435612,19454851:19455241,19455181:19459581,19455593:19458275,19455595:19455951,19467829:19468008,19468128:19468928,19468179:19468623,19468462:19468697,19471096:19482525,19471097:19494061,19472287:19476272,19472288:19482319,19472289:19473294,19488299:19496294,19488789:19491755,19488792:19491998,19499059:19510399,19499060:19508164,19499061:19508886,19499062:19499237,19499063:19499611,19500297:19500456,19500635:19503070,19503772:19503907,19544320:19544766,19544738:19548866,19545173:19545590,19545199:19550025,19550530:19556339,19551458:19558007,19551461:19553989,19554721:19554917,19571837:19572295,19572356:19590160,19572957:19573090,19576282:19577887,19577718:19580403,19632894:19686787,19634656:19678328,19634684:19677772,19636036:19638069,19644474:19646005,19644475:19674783,19645782:19654384,19645783:1964620', 'assoc_mat': '19394637:Teint_Dans_La_Masse:3726:19394779,19395020:Teint_Dans_La_Masse:3726:19397268,19395021:Teint_Dans_La_Masse:3726:19395202,19431274:Teint_Dans_La_Masse:3726:19432125,19431673:Teint_Dans_La_Masse:3726:19433612,19431676:Teint_Dans_La_Masse:3726:19433728,19434392:Teint_Dans_La_Masse:3726:19435950,19434394:Teint_Dans_La_Masse:3726:19436074,19434805:Teint_Dans_La_Masse:3726:19436374,19434806:Teint_Dans_La_Masse:3726:19436470,19434807:Teint_Dans_La_Masse:3726:19435002,19435271:Teint_Dans_La_Masse:3726:19435612,19454851:Teint_Dans_La_Masse:3726:19455241,19455181:Teint_Dans_La_Masse:3726:19459581,19455593:Teint_Dans_La_Masse:3726:19458275,19455595:Teint_Dans_La_Masse:3726:19455951,19467829:Teint_Dans_La_Masse:3726:19468008,19468128:Teint_Dans_La_Masse:3726:19468928,19468179:Teint_Dans_La_Masse:3726:19468623,19468462:Teint_Dans_La_Masse:3726:19468697,19471096:Teint_Dans_La_Masse:3726:19482525,19471097:Teint_Dans_La_Masse:3726:19494061,19472287:Teint_Dans_La_Masse:3726:19476272,19472288:Teint_Dans_La_Masse:3726:1'}), 'main_stat': {'nb_photos': 8667}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2025-01', 0.13595897162329176),)]} VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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': ((8667,),), 'unwanted_material_monthly_percentage': ((0.13595897162329176,),), 'material_repartition': (('JRM', 8667),), 'material_dict': {'JRM': 8667}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 1, 3), 0.04907321841328218, 288), (datetime.date(2025, 1, 6), 0.040134053960125315, 531), (datetime.date(2025, 1, 7), 0.18315196439745712, 283), (datetime.date(2025, 1, 8), 0.13048497663506636, 614), (datetime.date(2025, 1, 9), 0.13473864931194962, 532), (datetime.date(2025, 1, 10), 0.1894067954200693, 235), (datetime.date(2025, 1, 13), 0.12938004056078953, 616), (datetime.date(2025, 1, 14), 0.15819673479147872, 315), (datetime.date(2025, 1, 15), 0.15836835321056597, 560), (datetime.date(2025, 1, 16), 0.13275932432633594, 587), (datetime.date(2025, 1, 17), 0.10535333722984483, 309), (datetime.date(2025, 1, 20), 0.17741051573109973, 545), (datetime.date(2025, 1, 22), 0.1479127540808, 508), (datetime.date(2025, 1, 23), 0.1562433521320552, 581), (datetime.date(2025, 1, 24), 0.13146133344409378, 281), (datetime.date(2025, 1, 27), 0.12609188240367877, 491), (datetime.date(2025, 1, 28), 0.15789654977785797, 486), (datetime.date(2025, 1, 29), 0.1579324844324773, 585), (datetime.date(2025, 1, 30), 0.20504672488504902, 30), (datetime.date(2025, 1, 31), 0.1268512627463249, 290)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 1, 3), 0.04907321841328218, 288), (datetime.date(2025, 1, 6), 0.040134053960125315, 531), (datetime.date(2025, 1, 7), 0.18315196439745712, 283), (datetime.date(2025, 1, 8), 0.13048497663506636, 614), (datetime.date(2025, 1, 9), 0.13473864931194962, 532), (datetime.date(2025, 1, 10), 0.1894067954200693, 235), (datetime.date(2025, 1, 13), 0.12938004056078953, 616), (datetime.date(2025, 1, 14), 0.15819673479147872, 315), (datetime.date(2025, 1, 15), 0.15836835321056597, 560), (datetime.date(2025, 1, 16), 0.13275932432633594, 587), (datetime.date(2025, 1, 17), 0.10535333722984483, 309), (datetime.date(2025, 1, 20), 0.17741051573109973, 545), (datetime.date(2025, 1, 22), 0.1479127540808, 508), (datetime.date(2025, 1, 23), 0.1562433521320552, 581), (datetime.date(2025, 1, 24), 0.13146133344409378, 281), (datetime.date(2025, 1, 27), 0.12609188240367877, 491), (datetime.date(2025, 1, 28), 0.15789654977785797, 486), (datetime.date(2025, 1, 29), 0.1579324844324773, 585), (datetime.date(2025, 1, 30), 0.20504672488504902, 30), (datetime.date(2025, 1, 31), 0.1268512627463249, 290))}, 'quality_array': [['0.6784785437463524', '03012025'], ['0.4876419485593672', '06012025'], ['0.060611871519429046', '07012025'], ['0.6690403600870028', '08012025'], ['0.3478461936828805', '09012025'], ['0.4952687225121936', '10012025'], ['0.6874503737366016', '13012025'], ['0.7716467717387825', '14012025'], ['0.5391753491894069', '15012025'], ['0.6696237180439134', '16012025'], ['0.7603496560958662', '17012025'], ['0.6306837496519877', '20012025'], ['0.7357941185119705', '22012025'], ['1.0233687033844272', '23012025'], ['0.7037121508584268', '24012025'], ['0.5635079487338653', '27012025'], ['0.7956590449610412', '28012025'], ['0.6772887036423657', '29012025'], ['0.7347631145126714', '30012025'], ['0.8715396631763487', '31012025']], 'number_of_batch': ((125,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.026165055963399166, 'nb_photo': 4443, 'list_port_cont': '19394783,19395205,19397264,19432135,19433608,19433730,19435008,19435610,19435948,19436076,19436365,19436468,19455247,19455960,19458280,19459574,19468010,19468618,19468693,19468924,19473299,19476271,19482330,19482521,19491756,19491993,19494063,19496297,19499242,19499605,19500462,19503075,19503914,19508160,19508881,19510403,19544769,19545585,19548868,19550021,19553999,19554912,19556331,19557998,19572287,19573095,19577890,19580397,19590159,19638076,19646002,19646210,19654378,19674785,19677763,19678334,19686780,19695473,19697436,19700102,19701945,19704689,19713331,19713695,19714143,19717370,19722357,19726466,19726491,19728103,19755354,19764020,19765822,19766191,19768406,19775127,19781361,19792024,19811713,19821604,19823106,19824828,19839372,19839799,19843228,19846397,19864052,19870575,19878796,19886704,19887621,19887752,19890512,19910124,19912320,19913267,19915313,19962503,19976641,19978679,19984679,19991252,20004601,20014975,20019633,20020480,20024729,20029254,20029281,20031722,20032810,20038101,20040655,2004117', 'assoc_port': '19394637:19394783,19395020:19397264,19395021:19395205,19431274:19432135,19431673:19433608,19431676:19433730,19434392:19435948,19434394:19436076,19434805:19436365,19434806:19436468,19434807:19435008,19435271:19435610,19454851:19455247,19455181:19459574,19455593:19458280,19455595:19455960,19467829:19468010,19468128:19468924,19468179:19468618,19468462:19468693,19471096:19482521,19471097:19494063,19472287:19476271,19472288:19482330,19472289:19473299,19488299:19496297,19488789:19491756,19488792:19491993,19499059:19510403,19499060:19508160,19499061:19508881,19499062:19499242,19499063:19499605,19500297:19500462,19500635:19503075,19503772:19503914,19544320:19544769,19544738:19548868,19545173:19545585,19545199:19550021,19550530:19556331,19551458:19557998,19551461:19553999,19554721:19554912,19571837:19572287,19572356:19590159,19572957:19573095,19576282:19577890,19577718:19580397,19632894:19686780,19634656:19678334,19634684:19677763,19636036:19638076,19644474:19646002,19644475:19674785,19645782:19654378,19645783:1964621', 'assoc_mat': '19394637:autre_refus:3726:19394783,19395020:autre_refus:3726:19397264,19395021:autre_refus:3726:19395205,19431274:autre_refus:3726:19432135,19431673:autre_refus:3726:19433608,19431676:autre_refus:3726:19433730,19434392:autre_refus:3726:19435948,19434394:autre_refus:3726:19436076,19434805:autre_refus:3726:19436365,19434806:autre_refus:3726:19436468,19434807:autre_refus:3726:19435008,19435271:autre_refus:3726:19435610,19454851:autre_refus:3726:19455247,19455181:autre_refus:3726:19459574,19455593:autre_refus:3726:19458280,19455595:autre_refus:3726:19455960,19467829:autre_refus:3726:19468010,19468128:autre_refus:3726:19468924,19468179:autre_refus:3726:19468618,19468462:autre_refus:3726:19468693,19471096:autre_refus:3726:19482521,19471097:autre_refus:3726:19494063,19472287:autre_refus:3726:19476271,19472288:autre_refus:3726:19482330,19472289:autre_refus:3726:19473299,19488299:autre_refus:3726:19496297,19488789:autre_refus:3726:19491756,19488792:autre_refus:3726:19491993,19499059:autre_refus:3726:19510403,19499060:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.04053457020100825, 'nb_photo': 15143, 'list_port_cont': '19394782,19395210,19397270,19432136,19433617,19433726,19434999,19435609,19435953,19436072,19436367,19436469,19455251,19455954,19458277,19459575,19468007,19468620,19468700,19468922,19473302,19476268,19482323,19482522,19491751,19491997,19494059,19496292,19499239,19499612,19500454,19503078,19503915,19508167,19508891,19510397,19544770,19545587,19548870,19550019,19553990,19554916,19556332,19558006,19572298,19573091,19577879,19580407,19590168,19638072,19646006,19646212,19654383,19674768,19677771,19678331,19686790,19695474,19697440,19700108,19701941,19704683,19713329,19713696,19714145,19717359,19722354,19726464,19726488,19728110,19755359,19764015,19765827,19766183,19768413,19775130,19781368,19792026,19811706,19821607,19823107,19824825,19839371,19839794,19843230,19846404,19864054,19870580,19878797,19886708,19887620,19887757,19890517,19910129,19912328,19913268,19915312,19962494,19976633,19978678,19984683,19991262,20004593,20014984,20019632,20020487,20024732,20029251,20029280,20031723,20032808,20038096,20040657,2004118', 'assoc_port': '19394637:19394782,19395020:19397270,19395021:19395210,19431274:19432136,19431673:19433617,19431676:19433726,19434392:19435953,19434394:19436072,19434805:19436367,19434806:19436469,19434807:19434999,19435271:19435609,19454851:19455251,19455181:19459575,19455593:19458277,19455595:19455954,19467829:19468007,19468128:19468922,19468179:19468620,19468462:19468700,19471096:19482522,19471097:19494059,19472287:19476268,19472288:19482323,19472289:19473302,19488299:19496292,19488789:19491751,19488792:19491997,19499059:19510397,19499060:19508167,19499061:19508891,19499062:19499239,19499063:19499612,19500297:19500454,19500635:19503078,19503772:19503915,19544320:19544770,19544738:19548870,19545173:19545587,19545199:19550019,19550530:19556332,19551458:19558006,19551461:19553990,19554721:19554916,19571837:19572298,19572356:19590168,19572957:19573091,19576282:19577879,19577718:19580407,19632894:19686790,19634656:19678331,19634684:19677771,19636036:19638072,19644474:19646006,19644475:19674768,19645782:19654383,19645783:1964621', 'assoc_mat': '19394637:cartonnette:3726:19394782,19395020:cartonnette:3726:19397270,19395021:cartonnette:3726:19395210,19431274:cartonnette:3726:19432136,19431673:cartonnette:3726:19433617,19431676:cartonnette:3726:19433726,19434392:cartonnette:3726:19435953,19434394:cartonnette:3726:19436072,19434805:cartonnette:3726:19436367,19434806:cartonnette:3726:19436469,19434807:cartonnette:3726:19434999,19435271:cartonnette:3726:19435609,19454851:cartonnette:3726:19455251,19455181:cartonnette:3726:19459575,19455593:cartonnette:3726:19458277,19455595:cartonnette:3726:19455954,19467829:cartonnette:3726:19468007,19468128:cartonnette:3726:19468922,19468179:cartonnette:3726:19468620,19468462:cartonnette:3726:19468700,19471096:cartonnette:3726:19482522,19471097:cartonnette:3726:19494059,19472287:cartonnette:3726:19476268,19472288:cartonnette:3726:19482323,19472289:cartonnette:3726:19473302,19488299:cartonnette:3726:19496292,19488789:cartonnette:3726:19491751,19488792:cartonnette:3726:19491997,19499059:cartonnette:3726:19510397,19499060:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.025757001049856752, 'nb_photo': 14297, 'list_port_cont': '19394781,19395204,19397269,19432131,19433618,19433734,19435005,19435608,19435951,19436066,19436375,19436466,19455246,19455955,19458272,19459580,19468011,19468624,19468696,19468917,19473298,19476277,19482329,19482519,19491752,19492002,19494054,19496291,19499241,19499609,19500461,19503073,19503912,19508165,19508889,19510405,19544774,19545594,19548875,19550015,19553997,19554908,19556335,19558001,19572289,19573094,19577886,19580406,19590163,19638070,19646009,19646216,19654376,19674790,19677761,19678330,19686786,19695479,19697432,19700106,19701944,19704688,19713335,19713694,19714150,19717365,19722359,19726457,19726489,19728108,19755362,19764022,19765828,19766187,19768407,19775124,19781367,19792029,19811707,19821597,19823111,19824823,19839370,19839798,19843239,19846399,19864050,19870573,19878802,19886703,19887612,19887761,19890509,19910127,19912329,19913277,19915317,19962497,19976642,19978677,19984681,19991257,20004603,20014980,20019636,20020485,20024730,20029250,20029283,20031721,20032812,20038092,20040665,2004117', 'assoc_port': '19394637:19394781,19395020:19397269,19395021:19395204,19431274:19432131,19431673:19433618,19431676:19433734,19434392:19435951,19434394:19436066,19434805:19436375,19434806:19436466,19434807:19435005,19435271:19435608,19454851:19455246,19455181:19459580,19455593:19458272,19455595:19455955,19467829:19468011,19468128:19468917,19468179:19468624,19468462:19468696,19471096:19482519,19471097:19494054,19472287:19476277,19472288:19482329,19472289:19473298,19488299:19496291,19488789:19491752,19488792:19492002,19499059:19510405,19499060:19508165,19499061:19508889,19499062:19499241,19499063:19499609,19500297:19500461,19500635:19503073,19503772:19503912,19544320:19544774,19544738:19548875,19545173:19545594,19545199:19550015,19550530:19556335,19551458:19558001,19551461:19553997,19554721:19554908,19571837:19572289,19572356:19590163,19572957:19573094,19576282:19577886,19577718:19580406,19632894:19686786,19634656:19678330,19634684:19677761,19636036:19638070,19644474:19646009,19644475:19674790,19645782:19654376,19645783:1964621', 'assoc_mat': '19394637:Carton_brun:3726:19394781,19395020:Carton_brun:3726:19397269,19395021:Carton_brun:3726:19395204,19431274:Carton_brun:3726:19432131,19431673:Carton_brun:3726:19433618,19431676:Carton_brun:3726:19433734,19434392:Carton_brun:3726:19435951,19434394:Carton_brun:3726:19436066,19434805:Carton_brun:3726:19436375,19434806:Carton_brun:3726:19436466,19434807:Carton_brun:3726:19435005,19435271:Carton_brun:3726:19435608,19454851:Carton_brun:3726:19455246,19455181:Carton_brun:3726:19459580,19455593:Carton_brun:3726:19458272,19455595:Carton_brun:3726:19455955,19467829:Carton_brun:3726:19468011,19468128:Carton_brun:3726:19468917,19468179:Carton_brun:3726:19468624,19468462:Carton_brun:3726:19468696,19471096:Carton_brun:3726:19482519,19471097:Carton_brun:3726:19494054,19472287:Carton_brun:3726:19476277,19472288:Carton_brun:3726:19482329,19472289:Carton_brun:3726:19473298,19488299:Carton_brun:3726:19496291,19488789:Carton_brun:3726:19491752,19488792:Carton_brun:3726:19492002,19499059:Carton_brun:3726:19510405,19499060:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.01592542784980838, 'nb_photo': 3345, 'list_port_cont': '19394784,19395201,19397265,19432133,19433611,19433725,19435003,19435615,19435955,19436067,19436369,19436463,19455249,19455959,19458274,19459577,19468018,19468625,19468691,19468921,19473300,19476274,19482321,19482523,19491757,19491992,19494056,19496289,19499233,19499614,19500460,19503081,19503906,19508163,19508882,19510406,19544771,19545586,19548871,19550020,19553992,19554910,19556338,19558005,19572290,19573092,19577884,19580404,19590165,19638068,19646013,19646211,19654377,19674791,19677767,19678327,19686781,19695475,19697438,19700101,19701943,19704686,19713338,19713702,19714144,19717366,19722355,19726460,19726481,19728111,19755355,19764018,19765826,19766189,19768411,19775128,19781365,19792025,19811709,19821601,19823103,19824827,19839362,19839800,19843234,19846402,19864053,19870578,19878800,19886699,19887622,19887750,19890520,19910123,19912324,19913275,19915308,19962495,19976637,19978683,19984684,19991258,20004596,20014985,20019627,20020484,20024738,20029246,20029276,20031720,20032805,20038095,20040658,2004118', 'assoc_port': '19394637:19394784,19395020:19397265,19395021:19395201,19431274:19432133,19431673:19433611,19431676:19433725,19434392:19435955,19434394:19436067,19434805:19436369,19434806:19436463,19434807:19435003,19435271:19435615,19454851:19455249,19455181:19459577,19455593:19458274,19455595:19455959,19467829:19468018,19468128:19468921,19468179:19468625,19468462:19468691,19471096:19482523,19471097:19494056,19472287:19476274,19472288:19482321,19472289:19473300,19488299:19496289,19488789:19491757,19488792:19491992,19499059:19510406,19499060:19508163,19499061:19508882,19499062:19499233,19499063:19499614,19500297:19500460,19500635:19503081,19503772:19503906,19544320:19544771,19544738:19548871,19545173:19545586,19545199:19550020,19550530:19556338,19551458:19558005,19551461:19553992,19554721:19554910,19571837:19572290,19572356:19590165,19572957:19573092,19576282:19577884,19577718:19580404,19632894:19686781,19634656:19678327,19634684:19677767,19636036:19638068,19644474:19646013,19644475:19674791,19645782:19654377,19645783:1964621', 'assoc_mat': '19394637:Carton_gris:3726:19394784,19395020:Carton_gris:3726:19397265,19395021:Carton_gris:3726:19395201,19431274:Carton_gris:3726:19432133,19431673:Carton_gris:3726:19433611,19431676:Carton_gris:3726:19433725,19434392:Carton_gris:3726:19435955,19434394:Carton_gris:3726:19436067,19434805:Carton_gris:3726:19436369,19434806:Carton_gris:3726:19436463,19434807:Carton_gris:3726:19435003,19435271:Carton_gris:3726:19435615,19454851:Carton_gris:3726:19455249,19455181:Carton_gris:3726:19459577,19455593:Carton_gris:3726:19458274,19455595:Carton_gris:3726:19455959,19467829:Carton_gris:3726:19468018,19468128:Carton_gris:3726:19468921,19468179:Carton_gris:3726:19468625,19468462:Carton_gris:3726:19468691,19471096:Carton_gris:3726:19482523,19471097:Carton_gris:3726:19494056,19472287:Carton_gris:3726:19476274,19472288:Carton_gris:3726:19482321,19472289:Carton_gris:3726:19473300,19488299:Carton_gris:3726:19496289,19488789:Carton_gris:3726:19491757,19488792:Carton_gris:3726:19491992,19499059:Carton_gris:3726:19510406,19499060:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0009941089364134004, 'nb_photo': 313, 'list_port_cont': '19394788,19395199,19397272,19432127,19433609,19433736,19434997,19435614,19435946,19436070,19436464,19455244,19455956,19458270,19468016,19468621,19468695,19476270,19482322,19482526,19491754,19491994,19494057,19496295,19499244,19499610,19500457,19503071,19503910,19508887,19510401,19545593,19548865,19550023,19554913,19556337,19558000,19573089,19577885,19580398,19590161,19646217,19677766,19686791,19697441,19700100,19701951,19704691,19713336,19713698,19714147,19717361,19722350,19726468,19728106,19755363,19765823,19766180,19768416,19775126,19781360,19792033,19811712,19821605,19823102,19824822,19839804,19843238,19864060,19870574,19887613,19887754,19890518,19910119,19912327,19913272,19962501,19976638,19978680,19984676,19991260,20004599,20020489,20024736,20029278,20038094,20040656,20041183,20043556,20045589,20047269,20070809,20071112,20115718,20117135', 'assoc_port': '19394637:19394788,19395020:19397272,19395021:19395199,19431274:19432127,19431673:19433609,19431676:19433736,19434392:19435946,19434394:19436070,19434806:19436464,19434807:19434997,19435271:19435614,19454851:19455244,19455593:19458270,19455595:19455956,19467829:19468016,19468179:19468621,19468462:19468695,19471096:19482526,19471097:19494057,19472287:19476270,19472288:19482322,19488299:19496295,19488789:19491754,19488792:19491994,19499059:19510401,19499061:19508887,19499062:19499244,19499063:19499610,19500297:19500457,19500635:19503071,19503772:19503910,19544738:19548865,19545173:19545593,19545199:19550023,19550530:19556337,19551458:19558000,19554721:19554913,19572356:19590161,19572957:19573089,19576282:19577885,19577718:19580398,19632894:19686791,19634684:19677766,19645783:19646217,19695255:19713336,19695257:19713698,19695260:19714147,19696779:19726468,19697087:19728106,19697089:19700100,19697090:19697441,19700500:19717361,19700501:19722350,19701318:19701951,19704030:19704691,19753347:19755363,19754721:1976582', 'assoc_mat': '19394637:kraft:3726:19394788,19395020:kraft:3726:19397272,19395021:kraft:3726:19395199,19431274:kraft:3726:19432127,19431673:kraft:3726:19433609,19431676:kraft:3726:19433736,19434392:kraft:3726:19435946,19434394:kraft:3726:19436070,19434806:kraft:3726:19436464,19434807:kraft:3726:19434997,19435271:kraft:3726:19435614,19454851:kraft:3726:19455244,19455593:kraft:3726:19458270,19455595:kraft:3726:19455956,19467829:kraft:3726:19468016,19468179:kraft:3726:19468621,19468462:kraft:3726:19468695,19471096:kraft:3726:19482526,19471097:kraft:3726:19494057,19472287:kraft:3726:19476270,19472288:kraft:3726:19482322,19488299:kraft:3726:19496295,19488789:kraft:3726:19491754,19488792:kraft:3726:19491994,19499059:kraft:3726:19510401,19499061:kraft:3726:19508887,19499062:kraft:3726:19499244,19499063:kraft:3726:19499610,19500297:kraft:3726:19500457,19500635:kraft:3726:19503071,19503772:kraft:3726:19503910,19544738:kraft:3726:19548865,19545173:kraft:3726:19545593,19545199:kraft:3726:19550023,19550530:kraft:3726:19556337,19551458:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.027262644683406362, 'nb_photo': 5557, 'list_port_cont': '19394778,19395209,19397267,19432129,19433615,19433733,19435001,19435607,19435956,19436073,19436376,19436467,19455250,19455961,19458279,19459582,19468012,19468619,19468698,19468919,19473296,19476269,19482328,19482515,19491749,19491999,19494062,19496298,19499235,19499603,19500452,19503080,19503908,19508168,19508884,19510395,19544765,19545589,19548873,19550018,19553994,19554915,19556341,19558004,19572291,19573087,19577881,19580399,19590167,19638073,19646003,19646213,19654373,19674777,19677764,19678329,19686784,19695481,19697433,19700107,19701946,19704685,19713328,19713699,19714148,19717362,19722351,19726462,19726492,19728105,19755353,19764025,19765821,19766184,19768415,19775131,19781366,19792035,19811710,19821598,19823101,19824820,19839365,19839793,19843231,19846394,19864056,19870572,19878799,19886707,19887614,19887760,19890516,19910128,19912321,19913270,19915315,19962502,19976634,19978681,19984682,19991255,20004602,20014978,20019635,20020483,20024737,20029252,20029277,20031719,20032802,20038091,20040661,2004117', 'assoc_port': '19394637:19394778,19395020:19397267,19395021:19395209,19431274:19432129,19431673:19433615,19431676:19433733,19434392:19435956,19434394:19436073,19434805:19436376,19434806:19436467,19434807:19435001,19435271:19435607,19454851:19455250,19455181:19459582,19455593:19458279,19455595:19455961,19467829:19468012,19468128:19468919,19468179:19468619,19468462:19468698,19471096:19482515,19471097:19494062,19472287:19476269,19472288:19482328,19472289:19473296,19488299:19496298,19488789:19491749,19488792:19491999,19499059:19510395,19499060:19508168,19499061:19508884,19499062:19499235,19499063:19499603,19500297:19500452,19500635:19503080,19503772:19503908,19544320:19544765,19544738:19548873,19545173:19545589,19545199:19550018,19550530:19556341,19551458:19558004,19551461:19553994,19554721:19554915,19571837:19572291,19572356:19590167,19572957:19573087,19576282:19577881,19577718:19580399,19632894:19686784,19634656:19678329,19634684:19677764,19636036:19638073,19644474:19646003,19644475:19674777,19645782:19654373,19645783:1964621', 'assoc_mat': '19394637:plastique:3726:19394778,19395020:plastique:3726:19397267,19395021:plastique:3726:19395209,19431274:plastique:3726:19432129,19431673:plastique:3726:19433615,19431676:plastique:3726:19433733,19434392:plastique:3726:19435956,19434394:plastique:3726:19436073,19434805:plastique:3726:19436376,19434806:plastique:3726:19436467,19434807:plastique:3726:19435001,19435271:plastique:3726:19435607,19454851:plastique:3726:19455250,19455181:plastique:3726:19459582,19455593:plastique:3726:19458279,19455595:plastique:3726:19455961,19467829:plastique:3726:19468012,19468128:plastique:3726:19468919,19468179:plastique:3726:19468619,19468462:plastique:3726:19468698,19471096:plastique:3726:19482515,19471097:plastique:3726:19494062,19472287:plastique:3726:19476269,19472288:plastique:3726:19482328,19472289:plastique:3726:19473296,19488299:plastique:3726:19496298,19488789:plastique:3726:19491749,19488792:plastique:3726:19491999,19499059:plastique:3726:19510395,19499060:plastique:3726:19508168,19499061:plastique:3726:19508884,1'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.021254624915112017, 'nb_photo': 8369, 'list_port_cont': '19394779,19395202,19397268,19432125,19433612,19433728,19435002,19435612,19435950,19436074,19436374,19436470,19455241,19455951,19458275,19459581,19468008,19468623,19468697,19468928,19473294,19476272,19482319,19482525,19491755,19491998,19494061,19496294,19499237,19499611,19500456,19503070,19503907,19508164,19508886,19510399,19544766,19545590,19548866,19550025,19553989,19554917,19556339,19558007,19572295,19573090,19577887,19580403,19590160,19638069,19646005,19646206,19654384,19674783,19677772,19678328,19686787,19695478,19697434,19700104,19701949,19704690,19713332,19713703,19714140,19717369,19722353,19726463,19726484,19728107,19755364,19764024,19765819,19766185,19768410,19775125,19781362,19792028,19811705,19821603,19823105,19824826,19839361,19839795,19843235,19846403,19864057,19870579,19878801,19886709,19887611,19887755,19890515,19910120,19912323,19913276,19915311,19962505,19976632,19978682,19984678,19991254,20004597,20014977,20019619,20020481,20024739,20029256,20029282,20031725,20032809,20038093,20040659,2004117', 'assoc_port': '19394637:19394779,19395020:19397268,19395021:19395202,19431274:19432125,19431673:19433612,19431676:19433728,19434392:19435950,19434394:19436074,19434805:19436374,19434806:19436470,19434807:19435002,19435271:19435612,19454851:19455241,19455181:19459581,19455593:19458275,19455595:19455951,19467829:19468008,19468128:19468928,19468179:19468623,19468462:19468697,19471096:19482525,19471097:19494061,19472287:19476272,19472288:19482319,19472289:19473294,19488299:19496294,19488789:19491755,19488792:19491998,19499059:19510399,19499060:19508164,19499061:19508886,19499062:19499237,19499063:19499611,19500297:19500456,19500635:19503070,19503772:19503907,19544320:19544766,19544738:19548866,19545173:19545590,19545199:19550025,19550530:19556339,19551458:19558007,19551461:19553989,19554721:19554917,19571837:19572295,19572356:19590160,19572957:19573090,19576282:19577887,19577718:19580403,19632894:19686787,19634656:19678328,19634684:19677772,19636036:19638069,19644474:19646005,19644475:19674783,19645782:19654384,19645783:1964620', 'assoc_mat': '19394637:Teint_Dans_La_Masse:3726:19394779,19395020:Teint_Dans_La_Masse:3726:19397268,19395021:Teint_Dans_La_Masse:3726:19395202,19431274:Teint_Dans_La_Masse:3726:19432125,19431673:Teint_Dans_La_Masse:3726:19433612,19431676:Teint_Dans_La_Masse:3726:19433728,19434392:Teint_Dans_La_Masse:3726:19435950,19434394:Teint_Dans_La_Masse:3726:19436074,19434805:Teint_Dans_La_Masse:3726:19436374,19434806:Teint_Dans_La_Masse:3726:19436470,19434807:Teint_Dans_La_Masse:3726:19435002,19435271:Teint_Dans_La_Masse:3726:19435612,19454851:Teint_Dans_La_Masse:3726:19455241,19455181:Teint_Dans_La_Masse:3726:19459581,19455593:Teint_Dans_La_Masse:3726:19458275,19455595:Teint_Dans_La_Masse:3726:19455951,19467829:Teint_Dans_La_Masse:3726:19468008,19468128:Teint_Dans_La_Masse:3726:19468928,19468179:Teint_Dans_La_Masse:3726:19468623,19468462:Teint_Dans_La_Masse:3726:19468697,19471096:Teint_Dans_La_Masse:3726:19482525,19471097:Teint_Dans_La_Masse:3726:19494061,19472287:Teint_Dans_La_Masse:3726:19476272,19472288:Teint_Dans_La_Masse:3726:1'}), 'main_stat': {'nb_photos': 8667}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2025-01', 0.13595897162329176),)]} filepath : /data_2/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_01_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', '2.62%', 4443], 'cartonnette': ['cartonnette', '4.05%', 15143], 'Carton_brun': ['Carton_brun', '2.58%', 14297], 'Carton_gris': ['Carton_gris', '1.59%', 3345], 'kraft': ['kraft', '0.1%', 313], 'plastique': ['plastique', '2.73%', 5557], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '2.13%', 8369]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_01_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/Perlen_convoyeur 3.06user 2.32system 0:09.52elapsed 56%CPU (0avgtext+0avgdata 193476maxresident)k 26208inputs+336outputs (179major+82094minor)pagefaults 0swaps