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=20062 --dashboard_places=arc_en_ciel_jrm_peu_dense --rootfolder_sla=/data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense -v --mtr_id=979 --date=`date -d"$nowdate 15 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : 20062, 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 ! VR TODO 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 ! VR TODO 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 ! VR TODO 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=3385 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=3385 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= 3385 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=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="arc_en_ciel_jrm_peu_dense"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 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=3385 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= 3385 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=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier 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 ! VR TODO 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 ! VR TODO 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 ! VR TODO 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=3385 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=3385 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= 3385 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=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="arc_en_ciel_jrm_peu_dense"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 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=3385 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= 3385 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=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 25 month : 03 mtr_id : 979 dashboard_places : arc_en_ciel_jrm_peu_dense date : 2025-03 year : 2025 raspi : 20062 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'arc_en_ciel_jrm_peu_dense' and date like '%2025-03%') and created_at like '%2025-03%'))); nb_day : (5, 31) after unwanted_material_data nb_day : (5, 31) SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%20062%' 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 ! We will need to call the sla_per_day for these missing days : 2025-03-01 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-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-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-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-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 = 25 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 = '_______JRM' and ded.dashboard_place_id = 25 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 = 25 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= "arc_en_ciel_jrm_peu_dense" 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 {'JRM': {'mat': 'JRM', 'pht': 3726, 'datou_carac_id': 3459, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'papier,background'}} 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 (1641269,1648468,1644675,1648145,1651761,1654501,1658104,1660783,1665436,1669573,1673168,1675678,1679951,1679945,1688687,1688639,1689901) AND dr.mtr_portfolio_id=ptp.mtr_portfolio_id_1 AND dr.qualite >= 0 AND mpp.mtr_portfolio_id=ptp.mtr_portfolio_id_2 AND pcr.portfolio_id=ptp.mtr_portfolio_id_1 AND h.hashtag_id = pcr.hashtag_id AND ptp.type = pcr.hashtag_type AND mpp.hide_status = 0 AND ptp.hashtag_id=h.hashtag_id group by h.hashtag, dr.hashtag, ptp.type; VR TODO TO BETTER PARSE ! ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007758737799972387, 'nb_photo': 675, 'list_port_cont': '20948130,20948241,20948367,20948672,20948732,20964679,20966210,20966601,20969822,20971045,20972228,20973576,20973640,20973814,20975029,20976031,20976094,20976150,20977792,20979998,20980949,20981986,20983231,20984439,20984559,20984973,20985778,20985791,20987149,20987186,20989006,20989146,20989214,20990554,20990609,20991942,20992195,21001641,21002922,21002932,21003056,21007957,21010010,21011399,21012630,21013034,21015537,21016878,21017119,21018343,21019496,21022459,21022568,21022628,21023450,21031266,21031899,21032262,21033803,21051689,21051943,21053078,21058971,21059098,21061822,21062176,21063756,21067523,21068032,21070391,21074937,21074972,21078389,21078981,21079801,21082749,21082869,21083288,21084206,21089141,21105663,21105816,21106867,21107038,21109154,21109373,21110242,21110369,21113209,21113513,21114061,21114374,21115738,21121772,21124587,21124870,21126255,21129624,21132159,21132181,21142637,21143870,21145099,21146844,21147698,21148351,21152328,21152757,21155845,21157352,21158948,21160189,21224061,2122650', 'assoc_port': '20948122:20948130,20948193:20948241,20948291:20948367,20948661:20948672,20948730:20948732,20964506:20964679,20965613:20966210,20966600:20966601,20969626:20969822,20970847:20971045,20970848:20975029,20971881:20972228,20973395:20973814,20973396:20973640,20973397:20973576,20975993:20976031,20975994:20976094,20975995:20976150,20977625:20977792,20979775:20979998,20980885:20980949,20981923:20981986,20983199:20983231,20984408:20984439,20984409:20984559,20984410:20984973,20985747:20985791,20985748:20985778,20987078:20987149,20987079:20987186,20988801:20989006,20988802:20989146,20989141:20989214,20990451:20990554,20990452:20990609,20991724:20991942,20992187:20992195,21001567:21003056,21001568:21002932,21001569:21001641,21002843:21002922,21006205:21007957,21009933:21010010,21011294:21011399,21012536:21012630,21012918:21013034,21015498:21015537,21016805:21017119,21016807:21016878,21017919:21018343,21019276:21019496,21022455:21022568,21022456:21022628,21022457:21022459,21023392:21023450,21031000:21032262,21031001:2103126', 'assoc_mat': '20948122:autre_refus:3726:20948130,20948193:autre_refus:3726:20948241,20948291:autre_refus:3726:20948367,20948661:autre_refus:3726:20948672,20948730:autre_refus:3726:20948732,20964506:autre_refus:3726:20964679,20965613:autre_refus:3726:20966210,20966600:autre_refus:3726:20966601,20969626:autre_refus:3726:20969822,20970847:autre_refus:3726:20971045,20970848:autre_refus:3726:20975029,20971881:autre_refus:3726:20972228,20973395:autre_refus:3726:20973814,20973396:autre_refus:3726:20973640,20973397:autre_refus:3726:20973576,20975993:autre_refus:3726:20976031,20975994:autre_refus:3726:20976094,20975995:autre_refus:3726:20976150,20977625:autre_refus:3726:20977792,20979775:autre_refus:3726:20979998,20980885:autre_refus:3726:20980949,20981923:autre_refus:3726:20981986,20983199:autre_refus:3726:20983231,20984408:autre_refus:3726:20984439,20984409:autre_refus:3726:20984559,20984410:autre_refus:3726:20984973,20985747:autre_refus:3726:20985791,20985748:autre_refus:3726:20985778,20987078:autre_refus:3726:20987149,20987079:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007193408220629753, 'nb_photo': 1408, 'list_port_cont': '20947832,20948126,20948370,20948595,20948947,20964683,20965838,20965882,20966209,20966603,20967523,20967682,20969826,20969965,20970280,20971040,20972224,20972759,20973586,20973646,20973819,20975031,20976024,20976093,20976153,20976929,20977802,20978762,20979839,20980003,20980947,20981933,20981983,20982027,20982222,20983228,20984440,20984561,20984969,20985781,20985795,20987191,20988822,20989003,20989147,20989206,20990611,20991881,20991937,21001643,21002929,21005144,21007952,21008142,21008992,21010009,21010118,21011494,21012634,21013030,21014410,21015533,21015608,21016880,21017055,21017121,21018346,21019491,21022461,21022558,21022620,21024533,21024686,21025453,21025998,21026818,21031554,21031903,21032266,21034232,21034785,21051688,21051738,21051942,21052888,21053203,21061068,21061830,21061987,21062178,21062951,21063752,21063972,21064370,21064546,21065499,21067524,21068035,21068399,21070302,21070395,21070764,21071561,21073101,21073152,21074944,21075093,21078380,21078688,21078976,21079543,21079802,21080139,2108276', 'assoc_port': '20947779:20947832,20948122:20948126,20948291:20948370,20948529:20948947,20948594:20948595,20964506:20964683,20965613:20966209,20965638:20965882,20965639:20965838,20966600:20966603,20967444:20967682,20967445:20967523,20969599:20969965,20969612:20970280,20969625:20972759,20969626:20969826,20970847:20971040,20970848:20975031,20971881:20972224,20973395:20973819,20973396:20973646,20973397:20973586,20975993:20976024,20975994:20976093,20975995:20976153,20976770:20976929,20977625:20977802,20978677:20978762,20979775:20980003,20979776:20979839,20979777:20982222,20980885:20980947,20981923:20981983,20981924:20982027,20981925:20981933,20983199:20983228,20984408:20984440,20984409:20984561,20984410:20984969,20985747:20985795,20985748:20985781,20987079:20987191,20988801:20989003,20988802:20989147,20988803:20988822,20989141:20989206,20990452:20990611,20991723:20991881,20991724:20991937,21001568:21002929,21001569:21001643,21004987:21005144,21006205:21007952,21008056:21008142,21008954:21008992,21009932:21010118,21009933:2101000', 'assoc_mat': '20947779:cartonnette:3726:20947832,20948122:cartonnette:3726:20948126,20948291:cartonnette:3726:20948370,20948529:cartonnette:3726:20948947,20948594:cartonnette:3726:20948595,20964506:cartonnette:3726:20964683,20965613:cartonnette:3726:20966209,20965638:cartonnette:3726:20965882,20965639:cartonnette:3726:20965838,20966600:cartonnette:3726:20966603,20967444:cartonnette:3726:20967682,20967445:cartonnette:3726:20967523,20969599:cartonnette:3726:20969965,20969612:cartonnette:3726:20970280,20969625:cartonnette:3726:20972759,20969626:cartonnette:3726:20969826,20970847:cartonnette:3726:20971040,20970848:cartonnette:3726:20975031,20971881:cartonnette:3726:20972224,20973395:cartonnette:3726:20973819,20973396:cartonnette:3726:20973646,20973397:cartonnette:3726:20973586,20975993:cartonnette:3726:20976024,20975994:cartonnette:3726:20976093,20975995:cartonnette:3726:20976153,20976770:cartonnette:3726:20976929,20977625:cartonnette:3726:20977802,20978677:cartonnette:3726:20978762,20979775:cartonnette:3726:20980003,20979776:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009769917383370809, 'nb_photo': 1260, 'list_port_cont': '20947838,20948136,20948242,20948949,20964688,20965848,20965884,20966212,20966612,20967520,20967683,20969820,20969959,20970274,20971046,20972231,20972761,20973580,20973641,20973818,20975030,20976032,20976096,20976152,20977712,20977801,20978757,20979835,20979994,20980938,20981977,20982017,20983229,20984441,20984553,20984972,20985779,20985793,20987144,20987194,20989005,20989144,20989211,20990549,20990616,20991941,21003063,21005069,21007953,21011391,21014414,21015534,21015607,21022563,21031058,21031551,21034234,21034775,21051728,21051939,21052889,21053213,21058969,21059095,21061370,21061829,21062497,21062944,21063753,21063971,21068039,21068394,21070304,21070768,21071239,21071566,21073100,21073160,21074940,21074963,21075095,21078378,21078691,21080145,21082759,21082874,21083280,21084212,21086050,21086147,21088473,21106873,21107041,21108642,21109149,21109371,21110238,21113200,21114054,21114383,21114985,21115745,21121760,21122946,21123196,21126364,21127626,21128663,21132039,21132187,21132369,21132492,21132544,2113255', 'assoc_port': '20947779:20947838,20948122:20948136,20948193:20948242,20948529:20948949,20964506:20964688,20965613:20966212,20965638:20965884,20965639:20965848,20966600:20966612,20967444:20967683,20967445:20967520,20969599:20969959,20969612:20970274,20969625:20972761,20969626:20969820,20970847:20971046,20970848:20975030,20971881:20972231,20973395:20973818,20973396:20973641,20973397:20973580,20975993:20976032,20975994:20976096,20975995:20976152,20977624:20977712,20977625:20977801,20978677:20978757,20979775:20979994,20979776:20979835,20980885:20980938,20981923:20981977,20981924:20982017,20983199:20983229,20984408:20984441,20984409:20984553,20984410:20984972,20985747:20985793,20985748:20985779,20987078:20987144,20987079:20987194,20988801:20989005,20988802:20989144,20989141:20989211,20990451:20990549,20990452:20990616,20991724:20991941,21001567:21003063,21004986:21005069,21006205:21007953,21011294:21011391,21012537:21015607,21014325:21014414,21015498:21015534,21022455:21022563,21030999:21034775,21031002:21031058,21031494:2103155', 'assoc_mat': '20947779:Carton_brun:3726:20947838,20948122:Carton_brun:3726:20948136,20948193:Carton_brun:3726:20948242,20948529:Carton_brun:3726:20948949,20964506:Carton_brun:3726:20964688,20965613:Carton_brun:3726:20966212,20965638:Carton_brun:3726:20965884,20965639:Carton_brun:3726:20965848,20966600:Carton_brun:3726:20966612,20967444:Carton_brun:3726:20967683,20967445:Carton_brun:3726:20967520,20969599:Carton_brun:3726:20969959,20969612:Carton_brun:3726:20970274,20969625:Carton_brun:3726:20972761,20969626:Carton_brun:3726:20969820,20970847:Carton_brun:3726:20971046,20970848:Carton_brun:3726:20975030,20971881:Carton_brun:3726:20972231,20973395:Carton_brun:3726:20973818,20973396:Carton_brun:3726:20973641,20973397:Carton_brun:3726:20973580,20975993:Carton_brun:3726:20976032,20975994:Carton_brun:3726:20976096,20975995:Carton_brun:3726:20976152,20977624:Carton_brun:3726:20977712,20977625:Carton_brun:3726:20977801,20978677:Carton_brun:3726:20978757,20979775:Carton_brun:3726:20979994,20979776:Carton_brun:3726:20979835,20980885:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00814502276150966, 'nb_photo': 811, 'list_port_cont': '20947831,20947854,20947973,20947990,20948125,20948237,20948371,20948597,20948666,20948735,20948940,20964680,20965842,20965873,20969824,20970276,20971047,20972223,20972758,20973583,20973648,20973816,20975027,20976023,20976095,20976159,20976845,20977791,20978753,20979997,20982224,20984557,20985776,20985792,20988826,20989009,20989155,20991938,20992200,21001636,21002915,21003054,21005066,21007949,21008139,21010011,21010126,21011498,21012625,21013026,21014407,21015535,21015606,21016875,21017115,21018002,21019499,21022462,21022559,21022626,21023451,21024682,21025457,21031057,21031265,21031555,21031894,21032260,21033795,21034239,21034774,21051673,21051735,21051940,21052883,21053083,21053214,21059092,21061074,21061367,21061823,21063760,21063977,21064376,21065502,21067521,21068038,21068396,21070775,21071242,21071563,21073105,21073155,21074941,21078383,21078687,21079809,21080140,21082879,21083013,21083285,21086054,21086138,21088478,21089392,21105668,21105817,21106871,21107044,21109151,21109381,21110239,21110372,2111320', 'assoc_port': '20947776:20947973,20947777:20947854,20947779:20947831,20947931:20947990,20948122:20948125,20948193:20948237,20948291:20948371,20948529:20948940,20948594:20948597,20948661:20948666,20948730:20948735,20964506:20964680,20965638:20965873,20965639:20965842,20969612:20970276,20969625:20972758,20969626:20969824,20970847:20971047,20970848:20975027,20971881:20972223,20973395:20973816,20973396:20973648,20973397:20973583,20975993:20976023,20975994:20976095,20975995:20976159,20976769:20976845,20977625:20977791,20978677:20978753,20979775:20979997,20979777:20982224,20984409:20984557,20985747:20985792,20985748:20985776,20988801:20989009,20988802:20989155,20988803:20988826,20991724:20991938,20992187:20992200,21001567:21003054,21001569:21001636,21002843:21002915,21004986:21005066,21006205:21007949,21008056:21008139,21009932:21010126,21009933:21010011,21011295:21011498,21012536:21012625,21012537:21015606,21012918:21013026,21014325:21014407,21015498:21015535,21016805:21017115,21016807:21016875,21017918:21018002,21019276:2101949', 'assoc_mat': '20947776:Carton_gris:3726:20947973,20947777:Carton_gris:3726:20947854,20947779:Carton_gris:3726:20947831,20947931:Carton_gris:3726:20947990,20948122:Carton_gris:3726:20948125,20948193:Carton_gris:3726:20948237,20948291:Carton_gris:3726:20948371,20948529:Carton_gris:3726:20948940,20948594:Carton_gris:3726:20948597,20948661:Carton_gris:3726:20948666,20948730:Carton_gris:3726:20948735,20964506:Carton_gris:3726:20964680,20965638:Carton_gris:3726:20965873,20965639:Carton_gris:3726:20965842,20969612:Carton_gris:3726:20970276,20969625:Carton_gris:3726:20972758,20969626:Carton_gris:3726:20969824,20970847:Carton_gris:3726:20971047,20970848:Carton_gris:3726:20975027,20971881:Carton_gris:3726:20972223,20973395:Carton_gris:3726:20973816,20973396:Carton_gris:3726:20973648,20973397:Carton_gris:3726:20973583,20975993:Carton_gris:3726:20976023,20975994:Carton_gris:3726:20976095,20975995:Carton_gris:3726:20976159,20976769:Carton_gris:3726:20976845,20977625:Carton_gris:3726:20977791,20978677:Carton_gris:3726:20978753,20979775:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0027443509346329934, 'nb_photo': 174, 'list_port_cont': '20964687,20965878,20966207,20966605,20969967,20970283,20972226,20972754,20973581,20973649,20975026,20976027,20976149,20977795,20978761,20979996,20984445,20984967,20985783,20985787,20989000,20989212,21015541,21058973,21061821,21063979,21067522,21075096,21079541,21083014,21114075,21124590,21126354,21132458,21239231,21264590,21269242,21274298,21288570,21291906,21293841,21299109,21306940,21307046,21311294,21315277,21319401,21334604,21348121,21379831,21380122,21392872,21412424,21413816,21416532,21418319,21419625,21420852,21422184,21422956,21424401,21425325,21427281,21431773,21432829,21433829,21436793,21437624,21439212,21440084,21446594,21446634,21450868,21458550,21481418,21482867,21483415,21483514,21484234,21485417,21486862,21571189,21575739,21576821,21581859,21585461,21586361,21589058,21591184,21594988,21598018,21606523,21607188,21608568,21608808,21609258,21609274,21609661,21610352,21610709,21611733,21612038,21612202,21612256,21612439,21616354,21616420,21616534,21616544,21616569,21616584,21617007,21617021,2161703', 'assoc_port': '20964506:20964687,20965613:20966207,20965638:20965878,20966600:20966605,20969599:20969967,20969612:20970283,20969625:20972754,20970848:20975026,20971881:20972226,20973396:20973649,20973397:20973581,20975993:20976027,20975995:20976149,20977625:20977795,20978677:20978761,20979775:20979996,20984408:20984445,20984410:20984967,20985747:20985787,20985748:20985783,20988801:20989000,20989141:20989212,21015498:21015541,21051476:21061821,21058641:21058973,21063621:21063979,21067483:21067522,21072876:21075096,21079468:21079541,21082619:21083014,21113068:21114075,21121422:21132458,21124392:21124590,21126117:21126354,21239178:21239231,21264436:21264590,21268999:21269242,21274019:21274298,21288195:21288570,21291474:21291906,21293589:21293841,21298642:21299109,21301462:21307046,21306619:21306940,21311144:21311294,21314216:21315277,21319247:21319401,21334352:21334604,21348109:21348121,21378252:21380122,21378253:21379831,21392696:21392872,21412123:21412424,21413609:21413816,21416422:21416532,21418091:21418319,21419491:2141962', 'assoc_mat': '20964506:kraft:3726:20964687,20965613:kraft:3726:20966207,20965638:kraft:3726:20965878,20966600:kraft:3726:20966605,20969599:kraft:3726:20969967,20969612:kraft:3726:20970283,20969625:kraft:3726:20972754,20970848:kraft:3726:20975026,20971881:kraft:3726:20972226,20973396:kraft:3726:20973649,20973397:kraft:3726:20973581,20975993:kraft:3726:20976027,20975995:kraft:3726:20976149,20977625:kraft:3726:20977795,20978677:kraft:3726:20978761,20979775:kraft:3726:20979996,20984408:kraft:3726:20984445,20984410:kraft:3726:20984967,20985747:kraft:3726:20985787,20985748:kraft:3726:20985783,20988801:kraft:3726:20989000,20989141:kraft:3726:20989212,21015498:kraft:3726:21015541,21051476:kraft:3726:21061821,21058641:kraft:3726:21058973,21063621:kraft:3726:21063979,21067483:kraft:3726:21067522,21072876:kraft:3726:21075096,21079468:kraft:3726:21079541,21082619:kraft:3726:21083014,21113068:kraft:3726:21114075,21121422:kraft:3726:21132458,21124392:kraft:3726:21124590,21126117:kraft:3726:21126354,21239178:kraft:3726:21239231,21264436:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0031567153719896765, 'nb_photo': 60, 'list_port_cont': '20966204,20972221,20973582,20976033,20976090,20979993,20985777,21051941,21052881,21053208,21061982,21068393,21133668,21246770,21263771,21274256,21274329,21282222,21292853,21294712,21308271,21311293,21351286,21378482,21380089,21386966,21400834,21411400,21413817,21416529,21421045,21424863,21427284,21428727,21433826,21440078,21443026,21446591,21450867,21571622,21581124,21608616,21609175,21610702,21616530,21616585,21616596,21617014,21617042', 'assoc_port': '20965613:20966204,20971881:20972221,20973397:20973582,20975993:20976033,20975994:20976090,20979775:20979993,20985748:20985777,21051475:21051941,21052624:21052881,21053151:21053208,21061924:21061982,21067482:21068393,21121415:21133668,21245265:21246770,21263611:21263771,21274019:21274329,21274022:21274256,21281705:21282222,21292572:21292853,21294295:21294712,21308149:21308271,21311144:21311293,21350864:21351286,21378251:21380089,21378269:21386966,21378271:21378482,21400732:21400834,21411358:21411400,21413609:21413817,21416422:21416529,21420617:21421045,21424769:21424863,21427187:21427284,21428303:21428727,21433631:21433826,21440013:21440078,21442784:21443026,21446414:21446591,21450228:21450867,21571076:21571622,21572296:21617042,21572297:21617014,21572300:21616585,21572301:21616596,21572305:21616530,21580529:21581124,21606625:21610702,21606659:21609175,21606663:21608616', 'assoc_mat': '20965613:metal:3726:20966204,20971881:metal:3726:20972221,20973397:metal:3726:20973582,20975993:metal:3726:20976033,20975994:metal:3726:20976090,20979775:metal:3726:20979993,20985748:metal:3726:20985777,21051475:metal:3726:21051941,21052624:metal:3726:21052881,21053151:metal:3726:21053208,21061924:metal:3726:21061982,21067482:metal:3726:21068393,21121415:metal:3726:21133668,21245265:metal:3726:21246770,21263611:metal:3726:21263771,21274019:metal:3726:21274329,21274022:metal:3726:21274256,21281705:metal:3726:21282222,21292572:metal:3726:21292853,21294295:metal:3726:21294712,21308149:metal:3726:21308271,21311144:metal:3726:21311293,21350864:metal:3726:21351286,21378251:metal:3726:21380089,21378269:metal:3726:21386966,21378271:metal:3726:21378482,21400732:metal:3726:21400834,21411358:metal:3726:21411400,21413609:metal:3726:21413817,21416422:metal:3726:21416529,21420617:metal:3726:21421045,21424769:metal:3726:21424863,21427187:metal:3726:21427284,21428303:metal:3726:21428727,21433631:metal:3726:21433826,21440013:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.006823912957240115, 'nb_photo': 1110, 'list_port_cont': '20947821,20947840,20947847,20947979,20947981,20948133,20948243,20948667,20948743,20948948,20964682,20965843,20965875,20966213,20966606,20967515,20967690,20969821,20969962,20970277,20971043,20972229,20972762,20973584,20973643,20973808,20975023,20976029,20976089,20976160,20976835,20976933,20977710,20977796,20978756,20980000,20982019,20982216,20983239,20984448,20984564,20984964,20985785,20985797,20987148,20988831,20989001,20989150,20991882,21001637,21002920,21002933,21003059,21005070,21005146,21005380,21007951,21008079,21008087,21008984,21010002,21011497,21012627,21013035,21014413,21015539,21016881,21017052,21017116,21018352,21019495,21022469,21023445,21024531,21024683,21025461,21026821,21028259,21031263,21031561,21031898,21032264,21034238,21034778,21051669,21051934,21052885,21053081,21053210,21058968,21061825,21061988,21062171,21062498,21063758,21065498,21067519,21068033,21070303,21070372,21070399,21070770,21071565,21073099,21073153,21074942,21078386,21078684,21079545,21079812,21080147,21082873,21083017,2108328', 'assoc_port': '20947776:20947979,20947777:20947847,20947778:20947821,20947779:20947840,20947931:20947981,20948122:20948133,20948193:20948243,20948529:20948948,20948661:20948667,20948730:20948743,20964506:20964682,20965613:20966213,20965638:20965875,20965639:20965843,20966600:20966606,20967444:20967690,20967445:20967515,20969599:20969962,20969612:20970277,20969625:20972762,20969626:20969821,20970847:20971043,20970848:20975023,20971881:20972229,20973395:20973808,20973396:20973643,20973397:20973584,20975993:20976029,20975994:20976089,20975995:20976160,20976769:20976835,20976770:20976933,20977624:20977710,20977625:20977796,20978677:20978756,20979775:20980000,20979777:20982216,20981924:20982019,20983199:20983239,20984408:20984448,20984409:20984564,20984410:20984964,20985747:20985797,20985748:20985785,20987078:20987148,20988801:20989001,20988802:20989150,20988803:20988831,20991723:20991882,21001567:21003059,21001568:21002933,21001569:21001637,21002842:21005380,21002843:21002920,21004986:21005070,21004987:21005146,21006205:2100795', 'assoc_mat': '20947776:plastique:3726:20947979,20947777:plastique:3726:20947847,20947778:plastique:3726:20947821,20947779:plastique:3726:20947840,20947931:plastique:3726:20947981,20948122:plastique:3726:20948133,20948193:plastique:3726:20948243,20948529:plastique:3726:20948948,20948661:plastique:3726:20948667,20948730:plastique:3726:20948743,20964506:plastique:3726:20964682,20965613:plastique:3726:20966213,20965638:plastique:3726:20965875,20965639:plastique:3726:20965843,20966600:plastique:3726:20966606,20967444:plastique:3726:20967690,20967445:plastique:3726:20967515,20969599:plastique:3726:20969962,20969612:plastique:3726:20970277,20969625:plastique:3726:20972762,20969626:plastique:3726:20969821,20970847:plastique:3726:20971043,20970848:plastique:3726:20975023,20971881:plastique:3726:20972229,20973395:plastique:3726:20973808,20973396:plastique:3726:20973643,20973397:plastique:3726:20973584,20975993:plastique:3726:20976029,20975994:plastique:3726:20976089,20975995:plastique:3726:20976160,20976769:plastique:3726:20976835,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008378102186072281, 'nb_photo': 1904, 'list_port_cont': '20947833,20947985,20948244,20948369,20948601,20948662,20948740,20948939,20964684,20965837,20965881,20966214,20966604,20967522,20969823,20970282,20971041,20972222,20972752,20973585,20973651,20973815,20975025,20976030,20976092,20976151,20976931,20977713,20977799,20978763,20979829,20980001,20980943,20982024,20982215,20983230,20984446,20984560,20984971,20985775,20985788,20987153,20987187,20988827,20989002,20989151,20990545,20990612,20991885,20991946,20992192,21001644,21002917,21002926,21005072,21007958,21008093,21008993,21011489,21013036,21014408,21015542,21015613,21016882,21017117,21018005,21018348,21019483,21019498,21022466,21022560,21022621,21022712,21023449,21024530,21024684,21025459,21026819,21028258,21031065,21031268,21031559,21031901,21032267,21033799,21034242,21034784,21051935,21052886,21053076,21053207,21058972,21059096,21061067,21061376,21061622,21061819,21061980,21062175,21062491,21062948,21063757,21064379,21064540,21065495,21067525,21068390,21070306,21070396,21070769,21071249,21071562,21073097,2107315', 'assoc_port': '20947779:20947833,20947931:20947985,20948193:20948244,20948291:20948369,20948529:20948939,20948594:20948601,20948661:20948662,20948730:20948740,20964506:20964684,20965613:20966214,20965638:20965881,20965639:20965837,20966600:20966604,20967445:20967522,20969612:20970282,20969625:20972752,20969626:20969823,20970847:20971041,20970848:20975025,20971881:20972222,20973395:20973815,20973396:20973651,20973397:20973585,20975993:20976030,20975994:20976092,20975995:20976151,20976770:20976931,20977624:20977713,20977625:20977799,20978677:20978763,20979775:20980001,20979776:20979829,20979777:20982215,20980885:20980943,20981924:20982024,20983199:20983230,20984408:20984446,20984409:20984560,20984410:20984971,20985747:20985788,20985748:20985775,20987078:20987153,20987079:20987187,20988801:20989002,20988802:20989151,20988803:20988827,20990451:20990545,20990452:20990612,20991723:20991885,20991724:20991946,20992187:20992192,21001568:21002926,21001569:21001644,21002843:21002917,21004986:21005072,21006205:21007958,21008057:2100809', 'assoc_mat': '20947779:Teint_Dans_La_Masse:3726:20947833,20947931:Teint_Dans_La_Masse:3726:20947985,20948193:Teint_Dans_La_Masse:3726:20948244,20948291:Teint_Dans_La_Masse:3726:20948369,20948529:Teint_Dans_La_Masse:3726:20948939,20948594:Teint_Dans_La_Masse:3726:20948601,20948661:Teint_Dans_La_Masse:3726:20948662,20948730:Teint_Dans_La_Masse:3726:20948740,20964506:Teint_Dans_La_Masse:3726:20964684,20965613:Teint_Dans_La_Masse:3726:20966214,20965638:Teint_Dans_La_Masse:3726:20965881,20965639:Teint_Dans_La_Masse:3726:20965837,20966600:Teint_Dans_La_Masse:3726:20966604,20967445:Teint_Dans_La_Masse:3726:20967522,20969612:Teint_Dans_La_Masse:3726:20970282,20969625:Teint_Dans_La_Masse:3726:20972752,20969626:Teint_Dans_La_Masse:3726:20969823,20970847:Teint_Dans_La_Masse:3726:20971041,20970848:Teint_Dans_La_Masse:3726:20975025,20971881:Teint_Dans_La_Masse:3726:20972222,20973395:Teint_Dans_La_Masse:3726:20973815,20973396:Teint_Dans_La_Masse:3726:20973651,20973397:Teint_Dans_La_Masse:3726:20973585,20975993:Teint_Dans_La_Masse:3726:2'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(1641269,1648468,1644675,1648145,1651761,1654501,1658104,1660783,1665436,1669573,1673168,1675678,1679951,1679945,1688687,1688639,1689901)); after get_hostname_from_raspi SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______JRM' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=979) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=25 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': ((14769,),), 'unwanted_material_monthly_percentage': 0, 'material_repartition': (('JRM', 14738),), 'material_dict': {'JRM': 14738}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.030727145252475038, 295), (datetime.date(2025, 3, 3), 0.03473517686026074, 1249), (datetime.date(2025, 3, 4), 0.025682328446464536, 1206), (datetime.date(2025, 3, 5), 0.027623042474106366, 1341), (datetime.date(2025, 3, 6), 0.02840233452853388, 1098), (datetime.date(2025, 3, 7), 0.02469542902112017, 554), (datetime.date(2025, 3, 10), 0.029942892955242505, 711), (datetime.date(2025, 3, 11), 0.034432593683758006, 1609), (datetime.date(2025, 3, 12), 0.023631966391534972, 966), (datetime.date(2025, 3, 13), 0.027118398908121708, 856), (datetime.date(2025, 3, 14), 0.041062142912953, 1499), (datetime.date(2025, 3, 17), 0.0397061217250057, 1489), (datetime.date(2025, 3, 21), 0.040942994184791116, 1125), (datetime.date(2025, 3, 22), 0.03361346881726765, 740)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 3, 1), 0.030727145252475038, 295), (datetime.date(2025, 3, 3), 0.03473517686026074, 1249), (datetime.date(2025, 3, 4), 0.025682328446464536, 1206), (datetime.date(2025, 3, 5), 0.027623042474106366, 1341), (datetime.date(2025, 3, 6), 0.02840233452853388, 1098), (datetime.date(2025, 3, 7), 0.02469542902112017, 554), (datetime.date(2025, 3, 10), 0.029942892955242505, 711), (datetime.date(2025, 3, 11), 0.034432593683758006, 1609), (datetime.date(2025, 3, 12), 0.023631966391534972, 966), (datetime.date(2025, 3, 13), 0.027118398908121708, 856), (datetime.date(2025, 3, 14), 0.041062142912953, 1499), (datetime.date(2025, 3, 17), 0.0397061217250057, 1489), (datetime.date(2025, 3, 21), 0.040942994184791116, 1125), (datetime.date(2025, 3, 22), 0.03361346881726765, 740))}, 'quality_array': [], 'number_of_batch': ((571,),), 'datou_id_sts': 3385, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007758737799972387, 'nb_photo': 675, 'list_port_cont': '20948130,20948241,20948367,20948672,20948732,20964679,20966210,20966601,20969822,20971045,20972228,20973576,20973640,20973814,20975029,20976031,20976094,20976150,20977792,20979998,20980949,20981986,20983231,20984439,20984559,20984973,20985778,20985791,20987149,20987186,20989006,20989146,20989214,20990554,20990609,20991942,20992195,21001641,21002922,21002932,21003056,21007957,21010010,21011399,21012630,21013034,21015537,21016878,21017119,21018343,21019496,21022459,21022568,21022628,21023450,21031266,21031899,21032262,21033803,21051689,21051943,21053078,21058971,21059098,21061822,21062176,21063756,21067523,21068032,21070391,21074937,21074972,21078389,21078981,21079801,21082749,21082869,21083288,21084206,21089141,21105663,21105816,21106867,21107038,21109154,21109373,21110242,21110369,21113209,21113513,21114061,21114374,21115738,21121772,21124587,21124870,21126255,21129624,21132159,21132181,21142637,21143870,21145099,21146844,21147698,21148351,21152328,21152757,21155845,21157352,21158948,21160189,21224061,2122650', 'assoc_port': '20948122:20948130,20948193:20948241,20948291:20948367,20948661:20948672,20948730:20948732,20964506:20964679,20965613:20966210,20966600:20966601,20969626:20969822,20970847:20971045,20970848:20975029,20971881:20972228,20973395:20973814,20973396:20973640,20973397:20973576,20975993:20976031,20975994:20976094,20975995:20976150,20977625:20977792,20979775:20979998,20980885:20980949,20981923:20981986,20983199:20983231,20984408:20984439,20984409:20984559,20984410:20984973,20985747:20985791,20985748:20985778,20987078:20987149,20987079:20987186,20988801:20989006,20988802:20989146,20989141:20989214,20990451:20990554,20990452:20990609,20991724:20991942,20992187:20992195,21001567:21003056,21001568:21002932,21001569:21001641,21002843:21002922,21006205:21007957,21009933:21010010,21011294:21011399,21012536:21012630,21012918:21013034,21015498:21015537,21016805:21017119,21016807:21016878,21017919:21018343,21019276:21019496,21022455:21022568,21022456:21022628,21022457:21022459,21023392:21023450,21031000:21032262,21031001:2103126', 'assoc_mat': '20948122:autre_refus:3726:20948130,20948193:autre_refus:3726:20948241,20948291:autre_refus:3726:20948367,20948661:autre_refus:3726:20948672,20948730:autre_refus:3726:20948732,20964506:autre_refus:3726:20964679,20965613:autre_refus:3726:20966210,20966600:autre_refus:3726:20966601,20969626:autre_refus:3726:20969822,20970847:autre_refus:3726:20971045,20970848:autre_refus:3726:20975029,20971881:autre_refus:3726:20972228,20973395:autre_refus:3726:20973814,20973396:autre_refus:3726:20973640,20973397:autre_refus:3726:20973576,20975993:autre_refus:3726:20976031,20975994:autre_refus:3726:20976094,20975995:autre_refus:3726:20976150,20977625:autre_refus:3726:20977792,20979775:autre_refus:3726:20979998,20980885:autre_refus:3726:20980949,20981923:autre_refus:3726:20981986,20983199:autre_refus:3726:20983231,20984408:autre_refus:3726:20984439,20984409:autre_refus:3726:20984559,20984410:autre_refus:3726:20984973,20985747:autre_refus:3726:20985791,20985748:autre_refus:3726:20985778,20987078:autre_refus:3726:20987149,20987079:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007193408220629753, 'nb_photo': 1408, 'list_port_cont': '20947832,20948126,20948370,20948595,20948947,20964683,20965838,20965882,20966209,20966603,20967523,20967682,20969826,20969965,20970280,20971040,20972224,20972759,20973586,20973646,20973819,20975031,20976024,20976093,20976153,20976929,20977802,20978762,20979839,20980003,20980947,20981933,20981983,20982027,20982222,20983228,20984440,20984561,20984969,20985781,20985795,20987191,20988822,20989003,20989147,20989206,20990611,20991881,20991937,21001643,21002929,21005144,21007952,21008142,21008992,21010009,21010118,21011494,21012634,21013030,21014410,21015533,21015608,21016880,21017055,21017121,21018346,21019491,21022461,21022558,21022620,21024533,21024686,21025453,21025998,21026818,21031554,21031903,21032266,21034232,21034785,21051688,21051738,21051942,21052888,21053203,21061068,21061830,21061987,21062178,21062951,21063752,21063972,21064370,21064546,21065499,21067524,21068035,21068399,21070302,21070395,21070764,21071561,21073101,21073152,21074944,21075093,21078380,21078688,21078976,21079543,21079802,21080139,2108276', 'assoc_port': '20947779:20947832,20948122:20948126,20948291:20948370,20948529:20948947,20948594:20948595,20964506:20964683,20965613:20966209,20965638:20965882,20965639:20965838,20966600:20966603,20967444:20967682,20967445:20967523,20969599:20969965,20969612:20970280,20969625:20972759,20969626:20969826,20970847:20971040,20970848:20975031,20971881:20972224,20973395:20973819,20973396:20973646,20973397:20973586,20975993:20976024,20975994:20976093,20975995:20976153,20976770:20976929,20977625:20977802,20978677:20978762,20979775:20980003,20979776:20979839,20979777:20982222,20980885:20980947,20981923:20981983,20981924:20982027,20981925:20981933,20983199:20983228,20984408:20984440,20984409:20984561,20984410:20984969,20985747:20985795,20985748:20985781,20987079:20987191,20988801:20989003,20988802:20989147,20988803:20988822,20989141:20989206,20990452:20990611,20991723:20991881,20991724:20991937,21001568:21002929,21001569:21001643,21004987:21005144,21006205:21007952,21008056:21008142,21008954:21008992,21009932:21010118,21009933:2101000', 'assoc_mat': '20947779:cartonnette:3726:20947832,20948122:cartonnette:3726:20948126,20948291:cartonnette:3726:20948370,20948529:cartonnette:3726:20948947,20948594:cartonnette:3726:20948595,20964506:cartonnette:3726:20964683,20965613:cartonnette:3726:20966209,20965638:cartonnette:3726:20965882,20965639:cartonnette:3726:20965838,20966600:cartonnette:3726:20966603,20967444:cartonnette:3726:20967682,20967445:cartonnette:3726:20967523,20969599:cartonnette:3726:20969965,20969612:cartonnette:3726:20970280,20969625:cartonnette:3726:20972759,20969626:cartonnette:3726:20969826,20970847:cartonnette:3726:20971040,20970848:cartonnette:3726:20975031,20971881:cartonnette:3726:20972224,20973395:cartonnette:3726:20973819,20973396:cartonnette:3726:20973646,20973397:cartonnette:3726:20973586,20975993:cartonnette:3726:20976024,20975994:cartonnette:3726:20976093,20975995:cartonnette:3726:20976153,20976770:cartonnette:3726:20976929,20977625:cartonnette:3726:20977802,20978677:cartonnette:3726:20978762,20979775:cartonnette:3726:20980003,20979776:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009769917383370809, 'nb_photo': 1260, 'list_port_cont': '20947838,20948136,20948242,20948949,20964688,20965848,20965884,20966212,20966612,20967520,20967683,20969820,20969959,20970274,20971046,20972231,20972761,20973580,20973641,20973818,20975030,20976032,20976096,20976152,20977712,20977801,20978757,20979835,20979994,20980938,20981977,20982017,20983229,20984441,20984553,20984972,20985779,20985793,20987144,20987194,20989005,20989144,20989211,20990549,20990616,20991941,21003063,21005069,21007953,21011391,21014414,21015534,21015607,21022563,21031058,21031551,21034234,21034775,21051728,21051939,21052889,21053213,21058969,21059095,21061370,21061829,21062497,21062944,21063753,21063971,21068039,21068394,21070304,21070768,21071239,21071566,21073100,21073160,21074940,21074963,21075095,21078378,21078691,21080145,21082759,21082874,21083280,21084212,21086050,21086147,21088473,21106873,21107041,21108642,21109149,21109371,21110238,21113200,21114054,21114383,21114985,21115745,21121760,21122946,21123196,21126364,21127626,21128663,21132039,21132187,21132369,21132492,21132544,2113255', 'assoc_port': '20947779:20947838,20948122:20948136,20948193:20948242,20948529:20948949,20964506:20964688,20965613:20966212,20965638:20965884,20965639:20965848,20966600:20966612,20967444:20967683,20967445:20967520,20969599:20969959,20969612:20970274,20969625:20972761,20969626:20969820,20970847:20971046,20970848:20975030,20971881:20972231,20973395:20973818,20973396:20973641,20973397:20973580,20975993:20976032,20975994:20976096,20975995:20976152,20977624:20977712,20977625:20977801,20978677:20978757,20979775:20979994,20979776:20979835,20980885:20980938,20981923:20981977,20981924:20982017,20983199:20983229,20984408:20984441,20984409:20984553,20984410:20984972,20985747:20985793,20985748:20985779,20987078:20987144,20987079:20987194,20988801:20989005,20988802:20989144,20989141:20989211,20990451:20990549,20990452:20990616,20991724:20991941,21001567:21003063,21004986:21005069,21006205:21007953,21011294:21011391,21012537:21015607,21014325:21014414,21015498:21015534,21022455:21022563,21030999:21034775,21031002:21031058,21031494:2103155', 'assoc_mat': '20947779:Carton_brun:3726:20947838,20948122:Carton_brun:3726:20948136,20948193:Carton_brun:3726:20948242,20948529:Carton_brun:3726:20948949,20964506:Carton_brun:3726:20964688,20965613:Carton_brun:3726:20966212,20965638:Carton_brun:3726:20965884,20965639:Carton_brun:3726:20965848,20966600:Carton_brun:3726:20966612,20967444:Carton_brun:3726:20967683,20967445:Carton_brun:3726:20967520,20969599:Carton_brun:3726:20969959,20969612:Carton_brun:3726:20970274,20969625:Carton_brun:3726:20972761,20969626:Carton_brun:3726:20969820,20970847:Carton_brun:3726:20971046,20970848:Carton_brun:3726:20975030,20971881:Carton_brun:3726:20972231,20973395:Carton_brun:3726:20973818,20973396:Carton_brun:3726:20973641,20973397:Carton_brun:3726:20973580,20975993:Carton_brun:3726:20976032,20975994:Carton_brun:3726:20976096,20975995:Carton_brun:3726:20976152,20977624:Carton_brun:3726:20977712,20977625:Carton_brun:3726:20977801,20978677:Carton_brun:3726:20978757,20979775:Carton_brun:3726:20979994,20979776:Carton_brun:3726:20979835,20980885:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00814502276150966, 'nb_photo': 811, 'list_port_cont': '20947831,20947854,20947973,20947990,20948125,20948237,20948371,20948597,20948666,20948735,20948940,20964680,20965842,20965873,20969824,20970276,20971047,20972223,20972758,20973583,20973648,20973816,20975027,20976023,20976095,20976159,20976845,20977791,20978753,20979997,20982224,20984557,20985776,20985792,20988826,20989009,20989155,20991938,20992200,21001636,21002915,21003054,21005066,21007949,21008139,21010011,21010126,21011498,21012625,21013026,21014407,21015535,21015606,21016875,21017115,21018002,21019499,21022462,21022559,21022626,21023451,21024682,21025457,21031057,21031265,21031555,21031894,21032260,21033795,21034239,21034774,21051673,21051735,21051940,21052883,21053083,21053214,21059092,21061074,21061367,21061823,21063760,21063977,21064376,21065502,21067521,21068038,21068396,21070775,21071242,21071563,21073105,21073155,21074941,21078383,21078687,21079809,21080140,21082879,21083013,21083285,21086054,21086138,21088478,21089392,21105668,21105817,21106871,21107044,21109151,21109381,21110239,21110372,2111320', 'assoc_port': '20947776:20947973,20947777:20947854,20947779:20947831,20947931:20947990,20948122:20948125,20948193:20948237,20948291:20948371,20948529:20948940,20948594:20948597,20948661:20948666,20948730:20948735,20964506:20964680,20965638:20965873,20965639:20965842,20969612:20970276,20969625:20972758,20969626:20969824,20970847:20971047,20970848:20975027,20971881:20972223,20973395:20973816,20973396:20973648,20973397:20973583,20975993:20976023,20975994:20976095,20975995:20976159,20976769:20976845,20977625:20977791,20978677:20978753,20979775:20979997,20979777:20982224,20984409:20984557,20985747:20985792,20985748:20985776,20988801:20989009,20988802:20989155,20988803:20988826,20991724:20991938,20992187:20992200,21001567:21003054,21001569:21001636,21002843:21002915,21004986:21005066,21006205:21007949,21008056:21008139,21009932:21010126,21009933:21010011,21011295:21011498,21012536:21012625,21012537:21015606,21012918:21013026,21014325:21014407,21015498:21015535,21016805:21017115,21016807:21016875,21017918:21018002,21019276:2101949', 'assoc_mat': '20947776:Carton_gris:3726:20947973,20947777:Carton_gris:3726:20947854,20947779:Carton_gris:3726:20947831,20947931:Carton_gris:3726:20947990,20948122:Carton_gris:3726:20948125,20948193:Carton_gris:3726:20948237,20948291:Carton_gris:3726:20948371,20948529:Carton_gris:3726:20948940,20948594:Carton_gris:3726:20948597,20948661:Carton_gris:3726:20948666,20948730:Carton_gris:3726:20948735,20964506:Carton_gris:3726:20964680,20965638:Carton_gris:3726:20965873,20965639:Carton_gris:3726:20965842,20969612:Carton_gris:3726:20970276,20969625:Carton_gris:3726:20972758,20969626:Carton_gris:3726:20969824,20970847:Carton_gris:3726:20971047,20970848:Carton_gris:3726:20975027,20971881:Carton_gris:3726:20972223,20973395:Carton_gris:3726:20973816,20973396:Carton_gris:3726:20973648,20973397:Carton_gris:3726:20973583,20975993:Carton_gris:3726:20976023,20975994:Carton_gris:3726:20976095,20975995:Carton_gris:3726:20976159,20976769:Carton_gris:3726:20976845,20977625:Carton_gris:3726:20977791,20978677:Carton_gris:3726:20978753,20979775:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0027443509346329934, 'nb_photo': 174, 'list_port_cont': '20964687,20965878,20966207,20966605,20969967,20970283,20972226,20972754,20973581,20973649,20975026,20976027,20976149,20977795,20978761,20979996,20984445,20984967,20985783,20985787,20989000,20989212,21015541,21058973,21061821,21063979,21067522,21075096,21079541,21083014,21114075,21124590,21126354,21132458,21239231,21264590,21269242,21274298,21288570,21291906,21293841,21299109,21306940,21307046,21311294,21315277,21319401,21334604,21348121,21379831,21380122,21392872,21412424,21413816,21416532,21418319,21419625,21420852,21422184,21422956,21424401,21425325,21427281,21431773,21432829,21433829,21436793,21437624,21439212,21440084,21446594,21446634,21450868,21458550,21481418,21482867,21483415,21483514,21484234,21485417,21486862,21571189,21575739,21576821,21581859,21585461,21586361,21589058,21591184,21594988,21598018,21606523,21607188,21608568,21608808,21609258,21609274,21609661,21610352,21610709,21611733,21612038,21612202,21612256,21612439,21616354,21616420,21616534,21616544,21616569,21616584,21617007,21617021,2161703', 'assoc_port': '20964506:20964687,20965613:20966207,20965638:20965878,20966600:20966605,20969599:20969967,20969612:20970283,20969625:20972754,20970848:20975026,20971881:20972226,20973396:20973649,20973397:20973581,20975993:20976027,20975995:20976149,20977625:20977795,20978677:20978761,20979775:20979996,20984408:20984445,20984410:20984967,20985747:20985787,20985748:20985783,20988801:20989000,20989141:20989212,21015498:21015541,21051476:21061821,21058641:21058973,21063621:21063979,21067483:21067522,21072876:21075096,21079468:21079541,21082619:21083014,21113068:21114075,21121422:21132458,21124392:21124590,21126117:21126354,21239178:21239231,21264436:21264590,21268999:21269242,21274019:21274298,21288195:21288570,21291474:21291906,21293589:21293841,21298642:21299109,21301462:21307046,21306619:21306940,21311144:21311294,21314216:21315277,21319247:21319401,21334352:21334604,21348109:21348121,21378252:21380122,21378253:21379831,21392696:21392872,21412123:21412424,21413609:21413816,21416422:21416532,21418091:21418319,21419491:2141962', 'assoc_mat': '20964506:kraft:3726:20964687,20965613:kraft:3726:20966207,20965638:kraft:3726:20965878,20966600:kraft:3726:20966605,20969599:kraft:3726:20969967,20969612:kraft:3726:20970283,20969625:kraft:3726:20972754,20970848:kraft:3726:20975026,20971881:kraft:3726:20972226,20973396:kraft:3726:20973649,20973397:kraft:3726:20973581,20975993:kraft:3726:20976027,20975995:kraft:3726:20976149,20977625:kraft:3726:20977795,20978677:kraft:3726:20978761,20979775:kraft:3726:20979996,20984408:kraft:3726:20984445,20984410:kraft:3726:20984967,20985747:kraft:3726:20985787,20985748:kraft:3726:20985783,20988801:kraft:3726:20989000,20989141:kraft:3726:20989212,21015498:kraft:3726:21015541,21051476:kraft:3726:21061821,21058641:kraft:3726:21058973,21063621:kraft:3726:21063979,21067483:kraft:3726:21067522,21072876:kraft:3726:21075096,21079468:kraft:3726:21079541,21082619:kraft:3726:21083014,21113068:kraft:3726:21114075,21121422:kraft:3726:21132458,21124392:kraft:3726:21124590,21126117:kraft:3726:21126354,21239178:kraft:3726:21239231,21264436:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0031567153719896765, 'nb_photo': 60, 'list_port_cont': '20966204,20972221,20973582,20976033,20976090,20979993,20985777,21051941,21052881,21053208,21061982,21068393,21133668,21246770,21263771,21274256,21274329,21282222,21292853,21294712,21308271,21311293,21351286,21378482,21380089,21386966,21400834,21411400,21413817,21416529,21421045,21424863,21427284,21428727,21433826,21440078,21443026,21446591,21450867,21571622,21581124,21608616,21609175,21610702,21616530,21616585,21616596,21617014,21617042', 'assoc_port': '20965613:20966204,20971881:20972221,20973397:20973582,20975993:20976033,20975994:20976090,20979775:20979993,20985748:20985777,21051475:21051941,21052624:21052881,21053151:21053208,21061924:21061982,21067482:21068393,21121415:21133668,21245265:21246770,21263611:21263771,21274019:21274329,21274022:21274256,21281705:21282222,21292572:21292853,21294295:21294712,21308149:21308271,21311144:21311293,21350864:21351286,21378251:21380089,21378269:21386966,21378271:21378482,21400732:21400834,21411358:21411400,21413609:21413817,21416422:21416529,21420617:21421045,21424769:21424863,21427187:21427284,21428303:21428727,21433631:21433826,21440013:21440078,21442784:21443026,21446414:21446591,21450228:21450867,21571076:21571622,21572296:21617042,21572297:21617014,21572300:21616585,21572301:21616596,21572305:21616530,21580529:21581124,21606625:21610702,21606659:21609175,21606663:21608616', 'assoc_mat': '20965613:metal:3726:20966204,20971881:metal:3726:20972221,20973397:metal:3726:20973582,20975993:metal:3726:20976033,20975994:metal:3726:20976090,20979775:metal:3726:20979993,20985748:metal:3726:20985777,21051475:metal:3726:21051941,21052624:metal:3726:21052881,21053151:metal:3726:21053208,21061924:metal:3726:21061982,21067482:metal:3726:21068393,21121415:metal:3726:21133668,21245265:metal:3726:21246770,21263611:metal:3726:21263771,21274019:metal:3726:21274329,21274022:metal:3726:21274256,21281705:metal:3726:21282222,21292572:metal:3726:21292853,21294295:metal:3726:21294712,21308149:metal:3726:21308271,21311144:metal:3726:21311293,21350864:metal:3726:21351286,21378251:metal:3726:21380089,21378269:metal:3726:21386966,21378271:metal:3726:21378482,21400732:metal:3726:21400834,21411358:metal:3726:21411400,21413609:metal:3726:21413817,21416422:metal:3726:21416529,21420617:metal:3726:21421045,21424769:metal:3726:21424863,21427187:metal:3726:21427284,21428303:metal:3726:21428727,21433631:metal:3726:21433826,21440013:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.006823912957240115, 'nb_photo': 1110, 'list_port_cont': '20947821,20947840,20947847,20947979,20947981,20948133,20948243,20948667,20948743,20948948,20964682,20965843,20965875,20966213,20966606,20967515,20967690,20969821,20969962,20970277,20971043,20972229,20972762,20973584,20973643,20973808,20975023,20976029,20976089,20976160,20976835,20976933,20977710,20977796,20978756,20980000,20982019,20982216,20983239,20984448,20984564,20984964,20985785,20985797,20987148,20988831,20989001,20989150,20991882,21001637,21002920,21002933,21003059,21005070,21005146,21005380,21007951,21008079,21008087,21008984,21010002,21011497,21012627,21013035,21014413,21015539,21016881,21017052,21017116,21018352,21019495,21022469,21023445,21024531,21024683,21025461,21026821,21028259,21031263,21031561,21031898,21032264,21034238,21034778,21051669,21051934,21052885,21053081,21053210,21058968,21061825,21061988,21062171,21062498,21063758,21065498,21067519,21068033,21070303,21070372,21070399,21070770,21071565,21073099,21073153,21074942,21078386,21078684,21079545,21079812,21080147,21082873,21083017,2108328', 'assoc_port': '20947776:20947979,20947777:20947847,20947778:20947821,20947779:20947840,20947931:20947981,20948122:20948133,20948193:20948243,20948529:20948948,20948661:20948667,20948730:20948743,20964506:20964682,20965613:20966213,20965638:20965875,20965639:20965843,20966600:20966606,20967444:20967690,20967445:20967515,20969599:20969962,20969612:20970277,20969625:20972762,20969626:20969821,20970847:20971043,20970848:20975023,20971881:20972229,20973395:20973808,20973396:20973643,20973397:20973584,20975993:20976029,20975994:20976089,20975995:20976160,20976769:20976835,20976770:20976933,20977624:20977710,20977625:20977796,20978677:20978756,20979775:20980000,20979777:20982216,20981924:20982019,20983199:20983239,20984408:20984448,20984409:20984564,20984410:20984964,20985747:20985797,20985748:20985785,20987078:20987148,20988801:20989001,20988802:20989150,20988803:20988831,20991723:20991882,21001567:21003059,21001568:21002933,21001569:21001637,21002842:21005380,21002843:21002920,21004986:21005070,21004987:21005146,21006205:2100795', 'assoc_mat': '20947776:plastique:3726:20947979,20947777:plastique:3726:20947847,20947778:plastique:3726:20947821,20947779:plastique:3726:20947840,20947931:plastique:3726:20947981,20948122:plastique:3726:20948133,20948193:plastique:3726:20948243,20948529:plastique:3726:20948948,20948661:plastique:3726:20948667,20948730:plastique:3726:20948743,20964506:plastique:3726:20964682,20965613:plastique:3726:20966213,20965638:plastique:3726:20965875,20965639:plastique:3726:20965843,20966600:plastique:3726:20966606,20967444:plastique:3726:20967690,20967445:plastique:3726:20967515,20969599:plastique:3726:20969962,20969612:plastique:3726:20970277,20969625:plastique:3726:20972762,20969626:plastique:3726:20969821,20970847:plastique:3726:20971043,20970848:plastique:3726:20975023,20971881:plastique:3726:20972229,20973395:plastique:3726:20973808,20973396:plastique:3726:20973643,20973397:plastique:3726:20973584,20975993:plastique:3726:20976029,20975994:plastique:3726:20976089,20975995:plastique:3726:20976160,20976769:plastique:3726:20976835,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008378102186072281, 'nb_photo': 1904, 'list_port_cont': '20947833,20947985,20948244,20948369,20948601,20948662,20948740,20948939,20964684,20965837,20965881,20966214,20966604,20967522,20969823,20970282,20971041,20972222,20972752,20973585,20973651,20973815,20975025,20976030,20976092,20976151,20976931,20977713,20977799,20978763,20979829,20980001,20980943,20982024,20982215,20983230,20984446,20984560,20984971,20985775,20985788,20987153,20987187,20988827,20989002,20989151,20990545,20990612,20991885,20991946,20992192,21001644,21002917,21002926,21005072,21007958,21008093,21008993,21011489,21013036,21014408,21015542,21015613,21016882,21017117,21018005,21018348,21019483,21019498,21022466,21022560,21022621,21022712,21023449,21024530,21024684,21025459,21026819,21028258,21031065,21031268,21031559,21031901,21032267,21033799,21034242,21034784,21051935,21052886,21053076,21053207,21058972,21059096,21061067,21061376,21061622,21061819,21061980,21062175,21062491,21062948,21063757,21064379,21064540,21065495,21067525,21068390,21070306,21070396,21070769,21071249,21071562,21073097,2107315', 'assoc_port': '20947779:20947833,20947931:20947985,20948193:20948244,20948291:20948369,20948529:20948939,20948594:20948601,20948661:20948662,20948730:20948740,20964506:20964684,20965613:20966214,20965638:20965881,20965639:20965837,20966600:20966604,20967445:20967522,20969612:20970282,20969625:20972752,20969626:20969823,20970847:20971041,20970848:20975025,20971881:20972222,20973395:20973815,20973396:20973651,20973397:20973585,20975993:20976030,20975994:20976092,20975995:20976151,20976770:20976931,20977624:20977713,20977625:20977799,20978677:20978763,20979775:20980001,20979776:20979829,20979777:20982215,20980885:20980943,20981924:20982024,20983199:20983230,20984408:20984446,20984409:20984560,20984410:20984971,20985747:20985788,20985748:20985775,20987078:20987153,20987079:20987187,20988801:20989002,20988802:20989151,20988803:20988827,20990451:20990545,20990452:20990612,20991723:20991885,20991724:20991946,20992187:20992192,21001568:21002926,21001569:21001644,21002843:21002917,21004986:21005072,21006205:21007958,21008057:2100809', 'assoc_mat': '20947779:Teint_Dans_La_Masse:3726:20947833,20947931:Teint_Dans_La_Masse:3726:20947985,20948193:Teint_Dans_La_Masse:3726:20948244,20948291:Teint_Dans_La_Masse:3726:20948369,20948529:Teint_Dans_La_Masse:3726:20948939,20948594:Teint_Dans_La_Masse:3726:20948601,20948661:Teint_Dans_La_Masse:3726:20948662,20948730:Teint_Dans_La_Masse:3726:20948740,20964506:Teint_Dans_La_Masse:3726:20964684,20965613:Teint_Dans_La_Masse:3726:20966214,20965638:Teint_Dans_La_Masse:3726:20965881,20965639:Teint_Dans_La_Masse:3726:20965837,20966600:Teint_Dans_La_Masse:3726:20966604,20967445:Teint_Dans_La_Masse:3726:20967522,20969612:Teint_Dans_La_Masse:3726:20970282,20969625:Teint_Dans_La_Masse:3726:20972752,20969626:Teint_Dans_La_Masse:3726:20969823,20970847:Teint_Dans_La_Masse:3726:20971041,20970848:Teint_Dans_La_Masse:3726:20975025,20971881:Teint_Dans_La_Masse:3726:20972222,20973395:Teint_Dans_La_Masse:3726:20973815,20973396:Teint_Dans_La_Masse:3726:20973651,20973397:Teint_Dans_La_Masse:3726:20973585,20975993:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 14769}}, 'hostname': (), 'impurety_average_per_hashtag': []} VR TODO 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 ! VR TODO 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 ! VR TODO 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 ! VR TODO 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=3385 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=3385 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= 3385 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=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="arc_en_ciel_jrm_peu_dense"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 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=3385 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= 3385 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=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((14769,),), 'unwanted_material_monthly_percentage': 0, 'material_repartition': (('JRM', 14738),), 'material_dict': {'JRM': 14738}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.030727145252475038, 295), (datetime.date(2025, 3, 3), 0.03473517686026074, 1249), (datetime.date(2025, 3, 4), 0.025682328446464536, 1206), (datetime.date(2025, 3, 5), 0.027623042474106366, 1341), (datetime.date(2025, 3, 6), 0.02840233452853388, 1098), (datetime.date(2025, 3, 7), 0.02469542902112017, 554), (datetime.date(2025, 3, 10), 0.029942892955242505, 711), (datetime.date(2025, 3, 11), 0.034432593683758006, 1609), (datetime.date(2025, 3, 12), 0.023631966391534972, 966), (datetime.date(2025, 3, 13), 0.027118398908121708, 856), (datetime.date(2025, 3, 14), 0.041062142912953, 1499), (datetime.date(2025, 3, 17), 0.0397061217250057, 1489), (datetime.date(2025, 3, 21), 0.040942994184791116, 1125), (datetime.date(2025, 3, 22), 0.03361346881726765, 740)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 3, 1), 0.030727145252475038, 295), (datetime.date(2025, 3, 3), 0.03473517686026074, 1249), (datetime.date(2025, 3, 4), 0.025682328446464536, 1206), (datetime.date(2025, 3, 5), 0.027623042474106366, 1341), (datetime.date(2025, 3, 6), 0.02840233452853388, 1098), (datetime.date(2025, 3, 7), 0.02469542902112017, 554), (datetime.date(2025, 3, 10), 0.029942892955242505, 711), (datetime.date(2025, 3, 11), 0.034432593683758006, 1609), (datetime.date(2025, 3, 12), 0.023631966391534972, 966), (datetime.date(2025, 3, 13), 0.027118398908121708, 856), (datetime.date(2025, 3, 14), 0.041062142912953, 1499), (datetime.date(2025, 3, 17), 0.0397061217250057, 1489), (datetime.date(2025, 3, 21), 0.040942994184791116, 1125), (datetime.date(2025, 3, 22), 0.03361346881726765, 740))}, 'quality_array': [], 'number_of_batch': ((571,),), 'datou_id_sts': 3385, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007758737799972387, 'nb_photo': 675, 'list_port_cont': '20948130,20948241,20948367,20948672,20948732,20964679,20966210,20966601,20969822,20971045,20972228,20973576,20973640,20973814,20975029,20976031,20976094,20976150,20977792,20979998,20980949,20981986,20983231,20984439,20984559,20984973,20985778,20985791,20987149,20987186,20989006,20989146,20989214,20990554,20990609,20991942,20992195,21001641,21002922,21002932,21003056,21007957,21010010,21011399,21012630,21013034,21015537,21016878,21017119,21018343,21019496,21022459,21022568,21022628,21023450,21031266,21031899,21032262,21033803,21051689,21051943,21053078,21058971,21059098,21061822,21062176,21063756,21067523,21068032,21070391,21074937,21074972,21078389,21078981,21079801,21082749,21082869,21083288,21084206,21089141,21105663,21105816,21106867,21107038,21109154,21109373,21110242,21110369,21113209,21113513,21114061,21114374,21115738,21121772,21124587,21124870,21126255,21129624,21132159,21132181,21142637,21143870,21145099,21146844,21147698,21148351,21152328,21152757,21155845,21157352,21158948,21160189,21224061,2122650', 'assoc_port': '20948122:20948130,20948193:20948241,20948291:20948367,20948661:20948672,20948730:20948732,20964506:20964679,20965613:20966210,20966600:20966601,20969626:20969822,20970847:20971045,20970848:20975029,20971881:20972228,20973395:20973814,20973396:20973640,20973397:20973576,20975993:20976031,20975994:20976094,20975995:20976150,20977625:20977792,20979775:20979998,20980885:20980949,20981923:20981986,20983199:20983231,20984408:20984439,20984409:20984559,20984410:20984973,20985747:20985791,20985748:20985778,20987078:20987149,20987079:20987186,20988801:20989006,20988802:20989146,20989141:20989214,20990451:20990554,20990452:20990609,20991724:20991942,20992187:20992195,21001567:21003056,21001568:21002932,21001569:21001641,21002843:21002922,21006205:21007957,21009933:21010010,21011294:21011399,21012536:21012630,21012918:21013034,21015498:21015537,21016805:21017119,21016807:21016878,21017919:21018343,21019276:21019496,21022455:21022568,21022456:21022628,21022457:21022459,21023392:21023450,21031000:21032262,21031001:2103126', 'assoc_mat': '20948122:autre_refus:3726:20948130,20948193:autre_refus:3726:20948241,20948291:autre_refus:3726:20948367,20948661:autre_refus:3726:20948672,20948730:autre_refus:3726:20948732,20964506:autre_refus:3726:20964679,20965613:autre_refus:3726:20966210,20966600:autre_refus:3726:20966601,20969626:autre_refus:3726:20969822,20970847:autre_refus:3726:20971045,20970848:autre_refus:3726:20975029,20971881:autre_refus:3726:20972228,20973395:autre_refus:3726:20973814,20973396:autre_refus:3726:20973640,20973397:autre_refus:3726:20973576,20975993:autre_refus:3726:20976031,20975994:autre_refus:3726:20976094,20975995:autre_refus:3726:20976150,20977625:autre_refus:3726:20977792,20979775:autre_refus:3726:20979998,20980885:autre_refus:3726:20980949,20981923:autre_refus:3726:20981986,20983199:autre_refus:3726:20983231,20984408:autre_refus:3726:20984439,20984409:autre_refus:3726:20984559,20984410:autre_refus:3726:20984973,20985747:autre_refus:3726:20985791,20985748:autre_refus:3726:20985778,20987078:autre_refus:3726:20987149,20987079:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007193408220629753, 'nb_photo': 1408, 'list_port_cont': '20947832,20948126,20948370,20948595,20948947,20964683,20965838,20965882,20966209,20966603,20967523,20967682,20969826,20969965,20970280,20971040,20972224,20972759,20973586,20973646,20973819,20975031,20976024,20976093,20976153,20976929,20977802,20978762,20979839,20980003,20980947,20981933,20981983,20982027,20982222,20983228,20984440,20984561,20984969,20985781,20985795,20987191,20988822,20989003,20989147,20989206,20990611,20991881,20991937,21001643,21002929,21005144,21007952,21008142,21008992,21010009,21010118,21011494,21012634,21013030,21014410,21015533,21015608,21016880,21017055,21017121,21018346,21019491,21022461,21022558,21022620,21024533,21024686,21025453,21025998,21026818,21031554,21031903,21032266,21034232,21034785,21051688,21051738,21051942,21052888,21053203,21061068,21061830,21061987,21062178,21062951,21063752,21063972,21064370,21064546,21065499,21067524,21068035,21068399,21070302,21070395,21070764,21071561,21073101,21073152,21074944,21075093,21078380,21078688,21078976,21079543,21079802,21080139,2108276', 'assoc_port': '20947779:20947832,20948122:20948126,20948291:20948370,20948529:20948947,20948594:20948595,20964506:20964683,20965613:20966209,20965638:20965882,20965639:20965838,20966600:20966603,20967444:20967682,20967445:20967523,20969599:20969965,20969612:20970280,20969625:20972759,20969626:20969826,20970847:20971040,20970848:20975031,20971881:20972224,20973395:20973819,20973396:20973646,20973397:20973586,20975993:20976024,20975994:20976093,20975995:20976153,20976770:20976929,20977625:20977802,20978677:20978762,20979775:20980003,20979776:20979839,20979777:20982222,20980885:20980947,20981923:20981983,20981924:20982027,20981925:20981933,20983199:20983228,20984408:20984440,20984409:20984561,20984410:20984969,20985747:20985795,20985748:20985781,20987079:20987191,20988801:20989003,20988802:20989147,20988803:20988822,20989141:20989206,20990452:20990611,20991723:20991881,20991724:20991937,21001568:21002929,21001569:21001643,21004987:21005144,21006205:21007952,21008056:21008142,21008954:21008992,21009932:21010118,21009933:2101000', 'assoc_mat': '20947779:cartonnette:3726:20947832,20948122:cartonnette:3726:20948126,20948291:cartonnette:3726:20948370,20948529:cartonnette:3726:20948947,20948594:cartonnette:3726:20948595,20964506:cartonnette:3726:20964683,20965613:cartonnette:3726:20966209,20965638:cartonnette:3726:20965882,20965639:cartonnette:3726:20965838,20966600:cartonnette:3726:20966603,20967444:cartonnette:3726:20967682,20967445:cartonnette:3726:20967523,20969599:cartonnette:3726:20969965,20969612:cartonnette:3726:20970280,20969625:cartonnette:3726:20972759,20969626:cartonnette:3726:20969826,20970847:cartonnette:3726:20971040,20970848:cartonnette:3726:20975031,20971881:cartonnette:3726:20972224,20973395:cartonnette:3726:20973819,20973396:cartonnette:3726:20973646,20973397:cartonnette:3726:20973586,20975993:cartonnette:3726:20976024,20975994:cartonnette:3726:20976093,20975995:cartonnette:3726:20976153,20976770:cartonnette:3726:20976929,20977625:cartonnette:3726:20977802,20978677:cartonnette:3726:20978762,20979775:cartonnette:3726:20980003,20979776:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.009769917383370809, 'nb_photo': 1260, 'list_port_cont': '20947838,20948136,20948242,20948949,20964688,20965848,20965884,20966212,20966612,20967520,20967683,20969820,20969959,20970274,20971046,20972231,20972761,20973580,20973641,20973818,20975030,20976032,20976096,20976152,20977712,20977801,20978757,20979835,20979994,20980938,20981977,20982017,20983229,20984441,20984553,20984972,20985779,20985793,20987144,20987194,20989005,20989144,20989211,20990549,20990616,20991941,21003063,21005069,21007953,21011391,21014414,21015534,21015607,21022563,21031058,21031551,21034234,21034775,21051728,21051939,21052889,21053213,21058969,21059095,21061370,21061829,21062497,21062944,21063753,21063971,21068039,21068394,21070304,21070768,21071239,21071566,21073100,21073160,21074940,21074963,21075095,21078378,21078691,21080145,21082759,21082874,21083280,21084212,21086050,21086147,21088473,21106873,21107041,21108642,21109149,21109371,21110238,21113200,21114054,21114383,21114985,21115745,21121760,21122946,21123196,21126364,21127626,21128663,21132039,21132187,21132369,21132492,21132544,2113255', 'assoc_port': '20947779:20947838,20948122:20948136,20948193:20948242,20948529:20948949,20964506:20964688,20965613:20966212,20965638:20965884,20965639:20965848,20966600:20966612,20967444:20967683,20967445:20967520,20969599:20969959,20969612:20970274,20969625:20972761,20969626:20969820,20970847:20971046,20970848:20975030,20971881:20972231,20973395:20973818,20973396:20973641,20973397:20973580,20975993:20976032,20975994:20976096,20975995:20976152,20977624:20977712,20977625:20977801,20978677:20978757,20979775:20979994,20979776:20979835,20980885:20980938,20981923:20981977,20981924:20982017,20983199:20983229,20984408:20984441,20984409:20984553,20984410:20984972,20985747:20985793,20985748:20985779,20987078:20987144,20987079:20987194,20988801:20989005,20988802:20989144,20989141:20989211,20990451:20990549,20990452:20990616,20991724:20991941,21001567:21003063,21004986:21005069,21006205:21007953,21011294:21011391,21012537:21015607,21014325:21014414,21015498:21015534,21022455:21022563,21030999:21034775,21031002:21031058,21031494:2103155', 'assoc_mat': '20947779:Carton_brun:3726:20947838,20948122:Carton_brun:3726:20948136,20948193:Carton_brun:3726:20948242,20948529:Carton_brun:3726:20948949,20964506:Carton_brun:3726:20964688,20965613:Carton_brun:3726:20966212,20965638:Carton_brun:3726:20965884,20965639:Carton_brun:3726:20965848,20966600:Carton_brun:3726:20966612,20967444:Carton_brun:3726:20967683,20967445:Carton_brun:3726:20967520,20969599:Carton_brun:3726:20969959,20969612:Carton_brun:3726:20970274,20969625:Carton_brun:3726:20972761,20969626:Carton_brun:3726:20969820,20970847:Carton_brun:3726:20971046,20970848:Carton_brun:3726:20975030,20971881:Carton_brun:3726:20972231,20973395:Carton_brun:3726:20973818,20973396:Carton_brun:3726:20973641,20973397:Carton_brun:3726:20973580,20975993:Carton_brun:3726:20976032,20975994:Carton_brun:3726:20976096,20975995:Carton_brun:3726:20976152,20977624:Carton_brun:3726:20977712,20977625:Carton_brun:3726:20977801,20978677:Carton_brun:3726:20978757,20979775:Carton_brun:3726:20979994,20979776:Carton_brun:3726:20979835,20980885:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.00814502276150966, 'nb_photo': 811, 'list_port_cont': '20947831,20947854,20947973,20947990,20948125,20948237,20948371,20948597,20948666,20948735,20948940,20964680,20965842,20965873,20969824,20970276,20971047,20972223,20972758,20973583,20973648,20973816,20975027,20976023,20976095,20976159,20976845,20977791,20978753,20979997,20982224,20984557,20985776,20985792,20988826,20989009,20989155,20991938,20992200,21001636,21002915,21003054,21005066,21007949,21008139,21010011,21010126,21011498,21012625,21013026,21014407,21015535,21015606,21016875,21017115,21018002,21019499,21022462,21022559,21022626,21023451,21024682,21025457,21031057,21031265,21031555,21031894,21032260,21033795,21034239,21034774,21051673,21051735,21051940,21052883,21053083,21053214,21059092,21061074,21061367,21061823,21063760,21063977,21064376,21065502,21067521,21068038,21068396,21070775,21071242,21071563,21073105,21073155,21074941,21078383,21078687,21079809,21080140,21082879,21083013,21083285,21086054,21086138,21088478,21089392,21105668,21105817,21106871,21107044,21109151,21109381,21110239,21110372,2111320', 'assoc_port': '20947776:20947973,20947777:20947854,20947779:20947831,20947931:20947990,20948122:20948125,20948193:20948237,20948291:20948371,20948529:20948940,20948594:20948597,20948661:20948666,20948730:20948735,20964506:20964680,20965638:20965873,20965639:20965842,20969612:20970276,20969625:20972758,20969626:20969824,20970847:20971047,20970848:20975027,20971881:20972223,20973395:20973816,20973396:20973648,20973397:20973583,20975993:20976023,20975994:20976095,20975995:20976159,20976769:20976845,20977625:20977791,20978677:20978753,20979775:20979997,20979777:20982224,20984409:20984557,20985747:20985792,20985748:20985776,20988801:20989009,20988802:20989155,20988803:20988826,20991724:20991938,20992187:20992200,21001567:21003054,21001569:21001636,21002843:21002915,21004986:21005066,21006205:21007949,21008056:21008139,21009932:21010126,21009933:21010011,21011295:21011498,21012536:21012625,21012537:21015606,21012918:21013026,21014325:21014407,21015498:21015535,21016805:21017115,21016807:21016875,21017918:21018002,21019276:2101949', 'assoc_mat': '20947776:Carton_gris:3726:20947973,20947777:Carton_gris:3726:20947854,20947779:Carton_gris:3726:20947831,20947931:Carton_gris:3726:20947990,20948122:Carton_gris:3726:20948125,20948193:Carton_gris:3726:20948237,20948291:Carton_gris:3726:20948371,20948529:Carton_gris:3726:20948940,20948594:Carton_gris:3726:20948597,20948661:Carton_gris:3726:20948666,20948730:Carton_gris:3726:20948735,20964506:Carton_gris:3726:20964680,20965638:Carton_gris:3726:20965873,20965639:Carton_gris:3726:20965842,20969612:Carton_gris:3726:20970276,20969625:Carton_gris:3726:20972758,20969626:Carton_gris:3726:20969824,20970847:Carton_gris:3726:20971047,20970848:Carton_gris:3726:20975027,20971881:Carton_gris:3726:20972223,20973395:Carton_gris:3726:20973816,20973396:Carton_gris:3726:20973648,20973397:Carton_gris:3726:20973583,20975993:Carton_gris:3726:20976023,20975994:Carton_gris:3726:20976095,20975995:Carton_gris:3726:20976159,20976769:Carton_gris:3726:20976845,20977625:Carton_gris:3726:20977791,20978677:Carton_gris:3726:20978753,20979775:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0027443509346329934, 'nb_photo': 174, 'list_port_cont': '20964687,20965878,20966207,20966605,20969967,20970283,20972226,20972754,20973581,20973649,20975026,20976027,20976149,20977795,20978761,20979996,20984445,20984967,20985783,20985787,20989000,20989212,21015541,21058973,21061821,21063979,21067522,21075096,21079541,21083014,21114075,21124590,21126354,21132458,21239231,21264590,21269242,21274298,21288570,21291906,21293841,21299109,21306940,21307046,21311294,21315277,21319401,21334604,21348121,21379831,21380122,21392872,21412424,21413816,21416532,21418319,21419625,21420852,21422184,21422956,21424401,21425325,21427281,21431773,21432829,21433829,21436793,21437624,21439212,21440084,21446594,21446634,21450868,21458550,21481418,21482867,21483415,21483514,21484234,21485417,21486862,21571189,21575739,21576821,21581859,21585461,21586361,21589058,21591184,21594988,21598018,21606523,21607188,21608568,21608808,21609258,21609274,21609661,21610352,21610709,21611733,21612038,21612202,21612256,21612439,21616354,21616420,21616534,21616544,21616569,21616584,21617007,21617021,2161703', 'assoc_port': '20964506:20964687,20965613:20966207,20965638:20965878,20966600:20966605,20969599:20969967,20969612:20970283,20969625:20972754,20970848:20975026,20971881:20972226,20973396:20973649,20973397:20973581,20975993:20976027,20975995:20976149,20977625:20977795,20978677:20978761,20979775:20979996,20984408:20984445,20984410:20984967,20985747:20985787,20985748:20985783,20988801:20989000,20989141:20989212,21015498:21015541,21051476:21061821,21058641:21058973,21063621:21063979,21067483:21067522,21072876:21075096,21079468:21079541,21082619:21083014,21113068:21114075,21121422:21132458,21124392:21124590,21126117:21126354,21239178:21239231,21264436:21264590,21268999:21269242,21274019:21274298,21288195:21288570,21291474:21291906,21293589:21293841,21298642:21299109,21301462:21307046,21306619:21306940,21311144:21311294,21314216:21315277,21319247:21319401,21334352:21334604,21348109:21348121,21378252:21380122,21378253:21379831,21392696:21392872,21412123:21412424,21413609:21413816,21416422:21416532,21418091:21418319,21419491:2141962', 'assoc_mat': '20964506:kraft:3726:20964687,20965613:kraft:3726:20966207,20965638:kraft:3726:20965878,20966600:kraft:3726:20966605,20969599:kraft:3726:20969967,20969612:kraft:3726:20970283,20969625:kraft:3726:20972754,20970848:kraft:3726:20975026,20971881:kraft:3726:20972226,20973396:kraft:3726:20973649,20973397:kraft:3726:20973581,20975993:kraft:3726:20976027,20975995:kraft:3726:20976149,20977625:kraft:3726:20977795,20978677:kraft:3726:20978761,20979775:kraft:3726:20979996,20984408:kraft:3726:20984445,20984410:kraft:3726:20984967,20985747:kraft:3726:20985787,20985748:kraft:3726:20985783,20988801:kraft:3726:20989000,20989141:kraft:3726:20989212,21015498:kraft:3726:21015541,21051476:kraft:3726:21061821,21058641:kraft:3726:21058973,21063621:kraft:3726:21063979,21067483:kraft:3726:21067522,21072876:kraft:3726:21075096,21079468:kraft:3726:21079541,21082619:kraft:3726:21083014,21113068:kraft:3726:21114075,21121422:kraft:3726:21132458,21124392:kraft:3726:21124590,21126117:kraft:3726:21126354,21239178:kraft:3726:21239231,21264436:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0031567153719896765, 'nb_photo': 60, 'list_port_cont': '20966204,20972221,20973582,20976033,20976090,20979993,20985777,21051941,21052881,21053208,21061982,21068393,21133668,21246770,21263771,21274256,21274329,21282222,21292853,21294712,21308271,21311293,21351286,21378482,21380089,21386966,21400834,21411400,21413817,21416529,21421045,21424863,21427284,21428727,21433826,21440078,21443026,21446591,21450867,21571622,21581124,21608616,21609175,21610702,21616530,21616585,21616596,21617014,21617042', 'assoc_port': '20965613:20966204,20971881:20972221,20973397:20973582,20975993:20976033,20975994:20976090,20979775:20979993,20985748:20985777,21051475:21051941,21052624:21052881,21053151:21053208,21061924:21061982,21067482:21068393,21121415:21133668,21245265:21246770,21263611:21263771,21274019:21274329,21274022:21274256,21281705:21282222,21292572:21292853,21294295:21294712,21308149:21308271,21311144:21311293,21350864:21351286,21378251:21380089,21378269:21386966,21378271:21378482,21400732:21400834,21411358:21411400,21413609:21413817,21416422:21416529,21420617:21421045,21424769:21424863,21427187:21427284,21428303:21428727,21433631:21433826,21440013:21440078,21442784:21443026,21446414:21446591,21450228:21450867,21571076:21571622,21572296:21617042,21572297:21617014,21572300:21616585,21572301:21616596,21572305:21616530,21580529:21581124,21606625:21610702,21606659:21609175,21606663:21608616', 'assoc_mat': '20965613:metal:3726:20966204,20971881:metal:3726:20972221,20973397:metal:3726:20973582,20975993:metal:3726:20976033,20975994:metal:3726:20976090,20979775:metal:3726:20979993,20985748:metal:3726:20985777,21051475:metal:3726:21051941,21052624:metal:3726:21052881,21053151:metal:3726:21053208,21061924:metal:3726:21061982,21067482:metal:3726:21068393,21121415:metal:3726:21133668,21245265:metal:3726:21246770,21263611:metal:3726:21263771,21274019:metal:3726:21274329,21274022:metal:3726:21274256,21281705:metal:3726:21282222,21292572:metal:3726:21292853,21294295:metal:3726:21294712,21308149:metal:3726:21308271,21311144:metal:3726:21311293,21350864:metal:3726:21351286,21378251:metal:3726:21380089,21378269:metal:3726:21386966,21378271:metal:3726:21378482,21400732:metal:3726:21400834,21411358:metal:3726:21411400,21413609:metal:3726:21413817,21416422:metal:3726:21416529,21420617:metal:3726:21421045,21424769:metal:3726:21424863,21427187:metal:3726:21427284,21428303:metal:3726:21428727,21433631:metal:3726:21433826,21440013:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.006823912957240115, 'nb_photo': 1110, 'list_port_cont': '20947821,20947840,20947847,20947979,20947981,20948133,20948243,20948667,20948743,20948948,20964682,20965843,20965875,20966213,20966606,20967515,20967690,20969821,20969962,20970277,20971043,20972229,20972762,20973584,20973643,20973808,20975023,20976029,20976089,20976160,20976835,20976933,20977710,20977796,20978756,20980000,20982019,20982216,20983239,20984448,20984564,20984964,20985785,20985797,20987148,20988831,20989001,20989150,20991882,21001637,21002920,21002933,21003059,21005070,21005146,21005380,21007951,21008079,21008087,21008984,21010002,21011497,21012627,21013035,21014413,21015539,21016881,21017052,21017116,21018352,21019495,21022469,21023445,21024531,21024683,21025461,21026821,21028259,21031263,21031561,21031898,21032264,21034238,21034778,21051669,21051934,21052885,21053081,21053210,21058968,21061825,21061988,21062171,21062498,21063758,21065498,21067519,21068033,21070303,21070372,21070399,21070770,21071565,21073099,21073153,21074942,21078386,21078684,21079545,21079812,21080147,21082873,21083017,2108328', 'assoc_port': '20947776:20947979,20947777:20947847,20947778:20947821,20947779:20947840,20947931:20947981,20948122:20948133,20948193:20948243,20948529:20948948,20948661:20948667,20948730:20948743,20964506:20964682,20965613:20966213,20965638:20965875,20965639:20965843,20966600:20966606,20967444:20967690,20967445:20967515,20969599:20969962,20969612:20970277,20969625:20972762,20969626:20969821,20970847:20971043,20970848:20975023,20971881:20972229,20973395:20973808,20973396:20973643,20973397:20973584,20975993:20976029,20975994:20976089,20975995:20976160,20976769:20976835,20976770:20976933,20977624:20977710,20977625:20977796,20978677:20978756,20979775:20980000,20979777:20982216,20981924:20982019,20983199:20983239,20984408:20984448,20984409:20984564,20984410:20984964,20985747:20985797,20985748:20985785,20987078:20987148,20988801:20989001,20988802:20989150,20988803:20988831,20991723:20991882,21001567:21003059,21001568:21002933,21001569:21001637,21002842:21005380,21002843:21002920,21004986:21005070,21004987:21005146,21006205:2100795', 'assoc_mat': '20947776:plastique:3726:20947979,20947777:plastique:3726:20947847,20947778:plastique:3726:20947821,20947779:plastique:3726:20947840,20947931:plastique:3726:20947981,20948122:plastique:3726:20948133,20948193:plastique:3726:20948243,20948529:plastique:3726:20948948,20948661:plastique:3726:20948667,20948730:plastique:3726:20948743,20964506:plastique:3726:20964682,20965613:plastique:3726:20966213,20965638:plastique:3726:20965875,20965639:plastique:3726:20965843,20966600:plastique:3726:20966606,20967444:plastique:3726:20967690,20967445:plastique:3726:20967515,20969599:plastique:3726:20969962,20969612:plastique:3726:20970277,20969625:plastique:3726:20972762,20969626:plastique:3726:20969821,20970847:plastique:3726:20971043,20970848:plastique:3726:20975023,20971881:plastique:3726:20972229,20973395:plastique:3726:20973808,20973396:plastique:3726:20973643,20973397:plastique:3726:20973584,20975993:plastique:3726:20976029,20975994:plastique:3726:20976089,20975995:plastique:3726:20976160,20976769:plastique:3726:20976835,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008378102186072281, 'nb_photo': 1904, 'list_port_cont': '20947833,20947985,20948244,20948369,20948601,20948662,20948740,20948939,20964684,20965837,20965881,20966214,20966604,20967522,20969823,20970282,20971041,20972222,20972752,20973585,20973651,20973815,20975025,20976030,20976092,20976151,20976931,20977713,20977799,20978763,20979829,20980001,20980943,20982024,20982215,20983230,20984446,20984560,20984971,20985775,20985788,20987153,20987187,20988827,20989002,20989151,20990545,20990612,20991885,20991946,20992192,21001644,21002917,21002926,21005072,21007958,21008093,21008993,21011489,21013036,21014408,21015542,21015613,21016882,21017117,21018005,21018348,21019483,21019498,21022466,21022560,21022621,21022712,21023449,21024530,21024684,21025459,21026819,21028258,21031065,21031268,21031559,21031901,21032267,21033799,21034242,21034784,21051935,21052886,21053076,21053207,21058972,21059096,21061067,21061376,21061622,21061819,21061980,21062175,21062491,21062948,21063757,21064379,21064540,21065495,21067525,21068390,21070306,21070396,21070769,21071249,21071562,21073097,2107315', 'assoc_port': '20947779:20947833,20947931:20947985,20948193:20948244,20948291:20948369,20948529:20948939,20948594:20948601,20948661:20948662,20948730:20948740,20964506:20964684,20965613:20966214,20965638:20965881,20965639:20965837,20966600:20966604,20967445:20967522,20969612:20970282,20969625:20972752,20969626:20969823,20970847:20971041,20970848:20975025,20971881:20972222,20973395:20973815,20973396:20973651,20973397:20973585,20975993:20976030,20975994:20976092,20975995:20976151,20976770:20976931,20977624:20977713,20977625:20977799,20978677:20978763,20979775:20980001,20979776:20979829,20979777:20982215,20980885:20980943,20981924:20982024,20983199:20983230,20984408:20984446,20984409:20984560,20984410:20984971,20985747:20985788,20985748:20985775,20987078:20987153,20987079:20987187,20988801:20989002,20988802:20989151,20988803:20988827,20990451:20990545,20990452:20990612,20991723:20991885,20991724:20991946,20992187:20992192,21001568:21002926,21001569:21001644,21002843:21002917,21004986:21005072,21006205:21007958,21008057:2100809', 'assoc_mat': '20947779:Teint_Dans_La_Masse:3726:20947833,20947931:Teint_Dans_La_Masse:3726:20947985,20948193:Teint_Dans_La_Masse:3726:20948244,20948291:Teint_Dans_La_Masse:3726:20948369,20948529:Teint_Dans_La_Masse:3726:20948939,20948594:Teint_Dans_La_Masse:3726:20948601,20948661:Teint_Dans_La_Masse:3726:20948662,20948730:Teint_Dans_La_Masse:3726:20948740,20964506:Teint_Dans_La_Masse:3726:20964684,20965613:Teint_Dans_La_Masse:3726:20966214,20965638:Teint_Dans_La_Masse:3726:20965881,20965639:Teint_Dans_La_Masse:3726:20965837,20966600:Teint_Dans_La_Masse:3726:20966604,20967445:Teint_Dans_La_Masse:3726:20967522,20969612:Teint_Dans_La_Masse:3726:20970282,20969625:Teint_Dans_La_Masse:3726:20972752,20969626:Teint_Dans_La_Masse:3726:20969823,20970847:Teint_Dans_La_Masse:3726:20971041,20970848:Teint_Dans_La_Masse:3726:20975025,20971881:Teint_Dans_La_Masse:3726:20972222,20973395:Teint_Dans_La_Masse:3726:20973815,20973396:Teint_Dans_La_Masse:3726:20973651,20973397:Teint_Dans_La_Masse:3726:20973585,20975993:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 14769}}, 'hostname': (), 'impurety_average_per_hashtag': []} filepath : /data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense/sla_mensuel_arc_en_ciel_jrm_peu_dense_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 {'JRM': {'autre_refus': ['autre_refus', '0.78%', 675], 'cartonnette': ['cartonnette', '0.72%', 1408], 'Carton_brun': ['Carton_brun', '0.98%', 1260], 'Carton_gris': ['Carton_gris', '0.81%', 811], 'kraft': ['kraft', '0.27%', 174], 'metal': ['metal', '0.32%', 60], 'plastique': ['plastique', '0.68%', 1110], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '0.84%', 1904]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense/sla_mensuel_arc_en_ciel_jrm_peu_dense_mois_03_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense 2.72user 1.80system 0:11.23elapsed 40%CPU (0avgtext+0avgdata 194024maxresident)k 32816inputs+488outputs (57major+86791minor)pagefaults 0swaps