python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --job=sla_mensuel --raspi=20092 --dashboard_places=refus_amiens --rootfolder_sla=/data_4/data_log/job/memo/refus_amiens -v --mtr_id=983 --date=`date -d"$nowdate 15 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : 20092, Date : 2025-06 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 30) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3142 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3142 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3142 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3996 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3996 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3142 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3142 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3142 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3996 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3996 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 30) VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3142 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3142 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3142 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3996 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3996 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3142 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3142 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3142 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3996 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3996 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 15 month : 06 mtr_id : 983 dashboard_places : refus_amiens date : 2025-06 year : 2025 raspi : 20092 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'refus_amiens' and date like '%2025-06%') and created_at like '%2025-06%'))); nb_day : (6, 30) after unwanted_material_data nb_day : (6, 30) WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%20092%' AND ms.result_str like '%2025/06%'ORDER BY ms.id desc LIMIT 0, 1000000; Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-06-01 00:00:00,2025-06-02 00:00:00,2025-06-03 00:00:00,2025-06-04 00:00:00,2025-06-05 00:00:00,2025-06-06 00:00:00,2025-06-07 00:00:00,2025-06-08 00:00:00,2025-06-09 00:00:00,2025-06-10 00:00:00,2025-06-11 00:00:00,2025-06-12 00:00:00,2025-06-13 00:00:00,2025-06-14 00:00:00,2025-06-15 00:00:00,2025-06-16 00:00:00,2025-06-17 00:00:00,2025-06-18 00:00:00,2025-06-19 00:00:00,2025-06-20 00:00:00,2025-06-21 00:00:00,2025-06-22 00:00:00,2025-06-23 00:00:00,2025-06-24 00:00:00,2025-06-25 00:00:00,2025-06-26 00:00:00,2025-06-27 00:00:00,2025-06-28 00:00:00,2025-06-29 00:00:00,2025-06-30 00:00:00 after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 15 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______refus' and ded.dashboard_place_id = 15 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 15 and mp.name like '%062025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-06-01 : dt_date_just_month_year : 2025-06-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "refus_amiens" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-06-01" AND ded.date <= "2025-06-30" apple3 {'refus': {'mat': 'refus', 'pht': 4213, 'datou_carac_id': 3996, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus,textiles_sanitaires'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1864805,1867252,1870496,1873889,1877422,1882003,1885583,1888776,1893948,1897986,1904915,1906465,1908669,1912395,1911230,1914320,1917360,1920397,1922116,1925426,1930332,1926782,1930420,1929323,1932886,1938556,1938182,1940144,1940771,1951851) AND dr.mtr_portfolio_id=ptp.mtr_portfolio_id_1 AND dr.qualite >= 0 AND mpp.mtr_portfolio_id=ptp.mtr_portfolio_id_2 AND pcr.portfolio_id=ptp.mtr_portfolio_id_1 AND h.hashtag_id = pcr.hashtag_id AND ptp.type = pcr.hashtag_type AND mpp.hide_status = 0 AND ptp.hashtag_id=h.hashtag_id group by h.hashtag, dr.hashtag, ptp.type; VR TODO TO BETTER PARSE ! ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.006287462861399552, 'nb_photo': 865, 'list_port_cont': '23522898,23523766,23523842,23523866,23523916,23523935,23523977,23524049,23524127,23524266,23524497,23524533,23524581,23524638,23524684,23524715,23524739,23524773,23524821,23531122,23533661,23535537,23535652,23538074,23540886,23550817,23552679,23561730,23564997,23565401,23565554,23573823,23573972,23574481,23575126,23579820,23580946,23582111,23607763,23608259,23608296,23608527,23612656,23612731,23617431,23617608,23617802,23617926,23618105,23618311,23618575,23618745,23619624,23619837,23620223,23620522,23620769,23655120,23655314,23655642,23655766,23655966,23656113,23656274,23656714,23656791,23656913,23657112,23657251,23657476,23657679,23657894,23658081,23658195,23658529,23658834,23661409,23671791,23674909,23677643,23678608,23678683,23680306,23680528,23680614,23680725,23680847,23681055,23685127,23685540,23688346,23689481,23695649,23700786,23702122,23702471,23702598,23702786,23707905,23708288,23709139,23713049,23713233,23713441,23713847,23714126,23715799,23718232,23720699,23720920,23726291,23726798,23728024,2373547', 'assoc_port': '23522746:23524821,23522747:23524773,23522749:23524739,23522750:23524715,23522752:23524684,23522754:23524638,23522757:23524581,23522758:23524533,23522760:23524497,23522765:23524266,23522769:23524127,23522770:23524049,23522773:23523935,23522775:23523977,23522776:23523916,23522778:23523866,23522780:23523842,23522781:23523766,23522783:23522898,23528537:23582111,23528538:23564997,23528541:23565401,23528542:23535652,23531052:23531122,23533542:23533661,23535502:23535537,23537991:23538074,23540447:23540886,23544363:23574481,23549062:23575126,23550736:23550817,23552597:23552679,23557577:23579820,23558791:23580946,23561654:23561730,23565491:23565554,23572297:23573972,23572298:23573823,23607559:23617431,23607560:23617608,23607561:23617802,23607562:23617926,23607563:23618105,23607564:23618311,23607565:23618575,23607566:23618745,23607593:23619624,23607594:23619837,23607595:23620223,23607596:23620522,23607597:23620769,23607598:23612731,23607599:23612656,23607601:23608527,23607602:23608296,23607603:23608259,23607606:2360776', 'assoc_mat': '23522746:barquette_opaque:4213:23524821,23522747:barquette_opaque:4213:23524773,23522749:barquette_opaque:4213:23524739,23522750:barquette_opaque:4213:23524715,23522752:barquette_opaque:4213:23524684,23522754:barquette_opaque:4213:23524638,23522757:barquette_opaque:4213:23524581,23522758:barquette_opaque:4213:23524533,23522760:barquette_opaque:4213:23524497,23522765:barquette_opaque:4213:23524266,23522769:barquette_opaque:4213:23524127,23522770:barquette_opaque:4213:23524049,23522773:barquette_opaque:4213:23523935,23522775:barquette_opaque:4213:23523977,23522776:barquette_opaque:4213:23523916,23522778:barquette_opaque:4213:23523866,23522780:barquette_opaque:4213:23523842,23522781:barquette_opaque:4213:23523766,23522783:barquette_opaque:4213:23522898,23528537:barquette_opaque:4213:23582111,23528538:barquette_opaque:4213:23564997,23528541:barquette_opaque:4213:23565401,23528542:barquette_opaque:4213:23535652,23531052:barquette_opaque:4213:23531122,23533542:barquette_opaque:4213:23533661,23535502:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036535090883231427, 'nb_photo': 864, 'list_port_cont': '23522893,23523763,23523871,23523915,23523978,23524048,23524279,23524469,23524570,23524642,23524677,23524714,23524740,23524787,23524806,23533665,23535532,23538075,23550820,23552670,23564039,23565406,23565836,23573816,23573979,23575119,23579830,23580959,23607749,23608219,23608286,23608535,23612668,23612730,23617441,23617805,23617928,23618107,23618566,23618744,23619075,23619631,23619828,23620219,23620528,23654963,23655111,23655306,23655651,23655756,23656114,23656279,23656382,23656701,23656786,23657671,23657891,23658832,23661423,23671794,23674903,23677654,23678622,23680305,23680536,23680617,23680720,23681060,23685126,23695656,23700773,23702482,23702599,23702776,23706872,23707892,23713053,23713243,23713431,23713692,23714127,23715795,23720933,23722766,23728027,23735466,23737839,23741724,23742902,23743218,23743294,23744016,23744553,23746547,23747156,23747264,23747340,23747444,23747878,23748225,23749004,23749769,23751724,23751789,23757799,23758290,23758540,23759766,23759976,23760312,23760770,23760904,23760945,2376098', 'assoc_port': '23522746:23524806,23522747:23524787,23522749:23524740,23522750:23524714,23522752:23524677,23522754:23524642,23522757:23524570,23522761:23524469,23522765:23524279,23522770:23524048,23522775:23523978,23522776:23523915,23522778:23523871,23522781:23523763,23522783:23522893,23528533:23564039,23528541:23565406,23528545:23565836,23533542:23533665,23535502:23535532,23537991:23538075,23549062:23575119,23550736:23550820,23552597:23552670,23557577:23579830,23558791:23580959,23572297:23573979,23572298:23573816,23607559:23617441,23607561:23617805,23607562:23617928,23607563:23618107,23607565:23618566,23607566:23618744,23607579:23619075,23607593:23619631,23607594:23619828,23607595:23620219,23607596:23620528,23607598:23612730,23607599:23612668,23607601:23608535,23607602:23608286,23607604:23608219,23607606:23607749,23650226:23654963,23650227:23655111,23650228:23655306,23650229:23678622,23650231:23655651,23650232:23655756,23650235:23656114,23650236:23656279,23650237:23656382,23650239:23656701,23650240:23656786,23650247:2365767', 'assoc_mat': '23522746:carton:4213:23524806,23522747:carton:4213:23524787,23522749:carton:4213:23524740,23522750:carton:4213:23524714,23522752:carton:4213:23524677,23522754:carton:4213:23524642,23522757:carton:4213:23524570,23522761:carton:4213:23524469,23522765:carton:4213:23524279,23522770:carton:4213:23524048,23522775:carton:4213:23523978,23522776:carton:4213:23523915,23522778:carton:4213:23523871,23522781:carton:4213:23523763,23522783:carton:4213:23522893,23528533:carton:4213:23564039,23528541:carton:4213:23565406,23528545:carton:4213:23565836,23533542:carton:4213:23533665,23535502:carton:4213:23535532,23537991:carton:4213:23538075,23549062:carton:4213:23575119,23550736:carton:4213:23550820,23552597:carton:4213:23552670,23557577:carton:4213:23579830,23558791:carton:4213:23580959,23572297:carton:4213:23573979,23572298:carton:4213:23573816,23607559:carton:4213:23617441,23607561:carton:4213:23617805,23607562:carton:4213:23617928,23607563:carton:4213:23618107,23607565:carton:4213:23618566,23607566:carton:4213:23618744,2360'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.007236471083612558, 'nb_photo': 348, 'list_port_cont': '23523976,23524577,23524686,23524746,23524776,23524810,23531132,23533660,23538073,23561733,23564031,23565403,23565843,23571747,23573827,23575118,23582106,23607755,23608284,23612661,23612733,23617440,23617597,23617929,23619085,23620228,23620520,23654961,23655123,23655302,23655646,23656129,23656284,23656707,23656793,23657256,23657477,23657885,23658524,23658835,23671795,23674913,23678615,23680312,23685133,23685534,23689490,23695637,23700783,23702601,23706886,23708275,23713037,23713241,23713442,23714135,23720927,23726811,23728028,23740315,23741735,23742908,23743227,23743288,23744005,23747153,23747886,23747954,23749778,23751722,23751786,23757795,23759419,23759897,23759968,23760506,23760757,23760910,23760952,23761096,23763688,23763742,23763855,23763947,23765236,23778119,23783169,23785094,23792686,23799215,23803012,23803407,23803439,23804975,23806155,23806323,23806489,23809210,23812216,23817450,23821674,23849743,23849904,23898844,23910463,23910525,23911864,23919764,23922728,23924444,23924521,23924532,23931691,2399566', 'assoc_port': '23522746:23524810,23522747:23524776,23522749:23524746,23522752:23524686,23522757:23524577,23522775:23523976,23528533:23564031,23528537:23582106,23528541:23565403,23528545:23565843,23531052:23531132,23533542:23533660,23537991:23538073,23549062:23575118,23561654:23561733,23569326:23571747,23572298:23573827,23607559:23617440,23607560:23617597,23607562:23617929,23607579:23619085,23607595:23620228,23607596:23620520,23607598:23612733,23607599:23612661,23607602:23608284,23607606:23607755,23650226:23654961,23650227:23655123,23650228:23655302,23650229:23678615,23650231:23655646,23650235:23656129,23650236:23656284,23650239:23656707,23650240:23656793,23650244:23657256,23650245:23657477,23650249:23657885,23650253:23658524,23650255:23658835,23663342:23680312,23666428:23695637,23671701:23671795,23674765:23674913,23681658:23702601,23681659:23726811,23683965:23685534,23685096:23685133,23689436:23689490,23696926:23713037,23696929:23713241,23696932:23700783,23696949:23713442,23696967:23714135,23702424:23720927,23706699:2370688', 'assoc_mat': '23522746:ela:4213:23524810,23522747:ela:4213:23524776,23522749:ela:4213:23524746,23522752:ela:4213:23524686,23522757:ela:4213:23524577,23522775:ela:4213:23523976,23528533:ela:4213:23564031,23528537:ela:4213:23582106,23528541:ela:4213:23565403,23528545:ela:4213:23565843,23531052:ela:4213:23531132,23533542:ela:4213:23533660,23537991:ela:4213:23538073,23549062:ela:4213:23575118,23561654:ela:4213:23561733,23569326:ela:4213:23571747,23572298:ela:4213:23573827,23607559:ela:4213:23617440,23607560:ela:4213:23617597,23607562:ela:4213:23617929,23607579:ela:4213:23619085,23607595:ela:4213:23620228,23607596:ela:4213:23620520,23607598:ela:4213:23612733,23607599:ela:4213:23612661,23607602:ela:4213:23608284,23607606:ela:4213:23607755,23650226:ela:4213:23654961,23650227:ela:4213:23655123,23650228:ela:4213:23655302,23650229:ela:4213:23678615,23650231:ela:4213:23655646,23650235:ela:4213:23656129,23650236:ela:4213:23656284,23650239:ela:4213:23656707,23650240:ela:4213:23656793,23650244:ela:4213:23657256,23650245:ela:4213:2365747'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0037714688878688835, 'nb_photo': 946, 'list_port_cont': '23522887,23523774,23523837,23523879,23523907,23523937,23523984,23524262,23524433,23524471,23524507,23524549,23524710,23524741,23524778,23524809,23531131,23533657,23535541,23535660,23538072,23540883,23542768,23550826,23552672,23564044,23565399,23565851,23571755,23573811,23574485,23575115,23579824,23580961,23582101,23607764,23607805,23608222,23608250,23608297,23608520,23612669,23617442,23617595,23617803,23617937,23618096,23618312,23618564,23618754,23619091,23619633,23620229,23620531,23620760,23654958,23655124,23655303,23655657,23655978,23656117,23656276,23656389,23656710,23656795,23657121,23657244,23657480,23657664,23657879,23658087,23658208,23658520,23658833,23661416,23671786,23674905,23677641,23678609,23678695,23680315,23680527,23680624,23680721,23681067,23685129,23685544,23688341,23689488,23695653,23700774,23702120,23702480,23702588,23702780,23706877,23707899,23713038,23713242,23714125,23715808,23718228,23720694,23720932,23726301,23726807,23728037,23735469,23737829,23741083,23742913,23743108,23743222,2374329', 'assoc_port': '23522746:23524809,23522747:23524778,23522749:23524741,23522750:23524710,23522758:23524549,23522760:23524507,23522761:23524471,23522763:23524433,23522765:23524262,23522773:23523937,23522775:23523984,23522776:23523907,23522778:23523879,23522780:23523837,23522781:23523774,23522783:23522887,23528533:23564044,23528537:23582101,23528541:23565399,23528542:23535660,23528545:23565851,23531052:23531131,23533542:23533657,23535502:23535541,23537991:23538072,23540447:23540883,23542731:23542768,23544363:23574485,23549062:23575115,23550736:23550826,23552597:23552672,23557577:23579824,23558791:23580961,23569326:23571755,23572298:23573811,23607559:23617442,23607560:23617595,23607561:23617803,23607562:23617937,23607563:23618096,23607564:23618312,23607565:23618564,23607566:23618754,23607579:23619091,23607593:23619633,23607595:23620229,23607596:23620531,23607597:23620760,23607599:23612669,23607601:23608520,23607602:23608297,23607603:23608250,23607604:23608222,23607605:23607805,23607606:23607764,23650226:23654958,23650227:2365512', 'assoc_mat': '23522746:etiquette:4213:23524809,23522747:etiquette:4213:23524778,23522749:etiquette:4213:23524741,23522750:etiquette:4213:23524710,23522758:etiquette:4213:23524549,23522760:etiquette:4213:23524507,23522761:etiquette:4213:23524471,23522763:etiquette:4213:23524433,23522765:etiquette:4213:23524262,23522773:etiquette:4213:23523937,23522775:etiquette:4213:23523984,23522776:etiquette:4213:23523907,23522778:etiquette:4213:23523879,23522780:etiquette:4213:23523837,23522781:etiquette:4213:23523774,23522783:etiquette:4213:23522887,23528533:etiquette:4213:23564044,23528537:etiquette:4213:23582101,23528541:etiquette:4213:23565399,23528542:etiquette:4213:23535660,23528545:etiquette:4213:23565851,23531052:etiquette:4213:23531131,23533542:etiquette:4213:23533657,23535502:etiquette:4213:23535541,23537991:etiquette:4213:23538072,23540447:etiquette:4213:23540883,23542731:etiquette:4213:23542768,23544363:etiquette:4213:23574485,23549062:etiquette:4213:23575115,23550736:etiquette:4213:23550826,23552597:etiquette:4213:23552672,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.04624958927337406, 'nb_photo': 2554, 'list_port_cont': '23522903,23523762,23523833,23523904,23523921,23523973,23524012,23524053,23524125,23524276,23524435,23524468,23524499,23524536,23524579,23524676,23524713,23524750,23524785,23524817,23531123,23533666,23535533,23535661,23538085,23540881,23550828,23552668,23561734,23564029,23564994,23565394,23565845,23573812,23573974,23574493,23575129,23579827,23580950,23582102,23607753,23607798,23608216,23608244,23608289,23608528,23612658,23612727,23617435,23617793,23617933,23618095,23618319,23618562,23618747,23619089,23619251,23619619,23619839,23620233,23620529,23620761,23654956,23655114,23655312,23655650,23655768,23655975,23656273,23656375,23656716,23656799,23656923,23657117,23657249,23657676,23658080,23658197,23658527,23658847,23661414,23671792,23674915,23677650,23678620,23678686,23680307,23680537,23680611,23680712,23680845,23681061,23685130,23685541,23688343,23689483,23695641,23700784,23702113,23702474,23702590,23702781,23706888,23707893,23708278,23709150,23713039,23713246,23713445,23713843,23714133,23715800,23718230,2372069', 'assoc_port': '23522746:23524817,23522747:23524785,23522749:23524750,23522750:23524713,23522752:23524676,23522757:23524579,23522758:23524536,23522760:23524499,23522761:23524468,23522763:23524435,23522765:23524276,23522769:23524125,23522770:23524053,23522772:23524012,23522773:23523921,23522775:23523973,23522776:23523904,23522780:23523833,23522781:23523762,23522783:23522903,23528533:23564029,23528537:23582102,23528538:23564994,23528541:23565394,23528542:23535661,23528545:23565845,23531052:23531123,23533542:23533666,23535502:23535533,23537991:23538085,23540447:23540881,23544363:23574493,23549062:23575129,23550736:23550828,23552597:23552668,23557577:23579827,23558791:23580950,23561654:23561734,23572297:23573974,23572298:23573812,23607559:23617435,23607561:23617793,23607562:23617933,23607563:23618095,23607564:23618319,23607565:23618562,23607566:23618747,23607579:23619089,23607580:23619251,23607593:23619619,23607594:23619839,23607595:23620233,23607596:23620529,23607597:23620761,23607598:23612727,23607599:23612658,23607601:2360852', 'assoc_mat': '23522746:film_plastique:4213:23524817,23522747:film_plastique:4213:23524785,23522749:film_plastique:4213:23524750,23522750:film_plastique:4213:23524713,23522752:film_plastique:4213:23524676,23522757:film_plastique:4213:23524579,23522758:film_plastique:4213:23524536,23522760:film_plastique:4213:23524499,23522761:film_plastique:4213:23524468,23522763:film_plastique:4213:23524435,23522765:film_plastique:4213:23524276,23522769:film_plastique:4213:23524125,23522770:film_plastique:4213:23524053,23522772:film_plastique:4213:23524012,23522773:film_plastique:4213:23523921,23522775:film_plastique:4213:23523973,23522776:film_plastique:4213:23523904,23522780:film_plastique:4213:23523833,23522781:film_plastique:4213:23523762,23522783:film_plastique:4213:23522903,23528533:film_plastique:4213:23564029,23528537:film_plastique:4213:23582102,23528538:film_plastique:4213:23564994,23528541:film_plastique:4213:23565394,23528542:film_plastique:4213:23535661,23528545:film_plastique:4213:23565845,23531052:film_plastique:4213:2353112'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0017249569756832373, 'nb_photo': 12, 'list_port_cont': '23550831,23607750,23618571,23702602,23747195,23764088,24094040,24164590,24251633,24327548,24385597,24385949', 'assoc_port': '23550736:23550831,23607565:23618571,23607606:23607750,23681658:23702602,23739325:23747195,23762892:23764088,23972610:24094040,24046082:24164590,24239569:24251633,24319320:24327548,24385134:24385597,24385925:24385949', 'assoc_mat': '23550736:kraft:4213:23550831,23607565:kraft:4213:23618571,23607606:kraft:4213:23607750,23681658:kraft:4213:23702602,23739325:kraft:4213:23747195,23762892:kraft:4213:23764088,23972610:kraft:4213:24094040,24046082:kraft:4213:24164590,24239569:kraft:4213:24251633,24319320:kraft:4213:24327548,24385134:kraft:4213:24385597,24385925:kraft:4213:24385949'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004199811899604449, 'nb_photo': 1419, 'list_port_cont': '23522891,23523776,23523843,23523882,23523909,23523919,23523986,23524013,23524044,23524115,23524171,23524272,23524428,23524475,23524539,23524571,23524643,23524705,23524747,23524783,23524815,23531117,23533672,23535544,23535662,23538070,23540880,23542776,23550825,23561739,23564038,23564252,23564998,23565840,23573814,23573975,23574495,23575124,23580948,23582096,23607751,23607795,23608218,23608290,23608522,23612607,23612671,23612729,23617437,23617801,23617927,23618100,23618565,23618748,23619080,23619259,23619632,23619829,23620232,23620527,23620762,23654957,23655125,23655317,23655655,23655971,23656282,23656708,23656792,23657109,23657245,23657675,23658085,23658515,23658843,23661422,23674908,23678621,23678681,23680313,23680535,23680612,23680719,23681058,23685124,23685530,23688330,23695651,23700779,23702118,23702485,23702600,23702789,23706875,23707896,23708279,23713048,23713244,23713432,23713851,23714121,23715801,23720921,23722767,23726799,23728030,23735468,23737826,23740310,23741081,23741727,23742383,23742900,2374311', 'assoc_port': '23522746:23524815,23522747:23524783,23522749:23524747,23522750:23524705,23522754:23524643,23522757:23524571,23522758:23524539,23522761:23524475,23522763:23524428,23522765:23524272,23522767:23524171,23522769:23524115,23522770:23524044,23522772:23524013,23522773:23523919,23522775:23523986,23522776:23523909,23522778:23523882,23522780:23523843,23522781:23523776,23522783:23522891,23528533:23564038,23528535:23564252,23528537:23582096,23528538:23564998,23528542:23535662,23528545:23565840,23531052:23531117,23533542:23533672,23535502:23535544,23537991:23538070,23540447:23540880,23542731:23542776,23544363:23574495,23549062:23575124,23550736:23550825,23558791:23580948,23561654:23561739,23572297:23573975,23572298:23573814,23607559:23617437,23607561:23617801,23607562:23617927,23607563:23618100,23607565:23618565,23607566:23618748,23607579:23619080,23607580:23619259,23607593:23619632,23607594:23619829,23607595:23620232,23607596:23620527,23607597:23620762,23607598:23612729,23607599:23612671,23607600:23612607,23607601:2360852', 'assoc_mat': '23522746:metal:4213:23524815,23522747:metal:4213:23524783,23522749:metal:4213:23524747,23522750:metal:4213:23524705,23522754:metal:4213:23524643,23522757:metal:4213:23524571,23522758:metal:4213:23524539,23522761:metal:4213:23524475,23522763:metal:4213:23524428,23522765:metal:4213:23524272,23522767:metal:4213:23524171,23522769:metal:4213:23524115,23522770:metal:4213:23524044,23522772:metal:4213:23524013,23522773:metal:4213:23523919,23522775:metal:4213:23523986,23522776:metal:4213:23523909,23522778:metal:4213:23523882,23522780:metal:4213:23523843,23522781:metal:4213:23523776,23522783:metal:4213:23522891,23528533:metal:4213:23564038,23528535:metal:4213:23564252,23528537:metal:4213:23582096,23528538:metal:4213:23564998,23528542:metal:4213:23535662,23528545:metal:4213:23565840,23531052:metal:4213:23531117,23533542:metal:4213:23533672,23535502:metal:4213:23535544,23537991:metal:4213:23538070,23540447:metal:4213:23540880,23542731:metal:4213:23542776,23544363:metal:4213:23574495,23549062:metal:4213:23575124,23550736:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.054599943863049914, 'nb_photo': 4690, 'list_port_cont': '23522899,23523775,23523834,23523872,23523917,23523931,23523974,23524015,23524046,23524128,23524177,23524274,23524438,23524502,23524540,23524578,23524612,23524647,23524674,23524711,23524748,23524782,23524816,23531119,23533667,23535542,23535654,23538084,23540882,23550829,23552665,23561732,23564040,23564991,23565564,23565852,23571749,23573826,23573973,23574497,23575131,23580960,23582110,23607761,23607804,23608207,23608532,23612663,23612724,23617436,23617795,23617936,23618097,23618304,23618561,23618757,23619079,23619245,23619622,23619841,23620222,23620525,23620773,23654949,23655113,23655304,23655643,23655968,23656128,23656269,23656704,23656798,23656920,23657111,23657260,23657472,23657672,23657895,23658082,23658205,23658530,23658841,23661408,23671783,23674912,23677638,23678610,23678685,23680316,23680533,23680618,23680710,23680846,23681059,23685128,23685542,23688338,23689478,23695650,23700781,23702475,23702594,23702774,23706878,23707897,23708283,23709137,23713040,23713234,23713444,23713700,23714122,23715797,2371823', 'assoc_port': '23522746:23524816,23522747:23524782,23522749:23524748,23522750:23524711,23522752:23524674,23522754:23524647,23522755:23524612,23522757:23524578,23522758:23524540,23522760:23524502,23522763:23524438,23522765:23524274,23522767:23524177,23522769:23524128,23522770:23524046,23522772:23524015,23522773:23523931,23522775:23523974,23522776:23523917,23522778:23523872,23522780:23523834,23522781:23523775,23522783:23522899,23528533:23564040,23528537:23582110,23528538:23564991,23528542:23535654,23528545:23565852,23531052:23531119,23533542:23533667,23535502:23535542,23537991:23538084,23540447:23540882,23544363:23574497,23549062:23575131,23550736:23550829,23552597:23552665,23558791:23580960,23561654:23561732,23565491:23565564,23569326:23571749,23572297:23573973,23572298:23573826,23607559:23617436,23607561:23617795,23607562:23617936,23607563:23618097,23607564:23618304,23607565:23618561,23607566:23618757,23607579:23619079,23607580:23619245,23607593:23619622,23607594:23619841,23607595:23620222,23607596:23620525,23607597:2362077', 'assoc_mat': '23522746:papier:4213:23524816,23522747:papier:4213:23524782,23522749:papier:4213:23524748,23522750:papier:4213:23524711,23522752:papier:4213:23524674,23522754:papier:4213:23524647,23522755:papier:4213:23524612,23522757:papier:4213:23524578,23522758:papier:4213:23524540,23522760:papier:4213:23524502,23522763:papier:4213:23524438,23522765:papier:4213:23524274,23522767:papier:4213:23524177,23522769:papier:4213:23524128,23522770:papier:4213:23524046,23522772:papier:4213:23524015,23522773:papier:4213:23523931,23522775:papier:4213:23523974,23522776:papier:4213:23523917,23522778:papier:4213:23523872,23522780:papier:4213:23523834,23522781:papier:4213:23523775,23522783:papier:4213:23522899,23528533:papier:4213:23564040,23528537:papier:4213:23582110,23528538:papier:4213:23564991,23528542:papier:4213:23535654,23528545:papier:4213:23565852,23531052:papier:4213:23531119,23533542:papier:4213:23533667,23535502:papier:4213:23535542,23537991:papier:4213:23538084,23540447:papier:4213:23540882,23544363:papier:4213:23574497,2354'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.006683358409303269, 'nb_photo': 77, 'list_port_cont': '23535534,23550832,23552681,23565004,23580952,23656387,23657250,23657469,23658522,23658836,23680848,23689492,23706879,23713245,23713694,23726303,23726812,23741728,23743113,23743217,23747410,23757789,23761010,23761178,23763677,23796604,23850006,23898835,23911871,23919763,23931676,24018488,24089915,24092243,24094052,24115652,24116255,24132546,24134295,24135971,24161402,24161919,24162051,24162982,24164888,24164944,24165778,24167756,24167874,24170291,24171101,24173803,24176304,24178851,24261998,24262773,24263642,24264641,24279935,24284626,24284800,24308270,24325424,24328361,24328541,24342479,24361977,24390726,24409243', 'assoc_port': '23528538:23565004,23535502:23535534,23550736:23550832,23552597:23552681,23558791:23580952,23650237:23656387,23650244:23657250,23650245:23657469,23650253:23658522,23650255:23658836,23663350:23680848,23681640:23726303,23681659:23726812,23689436:23689492,23696929:23713245,23696962:23713694,23706699:23706879,23731743:23743217,23739331:23747410,23741717:23741728,23743106:23743113,23757453:23757789,23757463:23761178,23757480:23761010,23762885:23763677,23784541:23796604,23845232:23850006,23896955:23911871,23898784:23898835,23905499:23919763,23931619:23931676,23935735:24134295,23935757:24135971,23961893:24089915,23966881:24092243,23972610:24094052,23979656:24115652,23983414:24116255,23998044:24132546,24017357:24018488,24045430:24161402,24045431:24170291,24045434:24161919,24045437:24162051,24046045:24162982,24046085:24164944,24084320:24167874,24084324:24167756,24124700:24165778,24147434:24176304,24147436:24164888,24170336:24171101,24173747:24173803,24178811:24178851,24214840:24261998,24222024:24263642,24230040:2426464', 'assoc_mat': '23528538:pehd:4213:23565004,23535502:pehd:4213:23535534,23550736:pehd:4213:23550832,23552597:pehd:4213:23552681,23558791:pehd:4213:23580952,23650237:pehd:4213:23656387,23650244:pehd:4213:23657250,23650245:pehd:4213:23657469,23650253:pehd:4213:23658522,23650255:pehd:4213:23658836,23663350:pehd:4213:23680848,23681640:pehd:4213:23726303,23681659:pehd:4213:23726812,23689436:pehd:4213:23689492,23696929:pehd:4213:23713245,23696962:pehd:4213:23713694,23706699:pehd:4213:23706879,23731743:pehd:4213:23743217,23739331:pehd:4213:23747410,23741717:pehd:4213:23741728,23743106:pehd:4213:23743113,23757453:pehd:4213:23757789,23757463:pehd:4213:23761178,23757480:pehd:4213:23761010,23762885:pehd:4213:23763677,23784541:pehd:4213:23796604,23845232:pehd:4213:23850006,23896955:pehd:4213:23911871,23898784:pehd:4213:23898835,23905499:pehd:4213:23919763,23931619:pehd:4213:23931676,23935735:pehd:4213:24134295,23935757:pehd:4213:24135971,23961893:pehd:4213:24089915,23966881:pehd:4213:24092243,23972610:pehd:4213:24094052,23979656:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.021785006676431913, 'nb_photo': 3238, 'list_port_cont': '23522888,23523765,23523844,23523868,23523910,23523929,23523983,23524016,23524042,23524121,23524278,23524436,23524470,23524503,23524545,23524568,23524606,23524639,23524683,23524719,23524743,23524777,23524808,23531120,23533663,23535535,23535667,23538076,23540888,23542779,23550822,23552680,23561725,23564043,23564253,23564993,23565393,23565560,23565849,23571745,23573818,23573986,23574492,23575121,23579823,23580957,23582100,23607756,23607808,23608220,23608255,23608294,23608523,23612601,23612655,23612721,23617432,23617596,23617798,23617932,23618103,23618314,23618574,23618751,23619081,23619248,23619628,23619827,23620221,23620519,23620772,23654954,23655110,23655318,23655648,23655972,23656120,23656271,23656379,23656705,23656784,23656925,23657113,23657257,23657471,23657670,23657881,23658086,23658199,23658526,23658837,23661412,23671789,23674902,23677646,23678619,23678684,23680308,23680530,23680626,23680722,23680856,23681064,23685120,23685539,23688337,23689485,23695643,23700775,23702114,23702476,23702596,23702790,2370688', 'assoc_port': '23522746:23524808,23522747:23524777,23522749:23524743,23522750:23524719,23522752:23524683,23522754:23524639,23522755:23524606,23522757:23524568,23522758:23524545,23522760:23524503,23522761:23524470,23522763:23524436,23522765:23524278,23522769:23524121,23522770:23524042,23522772:23524016,23522773:23523929,23522775:23523983,23522776:23523910,23522778:23523868,23522780:23523844,23522781:23523765,23522783:23522888,23528533:23564043,23528535:23564253,23528537:23582100,23528538:23564993,23528541:23565393,23528542:23535667,23528545:23565849,23531052:23531120,23533542:23533663,23535502:23535535,23537991:23538076,23540447:23540888,23542731:23542779,23544363:23574492,23549062:23575121,23550736:23550822,23552597:23552680,23557577:23579823,23558791:23580957,23561654:23561725,23565491:23565560,23569326:23571745,23572297:23573986,23572298:23573818,23607559:23617432,23607560:23617596,23607561:23617798,23607562:23617932,23607563:23618103,23607564:23618314,23607565:23618574,23607566:23618751,23607579:23619081,23607580:2361924', 'assoc_mat': '23522746:pet_clair:4213:23524808,23522747:pet_clair:4213:23524777,23522749:pet_clair:4213:23524743,23522750:pet_clair:4213:23524719,23522752:pet_clair:4213:23524683,23522754:pet_clair:4213:23524639,23522755:pet_clair:4213:23524606,23522757:pet_clair:4213:23524568,23522758:pet_clair:4213:23524545,23522760:pet_clair:4213:23524503,23522761:pet_clair:4213:23524470,23522763:pet_clair:4213:23524436,23522765:pet_clair:4213:23524278,23522769:pet_clair:4213:23524121,23522770:pet_clair:4213:23524042,23522772:pet_clair:4213:23524016,23522773:pet_clair:4213:23523929,23522775:pet_clair:4213:23523983,23522776:pet_clair:4213:23523910,23522778:pet_clair:4213:23523868,23522780:pet_clair:4213:23523844,23522781:pet_clair:4213:23523765,23522783:pet_clair:4213:23522888,23528533:pet_clair:4213:23564043,23528535:pet_clair:4213:23564253,23528537:pet_clair:4213:23582100,23528538:pet_clair:4213:23564993,23528541:pet_clair:4213:23565393,23528542:pet_clair:4213:23535667,23528545:pet_clair:4213:23565849,23531052:pet_clair:4213:23531120,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0011212785263722681, 'nb_photo': 60, 'list_port_cont': '23524437,23533664,23552667,23564263,23564996,23617792,23617938,23618106,23618572,23655117,23656126,23656715,23657673,23657886,23658844,23700777,23702124,23702478,23735467,23759653,23760918,23763856,23796610,23806151,23840911,23919827,23933882,23965636,24046112,24129255,24129994,24134340,24161519,24163321,24165720,24165955,24166454,24166581,24168576,24168650,24176312,24250017,24255353,24256462,24262006,24271860,24281404,24306963,24307572,24327493,24328354,24328535,24366956,24380941,24386259', 'assoc_port': '23522763:23524437,23528535:23564263,23528538:23564996,23533542:23533664,23552597:23552667,23607561:23617792,23607562:23617938,23607563:23618106,23607565:23618572,23650227:23655117,23650235:23656126,23650239:23656715,23650247:23657673,23650249:23657886,23650255:23658844,23681639:23702124,23681655:23702478,23696932:23700777,23710958:23735467,23757466:23759653,23757477:23760918,23762886:23763856,23784541:23796610,23804738:23806151,23829030:23840911,23905500:23919827,23910715:24046112,23930266:23933882,23935739:24134340,23965308:23965636,23996189:24129255,23996203:24129994,24045433:24161519,24046073:24163321,24066179:24168650,24067523:24168576,24107069:24166581,24113564:24166454,24120852:24165955,24127998:24165720,24147434:24176312,24214840:24262006,24233573:24271860,24244699:24250017,24255298:24256462,24255307:24255353,24280692:24281404,24293648:24306963,24293674:24307572,24319315:24328354,24319316:24328535,24319322:24327493,24366928:24366956,24369383:24380941,24386075:24386259', 'assoc_mat': '23522763:pet_fonce:4213:23524437,23528535:pet_fonce:4213:23564263,23528538:pet_fonce:4213:23564996,23533542:pet_fonce:4213:23533664,23552597:pet_fonce:4213:23552667,23607561:pet_fonce:4213:23617792,23607562:pet_fonce:4213:23617938,23607563:pet_fonce:4213:23618106,23607565:pet_fonce:4213:23618572,23650227:pet_fonce:4213:23655117,23650235:pet_fonce:4213:23656126,23650239:pet_fonce:4213:23656715,23650247:pet_fonce:4213:23657673,23650249:pet_fonce:4213:23657886,23650255:pet_fonce:4213:23658844,23681639:pet_fonce:4213:23702124,23681655:pet_fonce:4213:23702478,23696932:pet_fonce:4213:23700777,23710958:pet_fonce:4213:23735467,23757466:pet_fonce:4213:23759653,23757477:pet_fonce:4213:23760918,23762886:pet_fonce:4213:23763856,23784541:pet_fonce:4213:23796610,23804738:pet_fonce:4213:23806151,23829030:pet_fonce:4213:23840911,23905500:pet_fonce:4213:23919827,23910715:pet_fonce:4213:24046112,23930266:pet_fonce:4213:23933882,23935739:pet_fonce:4213:24134340,23965308:pet_fonce:4213:23965636,23996189:pet_fonce:4213:24129255,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.01923337877777675, 'nb_photo': 1420, 'list_port_cont': '23522890,23523777,23523836,23523873,23523911,23523925,23523980,23524019,23524054,23524270,23524441,23524464,23524505,23524548,23524583,23524594,23524644,23524678,23524706,23524751,23524788,23524819,23531125,23533658,23535546,23535656,23538071,23540877,23542781,23550819,23552666,23561736,23564045,23565005,23565397,23565842,23571756,23573819,23573987,23574496,23575128,23579829,23580955,23582108,23607765,23607810,23608254,23608285,23608526,23612615,23612664,23612734,23617433,23617602,23617794,23617939,23618094,23618573,23618753,23619090,23619243,23619626,23620224,23620521,23620771,23654953,23655118,23655311,23655649,23655977,23656121,23656280,23656383,23656703,23656794,23656914,23657119,23657252,23657479,23657665,23657889,23658083,23658209,23658518,23658838,23661421,23671790,23674900,23677653,23678623,23678696,23680310,23680531,23680625,23680718,23680840,23681056,23685119,23685533,23688339,23689487,23695639,23700782,23702121,23702481,23702587,23707889,23708284,23709143,23713051,23713235,23713705,23713850,2371412', 'assoc_port': '23522746:23524819,23522747:23524788,23522749:23524751,23522750:23524706,23522752:23524678,23522754:23524644,23522755:23524594,23522757:23524583,23522758:23524548,23522760:23524505,23522761:23524464,23522763:23524441,23522765:23524270,23522770:23524054,23522772:23524019,23522773:23523925,23522775:23523980,23522776:23523911,23522778:23523873,23522780:23523836,23522781:23523777,23522783:23522890,23528533:23564045,23528537:23582108,23528538:23565005,23528541:23565397,23528542:23535656,23528545:23565842,23531052:23531125,23533542:23533658,23535502:23535546,23537991:23538071,23540447:23540877,23542731:23542781,23544363:23574496,23549062:23575128,23550736:23550819,23552597:23552666,23557577:23579829,23558791:23580955,23561654:23561736,23569326:23571756,23572297:23573987,23572298:23573819,23607559:23617433,23607560:23617602,23607561:23617794,23607562:23617939,23607563:23618094,23607565:23618573,23607566:23618753,23607579:23619090,23607580:23619243,23607593:23619626,23607595:23620224,23607596:23620521,23607597:2362077', 'assoc_mat': '23522746:pet_opaque:4213:23524819,23522747:pet_opaque:4213:23524788,23522749:pet_opaque:4213:23524751,23522750:pet_opaque:4213:23524706,23522752:pet_opaque:4213:23524678,23522754:pet_opaque:4213:23524644,23522755:pet_opaque:4213:23524594,23522757:pet_opaque:4213:23524583,23522758:pet_opaque:4213:23524548,23522760:pet_opaque:4213:23524505,23522761:pet_opaque:4213:23524464,23522763:pet_opaque:4213:23524441,23522765:pet_opaque:4213:23524270,23522770:pet_opaque:4213:23524054,23522772:pet_opaque:4213:23524019,23522773:pet_opaque:4213:23523925,23522775:pet_opaque:4213:23523980,23522776:pet_opaque:4213:23523911,23522778:pet_opaque:4213:23523873,23522780:pet_opaque:4213:23523836,23522781:pet_opaque:4213:23523777,23522783:pet_opaque:4213:23522890,23528533:pet_opaque:4213:23564045,23528537:pet_opaque:4213:23582108,23528538:pet_opaque:4213:23565005,23528541:pet_opaque:4213:23565397,23528542:pet_opaque:4213:23535656,23528545:pet_opaque:4213:23565842,23531052:pet_opaque:4213:23531125,23533542:pet_opaque:4213:23533658,2353'}) 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(1864805,1867252,1870496,1873889,1877422,1882003,1885583,1888776,1893948,1897986,1904915,1906465,1908669,1912395,1911230,1914320,1917360,1920397,1922116,1925426,1930332,1926782,1930420,1929323,1932886,1938556,1938182,1940144,1940771,1951851)); after get_hostname_from_raspi hasthag : refus hasthag that could be used but not yet : _______refus,textiles_sanitaires SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______refus' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=983) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=15 and date >='2025-06-01' and date <= '2025-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((4150,),), 'unwanted_material_monthly_percentage': ((0.11740310071622292,),), 'material_repartition': (('refus', 4136),), 'material_dict': {'refus': 4136}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.09764013458454936, 144), (datetime.date(2025, 6, 2), 0.09700947581567364, 168), (datetime.date(2025, 6, 3), 0.09549968468018473, 175), (datetime.date(2025, 6, 4), 0.11335061399773634, 210), (datetime.date(2025, 6, 5), 0.10705816573809156, 163), (datetime.date(2025, 6, 6), 0.1243001734099041, 186), (datetime.date(2025, 6, 7), 0.1277670373445504, 146), (datetime.date(2025, 6, 8), 0.11836349211043481, 155), (datetime.date(2025, 6, 9), 0.11552411583336361, 176), (datetime.date(2025, 6, 10), 0.11582076809258976, 146), (datetime.date(2025, 6, 11), 0.10345655124878027, 113), (datetime.date(2025, 6, 12), 0.1135876578336189, 131), (datetime.date(2025, 6, 13), 0.1264451024841556, 181), (datetime.date(2025, 6, 14), 0.13110532688649665, 160), (datetime.date(2025, 6, 15), 0.12961385299285305, 126), (datetime.date(2025, 6, 16), 0.12843502026167786, 145), (datetime.date(2025, 6, 17), 0.1328281467636661, 236), (datetime.date(2025, 6, 18), 0.14101621299934947, 206), (datetime.date(2025, 6, 19), 0.11857992692943213, 118), (datetime.date(2025, 6, 20), 0.08690356986013789, 316), (datetime.date(2025, 6, 21), 0.12647990485717198, 110), (datetime.date(2025, 6, 22), 0.1256188598944305, 80), (datetime.date(2025, 6, 23), 0.11665685614011406, 86), (datetime.date(2025, 6, 24), 0.12223142141814167, 77), (datetime.date(2025, 6, 25), 0.1821410361546312, 149), (datetime.date(2025, 6, 26), 0.13157964553401008, 80), (datetime.date(2025, 6, 27), 0.1277478823441393, 74), (datetime.date(2025, 6, 28), 0.16118991070645042, 76), (datetime.date(2025, 6, 29), 0.10446927544879055, 3), (datetime.date(2025, 6, 30), 0.1211907791709157, 14)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 6, 1), 0.09764013458454936, 144), (datetime.date(2025, 6, 2), 0.09700947581567364, 168), (datetime.date(2025, 6, 3), 0.09549968468018473, 175), (datetime.date(2025, 6, 4), 0.11335061399773634, 210), (datetime.date(2025, 6, 5), 0.10705816573809156, 163), (datetime.date(2025, 6, 6), 0.1243001734099041, 186), (datetime.date(2025, 6, 7), 0.1277670373445504, 146), (datetime.date(2025, 6, 8), 0.11836349211043481, 155), (datetime.date(2025, 6, 9), 0.11552411583336361, 176), (datetime.date(2025, 6, 10), 0.11582076809258976, 146), (datetime.date(2025, 6, 11), 0.10345655124878027, 113), (datetime.date(2025, 6, 12), 0.1135876578336189, 131), (datetime.date(2025, 6, 13), 0.1264451024841556, 181), (datetime.date(2025, 6, 14), 0.13110532688649665, 160), (datetime.date(2025, 6, 15), 0.12961385299285305, 126), (datetime.date(2025, 6, 16), 0.12843502026167786, 145), (datetime.date(2025, 6, 17), 0.1328281467636661, 236), (datetime.date(2025, 6, 18), 0.14101621299934947, 206), (datetime.date(2025, 6, 19), 0.11857992692943213, 118), (datetime.date(2025, 6, 20), 0.08690356986013789, 316), (datetime.date(2025, 6, 21), 0.12647990485717198, 110), (datetime.date(2025, 6, 22), 0.1256188598944305, 80), (datetime.date(2025, 6, 23), 0.11665685614011406, 86), (datetime.date(2025, 6, 24), 0.12223142141814167, 77), (datetime.date(2025, 6, 25), 0.1821410361546312, 149), (datetime.date(2025, 6, 26), 0.13157964553401008, 80), (datetime.date(2025, 6, 27), 0.1277478823441393, 74), (datetime.date(2025, 6, 28), 0.16118991070645042, 76), (datetime.date(2025, 6, 29), 0.10446927544879055, 3), (datetime.date(2025, 6, 30), 0.1211907791709157, 14))}, 'quality_array': [['-1.851377213629873', '01062025'], ['-1.922687416076372', '02062025'], ['-1.8218615263804618', '03062025'], ['-1.747708826196408', '04062025'], ['-1.8276804916119347', '05062025'], ['-1.6005473188152182', '06062025'], ['-1.4601036486118417', '07062025'], ['-1.70145829811813', '08062025'], ['-1.72194882745701', '09062025'], ['-1.5910670479729168', '10062025'], ['-1.4690815496038887', '11062025'], ['-1.4859850337367007', '12062025'], ['-1.3791740816716502', '13062025'], ['-1.4022280943033008', '14062025'], ['-1.5444718323541442', '15062025'], ['-1.479816741997873', '16062025'], ['-2.6833552324053307', '17062025'], ['-1.866937173442209', '18062025'], ['-1.7262655169395345', '19062025'], ['-2.3983614465159144', '20062025'], ['-1.3215280145773418', '21062025'], ['-1.305873581942424', '22062025'], ['-1.2326800368857886', '23062025'], ['-1.319061957843241', '24062025'], ['-2.1690055748277977', '25062025'], ['-1.269803688707808', '26062025'], ['-1.1672421138254254', '27062025'], ['-1.7139662628381023', '28062025'], ['-4.70457832298741', '29062025'], ['-0.9301699618830553', '30062025']], 'number_of_batch': ((646,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.006287462861399552, 'nb_photo': 865, 'list_port_cont': '23522898,23523766,23523842,23523866,23523916,23523935,23523977,23524049,23524127,23524266,23524497,23524533,23524581,23524638,23524684,23524715,23524739,23524773,23524821,23531122,23533661,23535537,23535652,23538074,23540886,23550817,23552679,23561730,23564997,23565401,23565554,23573823,23573972,23574481,23575126,23579820,23580946,23582111,23607763,23608259,23608296,23608527,23612656,23612731,23617431,23617608,23617802,23617926,23618105,23618311,23618575,23618745,23619624,23619837,23620223,23620522,23620769,23655120,23655314,23655642,23655766,23655966,23656113,23656274,23656714,23656791,23656913,23657112,23657251,23657476,23657679,23657894,23658081,23658195,23658529,23658834,23661409,23671791,23674909,23677643,23678608,23678683,23680306,23680528,23680614,23680725,23680847,23681055,23685127,23685540,23688346,23689481,23695649,23700786,23702122,23702471,23702598,23702786,23707905,23708288,23709139,23713049,23713233,23713441,23713847,23714126,23715799,23718232,23720699,23720920,23726291,23726798,23728024,2373547', 'assoc_port': '23522746:23524821,23522747:23524773,23522749:23524739,23522750:23524715,23522752:23524684,23522754:23524638,23522757:23524581,23522758:23524533,23522760:23524497,23522765:23524266,23522769:23524127,23522770:23524049,23522773:23523935,23522775:23523977,23522776:23523916,23522778:23523866,23522780:23523842,23522781:23523766,23522783:23522898,23528537:23582111,23528538:23564997,23528541:23565401,23528542:23535652,23531052:23531122,23533542:23533661,23535502:23535537,23537991:23538074,23540447:23540886,23544363:23574481,23549062:23575126,23550736:23550817,23552597:23552679,23557577:23579820,23558791:23580946,23561654:23561730,23565491:23565554,23572297:23573972,23572298:23573823,23607559:23617431,23607560:23617608,23607561:23617802,23607562:23617926,23607563:23618105,23607564:23618311,23607565:23618575,23607566:23618745,23607593:23619624,23607594:23619837,23607595:23620223,23607596:23620522,23607597:23620769,23607598:23612731,23607599:23612656,23607601:23608527,23607602:23608296,23607603:23608259,23607606:2360776', 'assoc_mat': '23522746:barquette_opaque:4213:23524821,23522747:barquette_opaque:4213:23524773,23522749:barquette_opaque:4213:23524739,23522750:barquette_opaque:4213:23524715,23522752:barquette_opaque:4213:23524684,23522754:barquette_opaque:4213:23524638,23522757:barquette_opaque:4213:23524581,23522758:barquette_opaque:4213:23524533,23522760:barquette_opaque:4213:23524497,23522765:barquette_opaque:4213:23524266,23522769:barquette_opaque:4213:23524127,23522770:barquette_opaque:4213:23524049,23522773:barquette_opaque:4213:23523935,23522775:barquette_opaque:4213:23523977,23522776:barquette_opaque:4213:23523916,23522778:barquette_opaque:4213:23523866,23522780:barquette_opaque:4213:23523842,23522781:barquette_opaque:4213:23523766,23522783:barquette_opaque:4213:23522898,23528537:barquette_opaque:4213:23582111,23528538:barquette_opaque:4213:23564997,23528541:barquette_opaque:4213:23565401,23528542:barquette_opaque:4213:23535652,23531052:barquette_opaque:4213:23531122,23533542:barquette_opaque:4213:23533661,23535502:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036535090883231427, 'nb_photo': 864, 'list_port_cont': '23522893,23523763,23523871,23523915,23523978,23524048,23524279,23524469,23524570,23524642,23524677,23524714,23524740,23524787,23524806,23533665,23535532,23538075,23550820,23552670,23564039,23565406,23565836,23573816,23573979,23575119,23579830,23580959,23607749,23608219,23608286,23608535,23612668,23612730,23617441,23617805,23617928,23618107,23618566,23618744,23619075,23619631,23619828,23620219,23620528,23654963,23655111,23655306,23655651,23655756,23656114,23656279,23656382,23656701,23656786,23657671,23657891,23658832,23661423,23671794,23674903,23677654,23678622,23680305,23680536,23680617,23680720,23681060,23685126,23695656,23700773,23702482,23702599,23702776,23706872,23707892,23713053,23713243,23713431,23713692,23714127,23715795,23720933,23722766,23728027,23735466,23737839,23741724,23742902,23743218,23743294,23744016,23744553,23746547,23747156,23747264,23747340,23747444,23747878,23748225,23749004,23749769,23751724,23751789,23757799,23758290,23758540,23759766,23759976,23760312,23760770,23760904,23760945,2376098', 'assoc_port': '23522746:23524806,23522747:23524787,23522749:23524740,23522750:23524714,23522752:23524677,23522754:23524642,23522757:23524570,23522761:23524469,23522765:23524279,23522770:23524048,23522775:23523978,23522776:23523915,23522778:23523871,23522781:23523763,23522783:23522893,23528533:23564039,23528541:23565406,23528545:23565836,23533542:23533665,23535502:23535532,23537991:23538075,23549062:23575119,23550736:23550820,23552597:23552670,23557577:23579830,23558791:23580959,23572297:23573979,23572298:23573816,23607559:23617441,23607561:23617805,23607562:23617928,23607563:23618107,23607565:23618566,23607566:23618744,23607579:23619075,23607593:23619631,23607594:23619828,23607595:23620219,23607596:23620528,23607598:23612730,23607599:23612668,23607601:23608535,23607602:23608286,23607604:23608219,23607606:23607749,23650226:23654963,23650227:23655111,23650228:23655306,23650229:23678622,23650231:23655651,23650232:23655756,23650235:23656114,23650236:23656279,23650237:23656382,23650239:23656701,23650240:23656786,23650247:2365767', 'assoc_mat': '23522746:carton:4213:23524806,23522747:carton:4213:23524787,23522749:carton:4213:23524740,23522750:carton:4213:23524714,23522752:carton:4213:23524677,23522754:carton:4213:23524642,23522757:carton:4213:23524570,23522761:carton:4213:23524469,23522765:carton:4213:23524279,23522770:carton:4213:23524048,23522775:carton:4213:23523978,23522776:carton:4213:23523915,23522778:carton:4213:23523871,23522781:carton:4213:23523763,23522783:carton:4213:23522893,23528533:carton:4213:23564039,23528541:carton:4213:23565406,23528545:carton:4213:23565836,23533542:carton:4213:23533665,23535502:carton:4213:23535532,23537991:carton:4213:23538075,23549062:carton:4213:23575119,23550736:carton:4213:23550820,23552597:carton:4213:23552670,23557577:carton:4213:23579830,23558791:carton:4213:23580959,23572297:carton:4213:23573979,23572298:carton:4213:23573816,23607559:carton:4213:23617441,23607561:carton:4213:23617805,23607562:carton:4213:23617928,23607563:carton:4213:23618107,23607565:carton:4213:23618566,23607566:carton:4213:23618744,2360'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.007236471083612558, 'nb_photo': 348, 'list_port_cont': '23523976,23524577,23524686,23524746,23524776,23524810,23531132,23533660,23538073,23561733,23564031,23565403,23565843,23571747,23573827,23575118,23582106,23607755,23608284,23612661,23612733,23617440,23617597,23617929,23619085,23620228,23620520,23654961,23655123,23655302,23655646,23656129,23656284,23656707,23656793,23657256,23657477,23657885,23658524,23658835,23671795,23674913,23678615,23680312,23685133,23685534,23689490,23695637,23700783,23702601,23706886,23708275,23713037,23713241,23713442,23714135,23720927,23726811,23728028,23740315,23741735,23742908,23743227,23743288,23744005,23747153,23747886,23747954,23749778,23751722,23751786,23757795,23759419,23759897,23759968,23760506,23760757,23760910,23760952,23761096,23763688,23763742,23763855,23763947,23765236,23778119,23783169,23785094,23792686,23799215,23803012,23803407,23803439,23804975,23806155,23806323,23806489,23809210,23812216,23817450,23821674,23849743,23849904,23898844,23910463,23910525,23911864,23919764,23922728,23924444,23924521,23924532,23931691,2399566', 'assoc_port': '23522746:23524810,23522747:23524776,23522749:23524746,23522752:23524686,23522757:23524577,23522775:23523976,23528533:23564031,23528537:23582106,23528541:23565403,23528545:23565843,23531052:23531132,23533542:23533660,23537991:23538073,23549062:23575118,23561654:23561733,23569326:23571747,23572298:23573827,23607559:23617440,23607560:23617597,23607562:23617929,23607579:23619085,23607595:23620228,23607596:23620520,23607598:23612733,23607599:23612661,23607602:23608284,23607606:23607755,23650226:23654961,23650227:23655123,23650228:23655302,23650229:23678615,23650231:23655646,23650235:23656129,23650236:23656284,23650239:23656707,23650240:23656793,23650244:23657256,23650245:23657477,23650249:23657885,23650253:23658524,23650255:23658835,23663342:23680312,23666428:23695637,23671701:23671795,23674765:23674913,23681658:23702601,23681659:23726811,23683965:23685534,23685096:23685133,23689436:23689490,23696926:23713037,23696929:23713241,23696932:23700783,23696949:23713442,23696967:23714135,23702424:23720927,23706699:2370688', 'assoc_mat': '23522746:ela:4213:23524810,23522747:ela:4213:23524776,23522749:ela:4213:23524746,23522752:ela:4213:23524686,23522757:ela:4213:23524577,23522775:ela:4213:23523976,23528533:ela:4213:23564031,23528537:ela:4213:23582106,23528541:ela:4213:23565403,23528545:ela:4213:23565843,23531052:ela:4213:23531132,23533542:ela:4213:23533660,23537991:ela:4213:23538073,23549062:ela:4213:23575118,23561654:ela:4213:23561733,23569326:ela:4213:23571747,23572298:ela:4213:23573827,23607559:ela:4213:23617440,23607560:ela:4213:23617597,23607562:ela:4213:23617929,23607579:ela:4213:23619085,23607595:ela:4213:23620228,23607596:ela:4213:23620520,23607598:ela:4213:23612733,23607599:ela:4213:23612661,23607602:ela:4213:23608284,23607606:ela:4213:23607755,23650226:ela:4213:23654961,23650227:ela:4213:23655123,23650228:ela:4213:23655302,23650229:ela:4213:23678615,23650231:ela:4213:23655646,23650235:ela:4213:23656129,23650236:ela:4213:23656284,23650239:ela:4213:23656707,23650240:ela:4213:23656793,23650244:ela:4213:23657256,23650245:ela:4213:2365747'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0037714688878688835, 'nb_photo': 946, 'list_port_cont': '23522887,23523774,23523837,23523879,23523907,23523937,23523984,23524262,23524433,23524471,23524507,23524549,23524710,23524741,23524778,23524809,23531131,23533657,23535541,23535660,23538072,23540883,23542768,23550826,23552672,23564044,23565399,23565851,23571755,23573811,23574485,23575115,23579824,23580961,23582101,23607764,23607805,23608222,23608250,23608297,23608520,23612669,23617442,23617595,23617803,23617937,23618096,23618312,23618564,23618754,23619091,23619633,23620229,23620531,23620760,23654958,23655124,23655303,23655657,23655978,23656117,23656276,23656389,23656710,23656795,23657121,23657244,23657480,23657664,23657879,23658087,23658208,23658520,23658833,23661416,23671786,23674905,23677641,23678609,23678695,23680315,23680527,23680624,23680721,23681067,23685129,23685544,23688341,23689488,23695653,23700774,23702120,23702480,23702588,23702780,23706877,23707899,23713038,23713242,23714125,23715808,23718228,23720694,23720932,23726301,23726807,23728037,23735469,23737829,23741083,23742913,23743108,23743222,2374329', 'assoc_port': '23522746:23524809,23522747:23524778,23522749:23524741,23522750:23524710,23522758:23524549,23522760:23524507,23522761:23524471,23522763:23524433,23522765:23524262,23522773:23523937,23522775:23523984,23522776:23523907,23522778:23523879,23522780:23523837,23522781:23523774,23522783:23522887,23528533:23564044,23528537:23582101,23528541:23565399,23528542:23535660,23528545:23565851,23531052:23531131,23533542:23533657,23535502:23535541,23537991:23538072,23540447:23540883,23542731:23542768,23544363:23574485,23549062:23575115,23550736:23550826,23552597:23552672,23557577:23579824,23558791:23580961,23569326:23571755,23572298:23573811,23607559:23617442,23607560:23617595,23607561:23617803,23607562:23617937,23607563:23618096,23607564:23618312,23607565:23618564,23607566:23618754,23607579:23619091,23607593:23619633,23607595:23620229,23607596:23620531,23607597:23620760,23607599:23612669,23607601:23608520,23607602:23608297,23607603:23608250,23607604:23608222,23607605:23607805,23607606:23607764,23650226:23654958,23650227:2365512', 'assoc_mat': '23522746:etiquette:4213:23524809,23522747:etiquette:4213:23524778,23522749:etiquette:4213:23524741,23522750:etiquette:4213:23524710,23522758:etiquette:4213:23524549,23522760:etiquette:4213:23524507,23522761:etiquette:4213:23524471,23522763:etiquette:4213:23524433,23522765:etiquette:4213:23524262,23522773:etiquette:4213:23523937,23522775:etiquette:4213:23523984,23522776:etiquette:4213:23523907,23522778:etiquette:4213:23523879,23522780:etiquette:4213:23523837,23522781:etiquette:4213:23523774,23522783:etiquette:4213:23522887,23528533:etiquette:4213:23564044,23528537:etiquette:4213:23582101,23528541:etiquette:4213:23565399,23528542:etiquette:4213:23535660,23528545:etiquette:4213:23565851,23531052:etiquette:4213:23531131,23533542:etiquette:4213:23533657,23535502:etiquette:4213:23535541,23537991:etiquette:4213:23538072,23540447:etiquette:4213:23540883,23542731:etiquette:4213:23542768,23544363:etiquette:4213:23574485,23549062:etiquette:4213:23575115,23550736:etiquette:4213:23550826,23552597:etiquette:4213:23552672,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.04624958927337406, 'nb_photo': 2554, 'list_port_cont': '23522903,23523762,23523833,23523904,23523921,23523973,23524012,23524053,23524125,23524276,23524435,23524468,23524499,23524536,23524579,23524676,23524713,23524750,23524785,23524817,23531123,23533666,23535533,23535661,23538085,23540881,23550828,23552668,23561734,23564029,23564994,23565394,23565845,23573812,23573974,23574493,23575129,23579827,23580950,23582102,23607753,23607798,23608216,23608244,23608289,23608528,23612658,23612727,23617435,23617793,23617933,23618095,23618319,23618562,23618747,23619089,23619251,23619619,23619839,23620233,23620529,23620761,23654956,23655114,23655312,23655650,23655768,23655975,23656273,23656375,23656716,23656799,23656923,23657117,23657249,23657676,23658080,23658197,23658527,23658847,23661414,23671792,23674915,23677650,23678620,23678686,23680307,23680537,23680611,23680712,23680845,23681061,23685130,23685541,23688343,23689483,23695641,23700784,23702113,23702474,23702590,23702781,23706888,23707893,23708278,23709150,23713039,23713246,23713445,23713843,23714133,23715800,23718230,2372069', 'assoc_port': '23522746:23524817,23522747:23524785,23522749:23524750,23522750:23524713,23522752:23524676,23522757:23524579,23522758:23524536,23522760:23524499,23522761:23524468,23522763:23524435,23522765:23524276,23522769:23524125,23522770:23524053,23522772:23524012,23522773:23523921,23522775:23523973,23522776:23523904,23522780:23523833,23522781:23523762,23522783:23522903,23528533:23564029,23528537:23582102,23528538:23564994,23528541:23565394,23528542:23535661,23528545:23565845,23531052:23531123,23533542:23533666,23535502:23535533,23537991:23538085,23540447:23540881,23544363:23574493,23549062:23575129,23550736:23550828,23552597:23552668,23557577:23579827,23558791:23580950,23561654:23561734,23572297:23573974,23572298:23573812,23607559:23617435,23607561:23617793,23607562:23617933,23607563:23618095,23607564:23618319,23607565:23618562,23607566:23618747,23607579:23619089,23607580:23619251,23607593:23619619,23607594:23619839,23607595:23620233,23607596:23620529,23607597:23620761,23607598:23612727,23607599:23612658,23607601:2360852', 'assoc_mat': '23522746:film_plastique:4213:23524817,23522747:film_plastique:4213:23524785,23522749:film_plastique:4213:23524750,23522750:film_plastique:4213:23524713,23522752:film_plastique:4213:23524676,23522757:film_plastique:4213:23524579,23522758:film_plastique:4213:23524536,23522760:film_plastique:4213:23524499,23522761:film_plastique:4213:23524468,23522763:film_plastique:4213:23524435,23522765:film_plastique:4213:23524276,23522769:film_plastique:4213:23524125,23522770:film_plastique:4213:23524053,23522772:film_plastique:4213:23524012,23522773:film_plastique:4213:23523921,23522775:film_plastique:4213:23523973,23522776:film_plastique:4213:23523904,23522780:film_plastique:4213:23523833,23522781:film_plastique:4213:23523762,23522783:film_plastique:4213:23522903,23528533:film_plastique:4213:23564029,23528537:film_plastique:4213:23582102,23528538:film_plastique:4213:23564994,23528541:film_plastique:4213:23565394,23528542:film_plastique:4213:23535661,23528545:film_plastique:4213:23565845,23531052:film_plastique:4213:2353112'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0017249569756832373, 'nb_photo': 12, 'list_port_cont': '23550831,23607750,23618571,23702602,23747195,23764088,24094040,24164590,24251633,24327548,24385597,24385949', 'assoc_port': '23550736:23550831,23607565:23618571,23607606:23607750,23681658:23702602,23739325:23747195,23762892:23764088,23972610:24094040,24046082:24164590,24239569:24251633,24319320:24327548,24385134:24385597,24385925:24385949', 'assoc_mat': '23550736:kraft:4213:23550831,23607565:kraft:4213:23618571,23607606:kraft:4213:23607750,23681658:kraft:4213:23702602,23739325:kraft:4213:23747195,23762892:kraft:4213:23764088,23972610:kraft:4213:24094040,24046082:kraft:4213:24164590,24239569:kraft:4213:24251633,24319320:kraft:4213:24327548,24385134:kraft:4213:24385597,24385925:kraft:4213:24385949'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004199811899604449, 'nb_photo': 1419, 'list_port_cont': '23522891,23523776,23523843,23523882,23523909,23523919,23523986,23524013,23524044,23524115,23524171,23524272,23524428,23524475,23524539,23524571,23524643,23524705,23524747,23524783,23524815,23531117,23533672,23535544,23535662,23538070,23540880,23542776,23550825,23561739,23564038,23564252,23564998,23565840,23573814,23573975,23574495,23575124,23580948,23582096,23607751,23607795,23608218,23608290,23608522,23612607,23612671,23612729,23617437,23617801,23617927,23618100,23618565,23618748,23619080,23619259,23619632,23619829,23620232,23620527,23620762,23654957,23655125,23655317,23655655,23655971,23656282,23656708,23656792,23657109,23657245,23657675,23658085,23658515,23658843,23661422,23674908,23678621,23678681,23680313,23680535,23680612,23680719,23681058,23685124,23685530,23688330,23695651,23700779,23702118,23702485,23702600,23702789,23706875,23707896,23708279,23713048,23713244,23713432,23713851,23714121,23715801,23720921,23722767,23726799,23728030,23735468,23737826,23740310,23741081,23741727,23742383,23742900,2374311', 'assoc_port': '23522746:23524815,23522747:23524783,23522749:23524747,23522750:23524705,23522754:23524643,23522757:23524571,23522758:23524539,23522761:23524475,23522763:23524428,23522765:23524272,23522767:23524171,23522769:23524115,23522770:23524044,23522772:23524013,23522773:23523919,23522775:23523986,23522776:23523909,23522778:23523882,23522780:23523843,23522781:23523776,23522783:23522891,23528533:23564038,23528535:23564252,23528537:23582096,23528538:23564998,23528542:23535662,23528545:23565840,23531052:23531117,23533542:23533672,23535502:23535544,23537991:23538070,23540447:23540880,23542731:23542776,23544363:23574495,23549062:23575124,23550736:23550825,23558791:23580948,23561654:23561739,23572297:23573975,23572298:23573814,23607559:23617437,23607561:23617801,23607562:23617927,23607563:23618100,23607565:23618565,23607566:23618748,23607579:23619080,23607580:23619259,23607593:23619632,23607594:23619829,23607595:23620232,23607596:23620527,23607597:23620762,23607598:23612729,23607599:23612671,23607600:23612607,23607601:2360852', 'assoc_mat': '23522746:metal:4213:23524815,23522747:metal:4213:23524783,23522749:metal:4213:23524747,23522750:metal:4213:23524705,23522754:metal:4213:23524643,23522757:metal:4213:23524571,23522758:metal:4213:23524539,23522761:metal:4213:23524475,23522763:metal:4213:23524428,23522765:metal:4213:23524272,23522767:metal:4213:23524171,23522769:metal:4213:23524115,23522770:metal:4213:23524044,23522772:metal:4213:23524013,23522773:metal:4213:23523919,23522775:metal:4213:23523986,23522776:metal:4213:23523909,23522778:metal:4213:23523882,23522780:metal:4213:23523843,23522781:metal:4213:23523776,23522783:metal:4213:23522891,23528533:metal:4213:23564038,23528535:metal:4213:23564252,23528537:metal:4213:23582096,23528538:metal:4213:23564998,23528542:metal:4213:23535662,23528545:metal:4213:23565840,23531052:metal:4213:23531117,23533542:metal:4213:23533672,23535502:metal:4213:23535544,23537991:metal:4213:23538070,23540447:metal:4213:23540880,23542731:metal:4213:23542776,23544363:metal:4213:23574495,23549062:metal:4213:23575124,23550736:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.054599943863049914, 'nb_photo': 4690, 'list_port_cont': '23522899,23523775,23523834,23523872,23523917,23523931,23523974,23524015,23524046,23524128,23524177,23524274,23524438,23524502,23524540,23524578,23524612,23524647,23524674,23524711,23524748,23524782,23524816,23531119,23533667,23535542,23535654,23538084,23540882,23550829,23552665,23561732,23564040,23564991,23565564,23565852,23571749,23573826,23573973,23574497,23575131,23580960,23582110,23607761,23607804,23608207,23608532,23612663,23612724,23617436,23617795,23617936,23618097,23618304,23618561,23618757,23619079,23619245,23619622,23619841,23620222,23620525,23620773,23654949,23655113,23655304,23655643,23655968,23656128,23656269,23656704,23656798,23656920,23657111,23657260,23657472,23657672,23657895,23658082,23658205,23658530,23658841,23661408,23671783,23674912,23677638,23678610,23678685,23680316,23680533,23680618,23680710,23680846,23681059,23685128,23685542,23688338,23689478,23695650,23700781,23702475,23702594,23702774,23706878,23707897,23708283,23709137,23713040,23713234,23713444,23713700,23714122,23715797,2371823', 'assoc_port': '23522746:23524816,23522747:23524782,23522749:23524748,23522750:23524711,23522752:23524674,23522754:23524647,23522755:23524612,23522757:23524578,23522758:23524540,23522760:23524502,23522763:23524438,23522765:23524274,23522767:23524177,23522769:23524128,23522770:23524046,23522772:23524015,23522773:23523931,23522775:23523974,23522776:23523917,23522778:23523872,23522780:23523834,23522781:23523775,23522783:23522899,23528533:23564040,23528537:23582110,23528538:23564991,23528542:23535654,23528545:23565852,23531052:23531119,23533542:23533667,23535502:23535542,23537991:23538084,23540447:23540882,23544363:23574497,23549062:23575131,23550736:23550829,23552597:23552665,23558791:23580960,23561654:23561732,23565491:23565564,23569326:23571749,23572297:23573973,23572298:23573826,23607559:23617436,23607561:23617795,23607562:23617936,23607563:23618097,23607564:23618304,23607565:23618561,23607566:23618757,23607579:23619079,23607580:23619245,23607593:23619622,23607594:23619841,23607595:23620222,23607596:23620525,23607597:2362077', 'assoc_mat': '23522746:papier:4213:23524816,23522747:papier:4213:23524782,23522749:papier:4213:23524748,23522750:papier:4213:23524711,23522752:papier:4213:23524674,23522754:papier:4213:23524647,23522755:papier:4213:23524612,23522757:papier:4213:23524578,23522758:papier:4213:23524540,23522760:papier:4213:23524502,23522763:papier:4213:23524438,23522765:papier:4213:23524274,23522767:papier:4213:23524177,23522769:papier:4213:23524128,23522770:papier:4213:23524046,23522772:papier:4213:23524015,23522773:papier:4213:23523931,23522775:papier:4213:23523974,23522776:papier:4213:23523917,23522778:papier:4213:23523872,23522780:papier:4213:23523834,23522781:papier:4213:23523775,23522783:papier:4213:23522899,23528533:papier:4213:23564040,23528537:papier:4213:23582110,23528538:papier:4213:23564991,23528542:papier:4213:23535654,23528545:papier:4213:23565852,23531052:papier:4213:23531119,23533542:papier:4213:23533667,23535502:papier:4213:23535542,23537991:papier:4213:23538084,23540447:papier:4213:23540882,23544363:papier:4213:23574497,2354'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.006683358409303269, 'nb_photo': 77, 'list_port_cont': '23535534,23550832,23552681,23565004,23580952,23656387,23657250,23657469,23658522,23658836,23680848,23689492,23706879,23713245,23713694,23726303,23726812,23741728,23743113,23743217,23747410,23757789,23761010,23761178,23763677,23796604,23850006,23898835,23911871,23919763,23931676,24018488,24089915,24092243,24094052,24115652,24116255,24132546,24134295,24135971,24161402,24161919,24162051,24162982,24164888,24164944,24165778,24167756,24167874,24170291,24171101,24173803,24176304,24178851,24261998,24262773,24263642,24264641,24279935,24284626,24284800,24308270,24325424,24328361,24328541,24342479,24361977,24390726,24409243', 'assoc_port': '23528538:23565004,23535502:23535534,23550736:23550832,23552597:23552681,23558791:23580952,23650237:23656387,23650244:23657250,23650245:23657469,23650253:23658522,23650255:23658836,23663350:23680848,23681640:23726303,23681659:23726812,23689436:23689492,23696929:23713245,23696962:23713694,23706699:23706879,23731743:23743217,23739331:23747410,23741717:23741728,23743106:23743113,23757453:23757789,23757463:23761178,23757480:23761010,23762885:23763677,23784541:23796604,23845232:23850006,23896955:23911871,23898784:23898835,23905499:23919763,23931619:23931676,23935735:24134295,23935757:24135971,23961893:24089915,23966881:24092243,23972610:24094052,23979656:24115652,23983414:24116255,23998044:24132546,24017357:24018488,24045430:24161402,24045431:24170291,24045434:24161919,24045437:24162051,24046045:24162982,24046085:24164944,24084320:24167874,24084324:24167756,24124700:24165778,24147434:24176304,24147436:24164888,24170336:24171101,24173747:24173803,24178811:24178851,24214840:24261998,24222024:24263642,24230040:2426464', 'assoc_mat': '23528538:pehd:4213:23565004,23535502:pehd:4213:23535534,23550736:pehd:4213:23550832,23552597:pehd:4213:23552681,23558791:pehd:4213:23580952,23650237:pehd:4213:23656387,23650244:pehd:4213:23657250,23650245:pehd:4213:23657469,23650253:pehd:4213:23658522,23650255:pehd:4213:23658836,23663350:pehd:4213:23680848,23681640:pehd:4213:23726303,23681659:pehd:4213:23726812,23689436:pehd:4213:23689492,23696929:pehd:4213:23713245,23696962:pehd:4213:23713694,23706699:pehd:4213:23706879,23731743:pehd:4213:23743217,23739331:pehd:4213:23747410,23741717:pehd:4213:23741728,23743106:pehd:4213:23743113,23757453:pehd:4213:23757789,23757463:pehd:4213:23761178,23757480:pehd:4213:23761010,23762885:pehd:4213:23763677,23784541:pehd:4213:23796604,23845232:pehd:4213:23850006,23896955:pehd:4213:23911871,23898784:pehd:4213:23898835,23905499:pehd:4213:23919763,23931619:pehd:4213:23931676,23935735:pehd:4213:24134295,23935757:pehd:4213:24135971,23961893:pehd:4213:24089915,23966881:pehd:4213:24092243,23972610:pehd:4213:24094052,23979656:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.021785006676431913, 'nb_photo': 3238, 'list_port_cont': '23522888,23523765,23523844,23523868,23523910,23523929,23523983,23524016,23524042,23524121,23524278,23524436,23524470,23524503,23524545,23524568,23524606,23524639,23524683,23524719,23524743,23524777,23524808,23531120,23533663,23535535,23535667,23538076,23540888,23542779,23550822,23552680,23561725,23564043,23564253,23564993,23565393,23565560,23565849,23571745,23573818,23573986,23574492,23575121,23579823,23580957,23582100,23607756,23607808,23608220,23608255,23608294,23608523,23612601,23612655,23612721,23617432,23617596,23617798,23617932,23618103,23618314,23618574,23618751,23619081,23619248,23619628,23619827,23620221,23620519,23620772,23654954,23655110,23655318,23655648,23655972,23656120,23656271,23656379,23656705,23656784,23656925,23657113,23657257,23657471,23657670,23657881,23658086,23658199,23658526,23658837,23661412,23671789,23674902,23677646,23678619,23678684,23680308,23680530,23680626,23680722,23680856,23681064,23685120,23685539,23688337,23689485,23695643,23700775,23702114,23702476,23702596,23702790,2370688', 'assoc_port': '23522746:23524808,23522747:23524777,23522749:23524743,23522750:23524719,23522752:23524683,23522754:23524639,23522755:23524606,23522757:23524568,23522758:23524545,23522760:23524503,23522761:23524470,23522763:23524436,23522765:23524278,23522769:23524121,23522770:23524042,23522772:23524016,23522773:23523929,23522775:23523983,23522776:23523910,23522778:23523868,23522780:23523844,23522781:23523765,23522783:23522888,23528533:23564043,23528535:23564253,23528537:23582100,23528538:23564993,23528541:23565393,23528542:23535667,23528545:23565849,23531052:23531120,23533542:23533663,23535502:23535535,23537991:23538076,23540447:23540888,23542731:23542779,23544363:23574492,23549062:23575121,23550736:23550822,23552597:23552680,23557577:23579823,23558791:23580957,23561654:23561725,23565491:23565560,23569326:23571745,23572297:23573986,23572298:23573818,23607559:23617432,23607560:23617596,23607561:23617798,23607562:23617932,23607563:23618103,23607564:23618314,23607565:23618574,23607566:23618751,23607579:23619081,23607580:2361924', 'assoc_mat': '23522746:pet_clair:4213:23524808,23522747:pet_clair:4213:23524777,23522749:pet_clair:4213:23524743,23522750:pet_clair:4213:23524719,23522752:pet_clair:4213:23524683,23522754:pet_clair:4213:23524639,23522755:pet_clair:4213:23524606,23522757:pet_clair:4213:23524568,23522758:pet_clair:4213:23524545,23522760:pet_clair:4213:23524503,23522761:pet_clair:4213:23524470,23522763:pet_clair:4213:23524436,23522765:pet_clair:4213:23524278,23522769:pet_clair:4213:23524121,23522770:pet_clair:4213:23524042,23522772:pet_clair:4213:23524016,23522773:pet_clair:4213:23523929,23522775:pet_clair:4213:23523983,23522776:pet_clair:4213:23523910,23522778:pet_clair:4213:23523868,23522780:pet_clair:4213:23523844,23522781:pet_clair:4213:23523765,23522783:pet_clair:4213:23522888,23528533:pet_clair:4213:23564043,23528535:pet_clair:4213:23564253,23528537:pet_clair:4213:23582100,23528538:pet_clair:4213:23564993,23528541:pet_clair:4213:23565393,23528542:pet_clair:4213:23535667,23528545:pet_clair:4213:23565849,23531052:pet_clair:4213:23531120,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0011212785263722681, 'nb_photo': 60, 'list_port_cont': '23524437,23533664,23552667,23564263,23564996,23617792,23617938,23618106,23618572,23655117,23656126,23656715,23657673,23657886,23658844,23700777,23702124,23702478,23735467,23759653,23760918,23763856,23796610,23806151,23840911,23919827,23933882,23965636,24046112,24129255,24129994,24134340,24161519,24163321,24165720,24165955,24166454,24166581,24168576,24168650,24176312,24250017,24255353,24256462,24262006,24271860,24281404,24306963,24307572,24327493,24328354,24328535,24366956,24380941,24386259', 'assoc_port': '23522763:23524437,23528535:23564263,23528538:23564996,23533542:23533664,23552597:23552667,23607561:23617792,23607562:23617938,23607563:23618106,23607565:23618572,23650227:23655117,23650235:23656126,23650239:23656715,23650247:23657673,23650249:23657886,23650255:23658844,23681639:23702124,23681655:23702478,23696932:23700777,23710958:23735467,23757466:23759653,23757477:23760918,23762886:23763856,23784541:23796610,23804738:23806151,23829030:23840911,23905500:23919827,23910715:24046112,23930266:23933882,23935739:24134340,23965308:23965636,23996189:24129255,23996203:24129994,24045433:24161519,24046073:24163321,24066179:24168650,24067523:24168576,24107069:24166581,24113564:24166454,24120852:24165955,24127998:24165720,24147434:24176312,24214840:24262006,24233573:24271860,24244699:24250017,24255298:24256462,24255307:24255353,24280692:24281404,24293648:24306963,24293674:24307572,24319315:24328354,24319316:24328535,24319322:24327493,24366928:24366956,24369383:24380941,24386075:24386259', 'assoc_mat': '23522763:pet_fonce:4213:23524437,23528535:pet_fonce:4213:23564263,23528538:pet_fonce:4213:23564996,23533542:pet_fonce:4213:23533664,23552597:pet_fonce:4213:23552667,23607561:pet_fonce:4213:23617792,23607562:pet_fonce:4213:23617938,23607563:pet_fonce:4213:23618106,23607565:pet_fonce:4213:23618572,23650227:pet_fonce:4213:23655117,23650235:pet_fonce:4213:23656126,23650239:pet_fonce:4213:23656715,23650247:pet_fonce:4213:23657673,23650249:pet_fonce:4213:23657886,23650255:pet_fonce:4213:23658844,23681639:pet_fonce:4213:23702124,23681655:pet_fonce:4213:23702478,23696932:pet_fonce:4213:23700777,23710958:pet_fonce:4213:23735467,23757466:pet_fonce:4213:23759653,23757477:pet_fonce:4213:23760918,23762886:pet_fonce:4213:23763856,23784541:pet_fonce:4213:23796610,23804738:pet_fonce:4213:23806151,23829030:pet_fonce:4213:23840911,23905500:pet_fonce:4213:23919827,23910715:pet_fonce:4213:24046112,23930266:pet_fonce:4213:23933882,23935739:pet_fonce:4213:24134340,23965308:pet_fonce:4213:23965636,23996189:pet_fonce:4213:24129255,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.01923337877777675, 'nb_photo': 1420, 'list_port_cont': '23522890,23523777,23523836,23523873,23523911,23523925,23523980,23524019,23524054,23524270,23524441,23524464,23524505,23524548,23524583,23524594,23524644,23524678,23524706,23524751,23524788,23524819,23531125,23533658,23535546,23535656,23538071,23540877,23542781,23550819,23552666,23561736,23564045,23565005,23565397,23565842,23571756,23573819,23573987,23574496,23575128,23579829,23580955,23582108,23607765,23607810,23608254,23608285,23608526,23612615,23612664,23612734,23617433,23617602,23617794,23617939,23618094,23618573,23618753,23619090,23619243,23619626,23620224,23620521,23620771,23654953,23655118,23655311,23655649,23655977,23656121,23656280,23656383,23656703,23656794,23656914,23657119,23657252,23657479,23657665,23657889,23658083,23658209,23658518,23658838,23661421,23671790,23674900,23677653,23678623,23678696,23680310,23680531,23680625,23680718,23680840,23681056,23685119,23685533,23688339,23689487,23695639,23700782,23702121,23702481,23702587,23707889,23708284,23709143,23713051,23713235,23713705,23713850,2371412', 'assoc_port': '23522746:23524819,23522747:23524788,23522749:23524751,23522750:23524706,23522752:23524678,23522754:23524644,23522755:23524594,23522757:23524583,23522758:23524548,23522760:23524505,23522761:23524464,23522763:23524441,23522765:23524270,23522770:23524054,23522772:23524019,23522773:23523925,23522775:23523980,23522776:23523911,23522778:23523873,23522780:23523836,23522781:23523777,23522783:23522890,23528533:23564045,23528537:23582108,23528538:23565005,23528541:23565397,23528542:23535656,23528545:23565842,23531052:23531125,23533542:23533658,23535502:23535546,23537991:23538071,23540447:23540877,23542731:23542781,23544363:23574496,23549062:23575128,23550736:23550819,23552597:23552666,23557577:23579829,23558791:23580955,23561654:23561736,23569326:23571756,23572297:23573987,23572298:23573819,23607559:23617433,23607560:23617602,23607561:23617794,23607562:23617939,23607563:23618094,23607565:23618573,23607566:23618753,23607579:23619090,23607580:23619243,23607593:23619626,23607595:23620224,23607596:23620521,23607597:2362077', 'assoc_mat': '23522746:pet_opaque:4213:23524819,23522747:pet_opaque:4213:23524788,23522749:pet_opaque:4213:23524751,23522750:pet_opaque:4213:23524706,23522752:pet_opaque:4213:23524678,23522754:pet_opaque:4213:23524644,23522755:pet_opaque:4213:23524594,23522757:pet_opaque:4213:23524583,23522758:pet_opaque:4213:23524548,23522760:pet_opaque:4213:23524505,23522761:pet_opaque:4213:23524464,23522763:pet_opaque:4213:23524441,23522765:pet_opaque:4213:23524270,23522770:pet_opaque:4213:23524054,23522772:pet_opaque:4213:23524019,23522773:pet_opaque:4213:23523925,23522775:pet_opaque:4213:23523980,23522776:pet_opaque:4213:23523911,23522778:pet_opaque:4213:23523873,23522780:pet_opaque:4213:23523836,23522781:pet_opaque:4213:23523777,23522783:pet_opaque:4213:23522890,23528533:pet_opaque:4213:23564045,23528537:pet_opaque:4213:23582108,23528538:pet_opaque:4213:23565005,23528541:pet_opaque:4213:23565397,23528542:pet_opaque:4213:23535656,23528545:pet_opaque:4213:23565842,23531052:pet_opaque:4213:23531125,23533542:pet_opaque:4213:23533658,2353'}), 'main_stat': {'nb_photos': 4150}}, 'hostname': (), 'impurety_average_per_hashtag': [(('refus', '2025-06', 0.11740310071622292),)]} VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3142 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3142 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3142 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3996 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3996 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3142 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3142 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3142 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3996 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3996 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3996 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((4150,),), 'unwanted_material_monthly_percentage': ((0.11740310071622292,),), 'material_repartition': (('refus', 4136),), 'material_dict': {'refus': 4136}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.09764013458454936, 144), (datetime.date(2025, 6, 2), 0.09700947581567364, 168), (datetime.date(2025, 6, 3), 0.09549968468018473, 175), (datetime.date(2025, 6, 4), 0.11335061399773634, 210), (datetime.date(2025, 6, 5), 0.10705816573809156, 163), (datetime.date(2025, 6, 6), 0.1243001734099041, 186), (datetime.date(2025, 6, 7), 0.1277670373445504, 146), (datetime.date(2025, 6, 8), 0.11836349211043481, 155), (datetime.date(2025, 6, 9), 0.11552411583336361, 176), (datetime.date(2025, 6, 10), 0.11582076809258976, 146), (datetime.date(2025, 6, 11), 0.10345655124878027, 113), (datetime.date(2025, 6, 12), 0.1135876578336189, 131), (datetime.date(2025, 6, 13), 0.1264451024841556, 181), (datetime.date(2025, 6, 14), 0.13110532688649665, 160), (datetime.date(2025, 6, 15), 0.12961385299285305, 126), (datetime.date(2025, 6, 16), 0.12843502026167786, 145), (datetime.date(2025, 6, 17), 0.1328281467636661, 236), (datetime.date(2025, 6, 18), 0.14101621299934947, 206), (datetime.date(2025, 6, 19), 0.11857992692943213, 118), (datetime.date(2025, 6, 20), 0.08690356986013789, 316), (datetime.date(2025, 6, 21), 0.12647990485717198, 110), (datetime.date(2025, 6, 22), 0.1256188598944305, 80), (datetime.date(2025, 6, 23), 0.11665685614011406, 86), (datetime.date(2025, 6, 24), 0.12223142141814167, 77), (datetime.date(2025, 6, 25), 0.1821410361546312, 149), (datetime.date(2025, 6, 26), 0.13157964553401008, 80), (datetime.date(2025, 6, 27), 0.1277478823441393, 74), (datetime.date(2025, 6, 28), 0.16118991070645042, 76), (datetime.date(2025, 6, 29), 0.10446927544879055, 3), (datetime.date(2025, 6, 30), 0.1211907791709157, 14)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 6, 1), 0.09764013458454936, 144), (datetime.date(2025, 6, 2), 0.09700947581567364, 168), (datetime.date(2025, 6, 3), 0.09549968468018473, 175), (datetime.date(2025, 6, 4), 0.11335061399773634, 210), (datetime.date(2025, 6, 5), 0.10705816573809156, 163), (datetime.date(2025, 6, 6), 0.1243001734099041, 186), (datetime.date(2025, 6, 7), 0.1277670373445504, 146), (datetime.date(2025, 6, 8), 0.11836349211043481, 155), (datetime.date(2025, 6, 9), 0.11552411583336361, 176), (datetime.date(2025, 6, 10), 0.11582076809258976, 146), (datetime.date(2025, 6, 11), 0.10345655124878027, 113), (datetime.date(2025, 6, 12), 0.1135876578336189, 131), (datetime.date(2025, 6, 13), 0.1264451024841556, 181), (datetime.date(2025, 6, 14), 0.13110532688649665, 160), (datetime.date(2025, 6, 15), 0.12961385299285305, 126), (datetime.date(2025, 6, 16), 0.12843502026167786, 145), (datetime.date(2025, 6, 17), 0.1328281467636661, 236), (datetime.date(2025, 6, 18), 0.14101621299934947, 206), (datetime.date(2025, 6, 19), 0.11857992692943213, 118), (datetime.date(2025, 6, 20), 0.08690356986013789, 316), (datetime.date(2025, 6, 21), 0.12647990485717198, 110), (datetime.date(2025, 6, 22), 0.1256188598944305, 80), (datetime.date(2025, 6, 23), 0.11665685614011406, 86), (datetime.date(2025, 6, 24), 0.12223142141814167, 77), (datetime.date(2025, 6, 25), 0.1821410361546312, 149), (datetime.date(2025, 6, 26), 0.13157964553401008, 80), (datetime.date(2025, 6, 27), 0.1277478823441393, 74), (datetime.date(2025, 6, 28), 0.16118991070645042, 76), (datetime.date(2025, 6, 29), 0.10446927544879055, 3), (datetime.date(2025, 6, 30), 0.1211907791709157, 14))}, 'quality_array': [['-1.851377213629873', '01062025'], ['-1.922687416076372', '02062025'], ['-1.8218615263804618', '03062025'], ['-1.747708826196408', '04062025'], ['-1.8276804916119347', '05062025'], ['-1.6005473188152182', '06062025'], ['-1.4601036486118417', '07062025'], ['-1.70145829811813', '08062025'], ['-1.72194882745701', '09062025'], ['-1.5910670479729168', '10062025'], ['-1.4690815496038887', '11062025'], ['-1.4859850337367007', '12062025'], ['-1.3791740816716502', '13062025'], ['-1.4022280943033008', '14062025'], ['-1.5444718323541442', '15062025'], ['-1.479816741997873', '16062025'], ['-2.6833552324053307', '17062025'], ['-1.866937173442209', '18062025'], ['-1.7262655169395345', '19062025'], ['-2.3983614465159144', '20062025'], ['-1.3215280145773418', '21062025'], ['-1.305873581942424', '22062025'], ['-1.2326800368857886', '23062025'], ['-1.319061957843241', '24062025'], ['-2.1690055748277977', '25062025'], ['-1.269803688707808', '26062025'], ['-1.1672421138254254', '27062025'], ['-1.7139662628381023', '28062025'], ['-4.70457832298741', '29062025'], ['-0.9301699618830553', '30062025']], 'number_of_batch': ((646,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.006287462861399552, 'nb_photo': 865, 'list_port_cont': '23522898,23523766,23523842,23523866,23523916,23523935,23523977,23524049,23524127,23524266,23524497,23524533,23524581,23524638,23524684,23524715,23524739,23524773,23524821,23531122,23533661,23535537,23535652,23538074,23540886,23550817,23552679,23561730,23564997,23565401,23565554,23573823,23573972,23574481,23575126,23579820,23580946,23582111,23607763,23608259,23608296,23608527,23612656,23612731,23617431,23617608,23617802,23617926,23618105,23618311,23618575,23618745,23619624,23619837,23620223,23620522,23620769,23655120,23655314,23655642,23655766,23655966,23656113,23656274,23656714,23656791,23656913,23657112,23657251,23657476,23657679,23657894,23658081,23658195,23658529,23658834,23661409,23671791,23674909,23677643,23678608,23678683,23680306,23680528,23680614,23680725,23680847,23681055,23685127,23685540,23688346,23689481,23695649,23700786,23702122,23702471,23702598,23702786,23707905,23708288,23709139,23713049,23713233,23713441,23713847,23714126,23715799,23718232,23720699,23720920,23726291,23726798,23728024,2373547', 'assoc_port': '23522746:23524821,23522747:23524773,23522749:23524739,23522750:23524715,23522752:23524684,23522754:23524638,23522757:23524581,23522758:23524533,23522760:23524497,23522765:23524266,23522769:23524127,23522770:23524049,23522773:23523935,23522775:23523977,23522776:23523916,23522778:23523866,23522780:23523842,23522781:23523766,23522783:23522898,23528537:23582111,23528538:23564997,23528541:23565401,23528542:23535652,23531052:23531122,23533542:23533661,23535502:23535537,23537991:23538074,23540447:23540886,23544363:23574481,23549062:23575126,23550736:23550817,23552597:23552679,23557577:23579820,23558791:23580946,23561654:23561730,23565491:23565554,23572297:23573972,23572298:23573823,23607559:23617431,23607560:23617608,23607561:23617802,23607562:23617926,23607563:23618105,23607564:23618311,23607565:23618575,23607566:23618745,23607593:23619624,23607594:23619837,23607595:23620223,23607596:23620522,23607597:23620769,23607598:23612731,23607599:23612656,23607601:23608527,23607602:23608296,23607603:23608259,23607606:2360776', 'assoc_mat': '23522746:barquette_opaque:4213:23524821,23522747:barquette_opaque:4213:23524773,23522749:barquette_opaque:4213:23524739,23522750:barquette_opaque:4213:23524715,23522752:barquette_opaque:4213:23524684,23522754:barquette_opaque:4213:23524638,23522757:barquette_opaque:4213:23524581,23522758:barquette_opaque:4213:23524533,23522760:barquette_opaque:4213:23524497,23522765:barquette_opaque:4213:23524266,23522769:barquette_opaque:4213:23524127,23522770:barquette_opaque:4213:23524049,23522773:barquette_opaque:4213:23523935,23522775:barquette_opaque:4213:23523977,23522776:barquette_opaque:4213:23523916,23522778:barquette_opaque:4213:23523866,23522780:barquette_opaque:4213:23523842,23522781:barquette_opaque:4213:23523766,23522783:barquette_opaque:4213:23522898,23528537:barquette_opaque:4213:23582111,23528538:barquette_opaque:4213:23564997,23528541:barquette_opaque:4213:23565401,23528542:barquette_opaque:4213:23535652,23531052:barquette_opaque:4213:23531122,23533542:barquette_opaque:4213:23533661,23535502:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036535090883231427, 'nb_photo': 864, 'list_port_cont': '23522893,23523763,23523871,23523915,23523978,23524048,23524279,23524469,23524570,23524642,23524677,23524714,23524740,23524787,23524806,23533665,23535532,23538075,23550820,23552670,23564039,23565406,23565836,23573816,23573979,23575119,23579830,23580959,23607749,23608219,23608286,23608535,23612668,23612730,23617441,23617805,23617928,23618107,23618566,23618744,23619075,23619631,23619828,23620219,23620528,23654963,23655111,23655306,23655651,23655756,23656114,23656279,23656382,23656701,23656786,23657671,23657891,23658832,23661423,23671794,23674903,23677654,23678622,23680305,23680536,23680617,23680720,23681060,23685126,23695656,23700773,23702482,23702599,23702776,23706872,23707892,23713053,23713243,23713431,23713692,23714127,23715795,23720933,23722766,23728027,23735466,23737839,23741724,23742902,23743218,23743294,23744016,23744553,23746547,23747156,23747264,23747340,23747444,23747878,23748225,23749004,23749769,23751724,23751789,23757799,23758290,23758540,23759766,23759976,23760312,23760770,23760904,23760945,2376098', 'assoc_port': '23522746:23524806,23522747:23524787,23522749:23524740,23522750:23524714,23522752:23524677,23522754:23524642,23522757:23524570,23522761:23524469,23522765:23524279,23522770:23524048,23522775:23523978,23522776:23523915,23522778:23523871,23522781:23523763,23522783:23522893,23528533:23564039,23528541:23565406,23528545:23565836,23533542:23533665,23535502:23535532,23537991:23538075,23549062:23575119,23550736:23550820,23552597:23552670,23557577:23579830,23558791:23580959,23572297:23573979,23572298:23573816,23607559:23617441,23607561:23617805,23607562:23617928,23607563:23618107,23607565:23618566,23607566:23618744,23607579:23619075,23607593:23619631,23607594:23619828,23607595:23620219,23607596:23620528,23607598:23612730,23607599:23612668,23607601:23608535,23607602:23608286,23607604:23608219,23607606:23607749,23650226:23654963,23650227:23655111,23650228:23655306,23650229:23678622,23650231:23655651,23650232:23655756,23650235:23656114,23650236:23656279,23650237:23656382,23650239:23656701,23650240:23656786,23650247:2365767', 'assoc_mat': '23522746:carton:4213:23524806,23522747:carton:4213:23524787,23522749:carton:4213:23524740,23522750:carton:4213:23524714,23522752:carton:4213:23524677,23522754:carton:4213:23524642,23522757:carton:4213:23524570,23522761:carton:4213:23524469,23522765:carton:4213:23524279,23522770:carton:4213:23524048,23522775:carton:4213:23523978,23522776:carton:4213:23523915,23522778:carton:4213:23523871,23522781:carton:4213:23523763,23522783:carton:4213:23522893,23528533:carton:4213:23564039,23528541:carton:4213:23565406,23528545:carton:4213:23565836,23533542:carton:4213:23533665,23535502:carton:4213:23535532,23537991:carton:4213:23538075,23549062:carton:4213:23575119,23550736:carton:4213:23550820,23552597:carton:4213:23552670,23557577:carton:4213:23579830,23558791:carton:4213:23580959,23572297:carton:4213:23573979,23572298:carton:4213:23573816,23607559:carton:4213:23617441,23607561:carton:4213:23617805,23607562:carton:4213:23617928,23607563:carton:4213:23618107,23607565:carton:4213:23618566,23607566:carton:4213:23618744,2360'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.007236471083612558, 'nb_photo': 348, 'list_port_cont': '23523976,23524577,23524686,23524746,23524776,23524810,23531132,23533660,23538073,23561733,23564031,23565403,23565843,23571747,23573827,23575118,23582106,23607755,23608284,23612661,23612733,23617440,23617597,23617929,23619085,23620228,23620520,23654961,23655123,23655302,23655646,23656129,23656284,23656707,23656793,23657256,23657477,23657885,23658524,23658835,23671795,23674913,23678615,23680312,23685133,23685534,23689490,23695637,23700783,23702601,23706886,23708275,23713037,23713241,23713442,23714135,23720927,23726811,23728028,23740315,23741735,23742908,23743227,23743288,23744005,23747153,23747886,23747954,23749778,23751722,23751786,23757795,23759419,23759897,23759968,23760506,23760757,23760910,23760952,23761096,23763688,23763742,23763855,23763947,23765236,23778119,23783169,23785094,23792686,23799215,23803012,23803407,23803439,23804975,23806155,23806323,23806489,23809210,23812216,23817450,23821674,23849743,23849904,23898844,23910463,23910525,23911864,23919764,23922728,23924444,23924521,23924532,23931691,2399566', 'assoc_port': '23522746:23524810,23522747:23524776,23522749:23524746,23522752:23524686,23522757:23524577,23522775:23523976,23528533:23564031,23528537:23582106,23528541:23565403,23528545:23565843,23531052:23531132,23533542:23533660,23537991:23538073,23549062:23575118,23561654:23561733,23569326:23571747,23572298:23573827,23607559:23617440,23607560:23617597,23607562:23617929,23607579:23619085,23607595:23620228,23607596:23620520,23607598:23612733,23607599:23612661,23607602:23608284,23607606:23607755,23650226:23654961,23650227:23655123,23650228:23655302,23650229:23678615,23650231:23655646,23650235:23656129,23650236:23656284,23650239:23656707,23650240:23656793,23650244:23657256,23650245:23657477,23650249:23657885,23650253:23658524,23650255:23658835,23663342:23680312,23666428:23695637,23671701:23671795,23674765:23674913,23681658:23702601,23681659:23726811,23683965:23685534,23685096:23685133,23689436:23689490,23696926:23713037,23696929:23713241,23696932:23700783,23696949:23713442,23696967:23714135,23702424:23720927,23706699:2370688', 'assoc_mat': '23522746:ela:4213:23524810,23522747:ela:4213:23524776,23522749:ela:4213:23524746,23522752:ela:4213:23524686,23522757:ela:4213:23524577,23522775:ela:4213:23523976,23528533:ela:4213:23564031,23528537:ela:4213:23582106,23528541:ela:4213:23565403,23528545:ela:4213:23565843,23531052:ela:4213:23531132,23533542:ela:4213:23533660,23537991:ela:4213:23538073,23549062:ela:4213:23575118,23561654:ela:4213:23561733,23569326:ela:4213:23571747,23572298:ela:4213:23573827,23607559:ela:4213:23617440,23607560:ela:4213:23617597,23607562:ela:4213:23617929,23607579:ela:4213:23619085,23607595:ela:4213:23620228,23607596:ela:4213:23620520,23607598:ela:4213:23612733,23607599:ela:4213:23612661,23607602:ela:4213:23608284,23607606:ela:4213:23607755,23650226:ela:4213:23654961,23650227:ela:4213:23655123,23650228:ela:4213:23655302,23650229:ela:4213:23678615,23650231:ela:4213:23655646,23650235:ela:4213:23656129,23650236:ela:4213:23656284,23650239:ela:4213:23656707,23650240:ela:4213:23656793,23650244:ela:4213:23657256,23650245:ela:4213:2365747'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0037714688878688835, 'nb_photo': 946, 'list_port_cont': '23522887,23523774,23523837,23523879,23523907,23523937,23523984,23524262,23524433,23524471,23524507,23524549,23524710,23524741,23524778,23524809,23531131,23533657,23535541,23535660,23538072,23540883,23542768,23550826,23552672,23564044,23565399,23565851,23571755,23573811,23574485,23575115,23579824,23580961,23582101,23607764,23607805,23608222,23608250,23608297,23608520,23612669,23617442,23617595,23617803,23617937,23618096,23618312,23618564,23618754,23619091,23619633,23620229,23620531,23620760,23654958,23655124,23655303,23655657,23655978,23656117,23656276,23656389,23656710,23656795,23657121,23657244,23657480,23657664,23657879,23658087,23658208,23658520,23658833,23661416,23671786,23674905,23677641,23678609,23678695,23680315,23680527,23680624,23680721,23681067,23685129,23685544,23688341,23689488,23695653,23700774,23702120,23702480,23702588,23702780,23706877,23707899,23713038,23713242,23714125,23715808,23718228,23720694,23720932,23726301,23726807,23728037,23735469,23737829,23741083,23742913,23743108,23743222,2374329', 'assoc_port': '23522746:23524809,23522747:23524778,23522749:23524741,23522750:23524710,23522758:23524549,23522760:23524507,23522761:23524471,23522763:23524433,23522765:23524262,23522773:23523937,23522775:23523984,23522776:23523907,23522778:23523879,23522780:23523837,23522781:23523774,23522783:23522887,23528533:23564044,23528537:23582101,23528541:23565399,23528542:23535660,23528545:23565851,23531052:23531131,23533542:23533657,23535502:23535541,23537991:23538072,23540447:23540883,23542731:23542768,23544363:23574485,23549062:23575115,23550736:23550826,23552597:23552672,23557577:23579824,23558791:23580961,23569326:23571755,23572298:23573811,23607559:23617442,23607560:23617595,23607561:23617803,23607562:23617937,23607563:23618096,23607564:23618312,23607565:23618564,23607566:23618754,23607579:23619091,23607593:23619633,23607595:23620229,23607596:23620531,23607597:23620760,23607599:23612669,23607601:23608520,23607602:23608297,23607603:23608250,23607604:23608222,23607605:23607805,23607606:23607764,23650226:23654958,23650227:2365512', 'assoc_mat': '23522746:etiquette:4213:23524809,23522747:etiquette:4213:23524778,23522749:etiquette:4213:23524741,23522750:etiquette:4213:23524710,23522758:etiquette:4213:23524549,23522760:etiquette:4213:23524507,23522761:etiquette:4213:23524471,23522763:etiquette:4213:23524433,23522765:etiquette:4213:23524262,23522773:etiquette:4213:23523937,23522775:etiquette:4213:23523984,23522776:etiquette:4213:23523907,23522778:etiquette:4213:23523879,23522780:etiquette:4213:23523837,23522781:etiquette:4213:23523774,23522783:etiquette:4213:23522887,23528533:etiquette:4213:23564044,23528537:etiquette:4213:23582101,23528541:etiquette:4213:23565399,23528542:etiquette:4213:23535660,23528545:etiquette:4213:23565851,23531052:etiquette:4213:23531131,23533542:etiquette:4213:23533657,23535502:etiquette:4213:23535541,23537991:etiquette:4213:23538072,23540447:etiquette:4213:23540883,23542731:etiquette:4213:23542768,23544363:etiquette:4213:23574485,23549062:etiquette:4213:23575115,23550736:etiquette:4213:23550826,23552597:etiquette:4213:23552672,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.04624958927337406, 'nb_photo': 2554, 'list_port_cont': '23522903,23523762,23523833,23523904,23523921,23523973,23524012,23524053,23524125,23524276,23524435,23524468,23524499,23524536,23524579,23524676,23524713,23524750,23524785,23524817,23531123,23533666,23535533,23535661,23538085,23540881,23550828,23552668,23561734,23564029,23564994,23565394,23565845,23573812,23573974,23574493,23575129,23579827,23580950,23582102,23607753,23607798,23608216,23608244,23608289,23608528,23612658,23612727,23617435,23617793,23617933,23618095,23618319,23618562,23618747,23619089,23619251,23619619,23619839,23620233,23620529,23620761,23654956,23655114,23655312,23655650,23655768,23655975,23656273,23656375,23656716,23656799,23656923,23657117,23657249,23657676,23658080,23658197,23658527,23658847,23661414,23671792,23674915,23677650,23678620,23678686,23680307,23680537,23680611,23680712,23680845,23681061,23685130,23685541,23688343,23689483,23695641,23700784,23702113,23702474,23702590,23702781,23706888,23707893,23708278,23709150,23713039,23713246,23713445,23713843,23714133,23715800,23718230,2372069', 'assoc_port': '23522746:23524817,23522747:23524785,23522749:23524750,23522750:23524713,23522752:23524676,23522757:23524579,23522758:23524536,23522760:23524499,23522761:23524468,23522763:23524435,23522765:23524276,23522769:23524125,23522770:23524053,23522772:23524012,23522773:23523921,23522775:23523973,23522776:23523904,23522780:23523833,23522781:23523762,23522783:23522903,23528533:23564029,23528537:23582102,23528538:23564994,23528541:23565394,23528542:23535661,23528545:23565845,23531052:23531123,23533542:23533666,23535502:23535533,23537991:23538085,23540447:23540881,23544363:23574493,23549062:23575129,23550736:23550828,23552597:23552668,23557577:23579827,23558791:23580950,23561654:23561734,23572297:23573974,23572298:23573812,23607559:23617435,23607561:23617793,23607562:23617933,23607563:23618095,23607564:23618319,23607565:23618562,23607566:23618747,23607579:23619089,23607580:23619251,23607593:23619619,23607594:23619839,23607595:23620233,23607596:23620529,23607597:23620761,23607598:23612727,23607599:23612658,23607601:2360852', 'assoc_mat': '23522746:film_plastique:4213:23524817,23522747:film_plastique:4213:23524785,23522749:film_plastique:4213:23524750,23522750:film_plastique:4213:23524713,23522752:film_plastique:4213:23524676,23522757:film_plastique:4213:23524579,23522758:film_plastique:4213:23524536,23522760:film_plastique:4213:23524499,23522761:film_plastique:4213:23524468,23522763:film_plastique:4213:23524435,23522765:film_plastique:4213:23524276,23522769:film_plastique:4213:23524125,23522770:film_plastique:4213:23524053,23522772:film_plastique:4213:23524012,23522773:film_plastique:4213:23523921,23522775:film_plastique:4213:23523973,23522776:film_plastique:4213:23523904,23522780:film_plastique:4213:23523833,23522781:film_plastique:4213:23523762,23522783:film_plastique:4213:23522903,23528533:film_plastique:4213:23564029,23528537:film_plastique:4213:23582102,23528538:film_plastique:4213:23564994,23528541:film_plastique:4213:23565394,23528542:film_plastique:4213:23535661,23528545:film_plastique:4213:23565845,23531052:film_plastique:4213:2353112'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0017249569756832373, 'nb_photo': 12, 'list_port_cont': '23550831,23607750,23618571,23702602,23747195,23764088,24094040,24164590,24251633,24327548,24385597,24385949', 'assoc_port': '23550736:23550831,23607565:23618571,23607606:23607750,23681658:23702602,23739325:23747195,23762892:23764088,23972610:24094040,24046082:24164590,24239569:24251633,24319320:24327548,24385134:24385597,24385925:24385949', 'assoc_mat': '23550736:kraft:4213:23550831,23607565:kraft:4213:23618571,23607606:kraft:4213:23607750,23681658:kraft:4213:23702602,23739325:kraft:4213:23747195,23762892:kraft:4213:23764088,23972610:kraft:4213:24094040,24046082:kraft:4213:24164590,24239569:kraft:4213:24251633,24319320:kraft:4213:24327548,24385134:kraft:4213:24385597,24385925:kraft:4213:24385949'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004199811899604449, 'nb_photo': 1419, 'list_port_cont': '23522891,23523776,23523843,23523882,23523909,23523919,23523986,23524013,23524044,23524115,23524171,23524272,23524428,23524475,23524539,23524571,23524643,23524705,23524747,23524783,23524815,23531117,23533672,23535544,23535662,23538070,23540880,23542776,23550825,23561739,23564038,23564252,23564998,23565840,23573814,23573975,23574495,23575124,23580948,23582096,23607751,23607795,23608218,23608290,23608522,23612607,23612671,23612729,23617437,23617801,23617927,23618100,23618565,23618748,23619080,23619259,23619632,23619829,23620232,23620527,23620762,23654957,23655125,23655317,23655655,23655971,23656282,23656708,23656792,23657109,23657245,23657675,23658085,23658515,23658843,23661422,23674908,23678621,23678681,23680313,23680535,23680612,23680719,23681058,23685124,23685530,23688330,23695651,23700779,23702118,23702485,23702600,23702789,23706875,23707896,23708279,23713048,23713244,23713432,23713851,23714121,23715801,23720921,23722767,23726799,23728030,23735468,23737826,23740310,23741081,23741727,23742383,23742900,2374311', 'assoc_port': '23522746:23524815,23522747:23524783,23522749:23524747,23522750:23524705,23522754:23524643,23522757:23524571,23522758:23524539,23522761:23524475,23522763:23524428,23522765:23524272,23522767:23524171,23522769:23524115,23522770:23524044,23522772:23524013,23522773:23523919,23522775:23523986,23522776:23523909,23522778:23523882,23522780:23523843,23522781:23523776,23522783:23522891,23528533:23564038,23528535:23564252,23528537:23582096,23528538:23564998,23528542:23535662,23528545:23565840,23531052:23531117,23533542:23533672,23535502:23535544,23537991:23538070,23540447:23540880,23542731:23542776,23544363:23574495,23549062:23575124,23550736:23550825,23558791:23580948,23561654:23561739,23572297:23573975,23572298:23573814,23607559:23617437,23607561:23617801,23607562:23617927,23607563:23618100,23607565:23618565,23607566:23618748,23607579:23619080,23607580:23619259,23607593:23619632,23607594:23619829,23607595:23620232,23607596:23620527,23607597:23620762,23607598:23612729,23607599:23612671,23607600:23612607,23607601:2360852', 'assoc_mat': '23522746:metal:4213:23524815,23522747:metal:4213:23524783,23522749:metal:4213:23524747,23522750:metal:4213:23524705,23522754:metal:4213:23524643,23522757:metal:4213:23524571,23522758:metal:4213:23524539,23522761:metal:4213:23524475,23522763:metal:4213:23524428,23522765:metal:4213:23524272,23522767:metal:4213:23524171,23522769:metal:4213:23524115,23522770:metal:4213:23524044,23522772:metal:4213:23524013,23522773:metal:4213:23523919,23522775:metal:4213:23523986,23522776:metal:4213:23523909,23522778:metal:4213:23523882,23522780:metal:4213:23523843,23522781:metal:4213:23523776,23522783:metal:4213:23522891,23528533:metal:4213:23564038,23528535:metal:4213:23564252,23528537:metal:4213:23582096,23528538:metal:4213:23564998,23528542:metal:4213:23535662,23528545:metal:4213:23565840,23531052:metal:4213:23531117,23533542:metal:4213:23533672,23535502:metal:4213:23535544,23537991:metal:4213:23538070,23540447:metal:4213:23540880,23542731:metal:4213:23542776,23544363:metal:4213:23574495,23549062:metal:4213:23575124,23550736:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.054599943863049914, 'nb_photo': 4690, 'list_port_cont': '23522899,23523775,23523834,23523872,23523917,23523931,23523974,23524015,23524046,23524128,23524177,23524274,23524438,23524502,23524540,23524578,23524612,23524647,23524674,23524711,23524748,23524782,23524816,23531119,23533667,23535542,23535654,23538084,23540882,23550829,23552665,23561732,23564040,23564991,23565564,23565852,23571749,23573826,23573973,23574497,23575131,23580960,23582110,23607761,23607804,23608207,23608532,23612663,23612724,23617436,23617795,23617936,23618097,23618304,23618561,23618757,23619079,23619245,23619622,23619841,23620222,23620525,23620773,23654949,23655113,23655304,23655643,23655968,23656128,23656269,23656704,23656798,23656920,23657111,23657260,23657472,23657672,23657895,23658082,23658205,23658530,23658841,23661408,23671783,23674912,23677638,23678610,23678685,23680316,23680533,23680618,23680710,23680846,23681059,23685128,23685542,23688338,23689478,23695650,23700781,23702475,23702594,23702774,23706878,23707897,23708283,23709137,23713040,23713234,23713444,23713700,23714122,23715797,2371823', 'assoc_port': '23522746:23524816,23522747:23524782,23522749:23524748,23522750:23524711,23522752:23524674,23522754:23524647,23522755:23524612,23522757:23524578,23522758:23524540,23522760:23524502,23522763:23524438,23522765:23524274,23522767:23524177,23522769:23524128,23522770:23524046,23522772:23524015,23522773:23523931,23522775:23523974,23522776:23523917,23522778:23523872,23522780:23523834,23522781:23523775,23522783:23522899,23528533:23564040,23528537:23582110,23528538:23564991,23528542:23535654,23528545:23565852,23531052:23531119,23533542:23533667,23535502:23535542,23537991:23538084,23540447:23540882,23544363:23574497,23549062:23575131,23550736:23550829,23552597:23552665,23558791:23580960,23561654:23561732,23565491:23565564,23569326:23571749,23572297:23573973,23572298:23573826,23607559:23617436,23607561:23617795,23607562:23617936,23607563:23618097,23607564:23618304,23607565:23618561,23607566:23618757,23607579:23619079,23607580:23619245,23607593:23619622,23607594:23619841,23607595:23620222,23607596:23620525,23607597:2362077', 'assoc_mat': '23522746:papier:4213:23524816,23522747:papier:4213:23524782,23522749:papier:4213:23524748,23522750:papier:4213:23524711,23522752:papier:4213:23524674,23522754:papier:4213:23524647,23522755:papier:4213:23524612,23522757:papier:4213:23524578,23522758:papier:4213:23524540,23522760:papier:4213:23524502,23522763:papier:4213:23524438,23522765:papier:4213:23524274,23522767:papier:4213:23524177,23522769:papier:4213:23524128,23522770:papier:4213:23524046,23522772:papier:4213:23524015,23522773:papier:4213:23523931,23522775:papier:4213:23523974,23522776:papier:4213:23523917,23522778:papier:4213:23523872,23522780:papier:4213:23523834,23522781:papier:4213:23523775,23522783:papier:4213:23522899,23528533:papier:4213:23564040,23528537:papier:4213:23582110,23528538:papier:4213:23564991,23528542:papier:4213:23535654,23528545:papier:4213:23565852,23531052:papier:4213:23531119,23533542:papier:4213:23533667,23535502:papier:4213:23535542,23537991:papier:4213:23538084,23540447:papier:4213:23540882,23544363:papier:4213:23574497,2354'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.006683358409303269, 'nb_photo': 77, 'list_port_cont': '23535534,23550832,23552681,23565004,23580952,23656387,23657250,23657469,23658522,23658836,23680848,23689492,23706879,23713245,23713694,23726303,23726812,23741728,23743113,23743217,23747410,23757789,23761010,23761178,23763677,23796604,23850006,23898835,23911871,23919763,23931676,24018488,24089915,24092243,24094052,24115652,24116255,24132546,24134295,24135971,24161402,24161919,24162051,24162982,24164888,24164944,24165778,24167756,24167874,24170291,24171101,24173803,24176304,24178851,24261998,24262773,24263642,24264641,24279935,24284626,24284800,24308270,24325424,24328361,24328541,24342479,24361977,24390726,24409243', 'assoc_port': '23528538:23565004,23535502:23535534,23550736:23550832,23552597:23552681,23558791:23580952,23650237:23656387,23650244:23657250,23650245:23657469,23650253:23658522,23650255:23658836,23663350:23680848,23681640:23726303,23681659:23726812,23689436:23689492,23696929:23713245,23696962:23713694,23706699:23706879,23731743:23743217,23739331:23747410,23741717:23741728,23743106:23743113,23757453:23757789,23757463:23761178,23757480:23761010,23762885:23763677,23784541:23796604,23845232:23850006,23896955:23911871,23898784:23898835,23905499:23919763,23931619:23931676,23935735:24134295,23935757:24135971,23961893:24089915,23966881:24092243,23972610:24094052,23979656:24115652,23983414:24116255,23998044:24132546,24017357:24018488,24045430:24161402,24045431:24170291,24045434:24161919,24045437:24162051,24046045:24162982,24046085:24164944,24084320:24167874,24084324:24167756,24124700:24165778,24147434:24176304,24147436:24164888,24170336:24171101,24173747:24173803,24178811:24178851,24214840:24261998,24222024:24263642,24230040:2426464', 'assoc_mat': '23528538:pehd:4213:23565004,23535502:pehd:4213:23535534,23550736:pehd:4213:23550832,23552597:pehd:4213:23552681,23558791:pehd:4213:23580952,23650237:pehd:4213:23656387,23650244:pehd:4213:23657250,23650245:pehd:4213:23657469,23650253:pehd:4213:23658522,23650255:pehd:4213:23658836,23663350:pehd:4213:23680848,23681640:pehd:4213:23726303,23681659:pehd:4213:23726812,23689436:pehd:4213:23689492,23696929:pehd:4213:23713245,23696962:pehd:4213:23713694,23706699:pehd:4213:23706879,23731743:pehd:4213:23743217,23739331:pehd:4213:23747410,23741717:pehd:4213:23741728,23743106:pehd:4213:23743113,23757453:pehd:4213:23757789,23757463:pehd:4213:23761178,23757480:pehd:4213:23761010,23762885:pehd:4213:23763677,23784541:pehd:4213:23796604,23845232:pehd:4213:23850006,23896955:pehd:4213:23911871,23898784:pehd:4213:23898835,23905499:pehd:4213:23919763,23931619:pehd:4213:23931676,23935735:pehd:4213:24134295,23935757:pehd:4213:24135971,23961893:pehd:4213:24089915,23966881:pehd:4213:24092243,23972610:pehd:4213:24094052,23979656:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.021785006676431913, 'nb_photo': 3238, 'list_port_cont': '23522888,23523765,23523844,23523868,23523910,23523929,23523983,23524016,23524042,23524121,23524278,23524436,23524470,23524503,23524545,23524568,23524606,23524639,23524683,23524719,23524743,23524777,23524808,23531120,23533663,23535535,23535667,23538076,23540888,23542779,23550822,23552680,23561725,23564043,23564253,23564993,23565393,23565560,23565849,23571745,23573818,23573986,23574492,23575121,23579823,23580957,23582100,23607756,23607808,23608220,23608255,23608294,23608523,23612601,23612655,23612721,23617432,23617596,23617798,23617932,23618103,23618314,23618574,23618751,23619081,23619248,23619628,23619827,23620221,23620519,23620772,23654954,23655110,23655318,23655648,23655972,23656120,23656271,23656379,23656705,23656784,23656925,23657113,23657257,23657471,23657670,23657881,23658086,23658199,23658526,23658837,23661412,23671789,23674902,23677646,23678619,23678684,23680308,23680530,23680626,23680722,23680856,23681064,23685120,23685539,23688337,23689485,23695643,23700775,23702114,23702476,23702596,23702790,2370688', 'assoc_port': '23522746:23524808,23522747:23524777,23522749:23524743,23522750:23524719,23522752:23524683,23522754:23524639,23522755:23524606,23522757:23524568,23522758:23524545,23522760:23524503,23522761:23524470,23522763:23524436,23522765:23524278,23522769:23524121,23522770:23524042,23522772:23524016,23522773:23523929,23522775:23523983,23522776:23523910,23522778:23523868,23522780:23523844,23522781:23523765,23522783:23522888,23528533:23564043,23528535:23564253,23528537:23582100,23528538:23564993,23528541:23565393,23528542:23535667,23528545:23565849,23531052:23531120,23533542:23533663,23535502:23535535,23537991:23538076,23540447:23540888,23542731:23542779,23544363:23574492,23549062:23575121,23550736:23550822,23552597:23552680,23557577:23579823,23558791:23580957,23561654:23561725,23565491:23565560,23569326:23571745,23572297:23573986,23572298:23573818,23607559:23617432,23607560:23617596,23607561:23617798,23607562:23617932,23607563:23618103,23607564:23618314,23607565:23618574,23607566:23618751,23607579:23619081,23607580:2361924', 'assoc_mat': '23522746:pet_clair:4213:23524808,23522747:pet_clair:4213:23524777,23522749:pet_clair:4213:23524743,23522750:pet_clair:4213:23524719,23522752:pet_clair:4213:23524683,23522754:pet_clair:4213:23524639,23522755:pet_clair:4213:23524606,23522757:pet_clair:4213:23524568,23522758:pet_clair:4213:23524545,23522760:pet_clair:4213:23524503,23522761:pet_clair:4213:23524470,23522763:pet_clair:4213:23524436,23522765:pet_clair:4213:23524278,23522769:pet_clair:4213:23524121,23522770:pet_clair:4213:23524042,23522772:pet_clair:4213:23524016,23522773:pet_clair:4213:23523929,23522775:pet_clair:4213:23523983,23522776:pet_clair:4213:23523910,23522778:pet_clair:4213:23523868,23522780:pet_clair:4213:23523844,23522781:pet_clair:4213:23523765,23522783:pet_clair:4213:23522888,23528533:pet_clair:4213:23564043,23528535:pet_clair:4213:23564253,23528537:pet_clair:4213:23582100,23528538:pet_clair:4213:23564993,23528541:pet_clair:4213:23565393,23528542:pet_clair:4213:23535667,23528545:pet_clair:4213:23565849,23531052:pet_clair:4213:23531120,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0011212785263722681, 'nb_photo': 60, 'list_port_cont': '23524437,23533664,23552667,23564263,23564996,23617792,23617938,23618106,23618572,23655117,23656126,23656715,23657673,23657886,23658844,23700777,23702124,23702478,23735467,23759653,23760918,23763856,23796610,23806151,23840911,23919827,23933882,23965636,24046112,24129255,24129994,24134340,24161519,24163321,24165720,24165955,24166454,24166581,24168576,24168650,24176312,24250017,24255353,24256462,24262006,24271860,24281404,24306963,24307572,24327493,24328354,24328535,24366956,24380941,24386259', 'assoc_port': '23522763:23524437,23528535:23564263,23528538:23564996,23533542:23533664,23552597:23552667,23607561:23617792,23607562:23617938,23607563:23618106,23607565:23618572,23650227:23655117,23650235:23656126,23650239:23656715,23650247:23657673,23650249:23657886,23650255:23658844,23681639:23702124,23681655:23702478,23696932:23700777,23710958:23735467,23757466:23759653,23757477:23760918,23762886:23763856,23784541:23796610,23804738:23806151,23829030:23840911,23905500:23919827,23910715:24046112,23930266:23933882,23935739:24134340,23965308:23965636,23996189:24129255,23996203:24129994,24045433:24161519,24046073:24163321,24066179:24168650,24067523:24168576,24107069:24166581,24113564:24166454,24120852:24165955,24127998:24165720,24147434:24176312,24214840:24262006,24233573:24271860,24244699:24250017,24255298:24256462,24255307:24255353,24280692:24281404,24293648:24306963,24293674:24307572,24319315:24328354,24319316:24328535,24319322:24327493,24366928:24366956,24369383:24380941,24386075:24386259', 'assoc_mat': '23522763:pet_fonce:4213:23524437,23528535:pet_fonce:4213:23564263,23528538:pet_fonce:4213:23564996,23533542:pet_fonce:4213:23533664,23552597:pet_fonce:4213:23552667,23607561:pet_fonce:4213:23617792,23607562:pet_fonce:4213:23617938,23607563:pet_fonce:4213:23618106,23607565:pet_fonce:4213:23618572,23650227:pet_fonce:4213:23655117,23650235:pet_fonce:4213:23656126,23650239:pet_fonce:4213:23656715,23650247:pet_fonce:4213:23657673,23650249:pet_fonce:4213:23657886,23650255:pet_fonce:4213:23658844,23681639:pet_fonce:4213:23702124,23681655:pet_fonce:4213:23702478,23696932:pet_fonce:4213:23700777,23710958:pet_fonce:4213:23735467,23757466:pet_fonce:4213:23759653,23757477:pet_fonce:4213:23760918,23762886:pet_fonce:4213:23763856,23784541:pet_fonce:4213:23796610,23804738:pet_fonce:4213:23806151,23829030:pet_fonce:4213:23840911,23905500:pet_fonce:4213:23919827,23910715:pet_fonce:4213:24046112,23930266:pet_fonce:4213:23933882,23935739:pet_fonce:4213:24134340,23965308:pet_fonce:4213:23965636,23996189:pet_fonce:4213:24129255,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.01923337877777675, 'nb_photo': 1420, 'list_port_cont': '23522890,23523777,23523836,23523873,23523911,23523925,23523980,23524019,23524054,23524270,23524441,23524464,23524505,23524548,23524583,23524594,23524644,23524678,23524706,23524751,23524788,23524819,23531125,23533658,23535546,23535656,23538071,23540877,23542781,23550819,23552666,23561736,23564045,23565005,23565397,23565842,23571756,23573819,23573987,23574496,23575128,23579829,23580955,23582108,23607765,23607810,23608254,23608285,23608526,23612615,23612664,23612734,23617433,23617602,23617794,23617939,23618094,23618573,23618753,23619090,23619243,23619626,23620224,23620521,23620771,23654953,23655118,23655311,23655649,23655977,23656121,23656280,23656383,23656703,23656794,23656914,23657119,23657252,23657479,23657665,23657889,23658083,23658209,23658518,23658838,23661421,23671790,23674900,23677653,23678623,23678696,23680310,23680531,23680625,23680718,23680840,23681056,23685119,23685533,23688339,23689487,23695639,23700782,23702121,23702481,23702587,23707889,23708284,23709143,23713051,23713235,23713705,23713850,2371412', 'assoc_port': '23522746:23524819,23522747:23524788,23522749:23524751,23522750:23524706,23522752:23524678,23522754:23524644,23522755:23524594,23522757:23524583,23522758:23524548,23522760:23524505,23522761:23524464,23522763:23524441,23522765:23524270,23522770:23524054,23522772:23524019,23522773:23523925,23522775:23523980,23522776:23523911,23522778:23523873,23522780:23523836,23522781:23523777,23522783:23522890,23528533:23564045,23528537:23582108,23528538:23565005,23528541:23565397,23528542:23535656,23528545:23565842,23531052:23531125,23533542:23533658,23535502:23535546,23537991:23538071,23540447:23540877,23542731:23542781,23544363:23574496,23549062:23575128,23550736:23550819,23552597:23552666,23557577:23579829,23558791:23580955,23561654:23561736,23569326:23571756,23572297:23573987,23572298:23573819,23607559:23617433,23607560:23617602,23607561:23617794,23607562:23617939,23607563:23618094,23607565:23618573,23607566:23618753,23607579:23619090,23607580:23619243,23607593:23619626,23607595:23620224,23607596:23620521,23607597:2362077', 'assoc_mat': '23522746:pet_opaque:4213:23524819,23522747:pet_opaque:4213:23524788,23522749:pet_opaque:4213:23524751,23522750:pet_opaque:4213:23524706,23522752:pet_opaque:4213:23524678,23522754:pet_opaque:4213:23524644,23522755:pet_opaque:4213:23524594,23522757:pet_opaque:4213:23524583,23522758:pet_opaque:4213:23524548,23522760:pet_opaque:4213:23524505,23522761:pet_opaque:4213:23524464,23522763:pet_opaque:4213:23524441,23522765:pet_opaque:4213:23524270,23522770:pet_opaque:4213:23524054,23522772:pet_opaque:4213:23524019,23522773:pet_opaque:4213:23523925,23522775:pet_opaque:4213:23523980,23522776:pet_opaque:4213:23523911,23522778:pet_opaque:4213:23523873,23522780:pet_opaque:4213:23523836,23522781:pet_opaque:4213:23523777,23522783:pet_opaque:4213:23522890,23528533:pet_opaque:4213:23564045,23528537:pet_opaque:4213:23582108,23528538:pet_opaque:4213:23565005,23528541:pet_opaque:4213:23565397,23528542:pet_opaque:4213:23535656,23528545:pet_opaque:4213:23565842,23531052:pet_opaque:4213:23531125,23533542:pet_opaque:4213:23533658,2353'}), 'main_stat': {'nb_photos': 4150}}, 'hostname': (), 'impurety_average_per_hashtag': [(('refus', '2025-06', 0.11740310071622292),)]} filepath : /data_4/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_06_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'refus': {'barquette_opaque': ['barquette_opaque', '0.63%', 865], 'carton': ['carton', '0.37%', 864], 'ela': ['ela', '0.72%', 348], 'etiquette': ['etiquette', '0.38%', 946], 'film_plastique': ['film_plastique', '4.62%', 2554], 'kraft': ['kraft', '0.17%', 12], 'metal': ['metal', '0.42%', 1419], 'papier': ['papier', '5.46%', 4690], 'pehd': ['pehd', '0.67%', 77], 'pet_clair': ['pet_clair', '2.18%', 3238], 'pet_fonce': ['pet_fonce', '0.11%', 60], 'pet_opaque': ['pet_opaque', '1.92%', 1420]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_06_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/refus_amiens 2.99user 2.53system 0:09.86elapsed 56%CPU (0avgtext+0avgdata 195968maxresident)k 4288inputs+608outputs (0major+76456minor)pagefaults 0swaps