python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --job=sla_mensuel --raspi=20095 --dashboard_places=Perlen_convoyeur --rootfolder_sla=/data_4/data_log/job/memo/Perlen_convoyeur -v --mtr_id=1053 --date=`date -d"$nowdate 15 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : 20095, Date : 2026-02 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 28) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4189 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4189 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4189 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4189 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4433 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4433 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4433 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4433 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 12489 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 12499 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12500 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 12492 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 12492 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! WARNING : number of outputs for step 12493 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 12502 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 12502 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 12495 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 12495 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 2 of step 12492 doesn't seem to be define in the database( WARNING : output 1 of step 12489 have datatype=2 whereas input 1 of step 12493 have datatype=7 WARNING : type of output 2 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12494 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12496 doesn't seem to be define in the database( WARNING : type of input 3 of step 12495 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12500 doesn't seem to be define in the database( WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12499 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 12496 have datatype=10 whereas input 3 of step 12498 have datatype=6 WARNING : type of input 5 of step 12498 doesn't seem to be define in the database( WARNING : output 0 of step 12501 have datatype=11 whereas input 5 of step 12498 have datatype=None WARNING : output 0 of step 12496 have datatype=10 whereas input 0 of step 12501 have datatype=18 WARNING : type of input 2 of step 12502 doesn't seem to be define in the database( WARNING : output 1 of step 12494 have datatype=7 whereas input 2 of step 12502 have datatype=None WARNING : type of output 3 of step 12502 doesn't seem to be define in the database( WARNING : type of input 2 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12499 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : type of output 1 of step 12500 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : output 0 of step 12493 have datatype=1 whereas input 0 of step 12494 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier', 'hashtag_weights': {'Carton_brun': 3, 'Carton_gris': 3, 'Teint_Dans_La_Masse': 2, 'autre_refus': 3, 'cartonnette': 2, 'kraft': 3, 'metal': 6, 'plastique': 2}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="Perlen_convoyeur"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4189 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4189 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4189 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4189 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4433 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4433 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4433 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4433 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 12489 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 12499 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12500 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 12492 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 12492 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! WARNING : number of outputs for step 12493 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 12502 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 12502 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 12495 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 12495 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 2 of step 12492 doesn't seem to be define in the database( WARNING : output 1 of step 12489 have datatype=2 whereas input 1 of step 12493 have datatype=7 WARNING : type of output 2 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12494 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12496 doesn't seem to be define in the database( WARNING : type of input 3 of step 12495 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12500 doesn't seem to be define in the database( WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12499 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 12496 have datatype=10 whereas input 3 of step 12498 have datatype=6 WARNING : type of input 5 of step 12498 doesn't seem to be define in the database( WARNING : output 0 of step 12501 have datatype=11 whereas input 5 of step 12498 have datatype=None WARNING : output 0 of step 12496 have datatype=10 whereas input 0 of step 12501 have datatype=18 WARNING : type of input 2 of step 12502 doesn't seem to be define in the database( WARNING : output 1 of step 12494 have datatype=7 whereas input 2 of step 12502 have datatype=None WARNING : type of output 3 of step 12502 doesn't seem to be define in the database( WARNING : type of input 2 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12499 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : type of output 1 of step 12500 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : output 0 of step 12493 have datatype=1 whereas input 0 of step 12494 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier', 'hashtag_weights': {'Carton_brun': 3, 'Carton_gris': 3, 'Teint_Dans_La_Masse': 2, 'autre_refus': 3, 'cartonnette': 2, 'kraft': 3, 'metal': 6, 'plastique': 2}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 28) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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 : 02 mtr_id : 1053 dashboard_places : Perlen_convoyeur date : 2026-02 year : 2026 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 '%2026-02%') and created_at like '%2026-02%'))); nb_day : (6, 28) after unwanted_material_data nb_day : (6, 28) 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 '%2026/02%'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 ! We will need to call the sla_per_day for these missing days : 2026-02-02 00:00:00,2026-02-03 00:00:00,2026-02-04 00:00:00,2026-02-05 00:00:00,2026-02-06 00:00:00,2026-02-09 00:00:00,2026-02-10 00:00:00,2026-02-11 00:00:00,2026-02-12 00:00:00,2026-02-13 00:00:00,2026-02-16 00:00:00,2026-02-17 00:00:00,2026-02-18 00:00:00,2026-02-19 00:00:00,2026-02-20 00:00:00,2026-02-23 00:00:00,2026-02-24 00:00:00,2026-02-25 00:00:00,2026-02-26 00:00:00,2026-02-27 00:00:00 after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 134 and month(ded.date) = 02 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______JRM' and ded.dashboard_place_id = 134 and month(ded.date) = 02 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 134 and mp.name like '%022026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-02-01 : dt_date_just_month_year : 2026-02-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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 >= "2026-02-01" AND ded.date <= "2026-02-28" 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 (2926739,2926753,2908200,2911351,2912630,2913265,2926763,2925740,2936996,2936990,2936986,2936984,2936982) 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.016496614860124787, 'nb_photo': 720, 'list_port_cont': '30381874,30382278,30382373,30384053,30412251,30412414,30412432,30412581,30414218,30414467,30415445,30415637,30425208,30426773,30426892,30428188,30429044,30430997,30431023,30437170,30438492,30464628,30486154,30487098,30489273,30521384,30521411,30521441,30521467,30521491,30521535,30524497,30525619,30527672,30530608,30547690,30550127,30550996,30552269,30553208,30558896,30559514,30561661,30565575,30567076,30568318,30568569,30568654,30568839,30568992,30569097,30605200,30605218,30605259,30605281,30605310,30605356,30605374,30605407,30605480,30605510,30605655,30605679,30605704,30605736,30605778,30606050,30606350', 'assoc_port': '30381759:30381874,30382058:30382373,30382060:30382278,30384019:30384053,30412041:30412251,30412362:30412581,30412374:30412432,30412376:30412414,30414126:30414218,30414405:30415445,30414406:30414467,30415517:30415637,30425112:30425208,30425700:30426773,30426812:30426892,30427490:30428188,30428962:30429044,30430918:30431023,30430919:30430997,30437094:30437170,30438441:30438492,30464567:30464628,30485832:30486154,30486953:30487098,30489165:30489273,30520972:30521384,30520973:30521411,30520974:30521441,30520975:30521467,30520995:30521491,30520996:30521535,30521056:30568569,30521057:30568654,30521058:30568839,30521059:30568992,30521060:30569097,30521077:30568318,30521078:30567076,30521107:30565575,30521108:30527672,30522092:30530608,30522351:30525619,30522593:30524497,30535121:30559514,30535400:30558896,30535629:30547690,30535872:30552269,30536162:30561661,30536530:30550996,30540344:30550127,30546578:30553208,30605140:30605407,30605141:30605480,30605160:30605704,30605161:30605736,30605162:30605778,30605163:3060567', 'assoc_mat': '30381759:autre_refus:3726:30381874,30382058:autre_refus:3726:30382373,30382060:autre_refus:3726:30382278,30384019:autre_refus:3726:30384053,30412041:autre_refus:3726:30412251,30412362:autre_refus:3726:30412581,30412374:autre_refus:3726:30412432,30412376:autre_refus:3726:30412414,30414126:autre_refus:3726:30414218,30414405:autre_refus:3726:30415445,30414406:autre_refus:3726:30414467,30415517:autre_refus:3726:30415637,30425112:autre_refus:3726:30425208,30425700:autre_refus:3726:30426773,30426812:autre_refus:3726:30426892,30427490:autre_refus:3726:30428188,30428962:autre_refus:3726:30429044,30430918:autre_refus:3726:30431023,30430919:autre_refus:3726:30430997,30437094:autre_refus:3726:30437170,30438441:autre_refus:3726:30438492,30464567:autre_refus:3726:30464628,30485832:autre_refus:3726:30486154,30486953:autre_refus:3726:30487098,30489165:autre_refus:3726:30489273,30520972:autre_refus:3726:30521384,30520973:autre_refus:3726:30521411,30520974:autre_refus:3726:30521441,30520975:autre_refus:3726:30521467,30520995:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013764370264938526, 'nb_photo': 1735, 'list_port_cont': '30381870,30382276,30382378,30384062,30412250,30412416,30412438,30412582,30414224,30414468,30415450,30415638,30425209,30426762,30426901,30428189,30429049,30430996,30431024,30437171,30438493,30464624,30486156,30487090,30489274,30508739,30521379,30521404,30521440,30521457,30521497,30521530,30524508,30525622,30527673,30530613,30547688,30550125,30550992,30552275,30553214,30558898,30559505,30561668,30565317,30565571,30567075,30568317,30568539,30568571,30568651,30568837,30568986,30569094,30605193,30605219,30605251,30605285,30605312,30605355,30605373,30605401,30605476,30605511,30605658,30605685,30605713,30605740,30605779,30606049,30606347', 'assoc_port': '30381759:30381870,30382058:30382378,30382060:30382276,30384019:30384062,30412041:30412250,30412362:30412582,30412374:30412438,30412376:30412416,30414126:30414224,30414405:30415450,30414406:30414468,30415517:30415638,30425112:30425209,30425700:30426762,30426812:30426901,30427490:30428189,30428962:30429049,30430918:30431024,30430919:30430996,30437094:30437171,30438441:30438493,30464567:30464624,30485832:30486156,30486953:30487090,30489165:30489274,30508645:30508739,30520972:30521379,30520973:30521404,30520974:30521440,30520975:30521457,30520995:30521497,30520996:30521530,30521055:30568539,30521056:30568571,30521057:30568651,30521058:30568837,30521059:30568986,30521060:30569094,30521077:30568317,30521078:30567075,30521107:30565571,30521108:30527673,30521110:30565317,30522092:30530613,30522351:30525622,30522593:30524508,30535121:30559505,30535400:30558898,30535629:30547688,30535872:30552275,30536162:30561668,30536530:30550992,30540344:30550125,30546578:30553214,30605140:30605401,30605141:30605476,30605160:3060571', 'assoc_mat': '30381759:cartonnette:3726:30381870,30382058:cartonnette:3726:30382378,30382060:cartonnette:3726:30382276,30384019:cartonnette:3726:30384062,30412041:cartonnette:3726:30412250,30412362:cartonnette:3726:30412582,30412374:cartonnette:3726:30412438,30412376:cartonnette:3726:30412416,30414126:cartonnette:3726:30414224,30414405:cartonnette:3726:30415450,30414406:cartonnette:3726:30414468,30415517:cartonnette:3726:30415638,30425112:cartonnette:3726:30425209,30425700:cartonnette:3726:30426762,30426812:cartonnette:3726:30426901,30427490:cartonnette:3726:30428189,30428962:cartonnette:3726:30429049,30430918:cartonnette:3726:30431024,30430919:cartonnette:3726:30430996,30437094:cartonnette:3726:30437171,30438441:cartonnette:3726:30438493,30464567:cartonnette:3726:30464624,30485832:cartonnette:3726:30486156,30486953:cartonnette:3726:30487090,30489165:cartonnette:3726:30489274,30508645:cartonnette:3726:30508739,30520972:cartonnette:3726:30521379,30520973:cartonnette:3726:30521404,30520974:cartonnette:3726:30521440,30520975:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.09394159603430927, 'nb_photo': 7534, 'list_port_cont': '30381871,30382285,30382371,30384055,30412259,30412408,30412439,30412591,30414219,30414469,30415451,30415629,30425214,30426767,30426893,30428194,30429038,30430998,30431027,30437166,30438482,30464630,30486149,30487092,30489280,30508729,30521380,30521407,30521442,30521462,30521495,30521531,30524505,30525616,30527664,30530609,30547691,30550117,30550999,30552276,30553210,30558901,30559509,30561658,30565313,30565566,30567084,30568314,30568543,30568576,30568650,30568836,30568988,30569090,30605195,30605220,30605258,30605289,30605317,30605350,30605376,30605406,30605483,30605516,30605653,30605682,30605712,30605737,30605783,30606045,30606344', 'assoc_port': '30381759:30381871,30382058:30382371,30382060:30382285,30384019:30384055,30412041:30412259,30412362:30412591,30412374:30412439,30412376:30412408,30414126:30414219,30414405:30415451,30414406:30414469,30415517:30415629,30425112:30425214,30425700:30426767,30426812:30426893,30427490:30428194,30428962:30429038,30430918:30431027,30430919:30430998,30437094:30437166,30438441:30438482,30464567:30464630,30485832:30486149,30486953:30487092,30489165:30489280,30508645:30508729,30520972:30521380,30520973:30521407,30520974:30521442,30520975:30521462,30520995:30521495,30520996:30521531,30521055:30568543,30521056:30568576,30521057:30568650,30521058:30568836,30521059:30568988,30521060:30569090,30521077:30568314,30521078:30567084,30521107:30565566,30521108:30527664,30521110:30565313,30522092:30530609,30522351:30525616,30522593:30524505,30535121:30559509,30535400:30558901,30535629:30547691,30535872:30552276,30536162:30561658,30536530:30550999,30540344:30550117,30546578:30553210,30605140:30605406,30605141:30605483,30605160:3060571', 'assoc_mat': '30381759:Carton_brun:3726:30381871,30382058:Carton_brun:3726:30382371,30382060:Carton_brun:3726:30382285,30384019:Carton_brun:3726:30384055,30412041:Carton_brun:3726:30412259,30412362:Carton_brun:3726:30412591,30412374:Carton_brun:3726:30412439,30412376:Carton_brun:3726:30412408,30414126:Carton_brun:3726:30414219,30414405:Carton_brun:3726:30415451,30414406:Carton_brun:3726:30414469,30415517:Carton_brun:3726:30415629,30425112:Carton_brun:3726:30425214,30425700:Carton_brun:3726:30426767,30426812:Carton_brun:3726:30426893,30427490:Carton_brun:3726:30428194,30428962:Carton_brun:3726:30429038,30430918:Carton_brun:3726:30431027,30430919:Carton_brun:3726:30430998,30437094:Carton_brun:3726:30437166,30438441:Carton_brun:3726:30438482,30464567:Carton_brun:3726:30464630,30485832:Carton_brun:3726:30486149,30486953:Carton_brun:3726:30487092,30489165:Carton_brun:3726:30489280,30508645:Carton_brun:3726:30508729,30520972:Carton_brun:3726:30521380,30520973:Carton_brun:3726:30521407,30520974:Carton_brun:3726:30521442,30520975:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004864504033003904, 'nb_photo': 186, 'list_port_cont': '30382275,30382377,30384052,30412253,30412436,30412585,30414216,30414477,30415444,30415635,30425215,30426769,30426897,30428187,30429048,30431000,30431025,30437165,30438490,30464626,30486148,30487093,30489277,30521378,30521409,30521432,30521466,30521488,30521533,30524506,30525621,30527665,30547686,30550124,30550989,30552277,30553217,30558899,30559507,30561667,30567080,30568319,30568573,30568646,30568830,30568995,30569091,30605197,30605226,30605250,30605284,30605314,30605345,30605384,30605405,30605478,30605518,30605659,30605680,30605705,30605735,30605786,30606041,30606340', 'assoc_port': '30382058:30382377,30382060:30382275,30384019:30384052,30412041:30412253,30412362:30412585,30412374:30412436,30414126:30414216,30414405:30415444,30414406:30414477,30415517:30415635,30425112:30425215,30425700:30426769,30426812:30426897,30427490:30428187,30428962:30429048,30430918:30431025,30430919:30431000,30437094:30437165,30438441:30438490,30464567:30464626,30485832:30486148,30486953:30487093,30489165:30489277,30520972:30521378,30520973:30521409,30520974:30521432,30520975:30521466,30520995:30521488,30520996:30521533,30521056:30568573,30521057:30568646,30521058:30568830,30521059:30568995,30521060:30569091,30521077:30568319,30521078:30567080,30521108:30527665,30522351:30525621,30522593:30524506,30535121:30559507,30535400:30558899,30535629:30547686,30535872:30552277,30536162:30561667,30536530:30550989,30540344:30550124,30546578:30553217,30605140:30605405,30605141:30605478,30605160:30605705,30605161:30605735,30605162:30605786,30605163:30605680,30605164:30606340,30605165:30605659,30605166:30605197,30605170:3060551', 'assoc_mat': '30382058:Carton_gris:3726:30382377,30382060:Carton_gris:3726:30382275,30384019:Carton_gris:3726:30384052,30412041:Carton_gris:3726:30412253,30412362:Carton_gris:3726:30412585,30412374:Carton_gris:3726:30412436,30414126:Carton_gris:3726:30414216,30414405:Carton_gris:3726:30415444,30414406:Carton_gris:3726:30414477,30415517:Carton_gris:3726:30415635,30425112:Carton_gris:3726:30425215,30425700:Carton_gris:3726:30426769,30426812:Carton_gris:3726:30426897,30427490:Carton_gris:3726:30428187,30428962:Carton_gris:3726:30429048,30430918:Carton_gris:3726:30431025,30430919:Carton_gris:3726:30431000,30437094:Carton_gris:3726:30437165,30438441:Carton_gris:3726:30438490,30464567:Carton_gris:3726:30464626,30485832:Carton_gris:3726:30486148,30486953:Carton_gris:3726:30487093,30489165:Carton_gris:3726:30489277,30520972:Carton_gris:3726:30521378,30520973:Carton_gris:3726:30521409,30520974:Carton_gris:3726:30521432,30520975:Carton_gris:3726:30521466,30520995:Carton_gris:3726:30521488,30520996:Carton_gris:3726:30521533,30521056:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00441999858282396, 'nb_photo': 71, 'list_port_cont': '30381877,30412410,30412437,30415628,30425207,30426890,30431026,30438491,30464631,30486150,30489272,30508742,30521382,30521458,30521538,30527671,30530611,30547687,30550995,30552266,30553211,30558893,30559513,30561664,30568645,30605257,30605311,30605348,30605379,30605482,30605515,30605663,30605683,30605789', 'assoc_port': '30381759:30381877,30412374:30412437,30412376:30412410,30415517:30415628,30425112:30425207,30426812:30426890,30430918:30431026,30438441:30438491,30464567:30464631,30485832:30486150,30489165:30489272,30508645:30508742,30520972:30521382,30520975:30521458,30520996:30521538,30521057:30568645,30521108:30527671,30522092:30530611,30535121:30559513,30535400:30558893,30535629:30547687,30535872:30552266,30536162:30561664,30536530:30550995,30546578:30553211,30605141:30605482,30605162:30605789,30605163:30605683,30605165:30605663,30605170:30605515,30605171:30605379,30605174:30605348,30605176:30605257,30605187:30605311', 'assoc_mat': '30381759:kraft:3726:30381877,30412374:kraft:3726:30412437,30412376:kraft:3726:30412410,30415517:kraft:3726:30415628,30425112:kraft:3726:30425207,30426812:kraft:3726:30426890,30430918:kraft:3726:30431026,30438441:kraft:3726:30438491,30464567:kraft:3726:30464631,30485832:kraft:3726:30486150,30489165:kraft:3726:30489272,30508645:kraft:3726:30508742,30520972:kraft:3726:30521382,30520975:kraft:3726:30521458,30520996:kraft:3726:30521538,30521057:kraft:3726:30568645,30521108:kraft:3726:30527671,30522092:kraft:3726:30530611,30535121:kraft:3726:30559513,30535400:kraft:3726:30558893,30535629:kraft:3726:30547687,30535872:kraft:3726:30552266,30536162:kraft:3726:30561664,30536530:kraft:3726:30550995,30546578:kraft:3726:30553211,30605141:kraft:3726:30605482,30605162:kraft:3726:30605789,30605163:kraft:3726:30605683,30605165:kraft:3726:30605663,30605170:kraft:3726:30605515,30605171:kraft:3726:30605379,30605174:kraft:3726:30605348,30605176:kraft:3726:30605257,30605187:kraft:3726:30605311'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0023790048704467157, 'nb_photo': 17, 'list_port_cont': '30384056,30431021,30438486,30521465,30521536,30561659,30565576,30568540,30605222,30605309,30605354,30605377,30605513', 'assoc_port': '30384019:30384056,30430918:30431021,30438441:30438486,30520975:30521465,30520996:30521536,30521055:30568540,30521107:30565576,30536162:30561659,30605170:30605513,30605171:30605377,30605174:30605354,30605177:30605222,30605187:30605309', 'assoc_mat': '30384019:metal:3726:30384056,30430918:metal:3726:30431021,30438441:metal:3726:30438486,30520975:metal:3726:30521465,30520996:metal:3726:30521536,30521055:metal:3726:30568540,30521107:metal:3726:30565576,30536162:metal:3726:30561659,30605170:metal:3726:30605513,30605171:metal:3726:30605377,30605174:metal:3726:30605354,30605177:metal:3726:30605222,30605187:metal:3726:30605309'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016626118878463148, 'nb_photo': 1740, 'list_port_cont': '30381873,30382279,30382376,30384051,30412258,30412417,30412441,30412592,30414213,30414474,30415448,30415633,30425210,30426764,30426894,30428186,30429040,30431003,30431022,30437174,30438488,30464627,30486159,30487095,30489281,30521388,30521410,30521435,30521464,30521489,30521534,30524507,30525623,30527675,30530614,30547689,30550116,30550991,30552270,30553207,30558890,30559512,30561665,30565311,30565565,30567081,30568322,30568533,30568572,30568649,30568831,30568994,30569089,30605190,30605217,30605252,30605279,30605315,30605351,30605378,30605403,30605486,30605519,30605657,30605681,30605708,30605745,30605780,30606044,30606346', 'assoc_port': '30381759:30381873,30382058:30382376,30382060:30382279,30384019:30384051,30412041:30412258,30412362:30412592,30412374:30412441,30412376:30412417,30414126:30414213,30414405:30415448,30414406:30414474,30415517:30415633,30425112:30425210,30425700:30426764,30426812:30426894,30427490:30428186,30428962:30429040,30430918:30431022,30430919:30431003,30437094:30437174,30438441:30438488,30464567:30464627,30485832:30486159,30486953:30487095,30489165:30489281,30520972:30521388,30520973:30521410,30520974:30521435,30520975:30521464,30520995:30521489,30520996:30521534,30521055:30568533,30521056:30568572,30521057:30568649,30521058:30568831,30521059:30568994,30521060:30569089,30521077:30568322,30521078:30567081,30521107:30565565,30521108:30527675,30521110:30565311,30522092:30530614,30522351:30525623,30522593:30524507,30535121:30559512,30535400:30558890,30535629:30547689,30535872:30552270,30536162:30561665,30536530:30550991,30540344:30550116,30546578:30553207,30605140:30605403,30605141:30605486,30605160:30605708,30605161:3060574', 'assoc_mat': '30381759:plastique:3726:30381873,30382058:plastique:3726:30382376,30382060:plastique:3726:30382279,30384019:plastique:3726:30384051,30412041:plastique:3726:30412258,30412362:plastique:3726:30412592,30412374:plastique:3726:30412441,30412376:plastique:3726:30412417,30414126:plastique:3726:30414213,30414405:plastique:3726:30415448,30414406:plastique:3726:30414474,30415517:plastique:3726:30415633,30425112:plastique:3726:30425210,30425700:plastique:3726:30426764,30426812:plastique:3726:30426894,30427490:plastique:3726:30428186,30428962:plastique:3726:30429040,30430918:plastique:3726:30431022,30430919:plastique:3726:30431003,30437094:plastique:3726:30437174,30438441:plastique:3726:30438488,30464567:plastique:3726:30464627,30485832:plastique:3726:30486159,30486953:plastique:3726:30487095,30489165:plastique:3726:30489281,30520972:plastique:3726:30521388,30520973:plastique:3726:30521410,30520974:plastique:3726:30521435,30520975:plastique:3726:30521464,30520995:plastique:3726:30521489,30520996:plastique:3726:30521534,3'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.020714652414180326, 'nb_photo': 3569, 'list_port_cont': '30381880,30382280,30382380,30384061,30412257,30412413,30412433,30412590,30414214,30414478,30415447,30415634,30425212,30426765,30426899,30428184,30429041,30430999,30431019,30437168,30438483,30464621,30486153,30487097,30489278,30508725,30521381,30521412,30521439,30521459,30521498,30521532,30524500,30525627,30527666,30530610,30547695,30550126,30550998,30552271,30553213,30558891,30559510,30561663,30565312,30565574,30567082,30568320,30568534,30568574,30568656,30568832,30568989,30569095,30605196,30605221,30605249,30605282,30605308,30605353,30605385,30605399,30605479,30605514,30605654,30605677,30605703,30605741,30605787,30606051,30606342', 'assoc_port': '30381759:30381880,30382058:30382380,30382060:30382280,30384019:30384061,30412041:30412257,30412362:30412590,30412374:30412433,30412376:30412413,30414126:30414214,30414405:30415447,30414406:30414478,30415517:30415634,30425112:30425212,30425700:30426765,30426812:30426899,30427490:30428184,30428962:30429041,30430918:30431019,30430919:30430999,30437094:30437168,30438441:30438483,30464567:30464621,30485832:30486153,30486953:30487097,30489165:30489278,30508645:30508725,30520972:30521381,30520973:30521412,30520974:30521439,30520975:30521459,30520995:30521498,30520996:30521532,30521055:30568534,30521056:30568574,30521057:30568656,30521058:30568832,30521059:30568989,30521060:30569095,30521077:30568320,30521078:30567082,30521107:30565574,30521108:30527666,30521110:30565312,30522092:30530610,30522351:30525627,30522593:30524500,30535121:30559510,30535400:30558891,30535629:30547695,30535872:30552271,30536162:30561663,30536530:30550998,30540344:30550126,30546578:30553213,30605140:30605399,30605141:30605479,30605160:3060570', 'assoc_mat': '30381759:Teint_Dans_La_Masse:3726:30381880,30382058:Teint_Dans_La_Masse:3726:30382380,30382060:Teint_Dans_La_Masse:3726:30382280,30384019:Teint_Dans_La_Masse:3726:30384061,30412041:Teint_Dans_La_Masse:3726:30412257,30412362:Teint_Dans_La_Masse:3726:30412590,30412374:Teint_Dans_La_Masse:3726:30412433,30412376:Teint_Dans_La_Masse:3726:30412413,30414126:Teint_Dans_La_Masse:3726:30414214,30414405:Teint_Dans_La_Masse:3726:30415447,30414406:Teint_Dans_La_Masse:3726:30414478,30415517:Teint_Dans_La_Masse:3726:30415634,30425112:Teint_Dans_La_Masse:3726:30425212,30425700:Teint_Dans_La_Masse:3726:30426765,30426812:Teint_Dans_La_Masse:3726:30426899,30427490:Teint_Dans_La_Masse:3726:30428184,30428962:Teint_Dans_La_Masse:3726:30429041,30430918:Teint_Dans_La_Masse:3726:30431019,30430919:Teint_Dans_La_Masse:3726:30430999,30437094:Teint_Dans_La_Masse:3726:30437168,30438441:Teint_Dans_La_Masse:3726:30438483,30464567:Teint_Dans_La_Masse:3726:30464621,30485832:Teint_Dans_La_Masse:3726:30486153,30486953:Teint_Dans_La_Masse:3726:3'}) 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(2926739,2926753,2908200,2911351,2912630,2913265,2926763,2925740,2936996,2936990,2936986,2936984,2936982)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496467, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30381874,30382278,30382373,30384053,30412251,30412414,30412432,30412581,30414218,30414467,30415445,30415637,30425208,30426773,30426892,30428188,30429044,30430997,30431023,30437170,30438492,30464628,30486154,30487098,30489273,30521384,30521411,30521441,30521467,30521491,30521535,30524497,30525619,30527672,30530608,30547690,30550127,30550996,30552269,30553208,30558896,30559514,30561661,30565575,30567076,30568318,30568569,30568654,30568839,30568992,30569097,30605200,30605218,30605259,30605281,30605310,30605356,30605374,30605407,30605480,30605510,30605655,30605679,30605704,30605736,30605778,30606050,30606350 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496468, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30381870,30382276,30382378,30384062,30412250,30412416,30412438,30412582,30414224,30414468,30415450,30415638,30425209,30426762,30426901,30428189,30429049,30430996,30431024,30437171,30438493,30464624,30486156,30487090,30489274,30508739,30521379,30521404,30521440,30521457,30521497,30521530,30524508,30525622,30527673,30530613,30547688,30550125,30550992,30552275,30553214,30558898,30559505,30561668,30565317,30565571,30567075,30568317,30568539,30568571,30568651,30568837,30568986,30569094,30605193,30605219,30605251,30605285,30605312,30605355,30605373,30605401,30605476,30605511,30605658,30605685,30605713,30605740,30605779,30606049,30606347 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496469, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30381871,30382285,30382371,30384055,30412259,30412408,30412439,30412591,30414219,30414469,30415451,30415629,30425214,30426767,30426893,30428194,30429038,30430998,30431027,30437166,30438482,30464630,30486149,30487092,30489280,30508729,30521380,30521407,30521442,30521462,30521495,30521531,30524505,30525616,30527664,30530609,30547691,30550117,30550999,30552276,30553210,30558901,30559509,30561658,30565313,30565566,30567084,30568314,30568543,30568576,30568650,30568836,30568988,30569090,30605195,30605220,30605258,30605289,30605317,30605350,30605376,30605406,30605483,30605516,30605653,30605682,30605712,30605737,30605783,30606045,30606344 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496470, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30382275,30382377,30384052,30412253,30412436,30412585,30414216,30414477,30415444,30415635,30425215,30426769,30426897,30428187,30429048,30431000,30431025,30437165,30438490,30464626,30486148,30487093,30489277,30521378,30521409,30521432,30521466,30521488,30521533,30524506,30525621,30527665,30547686,30550124,30550989,30552277,30553217,30558899,30559507,30561667,30567080,30568319,30568573,30568646,30568830,30568995,30569091,30605197,30605226,30605250,30605284,30605314,30605345,30605384,30605405,30605478,30605518,30605659,30605680,30605705,30605735,30605786,30606041,30606340 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496471, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30381877,30412410,30412437,30415628,30425207,30426890,30431026,30438491,30464631,30486150,30489272,30508742,30521382,30521458,30521538,30527671,30530611,30547687,30550995,30552266,30553211,30558893,30559513,30561664,30568645,30605257,30605311,30605348,30605379,30605482,30605515,30605663,30605683,30605789 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496472, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30384056,30431021,30438486,30521465,30521536,30561659,30565576,30568540,30605222,30605309,30605354,30605377,30605513 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496473, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30381873,30382279,30382376,30384051,30412258,30412417,30412441,30412592,30414213,30414474,30415448,30415633,30425210,30426764,30426894,30428186,30429040,30431003,30431022,30437174,30438488,30464627,30486159,30487095,30489281,30521388,30521410,30521435,30521464,30521489,30521534,30524507,30525623,30527675,30530614,30547689,30550116,30550991,30552270,30553207,30558890,30559512,30561665,30565311,30565565,30567081,30568322,30568533,30568572,30568649,30568831,30568994,30569089,30605190,30605217,30605252,30605279,30605315,30605351,30605378,30605403,30605486,30605519,30605657,30605681,30605708,30605745,30605780,30606044,30606346 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496474, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30381880,30382280,30382380,30384061,30412257,30412413,30412433,30412590,30414214,30414478,30415447,30415634,30425212,30426765,30426899,30428184,30429041,30430999,30431019,30437168,30438483,30464621,30486153,30487097,30489278,30508725,30521381,30521412,30521439,30521459,30521498,30521532,30524500,30525627,30527666,30530610,30547695,30550126,30550998,30552271,30553213,30558891,30559510,30561663,30565312,30565574,30567082,30568320,30568534,30568574,30568656,30568832,30568989,30569095,30605196,30605221,30605249,30605282,30605308,30605353,30605385,30605399,30605479,30605514,30605654,30605677,30605703,30605741,30605787,30606051,30606342 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for JRM : https://www.fotonower.com/velours/30496467,30496468,30496469,30496470,30496471,30496472,30496473,30496474?tags=autre_refus,cartonnette,Carton_brun,Carton_gris,kraft,metal,plastique,Teint_Dans_La_Masse 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 >='2026-02-01' and date <= '2026-02-28') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((6041,),), 'unwanted_material_monthly_percentage': ((0.15352799057147476,),), 'material_repartition': (('JRM', 3100),), 'material_dict': {'JRM': 3100}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 6), 0.1195386450758279, 89), (datetime.date(2026, 2, 9), 0.1320329860633672, 16), (datetime.date(2026, 2, 13), 0.15411783970154752, 89), (datetime.date(2026, 2, 16), 0.13557408690549047, 83), (datetime.date(2026, 2, 17), 0.19137160704019215, 95), (datetime.date(2026, 2, 18), 0.17069889400473126, 67), (datetime.date(2026, 2, 19), 0.1752433515047523, 35), (datetime.date(2026, 2, 20), 0.13387001950580255, 95), (datetime.date(2026, 2, 23), 0.17255932126433166, 93), (datetime.date(2026, 2, 24), 0.15978554065374034, 98), (datetime.date(2026, 2, 25), 0.13214944594263317, 83), (datetime.date(2026, 2, 26), 0.19106422805069373, 79), (datetime.date(2026, 2, 27), 0.12315782411931644, 86)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2026, 2, 6), 0.1195386450758279, 89), (datetime.date(2026, 2, 9), 0.1320329860633672, 16), (datetime.date(2026, 2, 13), 0.15411783970154752, 89), (datetime.date(2026, 2, 16), 0.13557408690549047, 83), (datetime.date(2026, 2, 17), 0.19137160704019215, 95), (datetime.date(2026, 2, 18), 0.17069889400473126, 67), (datetime.date(2026, 2, 19), 0.1752433515047523, 35), (datetime.date(2026, 2, 20), 0.13387001950580255, 95), (datetime.date(2026, 2, 23), 0.17255932126433166, 93), (datetime.date(2026, 2, 24), 0.15978554065374034, 98), (datetime.date(2026, 2, 25), 0.13214944594263317, 83), (datetime.date(2026, 2, 26), 0.19106422805069373, 79), (datetime.date(2026, 2, 27), 0.12315782411931644, 86))}, 'quality_array': [['-1.5498876016796466', '06022026'], ['-0.9961640022335935', '09022026'], ['-1.6873358380681573', '13022026'], ['-1.8032657732162876', '16022026'], ['-1.7145224340589666', '17022026'], ['-0.5277395063477651', '18022026'], ['-1.1125153492303608', '19022026'], ['-1.2386737836529735', '20022026'], ['-1.5705199231802351', '23022026'], ['-1.4560774560906062', '24022026'], ['-2.2373301887548176', '25022026'], ['-1.2547558165835784', '26022026'], ['-0.8611108856304283', '27022026']], 'number_of_batch': ((75,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016496614860124787, 'nb_photo': 720, 'list_port_cont': '30381874,30382278,30382373,30384053,30412251,30412414,30412432,30412581,30414218,30414467,30415445,30415637,30425208,30426773,30426892,30428188,30429044,30430997,30431023,30437170,30438492,30464628,30486154,30487098,30489273,30521384,30521411,30521441,30521467,30521491,30521535,30524497,30525619,30527672,30530608,30547690,30550127,30550996,30552269,30553208,30558896,30559514,30561661,30565575,30567076,30568318,30568569,30568654,30568839,30568992,30569097,30605200,30605218,30605259,30605281,30605310,30605356,30605374,30605407,30605480,30605510,30605655,30605679,30605704,30605736,30605778,30606050,30606350', 'assoc_port': '30381759:30381874,30382058:30382373,30382060:30382278,30384019:30384053,30412041:30412251,30412362:30412581,30412374:30412432,30412376:30412414,30414126:30414218,30414405:30415445,30414406:30414467,30415517:30415637,30425112:30425208,30425700:30426773,30426812:30426892,30427490:30428188,30428962:30429044,30430918:30431023,30430919:30430997,30437094:30437170,30438441:30438492,30464567:30464628,30485832:30486154,30486953:30487098,30489165:30489273,30520972:30521384,30520973:30521411,30520974:30521441,30520975:30521467,30520995:30521491,30520996:30521535,30521056:30568569,30521057:30568654,30521058:30568839,30521059:30568992,30521060:30569097,30521077:30568318,30521078:30567076,30521107:30565575,30521108:30527672,30522092:30530608,30522351:30525619,30522593:30524497,30535121:30559514,30535400:30558896,30535629:30547690,30535872:30552269,30536162:30561661,30536530:30550996,30540344:30550127,30546578:30553208,30605140:30605407,30605141:30605480,30605160:30605704,30605161:30605736,30605162:30605778,30605163:3060567', 'assoc_mat': '30381759:autre_refus:3726:30381874,30382058:autre_refus:3726:30382373,30382060:autre_refus:3726:30382278,30384019:autre_refus:3726:30384053,30412041:autre_refus:3726:30412251,30412362:autre_refus:3726:30412581,30412374:autre_refus:3726:30412432,30412376:autre_refus:3726:30412414,30414126:autre_refus:3726:30414218,30414405:autre_refus:3726:30415445,30414406:autre_refus:3726:30414467,30415517:autre_refus:3726:30415637,30425112:autre_refus:3726:30425208,30425700:autre_refus:3726:30426773,30426812:autre_refus:3726:30426892,30427490:autre_refus:3726:30428188,30428962:autre_refus:3726:30429044,30430918:autre_refus:3726:30431023,30430919:autre_refus:3726:30430997,30437094:autre_refus:3726:30437170,30438441:autre_refus:3726:30438492,30464567:autre_refus:3726:30464628,30485832:autre_refus:3726:30486154,30486953:autre_refus:3726:30487098,30489165:autre_refus:3726:30489273,30520972:autre_refus:3726:30521384,30520973:autre_refus:3726:30521411,30520974:autre_refus:3726:30521441,30520975:autre_refus:3726:30521467,30520995:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013764370264938526, 'nb_photo': 1735, 'list_port_cont': '30381870,30382276,30382378,30384062,30412250,30412416,30412438,30412582,30414224,30414468,30415450,30415638,30425209,30426762,30426901,30428189,30429049,30430996,30431024,30437171,30438493,30464624,30486156,30487090,30489274,30508739,30521379,30521404,30521440,30521457,30521497,30521530,30524508,30525622,30527673,30530613,30547688,30550125,30550992,30552275,30553214,30558898,30559505,30561668,30565317,30565571,30567075,30568317,30568539,30568571,30568651,30568837,30568986,30569094,30605193,30605219,30605251,30605285,30605312,30605355,30605373,30605401,30605476,30605511,30605658,30605685,30605713,30605740,30605779,30606049,30606347', 'assoc_port': '30381759:30381870,30382058:30382378,30382060:30382276,30384019:30384062,30412041:30412250,30412362:30412582,30412374:30412438,30412376:30412416,30414126:30414224,30414405:30415450,30414406:30414468,30415517:30415638,30425112:30425209,30425700:30426762,30426812:30426901,30427490:30428189,30428962:30429049,30430918:30431024,30430919:30430996,30437094:30437171,30438441:30438493,30464567:30464624,30485832:30486156,30486953:30487090,30489165:30489274,30508645:30508739,30520972:30521379,30520973:30521404,30520974:30521440,30520975:30521457,30520995:30521497,30520996:30521530,30521055:30568539,30521056:30568571,30521057:30568651,30521058:30568837,30521059:30568986,30521060:30569094,30521077:30568317,30521078:30567075,30521107:30565571,30521108:30527673,30521110:30565317,30522092:30530613,30522351:30525622,30522593:30524508,30535121:30559505,30535400:30558898,30535629:30547688,30535872:30552275,30536162:30561668,30536530:30550992,30540344:30550125,30546578:30553214,30605140:30605401,30605141:30605476,30605160:3060571', 'assoc_mat': '30381759:cartonnette:3726:30381870,30382058:cartonnette:3726:30382378,30382060:cartonnette:3726:30382276,30384019:cartonnette:3726:30384062,30412041:cartonnette:3726:30412250,30412362:cartonnette:3726:30412582,30412374:cartonnette:3726:30412438,30412376:cartonnette:3726:30412416,30414126:cartonnette:3726:30414224,30414405:cartonnette:3726:30415450,30414406:cartonnette:3726:30414468,30415517:cartonnette:3726:30415638,30425112:cartonnette:3726:30425209,30425700:cartonnette:3726:30426762,30426812:cartonnette:3726:30426901,30427490:cartonnette:3726:30428189,30428962:cartonnette:3726:30429049,30430918:cartonnette:3726:30431024,30430919:cartonnette:3726:30430996,30437094:cartonnette:3726:30437171,30438441:cartonnette:3726:30438493,30464567:cartonnette:3726:30464624,30485832:cartonnette:3726:30486156,30486953:cartonnette:3726:30487090,30489165:cartonnette:3726:30489274,30508645:cartonnette:3726:30508739,30520972:cartonnette:3726:30521379,30520973:cartonnette:3726:30521404,30520974:cartonnette:3726:30521440,30520975:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.09394159603430927, 'nb_photo': 7534, 'list_port_cont': '30381871,30382285,30382371,30384055,30412259,30412408,30412439,30412591,30414219,30414469,30415451,30415629,30425214,30426767,30426893,30428194,30429038,30430998,30431027,30437166,30438482,30464630,30486149,30487092,30489280,30508729,30521380,30521407,30521442,30521462,30521495,30521531,30524505,30525616,30527664,30530609,30547691,30550117,30550999,30552276,30553210,30558901,30559509,30561658,30565313,30565566,30567084,30568314,30568543,30568576,30568650,30568836,30568988,30569090,30605195,30605220,30605258,30605289,30605317,30605350,30605376,30605406,30605483,30605516,30605653,30605682,30605712,30605737,30605783,30606045,30606344', 'assoc_port': '30381759:30381871,30382058:30382371,30382060:30382285,30384019:30384055,30412041:30412259,30412362:30412591,30412374:30412439,30412376:30412408,30414126:30414219,30414405:30415451,30414406:30414469,30415517:30415629,30425112:30425214,30425700:30426767,30426812:30426893,30427490:30428194,30428962:30429038,30430918:30431027,30430919:30430998,30437094:30437166,30438441:30438482,30464567:30464630,30485832:30486149,30486953:30487092,30489165:30489280,30508645:30508729,30520972:30521380,30520973:30521407,30520974:30521442,30520975:30521462,30520995:30521495,30520996:30521531,30521055:30568543,30521056:30568576,30521057:30568650,30521058:30568836,30521059:30568988,30521060:30569090,30521077:30568314,30521078:30567084,30521107:30565566,30521108:30527664,30521110:30565313,30522092:30530609,30522351:30525616,30522593:30524505,30535121:30559509,30535400:30558901,30535629:30547691,30535872:30552276,30536162:30561658,30536530:30550999,30540344:30550117,30546578:30553210,30605140:30605406,30605141:30605483,30605160:3060571', 'assoc_mat': '30381759:Carton_brun:3726:30381871,30382058:Carton_brun:3726:30382371,30382060:Carton_brun:3726:30382285,30384019:Carton_brun:3726:30384055,30412041:Carton_brun:3726:30412259,30412362:Carton_brun:3726:30412591,30412374:Carton_brun:3726:30412439,30412376:Carton_brun:3726:30412408,30414126:Carton_brun:3726:30414219,30414405:Carton_brun:3726:30415451,30414406:Carton_brun:3726:30414469,30415517:Carton_brun:3726:30415629,30425112:Carton_brun:3726:30425214,30425700:Carton_brun:3726:30426767,30426812:Carton_brun:3726:30426893,30427490:Carton_brun:3726:30428194,30428962:Carton_brun:3726:30429038,30430918:Carton_brun:3726:30431027,30430919:Carton_brun:3726:30430998,30437094:Carton_brun:3726:30437166,30438441:Carton_brun:3726:30438482,30464567:Carton_brun:3726:30464630,30485832:Carton_brun:3726:30486149,30486953:Carton_brun:3726:30487092,30489165:Carton_brun:3726:30489280,30508645:Carton_brun:3726:30508729,30520972:Carton_brun:3726:30521380,30520973:Carton_brun:3726:30521407,30520974:Carton_brun:3726:30521442,30520975:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004864504033003904, 'nb_photo': 186, 'list_port_cont': '30382275,30382377,30384052,30412253,30412436,30412585,30414216,30414477,30415444,30415635,30425215,30426769,30426897,30428187,30429048,30431000,30431025,30437165,30438490,30464626,30486148,30487093,30489277,30521378,30521409,30521432,30521466,30521488,30521533,30524506,30525621,30527665,30547686,30550124,30550989,30552277,30553217,30558899,30559507,30561667,30567080,30568319,30568573,30568646,30568830,30568995,30569091,30605197,30605226,30605250,30605284,30605314,30605345,30605384,30605405,30605478,30605518,30605659,30605680,30605705,30605735,30605786,30606041,30606340', 'assoc_port': '30382058:30382377,30382060:30382275,30384019:30384052,30412041:30412253,30412362:30412585,30412374:30412436,30414126:30414216,30414405:30415444,30414406:30414477,30415517:30415635,30425112:30425215,30425700:30426769,30426812:30426897,30427490:30428187,30428962:30429048,30430918:30431025,30430919:30431000,30437094:30437165,30438441:30438490,30464567:30464626,30485832:30486148,30486953:30487093,30489165:30489277,30520972:30521378,30520973:30521409,30520974:30521432,30520975:30521466,30520995:30521488,30520996:30521533,30521056:30568573,30521057:30568646,30521058:30568830,30521059:30568995,30521060:30569091,30521077:30568319,30521078:30567080,30521108:30527665,30522351:30525621,30522593:30524506,30535121:30559507,30535400:30558899,30535629:30547686,30535872:30552277,30536162:30561667,30536530:30550989,30540344:30550124,30546578:30553217,30605140:30605405,30605141:30605478,30605160:30605705,30605161:30605735,30605162:30605786,30605163:30605680,30605164:30606340,30605165:30605659,30605166:30605197,30605170:3060551', 'assoc_mat': '30382058:Carton_gris:3726:30382377,30382060:Carton_gris:3726:30382275,30384019:Carton_gris:3726:30384052,30412041:Carton_gris:3726:30412253,30412362:Carton_gris:3726:30412585,30412374:Carton_gris:3726:30412436,30414126:Carton_gris:3726:30414216,30414405:Carton_gris:3726:30415444,30414406:Carton_gris:3726:30414477,30415517:Carton_gris:3726:30415635,30425112:Carton_gris:3726:30425215,30425700:Carton_gris:3726:30426769,30426812:Carton_gris:3726:30426897,30427490:Carton_gris:3726:30428187,30428962:Carton_gris:3726:30429048,30430918:Carton_gris:3726:30431025,30430919:Carton_gris:3726:30431000,30437094:Carton_gris:3726:30437165,30438441:Carton_gris:3726:30438490,30464567:Carton_gris:3726:30464626,30485832:Carton_gris:3726:30486148,30486953:Carton_gris:3726:30487093,30489165:Carton_gris:3726:30489277,30520972:Carton_gris:3726:30521378,30520973:Carton_gris:3726:30521409,30520974:Carton_gris:3726:30521432,30520975:Carton_gris:3726:30521466,30520995:Carton_gris:3726:30521488,30520996:Carton_gris:3726:30521533,30521056:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00441999858282396, 'nb_photo': 71, 'list_port_cont': '30381877,30412410,30412437,30415628,30425207,30426890,30431026,30438491,30464631,30486150,30489272,30508742,30521382,30521458,30521538,30527671,30530611,30547687,30550995,30552266,30553211,30558893,30559513,30561664,30568645,30605257,30605311,30605348,30605379,30605482,30605515,30605663,30605683,30605789', 'assoc_port': '30381759:30381877,30412374:30412437,30412376:30412410,30415517:30415628,30425112:30425207,30426812:30426890,30430918:30431026,30438441:30438491,30464567:30464631,30485832:30486150,30489165:30489272,30508645:30508742,30520972:30521382,30520975:30521458,30520996:30521538,30521057:30568645,30521108:30527671,30522092:30530611,30535121:30559513,30535400:30558893,30535629:30547687,30535872:30552266,30536162:30561664,30536530:30550995,30546578:30553211,30605141:30605482,30605162:30605789,30605163:30605683,30605165:30605663,30605170:30605515,30605171:30605379,30605174:30605348,30605176:30605257,30605187:30605311', 'assoc_mat': '30381759:kraft:3726:30381877,30412374:kraft:3726:30412437,30412376:kraft:3726:30412410,30415517:kraft:3726:30415628,30425112:kraft:3726:30425207,30426812:kraft:3726:30426890,30430918:kraft:3726:30431026,30438441:kraft:3726:30438491,30464567:kraft:3726:30464631,30485832:kraft:3726:30486150,30489165:kraft:3726:30489272,30508645:kraft:3726:30508742,30520972:kraft:3726:30521382,30520975:kraft:3726:30521458,30520996:kraft:3726:30521538,30521057:kraft:3726:30568645,30521108:kraft:3726:30527671,30522092:kraft:3726:30530611,30535121:kraft:3726:30559513,30535400:kraft:3726:30558893,30535629:kraft:3726:30547687,30535872:kraft:3726:30552266,30536162:kraft:3726:30561664,30536530:kraft:3726:30550995,30546578:kraft:3726:30553211,30605141:kraft:3726:30605482,30605162:kraft:3726:30605789,30605163:kraft:3726:30605683,30605165:kraft:3726:30605663,30605170:kraft:3726:30605515,30605171:kraft:3726:30605379,30605174:kraft:3726:30605348,30605176:kraft:3726:30605257,30605187:kraft:3726:30605311'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0023790048704467157, 'nb_photo': 17, 'list_port_cont': '30384056,30431021,30438486,30521465,30521536,30561659,30565576,30568540,30605222,30605309,30605354,30605377,30605513', 'assoc_port': '30384019:30384056,30430918:30431021,30438441:30438486,30520975:30521465,30520996:30521536,30521055:30568540,30521107:30565576,30536162:30561659,30605170:30605513,30605171:30605377,30605174:30605354,30605177:30605222,30605187:30605309', 'assoc_mat': '30384019:metal:3726:30384056,30430918:metal:3726:30431021,30438441:metal:3726:30438486,30520975:metal:3726:30521465,30520996:metal:3726:30521536,30521055:metal:3726:30568540,30521107:metal:3726:30565576,30536162:metal:3726:30561659,30605170:metal:3726:30605513,30605171:metal:3726:30605377,30605174:metal:3726:30605354,30605177:metal:3726:30605222,30605187:metal:3726:30605309'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016626118878463148, 'nb_photo': 1740, 'list_port_cont': '30381873,30382279,30382376,30384051,30412258,30412417,30412441,30412592,30414213,30414474,30415448,30415633,30425210,30426764,30426894,30428186,30429040,30431003,30431022,30437174,30438488,30464627,30486159,30487095,30489281,30521388,30521410,30521435,30521464,30521489,30521534,30524507,30525623,30527675,30530614,30547689,30550116,30550991,30552270,30553207,30558890,30559512,30561665,30565311,30565565,30567081,30568322,30568533,30568572,30568649,30568831,30568994,30569089,30605190,30605217,30605252,30605279,30605315,30605351,30605378,30605403,30605486,30605519,30605657,30605681,30605708,30605745,30605780,30606044,30606346', 'assoc_port': '30381759:30381873,30382058:30382376,30382060:30382279,30384019:30384051,30412041:30412258,30412362:30412592,30412374:30412441,30412376:30412417,30414126:30414213,30414405:30415448,30414406:30414474,30415517:30415633,30425112:30425210,30425700:30426764,30426812:30426894,30427490:30428186,30428962:30429040,30430918:30431022,30430919:30431003,30437094:30437174,30438441:30438488,30464567:30464627,30485832:30486159,30486953:30487095,30489165:30489281,30520972:30521388,30520973:30521410,30520974:30521435,30520975:30521464,30520995:30521489,30520996:30521534,30521055:30568533,30521056:30568572,30521057:30568649,30521058:30568831,30521059:30568994,30521060:30569089,30521077:30568322,30521078:30567081,30521107:30565565,30521108:30527675,30521110:30565311,30522092:30530614,30522351:30525623,30522593:30524507,30535121:30559512,30535400:30558890,30535629:30547689,30535872:30552270,30536162:30561665,30536530:30550991,30540344:30550116,30546578:30553207,30605140:30605403,30605141:30605486,30605160:30605708,30605161:3060574', 'assoc_mat': '30381759:plastique:3726:30381873,30382058:plastique:3726:30382376,30382060:plastique:3726:30382279,30384019:plastique:3726:30384051,30412041:plastique:3726:30412258,30412362:plastique:3726:30412592,30412374:plastique:3726:30412441,30412376:plastique:3726:30412417,30414126:plastique:3726:30414213,30414405:plastique:3726:30415448,30414406:plastique:3726:30414474,30415517:plastique:3726:30415633,30425112:plastique:3726:30425210,30425700:plastique:3726:30426764,30426812:plastique:3726:30426894,30427490:plastique:3726:30428186,30428962:plastique:3726:30429040,30430918:plastique:3726:30431022,30430919:plastique:3726:30431003,30437094:plastique:3726:30437174,30438441:plastique:3726:30438488,30464567:plastique:3726:30464627,30485832:plastique:3726:30486159,30486953:plastique:3726:30487095,30489165:plastique:3726:30489281,30520972:plastique:3726:30521388,30520973:plastique:3726:30521410,30520974:plastique:3726:30521435,30520975:plastique:3726:30521464,30520995:plastique:3726:30521489,30520996:plastique:3726:30521534,3'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.020714652414180326, 'nb_photo': 3569, 'list_port_cont': '30381880,30382280,30382380,30384061,30412257,30412413,30412433,30412590,30414214,30414478,30415447,30415634,30425212,30426765,30426899,30428184,30429041,30430999,30431019,30437168,30438483,30464621,30486153,30487097,30489278,30508725,30521381,30521412,30521439,30521459,30521498,30521532,30524500,30525627,30527666,30530610,30547695,30550126,30550998,30552271,30553213,30558891,30559510,30561663,30565312,30565574,30567082,30568320,30568534,30568574,30568656,30568832,30568989,30569095,30605196,30605221,30605249,30605282,30605308,30605353,30605385,30605399,30605479,30605514,30605654,30605677,30605703,30605741,30605787,30606051,30606342', 'assoc_port': '30381759:30381880,30382058:30382380,30382060:30382280,30384019:30384061,30412041:30412257,30412362:30412590,30412374:30412433,30412376:30412413,30414126:30414214,30414405:30415447,30414406:30414478,30415517:30415634,30425112:30425212,30425700:30426765,30426812:30426899,30427490:30428184,30428962:30429041,30430918:30431019,30430919:30430999,30437094:30437168,30438441:30438483,30464567:30464621,30485832:30486153,30486953:30487097,30489165:30489278,30508645:30508725,30520972:30521381,30520973:30521412,30520974:30521439,30520975:30521459,30520995:30521498,30520996:30521532,30521055:30568534,30521056:30568574,30521057:30568656,30521058:30568832,30521059:30568989,30521060:30569095,30521077:30568320,30521078:30567082,30521107:30565574,30521108:30527666,30521110:30565312,30522092:30530610,30522351:30525627,30522593:30524500,30535121:30559510,30535400:30558891,30535629:30547695,30535872:30552271,30536162:30561663,30536530:30550998,30540344:30550126,30546578:30553213,30605140:30605399,30605141:30605479,30605160:3060570', 'assoc_mat': '30381759:Teint_Dans_La_Masse:3726:30381880,30382058:Teint_Dans_La_Masse:3726:30382380,30382060:Teint_Dans_La_Masse:3726:30382280,30384019:Teint_Dans_La_Masse:3726:30384061,30412041:Teint_Dans_La_Masse:3726:30412257,30412362:Teint_Dans_La_Masse:3726:30412590,30412374:Teint_Dans_La_Masse:3726:30412433,30412376:Teint_Dans_La_Masse:3726:30412413,30414126:Teint_Dans_La_Masse:3726:30414214,30414405:Teint_Dans_La_Masse:3726:30415447,30414406:Teint_Dans_La_Masse:3726:30414478,30415517:Teint_Dans_La_Masse:3726:30415634,30425112:Teint_Dans_La_Masse:3726:30425212,30425700:Teint_Dans_La_Masse:3726:30426765,30426812:Teint_Dans_La_Masse:3726:30426899,30427490:Teint_Dans_La_Masse:3726:30428184,30428962:Teint_Dans_La_Masse:3726:30429041,30430918:Teint_Dans_La_Masse:3726:30431019,30430919:Teint_Dans_La_Masse:3726:30430999,30437094:Teint_Dans_La_Masse:3726:30437168,30438441:Teint_Dans_La_Masse:3726:30438483,30464567:Teint_Dans_La_Masse:3726:30464621,30485832:Teint_Dans_La_Masse:3726:30486153,30486953:Teint_Dans_La_Masse:3726:3'}), 'main_stat': {'nb_photos': 6041}, 'velours_link': {'JRM': 'https://www.fotonower.com/velours/30496467,30496468,30496469,30496470,30496471,30496472,30496473,30496474?tags=autre_refus,cartonnette,Carton_brun,Carton_gris,kraft,metal,plastique,Teint_Dans_La_Masse'}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2026-02', 0.15352799057147476),)]} VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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': ((6041,),), 'unwanted_material_monthly_percentage': ((0.15352799057147476,),), 'material_repartition': (('JRM', 3100),), 'material_dict': {'JRM': 3100}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 6), 0.1195386450758279, 89), (datetime.date(2026, 2, 9), 0.1320329860633672, 16), (datetime.date(2026, 2, 13), 0.15411783970154752, 89), (datetime.date(2026, 2, 16), 0.13557408690549047, 83), (datetime.date(2026, 2, 17), 0.19137160704019215, 95), (datetime.date(2026, 2, 18), 0.17069889400473126, 67), (datetime.date(2026, 2, 19), 0.1752433515047523, 35), (datetime.date(2026, 2, 20), 0.13387001950580255, 95), (datetime.date(2026, 2, 23), 0.17255932126433166, 93), (datetime.date(2026, 2, 24), 0.15978554065374034, 98), (datetime.date(2026, 2, 25), 0.13214944594263317, 83), (datetime.date(2026, 2, 26), 0.19106422805069373, 79), (datetime.date(2026, 2, 27), 0.12315782411931644, 86)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2026, 2, 6), 0.1195386450758279, 89), (datetime.date(2026, 2, 9), 0.1320329860633672, 16), (datetime.date(2026, 2, 13), 0.15411783970154752, 89), (datetime.date(2026, 2, 16), 0.13557408690549047, 83), (datetime.date(2026, 2, 17), 0.19137160704019215, 95), (datetime.date(2026, 2, 18), 0.17069889400473126, 67), (datetime.date(2026, 2, 19), 0.1752433515047523, 35), (datetime.date(2026, 2, 20), 0.13387001950580255, 95), (datetime.date(2026, 2, 23), 0.17255932126433166, 93), (datetime.date(2026, 2, 24), 0.15978554065374034, 98), (datetime.date(2026, 2, 25), 0.13214944594263317, 83), (datetime.date(2026, 2, 26), 0.19106422805069373, 79), (datetime.date(2026, 2, 27), 0.12315782411931644, 86))}, 'quality_array': [['-1.5498876016796466', '06022026'], ['-0.9961640022335935', '09022026'], ['-1.6873358380681573', '13022026'], ['-1.8032657732162876', '16022026'], ['-1.7145224340589666', '17022026'], ['-0.5277395063477651', '18022026'], ['-1.1125153492303608', '19022026'], ['-1.2386737836529735', '20022026'], ['-1.5705199231802351', '23022026'], ['-1.4560774560906062', '24022026'], ['-2.2373301887548176', '25022026'], ['-1.2547558165835784', '26022026'], ['-0.8611108856304283', '27022026']], 'number_of_batch': ((75,),), 'datou_id_sts': 4189, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016496614860124787, 'nb_photo': 720, 'list_port_cont': '30381874,30382278,30382373,30384053,30412251,30412414,30412432,30412581,30414218,30414467,30415445,30415637,30425208,30426773,30426892,30428188,30429044,30430997,30431023,30437170,30438492,30464628,30486154,30487098,30489273,30521384,30521411,30521441,30521467,30521491,30521535,30524497,30525619,30527672,30530608,30547690,30550127,30550996,30552269,30553208,30558896,30559514,30561661,30565575,30567076,30568318,30568569,30568654,30568839,30568992,30569097,30605200,30605218,30605259,30605281,30605310,30605356,30605374,30605407,30605480,30605510,30605655,30605679,30605704,30605736,30605778,30606050,30606350', 'assoc_port': '30381759:30381874,30382058:30382373,30382060:30382278,30384019:30384053,30412041:30412251,30412362:30412581,30412374:30412432,30412376:30412414,30414126:30414218,30414405:30415445,30414406:30414467,30415517:30415637,30425112:30425208,30425700:30426773,30426812:30426892,30427490:30428188,30428962:30429044,30430918:30431023,30430919:30430997,30437094:30437170,30438441:30438492,30464567:30464628,30485832:30486154,30486953:30487098,30489165:30489273,30520972:30521384,30520973:30521411,30520974:30521441,30520975:30521467,30520995:30521491,30520996:30521535,30521056:30568569,30521057:30568654,30521058:30568839,30521059:30568992,30521060:30569097,30521077:30568318,30521078:30567076,30521107:30565575,30521108:30527672,30522092:30530608,30522351:30525619,30522593:30524497,30535121:30559514,30535400:30558896,30535629:30547690,30535872:30552269,30536162:30561661,30536530:30550996,30540344:30550127,30546578:30553208,30605140:30605407,30605141:30605480,30605160:30605704,30605161:30605736,30605162:30605778,30605163:3060567', 'assoc_mat': '30381759:autre_refus:3726:30381874,30382058:autre_refus:3726:30382373,30382060:autre_refus:3726:30382278,30384019:autre_refus:3726:30384053,30412041:autre_refus:3726:30412251,30412362:autre_refus:3726:30412581,30412374:autre_refus:3726:30412432,30412376:autre_refus:3726:30412414,30414126:autre_refus:3726:30414218,30414405:autre_refus:3726:30415445,30414406:autre_refus:3726:30414467,30415517:autre_refus:3726:30415637,30425112:autre_refus:3726:30425208,30425700:autre_refus:3726:30426773,30426812:autre_refus:3726:30426892,30427490:autre_refus:3726:30428188,30428962:autre_refus:3726:30429044,30430918:autre_refus:3726:30431023,30430919:autre_refus:3726:30430997,30437094:autre_refus:3726:30437170,30438441:autre_refus:3726:30438492,30464567:autre_refus:3726:30464628,30485832:autre_refus:3726:30486154,30486953:autre_refus:3726:30487098,30489165:autre_refus:3726:30489273,30520972:autre_refus:3726:30521384,30520973:autre_refus:3726:30521411,30520974:autre_refus:3726:30521441,30520975:autre_refus:3726:30521467,30520995:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013764370264938526, 'nb_photo': 1735, 'list_port_cont': '30381870,30382276,30382378,30384062,30412250,30412416,30412438,30412582,30414224,30414468,30415450,30415638,30425209,30426762,30426901,30428189,30429049,30430996,30431024,30437171,30438493,30464624,30486156,30487090,30489274,30508739,30521379,30521404,30521440,30521457,30521497,30521530,30524508,30525622,30527673,30530613,30547688,30550125,30550992,30552275,30553214,30558898,30559505,30561668,30565317,30565571,30567075,30568317,30568539,30568571,30568651,30568837,30568986,30569094,30605193,30605219,30605251,30605285,30605312,30605355,30605373,30605401,30605476,30605511,30605658,30605685,30605713,30605740,30605779,30606049,30606347', 'assoc_port': '30381759:30381870,30382058:30382378,30382060:30382276,30384019:30384062,30412041:30412250,30412362:30412582,30412374:30412438,30412376:30412416,30414126:30414224,30414405:30415450,30414406:30414468,30415517:30415638,30425112:30425209,30425700:30426762,30426812:30426901,30427490:30428189,30428962:30429049,30430918:30431024,30430919:30430996,30437094:30437171,30438441:30438493,30464567:30464624,30485832:30486156,30486953:30487090,30489165:30489274,30508645:30508739,30520972:30521379,30520973:30521404,30520974:30521440,30520975:30521457,30520995:30521497,30520996:30521530,30521055:30568539,30521056:30568571,30521057:30568651,30521058:30568837,30521059:30568986,30521060:30569094,30521077:30568317,30521078:30567075,30521107:30565571,30521108:30527673,30521110:30565317,30522092:30530613,30522351:30525622,30522593:30524508,30535121:30559505,30535400:30558898,30535629:30547688,30535872:30552275,30536162:30561668,30536530:30550992,30540344:30550125,30546578:30553214,30605140:30605401,30605141:30605476,30605160:3060571', 'assoc_mat': '30381759:cartonnette:3726:30381870,30382058:cartonnette:3726:30382378,30382060:cartonnette:3726:30382276,30384019:cartonnette:3726:30384062,30412041:cartonnette:3726:30412250,30412362:cartonnette:3726:30412582,30412374:cartonnette:3726:30412438,30412376:cartonnette:3726:30412416,30414126:cartonnette:3726:30414224,30414405:cartonnette:3726:30415450,30414406:cartonnette:3726:30414468,30415517:cartonnette:3726:30415638,30425112:cartonnette:3726:30425209,30425700:cartonnette:3726:30426762,30426812:cartonnette:3726:30426901,30427490:cartonnette:3726:30428189,30428962:cartonnette:3726:30429049,30430918:cartonnette:3726:30431024,30430919:cartonnette:3726:30430996,30437094:cartonnette:3726:30437171,30438441:cartonnette:3726:30438493,30464567:cartonnette:3726:30464624,30485832:cartonnette:3726:30486156,30486953:cartonnette:3726:30487090,30489165:cartonnette:3726:30489274,30508645:cartonnette:3726:30508739,30520972:cartonnette:3726:30521379,30520973:cartonnette:3726:30521404,30520974:cartonnette:3726:30521440,30520975:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.09394159603430927, 'nb_photo': 7534, 'list_port_cont': '30381871,30382285,30382371,30384055,30412259,30412408,30412439,30412591,30414219,30414469,30415451,30415629,30425214,30426767,30426893,30428194,30429038,30430998,30431027,30437166,30438482,30464630,30486149,30487092,30489280,30508729,30521380,30521407,30521442,30521462,30521495,30521531,30524505,30525616,30527664,30530609,30547691,30550117,30550999,30552276,30553210,30558901,30559509,30561658,30565313,30565566,30567084,30568314,30568543,30568576,30568650,30568836,30568988,30569090,30605195,30605220,30605258,30605289,30605317,30605350,30605376,30605406,30605483,30605516,30605653,30605682,30605712,30605737,30605783,30606045,30606344', 'assoc_port': '30381759:30381871,30382058:30382371,30382060:30382285,30384019:30384055,30412041:30412259,30412362:30412591,30412374:30412439,30412376:30412408,30414126:30414219,30414405:30415451,30414406:30414469,30415517:30415629,30425112:30425214,30425700:30426767,30426812:30426893,30427490:30428194,30428962:30429038,30430918:30431027,30430919:30430998,30437094:30437166,30438441:30438482,30464567:30464630,30485832:30486149,30486953:30487092,30489165:30489280,30508645:30508729,30520972:30521380,30520973:30521407,30520974:30521442,30520975:30521462,30520995:30521495,30520996:30521531,30521055:30568543,30521056:30568576,30521057:30568650,30521058:30568836,30521059:30568988,30521060:30569090,30521077:30568314,30521078:30567084,30521107:30565566,30521108:30527664,30521110:30565313,30522092:30530609,30522351:30525616,30522593:30524505,30535121:30559509,30535400:30558901,30535629:30547691,30535872:30552276,30536162:30561658,30536530:30550999,30540344:30550117,30546578:30553210,30605140:30605406,30605141:30605483,30605160:3060571', 'assoc_mat': '30381759:Carton_brun:3726:30381871,30382058:Carton_brun:3726:30382371,30382060:Carton_brun:3726:30382285,30384019:Carton_brun:3726:30384055,30412041:Carton_brun:3726:30412259,30412362:Carton_brun:3726:30412591,30412374:Carton_brun:3726:30412439,30412376:Carton_brun:3726:30412408,30414126:Carton_brun:3726:30414219,30414405:Carton_brun:3726:30415451,30414406:Carton_brun:3726:30414469,30415517:Carton_brun:3726:30415629,30425112:Carton_brun:3726:30425214,30425700:Carton_brun:3726:30426767,30426812:Carton_brun:3726:30426893,30427490:Carton_brun:3726:30428194,30428962:Carton_brun:3726:30429038,30430918:Carton_brun:3726:30431027,30430919:Carton_brun:3726:30430998,30437094:Carton_brun:3726:30437166,30438441:Carton_brun:3726:30438482,30464567:Carton_brun:3726:30464630,30485832:Carton_brun:3726:30486149,30486953:Carton_brun:3726:30487092,30489165:Carton_brun:3726:30489280,30508645:Carton_brun:3726:30508729,30520972:Carton_brun:3726:30521380,30520973:Carton_brun:3726:30521407,30520974:Carton_brun:3726:30521442,30520975:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004864504033003904, 'nb_photo': 186, 'list_port_cont': '30382275,30382377,30384052,30412253,30412436,30412585,30414216,30414477,30415444,30415635,30425215,30426769,30426897,30428187,30429048,30431000,30431025,30437165,30438490,30464626,30486148,30487093,30489277,30521378,30521409,30521432,30521466,30521488,30521533,30524506,30525621,30527665,30547686,30550124,30550989,30552277,30553217,30558899,30559507,30561667,30567080,30568319,30568573,30568646,30568830,30568995,30569091,30605197,30605226,30605250,30605284,30605314,30605345,30605384,30605405,30605478,30605518,30605659,30605680,30605705,30605735,30605786,30606041,30606340', 'assoc_port': '30382058:30382377,30382060:30382275,30384019:30384052,30412041:30412253,30412362:30412585,30412374:30412436,30414126:30414216,30414405:30415444,30414406:30414477,30415517:30415635,30425112:30425215,30425700:30426769,30426812:30426897,30427490:30428187,30428962:30429048,30430918:30431025,30430919:30431000,30437094:30437165,30438441:30438490,30464567:30464626,30485832:30486148,30486953:30487093,30489165:30489277,30520972:30521378,30520973:30521409,30520974:30521432,30520975:30521466,30520995:30521488,30520996:30521533,30521056:30568573,30521057:30568646,30521058:30568830,30521059:30568995,30521060:30569091,30521077:30568319,30521078:30567080,30521108:30527665,30522351:30525621,30522593:30524506,30535121:30559507,30535400:30558899,30535629:30547686,30535872:30552277,30536162:30561667,30536530:30550989,30540344:30550124,30546578:30553217,30605140:30605405,30605141:30605478,30605160:30605705,30605161:30605735,30605162:30605786,30605163:30605680,30605164:30606340,30605165:30605659,30605166:30605197,30605170:3060551', 'assoc_mat': '30382058:Carton_gris:3726:30382377,30382060:Carton_gris:3726:30382275,30384019:Carton_gris:3726:30384052,30412041:Carton_gris:3726:30412253,30412362:Carton_gris:3726:30412585,30412374:Carton_gris:3726:30412436,30414126:Carton_gris:3726:30414216,30414405:Carton_gris:3726:30415444,30414406:Carton_gris:3726:30414477,30415517:Carton_gris:3726:30415635,30425112:Carton_gris:3726:30425215,30425700:Carton_gris:3726:30426769,30426812:Carton_gris:3726:30426897,30427490:Carton_gris:3726:30428187,30428962:Carton_gris:3726:30429048,30430918:Carton_gris:3726:30431025,30430919:Carton_gris:3726:30431000,30437094:Carton_gris:3726:30437165,30438441:Carton_gris:3726:30438490,30464567:Carton_gris:3726:30464626,30485832:Carton_gris:3726:30486148,30486953:Carton_gris:3726:30487093,30489165:Carton_gris:3726:30489277,30520972:Carton_gris:3726:30521378,30520973:Carton_gris:3726:30521409,30520974:Carton_gris:3726:30521432,30520975:Carton_gris:3726:30521466,30520995:Carton_gris:3726:30521488,30520996:Carton_gris:3726:30521533,30521056:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00441999858282396, 'nb_photo': 71, 'list_port_cont': '30381877,30412410,30412437,30415628,30425207,30426890,30431026,30438491,30464631,30486150,30489272,30508742,30521382,30521458,30521538,30527671,30530611,30547687,30550995,30552266,30553211,30558893,30559513,30561664,30568645,30605257,30605311,30605348,30605379,30605482,30605515,30605663,30605683,30605789', 'assoc_port': '30381759:30381877,30412374:30412437,30412376:30412410,30415517:30415628,30425112:30425207,30426812:30426890,30430918:30431026,30438441:30438491,30464567:30464631,30485832:30486150,30489165:30489272,30508645:30508742,30520972:30521382,30520975:30521458,30520996:30521538,30521057:30568645,30521108:30527671,30522092:30530611,30535121:30559513,30535400:30558893,30535629:30547687,30535872:30552266,30536162:30561664,30536530:30550995,30546578:30553211,30605141:30605482,30605162:30605789,30605163:30605683,30605165:30605663,30605170:30605515,30605171:30605379,30605174:30605348,30605176:30605257,30605187:30605311', 'assoc_mat': '30381759:kraft:3726:30381877,30412374:kraft:3726:30412437,30412376:kraft:3726:30412410,30415517:kraft:3726:30415628,30425112:kraft:3726:30425207,30426812:kraft:3726:30426890,30430918:kraft:3726:30431026,30438441:kraft:3726:30438491,30464567:kraft:3726:30464631,30485832:kraft:3726:30486150,30489165:kraft:3726:30489272,30508645:kraft:3726:30508742,30520972:kraft:3726:30521382,30520975:kraft:3726:30521458,30520996:kraft:3726:30521538,30521057:kraft:3726:30568645,30521108:kraft:3726:30527671,30522092:kraft:3726:30530611,30535121:kraft:3726:30559513,30535400:kraft:3726:30558893,30535629:kraft:3726:30547687,30535872:kraft:3726:30552266,30536162:kraft:3726:30561664,30536530:kraft:3726:30550995,30546578:kraft:3726:30553211,30605141:kraft:3726:30605482,30605162:kraft:3726:30605789,30605163:kraft:3726:30605683,30605165:kraft:3726:30605663,30605170:kraft:3726:30605515,30605171:kraft:3726:30605379,30605174:kraft:3726:30605348,30605176:kraft:3726:30605257,30605187:kraft:3726:30605311'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0023790048704467157, 'nb_photo': 17, 'list_port_cont': '30384056,30431021,30438486,30521465,30521536,30561659,30565576,30568540,30605222,30605309,30605354,30605377,30605513', 'assoc_port': '30384019:30384056,30430918:30431021,30438441:30438486,30520975:30521465,30520996:30521536,30521055:30568540,30521107:30565576,30536162:30561659,30605170:30605513,30605171:30605377,30605174:30605354,30605177:30605222,30605187:30605309', 'assoc_mat': '30384019:metal:3726:30384056,30430918:metal:3726:30431021,30438441:metal:3726:30438486,30520975:metal:3726:30521465,30520996:metal:3726:30521536,30521055:metal:3726:30568540,30521107:metal:3726:30565576,30536162:metal:3726:30561659,30605170:metal:3726:30605513,30605171:metal:3726:30605377,30605174:metal:3726:30605354,30605177:metal:3726:30605222,30605187:metal:3726:30605309'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016626118878463148, 'nb_photo': 1740, 'list_port_cont': '30381873,30382279,30382376,30384051,30412258,30412417,30412441,30412592,30414213,30414474,30415448,30415633,30425210,30426764,30426894,30428186,30429040,30431003,30431022,30437174,30438488,30464627,30486159,30487095,30489281,30521388,30521410,30521435,30521464,30521489,30521534,30524507,30525623,30527675,30530614,30547689,30550116,30550991,30552270,30553207,30558890,30559512,30561665,30565311,30565565,30567081,30568322,30568533,30568572,30568649,30568831,30568994,30569089,30605190,30605217,30605252,30605279,30605315,30605351,30605378,30605403,30605486,30605519,30605657,30605681,30605708,30605745,30605780,30606044,30606346', 'assoc_port': '30381759:30381873,30382058:30382376,30382060:30382279,30384019:30384051,30412041:30412258,30412362:30412592,30412374:30412441,30412376:30412417,30414126:30414213,30414405:30415448,30414406:30414474,30415517:30415633,30425112:30425210,30425700:30426764,30426812:30426894,30427490:30428186,30428962:30429040,30430918:30431022,30430919:30431003,30437094:30437174,30438441:30438488,30464567:30464627,30485832:30486159,30486953:30487095,30489165:30489281,30520972:30521388,30520973:30521410,30520974:30521435,30520975:30521464,30520995:30521489,30520996:30521534,30521055:30568533,30521056:30568572,30521057:30568649,30521058:30568831,30521059:30568994,30521060:30569089,30521077:30568322,30521078:30567081,30521107:30565565,30521108:30527675,30521110:30565311,30522092:30530614,30522351:30525623,30522593:30524507,30535121:30559512,30535400:30558890,30535629:30547689,30535872:30552270,30536162:30561665,30536530:30550991,30540344:30550116,30546578:30553207,30605140:30605403,30605141:30605486,30605160:30605708,30605161:3060574', 'assoc_mat': '30381759:plastique:3726:30381873,30382058:plastique:3726:30382376,30382060:plastique:3726:30382279,30384019:plastique:3726:30384051,30412041:plastique:3726:30412258,30412362:plastique:3726:30412592,30412374:plastique:3726:30412441,30412376:plastique:3726:30412417,30414126:plastique:3726:30414213,30414405:plastique:3726:30415448,30414406:plastique:3726:30414474,30415517:plastique:3726:30415633,30425112:plastique:3726:30425210,30425700:plastique:3726:30426764,30426812:plastique:3726:30426894,30427490:plastique:3726:30428186,30428962:plastique:3726:30429040,30430918:plastique:3726:30431022,30430919:plastique:3726:30431003,30437094:plastique:3726:30437174,30438441:plastique:3726:30438488,30464567:plastique:3726:30464627,30485832:plastique:3726:30486159,30486953:plastique:3726:30487095,30489165:plastique:3726:30489281,30520972:plastique:3726:30521388,30520973:plastique:3726:30521410,30520974:plastique:3726:30521435,30520975:plastique:3726:30521464,30520995:plastique:3726:30521489,30520996:plastique:3726:30521534,3'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.020714652414180326, 'nb_photo': 3569, 'list_port_cont': '30381880,30382280,30382380,30384061,30412257,30412413,30412433,30412590,30414214,30414478,30415447,30415634,30425212,30426765,30426899,30428184,30429041,30430999,30431019,30437168,30438483,30464621,30486153,30487097,30489278,30508725,30521381,30521412,30521439,30521459,30521498,30521532,30524500,30525627,30527666,30530610,30547695,30550126,30550998,30552271,30553213,30558891,30559510,30561663,30565312,30565574,30567082,30568320,30568534,30568574,30568656,30568832,30568989,30569095,30605196,30605221,30605249,30605282,30605308,30605353,30605385,30605399,30605479,30605514,30605654,30605677,30605703,30605741,30605787,30606051,30606342', 'assoc_port': '30381759:30381880,30382058:30382380,30382060:30382280,30384019:30384061,30412041:30412257,30412362:30412590,30412374:30412433,30412376:30412413,30414126:30414214,30414405:30415447,30414406:30414478,30415517:30415634,30425112:30425212,30425700:30426765,30426812:30426899,30427490:30428184,30428962:30429041,30430918:30431019,30430919:30430999,30437094:30437168,30438441:30438483,30464567:30464621,30485832:30486153,30486953:30487097,30489165:30489278,30508645:30508725,30520972:30521381,30520973:30521412,30520974:30521439,30520975:30521459,30520995:30521498,30520996:30521532,30521055:30568534,30521056:30568574,30521057:30568656,30521058:30568832,30521059:30568989,30521060:30569095,30521077:30568320,30521078:30567082,30521107:30565574,30521108:30527666,30521110:30565312,30522092:30530610,30522351:30525627,30522593:30524500,30535121:30559510,30535400:30558891,30535629:30547695,30535872:30552271,30536162:30561663,30536530:30550998,30540344:30550126,30546578:30553213,30605140:30605399,30605141:30605479,30605160:3060570', 'assoc_mat': '30381759:Teint_Dans_La_Masse:3726:30381880,30382058:Teint_Dans_La_Masse:3726:30382380,30382060:Teint_Dans_La_Masse:3726:30382280,30384019:Teint_Dans_La_Masse:3726:30384061,30412041:Teint_Dans_La_Masse:3726:30412257,30412362:Teint_Dans_La_Masse:3726:30412590,30412374:Teint_Dans_La_Masse:3726:30412433,30412376:Teint_Dans_La_Masse:3726:30412413,30414126:Teint_Dans_La_Masse:3726:30414214,30414405:Teint_Dans_La_Masse:3726:30415447,30414406:Teint_Dans_La_Masse:3726:30414478,30415517:Teint_Dans_La_Masse:3726:30415634,30425112:Teint_Dans_La_Masse:3726:30425212,30425700:Teint_Dans_La_Masse:3726:30426765,30426812:Teint_Dans_La_Masse:3726:30426899,30427490:Teint_Dans_La_Masse:3726:30428184,30428962:Teint_Dans_La_Masse:3726:30429041,30430918:Teint_Dans_La_Masse:3726:30431019,30430919:Teint_Dans_La_Masse:3726:30430999,30437094:Teint_Dans_La_Masse:3726:30437168,30438441:Teint_Dans_La_Masse:3726:30438483,30464567:Teint_Dans_La_Masse:3726:30464621,30485832:Teint_Dans_La_Masse:3726:30486153,30486953:Teint_Dans_La_Masse:3726:3'}), 'main_stat': {'nb_photos': 6041}, 'velours_link': {'JRM': 'https://www.fotonower.com/velours/30496467,30496468,30496469,30496470,30496471,30496472,30496473,30496474?tags=autre_refus,cartonnette,Carton_brun,Carton_gris,kraft,metal,plastique,Teint_Dans_La_Masse'}}, 'hostname': (('raspi-95',),), 'impurety_average_per_hashtag': [(('JRM', '2026-02', 0.15352799057147476),)]} filepath : /data_4/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_02_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'JRM': {'autre_refus': ['autre_refus', '1.65%', 720], 'cartonnette': ['cartonnette', '1.38%', 1735], 'Carton_brun': ['Carton_brun', '9.39%', 7534], 'Carton_gris': ['Carton_gris', '0.49%', 186], 'kraft': ['kraft', '0.44%', 71], 'metal': ['metal', '0.24%', 17], 'plastique': ['plastique', '1.66%', 1740], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '2.07%', 3569]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/Perlen_convoyeur/sla_mensuel_Perlen_convoyeur_mois_02_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/Perlen_convoyeur 2.55user 3.21system 0:06.04elapsed 95%CPU (0avgtext+0avgdata 183876maxresident)k 8584inputs+336outputs (3major+53460minor)pagefaults 0swaps