python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --job=sla_mensuel --raspi=20062 --dashboard_places=arc_en_ciel_jrm_peu_dense --rootfolder_sla=/data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense -v --mtr_id=979 --date=`date -d"$nowdate 15 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : 20062, Date : 2025-04 _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 : (1, 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 ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3385 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3385 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="arc_en_ciel_jrm_peu_dense"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3385 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3385 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (1, 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 ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3385 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3385 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="arc_en_ciel_jrm_peu_dense"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3385 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3385 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 25 month : 04 mtr_id : 979 dashboard_places : arc_en_ciel_jrm_peu_dense date : 2025-04 year : 2025 raspi : 20062 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'arc_en_ciel_jrm_peu_dense' and date like '%2025-04%') and created_at like '%2025-04%'))); nb_day : (1, 30) after unwanted_material_data nb_day : (1, 30) SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%20062%' AND ms.result_str like '%2025/04%'ORDER BY ms.id desc LIMIT 0, 1000000; Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-04-01 00:00:00,2025-04-02 00:00:00,2025-04-03 00:00:00,2025-04-04 00:00:00,2025-04-05 00:00:00,2025-04-07 00:00:00,2025-04-08 00:00:00,2025-04-09 00:00:00,2025-04-10 00:00:00,2025-04-11 00:00:00,2025-04-12 00:00:00,2025-04-14 00:00:00,2025-04-15 00:00:00,2025-04-16 00:00:00,2025-04-17 00:00:00,2025-04-18 00:00:00,2025-04-19 00:00:00,2025-04-21 00:00:00,2025-04-22 00:00:00,2025-04-23 00:00:00,2025-04-24 00:00:00,2025-04-25 00:00:00,2025-04-26 00:00:00,2025-04-28 00:00:00,2025-04-29 00:00:00,2025-04-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 = 25 and month(ded.date) = 04 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______JRM' and ded.dashboard_place_id = 25 and month(ded.date) = 04 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 25 and mp.name like '%042025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-04-01 : dt_date_just_month_year : 2025-04-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "arc_en_ciel_jrm_peu_dense" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-04-01" AND ded.date <= "2025-04-30" apple3 {'JRM': {'mat': 'JRM', 'pht': 3726, 'datou_carac_id': 3459, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'papier,background'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1720894,1720986,1721940,1725912,1729831,1733782,1738356,1740096,1744187,1748245,1752284,1756173,1761419,1761359,1765758,1770227) AND dr.mtr_portfolio_id=ptp.mtr_portfolio_id_1 AND dr.qualite >= 0 AND mpp.mtr_portfolio_id=ptp.mtr_portfolio_id_2 AND pcr.portfolio_id=ptp.mtr_portfolio_id_1 AND h.hashtag_id = pcr.hashtag_id AND ptp.type = pcr.hashtag_type AND mpp.hide_status = 0 AND ptp.hashtag_id=h.hashtag_id group by h.hashtag, dr.hashtag, ptp.type; VR TODO TO BETTER PARSE ! ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008524882267818312, 'nb_photo': 676, 'list_port_cont': '21939545,21940717,21941543,21941820,21942333,21947417,21950744,21951845,21951935,21954229,21955604,21957893,21958538,21958918,21960451,21962177,21968911,21969990,21975108,21976851,21977983,21982545,21983807,21985209,21986011,21987850,21989076,21991135,21991509,21995234,21998695,21999729,22000580,22002061,22004929,22005596,22005846,22006942,22008909,22011970,22012769,22013954,22014124,22017021,22019540,22020260,22020359,22021607,22022296,22022722,22022791,22023010,22024078,22025731,22025841,22026173,22026305,22027516,22027856,22029641,22030398,22031708,22033108,22034118,22035872,22037562,22038454,22039871,22042051,22042312,22045436,22045445,22046271,22046810,22047492,22048177,22049992,22053599,22054158,22056961,22057233,22057447,22057796,22058401,22058629,22063444,22065423,22065860,22066455,22067525,22068617,22069585,22071241,22071721,22071757,22073844,22074822,22077680,22078638,22080010,22082002,22083655,22084874,22090325,22090479,22092301,22094684,22096744,22098480,22099846,22100784,22103779,22106508,2210666', 'assoc_port': '21937349:21942333,21939506:21939545,21940176:21941543,21940636:21940717,21941525:21941820,21947247:21947417,21950214:21950744,21951150:21951845,21951849:21951935,21952686:21954229,21954907:21962177,21954910:21960451,21955433:21955604,21956045:21958918,21957693:21957893,21958303:21958538,21968667:21968911,21969754:21969990,21972979:22058401,21972980:22058629,21972987:22057796,21972988:22057447,21972989:22057233,21972990:22011970,21972992:22008909,21973621:22006942,21973629:22005846,21973659:22005596,21973685:22004929,21973711:21976851,21974688:21975108,21977364:22002061,21977382:21977983,21977973:22000580,21981131:21983807,21982467:21982545,21984455:21999729,21984456:21986011,21985174:21985209,21987148:21998695,21987843:21987850,21988642:21989076,21991050:21991509,21991053:21991135,21994417:21995234,22012264:22056961,22012283:22029641,22012284:22012769,22013065:22013954,22013946:22014124,22015277:22027856,22016903:22017021,22018850:22024078,22018851:22020359,22019464:22019540,22020025:22020260,22021041:2202229', 'assoc_mat': '21937349:autre_refus:3726:21942333,21939506:autre_refus:3726:21939545,21940176:autre_refus:3726:21941543,21940636:autre_refus:3726:21940717,21941525:autre_refus:3726:21941820,21947247:autre_refus:3726:21947417,21950214:autre_refus:3726:21950744,21951150:autre_refus:3726:21951845,21951849:autre_refus:3726:21951935,21952686:autre_refus:3726:21954229,21954907:autre_refus:3726:21962177,21954910:autre_refus:3726:21960451,21955433:autre_refus:3726:21955604,21956045:autre_refus:3726:21958918,21957693:autre_refus:3726:21957893,21958303:autre_refus:3726:21958538,21968667:autre_refus:3726:21968911,21969754:autre_refus:3726:21969990,21972979:autre_refus:3726:22058401,21972980:autre_refus:3726:22058629,21972987:autre_refus:3726:22057796,21972988:autre_refus:3726:22057447,21972989:autre_refus:3726:22057233,21972990:autre_refus:3726:22011970,21972992:autre_refus:3726:22008909,21973621:autre_refus:3726:22006942,21973629:autre_refus:3726:22005846,21973659:autre_refus:3726:22005596,21973685:autre_refus:3726:22004929,21973711:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007375532261292248, 'nb_photo': 1400, 'list_port_cont': '21938264,21938897,21939536,21940715,21941546,21941831,21942022,21942332,21946096,21946390,21946882,21947415,21947596,21949026,21949048,21949147,21950742,21951423,21951847,21951944,21954221,21956836,21957513,21957892,21958532,21958923,21960449,21961641,21962173,21962432,21968711,21968914,21969988,21971187,21971336,21973227,21975106,21976857,21977976,21979159,21981816,21982535,21983806,21984627,21985204,21987353,21987852,21987902,21989080,21989459,21990102,21991508,21992037,21993219,21993787,21995229,21995339,21996046,21998702,21999725,22004932,22005595,22005732,22006941,22007614,22008343,22009742,22010966,22011975,22012770,22013955,22014119,22015897,22016562,22017027,22019011,22019537,22020261,22020362,22021610,22022292,22022718,22022799,22023008,22024081,22025217,22025639,22025732,22025850,22026170,22026296,22026780,22027240,22027354,22027508,22027847,22029643,22030401,22031155,22031701,22033109,22035877,22037564,22038457,22039872,22040394,22042055,22042891,22043781,22045439,22045448,22046265,22046813,2204749', 'assoc_port': '21937349:21942332,21938146:21938264,21938516:21938897,21939506:21939536,21940176:21941546,21940636:21940715,21941523:21942022,21941525:21941831,21946003:21946096,21946268:21946390,21946647:21946882,21947247:21947415,21947539:21947596,21949002:21949048,21949015:21949147,21949016:21949026,21950214:21950742,21951150:21951847,21951151:21951423,21951849:21951944,21952686:21954221,21954907:21962173,21954908:21962432,21954909:21961641,21954910:21960449,21956045:21958923,21956486:21956836,21957159:21957513,21957693:21957892,21958303:21958532,21968666:21968711,21968667:21968914,21969242:22058860,21969754:21969988,21970480:21971336,21971138:21971187,21972980:22058621,21972981:22058146,21972983:22057955,21972984:22057887,21972985:22057620,21972988:22057449,21972990:22011975,21973005:22009742,21973006:22008343,21973008:21973227,21973619:22007614,21973621:22006941,21973657:22005732,21973659:22005595,21973685:22004932,21973711:21976857,21974688:21975106,21977382:21977976,21979049:21979159,21981131:21983806,21981750:2198181', 'assoc_mat': '21937349:cartonnette:3726:21942332,21938146:cartonnette:3726:21938264,21938516:cartonnette:3726:21938897,21939506:cartonnette:3726:21939536,21940176:cartonnette:3726:21941546,21940636:cartonnette:3726:21940715,21941523:cartonnette:3726:21942022,21941525:cartonnette:3726:21941831,21946003:cartonnette:3726:21946096,21946268:cartonnette:3726:21946390,21946647:cartonnette:3726:21946882,21947247:cartonnette:3726:21947415,21947539:cartonnette:3726:21947596,21949002:cartonnette:3726:21949048,21949015:cartonnette:3726:21949147,21949016:cartonnette:3726:21949026,21950214:cartonnette:3726:21950742,21951150:cartonnette:3726:21951847,21951151:cartonnette:3726:21951423,21951849:cartonnette:3726:21951944,21952686:cartonnette:3726:21954221,21954907:cartonnette:3726:21962173,21954908:cartonnette:3726:21962432,21954909:cartonnette:3726:21961641,21954910:cartonnette:3726:21960449,21956045:cartonnette:3726:21958923,21956486:cartonnette:3726:21956836,21957159:cartonnette:3726:21957513,21957693:cartonnette:3726:21957892,21958303:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.010123351118372216, 'nb_photo': 1266, 'list_port_cont': '21940714,21941824,21947414,21949025,21949045,21950747,21951427,21951844,21951946,21954220,21958537,21960441,21961636,21962172,21962430,21968916,21969994,21973226,21975112,21975738,21976861,21981820,21982536,21985202,21987359,21987847,21987895,21992043,21993786,21995344,21996053,21998693,21999734,22000581,22002060,22005603,22005741,22006386,22006946,22007606,22008344,22008905,22010959,22012771,22013958,22014127,22015899,22016565,22017020,22019012,22019541,22020269,22020365,22021606,22022300,22022714,22022795,22023009,22024080,22024441,22025212,22025643,22025724,22025845,22026174,22026306,22026779,22027235,22027355,22027515,22027853,22029638,22030392,22031704,22033113,22034112,22035882,22037561,22038446,22039870,22040389,22042054,22042894,22045442,22046267,22046807,22047499,22048170,22050835,22053929,22054155,22056957,22057945,22058144,22058396,22058625,22058864,22063443,22065422,22065865,22066450,22067532,22067599,22068620,22069587,22071248,22071722,22071758,22072616,22073845,22074821,22075216,22075305,2207582', 'assoc_port': '21940636:21940714,21941525:21941824,21947247:21947414,21949002:21949045,21949016:21949025,21950214:21950747,21951150:21951844,21951151:21951427,21951849:21951946,21952686:21954220,21954907:21962172,21954908:21962430,21954909:21961636,21954910:21960441,21958303:21958537,21968667:21968916,21969242:22058864,21969754:21969994,21972979:22058396,21972980:22058625,21972981:22058144,21972983:22057945,21972992:22008905,21973006:22008344,21973008:21973226,21973619:22007606,21973621:22006946,21973656:22006386,21973657:22005741,21973659:22005603,21973711:21976861,21973713:21975738,21974688:21975112,21977364:22002060,21977973:22000581,21981750:21981820,21982467:21982536,21984455:21999734,21985174:21985202,21987148:21998693,21987149:21987359,21987150:21987895,21987843:21987847,21991913:21992043,21993540:21993786,21995227:21995344,21995732:21996053,22010720:22010959,22012264:22056957,22012283:22029638,22012284:22012771,22013065:22013958,22013946:22014127,22015277:22027853,22015290:22016565,22015362:22015899,22016903:2201702', 'assoc_mat': '21940636:Carton_brun:3726:21940714,21941525:Carton_brun:3726:21941824,21947247:Carton_brun:3726:21947414,21949002:Carton_brun:3726:21949045,21949016:Carton_brun:3726:21949025,21950214:Carton_brun:3726:21950747,21951150:Carton_brun:3726:21951844,21951151:Carton_brun:3726:21951427,21951849:Carton_brun:3726:21951946,21952686:Carton_brun:3726:21954220,21954907:Carton_brun:3726:21962172,21954908:Carton_brun:3726:21962430,21954909:Carton_brun:3726:21961636,21954910:Carton_brun:3726:21960441,21958303:Carton_brun:3726:21958537,21968667:Carton_brun:3726:21968916,21969242:Carton_brun:3726:22058864,21969754:Carton_brun:3726:21969994,21972979:Carton_brun:3726:22058396,21972980:Carton_brun:3726:22058625,21972981:Carton_brun:3726:22058144,21972983:Carton_brun:3726:22057945,21972992:Carton_brun:3726:22008905,21973006:Carton_brun:3726:22008344,21973008:Carton_brun:3726:21973226,21973619:Carton_brun:3726:22007606,21973621:Carton_brun:3726:22006946,21973656:Carton_brun:3726:22006386,21973657:Carton_brun:3726:22005741,21973659:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008151204188285742, 'nb_photo': 757, 'list_port_cont': '21938891,21939537,21941541,21941826,21942024,21942336,21946095,21947601,21949017,21949141,21950743,21951425,21951840,21951945,21957506,21957894,21960452,21961639,21962174,21962422,21968910,21969987,21971193,21971329,21973218,21975110,21975734,21977986,21979165,21981821,21982544,21983816,21984628,21985206,21987358,21987849,21987899,21989073,21989465,21990101,21993212,21993794,21995230,21995343,21996050,21998697,21999727,22000579,22005598,22005856,22006379,22007610,22008348,22008910,22012768,22013961,22014123,22015904,22017028,22019007,22020262,22020368,22021601,22022290,22022719,22022794,22023017,22025734,22025844,22026167,22026301,22026772,22027234,22027345,22027518,22027857,22029642,22030399,22033112,22035881,22037555,22038456,22040395,22042057,22042313,22042885,22043771,22045440,22046814,22048166,22054151,22056960,22057231,22057626,22057794,22057952,22058141,22058400,22058626,22058858,22063438,22065424,22066458,22068621,22069596,22071239,22071752,22073850,22074824,22075220,22075827,22078646,22080017,2208200', 'assoc_port': '21937349:21942336,21938516:21938891,21939506:21939537,21940176:21941541,21941523:21942024,21941525:21941826,21946003:21946095,21947539:21947601,21949015:21949141,21949016:21949017,21950214:21950743,21951150:21951840,21951151:21951425,21951849:21951945,21954907:21962174,21954908:21962422,21954909:21961639,21954910:21960452,21957159:21957506,21957693:21957894,21968667:21968910,21969242:22058858,21969754:21969987,21970480:21971329,21971138:21971193,21972979:22058400,21972980:22058626,21972981:22058141,21972983:22057952,21972985:22057626,21972987:22057794,21972989:22057231,21972992:22008910,21973006:22008348,21973008:21973218,21973619:22007610,21973629:22005856,21973656:22006379,21973659:22005598,21973713:21975734,21974688:21975110,21977382:21977986,21977973:22000579,21979049:21979165,21981131:21983816,21981750:21981821,21982467:21982544,21984455:21999727,21984457:21984628,21985174:21985206,21987148:21998697,21987149:21987358,21987150:21987899,21987843:21987849,21988642:21989073,21989272:21989465,21989851:2199010', 'assoc_mat': '21937349:Carton_gris:3726:21942336,21938516:Carton_gris:3726:21938891,21939506:Carton_gris:3726:21939537,21940176:Carton_gris:3726:21941541,21941523:Carton_gris:3726:21942024,21941525:Carton_gris:3726:21941826,21946003:Carton_gris:3726:21946095,21947539:Carton_gris:3726:21947601,21949015:Carton_gris:3726:21949141,21949016:Carton_gris:3726:21949017,21950214:Carton_gris:3726:21950743,21951150:Carton_gris:3726:21951840,21951151:Carton_gris:3726:21951425,21951849:Carton_gris:3726:21951945,21954907:Carton_gris:3726:21962174,21954908:Carton_gris:3726:21962422,21954909:Carton_gris:3726:21961639,21954910:Carton_gris:3726:21960452,21957159:Carton_gris:3726:21957506,21957693:Carton_gris:3726:21957894,21968667:Carton_gris:3726:21968910,21969242:Carton_gris:3726:22058858,21969754:Carton_gris:3726:21969987,21970480:Carton_gris:3726:21971329,21971138:Carton_gris:3726:21971193,21972979:Carton_gris:3726:22058400,21972980:Carton_gris:3726:22058626,21972981:Carton_gris:3726:22058141,21972983:Carton_gris:3726:22057952,21972985:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.002604242673632418, 'nb_photo': 133, 'list_port_cont': '21977981,21983811,21985207,22006382,22017024,22019009,22020270,22020366,22024073,22025847,22026177,22026304,22026776,22027514,22035880,22037559,22038453,22040393,22042049,22046263,22053923,22065429,22066452,22067527,22071246,22073843,22074828,22080008,22082009,22083654,22092305,22094675,22094912,22123992,22155467,22155903,22158881,22180049,22184353,22193523,22199204,22203059,22208944,22213840,22217231,22217701,22220867,22222325,22230090,22233733,22245339,22292440,22293845,22296334,22297249,22299325,22299862,22300223,22300432,22302901,22330631,22331877,22336818,22337787,22340957,22342837,22347544,22351103,22352968,22356450,22375712,22377207,22377292,22378924,22383897,22385348,22385684,22393633,22393640,22398250,22400374,22405291,22408553,22409664,22411823,22421719,22425281,22426989,22428128,22428869,22429941,22431102,22431540,22433934,22435435,22438516,22440153,22444247,22446527,22463615,22476079,22479964,22494770,22494815,22511634,22512234,22516425,22520075,22524898,22524908,22538004,22542658,22565237,2256575', 'assoc_port': '21973656:22006382,21977382:21977981,21981131:21983811,21985174:21985207,22016903:22017024,22018850:22024073,22018851:22020366,22018852:22019009,22020025:22020270,22025602:22027514,22025605:22026776,22025607:22026304,22025751:22026177,22025752:22025847,22033508:22053923,22035450:22035880,22037104:22037559,22037968:22038453,22039770:22042049,22040278:22040393,22046140:22046263,22064824:22065429,22066283:22066452,22067410:22067527,22070826:22071246,22073126:22074828,22073726:22073843,22079627:22080008,22081402:22082009,22083525:22083654,22092127:22092305,22094130:22094675,22094736:22094912,22123930:22123992,22154159:22155467,22155479:22155903,22158748:22158881,22179166:22180049,22183776:22184353,22189425:22233733,22193306:22193523,22198756:22199204,22202704:22230090,22202706:22203059,22208520:22217231,22208522:22208944,22213698:22213840,22217591:22217701,22219297:22220867,22221127:22222325,22245318:22245339,22289234:22292440,22292234:22293845,22295185:22302901,22295187:22296334,22296942:22297249,22298204:2229932', 'assoc_mat': '21973656:kraft:3726:22006382,21977382:kraft:3726:21977981,21981131:kraft:3726:21983811,21985174:kraft:3726:21985207,22016903:kraft:3726:22017024,22018850:kraft:3726:22024073,22018851:kraft:3726:22020366,22018852:kraft:3726:22019009,22020025:kraft:3726:22020270,22025602:kraft:3726:22027514,22025605:kraft:3726:22026776,22025607:kraft:3726:22026304,22025751:kraft:3726:22026177,22025752:kraft:3726:22025847,22033508:kraft:3726:22053923,22035450:kraft:3726:22035880,22037104:kraft:3726:22037559,22037968:kraft:3726:22038453,22039770:kraft:3726:22042049,22040278:kraft:3726:22040393,22046140:kraft:3726:22046263,22064824:kraft:3726:22065429,22066283:kraft:3726:22066452,22067410:kraft:3726:22067527,22070826:kraft:3726:22071246,22073126:kraft:3726:22074828,22073726:kraft:3726:22073843,22079627:kraft:3726:22080008,22081402:kraft:3726:22082009,22083525:kraft:3726:22083654,22092127:kraft:3726:22092305,22094130:kraft:3726:22094675,22094736:kraft:3726:22094912,22123930:kraft:3726:22123992,22154159:kraft:3726:22155467,22155479:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0023373291109582187, 'nb_photo': 71, 'list_port_cont': '21938899,21939543,21958928,21971190,21993789,21999728,22004933,22012763,22017025,22042886,22045469,22046808,22057237,22058863,22066454,22084880,22089593,22134964,22141536,22157403,22176074,22180050,22196012,22205133,22208697,22217232,22222321,22231980,22246228,22246889,22296336,22299870,22305645,22338246,22340953,22343370,22346258,22354172,22355579,22356734,22390518,22392327,22406224,22406284,22409668,22412952,22424158,22425275,22425282,22426028,22426986,22429933,22447168,22454089,22471514,22473166,22479966,22490338,22490362,22510159,22515714,22521366,22523208,22542660,22549001,22550924,22564741', 'assoc_port': '21938516:21938899,21939506:21939543,21956045:21958928,21969242:22058863,21971138:21971190,21972989:22057237,21973685:22004933,21984455:21999728,21993540:21993789,22012284:22012763,22016903:22017025,22042804:22042886,22045277:22045469,22046685:22046808,22066283:22066454,22082389:22084880,22089462:22089593,22134675:22134964,22141307:22141536,22157210:22157403,22176017:22176074,22179166:22180050,22189424:22196012,22202703:22231980,22204505:22205133,22208520:22217232,22208521:22208697,22221127:22222321,22246126:22246228,22246839:22246889,22289235:22305645,22295187:22296336,22299500:22299870,22337916:22338246,22337933:22346258,22340605:22340953,22343049:22343370,22354081:22354172,22355140:22355579,22356644:22356734,22389620:22412952,22389622:22390518,22391339:22392327,22404280:22409668,22406055:22406224,22406056:22406284,22423926:22425275,22423928:22424158,22425012:22479966,22425014:22425282,22425813:22426028,22426756:22426986,22428979:22429933,22446413:22447168,22453208:22454089,22471399:22471514,22473003:2247316', 'assoc_mat': '21938516:metal:3726:21938899,21939506:metal:3726:21939543,21956045:metal:3726:21958928,21969242:metal:3726:22058863,21971138:metal:3726:21971190,21972989:metal:3726:22057237,21973685:metal:3726:22004933,21984455:metal:3726:21999728,21993540:metal:3726:21993789,22012284:metal:3726:22012763,22016903:metal:3726:22017025,22042804:metal:3726:22042886,22045277:metal:3726:22045469,22046685:metal:3726:22046808,22066283:metal:3726:22066454,22082389:metal:3726:22084880,22089462:metal:3726:22089593,22134675:metal:3726:22134964,22141307:metal:3726:22141536,22157210:metal:3726:22157403,22176017:metal:3726:22176074,22179166:metal:3726:22180050,22189424:metal:3726:22196012,22202703:metal:3726:22231980,22204505:metal:3726:22205133,22208520:metal:3726:22217232,22208521:metal:3726:22208697,22221127:metal:3726:22222321,22246126:metal:3726:22246228,22246839:metal:3726:22246889,22289235:metal:3726:22305645,22295187:metal:3726:22296336,22299500:metal:3726:22299870,22337916:metal:3726:22338246,22337933:metal:3726:22346258,22340605:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007286581082883396, 'nb_photo': 1111, 'list_port_cont': '21938893,21939542,21940725,21941545,21941830,21942020,21942334,21946090,21946123,21946386,21946884,21947421,21949028,21949046,21949145,21950750,21951841,21951936,21955594,21956840,21957511,21957895,21958533,21958925,21960447,21961632,21962170,21962423,21968709,21968906,21969996,21971191,21971333,21975733,21976859,21977979,21979158,21982540,21983812,21984634,21986010,21987355,21987858,21987897,21989082,21989463,21990096,21993796,21995228,21995345,21996051,21998704,21999732,22000582,22001690,22002068,22004931,22005597,22006947,22007616,22008345,22008908,22009730,22011969,22012766,22013957,22014121,22015906,22016564,22017018,22019002,22019538,22020364,22021608,22022297,22022724,22022793,22023007,22024084,22024446,22025214,22025642,22025729,22025848,22026171,22026299,22026773,22027349,22027511,22027850,22029647,22031145,22031707,22033110,22035875,22038452,22042314,22042888,22043779,22045454,22046262,22046811,22047503,22048167,22050833,22053927,22057236,22057451,22057628,22057801,22057951,22058140,22058628,2205886', 'assoc_port': '21937349:21942334,21938516:21938893,21939506:21939542,21940176:21941545,21940636:21940725,21941523:21942020,21941525:21941830,21945660:21946123,21946003:21946090,21946268:21946386,21946647:21946884,21947247:21947421,21949002:21949046,21949015:21949145,21949016:21949028,21950214:21950750,21951150:21951841,21951849:21951936,21954907:21962170,21954908:21962423,21954909:21961632,21954910:21960447,21955433:21955594,21956045:21958925,21956486:21956840,21957159:21957511,21957693:21957895,21958303:21958533,21968666:21968709,21968667:21968906,21969242:22058866,21969754:21969996,21970480:21971333,21971138:21971191,21972980:22058628,21972981:22058140,21972983:22057951,21972985:22057628,21972987:22057801,21972988:22057451,21972989:22057236,21972990:22011969,21972992:22008908,21973005:22009730,21973006:22008345,21973619:22007616,21973621:22006947,21973659:22005597,21973685:22004931,21973711:21976859,21973713:21975733,21977364:22002068,21977381:22001690,21977382:21977979,21977973:22000582,21979049:21979158,21981131:2198381', 'assoc_mat': '21937349:plastique:3726:21942334,21938516:plastique:3726:21938893,21939506:plastique:3726:21939542,21940176:plastique:3726:21941545,21940636:plastique:3726:21940725,21941523:plastique:3726:21942020,21941525:plastique:3726:21941830,21945660:plastique:3726:21946123,21946003:plastique:3726:21946090,21946268:plastique:3726:21946386,21946647:plastique:3726:21946884,21947247:plastique:3726:21947421,21949002:plastique:3726:21949046,21949015:plastique:3726:21949145,21949016:plastique:3726:21949028,21950214:plastique:3726:21950750,21951150:plastique:3726:21951841,21951849:plastique:3726:21951936,21954907:plastique:3726:21962170,21954908:plastique:3726:21962423,21954909:plastique:3726:21961632,21954910:plastique:3726:21960447,21955433:plastique:3726:21955594,21956045:plastique:3726:21958925,21956486:plastique:3726:21956840,21957159:plastique:3726:21957511,21957693:plastique:3726:21957895,21958303:plastique:3726:21958533,21968666:plastique:3726:21968709,21968667:plastique:3726:21968906,21969242:plastique:3726:22058866,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.010230622356344015, 'nb_photo': 2007, 'list_port_cont': '21938890,21939539,21940719,21941536,21941827,21942331,21946088,21946117,21947419,21947594,21949018,21949055,21949143,21950741,21951431,21951848,21951937,21954223,21955598,21956837,21957504,21957891,21958539,21958805,21958920,21960443,21961631,21962176,21962426,21968714,21968917,21969985,21971194,21971339,21973222,21975115,21975730,21976855,21977987,21979157,21981822,21982542,21983810,21984637,21985210,21986006,21987363,21987856,21987900,21989077,21989466,21990092,21991513,21992039,21993214,21993791,21995235,21995346,21996056,21998698,21999730,22001687,22002062,22004923,22005599,22005737,22005853,22006389,22006948,22007609,22008346,22008915,22009746,22010964,22011971,22012760,22013959,22014126,22015907,22016558,22017017,22019010,22019531,22020263,22020357,22021603,22022291,22022715,22022792,22023013,22024075,22025210,22025646,22025728,22025843,22026175,22026303,22026781,22027236,22027348,22027517,22027848,22029637,22030396,22031153,22033107,22034111,22035873,22037558,22038449,22039880,22040396,22042052,2204289', 'assoc_port': '21937349:21942331,21938516:21938890,21939506:21939539,21940176:21941536,21940636:21940719,21941525:21941827,21945660:21946117,21946003:21946088,21947247:21947419,21947539:21947594,21949002:21949055,21949015:21949143,21949016:21949018,21950214:21950741,21951150:21951848,21951151:21951431,21951849:21951937,21952686:21954223,21954907:21962176,21954908:21962426,21954909:21961631,21954910:21960443,21955433:21955598,21956045:21958920,21956486:21956837,21957159:21957504,21957693:21957891,21958303:21958539,21958770:21958805,21968666:21968714,21968667:21968917,21969242:22058861,21969754:21969985,21970480:21971339,21971138:21971194,21972979:22058406,21972980:22058623,21972981:22058147,21972983:22057956,21972987:22057804,21972989:22057232,21972990:22011971,21972992:22008915,21973005:22009746,21973006:22008346,21973008:21973222,21973619:22007609,21973621:22006948,21973629:22005853,21973656:22006389,21973657:22005737,21973659:22005599,21973685:22004923,21973711:21976855,21973713:21975730,21974688:21975115,21977364:2200206', 'assoc_mat': '21937349:Teint_Dans_La_Masse:3726:21942331,21938516:Teint_Dans_La_Masse:3726:21938890,21939506:Teint_Dans_La_Masse:3726:21939539,21940176:Teint_Dans_La_Masse:3726:21941536,21940636:Teint_Dans_La_Masse:3726:21940719,21941525:Teint_Dans_La_Masse:3726:21941827,21945660:Teint_Dans_La_Masse:3726:21946117,21946003:Teint_Dans_La_Masse:3726:21946088,21947247:Teint_Dans_La_Masse:3726:21947419,21947539:Teint_Dans_La_Masse:3726:21947594,21949002:Teint_Dans_La_Masse:3726:21949055,21949015:Teint_Dans_La_Masse:3726:21949143,21949016:Teint_Dans_La_Masse:3726:21949018,21950214:Teint_Dans_La_Masse:3726:21950741,21951150:Teint_Dans_La_Masse:3726:21951848,21951151:Teint_Dans_La_Masse:3726:21951431,21951849:Teint_Dans_La_Masse:3726:21951937,21952686:Teint_Dans_La_Masse:3726:21954223,21954907:Teint_Dans_La_Masse:3726:21962176,21954908:Teint_Dans_La_Masse:3726:21962426,21954909:Teint_Dans_La_Masse:3726:21961631,21954910:Teint_Dans_La_Masse:3726:21960443,21955433:Teint_Dans_La_Masse:3726:21955598,21956045:Teint_Dans_La_Masse:3726:2'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(1720894,1720986,1721940,1725912,1729831,1733782,1738356,1740096,1744187,1748245,1752284,1756173,1761419,1761359,1765758,1770227)); after get_hostname_from_raspi SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______JRM' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=979) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=25 and date >='2025-04-01' and date <= '2025-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((15658,),), 'unwanted_material_monthly_percentage': ((0.03617715350850373,),), 'material_repartition': (('JRM', 14410),), 'material_dict': {'JRM': 14410}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.032904725514844364, 782), (datetime.date(2025, 4, 2), 0.03127953608427425, 1539), (datetime.date(2025, 4, 3), 0.04471003138995447, 582), (datetime.date(2025, 4, 15), 0.034739890995393895, 927), (datetime.date(2025, 4, 16), 0.033360859024979844, 1260), (datetime.date(2025, 4, 17), 0.02808556819053822, 1399), (datetime.date(2025, 4, 18), 0.03948756840293151, 1203), (datetime.date(2025, 4, 19), 0.0329127385425759, 705), (datetime.date(2025, 4, 22), 0.042443140788895405, 541), (datetime.date(2025, 4, 23), 0.04692747858968517, 867), (datetime.date(2025, 4, 24), 0.04288238751726208, 1151), (datetime.date(2025, 4, 25), 0.04491422710504408, 1493), (datetime.date(2025, 4, 28), 0.03109004859547543, 1165), (datetime.date(2025, 4, 29), 0.03396040932670385, 796), (datetime.date(2025, 4, 30), 0.02545698524757958, 1248)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 4, 1), 0.032904725514844364, 782), (datetime.date(2025, 4, 2), 0.03127953608427425, 1539), (datetime.date(2025, 4, 3), 0.04471003138995447, 582), (datetime.date(2025, 4, 15), 0.034739890995393895, 927), (datetime.date(2025, 4, 16), 0.033360859024979844, 1260), (datetime.date(2025, 4, 17), 0.02808556819053822, 1399), (datetime.date(2025, 4, 18), 0.03948756840293151, 1203), (datetime.date(2025, 4, 19), 0.0329127385425759, 705), (datetime.date(2025, 4, 22), 0.042443140788895405, 541), (datetime.date(2025, 4, 23), 0.04692747858968517, 867), (datetime.date(2025, 4, 24), 0.04288238751726208, 1151), (datetime.date(2025, 4, 25), 0.04491422710504408, 1493), (datetime.date(2025, 4, 28), 0.03109004859547543, 1165), (datetime.date(2025, 4, 29), 0.03396040932670385, 796), (datetime.date(2025, 4, 30), 0.02545698524757958, 1248))}, 'quality_array': [], 'number_of_batch': ((614,),), 'datou_id_sts': 3385, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008524882267818312, 'nb_photo': 676, 'list_port_cont': '21939545,21940717,21941543,21941820,21942333,21947417,21950744,21951845,21951935,21954229,21955604,21957893,21958538,21958918,21960451,21962177,21968911,21969990,21975108,21976851,21977983,21982545,21983807,21985209,21986011,21987850,21989076,21991135,21991509,21995234,21998695,21999729,22000580,22002061,22004929,22005596,22005846,22006942,22008909,22011970,22012769,22013954,22014124,22017021,22019540,22020260,22020359,22021607,22022296,22022722,22022791,22023010,22024078,22025731,22025841,22026173,22026305,22027516,22027856,22029641,22030398,22031708,22033108,22034118,22035872,22037562,22038454,22039871,22042051,22042312,22045436,22045445,22046271,22046810,22047492,22048177,22049992,22053599,22054158,22056961,22057233,22057447,22057796,22058401,22058629,22063444,22065423,22065860,22066455,22067525,22068617,22069585,22071241,22071721,22071757,22073844,22074822,22077680,22078638,22080010,22082002,22083655,22084874,22090325,22090479,22092301,22094684,22096744,22098480,22099846,22100784,22103779,22106508,2210666', 'assoc_port': '21937349:21942333,21939506:21939545,21940176:21941543,21940636:21940717,21941525:21941820,21947247:21947417,21950214:21950744,21951150:21951845,21951849:21951935,21952686:21954229,21954907:21962177,21954910:21960451,21955433:21955604,21956045:21958918,21957693:21957893,21958303:21958538,21968667:21968911,21969754:21969990,21972979:22058401,21972980:22058629,21972987:22057796,21972988:22057447,21972989:22057233,21972990:22011970,21972992:22008909,21973621:22006942,21973629:22005846,21973659:22005596,21973685:22004929,21973711:21976851,21974688:21975108,21977364:22002061,21977382:21977983,21977973:22000580,21981131:21983807,21982467:21982545,21984455:21999729,21984456:21986011,21985174:21985209,21987148:21998695,21987843:21987850,21988642:21989076,21991050:21991509,21991053:21991135,21994417:21995234,22012264:22056961,22012283:22029641,22012284:22012769,22013065:22013954,22013946:22014124,22015277:22027856,22016903:22017021,22018850:22024078,22018851:22020359,22019464:22019540,22020025:22020260,22021041:2202229', 'assoc_mat': '21937349:autre_refus:3726:21942333,21939506:autre_refus:3726:21939545,21940176:autre_refus:3726:21941543,21940636:autre_refus:3726:21940717,21941525:autre_refus:3726:21941820,21947247:autre_refus:3726:21947417,21950214:autre_refus:3726:21950744,21951150:autre_refus:3726:21951845,21951849:autre_refus:3726:21951935,21952686:autre_refus:3726:21954229,21954907:autre_refus:3726:21962177,21954910:autre_refus:3726:21960451,21955433:autre_refus:3726:21955604,21956045:autre_refus:3726:21958918,21957693:autre_refus:3726:21957893,21958303:autre_refus:3726:21958538,21968667:autre_refus:3726:21968911,21969754:autre_refus:3726:21969990,21972979:autre_refus:3726:22058401,21972980:autre_refus:3726:22058629,21972987:autre_refus:3726:22057796,21972988:autre_refus:3726:22057447,21972989:autre_refus:3726:22057233,21972990:autre_refus:3726:22011970,21972992:autre_refus:3726:22008909,21973621:autre_refus:3726:22006942,21973629:autre_refus:3726:22005846,21973659:autre_refus:3726:22005596,21973685:autre_refus:3726:22004929,21973711:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007375532261292248, 'nb_photo': 1400, 'list_port_cont': '21938264,21938897,21939536,21940715,21941546,21941831,21942022,21942332,21946096,21946390,21946882,21947415,21947596,21949026,21949048,21949147,21950742,21951423,21951847,21951944,21954221,21956836,21957513,21957892,21958532,21958923,21960449,21961641,21962173,21962432,21968711,21968914,21969988,21971187,21971336,21973227,21975106,21976857,21977976,21979159,21981816,21982535,21983806,21984627,21985204,21987353,21987852,21987902,21989080,21989459,21990102,21991508,21992037,21993219,21993787,21995229,21995339,21996046,21998702,21999725,22004932,22005595,22005732,22006941,22007614,22008343,22009742,22010966,22011975,22012770,22013955,22014119,22015897,22016562,22017027,22019011,22019537,22020261,22020362,22021610,22022292,22022718,22022799,22023008,22024081,22025217,22025639,22025732,22025850,22026170,22026296,22026780,22027240,22027354,22027508,22027847,22029643,22030401,22031155,22031701,22033109,22035877,22037564,22038457,22039872,22040394,22042055,22042891,22043781,22045439,22045448,22046265,22046813,2204749', 'assoc_port': '21937349:21942332,21938146:21938264,21938516:21938897,21939506:21939536,21940176:21941546,21940636:21940715,21941523:21942022,21941525:21941831,21946003:21946096,21946268:21946390,21946647:21946882,21947247:21947415,21947539:21947596,21949002:21949048,21949015:21949147,21949016:21949026,21950214:21950742,21951150:21951847,21951151:21951423,21951849:21951944,21952686:21954221,21954907:21962173,21954908:21962432,21954909:21961641,21954910:21960449,21956045:21958923,21956486:21956836,21957159:21957513,21957693:21957892,21958303:21958532,21968666:21968711,21968667:21968914,21969242:22058860,21969754:21969988,21970480:21971336,21971138:21971187,21972980:22058621,21972981:22058146,21972983:22057955,21972984:22057887,21972985:22057620,21972988:22057449,21972990:22011975,21973005:22009742,21973006:22008343,21973008:21973227,21973619:22007614,21973621:22006941,21973657:22005732,21973659:22005595,21973685:22004932,21973711:21976857,21974688:21975106,21977382:21977976,21979049:21979159,21981131:21983806,21981750:2198181', 'assoc_mat': '21937349:cartonnette:3726:21942332,21938146:cartonnette:3726:21938264,21938516:cartonnette:3726:21938897,21939506:cartonnette:3726:21939536,21940176:cartonnette:3726:21941546,21940636:cartonnette:3726:21940715,21941523:cartonnette:3726:21942022,21941525:cartonnette:3726:21941831,21946003:cartonnette:3726:21946096,21946268:cartonnette:3726:21946390,21946647:cartonnette:3726:21946882,21947247:cartonnette:3726:21947415,21947539:cartonnette:3726:21947596,21949002:cartonnette:3726:21949048,21949015:cartonnette:3726:21949147,21949016:cartonnette:3726:21949026,21950214:cartonnette:3726:21950742,21951150:cartonnette:3726:21951847,21951151:cartonnette:3726:21951423,21951849:cartonnette:3726:21951944,21952686:cartonnette:3726:21954221,21954907:cartonnette:3726:21962173,21954908:cartonnette:3726:21962432,21954909:cartonnette:3726:21961641,21954910:cartonnette:3726:21960449,21956045:cartonnette:3726:21958923,21956486:cartonnette:3726:21956836,21957159:cartonnette:3726:21957513,21957693:cartonnette:3726:21957892,21958303:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.010123351118372216, 'nb_photo': 1266, 'list_port_cont': '21940714,21941824,21947414,21949025,21949045,21950747,21951427,21951844,21951946,21954220,21958537,21960441,21961636,21962172,21962430,21968916,21969994,21973226,21975112,21975738,21976861,21981820,21982536,21985202,21987359,21987847,21987895,21992043,21993786,21995344,21996053,21998693,21999734,22000581,22002060,22005603,22005741,22006386,22006946,22007606,22008344,22008905,22010959,22012771,22013958,22014127,22015899,22016565,22017020,22019012,22019541,22020269,22020365,22021606,22022300,22022714,22022795,22023009,22024080,22024441,22025212,22025643,22025724,22025845,22026174,22026306,22026779,22027235,22027355,22027515,22027853,22029638,22030392,22031704,22033113,22034112,22035882,22037561,22038446,22039870,22040389,22042054,22042894,22045442,22046267,22046807,22047499,22048170,22050835,22053929,22054155,22056957,22057945,22058144,22058396,22058625,22058864,22063443,22065422,22065865,22066450,22067532,22067599,22068620,22069587,22071248,22071722,22071758,22072616,22073845,22074821,22075216,22075305,2207582', 'assoc_port': '21940636:21940714,21941525:21941824,21947247:21947414,21949002:21949045,21949016:21949025,21950214:21950747,21951150:21951844,21951151:21951427,21951849:21951946,21952686:21954220,21954907:21962172,21954908:21962430,21954909:21961636,21954910:21960441,21958303:21958537,21968667:21968916,21969242:22058864,21969754:21969994,21972979:22058396,21972980:22058625,21972981:22058144,21972983:22057945,21972992:22008905,21973006:22008344,21973008:21973226,21973619:22007606,21973621:22006946,21973656:22006386,21973657:22005741,21973659:22005603,21973711:21976861,21973713:21975738,21974688:21975112,21977364:22002060,21977973:22000581,21981750:21981820,21982467:21982536,21984455:21999734,21985174:21985202,21987148:21998693,21987149:21987359,21987150:21987895,21987843:21987847,21991913:21992043,21993540:21993786,21995227:21995344,21995732:21996053,22010720:22010959,22012264:22056957,22012283:22029638,22012284:22012771,22013065:22013958,22013946:22014127,22015277:22027853,22015290:22016565,22015362:22015899,22016903:2201702', 'assoc_mat': '21940636:Carton_brun:3726:21940714,21941525:Carton_brun:3726:21941824,21947247:Carton_brun:3726:21947414,21949002:Carton_brun:3726:21949045,21949016:Carton_brun:3726:21949025,21950214:Carton_brun:3726:21950747,21951150:Carton_brun:3726:21951844,21951151:Carton_brun:3726:21951427,21951849:Carton_brun:3726:21951946,21952686:Carton_brun:3726:21954220,21954907:Carton_brun:3726:21962172,21954908:Carton_brun:3726:21962430,21954909:Carton_brun:3726:21961636,21954910:Carton_brun:3726:21960441,21958303:Carton_brun:3726:21958537,21968667:Carton_brun:3726:21968916,21969242:Carton_brun:3726:22058864,21969754:Carton_brun:3726:21969994,21972979:Carton_brun:3726:22058396,21972980:Carton_brun:3726:22058625,21972981:Carton_brun:3726:22058144,21972983:Carton_brun:3726:22057945,21972992:Carton_brun:3726:22008905,21973006:Carton_brun:3726:22008344,21973008:Carton_brun:3726:21973226,21973619:Carton_brun:3726:22007606,21973621:Carton_brun:3726:22006946,21973656:Carton_brun:3726:22006386,21973657:Carton_brun:3726:22005741,21973659:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008151204188285742, 'nb_photo': 757, 'list_port_cont': '21938891,21939537,21941541,21941826,21942024,21942336,21946095,21947601,21949017,21949141,21950743,21951425,21951840,21951945,21957506,21957894,21960452,21961639,21962174,21962422,21968910,21969987,21971193,21971329,21973218,21975110,21975734,21977986,21979165,21981821,21982544,21983816,21984628,21985206,21987358,21987849,21987899,21989073,21989465,21990101,21993212,21993794,21995230,21995343,21996050,21998697,21999727,22000579,22005598,22005856,22006379,22007610,22008348,22008910,22012768,22013961,22014123,22015904,22017028,22019007,22020262,22020368,22021601,22022290,22022719,22022794,22023017,22025734,22025844,22026167,22026301,22026772,22027234,22027345,22027518,22027857,22029642,22030399,22033112,22035881,22037555,22038456,22040395,22042057,22042313,22042885,22043771,22045440,22046814,22048166,22054151,22056960,22057231,22057626,22057794,22057952,22058141,22058400,22058626,22058858,22063438,22065424,22066458,22068621,22069596,22071239,22071752,22073850,22074824,22075220,22075827,22078646,22080017,2208200', 'assoc_port': '21937349:21942336,21938516:21938891,21939506:21939537,21940176:21941541,21941523:21942024,21941525:21941826,21946003:21946095,21947539:21947601,21949015:21949141,21949016:21949017,21950214:21950743,21951150:21951840,21951151:21951425,21951849:21951945,21954907:21962174,21954908:21962422,21954909:21961639,21954910:21960452,21957159:21957506,21957693:21957894,21968667:21968910,21969242:22058858,21969754:21969987,21970480:21971329,21971138:21971193,21972979:22058400,21972980:22058626,21972981:22058141,21972983:22057952,21972985:22057626,21972987:22057794,21972989:22057231,21972992:22008910,21973006:22008348,21973008:21973218,21973619:22007610,21973629:22005856,21973656:22006379,21973659:22005598,21973713:21975734,21974688:21975110,21977382:21977986,21977973:22000579,21979049:21979165,21981131:21983816,21981750:21981821,21982467:21982544,21984455:21999727,21984457:21984628,21985174:21985206,21987148:21998697,21987149:21987358,21987150:21987899,21987843:21987849,21988642:21989073,21989272:21989465,21989851:2199010', 'assoc_mat': '21937349:Carton_gris:3726:21942336,21938516:Carton_gris:3726:21938891,21939506:Carton_gris:3726:21939537,21940176:Carton_gris:3726:21941541,21941523:Carton_gris:3726:21942024,21941525:Carton_gris:3726:21941826,21946003:Carton_gris:3726:21946095,21947539:Carton_gris:3726:21947601,21949015:Carton_gris:3726:21949141,21949016:Carton_gris:3726:21949017,21950214:Carton_gris:3726:21950743,21951150:Carton_gris:3726:21951840,21951151:Carton_gris:3726:21951425,21951849:Carton_gris:3726:21951945,21954907:Carton_gris:3726:21962174,21954908:Carton_gris:3726:21962422,21954909:Carton_gris:3726:21961639,21954910:Carton_gris:3726:21960452,21957159:Carton_gris:3726:21957506,21957693:Carton_gris:3726:21957894,21968667:Carton_gris:3726:21968910,21969242:Carton_gris:3726:22058858,21969754:Carton_gris:3726:21969987,21970480:Carton_gris:3726:21971329,21971138:Carton_gris:3726:21971193,21972979:Carton_gris:3726:22058400,21972980:Carton_gris:3726:22058626,21972981:Carton_gris:3726:22058141,21972983:Carton_gris:3726:22057952,21972985:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.002604242673632418, 'nb_photo': 133, 'list_port_cont': '21977981,21983811,21985207,22006382,22017024,22019009,22020270,22020366,22024073,22025847,22026177,22026304,22026776,22027514,22035880,22037559,22038453,22040393,22042049,22046263,22053923,22065429,22066452,22067527,22071246,22073843,22074828,22080008,22082009,22083654,22092305,22094675,22094912,22123992,22155467,22155903,22158881,22180049,22184353,22193523,22199204,22203059,22208944,22213840,22217231,22217701,22220867,22222325,22230090,22233733,22245339,22292440,22293845,22296334,22297249,22299325,22299862,22300223,22300432,22302901,22330631,22331877,22336818,22337787,22340957,22342837,22347544,22351103,22352968,22356450,22375712,22377207,22377292,22378924,22383897,22385348,22385684,22393633,22393640,22398250,22400374,22405291,22408553,22409664,22411823,22421719,22425281,22426989,22428128,22428869,22429941,22431102,22431540,22433934,22435435,22438516,22440153,22444247,22446527,22463615,22476079,22479964,22494770,22494815,22511634,22512234,22516425,22520075,22524898,22524908,22538004,22542658,22565237,2256575', 'assoc_port': '21973656:22006382,21977382:21977981,21981131:21983811,21985174:21985207,22016903:22017024,22018850:22024073,22018851:22020366,22018852:22019009,22020025:22020270,22025602:22027514,22025605:22026776,22025607:22026304,22025751:22026177,22025752:22025847,22033508:22053923,22035450:22035880,22037104:22037559,22037968:22038453,22039770:22042049,22040278:22040393,22046140:22046263,22064824:22065429,22066283:22066452,22067410:22067527,22070826:22071246,22073126:22074828,22073726:22073843,22079627:22080008,22081402:22082009,22083525:22083654,22092127:22092305,22094130:22094675,22094736:22094912,22123930:22123992,22154159:22155467,22155479:22155903,22158748:22158881,22179166:22180049,22183776:22184353,22189425:22233733,22193306:22193523,22198756:22199204,22202704:22230090,22202706:22203059,22208520:22217231,22208522:22208944,22213698:22213840,22217591:22217701,22219297:22220867,22221127:22222325,22245318:22245339,22289234:22292440,22292234:22293845,22295185:22302901,22295187:22296334,22296942:22297249,22298204:2229932', 'assoc_mat': '21973656:kraft:3726:22006382,21977382:kraft:3726:21977981,21981131:kraft:3726:21983811,21985174:kraft:3726:21985207,22016903:kraft:3726:22017024,22018850:kraft:3726:22024073,22018851:kraft:3726:22020366,22018852:kraft:3726:22019009,22020025:kraft:3726:22020270,22025602:kraft:3726:22027514,22025605:kraft:3726:22026776,22025607:kraft:3726:22026304,22025751:kraft:3726:22026177,22025752:kraft:3726:22025847,22033508:kraft:3726:22053923,22035450:kraft:3726:22035880,22037104:kraft:3726:22037559,22037968:kraft:3726:22038453,22039770:kraft:3726:22042049,22040278:kraft:3726:22040393,22046140:kraft:3726:22046263,22064824:kraft:3726:22065429,22066283:kraft:3726:22066452,22067410:kraft:3726:22067527,22070826:kraft:3726:22071246,22073126:kraft:3726:22074828,22073726:kraft:3726:22073843,22079627:kraft:3726:22080008,22081402:kraft:3726:22082009,22083525:kraft:3726:22083654,22092127:kraft:3726:22092305,22094130:kraft:3726:22094675,22094736:kraft:3726:22094912,22123930:kraft:3726:22123992,22154159:kraft:3726:22155467,22155479:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0023373291109582187, 'nb_photo': 71, 'list_port_cont': '21938899,21939543,21958928,21971190,21993789,21999728,22004933,22012763,22017025,22042886,22045469,22046808,22057237,22058863,22066454,22084880,22089593,22134964,22141536,22157403,22176074,22180050,22196012,22205133,22208697,22217232,22222321,22231980,22246228,22246889,22296336,22299870,22305645,22338246,22340953,22343370,22346258,22354172,22355579,22356734,22390518,22392327,22406224,22406284,22409668,22412952,22424158,22425275,22425282,22426028,22426986,22429933,22447168,22454089,22471514,22473166,22479966,22490338,22490362,22510159,22515714,22521366,22523208,22542660,22549001,22550924,22564741', 'assoc_port': '21938516:21938899,21939506:21939543,21956045:21958928,21969242:22058863,21971138:21971190,21972989:22057237,21973685:22004933,21984455:21999728,21993540:21993789,22012284:22012763,22016903:22017025,22042804:22042886,22045277:22045469,22046685:22046808,22066283:22066454,22082389:22084880,22089462:22089593,22134675:22134964,22141307:22141536,22157210:22157403,22176017:22176074,22179166:22180050,22189424:22196012,22202703:22231980,22204505:22205133,22208520:22217232,22208521:22208697,22221127:22222321,22246126:22246228,22246839:22246889,22289235:22305645,22295187:22296336,22299500:22299870,22337916:22338246,22337933:22346258,22340605:22340953,22343049:22343370,22354081:22354172,22355140:22355579,22356644:22356734,22389620:22412952,22389622:22390518,22391339:22392327,22404280:22409668,22406055:22406224,22406056:22406284,22423926:22425275,22423928:22424158,22425012:22479966,22425014:22425282,22425813:22426028,22426756:22426986,22428979:22429933,22446413:22447168,22453208:22454089,22471399:22471514,22473003:2247316', 'assoc_mat': '21938516:metal:3726:21938899,21939506:metal:3726:21939543,21956045:metal:3726:21958928,21969242:metal:3726:22058863,21971138:metal:3726:21971190,21972989:metal:3726:22057237,21973685:metal:3726:22004933,21984455:metal:3726:21999728,21993540:metal:3726:21993789,22012284:metal:3726:22012763,22016903:metal:3726:22017025,22042804:metal:3726:22042886,22045277:metal:3726:22045469,22046685:metal:3726:22046808,22066283:metal:3726:22066454,22082389:metal:3726:22084880,22089462:metal:3726:22089593,22134675:metal:3726:22134964,22141307:metal:3726:22141536,22157210:metal:3726:22157403,22176017:metal:3726:22176074,22179166:metal:3726:22180050,22189424:metal:3726:22196012,22202703:metal:3726:22231980,22204505:metal:3726:22205133,22208520:metal:3726:22217232,22208521:metal:3726:22208697,22221127:metal:3726:22222321,22246126:metal:3726:22246228,22246839:metal:3726:22246889,22289235:metal:3726:22305645,22295187:metal:3726:22296336,22299500:metal:3726:22299870,22337916:metal:3726:22338246,22337933:metal:3726:22346258,22340605:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007286581082883396, 'nb_photo': 1111, 'list_port_cont': '21938893,21939542,21940725,21941545,21941830,21942020,21942334,21946090,21946123,21946386,21946884,21947421,21949028,21949046,21949145,21950750,21951841,21951936,21955594,21956840,21957511,21957895,21958533,21958925,21960447,21961632,21962170,21962423,21968709,21968906,21969996,21971191,21971333,21975733,21976859,21977979,21979158,21982540,21983812,21984634,21986010,21987355,21987858,21987897,21989082,21989463,21990096,21993796,21995228,21995345,21996051,21998704,21999732,22000582,22001690,22002068,22004931,22005597,22006947,22007616,22008345,22008908,22009730,22011969,22012766,22013957,22014121,22015906,22016564,22017018,22019002,22019538,22020364,22021608,22022297,22022724,22022793,22023007,22024084,22024446,22025214,22025642,22025729,22025848,22026171,22026299,22026773,22027349,22027511,22027850,22029647,22031145,22031707,22033110,22035875,22038452,22042314,22042888,22043779,22045454,22046262,22046811,22047503,22048167,22050833,22053927,22057236,22057451,22057628,22057801,22057951,22058140,22058628,2205886', 'assoc_port': '21937349:21942334,21938516:21938893,21939506:21939542,21940176:21941545,21940636:21940725,21941523:21942020,21941525:21941830,21945660:21946123,21946003:21946090,21946268:21946386,21946647:21946884,21947247:21947421,21949002:21949046,21949015:21949145,21949016:21949028,21950214:21950750,21951150:21951841,21951849:21951936,21954907:21962170,21954908:21962423,21954909:21961632,21954910:21960447,21955433:21955594,21956045:21958925,21956486:21956840,21957159:21957511,21957693:21957895,21958303:21958533,21968666:21968709,21968667:21968906,21969242:22058866,21969754:21969996,21970480:21971333,21971138:21971191,21972980:22058628,21972981:22058140,21972983:22057951,21972985:22057628,21972987:22057801,21972988:22057451,21972989:22057236,21972990:22011969,21972992:22008908,21973005:22009730,21973006:22008345,21973619:22007616,21973621:22006947,21973659:22005597,21973685:22004931,21973711:21976859,21973713:21975733,21977364:22002068,21977381:22001690,21977382:21977979,21977973:22000582,21979049:21979158,21981131:2198381', 'assoc_mat': '21937349:plastique:3726:21942334,21938516:plastique:3726:21938893,21939506:plastique:3726:21939542,21940176:plastique:3726:21941545,21940636:plastique:3726:21940725,21941523:plastique:3726:21942020,21941525:plastique:3726:21941830,21945660:plastique:3726:21946123,21946003:plastique:3726:21946090,21946268:plastique:3726:21946386,21946647:plastique:3726:21946884,21947247:plastique:3726:21947421,21949002:plastique:3726:21949046,21949015:plastique:3726:21949145,21949016:plastique:3726:21949028,21950214:plastique:3726:21950750,21951150:plastique:3726:21951841,21951849:plastique:3726:21951936,21954907:plastique:3726:21962170,21954908:plastique:3726:21962423,21954909:plastique:3726:21961632,21954910:plastique:3726:21960447,21955433:plastique:3726:21955594,21956045:plastique:3726:21958925,21956486:plastique:3726:21956840,21957159:plastique:3726:21957511,21957693:plastique:3726:21957895,21958303:plastique:3726:21958533,21968666:plastique:3726:21968709,21968667:plastique:3726:21968906,21969242:plastique:3726:22058866,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.010230622356344015, 'nb_photo': 2007, 'list_port_cont': '21938890,21939539,21940719,21941536,21941827,21942331,21946088,21946117,21947419,21947594,21949018,21949055,21949143,21950741,21951431,21951848,21951937,21954223,21955598,21956837,21957504,21957891,21958539,21958805,21958920,21960443,21961631,21962176,21962426,21968714,21968917,21969985,21971194,21971339,21973222,21975115,21975730,21976855,21977987,21979157,21981822,21982542,21983810,21984637,21985210,21986006,21987363,21987856,21987900,21989077,21989466,21990092,21991513,21992039,21993214,21993791,21995235,21995346,21996056,21998698,21999730,22001687,22002062,22004923,22005599,22005737,22005853,22006389,22006948,22007609,22008346,22008915,22009746,22010964,22011971,22012760,22013959,22014126,22015907,22016558,22017017,22019010,22019531,22020263,22020357,22021603,22022291,22022715,22022792,22023013,22024075,22025210,22025646,22025728,22025843,22026175,22026303,22026781,22027236,22027348,22027517,22027848,22029637,22030396,22031153,22033107,22034111,22035873,22037558,22038449,22039880,22040396,22042052,2204289', 'assoc_port': '21937349:21942331,21938516:21938890,21939506:21939539,21940176:21941536,21940636:21940719,21941525:21941827,21945660:21946117,21946003:21946088,21947247:21947419,21947539:21947594,21949002:21949055,21949015:21949143,21949016:21949018,21950214:21950741,21951150:21951848,21951151:21951431,21951849:21951937,21952686:21954223,21954907:21962176,21954908:21962426,21954909:21961631,21954910:21960443,21955433:21955598,21956045:21958920,21956486:21956837,21957159:21957504,21957693:21957891,21958303:21958539,21958770:21958805,21968666:21968714,21968667:21968917,21969242:22058861,21969754:21969985,21970480:21971339,21971138:21971194,21972979:22058406,21972980:22058623,21972981:22058147,21972983:22057956,21972987:22057804,21972989:22057232,21972990:22011971,21972992:22008915,21973005:22009746,21973006:22008346,21973008:21973222,21973619:22007609,21973621:22006948,21973629:22005853,21973656:22006389,21973657:22005737,21973659:22005599,21973685:22004923,21973711:21976855,21973713:21975730,21974688:21975115,21977364:2200206', 'assoc_mat': '21937349:Teint_Dans_La_Masse:3726:21942331,21938516:Teint_Dans_La_Masse:3726:21938890,21939506:Teint_Dans_La_Masse:3726:21939539,21940176:Teint_Dans_La_Masse:3726:21941536,21940636:Teint_Dans_La_Masse:3726:21940719,21941525:Teint_Dans_La_Masse:3726:21941827,21945660:Teint_Dans_La_Masse:3726:21946117,21946003:Teint_Dans_La_Masse:3726:21946088,21947247:Teint_Dans_La_Masse:3726:21947419,21947539:Teint_Dans_La_Masse:3726:21947594,21949002:Teint_Dans_La_Masse:3726:21949055,21949015:Teint_Dans_La_Masse:3726:21949143,21949016:Teint_Dans_La_Masse:3726:21949018,21950214:Teint_Dans_La_Masse:3726:21950741,21951150:Teint_Dans_La_Masse:3726:21951848,21951151:Teint_Dans_La_Masse:3726:21951431,21951849:Teint_Dans_La_Masse:3726:21951937,21952686:Teint_Dans_La_Masse:3726:21954223,21954907:Teint_Dans_La_Masse:3726:21962176,21954908:Teint_Dans_La_Masse:3726:21962426,21954909:Teint_Dans_La_Masse:3726:21961631,21954910:Teint_Dans_La_Masse:3726:21960443,21955433:Teint_Dans_La_Masse:3726:21955598,21956045:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 15658}}, 'hostname': (), 'impurety_average_per_hashtag': [(('JRM', '2025-04', 0.03617715350850373),)]} VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3385 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3385 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="arc_en_ciel_jrm_peu_dense"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3385 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3385 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3385 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3385 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3459 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=3459 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 3459 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 3726, 'hashtag_proportion': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,kraft,metal,plastique', 'hashtag_parmi': 'papier,background', 'hashtag_weights': {'Carton_brun': 1.5, 'Carton_gris': 1.5, 'Teint_Dans_La_Masse': 1.0, 'autre_refus': 1.5, 'cartonnette': 1.0, 'kraft': 1.5, 'metal': 3, 'plastique': 1}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((15658,),), 'unwanted_material_monthly_percentage': ((0.03617715350850373,),), 'material_repartition': (('JRM', 14410),), 'material_dict': {'JRM': 14410}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.032904725514844364, 782), (datetime.date(2025, 4, 2), 0.03127953608427425, 1539), (datetime.date(2025, 4, 3), 0.04471003138995447, 582), (datetime.date(2025, 4, 15), 0.034739890995393895, 927), (datetime.date(2025, 4, 16), 0.033360859024979844, 1260), (datetime.date(2025, 4, 17), 0.02808556819053822, 1399), (datetime.date(2025, 4, 18), 0.03948756840293151, 1203), (datetime.date(2025, 4, 19), 0.0329127385425759, 705), (datetime.date(2025, 4, 22), 0.042443140788895405, 541), (datetime.date(2025, 4, 23), 0.04692747858968517, 867), (datetime.date(2025, 4, 24), 0.04288238751726208, 1151), (datetime.date(2025, 4, 25), 0.04491422710504408, 1493), (datetime.date(2025, 4, 28), 0.03109004859547543, 1165), (datetime.date(2025, 4, 29), 0.03396040932670385, 796), (datetime.date(2025, 4, 30), 0.02545698524757958, 1248)), 'impurety_average_data_per_hashtag': {'JRM': ((datetime.date(2025, 4, 1), 0.032904725514844364, 782), (datetime.date(2025, 4, 2), 0.03127953608427425, 1539), (datetime.date(2025, 4, 3), 0.04471003138995447, 582), (datetime.date(2025, 4, 15), 0.034739890995393895, 927), (datetime.date(2025, 4, 16), 0.033360859024979844, 1260), (datetime.date(2025, 4, 17), 0.02808556819053822, 1399), (datetime.date(2025, 4, 18), 0.03948756840293151, 1203), (datetime.date(2025, 4, 19), 0.0329127385425759, 705), (datetime.date(2025, 4, 22), 0.042443140788895405, 541), (datetime.date(2025, 4, 23), 0.04692747858968517, 867), (datetime.date(2025, 4, 24), 0.04288238751726208, 1151), (datetime.date(2025, 4, 25), 0.04491422710504408, 1493), (datetime.date(2025, 4, 28), 0.03109004859547543, 1165), (datetime.date(2025, 4, 29), 0.03396040932670385, 796), (datetime.date(2025, 4, 30), 0.02545698524757958, 1248))}, 'quality_array': [], 'number_of_batch': ((614,),), 'datou_id_sts': 3385, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_refus', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008524882267818312, 'nb_photo': 676, 'list_port_cont': '21939545,21940717,21941543,21941820,21942333,21947417,21950744,21951845,21951935,21954229,21955604,21957893,21958538,21958918,21960451,21962177,21968911,21969990,21975108,21976851,21977983,21982545,21983807,21985209,21986011,21987850,21989076,21991135,21991509,21995234,21998695,21999729,22000580,22002061,22004929,22005596,22005846,22006942,22008909,22011970,22012769,22013954,22014124,22017021,22019540,22020260,22020359,22021607,22022296,22022722,22022791,22023010,22024078,22025731,22025841,22026173,22026305,22027516,22027856,22029641,22030398,22031708,22033108,22034118,22035872,22037562,22038454,22039871,22042051,22042312,22045436,22045445,22046271,22046810,22047492,22048177,22049992,22053599,22054158,22056961,22057233,22057447,22057796,22058401,22058629,22063444,22065423,22065860,22066455,22067525,22068617,22069585,22071241,22071721,22071757,22073844,22074822,22077680,22078638,22080010,22082002,22083655,22084874,22090325,22090479,22092301,22094684,22096744,22098480,22099846,22100784,22103779,22106508,2210666', 'assoc_port': '21937349:21942333,21939506:21939545,21940176:21941543,21940636:21940717,21941525:21941820,21947247:21947417,21950214:21950744,21951150:21951845,21951849:21951935,21952686:21954229,21954907:21962177,21954910:21960451,21955433:21955604,21956045:21958918,21957693:21957893,21958303:21958538,21968667:21968911,21969754:21969990,21972979:22058401,21972980:22058629,21972987:22057796,21972988:22057447,21972989:22057233,21972990:22011970,21972992:22008909,21973621:22006942,21973629:22005846,21973659:22005596,21973685:22004929,21973711:21976851,21974688:21975108,21977364:22002061,21977382:21977983,21977973:22000580,21981131:21983807,21982467:21982545,21984455:21999729,21984456:21986011,21985174:21985209,21987148:21998695,21987843:21987850,21988642:21989076,21991050:21991509,21991053:21991135,21994417:21995234,22012264:22056961,22012283:22029641,22012284:22012769,22013065:22013954,22013946:22014124,22015277:22027856,22016903:22017021,22018850:22024078,22018851:22020359,22019464:22019540,22020025:22020260,22021041:2202229', 'assoc_mat': '21937349:autre_refus:3726:21942333,21939506:autre_refus:3726:21939545,21940176:autre_refus:3726:21941543,21940636:autre_refus:3726:21940717,21941525:autre_refus:3726:21941820,21947247:autre_refus:3726:21947417,21950214:autre_refus:3726:21950744,21951150:autre_refus:3726:21951845,21951849:autre_refus:3726:21951935,21952686:autre_refus:3726:21954229,21954907:autre_refus:3726:21962177,21954910:autre_refus:3726:21960451,21955433:autre_refus:3726:21955604,21956045:autre_refus:3726:21958918,21957693:autre_refus:3726:21957893,21958303:autre_refus:3726:21958538,21968667:autre_refus:3726:21968911,21969754:autre_refus:3726:21969990,21972979:autre_refus:3726:22058401,21972980:autre_refus:3726:22058629,21972987:autre_refus:3726:22057796,21972988:autre_refus:3726:22057447,21972989:autre_refus:3726:22057233,21972990:autre_refus:3726:22011970,21972992:autre_refus:3726:22008909,21973621:autre_refus:3726:22006942,21973629:autre_refus:3726:22005846,21973659:autre_refus:3726:22005596,21973685:autre_refus:3726:22004929,21973711:'}, {'unwanted_material': 'cartonnette', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007375532261292248, 'nb_photo': 1400, 'list_port_cont': '21938264,21938897,21939536,21940715,21941546,21941831,21942022,21942332,21946096,21946390,21946882,21947415,21947596,21949026,21949048,21949147,21950742,21951423,21951847,21951944,21954221,21956836,21957513,21957892,21958532,21958923,21960449,21961641,21962173,21962432,21968711,21968914,21969988,21971187,21971336,21973227,21975106,21976857,21977976,21979159,21981816,21982535,21983806,21984627,21985204,21987353,21987852,21987902,21989080,21989459,21990102,21991508,21992037,21993219,21993787,21995229,21995339,21996046,21998702,21999725,22004932,22005595,22005732,22006941,22007614,22008343,22009742,22010966,22011975,22012770,22013955,22014119,22015897,22016562,22017027,22019011,22019537,22020261,22020362,22021610,22022292,22022718,22022799,22023008,22024081,22025217,22025639,22025732,22025850,22026170,22026296,22026780,22027240,22027354,22027508,22027847,22029643,22030401,22031155,22031701,22033109,22035877,22037564,22038457,22039872,22040394,22042055,22042891,22043781,22045439,22045448,22046265,22046813,2204749', 'assoc_port': '21937349:21942332,21938146:21938264,21938516:21938897,21939506:21939536,21940176:21941546,21940636:21940715,21941523:21942022,21941525:21941831,21946003:21946096,21946268:21946390,21946647:21946882,21947247:21947415,21947539:21947596,21949002:21949048,21949015:21949147,21949016:21949026,21950214:21950742,21951150:21951847,21951151:21951423,21951849:21951944,21952686:21954221,21954907:21962173,21954908:21962432,21954909:21961641,21954910:21960449,21956045:21958923,21956486:21956836,21957159:21957513,21957693:21957892,21958303:21958532,21968666:21968711,21968667:21968914,21969242:22058860,21969754:21969988,21970480:21971336,21971138:21971187,21972980:22058621,21972981:22058146,21972983:22057955,21972984:22057887,21972985:22057620,21972988:22057449,21972990:22011975,21973005:22009742,21973006:22008343,21973008:21973227,21973619:22007614,21973621:22006941,21973657:22005732,21973659:22005595,21973685:22004932,21973711:21976857,21974688:21975106,21977382:21977976,21979049:21979159,21981131:21983806,21981750:2198181', 'assoc_mat': '21937349:cartonnette:3726:21942332,21938146:cartonnette:3726:21938264,21938516:cartonnette:3726:21938897,21939506:cartonnette:3726:21939536,21940176:cartonnette:3726:21941546,21940636:cartonnette:3726:21940715,21941523:cartonnette:3726:21942022,21941525:cartonnette:3726:21941831,21946003:cartonnette:3726:21946096,21946268:cartonnette:3726:21946390,21946647:cartonnette:3726:21946882,21947247:cartonnette:3726:21947415,21947539:cartonnette:3726:21947596,21949002:cartonnette:3726:21949048,21949015:cartonnette:3726:21949147,21949016:cartonnette:3726:21949026,21950214:cartonnette:3726:21950742,21951150:cartonnette:3726:21951847,21951151:cartonnette:3726:21951423,21951849:cartonnette:3726:21951944,21952686:cartonnette:3726:21954221,21954907:cartonnette:3726:21962173,21954908:cartonnette:3726:21962432,21954909:cartonnette:3726:21961641,21954910:cartonnette:3726:21960449,21956045:cartonnette:3726:21958923,21956486:cartonnette:3726:21956836,21957159:cartonnette:3726:21957513,21957693:cartonnette:3726:21957892,21958303:'}, {'unwanted_material': 'Carton_brun', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.010123351118372216, 'nb_photo': 1266, 'list_port_cont': '21940714,21941824,21947414,21949025,21949045,21950747,21951427,21951844,21951946,21954220,21958537,21960441,21961636,21962172,21962430,21968916,21969994,21973226,21975112,21975738,21976861,21981820,21982536,21985202,21987359,21987847,21987895,21992043,21993786,21995344,21996053,21998693,21999734,22000581,22002060,22005603,22005741,22006386,22006946,22007606,22008344,22008905,22010959,22012771,22013958,22014127,22015899,22016565,22017020,22019012,22019541,22020269,22020365,22021606,22022300,22022714,22022795,22023009,22024080,22024441,22025212,22025643,22025724,22025845,22026174,22026306,22026779,22027235,22027355,22027515,22027853,22029638,22030392,22031704,22033113,22034112,22035882,22037561,22038446,22039870,22040389,22042054,22042894,22045442,22046267,22046807,22047499,22048170,22050835,22053929,22054155,22056957,22057945,22058144,22058396,22058625,22058864,22063443,22065422,22065865,22066450,22067532,22067599,22068620,22069587,22071248,22071722,22071758,22072616,22073845,22074821,22075216,22075305,2207582', 'assoc_port': '21940636:21940714,21941525:21941824,21947247:21947414,21949002:21949045,21949016:21949025,21950214:21950747,21951150:21951844,21951151:21951427,21951849:21951946,21952686:21954220,21954907:21962172,21954908:21962430,21954909:21961636,21954910:21960441,21958303:21958537,21968667:21968916,21969242:22058864,21969754:21969994,21972979:22058396,21972980:22058625,21972981:22058144,21972983:22057945,21972992:22008905,21973006:22008344,21973008:21973226,21973619:22007606,21973621:22006946,21973656:22006386,21973657:22005741,21973659:22005603,21973711:21976861,21973713:21975738,21974688:21975112,21977364:22002060,21977973:22000581,21981750:21981820,21982467:21982536,21984455:21999734,21985174:21985202,21987148:21998693,21987149:21987359,21987150:21987895,21987843:21987847,21991913:21992043,21993540:21993786,21995227:21995344,21995732:21996053,22010720:22010959,22012264:22056957,22012283:22029638,22012284:22012771,22013065:22013958,22013946:22014127,22015277:22027853,22015290:22016565,22015362:22015899,22016903:2201702', 'assoc_mat': '21940636:Carton_brun:3726:21940714,21941525:Carton_brun:3726:21941824,21947247:Carton_brun:3726:21947414,21949002:Carton_brun:3726:21949045,21949016:Carton_brun:3726:21949025,21950214:Carton_brun:3726:21950747,21951150:Carton_brun:3726:21951844,21951151:Carton_brun:3726:21951427,21951849:Carton_brun:3726:21951946,21952686:Carton_brun:3726:21954220,21954907:Carton_brun:3726:21962172,21954908:Carton_brun:3726:21962430,21954909:Carton_brun:3726:21961636,21954910:Carton_brun:3726:21960441,21958303:Carton_brun:3726:21958537,21968667:Carton_brun:3726:21968916,21969242:Carton_brun:3726:22058864,21969754:Carton_brun:3726:21969994,21972979:Carton_brun:3726:22058396,21972980:Carton_brun:3726:22058625,21972981:Carton_brun:3726:22058144,21972983:Carton_brun:3726:22057945,21972992:Carton_brun:3726:22008905,21973006:Carton_brun:3726:22008344,21973008:Carton_brun:3726:21973226,21973619:Carton_brun:3726:22007606,21973621:Carton_brun:3726:22006946,21973656:Carton_brun:3726:22006386,21973657:Carton_brun:3726:22005741,21973659:'}, {'unwanted_material': 'Carton_gris', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.008151204188285742, 'nb_photo': 757, 'list_port_cont': '21938891,21939537,21941541,21941826,21942024,21942336,21946095,21947601,21949017,21949141,21950743,21951425,21951840,21951945,21957506,21957894,21960452,21961639,21962174,21962422,21968910,21969987,21971193,21971329,21973218,21975110,21975734,21977986,21979165,21981821,21982544,21983816,21984628,21985206,21987358,21987849,21987899,21989073,21989465,21990101,21993212,21993794,21995230,21995343,21996050,21998697,21999727,22000579,22005598,22005856,22006379,22007610,22008348,22008910,22012768,22013961,22014123,22015904,22017028,22019007,22020262,22020368,22021601,22022290,22022719,22022794,22023017,22025734,22025844,22026167,22026301,22026772,22027234,22027345,22027518,22027857,22029642,22030399,22033112,22035881,22037555,22038456,22040395,22042057,22042313,22042885,22043771,22045440,22046814,22048166,22054151,22056960,22057231,22057626,22057794,22057952,22058141,22058400,22058626,22058858,22063438,22065424,22066458,22068621,22069596,22071239,22071752,22073850,22074824,22075220,22075827,22078646,22080017,2208200', 'assoc_port': '21937349:21942336,21938516:21938891,21939506:21939537,21940176:21941541,21941523:21942024,21941525:21941826,21946003:21946095,21947539:21947601,21949015:21949141,21949016:21949017,21950214:21950743,21951150:21951840,21951151:21951425,21951849:21951945,21954907:21962174,21954908:21962422,21954909:21961639,21954910:21960452,21957159:21957506,21957693:21957894,21968667:21968910,21969242:22058858,21969754:21969987,21970480:21971329,21971138:21971193,21972979:22058400,21972980:22058626,21972981:22058141,21972983:22057952,21972985:22057626,21972987:22057794,21972989:22057231,21972992:22008910,21973006:22008348,21973008:21973218,21973619:22007610,21973629:22005856,21973656:22006379,21973659:22005598,21973713:21975734,21974688:21975110,21977382:21977986,21977973:22000579,21979049:21979165,21981131:21983816,21981750:21981821,21982467:21982544,21984455:21999727,21984457:21984628,21985174:21985206,21987148:21998697,21987149:21987358,21987150:21987899,21987843:21987849,21988642:21989073,21989272:21989465,21989851:2199010', 'assoc_mat': '21937349:Carton_gris:3726:21942336,21938516:Carton_gris:3726:21938891,21939506:Carton_gris:3726:21939537,21940176:Carton_gris:3726:21941541,21941523:Carton_gris:3726:21942024,21941525:Carton_gris:3726:21941826,21946003:Carton_gris:3726:21946095,21947539:Carton_gris:3726:21947601,21949015:Carton_gris:3726:21949141,21949016:Carton_gris:3726:21949017,21950214:Carton_gris:3726:21950743,21951150:Carton_gris:3726:21951840,21951151:Carton_gris:3726:21951425,21951849:Carton_gris:3726:21951945,21954907:Carton_gris:3726:21962174,21954908:Carton_gris:3726:21962422,21954909:Carton_gris:3726:21961639,21954910:Carton_gris:3726:21960452,21957159:Carton_gris:3726:21957506,21957693:Carton_gris:3726:21957894,21968667:Carton_gris:3726:21968910,21969242:Carton_gris:3726:22058858,21969754:Carton_gris:3726:21969987,21970480:Carton_gris:3726:21971329,21971138:Carton_gris:3726:21971193,21972979:Carton_gris:3726:22058400,21972980:Carton_gris:3726:22058626,21972981:Carton_gris:3726:22058141,21972983:Carton_gris:3726:22057952,21972985:'}, {'unwanted_material': 'kraft', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.002604242673632418, 'nb_photo': 133, 'list_port_cont': '21977981,21983811,21985207,22006382,22017024,22019009,22020270,22020366,22024073,22025847,22026177,22026304,22026776,22027514,22035880,22037559,22038453,22040393,22042049,22046263,22053923,22065429,22066452,22067527,22071246,22073843,22074828,22080008,22082009,22083654,22092305,22094675,22094912,22123992,22155467,22155903,22158881,22180049,22184353,22193523,22199204,22203059,22208944,22213840,22217231,22217701,22220867,22222325,22230090,22233733,22245339,22292440,22293845,22296334,22297249,22299325,22299862,22300223,22300432,22302901,22330631,22331877,22336818,22337787,22340957,22342837,22347544,22351103,22352968,22356450,22375712,22377207,22377292,22378924,22383897,22385348,22385684,22393633,22393640,22398250,22400374,22405291,22408553,22409664,22411823,22421719,22425281,22426989,22428128,22428869,22429941,22431102,22431540,22433934,22435435,22438516,22440153,22444247,22446527,22463615,22476079,22479964,22494770,22494815,22511634,22512234,22516425,22520075,22524898,22524908,22538004,22542658,22565237,2256575', 'assoc_port': '21973656:22006382,21977382:21977981,21981131:21983811,21985174:21985207,22016903:22017024,22018850:22024073,22018851:22020366,22018852:22019009,22020025:22020270,22025602:22027514,22025605:22026776,22025607:22026304,22025751:22026177,22025752:22025847,22033508:22053923,22035450:22035880,22037104:22037559,22037968:22038453,22039770:22042049,22040278:22040393,22046140:22046263,22064824:22065429,22066283:22066452,22067410:22067527,22070826:22071246,22073126:22074828,22073726:22073843,22079627:22080008,22081402:22082009,22083525:22083654,22092127:22092305,22094130:22094675,22094736:22094912,22123930:22123992,22154159:22155467,22155479:22155903,22158748:22158881,22179166:22180049,22183776:22184353,22189425:22233733,22193306:22193523,22198756:22199204,22202704:22230090,22202706:22203059,22208520:22217231,22208522:22208944,22213698:22213840,22217591:22217701,22219297:22220867,22221127:22222325,22245318:22245339,22289234:22292440,22292234:22293845,22295185:22302901,22295187:22296334,22296942:22297249,22298204:2229932', 'assoc_mat': '21973656:kraft:3726:22006382,21977382:kraft:3726:21977981,21981131:kraft:3726:21983811,21985174:kraft:3726:21985207,22016903:kraft:3726:22017024,22018850:kraft:3726:22024073,22018851:kraft:3726:22020366,22018852:kraft:3726:22019009,22020025:kraft:3726:22020270,22025602:kraft:3726:22027514,22025605:kraft:3726:22026776,22025607:kraft:3726:22026304,22025751:kraft:3726:22026177,22025752:kraft:3726:22025847,22033508:kraft:3726:22053923,22035450:kraft:3726:22035880,22037104:kraft:3726:22037559,22037968:kraft:3726:22038453,22039770:kraft:3726:22042049,22040278:kraft:3726:22040393,22046140:kraft:3726:22046263,22064824:kraft:3726:22065429,22066283:kraft:3726:22066452,22067410:kraft:3726:22067527,22070826:kraft:3726:22071246,22073126:kraft:3726:22074828,22073726:kraft:3726:22073843,22079627:kraft:3726:22080008,22081402:kraft:3726:22082009,22083525:kraft:3726:22083654,22092127:kraft:3726:22092305,22094130:kraft:3726:22094675,22094736:kraft:3726:22094912,22123930:kraft:3726:22123992,22154159:kraft:3726:22155467,22155479:'}, {'unwanted_material': 'metal', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.0023373291109582187, 'nb_photo': 71, 'list_port_cont': '21938899,21939543,21958928,21971190,21993789,21999728,22004933,22012763,22017025,22042886,22045469,22046808,22057237,22058863,22066454,22084880,22089593,22134964,22141536,22157403,22176074,22180050,22196012,22205133,22208697,22217232,22222321,22231980,22246228,22246889,22296336,22299870,22305645,22338246,22340953,22343370,22346258,22354172,22355579,22356734,22390518,22392327,22406224,22406284,22409668,22412952,22424158,22425275,22425282,22426028,22426986,22429933,22447168,22454089,22471514,22473166,22479966,22490338,22490362,22510159,22515714,22521366,22523208,22542660,22549001,22550924,22564741', 'assoc_port': '21938516:21938899,21939506:21939543,21956045:21958928,21969242:22058863,21971138:21971190,21972989:22057237,21973685:22004933,21984455:21999728,21993540:21993789,22012284:22012763,22016903:22017025,22042804:22042886,22045277:22045469,22046685:22046808,22066283:22066454,22082389:22084880,22089462:22089593,22134675:22134964,22141307:22141536,22157210:22157403,22176017:22176074,22179166:22180050,22189424:22196012,22202703:22231980,22204505:22205133,22208520:22217232,22208521:22208697,22221127:22222321,22246126:22246228,22246839:22246889,22289235:22305645,22295187:22296336,22299500:22299870,22337916:22338246,22337933:22346258,22340605:22340953,22343049:22343370,22354081:22354172,22355140:22355579,22356644:22356734,22389620:22412952,22389622:22390518,22391339:22392327,22404280:22409668,22406055:22406224,22406056:22406284,22423926:22425275,22423928:22424158,22425012:22479966,22425014:22425282,22425813:22426028,22426756:22426986,22428979:22429933,22446413:22447168,22453208:22454089,22471399:22471514,22473003:2247316', 'assoc_mat': '21938516:metal:3726:21938899,21939506:metal:3726:21939543,21956045:metal:3726:21958928,21969242:metal:3726:22058863,21971138:metal:3726:21971190,21972989:metal:3726:22057237,21973685:metal:3726:22004933,21984455:metal:3726:21999728,21993540:metal:3726:21993789,22012284:metal:3726:22012763,22016903:metal:3726:22017025,22042804:metal:3726:22042886,22045277:metal:3726:22045469,22046685:metal:3726:22046808,22066283:metal:3726:22066454,22082389:metal:3726:22084880,22089462:metal:3726:22089593,22134675:metal:3726:22134964,22141307:metal:3726:22141536,22157210:metal:3726:22157403,22176017:metal:3726:22176074,22179166:metal:3726:22180050,22189424:metal:3726:22196012,22202703:metal:3726:22231980,22204505:metal:3726:22205133,22208520:metal:3726:22217232,22208521:metal:3726:22208697,22221127:metal:3726:22222321,22246126:metal:3726:22246228,22246839:metal:3726:22246889,22289235:metal:3726:22305645,22295187:metal:3726:22296336,22299500:metal:3726:22299870,22337916:metal:3726:22338246,22337933:metal:3726:22346258,22340605:'}, {'unwanted_material': 'plastique', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.007286581082883396, 'nb_photo': 1111, 'list_port_cont': '21938893,21939542,21940725,21941545,21941830,21942020,21942334,21946090,21946123,21946386,21946884,21947421,21949028,21949046,21949145,21950750,21951841,21951936,21955594,21956840,21957511,21957895,21958533,21958925,21960447,21961632,21962170,21962423,21968709,21968906,21969996,21971191,21971333,21975733,21976859,21977979,21979158,21982540,21983812,21984634,21986010,21987355,21987858,21987897,21989082,21989463,21990096,21993796,21995228,21995345,21996051,21998704,21999732,22000582,22001690,22002068,22004931,22005597,22006947,22007616,22008345,22008908,22009730,22011969,22012766,22013957,22014121,22015906,22016564,22017018,22019002,22019538,22020364,22021608,22022297,22022724,22022793,22023007,22024084,22024446,22025214,22025642,22025729,22025848,22026171,22026299,22026773,22027349,22027511,22027850,22029647,22031145,22031707,22033110,22035875,22038452,22042314,22042888,22043779,22045454,22046262,22046811,22047503,22048167,22050833,22053927,22057236,22057451,22057628,22057801,22057951,22058140,22058628,2205886', 'assoc_port': '21937349:21942334,21938516:21938893,21939506:21939542,21940176:21941545,21940636:21940725,21941523:21942020,21941525:21941830,21945660:21946123,21946003:21946090,21946268:21946386,21946647:21946884,21947247:21947421,21949002:21949046,21949015:21949145,21949016:21949028,21950214:21950750,21951150:21951841,21951849:21951936,21954907:21962170,21954908:21962423,21954909:21961632,21954910:21960447,21955433:21955594,21956045:21958925,21956486:21956840,21957159:21957511,21957693:21957895,21958303:21958533,21968666:21968709,21968667:21968906,21969242:22058866,21969754:21969996,21970480:21971333,21971138:21971191,21972980:22058628,21972981:22058140,21972983:22057951,21972985:22057628,21972987:22057801,21972988:22057451,21972989:22057236,21972990:22011969,21972992:22008908,21973005:22009730,21973006:22008345,21973619:22007616,21973621:22006947,21973659:22005597,21973685:22004931,21973711:21976859,21973713:21975733,21977364:22002068,21977381:22001690,21977382:21977979,21977973:22000582,21979049:21979158,21981131:2198381', 'assoc_mat': '21937349:plastique:3726:21942334,21938516:plastique:3726:21938893,21939506:plastique:3726:21939542,21940176:plastique:3726:21941545,21940636:plastique:3726:21940725,21941523:plastique:3726:21942020,21941525:plastique:3726:21941830,21945660:plastique:3726:21946123,21946003:plastique:3726:21946090,21946268:plastique:3726:21946386,21946647:plastique:3726:21946884,21947247:plastique:3726:21947421,21949002:plastique:3726:21949046,21949015:plastique:3726:21949145,21949016:plastique:3726:21949028,21950214:plastique:3726:21950750,21951150:plastique:3726:21951841,21951849:plastique:3726:21951936,21954907:plastique:3726:21962170,21954908:plastique:3726:21962423,21954909:plastique:3726:21961632,21954910:plastique:3726:21960447,21955433:plastique:3726:21955594,21956045:plastique:3726:21958925,21956486:plastique:3726:21956840,21957159:plastique:3726:21957511,21957693:plastique:3726:21957895,21958303:plastique:3726:21958533,21968666:plastique:3726:21968709,21968667:plastique:3726:21968906,21969242:plastique:3726:22058866,2'}, {'unwanted_material': 'Teint_Dans_La_Masse', 'main_material': 'JRM', 'pht_type': 3726, 'ratio': 0.010230622356344015, 'nb_photo': 2007, 'list_port_cont': '21938890,21939539,21940719,21941536,21941827,21942331,21946088,21946117,21947419,21947594,21949018,21949055,21949143,21950741,21951431,21951848,21951937,21954223,21955598,21956837,21957504,21957891,21958539,21958805,21958920,21960443,21961631,21962176,21962426,21968714,21968917,21969985,21971194,21971339,21973222,21975115,21975730,21976855,21977987,21979157,21981822,21982542,21983810,21984637,21985210,21986006,21987363,21987856,21987900,21989077,21989466,21990092,21991513,21992039,21993214,21993791,21995235,21995346,21996056,21998698,21999730,22001687,22002062,22004923,22005599,22005737,22005853,22006389,22006948,22007609,22008346,22008915,22009746,22010964,22011971,22012760,22013959,22014126,22015907,22016558,22017017,22019010,22019531,22020263,22020357,22021603,22022291,22022715,22022792,22023013,22024075,22025210,22025646,22025728,22025843,22026175,22026303,22026781,22027236,22027348,22027517,22027848,22029637,22030396,22031153,22033107,22034111,22035873,22037558,22038449,22039880,22040396,22042052,2204289', 'assoc_port': '21937349:21942331,21938516:21938890,21939506:21939539,21940176:21941536,21940636:21940719,21941525:21941827,21945660:21946117,21946003:21946088,21947247:21947419,21947539:21947594,21949002:21949055,21949015:21949143,21949016:21949018,21950214:21950741,21951150:21951848,21951151:21951431,21951849:21951937,21952686:21954223,21954907:21962176,21954908:21962426,21954909:21961631,21954910:21960443,21955433:21955598,21956045:21958920,21956486:21956837,21957159:21957504,21957693:21957891,21958303:21958539,21958770:21958805,21968666:21968714,21968667:21968917,21969242:22058861,21969754:21969985,21970480:21971339,21971138:21971194,21972979:22058406,21972980:22058623,21972981:22058147,21972983:22057956,21972987:22057804,21972989:22057232,21972990:22011971,21972992:22008915,21973005:22009746,21973006:22008346,21973008:21973222,21973619:22007609,21973621:22006948,21973629:22005853,21973656:22006389,21973657:22005737,21973659:22005599,21973685:22004923,21973711:21976855,21973713:21975730,21974688:21975115,21977364:2200206', 'assoc_mat': '21937349:Teint_Dans_La_Masse:3726:21942331,21938516:Teint_Dans_La_Masse:3726:21938890,21939506:Teint_Dans_La_Masse:3726:21939539,21940176:Teint_Dans_La_Masse:3726:21941536,21940636:Teint_Dans_La_Masse:3726:21940719,21941525:Teint_Dans_La_Masse:3726:21941827,21945660:Teint_Dans_La_Masse:3726:21946117,21946003:Teint_Dans_La_Masse:3726:21946088,21947247:Teint_Dans_La_Masse:3726:21947419,21947539:Teint_Dans_La_Masse:3726:21947594,21949002:Teint_Dans_La_Masse:3726:21949055,21949015:Teint_Dans_La_Masse:3726:21949143,21949016:Teint_Dans_La_Masse:3726:21949018,21950214:Teint_Dans_La_Masse:3726:21950741,21951150:Teint_Dans_La_Masse:3726:21951848,21951151:Teint_Dans_La_Masse:3726:21951431,21951849:Teint_Dans_La_Masse:3726:21951937,21952686:Teint_Dans_La_Masse:3726:21954223,21954907:Teint_Dans_La_Masse:3726:21962176,21954908:Teint_Dans_La_Masse:3726:21962426,21954909:Teint_Dans_La_Masse:3726:21961631,21954910:Teint_Dans_La_Masse:3726:21960443,21955433:Teint_Dans_La_Masse:3726:21955598,21956045:Teint_Dans_La_Masse:3726:2'}), 'main_stat': {'nb_photos': 15658}}, 'hostname': (), 'impurety_average_per_hashtag': [(('JRM', '2025-04', 0.03617715350850373),)]} filepath : /data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense/sla_mensuel_arc_en_ciel_jrm_peu_dense_mois_04_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'JRM': {'autre_refus': ['autre_refus', '0.85%', 676], 'cartonnette': ['cartonnette', '0.74%', 1400], 'Carton_brun': ['Carton_brun', '1.01%', 1266], 'Carton_gris': ['Carton_gris', '0.82%', 757], 'kraft': ['kraft', '0.26%', 133], 'metal': ['metal', '0.23%', 71], 'plastique': ['plastique', '0.73%', 1111], 'Teint_Dans_La_Masse': ['Teint_Dans_La_Masse', '1.02%', 2007]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense/sla_mensuel_arc_en_ciel_jrm_peu_dense_mois_04_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/arc_en_ciel_jrm_peu_dense 2.91user 2.14system 0:13.17elapsed 38%CPU (0avgtext+0avgdata 191212maxresident)k 122384inputs+552outputs (542major+75994minor)pagefaults 0swaps