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=30073 --dashboard_places=arc_en_ciel_jrm --rootfolder_sla=/data_4/data_log/job/memo/arc_en_ciel_jrm -v --mtr_id=979 --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 : 30073, Date : 2025-06 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 30) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4873 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=4873 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= 4873 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=4873 # 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=3459 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=3459 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= 3459 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=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 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,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} 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="arc_en_ciel_jrm"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4878 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=4878 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= 4878 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=4878 # 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=4302 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=4302 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= 4302 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=4302 # 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 ! 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 13596 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11881 final have less inputs used (1) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11881 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13625 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 11884 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 3 of step 11884 have datatype=6 WARNING : type of output 1 of step 13596 doesn't seem to be define in the database( WARNING : type of input 3 of step 11881 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 0 of step 13625 have datatype=18 WARNING : type of output 1 of step 13625 doesn't seem to be define in the database( WARNING : type of input 5 of step 11884 doesn't seem to be define in the database( 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': 2, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 30) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4873 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=4873 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= 4873 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=4873 # 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=3459 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=3459 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= 3459 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=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 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,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} 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="arc_en_ciel_jrm"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4878 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=4878 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= 4878 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=4878 # 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=4302 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=4302 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= 4302 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=4302 # 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 ! 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 13596 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11881 final have less inputs used (1) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11881 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13625 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 11884 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 3 of step 11884 have datatype=6 WARNING : type of output 1 of step 13596 doesn't seem to be define in the database( WARNING : type of input 3 of step 11881 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 0 of step 13625 have datatype=18 WARNING : type of output 1 of step 13625 doesn't seem to be define in the database( WARNING : type of input 5 of step 11884 doesn't seem to be define in the database( 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': 2, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 10 month : 06 mtr_id : 979 dashboard_places : arc_en_ciel_jrm date : 2025-06 year : 2025 raspi : 30073 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 = 'arc_en_ciel_jrm' and date like '%2025-06%') and created_at like '%2025-06%'))); nb_day : (6, 30) after unwanted_material_data nb_day : (6, 30) SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%30073%' AND ms.result_str like '%2025/06%'ORDER BY ms.id desc LIMIT 0, 1000000; No error ? {'log_dict': {'total_nb_images': 6761, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66796 seconds', 'coverage_times_pause': '0 days 67803 seconds', 'nb_photos_decision': 6678, 'nb_gray_level_ok': 6678, 'nb_dedup_ok': 2927, 'nb_two_criteria_ok': 2927, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 3751, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3009, 'ratio_coverage': 0.9765639848535798}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 2965, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2965, 'last_update': '2025/07/01', 'portfolio_id': 24410693, 'last_run_id': 1946497, 'total_number_of_photos': 3013}} No error ? {'log_dict': {'total_nb_images': 6761, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66796 seconds', 'coverage_times_pause': '0 days 67803 seconds', 'nb_photos_decision': 6678, 'nb_gray_level_ok': 6678, 'nb_dedup_ok': 2927, 'nb_two_criteria_ok': 2927, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 3751, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3009, 'ratio_coverage': 0.9765639848535798}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 2965, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2965, 'last_update': '2025/07/01', 'portfolio_id': 24410693, 'last_run_id': 1946497, 'total_number_of_photos': 3013}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 6761, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66796 seconds', 'coverage_times_pause': '0 days 67803 seconds', 'nb_photos_decision': 6678, 'nb_gray_level_ok': 6678, 'nb_dedup_ok': 2927, 'nb_two_criteria_ok': 2927, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 3751, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3009, 'ratio_coverage': 0.9765639848535798}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 2965, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2965, 'last_update': '2025/07/01', 'portfolio_id': 24410693, 'last_run_id': 1946497, 'total_number_of_photos': 3013}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2136, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21099 seconds', 'coverage_times_pause': '0 days 21419 seconds', 'nb_photos_decision': 2109, 'nb_gray_level_ok': 2109, 'nb_dedup_ok': 63, 'nb_two_criteria_ok': 63, 'nb_forced_upload': 27, 'end_of_day_photos_duplicated': 2046, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 89, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 3, 'nb_images_finished': 30, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 30, 'last_update': '2025/06/29', 'portfolio_id': 24380262, 'last_run_id': 1940157, 'total_number_of_photos': 91}} No error ? {'log_dict': {'total_nb_images': 6761, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66796 seconds', 'coverage_times_pause': '0 days 67803 seconds', 'nb_photos_decision': 6678, 'nb_gray_level_ok': 6678, 'nb_dedup_ok': 2927, 'nb_two_criteria_ok': 2927, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 3751, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3009, 'ratio_coverage': 0.9765639848535798}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 2965, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2965, 'last_update': '2025/07/01', 'portfolio_id': 24410693, 'last_run_id': 1946497, 'total_number_of_photos': 3013}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2136, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21099 seconds', 'coverage_times_pause': '0 days 21419 seconds', 'nb_photos_decision': 2109, 'nb_gray_level_ok': 2109, 'nb_dedup_ok': 63, 'nb_two_criteria_ok': 63, 'nb_forced_upload': 27, 'end_of_day_photos_duplicated': 2046, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 89, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 3, 'nb_images_finished': 30, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 30, 'last_update': '2025/06/29', 'portfolio_id': 24380262, 'last_run_id': 1940157, 'total_number_of_photos': 91}} No error ? {'log_dict': {'total_nb_images': 8533, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84428 seconds', 'coverage_times_pause': '0 days 85569 seconds', 'nb_photos_decision': 8437, 'nb_gray_level_ok': 8437, 'nb_dedup_ok': 4174, 'nb_two_criteria_ok': 4174, 'nb_forced_upload': 101, 'end_of_day_photos_duplicated': 4261, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 4269, 'ratio_coverage': 0.9771872359633792}, 'dashboard_dict': {'nb_ptf_finished': 30, 'nb_images_finished': 1662, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 45, 'nb_images_started': 2852, 'nb_selected_images': 4514, 'last_update': '2025/07/02', 'portfolio_id': 24359384, 'last_run_id': 1938526, 'total_number_of_photos': 4566}} No error ? {'log_dict': {'total_nb_images': 6761, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66796 seconds', 'coverage_times_pause': '0 days 67803 seconds', 'nb_photos_decision': 6678, 'nb_gray_level_ok': 6678, 'nb_dedup_ok': 2927, 'nb_two_criteria_ok': 2927, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 3751, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3009, 'ratio_coverage': 0.9765639848535798}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 2965, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2965, 'last_update': '2025/07/01', 'portfolio_id': 24410693, 'last_run_id': 1946260, 'total_number_of_photos': 3012}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2136, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21099 seconds', 'coverage_times_pause': '0 days 21419 seconds', 'nb_photos_decision': 2109, 'nb_gray_level_ok': 2109, 'nb_dedup_ok': 63, 'nb_two_criteria_ok': 63, 'nb_forced_upload': 27, 'end_of_day_photos_duplicated': 2046, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 89, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 3, 'nb_images_finished': 30, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 30, 'last_update': '2025/06/29', 'portfolio_id': 24380262, 'last_run_id': 1940157, 'total_number_of_photos': 91}} No error ? {'log_dict': {'total_nb_images': 8533, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84428 seconds', 'coverage_times_pause': '0 days 85569 seconds', 'nb_photos_decision': 8437, 'nb_gray_level_ok': 8437, 'nb_dedup_ok': 4174, 'nb_two_criteria_ok': 4174, 'nb_forced_upload': 101, 'end_of_day_photos_duplicated': 4261, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 4269, 'ratio_coverage': 0.9771872359633792}, 'dashboard_dict': {'nb_ptf_finished': 30, 'nb_images_finished': 1662, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 45, 'nb_images_started': 2852, 'nb_selected_images': 4514, 'last_update': '2025/06/30', 'portfolio_id': 24359384, 'last_run_id': 1938526, 'total_number_of_photos': 4566}} No error ? {'log_dict': {'total_nb_images': 8562, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84644 seconds', 'coverage_times_pause': '0 days 85857 seconds', 'nb_photos_decision': 0, 'nb_gray_level_ok': 0, 'nb_dedup_ok': 0, 'nb_two_criteria_ok': 0, 'nb_forced_upload': 0, 'end_of_day_photos_duplicated': 5209, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 701, 'end_of_day_photos_uploaded': 2651, 'ratio_coverage': 0.9796872648988993}, 'dashboard_dict': {'nb_ptf_finished': 50, 'nb_images_finished': 2551, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 52, 'nb_selected_images': 2603, 'last_update': '2025/06/30', 'portfolio_id': 24320820, 'last_run_id': 1935537, 'total_number_of_photos': 3389}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84498 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8469, 'nb_gray_level_ok': 8469, 'nb_dedup_ok': 3772, 'nb_two_criteria_ok': 3772, 'nb_forced_upload': 81, 'end_of_day_photos_duplicated': 4697, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3852, 'ratio_coverage': 0.9779974305258162}, 'dashboard_dict': {'nb_ptf_finished': 64, 'nb_images_finished': 3125, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 12, 'nb_images_started': 706, 'nb_selected_images': 3831, 'last_update': '2025/06/30', 'portfolio_id': 24279588, 'last_run_id': 1933078, 'total_number_of_photos': 3861}} No error ? {'log_dict': {'total_nb_images': 2136, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21099 seconds', 'coverage_times_pause': '0 days 21419 seconds', 'nb_photos_decision': 2109, 'nb_gray_level_ok': 2109, 'nb_dedup_ok': 63, 'nb_two_criteria_ok': 63, 'nb_forced_upload': 27, 'end_of_day_photos_duplicated': 2046, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 89, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 3, 'nb_images_finished': 30, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 30, 'last_update': '2025/06/29', 'portfolio_id': 24380262, 'last_run_id': 1940157, 'total_number_of_photos': 91}} No error ? {'log_dict': {'total_nb_images': 8533, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84428 seconds', 'coverage_times_pause': '0 days 85569 seconds', 'nb_photos_decision': 8437, 'nb_gray_level_ok': 8437, 'nb_dedup_ok': 4174, 'nb_two_criteria_ok': 4174, 'nb_forced_upload': 101, 'end_of_day_photos_duplicated': 4261, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 4269, 'ratio_coverage': 0.9771872359633792}, 'dashboard_dict': {'nb_ptf_finished': 30, 'nb_images_finished': 1662, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 45, 'nb_images_started': 2852, 'nb_selected_images': 4514, 'last_update': '2025/06/28', 'portfolio_id': 24359384, 'last_run_id': 1938526, 'total_number_of_photos': 4566}} No error ? {'log_dict': {'total_nb_images': 8562, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84644 seconds', 'coverage_times_pause': '0 days 85857 seconds', 'nb_photos_decision': 0, 'nb_gray_level_ok': 0, 'nb_dedup_ok': 0, 'nb_two_criteria_ok': 0, 'nb_forced_upload': 0, 'end_of_day_photos_duplicated': 5209, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 701, 'end_of_day_photos_uploaded': 2651, 'ratio_coverage': 0.9796872648988993}, 'dashboard_dict': {'nb_ptf_finished': 50, 'nb_images_finished': 2551, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 52, 'nb_selected_images': 2603, 'last_update': '2025/06/27', 'portfolio_id': 24320820, 'last_run_id': 1935537, 'total_number_of_photos': 3389}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84498 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8469, 'nb_gray_level_ok': 8469, 'nb_dedup_ok': 3772, 'nb_two_criteria_ok': 3772, 'nb_forced_upload': 81, 'end_of_day_photos_duplicated': 4697, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3852, 'ratio_coverage': 0.9779974305258162}, 'dashboard_dict': {'nb_ptf_finished': 64, 'nb_images_finished': 3125, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 12, 'nb_images_started': 706, 'nb_selected_images': 3831, 'last_update': '2025/06/26', 'portfolio_id': 24279588, 'last_run_id': 1933078, 'total_number_of_photos': 3861}} No error ? {'log_dict': {'total_nb_images': 2136, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21099 seconds', 'coverage_times_pause': '0 days 21419 seconds', 'nb_photos_decision': 2109, 'nb_gray_level_ok': 2109, 'nb_dedup_ok': 63, 'nb_two_criteria_ok': 63, 'nb_forced_upload': 27, 'end_of_day_photos_duplicated': 2046, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 89, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 3, 'nb_images_finished': 30, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 30, 'last_update': '2025/06/29', 'portfolio_id': 24380262, 'last_run_id': 1940143, 'total_number_of_photos': 89}} No error ? {'log_dict': {'total_nb_images': 8533, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84428 seconds', 'coverage_times_pause': '0 days 85569 seconds', 'nb_photos_decision': 8437, 'nb_gray_level_ok': 8437, 'nb_dedup_ok': 4174, 'nb_two_criteria_ok': 4174, 'nb_forced_upload': 101, 'end_of_day_photos_duplicated': 4261, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 4269, 'ratio_coverage': 0.9771872359633792}, 'dashboard_dict': {'nb_ptf_finished': 30, 'nb_images_finished': 1662, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 45, 'nb_images_started': 2852, 'nb_selected_images': 4514, 'last_update': '2025/06/28', 'portfolio_id': 24359384, 'last_run_id': 1938526, 'total_number_of_photos': 4566}} No error ? {'log_dict': {'total_nb_images': 8562, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84644 seconds', 'coverage_times_pause': '0 days 85857 seconds', 'nb_photos_decision': 0, 'nb_gray_level_ok': 0, 'nb_dedup_ok': 0, 'nb_two_criteria_ok': 0, 'nb_forced_upload': 0, 'end_of_day_photos_duplicated': 5209, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 701, 'end_of_day_photos_uploaded': 2651, 'ratio_coverage': 0.9796872648988993}, 'dashboard_dict': {'nb_ptf_finished': 50, 'nb_images_finished': 2551, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 52, 'nb_selected_images': 2603, 'last_update': '2025/06/27', 'portfolio_id': 24320820, 'last_run_id': 1935537, 'total_number_of_photos': 3389}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84498 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8469, 'nb_gray_level_ok': 8469, 'nb_dedup_ok': 3772, 'nb_two_criteria_ok': 3772, 'nb_forced_upload': 81, 'end_of_day_photos_duplicated': 4697, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3852, 'ratio_coverage': 0.9779974305258162}, 'dashboard_dict': {'nb_ptf_finished': 64, 'nb_images_finished': 3125, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 12, 'nb_images_started': 706, 'nb_selected_images': 3831, 'last_update': '2025/06/26', 'portfolio_id': 24279588, 'last_run_id': 1933078, 'total_number_of_photos': 3861}} No error ? {'log_dict': {'total_nb_images': 8533, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84428 seconds', 'coverage_times_pause': '0 days 85569 seconds', 'nb_photos_decision': 8437, 'nb_gray_level_ok': 8437, 'nb_dedup_ok': 4174, 'nb_two_criteria_ok': 4174, 'nb_forced_upload': 101, 'end_of_day_photos_duplicated': 4261, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 4269, 'ratio_coverage': 0.9771872359633792}, 'dashboard_dict': {'nb_ptf_finished': 30, 'nb_images_finished': 1662, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 45, 'nb_images_started': 2852, 'nb_selected_images': 4514, 'last_update': '2025/06/28', 'portfolio_id': 24359384, 'last_run_id': 1938204, 'total_number_of_photos': 4566}} No error ? {'log_dict': {'total_nb_images': 8562, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84644 seconds', 'coverage_times_pause': '0 days 85857 seconds', 'nb_photos_decision': 0, 'nb_gray_level_ok': 0, 'nb_dedup_ok': 0, 'nb_two_criteria_ok': 0, 'nb_forced_upload': 0, 'end_of_day_photos_duplicated': 5209, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 701, 'end_of_day_photos_uploaded': 2651, 'ratio_coverage': 0.9796872648988993}, 'dashboard_dict': {'nb_ptf_finished': 50, 'nb_images_finished': 2551, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 52, 'nb_selected_images': 2603, 'last_update': '2025/06/27', 'portfolio_id': 24320820, 'last_run_id': 1935537, 'total_number_of_photos': 3389}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84498 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8469, 'nb_gray_level_ok': 8469, 'nb_dedup_ok': 3772, 'nb_two_criteria_ok': 3772, 'nb_forced_upload': 81, 'end_of_day_photos_duplicated': 4697, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3852, 'ratio_coverage': 0.9779974305258162}, 'dashboard_dict': {'nb_ptf_finished': 64, 'nb_images_finished': 3125, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 12, 'nb_images_started': 706, 'nb_selected_images': 3831, 'last_update': '2025/06/26', 'portfolio_id': 24279588, 'last_run_id': 1933078, 'total_number_of_photos': 3861}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84498 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8469, 'nb_gray_level_ok': 8469, 'nb_dedup_ok': 3772, 'nb_two_criteria_ok': 3772, 'nb_forced_upload': 81, 'end_of_day_photos_duplicated': 4697, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3852, 'ratio_coverage': 0.9779974305258162}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 2703, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 20, 'nb_images_started': 1128, 'nb_selected_images': 3831, 'last_update': '2025/06/26', 'portfolio_id': 24279588, 'last_run_id': 1932712, 'total_number_of_photos': 3861}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84436 seconds', 'coverage_times_pause': '0 days 85751 seconds', 'nb_photos_decision': 8478, 'nb_gray_level_ok': 8478, 'nb_dedup_ok': 3411, 'nb_two_criteria_ok': 3411, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5066, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1167, 'end_of_day_photos_uploaded': 2316, 'ratio_coverage': 0.9772798296276577}, 'dashboard_dict': {'nb_ptf_finished': 67, 'nb_images_finished': 6842, 'nb_ptf_finished_for_older': 7, 'nb_images_finished_for_older': 670, 'nb_ptf_started': 3, 'nb_images_started': 208, 'nb_selected_images': 7720, 'last_update': '2025/06/21', 'portfolio_id': 24178744, 'last_run_id': 1925344, 'total_number_of_photos': 8976}} No error ? {'log_dict': {'total_nb_images': 8515, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84202 seconds', 'coverage_times_pause': '0 days 85392 seconds', 'nb_photos_decision': 8420, 'nb_gray_level_ok': 8420, 'nb_dedup_ok': 3602, 'nb_two_criteria_ok': 3602, 'nb_forced_upload': 100, 'end_of_day_photos_duplicated': 4815, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1958, 'end_of_day_photos_uploaded': 1741, 'ratio_coverage': 0.974571464947511}, 'dashboard_dict': {'nb_ptf_finished': 50, 'nb_images_finished': 6423, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 19, 'nb_images_started': 1280, 'nb_selected_images': 7703, 'last_update': '2025/06/26', 'portfolio_id': 24148179, 'last_run_id': 1932868, 'total_number_of_photos': 7753}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84436 seconds', 'coverage_times_pause': '0 days 85751 seconds', 'nb_photos_decision': 8478, 'nb_gray_level_ok': 8478, 'nb_dedup_ok': 3411, 'nb_two_criteria_ok': 3411, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5066, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1167, 'end_of_day_photos_uploaded': 2316, 'ratio_coverage': 0.9772798296276577}, 'dashboard_dict': {'nb_ptf_finished': 67, 'nb_images_finished': 6842, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 10, 'nb_images_started': 878, 'nb_selected_images': 7720, 'last_update': '2025/06/21', 'portfolio_id': 24178744, 'last_run_id': 1925344, 'total_number_of_photos': 7760}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84620 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8464, 'nb_gray_level_ok': 8464, 'nb_dedup_ok': 3750, 'nb_two_criteria_ok': 3750, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4714, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 131, 'end_of_day_photos_uploaded': 3710, 'ratio_coverage': 0.9794094839060637}, 'dashboard_dict': {'nb_ptf_finished': 66, 'nb_images_finished': 7185, 'nb_ptf_finished_for_older': 1, 'nb_images_finished_for_older': 90, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 7275, 'last_update': '2025/06/19', 'portfolio_id': 24113534, 'last_run_id': 1919206, 'total_number_of_photos': 7360}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84486 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8451, 'nb_gray_level_ok': 8451, 'nb_dedup_ok': 3229, 'nb_two_criteria_ok': 3229, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 5222, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3326, 'ratio_coverage': 0.9778585400293985}, 'dashboard_dict': {'nb_ptf_finished': 58, 'nb_images_finished': 6473, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 12, 'nb_images_started': 453, 'nb_selected_images': 6926, 'last_update': '2025/06/21', 'portfolio_id': 24075705, 'last_run_id': 1925145, 'total_number_of_photos': 6996}} No error ? {'log_dict': {'total_nb_images': 6767, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 66821 seconds', 'coverage_times_pause': '0 days 67860 seconds', 'nb_photos_decision': 6698, 'nb_gray_level_ok': 6698, 'nb_dedup_ok': 2771, 'nb_two_criteria_ok': 2771, 'nb_forced_upload': 69, 'end_of_day_photos_duplicated': 3927, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1376, 'end_of_day_photos_uploaded': 1463, 'ratio_coverage': 0.9769294872732057}, 'dashboard_dict': {'nb_ptf_finished': 60, 'nb_images_finished': 8503, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 9, 'nb_images_started': 624, 'nb_selected_images': 9127, 'last_update': '2025/06/20', 'portfolio_id': 24042746, 'last_run_id': 1921868, 'total_number_of_photos': 9131}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17612 seconds', 'coverage_times_pause': '0 days 17880 seconds', 'nb_photos_decision': 1765, 'nb_gray_level_ok': 1765, 'nb_dedup_ok': 872, 'nb_two_criteria_ok': 872, 'nb_forced_upload': 18, 'end_of_day_photos_duplicated': 893, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 889, 'ratio_coverage': 0.9784988054891939}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 1061, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 35, 'nb_selected_images': 1096, 'last_update': '2025/06/15', 'portfolio_id': 23983310, 'last_run_id': 1910208, 'total_number_of_photos': 1100}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84620 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8464, 'nb_gray_level_ok': 8464, 'nb_dedup_ok': 3750, 'nb_two_criteria_ok': 3750, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4714, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 131, 'end_of_day_photos_uploaded': 3710, 'ratio_coverage': 0.9794094839060637}, 'dashboard_dict': {'nb_ptf_finished': 66, 'nb_images_finished': 7185, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 90, 'nb_selected_images': 7275, 'last_update': '2025/06/19', 'portfolio_id': 24113534, 'last_run_id': 1919206, 'total_number_of_photos': 7360}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84486 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8451, 'nb_gray_level_ok': 8451, 'nb_dedup_ok': 3229, 'nb_two_criteria_ok': 3229, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 5222, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3326, 'ratio_coverage': 0.9778585400293985}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 5384, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 22, 'nb_images_started': 1542, 'nb_selected_images': 6926, 'last_update': '2025/06/18', 'portfolio_id': 24075705, 'last_run_id': 1916553, 'total_number_of_photos': 6996}} No error ? {'log_dict': {'total_nb_images': 6767, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 66821 seconds', 'coverage_times_pause': '0 days 67860 seconds', 'nb_photos_decision': 6698, 'nb_gray_level_ok': 6698, 'nb_dedup_ok': 2771, 'nb_two_criteria_ok': 2771, 'nb_forced_upload': 69, 'end_of_day_photos_duplicated': 3927, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1376, 'end_of_day_photos_uploaded': 1463, 'ratio_coverage': 0.9769294872732057}, 'dashboard_dict': {'nb_ptf_finished': 60, 'nb_images_finished': 8503, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 9, 'nb_images_started': 624, 'nb_selected_images': 9127, 'last_update': '2025/06/20', 'portfolio_id': 24042746, 'last_run_id': 1921868, 'total_number_of_photos': 9131}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17612 seconds', 'coverage_times_pause': '0 days 17880 seconds', 'nb_photos_decision': 1765, 'nb_gray_level_ok': 1765, 'nb_dedup_ok': 872, 'nb_two_criteria_ok': 872, 'nb_forced_upload': 18, 'end_of_day_photos_duplicated': 893, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 889, 'ratio_coverage': 0.9784988054891939}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 1061, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 35, 'nb_selected_images': 1096, 'last_update': '2025/06/15', 'portfolio_id': 23983310, 'last_run_id': 1910208, 'total_number_of_photos': 1100}} No error ? {'log_dict': {'total_nb_images': 8544, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84542 seconds', 'coverage_times_pause': '0 days 85678 seconds', 'nb_photos_decision': 8459, 'nb_gray_level_ok': 8459, 'nb_dedup_ok': 3398, 'nb_two_criteria_ok': 3398, 'nb_forced_upload': 85, 'end_of_day_photos_duplicated': 5061, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1168, 'end_of_day_photos_uploaded': 2314, 'ratio_coverage': 0.9785066956793481}, 'dashboard_dict': {'nb_ptf_finished': 67, 'nb_images_finished': 7824, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 309, 'nb_selected_images': 8133, 'last_update': '2025/06/14', 'portfolio_id': 23924590, 'last_run_id': 1908796, 'total_number_of_photos': 8181}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84620 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8464, 'nb_gray_level_ok': 8464, 'nb_dedup_ok': 3750, 'nb_two_criteria_ok': 3750, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4714, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 131, 'end_of_day_photos_uploaded': 3710, 'ratio_coverage': 0.9794094839060637}, 'dashboard_dict': {'nb_ptf_finished': 66, 'nb_images_finished': 7185, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 90, 'nb_selected_images': 7275, 'last_update': '2025/06/19', 'portfolio_id': 24113534, 'last_run_id': 1919206, 'total_number_of_photos': 7360}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84486 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8451, 'nb_gray_level_ok': 8451, 'nb_dedup_ok': 3229, 'nb_two_criteria_ok': 3229, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 5222, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3326, 'ratio_coverage': 0.9778585400293985}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 5384, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 22, 'nb_images_started': 1542, 'nb_selected_images': 6926, 'last_update': '2025/06/18', 'portfolio_id': 24075705, 'last_run_id': 1916553, 'total_number_of_photos': 6996}} No error ? {'log_dict': {'total_nb_images': 6767, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 66821 seconds', 'coverage_times_pause': '0 days 67860 seconds', 'nb_photos_decision': 6698, 'nb_gray_level_ok': 6698, 'nb_dedup_ok': 2771, 'nb_two_criteria_ok': 2771, 'nb_forced_upload': 69, 'end_of_day_photos_duplicated': 3927, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1376, 'end_of_day_photos_uploaded': 1463, 'ratio_coverage': 0.9769294872732057}, 'dashboard_dict': {'nb_ptf_finished': 43, 'nb_images_finished': 5018, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 26, 'nb_images_started': 3049, 'nb_selected_images': 8067, 'last_update': '2025/06/17', 'portfolio_id': 24042746, 'last_run_id': 1914311, 'total_number_of_photos': 9131}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17612 seconds', 'coverage_times_pause': '0 days 17880 seconds', 'nb_photos_decision': 1765, 'nb_gray_level_ok': 1765, 'nb_dedup_ok': 872, 'nb_two_criteria_ok': 872, 'nb_forced_upload': 18, 'end_of_day_photos_duplicated': 893, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 889, 'ratio_coverage': 0.9784988054891939}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 1061, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 35, 'nb_selected_images': 1096, 'last_update': '2025/06/15', 'portfolio_id': 23983310, 'last_run_id': 1910208, 'total_number_of_photos': 1100}} No error ? {'log_dict': {'total_nb_images': 8563, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84510 seconds', 'coverage_times_pause': '0 days 85867 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 2715, 'nb_two_criteria_ok': 2715, 'nb_forced_upload': 89, 'end_of_day_photos_duplicated': 5764, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 663, 'end_of_day_photos_uploaded': 2135, 'ratio_coverage': 0.978136321022234}, 'dashboard_dict': {'nb_ptf_finished': 69, 'nb_images_finished': 8322, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 58, 'nb_selected_images': 8380, 'last_update': '2025/06/15', 'portfolio_id': 23882999, 'last_run_id': 1910165, 'total_number_of_photos': 8417}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84486 seconds', 'coverage_times_pause': '0 days 85740 seconds', 'nb_photos_decision': 8451, 'nb_gray_level_ok': 8451, 'nb_dedup_ok': 3229, 'nb_two_criteria_ok': 3229, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 5222, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3326, 'ratio_coverage': 0.9778585400293985}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 5384, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 22, 'nb_images_started': 1542, 'nb_selected_images': 6926, 'last_update': '2025/06/18', 'portfolio_id': 24075705, 'last_run_id': 1916553, 'total_number_of_photos': 6996}} No error ? {'log_dict': {'total_nb_images': 6767, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 66821 seconds', 'coverage_times_pause': '0 days 67860 seconds', 'nb_photos_decision': 6698, 'nb_gray_level_ok': 6698, 'nb_dedup_ok': 2771, 'nb_two_criteria_ok': 2771, 'nb_forced_upload': 69, 'end_of_day_photos_duplicated': 3927, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1376, 'end_of_day_photos_uploaded': 1463, 'ratio_coverage': 0.9769294872732057}, 'dashboard_dict': {'nb_ptf_finished': 43, 'nb_images_finished': 5018, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 26, 'nb_images_started': 3049, 'nb_selected_images': 8067, 'last_update': '2025/06/17', 'portfolio_id': 24042746, 'last_run_id': 1914311, 'total_number_of_photos': 9131}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17612 seconds', 'coverage_times_pause': '0 days 17880 seconds', 'nb_photos_decision': 1765, 'nb_gray_level_ok': 1765, 'nb_dedup_ok': 872, 'nb_two_criteria_ok': 872, 'nb_forced_upload': 18, 'end_of_day_photos_duplicated': 893, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 889, 'ratio_coverage': 0.9784988054891939}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 1061, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 35, 'nb_selected_images': 1096, 'last_update': '2025/06/15', 'portfolio_id': 23983310, 'last_run_id': 1910208, 'total_number_of_photos': 1100}} No error ? {'log_dict': {'total_nb_images': 8544, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84542 seconds', 'coverage_times_pause': '0 days 85678 seconds', 'nb_photos_decision': 8459, 'nb_gray_level_ok': 8459, 'nb_dedup_ok': 3398, 'nb_two_criteria_ok': 3398, 'nb_forced_upload': 85, 'end_of_day_photos_duplicated': 5061, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1168, 'end_of_day_photos_uploaded': 2314, 'ratio_coverage': 0.9785066956793481}, 'dashboard_dict': {'nb_ptf_finished': 67, 'nb_images_finished': 7824, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 309, 'nb_selected_images': 8133, 'last_update': '2025/06/14', 'portfolio_id': 23924590, 'last_run_id': 1908796, 'total_number_of_photos': 8181}} No error ? {'log_dict': {'total_nb_images': 8563, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84510 seconds', 'coverage_times_pause': '0 days 85867 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 2715, 'nb_two_criteria_ok': 2715, 'nb_forced_upload': 89, 'end_of_day_photos_duplicated': 5764, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 663, 'end_of_day_photos_uploaded': 2135, 'ratio_coverage': 0.978136321022234}, 'dashboard_dict': {'nb_ptf_finished': 69, 'nb_images_finished': 8322, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 58, 'nb_selected_images': 8380, 'last_update': '2025/06/15', 'portfolio_id': 23882999, 'last_run_id': 1910165, 'total_number_of_photos': 8417}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84504 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 4427, 'nb_two_criteria_ok': 4427, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4052, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 4499, 'ratio_coverage': 0.9780668757740252}, 'dashboard_dict': {'nb_ptf_finished': 76, 'nb_images_finished': 7746, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 37, 'nb_selected_images': 7783, 'last_update': '2025/06/12', 'portfolio_id': 23828887, 'last_run_id': 1902006, 'total_number_of_photos': 7812}} No error ? {'log_dict': {'total_nb_images': 6767, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 66821 seconds', 'coverage_times_pause': '0 days 67860 seconds', 'nb_photos_decision': 6698, 'nb_gray_level_ok': 6698, 'nb_dedup_ok': 2771, 'nb_two_criteria_ok': 2771, 'nb_forced_upload': 69, 'end_of_day_photos_duplicated': 3927, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1376, 'end_of_day_photos_uploaded': 1463, 'ratio_coverage': 0.9769294872732057}, 'dashboard_dict': {'nb_ptf_finished': 43, 'nb_images_finished': 5018, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 26, 'nb_images_started': 3049, 'nb_selected_images': 8067, 'last_update': '2025/06/17', 'portfolio_id': 24042746, 'last_run_id': 1914311, 'total_number_of_photos': 8071}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17612 seconds', 'coverage_times_pause': '0 days 17880 seconds', 'nb_photos_decision': 1765, 'nb_gray_level_ok': 1765, 'nb_dedup_ok': 872, 'nb_two_criteria_ok': 872, 'nb_forced_upload': 18, 'end_of_day_photos_duplicated': 893, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 889, 'ratio_coverage': 0.9784988054891939}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 1061, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 35, 'nb_selected_images': 1096, 'last_update': '2025/06/15', 'portfolio_id': 23983310, 'last_run_id': 1910208, 'total_number_of_photos': 1100}} No error ? {'log_dict': {'total_nb_images': 8544, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84542 seconds', 'coverage_times_pause': '0 days 85678 seconds', 'nb_photos_decision': 8459, 'nb_gray_level_ok': 8459, 'nb_dedup_ok': 3398, 'nb_two_criteria_ok': 3398, 'nb_forced_upload': 85, 'end_of_day_photos_duplicated': 5061, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1168, 'end_of_day_photos_uploaded': 2314, 'ratio_coverage': 0.9785066956793481}, 'dashboard_dict': {'nb_ptf_finished': 67, 'nb_images_finished': 7824, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 309, 'nb_selected_images': 8133, 'last_update': '2025/06/14', 'portfolio_id': 23924590, 'last_run_id': 1908796, 'total_number_of_photos': 8181}} No error ? {'log_dict': {'total_nb_images': 8563, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84510 seconds', 'coverage_times_pause': '0 days 85867 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 2715, 'nb_two_criteria_ok': 2715, 'nb_forced_upload': 89, 'end_of_day_photos_duplicated': 5764, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 663, 'end_of_day_photos_uploaded': 2135, 'ratio_coverage': 0.978136321022234}, 'dashboard_dict': {'nb_ptf_finished': 69, 'nb_images_finished': 8322, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 58, 'nb_selected_images': 8380, 'last_update': '2025/06/15', 'portfolio_id': 23882999, 'last_run_id': 1910165, 'total_number_of_photos': 8417}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84504 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 4427, 'nb_two_criteria_ok': 4427, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4052, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 4499, 'ratio_coverage': 0.9780668757740252}, 'dashboard_dict': {'nb_ptf_finished': 76, 'nb_images_finished': 7746, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 37, 'nb_selected_images': 7783, 'last_update': '2025/06/12', 'portfolio_id': 23828887, 'last_run_id': 1902006, 'total_number_of_photos': 7812}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84494 seconds', 'coverage_times_pause': '0 days 85733 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 932, 'nb_two_criteria_ok': 932, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 7540, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 211, 'end_of_day_photos_uploaded': 798, 'ratio_coverage': 0.977951133693677}, 'dashboard_dict': {'nb_ptf_finished': 42, 'nb_images_finished': 2421, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2421, 'last_update': '2025/06/11', 'portfolio_id': 23798405, 'last_run_id': 1898493, 'total_number_of_photos': 2590}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17612 seconds', 'coverage_times_pause': '0 days 17880 seconds', 'nb_photos_decision': 1765, 'nb_gray_level_ok': 1765, 'nb_dedup_ok': 872, 'nb_two_criteria_ok': 872, 'nb_forced_upload': 18, 'end_of_day_photos_duplicated': 893, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 889, 'ratio_coverage': 0.9784988054891939}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 1061, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 35, 'nb_selected_images': 1096, 'last_update': '2025/06/15', 'portfolio_id': 23983310, 'last_run_id': 1910208, 'total_number_of_photos': 1100}} No error ? {'log_dict': {'total_nb_images': 8544, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84542 seconds', 'coverage_times_pause': '0 days 85678 seconds', 'nb_photos_decision': 8459, 'nb_gray_level_ok': 8459, 'nb_dedup_ok': 3398, 'nb_two_criteria_ok': 3398, 'nb_forced_upload': 85, 'end_of_day_photos_duplicated': 5061, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1168, 'end_of_day_photos_uploaded': 2314, 'ratio_coverage': 0.9785066956793481}, 'dashboard_dict': {'nb_ptf_finished': 67, 'nb_images_finished': 7824, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 309, 'nb_selected_images': 8133, 'last_update': '2025/06/14', 'portfolio_id': 23924590, 'last_run_id': 1908796, 'total_number_of_photos': 8181}} No error ? {'log_dict': {'total_nb_images': 8563, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84510 seconds', 'coverage_times_pause': '0 days 85867 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 2715, 'nb_two_criteria_ok': 2715, 'nb_forced_upload': 89, 'end_of_day_photos_duplicated': 5764, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 663, 'end_of_day_photos_uploaded': 2135, 'ratio_coverage': 0.978136321022234}, 'dashboard_dict': {'nb_ptf_finished': 69, 'nb_images_finished': 8322, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 58, 'nb_selected_images': 8380, 'last_update': '2025/06/15', 'portfolio_id': 23882999, 'last_run_id': 1910165, 'total_number_of_photos': 8417}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84504 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 4427, 'nb_two_criteria_ok': 4427, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4052, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 4499, 'ratio_coverage': 0.9780668757740252}, 'dashboard_dict': {'nb_ptf_finished': 76, 'nb_images_finished': 7746, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 37, 'nb_selected_images': 7783, 'last_update': '2025/06/12', 'portfolio_id': 23828887, 'last_run_id': 1902006, 'total_number_of_photos': 7812}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84494 seconds', 'coverage_times_pause': '0 days 85733 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 932, 'nb_two_criteria_ok': 932, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 7540, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 211, 'end_of_day_photos_uploaded': 798, 'ratio_coverage': 0.977951133693677}, 'dashboard_dict': {'nb_ptf_finished': 42, 'nb_images_finished': 2421, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2421, 'last_update': '2025/06/11', 'portfolio_id': 23798405, 'last_run_id': 1898493, 'total_number_of_photos': 2590}} No error ? {'log_dict': {'total_nb_images': 6773, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66969 seconds', 'coverage_times_pause': '0 days 67916 seconds', 'nb_photos_decision': 6702, 'nb_gray_level_ok': 6702, 'nb_dedup_ok': 2490, 'nb_two_criteria_ok': 2490, 'nb_forced_upload': 71, 'end_of_day_photos_duplicated': 4212, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 637, 'end_of_day_photos_uploaded': 1923, 'ratio_coverage': 0.9790932615973917}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 4640, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4640, 'last_update': '2025/06/10', 'portfolio_id': 23761859, 'last_run_id': 1894540, 'total_number_of_photos': 4736}} No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17612 seconds', 'coverage_times_pause': '0 days 17880 seconds', 'nb_photos_decision': 1765, 'nb_gray_level_ok': 1765, 'nb_dedup_ok': 872, 'nb_two_criteria_ok': 872, 'nb_forced_upload': 18, 'end_of_day_photos_duplicated': 893, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 889, 'ratio_coverage': 0.9784988054891939}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 1061, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 35, 'nb_selected_images': 1096, 'last_update': '2025/06/15', 'portfolio_id': 23983310, 'last_run_id': 1910170, 'total_number_of_photos': 1099}} No error ? {'log_dict': {'total_nb_images': 8544, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84542 seconds', 'coverage_times_pause': '0 days 85678 seconds', 'nb_photos_decision': 8459, 'nb_gray_level_ok': 8459, 'nb_dedup_ok': 3398, 'nb_two_criteria_ok': 3398, 'nb_forced_upload': 85, 'end_of_day_photos_duplicated': 5061, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1168, 'end_of_day_photos_uploaded': 2314, 'ratio_coverage': 0.9785066956793481}, 'dashboard_dict': {'nb_ptf_finished': 67, 'nb_images_finished': 7824, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 309, 'nb_selected_images': 8133, 'last_update': '2025/06/14', 'portfolio_id': 23924590, 'last_run_id': 1908796, 'total_number_of_photos': 8181}} No error ? {'log_dict': {'total_nb_images': 8563, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84510 seconds', 'coverage_times_pause': '0 days 85867 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 2715, 'nb_two_criteria_ok': 2715, 'nb_forced_upload': 89, 'end_of_day_photos_duplicated': 5764, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 663, 'end_of_day_photos_uploaded': 2135, 'ratio_coverage': 0.978136321022234}, 'dashboard_dict': {'nb_ptf_finished': 69, 'nb_images_finished': 8322, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 58, 'nb_selected_images': 8380, 'last_update': '2025/06/15', 'portfolio_id': 23882999, 'last_run_id': 1910165, 'total_number_of_photos': 8417}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84504 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 4427, 'nb_two_criteria_ok': 4427, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4052, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 4499, 'ratio_coverage': 0.9780668757740252}, 'dashboard_dict': {'nb_ptf_finished': 76, 'nb_images_finished': 7746, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 37, 'nb_selected_images': 7783, 'last_update': '2025/06/12', 'portfolio_id': 23828887, 'last_run_id': 1902006, 'total_number_of_photos': 7812}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84494 seconds', 'coverage_times_pause': '0 days 85733 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 932, 'nb_two_criteria_ok': 932, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 7540, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 211, 'end_of_day_photos_uploaded': 798, 'ratio_coverage': 0.977951133693677}, 'dashboard_dict': {'nb_ptf_finished': 42, 'nb_images_finished': 2421, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2421, 'last_update': '2025/06/11', 'portfolio_id': 23798405, 'last_run_id': 1898493, 'total_number_of_photos': 2590}} No error ? {'log_dict': {'total_nb_images': 6773, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66969 seconds', 'coverage_times_pause': '0 days 67916 seconds', 'nb_photos_decision': 6702, 'nb_gray_level_ok': 6702, 'nb_dedup_ok': 2490, 'nb_two_criteria_ok': 2490, 'nb_forced_upload': 71, 'end_of_day_photos_duplicated': 4212, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 637, 'end_of_day_photos_uploaded': 1923, 'ratio_coverage': 0.9790932615973917}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 4640, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4640, 'last_update': '2025/06/10', 'portfolio_id': 23761859, 'last_run_id': 1894540, 'total_number_of_photos': 4736}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8563, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84510 seconds', 'coverage_times_pause': '0 days 85867 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 2715, 'nb_two_criteria_ok': 2715, 'nb_forced_upload': 89, 'end_of_day_photos_duplicated': 5764, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 663, 'end_of_day_photos_uploaded': 2135, 'ratio_coverage': 0.978136321022234}, 'dashboard_dict': {'nb_ptf_finished': 69, 'nb_images_finished': 8322, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 58, 'nb_selected_images': 8380, 'last_update': '2025/06/13', 'portfolio_id': 23882999, 'last_run_id': 1904556, 'total_number_of_photos': 8417}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84504 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 4427, 'nb_two_criteria_ok': 4427, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4052, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 4499, 'ratio_coverage': 0.9780668757740252}, 'dashboard_dict': {'nb_ptf_finished': 76, 'nb_images_finished': 7746, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 37, 'nb_selected_images': 7783, 'last_update': '2025/06/12', 'portfolio_id': 23828887, 'last_run_id': 1902006, 'total_number_of_photos': 7812}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84494 seconds', 'coverage_times_pause': '0 days 85733 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 932, 'nb_two_criteria_ok': 932, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 7540, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 211, 'end_of_day_photos_uploaded': 798, 'ratio_coverage': 0.977951133693677}, 'dashboard_dict': {'nb_ptf_finished': 42, 'nb_images_finished': 2421, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2421, 'last_update': '2025/06/11', 'portfolio_id': 23798405, 'last_run_id': 1898493, 'total_number_of_photos': 2590}} No error ? {'log_dict': {'total_nb_images': 6773, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66969 seconds', 'coverage_times_pause': '0 days 67916 seconds', 'nb_photos_decision': 6702, 'nb_gray_level_ok': 6702, 'nb_dedup_ok': 2490, 'nb_two_criteria_ok': 2490, 'nb_forced_upload': 71, 'end_of_day_photos_duplicated': 4212, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 637, 'end_of_day_photos_uploaded': 1923, 'ratio_coverage': 0.9790932615973917}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 4640, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4640, 'last_update': '2025/06/10', 'portfolio_id': 23761859, 'last_run_id': 1894540, 'total_number_of_photos': 4736}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17661 seconds', 'coverage_times_pause': '0 days 17879 seconds', 'nb_photos_decision': 1764, 'nb_gray_level_ok': 1764, 'nb_dedup_ok': 677, 'nb_two_criteria_ok': 677, 'nb_forced_upload': 19, 'end_of_day_photos_duplicated': 1087, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 695, 'ratio_coverage': 0.9812211789543863}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 701, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 701, 'last_update': '2025/06/08', 'portfolio_id': 23731660, 'last_run_id': 1885718, 'total_number_of_photos': 706}} No error ? {'log_dict': {'total_nb_images': 8563, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84510 seconds', 'coverage_times_pause': '0 days 85867 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 2715, 'nb_two_criteria_ok': 2715, 'nb_forced_upload': 89, 'end_of_day_photos_duplicated': 5764, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 663, 'end_of_day_photos_uploaded': 2135, 'ratio_coverage': 0.978136321022234}, 'dashboard_dict': {'nb_ptf_finished': 69, 'nb_images_finished': 8322, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 58, 'nb_selected_images': 8380, 'last_update': '2025/06/13', 'portfolio_id': 23882999, 'last_run_id': 1904258, 'total_number_of_photos': 8417}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84504 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8479, 'nb_gray_level_ok': 8479, 'nb_dedup_ok': 4427, 'nb_two_criteria_ok': 4427, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4052, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 4499, 'ratio_coverage': 0.9780668757740252}, 'dashboard_dict': {'nb_ptf_finished': 76, 'nb_images_finished': 7746, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 37, 'nb_selected_images': 7783, 'last_update': '2025/06/12', 'portfolio_id': 23828887, 'last_run_id': 1902006, 'total_number_of_photos': 7812}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84494 seconds', 'coverage_times_pause': '0 days 85733 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 932, 'nb_two_criteria_ok': 932, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 7540, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 211, 'end_of_day_photos_uploaded': 798, 'ratio_coverage': 0.977951133693677}, 'dashboard_dict': {'nb_ptf_finished': 42, 'nb_images_finished': 2421, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2421, 'last_update': '2025/06/11', 'portfolio_id': 23798405, 'last_run_id': 1898493, 'total_number_of_photos': 2590}} No error ? {'log_dict': {'total_nb_images': 6773, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66969 seconds', 'coverage_times_pause': '0 days 67916 seconds', 'nb_photos_decision': 6702, 'nb_gray_level_ok': 6702, 'nb_dedup_ok': 2490, 'nb_two_criteria_ok': 2490, 'nb_forced_upload': 71, 'end_of_day_photos_duplicated': 4212, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 637, 'end_of_day_photos_uploaded': 1923, 'ratio_coverage': 0.9790932615973917}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 4640, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4640, 'last_update': '2025/06/10', 'portfolio_id': 23761859, 'last_run_id': 1894540, 'total_number_of_photos': 4736}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17661 seconds', 'coverage_times_pause': '0 days 17879 seconds', 'nb_photos_decision': 1764, 'nb_gray_level_ok': 1764, 'nb_dedup_ok': 677, 'nb_two_criteria_ok': 677, 'nb_forced_upload': 19, 'end_of_day_photos_duplicated': 1087, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 695, 'ratio_coverage': 0.9812211789543863}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 701, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 701, 'last_update': '2025/06/08', 'portfolio_id': 23731660, 'last_run_id': 1885718, 'total_number_of_photos': 706}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84395 seconds', 'coverage_times_pause': '0 days 85738 seconds', 'nb_photos_decision': 8458, 'nb_gray_level_ok': 8458, 'nb_dedup_ok': 3419, 'nb_two_criteria_ok': 3419, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5039, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3506, 'ratio_coverage': 0.9768052870982303}, 'dashboard_dict': {'nb_ptf_finished': 63, 'nb_images_finished': 3272, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 177, 'nb_selected_images': 3449, 'last_update': '2025/06/07', 'portfolio_id': 23691305, 'last_run_id': 1883633, 'total_number_of_photos': 3514}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84494 seconds', 'coverage_times_pause': '0 days 85733 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 932, 'nb_two_criteria_ok': 932, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 7540, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 211, 'end_of_day_photos_uploaded': 798, 'ratio_coverage': 0.977951133693677}, 'dashboard_dict': {'nb_ptf_finished': 42, 'nb_images_finished': 2421, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2421, 'last_update': '2025/06/11', 'portfolio_id': 23798405, 'last_run_id': 1897963, 'total_number_of_photos': 2590}} No error ? {'log_dict': {'total_nb_images': 6773, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66969 seconds', 'coverage_times_pause': '0 days 67916 seconds', 'nb_photos_decision': 6702, 'nb_gray_level_ok': 6702, 'nb_dedup_ok': 2490, 'nb_two_criteria_ok': 2490, 'nb_forced_upload': 71, 'end_of_day_photos_duplicated': 4212, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 637, 'end_of_day_photos_uploaded': 1923, 'ratio_coverage': 0.9790932615973917}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 4640, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4640, 'last_update': '2025/06/10', 'portfolio_id': 23761859, 'last_run_id': 1894540, 'total_number_of_photos': 4736}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17661 seconds', 'coverage_times_pause': '0 days 17879 seconds', 'nb_photos_decision': 1764, 'nb_gray_level_ok': 1764, 'nb_dedup_ok': 677, 'nb_two_criteria_ok': 677, 'nb_forced_upload': 19, 'end_of_day_photos_duplicated': 1087, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 695, 'ratio_coverage': 0.9812211789543863}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 701, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 701, 'last_update': '2025/06/08', 'portfolio_id': 23731660, 'last_run_id': 1885718, 'total_number_of_photos': 706}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84395 seconds', 'coverage_times_pause': '0 days 85738 seconds', 'nb_photos_decision': 8458, 'nb_gray_level_ok': 8458, 'nb_dedup_ok': 3419, 'nb_two_criteria_ok': 3419, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5039, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3506, 'ratio_coverage': 0.9768052870982303}, 'dashboard_dict': {'nb_ptf_finished': 63, 'nb_images_finished': 3272, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 177, 'nb_selected_images': 3449, 'last_update': '2025/06/07', 'portfolio_id': 23691305, 'last_run_id': 1883633, 'total_number_of_photos': 3514}} No error ? {'log_dict': {'total_nb_images': 8532, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84355 seconds', 'coverage_times_pause': '0 days 85563 seconds', 'nb_photos_decision': 8441, 'nb_gray_level_ok': 8441, 'nb_dedup_ok': 3930, 'nb_two_criteria_ok': 3930, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4511, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4020, 'ratio_coverage': 0.9763423187768377}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3214, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 14, 'nb_images_started': 813, 'nb_selected_images': 4027, 'last_update': '2025/06/06', 'portfolio_id': 23651422, 'last_run_id': 1879346, 'total_number_of_photos': 4105}} No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84464 seconds', 'coverage_times_pause': '0 days 85746 seconds', 'nb_photos_decision': 8473, 'nb_gray_level_ok': 8473, 'nb_dedup_ok': 4389, 'nb_two_criteria_ok': 4389, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4084, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4462, 'ratio_coverage': 0.9776039074526326}, 'dashboard_dict': {'nb_ptf_finished': 77, 'nb_images_finished': 4296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 4, 'nb_images_started': 170, 'nb_selected_images': 4466, 'last_update': '2025/06/05', 'portfolio_id': 23606231, 'last_run_id': 1875320, 'total_number_of_photos': 4481}} No error ? {'log_dict': {'total_nb_images': 6773, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66969 seconds', 'coverage_times_pause': '0 days 67916 seconds', 'nb_photos_decision': 6702, 'nb_gray_level_ok': 6702, 'nb_dedup_ok': 2490, 'nb_two_criteria_ok': 2490, 'nb_forced_upload': 71, 'end_of_day_photos_duplicated': 4212, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 637, 'end_of_day_photos_uploaded': 1923, 'ratio_coverage': 0.9790932615973917}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 4640, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4640, 'last_update': '2025/06/10', 'portfolio_id': 23761859, 'last_run_id': 1893937, 'total_number_of_photos': 4736}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17661 seconds', 'coverage_times_pause': '0 days 17879 seconds', 'nb_photos_decision': 1764, 'nb_gray_level_ok': 1764, 'nb_dedup_ok': 677, 'nb_two_criteria_ok': 677, 'nb_forced_upload': 19, 'end_of_day_photos_duplicated': 1087, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 695, 'ratio_coverage': 0.9812211789543863}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 701, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 701, 'last_update': '2025/06/08', 'portfolio_id': 23731660, 'last_run_id': 1885718, 'total_number_of_photos': 706}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84395 seconds', 'coverage_times_pause': '0 days 85738 seconds', 'nb_photos_decision': 8458, 'nb_gray_level_ok': 8458, 'nb_dedup_ok': 3419, 'nb_two_criteria_ok': 3419, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5039, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3506, 'ratio_coverage': 0.9768052870982303}, 'dashboard_dict': {'nb_ptf_finished': 63, 'nb_images_finished': 3272, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 177, 'nb_selected_images': 3449, 'last_update': '2025/06/07', 'portfolio_id': 23691305, 'last_run_id': 1883633, 'total_number_of_photos': 3514}} No error ? {'log_dict': {'total_nb_images': 8532, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84355 seconds', 'coverage_times_pause': '0 days 85563 seconds', 'nb_photos_decision': 8441, 'nb_gray_level_ok': 8441, 'nb_dedup_ok': 3930, 'nb_two_criteria_ok': 3930, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4511, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4020, 'ratio_coverage': 0.9763423187768377}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3214, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 14, 'nb_images_started': 813, 'nb_selected_images': 4027, 'last_update': '2025/06/06', 'portfolio_id': 23651422, 'last_run_id': 1879346, 'total_number_of_photos': 4105}} No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84464 seconds', 'coverage_times_pause': '0 days 85746 seconds', 'nb_photos_decision': 8473, 'nb_gray_level_ok': 8473, 'nb_dedup_ok': 4389, 'nb_two_criteria_ok': 4389, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4084, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4462, 'ratio_coverage': 0.9776039074526326}, 'dashboard_dict': {'nb_ptf_finished': 77, 'nb_images_finished': 4296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 4, 'nb_images_started': 170, 'nb_selected_images': 4466, 'last_update': '2025/06/05', 'portfolio_id': 23606231, 'last_run_id': 1875320, 'total_number_of_photos': 4481}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84346 seconds', 'coverage_times_pause': '0 days 85620 seconds', 'nb_photos_decision': 8461, 'nb_gray_level_ok': 8461, 'nb_dedup_ok': 3251, 'nb_two_criteria_ok': 3251, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5210, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3323, 'ratio_coverage': 0.9762381509045244}, 'dashboard_dict': {'nb_ptf_finished': 61, 'nb_images_finished': 3223, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 54, 'nb_selected_images': 3277, 'last_update': '2025/06/04', 'portfolio_id': 23572229, 'last_run_id': 1871480, 'total_number_of_photos': 3336}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 1783, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 17661 seconds', 'coverage_times_pause': '0 days 17879 seconds', 'nb_photos_decision': 1764, 'nb_gray_level_ok': 1764, 'nb_dedup_ok': 677, 'nb_two_criteria_ok': 677, 'nb_forced_upload': 19, 'end_of_day_photos_duplicated': 1087, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 695, 'ratio_coverage': 0.9812211789543863}, 'dashboard_dict': {'nb_ptf_finished': 14, 'nb_images_finished': 701, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 701, 'last_update': '2025/06/08', 'portfolio_id': 23731660, 'last_run_id': 1885718, 'total_number_of_photos': 706}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84395 seconds', 'coverage_times_pause': '0 days 85738 seconds', 'nb_photos_decision': 8458, 'nb_gray_level_ok': 8458, 'nb_dedup_ok': 3419, 'nb_two_criteria_ok': 3419, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5039, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3506, 'ratio_coverage': 0.9768052870982303}, 'dashboard_dict': {'nb_ptf_finished': 63, 'nb_images_finished': 3272, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 177, 'nb_selected_images': 3449, 'last_update': '2025/06/07', 'portfolio_id': 23691305, 'last_run_id': 1883633, 'total_number_of_photos': 3514}} No error ? {'log_dict': {'total_nb_images': 8532, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84355 seconds', 'coverage_times_pause': '0 days 85563 seconds', 'nb_photos_decision': 8441, 'nb_gray_level_ok': 8441, 'nb_dedup_ok': 3930, 'nb_two_criteria_ok': 3930, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4511, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4020, 'ratio_coverage': 0.9763423187768377}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3214, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 14, 'nb_images_started': 813, 'nb_selected_images': 4027, 'last_update': '2025/06/06', 'portfolio_id': 23651422, 'last_run_id': 1879346, 'total_number_of_photos': 4105}} No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84464 seconds', 'coverage_times_pause': '0 days 85746 seconds', 'nb_photos_decision': 8473, 'nb_gray_level_ok': 8473, 'nb_dedup_ok': 4389, 'nb_two_criteria_ok': 4389, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4084, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4462, 'ratio_coverage': 0.9776039074526326}, 'dashboard_dict': {'nb_ptf_finished': 77, 'nb_images_finished': 4296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 4, 'nb_images_started': 170, 'nb_selected_images': 4466, 'last_update': '2025/06/05', 'portfolio_id': 23606231, 'last_run_id': 1875320, 'total_number_of_photos': 4481}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84346 seconds', 'coverage_times_pause': '0 days 85620 seconds', 'nb_photos_decision': 8461, 'nb_gray_level_ok': 8461, 'nb_dedup_ok': 3251, 'nb_two_criteria_ok': 3251, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5210, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3323, 'ratio_coverage': 0.9762381509045244}, 'dashboard_dict': {'nb_ptf_finished': 61, 'nb_images_finished': 3223, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 54, 'nb_selected_images': 3277, 'last_update': '2025/06/04', 'portfolio_id': 23572229, 'last_run_id': 1871480, 'total_number_of_photos': 3336}} No error ? {'log_dict': {'total_nb_images': 6749, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66605 seconds', 'coverage_times_pause': '0 days 67682 seconds', 'nb_photos_decision': 6692, 'nb_gray_level_ok': 6692, 'nb_dedup_ok': 3290, 'nb_two_criteria_ok': 3290, 'nb_forced_upload': 57, 'end_of_day_photos_duplicated': 3402, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3346, 'ratio_coverage': 0.973771546367637}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 3296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 3296, 'last_update': '2025/06/03', 'portfolio_id': 23525872, 'last_run_id': 1867615, 'total_number_of_photos': 3348}} No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84395 seconds', 'coverage_times_pause': '0 days 85738 seconds', 'nb_photos_decision': 8458, 'nb_gray_level_ok': 8458, 'nb_dedup_ok': 3419, 'nb_two_criteria_ok': 3419, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5039, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3506, 'ratio_coverage': 0.9768052870982303}, 'dashboard_dict': {'nb_ptf_finished': 63, 'nb_images_finished': 3272, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 3, 'nb_images_started': 177, 'nb_selected_images': 3449, 'last_update': '2025/06/07', 'portfolio_id': 23691305, 'last_run_id': 1883633, 'total_number_of_photos': 3514}} No error ? {'log_dict': {'total_nb_images': 8532, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84355 seconds', 'coverage_times_pause': '0 days 85563 seconds', 'nb_photos_decision': 8441, 'nb_gray_level_ok': 8441, 'nb_dedup_ok': 3930, 'nb_two_criteria_ok': 3930, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4511, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4020, 'ratio_coverage': 0.9763423187768377}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3214, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 14, 'nb_images_started': 813, 'nb_selected_images': 4027, 'last_update': '2025/06/06', 'portfolio_id': 23651422, 'last_run_id': 1879346, 'total_number_of_photos': 4105}} No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84464 seconds', 'coverage_times_pause': '0 days 85746 seconds', 'nb_photos_decision': 8473, 'nb_gray_level_ok': 8473, 'nb_dedup_ok': 4389, 'nb_two_criteria_ok': 4389, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4084, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4462, 'ratio_coverage': 0.9776039074526326}, 'dashboard_dict': {'nb_ptf_finished': 77, 'nb_images_finished': 4296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 4, 'nb_images_started': 170, 'nb_selected_images': 4466, 'last_update': '2025/06/05', 'portfolio_id': 23606231, 'last_run_id': 1875320, 'total_number_of_photos': 4481}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84346 seconds', 'coverage_times_pause': '0 days 85620 seconds', 'nb_photos_decision': 8461, 'nb_gray_level_ok': 8461, 'nb_dedup_ok': 3251, 'nb_two_criteria_ok': 3251, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5210, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3323, 'ratio_coverage': 0.9762381509045244}, 'dashboard_dict': {'nb_ptf_finished': 61, 'nb_images_finished': 3223, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 54, 'nb_selected_images': 3277, 'last_update': '2025/06/04', 'portfolio_id': 23572229, 'last_run_id': 1871480, 'total_number_of_photos': 3336}} No error ? {'log_dict': {'total_nb_images': 6749, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66605 seconds', 'coverage_times_pause': '0 days 67682 seconds', 'nb_photos_decision': 6692, 'nb_gray_level_ok': 6692, 'nb_dedup_ok': 3290, 'nb_two_criteria_ok': 3290, 'nb_forced_upload': 57, 'end_of_day_photos_duplicated': 3402, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3346, 'ratio_coverage': 0.973771546367637}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 3296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 3296, 'last_update': '2025/06/03', 'portfolio_id': 23525872, 'last_run_id': 1867615, 'total_number_of_photos': 3348}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8550, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84395 seconds', 'coverage_times_pause': '0 days 85738 seconds', 'nb_photos_decision': 8458, 'nb_gray_level_ok': 8458, 'nb_dedup_ok': 3419, 'nb_two_criteria_ok': 3419, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5039, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3506, 'ratio_coverage': 0.9768052870982303}, 'dashboard_dict': {'nb_ptf_finished': 58, 'nb_images_finished': 3025, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 8, 'nb_images_started': 424, 'nb_selected_images': 3449, 'last_update': '2025/06/07', 'portfolio_id': 23691305, 'last_run_id': 1881867, 'total_number_of_photos': 3514}} No error ? {'log_dict': {'total_nb_images': 8532, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84355 seconds', 'coverage_times_pause': '0 days 85563 seconds', 'nb_photos_decision': 8441, 'nb_gray_level_ok': 8441, 'nb_dedup_ok': 3930, 'nb_two_criteria_ok': 3930, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4511, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4020, 'ratio_coverage': 0.9763423187768377}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3214, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 14, 'nb_images_started': 813, 'nb_selected_images': 4027, 'last_update': '2025/06/06', 'portfolio_id': 23651422, 'last_run_id': 1879346, 'total_number_of_photos': 4105}} No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84464 seconds', 'coverage_times_pause': '0 days 85746 seconds', 'nb_photos_decision': 8473, 'nb_gray_level_ok': 8473, 'nb_dedup_ok': 4389, 'nb_two_criteria_ok': 4389, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4084, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4462, 'ratio_coverage': 0.9776039074526326}, 'dashboard_dict': {'nb_ptf_finished': 77, 'nb_images_finished': 4296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 4, 'nb_images_started': 170, 'nb_selected_images': 4466, 'last_update': '2025/06/05', 'portfolio_id': 23606231, 'last_run_id': 1875320, 'total_number_of_photos': 4481}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84346 seconds', 'coverage_times_pause': '0 days 85620 seconds', 'nb_photos_decision': 8461, 'nb_gray_level_ok': 8461, 'nb_dedup_ok': 3251, 'nb_two_criteria_ok': 3251, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5210, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3323, 'ratio_coverage': 0.9762381509045244}, 'dashboard_dict': {'nb_ptf_finished': 61, 'nb_images_finished': 3223, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 54, 'nb_selected_images': 3277, 'last_update': '2025/06/04', 'portfolio_id': 23572229, 'last_run_id': 1871480, 'total_number_of_photos': 3336}} No error ? {'log_dict': {'total_nb_images': 6749, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66605 seconds', 'coverage_times_pause': '0 days 67682 seconds', 'nb_photos_decision': 6692, 'nb_gray_level_ok': 6692, 'nb_dedup_ok': 3290, 'nb_two_criteria_ok': 3290, 'nb_forced_upload': 57, 'end_of_day_photos_duplicated': 3402, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3346, 'ratio_coverage': 0.973771546367637}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 3296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 3296, 'last_update': '2025/06/03', 'portfolio_id': 23525872, 'last_run_id': 1867615, 'total_number_of_photos': 3348}} Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8532, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84355 seconds', 'coverage_times_pause': '0 days 85563 seconds', 'nb_photos_decision': 8441, 'nb_gray_level_ok': 8441, 'nb_dedup_ok': 3930, 'nb_two_criteria_ok': 3930, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4511, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4020, 'ratio_coverage': 0.9763423187768377}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3214, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 10, 'nb_selected_images': 3224, 'last_update': '2025/06/06', 'portfolio_id': 23651422, 'last_run_id': 1877423, 'total_number_of_photos': 4105}} No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84464 seconds', 'coverage_times_pause': '0 days 85746 seconds', 'nb_photos_decision': 8473, 'nb_gray_level_ok': 8473, 'nb_dedup_ok': 4389, 'nb_two_criteria_ok': 4389, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4084, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4462, 'ratio_coverage': 0.9776039074526326}, 'dashboard_dict': {'nb_ptf_finished': 77, 'nb_images_finished': 4296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 4, 'nb_images_started': 170, 'nb_selected_images': 4466, 'last_update': '2025/06/05', 'portfolio_id': 23606231, 'last_run_id': 1875320, 'total_number_of_photos': 4481}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84346 seconds', 'coverage_times_pause': '0 days 85620 seconds', 'nb_photos_decision': 8461, 'nb_gray_level_ok': 8461, 'nb_dedup_ok': 3251, 'nb_two_criteria_ok': 3251, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5210, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3323, 'ratio_coverage': 0.9762381509045244}, 'dashboard_dict': {'nb_ptf_finished': 61, 'nb_images_finished': 3223, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 54, 'nb_selected_images': 3277, 'last_update': '2025/06/04', 'portfolio_id': 23572229, 'last_run_id': 1871480, 'total_number_of_photos': 3336}} No error ? {'log_dict': {'total_nb_images': 6749, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66605 seconds', 'coverage_times_pause': '0 days 67682 seconds', 'nb_photos_decision': 6692, 'nb_gray_level_ok': 6692, 'nb_dedup_ok': 3290, 'nb_two_criteria_ok': 3290, 'nb_forced_upload': 57, 'end_of_day_photos_duplicated': 3402, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3346, 'ratio_coverage': 0.973771546367637}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 3296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 3296, 'last_update': '2025/06/03', 'portfolio_id': 23525872, 'last_run_id': 1867615, 'total_number_of_photos': 3348}} Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84464 seconds', 'coverage_times_pause': '0 days 85746 seconds', 'nb_photos_decision': 8473, 'nb_gray_level_ok': 8473, 'nb_dedup_ok': 4389, 'nb_two_criteria_ok': 4389, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4084, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4462, 'ratio_coverage': 0.9776039074526326}, 'dashboard_dict': {'nb_ptf_finished': 74, 'nb_images_finished': 4169, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 7, 'nb_images_started': 297, 'nb_selected_images': 4466, 'last_update': '2025/06/05', 'portfolio_id': 23606231, 'last_run_id': 1873731, 'total_number_of_photos': 4481}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84346 seconds', 'coverage_times_pause': '0 days 85620 seconds', 'nb_photos_decision': 8461, 'nb_gray_level_ok': 8461, 'nb_dedup_ok': 3251, 'nb_two_criteria_ok': 3251, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5210, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3323, 'ratio_coverage': 0.9762381509045244}, 'dashboard_dict': {'nb_ptf_finished': 61, 'nb_images_finished': 3223, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 54, 'nb_selected_images': 3277, 'last_update': '2025/06/04', 'portfolio_id': 23572229, 'last_run_id': 1871480, 'total_number_of_photos': 3336}} No error ? {'log_dict': {'total_nb_images': 6749, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66605 seconds', 'coverage_times_pause': '0 days 67682 seconds', 'nb_photos_decision': 6692, 'nb_gray_level_ok': 6692, 'nb_dedup_ok': 3290, 'nb_two_criteria_ok': 3290, 'nb_forced_upload': 57, 'end_of_day_photos_duplicated': 3402, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3346, 'ratio_coverage': 0.973771546367637}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 3296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 3296, 'last_update': '2025/06/03', 'portfolio_id': 23525872, 'last_run_id': 1867615, 'total_number_of_photos': 3348}} Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84346 seconds', 'coverage_times_pause': '0 days 85620 seconds', 'nb_photos_decision': 8461, 'nb_gray_level_ok': 8461, 'nb_dedup_ok': 3251, 'nb_two_criteria_ok': 3251, 'nb_forced_upload': 77, 'end_of_day_photos_duplicated': 5210, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 3323, 'ratio_coverage': 0.9762381509045244}, 'dashboard_dict': {'nb_ptf_finished': 60, 'nb_images_finished': 3149, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 2, 'nb_images_started': 128, 'nb_selected_images': 3277, 'last_update': '2025/06/04', 'portfolio_id': 23572229, 'last_run_id': 1870497, 'total_number_of_photos': 3336}} No error ? {'log_dict': {'total_nb_images': 6749, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 66605 seconds', 'coverage_times_pause': '0 days 67682 seconds', 'nb_photos_decision': 6692, 'nb_gray_level_ok': 6692, 'nb_dedup_ok': 3290, 'nb_two_criteria_ok': 3290, 'nb_forced_upload': 57, 'end_of_day_photos_duplicated': 3402, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 3346, 'ratio_coverage': 0.973771546367637}, 'dashboard_dict': {'nb_ptf_finished': 56, 'nb_images_finished': 3296, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 3296, 'last_update': '2025/06/03', 'portfolio_id': 23525872, 'last_run_id': 1867615, 'total_number_of_photos': 3348}} Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Since we don't have condition on date we need to verify this lately ! Found day : 2025-06-30 00:00:00 Found day : 2025-06-28 00:00:00 Found day : 2025-06-27 00:00:00 Found day : 2025-06-26 00:00:00 Found day : 2025-06-25 00:00:00 Found day : 2025-06-20 00:00:00 Found day : 2025-06-19 00:00:00 Found day : 2025-06-18 00:00:00 Found day : 2025-06-17 00:00:00 Found day : 2025-06-16 00:00:00 Found day : 2025-06-14 00:00:00 Found day : 2025-06-13 00:00:00 Found day : 2025-06-12 00:00:00 Found day : 2025-06-11 00:00:00 Found day : 2025-06-10 00:00:00 Found day : 2025-06-09 00:00:00 Found day : 2025-06-07 00:00:00 Found day : 2025-06-06 00:00:00 Found day : 2025-06-05 00:00:00 Found day : 2025-06-04 00:00:00 Found day : 2025-06-03 00:00:00 Found day : 2025-06-02 00:00:00 Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-06-21 00:00:00,2025-06-23 00:00:00,2025-06-24 00:00:00 after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 10 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______JRM' and ded.dashboard_place_id = 10 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 10 and mp.name like '%062025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-06-01 : dt_date_just_month_year : 2025-06-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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= "arc_en_ciel_jrm" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-06-01" AND ded.date <= "2025-06-30" apple3 {'JRM': {'mat': 'JRM', 'pht': 3726, 'datou_carac_id': 4302, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'papier'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1867615,1871480,1875320,1879346,1883633,1885718,1894540,1898493,1902006,1910165,1927500,1910208,1921868,1925145,1925525,1932868,1925344,1925333,1929579,1933078,1935537,1938526,1940157,1946497) 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.005057384244367119, 'nb_photo': 7574, 'list_port_cont': '23525957,23526059,23526320,23526654,23526983,23527386,23527731,23528156,23528662,23529332,23529843,23530405,23531062,23531777,23532403,23533112,23534680,23535512,23536750,23537415,23537953,23538667,23539334,23539907,23540490,23543932,23544374,23545067,23545692,23546440,23547128,23548171,23549073,23549929,23551036,23552534,23553081,23553521,23554335,23556168,23556889,23557593,23558238,23558804,23559562,23560062,23560768,23561883,23562721,23563423,23566310,23572448,23572779,23574524,23574629,23575375,23575477,23575965,23576271,23576797,23577292,23577857,23578105,23578486,23578860,23579422,23579444,23579767,23579796,23580139,23580385,23585055,23585393,23586024,23586542,23587166,23587862,23588764,23589289,23589978,23590534,23591151,23591667,23592198,23592559,23593338,23594712,23595086,23595432,23595967,23596575,23597875,23599288,23599572,23599833,23600690,23600702,23601144,23601535,23602025,23603583,23604210,23604628,23605388,23605538,23606048,23606348,23606629,23606996,23607405,23608303,23608586,23609046,2360950', 'assoc_port': '23525945:23525957,23526028:23526059,23526302:23526320,23526633:23526654,23526971:23526983,23527369:23527386,23527715:23527731,23528131:23528156,23528644:23528662,23529291:23529332,23529835:23529843,23530360:23530405,23531033:23531062,23531742:23531777,23532378:23532403,23533080:23533112,23534658:23534680,23535481:23535512,23536707:23536750,23537388:23537415,23537919:23537953,23538641:23538667,23539303:23539334,23539854:23539907,23540468:23540490,23543904:23543932,23544321:23544374,23545016:23545067,23545644:23545692,23546414:23546440,23547059:23547128,23548101:23548171,23548984:23549073,23549856:23549929,23550939:23551036,23552513:23552534,23553062:23553081,23553438:23553521,23554249:23554335,23556138:23556168,23556841:23556889,23557546:23557593,23558209:23558238,23558702:23558804,23559495:23559562,23559991:23560062,23560642:23560768,23561867:23561883,23562708:23562721,23563332:23563423,23566297:23566310,23572408:23572448,23572766:23572779,23574516:23574524,23574624:23574629,23575369:23575375,23575456:2357547', 'assoc_mat': '23525945:autre_refus:3726:23525957,23526028:autre_refus:3726:23526059,23526302:autre_refus:3726:23526320,23526633:autre_refus:3726:23526654,23526971:autre_refus:3726:23526983,23527369:autre_refus:3726:23527386,23527715:autre_refus:3726:23527731,23528131:autre_refus:3726:23528156,23528644:autre_refus:3726:23528662,23529291:autre_refus:3726:23529332,23529835:autre_refus:3726:23529843,23530360:autre_refus:3726:23530405,23531033:autre_refus:3726:23531062,23531742:autre_refus:3726:23531777,23532378:autre_refus:3726:23532403,23533080:autre_refus:3726:23533112,23534658:autre_refus:3726:23534680,23535481:autre_refus:3726:23535512,23536707:autre_refus:3726:23536750,23537388:autre_refus:3726:23537415,23537919:autre_refus:3726:23537953,23538641:autre_refus:3726:23538667,23539303:autre_refus:3726:23539334,23539854:autre_refus:3726:23539907,23540468:autre_refus:3726:23540490,23543904:autre_refus:3726:23543932,23544321:autre_refus:3726:23544374,23545016:autre_refus:3726:23545067,23545644:autre_refus:3726:23545692,23546414:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0052668074216894525, 'nb_photo': 10640, 'list_port_cont': '23525948,23526060,23526317,23526986,23527387,23527737,23528164,23528664,23529343,23529839,23530409,23531070,23531766,23532399,23533106,23534684,23535111,23535506,23536114,23536749,23537421,23537946,23538677,23539335,23539900,23540488,23543783,23543933,23544378,23545065,23545696,23546446,23547121,23548169,23549077,23549924,23551040,23552538,23553091,23553513,23554329,23556178,23556887,23557581,23558243,23558802,23559565,23560060,23560767,23561879,23562723,23563418,23565503,23566306,23574627,23575380,23575488,23575975,23576272,23576551,23576640,23576799,23577290,23577862,23578110,23578861,23579418,23579432,23579757,23579798,23580145,23580386,23585058,23585395,23586023,23586550,23587172,23587861,23588760,23589292,23589972,23590531,23591155,23591668,23592206,23592556,23593336,23594705,23595095,23595436,23595974,23596576,23597871,23598758,23599290,23599566,23599838,23600687,23600705,23600826,23601141,23601528,23602014,23602774,23603584,23604211,23604621,23605383,23605542,23606051,23606354,23606628,23606992,2360740', 'assoc_port': '23525945:23525948,23526028:23526060,23526302:23526317,23526971:23526986,23527369:23527387,23527715:23527737,23528131:23528164,23528644:23528664,23529291:23529343,23529835:23529839,23530360:23530409,23531033:23531070,23531742:23531766,23532378:23532399,23533080:23533106,23534658:23534684,23535076:23535111,23535481:23535506,23536090:23536114,23536707:23536749,23537388:23537421,23537919:23537946,23538641:23538677,23539303:23539335,23539854:23539900,23540468:23540488,23543774:23543783,23543904:23543933,23544321:23544378,23545016:23545065,23545644:23545696,23546414:23546446,23547059:23547121,23548101:23548169,23548984:23549077,23549856:23549924,23550939:23551040,23552513:23552538,23553062:23553091,23553438:23553513,23554249:23554329,23556138:23556178,23556841:23556887,23557546:23557581,23558209:23558243,23558702:23558802,23559495:23559565,23559991:23560060,23560642:23560767,23561867:23561879,23562708:23562723,23563332:23563418,23565391:23565503,23566297:23566306,23574624:23574627,23575369:23575380,23575456:2357548', 'assoc_mat': '23525945:cartonnette:3726:23525948,23526028:cartonnette:3726:23526060,23526302:cartonnette:3726:23526317,23526971:cartonnette:3726:23526986,23527369:cartonnette:3726:23527387,23527715:cartonnette:3726:23527737,23528131:cartonnette:3726:23528164,23528644:cartonnette:3726:23528664,23529291:cartonnette:3726:23529343,23529835:cartonnette:3726:23529839,23530360:cartonnette:3726:23530409,23531033:cartonnette:3726:23531070,23531742:cartonnette:3726:23531766,23532378:cartonnette:3726:23532399,23533080:cartonnette:3726:23533106,23534658:cartonnette:3726:23534684,23535076:cartonnette:3726:23535111,23535481:cartonnette:3726:23535506,23536090:cartonnette:3726:23536114,23536707:cartonnette:3726:23536749,23537388:cartonnette:3726:23537421,23537919:cartonnette:3726:23537946,23538641:cartonnette:3726:23538677,23539303:cartonnette:3726:23539335,23539854:cartonnette:3726:23539900,23540468:cartonnette:3726:23540488,23543774:cartonnette:3726:23543783,23543904:cartonnette:3726:23543933,23544321:cartonnette:3726:23544378,23545016:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.019596479351846663, 'nb_photo': 10828, 'list_port_cont': '23525952,23526064,23526321,23526987,23527389,23527732,23528165,23528657,23529335,23529846,23530402,23531059,23531770,23532405,23533114,23534402,23534679,23535107,23535509,23536115,23536744,23537957,23538673,23539332,23539903,23540495,23543785,23543937,23544370,23545062,23545694,23546442,23547122,23548175,23549069,23549925,23551033,23552539,23553082,23553522,23554331,23556170,23556892,23557587,23558240,23558803,23559560,23560057,23560764,23561884,23562724,23563417,23566313,23572771,23573239,23574631,23575478,23575970,23576275,23576554,23576646,23576798,23577293,23577859,23578106,23578493,23578859,23579429,23579433,23579763,23579797,23580141,23580379,23585051,23585398,23586027,23586549,23587173,23587853,23589288,23589974,23590538,23591149,23591673,23592204,23592562,23593333,23594706,23595084,23595426,23595965,23596579,23597879,23598755,23599564,23599834,23600688,23600704,23600827,23601147,23601533,23602024,23602776,23603586,23604215,23604622,23605391,23605546,23606055,23606345,23606630,23606987,23607401,2360830', 'assoc_port': '23525945:23525952,23526028:23526064,23526302:23526321,23526971:23526987,23527369:23527389,23527715:23527732,23528131:23528165,23528644:23528657,23529291:23529335,23529835:23529846,23530360:23530402,23531033:23531059,23531742:23531770,23532378:23532405,23533080:23533114,23534397:23534402,23534658:23534679,23535076:23535107,23535481:23535509,23536090:23536115,23536707:23536744,23537919:23537957,23538641:23538673,23539303:23539332,23539854:23539903,23540468:23540495,23543774:23543785,23543904:23543937,23544321:23544370,23545016:23545062,23545644:23545694,23546414:23546442,23547059:23547122,23548101:23548175,23548984:23549069,23549856:23549925,23550939:23551033,23552513:23552539,23553062:23553082,23553438:23553522,23554249:23554331,23556138:23556170,23556841:23556892,23557546:23557587,23558209:23558240,23558702:23558803,23559495:23559560,23559991:23560057,23560642:23560764,23561867:23561884,23562708:23562724,23563332:23563417,23566297:23566313,23572766:23572771,23573213:23573239,23574624:23574631,23575456:2357547', 'assoc_mat': '23525945:Carton_brun:3726:23525952,23526028:Carton_brun:3726:23526064,23526302:Carton_brun:3726:23526321,23526971:Carton_brun:3726:23526987,23527369:Carton_brun:3726:23527389,23527715:Carton_brun:3726:23527732,23528131:Carton_brun:3726:23528165,23528644:Carton_brun:3726:23528657,23529291:Carton_brun:3726:23529335,23529835:Carton_brun:3726:23529846,23530360:Carton_brun:3726:23530402,23531033:Carton_brun:3726:23531059,23531742:Carton_brun:3726:23531770,23532378:Carton_brun:3726:23532405,23533080:Carton_brun:3726:23533114,23534397:Carton_brun:3726:23534402,23534658:Carton_brun:3726:23534679,23535076:Carton_brun:3726:23535107,23535481:Carton_brun:3726:23535509,23536090:Carton_brun:3726:23536115,23536707:Carton_brun:3726:23536744,23537919:Carton_brun:3726:23537957,23538641:Carton_brun:3726:23538673,23539303:Carton_brun:3726:23539332,23539854:Carton_brun:3726:23539903,23540468:Carton_brun:3726:23540495,23543774:Carton_brun:3726:23543785,23543904:Carton_brun:3726:23543937,23544321:Carton_brun:3726:23544370,23545016:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00737334714126409, 'nb_photo': 11211, 'list_port_cont': '23525946,23526065,23526316,23526647,23526982,23527392,23527733,23528157,23528663,23529338,23529844,23530412,23531069,23531776,23532407,23533103,23534408,23534687,23535101,23535510,23536748,23537411,23537955,23538674,23539341,23539897,23540487,23543779,23543927,23544367,23545066,23545685,23546438,23547126,23548174,23549070,23549930,23551031,23552528,23553086,23553514,23554339,23556171,23556897,23557589,23558244,23558798,23559561,23560056,23560757,23561878,23562726,23563428,23565505,23574630,23575972,23576276,23576546,23576648,23576796,23577288,23577866,23578103,23578492,23578852,23579428,23579435,23579765,23579788,23580142,23580376,23585054,23585389,23586031,23586543,23587165,23587856,23588761,23589284,23589973,23590528,23591154,23591662,23592199,23592553,23593339,23594703,23595090,23595433,23595970,23596573,23597874,23598749,23599296,23599567,23599841,23600695,23600699,23600829,23601143,23601539,23602021,23602781,23603585,23604209,23604630,23605381,23605541,23606056,23606349,23606625,23606986,23607399,2360830', 'assoc_port': '23525945:23525946,23526028:23526065,23526302:23526316,23526633:23526647,23526971:23526982,23527369:23527392,23527715:23527733,23528131:23528157,23528644:23528663,23529291:23529338,23529835:23529844,23530360:23530412,23531033:23531069,23531742:23531776,23532378:23532407,23533080:23533103,23534397:23534408,23534658:23534687,23535076:23535101,23535481:23535510,23536707:23536748,23537388:23537411,23537919:23537955,23538641:23538674,23539303:23539341,23539854:23539897,23540468:23540487,23543774:23543779,23543904:23543927,23544321:23544367,23545016:23545066,23545644:23545685,23546414:23546438,23547059:23547126,23548101:23548174,23548984:23549070,23549856:23549930,23550939:23551031,23552513:23552528,23553062:23553086,23553438:23553514,23554249:23554339,23556138:23556171,23556841:23556897,23557546:23557589,23558209:23558244,23558702:23558798,23559495:23559561,23559991:23560056,23560642:23560757,23561867:23561878,23562708:23562726,23563332:23563428,23565391:23565505,23574624:23574630,23575958:23575972,23576262:2357627', 'assoc_mat': '23525945:Carton_gris:3726:23525946,23526028:Carton_gris:3726:23526065,23526302:Carton_gris:3726:23526316,23526633:Carton_gris:3726:23526647,23526971:Carton_gris:3726:23526982,23527369:Carton_gris:3726:23527392,23527715:Carton_gris:3726:23527733,23528131:Carton_gris:3726:23528157,23528644:Carton_gris:3726:23528663,23529291:Carton_gris:3726:23529338,23529835:Carton_gris:3726:23529844,23530360:Carton_gris:3726:23530412,23531033:Carton_gris:3726:23531069,23531742:Carton_gris:3726:23531776,23532378:Carton_gris:3726:23532407,23533080:Carton_gris:3726:23533103,23534397:Carton_gris:3726:23534408,23534658:Carton_gris:3726:23534687,23535076:Carton_gris:3726:23535101,23535481:Carton_gris:3726:23535510,23536707:Carton_gris:3726:23536748,23537388:Carton_gris:3726:23537411,23537919:Carton_gris:3726:23537955,23538641:Carton_gris:3726:23538674,23539303:Carton_gris:3726:23539341,23539854:Carton_gris:3726:23539897,23540468:Carton_gris:3726:23540487,23543774:Carton_gris:3726:23543779,23543904:Carton_gris:3726:23543927,23544321:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0028598532418010573, 'nb_photo': 2069, 'list_port_cont': '23526069,23526314,23526991,23527385,23527730,23528158,23528654,23529836,23530415,23531068,23531773,23532406,23533110,23534405,23534685,23535102,23535515,23537417,23538676,23539333,23540493,23544369,23545693,23546435,23548168,23549074,23549923,23551032,23552531,23553520,23554330,23556898,23557586,23558797,23560054,23561874,23562720,23563420,23566314,23575378,23576265,23576644,23578856,23579439,23579789,23580138,23580378,23585394,23586032,23586553,23587169,23587852,23588759,23589293,23589979,23590527,23591156,23592200,23592560,23593335,23594711,23595431,23599562,23600692,23600825,23601145,23601536,23602775,23603580,23604208,23604629,23605392,23605544,23606053,23606347,23606985,23607407,23608308,23611048,23611384,23611889,23612962,23613329,23614041,23614470,23616421,23617078,23617686,23618174,23618873,23620944,23621686,23623425,23624299,23626008,23628455,23632195,23632436,23633760,23634609,23635523,23636020,23636485,23637252,23637331,23637404,23637558,23637675,23638188,23638629,23639372,23639788,23642061,2364249', 'assoc_port': '23526028:23526069,23526302:23526314,23526971:23526991,23527369:23527385,23527715:23527730,23528131:23528158,23528644:23528654,23529835:23529836,23530360:23530415,23531033:23531068,23531742:23531773,23532378:23532406,23533080:23533110,23534397:23534405,23534658:23534685,23535076:23535102,23535481:23535515,23537388:23537417,23538641:23538676,23539303:23539333,23540468:23540493,23544321:23544369,23545644:23545693,23546414:23546435,23548101:23548168,23548984:23549074,23549856:23549923,23550939:23551032,23552513:23552531,23553438:23553520,23554249:23554330,23556841:23556898,23557546:23557586,23558702:23558797,23559991:23560054,23561867:23561874,23562708:23562720,23563332:23563420,23566297:23566314,23575369:23575378,23576262:23576265,23576637:23576644,23578849:23578856,23579417:23579439,23579783:23579789,23580131:23580138,23580373:23580378,23585380:23585394,23585918:23586032,23586541:23586553,23587094:23587169,23587797:23587852,23588678:23588759,23589274:23589293,23589945:23589979,23590466:23590527,23591128:2359115', 'assoc_mat': '23526028:kraft:3726:23526069,23526302:kraft:3726:23526314,23526971:kraft:3726:23526991,23527369:kraft:3726:23527385,23527715:kraft:3726:23527730,23528131:kraft:3726:23528158,23528644:kraft:3726:23528654,23529835:kraft:3726:23529836,23530360:kraft:3726:23530415,23531033:kraft:3726:23531068,23531742:kraft:3726:23531773,23532378:kraft:3726:23532406,23533080:kraft:3726:23533110,23534397:kraft:3726:23534405,23534658:kraft:3726:23534685,23535076:kraft:3726:23535102,23535481:kraft:3726:23535515,23537388:kraft:3726:23537417,23538641:kraft:3726:23538676,23539303:kraft:3726:23539333,23540468:kraft:3726:23540493,23544321:kraft:3726:23544369,23545644:kraft:3726:23545693,23546414:kraft:3726:23546435,23548101:kraft:3726:23548168,23548984:kraft:3726:23549074,23549856:kraft:3726:23549923,23550939:kraft:3726:23551032,23552513:kraft:3726:23552531,23553438:kraft:3726:23553520,23554249:kraft:3726:23554330,23556841:kraft:3726:23556898,23557546:kraft:3726:23557586,23558702:kraft:3726:23558797,23559991:kraft:3726:23560054,23561867:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0029518350882386706, 'nb_photo': 585, 'list_port_cont': '23526068,23526992,23528167,23529845,23533104,23534677,23535103,23545695,23548178,23549928,23552532,23554337,23556896,23557582,23560059,23573233,23576801,23577865,23578109,23578854,23579760,23579790,23580384,23587857,23588768,23591152,23592201,23594707,23595091,23597880,23600686,23601146,23604216,23605385,23606993,23607398,23608302,23609506,23610464,23613578,23614051,23616422,23617270,23617683,23618178,23618871,23621681,23622326,23624310,23626937,23627636,23632196,23632913,23635047,23636016,23637332,23637396,23642492,23645831,23646870,23647410,23648221,23650030,23650307,23652730,23653825,23655060,23655472,23662228,23663326,23670550,23672546,23674206,23675524,23679814,23685203,23685496,23696178,23696501,23696943,23697675,23699816,23700586,23700861,23709966,23712568,23712625,23712748,23712891,23713081,23715702,23721178,23724328,23726856,23733924,23734848,23735439,23778204,23782139,23782792,23784677,23785328,23788046,23791466,23795391,23814842,23820077,23823209,23823859,23827999,23829822,23830871,23832903,2383517', 'assoc_port': '23526028:23526068,23526971:23526992,23528131:23528167,23529835:23529845,23533080:23533104,23534658:23534677,23535076:23535103,23545644:23545695,23548101:23548178,23549856:23549928,23552513:23552532,23554249:23554337,23556841:23556896,23557546:23557582,23559991:23560059,23573213:23573233,23576792:23576801,23577854:23577865,23578098:23578109,23578849:23578854,23579501:23579760,23579783:23579790,23580373:23580384,23587797:23587857,23588678:23588768,23591128:23591152,23592170:23592201,23594697:23594707,23595072:23595091,23597869:23597880,23600684:23600686,23601136:23601146,23604206:23604216,23605380:23605385,23606984:23606993,23607397:23607398,23608281:23608302,23609497:23609506,23610458:23610464,23613576:23613578,23614039:23614051,23616413:23616422,23617264:23617270,23617670:23617683,23618131:23618178,23618827:23618871,23621657:23621681,23622302:23622326,23624195:23624310,23626910:23626937,23627631:23627636,23632149:23632196,23632901:23632913,23634973:23635047,23636007:23636016,23637316:23637332,23637385:2363739', 'assoc_mat': '23526028:metal:3726:23526068,23526971:metal:3726:23526992,23528131:metal:3726:23528167,23529835:metal:3726:23529845,23533080:metal:3726:23533104,23534658:metal:3726:23534677,23535076:metal:3726:23535103,23545644:metal:3726:23545695,23548101:metal:3726:23548178,23549856:metal:3726:23549928,23552513:metal:3726:23552532,23554249:metal:3726:23554337,23556841:metal:3726:23556896,23557546:metal:3726:23557582,23559991:metal:3726:23560059,23573213:metal:3726:23573233,23576792:metal:3726:23576801,23577854:metal:3726:23577865,23578098:metal:3726:23578109,23578849:metal:3726:23578854,23579501:metal:3726:23579760,23579783:metal:3726:23579790,23580373:metal:3726:23580384,23587797:metal:3726:23587857,23588678:metal:3726:23588768,23591128:metal:3726:23591152,23592170:metal:3726:23592201,23594697:metal:3726:23594707,23595072:metal:3726:23595091,23597869:metal:3726:23597880,23600684:metal:3726:23600686,23601136:metal:3726:23601146,23604206:metal:3726:23604216,23605380:metal:3726:23605385,23606984:metal:3726:23606993,23607397:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004957327679325341, 'nb_photo': 8426, 'list_port_cont': '23525947,23526062,23526319,23526985,23527382,23527738,23528161,23528656,23529342,23529847,23530416,23531065,23531774,23532402,23533107,23534682,23535507,23536111,23536747,23537414,23537956,23538675,23539337,23539901,23540489,23543782,23543930,23544377,23545070,23545690,23546434,23547119,23548177,23549068,23549934,23551034,23552530,23553088,23553519,23554334,23556175,23556895,23557588,23558236,23558799,23559566,23560050,23560758,23561880,23562727,23563425,23565506,23572447,23572778,23573230,23575377,23575479,23575974,23576267,23576547,23576643,23576803,23577298,23577860,23578101,23578489,23578855,23579425,23579441,23579768,23579793,23580148,23580381,23585396,23586021,23586546,23587176,23587855,23588765,23589287,23589970,23591153,23591663,23592195,23592561,23593340,23594709,23595089,23595425,23595969,23596581,23598757,23599293,23599569,23599837,23600696,23600708,23601137,23601529,23602022,23602780,23603582,23604212,23604620,23605382,23605539,23606046,23606355,23606632,23606989,23607406,23608299,23608583,2360904', 'assoc_port': '23525945:23525947,23526028:23526062,23526302:23526319,23526971:23526985,23527369:23527382,23527715:23527738,23528131:23528161,23528644:23528656,23529291:23529342,23529835:23529847,23530360:23530416,23531033:23531065,23531742:23531774,23532378:23532402,23533080:23533107,23534658:23534682,23535481:23535507,23536090:23536111,23536707:23536747,23537388:23537414,23537919:23537956,23538641:23538675,23539303:23539337,23539854:23539901,23540468:23540489,23543774:23543782,23543904:23543930,23544321:23544377,23545016:23545070,23545644:23545690,23546414:23546434,23547059:23547119,23548101:23548177,23548984:23549068,23549856:23549934,23550939:23551034,23552513:23552530,23553062:23553088,23553438:23553519,23554249:23554334,23556138:23556175,23556841:23556895,23557546:23557588,23558209:23558236,23558702:23558799,23559495:23559566,23559991:23560050,23560642:23560758,23561867:23561880,23562708:23562727,23563332:23563425,23565391:23565506,23572408:23572447,23572766:23572778,23573213:23573230,23575369:23575377,23575456:2357547', 'assoc_mat': '23525945:plastique:3726:23525947,23526028:plastique:3726:23526062,23526302:plastique:3726:23526319,23526971:plastique:3726:23526985,23527369:plastique:3726:23527382,23527715:plastique:3726:23527738,23528131:plastique:3726:23528161,23528644:plastique:3726:23528656,23529291:plastique:3726:23529342,23529835:plastique:3726:23529847,23530360:plastique:3726:23530416,23531033:plastique:3726:23531065,23531742:plastique:3726:23531774,23532378:plastique:3726:23532402,23533080:plastique:3726:23533107,23534658:plastique:3726:23534682,23535481:plastique:3726:23535507,23536090:plastique:3726:23536111,23536707:plastique:3726:23536747,23537388:plastique:3726:23537414,23537919:plastique:3726:23537956,23538641:plastique:3726:23538675,23539303:plastique:3726:23539337,23539854:plastique:3726:23539901,23540468:plastique:3726:23540489,23543774:plastique:3726:23543782,23543904:plastique:3726:23543930,23544321:plastique:3726:23544377,23545016:plastique:3726:23545070,23545644:plastique:3726:23545690,23546414:plastique:3726:23546434,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.012964994538394019, 'nb_photo': 20893, 'list_port_cont': '23525954,23526067,23526322,23526656,23526989,23527383,23527739,23528160,23528655,23529341,23529838,23530404,23531067,23531769,23532404,23533113,23534412,23534678,23535112,23535513,23536112,23536746,23537419,23537950,23538669,23539339,23539904,23540497,23543777,23543935,23544376,23545069,23545691,23546437,23547123,23548176,23549067,23549927,23551041,23552537,23553087,23553512,23554328,23556172,23556890,23557585,23558234,23558801,23559556,23560053,23560762,23561882,23562722,23563429,23565504,23566309,23572446,23573237,23574411,23574527,23574636,23575484,23575966,23576270,23576552,23576638,23576793,23577294,23577861,23578107,23578487,23578862,23579419,23579431,23579759,23579795,23580149,23580377,23585061,23585390,23586022,23586545,23587170,23587860,23588769,23589285,23589975,23590529,23591150,23591670,23592205,23592554,23593341,23594704,23595094,23595427,23595971,23596578,23597872,23598748,23599294,23599568,23599830,23600691,23600706,23600824,23601138,23601538,23602019,23602773,23603579,23604219,23604623,2360538', 'assoc_port': '23525945:23525954,23526028:23526067,23526302:23526322,23526633:23526656,23526971:23526989,23527369:23527383,23527715:23527739,23528131:23528160,23528644:23528655,23529291:23529341,23529835:23529838,23530360:23530404,23531033:23531067,23531742:23531769,23532378:23532404,23533080:23533113,23534397:23534412,23534658:23534678,23535076:23535112,23535481:23535513,23536090:23536112,23536707:23536746,23537388:23537419,23537919:23537950,23538641:23538669,23539303:23539339,23539854:23539904,23540468:23540497,23543774:23543777,23543904:23543935,23544321:23544376,23545016:23545069,23545644:23545691,23546414:23546437,23547059:23547123,23548101:23548176,23548984:23549067,23549856:23549927,23550939:23551041,23552513:23552537,23553062:23553087,23553438:23553512,23554249:23554328,23556138:23556172,23556841:23556890,23557546:23557585,23558209:23558234,23558702:23558801,23559495:23559556,23559991:23560053,23560642:23560762,23561867:23561882,23562708:23562722,23563332:23563429,23565391:23565504,23566297:23566309,23572408:2357244', 'assoc_mat': '23525945:Teint_Dans_La_Masse:3726:23525954,23526028:Teint_Dans_La_Masse:3726:23526067,23526302:Teint_Dans_La_Masse:3726:23526322,23526633:Teint_Dans_La_Masse:3726:23526656,23526971:Teint_Dans_La_Masse:3726:23526989,23527369:Teint_Dans_La_Masse:3726:23527383,23527715:Teint_Dans_La_Masse:3726:23527739,23528131:Teint_Dans_La_Masse:3726:23528160,23528644:Teint_Dans_La_Masse:3726:23528655,23529291:Teint_Dans_La_Masse:3726:23529341,23529835:Teint_Dans_La_Masse:3726:23529838,23530360:Teint_Dans_La_Masse:3726:23530404,23531033:Teint_Dans_La_Masse:3726:23531067,23531742:Teint_Dans_La_Masse:3726:23531769,23532378:Teint_Dans_La_Masse:3726:23532404,23533080:Teint_Dans_La_Masse:3726:23533113,23534397:Teint_Dans_La_Masse:3726:23534412,23534658:Teint_Dans_La_Masse:3726:23534678,23535076:Teint_Dans_La_Masse:3726:23535112,23535481:Teint_Dans_La_Masse:3726:23535513,23536090:Teint_Dans_La_Masse:3726:23536112,23536707:Teint_Dans_La_Masse:3726:23536746,23537388:Teint_Dans_La_Masse:3726:23537419,23537919:Teint_Dans_La_Masse:3726:2'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(1867615,1871480,1875320,1879346,1883633,1885718,1894540,1898493,1902006,1910165,1927500,1910208,1921868,1925145,1925525,1932868,1925344,1925333,1929579,1933078,1935537,1938526,1940157,1946497)); 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=979) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=10 and date >='2025-06-01' and date <= '2025-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((107104,),), 'unwanted_material_monthly_percentage': ((0.048227744061745084,),), 'material_repartition': (('JRM', 104081),), 'material_dict': {'JRM': 104081}, 'coverage_data': (('2025/06/30/', 0.976564), ('2025/06/28/', 1.0), ('2025/06/27/', 0.977187), ('2025/06/26/', 0.979687), ('2025/06/25/', 0.977997), ('2025/06/20/', 0.97728), ('2025/06/19/', 0.974571), ('2025/06/18/', 0.979409), ('2025/06/17/', 0.977859), ('2025/06/16/', 0.976929), ('2025/06/14/', 0.978499), ('2025/06/13/', 0.978507), ('2025/06/12/', 0.978136), ('2025/06/11/', 0.978067), ('2025/06/10/', 0.977951), ('2025/06/09/', 0.979093), ('2025/06/07/', 0.981221), ('2025/06/06/', 0.976805), ('2025/06/05/', 0.976342), ('2025/06/04/', 0.977604), ('2025/06/03/', 0.976238), ('2025/06/02/', 0.973772)), 'impurety_average_data': ((datetime.date(2025, 6, 2), 0.0526615580826415, 3296), (datetime.date(2025, 6, 3), 0.050013810634511664, 3277), (datetime.date(2025, 6, 4), 0.04957748984951549, 4466), (datetime.date(2025, 6, 5), 0.04537575304947456, 4035), (datetime.date(2025, 6, 6), 0.05387365721942639, 3449), (datetime.date(2025, 6, 7), 0.05025021848843321, 701), (datetime.date(2025, 6, 9), 0.04415613218613245, 4640), (datetime.date(2025, 6, 10), 0.06865446779267274, 2421), (datetime.date(2025, 6, 11), 0.048205257284777904, 7783), (datetime.date(2025, 6, 12), 0.04780409585632248, 8325), (datetime.date(2025, 6, 13), 0.04491212410727034, 8133), (datetime.date(2025, 6, 14), 0.05532346808444853, 1096), (datetime.date(2025, 6, 16), 0.04364578714385726, 9127), (datetime.date(2025, 6, 17), 0.0513501829166999, 6926), (datetime.date(2025, 6, 18), 0.043236889660619185, 7275), (datetime.date(2025, 6, 19), 0.04174308223091769, 7703), (datetime.date(2025, 6, 20), 0.052348148232956804, 7720), (datetime.date(2025, 6, 21), 0.06001972168658217, 6), (datetime.date(2025, 6, 24), 0.04728888861687083, 2724), (datetime.date(2025, 6, 25), 0.043653715609153584, 3831), (datetime.date(2025, 6, 26), 0.04503088280700554, 2603), (datetime.date(2025, 6, 27), 0.04497005548190578, 4514), (datetime.date(2025, 6, 28), 0.04859325772029209, 30), (datetime.date(2025, 6, 30), 0.04794968546230305, 2965)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 6, 2), 0.0526615580826415, 3296), (datetime.date(2025, 6, 3), 0.050013810634511664, 3277), (datetime.date(2025, 6, 4), 0.04957748984951549, 4466), (datetime.date(2025, 6, 5), 0.04537575304947456, 4035), (datetime.date(2025, 6, 6), 0.05387365721942639, 3449), (datetime.date(2025, 6, 7), 0.05025021848843321, 701), (datetime.date(2025, 6, 9), 0.04415613218613245, 4640), (datetime.date(2025, 6, 10), 0.06865446779267274, 2421), (datetime.date(2025, 6, 11), 0.048205257284777904, 7783), (datetime.date(2025, 6, 12), 0.04780409585632248, 8325), (datetime.date(2025, 6, 13), 0.04491212410727034, 8133), (datetime.date(2025, 6, 14), 0.05532346808444853, 1096), (datetime.date(2025, 6, 16), 0.04364578714385726, 9127), (datetime.date(2025, 6, 17), 0.0513501829166999, 6926), (datetime.date(2025, 6, 18), 0.043236889660619185, 7275), (datetime.date(2025, 6, 19), 0.04174308223091769, 7703), (datetime.date(2025, 6, 20), 0.052348148232956804, 7720), (datetime.date(2025, 6, 21), 0.06001972168658217, 6), (datetime.date(2025, 6, 24), 0.04728888861687083, 2724), (datetime.date(2025, 6, 25), 0.043653715609153584, 3831), (datetime.date(2025, 6, 26), 0.04503088280700554, 2603), (datetime.date(2025, 6, 27), 0.04497005548190578, 4514), (datetime.date(2025, 6, 28), 0.04859325772029209, 30), (datetime.date(2025, 6, 30), 0.04794968546230305, 2965))}, 'quality_array': [['-4.663749571866619', '02062025'], ['-4.564772357512287', '03062025'], ['-4.699017727118491', '04062025'], ['-4.687846857004656', '05062025'], ['-4.739459348574449', '06062025'], ['-4.792453764778051', '07062025'], ['-4.396159490725603', '09062025'], ['-4.4034191690293305', '10062025'], ['-4.711265271966628', '11062025'], ['-4.851291452234305', '12062025'], ['-4.634276242135348', '13062025'], ['-4.622308700070088', '14062025'], ['-4.731516190100221', '16062025'], ['-4.528634987813945', '17062025'], ['-4.4777010858905975', '18062025'], ['-4.499213694267429', '19062025'], ['-3.933636874246675', '20062025'], ['-5.710016074636889', '21062025'], ['-4.359845690115955', '24062025'], ['-4.372611970429952', '25062025'], ['-4.26957401612936', '26062025'], ['-4.32213955709934', '27062025'], ['-4.398229977065266', '28062025'], ['-4.035407513457558', '30062025']], 'number_of_batch': ((1332,),), 'datou_id_sts': 4878, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005057384244367119, 'nb_photo': 7574, 'list_port_cont': '23525957,23526059,23526320,23526654,23526983,23527386,23527731,23528156,23528662,23529332,23529843,23530405,23531062,23531777,23532403,23533112,23534680,23535512,23536750,23537415,23537953,23538667,23539334,23539907,23540490,23543932,23544374,23545067,23545692,23546440,23547128,23548171,23549073,23549929,23551036,23552534,23553081,23553521,23554335,23556168,23556889,23557593,23558238,23558804,23559562,23560062,23560768,23561883,23562721,23563423,23566310,23572448,23572779,23574524,23574629,23575375,23575477,23575965,23576271,23576797,23577292,23577857,23578105,23578486,23578860,23579422,23579444,23579767,23579796,23580139,23580385,23585055,23585393,23586024,23586542,23587166,23587862,23588764,23589289,23589978,23590534,23591151,23591667,23592198,23592559,23593338,23594712,23595086,23595432,23595967,23596575,23597875,23599288,23599572,23599833,23600690,23600702,23601144,23601535,23602025,23603583,23604210,23604628,23605388,23605538,23606048,23606348,23606629,23606996,23607405,23608303,23608586,23609046,2360950', 'assoc_port': '23525945:23525957,23526028:23526059,23526302:23526320,23526633:23526654,23526971:23526983,23527369:23527386,23527715:23527731,23528131:23528156,23528644:23528662,23529291:23529332,23529835:23529843,23530360:23530405,23531033:23531062,23531742:23531777,23532378:23532403,23533080:23533112,23534658:23534680,23535481:23535512,23536707:23536750,23537388:23537415,23537919:23537953,23538641:23538667,23539303:23539334,23539854:23539907,23540468:23540490,23543904:23543932,23544321:23544374,23545016:23545067,23545644:23545692,23546414:23546440,23547059:23547128,23548101:23548171,23548984:23549073,23549856:23549929,23550939:23551036,23552513:23552534,23553062:23553081,23553438:23553521,23554249:23554335,23556138:23556168,23556841:23556889,23557546:23557593,23558209:23558238,23558702:23558804,23559495:23559562,23559991:23560062,23560642:23560768,23561867:23561883,23562708:23562721,23563332:23563423,23566297:23566310,23572408:23572448,23572766:23572779,23574516:23574524,23574624:23574629,23575369:23575375,23575456:2357547', 'assoc_mat': '23525945:autre_refus:3726:23525957,23526028:autre_refus:3726:23526059,23526302:autre_refus:3726:23526320,23526633:autre_refus:3726:23526654,23526971:autre_refus:3726:23526983,23527369:autre_refus:3726:23527386,23527715:autre_refus:3726:23527731,23528131:autre_refus:3726:23528156,23528644:autre_refus:3726:23528662,23529291:autre_refus:3726:23529332,23529835:autre_refus:3726:23529843,23530360:autre_refus:3726:23530405,23531033:autre_refus:3726:23531062,23531742:autre_refus:3726:23531777,23532378:autre_refus:3726:23532403,23533080:autre_refus:3726:23533112,23534658:autre_refus:3726:23534680,23535481:autre_refus:3726:23535512,23536707:autre_refus:3726:23536750,23537388:autre_refus:3726:23537415,23537919:autre_refus:3726:23537953,23538641:autre_refus:3726:23538667,23539303:autre_refus:3726:23539334,23539854:autre_refus:3726:23539907,23540468:autre_refus:3726:23540490,23543904:autre_refus:3726:23543932,23544321:autre_refus:3726:23544374,23545016:autre_refus:3726:23545067,23545644:autre_refus:3726:23545692,23546414:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0052668074216894525, 'nb_photo': 10640, 'list_port_cont': '23525948,23526060,23526317,23526986,23527387,23527737,23528164,23528664,23529343,23529839,23530409,23531070,23531766,23532399,23533106,23534684,23535111,23535506,23536114,23536749,23537421,23537946,23538677,23539335,23539900,23540488,23543783,23543933,23544378,23545065,23545696,23546446,23547121,23548169,23549077,23549924,23551040,23552538,23553091,23553513,23554329,23556178,23556887,23557581,23558243,23558802,23559565,23560060,23560767,23561879,23562723,23563418,23565503,23566306,23574627,23575380,23575488,23575975,23576272,23576551,23576640,23576799,23577290,23577862,23578110,23578861,23579418,23579432,23579757,23579798,23580145,23580386,23585058,23585395,23586023,23586550,23587172,23587861,23588760,23589292,23589972,23590531,23591155,23591668,23592206,23592556,23593336,23594705,23595095,23595436,23595974,23596576,23597871,23598758,23599290,23599566,23599838,23600687,23600705,23600826,23601141,23601528,23602014,23602774,23603584,23604211,23604621,23605383,23605542,23606051,23606354,23606628,23606992,2360740', 'assoc_port': '23525945:23525948,23526028:23526060,23526302:23526317,23526971:23526986,23527369:23527387,23527715:23527737,23528131:23528164,23528644:23528664,23529291:23529343,23529835:23529839,23530360:23530409,23531033:23531070,23531742:23531766,23532378:23532399,23533080:23533106,23534658:23534684,23535076:23535111,23535481:23535506,23536090:23536114,23536707:23536749,23537388:23537421,23537919:23537946,23538641:23538677,23539303:23539335,23539854:23539900,23540468:23540488,23543774:23543783,23543904:23543933,23544321:23544378,23545016:23545065,23545644:23545696,23546414:23546446,23547059:23547121,23548101:23548169,23548984:23549077,23549856:23549924,23550939:23551040,23552513:23552538,23553062:23553091,23553438:23553513,23554249:23554329,23556138:23556178,23556841:23556887,23557546:23557581,23558209:23558243,23558702:23558802,23559495:23559565,23559991:23560060,23560642:23560767,23561867:23561879,23562708:23562723,23563332:23563418,23565391:23565503,23566297:23566306,23574624:23574627,23575369:23575380,23575456:2357548', 'assoc_mat': '23525945:cartonnette:3726:23525948,23526028:cartonnette:3726:23526060,23526302:cartonnette:3726:23526317,23526971:cartonnette:3726:23526986,23527369:cartonnette:3726:23527387,23527715:cartonnette:3726:23527737,23528131:cartonnette:3726:23528164,23528644:cartonnette:3726:23528664,23529291:cartonnette:3726:23529343,23529835:cartonnette:3726:23529839,23530360:cartonnette:3726:23530409,23531033:cartonnette:3726:23531070,23531742:cartonnette:3726:23531766,23532378:cartonnette:3726:23532399,23533080:cartonnette:3726:23533106,23534658:cartonnette:3726:23534684,23535076:cartonnette:3726:23535111,23535481:cartonnette:3726:23535506,23536090:cartonnette:3726:23536114,23536707:cartonnette:3726:23536749,23537388:cartonnette:3726:23537421,23537919:cartonnette:3726:23537946,23538641:cartonnette:3726:23538677,23539303:cartonnette:3726:23539335,23539854:cartonnette:3726:23539900,23540468:cartonnette:3726:23540488,23543774:cartonnette:3726:23543783,23543904:cartonnette:3726:23543933,23544321:cartonnette:3726:23544378,23545016:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.019596479351846663, 'nb_photo': 10828, 'list_port_cont': '23525952,23526064,23526321,23526987,23527389,23527732,23528165,23528657,23529335,23529846,23530402,23531059,23531770,23532405,23533114,23534402,23534679,23535107,23535509,23536115,23536744,23537957,23538673,23539332,23539903,23540495,23543785,23543937,23544370,23545062,23545694,23546442,23547122,23548175,23549069,23549925,23551033,23552539,23553082,23553522,23554331,23556170,23556892,23557587,23558240,23558803,23559560,23560057,23560764,23561884,23562724,23563417,23566313,23572771,23573239,23574631,23575478,23575970,23576275,23576554,23576646,23576798,23577293,23577859,23578106,23578493,23578859,23579429,23579433,23579763,23579797,23580141,23580379,23585051,23585398,23586027,23586549,23587173,23587853,23589288,23589974,23590538,23591149,23591673,23592204,23592562,23593333,23594706,23595084,23595426,23595965,23596579,23597879,23598755,23599564,23599834,23600688,23600704,23600827,23601147,23601533,23602024,23602776,23603586,23604215,23604622,23605391,23605546,23606055,23606345,23606630,23606987,23607401,2360830', 'assoc_port': '23525945:23525952,23526028:23526064,23526302:23526321,23526971:23526987,23527369:23527389,23527715:23527732,23528131:23528165,23528644:23528657,23529291:23529335,23529835:23529846,23530360:23530402,23531033:23531059,23531742:23531770,23532378:23532405,23533080:23533114,23534397:23534402,23534658:23534679,23535076:23535107,23535481:23535509,23536090:23536115,23536707:23536744,23537919:23537957,23538641:23538673,23539303:23539332,23539854:23539903,23540468:23540495,23543774:23543785,23543904:23543937,23544321:23544370,23545016:23545062,23545644:23545694,23546414:23546442,23547059:23547122,23548101:23548175,23548984:23549069,23549856:23549925,23550939:23551033,23552513:23552539,23553062:23553082,23553438:23553522,23554249:23554331,23556138:23556170,23556841:23556892,23557546:23557587,23558209:23558240,23558702:23558803,23559495:23559560,23559991:23560057,23560642:23560764,23561867:23561884,23562708:23562724,23563332:23563417,23566297:23566313,23572766:23572771,23573213:23573239,23574624:23574631,23575456:2357547', 'assoc_mat': '23525945:Carton_brun:3726:23525952,23526028:Carton_brun:3726:23526064,23526302:Carton_brun:3726:23526321,23526971:Carton_brun:3726:23526987,23527369:Carton_brun:3726:23527389,23527715:Carton_brun:3726:23527732,23528131:Carton_brun:3726:23528165,23528644:Carton_brun:3726:23528657,23529291:Carton_brun:3726:23529335,23529835:Carton_brun:3726:23529846,23530360:Carton_brun:3726:23530402,23531033:Carton_brun:3726:23531059,23531742:Carton_brun:3726:23531770,23532378:Carton_brun:3726:23532405,23533080:Carton_brun:3726:23533114,23534397:Carton_brun:3726:23534402,23534658:Carton_brun:3726:23534679,23535076:Carton_brun:3726:23535107,23535481:Carton_brun:3726:23535509,23536090:Carton_brun:3726:23536115,23536707:Carton_brun:3726:23536744,23537919:Carton_brun:3726:23537957,23538641:Carton_brun:3726:23538673,23539303:Carton_brun:3726:23539332,23539854:Carton_brun:3726:23539903,23540468:Carton_brun:3726:23540495,23543774:Carton_brun:3726:23543785,23543904:Carton_brun:3726:23543937,23544321:Carton_brun:3726:23544370,23545016:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00737334714126409, 'nb_photo': 11211, 'list_port_cont': '23525946,23526065,23526316,23526647,23526982,23527392,23527733,23528157,23528663,23529338,23529844,23530412,23531069,23531776,23532407,23533103,23534408,23534687,23535101,23535510,23536748,23537411,23537955,23538674,23539341,23539897,23540487,23543779,23543927,23544367,23545066,23545685,23546438,23547126,23548174,23549070,23549930,23551031,23552528,23553086,23553514,23554339,23556171,23556897,23557589,23558244,23558798,23559561,23560056,23560757,23561878,23562726,23563428,23565505,23574630,23575972,23576276,23576546,23576648,23576796,23577288,23577866,23578103,23578492,23578852,23579428,23579435,23579765,23579788,23580142,23580376,23585054,23585389,23586031,23586543,23587165,23587856,23588761,23589284,23589973,23590528,23591154,23591662,23592199,23592553,23593339,23594703,23595090,23595433,23595970,23596573,23597874,23598749,23599296,23599567,23599841,23600695,23600699,23600829,23601143,23601539,23602021,23602781,23603585,23604209,23604630,23605381,23605541,23606056,23606349,23606625,23606986,23607399,2360830', 'assoc_port': '23525945:23525946,23526028:23526065,23526302:23526316,23526633:23526647,23526971:23526982,23527369:23527392,23527715:23527733,23528131:23528157,23528644:23528663,23529291:23529338,23529835:23529844,23530360:23530412,23531033:23531069,23531742:23531776,23532378:23532407,23533080:23533103,23534397:23534408,23534658:23534687,23535076:23535101,23535481:23535510,23536707:23536748,23537388:23537411,23537919:23537955,23538641:23538674,23539303:23539341,23539854:23539897,23540468:23540487,23543774:23543779,23543904:23543927,23544321:23544367,23545016:23545066,23545644:23545685,23546414:23546438,23547059:23547126,23548101:23548174,23548984:23549070,23549856:23549930,23550939:23551031,23552513:23552528,23553062:23553086,23553438:23553514,23554249:23554339,23556138:23556171,23556841:23556897,23557546:23557589,23558209:23558244,23558702:23558798,23559495:23559561,23559991:23560056,23560642:23560757,23561867:23561878,23562708:23562726,23563332:23563428,23565391:23565505,23574624:23574630,23575958:23575972,23576262:2357627', 'assoc_mat': '23525945:Carton_gris:3726:23525946,23526028:Carton_gris:3726:23526065,23526302:Carton_gris:3726:23526316,23526633:Carton_gris:3726:23526647,23526971:Carton_gris:3726:23526982,23527369:Carton_gris:3726:23527392,23527715:Carton_gris:3726:23527733,23528131:Carton_gris:3726:23528157,23528644:Carton_gris:3726:23528663,23529291:Carton_gris:3726:23529338,23529835:Carton_gris:3726:23529844,23530360:Carton_gris:3726:23530412,23531033:Carton_gris:3726:23531069,23531742:Carton_gris:3726:23531776,23532378:Carton_gris:3726:23532407,23533080:Carton_gris:3726:23533103,23534397:Carton_gris:3726:23534408,23534658:Carton_gris:3726:23534687,23535076:Carton_gris:3726:23535101,23535481:Carton_gris:3726:23535510,23536707:Carton_gris:3726:23536748,23537388:Carton_gris:3726:23537411,23537919:Carton_gris:3726:23537955,23538641:Carton_gris:3726:23538674,23539303:Carton_gris:3726:23539341,23539854:Carton_gris:3726:23539897,23540468:Carton_gris:3726:23540487,23543774:Carton_gris:3726:23543779,23543904:Carton_gris:3726:23543927,23544321:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0028598532418010573, 'nb_photo': 2069, 'list_port_cont': '23526069,23526314,23526991,23527385,23527730,23528158,23528654,23529836,23530415,23531068,23531773,23532406,23533110,23534405,23534685,23535102,23535515,23537417,23538676,23539333,23540493,23544369,23545693,23546435,23548168,23549074,23549923,23551032,23552531,23553520,23554330,23556898,23557586,23558797,23560054,23561874,23562720,23563420,23566314,23575378,23576265,23576644,23578856,23579439,23579789,23580138,23580378,23585394,23586032,23586553,23587169,23587852,23588759,23589293,23589979,23590527,23591156,23592200,23592560,23593335,23594711,23595431,23599562,23600692,23600825,23601145,23601536,23602775,23603580,23604208,23604629,23605392,23605544,23606053,23606347,23606985,23607407,23608308,23611048,23611384,23611889,23612962,23613329,23614041,23614470,23616421,23617078,23617686,23618174,23618873,23620944,23621686,23623425,23624299,23626008,23628455,23632195,23632436,23633760,23634609,23635523,23636020,23636485,23637252,23637331,23637404,23637558,23637675,23638188,23638629,23639372,23639788,23642061,2364249', 'assoc_port': '23526028:23526069,23526302:23526314,23526971:23526991,23527369:23527385,23527715:23527730,23528131:23528158,23528644:23528654,23529835:23529836,23530360:23530415,23531033:23531068,23531742:23531773,23532378:23532406,23533080:23533110,23534397:23534405,23534658:23534685,23535076:23535102,23535481:23535515,23537388:23537417,23538641:23538676,23539303:23539333,23540468:23540493,23544321:23544369,23545644:23545693,23546414:23546435,23548101:23548168,23548984:23549074,23549856:23549923,23550939:23551032,23552513:23552531,23553438:23553520,23554249:23554330,23556841:23556898,23557546:23557586,23558702:23558797,23559991:23560054,23561867:23561874,23562708:23562720,23563332:23563420,23566297:23566314,23575369:23575378,23576262:23576265,23576637:23576644,23578849:23578856,23579417:23579439,23579783:23579789,23580131:23580138,23580373:23580378,23585380:23585394,23585918:23586032,23586541:23586553,23587094:23587169,23587797:23587852,23588678:23588759,23589274:23589293,23589945:23589979,23590466:23590527,23591128:2359115', 'assoc_mat': '23526028:kraft:3726:23526069,23526302:kraft:3726:23526314,23526971:kraft:3726:23526991,23527369:kraft:3726:23527385,23527715:kraft:3726:23527730,23528131:kraft:3726:23528158,23528644:kraft:3726:23528654,23529835:kraft:3726:23529836,23530360:kraft:3726:23530415,23531033:kraft:3726:23531068,23531742:kraft:3726:23531773,23532378:kraft:3726:23532406,23533080:kraft:3726:23533110,23534397:kraft:3726:23534405,23534658:kraft:3726:23534685,23535076:kraft:3726:23535102,23535481:kraft:3726:23535515,23537388:kraft:3726:23537417,23538641:kraft:3726:23538676,23539303:kraft:3726:23539333,23540468:kraft:3726:23540493,23544321:kraft:3726:23544369,23545644:kraft:3726:23545693,23546414:kraft:3726:23546435,23548101:kraft:3726:23548168,23548984:kraft:3726:23549074,23549856:kraft:3726:23549923,23550939:kraft:3726:23551032,23552513:kraft:3726:23552531,23553438:kraft:3726:23553520,23554249:kraft:3726:23554330,23556841:kraft:3726:23556898,23557546:kraft:3726:23557586,23558702:kraft:3726:23558797,23559991:kraft:3726:23560054,23561867:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0029518350882386706, 'nb_photo': 585, 'list_port_cont': '23526068,23526992,23528167,23529845,23533104,23534677,23535103,23545695,23548178,23549928,23552532,23554337,23556896,23557582,23560059,23573233,23576801,23577865,23578109,23578854,23579760,23579790,23580384,23587857,23588768,23591152,23592201,23594707,23595091,23597880,23600686,23601146,23604216,23605385,23606993,23607398,23608302,23609506,23610464,23613578,23614051,23616422,23617270,23617683,23618178,23618871,23621681,23622326,23624310,23626937,23627636,23632196,23632913,23635047,23636016,23637332,23637396,23642492,23645831,23646870,23647410,23648221,23650030,23650307,23652730,23653825,23655060,23655472,23662228,23663326,23670550,23672546,23674206,23675524,23679814,23685203,23685496,23696178,23696501,23696943,23697675,23699816,23700586,23700861,23709966,23712568,23712625,23712748,23712891,23713081,23715702,23721178,23724328,23726856,23733924,23734848,23735439,23778204,23782139,23782792,23784677,23785328,23788046,23791466,23795391,23814842,23820077,23823209,23823859,23827999,23829822,23830871,23832903,2383517', 'assoc_port': '23526028:23526068,23526971:23526992,23528131:23528167,23529835:23529845,23533080:23533104,23534658:23534677,23535076:23535103,23545644:23545695,23548101:23548178,23549856:23549928,23552513:23552532,23554249:23554337,23556841:23556896,23557546:23557582,23559991:23560059,23573213:23573233,23576792:23576801,23577854:23577865,23578098:23578109,23578849:23578854,23579501:23579760,23579783:23579790,23580373:23580384,23587797:23587857,23588678:23588768,23591128:23591152,23592170:23592201,23594697:23594707,23595072:23595091,23597869:23597880,23600684:23600686,23601136:23601146,23604206:23604216,23605380:23605385,23606984:23606993,23607397:23607398,23608281:23608302,23609497:23609506,23610458:23610464,23613576:23613578,23614039:23614051,23616413:23616422,23617264:23617270,23617670:23617683,23618131:23618178,23618827:23618871,23621657:23621681,23622302:23622326,23624195:23624310,23626910:23626937,23627631:23627636,23632149:23632196,23632901:23632913,23634973:23635047,23636007:23636016,23637316:23637332,23637385:2363739', 'assoc_mat': '23526028:metal:3726:23526068,23526971:metal:3726:23526992,23528131:metal:3726:23528167,23529835:metal:3726:23529845,23533080:metal:3726:23533104,23534658:metal:3726:23534677,23535076:metal:3726:23535103,23545644:metal:3726:23545695,23548101:metal:3726:23548178,23549856:metal:3726:23549928,23552513:metal:3726:23552532,23554249:metal:3726:23554337,23556841:metal:3726:23556896,23557546:metal:3726:23557582,23559991:metal:3726:23560059,23573213:metal:3726:23573233,23576792:metal:3726:23576801,23577854:metal:3726:23577865,23578098:metal:3726:23578109,23578849:metal:3726:23578854,23579501:metal:3726:23579760,23579783:metal:3726:23579790,23580373:metal:3726:23580384,23587797:metal:3726:23587857,23588678:metal:3726:23588768,23591128:metal:3726:23591152,23592170:metal:3726:23592201,23594697:metal:3726:23594707,23595072:metal:3726:23595091,23597869:metal:3726:23597880,23600684:metal:3726:23600686,23601136:metal:3726:23601146,23604206:metal:3726:23604216,23605380:metal:3726:23605385,23606984:metal:3726:23606993,23607397:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004957327679325341, 'nb_photo': 8426, 'list_port_cont': '23525947,23526062,23526319,23526985,23527382,23527738,23528161,23528656,23529342,23529847,23530416,23531065,23531774,23532402,23533107,23534682,23535507,23536111,23536747,23537414,23537956,23538675,23539337,23539901,23540489,23543782,23543930,23544377,23545070,23545690,23546434,23547119,23548177,23549068,23549934,23551034,23552530,23553088,23553519,23554334,23556175,23556895,23557588,23558236,23558799,23559566,23560050,23560758,23561880,23562727,23563425,23565506,23572447,23572778,23573230,23575377,23575479,23575974,23576267,23576547,23576643,23576803,23577298,23577860,23578101,23578489,23578855,23579425,23579441,23579768,23579793,23580148,23580381,23585396,23586021,23586546,23587176,23587855,23588765,23589287,23589970,23591153,23591663,23592195,23592561,23593340,23594709,23595089,23595425,23595969,23596581,23598757,23599293,23599569,23599837,23600696,23600708,23601137,23601529,23602022,23602780,23603582,23604212,23604620,23605382,23605539,23606046,23606355,23606632,23606989,23607406,23608299,23608583,2360904', 'assoc_port': '23525945:23525947,23526028:23526062,23526302:23526319,23526971:23526985,23527369:23527382,23527715:23527738,23528131:23528161,23528644:23528656,23529291:23529342,23529835:23529847,23530360:23530416,23531033:23531065,23531742:23531774,23532378:23532402,23533080:23533107,23534658:23534682,23535481:23535507,23536090:23536111,23536707:23536747,23537388:23537414,23537919:23537956,23538641:23538675,23539303:23539337,23539854:23539901,23540468:23540489,23543774:23543782,23543904:23543930,23544321:23544377,23545016:23545070,23545644:23545690,23546414:23546434,23547059:23547119,23548101:23548177,23548984:23549068,23549856:23549934,23550939:23551034,23552513:23552530,23553062:23553088,23553438:23553519,23554249:23554334,23556138:23556175,23556841:23556895,23557546:23557588,23558209:23558236,23558702:23558799,23559495:23559566,23559991:23560050,23560642:23560758,23561867:23561880,23562708:23562727,23563332:23563425,23565391:23565506,23572408:23572447,23572766:23572778,23573213:23573230,23575369:23575377,23575456:2357547', 'assoc_mat': '23525945:plastique:3726:23525947,23526028:plastique:3726:23526062,23526302:plastique:3726:23526319,23526971:plastique:3726:23526985,23527369:plastique:3726:23527382,23527715:plastique:3726:23527738,23528131:plastique:3726:23528161,23528644:plastique:3726:23528656,23529291:plastique:3726:23529342,23529835:plastique:3726:23529847,23530360:plastique:3726:23530416,23531033:plastique:3726:23531065,23531742:plastique:3726:23531774,23532378:plastique:3726:23532402,23533080:plastique:3726:23533107,23534658:plastique:3726:23534682,23535481:plastique:3726:23535507,23536090:plastique:3726:23536111,23536707:plastique:3726:23536747,23537388:plastique:3726:23537414,23537919:plastique:3726:23537956,23538641:plastique:3726:23538675,23539303:plastique:3726:23539337,23539854:plastique:3726:23539901,23540468:plastique:3726:23540489,23543774:plastique:3726:23543782,23543904:plastique:3726:23543930,23544321:plastique:3726:23544377,23545016:plastique:3726:23545070,23545644:plastique:3726:23545690,23546414:plastique:3726:23546434,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.012964994538394019, 'nb_photo': 20893, 'list_port_cont': '23525954,23526067,23526322,23526656,23526989,23527383,23527739,23528160,23528655,23529341,23529838,23530404,23531067,23531769,23532404,23533113,23534412,23534678,23535112,23535513,23536112,23536746,23537419,23537950,23538669,23539339,23539904,23540497,23543777,23543935,23544376,23545069,23545691,23546437,23547123,23548176,23549067,23549927,23551041,23552537,23553087,23553512,23554328,23556172,23556890,23557585,23558234,23558801,23559556,23560053,23560762,23561882,23562722,23563429,23565504,23566309,23572446,23573237,23574411,23574527,23574636,23575484,23575966,23576270,23576552,23576638,23576793,23577294,23577861,23578107,23578487,23578862,23579419,23579431,23579759,23579795,23580149,23580377,23585061,23585390,23586022,23586545,23587170,23587860,23588769,23589285,23589975,23590529,23591150,23591670,23592205,23592554,23593341,23594704,23595094,23595427,23595971,23596578,23597872,23598748,23599294,23599568,23599830,23600691,23600706,23600824,23601138,23601538,23602019,23602773,23603579,23604219,23604623,2360538', 'assoc_port': '23525945:23525954,23526028:23526067,23526302:23526322,23526633:23526656,23526971:23526989,23527369:23527383,23527715:23527739,23528131:23528160,23528644:23528655,23529291:23529341,23529835:23529838,23530360:23530404,23531033:23531067,23531742:23531769,23532378:23532404,23533080:23533113,23534397:23534412,23534658:23534678,23535076:23535112,23535481:23535513,23536090:23536112,23536707:23536746,23537388:23537419,23537919:23537950,23538641:23538669,23539303:23539339,23539854:23539904,23540468:23540497,23543774:23543777,23543904:23543935,23544321:23544376,23545016:23545069,23545644:23545691,23546414:23546437,23547059:23547123,23548101:23548176,23548984:23549067,23549856:23549927,23550939:23551041,23552513:23552537,23553062:23553087,23553438:23553512,23554249:23554328,23556138:23556172,23556841:23556890,23557546:23557585,23558209:23558234,23558702:23558801,23559495:23559556,23559991:23560053,23560642:23560762,23561867:23561882,23562708:23562722,23563332:23563429,23565391:23565504,23566297:23566309,23572408:2357244', 'assoc_mat': '23525945:Teint_Dans_La_Masse:3726:23525954,23526028:Teint_Dans_La_Masse:3726:23526067,23526302:Teint_Dans_La_Masse:3726:23526322,23526633:Teint_Dans_La_Masse:3726:23526656,23526971:Teint_Dans_La_Masse:3726:23526989,23527369:Teint_Dans_La_Masse:3726:23527383,23527715:Teint_Dans_La_Masse:3726:23527739,23528131:Teint_Dans_La_Masse:3726:23528160,23528644:Teint_Dans_La_Masse:3726:23528655,23529291:Teint_Dans_La_Masse:3726:23529341,23529835:Teint_Dans_La_Masse:3726:23529838,23530360:Teint_Dans_La_Masse:3726:23530404,23531033:Teint_Dans_La_Masse:3726:23531067,23531742:Teint_Dans_La_Masse:3726:23531769,23532378:Teint_Dans_La_Masse:3726:23532404,23533080:Teint_Dans_La_Masse:3726:23533113,23534397:Teint_Dans_La_Masse:3726:23534412,23534658:Teint_Dans_La_Masse:3726:23534678,23535076:Teint_Dans_La_Masse:3726:23535112,23535481:Teint_Dans_La_Masse:3726:23535513,23536090:Teint_Dans_La_Masse:3726:23536112,23536707:Teint_Dans_La_Masse:3726:23536746,23537388:Teint_Dans_La_Masse:3726:23537419,23537919:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 107104}}, 'hostname': (('jetson-73',),), 'impurety_average_per_hashtag': [(('JRM', '2025-06', 0.048227744061745084),)]} 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=4873 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=4873 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= 4873 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=4873 # 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=3459 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=3459 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= 3459 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=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 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,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} 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="arc_en_ciel_jrm"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4878 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=4878 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= 4878 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=4878 # 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=4302 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=4302 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= 4302 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=4302 # 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 ! 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 13596 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11881 final have less inputs used (1) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11881 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13625 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 11884 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 3 of step 11884 have datatype=6 WARNING : type of output 1 of step 13596 doesn't seem to be define in the database( WARNING : type of input 3 of step 11881 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 0 of step 13625 have datatype=18 WARNING : type of output 1 of step 13625 doesn't seem to be define in the database( WARNING : type of input 5 of step 11884 doesn't seem to be define in the database( 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': 2, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((107104,),), 'unwanted_material_monthly_percentage': ((0.048227744061745084,),), 'material_repartition': (('JRM', 104081),), 'material_dict': {'JRM': 104081}, 'coverage_data': (('2025/06/30/', 0.976564), ('2025/06/28/', 1.0), ('2025/06/27/', 0.977187), ('2025/06/26/', 0.979687), ('2025/06/25/', 0.977997), ('2025/06/20/', 0.97728), ('2025/06/19/', 0.974571), ('2025/06/18/', 0.979409), ('2025/06/17/', 0.977859), ('2025/06/16/', 0.976929), ('2025/06/14/', 0.978499), ('2025/06/13/', 0.978507), ('2025/06/12/', 0.978136), ('2025/06/11/', 0.978067), ('2025/06/10/', 0.977951), ('2025/06/09/', 0.979093), ('2025/06/07/', 0.981221), ('2025/06/06/', 0.976805), ('2025/06/05/', 0.976342), ('2025/06/04/', 0.977604), ('2025/06/03/', 0.976238), ('2025/06/02/', 0.973772)), 'impurety_average_data': ((datetime.date(2025, 6, 2), 0.0526615580826415, 3296), (datetime.date(2025, 6, 3), 0.050013810634511664, 3277), (datetime.date(2025, 6, 4), 0.04957748984951549, 4466), (datetime.date(2025, 6, 5), 0.04537575304947456, 4035), (datetime.date(2025, 6, 6), 0.05387365721942639, 3449), (datetime.date(2025, 6, 7), 0.05025021848843321, 701), (datetime.date(2025, 6, 9), 0.04415613218613245, 4640), (datetime.date(2025, 6, 10), 0.06865446779267274, 2421), (datetime.date(2025, 6, 11), 0.048205257284777904, 7783), (datetime.date(2025, 6, 12), 0.04780409585632248, 8325), (datetime.date(2025, 6, 13), 0.04491212410727034, 8133), (datetime.date(2025, 6, 14), 0.05532346808444853, 1096), (datetime.date(2025, 6, 16), 0.04364578714385726, 9127), (datetime.date(2025, 6, 17), 0.0513501829166999, 6926), (datetime.date(2025, 6, 18), 0.043236889660619185, 7275), (datetime.date(2025, 6, 19), 0.04174308223091769, 7703), (datetime.date(2025, 6, 20), 0.052348148232956804, 7720), (datetime.date(2025, 6, 21), 0.06001972168658217, 6), (datetime.date(2025, 6, 24), 0.04728888861687083, 2724), (datetime.date(2025, 6, 25), 0.043653715609153584, 3831), (datetime.date(2025, 6, 26), 0.04503088280700554, 2603), (datetime.date(2025, 6, 27), 0.04497005548190578, 4514), (datetime.date(2025, 6, 28), 0.04859325772029209, 30), (datetime.date(2025, 6, 30), 0.04794968546230305, 2965)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 6, 2), 0.0526615580826415, 3296), (datetime.date(2025, 6, 3), 0.050013810634511664, 3277), (datetime.date(2025, 6, 4), 0.04957748984951549, 4466), (datetime.date(2025, 6, 5), 0.04537575304947456, 4035), (datetime.date(2025, 6, 6), 0.05387365721942639, 3449), (datetime.date(2025, 6, 7), 0.05025021848843321, 701), (datetime.date(2025, 6, 9), 0.04415613218613245, 4640), (datetime.date(2025, 6, 10), 0.06865446779267274, 2421), (datetime.date(2025, 6, 11), 0.048205257284777904, 7783), (datetime.date(2025, 6, 12), 0.04780409585632248, 8325), (datetime.date(2025, 6, 13), 0.04491212410727034, 8133), (datetime.date(2025, 6, 14), 0.05532346808444853, 1096), (datetime.date(2025, 6, 16), 0.04364578714385726, 9127), (datetime.date(2025, 6, 17), 0.0513501829166999, 6926), (datetime.date(2025, 6, 18), 0.043236889660619185, 7275), (datetime.date(2025, 6, 19), 0.04174308223091769, 7703), (datetime.date(2025, 6, 20), 0.052348148232956804, 7720), (datetime.date(2025, 6, 21), 0.06001972168658217, 6), (datetime.date(2025, 6, 24), 0.04728888861687083, 2724), (datetime.date(2025, 6, 25), 0.043653715609153584, 3831), (datetime.date(2025, 6, 26), 0.04503088280700554, 2603), (datetime.date(2025, 6, 27), 0.04497005548190578, 4514), (datetime.date(2025, 6, 28), 0.04859325772029209, 30), (datetime.date(2025, 6, 30), 0.04794968546230305, 2965))}, 'quality_array': [['-4.663749571866619', '02062025'], ['-4.564772357512287', '03062025'], ['-4.699017727118491', '04062025'], ['-4.687846857004656', '05062025'], ['-4.739459348574449', '06062025'], ['-4.792453764778051', '07062025'], ['-4.396159490725603', '09062025'], ['-4.4034191690293305', '10062025'], ['-4.711265271966628', '11062025'], ['-4.851291452234305', '12062025'], ['-4.634276242135348', '13062025'], ['-4.622308700070088', '14062025'], ['-4.731516190100221', '16062025'], ['-4.528634987813945', '17062025'], ['-4.4777010858905975', '18062025'], ['-4.499213694267429', '19062025'], ['-3.933636874246675', '20062025'], ['-5.710016074636889', '21062025'], ['-4.359845690115955', '24062025'], ['-4.372611970429952', '25062025'], ['-4.26957401612936', '26062025'], ['-4.32213955709934', '27062025'], ['-4.398229977065266', '28062025'], ['-4.035407513457558', '30062025']], 'number_of_batch': ((1332,),), 'datou_id_sts': 4878, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.005057384244367119, 'nb_photo': 7574, 'list_port_cont': '23525957,23526059,23526320,23526654,23526983,23527386,23527731,23528156,23528662,23529332,23529843,23530405,23531062,23531777,23532403,23533112,23534680,23535512,23536750,23537415,23537953,23538667,23539334,23539907,23540490,23543932,23544374,23545067,23545692,23546440,23547128,23548171,23549073,23549929,23551036,23552534,23553081,23553521,23554335,23556168,23556889,23557593,23558238,23558804,23559562,23560062,23560768,23561883,23562721,23563423,23566310,23572448,23572779,23574524,23574629,23575375,23575477,23575965,23576271,23576797,23577292,23577857,23578105,23578486,23578860,23579422,23579444,23579767,23579796,23580139,23580385,23585055,23585393,23586024,23586542,23587166,23587862,23588764,23589289,23589978,23590534,23591151,23591667,23592198,23592559,23593338,23594712,23595086,23595432,23595967,23596575,23597875,23599288,23599572,23599833,23600690,23600702,23601144,23601535,23602025,23603583,23604210,23604628,23605388,23605538,23606048,23606348,23606629,23606996,23607405,23608303,23608586,23609046,2360950', 'assoc_port': '23525945:23525957,23526028:23526059,23526302:23526320,23526633:23526654,23526971:23526983,23527369:23527386,23527715:23527731,23528131:23528156,23528644:23528662,23529291:23529332,23529835:23529843,23530360:23530405,23531033:23531062,23531742:23531777,23532378:23532403,23533080:23533112,23534658:23534680,23535481:23535512,23536707:23536750,23537388:23537415,23537919:23537953,23538641:23538667,23539303:23539334,23539854:23539907,23540468:23540490,23543904:23543932,23544321:23544374,23545016:23545067,23545644:23545692,23546414:23546440,23547059:23547128,23548101:23548171,23548984:23549073,23549856:23549929,23550939:23551036,23552513:23552534,23553062:23553081,23553438:23553521,23554249:23554335,23556138:23556168,23556841:23556889,23557546:23557593,23558209:23558238,23558702:23558804,23559495:23559562,23559991:23560062,23560642:23560768,23561867:23561883,23562708:23562721,23563332:23563423,23566297:23566310,23572408:23572448,23572766:23572779,23574516:23574524,23574624:23574629,23575369:23575375,23575456:2357547', 'assoc_mat': '23525945:autre_refus:3726:23525957,23526028:autre_refus:3726:23526059,23526302:autre_refus:3726:23526320,23526633:autre_refus:3726:23526654,23526971:autre_refus:3726:23526983,23527369:autre_refus:3726:23527386,23527715:autre_refus:3726:23527731,23528131:autre_refus:3726:23528156,23528644:autre_refus:3726:23528662,23529291:autre_refus:3726:23529332,23529835:autre_refus:3726:23529843,23530360:autre_refus:3726:23530405,23531033:autre_refus:3726:23531062,23531742:autre_refus:3726:23531777,23532378:autre_refus:3726:23532403,23533080:autre_refus:3726:23533112,23534658:autre_refus:3726:23534680,23535481:autre_refus:3726:23535512,23536707:autre_refus:3726:23536750,23537388:autre_refus:3726:23537415,23537919:autre_refus:3726:23537953,23538641:autre_refus:3726:23538667,23539303:autre_refus:3726:23539334,23539854:autre_refus:3726:23539907,23540468:autre_refus:3726:23540490,23543904:autre_refus:3726:23543932,23544321:autre_refus:3726:23544374,23545016:autre_refus:3726:23545067,23545644:autre_refus:3726:23545692,23546414:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0052668074216894525, 'nb_photo': 10640, 'list_port_cont': '23525948,23526060,23526317,23526986,23527387,23527737,23528164,23528664,23529343,23529839,23530409,23531070,23531766,23532399,23533106,23534684,23535111,23535506,23536114,23536749,23537421,23537946,23538677,23539335,23539900,23540488,23543783,23543933,23544378,23545065,23545696,23546446,23547121,23548169,23549077,23549924,23551040,23552538,23553091,23553513,23554329,23556178,23556887,23557581,23558243,23558802,23559565,23560060,23560767,23561879,23562723,23563418,23565503,23566306,23574627,23575380,23575488,23575975,23576272,23576551,23576640,23576799,23577290,23577862,23578110,23578861,23579418,23579432,23579757,23579798,23580145,23580386,23585058,23585395,23586023,23586550,23587172,23587861,23588760,23589292,23589972,23590531,23591155,23591668,23592206,23592556,23593336,23594705,23595095,23595436,23595974,23596576,23597871,23598758,23599290,23599566,23599838,23600687,23600705,23600826,23601141,23601528,23602014,23602774,23603584,23604211,23604621,23605383,23605542,23606051,23606354,23606628,23606992,2360740', 'assoc_port': '23525945:23525948,23526028:23526060,23526302:23526317,23526971:23526986,23527369:23527387,23527715:23527737,23528131:23528164,23528644:23528664,23529291:23529343,23529835:23529839,23530360:23530409,23531033:23531070,23531742:23531766,23532378:23532399,23533080:23533106,23534658:23534684,23535076:23535111,23535481:23535506,23536090:23536114,23536707:23536749,23537388:23537421,23537919:23537946,23538641:23538677,23539303:23539335,23539854:23539900,23540468:23540488,23543774:23543783,23543904:23543933,23544321:23544378,23545016:23545065,23545644:23545696,23546414:23546446,23547059:23547121,23548101:23548169,23548984:23549077,23549856:23549924,23550939:23551040,23552513:23552538,23553062:23553091,23553438:23553513,23554249:23554329,23556138:23556178,23556841:23556887,23557546:23557581,23558209:23558243,23558702:23558802,23559495:23559565,23559991:23560060,23560642:23560767,23561867:23561879,23562708:23562723,23563332:23563418,23565391:23565503,23566297:23566306,23574624:23574627,23575369:23575380,23575456:2357548', 'assoc_mat': '23525945:cartonnette:3726:23525948,23526028:cartonnette:3726:23526060,23526302:cartonnette:3726:23526317,23526971:cartonnette:3726:23526986,23527369:cartonnette:3726:23527387,23527715:cartonnette:3726:23527737,23528131:cartonnette:3726:23528164,23528644:cartonnette:3726:23528664,23529291:cartonnette:3726:23529343,23529835:cartonnette:3726:23529839,23530360:cartonnette:3726:23530409,23531033:cartonnette:3726:23531070,23531742:cartonnette:3726:23531766,23532378:cartonnette:3726:23532399,23533080:cartonnette:3726:23533106,23534658:cartonnette:3726:23534684,23535076:cartonnette:3726:23535111,23535481:cartonnette:3726:23535506,23536090:cartonnette:3726:23536114,23536707:cartonnette:3726:23536749,23537388:cartonnette:3726:23537421,23537919:cartonnette:3726:23537946,23538641:cartonnette:3726:23538677,23539303:cartonnette:3726:23539335,23539854:cartonnette:3726:23539900,23540468:cartonnette:3726:23540488,23543774:cartonnette:3726:23543783,23543904:cartonnette:3726:23543933,23544321:cartonnette:3726:23544378,23545016:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.019596479351846663, 'nb_photo': 10828, 'list_port_cont': '23525952,23526064,23526321,23526987,23527389,23527732,23528165,23528657,23529335,23529846,23530402,23531059,23531770,23532405,23533114,23534402,23534679,23535107,23535509,23536115,23536744,23537957,23538673,23539332,23539903,23540495,23543785,23543937,23544370,23545062,23545694,23546442,23547122,23548175,23549069,23549925,23551033,23552539,23553082,23553522,23554331,23556170,23556892,23557587,23558240,23558803,23559560,23560057,23560764,23561884,23562724,23563417,23566313,23572771,23573239,23574631,23575478,23575970,23576275,23576554,23576646,23576798,23577293,23577859,23578106,23578493,23578859,23579429,23579433,23579763,23579797,23580141,23580379,23585051,23585398,23586027,23586549,23587173,23587853,23589288,23589974,23590538,23591149,23591673,23592204,23592562,23593333,23594706,23595084,23595426,23595965,23596579,23597879,23598755,23599564,23599834,23600688,23600704,23600827,23601147,23601533,23602024,23602776,23603586,23604215,23604622,23605391,23605546,23606055,23606345,23606630,23606987,23607401,2360830', 'assoc_port': '23525945:23525952,23526028:23526064,23526302:23526321,23526971:23526987,23527369:23527389,23527715:23527732,23528131:23528165,23528644:23528657,23529291:23529335,23529835:23529846,23530360:23530402,23531033:23531059,23531742:23531770,23532378:23532405,23533080:23533114,23534397:23534402,23534658:23534679,23535076:23535107,23535481:23535509,23536090:23536115,23536707:23536744,23537919:23537957,23538641:23538673,23539303:23539332,23539854:23539903,23540468:23540495,23543774:23543785,23543904:23543937,23544321:23544370,23545016:23545062,23545644:23545694,23546414:23546442,23547059:23547122,23548101:23548175,23548984:23549069,23549856:23549925,23550939:23551033,23552513:23552539,23553062:23553082,23553438:23553522,23554249:23554331,23556138:23556170,23556841:23556892,23557546:23557587,23558209:23558240,23558702:23558803,23559495:23559560,23559991:23560057,23560642:23560764,23561867:23561884,23562708:23562724,23563332:23563417,23566297:23566313,23572766:23572771,23573213:23573239,23574624:23574631,23575456:2357547', 'assoc_mat': '23525945:Carton_brun:3726:23525952,23526028:Carton_brun:3726:23526064,23526302:Carton_brun:3726:23526321,23526971:Carton_brun:3726:23526987,23527369:Carton_brun:3726:23527389,23527715:Carton_brun:3726:23527732,23528131:Carton_brun:3726:23528165,23528644:Carton_brun:3726:23528657,23529291:Carton_brun:3726:23529335,23529835:Carton_brun:3726:23529846,23530360:Carton_brun:3726:23530402,23531033:Carton_brun:3726:23531059,23531742:Carton_brun:3726:23531770,23532378:Carton_brun:3726:23532405,23533080:Carton_brun:3726:23533114,23534397:Carton_brun:3726:23534402,23534658:Carton_brun:3726:23534679,23535076:Carton_brun:3726:23535107,23535481:Carton_brun:3726:23535509,23536090:Carton_brun:3726:23536115,23536707:Carton_brun:3726:23536744,23537919:Carton_brun:3726:23537957,23538641:Carton_brun:3726:23538673,23539303:Carton_brun:3726:23539332,23539854:Carton_brun:3726:23539903,23540468:Carton_brun:3726:23540495,23543774:Carton_brun:3726:23543785,23543904:Carton_brun:3726:23543937,23544321:Carton_brun:3726:23544370,23545016:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00737334714126409, 'nb_photo': 11211, 'list_port_cont': '23525946,23526065,23526316,23526647,23526982,23527392,23527733,23528157,23528663,23529338,23529844,23530412,23531069,23531776,23532407,23533103,23534408,23534687,23535101,23535510,23536748,23537411,23537955,23538674,23539341,23539897,23540487,23543779,23543927,23544367,23545066,23545685,23546438,23547126,23548174,23549070,23549930,23551031,23552528,23553086,23553514,23554339,23556171,23556897,23557589,23558244,23558798,23559561,23560056,23560757,23561878,23562726,23563428,23565505,23574630,23575972,23576276,23576546,23576648,23576796,23577288,23577866,23578103,23578492,23578852,23579428,23579435,23579765,23579788,23580142,23580376,23585054,23585389,23586031,23586543,23587165,23587856,23588761,23589284,23589973,23590528,23591154,23591662,23592199,23592553,23593339,23594703,23595090,23595433,23595970,23596573,23597874,23598749,23599296,23599567,23599841,23600695,23600699,23600829,23601143,23601539,23602021,23602781,23603585,23604209,23604630,23605381,23605541,23606056,23606349,23606625,23606986,23607399,2360830', 'assoc_port': '23525945:23525946,23526028:23526065,23526302:23526316,23526633:23526647,23526971:23526982,23527369:23527392,23527715:23527733,23528131:23528157,23528644:23528663,23529291:23529338,23529835:23529844,23530360:23530412,23531033:23531069,23531742:23531776,23532378:23532407,23533080:23533103,23534397:23534408,23534658:23534687,23535076:23535101,23535481:23535510,23536707:23536748,23537388:23537411,23537919:23537955,23538641:23538674,23539303:23539341,23539854:23539897,23540468:23540487,23543774:23543779,23543904:23543927,23544321:23544367,23545016:23545066,23545644:23545685,23546414:23546438,23547059:23547126,23548101:23548174,23548984:23549070,23549856:23549930,23550939:23551031,23552513:23552528,23553062:23553086,23553438:23553514,23554249:23554339,23556138:23556171,23556841:23556897,23557546:23557589,23558209:23558244,23558702:23558798,23559495:23559561,23559991:23560056,23560642:23560757,23561867:23561878,23562708:23562726,23563332:23563428,23565391:23565505,23574624:23574630,23575958:23575972,23576262:2357627', 'assoc_mat': '23525945:Carton_gris:3726:23525946,23526028:Carton_gris:3726:23526065,23526302:Carton_gris:3726:23526316,23526633:Carton_gris:3726:23526647,23526971:Carton_gris:3726:23526982,23527369:Carton_gris:3726:23527392,23527715:Carton_gris:3726:23527733,23528131:Carton_gris:3726:23528157,23528644:Carton_gris:3726:23528663,23529291:Carton_gris:3726:23529338,23529835:Carton_gris:3726:23529844,23530360:Carton_gris:3726:23530412,23531033:Carton_gris:3726:23531069,23531742:Carton_gris:3726:23531776,23532378:Carton_gris:3726:23532407,23533080:Carton_gris:3726:23533103,23534397:Carton_gris:3726:23534408,23534658:Carton_gris:3726:23534687,23535076:Carton_gris:3726:23535101,23535481:Carton_gris:3726:23535510,23536707:Carton_gris:3726:23536748,23537388:Carton_gris:3726:23537411,23537919:Carton_gris:3726:23537955,23538641:Carton_gris:3726:23538674,23539303:Carton_gris:3726:23539341,23539854:Carton_gris:3726:23539897,23540468:Carton_gris:3726:23540487,23543774:Carton_gris:3726:23543779,23543904:Carton_gris:3726:23543927,23544321:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0028598532418010573, 'nb_photo': 2069, 'list_port_cont': '23526069,23526314,23526991,23527385,23527730,23528158,23528654,23529836,23530415,23531068,23531773,23532406,23533110,23534405,23534685,23535102,23535515,23537417,23538676,23539333,23540493,23544369,23545693,23546435,23548168,23549074,23549923,23551032,23552531,23553520,23554330,23556898,23557586,23558797,23560054,23561874,23562720,23563420,23566314,23575378,23576265,23576644,23578856,23579439,23579789,23580138,23580378,23585394,23586032,23586553,23587169,23587852,23588759,23589293,23589979,23590527,23591156,23592200,23592560,23593335,23594711,23595431,23599562,23600692,23600825,23601145,23601536,23602775,23603580,23604208,23604629,23605392,23605544,23606053,23606347,23606985,23607407,23608308,23611048,23611384,23611889,23612962,23613329,23614041,23614470,23616421,23617078,23617686,23618174,23618873,23620944,23621686,23623425,23624299,23626008,23628455,23632195,23632436,23633760,23634609,23635523,23636020,23636485,23637252,23637331,23637404,23637558,23637675,23638188,23638629,23639372,23639788,23642061,2364249', 'assoc_port': '23526028:23526069,23526302:23526314,23526971:23526991,23527369:23527385,23527715:23527730,23528131:23528158,23528644:23528654,23529835:23529836,23530360:23530415,23531033:23531068,23531742:23531773,23532378:23532406,23533080:23533110,23534397:23534405,23534658:23534685,23535076:23535102,23535481:23535515,23537388:23537417,23538641:23538676,23539303:23539333,23540468:23540493,23544321:23544369,23545644:23545693,23546414:23546435,23548101:23548168,23548984:23549074,23549856:23549923,23550939:23551032,23552513:23552531,23553438:23553520,23554249:23554330,23556841:23556898,23557546:23557586,23558702:23558797,23559991:23560054,23561867:23561874,23562708:23562720,23563332:23563420,23566297:23566314,23575369:23575378,23576262:23576265,23576637:23576644,23578849:23578856,23579417:23579439,23579783:23579789,23580131:23580138,23580373:23580378,23585380:23585394,23585918:23586032,23586541:23586553,23587094:23587169,23587797:23587852,23588678:23588759,23589274:23589293,23589945:23589979,23590466:23590527,23591128:2359115', 'assoc_mat': '23526028:kraft:3726:23526069,23526302:kraft:3726:23526314,23526971:kraft:3726:23526991,23527369:kraft:3726:23527385,23527715:kraft:3726:23527730,23528131:kraft:3726:23528158,23528644:kraft:3726:23528654,23529835:kraft:3726:23529836,23530360:kraft:3726:23530415,23531033:kraft:3726:23531068,23531742:kraft:3726:23531773,23532378:kraft:3726:23532406,23533080:kraft:3726:23533110,23534397:kraft:3726:23534405,23534658:kraft:3726:23534685,23535076:kraft:3726:23535102,23535481:kraft:3726:23535515,23537388:kraft:3726:23537417,23538641:kraft:3726:23538676,23539303:kraft:3726:23539333,23540468:kraft:3726:23540493,23544321:kraft:3726:23544369,23545644:kraft:3726:23545693,23546414:kraft:3726:23546435,23548101:kraft:3726:23548168,23548984:kraft:3726:23549074,23549856:kraft:3726:23549923,23550939:kraft:3726:23551032,23552513:kraft:3726:23552531,23553438:kraft:3726:23553520,23554249:kraft:3726:23554330,23556841:kraft:3726:23556898,23557546:kraft:3726:23557586,23558702:kraft:3726:23558797,23559991:kraft:3726:23560054,23561867:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0029518350882386706, 'nb_photo': 585, 'list_port_cont': '23526068,23526992,23528167,23529845,23533104,23534677,23535103,23545695,23548178,23549928,23552532,23554337,23556896,23557582,23560059,23573233,23576801,23577865,23578109,23578854,23579760,23579790,23580384,23587857,23588768,23591152,23592201,23594707,23595091,23597880,23600686,23601146,23604216,23605385,23606993,23607398,23608302,23609506,23610464,23613578,23614051,23616422,23617270,23617683,23618178,23618871,23621681,23622326,23624310,23626937,23627636,23632196,23632913,23635047,23636016,23637332,23637396,23642492,23645831,23646870,23647410,23648221,23650030,23650307,23652730,23653825,23655060,23655472,23662228,23663326,23670550,23672546,23674206,23675524,23679814,23685203,23685496,23696178,23696501,23696943,23697675,23699816,23700586,23700861,23709966,23712568,23712625,23712748,23712891,23713081,23715702,23721178,23724328,23726856,23733924,23734848,23735439,23778204,23782139,23782792,23784677,23785328,23788046,23791466,23795391,23814842,23820077,23823209,23823859,23827999,23829822,23830871,23832903,2383517', 'assoc_port': '23526028:23526068,23526971:23526992,23528131:23528167,23529835:23529845,23533080:23533104,23534658:23534677,23535076:23535103,23545644:23545695,23548101:23548178,23549856:23549928,23552513:23552532,23554249:23554337,23556841:23556896,23557546:23557582,23559991:23560059,23573213:23573233,23576792:23576801,23577854:23577865,23578098:23578109,23578849:23578854,23579501:23579760,23579783:23579790,23580373:23580384,23587797:23587857,23588678:23588768,23591128:23591152,23592170:23592201,23594697:23594707,23595072:23595091,23597869:23597880,23600684:23600686,23601136:23601146,23604206:23604216,23605380:23605385,23606984:23606993,23607397:23607398,23608281:23608302,23609497:23609506,23610458:23610464,23613576:23613578,23614039:23614051,23616413:23616422,23617264:23617270,23617670:23617683,23618131:23618178,23618827:23618871,23621657:23621681,23622302:23622326,23624195:23624310,23626910:23626937,23627631:23627636,23632149:23632196,23632901:23632913,23634973:23635047,23636007:23636016,23637316:23637332,23637385:2363739', 'assoc_mat': '23526028:metal:3726:23526068,23526971:metal:3726:23526992,23528131:metal:3726:23528167,23529835:metal:3726:23529845,23533080:metal:3726:23533104,23534658:metal:3726:23534677,23535076:metal:3726:23535103,23545644:metal:3726:23545695,23548101:metal:3726:23548178,23549856:metal:3726:23549928,23552513:metal:3726:23552532,23554249:metal:3726:23554337,23556841:metal:3726:23556896,23557546:metal:3726:23557582,23559991:metal:3726:23560059,23573213:metal:3726:23573233,23576792:metal:3726:23576801,23577854:metal:3726:23577865,23578098:metal:3726:23578109,23578849:metal:3726:23578854,23579501:metal:3726:23579760,23579783:metal:3726:23579790,23580373:metal:3726:23580384,23587797:metal:3726:23587857,23588678:metal:3726:23588768,23591128:metal:3726:23591152,23592170:metal:3726:23592201,23594697:metal:3726:23594707,23595072:metal:3726:23595091,23597869:metal:3726:23597880,23600684:metal:3726:23600686,23601136:metal:3726:23601146,23604206:metal:3726:23604216,23605380:metal:3726:23605385,23606984:metal:3726:23606993,23607397:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004957327679325341, 'nb_photo': 8426, 'list_port_cont': '23525947,23526062,23526319,23526985,23527382,23527738,23528161,23528656,23529342,23529847,23530416,23531065,23531774,23532402,23533107,23534682,23535507,23536111,23536747,23537414,23537956,23538675,23539337,23539901,23540489,23543782,23543930,23544377,23545070,23545690,23546434,23547119,23548177,23549068,23549934,23551034,23552530,23553088,23553519,23554334,23556175,23556895,23557588,23558236,23558799,23559566,23560050,23560758,23561880,23562727,23563425,23565506,23572447,23572778,23573230,23575377,23575479,23575974,23576267,23576547,23576643,23576803,23577298,23577860,23578101,23578489,23578855,23579425,23579441,23579768,23579793,23580148,23580381,23585396,23586021,23586546,23587176,23587855,23588765,23589287,23589970,23591153,23591663,23592195,23592561,23593340,23594709,23595089,23595425,23595969,23596581,23598757,23599293,23599569,23599837,23600696,23600708,23601137,23601529,23602022,23602780,23603582,23604212,23604620,23605382,23605539,23606046,23606355,23606632,23606989,23607406,23608299,23608583,2360904', 'assoc_port': '23525945:23525947,23526028:23526062,23526302:23526319,23526971:23526985,23527369:23527382,23527715:23527738,23528131:23528161,23528644:23528656,23529291:23529342,23529835:23529847,23530360:23530416,23531033:23531065,23531742:23531774,23532378:23532402,23533080:23533107,23534658:23534682,23535481:23535507,23536090:23536111,23536707:23536747,23537388:23537414,23537919:23537956,23538641:23538675,23539303:23539337,23539854:23539901,23540468:23540489,23543774:23543782,23543904:23543930,23544321:23544377,23545016:23545070,23545644:23545690,23546414:23546434,23547059:23547119,23548101:23548177,23548984:23549068,23549856:23549934,23550939:23551034,23552513:23552530,23553062:23553088,23553438:23553519,23554249:23554334,23556138:23556175,23556841:23556895,23557546:23557588,23558209:23558236,23558702:23558799,23559495:23559566,23559991:23560050,23560642:23560758,23561867:23561880,23562708:23562727,23563332:23563425,23565391:23565506,23572408:23572447,23572766:23572778,23573213:23573230,23575369:23575377,23575456:2357547', 'assoc_mat': '23525945:plastique:3726:23525947,23526028:plastique:3726:23526062,23526302:plastique:3726:23526319,23526971:plastique:3726:23526985,23527369:plastique:3726:23527382,23527715:plastique:3726:23527738,23528131:plastique:3726:23528161,23528644:plastique:3726:23528656,23529291:plastique:3726:23529342,23529835:plastique:3726:23529847,23530360:plastique:3726:23530416,23531033:plastique:3726:23531065,23531742:plastique:3726:23531774,23532378:plastique:3726:23532402,23533080:plastique:3726:23533107,23534658:plastique:3726:23534682,23535481:plastique:3726:23535507,23536090:plastique:3726:23536111,23536707:plastique:3726:23536747,23537388:plastique:3726:23537414,23537919:plastique:3726:23537956,23538641:plastique:3726:23538675,23539303:plastique:3726:23539337,23539854:plastique:3726:23539901,23540468:plastique:3726:23540489,23543774:plastique:3726:23543782,23543904:plastique:3726:23543930,23544321:plastique:3726:23544377,23545016:plastique:3726:23545070,23545644:plastique:3726:23545690,23546414:plastique:3726:23546434,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.012964994538394019, 'nb_photo': 20893, 'list_port_cont': '23525954,23526067,23526322,23526656,23526989,23527383,23527739,23528160,23528655,23529341,23529838,23530404,23531067,23531769,23532404,23533113,23534412,23534678,23535112,23535513,23536112,23536746,23537419,23537950,23538669,23539339,23539904,23540497,23543777,23543935,23544376,23545069,23545691,23546437,23547123,23548176,23549067,23549927,23551041,23552537,23553087,23553512,23554328,23556172,23556890,23557585,23558234,23558801,23559556,23560053,23560762,23561882,23562722,23563429,23565504,23566309,23572446,23573237,23574411,23574527,23574636,23575484,23575966,23576270,23576552,23576638,23576793,23577294,23577861,23578107,23578487,23578862,23579419,23579431,23579759,23579795,23580149,23580377,23585061,23585390,23586022,23586545,23587170,23587860,23588769,23589285,23589975,23590529,23591150,23591670,23592205,23592554,23593341,23594704,23595094,23595427,23595971,23596578,23597872,23598748,23599294,23599568,23599830,23600691,23600706,23600824,23601138,23601538,23602019,23602773,23603579,23604219,23604623,2360538', 'assoc_port': '23525945:23525954,23526028:23526067,23526302:23526322,23526633:23526656,23526971:23526989,23527369:23527383,23527715:23527739,23528131:23528160,23528644:23528655,23529291:23529341,23529835:23529838,23530360:23530404,23531033:23531067,23531742:23531769,23532378:23532404,23533080:23533113,23534397:23534412,23534658:23534678,23535076:23535112,23535481:23535513,23536090:23536112,23536707:23536746,23537388:23537419,23537919:23537950,23538641:23538669,23539303:23539339,23539854:23539904,23540468:23540497,23543774:23543777,23543904:23543935,23544321:23544376,23545016:23545069,23545644:23545691,23546414:23546437,23547059:23547123,23548101:23548176,23548984:23549067,23549856:23549927,23550939:23551041,23552513:23552537,23553062:23553087,23553438:23553512,23554249:23554328,23556138:23556172,23556841:23556890,23557546:23557585,23558209:23558234,23558702:23558801,23559495:23559556,23559991:23560053,23560642:23560762,23561867:23561882,23562708:23562722,23563332:23563429,23565391:23565504,23566297:23566309,23572408:2357244', 'assoc_mat': '23525945:Teint_Dans_La_Masse:3726:23525954,23526028:Teint_Dans_La_Masse:3726:23526067,23526302:Teint_Dans_La_Masse:3726:23526322,23526633:Teint_Dans_La_Masse:3726:23526656,23526971:Teint_Dans_La_Masse:3726:23526989,23527369:Teint_Dans_La_Masse:3726:23527383,23527715:Teint_Dans_La_Masse:3726:23527739,23528131:Teint_Dans_La_Masse:3726:23528160,23528644:Teint_Dans_La_Masse:3726:23528655,23529291:Teint_Dans_La_Masse:3726:23529341,23529835:Teint_Dans_La_Masse:3726:23529838,23530360:Teint_Dans_La_Masse:3726:23530404,23531033:Teint_Dans_La_Masse:3726:23531067,23531742:Teint_Dans_La_Masse:3726:23531769,23532378:Teint_Dans_La_Masse:3726:23532404,23533080:Teint_Dans_La_Masse:3726:23533113,23534397:Teint_Dans_La_Masse:3726:23534412,23534658:Teint_Dans_La_Masse:3726:23534678,23535076:Teint_Dans_La_Masse:3726:23535112,23535481:Teint_Dans_La_Masse:3726:23535513,23536090:Teint_Dans_La_Masse:3726:23536112,23536707:Teint_Dans_La_Masse:3726:23536746,23537388:Teint_Dans_La_Masse:3726:23537419,23537919:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 107104}}, 'hostname': (('jetson-73',),), 'impurety_average_per_hashtag': [(('JRM', '2025-06', 0.048227744061745084),)]} filepath : /data_4/data_log/job/memo/arc_en_ciel_jrm/sla_mensuel_arc_en_ciel_jrm_mois_06_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'JRM': {'autre_refus': ['autre_refus', '0.51%', 7574], 'cartonnette': ['cartonnette', '0.53%', 10640], 'Carton_brun': ['Carton_brun', '1.96%', 10828], 'Carton_gris': ['Carton_gris', '0.74%', 11211], 'kraft': ['kraft', '0.29%', 2069], 'metal': ['metal', '0.3%', 585], 'plastique': ['plastique', '0.5%', 8426], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '1.3%', 20893]}} before organize_and_plot_coverage_data before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/arc_en_ciel_jrm/sla_mensuel_arc_en_ciel_jrm_mois_06_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/arc_en_ciel_jrm 2.65user 2.80system 1:22.74elapsed 6%CPU (0avgtext+0avgdata 195688maxresident)k 4640inputs+536outputs (20major+67891minor)pagefaults 0swaps