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=20092 --dashboard_places=refus_amiens --rootfolder_sla=/data_2/data_log/job/memo/refus_amiens -v --mtr_id=983 --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 : 20092, Date : 2025-03 _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 : (5, 31) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 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 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} 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="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 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 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 31) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 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 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} 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="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 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 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 15 month : 03 mtr_id : 983 dashboard_places : refus_amiens date : 2025-03 year : 2025 raspi : 20092 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 = 'refus_amiens' and date like '%2025-03%') and created_at like '%2025-03%'))); nb_day : (5, 31) after unwanted_material_data nb_day : (5, 31) WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used 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 '%20092%' AND ms.result_str like '%2025/03%'ORDER BY ms.id desc LIMIT 0, 1000000; Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-03-01 00:00:00,2025-03-02 00:00:00,2025-03-03 00:00:00,2025-03-04 00:00:00,2025-03-05 00:00:00,2025-03-06 00:00:00,2025-03-07 00:00:00,2025-03-08 00:00:00,2025-03-09 00:00:00,2025-03-10 00:00:00,2025-03-11 00:00:00,2025-03-12 00:00:00,2025-03-13 00:00:00,2025-03-14 00:00:00,2025-03-15 00:00:00,2025-03-16 00:00:00,2025-03-17 00:00:00,2025-03-18 00:00:00,2025-03-19 00:00:00,2025-03-20 00:00:00,2025-03-21 00:00:00,2025-03-22 00:00:00,2025-03-23 00:00:00,2025-03-24 00:00:00,2025-03-25 00:00:00,2025-03-26 00:00:00,2025-03-27 00:00:00,2025-03-28 00:00:00,2025-03-29 00:00:00,2025-03-30 00:00:00,2025-03-31 00:00:00 after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 15 and month(ded.date) = 03 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______refus' and ded.dashboard_place_id = 15 and month(ded.date) = 03 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 = 15 and mp.name like '%032025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-03-01 : dt_date_just_month_year : 2025-03-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! 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= "refus_amiens" 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-03-01" AND ded.date <= "2025-03-31" apple3 {'refus': {'mat': 'refus', 'pht': 4213, 'datou_carac_id': 3996, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus,textiles_sanitaires'}} 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 (1700907,1704301,1707893,1709702,1710244,1713808) 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': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032400499317800807, 'nb_photo': 661, 'list_port_cont': '21779740,21779775,21780345,21780531,21780722,21781346,21781376,21781450,21782827,21783299,21783576,21784533,21784927,21788845,21790562,21790831,21795167,21799037,21803015,21804543,21805485,21806192,21808332,21808589,21808749,21808789,21809349,21809573,21809898,21810181,21810366,21810427,21810571,21811303,21812738,21815933,21820797,21820895,21821256,21823601,21824107,21829002,21830162,21830700,21830943,21833324,21833862,21836262,21839681,21841990,21842349,21844555,21848132,21853162,21854019,21855524,21858545,21860513,21863019,21866534,21867291,21870664,21870742,21870862,21871030,21871241,21871337,21871479,21871885,21872201,21872717,21873012,21873784,21873985,21874278,21875531,21875744,21876479,21879086,21893416,21893532,21893562,21893595,21893628,21893675,21893723,21893810,21893843,21893873,21893896,21893982,21894043,21894078,21894120,21894144,21894208,21897808,21898025,21900222,21900534,21900666,21904907,21906394,21906451,21906542,21906591,21906905,21906955,21907458,21908292,21912966,21914875,21916054,2192193', 'assoc_port': '21779443:21779740,21779445:21824107,21779446:21806192,21779447:21780722,21779448:21780345,21779450:21780531,21779452:21779775,21780856:21823601,21780857:21808332,21780858:21808589,21780859:21808789,21780860:21821256,21780861:21809573,21780862:21809898,21780864:21810181,21780865:21810366,21780884:21810571,21780893:21811303,21780918:21808749,21780919:21810427,21780920:21803015,21780921:21788845,21780922:21784927,21780923:21784533,21780925:21783299,21780926:21783576,21780927:21782827,21780928:21781346,21780929:21781376,21780930:21781450,21789865:21790562,21790680:21790831,21794660:21795167,21798252:21799037,21804156:21804543,21805181:21805485,21808651:21809349,21812511:21812738,21815718:21815933,21820590:21820895,21820591:21820797,21828553:21833324,21828555:21830700,21828557:21830162,21828563:21841990,21828591:21829002,21830807:21830943,21833540:21833862,21835986:21836262,21838936:21839681,21842152:21842349,21844435:21844555,21847639:21848132,21852283:21853162,21853646:21854019,21855235:21855524,21857529:2185854', 'assoc_mat': '21779443:barquette_opaque:4213:21779740,21779445:barquette_opaque:4213:21824107,21779446:barquette_opaque:4213:21806192,21779447:barquette_opaque:4213:21780722,21779448:barquette_opaque:4213:21780345,21779450:barquette_opaque:4213:21780531,21779452:barquette_opaque:4213:21779775,21780856:barquette_opaque:4213:21823601,21780857:barquette_opaque:4213:21808332,21780858:barquette_opaque:4213:21808589,21780859:barquette_opaque:4213:21808789,21780860:barquette_opaque:4213:21821256,21780861:barquette_opaque:4213:21809573,21780862:barquette_opaque:4213:21809898,21780864:barquette_opaque:4213:21810181,21780865:barquette_opaque:4213:21810366,21780884:barquette_opaque:4213:21810571,21780893:barquette_opaque:4213:21811303,21780918:barquette_opaque:4213:21808749,21780919:barquette_opaque:4213:21810427,21780920:barquette_opaque:4213:21803015,21780921:barquette_opaque:4213:21788845,21780922:barquette_opaque:4213:21784927,21780923:barquette_opaque:4213:21784533,21780925:barquette_opaque:4213:21783299,21780926:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0028658200003600824, 'nb_photo': 876, 'list_port_cont': '21779748,21779782,21780227,21780336,21780372,21780511,21780735,21781344,21781377,21781440,21782112,21782829,21783310,21784525,21784918,21788831,21790563,21790829,21795180,21799026,21803007,21804539,21805481,21806190,21808337,21808598,21808759,21808784,21809364,21809564,21809897,21810173,21810381,21810426,21810582,21811284,21812762,21815929,21818943,21820809,21820888,21821243,21823611,21824102,21829013,21830168,21830689,21830933,21831892,21833321,21833859,21839680,21841981,21844063,21844558,21848128,21853171,21854017,21855537,21858531,21863010,21866543,21867297,21870439,21870666,21870726,21870874,21871038,21871256,21871335,21871493,21871888,21871979,21872209,21872725,21873005,21873361,21873787,21873980,21874282,21874481,21875530,21875739,21876005,21876471,21878933,21879080,21893417,21893535,21893567,21893592,21893631,21893688,21893761,21893798,21893832,21893863,21893905,21893972,21893986,21894071,21894107,21894140,21894176,21894207,21897824,21898022,21900223,21900532,21900674,21904905,21906402,21906460,2190654', 'assoc_port': '21779443:21779748,21779445:21824102,21779446:21806190,21779447:21780735,21779448:21780336,21779449:21780372,21779450:21780511,21779451:21780227,21779452:21779782,21780856:21823611,21780857:21808337,21780858:21808598,21780859:21808784,21780860:21821243,21780861:21809564,21780862:21809897,21780864:21810173,21780865:21810381,21780884:21810582,21780893:21811284,21780918:21808759,21780919:21810426,21780920:21803007,21780921:21788831,21780922:21784918,21780923:21784525,21780925:21783310,21780927:21782829,21780928:21781344,21780929:21781377,21780930:21781440,21781684:21782112,21789865:21790563,21790680:21790829,21794660:21795180,21798252:21799026,21804156:21804539,21805181:21805481,21808651:21809364,21812511:21812762,21815718:21815929,21818667:21818943,21820590:21820888,21820591:21820809,21828551:21831892,21828553:21833321,21828555:21830689,21828557:21830168,21828563:21841981,21828591:21829013,21830807:21830933,21833540:21833859,21838936:21839680,21843928:21844063,21844435:21844558,21847639:21848128,21852283:2185317', 'assoc_mat': '21779443:carton:4213:21779748,21779445:carton:4213:21824102,21779446:carton:4213:21806190,21779447:carton:4213:21780735,21779448:carton:4213:21780336,21779449:carton:4213:21780372,21779450:carton:4213:21780511,21779451:carton:4213:21780227,21779452:carton:4213:21779782,21780856:carton:4213:21823611,21780857:carton:4213:21808337,21780858:carton:4213:21808598,21780859:carton:4213:21808784,21780860:carton:4213:21821243,21780861:carton:4213:21809564,21780862:carton:4213:21809897,21780864:carton:4213:21810173,21780865:carton:4213:21810381,21780884:carton:4213:21810582,21780893:carton:4213:21811284,21780918:carton:4213:21808759,21780919:carton:4213:21810426,21780920:carton:4213:21803007,21780921:carton:4213:21788831,21780922:carton:4213:21784918,21780923:carton:4213:21784525,21780925:carton:4213:21783310,21780927:carton:4213:21782829,21780928:carton:4213:21781344,21780929:carton:4213:21781377,21780930:carton:4213:21781440,21781684:carton:4213:21782112,21789865:carton:4213:21790563,21790680:carton:4213:21790829,2179'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032510347972613965, 'nb_photo': 198, 'list_port_cont': '21779743,21780378,21780513,21780725,21781348,21781381,21781444,21783307,21784219,21784926,21788844,21790570,21794694,21795172,21799028,21803000,21804552,21806201,21808339,21808587,21808763,21808792,21809895,21810170,21810371,21810434,21810578,21811288,21812724,21815941,21818949,21820811,21820893,21821259,21823609,21824108,21829684,21830702,21833336,21833866,21839683,21863018,21866536,21867298,21870453,21870730,21871041,21871242,21871494,21873002,21873776,21874286,21875533,21875741,21876010,21878929,21893534,21893557,21893591,21893676,21893710,21893809,21893838,21893862,21893898,21893980,21894074,21894147,21894181,21897818,21898024,21900220,21900537,21900675,21904911,21906400,21906538,21906579,21906966,21907448,21908302,21914872,21916055,21921932,21922248,21923471,21924143,21928873,21930864', 'assoc_port': '21779443:21779743,21779445:21824108,21779446:21806201,21779447:21780725,21779449:21780378,21779450:21780513,21780856:21823609,21780857:21808339,21780858:21808587,21780859:21808792,21780860:21821259,21780862:21809895,21780864:21810170,21780865:21810371,21780884:21810578,21780893:21811288,21780918:21808763,21780919:21810434,21780920:21803000,21780921:21788844,21780922:21784926,21780924:21784219,21780925:21783307,21780928:21781348,21780929:21781381,21780930:21781444,21784663:21794694,21789865:21790570,21794660:21795172,21798252:21799028,21804156:21804552,21812511:21812724,21815718:21815941,21818667:21818949,21820590:21820893,21820591:21820811,21828553:21833336,21828555:21830702,21828559:21829684,21833540:21833866,21838936:21839683,21862868:21863018,21866429:21866536,21867163:21867298,21870286:21871041,21870288:21871242,21870291:21871494,21870293:21870730,21870297:21870453,21872995:21873002,21873752:21873776,21874197:21874286,21875393:21875533,21875733:21875741,21875983:21876010,21878609:21878929,21893284:2189383', 'assoc_mat': '21779443:ela:4213:21779743,21779445:ela:4213:21824108,21779446:ela:4213:21806201,21779447:ela:4213:21780725,21779449:ela:4213:21780378,21779450:ela:4213:21780513,21780856:ela:4213:21823609,21780857:ela:4213:21808339,21780858:ela:4213:21808587,21780859:ela:4213:21808792,21780860:ela:4213:21821259,21780862:ela:4213:21809895,21780864:ela:4213:21810170,21780865:ela:4213:21810371,21780884:ela:4213:21810578,21780893:ela:4213:21811288,21780918:ela:4213:21808763,21780919:ela:4213:21810434,21780920:ela:4213:21803000,21780921:ela:4213:21788844,21780922:ela:4213:21784926,21780924:ela:4213:21784219,21780925:ela:4213:21783307,21780928:ela:4213:21781348,21780929:ela:4213:21781381,21780930:ela:4213:21781444,21784663:ela:4213:21794694,21789865:ela:4213:21790570,21794660:ela:4213:21795172,21798252:ela:4213:21799028,21804156:ela:4213:21804552,21812511:ela:4213:21812724,21815718:ela:4213:21815941,21818667:ela:4213:21818949,21820590:ela:4213:21820893,21820591:ela:4213:21820811,21828553:ela:4213:21833336,21828555:ela:4213:2183070'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0028444782452004226, 'nb_photo': 981, 'list_port_cont': '21779751,21779784,21780225,21780333,21780371,21780525,21780724,21781335,21781372,21781439,21783295,21784206,21784531,21784925,21788836,21790569,21790821,21792496,21795168,21799032,21803011,21804545,21805496,21806209,21808345,21808600,21808752,21808797,21809363,21809558,21809896,21810174,21810368,21810429,21810581,21811293,21812725,21815934,21818951,21820807,21820890,21821246,21823602,21824116,21829016,21829692,21830167,21830696,21830939,21831890,21833329,21833863,21836270,21839693,21841991,21842355,21844050,21844556,21848139,21853168,21854005,21855535,21858546,21862165,21863008,21866539,21867284,21870440,21870677,21870739,21870871,21871034,21871255,21871333,21871485,21871879,21871987,21872203,21872716,21873010,21873780,21873971,21874288,21874471,21875748,21876004,21876474,21878931,21879074,21893428,21893451,21893529,21893561,21893598,21893637,21893677,21893721,21893764,21893794,21893836,21893866,21893904,21893944,21894042,21894087,21894110,21894188,21894223,21897809,21898033,21900224,21900541,21900671,2190490', 'assoc_port': '21779443:21779751,21779445:21824116,21779446:21806209,21779447:21780724,21779448:21780333,21779449:21780371,21779450:21780525,21779451:21780225,21779452:21779784,21780856:21823602,21780857:21808345,21780858:21808600,21780859:21808797,21780860:21821246,21780861:21809558,21780862:21809896,21780864:21810174,21780865:21810368,21780884:21810581,21780893:21811293,21780918:21808752,21780919:21810429,21780920:21803011,21780921:21788836,21780922:21784925,21780923:21784531,21780924:21784206,21780925:21783295,21780928:21781335,21780929:21781372,21780930:21781439,21789865:21790569,21790680:21790821,21792144:21792496,21794660:21795168,21798252:21799032,21804156:21804545,21805181:21805496,21808651:21809363,21812511:21812725,21815718:21815934,21818667:21818951,21820590:21820890,21820591:21820807,21828551:21831890,21828553:21833329,21828555:21830696,21828557:21830167,21828559:21829692,21828563:21841991,21828591:21829016,21830807:21830939,21833540:21833863,21835986:21836270,21838936:21839693,21842152:21842355,21843928:2184405', 'assoc_mat': '21779443:etiquette:4213:21779751,21779445:etiquette:4213:21824116,21779446:etiquette:4213:21806209,21779447:etiquette:4213:21780724,21779448:etiquette:4213:21780333,21779449:etiquette:4213:21780371,21779450:etiquette:4213:21780525,21779451:etiquette:4213:21780225,21779452:etiquette:4213:21779784,21780856:etiquette:4213:21823602,21780857:etiquette:4213:21808345,21780858:etiquette:4213:21808600,21780859:etiquette:4213:21808797,21780860:etiquette:4213:21821246,21780861:etiquette:4213:21809558,21780862:etiquette:4213:21809896,21780864:etiquette:4213:21810174,21780865:etiquette:4213:21810368,21780884:etiquette:4213:21810581,21780893:etiquette:4213:21811293,21780918:etiquette:4213:21808752,21780919:etiquette:4213:21810429,21780920:etiquette:4213:21803011,21780921:etiquette:4213:21788836,21780922:etiquette:4213:21784925,21780923:etiquette:4213:21784531,21780924:etiquette:4213:21784206,21780925:etiquette:4213:21783295,21780928:etiquette:4213:21781335,21780929:etiquette:4213:21781372,21780930:etiquette:4213:21781439,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03124399298868142, 'nb_photo': 2484, 'list_port_cont': '21779735,21779770,21780229,21780334,21780366,21780517,21780730,21781343,21781368,21781455,21782109,21783302,21783567,21784215,21784519,21784919,21788837,21790560,21790817,21792492,21794701,21795181,21799040,21803005,21804549,21805486,21806206,21808347,21808602,21808765,21808787,21809358,21809568,21809883,21810177,21810378,21810428,21810570,21811289,21812760,21815935,21818946,21820800,21820886,21821244,21823606,21824103,21829007,21829677,21830176,21830701,21830944,21831889,21833332,21833867,21836263,21839689,21841994,21842351,21844056,21844561,21848141,21853173,21854011,21855525,21858543,21860511,21862163,21863012,21866544,21867293,21870449,21870678,21870740,21870867,21871026,21871250,21871338,21871484,21871882,21871993,21872206,21872723,21873003,21873348,21873783,21873975,21874284,21874482,21875522,21875750,21876012,21876481,21878930,21879075,21893426,21893450,21893525,21893559,21893600,21893624,21893680,21893708,21893768,21893800,21893839,21893877,21893906,21893941,21893973,21894000,21894044,21894085,2189411', 'assoc_port': '21779443:21779735,21779445:21824103,21779446:21806206,21779447:21780730,21779448:21780334,21779449:21780366,21779450:21780517,21779451:21780229,21779452:21779770,21780856:21823606,21780857:21808347,21780858:21808602,21780859:21808787,21780860:21821244,21780861:21809568,21780862:21809883,21780864:21810177,21780865:21810378,21780884:21810570,21780893:21811289,21780918:21808765,21780919:21810428,21780920:21803005,21780921:21788837,21780922:21784919,21780923:21784519,21780924:21784215,21780925:21783302,21780926:21783567,21780928:21781343,21780929:21781368,21780930:21781455,21781684:21782109,21784663:21794701,21789865:21790560,21790680:21790817,21792144:21792492,21794660:21795181,21798252:21799040,21804156:21804549,21805181:21805486,21808651:21809358,21812511:21812760,21815718:21815935,21818667:21818946,21820590:21820886,21820591:21820800,21828551:21831889,21828553:21833332,21828555:21830701,21828557:21830176,21828559:21829677,21828563:21841994,21828591:21829007,21830807:21830944,21833540:21833867,21835986:2183626', 'assoc_mat': '21779443:film_plastique:4213:21779735,21779445:film_plastique:4213:21824103,21779446:film_plastique:4213:21806206,21779447:film_plastique:4213:21780730,21779448:film_plastique:4213:21780334,21779449:film_plastique:4213:21780366,21779450:film_plastique:4213:21780517,21779451:film_plastique:4213:21780229,21779452:film_plastique:4213:21779770,21780856:film_plastique:4213:21823606,21780857:film_plastique:4213:21808347,21780858:film_plastique:4213:21808602,21780859:film_plastique:4213:21808787,21780860:film_plastique:4213:21821244,21780861:film_plastique:4213:21809568,21780862:film_plastique:4213:21809883,21780864:film_plastique:4213:21810177,21780865:film_plastique:4213:21810378,21780884:film_plastique:4213:21810570,21780893:film_plastique:4213:21811289,21780918:film_plastique:4213:21808765,21780919:film_plastique:4213:21810428,21780920:film_plastique:4213:21803005,21780921:film_plastique:4213:21788837,21780922:film_plastique:4213:21784919,21780923:film_plastique:4213:21784519,21780924:film_plastique:4213:2178421'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0006829393527929814, 'nb_photo': 10, 'list_port_cont': '21781345,21821249,21830694,21855526,21863014,21874281,21900668,21907449,21928874', 'assoc_port': '21780860:21821249,21780928:21781345,21828555:21830694,21855235:21855526,21862868:21863014,21874197:21874281,21897326:21900668,21902685:21907449,21928540:21928874', 'assoc_mat': '21780860:kraft:4213:21821249,21780928:kraft:4213:21781345,21828555:kraft:4213:21830694,21855235:kraft:4213:21855526,21862868:kraft:4213:21863014,21874197:kraft:4213:21874281,21897326:kraft:4213:21900668,21902685:kraft:4213:21907449,21928540:kraft:4213:21928874'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.005447345257634398, 'nb_photo': 2464, 'list_port_cont': '21779741,21779773,21780219,21780330,21780364,21780508,21780726,21781337,21781371,21781454,21782100,21782830,21783294,21783568,21784205,21784524,21784914,21788830,21790556,21790827,21792493,21794699,21795177,21799035,21803006,21804546,21805491,21806189,21808341,21808599,21808762,21808798,21809353,21809555,21809885,21810184,21810372,21810436,21810583,21811301,21812744,21815939,21818942,21820808,21820894,21821248,21823612,21824115,21829004,21829680,21830174,21830692,21830927,21831885,21833335,21833872,21836264,21839692,21841987,21842335,21844059,21844554,21848143,21853163,21854008,21855530,21858534,21860512,21862158,21863015,21866541,21867285,21870452,21870670,21870741,21870865,21871036,21871243,21871339,21871483,21871875,21871990,21872199,21872713,21873004,21873350,21873778,21873986,21874276,21874479,21875520,21875742,21876008,21876485,21878944,21879084,21893418,21893462,21893524,21893554,21893603,21893638,21893684,21893709,21893769,21893801,21893834,21893868,21893903,21893933,21893981,21894038,21894077,2189412', 'assoc_port': '21779443:21779741,21779445:21824115,21779446:21806189,21779447:21780726,21779448:21780330,21779449:21780364,21779450:21780508,21779451:21780219,21779452:21779773,21780856:21823612,21780857:21808341,21780858:21808599,21780859:21808798,21780860:21821248,21780861:21809555,21780862:21809885,21780864:21810184,21780865:21810372,21780884:21810583,21780893:21811301,21780918:21808762,21780919:21810436,21780920:21803006,21780921:21788830,21780922:21784914,21780923:21784524,21780924:21784205,21780925:21783294,21780926:21783568,21780927:21782830,21780928:21781337,21780929:21781371,21780930:21781454,21781684:21782100,21784663:21794699,21789865:21790556,21790680:21790827,21792144:21792493,21794660:21795177,21798252:21799035,21804156:21804546,21805181:21805491,21808651:21809353,21812511:21812744,21815718:21815939,21818667:21818942,21820590:21820894,21820591:21820808,21828551:21831885,21828553:21833335,21828555:21830692,21828557:21830174,21828559:21829680,21828563:21841987,21828591:21829004,21830807:21830927,21833540:2183387', 'assoc_mat': '21779443:metal:4213:21779741,21779445:metal:4213:21824115,21779446:metal:4213:21806189,21779447:metal:4213:21780726,21779448:metal:4213:21780330,21779449:metal:4213:21780364,21779450:metal:4213:21780508,21779451:metal:4213:21780219,21779452:metal:4213:21779773,21780856:metal:4213:21823612,21780857:metal:4213:21808341,21780858:metal:4213:21808599,21780859:metal:4213:21808798,21780860:metal:4213:21821248,21780861:metal:4213:21809555,21780862:metal:4213:21809885,21780864:metal:4213:21810184,21780865:metal:4213:21810372,21780884:metal:4213:21810583,21780893:metal:4213:21811301,21780918:metal:4213:21808762,21780919:metal:4213:21810436,21780920:metal:4213:21803006,21780921:metal:4213:21788830,21780922:metal:4213:21784914,21780923:metal:4213:21784524,21780924:metal:4213:21784205,21780925:metal:4213:21783294,21780926:metal:4213:21783568,21780927:metal:4213:21782830,21780928:metal:4213:21781337,21780929:metal:4213:21781371,21780930:metal:4213:21781454,21781684:metal:4213:21782100,21784663:metal:4213:21794699,21789865:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.02945414163585054, 'nb_photo': 3892, 'list_port_cont': '21779744,21779777,21780220,21780337,21780368,21780515,21780723,21781339,21781378,21781442,21782099,21782839,21783298,21783570,21784211,21784526,21784915,21788843,21790561,21790823,21792499,21794700,21795179,21799027,21803008,21804544,21805484,21806197,21808340,21808588,21808760,21808783,21809361,21809562,21809886,21810183,21810365,21810437,21810580,21811291,21812745,21815928,21818947,21820801,21820892,21821252,21823605,21824110,21829010,21829693,21830171,21830698,21830942,21831894,21833331,21833874,21836271,21839687,21841978,21842327,21844058,21844564,21848140,21853172,21854015,21855533,21858537,21860507,21862169,21863022,21866532,21867290,21870451,21870673,21870734,21870863,21871040,21871253,21871332,21871488,21871889,21871994,21872208,21872724,21873001,21873349,21873775,21873984,21874277,21874484,21875535,21875749,21876011,21876473,21878942,21879081,21893424,21893463,21893533,21893555,21893589,21893630,21893686,21893711,21893765,21893797,21893830,21893874,21893912,21893934,21893969,21893989,21894048,2189408', 'assoc_port': '21779443:21779744,21779445:21824110,21779446:21806197,21779447:21780723,21779448:21780337,21779449:21780368,21779450:21780515,21779451:21780220,21779452:21779777,21780856:21823605,21780857:21808340,21780858:21808588,21780859:21808783,21780860:21821252,21780861:21809562,21780862:21809886,21780864:21810183,21780865:21810365,21780884:21810580,21780893:21811291,21780918:21808760,21780919:21810437,21780920:21803008,21780921:21788843,21780922:21784915,21780923:21784526,21780924:21784211,21780925:21783298,21780926:21783570,21780927:21782839,21780928:21781339,21780929:21781378,21780930:21781442,21781684:21782099,21784663:21794700,21789865:21790561,21790680:21790823,21792144:21792499,21794660:21795179,21798252:21799027,21804156:21804544,21805181:21805484,21808651:21809361,21812511:21812745,21815718:21815928,21818667:21818947,21820590:21820892,21820591:21820801,21828551:21831894,21828553:21833331,21828555:21830698,21828557:21830171,21828559:21829693,21828563:21841978,21828591:21829010,21830807:21830942,21833540:2183387', 'assoc_mat': '21779443:papier:4213:21779744,21779445:papier:4213:21824110,21779446:papier:4213:21806197,21779447:papier:4213:21780723,21779448:papier:4213:21780337,21779449:papier:4213:21780368,21779450:papier:4213:21780515,21779451:papier:4213:21780220,21779452:papier:4213:21779777,21780856:papier:4213:21823605,21780857:papier:4213:21808340,21780858:papier:4213:21808588,21780859:papier:4213:21808783,21780860:papier:4213:21821252,21780861:papier:4213:21809562,21780862:papier:4213:21809886,21780864:papier:4213:21810183,21780865:papier:4213:21810365,21780884:papier:4213:21810580,21780893:papier:4213:21811291,21780918:papier:4213:21808760,21780919:papier:4213:21810437,21780920:papier:4213:21803008,21780921:papier:4213:21788843,21780922:papier:4213:21784915,21780923:papier:4213:21784526,21780924:papier:4213:21784211,21780925:papier:4213:21783298,21780926:papier:4213:21783570,21780927:papier:4213:21782839,21780928:papier:4213:21781339,21780929:papier:4213:21781378,21780930:papier:4213:21781442,21781684:papier:4213:21782099,2178'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0029523534730137575, 'nb_photo': 69, 'list_port_cont': '21781347,21781375,21782836,21784924,21790572,21792504,21799036,21803014,21808334,21808592,21808755,21809559,21810172,21810430,21811297,21820803,21823613,21829014,21830178,21831891,21836258,21839686,21854009,21866530,21867282,21871029,21871486,21874273,21876486,21893587,21893678,21893844,21893943,21897814,21898026,21900525,21906393,21906581,21906908,21907445,21908296,21916067,21921931,21923483,21924147,21928878,21930861', 'assoc_port': '21780856:21823613,21780857:21808334,21780858:21808592,21780861:21809559,21780864:21810172,21780893:21811297,21780918:21808755,21780919:21810430,21780920:21803014,21780922:21784924,21780927:21782836,21780928:21781347,21780929:21781375,21789865:21790572,21792144:21792504,21798252:21799036,21820591:21820803,21828551:21831891,21828557:21830178,21828591:21829014,21835986:21836258,21838936:21839686,21853646:21854009,21866429:21866530,21867163:21867282,21870286:21871029,21870291:21871486,21874197:21874273,21876288:21876486,21893284:21893844,21893329:21893943,21893354:21893678,21893378:21893587,21897325:21900525,21897327:21897814,21897328:21898026,21897331:21906581,21902683:21906908,21902685:21907445,21906318:21906393,21908083:21908296,21915814:21916067,21920703:21924147,21920704:21921931,21923361:21923483,21928540:21928878,21930515:21930861', 'assoc_mat': '21780856:pehd:4213:21823613,21780857:pehd:4213:21808334,21780858:pehd:4213:21808592,21780861:pehd:4213:21809559,21780864:pehd:4213:21810172,21780893:pehd:4213:21811297,21780918:pehd:4213:21808755,21780919:pehd:4213:21810430,21780920:pehd:4213:21803014,21780922:pehd:4213:21784924,21780927:pehd:4213:21782836,21780928:pehd:4213:21781347,21780929:pehd:4213:21781375,21789865:pehd:4213:21790572,21792144:pehd:4213:21792504,21798252:pehd:4213:21799036,21820591:pehd:4213:21820803,21828551:pehd:4213:21831891,21828557:pehd:4213:21830178,21828591:pehd:4213:21829014,21835986:pehd:4213:21836258,21838936:pehd:4213:21839686,21853646:pehd:4213:21854009,21866429:pehd:4213:21866530,21867163:pehd:4213:21867282,21870286:pehd:4213:21871029,21870291:pehd:4213:21871486,21874197:pehd:4213:21874273,21876288:pehd:4213:21876486,21893284:pehd:4213:21893844,21893329:pehd:4213:21893943,21893354:pehd:4213:21893678,21893378:pehd:4213:21893587,21897325:pehd:4213:21900525,21897327:pehd:4213:21897814,21897328:pehd:4213:21898026,21897331:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.022629260514299525, 'nb_photo': 3754, 'list_port_cont': '21779742,21779774,21780228,21780346,21780375,21780519,21780738,21781334,21781374,21781448,21782104,21782835,21783308,21783573,21784212,21784532,21784921,21788840,21790567,21790825,21792500,21794692,21795169,21799031,21803002,21804538,21805487,21806196,21808342,21808590,21808764,21808790,21809350,21809560,21809892,21810169,21810373,21810431,21810575,21811285,21812730,21815937,21818939,21820802,21820880,21821254,21823610,21824117,21829009,21829682,21830170,21830699,21830935,21831887,21833326,21833870,21836257,21839678,21841988,21842352,21844061,21844563,21848135,21853164,21854006,21855536,21858540,21860503,21862159,21863006,21866533,21867286,21870454,21870668,21870735,21870859,21871037,21871245,21871334,21871481,21871877,21871988,21872204,21872715,21873008,21873363,21873785,21873972,21874272,21874475,21875538,21875747,21876019,21876472,21878936,21879072,21893419,21893459,21893520,21893558,21893594,21893633,21893679,21893712,21893773,21893795,21893837,21893870,21893907,21893931,21893970,21893987,21894039,2189407', 'assoc_port': '21779443:21779742,21779445:21824117,21779446:21806196,21779447:21780738,21779448:21780346,21779449:21780375,21779450:21780519,21779451:21780228,21779452:21779774,21780856:21823610,21780857:21808342,21780858:21808590,21780859:21808790,21780860:21821254,21780861:21809560,21780862:21809892,21780864:21810169,21780865:21810373,21780884:21810575,21780893:21811285,21780918:21808764,21780919:21810431,21780920:21803002,21780921:21788840,21780922:21784921,21780923:21784532,21780924:21784212,21780925:21783308,21780926:21783573,21780927:21782835,21780928:21781334,21780929:21781374,21780930:21781448,21781684:21782104,21784663:21794692,21789865:21790567,21790680:21790825,21792144:21792500,21794660:21795169,21798252:21799031,21804156:21804538,21805181:21805487,21808651:21809350,21812511:21812730,21815718:21815937,21818667:21818939,21820590:21820880,21820591:21820802,21828551:21831887,21828553:21833326,21828555:21830699,21828557:21830170,21828559:21829682,21828563:21841988,21828591:21829009,21830807:21830935,21833540:2183387', 'assoc_mat': '21779443:pet_clair:4213:21779742,21779445:pet_clair:4213:21824117,21779446:pet_clair:4213:21806196,21779447:pet_clair:4213:21780738,21779448:pet_clair:4213:21780346,21779449:pet_clair:4213:21780375,21779450:pet_clair:4213:21780519,21779451:pet_clair:4213:21780228,21779452:pet_clair:4213:21779774,21780856:pet_clair:4213:21823610,21780857:pet_clair:4213:21808342,21780858:pet_clair:4213:21808590,21780859:pet_clair:4213:21808790,21780860:pet_clair:4213:21821254,21780861:pet_clair:4213:21809560,21780862:pet_clair:4213:21809892,21780864:pet_clair:4213:21810169,21780865:pet_clair:4213:21810373,21780884:pet_clair:4213:21810575,21780893:pet_clair:4213:21811285,21780918:pet_clair:4213:21808764,21780919:pet_clair:4213:21810431,21780920:pet_clair:4213:21803002,21780921:pet_clair:4213:21788840,21780922:pet_clair:4213:21784921,21780923:pet_clair:4213:21784532,21780924:pet_clair:4213:21784212,21780925:pet_clair:4213:21783308,21780926:pet_clair:4213:21783573,21780927:pet_clair:4213:21782835,21780928:pet_clair:4213:21781334,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00043725757788750416, 'nb_photo': 57, 'list_port_cont': '21779749,21780376,21780734,21782832,21784916,21788839,21790568,21795176,21805495,21808596,21808756,21809563,21810185,21810425,21810576,21811300,21820814,21823616,21824105,21829018,21830695,21842329,21867288,21871249,21871880,21874285,21874480,21875526,21878938,21879076,21893689,21893865,21893900,21893983,21894082,21906388,21906589,21906914,21908293,21912973,21922246,21924153,21928882', 'assoc_port': '21779443:21779749,21779445:21824105,21779447:21780734,21779449:21780376,21780856:21823616,21780858:21808596,21780861:21809563,21780864:21810185,21780884:21810576,21780893:21811300,21780918:21808756,21780919:21810425,21780921:21788839,21780922:21784916,21780927:21782832,21789865:21790568,21794660:21795176,21805181:21805495,21820591:21820814,21828555:21830695,21828591:21829018,21842152:21842329,21867163:21867288,21870288:21871249,21870296:21871880,21874197:21874285,21874392:21874480,21875393:21875526,21878609:21878938,21878613:21879076,21893303:21893900,21893324:21894082,21893330:21893983,21893354:21893689,21893374:21893865,21897331:21906589,21902683:21906914,21906318:21906388,21908083:21908293,21911971:21912973,21920703:21924153,21922021:21922246,21928540:21928882', 'assoc_mat': '21779443:pet_fonce:4213:21779749,21779445:pet_fonce:4213:21824105,21779447:pet_fonce:4213:21780734,21779449:pet_fonce:4213:21780376,21780856:pet_fonce:4213:21823616,21780858:pet_fonce:4213:21808596,21780861:pet_fonce:4213:21809563,21780864:pet_fonce:4213:21810185,21780884:pet_fonce:4213:21810576,21780893:pet_fonce:4213:21811300,21780918:pet_fonce:4213:21808756,21780919:pet_fonce:4213:21810425,21780921:pet_fonce:4213:21788839,21780922:pet_fonce:4213:21784916,21780927:pet_fonce:4213:21782832,21789865:pet_fonce:4213:21790568,21794660:pet_fonce:4213:21795176,21805181:pet_fonce:4213:21805495,21820591:pet_fonce:4213:21820814,21828555:pet_fonce:4213:21830695,21828591:pet_fonce:4213:21829018,21842152:pet_fonce:4213:21842329,21867163:pet_fonce:4213:21867288,21870288:pet_fonce:4213:21871249,21870296:pet_fonce:4213:21871880,21874197:pet_fonce:4213:21874285,21874392:pet_fonce:4213:21874480,21875393:pet_fonce:4213:21875526,21878609:pet_fonce:4213:21878938,21878613:pet_fonce:4213:21879076,21893303:pet_fonce:4213:21893900,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.012128502836052593, 'nb_photo': 2003, 'list_port_cont': '21779745,21779778,21780221,21780338,21780370,21780507,21780727,21781341,21781370,21781441,21782106,21782840,21783309,21783563,21784216,21784528,21784912,21788842,21790571,21790832,21792488,21794688,21795174,21799034,21803003,21804551,21805494,21806194,21808346,21808595,21808754,21808795,21809351,21809561,21809893,21810175,21810374,21810424,21810579,21811295,21812743,21815931,21818940,21820798,21820887,21821250,21823615,21824114,21829012,21830175,21830686,21830936,21831900,21833333,21833875,21836272,21839679,21841993,21842345,21844053,21844566,21848134,21853160,21854007,21855532,21858536,21860516,21862164,21863013,21866538,21867294,21870450,21870663,21870736,21870868,21871027,21871254,21871340,21871487,21871884,21871982,21872215,21872712,21873007,21873351,21873781,21873981,21874279,21874472,21875536,21875736,21876006,21876480,21878940,21879085,21893415,21893465,21893531,21893564,21893593,21893626,21893681,21893713,21893766,21893806,21893842,21893875,21893911,21893935,21893974,21893993,21894040,21894072,2189410', 'assoc_port': '21779443:21779745,21779445:21824114,21779446:21806194,21779447:21780727,21779448:21780338,21779449:21780370,21779450:21780507,21779451:21780221,21779452:21779778,21780856:21823615,21780857:21808346,21780858:21808595,21780859:21808795,21780860:21821250,21780861:21809561,21780862:21809893,21780864:21810175,21780865:21810374,21780884:21810579,21780893:21811295,21780918:21808754,21780919:21810424,21780920:21803003,21780921:21788842,21780922:21784912,21780923:21784528,21780924:21784216,21780925:21783309,21780926:21783563,21780927:21782840,21780928:21781341,21780929:21781370,21780930:21781441,21781684:21782106,21784663:21794688,21789865:21790571,21790680:21790832,21792144:21792488,21794660:21795174,21798252:21799034,21804156:21804551,21805181:21805494,21808651:21809351,21812511:21812743,21815718:21815931,21818667:21818940,21820590:21820887,21820591:21820798,21828551:21831900,21828553:21833333,21828555:21830686,21828557:21830175,21828563:21841993,21828591:21829012,21830807:21830936,21833540:21833875,21835986:2183627', 'assoc_mat': '21779443:pet_opaque:4213:21779745,21779445:pet_opaque:4213:21824114,21779446:pet_opaque:4213:21806194,21779447:pet_opaque:4213:21780727,21779448:pet_opaque:4213:21780338,21779449:pet_opaque:4213:21780370,21779450:pet_opaque:4213:21780507,21779451:pet_opaque:4213:21780221,21779452:pet_opaque:4213:21779778,21780856:pet_opaque:4213:21823615,21780857:pet_opaque:4213:21808346,21780858:pet_opaque:4213:21808595,21780859:pet_opaque:4213:21808795,21780860:pet_opaque:4213:21821250,21780861:pet_opaque:4213:21809561,21780862:pet_opaque:4213:21809893,21780864:pet_opaque:4213:21810175,21780865:pet_opaque:4213:21810374,21780884:pet_opaque:4213:21810579,21780893:pet_opaque:4213:21811295,21780918:pet_opaque:4213:21808754,21780919:pet_opaque:4213:21810424,21780920:pet_opaque:4213:21803003,21780921:pet_opaque:4213:21788842,21780922:pet_opaque:4213:21784912,21780923:pet_opaque:4213:21784528,21780924:pet_opaque:4213:21784216,21780925:pet_opaque:4213:21783309,21780926:pet_opaque:4213:21783563,21780927:pet_opaque:4213:21782840,2178'}) 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(1700907,1704301,1707893,1709702,1710244,1713808)); after get_hostname_from_raspi hasthag : refus hasthag that could be used but not yet : _______refus,textiles_sanitaires SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______refus' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=983) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=15 and date >='2025-03-01' and date <= '2025-03-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((3918,),), 'unwanted_material_monthly_percentage': ((0.1134844828553655,),), 'material_repartition': (('refus', 2938),), 'material_dict': {'refus': 2938}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 26), 0.09816619325535392, 1312), (datetime.date(2025, 3, 27), 0.12102760736640707, 409), (datetime.date(2025, 3, 28), 0.12244262814496973, 368), (datetime.date(2025, 3, 29), 0.12691441401173878, 496), (datetime.date(2025, 3, 30), 0.1202330125523819, 353), (datetime.date(2025, 3, 31), 0.1202695709735065, 980)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 3, 26), 0.09816619325535392, 1312), (datetime.date(2025, 3, 27), 0.12102760736640707, 409), (datetime.date(2025, 3, 28), 0.12244262814496973, 368), (datetime.date(2025, 3, 29), 0.12691441401173878, 496), (datetime.date(2025, 3, 30), 0.1202330125523819, 353), (datetime.date(2025, 3, 31), 0.1202695709735065, 980))}, 'quality_array': [['-2.3281674844066593', '26032025'], ['-3.2824344148806883', '27032025'], ['-2.8603423024924752', '28032025'], ['-2.7436052665419965', '29032025'], ['-2.539876298250719', '30032025'], ['-2.391104079290964', '31032025']], 'number_of_batch': ((142,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032400499317800807, 'nb_photo': 661, 'list_port_cont': '21779740,21779775,21780345,21780531,21780722,21781346,21781376,21781450,21782827,21783299,21783576,21784533,21784927,21788845,21790562,21790831,21795167,21799037,21803015,21804543,21805485,21806192,21808332,21808589,21808749,21808789,21809349,21809573,21809898,21810181,21810366,21810427,21810571,21811303,21812738,21815933,21820797,21820895,21821256,21823601,21824107,21829002,21830162,21830700,21830943,21833324,21833862,21836262,21839681,21841990,21842349,21844555,21848132,21853162,21854019,21855524,21858545,21860513,21863019,21866534,21867291,21870664,21870742,21870862,21871030,21871241,21871337,21871479,21871885,21872201,21872717,21873012,21873784,21873985,21874278,21875531,21875744,21876479,21879086,21893416,21893532,21893562,21893595,21893628,21893675,21893723,21893810,21893843,21893873,21893896,21893982,21894043,21894078,21894120,21894144,21894208,21897808,21898025,21900222,21900534,21900666,21904907,21906394,21906451,21906542,21906591,21906905,21906955,21907458,21908292,21912966,21914875,21916054,2192193', 'assoc_port': '21779443:21779740,21779445:21824107,21779446:21806192,21779447:21780722,21779448:21780345,21779450:21780531,21779452:21779775,21780856:21823601,21780857:21808332,21780858:21808589,21780859:21808789,21780860:21821256,21780861:21809573,21780862:21809898,21780864:21810181,21780865:21810366,21780884:21810571,21780893:21811303,21780918:21808749,21780919:21810427,21780920:21803015,21780921:21788845,21780922:21784927,21780923:21784533,21780925:21783299,21780926:21783576,21780927:21782827,21780928:21781346,21780929:21781376,21780930:21781450,21789865:21790562,21790680:21790831,21794660:21795167,21798252:21799037,21804156:21804543,21805181:21805485,21808651:21809349,21812511:21812738,21815718:21815933,21820590:21820895,21820591:21820797,21828553:21833324,21828555:21830700,21828557:21830162,21828563:21841990,21828591:21829002,21830807:21830943,21833540:21833862,21835986:21836262,21838936:21839681,21842152:21842349,21844435:21844555,21847639:21848132,21852283:21853162,21853646:21854019,21855235:21855524,21857529:2185854', 'assoc_mat': '21779443:barquette_opaque:4213:21779740,21779445:barquette_opaque:4213:21824107,21779446:barquette_opaque:4213:21806192,21779447:barquette_opaque:4213:21780722,21779448:barquette_opaque:4213:21780345,21779450:barquette_opaque:4213:21780531,21779452:barquette_opaque:4213:21779775,21780856:barquette_opaque:4213:21823601,21780857:barquette_opaque:4213:21808332,21780858:barquette_opaque:4213:21808589,21780859:barquette_opaque:4213:21808789,21780860:barquette_opaque:4213:21821256,21780861:barquette_opaque:4213:21809573,21780862:barquette_opaque:4213:21809898,21780864:barquette_opaque:4213:21810181,21780865:barquette_opaque:4213:21810366,21780884:barquette_opaque:4213:21810571,21780893:barquette_opaque:4213:21811303,21780918:barquette_opaque:4213:21808749,21780919:barquette_opaque:4213:21810427,21780920:barquette_opaque:4213:21803015,21780921:barquette_opaque:4213:21788845,21780922:barquette_opaque:4213:21784927,21780923:barquette_opaque:4213:21784533,21780925:barquette_opaque:4213:21783299,21780926:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0028658200003600824, 'nb_photo': 876, 'list_port_cont': '21779748,21779782,21780227,21780336,21780372,21780511,21780735,21781344,21781377,21781440,21782112,21782829,21783310,21784525,21784918,21788831,21790563,21790829,21795180,21799026,21803007,21804539,21805481,21806190,21808337,21808598,21808759,21808784,21809364,21809564,21809897,21810173,21810381,21810426,21810582,21811284,21812762,21815929,21818943,21820809,21820888,21821243,21823611,21824102,21829013,21830168,21830689,21830933,21831892,21833321,21833859,21839680,21841981,21844063,21844558,21848128,21853171,21854017,21855537,21858531,21863010,21866543,21867297,21870439,21870666,21870726,21870874,21871038,21871256,21871335,21871493,21871888,21871979,21872209,21872725,21873005,21873361,21873787,21873980,21874282,21874481,21875530,21875739,21876005,21876471,21878933,21879080,21893417,21893535,21893567,21893592,21893631,21893688,21893761,21893798,21893832,21893863,21893905,21893972,21893986,21894071,21894107,21894140,21894176,21894207,21897824,21898022,21900223,21900532,21900674,21904905,21906402,21906460,2190654', 'assoc_port': '21779443:21779748,21779445:21824102,21779446:21806190,21779447:21780735,21779448:21780336,21779449:21780372,21779450:21780511,21779451:21780227,21779452:21779782,21780856:21823611,21780857:21808337,21780858:21808598,21780859:21808784,21780860:21821243,21780861:21809564,21780862:21809897,21780864:21810173,21780865:21810381,21780884:21810582,21780893:21811284,21780918:21808759,21780919:21810426,21780920:21803007,21780921:21788831,21780922:21784918,21780923:21784525,21780925:21783310,21780927:21782829,21780928:21781344,21780929:21781377,21780930:21781440,21781684:21782112,21789865:21790563,21790680:21790829,21794660:21795180,21798252:21799026,21804156:21804539,21805181:21805481,21808651:21809364,21812511:21812762,21815718:21815929,21818667:21818943,21820590:21820888,21820591:21820809,21828551:21831892,21828553:21833321,21828555:21830689,21828557:21830168,21828563:21841981,21828591:21829013,21830807:21830933,21833540:21833859,21838936:21839680,21843928:21844063,21844435:21844558,21847639:21848128,21852283:2185317', 'assoc_mat': '21779443:carton:4213:21779748,21779445:carton:4213:21824102,21779446:carton:4213:21806190,21779447:carton:4213:21780735,21779448:carton:4213:21780336,21779449:carton:4213:21780372,21779450:carton:4213:21780511,21779451:carton:4213:21780227,21779452:carton:4213:21779782,21780856:carton:4213:21823611,21780857:carton:4213:21808337,21780858:carton:4213:21808598,21780859:carton:4213:21808784,21780860:carton:4213:21821243,21780861:carton:4213:21809564,21780862:carton:4213:21809897,21780864:carton:4213:21810173,21780865:carton:4213:21810381,21780884:carton:4213:21810582,21780893:carton:4213:21811284,21780918:carton:4213:21808759,21780919:carton:4213:21810426,21780920:carton:4213:21803007,21780921:carton:4213:21788831,21780922:carton:4213:21784918,21780923:carton:4213:21784525,21780925:carton:4213:21783310,21780927:carton:4213:21782829,21780928:carton:4213:21781344,21780929:carton:4213:21781377,21780930:carton:4213:21781440,21781684:carton:4213:21782112,21789865:carton:4213:21790563,21790680:carton:4213:21790829,2179'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032510347972613965, 'nb_photo': 198, 'list_port_cont': '21779743,21780378,21780513,21780725,21781348,21781381,21781444,21783307,21784219,21784926,21788844,21790570,21794694,21795172,21799028,21803000,21804552,21806201,21808339,21808587,21808763,21808792,21809895,21810170,21810371,21810434,21810578,21811288,21812724,21815941,21818949,21820811,21820893,21821259,21823609,21824108,21829684,21830702,21833336,21833866,21839683,21863018,21866536,21867298,21870453,21870730,21871041,21871242,21871494,21873002,21873776,21874286,21875533,21875741,21876010,21878929,21893534,21893557,21893591,21893676,21893710,21893809,21893838,21893862,21893898,21893980,21894074,21894147,21894181,21897818,21898024,21900220,21900537,21900675,21904911,21906400,21906538,21906579,21906966,21907448,21908302,21914872,21916055,21921932,21922248,21923471,21924143,21928873,21930864', 'assoc_port': '21779443:21779743,21779445:21824108,21779446:21806201,21779447:21780725,21779449:21780378,21779450:21780513,21780856:21823609,21780857:21808339,21780858:21808587,21780859:21808792,21780860:21821259,21780862:21809895,21780864:21810170,21780865:21810371,21780884:21810578,21780893:21811288,21780918:21808763,21780919:21810434,21780920:21803000,21780921:21788844,21780922:21784926,21780924:21784219,21780925:21783307,21780928:21781348,21780929:21781381,21780930:21781444,21784663:21794694,21789865:21790570,21794660:21795172,21798252:21799028,21804156:21804552,21812511:21812724,21815718:21815941,21818667:21818949,21820590:21820893,21820591:21820811,21828553:21833336,21828555:21830702,21828559:21829684,21833540:21833866,21838936:21839683,21862868:21863018,21866429:21866536,21867163:21867298,21870286:21871041,21870288:21871242,21870291:21871494,21870293:21870730,21870297:21870453,21872995:21873002,21873752:21873776,21874197:21874286,21875393:21875533,21875733:21875741,21875983:21876010,21878609:21878929,21893284:2189383', 'assoc_mat': '21779443:ela:4213:21779743,21779445:ela:4213:21824108,21779446:ela:4213:21806201,21779447:ela:4213:21780725,21779449:ela:4213:21780378,21779450:ela:4213:21780513,21780856:ela:4213:21823609,21780857:ela:4213:21808339,21780858:ela:4213:21808587,21780859:ela:4213:21808792,21780860:ela:4213:21821259,21780862:ela:4213:21809895,21780864:ela:4213:21810170,21780865:ela:4213:21810371,21780884:ela:4213:21810578,21780893:ela:4213:21811288,21780918:ela:4213:21808763,21780919:ela:4213:21810434,21780920:ela:4213:21803000,21780921:ela:4213:21788844,21780922:ela:4213:21784926,21780924:ela:4213:21784219,21780925:ela:4213:21783307,21780928:ela:4213:21781348,21780929:ela:4213:21781381,21780930:ela:4213:21781444,21784663:ela:4213:21794694,21789865:ela:4213:21790570,21794660:ela:4213:21795172,21798252:ela:4213:21799028,21804156:ela:4213:21804552,21812511:ela:4213:21812724,21815718:ela:4213:21815941,21818667:ela:4213:21818949,21820590:ela:4213:21820893,21820591:ela:4213:21820811,21828553:ela:4213:21833336,21828555:ela:4213:2183070'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0028444782452004226, 'nb_photo': 981, 'list_port_cont': '21779751,21779784,21780225,21780333,21780371,21780525,21780724,21781335,21781372,21781439,21783295,21784206,21784531,21784925,21788836,21790569,21790821,21792496,21795168,21799032,21803011,21804545,21805496,21806209,21808345,21808600,21808752,21808797,21809363,21809558,21809896,21810174,21810368,21810429,21810581,21811293,21812725,21815934,21818951,21820807,21820890,21821246,21823602,21824116,21829016,21829692,21830167,21830696,21830939,21831890,21833329,21833863,21836270,21839693,21841991,21842355,21844050,21844556,21848139,21853168,21854005,21855535,21858546,21862165,21863008,21866539,21867284,21870440,21870677,21870739,21870871,21871034,21871255,21871333,21871485,21871879,21871987,21872203,21872716,21873010,21873780,21873971,21874288,21874471,21875748,21876004,21876474,21878931,21879074,21893428,21893451,21893529,21893561,21893598,21893637,21893677,21893721,21893764,21893794,21893836,21893866,21893904,21893944,21894042,21894087,21894110,21894188,21894223,21897809,21898033,21900224,21900541,21900671,2190490', 'assoc_port': '21779443:21779751,21779445:21824116,21779446:21806209,21779447:21780724,21779448:21780333,21779449:21780371,21779450:21780525,21779451:21780225,21779452:21779784,21780856:21823602,21780857:21808345,21780858:21808600,21780859:21808797,21780860:21821246,21780861:21809558,21780862:21809896,21780864:21810174,21780865:21810368,21780884:21810581,21780893:21811293,21780918:21808752,21780919:21810429,21780920:21803011,21780921:21788836,21780922:21784925,21780923:21784531,21780924:21784206,21780925:21783295,21780928:21781335,21780929:21781372,21780930:21781439,21789865:21790569,21790680:21790821,21792144:21792496,21794660:21795168,21798252:21799032,21804156:21804545,21805181:21805496,21808651:21809363,21812511:21812725,21815718:21815934,21818667:21818951,21820590:21820890,21820591:21820807,21828551:21831890,21828553:21833329,21828555:21830696,21828557:21830167,21828559:21829692,21828563:21841991,21828591:21829016,21830807:21830939,21833540:21833863,21835986:21836270,21838936:21839693,21842152:21842355,21843928:2184405', 'assoc_mat': '21779443:etiquette:4213:21779751,21779445:etiquette:4213:21824116,21779446:etiquette:4213:21806209,21779447:etiquette:4213:21780724,21779448:etiquette:4213:21780333,21779449:etiquette:4213:21780371,21779450:etiquette:4213:21780525,21779451:etiquette:4213:21780225,21779452:etiquette:4213:21779784,21780856:etiquette:4213:21823602,21780857:etiquette:4213:21808345,21780858:etiquette:4213:21808600,21780859:etiquette:4213:21808797,21780860:etiquette:4213:21821246,21780861:etiquette:4213:21809558,21780862:etiquette:4213:21809896,21780864:etiquette:4213:21810174,21780865:etiquette:4213:21810368,21780884:etiquette:4213:21810581,21780893:etiquette:4213:21811293,21780918:etiquette:4213:21808752,21780919:etiquette:4213:21810429,21780920:etiquette:4213:21803011,21780921:etiquette:4213:21788836,21780922:etiquette:4213:21784925,21780923:etiquette:4213:21784531,21780924:etiquette:4213:21784206,21780925:etiquette:4213:21783295,21780928:etiquette:4213:21781335,21780929:etiquette:4213:21781372,21780930:etiquette:4213:21781439,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03124399298868142, 'nb_photo': 2484, 'list_port_cont': '21779735,21779770,21780229,21780334,21780366,21780517,21780730,21781343,21781368,21781455,21782109,21783302,21783567,21784215,21784519,21784919,21788837,21790560,21790817,21792492,21794701,21795181,21799040,21803005,21804549,21805486,21806206,21808347,21808602,21808765,21808787,21809358,21809568,21809883,21810177,21810378,21810428,21810570,21811289,21812760,21815935,21818946,21820800,21820886,21821244,21823606,21824103,21829007,21829677,21830176,21830701,21830944,21831889,21833332,21833867,21836263,21839689,21841994,21842351,21844056,21844561,21848141,21853173,21854011,21855525,21858543,21860511,21862163,21863012,21866544,21867293,21870449,21870678,21870740,21870867,21871026,21871250,21871338,21871484,21871882,21871993,21872206,21872723,21873003,21873348,21873783,21873975,21874284,21874482,21875522,21875750,21876012,21876481,21878930,21879075,21893426,21893450,21893525,21893559,21893600,21893624,21893680,21893708,21893768,21893800,21893839,21893877,21893906,21893941,21893973,21894000,21894044,21894085,2189411', 'assoc_port': '21779443:21779735,21779445:21824103,21779446:21806206,21779447:21780730,21779448:21780334,21779449:21780366,21779450:21780517,21779451:21780229,21779452:21779770,21780856:21823606,21780857:21808347,21780858:21808602,21780859:21808787,21780860:21821244,21780861:21809568,21780862:21809883,21780864:21810177,21780865:21810378,21780884:21810570,21780893:21811289,21780918:21808765,21780919:21810428,21780920:21803005,21780921:21788837,21780922:21784919,21780923:21784519,21780924:21784215,21780925:21783302,21780926:21783567,21780928:21781343,21780929:21781368,21780930:21781455,21781684:21782109,21784663:21794701,21789865:21790560,21790680:21790817,21792144:21792492,21794660:21795181,21798252:21799040,21804156:21804549,21805181:21805486,21808651:21809358,21812511:21812760,21815718:21815935,21818667:21818946,21820590:21820886,21820591:21820800,21828551:21831889,21828553:21833332,21828555:21830701,21828557:21830176,21828559:21829677,21828563:21841994,21828591:21829007,21830807:21830944,21833540:21833867,21835986:2183626', 'assoc_mat': '21779443:film_plastique:4213:21779735,21779445:film_plastique:4213:21824103,21779446:film_plastique:4213:21806206,21779447:film_plastique:4213:21780730,21779448:film_plastique:4213:21780334,21779449:film_plastique:4213:21780366,21779450:film_plastique:4213:21780517,21779451:film_plastique:4213:21780229,21779452:film_plastique:4213:21779770,21780856:film_plastique:4213:21823606,21780857:film_plastique:4213:21808347,21780858:film_plastique:4213:21808602,21780859:film_plastique:4213:21808787,21780860:film_plastique:4213:21821244,21780861:film_plastique:4213:21809568,21780862:film_plastique:4213:21809883,21780864:film_plastique:4213:21810177,21780865:film_plastique:4213:21810378,21780884:film_plastique:4213:21810570,21780893:film_plastique:4213:21811289,21780918:film_plastique:4213:21808765,21780919:film_plastique:4213:21810428,21780920:film_plastique:4213:21803005,21780921:film_plastique:4213:21788837,21780922:film_plastique:4213:21784919,21780923:film_plastique:4213:21784519,21780924:film_plastique:4213:2178421'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0006829393527929814, 'nb_photo': 10, 'list_port_cont': '21781345,21821249,21830694,21855526,21863014,21874281,21900668,21907449,21928874', 'assoc_port': '21780860:21821249,21780928:21781345,21828555:21830694,21855235:21855526,21862868:21863014,21874197:21874281,21897326:21900668,21902685:21907449,21928540:21928874', 'assoc_mat': '21780860:kraft:4213:21821249,21780928:kraft:4213:21781345,21828555:kraft:4213:21830694,21855235:kraft:4213:21855526,21862868:kraft:4213:21863014,21874197:kraft:4213:21874281,21897326:kraft:4213:21900668,21902685:kraft:4213:21907449,21928540:kraft:4213:21928874'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.005447345257634398, 'nb_photo': 2464, 'list_port_cont': '21779741,21779773,21780219,21780330,21780364,21780508,21780726,21781337,21781371,21781454,21782100,21782830,21783294,21783568,21784205,21784524,21784914,21788830,21790556,21790827,21792493,21794699,21795177,21799035,21803006,21804546,21805491,21806189,21808341,21808599,21808762,21808798,21809353,21809555,21809885,21810184,21810372,21810436,21810583,21811301,21812744,21815939,21818942,21820808,21820894,21821248,21823612,21824115,21829004,21829680,21830174,21830692,21830927,21831885,21833335,21833872,21836264,21839692,21841987,21842335,21844059,21844554,21848143,21853163,21854008,21855530,21858534,21860512,21862158,21863015,21866541,21867285,21870452,21870670,21870741,21870865,21871036,21871243,21871339,21871483,21871875,21871990,21872199,21872713,21873004,21873350,21873778,21873986,21874276,21874479,21875520,21875742,21876008,21876485,21878944,21879084,21893418,21893462,21893524,21893554,21893603,21893638,21893684,21893709,21893769,21893801,21893834,21893868,21893903,21893933,21893981,21894038,21894077,2189412', 'assoc_port': '21779443:21779741,21779445:21824115,21779446:21806189,21779447:21780726,21779448:21780330,21779449:21780364,21779450:21780508,21779451:21780219,21779452:21779773,21780856:21823612,21780857:21808341,21780858:21808599,21780859:21808798,21780860:21821248,21780861:21809555,21780862:21809885,21780864:21810184,21780865:21810372,21780884:21810583,21780893:21811301,21780918:21808762,21780919:21810436,21780920:21803006,21780921:21788830,21780922:21784914,21780923:21784524,21780924:21784205,21780925:21783294,21780926:21783568,21780927:21782830,21780928:21781337,21780929:21781371,21780930:21781454,21781684:21782100,21784663:21794699,21789865:21790556,21790680:21790827,21792144:21792493,21794660:21795177,21798252:21799035,21804156:21804546,21805181:21805491,21808651:21809353,21812511:21812744,21815718:21815939,21818667:21818942,21820590:21820894,21820591:21820808,21828551:21831885,21828553:21833335,21828555:21830692,21828557:21830174,21828559:21829680,21828563:21841987,21828591:21829004,21830807:21830927,21833540:2183387', 'assoc_mat': '21779443:metal:4213:21779741,21779445:metal:4213:21824115,21779446:metal:4213:21806189,21779447:metal:4213:21780726,21779448:metal:4213:21780330,21779449:metal:4213:21780364,21779450:metal:4213:21780508,21779451:metal:4213:21780219,21779452:metal:4213:21779773,21780856:metal:4213:21823612,21780857:metal:4213:21808341,21780858:metal:4213:21808599,21780859:metal:4213:21808798,21780860:metal:4213:21821248,21780861:metal:4213:21809555,21780862:metal:4213:21809885,21780864:metal:4213:21810184,21780865:metal:4213:21810372,21780884:metal:4213:21810583,21780893:metal:4213:21811301,21780918:metal:4213:21808762,21780919:metal:4213:21810436,21780920:metal:4213:21803006,21780921:metal:4213:21788830,21780922:metal:4213:21784914,21780923:metal:4213:21784524,21780924:metal:4213:21784205,21780925:metal:4213:21783294,21780926:metal:4213:21783568,21780927:metal:4213:21782830,21780928:metal:4213:21781337,21780929:metal:4213:21781371,21780930:metal:4213:21781454,21781684:metal:4213:21782100,21784663:metal:4213:21794699,21789865:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.02945414163585054, 'nb_photo': 3892, 'list_port_cont': '21779744,21779777,21780220,21780337,21780368,21780515,21780723,21781339,21781378,21781442,21782099,21782839,21783298,21783570,21784211,21784526,21784915,21788843,21790561,21790823,21792499,21794700,21795179,21799027,21803008,21804544,21805484,21806197,21808340,21808588,21808760,21808783,21809361,21809562,21809886,21810183,21810365,21810437,21810580,21811291,21812745,21815928,21818947,21820801,21820892,21821252,21823605,21824110,21829010,21829693,21830171,21830698,21830942,21831894,21833331,21833874,21836271,21839687,21841978,21842327,21844058,21844564,21848140,21853172,21854015,21855533,21858537,21860507,21862169,21863022,21866532,21867290,21870451,21870673,21870734,21870863,21871040,21871253,21871332,21871488,21871889,21871994,21872208,21872724,21873001,21873349,21873775,21873984,21874277,21874484,21875535,21875749,21876011,21876473,21878942,21879081,21893424,21893463,21893533,21893555,21893589,21893630,21893686,21893711,21893765,21893797,21893830,21893874,21893912,21893934,21893969,21893989,21894048,2189408', 'assoc_port': '21779443:21779744,21779445:21824110,21779446:21806197,21779447:21780723,21779448:21780337,21779449:21780368,21779450:21780515,21779451:21780220,21779452:21779777,21780856:21823605,21780857:21808340,21780858:21808588,21780859:21808783,21780860:21821252,21780861:21809562,21780862:21809886,21780864:21810183,21780865:21810365,21780884:21810580,21780893:21811291,21780918:21808760,21780919:21810437,21780920:21803008,21780921:21788843,21780922:21784915,21780923:21784526,21780924:21784211,21780925:21783298,21780926:21783570,21780927:21782839,21780928:21781339,21780929:21781378,21780930:21781442,21781684:21782099,21784663:21794700,21789865:21790561,21790680:21790823,21792144:21792499,21794660:21795179,21798252:21799027,21804156:21804544,21805181:21805484,21808651:21809361,21812511:21812745,21815718:21815928,21818667:21818947,21820590:21820892,21820591:21820801,21828551:21831894,21828553:21833331,21828555:21830698,21828557:21830171,21828559:21829693,21828563:21841978,21828591:21829010,21830807:21830942,21833540:2183387', 'assoc_mat': '21779443:papier:4213:21779744,21779445:papier:4213:21824110,21779446:papier:4213:21806197,21779447:papier:4213:21780723,21779448:papier:4213:21780337,21779449:papier:4213:21780368,21779450:papier:4213:21780515,21779451:papier:4213:21780220,21779452:papier:4213:21779777,21780856:papier:4213:21823605,21780857:papier:4213:21808340,21780858:papier:4213:21808588,21780859:papier:4213:21808783,21780860:papier:4213:21821252,21780861:papier:4213:21809562,21780862:papier:4213:21809886,21780864:papier:4213:21810183,21780865:papier:4213:21810365,21780884:papier:4213:21810580,21780893:papier:4213:21811291,21780918:papier:4213:21808760,21780919:papier:4213:21810437,21780920:papier:4213:21803008,21780921:papier:4213:21788843,21780922:papier:4213:21784915,21780923:papier:4213:21784526,21780924:papier:4213:21784211,21780925:papier:4213:21783298,21780926:papier:4213:21783570,21780927:papier:4213:21782839,21780928:papier:4213:21781339,21780929:papier:4213:21781378,21780930:papier:4213:21781442,21781684:papier:4213:21782099,2178'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0029523534730137575, 'nb_photo': 69, 'list_port_cont': '21781347,21781375,21782836,21784924,21790572,21792504,21799036,21803014,21808334,21808592,21808755,21809559,21810172,21810430,21811297,21820803,21823613,21829014,21830178,21831891,21836258,21839686,21854009,21866530,21867282,21871029,21871486,21874273,21876486,21893587,21893678,21893844,21893943,21897814,21898026,21900525,21906393,21906581,21906908,21907445,21908296,21916067,21921931,21923483,21924147,21928878,21930861', 'assoc_port': '21780856:21823613,21780857:21808334,21780858:21808592,21780861:21809559,21780864:21810172,21780893:21811297,21780918:21808755,21780919:21810430,21780920:21803014,21780922:21784924,21780927:21782836,21780928:21781347,21780929:21781375,21789865:21790572,21792144:21792504,21798252:21799036,21820591:21820803,21828551:21831891,21828557:21830178,21828591:21829014,21835986:21836258,21838936:21839686,21853646:21854009,21866429:21866530,21867163:21867282,21870286:21871029,21870291:21871486,21874197:21874273,21876288:21876486,21893284:21893844,21893329:21893943,21893354:21893678,21893378:21893587,21897325:21900525,21897327:21897814,21897328:21898026,21897331:21906581,21902683:21906908,21902685:21907445,21906318:21906393,21908083:21908296,21915814:21916067,21920703:21924147,21920704:21921931,21923361:21923483,21928540:21928878,21930515:21930861', 'assoc_mat': '21780856:pehd:4213:21823613,21780857:pehd:4213:21808334,21780858:pehd:4213:21808592,21780861:pehd:4213:21809559,21780864:pehd:4213:21810172,21780893:pehd:4213:21811297,21780918:pehd:4213:21808755,21780919:pehd:4213:21810430,21780920:pehd:4213:21803014,21780922:pehd:4213:21784924,21780927:pehd:4213:21782836,21780928:pehd:4213:21781347,21780929:pehd:4213:21781375,21789865:pehd:4213:21790572,21792144:pehd:4213:21792504,21798252:pehd:4213:21799036,21820591:pehd:4213:21820803,21828551:pehd:4213:21831891,21828557:pehd:4213:21830178,21828591:pehd:4213:21829014,21835986:pehd:4213:21836258,21838936:pehd:4213:21839686,21853646:pehd:4213:21854009,21866429:pehd:4213:21866530,21867163:pehd:4213:21867282,21870286:pehd:4213:21871029,21870291:pehd:4213:21871486,21874197:pehd:4213:21874273,21876288:pehd:4213:21876486,21893284:pehd:4213:21893844,21893329:pehd:4213:21893943,21893354:pehd:4213:21893678,21893378:pehd:4213:21893587,21897325:pehd:4213:21900525,21897327:pehd:4213:21897814,21897328:pehd:4213:21898026,21897331:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.022629260514299525, 'nb_photo': 3754, 'list_port_cont': '21779742,21779774,21780228,21780346,21780375,21780519,21780738,21781334,21781374,21781448,21782104,21782835,21783308,21783573,21784212,21784532,21784921,21788840,21790567,21790825,21792500,21794692,21795169,21799031,21803002,21804538,21805487,21806196,21808342,21808590,21808764,21808790,21809350,21809560,21809892,21810169,21810373,21810431,21810575,21811285,21812730,21815937,21818939,21820802,21820880,21821254,21823610,21824117,21829009,21829682,21830170,21830699,21830935,21831887,21833326,21833870,21836257,21839678,21841988,21842352,21844061,21844563,21848135,21853164,21854006,21855536,21858540,21860503,21862159,21863006,21866533,21867286,21870454,21870668,21870735,21870859,21871037,21871245,21871334,21871481,21871877,21871988,21872204,21872715,21873008,21873363,21873785,21873972,21874272,21874475,21875538,21875747,21876019,21876472,21878936,21879072,21893419,21893459,21893520,21893558,21893594,21893633,21893679,21893712,21893773,21893795,21893837,21893870,21893907,21893931,21893970,21893987,21894039,2189407', 'assoc_port': '21779443:21779742,21779445:21824117,21779446:21806196,21779447:21780738,21779448:21780346,21779449:21780375,21779450:21780519,21779451:21780228,21779452:21779774,21780856:21823610,21780857:21808342,21780858:21808590,21780859:21808790,21780860:21821254,21780861:21809560,21780862:21809892,21780864:21810169,21780865:21810373,21780884:21810575,21780893:21811285,21780918:21808764,21780919:21810431,21780920:21803002,21780921:21788840,21780922:21784921,21780923:21784532,21780924:21784212,21780925:21783308,21780926:21783573,21780927:21782835,21780928:21781334,21780929:21781374,21780930:21781448,21781684:21782104,21784663:21794692,21789865:21790567,21790680:21790825,21792144:21792500,21794660:21795169,21798252:21799031,21804156:21804538,21805181:21805487,21808651:21809350,21812511:21812730,21815718:21815937,21818667:21818939,21820590:21820880,21820591:21820802,21828551:21831887,21828553:21833326,21828555:21830699,21828557:21830170,21828559:21829682,21828563:21841988,21828591:21829009,21830807:21830935,21833540:2183387', 'assoc_mat': '21779443:pet_clair:4213:21779742,21779445:pet_clair:4213:21824117,21779446:pet_clair:4213:21806196,21779447:pet_clair:4213:21780738,21779448:pet_clair:4213:21780346,21779449:pet_clair:4213:21780375,21779450:pet_clair:4213:21780519,21779451:pet_clair:4213:21780228,21779452:pet_clair:4213:21779774,21780856:pet_clair:4213:21823610,21780857:pet_clair:4213:21808342,21780858:pet_clair:4213:21808590,21780859:pet_clair:4213:21808790,21780860:pet_clair:4213:21821254,21780861:pet_clair:4213:21809560,21780862:pet_clair:4213:21809892,21780864:pet_clair:4213:21810169,21780865:pet_clair:4213:21810373,21780884:pet_clair:4213:21810575,21780893:pet_clair:4213:21811285,21780918:pet_clair:4213:21808764,21780919:pet_clair:4213:21810431,21780920:pet_clair:4213:21803002,21780921:pet_clair:4213:21788840,21780922:pet_clair:4213:21784921,21780923:pet_clair:4213:21784532,21780924:pet_clair:4213:21784212,21780925:pet_clair:4213:21783308,21780926:pet_clair:4213:21783573,21780927:pet_clair:4213:21782835,21780928:pet_clair:4213:21781334,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00043725757788750416, 'nb_photo': 57, 'list_port_cont': '21779749,21780376,21780734,21782832,21784916,21788839,21790568,21795176,21805495,21808596,21808756,21809563,21810185,21810425,21810576,21811300,21820814,21823616,21824105,21829018,21830695,21842329,21867288,21871249,21871880,21874285,21874480,21875526,21878938,21879076,21893689,21893865,21893900,21893983,21894082,21906388,21906589,21906914,21908293,21912973,21922246,21924153,21928882', 'assoc_port': '21779443:21779749,21779445:21824105,21779447:21780734,21779449:21780376,21780856:21823616,21780858:21808596,21780861:21809563,21780864:21810185,21780884:21810576,21780893:21811300,21780918:21808756,21780919:21810425,21780921:21788839,21780922:21784916,21780927:21782832,21789865:21790568,21794660:21795176,21805181:21805495,21820591:21820814,21828555:21830695,21828591:21829018,21842152:21842329,21867163:21867288,21870288:21871249,21870296:21871880,21874197:21874285,21874392:21874480,21875393:21875526,21878609:21878938,21878613:21879076,21893303:21893900,21893324:21894082,21893330:21893983,21893354:21893689,21893374:21893865,21897331:21906589,21902683:21906914,21906318:21906388,21908083:21908293,21911971:21912973,21920703:21924153,21922021:21922246,21928540:21928882', 'assoc_mat': '21779443:pet_fonce:4213:21779749,21779445:pet_fonce:4213:21824105,21779447:pet_fonce:4213:21780734,21779449:pet_fonce:4213:21780376,21780856:pet_fonce:4213:21823616,21780858:pet_fonce:4213:21808596,21780861:pet_fonce:4213:21809563,21780864:pet_fonce:4213:21810185,21780884:pet_fonce:4213:21810576,21780893:pet_fonce:4213:21811300,21780918:pet_fonce:4213:21808756,21780919:pet_fonce:4213:21810425,21780921:pet_fonce:4213:21788839,21780922:pet_fonce:4213:21784916,21780927:pet_fonce:4213:21782832,21789865:pet_fonce:4213:21790568,21794660:pet_fonce:4213:21795176,21805181:pet_fonce:4213:21805495,21820591:pet_fonce:4213:21820814,21828555:pet_fonce:4213:21830695,21828591:pet_fonce:4213:21829018,21842152:pet_fonce:4213:21842329,21867163:pet_fonce:4213:21867288,21870288:pet_fonce:4213:21871249,21870296:pet_fonce:4213:21871880,21874197:pet_fonce:4213:21874285,21874392:pet_fonce:4213:21874480,21875393:pet_fonce:4213:21875526,21878609:pet_fonce:4213:21878938,21878613:pet_fonce:4213:21879076,21893303:pet_fonce:4213:21893900,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.012128502836052593, 'nb_photo': 2003, 'list_port_cont': '21779745,21779778,21780221,21780338,21780370,21780507,21780727,21781341,21781370,21781441,21782106,21782840,21783309,21783563,21784216,21784528,21784912,21788842,21790571,21790832,21792488,21794688,21795174,21799034,21803003,21804551,21805494,21806194,21808346,21808595,21808754,21808795,21809351,21809561,21809893,21810175,21810374,21810424,21810579,21811295,21812743,21815931,21818940,21820798,21820887,21821250,21823615,21824114,21829012,21830175,21830686,21830936,21831900,21833333,21833875,21836272,21839679,21841993,21842345,21844053,21844566,21848134,21853160,21854007,21855532,21858536,21860516,21862164,21863013,21866538,21867294,21870450,21870663,21870736,21870868,21871027,21871254,21871340,21871487,21871884,21871982,21872215,21872712,21873007,21873351,21873781,21873981,21874279,21874472,21875536,21875736,21876006,21876480,21878940,21879085,21893415,21893465,21893531,21893564,21893593,21893626,21893681,21893713,21893766,21893806,21893842,21893875,21893911,21893935,21893974,21893993,21894040,21894072,2189410', 'assoc_port': '21779443:21779745,21779445:21824114,21779446:21806194,21779447:21780727,21779448:21780338,21779449:21780370,21779450:21780507,21779451:21780221,21779452:21779778,21780856:21823615,21780857:21808346,21780858:21808595,21780859:21808795,21780860:21821250,21780861:21809561,21780862:21809893,21780864:21810175,21780865:21810374,21780884:21810579,21780893:21811295,21780918:21808754,21780919:21810424,21780920:21803003,21780921:21788842,21780922:21784912,21780923:21784528,21780924:21784216,21780925:21783309,21780926:21783563,21780927:21782840,21780928:21781341,21780929:21781370,21780930:21781441,21781684:21782106,21784663:21794688,21789865:21790571,21790680:21790832,21792144:21792488,21794660:21795174,21798252:21799034,21804156:21804551,21805181:21805494,21808651:21809351,21812511:21812743,21815718:21815931,21818667:21818940,21820590:21820887,21820591:21820798,21828551:21831900,21828553:21833333,21828555:21830686,21828557:21830175,21828563:21841993,21828591:21829012,21830807:21830936,21833540:21833875,21835986:2183627', 'assoc_mat': '21779443:pet_opaque:4213:21779745,21779445:pet_opaque:4213:21824114,21779446:pet_opaque:4213:21806194,21779447:pet_opaque:4213:21780727,21779448:pet_opaque:4213:21780338,21779449:pet_opaque:4213:21780370,21779450:pet_opaque:4213:21780507,21779451:pet_opaque:4213:21780221,21779452:pet_opaque:4213:21779778,21780856:pet_opaque:4213:21823615,21780857:pet_opaque:4213:21808346,21780858:pet_opaque:4213:21808595,21780859:pet_opaque:4213:21808795,21780860:pet_opaque:4213:21821250,21780861:pet_opaque:4213:21809561,21780862:pet_opaque:4213:21809893,21780864:pet_opaque:4213:21810175,21780865:pet_opaque:4213:21810374,21780884:pet_opaque:4213:21810579,21780893:pet_opaque:4213:21811295,21780918:pet_opaque:4213:21808754,21780919:pet_opaque:4213:21810424,21780920:pet_opaque:4213:21803003,21780921:pet_opaque:4213:21788842,21780922:pet_opaque:4213:21784912,21780923:pet_opaque:4213:21784528,21780924:pet_opaque:4213:21784216,21780925:pet_opaque:4213:21783309,21780926:pet_opaque:4213:21783563,21780927:pet_opaque:4213:21782840,2178'}), 'main_stat': {'nb_photos': 3918}}, 'hostname': (('raspi-92',),), 'impurety_average_per_hashtag': [(('refus', '2025-03', 0.1134844828553655),)]} VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 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 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} 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="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 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 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((3918,),), 'unwanted_material_monthly_percentage': ((0.1134844828553655,),), 'material_repartition': (('refus', 2938),), 'material_dict': {'refus': 2938}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 26), 0.09816619325535392, 1312), (datetime.date(2025, 3, 27), 0.12102760736640707, 409), (datetime.date(2025, 3, 28), 0.12244262814496973, 368), (datetime.date(2025, 3, 29), 0.12691441401173878, 496), (datetime.date(2025, 3, 30), 0.1202330125523819, 353), (datetime.date(2025, 3, 31), 0.1202695709735065, 980)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 3, 26), 0.09816619325535392, 1312), (datetime.date(2025, 3, 27), 0.12102760736640707, 409), (datetime.date(2025, 3, 28), 0.12244262814496973, 368), (datetime.date(2025, 3, 29), 0.12691441401173878, 496), (datetime.date(2025, 3, 30), 0.1202330125523819, 353), (datetime.date(2025, 3, 31), 0.1202695709735065, 980))}, 'quality_array': [['-2.3281674844066593', '26032025'], ['-3.2824344148806883', '27032025'], ['-2.8603423024924752', '28032025'], ['-2.7436052665419965', '29032025'], ['-2.539876298250719', '30032025'], ['-2.391104079290964', '31032025']], 'number_of_batch': ((142,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032400499317800807, 'nb_photo': 661, 'list_port_cont': '21779740,21779775,21780345,21780531,21780722,21781346,21781376,21781450,21782827,21783299,21783576,21784533,21784927,21788845,21790562,21790831,21795167,21799037,21803015,21804543,21805485,21806192,21808332,21808589,21808749,21808789,21809349,21809573,21809898,21810181,21810366,21810427,21810571,21811303,21812738,21815933,21820797,21820895,21821256,21823601,21824107,21829002,21830162,21830700,21830943,21833324,21833862,21836262,21839681,21841990,21842349,21844555,21848132,21853162,21854019,21855524,21858545,21860513,21863019,21866534,21867291,21870664,21870742,21870862,21871030,21871241,21871337,21871479,21871885,21872201,21872717,21873012,21873784,21873985,21874278,21875531,21875744,21876479,21879086,21893416,21893532,21893562,21893595,21893628,21893675,21893723,21893810,21893843,21893873,21893896,21893982,21894043,21894078,21894120,21894144,21894208,21897808,21898025,21900222,21900534,21900666,21904907,21906394,21906451,21906542,21906591,21906905,21906955,21907458,21908292,21912966,21914875,21916054,2192193', 'assoc_port': '21779443:21779740,21779445:21824107,21779446:21806192,21779447:21780722,21779448:21780345,21779450:21780531,21779452:21779775,21780856:21823601,21780857:21808332,21780858:21808589,21780859:21808789,21780860:21821256,21780861:21809573,21780862:21809898,21780864:21810181,21780865:21810366,21780884:21810571,21780893:21811303,21780918:21808749,21780919:21810427,21780920:21803015,21780921:21788845,21780922:21784927,21780923:21784533,21780925:21783299,21780926:21783576,21780927:21782827,21780928:21781346,21780929:21781376,21780930:21781450,21789865:21790562,21790680:21790831,21794660:21795167,21798252:21799037,21804156:21804543,21805181:21805485,21808651:21809349,21812511:21812738,21815718:21815933,21820590:21820895,21820591:21820797,21828553:21833324,21828555:21830700,21828557:21830162,21828563:21841990,21828591:21829002,21830807:21830943,21833540:21833862,21835986:21836262,21838936:21839681,21842152:21842349,21844435:21844555,21847639:21848132,21852283:21853162,21853646:21854019,21855235:21855524,21857529:2185854', 'assoc_mat': '21779443:barquette_opaque:4213:21779740,21779445:barquette_opaque:4213:21824107,21779446:barquette_opaque:4213:21806192,21779447:barquette_opaque:4213:21780722,21779448:barquette_opaque:4213:21780345,21779450:barquette_opaque:4213:21780531,21779452:barquette_opaque:4213:21779775,21780856:barquette_opaque:4213:21823601,21780857:barquette_opaque:4213:21808332,21780858:barquette_opaque:4213:21808589,21780859:barquette_opaque:4213:21808789,21780860:barquette_opaque:4213:21821256,21780861:barquette_opaque:4213:21809573,21780862:barquette_opaque:4213:21809898,21780864:barquette_opaque:4213:21810181,21780865:barquette_opaque:4213:21810366,21780884:barquette_opaque:4213:21810571,21780893:barquette_opaque:4213:21811303,21780918:barquette_opaque:4213:21808749,21780919:barquette_opaque:4213:21810427,21780920:barquette_opaque:4213:21803015,21780921:barquette_opaque:4213:21788845,21780922:barquette_opaque:4213:21784927,21780923:barquette_opaque:4213:21784533,21780925:barquette_opaque:4213:21783299,21780926:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0028658200003600824, 'nb_photo': 876, 'list_port_cont': '21779748,21779782,21780227,21780336,21780372,21780511,21780735,21781344,21781377,21781440,21782112,21782829,21783310,21784525,21784918,21788831,21790563,21790829,21795180,21799026,21803007,21804539,21805481,21806190,21808337,21808598,21808759,21808784,21809364,21809564,21809897,21810173,21810381,21810426,21810582,21811284,21812762,21815929,21818943,21820809,21820888,21821243,21823611,21824102,21829013,21830168,21830689,21830933,21831892,21833321,21833859,21839680,21841981,21844063,21844558,21848128,21853171,21854017,21855537,21858531,21863010,21866543,21867297,21870439,21870666,21870726,21870874,21871038,21871256,21871335,21871493,21871888,21871979,21872209,21872725,21873005,21873361,21873787,21873980,21874282,21874481,21875530,21875739,21876005,21876471,21878933,21879080,21893417,21893535,21893567,21893592,21893631,21893688,21893761,21893798,21893832,21893863,21893905,21893972,21893986,21894071,21894107,21894140,21894176,21894207,21897824,21898022,21900223,21900532,21900674,21904905,21906402,21906460,2190654', 'assoc_port': '21779443:21779748,21779445:21824102,21779446:21806190,21779447:21780735,21779448:21780336,21779449:21780372,21779450:21780511,21779451:21780227,21779452:21779782,21780856:21823611,21780857:21808337,21780858:21808598,21780859:21808784,21780860:21821243,21780861:21809564,21780862:21809897,21780864:21810173,21780865:21810381,21780884:21810582,21780893:21811284,21780918:21808759,21780919:21810426,21780920:21803007,21780921:21788831,21780922:21784918,21780923:21784525,21780925:21783310,21780927:21782829,21780928:21781344,21780929:21781377,21780930:21781440,21781684:21782112,21789865:21790563,21790680:21790829,21794660:21795180,21798252:21799026,21804156:21804539,21805181:21805481,21808651:21809364,21812511:21812762,21815718:21815929,21818667:21818943,21820590:21820888,21820591:21820809,21828551:21831892,21828553:21833321,21828555:21830689,21828557:21830168,21828563:21841981,21828591:21829013,21830807:21830933,21833540:21833859,21838936:21839680,21843928:21844063,21844435:21844558,21847639:21848128,21852283:2185317', 'assoc_mat': '21779443:carton:4213:21779748,21779445:carton:4213:21824102,21779446:carton:4213:21806190,21779447:carton:4213:21780735,21779448:carton:4213:21780336,21779449:carton:4213:21780372,21779450:carton:4213:21780511,21779451:carton:4213:21780227,21779452:carton:4213:21779782,21780856:carton:4213:21823611,21780857:carton:4213:21808337,21780858:carton:4213:21808598,21780859:carton:4213:21808784,21780860:carton:4213:21821243,21780861:carton:4213:21809564,21780862:carton:4213:21809897,21780864:carton:4213:21810173,21780865:carton:4213:21810381,21780884:carton:4213:21810582,21780893:carton:4213:21811284,21780918:carton:4213:21808759,21780919:carton:4213:21810426,21780920:carton:4213:21803007,21780921:carton:4213:21788831,21780922:carton:4213:21784918,21780923:carton:4213:21784525,21780925:carton:4213:21783310,21780927:carton:4213:21782829,21780928:carton:4213:21781344,21780929:carton:4213:21781377,21780930:carton:4213:21781440,21781684:carton:4213:21782112,21789865:carton:4213:21790563,21790680:carton:4213:21790829,2179'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032510347972613965, 'nb_photo': 198, 'list_port_cont': '21779743,21780378,21780513,21780725,21781348,21781381,21781444,21783307,21784219,21784926,21788844,21790570,21794694,21795172,21799028,21803000,21804552,21806201,21808339,21808587,21808763,21808792,21809895,21810170,21810371,21810434,21810578,21811288,21812724,21815941,21818949,21820811,21820893,21821259,21823609,21824108,21829684,21830702,21833336,21833866,21839683,21863018,21866536,21867298,21870453,21870730,21871041,21871242,21871494,21873002,21873776,21874286,21875533,21875741,21876010,21878929,21893534,21893557,21893591,21893676,21893710,21893809,21893838,21893862,21893898,21893980,21894074,21894147,21894181,21897818,21898024,21900220,21900537,21900675,21904911,21906400,21906538,21906579,21906966,21907448,21908302,21914872,21916055,21921932,21922248,21923471,21924143,21928873,21930864', 'assoc_port': '21779443:21779743,21779445:21824108,21779446:21806201,21779447:21780725,21779449:21780378,21779450:21780513,21780856:21823609,21780857:21808339,21780858:21808587,21780859:21808792,21780860:21821259,21780862:21809895,21780864:21810170,21780865:21810371,21780884:21810578,21780893:21811288,21780918:21808763,21780919:21810434,21780920:21803000,21780921:21788844,21780922:21784926,21780924:21784219,21780925:21783307,21780928:21781348,21780929:21781381,21780930:21781444,21784663:21794694,21789865:21790570,21794660:21795172,21798252:21799028,21804156:21804552,21812511:21812724,21815718:21815941,21818667:21818949,21820590:21820893,21820591:21820811,21828553:21833336,21828555:21830702,21828559:21829684,21833540:21833866,21838936:21839683,21862868:21863018,21866429:21866536,21867163:21867298,21870286:21871041,21870288:21871242,21870291:21871494,21870293:21870730,21870297:21870453,21872995:21873002,21873752:21873776,21874197:21874286,21875393:21875533,21875733:21875741,21875983:21876010,21878609:21878929,21893284:2189383', 'assoc_mat': '21779443:ela:4213:21779743,21779445:ela:4213:21824108,21779446:ela:4213:21806201,21779447:ela:4213:21780725,21779449:ela:4213:21780378,21779450:ela:4213:21780513,21780856:ela:4213:21823609,21780857:ela:4213:21808339,21780858:ela:4213:21808587,21780859:ela:4213:21808792,21780860:ela:4213:21821259,21780862:ela:4213:21809895,21780864:ela:4213:21810170,21780865:ela:4213:21810371,21780884:ela:4213:21810578,21780893:ela:4213:21811288,21780918:ela:4213:21808763,21780919:ela:4213:21810434,21780920:ela:4213:21803000,21780921:ela:4213:21788844,21780922:ela:4213:21784926,21780924:ela:4213:21784219,21780925:ela:4213:21783307,21780928:ela:4213:21781348,21780929:ela:4213:21781381,21780930:ela:4213:21781444,21784663:ela:4213:21794694,21789865:ela:4213:21790570,21794660:ela:4213:21795172,21798252:ela:4213:21799028,21804156:ela:4213:21804552,21812511:ela:4213:21812724,21815718:ela:4213:21815941,21818667:ela:4213:21818949,21820590:ela:4213:21820893,21820591:ela:4213:21820811,21828553:ela:4213:21833336,21828555:ela:4213:2183070'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0028444782452004226, 'nb_photo': 981, 'list_port_cont': '21779751,21779784,21780225,21780333,21780371,21780525,21780724,21781335,21781372,21781439,21783295,21784206,21784531,21784925,21788836,21790569,21790821,21792496,21795168,21799032,21803011,21804545,21805496,21806209,21808345,21808600,21808752,21808797,21809363,21809558,21809896,21810174,21810368,21810429,21810581,21811293,21812725,21815934,21818951,21820807,21820890,21821246,21823602,21824116,21829016,21829692,21830167,21830696,21830939,21831890,21833329,21833863,21836270,21839693,21841991,21842355,21844050,21844556,21848139,21853168,21854005,21855535,21858546,21862165,21863008,21866539,21867284,21870440,21870677,21870739,21870871,21871034,21871255,21871333,21871485,21871879,21871987,21872203,21872716,21873010,21873780,21873971,21874288,21874471,21875748,21876004,21876474,21878931,21879074,21893428,21893451,21893529,21893561,21893598,21893637,21893677,21893721,21893764,21893794,21893836,21893866,21893904,21893944,21894042,21894087,21894110,21894188,21894223,21897809,21898033,21900224,21900541,21900671,2190490', 'assoc_port': '21779443:21779751,21779445:21824116,21779446:21806209,21779447:21780724,21779448:21780333,21779449:21780371,21779450:21780525,21779451:21780225,21779452:21779784,21780856:21823602,21780857:21808345,21780858:21808600,21780859:21808797,21780860:21821246,21780861:21809558,21780862:21809896,21780864:21810174,21780865:21810368,21780884:21810581,21780893:21811293,21780918:21808752,21780919:21810429,21780920:21803011,21780921:21788836,21780922:21784925,21780923:21784531,21780924:21784206,21780925:21783295,21780928:21781335,21780929:21781372,21780930:21781439,21789865:21790569,21790680:21790821,21792144:21792496,21794660:21795168,21798252:21799032,21804156:21804545,21805181:21805496,21808651:21809363,21812511:21812725,21815718:21815934,21818667:21818951,21820590:21820890,21820591:21820807,21828551:21831890,21828553:21833329,21828555:21830696,21828557:21830167,21828559:21829692,21828563:21841991,21828591:21829016,21830807:21830939,21833540:21833863,21835986:21836270,21838936:21839693,21842152:21842355,21843928:2184405', 'assoc_mat': '21779443:etiquette:4213:21779751,21779445:etiquette:4213:21824116,21779446:etiquette:4213:21806209,21779447:etiquette:4213:21780724,21779448:etiquette:4213:21780333,21779449:etiquette:4213:21780371,21779450:etiquette:4213:21780525,21779451:etiquette:4213:21780225,21779452:etiquette:4213:21779784,21780856:etiquette:4213:21823602,21780857:etiquette:4213:21808345,21780858:etiquette:4213:21808600,21780859:etiquette:4213:21808797,21780860:etiquette:4213:21821246,21780861:etiquette:4213:21809558,21780862:etiquette:4213:21809896,21780864:etiquette:4213:21810174,21780865:etiquette:4213:21810368,21780884:etiquette:4213:21810581,21780893:etiquette:4213:21811293,21780918:etiquette:4213:21808752,21780919:etiquette:4213:21810429,21780920:etiquette:4213:21803011,21780921:etiquette:4213:21788836,21780922:etiquette:4213:21784925,21780923:etiquette:4213:21784531,21780924:etiquette:4213:21784206,21780925:etiquette:4213:21783295,21780928:etiquette:4213:21781335,21780929:etiquette:4213:21781372,21780930:etiquette:4213:21781439,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03124399298868142, 'nb_photo': 2484, 'list_port_cont': '21779735,21779770,21780229,21780334,21780366,21780517,21780730,21781343,21781368,21781455,21782109,21783302,21783567,21784215,21784519,21784919,21788837,21790560,21790817,21792492,21794701,21795181,21799040,21803005,21804549,21805486,21806206,21808347,21808602,21808765,21808787,21809358,21809568,21809883,21810177,21810378,21810428,21810570,21811289,21812760,21815935,21818946,21820800,21820886,21821244,21823606,21824103,21829007,21829677,21830176,21830701,21830944,21831889,21833332,21833867,21836263,21839689,21841994,21842351,21844056,21844561,21848141,21853173,21854011,21855525,21858543,21860511,21862163,21863012,21866544,21867293,21870449,21870678,21870740,21870867,21871026,21871250,21871338,21871484,21871882,21871993,21872206,21872723,21873003,21873348,21873783,21873975,21874284,21874482,21875522,21875750,21876012,21876481,21878930,21879075,21893426,21893450,21893525,21893559,21893600,21893624,21893680,21893708,21893768,21893800,21893839,21893877,21893906,21893941,21893973,21894000,21894044,21894085,2189411', 'assoc_port': '21779443:21779735,21779445:21824103,21779446:21806206,21779447:21780730,21779448:21780334,21779449:21780366,21779450:21780517,21779451:21780229,21779452:21779770,21780856:21823606,21780857:21808347,21780858:21808602,21780859:21808787,21780860:21821244,21780861:21809568,21780862:21809883,21780864:21810177,21780865:21810378,21780884:21810570,21780893:21811289,21780918:21808765,21780919:21810428,21780920:21803005,21780921:21788837,21780922:21784919,21780923:21784519,21780924:21784215,21780925:21783302,21780926:21783567,21780928:21781343,21780929:21781368,21780930:21781455,21781684:21782109,21784663:21794701,21789865:21790560,21790680:21790817,21792144:21792492,21794660:21795181,21798252:21799040,21804156:21804549,21805181:21805486,21808651:21809358,21812511:21812760,21815718:21815935,21818667:21818946,21820590:21820886,21820591:21820800,21828551:21831889,21828553:21833332,21828555:21830701,21828557:21830176,21828559:21829677,21828563:21841994,21828591:21829007,21830807:21830944,21833540:21833867,21835986:2183626', 'assoc_mat': '21779443:film_plastique:4213:21779735,21779445:film_plastique:4213:21824103,21779446:film_plastique:4213:21806206,21779447:film_plastique:4213:21780730,21779448:film_plastique:4213:21780334,21779449:film_plastique:4213:21780366,21779450:film_plastique:4213:21780517,21779451:film_plastique:4213:21780229,21779452:film_plastique:4213:21779770,21780856:film_plastique:4213:21823606,21780857:film_plastique:4213:21808347,21780858:film_plastique:4213:21808602,21780859:film_plastique:4213:21808787,21780860:film_plastique:4213:21821244,21780861:film_plastique:4213:21809568,21780862:film_plastique:4213:21809883,21780864:film_plastique:4213:21810177,21780865:film_plastique:4213:21810378,21780884:film_plastique:4213:21810570,21780893:film_plastique:4213:21811289,21780918:film_plastique:4213:21808765,21780919:film_plastique:4213:21810428,21780920:film_plastique:4213:21803005,21780921:film_plastique:4213:21788837,21780922:film_plastique:4213:21784919,21780923:film_plastique:4213:21784519,21780924:film_plastique:4213:2178421'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0006829393527929814, 'nb_photo': 10, 'list_port_cont': '21781345,21821249,21830694,21855526,21863014,21874281,21900668,21907449,21928874', 'assoc_port': '21780860:21821249,21780928:21781345,21828555:21830694,21855235:21855526,21862868:21863014,21874197:21874281,21897326:21900668,21902685:21907449,21928540:21928874', 'assoc_mat': '21780860:kraft:4213:21821249,21780928:kraft:4213:21781345,21828555:kraft:4213:21830694,21855235:kraft:4213:21855526,21862868:kraft:4213:21863014,21874197:kraft:4213:21874281,21897326:kraft:4213:21900668,21902685:kraft:4213:21907449,21928540:kraft:4213:21928874'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.005447345257634398, 'nb_photo': 2464, 'list_port_cont': '21779741,21779773,21780219,21780330,21780364,21780508,21780726,21781337,21781371,21781454,21782100,21782830,21783294,21783568,21784205,21784524,21784914,21788830,21790556,21790827,21792493,21794699,21795177,21799035,21803006,21804546,21805491,21806189,21808341,21808599,21808762,21808798,21809353,21809555,21809885,21810184,21810372,21810436,21810583,21811301,21812744,21815939,21818942,21820808,21820894,21821248,21823612,21824115,21829004,21829680,21830174,21830692,21830927,21831885,21833335,21833872,21836264,21839692,21841987,21842335,21844059,21844554,21848143,21853163,21854008,21855530,21858534,21860512,21862158,21863015,21866541,21867285,21870452,21870670,21870741,21870865,21871036,21871243,21871339,21871483,21871875,21871990,21872199,21872713,21873004,21873350,21873778,21873986,21874276,21874479,21875520,21875742,21876008,21876485,21878944,21879084,21893418,21893462,21893524,21893554,21893603,21893638,21893684,21893709,21893769,21893801,21893834,21893868,21893903,21893933,21893981,21894038,21894077,2189412', 'assoc_port': '21779443:21779741,21779445:21824115,21779446:21806189,21779447:21780726,21779448:21780330,21779449:21780364,21779450:21780508,21779451:21780219,21779452:21779773,21780856:21823612,21780857:21808341,21780858:21808599,21780859:21808798,21780860:21821248,21780861:21809555,21780862:21809885,21780864:21810184,21780865:21810372,21780884:21810583,21780893:21811301,21780918:21808762,21780919:21810436,21780920:21803006,21780921:21788830,21780922:21784914,21780923:21784524,21780924:21784205,21780925:21783294,21780926:21783568,21780927:21782830,21780928:21781337,21780929:21781371,21780930:21781454,21781684:21782100,21784663:21794699,21789865:21790556,21790680:21790827,21792144:21792493,21794660:21795177,21798252:21799035,21804156:21804546,21805181:21805491,21808651:21809353,21812511:21812744,21815718:21815939,21818667:21818942,21820590:21820894,21820591:21820808,21828551:21831885,21828553:21833335,21828555:21830692,21828557:21830174,21828559:21829680,21828563:21841987,21828591:21829004,21830807:21830927,21833540:2183387', 'assoc_mat': '21779443:metal:4213:21779741,21779445:metal:4213:21824115,21779446:metal:4213:21806189,21779447:metal:4213:21780726,21779448:metal:4213:21780330,21779449:metal:4213:21780364,21779450:metal:4213:21780508,21779451:metal:4213:21780219,21779452:metal:4213:21779773,21780856:metal:4213:21823612,21780857:metal:4213:21808341,21780858:metal:4213:21808599,21780859:metal:4213:21808798,21780860:metal:4213:21821248,21780861:metal:4213:21809555,21780862:metal:4213:21809885,21780864:metal:4213:21810184,21780865:metal:4213:21810372,21780884:metal:4213:21810583,21780893:metal:4213:21811301,21780918:metal:4213:21808762,21780919:metal:4213:21810436,21780920:metal:4213:21803006,21780921:metal:4213:21788830,21780922:metal:4213:21784914,21780923:metal:4213:21784524,21780924:metal:4213:21784205,21780925:metal:4213:21783294,21780926:metal:4213:21783568,21780927:metal:4213:21782830,21780928:metal:4213:21781337,21780929:metal:4213:21781371,21780930:metal:4213:21781454,21781684:metal:4213:21782100,21784663:metal:4213:21794699,21789865:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.02945414163585054, 'nb_photo': 3892, 'list_port_cont': '21779744,21779777,21780220,21780337,21780368,21780515,21780723,21781339,21781378,21781442,21782099,21782839,21783298,21783570,21784211,21784526,21784915,21788843,21790561,21790823,21792499,21794700,21795179,21799027,21803008,21804544,21805484,21806197,21808340,21808588,21808760,21808783,21809361,21809562,21809886,21810183,21810365,21810437,21810580,21811291,21812745,21815928,21818947,21820801,21820892,21821252,21823605,21824110,21829010,21829693,21830171,21830698,21830942,21831894,21833331,21833874,21836271,21839687,21841978,21842327,21844058,21844564,21848140,21853172,21854015,21855533,21858537,21860507,21862169,21863022,21866532,21867290,21870451,21870673,21870734,21870863,21871040,21871253,21871332,21871488,21871889,21871994,21872208,21872724,21873001,21873349,21873775,21873984,21874277,21874484,21875535,21875749,21876011,21876473,21878942,21879081,21893424,21893463,21893533,21893555,21893589,21893630,21893686,21893711,21893765,21893797,21893830,21893874,21893912,21893934,21893969,21893989,21894048,2189408', 'assoc_port': '21779443:21779744,21779445:21824110,21779446:21806197,21779447:21780723,21779448:21780337,21779449:21780368,21779450:21780515,21779451:21780220,21779452:21779777,21780856:21823605,21780857:21808340,21780858:21808588,21780859:21808783,21780860:21821252,21780861:21809562,21780862:21809886,21780864:21810183,21780865:21810365,21780884:21810580,21780893:21811291,21780918:21808760,21780919:21810437,21780920:21803008,21780921:21788843,21780922:21784915,21780923:21784526,21780924:21784211,21780925:21783298,21780926:21783570,21780927:21782839,21780928:21781339,21780929:21781378,21780930:21781442,21781684:21782099,21784663:21794700,21789865:21790561,21790680:21790823,21792144:21792499,21794660:21795179,21798252:21799027,21804156:21804544,21805181:21805484,21808651:21809361,21812511:21812745,21815718:21815928,21818667:21818947,21820590:21820892,21820591:21820801,21828551:21831894,21828553:21833331,21828555:21830698,21828557:21830171,21828559:21829693,21828563:21841978,21828591:21829010,21830807:21830942,21833540:2183387', 'assoc_mat': '21779443:papier:4213:21779744,21779445:papier:4213:21824110,21779446:papier:4213:21806197,21779447:papier:4213:21780723,21779448:papier:4213:21780337,21779449:papier:4213:21780368,21779450:papier:4213:21780515,21779451:papier:4213:21780220,21779452:papier:4213:21779777,21780856:papier:4213:21823605,21780857:papier:4213:21808340,21780858:papier:4213:21808588,21780859:papier:4213:21808783,21780860:papier:4213:21821252,21780861:papier:4213:21809562,21780862:papier:4213:21809886,21780864:papier:4213:21810183,21780865:papier:4213:21810365,21780884:papier:4213:21810580,21780893:papier:4213:21811291,21780918:papier:4213:21808760,21780919:papier:4213:21810437,21780920:papier:4213:21803008,21780921:papier:4213:21788843,21780922:papier:4213:21784915,21780923:papier:4213:21784526,21780924:papier:4213:21784211,21780925:papier:4213:21783298,21780926:papier:4213:21783570,21780927:papier:4213:21782839,21780928:papier:4213:21781339,21780929:papier:4213:21781378,21780930:papier:4213:21781442,21781684:papier:4213:21782099,2178'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0029523534730137575, 'nb_photo': 69, 'list_port_cont': '21781347,21781375,21782836,21784924,21790572,21792504,21799036,21803014,21808334,21808592,21808755,21809559,21810172,21810430,21811297,21820803,21823613,21829014,21830178,21831891,21836258,21839686,21854009,21866530,21867282,21871029,21871486,21874273,21876486,21893587,21893678,21893844,21893943,21897814,21898026,21900525,21906393,21906581,21906908,21907445,21908296,21916067,21921931,21923483,21924147,21928878,21930861', 'assoc_port': '21780856:21823613,21780857:21808334,21780858:21808592,21780861:21809559,21780864:21810172,21780893:21811297,21780918:21808755,21780919:21810430,21780920:21803014,21780922:21784924,21780927:21782836,21780928:21781347,21780929:21781375,21789865:21790572,21792144:21792504,21798252:21799036,21820591:21820803,21828551:21831891,21828557:21830178,21828591:21829014,21835986:21836258,21838936:21839686,21853646:21854009,21866429:21866530,21867163:21867282,21870286:21871029,21870291:21871486,21874197:21874273,21876288:21876486,21893284:21893844,21893329:21893943,21893354:21893678,21893378:21893587,21897325:21900525,21897327:21897814,21897328:21898026,21897331:21906581,21902683:21906908,21902685:21907445,21906318:21906393,21908083:21908296,21915814:21916067,21920703:21924147,21920704:21921931,21923361:21923483,21928540:21928878,21930515:21930861', 'assoc_mat': '21780856:pehd:4213:21823613,21780857:pehd:4213:21808334,21780858:pehd:4213:21808592,21780861:pehd:4213:21809559,21780864:pehd:4213:21810172,21780893:pehd:4213:21811297,21780918:pehd:4213:21808755,21780919:pehd:4213:21810430,21780920:pehd:4213:21803014,21780922:pehd:4213:21784924,21780927:pehd:4213:21782836,21780928:pehd:4213:21781347,21780929:pehd:4213:21781375,21789865:pehd:4213:21790572,21792144:pehd:4213:21792504,21798252:pehd:4213:21799036,21820591:pehd:4213:21820803,21828551:pehd:4213:21831891,21828557:pehd:4213:21830178,21828591:pehd:4213:21829014,21835986:pehd:4213:21836258,21838936:pehd:4213:21839686,21853646:pehd:4213:21854009,21866429:pehd:4213:21866530,21867163:pehd:4213:21867282,21870286:pehd:4213:21871029,21870291:pehd:4213:21871486,21874197:pehd:4213:21874273,21876288:pehd:4213:21876486,21893284:pehd:4213:21893844,21893329:pehd:4213:21893943,21893354:pehd:4213:21893678,21893378:pehd:4213:21893587,21897325:pehd:4213:21900525,21897327:pehd:4213:21897814,21897328:pehd:4213:21898026,21897331:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.022629260514299525, 'nb_photo': 3754, 'list_port_cont': '21779742,21779774,21780228,21780346,21780375,21780519,21780738,21781334,21781374,21781448,21782104,21782835,21783308,21783573,21784212,21784532,21784921,21788840,21790567,21790825,21792500,21794692,21795169,21799031,21803002,21804538,21805487,21806196,21808342,21808590,21808764,21808790,21809350,21809560,21809892,21810169,21810373,21810431,21810575,21811285,21812730,21815937,21818939,21820802,21820880,21821254,21823610,21824117,21829009,21829682,21830170,21830699,21830935,21831887,21833326,21833870,21836257,21839678,21841988,21842352,21844061,21844563,21848135,21853164,21854006,21855536,21858540,21860503,21862159,21863006,21866533,21867286,21870454,21870668,21870735,21870859,21871037,21871245,21871334,21871481,21871877,21871988,21872204,21872715,21873008,21873363,21873785,21873972,21874272,21874475,21875538,21875747,21876019,21876472,21878936,21879072,21893419,21893459,21893520,21893558,21893594,21893633,21893679,21893712,21893773,21893795,21893837,21893870,21893907,21893931,21893970,21893987,21894039,2189407', 'assoc_port': '21779443:21779742,21779445:21824117,21779446:21806196,21779447:21780738,21779448:21780346,21779449:21780375,21779450:21780519,21779451:21780228,21779452:21779774,21780856:21823610,21780857:21808342,21780858:21808590,21780859:21808790,21780860:21821254,21780861:21809560,21780862:21809892,21780864:21810169,21780865:21810373,21780884:21810575,21780893:21811285,21780918:21808764,21780919:21810431,21780920:21803002,21780921:21788840,21780922:21784921,21780923:21784532,21780924:21784212,21780925:21783308,21780926:21783573,21780927:21782835,21780928:21781334,21780929:21781374,21780930:21781448,21781684:21782104,21784663:21794692,21789865:21790567,21790680:21790825,21792144:21792500,21794660:21795169,21798252:21799031,21804156:21804538,21805181:21805487,21808651:21809350,21812511:21812730,21815718:21815937,21818667:21818939,21820590:21820880,21820591:21820802,21828551:21831887,21828553:21833326,21828555:21830699,21828557:21830170,21828559:21829682,21828563:21841988,21828591:21829009,21830807:21830935,21833540:2183387', 'assoc_mat': '21779443:pet_clair:4213:21779742,21779445:pet_clair:4213:21824117,21779446:pet_clair:4213:21806196,21779447:pet_clair:4213:21780738,21779448:pet_clair:4213:21780346,21779449:pet_clair:4213:21780375,21779450:pet_clair:4213:21780519,21779451:pet_clair:4213:21780228,21779452:pet_clair:4213:21779774,21780856:pet_clair:4213:21823610,21780857:pet_clair:4213:21808342,21780858:pet_clair:4213:21808590,21780859:pet_clair:4213:21808790,21780860:pet_clair:4213:21821254,21780861:pet_clair:4213:21809560,21780862:pet_clair:4213:21809892,21780864:pet_clair:4213:21810169,21780865:pet_clair:4213:21810373,21780884:pet_clair:4213:21810575,21780893:pet_clair:4213:21811285,21780918:pet_clair:4213:21808764,21780919:pet_clair:4213:21810431,21780920:pet_clair:4213:21803002,21780921:pet_clair:4213:21788840,21780922:pet_clair:4213:21784921,21780923:pet_clair:4213:21784532,21780924:pet_clair:4213:21784212,21780925:pet_clair:4213:21783308,21780926:pet_clair:4213:21783573,21780927:pet_clair:4213:21782835,21780928:pet_clair:4213:21781334,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00043725757788750416, 'nb_photo': 57, 'list_port_cont': '21779749,21780376,21780734,21782832,21784916,21788839,21790568,21795176,21805495,21808596,21808756,21809563,21810185,21810425,21810576,21811300,21820814,21823616,21824105,21829018,21830695,21842329,21867288,21871249,21871880,21874285,21874480,21875526,21878938,21879076,21893689,21893865,21893900,21893983,21894082,21906388,21906589,21906914,21908293,21912973,21922246,21924153,21928882', 'assoc_port': '21779443:21779749,21779445:21824105,21779447:21780734,21779449:21780376,21780856:21823616,21780858:21808596,21780861:21809563,21780864:21810185,21780884:21810576,21780893:21811300,21780918:21808756,21780919:21810425,21780921:21788839,21780922:21784916,21780927:21782832,21789865:21790568,21794660:21795176,21805181:21805495,21820591:21820814,21828555:21830695,21828591:21829018,21842152:21842329,21867163:21867288,21870288:21871249,21870296:21871880,21874197:21874285,21874392:21874480,21875393:21875526,21878609:21878938,21878613:21879076,21893303:21893900,21893324:21894082,21893330:21893983,21893354:21893689,21893374:21893865,21897331:21906589,21902683:21906914,21906318:21906388,21908083:21908293,21911971:21912973,21920703:21924153,21922021:21922246,21928540:21928882', 'assoc_mat': '21779443:pet_fonce:4213:21779749,21779445:pet_fonce:4213:21824105,21779447:pet_fonce:4213:21780734,21779449:pet_fonce:4213:21780376,21780856:pet_fonce:4213:21823616,21780858:pet_fonce:4213:21808596,21780861:pet_fonce:4213:21809563,21780864:pet_fonce:4213:21810185,21780884:pet_fonce:4213:21810576,21780893:pet_fonce:4213:21811300,21780918:pet_fonce:4213:21808756,21780919:pet_fonce:4213:21810425,21780921:pet_fonce:4213:21788839,21780922:pet_fonce:4213:21784916,21780927:pet_fonce:4213:21782832,21789865:pet_fonce:4213:21790568,21794660:pet_fonce:4213:21795176,21805181:pet_fonce:4213:21805495,21820591:pet_fonce:4213:21820814,21828555:pet_fonce:4213:21830695,21828591:pet_fonce:4213:21829018,21842152:pet_fonce:4213:21842329,21867163:pet_fonce:4213:21867288,21870288:pet_fonce:4213:21871249,21870296:pet_fonce:4213:21871880,21874197:pet_fonce:4213:21874285,21874392:pet_fonce:4213:21874480,21875393:pet_fonce:4213:21875526,21878609:pet_fonce:4213:21878938,21878613:pet_fonce:4213:21879076,21893303:pet_fonce:4213:21893900,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.012128502836052593, 'nb_photo': 2003, 'list_port_cont': '21779745,21779778,21780221,21780338,21780370,21780507,21780727,21781341,21781370,21781441,21782106,21782840,21783309,21783563,21784216,21784528,21784912,21788842,21790571,21790832,21792488,21794688,21795174,21799034,21803003,21804551,21805494,21806194,21808346,21808595,21808754,21808795,21809351,21809561,21809893,21810175,21810374,21810424,21810579,21811295,21812743,21815931,21818940,21820798,21820887,21821250,21823615,21824114,21829012,21830175,21830686,21830936,21831900,21833333,21833875,21836272,21839679,21841993,21842345,21844053,21844566,21848134,21853160,21854007,21855532,21858536,21860516,21862164,21863013,21866538,21867294,21870450,21870663,21870736,21870868,21871027,21871254,21871340,21871487,21871884,21871982,21872215,21872712,21873007,21873351,21873781,21873981,21874279,21874472,21875536,21875736,21876006,21876480,21878940,21879085,21893415,21893465,21893531,21893564,21893593,21893626,21893681,21893713,21893766,21893806,21893842,21893875,21893911,21893935,21893974,21893993,21894040,21894072,2189410', 'assoc_port': '21779443:21779745,21779445:21824114,21779446:21806194,21779447:21780727,21779448:21780338,21779449:21780370,21779450:21780507,21779451:21780221,21779452:21779778,21780856:21823615,21780857:21808346,21780858:21808595,21780859:21808795,21780860:21821250,21780861:21809561,21780862:21809893,21780864:21810175,21780865:21810374,21780884:21810579,21780893:21811295,21780918:21808754,21780919:21810424,21780920:21803003,21780921:21788842,21780922:21784912,21780923:21784528,21780924:21784216,21780925:21783309,21780926:21783563,21780927:21782840,21780928:21781341,21780929:21781370,21780930:21781441,21781684:21782106,21784663:21794688,21789865:21790571,21790680:21790832,21792144:21792488,21794660:21795174,21798252:21799034,21804156:21804551,21805181:21805494,21808651:21809351,21812511:21812743,21815718:21815931,21818667:21818940,21820590:21820887,21820591:21820798,21828551:21831900,21828553:21833333,21828555:21830686,21828557:21830175,21828563:21841993,21828591:21829012,21830807:21830936,21833540:21833875,21835986:2183627', 'assoc_mat': '21779443:pet_opaque:4213:21779745,21779445:pet_opaque:4213:21824114,21779446:pet_opaque:4213:21806194,21779447:pet_opaque:4213:21780727,21779448:pet_opaque:4213:21780338,21779449:pet_opaque:4213:21780370,21779450:pet_opaque:4213:21780507,21779451:pet_opaque:4213:21780221,21779452:pet_opaque:4213:21779778,21780856:pet_opaque:4213:21823615,21780857:pet_opaque:4213:21808346,21780858:pet_opaque:4213:21808595,21780859:pet_opaque:4213:21808795,21780860:pet_opaque:4213:21821250,21780861:pet_opaque:4213:21809561,21780862:pet_opaque:4213:21809893,21780864:pet_opaque:4213:21810175,21780865:pet_opaque:4213:21810374,21780884:pet_opaque:4213:21810579,21780893:pet_opaque:4213:21811295,21780918:pet_opaque:4213:21808754,21780919:pet_opaque:4213:21810424,21780920:pet_opaque:4213:21803003,21780921:pet_opaque:4213:21788842,21780922:pet_opaque:4213:21784912,21780923:pet_opaque:4213:21784528,21780924:pet_opaque:4213:21784216,21780925:pet_opaque:4213:21783309,21780926:pet_opaque:4213:21783563,21780927:pet_opaque:4213:21782840,2178'}), 'main_stat': {'nb_photos': 3918}}, 'hostname': (('raspi-92',),), 'impurety_average_per_hashtag': [(('refus', '2025-03', 0.1134844828553655),)]} filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_03_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 {'refus': {'barquette_opaque': ['barquette_opaque', '0.32%', 661], 'carton': ['carton', '0.29%', 876], 'ela': ['ela', '0.33%', 198], 'etiquette': ['etiquette', '0.28%', 981], 'film_plastique': ['film_plastique', '3.12%', 2484], 'kraft': ['kraft', '0.07%', 10], 'metal': ['metal', '0.54%', 2464], 'papier': ['papier', '2.95%', 3892], 'pehd': ['pehd', '0.3%', 69], 'pet_clair': ['pet_clair', '2.26%', 3754], 'pet_fonce': ['pet_fonce', '0.04%', 57], 'pet_opaque': ['pet_opaque', '1.21%', 2003]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_03_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/refus_amiens 2.90user 2.72system 0:34.97elapsed 16%CPU (0avgtext+0avgdata 193372maxresident)k 46096inputs+464outputs (219major+74480minor)pagefaults 0swaps