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-10 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (2, 31) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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 : (2, 31) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! 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 : 10 mtr_id : 979 dashboard_places : arc_en_ciel_jrm date : 2025-10 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-10%') and created_at like '%2025-10%'))); nb_day : (2, 31) after unwanted_material_data nb_day : (2, 31) SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%30073%' AND ms.result_str like '%2025/10%'ORDER BY ms.id desc LIMIT 0, 1000000; No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84554 seconds', 'coverage_times_pause': '0 days 85930 seconds', 'nb_photos_decision': 8487, 'nb_gray_level_ok': 8487, 'nb_dedup_ok': 3712, 'nb_two_criteria_ok': 3712, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 4775, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 3791, 'ratio_coverage': 0.9786455861757659}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4406, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4406, 'last_update': '2025/11/03', 'portfolio_id': 27984121, 'last_run_id': 2507387, 'total_number_of_photos': 4449}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84554 seconds', 'coverage_times_pause': '0 days 85930 seconds', 'nb_photos_decision': 8487, 'nb_gray_level_ok': 8487, 'nb_dedup_ok': 3712, 'nb_two_criteria_ok': 3712, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 4775, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 3791, 'ratio_coverage': 0.9786455861757659}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4406, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4406, 'last_update': '2025/11/03', 'portfolio_id': 27984121, 'last_run_id': 2507387, 'total_number_of_photos': 4449}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84470 seconds', 'coverage_times_pause': '0 days 85616 seconds', 'nb_photos_decision': 8446, 'nb_gray_level_ok': 8446, 'nb_dedup_ok': 3909, 'nb_two_criteria_ok': 3909, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4537, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 3997, 'ratio_coverage': 0.9776733527008414}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4657, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4657, 'last_update': '2025/11/03', 'portfolio_id': 27928746, 'last_run_id': 2507307, 'total_number_of_photos': 4690}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84554 seconds', 'coverage_times_pause': '0 days 85930 seconds', 'nb_photos_decision': 8487, 'nb_gray_level_ok': 8487, 'nb_dedup_ok': 3712, 'nb_two_criteria_ok': 3712, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 4775, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 3791, 'ratio_coverage': 0.9786455861757659}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4406, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4406, 'last_update': '2025/11/03', 'portfolio_id': 27984121, 'last_run_id': 2507387, 'total_number_of_photos': 4449}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84470 seconds', 'coverage_times_pause': '0 days 85616 seconds', 'nb_photos_decision': 8446, 'nb_gray_level_ok': 8446, 'nb_dedup_ok': 3909, 'nb_two_criteria_ok': 3909, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4537, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 3997, 'ratio_coverage': 0.9776733527008414}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4657, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4657, 'last_update': '2025/11/03', 'portfolio_id': 27928746, 'last_run_id': 2507307, 'total_number_of_photos': 4690}} No error ? {'log_dict': {'total_nb_images': 8580, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84755 seconds', 'coverage_times_pause': '0 days 86041 seconds', 'nb_photos_decision': 8502, 'nb_gray_level_ok': 8502, 'nb_dedup_ok': 4150, 'nb_two_criteria_ok': 4150, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 4352, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 153, 'end_of_day_photos_uploaded': 4074, 'ratio_coverage': 0.9809720019907637}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 76, 'nb_images_started': 4742, 'nb_selected_images': 4742, 'last_update': '2025/11/05', 'portfolio_id': 27909733, 'last_run_id': 2507231, 'total_number_of_photos': 4774}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84554 seconds', 'coverage_times_pause': '0 days 85930 seconds', 'nb_photos_decision': 8487, 'nb_gray_level_ok': 8487, 'nb_dedup_ok': 3712, 'nb_two_criteria_ok': 3712, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 4775, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 3791, 'ratio_coverage': 0.9786455861757659}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4406, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4406, 'last_update': '2025/11/03', 'portfolio_id': 27984121, 'last_run_id': 2507387, 'total_number_of_photos': 4449}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84470 seconds', 'coverage_times_pause': '0 days 85616 seconds', 'nb_photos_decision': 8446, 'nb_gray_level_ok': 8446, 'nb_dedup_ok': 3909, 'nb_two_criteria_ok': 3909, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4537, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 3997, 'ratio_coverage': 0.9776733527008414}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4657, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4657, 'last_update': '2025/11/03', 'portfolio_id': 27928746, 'last_run_id': 2507307, 'total_number_of_photos': 4690}} No error ? {'log_dict': {'total_nb_images': 8580, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84755 seconds', 'coverage_times_pause': '0 days 86041 seconds', 'nb_photos_decision': 8502, 'nb_gray_level_ok': 8502, 'nb_dedup_ok': 4150, 'nb_two_criteria_ok': 4150, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 4352, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 153, 'end_of_day_photos_uploaded': 4074, 'ratio_coverage': 0.9809720019907637}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 76, 'nb_images_started': 4742, 'nb_selected_images': 4742, 'last_update': '2025/11/03', 'portfolio_id': 27909733, 'last_run_id': 2507231, 'total_number_of_photos': 4774}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84434 seconds', 'coverage_times_pause': '0 days 85693 seconds', 'nb_photos_decision': 8452, 'nb_gray_level_ok': 8452, 'nb_dedup_ok': 3525, 'nb_two_criteria_ok': 3525, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 4922, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3622, 'ratio_coverage': 0.9772566812115882}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 79, 'nb_images_started': 3754, 'nb_selected_images': 3754, 'last_update': '2025/11/03', 'portfolio_id': 28008639, 'last_run_id': 2507389, 'total_number_of_photos': 3785}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84554 seconds', 'coverage_times_pause': '0 days 85930 seconds', 'nb_photos_decision': 8487, 'nb_gray_level_ok': 8487, 'nb_dedup_ok': 3712, 'nb_two_criteria_ok': 3712, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 4775, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 3791, 'ratio_coverage': 0.9786455861757659}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4406, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4406, 'last_update': '2025/11/01', 'portfolio_id': 27984121, 'last_run_id': 2498653, 'total_number_of_photos': 4449}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84470 seconds', 'coverage_times_pause': '0 days 85616 seconds', 'nb_photos_decision': 8446, 'nb_gray_level_ok': 8446, 'nb_dedup_ok': 3909, 'nb_two_criteria_ok': 3909, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4537, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 3997, 'ratio_coverage': 0.9776733527008414}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4648, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4648, 'last_update': '2025/10/31', 'portfolio_id': 27928746, 'last_run_id': 2494689, 'total_number_of_photos': 4690}} No error ? {'log_dict': {'total_nb_images': 8580, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84755 seconds', 'coverage_times_pause': '0 days 86041 seconds', 'nb_photos_decision': 8502, 'nb_gray_level_ok': 8502, 'nb_dedup_ok': 4150, 'nb_two_criteria_ok': 4150, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 4352, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 153, 'end_of_day_photos_uploaded': 4074, 'ratio_coverage': 0.9809720019907637}, 'dashboard_dict': {'nb_ptf_finished': 25, 'nb_images_finished': 1668, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 49, 'nb_images_started': 2920, 'nb_selected_images': 4588, 'last_update': '2025/10/30', 'portfolio_id': 27909733, 'last_run_id': 2482243, 'total_number_of_photos': 4774}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84434 seconds', 'coverage_times_pause': '0 days 85693 seconds', 'nb_photos_decision': 8452, 'nb_gray_level_ok': 8452, 'nb_dedup_ok': 3525, 'nb_two_criteria_ok': 3525, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 4922, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3622, 'ratio_coverage': 0.9772566812115882}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 6790, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67073 seconds', 'coverage_times_pause': '0 days 68099 seconds', 'nb_photos_decision': 6723, 'nb_gray_level_ok': 6723, 'nb_dedup_ok': 3030, 'nb_two_criteria_ok': 3030, 'nb_forced_upload': 62, 'end_of_day_photos_duplicated': 3693, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 3091, 'ratio_coverage': 0.980613751663036}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84554 seconds', 'coverage_times_pause': '0 days 85930 seconds', 'nb_photos_decision': 8487, 'nb_gray_level_ok': 8487, 'nb_dedup_ok': 3712, 'nb_two_criteria_ok': 3712, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 4775, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 2, 'end_of_day_photos_uploaded': 3791, 'ratio_coverage': 0.9786455861757659}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4406, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4406, 'last_update': '2025/11/01', 'portfolio_id': 27984121, 'last_run_id': 2498653, 'total_number_of_photos': 4449}} No error ? {'log_dict': {'total_nb_images': 8538, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84470 seconds', 'coverage_times_pause': '0 days 85616 seconds', 'nb_photos_decision': 8446, 'nb_gray_level_ok': 8446, 'nb_dedup_ok': 3909, 'nb_two_criteria_ok': 3909, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 4537, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 3997, 'ratio_coverage': 0.9776733527008414}, 'dashboard_dict': {'nb_ptf_finished': 70, 'nb_images_finished': 4648, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4648, 'last_update': '2025/10/31', 'portfolio_id': 27928746, 'last_run_id': 2494689, 'total_number_of_photos': 4690}} No error ? {'log_dict': {'total_nb_images': 8580, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84755 seconds', 'coverage_times_pause': '0 days 86041 seconds', 'nb_photos_decision': 8502, 'nb_gray_level_ok': 8502, 'nb_dedup_ok': 4150, 'nb_two_criteria_ok': 4150, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 4352, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 153, 'end_of_day_photos_uploaded': 4074, 'ratio_coverage': 0.9809720019907637}, 'dashboard_dict': {'nb_ptf_finished': 25, 'nb_images_finished': 1668, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 49, 'nb_images_started': 2920, 'nb_selected_images': 4588, 'last_update': '2025/10/30', 'portfolio_id': 27909733, 'last_run_id': 2482243, 'total_number_of_photos': 4774}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84434 seconds', 'coverage_times_pause': '0 days 85693 seconds', 'nb_photos_decision': 8452, 'nb_gray_level_ok': 8452, 'nb_dedup_ok': 3525, 'nb_two_criteria_ok': 3525, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 4922, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3622, 'ratio_coverage': 0.9772566812115882}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 6790, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67073 seconds', 'coverage_times_pause': '0 days 68099 seconds', 'nb_photos_decision': 6723, 'nb_gray_level_ok': 6723, 'nb_dedup_ok': 3030, 'nb_two_criteria_ok': 3030, 'nb_forced_upload': 62, 'end_of_day_photos_duplicated': 3693, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 3091, 'ratio_coverage': 0.980613751663036}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8580, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84755 seconds', 'coverage_times_pause': '0 days 86041 seconds', 'nb_photos_decision': 8502, 'nb_gray_level_ok': 8502, 'nb_dedup_ok': 4150, 'nb_two_criteria_ok': 4150, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 4352, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 153, 'end_of_day_photos_uploaded': 4074, 'ratio_coverage': 0.9809720019907637}, 'dashboard_dict': {'nb_ptf_finished': 24, 'nb_images_finished': 1585, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 50, 'nb_images_started': 3003, 'nb_selected_images': 4588, 'last_update': '2025/10/30', 'portfolio_id': 27909733, 'last_run_id': 2481377, 'total_number_of_photos': 4620}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84434 seconds', 'coverage_times_pause': '0 days 85693 seconds', 'nb_photos_decision': 8452, 'nb_gray_level_ok': 8452, 'nb_dedup_ok': 3525, 'nb_two_criteria_ok': 3525, 'nb_forced_upload': 98, 'end_of_day_photos_duplicated': 4922, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3622, 'ratio_coverage': 0.9772566812115882}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 6790, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67073 seconds', 'coverage_times_pause': '0 days 68099 seconds', 'nb_photos_decision': 6723, 'nb_gray_level_ok': 6723, 'nb_dedup_ok': 3030, 'nb_two_criteria_ok': 3030, 'nb_forced_upload': 62, 'end_of_day_photos_duplicated': 3693, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 3091, 'ratio_coverage': 0.980613751663036}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2143, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21199 seconds', 'coverage_times_pause': '0 days 21489 seconds', 'nb_photos_decision': 2124, 'nb_gray_level_ok': 2124, 'nb_dedup_ok': 96, 'nb_two_criteria_ok': 96, 'nb_forced_upload': 24, 'end_of_day_photos_duplicated': 2023, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 119, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 8562, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84617 seconds', 'coverage_times_pause': '0 days 85860 seconds', 'nb_photos_decision': 8480, 'nb_gray_level_ok': 8480, 'nb_dedup_ok': 3615, 'nb_two_criteria_ok': 3615, 'nb_forced_upload': 82, 'end_of_day_photos_duplicated': 4865, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3696, 'ratio_coverage': 0.9793747612819593}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 8551, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84456 seconds', 'coverage_times_pause': '0 days 85750 seconds', 'nb_photos_decision': 8482, 'nb_gray_level_ok': 8482, 'nb_dedup_ok': 3650, 'nb_two_criteria_ok': 3650, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4829, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3721, 'ratio_coverage': 0.977511313788354}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 1789, 'max_time_between_images': '0 days 20 seconds', 'coverage_pause': '0 days 17655 seconds', 'coverage_times_pause': '0 days 17940 seconds', 'nb_photos_decision': 1772, 'nb_gray_level_ok': 1772, 'nb_dedup_ok': 151, 'nb_two_criteria_ok': 151, 'nb_forced_upload': 17, 'end_of_day_photos_duplicated': 1621, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 167, 'ratio_coverage': 0.9808878271015057}, 'dashboard_dict': {'nb_ptf_finished': 12, 'nb_images_finished': 169, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 169, 'last_update': '2025/10/19', 'portfolio_id': 27896765, 'last_run_id': 2477193, 'total_number_of_photos': 189}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84430 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8474, 'nb_gray_level_ok': 8474, 'nb_dedup_ok': 4462, 'nb_two_criteria_ok': 4462, 'nb_forced_upload': 88, 'end_of_day_photos_duplicated': 4010, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 4545, 'ratio_coverage': 0.9772103843794488}, 'dashboard_dict': {'nb_ptf_finished': 48, 'nb_images_finished': 3952, 'nb_ptf_finished_for_older': 1, 'nb_images_finished_for_older': 52, 'nb_ptf_started': 28, 'nb_images_started': 1826, 'nb_selected_images': 5830, 'last_update': '2025/10/18', 'portfolio_id': 27870361, 'last_run_id': 2475369, 'total_number_of_photos': 5907}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84637 seconds', 'coverage_times_pause': '0 days 85804 seconds', 'nb_photos_decision': 8475, 'nb_gray_level_ok': 8475, 'nb_dedup_ok': 5131, 'nb_two_criteria_ok': 5131, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 3344, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 583, 'end_of_day_photos_uploaded': 4629, 'ratio_coverage': 0.9796062454426556}, 'dashboard_dict': {'nb_ptf_finished': 35, 'nb_images_finished': 2586, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 46, 'nb_images_started': 3275, 'nb_selected_images': 5861, 'last_update': '2025/10/17', 'portfolio_id': 27849519, 'last_run_id': 2470193, 'total_number_of_photos': 5876}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84559 seconds', 'coverage_times_pause': '0 days 85799 seconds', 'nb_photos_decision': 8464, 'nb_gray_level_ok': 8464, 'nb_dedup_ok': 2075, 'nb_two_criteria_ok': 2075, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 6389, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 6, 'end_of_day_photos_uploaded': 2160, 'ratio_coverage': 0.97870345721594}, 'dashboard_dict': {'nb_ptf_finished': 41, 'nb_images_finished': 2435, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2435, 'last_update': '2025/10/16', 'portfolio_id': 27818041, 'last_run_id': 2467957, 'total_number_of_photos': 2487}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84364 seconds', 'coverage_times_pause': '0 days 85690 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 3630, 'nb_two_criteria_ok': 3630, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 4837, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 6, 'end_of_day_photos_uploaded': 3701, 'ratio_coverage': 0.976446486649151}, 'dashboard_dict': {'nb_ptf_finished': 64, 'nb_images_finished': 4215, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4215, 'last_update': '2025/10/15', 'portfolio_id': 27777890, 'last_run_id': 2459539, 'total_number_of_photos': 4283}} No error ? {'log_dict': {'total_nb_images': 6797, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 67144 seconds', 'coverage_times_pause': '0 days 68158 seconds', 'nb_photos_decision': 6721, 'nb_gray_level_ok': 6721, 'nb_dedup_ok': 1977, 'nb_two_criteria_ok': 1977, 'nb_forced_upload': 76, 'end_of_day_photos_duplicated': 4744, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 2052, 'ratio_coverage': 0.9816517785347739}, 'dashboard_dict': {'nb_ptf_finished': 36, 'nb_images_finished': 2169, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2169, 'last_update': '2025/10/14', 'portfolio_id': 27747722, 'last_run_id': 2451969, 'total_number_of_photos': 2246}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84430 seconds', 'coverage_times_pause': '0 days 85809 seconds', 'nb_photos_decision': 8474, 'nb_gray_level_ok': 8474, 'nb_dedup_ok': 4462, 'nb_two_criteria_ok': 4462, 'nb_forced_upload': 88, 'end_of_day_photos_duplicated': 4010, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 4545, 'ratio_coverage': 0.9772103843794488}, 'dashboard_dict': {'nb_ptf_finished': 47, 'nb_images_finished': 3944, 'nb_ptf_finished_for_older': 1, 'nb_images_finished_for_older': 52, 'nb_ptf_started': 29, 'nb_images_started': 1834, 'nb_selected_images': 5830, 'last_update': '2025/10/18', 'portfolio_id': 27870361, 'last_run_id': 2475120, 'total_number_of_photos': 5907}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84637 seconds', 'coverage_times_pause': '0 days 85804 seconds', 'nb_photos_decision': 8475, 'nb_gray_level_ok': 8475, 'nb_dedup_ok': 5131, 'nb_two_criteria_ok': 5131, 'nb_forced_upload': 87, 'end_of_day_photos_duplicated': 3344, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 583, 'end_of_day_photos_uploaded': 4629, 'ratio_coverage': 0.9796062454426556}, 'dashboard_dict': {'nb_ptf_finished': 35, 'nb_images_finished': 2586, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 46, 'nb_images_started': 3275, 'nb_selected_images': 5861, 'last_update': '2025/10/17', 'portfolio_id': 27849519, 'last_run_id': 2470193, 'total_number_of_photos': 5876}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84559 seconds', 'coverage_times_pause': '0 days 85799 seconds', 'nb_photos_decision': 8464, 'nb_gray_level_ok': 8464, 'nb_dedup_ok': 2075, 'nb_two_criteria_ok': 2075, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 6389, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 6, 'end_of_day_photos_uploaded': 2160, 'ratio_coverage': 0.97870345721594}, 'dashboard_dict': {'nb_ptf_finished': 41, 'nb_images_finished': 2435, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2435, 'last_update': '2025/10/16', 'portfolio_id': 27818041, 'last_run_id': 2467957, 'total_number_of_photos': 2487}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84364 seconds', 'coverage_times_pause': '0 days 85690 seconds', 'nb_photos_decision': 8472, 'nb_gray_level_ok': 8472, 'nb_dedup_ok': 3630, 'nb_two_criteria_ok': 3630, 'nb_forced_upload': 78, 'end_of_day_photos_duplicated': 4837, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 6, 'end_of_day_photos_uploaded': 3701, 'ratio_coverage': 0.976446486649151}, 'dashboard_dict': {'nb_ptf_finished': 64, 'nb_images_finished': 4215, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4215, 'last_update': '2025/10/15', 'portfolio_id': 27777890, 'last_run_id': 2459539, 'total_number_of_photos': 4283}} No error ? {'log_dict': {'total_nb_images': 6797, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 67144 seconds', 'coverage_times_pause': '0 days 68158 seconds', 'nb_photos_decision': 6721, 'nb_gray_level_ok': 6721, 'nb_dedup_ok': 1977, 'nb_two_criteria_ok': 1977, 'nb_forced_upload': 76, 'end_of_day_photos_duplicated': 4744, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 2052, 'ratio_coverage': 0.9816517785347739}, 'dashboard_dict': {'nb_ptf_finished': 36, 'nb_images_finished': 2169, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2169, 'last_update': '2025/10/14', 'portfolio_id': 27747722, 'last_run_id': 2451969, 'total_number_of_photos': 2246}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2148, 'max_time_between_images': '0 days 21 seconds', 'coverage_pause': '0 days 21284 seconds', 'coverage_times_pause': '0 days 21539 seconds', 'nb_photos_decision': 2124, 'nb_gray_level_ok': 2124, 'nb_dedup_ok': 117, 'nb_two_criteria_ok': 117, 'nb_forced_upload': 24, 'end_of_day_photos_duplicated': 2007, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 140, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 11, 'nb_images_finished': 123, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 123, 'last_update': '2025/10/12', 'portfolio_id': 27720005, 'last_run_id': 2442311, 'total_number_of_photos': 146}} No error ? {'log_dict': {'total_nb_images': 6797, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 67144 seconds', 'coverage_times_pause': '0 days 68158 seconds', 'nb_photos_decision': 6721, 'nb_gray_level_ok': 6721, 'nb_dedup_ok': 1977, 'nb_two_criteria_ok': 1977, 'nb_forced_upload': 76, 'end_of_day_photos_duplicated': 4744, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 2052, 'ratio_coverage': 0.9816517785347739}, 'dashboard_dict': {'nb_ptf_finished': 36, 'nb_images_finished': 2169, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2169, 'last_update': '2025/10/14', 'portfolio_id': 27747722, 'last_run_id': 2451969, 'total_number_of_photos': 2246}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2148, 'max_time_between_images': '0 days 21 seconds', 'coverage_pause': '0 days 21284 seconds', 'coverage_times_pause': '0 days 21539 seconds', 'nb_photos_decision': 2124, 'nb_gray_level_ok': 2124, 'nb_dedup_ok': 117, 'nb_two_criteria_ok': 117, 'nb_forced_upload': 24, 'end_of_day_photos_duplicated': 2007, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 140, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 11, 'nb_images_finished': 123, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 123, 'last_update': '2025/10/12', 'portfolio_id': 27720005, 'last_run_id': 2442311, 'total_number_of_photos': 146}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84432 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8465, 'nb_gray_level_ok': 8465, 'nb_dedup_ok': 4154, 'nb_two_criteria_ok': 4154, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4311, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4244, 'ratio_coverage': 0.9772335327955185}, 'dashboard_dict': {'nb_ptf_finished': 49, 'nb_images_finished': 2557, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1859, 'nb_selected_images': 4416, 'last_update': '2025/10/13', 'portfolio_id': 27666951, 'last_run_id': 2438295, 'total_number_of_photos': 4445}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84662 seconds', 'coverage_times_pause': '0 days 85928 seconds', 'nb_photos_decision': 8500, 'nb_gray_level_ok': 8500, 'nb_dedup_ok': 4072, 'nb_two_criteria_ok': 4072, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4428, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4136, 'ratio_coverage': 0.979895600643526}, 'dashboard_dict': {'nb_ptf_finished': 44, 'nb_images_finished': 2830, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1817, 'nb_selected_images': 4647, 'last_update': '2025/10/13', 'portfolio_id': 27616356, 'last_run_id': 2432375, 'total_number_of_photos': 4669}} No error ? {'log_dict': {'total_nb_images': 6797, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 67144 seconds', 'coverage_times_pause': '0 days 68158 seconds', 'nb_photos_decision': 6721, 'nb_gray_level_ok': 6721, 'nb_dedup_ok': 1977, 'nb_two_criteria_ok': 1977, 'nb_forced_upload': 76, 'end_of_day_photos_duplicated': 4744, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 2052, 'ratio_coverage': 0.9816517785347739}, 'dashboard_dict': {'nb_ptf_finished': 36, 'nb_images_finished': 2169, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2169, 'last_update': '2025/10/14', 'portfolio_id': 27747722, 'last_run_id': 2451969, 'total_number_of_photos': 2246}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2148, 'max_time_between_images': '0 days 21 seconds', 'coverage_pause': '0 days 21284 seconds', 'coverage_times_pause': '0 days 21539 seconds', 'nb_photos_decision': 2124, 'nb_gray_level_ok': 2124, 'nb_dedup_ok': 117, 'nb_two_criteria_ok': 117, 'nb_forced_upload': 24, 'end_of_day_photos_duplicated': 2007, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 140, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 11, 'nb_images_finished': 123, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 123, 'last_update': '2025/10/12', 'portfolio_id': 27720005, 'last_run_id': 2442311, 'total_number_of_photos': 146}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84432 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8465, 'nb_gray_level_ok': 8465, 'nb_dedup_ok': 4154, 'nb_two_criteria_ok': 4154, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4311, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4244, 'ratio_coverage': 0.9772335327955185}, 'dashboard_dict': {'nb_ptf_finished': 49, 'nb_images_finished': 2557, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1859, 'nb_selected_images': 4416, 'last_update': '2025/10/13', 'portfolio_id': 27666951, 'last_run_id': 2438295, 'total_number_of_photos': 4445}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84662 seconds', 'coverage_times_pause': '0 days 85928 seconds', 'nb_photos_decision': 8500, 'nb_gray_level_ok': 8500, 'nb_dedup_ok': 4072, 'nb_two_criteria_ok': 4072, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4428, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4136, 'ratio_coverage': 0.979895600643526}, 'dashboard_dict': {'nb_ptf_finished': 44, 'nb_images_finished': 2830, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1817, 'nb_selected_images': 4647, 'last_update': '2025/10/13', 'portfolio_id': 27616356, 'last_run_id': 2432375, 'total_number_of_photos': 4669}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 82 seconds', 'coverage_pause': '0 days 84775 seconds', 'coverage_times_pause': '0 days 85984 seconds', 'nb_photos_decision': 8497, 'nb_gray_level_ok': 8497, 'nb_dedup_ok': 4375, 'nb_two_criteria_ok': 4375, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4118, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 4453, 'ratio_coverage': 0.9812034861514601}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3247, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 23, 'nb_images_started': 1589, 'nb_selected_images': 4836, 'last_update': '2025/10/13', 'portfolio_id': 27570630, 'last_run_id': 2425187, 'total_number_of_photos': 4874}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2148, 'max_time_between_images': '0 days 21 seconds', 'coverage_pause': '0 days 21284 seconds', 'coverage_times_pause': '0 days 21539 seconds', 'nb_photos_decision': 2124, 'nb_gray_level_ok': 2124, 'nb_dedup_ok': 117, 'nb_two_criteria_ok': 117, 'nb_forced_upload': 24, 'end_of_day_photos_duplicated': 2007, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 140, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 11, 'nb_images_finished': 123, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 123, 'last_update': '2025/10/12', 'portfolio_id': 27720005, 'last_run_id': 2442311, 'total_number_of_photos': 146}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84432 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8465, 'nb_gray_level_ok': 8465, 'nb_dedup_ok': 4154, 'nb_two_criteria_ok': 4154, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4311, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4244, 'ratio_coverage': 0.9772335327955185}, 'dashboard_dict': {'nb_ptf_finished': 49, 'nb_images_finished': 2557, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1859, 'nb_selected_images': 4416, 'last_update': '2025/10/13', 'portfolio_id': 27666951, 'last_run_id': 2438295, 'total_number_of_photos': 4445}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84662 seconds', 'coverage_times_pause': '0 days 85928 seconds', 'nb_photos_decision': 8500, 'nb_gray_level_ok': 8500, 'nb_dedup_ok': 4072, 'nb_two_criteria_ok': 4072, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4428, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4136, 'ratio_coverage': 0.979895600643526}, 'dashboard_dict': {'nb_ptf_finished': 44, 'nb_images_finished': 2830, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1817, 'nb_selected_images': 4647, 'last_update': '2025/10/13', 'portfolio_id': 27616356, 'last_run_id': 2432375, 'total_number_of_photos': 4669}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 82 seconds', 'coverage_pause': '0 days 84775 seconds', 'coverage_times_pause': '0 days 85984 seconds', 'nb_photos_decision': 8497, 'nb_gray_level_ok': 8497, 'nb_dedup_ok': 4375, 'nb_two_criteria_ok': 4375, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4118, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 4453, 'ratio_coverage': 0.9812034861514601}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3247, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 23, 'nb_images_started': 1589, 'nb_selected_images': 4836, 'last_update': '2025/10/13', 'portfolio_id': 27570630, 'last_run_id': 2425187, 'total_number_of_photos': 4874}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84449 seconds', 'coverage_times_pause': '0 days 85745 seconds', 'nb_photos_decision': 8442, 'nb_gray_level_ok': 8442, 'nb_dedup_ok': 2439, 'nb_two_criteria_ok': 2439, 'nb_forced_upload': 101, 'end_of_day_photos_no_longer_on_disk': 1, 'end_of_day_photos_duplicated': 6003, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 2538, 'ratio_coverage': 0.9774302943321104}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 69, 'nb_images_started': 2664, 'nb_selected_images': 2664, 'last_update': '2025/10/09', 'portfolio_id': 27544535, 'last_run_id': 2415055, 'total_number_of_photos': 2743}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2148, 'max_time_between_images': '0 days 21 seconds', 'coverage_pause': '0 days 21284 seconds', 'coverage_times_pause': '0 days 21539 seconds', 'nb_photos_decision': 2124, 'nb_gray_level_ok': 2124, 'nb_dedup_ok': 117, 'nb_two_criteria_ok': 117, 'nb_forced_upload': 24, 'end_of_day_photos_duplicated': 2007, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 140, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 11, 'nb_images_finished': 123, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 123, 'last_update': '2025/10/12', 'portfolio_id': 27720005, 'last_run_id': 2442311, 'total_number_of_photos': 145}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84432 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8465, 'nb_gray_level_ok': 8465, 'nb_dedup_ok': 4154, 'nb_two_criteria_ok': 4154, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4311, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4244, 'ratio_coverage': 0.9772335327955185}, 'dashboard_dict': {'nb_ptf_finished': 49, 'nb_images_finished': 2557, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1859, 'nb_selected_images': 4416, 'last_update': '2025/10/11', 'portfolio_id': 27666951, 'last_run_id': 2438295, 'total_number_of_photos': 4445}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84662 seconds', 'coverage_times_pause': '0 days 85928 seconds', 'nb_photos_decision': 8500, 'nb_gray_level_ok': 8500, 'nb_dedup_ok': 4072, 'nb_two_criteria_ok': 4072, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4428, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4136, 'ratio_coverage': 0.979895600643526}, 'dashboard_dict': {'nb_ptf_finished': 44, 'nb_images_finished': 2830, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1817, 'nb_selected_images': 4647, 'last_update': '2025/10/10', 'portfolio_id': 27616356, 'last_run_id': 2432375, 'total_number_of_photos': 4669}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 82 seconds', 'coverage_pause': '0 days 84775 seconds', 'coverage_times_pause': '0 days 85984 seconds', 'nb_photos_decision': 8497, 'nb_gray_level_ok': 8497, 'nb_dedup_ok': 4375, 'nb_two_criteria_ok': 4375, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4118, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 4453, 'ratio_coverage': 0.9812034861514601}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3247, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 23, 'nb_images_started': 1589, 'nb_selected_images': 4836, 'last_update': '2025/10/10', 'portfolio_id': 27570630, 'last_run_id': 2425187, 'total_number_of_photos': 4874}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84449 seconds', 'coverage_times_pause': '0 days 85745 seconds', 'nb_photos_decision': 8442, 'nb_gray_level_ok': 8442, 'nb_dedup_ok': 2439, 'nb_two_criteria_ok': 2439, 'nb_forced_upload': 101, 'end_of_day_photos_no_longer_on_disk': 1, 'end_of_day_photos_duplicated': 6003, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 2538, 'ratio_coverage': 0.9774302943321104}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 69, 'nb_images_started': 2664, 'nb_selected_images': 2664, 'last_update': '2025/10/09', 'portfolio_id': 27544535, 'last_run_id': 2415055, 'total_number_of_photos': 2743}} No error ? {'log_dict': {'total_nb_images': 6791, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67080 seconds', 'coverage_times_pause': '0 days 68098 seconds', 'nb_photos_decision': 6732, 'nb_gray_level_ok': 6732, 'nb_dedup_ok': 3140, 'nb_two_criteria_ok': 3140, 'nb_forced_upload': 59, 'end_of_day_photos_duplicated': 3592, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 3197, 'ratio_coverage': 0.9807160923405313}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 57, 'nb_images_started': 3454, 'nb_selected_images': 3454, 'last_update': '2025/10/09', 'portfolio_id': 27519532, 'last_run_id': 2414581, 'total_number_of_photos': 3499}} No error ? {'log_dict': {'total_nb_images': 2148, 'max_time_between_images': '0 days 21 seconds', 'coverage_pause': '0 days 21284 seconds', 'coverage_times_pause': '0 days 21539 seconds', 'nb_photos_decision': 2124, 'nb_gray_level_ok': 2124, 'nb_dedup_ok': 117, 'nb_two_criteria_ok': 117, 'nb_forced_upload': 24, 'end_of_day_photos_duplicated': 2007, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 140, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 11, 'nb_images_finished': 123, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 123, 'last_update': '2025/10/12', 'portfolio_id': 27720005, 'last_run_id': 2442293, 'total_number_of_photos': 145}} No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84432 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8465, 'nb_gray_level_ok': 8465, 'nb_dedup_ok': 4154, 'nb_two_criteria_ok': 4154, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4311, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4244, 'ratio_coverage': 0.9772335327955185}, 'dashboard_dict': {'nb_ptf_finished': 49, 'nb_images_finished': 2557, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1859, 'nb_selected_images': 4416, 'last_update': '2025/10/11', 'portfolio_id': 27666951, 'last_run_id': 2438295, 'total_number_of_photos': 4445}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84662 seconds', 'coverage_times_pause': '0 days 85928 seconds', 'nb_photos_decision': 8500, 'nb_gray_level_ok': 8500, 'nb_dedup_ok': 4072, 'nb_two_criteria_ok': 4072, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4428, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4136, 'ratio_coverage': 0.979895600643526}, 'dashboard_dict': {'nb_ptf_finished': 44, 'nb_images_finished': 2830, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1817, 'nb_selected_images': 4647, 'last_update': '2025/10/10', 'portfolio_id': 27616356, 'last_run_id': 2432375, 'total_number_of_photos': 4669}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 82 seconds', 'coverage_pause': '0 days 84775 seconds', 'coverage_times_pause': '0 days 85984 seconds', 'nb_photos_decision': 8497, 'nb_gray_level_ok': 8497, 'nb_dedup_ok': 4375, 'nb_two_criteria_ok': 4375, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4118, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 4453, 'ratio_coverage': 0.9812034861514601}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3247, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 23, 'nb_images_started': 1589, 'nb_selected_images': 4836, 'last_update': '2025/10/10', 'portfolio_id': 27570630, 'last_run_id': 2425187, 'total_number_of_photos': 4874}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84449 seconds', 'coverage_times_pause': '0 days 85745 seconds', 'nb_photos_decision': 8442, 'nb_gray_level_ok': 8442, 'nb_dedup_ok': 2439, 'nb_two_criteria_ok': 2439, 'nb_forced_upload': 101, 'end_of_day_photos_no_longer_on_disk': 1, 'end_of_day_photos_duplicated': 6003, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 2538, 'ratio_coverage': 0.9774302943321104}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 69, 'nb_images_started': 2664, 'nb_selected_images': 2664, 'last_update': '2025/10/09', 'portfolio_id': 27544535, 'last_run_id': 2415055, 'total_number_of_photos': 2743}} No error ? {'log_dict': {'total_nb_images': 6791, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67080 seconds', 'coverage_times_pause': '0 days 68098 seconds', 'nb_photos_decision': 6732, 'nb_gray_level_ok': 6732, 'nb_dedup_ok': 3140, 'nb_two_criteria_ok': 3140, 'nb_forced_upload': 59, 'end_of_day_photos_duplicated': 3592, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 3197, 'ratio_coverage': 0.9807160923405313}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 57, 'nb_images_started': 3454, 'nb_selected_images': 3454, 'last_update': '2025/10/09', 'portfolio_id': 27519532, 'last_run_id': 2414581, 'total_number_of_photos': 3499}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 8556, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84432 seconds', 'coverage_times_pause': '0 days 85796 seconds', 'nb_photos_decision': 8465, 'nb_gray_level_ok': 8465, 'nb_dedup_ok': 4154, 'nb_two_criteria_ok': 4154, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4311, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4244, 'ratio_coverage': 0.9772335327955185}, 'dashboard_dict': {'nb_ptf_finished': 49, 'nb_images_finished': 2557, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1859, 'nb_selected_images': 4416, 'last_update': '2025/10/11', 'portfolio_id': 27666951, 'last_run_id': 2438043, 'total_number_of_photos': 4445}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84662 seconds', 'coverage_times_pause': '0 days 85928 seconds', 'nb_photos_decision': 8500, 'nb_gray_level_ok': 8500, 'nb_dedup_ok': 4072, 'nb_two_criteria_ok': 4072, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4428, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4136, 'ratio_coverage': 0.979895600643526}, 'dashboard_dict': {'nb_ptf_finished': 44, 'nb_images_finished': 2830, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 27, 'nb_images_started': 1817, 'nb_selected_images': 4647, 'last_update': '2025/10/10', 'portfolio_id': 27616356, 'last_run_id': 2432375, 'total_number_of_photos': 4669}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 82 seconds', 'coverage_pause': '0 days 84775 seconds', 'coverage_times_pause': '0 days 85984 seconds', 'nb_photos_decision': 8497, 'nb_gray_level_ok': 8497, 'nb_dedup_ok': 4375, 'nb_two_criteria_ok': 4375, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4118, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 4453, 'ratio_coverage': 0.9812034861514601}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3247, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 23, 'nb_images_started': 1589, 'nb_selected_images': 4836, 'last_update': '2025/10/10', 'portfolio_id': 27570630, 'last_run_id': 2425187, 'total_number_of_photos': 4874}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84449 seconds', 'coverage_times_pause': '0 days 85745 seconds', 'nb_photos_decision': 8442, 'nb_gray_level_ok': 8442, 'nb_dedup_ok': 2439, 'nb_two_criteria_ok': 2439, 'nb_forced_upload': 101, 'end_of_day_photos_no_longer_on_disk': 1, 'end_of_day_photos_duplicated': 6003, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 2538, 'ratio_coverage': 0.9774302943321104}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 69, 'nb_images_started': 2664, 'nb_selected_images': 2664, 'last_update': '2025/10/09', 'portfolio_id': 27544535, 'last_run_id': 2415055, 'total_number_of_photos': 2743}} No error ? {'log_dict': {'total_nb_images': 6791, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67080 seconds', 'coverage_times_pause': '0 days 68098 seconds', 'nb_photos_decision': 6732, 'nb_gray_level_ok': 6732, 'nb_dedup_ok': 3140, 'nb_two_criteria_ok': 3140, 'nb_forced_upload': 59, 'end_of_day_photos_duplicated': 3592, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 3197, 'ratio_coverage': 0.9807160923405313}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 57, 'nb_images_started': 3454, 'nb_selected_images': 3454, 'last_update': '2025/10/09', 'portfolio_id': 27519532, 'last_run_id': 2414581, 'total_number_of_photos': 3499}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2143, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21157 seconds', 'coverage_times_pause': '0 days 21489 seconds', 'nb_photos_decision': 2127, 'nb_gray_level_ok': 2127, 'nb_dedup_ok': 500, 'nb_two_criteria_ok': 500, 'nb_forced_upload': 21, 'end_of_day_photos_duplicated': 1623, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 519, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 10, 'nb_images_finished': 560, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 560, 'last_update': '2025/10/05', 'portfolio_id': 27508000, 'last_run_id': 2404355, 'total_number_of_photos': 574}} No error ? {'log_dict': {'total_nb_images': 8569, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84662 seconds', 'coverage_times_pause': '0 days 85928 seconds', 'nb_photos_decision': 8500, 'nb_gray_level_ok': 8500, 'nb_dedup_ok': 4072, 'nb_two_criteria_ok': 4072, 'nb_forced_upload': 74, 'end_of_day_photos_duplicated': 4428, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4136, 'ratio_coverage': 0.979895600643526}, 'dashboard_dict': {'nb_ptf_finished': 41, 'nb_images_finished': 2668, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 22, 'nb_images_started': 1559, 'nb_selected_images': 4227, 'last_update': '2025/10/10', 'portfolio_id': 27616356, 'last_run_id': 2428115, 'total_number_of_photos': 4669}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 82 seconds', 'coverage_pause': '0 days 84775 seconds', 'coverage_times_pause': '0 days 85984 seconds', 'nb_photos_decision': 8497, 'nb_gray_level_ok': 8497, 'nb_dedup_ok': 4375, 'nb_two_criteria_ok': 4375, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4118, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 4453, 'ratio_coverage': 0.9812034861514601}, 'dashboard_dict': {'nb_ptf_finished': 54, 'nb_images_finished': 3247, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 23, 'nb_images_started': 1589, 'nb_selected_images': 4836, 'last_update': '2025/10/09', 'portfolio_id': 27570630, 'last_run_id': 2425187, 'total_number_of_photos': 4874}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84449 seconds', 'coverage_times_pause': '0 days 85745 seconds', 'nb_photos_decision': 8442, 'nb_gray_level_ok': 8442, 'nb_dedup_ok': 2439, 'nb_two_criteria_ok': 2439, 'nb_forced_upload': 101, 'end_of_day_photos_no_longer_on_disk': 1, 'end_of_day_photos_duplicated': 6003, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 2538, 'ratio_coverage': 0.9774302943321104}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 69, 'nb_images_started': 2664, 'nb_selected_images': 2664, 'last_update': '2025/10/09', 'portfolio_id': 27544535, 'last_run_id': 2415055, 'total_number_of_photos': 2743}} No error ? {'log_dict': {'total_nb_images': 6791, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67080 seconds', 'coverage_times_pause': '0 days 68098 seconds', 'nb_photos_decision': 6732, 'nb_gray_level_ok': 6732, 'nb_dedup_ok': 3140, 'nb_two_criteria_ok': 3140, 'nb_forced_upload': 59, 'end_of_day_photos_duplicated': 3592, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 3197, 'ratio_coverage': 0.9807160923405313}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 57, 'nb_images_started': 3454, 'nb_selected_images': 3454, 'last_update': '2025/10/09', 'portfolio_id': 27519532, 'last_run_id': 2414581, 'total_number_of_photos': 3499}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2143, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21157 seconds', 'coverage_times_pause': '0 days 21489 seconds', 'nb_photos_decision': 2127, 'nb_gray_level_ok': 2127, 'nb_dedup_ok': 500, 'nb_two_criteria_ok': 500, 'nb_forced_upload': 21, 'end_of_day_photos_duplicated': 1623, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 519, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 10, 'nb_images_finished': 560, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 560, 'last_update': '2025/10/05', 'portfolio_id': 27508000, 'last_run_id': 2404355, 'total_number_of_photos': 574}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84427 seconds', 'coverage_times_pause': '0 days 85692 seconds', 'nb_photos_decision': 8457, 'nb_gray_level_ok': 8457, 'nb_dedup_ok': 4324, 'nb_two_criteria_ok': 4324, 'nb_forced_upload': 93, 'end_of_day_photos_duplicated': 4133, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4411, 'ratio_coverage': 0.9771756617553444}, 'dashboard_dict': {'nb_ptf_finished': 75, 'nb_images_finished': 5105, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 5105, 'last_update': '2025/10/04', 'portfolio_id': 27462370, 'last_run_id': 2402241, 'total_number_of_photos': 5136}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 82 seconds', 'coverage_pause': '0 days 84775 seconds', 'coverage_times_pause': '0 days 85984 seconds', 'nb_photos_decision': 8497, 'nb_gray_level_ok': 8497, 'nb_dedup_ok': 4375, 'nb_two_criteria_ok': 4375, 'nb_forced_upload': 83, 'end_of_day_photos_duplicated': 4118, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 3, 'end_of_day_photos_uploaded': 4453, 'ratio_coverage': 0.9812034861514601}, 'dashboard_dict': {'nb_ptf_finished': 35, 'nb_images_finished': 2510, 'nb_ptf_finished_for_older': 16, 'nb_images_finished_for_older': 547, 'nb_ptf_started': 18, 'nb_images_started': 1267, 'nb_selected_images': 4324, 'last_update': '2025/10/09', 'portfolio_id': 27570630, 'last_run_id': 2419655, 'total_number_of_photos': 4874}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84449 seconds', 'coverage_times_pause': '0 days 85745 seconds', 'nb_photos_decision': 8442, 'nb_gray_level_ok': 8442, 'nb_dedup_ok': 2439, 'nb_two_criteria_ok': 2439, 'nb_forced_upload': 101, 'end_of_day_photos_no_longer_on_disk': 1, 'end_of_day_photos_duplicated': 6003, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 2538, 'ratio_coverage': 0.9774302943321104}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 69, 'nb_images_started': 2664, 'nb_selected_images': 2664, 'last_update': '2025/10/09', 'portfolio_id': 27544535, 'last_run_id': 2415055, 'total_number_of_photos': 2743}} No error ? {'log_dict': {'total_nb_images': 6791, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67080 seconds', 'coverage_times_pause': '0 days 68098 seconds', 'nb_photos_decision': 6732, 'nb_gray_level_ok': 6732, 'nb_dedup_ok': 3140, 'nb_two_criteria_ok': 3140, 'nb_forced_upload': 59, 'end_of_day_photos_duplicated': 3592, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 3197, 'ratio_coverage': 0.9807160923405313}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 57, 'nb_images_started': 3454, 'nb_selected_images': 3454, 'last_update': '2025/10/09', 'portfolio_id': 27519532, 'last_run_id': 2414581, 'total_number_of_photos': 3499}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2143, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21157 seconds', 'coverage_times_pause': '0 days 21489 seconds', 'nb_photos_decision': 2127, 'nb_gray_level_ok': 2127, 'nb_dedup_ok': 500, 'nb_two_criteria_ok': 500, 'nb_forced_upload': 21, 'end_of_day_photos_duplicated': 1623, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 519, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 10, 'nb_images_finished': 560, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 560, 'last_update': '2025/10/05', 'portfolio_id': 27508000, 'last_run_id': 2404355, 'total_number_of_photos': 574}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84427 seconds', 'coverage_times_pause': '0 days 85692 seconds', 'nb_photos_decision': 8457, 'nb_gray_level_ok': 8457, 'nb_dedup_ok': 4324, 'nb_two_criteria_ok': 4324, 'nb_forced_upload': 93, 'end_of_day_photos_duplicated': 4133, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4411, 'ratio_coverage': 0.9771756617553444}, 'dashboard_dict': {'nb_ptf_finished': 75, 'nb_images_finished': 5105, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 5105, 'last_update': '2025/10/04', 'portfolio_id': 27462370, 'last_run_id': 2402241, 'total_number_of_photos': 5136}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84612 seconds', 'coverage_times_pause': '0 days 85805 seconds', 'nb_photos_decision': 8470, 'nb_gray_level_ok': 8470, 'nb_dedup_ok': 2620, 'nb_two_criteria_ok': 2620, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5850, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 2701, 'ratio_coverage': 0.9793168902417853}, 'dashboard_dict': {'nb_ptf_finished': 57, 'nb_images_finished': 2895, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2895, 'last_update': '2025/10/03', 'portfolio_id': 27424580, 'last_run_id': 2394823, 'total_number_of_photos': 2959}} No error ? {'log_dict': {'total_nb_images': 8549, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84449 seconds', 'coverage_times_pause': '0 days 85745 seconds', 'nb_photos_decision': 8442, 'nb_gray_level_ok': 8442, 'nb_dedup_ok': 2439, 'nb_two_criteria_ok': 2439, 'nb_forced_upload': 101, 'end_of_day_photos_no_longer_on_disk': 1, 'end_of_day_photos_duplicated': 6003, 'end_of_day_photos_nothing_done': 6, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 2538, 'ratio_coverage': 0.9774302943321104}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 0, 'total_number_of_photos': 0, 'last_update': '0000/00/00'}} No error ? {'log_dict': {'total_nb_images': 6791, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 67080 seconds', 'coverage_times_pause': '0 days 68098 seconds', 'nb_photos_decision': 6732, 'nb_gray_level_ok': 6732, 'nb_dedup_ok': 3140, 'nb_two_criteria_ok': 3140, 'nb_forced_upload': 59, 'end_of_day_photos_duplicated': 3592, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 1, 'end_of_day_photos_uploaded': 3197, 'ratio_coverage': 0.9807160923405313}, 'dashboard_dict': {'nb_ptf_finished': 0, 'nb_images_finished': 0, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 17, 'nb_images_started': 881, 'nb_selected_images': 881, 'last_update': '2025/10/08', 'portfolio_id': 27519532, 'last_run_id': 2412725, 'total_number_of_photos': 3499}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2143, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21157 seconds', 'coverage_times_pause': '0 days 21489 seconds', 'nb_photos_decision': 2127, 'nb_gray_level_ok': 2127, 'nb_dedup_ok': 500, 'nb_two_criteria_ok': 500, 'nb_forced_upload': 21, 'end_of_day_photos_duplicated': 1623, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 519, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 10, 'nb_images_finished': 560, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 560, 'last_update': '2025/10/05', 'portfolio_id': 27508000, 'last_run_id': 2404355, 'total_number_of_photos': 574}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84427 seconds', 'coverage_times_pause': '0 days 85692 seconds', 'nb_photos_decision': 8457, 'nb_gray_level_ok': 8457, 'nb_dedup_ok': 4324, 'nb_two_criteria_ok': 4324, 'nb_forced_upload': 93, 'end_of_day_photos_duplicated': 4133, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4411, 'ratio_coverage': 0.9771756617553444}, 'dashboard_dict': {'nb_ptf_finished': 75, 'nb_images_finished': 5105, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 5105, 'last_update': '2025/10/04', 'portfolio_id': 27462370, 'last_run_id': 2402241, 'total_number_of_photos': 5136}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84612 seconds', 'coverage_times_pause': '0 days 85805 seconds', 'nb_photos_decision': 8470, 'nb_gray_level_ok': 8470, 'nb_dedup_ok': 2620, 'nb_two_criteria_ok': 2620, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5850, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 2701, 'ratio_coverage': 0.9793168902417853}, 'dashboard_dict': {'nb_ptf_finished': 57, 'nb_images_finished': 2895, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2895, 'last_update': '2025/10/03', 'portfolio_id': 27424580, 'last_run_id': 2394823, 'total_number_of_photos': 2959}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84743 seconds', 'coverage_times_pause': '0 days 85985 seconds', 'nb_photos_decision': 8489, 'nb_gray_level_ok': 8489, 'nb_dedup_ok': 4285, 'nb_two_criteria_ok': 4285, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4201, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4369, 'ratio_coverage': 0.980833111494346}, 'dashboard_dict': {'nb_ptf_finished': 79, 'nb_images_finished': 4820, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4820, 'last_update': '2025/10/02', 'portfolio_id': 27375678, 'last_run_id': 2387417, 'total_number_of_photos': 4842}} Since we don't have condition on date we need to verify this lately ! No error ? {'log_dict': {'total_nb_images': 2143, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21157 seconds', 'coverage_times_pause': '0 days 21489 seconds', 'nb_photos_decision': 2127, 'nb_gray_level_ok': 2127, 'nb_dedup_ok': 500, 'nb_two_criteria_ok': 500, 'nb_forced_upload': 21, 'end_of_day_photos_duplicated': 1623, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 519, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 10, 'nb_images_finished': 560, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 560, 'last_update': '2025/10/05', 'portfolio_id': 27508000, 'last_run_id': 2404355, 'total_number_of_photos': 574}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84427 seconds', 'coverage_times_pause': '0 days 85692 seconds', 'nb_photos_decision': 8457, 'nb_gray_level_ok': 8457, 'nb_dedup_ok': 4324, 'nb_two_criteria_ok': 4324, 'nb_forced_upload': 93, 'end_of_day_photos_duplicated': 4133, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4411, 'ratio_coverage': 0.9771756617553444}, 'dashboard_dict': {'nb_ptf_finished': 75, 'nb_images_finished': 5105, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 5105, 'last_update': '2025/10/04', 'portfolio_id': 27462370, 'last_run_id': 2402241, 'total_number_of_photos': 5136}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84612 seconds', 'coverage_times_pause': '0 days 85805 seconds', 'nb_photos_decision': 8470, 'nb_gray_level_ok': 8470, 'nb_dedup_ok': 2620, 'nb_two_criteria_ok': 2620, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5850, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 2701, 'ratio_coverage': 0.9793168902417853}, 'dashboard_dict': {'nb_ptf_finished': 57, 'nb_images_finished': 2895, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2895, 'last_update': '2025/10/03', 'portfolio_id': 27424580, 'last_run_id': 2394823, 'total_number_of_photos': 2959}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84743 seconds', 'coverage_times_pause': '0 days 85985 seconds', 'nb_photos_decision': 8489, 'nb_gray_level_ok': 8489, 'nb_dedup_ok': 4285, 'nb_two_criteria_ok': 4285, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4201, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4369, 'ratio_coverage': 0.980833111494346}, 'dashboard_dict': {'nb_ptf_finished': 79, 'nb_images_finished': 4820, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4820, 'last_update': '2025/10/02', 'portfolio_id': 27375678, 'last_run_id': 2387417, 'total_number_of_photos': 4842}} 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': 2143, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 21157 seconds', 'coverage_times_pause': '0 days 21489 seconds', 'nb_photos_decision': 2127, 'nb_gray_level_ok': 2127, 'nb_dedup_ok': 500, 'nb_two_criteria_ok': 500, 'nb_forced_upload': 21, 'end_of_day_photos_duplicated': 1623, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 519, 'ratio_coverage': 1.0}, 'dashboard_dict': {'nb_ptf_finished': 10, 'nb_images_finished': 560, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 560, 'last_update': '2025/10/05', 'portfolio_id': 27508000, 'last_run_id': 2404347, 'total_number_of_photos': 573}} No error ? {'log_dict': {'total_nb_images': 8545, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84427 seconds', 'coverage_times_pause': '0 days 85692 seconds', 'nb_photos_decision': 8457, 'nb_gray_level_ok': 8457, 'nb_dedup_ok': 4324, 'nb_two_criteria_ok': 4324, 'nb_forced_upload': 93, 'end_of_day_photos_duplicated': 4133, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4411, 'ratio_coverage': 0.9771756617553444}, 'dashboard_dict': {'nb_ptf_finished': 75, 'nb_images_finished': 5105, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 5105, 'last_update': '2025/10/04', 'portfolio_id': 27462370, 'last_run_id': 2402241, 'total_number_of_photos': 5136}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84612 seconds', 'coverage_times_pause': '0 days 85805 seconds', 'nb_photos_decision': 8470, 'nb_gray_level_ok': 8470, 'nb_dedup_ok': 2620, 'nb_two_criteria_ok': 2620, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5850, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 2701, 'ratio_coverage': 0.9793168902417853}, 'dashboard_dict': {'nb_ptf_finished': 57, 'nb_images_finished': 2895, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2895, 'last_update': '2025/10/03', 'portfolio_id': 27424580, 'last_run_id': 2394823, 'total_number_of_photos': 2959}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84743 seconds', 'coverage_times_pause': '0 days 85985 seconds', 'nb_photos_decision': 8489, 'nb_gray_level_ok': 8489, 'nb_dedup_ok': 4285, 'nb_two_criteria_ok': 4285, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4201, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4369, 'ratio_coverage': 0.980833111494346}, 'dashboard_dict': {'nb_ptf_finished': 79, 'nb_images_finished': 4820, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4820, 'last_update': '2025/10/02', 'portfolio_id': 27375678, 'last_run_id': 2387417, 'total_number_of_photos': 4842}} 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': 8545, 'max_time_between_images': '0 days 80 seconds', 'coverage_pause': '0 days 84427 seconds', 'coverage_times_pause': '0 days 85692 seconds', 'nb_photos_decision': 8457, 'nb_gray_level_ok': 8457, 'nb_dedup_ok': 4324, 'nb_two_criteria_ok': 4324, 'nb_forced_upload': 93, 'end_of_day_photos_duplicated': 4133, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_uploaded': 4411, 'ratio_coverage': 0.9771756617553444}, 'dashboard_dict': {'nb_ptf_finished': 73, 'nb_images_finished': 4938, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 2, 'nb_images_started': 167, 'nb_selected_images': 5105, 'last_update': '2025/10/04', 'portfolio_id': 27462370, 'last_run_id': 2400549, 'total_number_of_photos': 5136}} No error ? {'log_dict': {'total_nb_images': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84612 seconds', 'coverage_times_pause': '0 days 85805 seconds', 'nb_photos_decision': 8470, 'nb_gray_level_ok': 8470, 'nb_dedup_ok': 2620, 'nb_two_criteria_ok': 2620, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5850, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 2701, 'ratio_coverage': 0.9793168902417853}, 'dashboard_dict': {'nb_ptf_finished': 57, 'nb_images_finished': 2895, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2895, 'last_update': '2025/10/03', 'portfolio_id': 27424580, 'last_run_id': 2394823, 'total_number_of_photos': 2959}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84743 seconds', 'coverage_times_pause': '0 days 85985 seconds', 'nb_photos_decision': 8489, 'nb_gray_level_ok': 8489, 'nb_dedup_ok': 4285, 'nb_two_criteria_ok': 4285, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4201, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4369, 'ratio_coverage': 0.980833111494346}, 'dashboard_dict': {'nb_ptf_finished': 79, 'nb_images_finished': 4820, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4820, 'last_update': '2025/10/02', 'portfolio_id': 27375678, 'last_run_id': 2387417, 'total_number_of_photos': 4842}} 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': 8557, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84612 seconds', 'coverage_times_pause': '0 days 85805 seconds', 'nb_photos_decision': 8470, 'nb_gray_level_ok': 8470, 'nb_dedup_ok': 2620, 'nb_two_criteria_ok': 2620, 'nb_forced_upload': 92, 'end_of_day_photos_duplicated': 5850, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 5, 'end_of_day_photos_uploaded': 2701, 'ratio_coverage': 0.9793168902417853}, 'dashboard_dict': {'nb_ptf_finished': 57, 'nb_images_finished': 2895, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 2895, 'last_update': '2025/10/03', 'portfolio_id': 27424580, 'last_run_id': 2392733, 'total_number_of_photos': 2959}} No error ? {'log_dict': {'total_nb_images': 8575, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84743 seconds', 'coverage_times_pause': '0 days 85985 seconds', 'nb_photos_decision': 8489, 'nb_gray_level_ok': 8489, 'nb_dedup_ok': 4285, 'nb_two_criteria_ok': 4285, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4201, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4369, 'ratio_coverage': 0.980833111494346}, 'dashboard_dict': {'nb_ptf_finished': 79, 'nb_images_finished': 4820, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 0, 'nb_images_started': 0, 'nb_selected_images': 4820, 'last_update': '2025/10/02', 'portfolio_id': 27375678, 'last_run_id': 2387417, 'total_number_of_photos': 4842}} 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': 8575, 'max_time_between_images': '0 days 81 seconds', 'coverage_pause': '0 days 84743 seconds', 'coverage_times_pause': '0 days 85985 seconds', 'nb_photos_decision': 8489, 'nb_gray_level_ok': 8489, 'nb_dedup_ok': 4285, 'nb_two_criteria_ok': 4285, 'nb_forced_upload': 91, 'end_of_day_photos_duplicated': 4201, 'end_of_day_photos_nothing_done': 1, 'end_of_day_photos_ok_for_neural_classification': 4, 'end_of_day_photos_uploaded': 4369, 'ratio_coverage': 0.980833111494346}, 'dashboard_dict': {'nb_ptf_finished': 78, 'nb_images_finished': 4788, 'nb_ptf_finished_for_older': 0, 'nb_images_finished_for_older': 0, 'nb_ptf_started': 1, 'nb_images_started': 32, 'nb_selected_images': 4820, 'last_update': '2025/10/02', 'portfolio_id': 27375678, 'last_run_id': 2386575, 'total_number_of_photos': 4842}} 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-10-31 00:00:00 Found day : 2025-10-30 00:00:00 Found day : 2025-10-29 00:00:00 Found day : 2025-10-28 00:00:00 Found day : 2025-10-27 00:00:00 Found day : 2025-10-25 00:00:00 Found day : 2025-10-24 00:00:00 Found day : 2025-10-23 00:00:00 Found day : 2025-10-18 00:00:00 Found day : 2025-10-17 00:00:00 Found day : 2025-10-16 00:00:00 Found day : 2025-10-15 00:00:00 Found day : 2025-10-14 00:00:00 Found day : 2025-10-13 00:00:00 Found day : 2025-10-11 00:00:00 Found day : 2025-10-10 00:00:00 Found day : 2025-10-09 00:00:00 Found day : 2025-10-08 00:00:00 Found day : 2025-10-07 00:00:00 Found day : 2025-10-06 00:00:00 Found day : 2025-10-04 00:00:00 Found day : 2025-10-03 00:00:00 Found day : 2025-10-02 00:00:00 Found day : 2025-10-01 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-10-20 00:00:00,2025-10-21 00:00:00,2025-10-22 00:00:00 after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 10 and month(ded.date) = 10 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), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______JRM' and ded.dashboard_place_id = 10 and month(ded.date) = 10 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 '%102025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-10-01 : dt_date_just_month_year : 2025-10-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-10-01" AND ded.date <= "2025-10-31" 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 (2387417,2394823,2402241,2404355,2414581,2415055,2425187,2432375,2438295,2442311,2451969,2459539,2467957,2470193,2475369,2507303,2507313,2507411,2507283,2507249,2507317,2507329,2507345,2507389,2507231,2507307,2507387) 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.004511838530692392, 'nb_photo': 11814, 'list_port_cont': '27375888,27376535,27376928,27377204,27378464,27378729,27379011,27379422,27379918,27380391,27380894,27381459,27382004,27382466,27382947,27384339,27384688,27384969,27385213,27385620,27385983,27386412,27386761,27387270,27388002,27390125,27390840,27391372,27392212,27394673,27395267,27395927,27396470,27397100,27397689,27398449,27399532,27399997,27400849,27401588,27403924,27404325,27404694,27405159,27405434,27405893,27406444,27407333,27407905,27408450,27408964,27409741,27410230,27410837,27411509,27412221,27413221,27413782,27414325,27415324,27415454,27415864,27416158,27416925,27417180,27418815,27419324,27419736,27420247,27420797,27421281,27421967,27422651,27423613,27424100,27425170,27425509,27425932,27427285,27427598,27427897,27428646,27429153,27429530,27430073,27430535,27431020,27431453,27432845,27433388,27433519,27433814,27434092,27434409,27434809,27435304,27436090,27436963,27438555,27438749,27439202,27439892,27445664,27446788,27448464,27448778,27449069,27449491,27450057,27451100,27451633,27451890,27452370,2745270', 'assoc_port': '27375839:27375888,27376525:27376535,27376906:27376928,27377191:27377204,27378456:27378464,27378717:27378729,27378994:27379011,27379410:27379422,27379907:27379918,27380372:27380391,27380848:27380894,27381440:27381459,27381997:27382004,27382455:27382466,27382890:27382947,27384322:27384339,27384680:27384688,27384953:27384969,27385199:27385213,27385566:27385620,27385977:27385983,27386362:27386412,27386738:27386761,27387203:27387270,27387984:27388002,27390105:27390125,27390791:27390840,27391355:27391372,27392176:27392212,27394659:27394673,27395242:27395267,27395913:27395927,27396429:27396470,27397076:27397100,27397673:27397689,27398369:27398449,27399474:27399532,27399974:27399997,27400780:27400849,27401557:27401588,27403901:27403924,27404296:27404325,27404682:27404694,27405147:27405159,27405398:27405434,27405885:27405893,27406408:27406444,27407294:27407333,27407854:27407905,27408403:27408450,27408924:27408964,27409726:27409741,27410197:27410230,27410821:27410837,27411483:27411509,27412214:27412221,27413207:2741322', 'assoc_mat': '27375839:autre_refus:3726:27375888,27376525:autre_refus:3726:27376535,27376906:autre_refus:3726:27376928,27377191:autre_refus:3726:27377204,27378456:autre_refus:3726:27378464,27378717:autre_refus:3726:27378729,27378994:autre_refus:3726:27379011,27379410:autre_refus:3726:27379422,27379907:autre_refus:3726:27379918,27380372:autre_refus:3726:27380391,27380848:autre_refus:3726:27380894,27381440:autre_refus:3726:27381459,27381997:autre_refus:3726:27382004,27382455:autre_refus:3726:27382466,27382890:autre_refus:3726:27382947,27384322:autre_refus:3726:27384339,27384680:autre_refus:3726:27384688,27384953:autre_refus:3726:27384969,27385199:autre_refus:3726:27385213,27385566:autre_refus:3726:27385620,27385977:autre_refus:3726:27385983,27386362:autre_refus:3726:27386412,27386738:autre_refus:3726:27386761,27387203:autre_refus:3726:27387270,27387984:autre_refus:3726:27388002,27390105:autre_refus:3726:27390125,27390791:autre_refus:3726:27390840,27391355:autre_refus:3726:27391372,27392176:autre_refus:3726:27392212,27394659:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004555915041451907, 'nb_photo': 19235, 'list_port_cont': '27375885,27376528,27376929,27377202,27378468,27378737,27379016,27379445,27379917,27380403,27380896,27381463,27382005,27382464,27382945,27384337,27384693,27384971,27385215,27385618,27385987,27386405,27386760,27387274,27388019,27389382,27390121,27390838,27391374,27392205,27394668,27395266,27395925,27396476,27397095,27397688,27398457,27399995,27400844,27401582,27403929,27404329,27404695,27405155,27405430,27406452,27407335,27407908,27408454,27408961,27409738,27410231,27410846,27411514,27412227,27413219,27413776,27414304,27415326,27415457,27415854,27416167,27416918,27417172,27418378,27418836,27419327,27419734,27420243,27420805,27421287,27421973,27422639,27423618,27424098,27424704,27425169,27425505,27425935,27427288,27427594,27427903,27428386,27428645,27429152,27429529,27430071,27430533,27431022,27431450,27433056,27433385,27433524,27433811,27434097,27434417,27434800,27435306,27436093,27436954,27438552,27438748,27439200,27439895,27446605,27446782,27448461,27448780,27449078,27449493,27450059,27451108,27451630,2745188', 'assoc_port': '27375839:27375885,27376525:27376528,27376906:27376929,27377191:27377202,27378456:27378468,27378717:27378737,27378994:27379016,27379410:27379445,27379907:27379917,27380372:27380403,27380848:27380896,27381440:27381463,27381997:27382005,27382455:27382464,27382890:27382945,27384322:27384337,27384680:27384693,27384953:27384971,27385199:27385215,27385566:27385618,27385977:27385987,27386362:27386405,27386738:27386760,27387203:27387274,27387984:27388019,27389340:27389382,27390105:27390121,27390791:27390838,27391355:27391374,27392176:27392205,27394659:27394668,27395242:27395266,27395913:27395925,27396429:27396476,27397076:27397095,27397673:27397688,27398369:27398457,27399974:27399995,27400780:27400844,27401557:27401582,27403901:27403929,27404296:27404329,27404682:27404695,27405147:27405155,27405398:27405430,27406408:27406452,27407294:27407335,27407854:27407908,27408403:27408454,27408924:27408961,27409726:27409738,27410197:27410231,27410821:27410846,27411483:27411514,27412214:27412227,27413207:27413219,27413745:2741377', 'assoc_mat': '27375839:cartonnette:3726:27375885,27376525:cartonnette:3726:27376528,27376906:cartonnette:3726:27376929,27377191:cartonnette:3726:27377202,27378456:cartonnette:3726:27378468,27378717:cartonnette:3726:27378737,27378994:cartonnette:3726:27379016,27379410:cartonnette:3726:27379445,27379907:cartonnette:3726:27379917,27380372:cartonnette:3726:27380403,27380848:cartonnette:3726:27380896,27381440:cartonnette:3726:27381463,27381997:cartonnette:3726:27382005,27382455:cartonnette:3726:27382464,27382890:cartonnette:3726:27382945,27384322:cartonnette:3726:27384337,27384680:cartonnette:3726:27384693,27384953:cartonnette:3726:27384971,27385199:cartonnette:3726:27385215,27385566:cartonnette:3726:27385618,27385977:cartonnette:3726:27385987,27386362:cartonnette:3726:27386405,27386738:cartonnette:3726:27386760,27387203:cartonnette:3726:27387274,27387984:cartonnette:3726:27388019,27389340:cartonnette:3726:27389382,27390105:cartonnette:3726:27390121,27390791:cartonnette:3726:27390838,27391355:cartonnette:3726:27391374,27392176:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016667638804075423, 'nb_photo': 19501, 'list_port_cont': '27375884,27376534,27376930,27377199,27378470,27378740,27379015,27379440,27379919,27380398,27380904,27381455,27382009,27382470,27382941,27384333,27384692,27384972,27385222,27385622,27385991,27386401,27386756,27387269,27388025,27389380,27390123,27390835,27391370,27392206,27394674,27395262,27395935,27396475,27397091,27397683,27398454,27399999,27400845,27401581,27403922,27404323,27404702,27405153,27405433,27405901,27406449,27407338,27407914,27408453,27408965,27409742,27410229,27410838,27411513,27412225,27413223,27413773,27414316,27415333,27415455,27415856,27416165,27416922,27417173,27417995,27418370,27418838,27419323,27419732,27420237,27420800,27421278,27421966,27422682,27424104,27424702,27425165,27425511,27425938,27427907,27428376,27428644,27429145,27429524,27430070,27430540,27431026,27431448,27432849,27433048,27433379,27433523,27433813,27434101,27434406,27434802,27435312,27436097,27438745,27439207,27439903,27445661,27446611,27446787,27448460,27448777,27449079,27449502,27450051,27451104,27451632,27451893,2745236', 'assoc_port': '27375839:27375884,27376525:27376534,27376906:27376930,27377191:27377199,27378456:27378470,27378717:27378740,27378994:27379015,27379410:27379440,27379907:27379919,27380372:27380398,27380848:27380904,27381440:27381455,27381997:27382009,27382455:27382470,27382890:27382941,27384322:27384333,27384680:27384692,27384953:27384972,27385199:27385222,27385566:27385622,27385977:27385991,27386362:27386401,27386738:27386756,27387203:27387269,27387984:27388025,27389340:27389380,27390105:27390123,27390791:27390835,27391355:27391370,27392176:27392206,27394659:27394674,27395242:27395262,27395913:27395935,27396429:27396475,27397076:27397091,27397673:27397683,27398369:27398454,27399974:27399999,27400780:27400845,27401557:27401581,27403901:27403922,27404296:27404323,27404682:27404702,27405147:27405153,27405398:27405433,27405885:27405901,27406408:27406449,27407294:27407338,27407854:27407914,27408403:27408453,27408924:27408965,27409726:27409742,27410197:27410229,27410821:27410838,27411483:27411513,27412214:27412225,27413207:2741322', 'assoc_mat': '27375839:Carton_brun:3726:27375884,27376525:Carton_brun:3726:27376534,27376906:Carton_brun:3726:27376930,27377191:Carton_brun:3726:27377199,27378456:Carton_brun:3726:27378470,27378717:Carton_brun:3726:27378740,27378994:Carton_brun:3726:27379015,27379410:Carton_brun:3726:27379440,27379907:Carton_brun:3726:27379919,27380372:Carton_brun:3726:27380398,27380848:Carton_brun:3726:27380904,27381440:Carton_brun:3726:27381455,27381997:Carton_brun:3726:27382009,27382455:Carton_brun:3726:27382470,27382890:Carton_brun:3726:27382941,27384322:Carton_brun:3726:27384333,27384680:Carton_brun:3726:27384692,27384953:Carton_brun:3726:27384972,27385199:Carton_brun:3726:27385222,27385566:Carton_brun:3726:27385622,27385977:Carton_brun:3726:27385991,27386362:Carton_brun:3726:27386401,27386738:Carton_brun:3726:27386756,27387203:Carton_brun:3726:27387269,27387984:Carton_brun:3726:27388025,27389340:Carton_brun:3726:27389380,27390105:Carton_brun:3726:27390123,27390791:Carton_brun:3726:27390835,27391355:Carton_brun:3726:27391370,27392176:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009253308283522933, 'nb_photo': 19989, 'list_port_cont': '27375889,27376529,27376931,27377200,27378462,27378731,27379006,27379439,27379912,27380399,27380895,27381451,27382013,27382471,27382943,27384336,27384696,27384967,27385220,27385623,27385992,27386406,27386751,27387272,27388023,27388804,27389383,27390126,27390839,27391371,27392207,27394677,27395271,27395934,27396469,27397094,27397682,27398455,27399536,27399990,27400839,27401592,27403919,27404332,27404705,27405160,27405429,27405894,27406443,27407337,27407904,27408447,27409734,27410232,27410836,27411510,27412230,27413220,27413778,27414321,27415447,27415857,27416164,27416919,27417169,27417990,27418374,27418816,27419326,27419735,27420244,27420801,27421284,27421972,27422658,27424103,27424696,27425161,27425510,27425937,27427281,27427599,27427898,27428379,27428650,27429144,27429525,27430074,27430532,27431021,27431449,27432850,27433046,27433377,27433521,27433810,27434096,27434412,27434803,27435310,27436089,27436959,27438554,27438752,27439206,27439893,27445668,27446608,27446792,27448773,27449077,27449500,27450050,2745110', 'assoc_port': '27375839:27375889,27376525:27376529,27376906:27376931,27377191:27377200,27378456:27378462,27378717:27378731,27378994:27379006,27379410:27379439,27379907:27379912,27380372:27380399,27380848:27380895,27381440:27381451,27381997:27382013,27382455:27382471,27382890:27382943,27384322:27384336,27384680:27384696,27384953:27384967,27385199:27385220,27385566:27385623,27385977:27385992,27386362:27386406,27386738:27386751,27387203:27387272,27387984:27388023,27388759:27388804,27389340:27389383,27390105:27390126,27390791:27390839,27391355:27391371,27392176:27392207,27394659:27394677,27395242:27395271,27395913:27395934,27396429:27396469,27397076:27397094,27397673:27397682,27398369:27398455,27399474:27399536,27399974:27399990,27400780:27400839,27401557:27401592,27403901:27403919,27404296:27404332,27404682:27404705,27405147:27405160,27405398:27405429,27405885:27405894,27406408:27406443,27407294:27407337,27407854:27407904,27408403:27408447,27409726:27409734,27410197:27410232,27410821:27410836,27411483:27411510,27412214:2741223', 'assoc_mat': '27375839:Carton_gris:3726:27375889,27376525:Carton_gris:3726:27376529,27376906:Carton_gris:3726:27376931,27377191:Carton_gris:3726:27377200,27378456:Carton_gris:3726:27378462,27378717:Carton_gris:3726:27378731,27378994:Carton_gris:3726:27379006,27379410:Carton_gris:3726:27379439,27379907:Carton_gris:3726:27379912,27380372:Carton_gris:3726:27380399,27380848:Carton_gris:3726:27380895,27381440:Carton_gris:3726:27381451,27381997:Carton_gris:3726:27382013,27382455:Carton_gris:3726:27382471,27382890:Carton_gris:3726:27382943,27384322:Carton_gris:3726:27384336,27384680:Carton_gris:3726:27384696,27384953:Carton_gris:3726:27384967,27385199:Carton_gris:3726:27385220,27385566:Carton_gris:3726:27385623,27385977:Carton_gris:3726:27385992,27386362:Carton_gris:3726:27386406,27386738:Carton_gris:3726:27386751,27387203:Carton_gris:3726:27387272,27387984:Carton_gris:3726:27388023,27388759:Carton_gris:3726:27388804,27389340:Carton_gris:3726:27389383,27390105:Carton_gris:3726:27390126,27390791:Carton_gris:3726:27390839,27391355:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00201129286569613, 'nb_photo': 3037, 'list_port_cont': '27376536,27377198,27378463,27379920,27380900,27381458,27382462,27382952,27384686,27384974,27385216,27385624,27385994,27386755,27387279,27389381,27390836,27391364,27392209,27394669,27395928,27396473,27397096,27398447,27399993,27400843,27403925,27404330,27405154,27405428,27406453,27407916,27410835,27412224,27413222,27413780,27414322,27415855,27416169,27416921,27417176,27418380,27418817,27419328,27419731,27420245,27420803,27421282,27422676,27424695,27425167,27425507,27425933,27427592,27427900,27429147,27430075,27430530,27431027,27433054,27433807,27436096,27438753,27439208,27439901,27446601,27448774,27449496,27451623,27451889,27452373,27452700,27453315,27453935,27454529,27455060,27461028,27461802,27464300,27464970,27466539,27467027,27467621,27468502,27469014,27470848,27471446,27472908,27474249,27475819,27476534,27478055,27481058,27481901,27483139,27483737,27486714,27489611,27490358,27490870,27491457,27491996,27493268,27493918,27494648,27495913,27496425,27497893,27498545,27498888,27499156,27499515,27500388,2750194', 'assoc_port': '27376525:27376536,27377191:27377198,27378456:27378463,27379907:27379920,27380848:27380900,27381440:27381458,27382455:27382462,27382890:27382952,27384680:27384686,27384953:27384974,27385199:27385216,27385566:27385624,27385977:27385994,27386738:27386755,27387203:27387279,27389340:27389381,27390791:27390836,27391355:27391364,27392176:27392209,27394659:27394669,27395913:27395928,27396429:27396473,27397076:27397096,27398369:27398447,27399974:27399993,27400780:27400843,27403901:27403925,27404296:27404330,27405147:27405154,27405398:27405428,27406408:27406453,27407854:27407916,27410821:27410835,27412214:27412224,27413207:27413222,27413745:27413780,27414258:27414322,27415818:27415855,27416157:27416169,27416890:27416921,27417155:27417176,27418346:27418380,27418801:27418817,27419316:27419328,27419706:27419731,27420225:27420245,27420770:27420803,27421265:27421282,27422618:27422676,27424686:27424695,27425124:27425167,27425471:27425507,27425856:27425933,27427585:27427592,27427882:27427900,27429102:27429147,27430058:2743007', 'assoc_mat': '27376525:kraft:3726:27376536,27377191:kraft:3726:27377198,27378456:kraft:3726:27378463,27379907:kraft:3726:27379920,27380848:kraft:3726:27380900,27381440:kraft:3726:27381458,27382455:kraft:3726:27382462,27382890:kraft:3726:27382952,27384680:kraft:3726:27384686,27384953:kraft:3726:27384974,27385199:kraft:3726:27385216,27385566:kraft:3726:27385624,27385977:kraft:3726:27385994,27386738:kraft:3726:27386755,27387203:kraft:3726:27387279,27389340:kraft:3726:27389381,27390791:kraft:3726:27390836,27391355:kraft:3726:27391364,27392176:kraft:3726:27392209,27394659:kraft:3726:27394669,27395913:kraft:3726:27395928,27396429:kraft:3726:27396473,27397076:kraft:3726:27397096,27398369:kraft:3726:27398447,27399974:kraft:3726:27399993,27400780:kraft:3726:27400843,27403901:kraft:3726:27403925,27404296:kraft:3726:27404330,27405147:kraft:3726:27405154,27405398:kraft:3726:27405428,27406408:kraft:3726:27406453,27407854:kraft:3726:27407916,27410821:kraft:3726:27410835,27412214:kraft:3726:27412224,27413207:kraft:3726:27413222,27413745:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0007688136975636337, 'nb_photo': 883, 'list_port_cont': '27377206,27378473,27381456,27382463,27382948,27384335,27384976,27390837,27398452,27404700,27405431,27413214,27420248,27421974,27424097,27427908,27430079,27433047,27434090,27434405,27436092,27450055,27451626,27456910,27458954,27460492,27461799,27462767,27464294,27464962,27465551,27470604,27471984,27472397,27474248,27475820,27476529,27478059,27482531,27485124,27490355,27490864,27492603,27493272,27493909,27495912,27497036,27498889,27499155,27500386,27501207,27501526,27502491,27504302,27505609,27506065,27508714,27509233,27510114,27510923,27519696,27520089,27520435,27520877,27522425,27522988,27524642,27526200,27526533,27528228,27529008,27533221,27534128,27535491,27537243,27537660,27539739,27540153,27540351,27540804,27541703,27542342,27544810,27547374,27548617,27548841,27548993,27549456,27552107,27552940,27553269,27553634,27555390,27555868,27564471,27564984,27565378,27570641,27571869,27572108,27573675,27573866,27575476,27575989,27576448,27577529,27580916,27582371,27584510,27585630,27592157,27596748,27597974,2759883', 'assoc_port': '27377191:27377206,27378456:27378473,27381440:27381456,27382455:27382463,27382890:27382948,27384322:27384335,27384953:27384976,27390791:27390837,27398369:27398452,27404682:27404700,27405398:27405431,27413207:27413214,27420225:27420248,27421942:27421974,27424087:27424097,27427882:27427908,27430058:27430079,27433044:27433047,27434083:27434090,27434369:27434405,27436023:27436092,27450035:27450055,27451540:27451626,27456890:27456910,27458863:27458954,27460478:27460492,27461682:27461799,27462676:27462767,27464289:27464294,27464951:27464962,27465533:27465551,27470593:27470604,27471962:27471984,27472372:27472397,27474194:27474248,27475805:27475820,27476483:27476529,27478030:27478059,27482504:27482531,27485107:27485124,27490309:27490355,27490848:27490864,27492533:27492603,27493243:27493272,27493854:27493909,27495873:27495912,27496981:27497036,27498848:27498889,27499115:27499155,27500341:27500386,27501189:27501207,27501488:27501526,27502478:27502491,27504290:27504302,27505585:27505609,27506043:27506065,27508709:2750871', 'assoc_mat': '27377191:metal:3726:27377206,27378456:metal:3726:27378473,27381440:metal:3726:27381456,27382455:metal:3726:27382463,27382890:metal:3726:27382948,27384322:metal:3726:27384335,27384953:metal:3726:27384976,27390791:metal:3726:27390837,27398369:metal:3726:27398452,27404682:metal:3726:27404700,27405398:metal:3726:27405431,27413207:metal:3726:27413214,27420225:metal:3726:27420248,27421942:metal:3726:27421974,27424087:metal:3726:27424097,27427882:metal:3726:27427908,27430058:metal:3726:27430079,27433044:metal:3726:27433047,27434083:metal:3726:27434090,27434369:metal:3726:27434405,27436023:metal:3726:27436092,27450035:metal:3726:27450055,27451540:metal:3726:27451626,27456890:metal:3726:27456910,27458863:metal:3726:27458954,27460478:metal:3726:27460492,27461682:metal:3726:27461799,27462676:metal:3726:27462767,27464289:metal:3726:27464294,27464951:metal:3726:27464962,27465533:metal:3726:27465551,27470593:metal:3726:27470604,27471962:metal:3726:27471984,27472372:metal:3726:27472397,27474194:metal:3726:27474248,27475805:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.003967865270665909, 'nb_photo': 12715, 'list_port_cont': '27375886,27376531,27376935,27377203,27378467,27378739,27379014,27379446,27379921,27380396,27380897,27381454,27382469,27382942,27384329,27384687,27384975,27385221,27385621,27385986,27386404,27386758,27387277,27388020,27389385,27390132,27390842,27391366,27392215,27394676,27395264,27395931,27396466,27397099,27398450,27399989,27400847,27401584,27403920,27404331,27404699,27405162,27405896,27407330,27407915,27408452,27410226,27410845,27411512,27412219,27413215,27413775,27414305,27415456,27415861,27416159,27416927,27417170,27418377,27418834,27419332,27419737,27420239,27420796,27421286,27421970,27422678,27423616,27424093,27424697,27425164,27425502,27425930,27427287,27428643,27429150,27429518,27430537,27431028,27431451,27432848,27433050,27433381,27433808,27434094,27434410,27434807,27435303,27436099,27436965,27438754,27439209,27439899,27445659,27446610,27446784,27448462,27448771,27449073,27449492,27450056,27451110,27451624,27451895,27452376,27452704,27453310,27453939,27454522,27455076,27455819,27456394,27456900,2745866', 'assoc_port': '27375839:27375886,27376525:27376531,27376906:27376935,27377191:27377203,27378456:27378467,27378717:27378739,27378994:27379014,27379410:27379446,27379907:27379921,27380372:27380396,27380848:27380897,27381440:27381454,27382455:27382469,27382890:27382942,27384322:27384329,27384680:27384687,27384953:27384975,27385199:27385221,27385566:27385621,27385977:27385986,27386362:27386404,27386738:27386758,27387203:27387277,27387984:27388020,27389340:27389385,27390105:27390132,27390791:27390842,27391355:27391366,27392176:27392215,27394659:27394676,27395242:27395264,27395913:27395931,27396429:27396466,27397076:27397099,27398369:27398450,27399974:27399989,27400780:27400847,27401557:27401584,27403901:27403920,27404296:27404331,27404682:27404699,27405147:27405162,27405885:27405896,27407294:27407330,27407854:27407915,27408403:27408452,27410197:27410226,27410821:27410845,27411483:27411512,27412214:27412219,27413207:27413215,27413745:27413775,27414258:27414305,27415415:27415456,27415818:27415861,27416157:27416159,27416890:2741692', 'assoc_mat': '27375839:plastique:3726:27375886,27376525:plastique:3726:27376531,27376906:plastique:3726:27376935,27377191:plastique:3726:27377203,27378456:plastique:3726:27378467,27378717:plastique:3726:27378739,27378994:plastique:3726:27379014,27379410:plastique:3726:27379446,27379907:plastique:3726:27379921,27380372:plastique:3726:27380396,27380848:plastique:3726:27380897,27381440:plastique:3726:27381454,27382455:plastique:3726:27382469,27382890:plastique:3726:27382942,27384322:plastique:3726:27384329,27384680:plastique:3726:27384687,27384953:plastique:3726:27384975,27385199:plastique:3726:27385221,27385566:plastique:3726:27385621,27385977:plastique:3726:27385986,27386362:plastique:3726:27386404,27386738:plastique:3726:27386758,27387203:plastique:3726:27387277,27387984:plastique:3726:27388020,27389340:plastique:3726:27389385,27390105:plastique:3726:27390132,27390791:plastique:3726:27390842,27391355:plastique:3726:27391366,27392176:plastique:3726:27392215,27394659:plastique:3726:27394676,27395242:plastique:3726:27395264,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013530926557821022, 'nb_photo': 33955, 'list_port_cont': '27375890,27376530,27376939,27377201,27378471,27378733,27379017,27379423,27379913,27380394,27380903,27381461,27382007,27382468,27382950,27384334,27384697,27384970,27385214,27385626,27385993,27386407,27386753,27387276,27388003,27389378,27390122,27390834,27391365,27392204,27394672,27395272,27395926,27396467,27397093,27397691,27398446,27399537,27399992,27400841,27401591,27403930,27404328,27404703,27405163,27405425,27405897,27406447,27407341,27407907,27408449,27408966,27409740,27410233,27410841,27411515,27412228,27413217,27413783,27414319,27415327,27415451,27415863,27416162,27416924,27417178,27417991,27418376,27418832,27419333,27419751,27420246,27420802,27421288,27421963,27422647,27423614,27424094,27424699,27425171,27425508,27425931,27427284,27427596,27427899,27428385,27428647,27429142,27429528,27430077,27430534,27431018,27431452,27432855,27433053,27433384,27433522,27433812,27434100,27434416,27434808,27435315,27436091,27436960,27438560,27438755,27439203,27439896,27445660,27446606,27446785,27448465,27448776,2744906', 'assoc_port': '27375839:27375890,27376525:27376530,27376906:27376939,27377191:27377201,27378456:27378471,27378717:27378733,27378994:27379017,27379410:27379423,27379907:27379913,27380372:27380394,27380848:27380903,27381440:27381461,27381997:27382007,27382455:27382468,27382890:27382950,27384322:27384334,27384680:27384697,27384953:27384970,27385199:27385214,27385566:27385626,27385977:27385993,27386362:27386407,27386738:27386753,27387203:27387276,27387984:27388003,27389340:27389378,27390105:27390122,27390791:27390834,27391355:27391365,27392176:27392204,27394659:27394672,27395242:27395272,27395913:27395926,27396429:27396467,27397076:27397093,27397673:27397691,27398369:27398446,27399474:27399537,27399974:27399992,27400780:27400841,27401557:27401591,27403901:27403930,27404296:27404328,27404682:27404703,27405147:27405163,27405398:27405425,27405885:27405897,27406408:27406447,27407294:27407341,27407854:27407907,27408403:27408449,27408924:27408966,27409726:27409740,27410197:27410233,27410821:27410841,27411483:27411515,27412214:2741222', 'assoc_mat': '27375839:Teint_Dans_La_Masse:3726:27375890,27376525:Teint_Dans_La_Masse:3726:27376530,27376906:Teint_Dans_La_Masse:3726:27376939,27377191:Teint_Dans_La_Masse:3726:27377201,27378456:Teint_Dans_La_Masse:3726:27378471,27378717:Teint_Dans_La_Masse:3726:27378733,27378994:Teint_Dans_La_Masse:3726:27379017,27379410:Teint_Dans_La_Masse:3726:27379423,27379907:Teint_Dans_La_Masse:3726:27379913,27380372:Teint_Dans_La_Masse:3726:27380394,27380848:Teint_Dans_La_Masse:3726:27380903,27381440:Teint_Dans_La_Masse:3726:27381461,27381997:Teint_Dans_La_Masse:3726:27382007,27382455:Teint_Dans_La_Masse:3726:27382468,27382890:Teint_Dans_La_Masse:3726:27382950,27384322:Teint_Dans_La_Masse:3726:27384334,27384680:Teint_Dans_La_Masse:3726:27384697,27384953:Teint_Dans_La_Masse:3726:27384970,27385199:Teint_Dans_La_Masse:3726:27385214,27385566:Teint_Dans_La_Masse:3726:27385626,27385977:Teint_Dans_La_Masse:3726:27385993,27386362:Teint_Dans_La_Masse:3726:27386407,27386738:Teint_Dans_La_Masse:3726:27386753,27387203: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(2387417,2394823,2402241,2404355,2414581,2415055,2425187,2432375,2438295,2442311,2451969,2459539,2467957,2470193,2475369,2507303,2507313,2507411,2507283,2507249,2507317,2507329,2507345,2507389,2507231,2507307,2507387)); 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-10-01' and date <= '2025-10-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((68048,),), 'unwanted_material_monthly_percentage': ((0.051427836777828764,),), 'material_repartition': (('JRM', 54074),), 'material_dict': {'JRM': 54074}, 'coverage_data': (('2025/10/31/', 0.978646), ('2025/10/30/', 0.977673), ('2025/10/29/', 0.980972), ('2025/10/28/', 0.977257), ('2025/10/27/', 0.980614), ('2025/10/25/', 1.0), ('2025/10/24/', 0.979375), ('2025/10/23/', 0.977511), ('2025/10/18/', 0.980888), ('2025/10/17/', 0.97721), ('2025/10/16/', 0.979606), ('2025/10/15/', 0.978703), ('2025/10/14/', 0.976447), ('2025/10/13/', 0.981652), ('2025/10/11/', 1.0), ('2025/10/10/', 0.977234), ('2025/10/09/', 0.979896), ('2025/10/08/', 0.981203), ('2025/10/07/', 0.97743), ('2025/10/06/', 0.980716), ('2025/10/04/', 1.0), ('2025/10/03/', 0.977176), ('2025/10/02/', 0.979317), ('2025/10/01/', 0.980833)), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.05851921608378556, 33), (datetime.date(2025, 10, 2), 0.052971674626357705, 35), (datetime.date(2025, 10, 3), 0.04959388385031098, 75), (datetime.date(2025, 10, 4), 0.06701871799066046, 13), (datetime.date(2025, 10, 6), 0.04738186162197439, 39), (datetime.date(2025, 10, 7), 0.051233647792161635, 10), (datetime.date(2025, 10, 8), 0.05312139379879506, 11), (datetime.date(2025, 10, 9), 0.047942870743609346, 72), (datetime.date(2025, 10, 10), 0.048554768245940884, 69), (datetime.date(2025, 10, 11), 0.05223680779472603, 8), (datetime.date(2025, 10, 13), 0.05178131352835013, 31), (datetime.date(2025, 10, 14), 0.052935293099044635, 8), (datetime.date(2025, 10, 15), 0.05024224079621961, 15), (datetime.date(2025, 10, 16), 0.047152172453492146, 66), (datetime.date(2025, 10, 17), 0.04680425679887462, 67), (datetime.date(2025, 10, 18), 0.09190434322411113, 14), (datetime.date(2025, 10, 20), 0.04798512433369648, 63), (datetime.date(2025, 10, 21), 0.048994717234631086, 15), (datetime.date(2025, 10, 22), 0.04840942886392968, 77), (datetime.date(2025, 10, 23), 0.05443230067577676, 73), (datetime.date(2025, 10, 24), 0.05008451504732276, 62), (datetime.date(2025, 10, 25), 0.05160837459849461, 9), (datetime.date(2025, 10, 27), 0.05162769682812121, 34), (datetime.date(2025, 10, 28), 0.050642663840710714, 9), (datetime.date(2025, 10, 29), 0.05178025075517126, 69), (datetime.date(2025, 10, 30), 0.056685537512348276, 64), (datetime.date(2025, 10, 31), 0.06136278964841047, 68)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 10, 1), 0.05851921608378556, 33), (datetime.date(2025, 10, 2), 0.052971674626357705, 35), (datetime.date(2025, 10, 3), 0.04959388385031098, 75), (datetime.date(2025, 10, 4), 0.06701871799066046, 13), (datetime.date(2025, 10, 6), 0.04738186162197439, 39), (datetime.date(2025, 10, 7), 0.051233647792161635, 10), (datetime.date(2025, 10, 8), 0.05312139379879506, 11), (datetime.date(2025, 10, 9), 0.047942870743609346, 72), (datetime.date(2025, 10, 10), 0.048554768245940884, 69), (datetime.date(2025, 10, 11), 0.05223680779472603, 8), (datetime.date(2025, 10, 13), 0.05178131352835013, 31), (datetime.date(2025, 10, 14), 0.052935293099044635, 8), (datetime.date(2025, 10, 15), 0.05024224079621961, 15), (datetime.date(2025, 10, 16), 0.047152172453492146, 66), (datetime.date(2025, 10, 17), 0.04680425679887462, 67), (datetime.date(2025, 10, 18), 0.09190434322411113, 14), (datetime.date(2025, 10, 20), 0.04798512433369648, 63), (datetime.date(2025, 10, 21), 0.048994717234631086, 15), (datetime.date(2025, 10, 22), 0.04840942886392968, 77), (datetime.date(2025, 10, 23), 0.05443230067577676, 73), (datetime.date(2025, 10, 24), 0.05008451504732276, 62), (datetime.date(2025, 10, 25), 0.05160837459849461, 9), (datetime.date(2025, 10, 27), 0.05162769682812121, 34), (datetime.date(2025, 10, 28), 0.050642663840710714, 9), (datetime.date(2025, 10, 29), 0.05178025075517126, 69), (datetime.date(2025, 10, 30), 0.056685537512348276, 64), (datetime.date(2025, 10, 31), 0.06136278964841047, 68))}, 'quality_array': [['-4.585875217279491', '01102025'], ['-4.7755453074268495', '02102025'], ['-4.6496431544048', '03102025'], ['-4.618913358049369', '04102025'], ['-4.459701870966963', '06102025'], ['-4.657856360546822', '07102025'], ['-4.47242770071129', '08102025'], ['-4.542679873544522', '09102025'], ['-4.653846465828635', '10102025'], ['-4.501929944883979', '11102025'], ['-4.703000400364968', '13102025'], ['-4.659908064902947', '14102025'], ['-4.565948022111064', '15102025'], ['-4.539520465722869', '16102025'], ['-4.6072593839702405', '17102025'], ['-4.690678161808121', '18102025'], ['-4.641222830324388', '20102025'], ['-4.550583390277352', '21102025'], ['-4.589298726801789', '22102025'], ['-4.678145318945483', '23102025'], ['-4.737544057229843', '24102025'], ['-3.9111660238580215', '25102025'], ['-4.603153857541802', '27102025'], ['-4.6058330844061235', '28102025'], ['-4.729411660432481', '29102025'], ['-4.553997808697478', '30102025'], ['-4.666340281479', '31102025']], 'number_of_batch': ((1605,),), 'datou_id_sts': 4878, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004511838530692392, 'nb_photo': 11814, 'list_port_cont': '27375888,27376535,27376928,27377204,27378464,27378729,27379011,27379422,27379918,27380391,27380894,27381459,27382004,27382466,27382947,27384339,27384688,27384969,27385213,27385620,27385983,27386412,27386761,27387270,27388002,27390125,27390840,27391372,27392212,27394673,27395267,27395927,27396470,27397100,27397689,27398449,27399532,27399997,27400849,27401588,27403924,27404325,27404694,27405159,27405434,27405893,27406444,27407333,27407905,27408450,27408964,27409741,27410230,27410837,27411509,27412221,27413221,27413782,27414325,27415324,27415454,27415864,27416158,27416925,27417180,27418815,27419324,27419736,27420247,27420797,27421281,27421967,27422651,27423613,27424100,27425170,27425509,27425932,27427285,27427598,27427897,27428646,27429153,27429530,27430073,27430535,27431020,27431453,27432845,27433388,27433519,27433814,27434092,27434409,27434809,27435304,27436090,27436963,27438555,27438749,27439202,27439892,27445664,27446788,27448464,27448778,27449069,27449491,27450057,27451100,27451633,27451890,27452370,2745270', 'assoc_port': '27375839:27375888,27376525:27376535,27376906:27376928,27377191:27377204,27378456:27378464,27378717:27378729,27378994:27379011,27379410:27379422,27379907:27379918,27380372:27380391,27380848:27380894,27381440:27381459,27381997:27382004,27382455:27382466,27382890:27382947,27384322:27384339,27384680:27384688,27384953:27384969,27385199:27385213,27385566:27385620,27385977:27385983,27386362:27386412,27386738:27386761,27387203:27387270,27387984:27388002,27390105:27390125,27390791:27390840,27391355:27391372,27392176:27392212,27394659:27394673,27395242:27395267,27395913:27395927,27396429:27396470,27397076:27397100,27397673:27397689,27398369:27398449,27399474:27399532,27399974:27399997,27400780:27400849,27401557:27401588,27403901:27403924,27404296:27404325,27404682:27404694,27405147:27405159,27405398:27405434,27405885:27405893,27406408:27406444,27407294:27407333,27407854:27407905,27408403:27408450,27408924:27408964,27409726:27409741,27410197:27410230,27410821:27410837,27411483:27411509,27412214:27412221,27413207:2741322', 'assoc_mat': '27375839:autre_refus:3726:27375888,27376525:autre_refus:3726:27376535,27376906:autre_refus:3726:27376928,27377191:autre_refus:3726:27377204,27378456:autre_refus:3726:27378464,27378717:autre_refus:3726:27378729,27378994:autre_refus:3726:27379011,27379410:autre_refus:3726:27379422,27379907:autre_refus:3726:27379918,27380372:autre_refus:3726:27380391,27380848:autre_refus:3726:27380894,27381440:autre_refus:3726:27381459,27381997:autre_refus:3726:27382004,27382455:autre_refus:3726:27382466,27382890:autre_refus:3726:27382947,27384322:autre_refus:3726:27384339,27384680:autre_refus:3726:27384688,27384953:autre_refus:3726:27384969,27385199:autre_refus:3726:27385213,27385566:autre_refus:3726:27385620,27385977:autre_refus:3726:27385983,27386362:autre_refus:3726:27386412,27386738:autre_refus:3726:27386761,27387203:autre_refus:3726:27387270,27387984:autre_refus:3726:27388002,27390105:autre_refus:3726:27390125,27390791:autre_refus:3726:27390840,27391355:autre_refus:3726:27391372,27392176:autre_refus:3726:27392212,27394659:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004555915041451907, 'nb_photo': 19235, 'list_port_cont': '27375885,27376528,27376929,27377202,27378468,27378737,27379016,27379445,27379917,27380403,27380896,27381463,27382005,27382464,27382945,27384337,27384693,27384971,27385215,27385618,27385987,27386405,27386760,27387274,27388019,27389382,27390121,27390838,27391374,27392205,27394668,27395266,27395925,27396476,27397095,27397688,27398457,27399995,27400844,27401582,27403929,27404329,27404695,27405155,27405430,27406452,27407335,27407908,27408454,27408961,27409738,27410231,27410846,27411514,27412227,27413219,27413776,27414304,27415326,27415457,27415854,27416167,27416918,27417172,27418378,27418836,27419327,27419734,27420243,27420805,27421287,27421973,27422639,27423618,27424098,27424704,27425169,27425505,27425935,27427288,27427594,27427903,27428386,27428645,27429152,27429529,27430071,27430533,27431022,27431450,27433056,27433385,27433524,27433811,27434097,27434417,27434800,27435306,27436093,27436954,27438552,27438748,27439200,27439895,27446605,27446782,27448461,27448780,27449078,27449493,27450059,27451108,27451630,2745188', 'assoc_port': '27375839:27375885,27376525:27376528,27376906:27376929,27377191:27377202,27378456:27378468,27378717:27378737,27378994:27379016,27379410:27379445,27379907:27379917,27380372:27380403,27380848:27380896,27381440:27381463,27381997:27382005,27382455:27382464,27382890:27382945,27384322:27384337,27384680:27384693,27384953:27384971,27385199:27385215,27385566:27385618,27385977:27385987,27386362:27386405,27386738:27386760,27387203:27387274,27387984:27388019,27389340:27389382,27390105:27390121,27390791:27390838,27391355:27391374,27392176:27392205,27394659:27394668,27395242:27395266,27395913:27395925,27396429:27396476,27397076:27397095,27397673:27397688,27398369:27398457,27399974:27399995,27400780:27400844,27401557:27401582,27403901:27403929,27404296:27404329,27404682:27404695,27405147:27405155,27405398:27405430,27406408:27406452,27407294:27407335,27407854:27407908,27408403:27408454,27408924:27408961,27409726:27409738,27410197:27410231,27410821:27410846,27411483:27411514,27412214:27412227,27413207:27413219,27413745:2741377', 'assoc_mat': '27375839:cartonnette:3726:27375885,27376525:cartonnette:3726:27376528,27376906:cartonnette:3726:27376929,27377191:cartonnette:3726:27377202,27378456:cartonnette:3726:27378468,27378717:cartonnette:3726:27378737,27378994:cartonnette:3726:27379016,27379410:cartonnette:3726:27379445,27379907:cartonnette:3726:27379917,27380372:cartonnette:3726:27380403,27380848:cartonnette:3726:27380896,27381440:cartonnette:3726:27381463,27381997:cartonnette:3726:27382005,27382455:cartonnette:3726:27382464,27382890:cartonnette:3726:27382945,27384322:cartonnette:3726:27384337,27384680:cartonnette:3726:27384693,27384953:cartonnette:3726:27384971,27385199:cartonnette:3726:27385215,27385566:cartonnette:3726:27385618,27385977:cartonnette:3726:27385987,27386362:cartonnette:3726:27386405,27386738:cartonnette:3726:27386760,27387203:cartonnette:3726:27387274,27387984:cartonnette:3726:27388019,27389340:cartonnette:3726:27389382,27390105:cartonnette:3726:27390121,27390791:cartonnette:3726:27390838,27391355:cartonnette:3726:27391374,27392176:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016667638804075423, 'nb_photo': 19501, 'list_port_cont': '27375884,27376534,27376930,27377199,27378470,27378740,27379015,27379440,27379919,27380398,27380904,27381455,27382009,27382470,27382941,27384333,27384692,27384972,27385222,27385622,27385991,27386401,27386756,27387269,27388025,27389380,27390123,27390835,27391370,27392206,27394674,27395262,27395935,27396475,27397091,27397683,27398454,27399999,27400845,27401581,27403922,27404323,27404702,27405153,27405433,27405901,27406449,27407338,27407914,27408453,27408965,27409742,27410229,27410838,27411513,27412225,27413223,27413773,27414316,27415333,27415455,27415856,27416165,27416922,27417173,27417995,27418370,27418838,27419323,27419732,27420237,27420800,27421278,27421966,27422682,27424104,27424702,27425165,27425511,27425938,27427907,27428376,27428644,27429145,27429524,27430070,27430540,27431026,27431448,27432849,27433048,27433379,27433523,27433813,27434101,27434406,27434802,27435312,27436097,27438745,27439207,27439903,27445661,27446611,27446787,27448460,27448777,27449079,27449502,27450051,27451104,27451632,27451893,2745236', 'assoc_port': '27375839:27375884,27376525:27376534,27376906:27376930,27377191:27377199,27378456:27378470,27378717:27378740,27378994:27379015,27379410:27379440,27379907:27379919,27380372:27380398,27380848:27380904,27381440:27381455,27381997:27382009,27382455:27382470,27382890:27382941,27384322:27384333,27384680:27384692,27384953:27384972,27385199:27385222,27385566:27385622,27385977:27385991,27386362:27386401,27386738:27386756,27387203:27387269,27387984:27388025,27389340:27389380,27390105:27390123,27390791:27390835,27391355:27391370,27392176:27392206,27394659:27394674,27395242:27395262,27395913:27395935,27396429:27396475,27397076:27397091,27397673:27397683,27398369:27398454,27399974:27399999,27400780:27400845,27401557:27401581,27403901:27403922,27404296:27404323,27404682:27404702,27405147:27405153,27405398:27405433,27405885:27405901,27406408:27406449,27407294:27407338,27407854:27407914,27408403:27408453,27408924:27408965,27409726:27409742,27410197:27410229,27410821:27410838,27411483:27411513,27412214:27412225,27413207:2741322', 'assoc_mat': '27375839:Carton_brun:3726:27375884,27376525:Carton_brun:3726:27376534,27376906:Carton_brun:3726:27376930,27377191:Carton_brun:3726:27377199,27378456:Carton_brun:3726:27378470,27378717:Carton_brun:3726:27378740,27378994:Carton_brun:3726:27379015,27379410:Carton_brun:3726:27379440,27379907:Carton_brun:3726:27379919,27380372:Carton_brun:3726:27380398,27380848:Carton_brun:3726:27380904,27381440:Carton_brun:3726:27381455,27381997:Carton_brun:3726:27382009,27382455:Carton_brun:3726:27382470,27382890:Carton_brun:3726:27382941,27384322:Carton_brun:3726:27384333,27384680:Carton_brun:3726:27384692,27384953:Carton_brun:3726:27384972,27385199:Carton_brun:3726:27385222,27385566:Carton_brun:3726:27385622,27385977:Carton_brun:3726:27385991,27386362:Carton_brun:3726:27386401,27386738:Carton_brun:3726:27386756,27387203:Carton_brun:3726:27387269,27387984:Carton_brun:3726:27388025,27389340:Carton_brun:3726:27389380,27390105:Carton_brun:3726:27390123,27390791:Carton_brun:3726:27390835,27391355:Carton_brun:3726:27391370,27392176:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009253308283522933, 'nb_photo': 19989, 'list_port_cont': '27375889,27376529,27376931,27377200,27378462,27378731,27379006,27379439,27379912,27380399,27380895,27381451,27382013,27382471,27382943,27384336,27384696,27384967,27385220,27385623,27385992,27386406,27386751,27387272,27388023,27388804,27389383,27390126,27390839,27391371,27392207,27394677,27395271,27395934,27396469,27397094,27397682,27398455,27399536,27399990,27400839,27401592,27403919,27404332,27404705,27405160,27405429,27405894,27406443,27407337,27407904,27408447,27409734,27410232,27410836,27411510,27412230,27413220,27413778,27414321,27415447,27415857,27416164,27416919,27417169,27417990,27418374,27418816,27419326,27419735,27420244,27420801,27421284,27421972,27422658,27424103,27424696,27425161,27425510,27425937,27427281,27427599,27427898,27428379,27428650,27429144,27429525,27430074,27430532,27431021,27431449,27432850,27433046,27433377,27433521,27433810,27434096,27434412,27434803,27435310,27436089,27436959,27438554,27438752,27439206,27439893,27445668,27446608,27446792,27448773,27449077,27449500,27450050,2745110', 'assoc_port': '27375839:27375889,27376525:27376529,27376906:27376931,27377191:27377200,27378456:27378462,27378717:27378731,27378994:27379006,27379410:27379439,27379907:27379912,27380372:27380399,27380848:27380895,27381440:27381451,27381997:27382013,27382455:27382471,27382890:27382943,27384322:27384336,27384680:27384696,27384953:27384967,27385199:27385220,27385566:27385623,27385977:27385992,27386362:27386406,27386738:27386751,27387203:27387272,27387984:27388023,27388759:27388804,27389340:27389383,27390105:27390126,27390791:27390839,27391355:27391371,27392176:27392207,27394659:27394677,27395242:27395271,27395913:27395934,27396429:27396469,27397076:27397094,27397673:27397682,27398369:27398455,27399474:27399536,27399974:27399990,27400780:27400839,27401557:27401592,27403901:27403919,27404296:27404332,27404682:27404705,27405147:27405160,27405398:27405429,27405885:27405894,27406408:27406443,27407294:27407337,27407854:27407904,27408403:27408447,27409726:27409734,27410197:27410232,27410821:27410836,27411483:27411510,27412214:2741223', 'assoc_mat': '27375839:Carton_gris:3726:27375889,27376525:Carton_gris:3726:27376529,27376906:Carton_gris:3726:27376931,27377191:Carton_gris:3726:27377200,27378456:Carton_gris:3726:27378462,27378717:Carton_gris:3726:27378731,27378994:Carton_gris:3726:27379006,27379410:Carton_gris:3726:27379439,27379907:Carton_gris:3726:27379912,27380372:Carton_gris:3726:27380399,27380848:Carton_gris:3726:27380895,27381440:Carton_gris:3726:27381451,27381997:Carton_gris:3726:27382013,27382455:Carton_gris:3726:27382471,27382890:Carton_gris:3726:27382943,27384322:Carton_gris:3726:27384336,27384680:Carton_gris:3726:27384696,27384953:Carton_gris:3726:27384967,27385199:Carton_gris:3726:27385220,27385566:Carton_gris:3726:27385623,27385977:Carton_gris:3726:27385992,27386362:Carton_gris:3726:27386406,27386738:Carton_gris:3726:27386751,27387203:Carton_gris:3726:27387272,27387984:Carton_gris:3726:27388023,27388759:Carton_gris:3726:27388804,27389340:Carton_gris:3726:27389383,27390105:Carton_gris:3726:27390126,27390791:Carton_gris:3726:27390839,27391355:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00201129286569613, 'nb_photo': 3037, 'list_port_cont': '27376536,27377198,27378463,27379920,27380900,27381458,27382462,27382952,27384686,27384974,27385216,27385624,27385994,27386755,27387279,27389381,27390836,27391364,27392209,27394669,27395928,27396473,27397096,27398447,27399993,27400843,27403925,27404330,27405154,27405428,27406453,27407916,27410835,27412224,27413222,27413780,27414322,27415855,27416169,27416921,27417176,27418380,27418817,27419328,27419731,27420245,27420803,27421282,27422676,27424695,27425167,27425507,27425933,27427592,27427900,27429147,27430075,27430530,27431027,27433054,27433807,27436096,27438753,27439208,27439901,27446601,27448774,27449496,27451623,27451889,27452373,27452700,27453315,27453935,27454529,27455060,27461028,27461802,27464300,27464970,27466539,27467027,27467621,27468502,27469014,27470848,27471446,27472908,27474249,27475819,27476534,27478055,27481058,27481901,27483139,27483737,27486714,27489611,27490358,27490870,27491457,27491996,27493268,27493918,27494648,27495913,27496425,27497893,27498545,27498888,27499156,27499515,27500388,2750194', 'assoc_port': '27376525:27376536,27377191:27377198,27378456:27378463,27379907:27379920,27380848:27380900,27381440:27381458,27382455:27382462,27382890:27382952,27384680:27384686,27384953:27384974,27385199:27385216,27385566:27385624,27385977:27385994,27386738:27386755,27387203:27387279,27389340:27389381,27390791:27390836,27391355:27391364,27392176:27392209,27394659:27394669,27395913:27395928,27396429:27396473,27397076:27397096,27398369:27398447,27399974:27399993,27400780:27400843,27403901:27403925,27404296:27404330,27405147:27405154,27405398:27405428,27406408:27406453,27407854:27407916,27410821:27410835,27412214:27412224,27413207:27413222,27413745:27413780,27414258:27414322,27415818:27415855,27416157:27416169,27416890:27416921,27417155:27417176,27418346:27418380,27418801:27418817,27419316:27419328,27419706:27419731,27420225:27420245,27420770:27420803,27421265:27421282,27422618:27422676,27424686:27424695,27425124:27425167,27425471:27425507,27425856:27425933,27427585:27427592,27427882:27427900,27429102:27429147,27430058:2743007', 'assoc_mat': '27376525:kraft:3726:27376536,27377191:kraft:3726:27377198,27378456:kraft:3726:27378463,27379907:kraft:3726:27379920,27380848:kraft:3726:27380900,27381440:kraft:3726:27381458,27382455:kraft:3726:27382462,27382890:kraft:3726:27382952,27384680:kraft:3726:27384686,27384953:kraft:3726:27384974,27385199:kraft:3726:27385216,27385566:kraft:3726:27385624,27385977:kraft:3726:27385994,27386738:kraft:3726:27386755,27387203:kraft:3726:27387279,27389340:kraft:3726:27389381,27390791:kraft:3726:27390836,27391355:kraft:3726:27391364,27392176:kraft:3726:27392209,27394659:kraft:3726:27394669,27395913:kraft:3726:27395928,27396429:kraft:3726:27396473,27397076:kraft:3726:27397096,27398369:kraft:3726:27398447,27399974:kraft:3726:27399993,27400780:kraft:3726:27400843,27403901:kraft:3726:27403925,27404296:kraft:3726:27404330,27405147:kraft:3726:27405154,27405398:kraft:3726:27405428,27406408:kraft:3726:27406453,27407854:kraft:3726:27407916,27410821:kraft:3726:27410835,27412214:kraft:3726:27412224,27413207:kraft:3726:27413222,27413745:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0007688136975636337, 'nb_photo': 883, 'list_port_cont': '27377206,27378473,27381456,27382463,27382948,27384335,27384976,27390837,27398452,27404700,27405431,27413214,27420248,27421974,27424097,27427908,27430079,27433047,27434090,27434405,27436092,27450055,27451626,27456910,27458954,27460492,27461799,27462767,27464294,27464962,27465551,27470604,27471984,27472397,27474248,27475820,27476529,27478059,27482531,27485124,27490355,27490864,27492603,27493272,27493909,27495912,27497036,27498889,27499155,27500386,27501207,27501526,27502491,27504302,27505609,27506065,27508714,27509233,27510114,27510923,27519696,27520089,27520435,27520877,27522425,27522988,27524642,27526200,27526533,27528228,27529008,27533221,27534128,27535491,27537243,27537660,27539739,27540153,27540351,27540804,27541703,27542342,27544810,27547374,27548617,27548841,27548993,27549456,27552107,27552940,27553269,27553634,27555390,27555868,27564471,27564984,27565378,27570641,27571869,27572108,27573675,27573866,27575476,27575989,27576448,27577529,27580916,27582371,27584510,27585630,27592157,27596748,27597974,2759883', 'assoc_port': '27377191:27377206,27378456:27378473,27381440:27381456,27382455:27382463,27382890:27382948,27384322:27384335,27384953:27384976,27390791:27390837,27398369:27398452,27404682:27404700,27405398:27405431,27413207:27413214,27420225:27420248,27421942:27421974,27424087:27424097,27427882:27427908,27430058:27430079,27433044:27433047,27434083:27434090,27434369:27434405,27436023:27436092,27450035:27450055,27451540:27451626,27456890:27456910,27458863:27458954,27460478:27460492,27461682:27461799,27462676:27462767,27464289:27464294,27464951:27464962,27465533:27465551,27470593:27470604,27471962:27471984,27472372:27472397,27474194:27474248,27475805:27475820,27476483:27476529,27478030:27478059,27482504:27482531,27485107:27485124,27490309:27490355,27490848:27490864,27492533:27492603,27493243:27493272,27493854:27493909,27495873:27495912,27496981:27497036,27498848:27498889,27499115:27499155,27500341:27500386,27501189:27501207,27501488:27501526,27502478:27502491,27504290:27504302,27505585:27505609,27506043:27506065,27508709:2750871', 'assoc_mat': '27377191:metal:3726:27377206,27378456:metal:3726:27378473,27381440:metal:3726:27381456,27382455:metal:3726:27382463,27382890:metal:3726:27382948,27384322:metal:3726:27384335,27384953:metal:3726:27384976,27390791:metal:3726:27390837,27398369:metal:3726:27398452,27404682:metal:3726:27404700,27405398:metal:3726:27405431,27413207:metal:3726:27413214,27420225:metal:3726:27420248,27421942:metal:3726:27421974,27424087:metal:3726:27424097,27427882:metal:3726:27427908,27430058:metal:3726:27430079,27433044:metal:3726:27433047,27434083:metal:3726:27434090,27434369:metal:3726:27434405,27436023:metal:3726:27436092,27450035:metal:3726:27450055,27451540:metal:3726:27451626,27456890:metal:3726:27456910,27458863:metal:3726:27458954,27460478:metal:3726:27460492,27461682:metal:3726:27461799,27462676:metal:3726:27462767,27464289:metal:3726:27464294,27464951:metal:3726:27464962,27465533:metal:3726:27465551,27470593:metal:3726:27470604,27471962:metal:3726:27471984,27472372:metal:3726:27472397,27474194:metal:3726:27474248,27475805:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.003967865270665909, 'nb_photo': 12715, 'list_port_cont': '27375886,27376531,27376935,27377203,27378467,27378739,27379014,27379446,27379921,27380396,27380897,27381454,27382469,27382942,27384329,27384687,27384975,27385221,27385621,27385986,27386404,27386758,27387277,27388020,27389385,27390132,27390842,27391366,27392215,27394676,27395264,27395931,27396466,27397099,27398450,27399989,27400847,27401584,27403920,27404331,27404699,27405162,27405896,27407330,27407915,27408452,27410226,27410845,27411512,27412219,27413215,27413775,27414305,27415456,27415861,27416159,27416927,27417170,27418377,27418834,27419332,27419737,27420239,27420796,27421286,27421970,27422678,27423616,27424093,27424697,27425164,27425502,27425930,27427287,27428643,27429150,27429518,27430537,27431028,27431451,27432848,27433050,27433381,27433808,27434094,27434410,27434807,27435303,27436099,27436965,27438754,27439209,27439899,27445659,27446610,27446784,27448462,27448771,27449073,27449492,27450056,27451110,27451624,27451895,27452376,27452704,27453310,27453939,27454522,27455076,27455819,27456394,27456900,2745866', 'assoc_port': '27375839:27375886,27376525:27376531,27376906:27376935,27377191:27377203,27378456:27378467,27378717:27378739,27378994:27379014,27379410:27379446,27379907:27379921,27380372:27380396,27380848:27380897,27381440:27381454,27382455:27382469,27382890:27382942,27384322:27384329,27384680:27384687,27384953:27384975,27385199:27385221,27385566:27385621,27385977:27385986,27386362:27386404,27386738:27386758,27387203:27387277,27387984:27388020,27389340:27389385,27390105:27390132,27390791:27390842,27391355:27391366,27392176:27392215,27394659:27394676,27395242:27395264,27395913:27395931,27396429:27396466,27397076:27397099,27398369:27398450,27399974:27399989,27400780:27400847,27401557:27401584,27403901:27403920,27404296:27404331,27404682:27404699,27405147:27405162,27405885:27405896,27407294:27407330,27407854:27407915,27408403:27408452,27410197:27410226,27410821:27410845,27411483:27411512,27412214:27412219,27413207:27413215,27413745:27413775,27414258:27414305,27415415:27415456,27415818:27415861,27416157:27416159,27416890:2741692', 'assoc_mat': '27375839:plastique:3726:27375886,27376525:plastique:3726:27376531,27376906:plastique:3726:27376935,27377191:plastique:3726:27377203,27378456:plastique:3726:27378467,27378717:plastique:3726:27378739,27378994:plastique:3726:27379014,27379410:plastique:3726:27379446,27379907:plastique:3726:27379921,27380372:plastique:3726:27380396,27380848:plastique:3726:27380897,27381440:plastique:3726:27381454,27382455:plastique:3726:27382469,27382890:plastique:3726:27382942,27384322:plastique:3726:27384329,27384680:plastique:3726:27384687,27384953:plastique:3726:27384975,27385199:plastique:3726:27385221,27385566:plastique:3726:27385621,27385977:plastique:3726:27385986,27386362:plastique:3726:27386404,27386738:plastique:3726:27386758,27387203:plastique:3726:27387277,27387984:plastique:3726:27388020,27389340:plastique:3726:27389385,27390105:plastique:3726:27390132,27390791:plastique:3726:27390842,27391355:plastique:3726:27391366,27392176:plastique:3726:27392215,27394659:plastique:3726:27394676,27395242:plastique:3726:27395264,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013530926557821022, 'nb_photo': 33955, 'list_port_cont': '27375890,27376530,27376939,27377201,27378471,27378733,27379017,27379423,27379913,27380394,27380903,27381461,27382007,27382468,27382950,27384334,27384697,27384970,27385214,27385626,27385993,27386407,27386753,27387276,27388003,27389378,27390122,27390834,27391365,27392204,27394672,27395272,27395926,27396467,27397093,27397691,27398446,27399537,27399992,27400841,27401591,27403930,27404328,27404703,27405163,27405425,27405897,27406447,27407341,27407907,27408449,27408966,27409740,27410233,27410841,27411515,27412228,27413217,27413783,27414319,27415327,27415451,27415863,27416162,27416924,27417178,27417991,27418376,27418832,27419333,27419751,27420246,27420802,27421288,27421963,27422647,27423614,27424094,27424699,27425171,27425508,27425931,27427284,27427596,27427899,27428385,27428647,27429142,27429528,27430077,27430534,27431018,27431452,27432855,27433053,27433384,27433522,27433812,27434100,27434416,27434808,27435315,27436091,27436960,27438560,27438755,27439203,27439896,27445660,27446606,27446785,27448465,27448776,2744906', 'assoc_port': '27375839:27375890,27376525:27376530,27376906:27376939,27377191:27377201,27378456:27378471,27378717:27378733,27378994:27379017,27379410:27379423,27379907:27379913,27380372:27380394,27380848:27380903,27381440:27381461,27381997:27382007,27382455:27382468,27382890:27382950,27384322:27384334,27384680:27384697,27384953:27384970,27385199:27385214,27385566:27385626,27385977:27385993,27386362:27386407,27386738:27386753,27387203:27387276,27387984:27388003,27389340:27389378,27390105:27390122,27390791:27390834,27391355:27391365,27392176:27392204,27394659:27394672,27395242:27395272,27395913:27395926,27396429:27396467,27397076:27397093,27397673:27397691,27398369:27398446,27399474:27399537,27399974:27399992,27400780:27400841,27401557:27401591,27403901:27403930,27404296:27404328,27404682:27404703,27405147:27405163,27405398:27405425,27405885:27405897,27406408:27406447,27407294:27407341,27407854:27407907,27408403:27408449,27408924:27408966,27409726:27409740,27410197:27410233,27410821:27410841,27411483:27411515,27412214:2741222', 'assoc_mat': '27375839:Teint_Dans_La_Masse:3726:27375890,27376525:Teint_Dans_La_Masse:3726:27376530,27376906:Teint_Dans_La_Masse:3726:27376939,27377191:Teint_Dans_La_Masse:3726:27377201,27378456:Teint_Dans_La_Masse:3726:27378471,27378717:Teint_Dans_La_Masse:3726:27378733,27378994:Teint_Dans_La_Masse:3726:27379017,27379410:Teint_Dans_La_Masse:3726:27379423,27379907:Teint_Dans_La_Masse:3726:27379913,27380372:Teint_Dans_La_Masse:3726:27380394,27380848:Teint_Dans_La_Masse:3726:27380903,27381440:Teint_Dans_La_Masse:3726:27381461,27381997:Teint_Dans_La_Masse:3726:27382007,27382455:Teint_Dans_La_Masse:3726:27382468,27382890:Teint_Dans_La_Masse:3726:27382950,27384322:Teint_Dans_La_Masse:3726:27384334,27384680:Teint_Dans_La_Masse:3726:27384697,27384953:Teint_Dans_La_Masse:3726:27384970,27385199:Teint_Dans_La_Masse:3726:27385214,27385566:Teint_Dans_La_Masse:3726:27385626,27385977:Teint_Dans_La_Masse:3726:27385993,27386362:Teint_Dans_La_Masse:3726:27386407,27386738:Teint_Dans_La_Masse:3726:27386753,27387203:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 95316}}, 'hostname': (('jetson-73',),), 'impurety_average_per_hashtag': [(('JRM', '2025-10', 0.051427836777828764),)]} 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': ((68048,),), 'unwanted_material_monthly_percentage': ((0.051427836777828764,),), 'material_repartition': (('JRM', 54074),), 'material_dict': {'JRM': 54074}, 'coverage_data': (('2025/10/31/', 0.978646), ('2025/10/30/', 0.977673), ('2025/10/29/', 0.980972), ('2025/10/28/', 0.977257), ('2025/10/27/', 0.980614), ('2025/10/25/', 1.0), ('2025/10/24/', 0.979375), ('2025/10/23/', 0.977511), ('2025/10/18/', 0.980888), ('2025/10/17/', 0.97721), ('2025/10/16/', 0.979606), ('2025/10/15/', 0.978703), ('2025/10/14/', 0.976447), ('2025/10/13/', 0.981652), ('2025/10/11/', 1.0), ('2025/10/10/', 0.977234), ('2025/10/09/', 0.979896), ('2025/10/08/', 0.981203), ('2025/10/07/', 0.97743), ('2025/10/06/', 0.980716), ('2025/10/04/', 1.0), ('2025/10/03/', 0.977176), ('2025/10/02/', 0.979317), ('2025/10/01/', 0.980833)), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.05851921608378556, 33), (datetime.date(2025, 10, 2), 0.052971674626357705, 35), (datetime.date(2025, 10, 3), 0.04959388385031098, 75), (datetime.date(2025, 10, 4), 0.06701871799066046, 13), (datetime.date(2025, 10, 6), 0.04738186162197439, 39), (datetime.date(2025, 10, 7), 0.051233647792161635, 10), (datetime.date(2025, 10, 8), 0.05312139379879506, 11), (datetime.date(2025, 10, 9), 0.047942870743609346, 72), (datetime.date(2025, 10, 10), 0.048554768245940884, 69), (datetime.date(2025, 10, 11), 0.05223680779472603, 8), (datetime.date(2025, 10, 13), 0.05178131352835013, 31), (datetime.date(2025, 10, 14), 0.052935293099044635, 8), (datetime.date(2025, 10, 15), 0.05024224079621961, 15), (datetime.date(2025, 10, 16), 0.047152172453492146, 66), (datetime.date(2025, 10, 17), 0.04680425679887462, 67), (datetime.date(2025, 10, 18), 0.09190434322411113, 14), (datetime.date(2025, 10, 20), 0.04798512433369648, 63), (datetime.date(2025, 10, 21), 0.048994717234631086, 15), (datetime.date(2025, 10, 22), 0.04840942886392968, 77), (datetime.date(2025, 10, 23), 0.05443230067577676, 73), (datetime.date(2025, 10, 24), 0.05008451504732276, 62), (datetime.date(2025, 10, 25), 0.05160837459849461, 9), (datetime.date(2025, 10, 27), 0.05162769682812121, 34), (datetime.date(2025, 10, 28), 0.050642663840710714, 9), (datetime.date(2025, 10, 29), 0.05178025075517126, 69), (datetime.date(2025, 10, 30), 0.056685537512348276, 64), (datetime.date(2025, 10, 31), 0.06136278964841047, 68)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 10, 1), 0.05851921608378556, 33), (datetime.date(2025, 10, 2), 0.052971674626357705, 35), (datetime.date(2025, 10, 3), 0.04959388385031098, 75), (datetime.date(2025, 10, 4), 0.06701871799066046, 13), (datetime.date(2025, 10, 6), 0.04738186162197439, 39), (datetime.date(2025, 10, 7), 0.051233647792161635, 10), (datetime.date(2025, 10, 8), 0.05312139379879506, 11), (datetime.date(2025, 10, 9), 0.047942870743609346, 72), (datetime.date(2025, 10, 10), 0.048554768245940884, 69), (datetime.date(2025, 10, 11), 0.05223680779472603, 8), (datetime.date(2025, 10, 13), 0.05178131352835013, 31), (datetime.date(2025, 10, 14), 0.052935293099044635, 8), (datetime.date(2025, 10, 15), 0.05024224079621961, 15), (datetime.date(2025, 10, 16), 0.047152172453492146, 66), (datetime.date(2025, 10, 17), 0.04680425679887462, 67), (datetime.date(2025, 10, 18), 0.09190434322411113, 14), (datetime.date(2025, 10, 20), 0.04798512433369648, 63), (datetime.date(2025, 10, 21), 0.048994717234631086, 15), (datetime.date(2025, 10, 22), 0.04840942886392968, 77), (datetime.date(2025, 10, 23), 0.05443230067577676, 73), (datetime.date(2025, 10, 24), 0.05008451504732276, 62), (datetime.date(2025, 10, 25), 0.05160837459849461, 9), (datetime.date(2025, 10, 27), 0.05162769682812121, 34), (datetime.date(2025, 10, 28), 0.050642663840710714, 9), (datetime.date(2025, 10, 29), 0.05178025075517126, 69), (datetime.date(2025, 10, 30), 0.056685537512348276, 64), (datetime.date(2025, 10, 31), 0.06136278964841047, 68))}, 'quality_array': [['-4.585875217279491', '01102025'], ['-4.7755453074268495', '02102025'], ['-4.6496431544048', '03102025'], ['-4.618913358049369', '04102025'], ['-4.459701870966963', '06102025'], ['-4.657856360546822', '07102025'], ['-4.47242770071129', '08102025'], ['-4.542679873544522', '09102025'], ['-4.653846465828635', '10102025'], ['-4.501929944883979', '11102025'], ['-4.703000400364968', '13102025'], ['-4.659908064902947', '14102025'], ['-4.565948022111064', '15102025'], ['-4.539520465722869', '16102025'], ['-4.6072593839702405', '17102025'], ['-4.690678161808121', '18102025'], ['-4.641222830324388', '20102025'], ['-4.550583390277352', '21102025'], ['-4.589298726801789', '22102025'], ['-4.678145318945483', '23102025'], ['-4.737544057229843', '24102025'], ['-3.9111660238580215', '25102025'], ['-4.603153857541802', '27102025'], ['-4.6058330844061235', '28102025'], ['-4.729411660432481', '29102025'], ['-4.553997808697478', '30102025'], ['-4.666340281479', '31102025']], 'number_of_batch': ((1605,),), 'datou_id_sts': 4878, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004511838530692392, 'nb_photo': 11814, 'list_port_cont': '27375888,27376535,27376928,27377204,27378464,27378729,27379011,27379422,27379918,27380391,27380894,27381459,27382004,27382466,27382947,27384339,27384688,27384969,27385213,27385620,27385983,27386412,27386761,27387270,27388002,27390125,27390840,27391372,27392212,27394673,27395267,27395927,27396470,27397100,27397689,27398449,27399532,27399997,27400849,27401588,27403924,27404325,27404694,27405159,27405434,27405893,27406444,27407333,27407905,27408450,27408964,27409741,27410230,27410837,27411509,27412221,27413221,27413782,27414325,27415324,27415454,27415864,27416158,27416925,27417180,27418815,27419324,27419736,27420247,27420797,27421281,27421967,27422651,27423613,27424100,27425170,27425509,27425932,27427285,27427598,27427897,27428646,27429153,27429530,27430073,27430535,27431020,27431453,27432845,27433388,27433519,27433814,27434092,27434409,27434809,27435304,27436090,27436963,27438555,27438749,27439202,27439892,27445664,27446788,27448464,27448778,27449069,27449491,27450057,27451100,27451633,27451890,27452370,2745270', 'assoc_port': '27375839:27375888,27376525:27376535,27376906:27376928,27377191:27377204,27378456:27378464,27378717:27378729,27378994:27379011,27379410:27379422,27379907:27379918,27380372:27380391,27380848:27380894,27381440:27381459,27381997:27382004,27382455:27382466,27382890:27382947,27384322:27384339,27384680:27384688,27384953:27384969,27385199:27385213,27385566:27385620,27385977:27385983,27386362:27386412,27386738:27386761,27387203:27387270,27387984:27388002,27390105:27390125,27390791:27390840,27391355:27391372,27392176:27392212,27394659:27394673,27395242:27395267,27395913:27395927,27396429:27396470,27397076:27397100,27397673:27397689,27398369:27398449,27399474:27399532,27399974:27399997,27400780:27400849,27401557:27401588,27403901:27403924,27404296:27404325,27404682:27404694,27405147:27405159,27405398:27405434,27405885:27405893,27406408:27406444,27407294:27407333,27407854:27407905,27408403:27408450,27408924:27408964,27409726:27409741,27410197:27410230,27410821:27410837,27411483:27411509,27412214:27412221,27413207:2741322', 'assoc_mat': '27375839:autre_refus:3726:27375888,27376525:autre_refus:3726:27376535,27376906:autre_refus:3726:27376928,27377191:autre_refus:3726:27377204,27378456:autre_refus:3726:27378464,27378717:autre_refus:3726:27378729,27378994:autre_refus:3726:27379011,27379410:autre_refus:3726:27379422,27379907:autre_refus:3726:27379918,27380372:autre_refus:3726:27380391,27380848:autre_refus:3726:27380894,27381440:autre_refus:3726:27381459,27381997:autre_refus:3726:27382004,27382455:autre_refus:3726:27382466,27382890:autre_refus:3726:27382947,27384322:autre_refus:3726:27384339,27384680:autre_refus:3726:27384688,27384953:autre_refus:3726:27384969,27385199:autre_refus:3726:27385213,27385566:autre_refus:3726:27385620,27385977:autre_refus:3726:27385983,27386362:autre_refus:3726:27386412,27386738:autre_refus:3726:27386761,27387203:autre_refus:3726:27387270,27387984:autre_refus:3726:27388002,27390105:autre_refus:3726:27390125,27390791:autre_refus:3726:27390840,27391355:autre_refus:3726:27391372,27392176:autre_refus:3726:27392212,27394659:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.004555915041451907, 'nb_photo': 19235, 'list_port_cont': '27375885,27376528,27376929,27377202,27378468,27378737,27379016,27379445,27379917,27380403,27380896,27381463,27382005,27382464,27382945,27384337,27384693,27384971,27385215,27385618,27385987,27386405,27386760,27387274,27388019,27389382,27390121,27390838,27391374,27392205,27394668,27395266,27395925,27396476,27397095,27397688,27398457,27399995,27400844,27401582,27403929,27404329,27404695,27405155,27405430,27406452,27407335,27407908,27408454,27408961,27409738,27410231,27410846,27411514,27412227,27413219,27413776,27414304,27415326,27415457,27415854,27416167,27416918,27417172,27418378,27418836,27419327,27419734,27420243,27420805,27421287,27421973,27422639,27423618,27424098,27424704,27425169,27425505,27425935,27427288,27427594,27427903,27428386,27428645,27429152,27429529,27430071,27430533,27431022,27431450,27433056,27433385,27433524,27433811,27434097,27434417,27434800,27435306,27436093,27436954,27438552,27438748,27439200,27439895,27446605,27446782,27448461,27448780,27449078,27449493,27450059,27451108,27451630,2745188', 'assoc_port': '27375839:27375885,27376525:27376528,27376906:27376929,27377191:27377202,27378456:27378468,27378717:27378737,27378994:27379016,27379410:27379445,27379907:27379917,27380372:27380403,27380848:27380896,27381440:27381463,27381997:27382005,27382455:27382464,27382890:27382945,27384322:27384337,27384680:27384693,27384953:27384971,27385199:27385215,27385566:27385618,27385977:27385987,27386362:27386405,27386738:27386760,27387203:27387274,27387984:27388019,27389340:27389382,27390105:27390121,27390791:27390838,27391355:27391374,27392176:27392205,27394659:27394668,27395242:27395266,27395913:27395925,27396429:27396476,27397076:27397095,27397673:27397688,27398369:27398457,27399974:27399995,27400780:27400844,27401557:27401582,27403901:27403929,27404296:27404329,27404682:27404695,27405147:27405155,27405398:27405430,27406408:27406452,27407294:27407335,27407854:27407908,27408403:27408454,27408924:27408961,27409726:27409738,27410197:27410231,27410821:27410846,27411483:27411514,27412214:27412227,27413207:27413219,27413745:2741377', 'assoc_mat': '27375839:cartonnette:3726:27375885,27376525:cartonnette:3726:27376528,27376906:cartonnette:3726:27376929,27377191:cartonnette:3726:27377202,27378456:cartonnette:3726:27378468,27378717:cartonnette:3726:27378737,27378994:cartonnette:3726:27379016,27379410:cartonnette:3726:27379445,27379907:cartonnette:3726:27379917,27380372:cartonnette:3726:27380403,27380848:cartonnette:3726:27380896,27381440:cartonnette:3726:27381463,27381997:cartonnette:3726:27382005,27382455:cartonnette:3726:27382464,27382890:cartonnette:3726:27382945,27384322:cartonnette:3726:27384337,27384680:cartonnette:3726:27384693,27384953:cartonnette:3726:27384971,27385199:cartonnette:3726:27385215,27385566:cartonnette:3726:27385618,27385977:cartonnette:3726:27385987,27386362:cartonnette:3726:27386405,27386738:cartonnette:3726:27386760,27387203:cartonnette:3726:27387274,27387984:cartonnette:3726:27388019,27389340:cartonnette:3726:27389382,27390105:cartonnette:3726:27390121,27390791:cartonnette:3726:27390838,27391355:cartonnette:3726:27391374,27392176:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.016667638804075423, 'nb_photo': 19501, 'list_port_cont': '27375884,27376534,27376930,27377199,27378470,27378740,27379015,27379440,27379919,27380398,27380904,27381455,27382009,27382470,27382941,27384333,27384692,27384972,27385222,27385622,27385991,27386401,27386756,27387269,27388025,27389380,27390123,27390835,27391370,27392206,27394674,27395262,27395935,27396475,27397091,27397683,27398454,27399999,27400845,27401581,27403922,27404323,27404702,27405153,27405433,27405901,27406449,27407338,27407914,27408453,27408965,27409742,27410229,27410838,27411513,27412225,27413223,27413773,27414316,27415333,27415455,27415856,27416165,27416922,27417173,27417995,27418370,27418838,27419323,27419732,27420237,27420800,27421278,27421966,27422682,27424104,27424702,27425165,27425511,27425938,27427907,27428376,27428644,27429145,27429524,27430070,27430540,27431026,27431448,27432849,27433048,27433379,27433523,27433813,27434101,27434406,27434802,27435312,27436097,27438745,27439207,27439903,27445661,27446611,27446787,27448460,27448777,27449079,27449502,27450051,27451104,27451632,27451893,2745236', 'assoc_port': '27375839:27375884,27376525:27376534,27376906:27376930,27377191:27377199,27378456:27378470,27378717:27378740,27378994:27379015,27379410:27379440,27379907:27379919,27380372:27380398,27380848:27380904,27381440:27381455,27381997:27382009,27382455:27382470,27382890:27382941,27384322:27384333,27384680:27384692,27384953:27384972,27385199:27385222,27385566:27385622,27385977:27385991,27386362:27386401,27386738:27386756,27387203:27387269,27387984:27388025,27389340:27389380,27390105:27390123,27390791:27390835,27391355:27391370,27392176:27392206,27394659:27394674,27395242:27395262,27395913:27395935,27396429:27396475,27397076:27397091,27397673:27397683,27398369:27398454,27399974:27399999,27400780:27400845,27401557:27401581,27403901:27403922,27404296:27404323,27404682:27404702,27405147:27405153,27405398:27405433,27405885:27405901,27406408:27406449,27407294:27407338,27407854:27407914,27408403:27408453,27408924:27408965,27409726:27409742,27410197:27410229,27410821:27410838,27411483:27411513,27412214:27412225,27413207:2741322', 'assoc_mat': '27375839:Carton_brun:3726:27375884,27376525:Carton_brun:3726:27376534,27376906:Carton_brun:3726:27376930,27377191:Carton_brun:3726:27377199,27378456:Carton_brun:3726:27378470,27378717:Carton_brun:3726:27378740,27378994:Carton_brun:3726:27379015,27379410:Carton_brun:3726:27379440,27379907:Carton_brun:3726:27379919,27380372:Carton_brun:3726:27380398,27380848:Carton_brun:3726:27380904,27381440:Carton_brun:3726:27381455,27381997:Carton_brun:3726:27382009,27382455:Carton_brun:3726:27382470,27382890:Carton_brun:3726:27382941,27384322:Carton_brun:3726:27384333,27384680:Carton_brun:3726:27384692,27384953:Carton_brun:3726:27384972,27385199:Carton_brun:3726:27385222,27385566:Carton_brun:3726:27385622,27385977:Carton_brun:3726:27385991,27386362:Carton_brun:3726:27386401,27386738:Carton_brun:3726:27386756,27387203:Carton_brun:3726:27387269,27387984:Carton_brun:3726:27388025,27389340:Carton_brun:3726:27389380,27390105:Carton_brun:3726:27390123,27390791:Carton_brun:3726:27390835,27391355:Carton_brun:3726:27391370,27392176:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009253308283522933, 'nb_photo': 19989, 'list_port_cont': '27375889,27376529,27376931,27377200,27378462,27378731,27379006,27379439,27379912,27380399,27380895,27381451,27382013,27382471,27382943,27384336,27384696,27384967,27385220,27385623,27385992,27386406,27386751,27387272,27388023,27388804,27389383,27390126,27390839,27391371,27392207,27394677,27395271,27395934,27396469,27397094,27397682,27398455,27399536,27399990,27400839,27401592,27403919,27404332,27404705,27405160,27405429,27405894,27406443,27407337,27407904,27408447,27409734,27410232,27410836,27411510,27412230,27413220,27413778,27414321,27415447,27415857,27416164,27416919,27417169,27417990,27418374,27418816,27419326,27419735,27420244,27420801,27421284,27421972,27422658,27424103,27424696,27425161,27425510,27425937,27427281,27427599,27427898,27428379,27428650,27429144,27429525,27430074,27430532,27431021,27431449,27432850,27433046,27433377,27433521,27433810,27434096,27434412,27434803,27435310,27436089,27436959,27438554,27438752,27439206,27439893,27445668,27446608,27446792,27448773,27449077,27449500,27450050,2745110', 'assoc_port': '27375839:27375889,27376525:27376529,27376906:27376931,27377191:27377200,27378456:27378462,27378717:27378731,27378994:27379006,27379410:27379439,27379907:27379912,27380372:27380399,27380848:27380895,27381440:27381451,27381997:27382013,27382455:27382471,27382890:27382943,27384322:27384336,27384680:27384696,27384953:27384967,27385199:27385220,27385566:27385623,27385977:27385992,27386362:27386406,27386738:27386751,27387203:27387272,27387984:27388023,27388759:27388804,27389340:27389383,27390105:27390126,27390791:27390839,27391355:27391371,27392176:27392207,27394659:27394677,27395242:27395271,27395913:27395934,27396429:27396469,27397076:27397094,27397673:27397682,27398369:27398455,27399474:27399536,27399974:27399990,27400780:27400839,27401557:27401592,27403901:27403919,27404296:27404332,27404682:27404705,27405147:27405160,27405398:27405429,27405885:27405894,27406408:27406443,27407294:27407337,27407854:27407904,27408403:27408447,27409726:27409734,27410197:27410232,27410821:27410836,27411483:27411510,27412214:2741223', 'assoc_mat': '27375839:Carton_gris:3726:27375889,27376525:Carton_gris:3726:27376529,27376906:Carton_gris:3726:27376931,27377191:Carton_gris:3726:27377200,27378456:Carton_gris:3726:27378462,27378717:Carton_gris:3726:27378731,27378994:Carton_gris:3726:27379006,27379410:Carton_gris:3726:27379439,27379907:Carton_gris:3726:27379912,27380372:Carton_gris:3726:27380399,27380848:Carton_gris:3726:27380895,27381440:Carton_gris:3726:27381451,27381997:Carton_gris:3726:27382013,27382455:Carton_gris:3726:27382471,27382890:Carton_gris:3726:27382943,27384322:Carton_gris:3726:27384336,27384680:Carton_gris:3726:27384696,27384953:Carton_gris:3726:27384967,27385199:Carton_gris:3726:27385220,27385566:Carton_gris:3726:27385623,27385977:Carton_gris:3726:27385992,27386362:Carton_gris:3726:27386406,27386738:Carton_gris:3726:27386751,27387203:Carton_gris:3726:27387272,27387984:Carton_gris:3726:27388023,27388759:Carton_gris:3726:27388804,27389340:Carton_gris:3726:27389383,27390105:Carton_gris:3726:27390126,27390791:Carton_gris:3726:27390839,27391355:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00201129286569613, 'nb_photo': 3037, 'list_port_cont': '27376536,27377198,27378463,27379920,27380900,27381458,27382462,27382952,27384686,27384974,27385216,27385624,27385994,27386755,27387279,27389381,27390836,27391364,27392209,27394669,27395928,27396473,27397096,27398447,27399993,27400843,27403925,27404330,27405154,27405428,27406453,27407916,27410835,27412224,27413222,27413780,27414322,27415855,27416169,27416921,27417176,27418380,27418817,27419328,27419731,27420245,27420803,27421282,27422676,27424695,27425167,27425507,27425933,27427592,27427900,27429147,27430075,27430530,27431027,27433054,27433807,27436096,27438753,27439208,27439901,27446601,27448774,27449496,27451623,27451889,27452373,27452700,27453315,27453935,27454529,27455060,27461028,27461802,27464300,27464970,27466539,27467027,27467621,27468502,27469014,27470848,27471446,27472908,27474249,27475819,27476534,27478055,27481058,27481901,27483139,27483737,27486714,27489611,27490358,27490870,27491457,27491996,27493268,27493918,27494648,27495913,27496425,27497893,27498545,27498888,27499156,27499515,27500388,2750194', 'assoc_port': '27376525:27376536,27377191:27377198,27378456:27378463,27379907:27379920,27380848:27380900,27381440:27381458,27382455:27382462,27382890:27382952,27384680:27384686,27384953:27384974,27385199:27385216,27385566:27385624,27385977:27385994,27386738:27386755,27387203:27387279,27389340:27389381,27390791:27390836,27391355:27391364,27392176:27392209,27394659:27394669,27395913:27395928,27396429:27396473,27397076:27397096,27398369:27398447,27399974:27399993,27400780:27400843,27403901:27403925,27404296:27404330,27405147:27405154,27405398:27405428,27406408:27406453,27407854:27407916,27410821:27410835,27412214:27412224,27413207:27413222,27413745:27413780,27414258:27414322,27415818:27415855,27416157:27416169,27416890:27416921,27417155:27417176,27418346:27418380,27418801:27418817,27419316:27419328,27419706:27419731,27420225:27420245,27420770:27420803,27421265:27421282,27422618:27422676,27424686:27424695,27425124:27425167,27425471:27425507,27425856:27425933,27427585:27427592,27427882:27427900,27429102:27429147,27430058:2743007', 'assoc_mat': '27376525:kraft:3726:27376536,27377191:kraft:3726:27377198,27378456:kraft:3726:27378463,27379907:kraft:3726:27379920,27380848:kraft:3726:27380900,27381440:kraft:3726:27381458,27382455:kraft:3726:27382462,27382890:kraft:3726:27382952,27384680:kraft:3726:27384686,27384953:kraft:3726:27384974,27385199:kraft:3726:27385216,27385566:kraft:3726:27385624,27385977:kraft:3726:27385994,27386738:kraft:3726:27386755,27387203:kraft:3726:27387279,27389340:kraft:3726:27389381,27390791:kraft:3726:27390836,27391355:kraft:3726:27391364,27392176:kraft:3726:27392209,27394659:kraft:3726:27394669,27395913:kraft:3726:27395928,27396429:kraft:3726:27396473,27397076:kraft:3726:27397096,27398369:kraft:3726:27398447,27399974:kraft:3726:27399993,27400780:kraft:3726:27400843,27403901:kraft:3726:27403925,27404296:kraft:3726:27404330,27405147:kraft:3726:27405154,27405398:kraft:3726:27405428,27406408:kraft:3726:27406453,27407854:kraft:3726:27407916,27410821:kraft:3726:27410835,27412214:kraft:3726:27412224,27413207:kraft:3726:27413222,27413745:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0007688136975636337, 'nb_photo': 883, 'list_port_cont': '27377206,27378473,27381456,27382463,27382948,27384335,27384976,27390837,27398452,27404700,27405431,27413214,27420248,27421974,27424097,27427908,27430079,27433047,27434090,27434405,27436092,27450055,27451626,27456910,27458954,27460492,27461799,27462767,27464294,27464962,27465551,27470604,27471984,27472397,27474248,27475820,27476529,27478059,27482531,27485124,27490355,27490864,27492603,27493272,27493909,27495912,27497036,27498889,27499155,27500386,27501207,27501526,27502491,27504302,27505609,27506065,27508714,27509233,27510114,27510923,27519696,27520089,27520435,27520877,27522425,27522988,27524642,27526200,27526533,27528228,27529008,27533221,27534128,27535491,27537243,27537660,27539739,27540153,27540351,27540804,27541703,27542342,27544810,27547374,27548617,27548841,27548993,27549456,27552107,27552940,27553269,27553634,27555390,27555868,27564471,27564984,27565378,27570641,27571869,27572108,27573675,27573866,27575476,27575989,27576448,27577529,27580916,27582371,27584510,27585630,27592157,27596748,27597974,2759883', 'assoc_port': '27377191:27377206,27378456:27378473,27381440:27381456,27382455:27382463,27382890:27382948,27384322:27384335,27384953:27384976,27390791:27390837,27398369:27398452,27404682:27404700,27405398:27405431,27413207:27413214,27420225:27420248,27421942:27421974,27424087:27424097,27427882:27427908,27430058:27430079,27433044:27433047,27434083:27434090,27434369:27434405,27436023:27436092,27450035:27450055,27451540:27451626,27456890:27456910,27458863:27458954,27460478:27460492,27461682:27461799,27462676:27462767,27464289:27464294,27464951:27464962,27465533:27465551,27470593:27470604,27471962:27471984,27472372:27472397,27474194:27474248,27475805:27475820,27476483:27476529,27478030:27478059,27482504:27482531,27485107:27485124,27490309:27490355,27490848:27490864,27492533:27492603,27493243:27493272,27493854:27493909,27495873:27495912,27496981:27497036,27498848:27498889,27499115:27499155,27500341:27500386,27501189:27501207,27501488:27501526,27502478:27502491,27504290:27504302,27505585:27505609,27506043:27506065,27508709:2750871', 'assoc_mat': '27377191:metal:3726:27377206,27378456:metal:3726:27378473,27381440:metal:3726:27381456,27382455:metal:3726:27382463,27382890:metal:3726:27382948,27384322:metal:3726:27384335,27384953:metal:3726:27384976,27390791:metal:3726:27390837,27398369:metal:3726:27398452,27404682:metal:3726:27404700,27405398:metal:3726:27405431,27413207:metal:3726:27413214,27420225:metal:3726:27420248,27421942:metal:3726:27421974,27424087:metal:3726:27424097,27427882:metal:3726:27427908,27430058:metal:3726:27430079,27433044:metal:3726:27433047,27434083:metal:3726:27434090,27434369:metal:3726:27434405,27436023:metal:3726:27436092,27450035:metal:3726:27450055,27451540:metal:3726:27451626,27456890:metal:3726:27456910,27458863:metal:3726:27458954,27460478:metal:3726:27460492,27461682:metal:3726:27461799,27462676:metal:3726:27462767,27464289:metal:3726:27464294,27464951:metal:3726:27464962,27465533:metal:3726:27465551,27470593:metal:3726:27470604,27471962:metal:3726:27471984,27472372:metal:3726:27472397,27474194:metal:3726:27474248,27475805:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.003967865270665909, 'nb_photo': 12715, 'list_port_cont': '27375886,27376531,27376935,27377203,27378467,27378739,27379014,27379446,27379921,27380396,27380897,27381454,27382469,27382942,27384329,27384687,27384975,27385221,27385621,27385986,27386404,27386758,27387277,27388020,27389385,27390132,27390842,27391366,27392215,27394676,27395264,27395931,27396466,27397099,27398450,27399989,27400847,27401584,27403920,27404331,27404699,27405162,27405896,27407330,27407915,27408452,27410226,27410845,27411512,27412219,27413215,27413775,27414305,27415456,27415861,27416159,27416927,27417170,27418377,27418834,27419332,27419737,27420239,27420796,27421286,27421970,27422678,27423616,27424093,27424697,27425164,27425502,27425930,27427287,27428643,27429150,27429518,27430537,27431028,27431451,27432848,27433050,27433381,27433808,27434094,27434410,27434807,27435303,27436099,27436965,27438754,27439209,27439899,27445659,27446610,27446784,27448462,27448771,27449073,27449492,27450056,27451110,27451624,27451895,27452376,27452704,27453310,27453939,27454522,27455076,27455819,27456394,27456900,2745866', 'assoc_port': '27375839:27375886,27376525:27376531,27376906:27376935,27377191:27377203,27378456:27378467,27378717:27378739,27378994:27379014,27379410:27379446,27379907:27379921,27380372:27380396,27380848:27380897,27381440:27381454,27382455:27382469,27382890:27382942,27384322:27384329,27384680:27384687,27384953:27384975,27385199:27385221,27385566:27385621,27385977:27385986,27386362:27386404,27386738:27386758,27387203:27387277,27387984:27388020,27389340:27389385,27390105:27390132,27390791:27390842,27391355:27391366,27392176:27392215,27394659:27394676,27395242:27395264,27395913:27395931,27396429:27396466,27397076:27397099,27398369:27398450,27399974:27399989,27400780:27400847,27401557:27401584,27403901:27403920,27404296:27404331,27404682:27404699,27405147:27405162,27405885:27405896,27407294:27407330,27407854:27407915,27408403:27408452,27410197:27410226,27410821:27410845,27411483:27411512,27412214:27412219,27413207:27413215,27413745:27413775,27414258:27414305,27415415:27415456,27415818:27415861,27416157:27416159,27416890:2741692', 'assoc_mat': '27375839:plastique:3726:27375886,27376525:plastique:3726:27376531,27376906:plastique:3726:27376935,27377191:plastique:3726:27377203,27378456:plastique:3726:27378467,27378717:plastique:3726:27378739,27378994:plastique:3726:27379014,27379410:plastique:3726:27379446,27379907:plastique:3726:27379921,27380372:plastique:3726:27380396,27380848:plastique:3726:27380897,27381440:plastique:3726:27381454,27382455:plastique:3726:27382469,27382890:plastique:3726:27382942,27384322:plastique:3726:27384329,27384680:plastique:3726:27384687,27384953:plastique:3726:27384975,27385199:plastique:3726:27385221,27385566:plastique:3726:27385621,27385977:plastique:3726:27385986,27386362:plastique:3726:27386404,27386738:plastique:3726:27386758,27387203:plastique:3726:27387277,27387984:plastique:3726:27388020,27389340:plastique:3726:27389385,27390105:plastique:3726:27390132,27390791:plastique:3726:27390842,27391355:plastique:3726:27391366,27392176:plastique:3726:27392215,27394659:plastique:3726:27394676,27395242:plastique:3726:27395264,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.013530926557821022, 'nb_photo': 33955, 'list_port_cont': '27375890,27376530,27376939,27377201,27378471,27378733,27379017,27379423,27379913,27380394,27380903,27381461,27382007,27382468,27382950,27384334,27384697,27384970,27385214,27385626,27385993,27386407,27386753,27387276,27388003,27389378,27390122,27390834,27391365,27392204,27394672,27395272,27395926,27396467,27397093,27397691,27398446,27399537,27399992,27400841,27401591,27403930,27404328,27404703,27405163,27405425,27405897,27406447,27407341,27407907,27408449,27408966,27409740,27410233,27410841,27411515,27412228,27413217,27413783,27414319,27415327,27415451,27415863,27416162,27416924,27417178,27417991,27418376,27418832,27419333,27419751,27420246,27420802,27421288,27421963,27422647,27423614,27424094,27424699,27425171,27425508,27425931,27427284,27427596,27427899,27428385,27428647,27429142,27429528,27430077,27430534,27431018,27431452,27432855,27433053,27433384,27433522,27433812,27434100,27434416,27434808,27435315,27436091,27436960,27438560,27438755,27439203,27439896,27445660,27446606,27446785,27448465,27448776,2744906', 'assoc_port': '27375839:27375890,27376525:27376530,27376906:27376939,27377191:27377201,27378456:27378471,27378717:27378733,27378994:27379017,27379410:27379423,27379907:27379913,27380372:27380394,27380848:27380903,27381440:27381461,27381997:27382007,27382455:27382468,27382890:27382950,27384322:27384334,27384680:27384697,27384953:27384970,27385199:27385214,27385566:27385626,27385977:27385993,27386362:27386407,27386738:27386753,27387203:27387276,27387984:27388003,27389340:27389378,27390105:27390122,27390791:27390834,27391355:27391365,27392176:27392204,27394659:27394672,27395242:27395272,27395913:27395926,27396429:27396467,27397076:27397093,27397673:27397691,27398369:27398446,27399474:27399537,27399974:27399992,27400780:27400841,27401557:27401591,27403901:27403930,27404296:27404328,27404682:27404703,27405147:27405163,27405398:27405425,27405885:27405897,27406408:27406447,27407294:27407341,27407854:27407907,27408403:27408449,27408924:27408966,27409726:27409740,27410197:27410233,27410821:27410841,27411483:27411515,27412214:2741222', 'assoc_mat': '27375839:Teint_Dans_La_Masse:3726:27375890,27376525:Teint_Dans_La_Masse:3726:27376530,27376906:Teint_Dans_La_Masse:3726:27376939,27377191:Teint_Dans_La_Masse:3726:27377201,27378456:Teint_Dans_La_Masse:3726:27378471,27378717:Teint_Dans_La_Masse:3726:27378733,27378994:Teint_Dans_La_Masse:3726:27379017,27379410:Teint_Dans_La_Masse:3726:27379423,27379907:Teint_Dans_La_Masse:3726:27379913,27380372:Teint_Dans_La_Masse:3726:27380394,27380848:Teint_Dans_La_Masse:3726:27380903,27381440:Teint_Dans_La_Masse:3726:27381461,27381997:Teint_Dans_La_Masse:3726:27382007,27382455:Teint_Dans_La_Masse:3726:27382468,27382890:Teint_Dans_La_Masse:3726:27382950,27384322:Teint_Dans_La_Masse:3726:27384334,27384680:Teint_Dans_La_Masse:3726:27384697,27384953:Teint_Dans_La_Masse:3726:27384970,27385199:Teint_Dans_La_Masse:3726:27385214,27385566:Teint_Dans_La_Masse:3726:27385626,27385977:Teint_Dans_La_Masse:3726:27385993,27386362:Teint_Dans_La_Masse:3726:27386407,27386738:Teint_Dans_La_Masse:3726:27386753,27387203:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 95316}}, 'hostname': (('jetson-73',),), 'impurety_average_per_hashtag': [(('JRM', '2025-10', 0.051427836777828764),)]} filepath : /data_4/data_log/job/memo/arc_en_ciel_jrm/sla_mensuel_arc_en_ciel_jrm_mois_10_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.45%', 11814], 'cartonnette': ['cartonnette', '0.46%', 19235], 'Carton_brun': ['Carton_brun', '1.67%', 19501], 'Carton_gris': ['Carton_gris', '0.93%', 19989], 'kraft': ['kraft', '0.2%', 3037], 'metal': ['metal', '0.08%', 883], 'plastique': ['plastique', '0.4%', 12715], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '1.35%', 33955]}} 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_10_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/arc_en_ciel_jrm 2.51user 2.56system 0:09.67elapsed 52%CPU (0avgtext+0avgdata 176176maxresident)k 23272inputs+520outputs (93major+46826minor)pagefaults 0swaps