python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j exemple_contaminant_stat -v --date 2025-10 --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-10 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (2, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Working exemple contaminant stat SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-10-01" AND ded.date <= "2025-10-31" 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 (2384953,2392600,2406372,2406357,2406351,2408597,2412709,2419637,2428107,2436195,2442077,2442777,2450016,2457661,2465477,2468735,2473650,2477027,2484329,2484209,2484315,2484303,2484299,2484283,2484275,2484225,2484261,2493485,2493515,2496805) 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', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014705980367627302, 'nb_photo': 16760, 'list_port_cont': '27419801,27420588,27420625,27420726,27421186,27421779,27422314,27422706,27423375,27423737,27423886,27424167,27424593,27424939,27425344,27425442,27425645,27426153,27426582,27426686,27426959,27427038,27427360,27459206,27459419,27459616,27459910,27460226,27460411,27460611,27460728,27460894,27461086,27461122,27461303,27461580,27461610,27461700,27461733,27461834,27461868,27461917,27462105,27462264,27462320,27538869,27538881,27539099,27539241,27539418,27539567,27539886,27540272,27540930,27541335,27541495,27541812,27542514,27542988,27543315,27543622,27543868,27544015,27544202,27544424,27544577,27544715,27546253,27546327,27546606,27546804,27546928,27547004,27547086,27547120,27547465,27548128,27548307,27548729,27549041,27549590,27550796,27551567,27552189,27552249,27553063,27557732,27557852,27558126,27558679,27558973,27559342,27560248,27560400,27561002,27561460,27561801,27562122,27562407,27563118,27563698,27564342,27564554,27564720,27565030,27565438,27565627,27566045,27572055,27572139,27572185,27572266,27572358,2757239', 'assoc_port': '27419509:27427038,27419511:27427360,27419514:27426959,27419518:27426686,27419521:27426153,27419523:27426582,27419529:27425645,27419531:27425344,27419537:27424939,27419539:27425442,27419543:27424167,27419546:27423886,27419551:27423375,27419556:27423737,27419558:27422706,27419563:27421779,27419567:27420726,27419569:27421186,27419573:27420588,27419601:27420625,27419606:27419801,27421651:27422314,27424393:27424593,27458264:27460728,27458267:27460894,27458270:27461086,27458273:27461303,27458276:27461733,27458278:27461834,27458281:27462264,27458283:27462105,27458285:27461700,27458287:27461917,27458289:27461868,27458291:27461580,27458293:27461610,27458295:27461122,27458297:27460611,27458299:27460411,27458301:27459616,27458303:27460226,27458305:27459206,27458307:27459419,27459638:27459910,27462139:27462320,27530981:27538881,27530984:27538869,27530988:27539099,27530992:27539241,27530995:27539418,27530999:27539567,27531003:27539886,27531007:27540272,27531016:27540930,27531021:27541495,27531025:27541335,27531030:2754181', 'assoc_mat': '27419509:autre:4230:27427038,27419511:autre:4230:27427360,27419514:autre:4230:27426959,27419518:autre:4230:27426686,27419521:autre:4230:27426153,27419523:autre:4230:27426582,27419529:autre:4230:27425645,27419531:autre:4230:27425344,27419537:autre:4230:27424939,27419539:autre:4230:27425442,27419543:autre:4230:27424167,27419546:autre:4230:27423886,27419551:autre:4230:27423375,27419556:autre:4230:27423737,27419558:autre:4230:27422706,27419563:autre:4230:27421779,27419567:autre:4230:27420726,27419569:autre:4230:27421186,27419573:autre:4230:27420588,27419601:autre:4230:27420625,27419606:autre:4230:27419801,27421651:autre:4230:27422314,27424393:autre:4230:27424593,27458264:autre:4230:27460728,27458267:autre:4230:27460894,27458270:autre:4230:27461086,27458273:autre:4230:27461303,27458276:autre:4230:27461733,27458278:autre:4230:27461834,27458281:autre:4230:27462264,27458283:autre:4230:27462105,27458285:autre:4230:27461700,27458287:autre:4230:27461917,27458289:autre:4230:27461868,27458291:autre:4230:27461580,27458293:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06444572547294747, 'nb_photo': 113444, 'list_port_cont': '27419811,27420593,27420622,27420734,27421191,27421791,27422330,27422720,27423380,27423740,27423885,27424175,27424598,27424946,27425340,27425450,27425652,27426151,27426592,27426676,27426969,27427044,27427369,27459216,27459425,27459615,27459916,27460228,27460420,27460609,27460732,27460895,27461083,27461127,27461311,27461572,27461624,27461694,27461744,27461840,27461872,27461914,27462112,27462267,27462314,27538862,27538891,27539105,27539254,27539416,27539581,27539895,27540261,27540940,27541343,27541491,27541821,27542513,27542987,27543316,27543630,27543870,27544025,27544210,27544432,27544582,27544728,27546260,27546333,27546604,27546801,27546920,27547012,27547095,27547132,27547468,27548139,27548311,27548739,27549055,27549595,27550782,27551573,27552206,27552245,27553056,27557734,27557851,27558140,27558673,27558986,27559345,27560259,27560392,27561005,27561473,27561800,27562132,27562399,27563127,27563699,27564341,27564570,27564730,27565040,27565452,27565635,27566048,27572070,27572137,27572202,27572261,27572357,2757240', 'assoc_port': '27419509:27427044,27419511:27427369,27419514:27426969,27419518:27426676,27419521:27426151,27419523:27426592,27419529:27425652,27419531:27425340,27419537:27424946,27419539:27425450,27419543:27424175,27419546:27423885,27419551:27423380,27419556:27423740,27419558:27422720,27419563:27421791,27419567:27420734,27419569:27421191,27419573:27420593,27419601:27420622,27419606:27419811,27421651:27422330,27424393:27424598,27458264:27460732,27458267:27460895,27458270:27461083,27458273:27461311,27458276:27461744,27458278:27461840,27458281:27462267,27458283:27462112,27458285:27461694,27458287:27461914,27458289:27461872,27458291:27461572,27458293:27461624,27458295:27461127,27458297:27460609,27458299:27460420,27458301:27459615,27458303:27460228,27458305:27459216,27458307:27459425,27459638:27459916,27462139:27462314,27530981:27538891,27530984:27538862,27530988:27539105,27530992:27539254,27530995:27539416,27530999:27539581,27531003:27539895,27531007:27540261,27531016:27540940,27531021:27541491,27531025:27541343,27531030:2754182', 'assoc_mat': '27419509:carton:4230:27427044,27419511:carton:4230:27427369,27419514:carton:4230:27426969,27419518:carton:4230:27426676,27419521:carton:4230:27426151,27419523:carton:4230:27426592,27419529:carton:4230:27425652,27419531:carton:4230:27425340,27419537:carton:4230:27424946,27419539:carton:4230:27425450,27419543:carton:4230:27424175,27419546:carton:4230:27423885,27419551:carton:4230:27423380,27419556:carton:4230:27423740,27419558:carton:4230:27422720,27419563:carton:4230:27421791,27419567:carton:4230:27420734,27419569:carton:4230:27421191,27419573:carton:4230:27420593,27419601:carton:4230:27420622,27419606:carton:4230:27419811,27421651:carton:4230:27422330,27424393:carton:4230:27424598,27458264:carton:4230:27460732,27458267:carton:4230:27460895,27458270:carton:4230:27461083,27458273:carton:4230:27461311,27458276:carton:4230:27461744,27458278:carton:4230:27461840,27458281:carton:4230:27462267,27458283:carton:4230:27462112,27458285:carton:4230:27461694,27458287:carton:4230:27461914,27458289:carton:4230:27461872,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015643915775535387, 'nb_photo': 2028, 'list_port_cont': '27419796,27420579,27420621,27420718,27421199,27421793,27422326,27422711,27423383,27423730,27423882,27424170,27424591,27425448,27425650,27426157,27426579,27426685,27427041,27459213,27459421,27459614,27459905,27460236,27460414,27460604,27460731,27460885,27461081,27461130,27461309,27461574,27461619,27461702,27461731,27461823,27461865,27461909,27462100,27462266,27462319,27538878,27539090,27539240,27539570,27539896,27540269,27540935,27541336,27542507,27542984,27543632,27543854,27544203,27544425,27544726,27546256,27546322,27546605,27546797,27546929,27547010,27547119,27547456,27548125,27548308,27548730,27549053,27550788,27551578,27552196,27552241,27557730,27557861,27558136,27558676,27558972,27559340,27560252,27560393,27561004,27561462,27561793,27562121,27562392,27563687,27564331,27564556,27564726,27565023,27565445,27565632,27566051,27572149,27572267,27572346,27572401,27572579,27572615,27572687,27572899,27573004,27573072,27573114,27573170,27573308,27573386,27576025,27576597,27579535,27580955,27581923,27583495,2758443', 'assoc_port': '27419509:27427041,27419518:27426685,27419521:27426157,27419523:27426579,27419529:27425650,27419539:27425448,27419543:27424170,27419546:27423882,27419551:27423383,27419556:27423730,27419558:27422711,27419563:27421793,27419567:27420718,27419569:27421199,27419573:27420579,27419601:27420621,27419606:27419796,27421651:27422326,27424393:27424591,27458264:27460731,27458267:27460885,27458270:27461081,27458273:27461309,27458276:27461731,27458278:27461823,27458281:27462266,27458283:27462100,27458285:27461702,27458287:27461909,27458289:27461865,27458291:27461574,27458293:27461619,27458295:27461130,27458297:27460604,27458299:27460414,27458301:27459614,27458303:27460236,27458305:27459213,27458307:27459421,27459638:27459905,27462139:27462319,27530981:27538878,27530988:27539090,27530992:27539240,27530999:27539570,27531003:27539896,27531007:27540269,27531016:27540935,27531025:27541336,27531034:27542507,27531038:27542984,27531048:27543632,27531051:27543854,27531058:27546256,27531065:27544203,27531066:27546322,27531073:2754442', 'assoc_mat': '27419509:metal:4230:27427041,27419518:metal:4230:27426685,27419521:metal:4230:27426157,27419523:metal:4230:27426579,27419529:metal:4230:27425650,27419539:metal:4230:27425448,27419543:metal:4230:27424170,27419546:metal:4230:27423882,27419551:metal:4230:27423383,27419556:metal:4230:27423730,27419558:metal:4230:27422711,27419563:metal:4230:27421793,27419567:metal:4230:27420718,27419569:metal:4230:27421199,27419573:metal:4230:27420579,27419601:metal:4230:27420621,27419606:metal:4230:27419796,27421651:metal:4230:27422326,27424393:metal:4230:27424591,27458264:metal:4230:27460731,27458267:metal:4230:27460885,27458270:metal:4230:27461081,27458273:metal:4230:27461309,27458276:metal:4230:27461731,27458278:metal:4230:27461823,27458281:metal:4230:27462266,27458283:metal:4230:27462100,27458285:metal:4230:27461702,27458287:metal:4230:27461909,27458289:metal:4230:27461865,27458291:metal:4230:27461574,27458293:metal:4230:27461619,27458295:metal:4230:27461130,27458297:metal:4230:27460604,27458299:metal:4230:27460414,27458301:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18504152570739973, 'nb_photo': 320130, 'list_port_cont': '27419810,27420587,27420627,27420735,27421196,27421792,27422328,27422719,27423374,27423735,27423888,27424183,27424592,27424951,27425346,27425445,27425651,27426164,27426588,27426691,27426965,27427034,27427371,27459217,27459423,27459604,27459909,27460227,27460417,27460608,27460733,27460901,27461076,27461133,27461300,27461582,27461621,27461706,27461735,27461836,27461873,27461921,27462110,27462257,27462322,27538870,27538885,27539093,27539249,27539429,27539576,27539891,27540273,27540936,27541345,27541503,27541827,27542521,27543001,27543320,27543629,27543863,27544019,27544215,27544431,27544583,27544721,27546264,27546323,27546599,27546808,27546925,27547013,27547092,27547133,27547464,27548138,27548298,27548735,27549056,27549596,27550786,27551582,27552200,27552251,27553064,27557727,27557858,27558137,27558666,27558975,27559349,27560250,27560397,27561003,27561472,27561796,27562129,27562401,27563126,27563691,27564333,27564569,27564735,27565031,27565444,27565636,27566055,27572063,27572143,27572200,27572263,27572363,2757240', 'assoc_port': '27419509:27427034,27419511:27427371,27419514:27426965,27419518:27426691,27419521:27426164,27419523:27426588,27419529:27425651,27419531:27425346,27419537:27424951,27419539:27425445,27419543:27424183,27419546:27423888,27419551:27423374,27419556:27423735,27419558:27422719,27419563:27421792,27419567:27420735,27419569:27421196,27419573:27420587,27419601:27420627,27419606:27419810,27421651:27422328,27424393:27424592,27458264:27460733,27458267:27460901,27458270:27461076,27458273:27461300,27458276:27461735,27458278:27461836,27458281:27462257,27458283:27462110,27458285:27461706,27458287:27461921,27458289:27461873,27458291:27461582,27458293:27461621,27458295:27461133,27458297:27460608,27458299:27460417,27458301:27459604,27458303:27460227,27458305:27459217,27458307:27459423,27459638:27459909,27462139:27462322,27530981:27538885,27530984:27538870,27530988:27539093,27530992:27539249,27530995:27539429,27530999:27539576,27531003:27539891,27531007:27540273,27531016:27540936,27531021:27541503,27531025:27541345,27531030:2754182', 'assoc_mat': '27419509:papier:4230:27427034,27419511:papier:4230:27427371,27419514:papier:4230:27426965,27419518:papier:4230:27426691,27419521:papier:4230:27426164,27419523:papier:4230:27426588,27419529:papier:4230:27425651,27419531:papier:4230:27425346,27419537:papier:4230:27424951,27419539:papier:4230:27425445,27419543:papier:4230:27424183,27419546:papier:4230:27423888,27419551:papier:4230:27423374,27419556:papier:4230:27423735,27419558:papier:4230:27422719,27419563:papier:4230:27421792,27419567:papier:4230:27420735,27419569:papier:4230:27421196,27419573:papier:4230:27420587,27419601:papier:4230:27420627,27419606:papier:4230:27419810,27421651:papier:4230:27422328,27424393:papier:4230:27424592,27458264:papier:4230:27460733,27458267:papier:4230:27460901,27458270:papier:4230:27461076,27458273:papier:4230:27461300,27458276:papier:4230:27461735,27458278:papier:4230:27461836,27458281:papier:4230:27462257,27458283:papier:4230:27462110,27458285:papier:4230:27461706,27458287:papier:4230:27461921,27458289:papier:4230:27461873,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005226425483397223, 'nb_photo': 2608, 'list_port_cont': '27419812,27420592,27420629,27420727,27421197,27421795,27422327,27422722,27423378,27423738,27423884,27424179,27424584,27424950,27425446,27425646,27426163,27426688,27426964,27427045,27427374,27459211,27459422,27459606,27459914,27460229,27460419,27460614,27460899,27461078,27461126,27461314,27461583,27461612,27461699,27461732,27461835,27461878,27461919,27462104,27462265,27462324,27538868,27538887,27539101,27539251,27539421,27539565,27539894,27540258,27540932,27541334,27541496,27541820,27542522,27542998,27543631,27543865,27544730,27546257,27546328,27546600,27546807,27546927,27547134,27547462,27548140,27548302,27548732,27549049,27549597,27550784,27551570,27552199,27552242,27553054,27557738,27557859,27558131,27558669,27558978,27559350,27560257,27560389,27560995,27561469,27561795,27562127,27562408,27563117,27563701,27564334,27564566,27564733,27565036,27565454,27565628,27566054,27572268,27572359,27572405,27572583,27572614,27572680,27572769,27572886,27573010,27573083,27573117,27573173,27573298,27573376,27576596,2758038', 'assoc_port': '27419509:27427045,27419511:27427374,27419514:27426964,27419518:27426688,27419521:27426163,27419529:27425646,27419537:27424950,27419539:27425446,27419543:27424179,27419546:27423884,27419551:27423378,27419556:27423738,27419558:27422722,27419563:27421795,27419567:27420727,27419569:27421197,27419573:27420592,27419601:27420629,27419606:27419812,27421651:27422327,27424393:27424584,27458267:27460899,27458270:27461078,27458273:27461314,27458276:27461732,27458278:27461835,27458281:27462265,27458283:27462104,27458285:27461699,27458287:27461919,27458289:27461878,27458291:27461583,27458293:27461612,27458295:27461126,27458297:27460614,27458299:27460419,27458301:27459606,27458303:27460229,27458305:27459211,27458307:27459422,27459638:27459914,27462139:27462324,27530981:27538887,27530984:27538868,27530988:27539101,27530992:27539251,27530995:27539421,27530999:27539565,27531003:27539894,27531007:27540258,27531016:27540932,27531021:27541496,27531025:27541334,27531030:27541820,27531034:27542522,27531038:27542998,27531048:2754363', 'assoc_mat': '27419509:pehd:4230:27427045,27419511:pehd:4230:27427374,27419514:pehd:4230:27426964,27419518:pehd:4230:27426688,27419521:pehd:4230:27426163,27419529:pehd:4230:27425646,27419537:pehd:4230:27424950,27419539:pehd:4230:27425446,27419543:pehd:4230:27424179,27419546:pehd:4230:27423884,27419551:pehd:4230:27423378,27419556:pehd:4230:27423738,27419558:pehd:4230:27422722,27419563:pehd:4230:27421795,27419567:pehd:4230:27420727,27419569:pehd:4230:27421197,27419573:pehd:4230:27420592,27419601:pehd:4230:27420629,27419606:pehd:4230:27419812,27421651:pehd:4230:27422327,27424393:pehd:4230:27424584,27458267:pehd:4230:27460899,27458270:pehd:4230:27461078,27458273:pehd:4230:27461314,27458276:pehd:4230:27461732,27458278:pehd:4230:27461835,27458281:pehd:4230:27462265,27458283:pehd:4230:27462104,27458285:pehd:4230:27461699,27458287:pehd:4230:27461919,27458289:pehd:4230:27461878,27458291:pehd:4230:27461583,27458293:pehd:4230:27461612,27458295:pehd:4230:27461126,27458297:pehd:4230:27460614,27458299:pehd:4230:27460419,27458301:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010630832168573186, 'nb_photo': 21067, 'list_port_cont': '27419813,27420596,27420632,27420723,27421185,27421790,27422322,27422712,27423382,27423736,27423887,27424174,27424594,27424941,27425338,27425451,27425641,27426161,27426596,27426689,27426956,27427043,27427375,27459212,27459414,27459610,27459912,27460232,27460413,27460612,27460726,27460896,27461079,27461135,27461304,27461578,27461614,27461705,27461738,27461838,27461879,27461918,27462114,27462262,27462323,27538864,27538884,27539104,27539242,27539427,27539577,27539885,27540265,27540943,27541346,27541501,27541814,27542518,27543000,27543313,27543617,27543862,27544014,27544217,27544430,27544579,27544729,27546267,27546324,27546593,27546809,27546924,27547008,27547096,27547128,27547461,27548136,27548304,27548737,27549051,27549586,27550790,27551575,27552203,27552246,27553060,27557742,27557857,27558141,27558670,27558980,27559346,27560256,27560402,27561008,27561463,27561802,27562128,27562400,27563123,27563690,27564340,27564555,27564731,27565037,27565442,27565637,27566047,27572061,27572138,27572196,27572262,27572355,2757240', 'assoc_port': '27419509:27427043,27419511:27427375,27419514:27426956,27419518:27426689,27419521:27426161,27419523:27426596,27419529:27425641,27419531:27425338,27419537:27424941,27419539:27425451,27419543:27424174,27419546:27423887,27419551:27423382,27419556:27423736,27419558:27422712,27419563:27421790,27419567:27420723,27419569:27421185,27419573:27420596,27419601:27420632,27419606:27419813,27421651:27422322,27424393:27424594,27458264:27460726,27458267:27460896,27458270:27461079,27458273:27461304,27458276:27461738,27458278:27461838,27458281:27462262,27458283:27462114,27458285:27461705,27458287:27461918,27458289:27461879,27458291:27461578,27458293:27461614,27458295:27461135,27458297:27460612,27458299:27460413,27458301:27459610,27458303:27460232,27458305:27459212,27458307:27459414,27459638:27459912,27462139:27462323,27530981:27538884,27530984:27538864,27530988:27539104,27530992:27539242,27530995:27539427,27530999:27539577,27531003:27539885,27531007:27540265,27531016:27540943,27531021:27541501,27531025:27541346,27531030:2754181', 'assoc_mat': '27419509:pet_clair:4230:27427043,27419511:pet_clair:4230:27427375,27419514:pet_clair:4230:27426956,27419518:pet_clair:4230:27426689,27419521:pet_clair:4230:27426161,27419523:pet_clair:4230:27426596,27419529:pet_clair:4230:27425641,27419531:pet_clair:4230:27425338,27419537:pet_clair:4230:27424941,27419539:pet_clair:4230:27425451,27419543:pet_clair:4230:27424174,27419546:pet_clair:4230:27423887,27419551:pet_clair:4230:27423382,27419556:pet_clair:4230:27423736,27419558:pet_clair:4230:27422712,27419563:pet_clair:4230:27421790,27419567:pet_clair:4230:27420723,27419569:pet_clair:4230:27421185,27419573:pet_clair:4230:27420596,27419601:pet_clair:4230:27420632,27419606:pet_clair:4230:27419813,27421651:pet_clair:4230:27422322,27424393:pet_clair:4230:27424594,27458264:pet_clair:4230:27460726,27458267:pet_clair:4230:27460896,27458270:pet_clair:4230:27461079,27458273:pet_clair:4230:27461304,27458276:pet_clair:4230:27461738,27458278:pet_clair:4230:27461838,27458281:pet_clair:4230:27462262,27458283:pet_clair:4230:27462114,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003263674001917912, 'nb_photo': 965, 'list_port_cont': '27420595,27420623,27422718,27423372,27423880,27424942,27425345,27425644,27426152,27427042,27427373,27459214,27459418,27459617,27459913,27460230,27460408,27460600,27460897,27461136,27461573,27461623,27461745,27461876,27461911,27462309,27538857,27538877,27540941,27542515,27543312,27543619,27543869,27544420,27546265,27546334,27546598,27546803,27546917,27547006,27547089,27547123,27547460,27548142,27548312,27551574,27552201,27552244,27557740,27558139,27558674,27558985,27559352,27560258,27561799,27562130,27563121,27564344,27564568,27564727,27565449,27565631,27566057,27572148,27572352,27572406,27572585,27572618,27572763,27572894,27573011,27573077,27573106,27573178,27573306,27579539,27581934,27583821,27584428,27587933,27588745,27588967,27593437,27593970,27594208,27594231,27595201,27595955,27596059,27596389,27596797,27596893,27597528,27599700,27599907,27600894,27601296,27601744,27605097,27605613,27606690,27608702,27610390,27612064,27626203,27690475,27690671,27690869,27691095,27691212,27691671,27692437,27692668,2769274', 'assoc_port': '27419509:27427042,27419511:27427373,27419521:27426152,27419529:27425644,27419531:27425345,27419537:27424942,27419546:27423880,27419551:27423372,27419558:27422718,27419573:27420595,27419601:27420623,27458267:27460897,27458276:27461745,27458287:27461911,27458289:27461876,27458291:27461573,27458293:27461623,27458295:27461136,27458297:27460600,27458299:27460408,27458301:27459617,27458303:27460230,27458305:27459214,27458307:27459418,27459638:27459913,27462139:27462309,27530981:27538877,27530984:27538857,27531016:27540941,27531034:27542515,27531043:27543312,27531048:27543619,27531051:27543869,27531058:27546265,27531066:27546334,27531073:27544420,27531074:27546598,27531082:27546803,27531089:27546917,27531096:27547006,27531103:27547123,27531108:27547089,27531113:27594231,27531117:27547460,27531121:27584428,27531126:27548142,27531130:27548312,27531141:27601744,27531153:27557740,27531155:27551574,27531162:27552201,27531166:27552244,27531168:27558139,27531176:27601296,27531180:27558674,27531184:27558985,27531191:2755935', 'assoc_mat': '27419509:pet_fonce:4230:27427042,27419511:pet_fonce:4230:27427373,27419521:pet_fonce:4230:27426152,27419529:pet_fonce:4230:27425644,27419531:pet_fonce:4230:27425345,27419537:pet_fonce:4230:27424942,27419546:pet_fonce:4230:27423880,27419551:pet_fonce:4230:27423372,27419558:pet_fonce:4230:27422718,27419573:pet_fonce:4230:27420595,27419601:pet_fonce:4230:27420623,27458267:pet_fonce:4230:27460897,27458276:pet_fonce:4230:27461745,27458287:pet_fonce:4230:27461911,27458289:pet_fonce:4230:27461876,27458291:pet_fonce:4230:27461573,27458293:pet_fonce:4230:27461623,27458295:pet_fonce:4230:27461136,27458297:pet_fonce:4230:27460600,27458299:pet_fonce:4230:27460408,27458301:pet_fonce:4230:27459617,27458303:pet_fonce:4230:27460230,27458305:pet_fonce:4230:27459214,27458307:pet_fonce:4230:27459418,27459638:pet_fonce:4230:27459913,27462139:pet_fonce:4230:27462309,27530981:pet_fonce:4230:27538877,27530984:pet_fonce:4230:27538857,27531016:pet_fonce:4230:27540941,27531034:pet_fonce:4230:27542515,27531043:pet_fonce:4230:27543312,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(2384953,2392600,2406372,2406357,2406351,2408597,2412709,2419637,2428107,2436195,2442077,2442777,2450016,2457661,2465477,2468735,2473650,2477027,2484329,2484209,2484315,2484303,2484299,2484283,2484275,2484225,2484261,2493485,2493515,2496805)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124558, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419801,27420588,27420625,27420726,27421186,27421779,27422314,27422706,27423375,27423737,27423886,27424167,27424593,27424939,27425344,27425442,27425645,27426153,27426582,27426686,27426959,27427038,27427360,27459206,27459419,27459616,27459910,27460226,27460411,27460611,27460728,27460894,27461086,27461122,27461303,27461580,27461610,27461700,27461733,27461834,27461868,27461917,27462105,27462264,27462320,27538869,27538881,27539099,27539241,27539418,27539567,27539886,27540272,27540930,27541335,27541495,27541812,27542514,27542988,27543315,27543622,27543868,27544015,27544202,27544424,27544577,27544715,27546253,27546327,27546606,27546804,27546928,27547004,27547086,27547120,27547465,27548128,27548307,27548729,27549041,27549590,27550796,27551567,27552189,27552249,27553063,27557732,27557852,27558126,27558679,27558973,27559342,27560248,27560400,27561002,27561460,27561801,27562122,27562407,27563118,27563698,27564342,27564554,27564720,27565030,27565438,27565627,27566045,27572055,27572139,27572185,27572266,27572358,2757239 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124559, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419811,27420593,27420622,27420734,27421191,27421791,27422330,27422720,27423380,27423740,27423885,27424175,27424598,27424946,27425340,27425450,27425652,27426151,27426592,27426676,27426969,27427044,27427369,27459216,27459425,27459615,27459916,27460228,27460420,27460609,27460732,27460895,27461083,27461127,27461311,27461572,27461624,27461694,27461744,27461840,27461872,27461914,27462112,27462267,27462314,27538862,27538891,27539105,27539254,27539416,27539581,27539895,27540261,27540940,27541343,27541491,27541821,27542513,27542987,27543316,27543630,27543870,27544025,27544210,27544432,27544582,27544728,27546260,27546333,27546604,27546801,27546920,27547012,27547095,27547132,27547468,27548139,27548311,27548739,27549055,27549595,27550782,27551573,27552206,27552245,27553056,27557734,27557851,27558140,27558673,27558986,27559345,27560259,27560392,27561005,27561473,27561800,27562132,27562399,27563127,27563699,27564341,27564570,27564730,27565040,27565452,27565635,27566048,27572070,27572137,27572202,27572261,27572357,2757240 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124560, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419796,27420579,27420621,27420718,27421199,27421793,27422326,27422711,27423383,27423730,27423882,27424170,27424591,27425448,27425650,27426157,27426579,27426685,27427041,27459213,27459421,27459614,27459905,27460236,27460414,27460604,27460731,27460885,27461081,27461130,27461309,27461574,27461619,27461702,27461731,27461823,27461865,27461909,27462100,27462266,27462319,27538878,27539090,27539240,27539570,27539896,27540269,27540935,27541336,27542507,27542984,27543632,27543854,27544203,27544425,27544726,27546256,27546322,27546605,27546797,27546929,27547010,27547119,27547456,27548125,27548308,27548730,27549053,27550788,27551578,27552196,27552241,27557730,27557861,27558136,27558676,27558972,27559340,27560252,27560393,27561004,27561462,27561793,27562121,27562392,27563687,27564331,27564556,27564726,27565023,27565445,27565632,27566051,27572149,27572267,27572346,27572401,27572579,27572615,27572687,27572899,27573004,27573072,27573114,27573170,27573308,27573386,27576025,27576597,27579535,27580955,27581923,27583495,2758443 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124561, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419810,27420587,27420627,27420735,27421196,27421792,27422328,27422719,27423374,27423735,27423888,27424183,27424592,27424951,27425346,27425445,27425651,27426164,27426588,27426691,27426965,27427034,27427371,27459217,27459423,27459604,27459909,27460227,27460417,27460608,27460733,27460901,27461076,27461133,27461300,27461582,27461621,27461706,27461735,27461836,27461873,27461921,27462110,27462257,27462322,27538870,27538885,27539093,27539249,27539429,27539576,27539891,27540273,27540936,27541345,27541503,27541827,27542521,27543001,27543320,27543629,27543863,27544019,27544215,27544431,27544583,27544721,27546264,27546323,27546599,27546808,27546925,27547013,27547092,27547133,27547464,27548138,27548298,27548735,27549056,27549596,27550786,27551582,27552200,27552251,27553064,27557727,27557858,27558137,27558666,27558975,27559349,27560250,27560397,27561003,27561472,27561796,27562129,27562401,27563126,27563691,27564333,27564569,27564735,27565031,27565444,27565636,27566055,27572063,27572143,27572200,27572263,27572363,2757240 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124562, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419812,27420592,27420629,27420727,27421197,27421795,27422327,27422722,27423378,27423738,27423884,27424179,27424584,27424950,27425446,27425646,27426163,27426688,27426964,27427045,27427374,27459211,27459422,27459606,27459914,27460229,27460419,27460614,27460899,27461078,27461126,27461314,27461583,27461612,27461699,27461732,27461835,27461878,27461919,27462104,27462265,27462324,27538868,27538887,27539101,27539251,27539421,27539565,27539894,27540258,27540932,27541334,27541496,27541820,27542522,27542998,27543631,27543865,27544730,27546257,27546328,27546600,27546807,27546927,27547134,27547462,27548140,27548302,27548732,27549049,27549597,27550784,27551570,27552199,27552242,27553054,27557738,27557859,27558131,27558669,27558978,27559350,27560257,27560389,27560995,27561469,27561795,27562127,27562408,27563117,27563701,27564334,27564566,27564733,27565036,27565454,27565628,27566054,27572268,27572359,27572405,27572583,27572614,27572680,27572769,27572886,27573010,27573083,27573117,27573173,27573298,27573376,27576596,2758038 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124563, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419813,27420596,27420632,27420723,27421185,27421790,27422322,27422712,27423382,27423736,27423887,27424174,27424594,27424941,27425338,27425451,27425641,27426161,27426596,27426689,27426956,27427043,27427375,27459212,27459414,27459610,27459912,27460232,27460413,27460612,27460726,27460896,27461079,27461135,27461304,27461578,27461614,27461705,27461738,27461838,27461879,27461918,27462114,27462262,27462323,27538864,27538884,27539104,27539242,27539427,27539577,27539885,27540265,27540943,27541346,27541501,27541814,27542518,27543000,27543313,27543617,27543862,27544014,27544217,27544430,27544579,27544729,27546267,27546324,27546593,27546809,27546924,27547008,27547096,27547128,27547461,27548136,27548304,27548737,27549051,27549586,27550790,27551575,27552203,27552246,27553060,27557742,27557857,27558141,27558670,27558980,27559346,27560256,27560402,27561008,27561463,27561802,27562128,27562400,27563123,27563690,27564340,27564555,27564731,27565037,27565442,27565637,27566047,27572061,27572138,27572196,27572262,27572355,2757240 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124564, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27420595,27420623,27422718,27423372,27423880,27424942,27425345,27425644,27426152,27427042,27427373,27459214,27459418,27459617,27459913,27460230,27460408,27460600,27460897,27461136,27461573,27461623,27461745,27461876,27461911,27462309,27538857,27538877,27540941,27542515,27543312,27543619,27543869,27544420,27546265,27546334,27546598,27546803,27546917,27547006,27547089,27547123,27547460,27548142,27548312,27551574,27552201,27552244,27557740,27558139,27558674,27558985,27559352,27560258,27561799,27562130,27563121,27564344,27564568,27564727,27565449,27565631,27566057,27572148,27572352,27572406,27572585,27572618,27572763,27572894,27573011,27573077,27573106,27573178,27573306,27579539,27581934,27583821,27584428,27587933,27588745,27588967,27593437,27593970,27594208,27594231,27595201,27595955,27596059,27596389,27596797,27596893,27597528,27599700,27599907,27600894,27601296,27601744,27605097,27605613,27606690,27608702,27610390,27612064,27626203,27690475,27690671,27690869,27691095,27691212,27691671,27692437,27692668,2769274 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124558,30124559,30124560,30124561,30124562,30124563,30124564?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce Fonction SLA_MENSUEL nb_day : (2, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 10 mtr_id : dashboard_places : SCCU_cam7 date : 2025-10 year : 2025 raspi : 0 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 = 'SCCU_cam7' and date like '%2025-10%') and created_at like '%2025-10%'))); nb_day : (2, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 10 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 10 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%102025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-10-01 : dt_date_just_month_year : 2025-10-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO 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= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-10-01" AND ded.date <= "2025-10-31" 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 (2384953,2392600,2406372,2406357,2406351,2408597,2412709,2419637,2428107,2436195,2442077,2442777,2450016,2457661,2465477,2468735,2473650,2477027,2484329,2484209,2484315,2484303,2484299,2484283,2484275,2484225,2484261,2493485,2493515,2496805) 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', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014705980367627302, 'nb_photo': 16760, 'list_port_cont': '27419801,27420588,27420625,27420726,27421186,27421779,27422314,27422706,27423375,27423737,27423886,27424167,27424593,27424939,27425344,27425442,27425645,27426153,27426582,27426686,27426959,27427038,27427360,27459206,27459419,27459616,27459910,27460226,27460411,27460611,27460728,27460894,27461086,27461122,27461303,27461580,27461610,27461700,27461733,27461834,27461868,27461917,27462105,27462264,27462320,27538869,27538881,27539099,27539241,27539418,27539567,27539886,27540272,27540930,27541335,27541495,27541812,27542514,27542988,27543315,27543622,27543868,27544015,27544202,27544424,27544577,27544715,27546253,27546327,27546606,27546804,27546928,27547004,27547086,27547120,27547465,27548128,27548307,27548729,27549041,27549590,27550796,27551567,27552189,27552249,27553063,27557732,27557852,27558126,27558679,27558973,27559342,27560248,27560400,27561002,27561460,27561801,27562122,27562407,27563118,27563698,27564342,27564554,27564720,27565030,27565438,27565627,27566045,27572055,27572139,27572185,27572266,27572358,2757239', 'assoc_port': '27419509:27427038,27419511:27427360,27419514:27426959,27419518:27426686,27419521:27426153,27419523:27426582,27419529:27425645,27419531:27425344,27419537:27424939,27419539:27425442,27419543:27424167,27419546:27423886,27419551:27423375,27419556:27423737,27419558:27422706,27419563:27421779,27419567:27420726,27419569:27421186,27419573:27420588,27419601:27420625,27419606:27419801,27421651:27422314,27424393:27424593,27458264:27460728,27458267:27460894,27458270:27461086,27458273:27461303,27458276:27461733,27458278:27461834,27458281:27462264,27458283:27462105,27458285:27461700,27458287:27461917,27458289:27461868,27458291:27461580,27458293:27461610,27458295:27461122,27458297:27460611,27458299:27460411,27458301:27459616,27458303:27460226,27458305:27459206,27458307:27459419,27459638:27459910,27462139:27462320,27530981:27538881,27530984:27538869,27530988:27539099,27530992:27539241,27530995:27539418,27530999:27539567,27531003:27539886,27531007:27540272,27531016:27540930,27531021:27541495,27531025:27541335,27531030:2754181', 'assoc_mat': '27419509:autre:4230:27427038,27419511:autre:4230:27427360,27419514:autre:4230:27426959,27419518:autre:4230:27426686,27419521:autre:4230:27426153,27419523:autre:4230:27426582,27419529:autre:4230:27425645,27419531:autre:4230:27425344,27419537:autre:4230:27424939,27419539:autre:4230:27425442,27419543:autre:4230:27424167,27419546:autre:4230:27423886,27419551:autre:4230:27423375,27419556:autre:4230:27423737,27419558:autre:4230:27422706,27419563:autre:4230:27421779,27419567:autre:4230:27420726,27419569:autre:4230:27421186,27419573:autre:4230:27420588,27419601:autre:4230:27420625,27419606:autre:4230:27419801,27421651:autre:4230:27422314,27424393:autre:4230:27424593,27458264:autre:4230:27460728,27458267:autre:4230:27460894,27458270:autre:4230:27461086,27458273:autre:4230:27461303,27458276:autre:4230:27461733,27458278:autre:4230:27461834,27458281:autre:4230:27462264,27458283:autre:4230:27462105,27458285:autre:4230:27461700,27458287:autre:4230:27461917,27458289:autre:4230:27461868,27458291:autre:4230:27461580,27458293:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06444572547294747, 'nb_photo': 113444, 'list_port_cont': '27419811,27420593,27420622,27420734,27421191,27421791,27422330,27422720,27423380,27423740,27423885,27424175,27424598,27424946,27425340,27425450,27425652,27426151,27426592,27426676,27426969,27427044,27427369,27459216,27459425,27459615,27459916,27460228,27460420,27460609,27460732,27460895,27461083,27461127,27461311,27461572,27461624,27461694,27461744,27461840,27461872,27461914,27462112,27462267,27462314,27538862,27538891,27539105,27539254,27539416,27539581,27539895,27540261,27540940,27541343,27541491,27541821,27542513,27542987,27543316,27543630,27543870,27544025,27544210,27544432,27544582,27544728,27546260,27546333,27546604,27546801,27546920,27547012,27547095,27547132,27547468,27548139,27548311,27548739,27549055,27549595,27550782,27551573,27552206,27552245,27553056,27557734,27557851,27558140,27558673,27558986,27559345,27560259,27560392,27561005,27561473,27561800,27562132,27562399,27563127,27563699,27564341,27564570,27564730,27565040,27565452,27565635,27566048,27572070,27572137,27572202,27572261,27572357,2757240', 'assoc_port': '27419509:27427044,27419511:27427369,27419514:27426969,27419518:27426676,27419521:27426151,27419523:27426592,27419529:27425652,27419531:27425340,27419537:27424946,27419539:27425450,27419543:27424175,27419546:27423885,27419551:27423380,27419556:27423740,27419558:27422720,27419563:27421791,27419567:27420734,27419569:27421191,27419573:27420593,27419601:27420622,27419606:27419811,27421651:27422330,27424393:27424598,27458264:27460732,27458267:27460895,27458270:27461083,27458273:27461311,27458276:27461744,27458278:27461840,27458281:27462267,27458283:27462112,27458285:27461694,27458287:27461914,27458289:27461872,27458291:27461572,27458293:27461624,27458295:27461127,27458297:27460609,27458299:27460420,27458301:27459615,27458303:27460228,27458305:27459216,27458307:27459425,27459638:27459916,27462139:27462314,27530981:27538891,27530984:27538862,27530988:27539105,27530992:27539254,27530995:27539416,27530999:27539581,27531003:27539895,27531007:27540261,27531016:27540940,27531021:27541491,27531025:27541343,27531030:2754182', 'assoc_mat': '27419509:carton:4230:27427044,27419511:carton:4230:27427369,27419514:carton:4230:27426969,27419518:carton:4230:27426676,27419521:carton:4230:27426151,27419523:carton:4230:27426592,27419529:carton:4230:27425652,27419531:carton:4230:27425340,27419537:carton:4230:27424946,27419539:carton:4230:27425450,27419543:carton:4230:27424175,27419546:carton:4230:27423885,27419551:carton:4230:27423380,27419556:carton:4230:27423740,27419558:carton:4230:27422720,27419563:carton:4230:27421791,27419567:carton:4230:27420734,27419569:carton:4230:27421191,27419573:carton:4230:27420593,27419601:carton:4230:27420622,27419606:carton:4230:27419811,27421651:carton:4230:27422330,27424393:carton:4230:27424598,27458264:carton:4230:27460732,27458267:carton:4230:27460895,27458270:carton:4230:27461083,27458273:carton:4230:27461311,27458276:carton:4230:27461744,27458278:carton:4230:27461840,27458281:carton:4230:27462267,27458283:carton:4230:27462112,27458285:carton:4230:27461694,27458287:carton:4230:27461914,27458289:carton:4230:27461872,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015643915775535387, 'nb_photo': 2028, 'list_port_cont': '27419796,27420579,27420621,27420718,27421199,27421793,27422326,27422711,27423383,27423730,27423882,27424170,27424591,27425448,27425650,27426157,27426579,27426685,27427041,27459213,27459421,27459614,27459905,27460236,27460414,27460604,27460731,27460885,27461081,27461130,27461309,27461574,27461619,27461702,27461731,27461823,27461865,27461909,27462100,27462266,27462319,27538878,27539090,27539240,27539570,27539896,27540269,27540935,27541336,27542507,27542984,27543632,27543854,27544203,27544425,27544726,27546256,27546322,27546605,27546797,27546929,27547010,27547119,27547456,27548125,27548308,27548730,27549053,27550788,27551578,27552196,27552241,27557730,27557861,27558136,27558676,27558972,27559340,27560252,27560393,27561004,27561462,27561793,27562121,27562392,27563687,27564331,27564556,27564726,27565023,27565445,27565632,27566051,27572149,27572267,27572346,27572401,27572579,27572615,27572687,27572899,27573004,27573072,27573114,27573170,27573308,27573386,27576025,27576597,27579535,27580955,27581923,27583495,2758443', 'assoc_port': '27419509:27427041,27419518:27426685,27419521:27426157,27419523:27426579,27419529:27425650,27419539:27425448,27419543:27424170,27419546:27423882,27419551:27423383,27419556:27423730,27419558:27422711,27419563:27421793,27419567:27420718,27419569:27421199,27419573:27420579,27419601:27420621,27419606:27419796,27421651:27422326,27424393:27424591,27458264:27460731,27458267:27460885,27458270:27461081,27458273:27461309,27458276:27461731,27458278:27461823,27458281:27462266,27458283:27462100,27458285:27461702,27458287:27461909,27458289:27461865,27458291:27461574,27458293:27461619,27458295:27461130,27458297:27460604,27458299:27460414,27458301:27459614,27458303:27460236,27458305:27459213,27458307:27459421,27459638:27459905,27462139:27462319,27530981:27538878,27530988:27539090,27530992:27539240,27530999:27539570,27531003:27539896,27531007:27540269,27531016:27540935,27531025:27541336,27531034:27542507,27531038:27542984,27531048:27543632,27531051:27543854,27531058:27546256,27531065:27544203,27531066:27546322,27531073:2754442', 'assoc_mat': '27419509:metal:4230:27427041,27419518:metal:4230:27426685,27419521:metal:4230:27426157,27419523:metal:4230:27426579,27419529:metal:4230:27425650,27419539:metal:4230:27425448,27419543:metal:4230:27424170,27419546:metal:4230:27423882,27419551:metal:4230:27423383,27419556:metal:4230:27423730,27419558:metal:4230:27422711,27419563:metal:4230:27421793,27419567:metal:4230:27420718,27419569:metal:4230:27421199,27419573:metal:4230:27420579,27419601:metal:4230:27420621,27419606:metal:4230:27419796,27421651:metal:4230:27422326,27424393:metal:4230:27424591,27458264:metal:4230:27460731,27458267:metal:4230:27460885,27458270:metal:4230:27461081,27458273:metal:4230:27461309,27458276:metal:4230:27461731,27458278:metal:4230:27461823,27458281:metal:4230:27462266,27458283:metal:4230:27462100,27458285:metal:4230:27461702,27458287:metal:4230:27461909,27458289:metal:4230:27461865,27458291:metal:4230:27461574,27458293:metal:4230:27461619,27458295:metal:4230:27461130,27458297:metal:4230:27460604,27458299:metal:4230:27460414,27458301:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18504152570739973, 'nb_photo': 320130, 'list_port_cont': '27419810,27420587,27420627,27420735,27421196,27421792,27422328,27422719,27423374,27423735,27423888,27424183,27424592,27424951,27425346,27425445,27425651,27426164,27426588,27426691,27426965,27427034,27427371,27459217,27459423,27459604,27459909,27460227,27460417,27460608,27460733,27460901,27461076,27461133,27461300,27461582,27461621,27461706,27461735,27461836,27461873,27461921,27462110,27462257,27462322,27538870,27538885,27539093,27539249,27539429,27539576,27539891,27540273,27540936,27541345,27541503,27541827,27542521,27543001,27543320,27543629,27543863,27544019,27544215,27544431,27544583,27544721,27546264,27546323,27546599,27546808,27546925,27547013,27547092,27547133,27547464,27548138,27548298,27548735,27549056,27549596,27550786,27551582,27552200,27552251,27553064,27557727,27557858,27558137,27558666,27558975,27559349,27560250,27560397,27561003,27561472,27561796,27562129,27562401,27563126,27563691,27564333,27564569,27564735,27565031,27565444,27565636,27566055,27572063,27572143,27572200,27572263,27572363,2757240', 'assoc_port': '27419509:27427034,27419511:27427371,27419514:27426965,27419518:27426691,27419521:27426164,27419523:27426588,27419529:27425651,27419531:27425346,27419537:27424951,27419539:27425445,27419543:27424183,27419546:27423888,27419551:27423374,27419556:27423735,27419558:27422719,27419563:27421792,27419567:27420735,27419569:27421196,27419573:27420587,27419601:27420627,27419606:27419810,27421651:27422328,27424393:27424592,27458264:27460733,27458267:27460901,27458270:27461076,27458273:27461300,27458276:27461735,27458278:27461836,27458281:27462257,27458283:27462110,27458285:27461706,27458287:27461921,27458289:27461873,27458291:27461582,27458293:27461621,27458295:27461133,27458297:27460608,27458299:27460417,27458301:27459604,27458303:27460227,27458305:27459217,27458307:27459423,27459638:27459909,27462139:27462322,27530981:27538885,27530984:27538870,27530988:27539093,27530992:27539249,27530995:27539429,27530999:27539576,27531003:27539891,27531007:27540273,27531016:27540936,27531021:27541503,27531025:27541345,27531030:2754182', 'assoc_mat': '27419509:papier:4230:27427034,27419511:papier:4230:27427371,27419514:papier:4230:27426965,27419518:papier:4230:27426691,27419521:papier:4230:27426164,27419523:papier:4230:27426588,27419529:papier:4230:27425651,27419531:papier:4230:27425346,27419537:papier:4230:27424951,27419539:papier:4230:27425445,27419543:papier:4230:27424183,27419546:papier:4230:27423888,27419551:papier:4230:27423374,27419556:papier:4230:27423735,27419558:papier:4230:27422719,27419563:papier:4230:27421792,27419567:papier:4230:27420735,27419569:papier:4230:27421196,27419573:papier:4230:27420587,27419601:papier:4230:27420627,27419606:papier:4230:27419810,27421651:papier:4230:27422328,27424393:papier:4230:27424592,27458264:papier:4230:27460733,27458267:papier:4230:27460901,27458270:papier:4230:27461076,27458273:papier:4230:27461300,27458276:papier:4230:27461735,27458278:papier:4230:27461836,27458281:papier:4230:27462257,27458283:papier:4230:27462110,27458285:papier:4230:27461706,27458287:papier:4230:27461921,27458289:papier:4230:27461873,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005226425483397223, 'nb_photo': 2608, 'list_port_cont': '27419812,27420592,27420629,27420727,27421197,27421795,27422327,27422722,27423378,27423738,27423884,27424179,27424584,27424950,27425446,27425646,27426163,27426688,27426964,27427045,27427374,27459211,27459422,27459606,27459914,27460229,27460419,27460614,27460899,27461078,27461126,27461314,27461583,27461612,27461699,27461732,27461835,27461878,27461919,27462104,27462265,27462324,27538868,27538887,27539101,27539251,27539421,27539565,27539894,27540258,27540932,27541334,27541496,27541820,27542522,27542998,27543631,27543865,27544730,27546257,27546328,27546600,27546807,27546927,27547134,27547462,27548140,27548302,27548732,27549049,27549597,27550784,27551570,27552199,27552242,27553054,27557738,27557859,27558131,27558669,27558978,27559350,27560257,27560389,27560995,27561469,27561795,27562127,27562408,27563117,27563701,27564334,27564566,27564733,27565036,27565454,27565628,27566054,27572268,27572359,27572405,27572583,27572614,27572680,27572769,27572886,27573010,27573083,27573117,27573173,27573298,27573376,27576596,2758038', 'assoc_port': '27419509:27427045,27419511:27427374,27419514:27426964,27419518:27426688,27419521:27426163,27419529:27425646,27419537:27424950,27419539:27425446,27419543:27424179,27419546:27423884,27419551:27423378,27419556:27423738,27419558:27422722,27419563:27421795,27419567:27420727,27419569:27421197,27419573:27420592,27419601:27420629,27419606:27419812,27421651:27422327,27424393:27424584,27458267:27460899,27458270:27461078,27458273:27461314,27458276:27461732,27458278:27461835,27458281:27462265,27458283:27462104,27458285:27461699,27458287:27461919,27458289:27461878,27458291:27461583,27458293:27461612,27458295:27461126,27458297:27460614,27458299:27460419,27458301:27459606,27458303:27460229,27458305:27459211,27458307:27459422,27459638:27459914,27462139:27462324,27530981:27538887,27530984:27538868,27530988:27539101,27530992:27539251,27530995:27539421,27530999:27539565,27531003:27539894,27531007:27540258,27531016:27540932,27531021:27541496,27531025:27541334,27531030:27541820,27531034:27542522,27531038:27542998,27531048:2754363', 'assoc_mat': '27419509:pehd:4230:27427045,27419511:pehd:4230:27427374,27419514:pehd:4230:27426964,27419518:pehd:4230:27426688,27419521:pehd:4230:27426163,27419529:pehd:4230:27425646,27419537:pehd:4230:27424950,27419539:pehd:4230:27425446,27419543:pehd:4230:27424179,27419546:pehd:4230:27423884,27419551:pehd:4230:27423378,27419556:pehd:4230:27423738,27419558:pehd:4230:27422722,27419563:pehd:4230:27421795,27419567:pehd:4230:27420727,27419569:pehd:4230:27421197,27419573:pehd:4230:27420592,27419601:pehd:4230:27420629,27419606:pehd:4230:27419812,27421651:pehd:4230:27422327,27424393:pehd:4230:27424584,27458267:pehd:4230:27460899,27458270:pehd:4230:27461078,27458273:pehd:4230:27461314,27458276:pehd:4230:27461732,27458278:pehd:4230:27461835,27458281:pehd:4230:27462265,27458283:pehd:4230:27462104,27458285:pehd:4230:27461699,27458287:pehd:4230:27461919,27458289:pehd:4230:27461878,27458291:pehd:4230:27461583,27458293:pehd:4230:27461612,27458295:pehd:4230:27461126,27458297:pehd:4230:27460614,27458299:pehd:4230:27460419,27458301:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010630832168573186, 'nb_photo': 21067, 'list_port_cont': '27419813,27420596,27420632,27420723,27421185,27421790,27422322,27422712,27423382,27423736,27423887,27424174,27424594,27424941,27425338,27425451,27425641,27426161,27426596,27426689,27426956,27427043,27427375,27459212,27459414,27459610,27459912,27460232,27460413,27460612,27460726,27460896,27461079,27461135,27461304,27461578,27461614,27461705,27461738,27461838,27461879,27461918,27462114,27462262,27462323,27538864,27538884,27539104,27539242,27539427,27539577,27539885,27540265,27540943,27541346,27541501,27541814,27542518,27543000,27543313,27543617,27543862,27544014,27544217,27544430,27544579,27544729,27546267,27546324,27546593,27546809,27546924,27547008,27547096,27547128,27547461,27548136,27548304,27548737,27549051,27549586,27550790,27551575,27552203,27552246,27553060,27557742,27557857,27558141,27558670,27558980,27559346,27560256,27560402,27561008,27561463,27561802,27562128,27562400,27563123,27563690,27564340,27564555,27564731,27565037,27565442,27565637,27566047,27572061,27572138,27572196,27572262,27572355,2757240', 'assoc_port': '27419509:27427043,27419511:27427375,27419514:27426956,27419518:27426689,27419521:27426161,27419523:27426596,27419529:27425641,27419531:27425338,27419537:27424941,27419539:27425451,27419543:27424174,27419546:27423887,27419551:27423382,27419556:27423736,27419558:27422712,27419563:27421790,27419567:27420723,27419569:27421185,27419573:27420596,27419601:27420632,27419606:27419813,27421651:27422322,27424393:27424594,27458264:27460726,27458267:27460896,27458270:27461079,27458273:27461304,27458276:27461738,27458278:27461838,27458281:27462262,27458283:27462114,27458285:27461705,27458287:27461918,27458289:27461879,27458291:27461578,27458293:27461614,27458295:27461135,27458297:27460612,27458299:27460413,27458301:27459610,27458303:27460232,27458305:27459212,27458307:27459414,27459638:27459912,27462139:27462323,27530981:27538884,27530984:27538864,27530988:27539104,27530992:27539242,27530995:27539427,27530999:27539577,27531003:27539885,27531007:27540265,27531016:27540943,27531021:27541501,27531025:27541346,27531030:2754181', 'assoc_mat': '27419509:pet_clair:4230:27427043,27419511:pet_clair:4230:27427375,27419514:pet_clair:4230:27426956,27419518:pet_clair:4230:27426689,27419521:pet_clair:4230:27426161,27419523:pet_clair:4230:27426596,27419529:pet_clair:4230:27425641,27419531:pet_clair:4230:27425338,27419537:pet_clair:4230:27424941,27419539:pet_clair:4230:27425451,27419543:pet_clair:4230:27424174,27419546:pet_clair:4230:27423887,27419551:pet_clair:4230:27423382,27419556:pet_clair:4230:27423736,27419558:pet_clair:4230:27422712,27419563:pet_clair:4230:27421790,27419567:pet_clair:4230:27420723,27419569:pet_clair:4230:27421185,27419573:pet_clair:4230:27420596,27419601:pet_clair:4230:27420632,27419606:pet_clair:4230:27419813,27421651:pet_clair:4230:27422322,27424393:pet_clair:4230:27424594,27458264:pet_clair:4230:27460726,27458267:pet_clair:4230:27460896,27458270:pet_clair:4230:27461079,27458273:pet_clair:4230:27461304,27458276:pet_clair:4230:27461738,27458278:pet_clair:4230:27461838,27458281:pet_clair:4230:27462262,27458283:pet_clair:4230:27462114,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003263674001917912, 'nb_photo': 965, 'list_port_cont': '27420595,27420623,27422718,27423372,27423880,27424942,27425345,27425644,27426152,27427042,27427373,27459214,27459418,27459617,27459913,27460230,27460408,27460600,27460897,27461136,27461573,27461623,27461745,27461876,27461911,27462309,27538857,27538877,27540941,27542515,27543312,27543619,27543869,27544420,27546265,27546334,27546598,27546803,27546917,27547006,27547089,27547123,27547460,27548142,27548312,27551574,27552201,27552244,27557740,27558139,27558674,27558985,27559352,27560258,27561799,27562130,27563121,27564344,27564568,27564727,27565449,27565631,27566057,27572148,27572352,27572406,27572585,27572618,27572763,27572894,27573011,27573077,27573106,27573178,27573306,27579539,27581934,27583821,27584428,27587933,27588745,27588967,27593437,27593970,27594208,27594231,27595201,27595955,27596059,27596389,27596797,27596893,27597528,27599700,27599907,27600894,27601296,27601744,27605097,27605613,27606690,27608702,27610390,27612064,27626203,27690475,27690671,27690869,27691095,27691212,27691671,27692437,27692668,2769274', 'assoc_port': '27419509:27427042,27419511:27427373,27419521:27426152,27419529:27425644,27419531:27425345,27419537:27424942,27419546:27423880,27419551:27423372,27419558:27422718,27419573:27420595,27419601:27420623,27458267:27460897,27458276:27461745,27458287:27461911,27458289:27461876,27458291:27461573,27458293:27461623,27458295:27461136,27458297:27460600,27458299:27460408,27458301:27459617,27458303:27460230,27458305:27459214,27458307:27459418,27459638:27459913,27462139:27462309,27530981:27538877,27530984:27538857,27531016:27540941,27531034:27542515,27531043:27543312,27531048:27543619,27531051:27543869,27531058:27546265,27531066:27546334,27531073:27544420,27531074:27546598,27531082:27546803,27531089:27546917,27531096:27547006,27531103:27547123,27531108:27547089,27531113:27594231,27531117:27547460,27531121:27584428,27531126:27548142,27531130:27548312,27531141:27601744,27531153:27557740,27531155:27551574,27531162:27552201,27531166:27552244,27531168:27558139,27531176:27601296,27531180:27558674,27531184:27558985,27531191:2755935', 'assoc_mat': '27419509:pet_fonce:4230:27427042,27419511:pet_fonce:4230:27427373,27419521:pet_fonce:4230:27426152,27419529:pet_fonce:4230:27425644,27419531:pet_fonce:4230:27425345,27419537:pet_fonce:4230:27424942,27419546:pet_fonce:4230:27423880,27419551:pet_fonce:4230:27423372,27419558:pet_fonce:4230:27422718,27419573:pet_fonce:4230:27420595,27419601:pet_fonce:4230:27420623,27458267:pet_fonce:4230:27460897,27458276:pet_fonce:4230:27461745,27458287:pet_fonce:4230:27461911,27458289:pet_fonce:4230:27461876,27458291:pet_fonce:4230:27461573,27458293:pet_fonce:4230:27461623,27458295:pet_fonce:4230:27461136,27458297:pet_fonce:4230:27460600,27458299:pet_fonce:4230:27460408,27458301:pet_fonce:4230:27459617,27458303:pet_fonce:4230:27460230,27458305:pet_fonce:4230:27459214,27458307:pet_fonce:4230:27459418,27459638:pet_fonce:4230:27459913,27462139:pet_fonce:4230:27462309,27530981:pet_fonce:4230:27538877,27530984:pet_fonce:4230:27538857,27531016:pet_fonce:4230:27540941,27531034:pet_fonce:4230:27542515,27531043:pet_fonce:4230:27543312,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(2384953,2392600,2406372,2406357,2406351,2408597,2412709,2419637,2428107,2436195,2442077,2442777,2450016,2457661,2465477,2468735,2473650,2477027,2484329,2484209,2484315,2484303,2484299,2484283,2484275,2484225,2484261,2493485,2493515,2496805)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124558, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419801,27420588,27420625,27420726,27421186,27421779,27422314,27422706,27423375,27423737,27423886,27424167,27424593,27424939,27425344,27425442,27425645,27426153,27426582,27426686,27426959,27427038,27427360,27459206,27459419,27459616,27459910,27460226,27460411,27460611,27460728,27460894,27461086,27461122,27461303,27461580,27461610,27461700,27461733,27461834,27461868,27461917,27462105,27462264,27462320,27538869,27538881,27539099,27539241,27539418,27539567,27539886,27540272,27540930,27541335,27541495,27541812,27542514,27542988,27543315,27543622,27543868,27544015,27544202,27544424,27544577,27544715,27546253,27546327,27546606,27546804,27546928,27547004,27547086,27547120,27547465,27548128,27548307,27548729,27549041,27549590,27550796,27551567,27552189,27552249,27553063,27557732,27557852,27558126,27558679,27558973,27559342,27560248,27560400,27561002,27561460,27561801,27562122,27562407,27563118,27563698,27564342,27564554,27564720,27565030,27565438,27565627,27566045,27572055,27572139,27572185,27572266,27572358,2757239 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124559, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419811,27420593,27420622,27420734,27421191,27421791,27422330,27422720,27423380,27423740,27423885,27424175,27424598,27424946,27425340,27425450,27425652,27426151,27426592,27426676,27426969,27427044,27427369,27459216,27459425,27459615,27459916,27460228,27460420,27460609,27460732,27460895,27461083,27461127,27461311,27461572,27461624,27461694,27461744,27461840,27461872,27461914,27462112,27462267,27462314,27538862,27538891,27539105,27539254,27539416,27539581,27539895,27540261,27540940,27541343,27541491,27541821,27542513,27542987,27543316,27543630,27543870,27544025,27544210,27544432,27544582,27544728,27546260,27546333,27546604,27546801,27546920,27547012,27547095,27547132,27547468,27548139,27548311,27548739,27549055,27549595,27550782,27551573,27552206,27552245,27553056,27557734,27557851,27558140,27558673,27558986,27559345,27560259,27560392,27561005,27561473,27561800,27562132,27562399,27563127,27563699,27564341,27564570,27564730,27565040,27565452,27565635,27566048,27572070,27572137,27572202,27572261,27572357,2757240 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124560, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419796,27420579,27420621,27420718,27421199,27421793,27422326,27422711,27423383,27423730,27423882,27424170,27424591,27425448,27425650,27426157,27426579,27426685,27427041,27459213,27459421,27459614,27459905,27460236,27460414,27460604,27460731,27460885,27461081,27461130,27461309,27461574,27461619,27461702,27461731,27461823,27461865,27461909,27462100,27462266,27462319,27538878,27539090,27539240,27539570,27539896,27540269,27540935,27541336,27542507,27542984,27543632,27543854,27544203,27544425,27544726,27546256,27546322,27546605,27546797,27546929,27547010,27547119,27547456,27548125,27548308,27548730,27549053,27550788,27551578,27552196,27552241,27557730,27557861,27558136,27558676,27558972,27559340,27560252,27560393,27561004,27561462,27561793,27562121,27562392,27563687,27564331,27564556,27564726,27565023,27565445,27565632,27566051,27572149,27572267,27572346,27572401,27572579,27572615,27572687,27572899,27573004,27573072,27573114,27573170,27573308,27573386,27576025,27576597,27579535,27580955,27581923,27583495,2758443 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124561, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419810,27420587,27420627,27420735,27421196,27421792,27422328,27422719,27423374,27423735,27423888,27424183,27424592,27424951,27425346,27425445,27425651,27426164,27426588,27426691,27426965,27427034,27427371,27459217,27459423,27459604,27459909,27460227,27460417,27460608,27460733,27460901,27461076,27461133,27461300,27461582,27461621,27461706,27461735,27461836,27461873,27461921,27462110,27462257,27462322,27538870,27538885,27539093,27539249,27539429,27539576,27539891,27540273,27540936,27541345,27541503,27541827,27542521,27543001,27543320,27543629,27543863,27544019,27544215,27544431,27544583,27544721,27546264,27546323,27546599,27546808,27546925,27547013,27547092,27547133,27547464,27548138,27548298,27548735,27549056,27549596,27550786,27551582,27552200,27552251,27553064,27557727,27557858,27558137,27558666,27558975,27559349,27560250,27560397,27561003,27561472,27561796,27562129,27562401,27563126,27563691,27564333,27564569,27564735,27565031,27565444,27565636,27566055,27572063,27572143,27572200,27572263,27572363,2757240 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124562, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419812,27420592,27420629,27420727,27421197,27421795,27422327,27422722,27423378,27423738,27423884,27424179,27424584,27424950,27425446,27425646,27426163,27426688,27426964,27427045,27427374,27459211,27459422,27459606,27459914,27460229,27460419,27460614,27460899,27461078,27461126,27461314,27461583,27461612,27461699,27461732,27461835,27461878,27461919,27462104,27462265,27462324,27538868,27538887,27539101,27539251,27539421,27539565,27539894,27540258,27540932,27541334,27541496,27541820,27542522,27542998,27543631,27543865,27544730,27546257,27546328,27546600,27546807,27546927,27547134,27547462,27548140,27548302,27548732,27549049,27549597,27550784,27551570,27552199,27552242,27553054,27557738,27557859,27558131,27558669,27558978,27559350,27560257,27560389,27560995,27561469,27561795,27562127,27562408,27563117,27563701,27564334,27564566,27564733,27565036,27565454,27565628,27566054,27572268,27572359,27572405,27572583,27572614,27572680,27572769,27572886,27573010,27573083,27573117,27573173,27573298,27573376,27576596,2758038 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124563, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419813,27420596,27420632,27420723,27421185,27421790,27422322,27422712,27423382,27423736,27423887,27424174,27424594,27424941,27425338,27425451,27425641,27426161,27426596,27426689,27426956,27427043,27427375,27459212,27459414,27459610,27459912,27460232,27460413,27460612,27460726,27460896,27461079,27461135,27461304,27461578,27461614,27461705,27461738,27461838,27461879,27461918,27462114,27462262,27462323,27538864,27538884,27539104,27539242,27539427,27539577,27539885,27540265,27540943,27541346,27541501,27541814,27542518,27543000,27543313,27543617,27543862,27544014,27544217,27544430,27544579,27544729,27546267,27546324,27546593,27546809,27546924,27547008,27547096,27547128,27547461,27548136,27548304,27548737,27549051,27549586,27550790,27551575,27552203,27552246,27553060,27557742,27557857,27558141,27558670,27558980,27559346,27560256,27560402,27561008,27561463,27561802,27562128,27562400,27563123,27563690,27564340,27564555,27564731,27565037,27565442,27565637,27566047,27572061,27572138,27572196,27572262,27572355,2757240 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124564, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27420595,27420623,27422718,27423372,27423880,27424942,27425345,27425644,27426152,27427042,27427373,27459214,27459418,27459617,27459913,27460230,27460408,27460600,27460897,27461136,27461573,27461623,27461745,27461876,27461911,27462309,27538857,27538877,27540941,27542515,27543312,27543619,27543869,27544420,27546265,27546334,27546598,27546803,27546917,27547006,27547089,27547123,27547460,27548142,27548312,27551574,27552201,27552244,27557740,27558139,27558674,27558985,27559352,27560258,27561799,27562130,27563121,27564344,27564568,27564727,27565449,27565631,27566057,27572148,27572352,27572406,27572585,27572618,27572763,27572894,27573011,27573077,27573106,27573178,27573306,27579539,27581934,27583821,27584428,27587933,27588745,27588967,27593437,27593970,27594208,27594231,27595201,27595955,27596059,27596389,27596797,27596893,27597528,27599700,27599907,27600894,27601296,27601744,27605097,27605613,27606690,27608702,27610390,27612064,27626203,27690475,27690671,27690869,27691095,27691212,27691671,27692437,27692668,2769274 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124558,30124559,30124560,30124561,30124562,30124563,30124564?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2025-10-01' and date <= '2025-10-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1580,),), 'unwanted_material_monthly_percentage': ((0.734559377028661,),), 'material_repartition': (('incineration', 1580),), 'material_dict': {'incineration': 1580}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.7054779778095741, 2), (datetime.date(2025, 10, 2), 0.6747298148154705, 2), (datetime.date(2025, 10, 3), 0.6832917330210965, 2), (datetime.date(2025, 10, 4), 0.7547827386752957, 2), (datetime.date(2025, 10, 5), 0.8109524259269868, 2), (datetime.date(2025, 10, 6), 0.711912170205592, 4), (datetime.date(2025, 10, 7), 0.7483601322050677, 3), (datetime.date(2025, 10, 8), 0.6892857486309879, 2), (datetime.date(2025, 10, 9), 0.6857829107923281, 1), (datetime.date(2025, 10, 10), 0.7087370745233148, 2), (datetime.date(2025, 10, 11), 0.7375400301927798, 1), (datetime.date(2025, 10, 12), 0.8367154994401323, 2), (datetime.date(2025, 10, 13), 0.7654051442232372, 3), (datetime.date(2025, 10, 14), 0.7030917379230247, 2), (datetime.date(2025, 10, 15), 0.7173697019402465, 1), (datetime.date(2025, 10, 16), 0.7251553531628971, 3), (datetime.date(2025, 10, 17), 0.6983393378381997, 1), (datetime.date(2025, 10, 18), 0.6531044337018516, 2), (datetime.date(2025, 10, 19), 0.7447846559777486, 2), (datetime.date(2025, 10, 21), 0.7733533197622132, 2), (datetime.date(2025, 10, 22), 0.7650085365716839, 4), (datetime.date(2025, 10, 23), 0.7359088585072924, 3), (datetime.date(2025, 10, 24), 0.7087617942525944, 4), (datetime.date(2025, 10, 25), 0.7419386849717989, 3), (datetime.date(2025, 10, 26), 0.8239361682198136, 4), (datetime.date(2025, 10, 27), 0.7563898712276299, 4), (datetime.date(2025, 10, 28), 0.7772193026827374, 4), (datetime.date(2025, 10, 29), 0.7605406673495437, 3), (datetime.date(2025, 10, 30), 0.6822855939692737, 4), (datetime.date(2025, 10, 31), 0.6522240727166645, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 10, 1), 0.7054779778095741, 2), (datetime.date(2025, 10, 2), 0.6747298148154705, 2), (datetime.date(2025, 10, 3), 0.6832917330210965, 2), (datetime.date(2025, 10, 4), 0.7547827386752957, 2), (datetime.date(2025, 10, 5), 0.8109524259269868, 2), (datetime.date(2025, 10, 6), 0.711912170205592, 4), (datetime.date(2025, 10, 7), 0.7483601322050677, 3), (datetime.date(2025, 10, 8), 0.6892857486309879, 2), (datetime.date(2025, 10, 9), 0.6857829107923281, 1), (datetime.date(2025, 10, 10), 0.7087370745233148, 2), (datetime.date(2025, 10, 11), 0.7375400301927798, 1), (datetime.date(2025, 10, 12), 0.8367154994401323, 2), (datetime.date(2025, 10, 13), 0.7654051442232372, 3), (datetime.date(2025, 10, 14), 0.7030917379230247, 2), (datetime.date(2025, 10, 15), 0.7173697019402465, 1), (datetime.date(2025, 10, 16), 0.7251553531628971, 3), (datetime.date(2025, 10, 17), 0.6983393378381997, 1), (datetime.date(2025, 10, 18), 0.6531044337018516, 2), (datetime.date(2025, 10, 19), 0.7447846559777486, 2), (datetime.date(2025, 10, 21), 0.7733533197622132, 2), (datetime.date(2025, 10, 22), 0.7650085365716839, 4), (datetime.date(2025, 10, 23), 0.7359088585072924, 3), (datetime.date(2025, 10, 24), 0.7087617942525944, 4), (datetime.date(2025, 10, 25), 0.7419386849717989, 3), (datetime.date(2025, 10, 26), 0.8239361682198136, 4), (datetime.date(2025, 10, 27), 0.7563898712276299, 4), (datetime.date(2025, 10, 28), 0.7772193026827374, 4), (datetime.date(2025, 10, 29), 0.7605406673495437, 3), (datetime.date(2025, 10, 30), 0.6822855939692737, 4), (datetime.date(2025, 10, 31), 0.6522240727166645, 2))}, 'quality_array': [['-8.37139241133978', '01102025'], ['-8.030738622754848', '02102025'], ['-8.10978577166114', '03102025'], ['-8.269227304570922', '04102025'], ['-8.347799980372129', '05102025'], ['-8.12701547103574', '06102025'], ['-8.063106524134215', '07102025'], ['-8.282593280753673', '08102025'], ['-8.333809956937186', '09102025'], ['-8.342496006082387', '10102025'], ['-8.19835602937615', '11102025'], ['-8.245256459655144', '12102025'], ['-7.996466730490495', '13102025'], ['-8.160951152914539', '14102025'], ['-8.251090745486188', '15102025'], ['-8.091756540627506', '16102025'], ['-8.146152425164118', '17102025'], ['-8.284833195379964', '18102025'], ['-8.391737038005568', '19102025'], ['-8.371075946009217', '21102025'], ['-8.282626540147604', '22102025'], ['-8.30025171858188', '23102025'], ['-8.081587079007189', '24102025'], ['-8.002410499291592', '25102025'], ['-8.185237000931524', '26102025'], ['-8.16082377790358', '27102025'], ['-7.725357327114873', '28102025'], ['-7.9236817559003105', '29102025'], ['-8.10359920125422', '30102025'], ['-8.021479440115328', '31102025']], 'number_of_batch': ((604,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014705980367627302, 'nb_photo': 16760, 'list_port_cont': '27419801,27420588,27420625,27420726,27421186,27421779,27422314,27422706,27423375,27423737,27423886,27424167,27424593,27424939,27425344,27425442,27425645,27426153,27426582,27426686,27426959,27427038,27427360,27459206,27459419,27459616,27459910,27460226,27460411,27460611,27460728,27460894,27461086,27461122,27461303,27461580,27461610,27461700,27461733,27461834,27461868,27461917,27462105,27462264,27462320,27538869,27538881,27539099,27539241,27539418,27539567,27539886,27540272,27540930,27541335,27541495,27541812,27542514,27542988,27543315,27543622,27543868,27544015,27544202,27544424,27544577,27544715,27546253,27546327,27546606,27546804,27546928,27547004,27547086,27547120,27547465,27548128,27548307,27548729,27549041,27549590,27550796,27551567,27552189,27552249,27553063,27557732,27557852,27558126,27558679,27558973,27559342,27560248,27560400,27561002,27561460,27561801,27562122,27562407,27563118,27563698,27564342,27564554,27564720,27565030,27565438,27565627,27566045,27572055,27572139,27572185,27572266,27572358,2757239', 'assoc_port': '27419509:27427038,27419511:27427360,27419514:27426959,27419518:27426686,27419521:27426153,27419523:27426582,27419529:27425645,27419531:27425344,27419537:27424939,27419539:27425442,27419543:27424167,27419546:27423886,27419551:27423375,27419556:27423737,27419558:27422706,27419563:27421779,27419567:27420726,27419569:27421186,27419573:27420588,27419601:27420625,27419606:27419801,27421651:27422314,27424393:27424593,27458264:27460728,27458267:27460894,27458270:27461086,27458273:27461303,27458276:27461733,27458278:27461834,27458281:27462264,27458283:27462105,27458285:27461700,27458287:27461917,27458289:27461868,27458291:27461580,27458293:27461610,27458295:27461122,27458297:27460611,27458299:27460411,27458301:27459616,27458303:27460226,27458305:27459206,27458307:27459419,27459638:27459910,27462139:27462320,27530981:27538881,27530984:27538869,27530988:27539099,27530992:27539241,27530995:27539418,27530999:27539567,27531003:27539886,27531007:27540272,27531016:27540930,27531021:27541495,27531025:27541335,27531030:2754181', 'assoc_mat': '27419509:autre:4230:27427038,27419511:autre:4230:27427360,27419514:autre:4230:27426959,27419518:autre:4230:27426686,27419521:autre:4230:27426153,27419523:autre:4230:27426582,27419529:autre:4230:27425645,27419531:autre:4230:27425344,27419537:autre:4230:27424939,27419539:autre:4230:27425442,27419543:autre:4230:27424167,27419546:autre:4230:27423886,27419551:autre:4230:27423375,27419556:autre:4230:27423737,27419558:autre:4230:27422706,27419563:autre:4230:27421779,27419567:autre:4230:27420726,27419569:autre:4230:27421186,27419573:autre:4230:27420588,27419601:autre:4230:27420625,27419606:autre:4230:27419801,27421651:autre:4230:27422314,27424393:autre:4230:27424593,27458264:autre:4230:27460728,27458267:autre:4230:27460894,27458270:autre:4230:27461086,27458273:autre:4230:27461303,27458276:autre:4230:27461733,27458278:autre:4230:27461834,27458281:autre:4230:27462264,27458283:autre:4230:27462105,27458285:autre:4230:27461700,27458287:autre:4230:27461917,27458289:autre:4230:27461868,27458291:autre:4230:27461580,27458293:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06444572547294747, 'nb_photo': 113444, 'list_port_cont': '27419811,27420593,27420622,27420734,27421191,27421791,27422330,27422720,27423380,27423740,27423885,27424175,27424598,27424946,27425340,27425450,27425652,27426151,27426592,27426676,27426969,27427044,27427369,27459216,27459425,27459615,27459916,27460228,27460420,27460609,27460732,27460895,27461083,27461127,27461311,27461572,27461624,27461694,27461744,27461840,27461872,27461914,27462112,27462267,27462314,27538862,27538891,27539105,27539254,27539416,27539581,27539895,27540261,27540940,27541343,27541491,27541821,27542513,27542987,27543316,27543630,27543870,27544025,27544210,27544432,27544582,27544728,27546260,27546333,27546604,27546801,27546920,27547012,27547095,27547132,27547468,27548139,27548311,27548739,27549055,27549595,27550782,27551573,27552206,27552245,27553056,27557734,27557851,27558140,27558673,27558986,27559345,27560259,27560392,27561005,27561473,27561800,27562132,27562399,27563127,27563699,27564341,27564570,27564730,27565040,27565452,27565635,27566048,27572070,27572137,27572202,27572261,27572357,2757240', 'assoc_port': '27419509:27427044,27419511:27427369,27419514:27426969,27419518:27426676,27419521:27426151,27419523:27426592,27419529:27425652,27419531:27425340,27419537:27424946,27419539:27425450,27419543:27424175,27419546:27423885,27419551:27423380,27419556:27423740,27419558:27422720,27419563:27421791,27419567:27420734,27419569:27421191,27419573:27420593,27419601:27420622,27419606:27419811,27421651:27422330,27424393:27424598,27458264:27460732,27458267:27460895,27458270:27461083,27458273:27461311,27458276:27461744,27458278:27461840,27458281:27462267,27458283:27462112,27458285:27461694,27458287:27461914,27458289:27461872,27458291:27461572,27458293:27461624,27458295:27461127,27458297:27460609,27458299:27460420,27458301:27459615,27458303:27460228,27458305:27459216,27458307:27459425,27459638:27459916,27462139:27462314,27530981:27538891,27530984:27538862,27530988:27539105,27530992:27539254,27530995:27539416,27530999:27539581,27531003:27539895,27531007:27540261,27531016:27540940,27531021:27541491,27531025:27541343,27531030:2754182', 'assoc_mat': '27419509:carton:4230:27427044,27419511:carton:4230:27427369,27419514:carton:4230:27426969,27419518:carton:4230:27426676,27419521:carton:4230:27426151,27419523:carton:4230:27426592,27419529:carton:4230:27425652,27419531:carton:4230:27425340,27419537:carton:4230:27424946,27419539:carton:4230:27425450,27419543:carton:4230:27424175,27419546:carton:4230:27423885,27419551:carton:4230:27423380,27419556:carton:4230:27423740,27419558:carton:4230:27422720,27419563:carton:4230:27421791,27419567:carton:4230:27420734,27419569:carton:4230:27421191,27419573:carton:4230:27420593,27419601:carton:4230:27420622,27419606:carton:4230:27419811,27421651:carton:4230:27422330,27424393:carton:4230:27424598,27458264:carton:4230:27460732,27458267:carton:4230:27460895,27458270:carton:4230:27461083,27458273:carton:4230:27461311,27458276:carton:4230:27461744,27458278:carton:4230:27461840,27458281:carton:4230:27462267,27458283:carton:4230:27462112,27458285:carton:4230:27461694,27458287:carton:4230:27461914,27458289:carton:4230:27461872,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015643915775535387, 'nb_photo': 2028, 'list_port_cont': '27419796,27420579,27420621,27420718,27421199,27421793,27422326,27422711,27423383,27423730,27423882,27424170,27424591,27425448,27425650,27426157,27426579,27426685,27427041,27459213,27459421,27459614,27459905,27460236,27460414,27460604,27460731,27460885,27461081,27461130,27461309,27461574,27461619,27461702,27461731,27461823,27461865,27461909,27462100,27462266,27462319,27538878,27539090,27539240,27539570,27539896,27540269,27540935,27541336,27542507,27542984,27543632,27543854,27544203,27544425,27544726,27546256,27546322,27546605,27546797,27546929,27547010,27547119,27547456,27548125,27548308,27548730,27549053,27550788,27551578,27552196,27552241,27557730,27557861,27558136,27558676,27558972,27559340,27560252,27560393,27561004,27561462,27561793,27562121,27562392,27563687,27564331,27564556,27564726,27565023,27565445,27565632,27566051,27572149,27572267,27572346,27572401,27572579,27572615,27572687,27572899,27573004,27573072,27573114,27573170,27573308,27573386,27576025,27576597,27579535,27580955,27581923,27583495,2758443', 'assoc_port': '27419509:27427041,27419518:27426685,27419521:27426157,27419523:27426579,27419529:27425650,27419539:27425448,27419543:27424170,27419546:27423882,27419551:27423383,27419556:27423730,27419558:27422711,27419563:27421793,27419567:27420718,27419569:27421199,27419573:27420579,27419601:27420621,27419606:27419796,27421651:27422326,27424393:27424591,27458264:27460731,27458267:27460885,27458270:27461081,27458273:27461309,27458276:27461731,27458278:27461823,27458281:27462266,27458283:27462100,27458285:27461702,27458287:27461909,27458289:27461865,27458291:27461574,27458293:27461619,27458295:27461130,27458297:27460604,27458299:27460414,27458301:27459614,27458303:27460236,27458305:27459213,27458307:27459421,27459638:27459905,27462139:27462319,27530981:27538878,27530988:27539090,27530992:27539240,27530999:27539570,27531003:27539896,27531007:27540269,27531016:27540935,27531025:27541336,27531034:27542507,27531038:27542984,27531048:27543632,27531051:27543854,27531058:27546256,27531065:27544203,27531066:27546322,27531073:2754442', 'assoc_mat': '27419509:metal:4230:27427041,27419518:metal:4230:27426685,27419521:metal:4230:27426157,27419523:metal:4230:27426579,27419529:metal:4230:27425650,27419539:metal:4230:27425448,27419543:metal:4230:27424170,27419546:metal:4230:27423882,27419551:metal:4230:27423383,27419556:metal:4230:27423730,27419558:metal:4230:27422711,27419563:metal:4230:27421793,27419567:metal:4230:27420718,27419569:metal:4230:27421199,27419573:metal:4230:27420579,27419601:metal:4230:27420621,27419606:metal:4230:27419796,27421651:metal:4230:27422326,27424393:metal:4230:27424591,27458264:metal:4230:27460731,27458267:metal:4230:27460885,27458270:metal:4230:27461081,27458273:metal:4230:27461309,27458276:metal:4230:27461731,27458278:metal:4230:27461823,27458281:metal:4230:27462266,27458283:metal:4230:27462100,27458285:metal:4230:27461702,27458287:metal:4230:27461909,27458289:metal:4230:27461865,27458291:metal:4230:27461574,27458293:metal:4230:27461619,27458295:metal:4230:27461130,27458297:metal:4230:27460604,27458299:metal:4230:27460414,27458301:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18504152570739973, 'nb_photo': 320130, 'list_port_cont': '27419810,27420587,27420627,27420735,27421196,27421792,27422328,27422719,27423374,27423735,27423888,27424183,27424592,27424951,27425346,27425445,27425651,27426164,27426588,27426691,27426965,27427034,27427371,27459217,27459423,27459604,27459909,27460227,27460417,27460608,27460733,27460901,27461076,27461133,27461300,27461582,27461621,27461706,27461735,27461836,27461873,27461921,27462110,27462257,27462322,27538870,27538885,27539093,27539249,27539429,27539576,27539891,27540273,27540936,27541345,27541503,27541827,27542521,27543001,27543320,27543629,27543863,27544019,27544215,27544431,27544583,27544721,27546264,27546323,27546599,27546808,27546925,27547013,27547092,27547133,27547464,27548138,27548298,27548735,27549056,27549596,27550786,27551582,27552200,27552251,27553064,27557727,27557858,27558137,27558666,27558975,27559349,27560250,27560397,27561003,27561472,27561796,27562129,27562401,27563126,27563691,27564333,27564569,27564735,27565031,27565444,27565636,27566055,27572063,27572143,27572200,27572263,27572363,2757240', 'assoc_port': '27419509:27427034,27419511:27427371,27419514:27426965,27419518:27426691,27419521:27426164,27419523:27426588,27419529:27425651,27419531:27425346,27419537:27424951,27419539:27425445,27419543:27424183,27419546:27423888,27419551:27423374,27419556:27423735,27419558:27422719,27419563:27421792,27419567:27420735,27419569:27421196,27419573:27420587,27419601:27420627,27419606:27419810,27421651:27422328,27424393:27424592,27458264:27460733,27458267:27460901,27458270:27461076,27458273:27461300,27458276:27461735,27458278:27461836,27458281:27462257,27458283:27462110,27458285:27461706,27458287:27461921,27458289:27461873,27458291:27461582,27458293:27461621,27458295:27461133,27458297:27460608,27458299:27460417,27458301:27459604,27458303:27460227,27458305:27459217,27458307:27459423,27459638:27459909,27462139:27462322,27530981:27538885,27530984:27538870,27530988:27539093,27530992:27539249,27530995:27539429,27530999:27539576,27531003:27539891,27531007:27540273,27531016:27540936,27531021:27541503,27531025:27541345,27531030:2754182', 'assoc_mat': '27419509:papier:4230:27427034,27419511:papier:4230:27427371,27419514:papier:4230:27426965,27419518:papier:4230:27426691,27419521:papier:4230:27426164,27419523:papier:4230:27426588,27419529:papier:4230:27425651,27419531:papier:4230:27425346,27419537:papier:4230:27424951,27419539:papier:4230:27425445,27419543:papier:4230:27424183,27419546:papier:4230:27423888,27419551:papier:4230:27423374,27419556:papier:4230:27423735,27419558:papier:4230:27422719,27419563:papier:4230:27421792,27419567:papier:4230:27420735,27419569:papier:4230:27421196,27419573:papier:4230:27420587,27419601:papier:4230:27420627,27419606:papier:4230:27419810,27421651:papier:4230:27422328,27424393:papier:4230:27424592,27458264:papier:4230:27460733,27458267:papier:4230:27460901,27458270:papier:4230:27461076,27458273:papier:4230:27461300,27458276:papier:4230:27461735,27458278:papier:4230:27461836,27458281:papier:4230:27462257,27458283:papier:4230:27462110,27458285:papier:4230:27461706,27458287:papier:4230:27461921,27458289:papier:4230:27461873,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005226425483397223, 'nb_photo': 2608, 'list_port_cont': '27419812,27420592,27420629,27420727,27421197,27421795,27422327,27422722,27423378,27423738,27423884,27424179,27424584,27424950,27425446,27425646,27426163,27426688,27426964,27427045,27427374,27459211,27459422,27459606,27459914,27460229,27460419,27460614,27460899,27461078,27461126,27461314,27461583,27461612,27461699,27461732,27461835,27461878,27461919,27462104,27462265,27462324,27538868,27538887,27539101,27539251,27539421,27539565,27539894,27540258,27540932,27541334,27541496,27541820,27542522,27542998,27543631,27543865,27544730,27546257,27546328,27546600,27546807,27546927,27547134,27547462,27548140,27548302,27548732,27549049,27549597,27550784,27551570,27552199,27552242,27553054,27557738,27557859,27558131,27558669,27558978,27559350,27560257,27560389,27560995,27561469,27561795,27562127,27562408,27563117,27563701,27564334,27564566,27564733,27565036,27565454,27565628,27566054,27572268,27572359,27572405,27572583,27572614,27572680,27572769,27572886,27573010,27573083,27573117,27573173,27573298,27573376,27576596,2758038', 'assoc_port': '27419509:27427045,27419511:27427374,27419514:27426964,27419518:27426688,27419521:27426163,27419529:27425646,27419537:27424950,27419539:27425446,27419543:27424179,27419546:27423884,27419551:27423378,27419556:27423738,27419558:27422722,27419563:27421795,27419567:27420727,27419569:27421197,27419573:27420592,27419601:27420629,27419606:27419812,27421651:27422327,27424393:27424584,27458267:27460899,27458270:27461078,27458273:27461314,27458276:27461732,27458278:27461835,27458281:27462265,27458283:27462104,27458285:27461699,27458287:27461919,27458289:27461878,27458291:27461583,27458293:27461612,27458295:27461126,27458297:27460614,27458299:27460419,27458301:27459606,27458303:27460229,27458305:27459211,27458307:27459422,27459638:27459914,27462139:27462324,27530981:27538887,27530984:27538868,27530988:27539101,27530992:27539251,27530995:27539421,27530999:27539565,27531003:27539894,27531007:27540258,27531016:27540932,27531021:27541496,27531025:27541334,27531030:27541820,27531034:27542522,27531038:27542998,27531048:2754363', 'assoc_mat': '27419509:pehd:4230:27427045,27419511:pehd:4230:27427374,27419514:pehd:4230:27426964,27419518:pehd:4230:27426688,27419521:pehd:4230:27426163,27419529:pehd:4230:27425646,27419537:pehd:4230:27424950,27419539:pehd:4230:27425446,27419543:pehd:4230:27424179,27419546:pehd:4230:27423884,27419551:pehd:4230:27423378,27419556:pehd:4230:27423738,27419558:pehd:4230:27422722,27419563:pehd:4230:27421795,27419567:pehd:4230:27420727,27419569:pehd:4230:27421197,27419573:pehd:4230:27420592,27419601:pehd:4230:27420629,27419606:pehd:4230:27419812,27421651:pehd:4230:27422327,27424393:pehd:4230:27424584,27458267:pehd:4230:27460899,27458270:pehd:4230:27461078,27458273:pehd:4230:27461314,27458276:pehd:4230:27461732,27458278:pehd:4230:27461835,27458281:pehd:4230:27462265,27458283:pehd:4230:27462104,27458285:pehd:4230:27461699,27458287:pehd:4230:27461919,27458289:pehd:4230:27461878,27458291:pehd:4230:27461583,27458293:pehd:4230:27461612,27458295:pehd:4230:27461126,27458297:pehd:4230:27460614,27458299:pehd:4230:27460419,27458301:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010630832168573186, 'nb_photo': 21067, 'list_port_cont': '27419813,27420596,27420632,27420723,27421185,27421790,27422322,27422712,27423382,27423736,27423887,27424174,27424594,27424941,27425338,27425451,27425641,27426161,27426596,27426689,27426956,27427043,27427375,27459212,27459414,27459610,27459912,27460232,27460413,27460612,27460726,27460896,27461079,27461135,27461304,27461578,27461614,27461705,27461738,27461838,27461879,27461918,27462114,27462262,27462323,27538864,27538884,27539104,27539242,27539427,27539577,27539885,27540265,27540943,27541346,27541501,27541814,27542518,27543000,27543313,27543617,27543862,27544014,27544217,27544430,27544579,27544729,27546267,27546324,27546593,27546809,27546924,27547008,27547096,27547128,27547461,27548136,27548304,27548737,27549051,27549586,27550790,27551575,27552203,27552246,27553060,27557742,27557857,27558141,27558670,27558980,27559346,27560256,27560402,27561008,27561463,27561802,27562128,27562400,27563123,27563690,27564340,27564555,27564731,27565037,27565442,27565637,27566047,27572061,27572138,27572196,27572262,27572355,2757240', 'assoc_port': '27419509:27427043,27419511:27427375,27419514:27426956,27419518:27426689,27419521:27426161,27419523:27426596,27419529:27425641,27419531:27425338,27419537:27424941,27419539:27425451,27419543:27424174,27419546:27423887,27419551:27423382,27419556:27423736,27419558:27422712,27419563:27421790,27419567:27420723,27419569:27421185,27419573:27420596,27419601:27420632,27419606:27419813,27421651:27422322,27424393:27424594,27458264:27460726,27458267:27460896,27458270:27461079,27458273:27461304,27458276:27461738,27458278:27461838,27458281:27462262,27458283:27462114,27458285:27461705,27458287:27461918,27458289:27461879,27458291:27461578,27458293:27461614,27458295:27461135,27458297:27460612,27458299:27460413,27458301:27459610,27458303:27460232,27458305:27459212,27458307:27459414,27459638:27459912,27462139:27462323,27530981:27538884,27530984:27538864,27530988:27539104,27530992:27539242,27530995:27539427,27530999:27539577,27531003:27539885,27531007:27540265,27531016:27540943,27531021:27541501,27531025:27541346,27531030:2754181', 'assoc_mat': '27419509:pet_clair:4230:27427043,27419511:pet_clair:4230:27427375,27419514:pet_clair:4230:27426956,27419518:pet_clair:4230:27426689,27419521:pet_clair:4230:27426161,27419523:pet_clair:4230:27426596,27419529:pet_clair:4230:27425641,27419531:pet_clair:4230:27425338,27419537:pet_clair:4230:27424941,27419539:pet_clair:4230:27425451,27419543:pet_clair:4230:27424174,27419546:pet_clair:4230:27423887,27419551:pet_clair:4230:27423382,27419556:pet_clair:4230:27423736,27419558:pet_clair:4230:27422712,27419563:pet_clair:4230:27421790,27419567:pet_clair:4230:27420723,27419569:pet_clair:4230:27421185,27419573:pet_clair:4230:27420596,27419601:pet_clair:4230:27420632,27419606:pet_clair:4230:27419813,27421651:pet_clair:4230:27422322,27424393:pet_clair:4230:27424594,27458264:pet_clair:4230:27460726,27458267:pet_clair:4230:27460896,27458270:pet_clair:4230:27461079,27458273:pet_clair:4230:27461304,27458276:pet_clair:4230:27461738,27458278:pet_clair:4230:27461838,27458281:pet_clair:4230:27462262,27458283:pet_clair:4230:27462114,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003263674001917912, 'nb_photo': 965, 'list_port_cont': '27420595,27420623,27422718,27423372,27423880,27424942,27425345,27425644,27426152,27427042,27427373,27459214,27459418,27459617,27459913,27460230,27460408,27460600,27460897,27461136,27461573,27461623,27461745,27461876,27461911,27462309,27538857,27538877,27540941,27542515,27543312,27543619,27543869,27544420,27546265,27546334,27546598,27546803,27546917,27547006,27547089,27547123,27547460,27548142,27548312,27551574,27552201,27552244,27557740,27558139,27558674,27558985,27559352,27560258,27561799,27562130,27563121,27564344,27564568,27564727,27565449,27565631,27566057,27572148,27572352,27572406,27572585,27572618,27572763,27572894,27573011,27573077,27573106,27573178,27573306,27579539,27581934,27583821,27584428,27587933,27588745,27588967,27593437,27593970,27594208,27594231,27595201,27595955,27596059,27596389,27596797,27596893,27597528,27599700,27599907,27600894,27601296,27601744,27605097,27605613,27606690,27608702,27610390,27612064,27626203,27690475,27690671,27690869,27691095,27691212,27691671,27692437,27692668,2769274', 'assoc_port': '27419509:27427042,27419511:27427373,27419521:27426152,27419529:27425644,27419531:27425345,27419537:27424942,27419546:27423880,27419551:27423372,27419558:27422718,27419573:27420595,27419601:27420623,27458267:27460897,27458276:27461745,27458287:27461911,27458289:27461876,27458291:27461573,27458293:27461623,27458295:27461136,27458297:27460600,27458299:27460408,27458301:27459617,27458303:27460230,27458305:27459214,27458307:27459418,27459638:27459913,27462139:27462309,27530981:27538877,27530984:27538857,27531016:27540941,27531034:27542515,27531043:27543312,27531048:27543619,27531051:27543869,27531058:27546265,27531066:27546334,27531073:27544420,27531074:27546598,27531082:27546803,27531089:27546917,27531096:27547006,27531103:27547123,27531108:27547089,27531113:27594231,27531117:27547460,27531121:27584428,27531126:27548142,27531130:27548312,27531141:27601744,27531153:27557740,27531155:27551574,27531162:27552201,27531166:27552244,27531168:27558139,27531176:27601296,27531180:27558674,27531184:27558985,27531191:2755935', 'assoc_mat': '27419509:pet_fonce:4230:27427042,27419511:pet_fonce:4230:27427373,27419521:pet_fonce:4230:27426152,27419529:pet_fonce:4230:27425644,27419531:pet_fonce:4230:27425345,27419537:pet_fonce:4230:27424942,27419546:pet_fonce:4230:27423880,27419551:pet_fonce:4230:27423372,27419558:pet_fonce:4230:27422718,27419573:pet_fonce:4230:27420595,27419601:pet_fonce:4230:27420623,27458267:pet_fonce:4230:27460897,27458276:pet_fonce:4230:27461745,27458287:pet_fonce:4230:27461911,27458289:pet_fonce:4230:27461876,27458291:pet_fonce:4230:27461573,27458293:pet_fonce:4230:27461623,27458295:pet_fonce:4230:27461136,27458297:pet_fonce:4230:27460600,27458299:pet_fonce:4230:27460408,27458301:pet_fonce:4230:27459617,27458303:pet_fonce:4230:27460230,27458305:pet_fonce:4230:27459214,27458307:pet_fonce:4230:27459418,27459638:pet_fonce:4230:27459913,27462139:pet_fonce:4230:27462309,27530981:pet_fonce:4230:27538877,27530984:pet_fonce:4230:27538857,27531016:pet_fonce:4230:27540941,27531034:pet_fonce:4230:27542515,27531043:pet_fonce:4230:27543312,2'}), 'main_stat': {'nb_photos': 1580}, 'velours_link': 'https://www.fotonower.com/velours/30124558,30124559,30124560,30124561,30124562,30124563,30124564?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-10', 0.734559377028661),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1580,),), 'unwanted_material_monthly_percentage': ((0.734559377028661,),), 'material_repartition': (('incineration', 1580),), 'material_dict': {'incineration': 1580}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.7054779778095741, 2), (datetime.date(2025, 10, 2), 0.6747298148154705, 2), (datetime.date(2025, 10, 3), 0.6832917330210965, 2), (datetime.date(2025, 10, 4), 0.7547827386752957, 2), (datetime.date(2025, 10, 5), 0.8109524259269868, 2), (datetime.date(2025, 10, 6), 0.711912170205592, 4), (datetime.date(2025, 10, 7), 0.7483601322050677, 3), (datetime.date(2025, 10, 8), 0.6892857486309879, 2), (datetime.date(2025, 10, 9), 0.6857829107923281, 1), (datetime.date(2025, 10, 10), 0.7087370745233148, 2), (datetime.date(2025, 10, 11), 0.7375400301927798, 1), (datetime.date(2025, 10, 12), 0.8367154994401323, 2), (datetime.date(2025, 10, 13), 0.7654051442232372, 3), (datetime.date(2025, 10, 14), 0.7030917379230247, 2), (datetime.date(2025, 10, 15), 0.7173697019402465, 1), (datetime.date(2025, 10, 16), 0.7251553531628971, 3), (datetime.date(2025, 10, 17), 0.6983393378381997, 1), (datetime.date(2025, 10, 18), 0.6531044337018516, 2), (datetime.date(2025, 10, 19), 0.7447846559777486, 2), (datetime.date(2025, 10, 21), 0.7733533197622132, 2), (datetime.date(2025, 10, 22), 0.7650085365716839, 4), (datetime.date(2025, 10, 23), 0.7359088585072924, 3), (datetime.date(2025, 10, 24), 0.7087617942525944, 4), (datetime.date(2025, 10, 25), 0.7419386849717989, 3), (datetime.date(2025, 10, 26), 0.8239361682198136, 4), (datetime.date(2025, 10, 27), 0.7563898712276299, 4), (datetime.date(2025, 10, 28), 0.7772193026827374, 4), (datetime.date(2025, 10, 29), 0.7605406673495437, 3), (datetime.date(2025, 10, 30), 0.6822855939692737, 4), (datetime.date(2025, 10, 31), 0.6522240727166645, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 10, 1), 0.7054779778095741, 2), (datetime.date(2025, 10, 2), 0.6747298148154705, 2), (datetime.date(2025, 10, 3), 0.6832917330210965, 2), (datetime.date(2025, 10, 4), 0.7547827386752957, 2), (datetime.date(2025, 10, 5), 0.8109524259269868, 2), (datetime.date(2025, 10, 6), 0.711912170205592, 4), (datetime.date(2025, 10, 7), 0.7483601322050677, 3), (datetime.date(2025, 10, 8), 0.6892857486309879, 2), (datetime.date(2025, 10, 9), 0.6857829107923281, 1), (datetime.date(2025, 10, 10), 0.7087370745233148, 2), (datetime.date(2025, 10, 11), 0.7375400301927798, 1), (datetime.date(2025, 10, 12), 0.8367154994401323, 2), (datetime.date(2025, 10, 13), 0.7654051442232372, 3), (datetime.date(2025, 10, 14), 0.7030917379230247, 2), (datetime.date(2025, 10, 15), 0.7173697019402465, 1), (datetime.date(2025, 10, 16), 0.7251553531628971, 3), (datetime.date(2025, 10, 17), 0.6983393378381997, 1), (datetime.date(2025, 10, 18), 0.6531044337018516, 2), (datetime.date(2025, 10, 19), 0.7447846559777486, 2), (datetime.date(2025, 10, 21), 0.7733533197622132, 2), (datetime.date(2025, 10, 22), 0.7650085365716839, 4), (datetime.date(2025, 10, 23), 0.7359088585072924, 3), (datetime.date(2025, 10, 24), 0.7087617942525944, 4), (datetime.date(2025, 10, 25), 0.7419386849717989, 3), (datetime.date(2025, 10, 26), 0.8239361682198136, 4), (datetime.date(2025, 10, 27), 0.7563898712276299, 4), (datetime.date(2025, 10, 28), 0.7772193026827374, 4), (datetime.date(2025, 10, 29), 0.7605406673495437, 3), (datetime.date(2025, 10, 30), 0.6822855939692737, 4), (datetime.date(2025, 10, 31), 0.6522240727166645, 2))}, 'quality_array': [['-8.37139241133978', '01102025'], ['-8.030738622754848', '02102025'], ['-8.10978577166114', '03102025'], ['-8.269227304570922', '04102025'], ['-8.347799980372129', '05102025'], ['-8.12701547103574', '06102025'], ['-8.063106524134215', '07102025'], ['-8.282593280753673', '08102025'], ['-8.333809956937186', '09102025'], ['-8.342496006082387', '10102025'], ['-8.19835602937615', '11102025'], ['-8.245256459655144', '12102025'], ['-7.996466730490495', '13102025'], ['-8.160951152914539', '14102025'], ['-8.251090745486188', '15102025'], ['-8.091756540627506', '16102025'], ['-8.146152425164118', '17102025'], ['-8.284833195379964', '18102025'], ['-8.391737038005568', '19102025'], ['-8.371075946009217', '21102025'], ['-8.282626540147604', '22102025'], ['-8.30025171858188', '23102025'], ['-8.081587079007189', '24102025'], ['-8.002410499291592', '25102025'], ['-8.185237000931524', '26102025'], ['-8.16082377790358', '27102025'], ['-7.725357327114873', '28102025'], ['-7.9236817559003105', '29102025'], ['-8.10359920125422', '30102025'], ['-8.021479440115328', '31102025']], 'number_of_batch': ((604,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014705980367627302, 'nb_photo': 16760, 'list_port_cont': '27419801,27420588,27420625,27420726,27421186,27421779,27422314,27422706,27423375,27423737,27423886,27424167,27424593,27424939,27425344,27425442,27425645,27426153,27426582,27426686,27426959,27427038,27427360,27459206,27459419,27459616,27459910,27460226,27460411,27460611,27460728,27460894,27461086,27461122,27461303,27461580,27461610,27461700,27461733,27461834,27461868,27461917,27462105,27462264,27462320,27538869,27538881,27539099,27539241,27539418,27539567,27539886,27540272,27540930,27541335,27541495,27541812,27542514,27542988,27543315,27543622,27543868,27544015,27544202,27544424,27544577,27544715,27546253,27546327,27546606,27546804,27546928,27547004,27547086,27547120,27547465,27548128,27548307,27548729,27549041,27549590,27550796,27551567,27552189,27552249,27553063,27557732,27557852,27558126,27558679,27558973,27559342,27560248,27560400,27561002,27561460,27561801,27562122,27562407,27563118,27563698,27564342,27564554,27564720,27565030,27565438,27565627,27566045,27572055,27572139,27572185,27572266,27572358,2757239', 'assoc_port': '27419509:27427038,27419511:27427360,27419514:27426959,27419518:27426686,27419521:27426153,27419523:27426582,27419529:27425645,27419531:27425344,27419537:27424939,27419539:27425442,27419543:27424167,27419546:27423886,27419551:27423375,27419556:27423737,27419558:27422706,27419563:27421779,27419567:27420726,27419569:27421186,27419573:27420588,27419601:27420625,27419606:27419801,27421651:27422314,27424393:27424593,27458264:27460728,27458267:27460894,27458270:27461086,27458273:27461303,27458276:27461733,27458278:27461834,27458281:27462264,27458283:27462105,27458285:27461700,27458287:27461917,27458289:27461868,27458291:27461580,27458293:27461610,27458295:27461122,27458297:27460611,27458299:27460411,27458301:27459616,27458303:27460226,27458305:27459206,27458307:27459419,27459638:27459910,27462139:27462320,27530981:27538881,27530984:27538869,27530988:27539099,27530992:27539241,27530995:27539418,27530999:27539567,27531003:27539886,27531007:27540272,27531016:27540930,27531021:27541495,27531025:27541335,27531030:2754181', 'assoc_mat': '27419509:autre:4230:27427038,27419511:autre:4230:27427360,27419514:autre:4230:27426959,27419518:autre:4230:27426686,27419521:autre:4230:27426153,27419523:autre:4230:27426582,27419529:autre:4230:27425645,27419531:autre:4230:27425344,27419537:autre:4230:27424939,27419539:autre:4230:27425442,27419543:autre:4230:27424167,27419546:autre:4230:27423886,27419551:autre:4230:27423375,27419556:autre:4230:27423737,27419558:autre:4230:27422706,27419563:autre:4230:27421779,27419567:autre:4230:27420726,27419569:autre:4230:27421186,27419573:autre:4230:27420588,27419601:autre:4230:27420625,27419606:autre:4230:27419801,27421651:autre:4230:27422314,27424393:autre:4230:27424593,27458264:autre:4230:27460728,27458267:autre:4230:27460894,27458270:autre:4230:27461086,27458273:autre:4230:27461303,27458276:autre:4230:27461733,27458278:autre:4230:27461834,27458281:autre:4230:27462264,27458283:autre:4230:27462105,27458285:autre:4230:27461700,27458287:autre:4230:27461917,27458289:autre:4230:27461868,27458291:autre:4230:27461580,27458293:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06444572547294747, 'nb_photo': 113444, 'list_port_cont': '27419811,27420593,27420622,27420734,27421191,27421791,27422330,27422720,27423380,27423740,27423885,27424175,27424598,27424946,27425340,27425450,27425652,27426151,27426592,27426676,27426969,27427044,27427369,27459216,27459425,27459615,27459916,27460228,27460420,27460609,27460732,27460895,27461083,27461127,27461311,27461572,27461624,27461694,27461744,27461840,27461872,27461914,27462112,27462267,27462314,27538862,27538891,27539105,27539254,27539416,27539581,27539895,27540261,27540940,27541343,27541491,27541821,27542513,27542987,27543316,27543630,27543870,27544025,27544210,27544432,27544582,27544728,27546260,27546333,27546604,27546801,27546920,27547012,27547095,27547132,27547468,27548139,27548311,27548739,27549055,27549595,27550782,27551573,27552206,27552245,27553056,27557734,27557851,27558140,27558673,27558986,27559345,27560259,27560392,27561005,27561473,27561800,27562132,27562399,27563127,27563699,27564341,27564570,27564730,27565040,27565452,27565635,27566048,27572070,27572137,27572202,27572261,27572357,2757240', 'assoc_port': '27419509:27427044,27419511:27427369,27419514:27426969,27419518:27426676,27419521:27426151,27419523:27426592,27419529:27425652,27419531:27425340,27419537:27424946,27419539:27425450,27419543:27424175,27419546:27423885,27419551:27423380,27419556:27423740,27419558:27422720,27419563:27421791,27419567:27420734,27419569:27421191,27419573:27420593,27419601:27420622,27419606:27419811,27421651:27422330,27424393:27424598,27458264:27460732,27458267:27460895,27458270:27461083,27458273:27461311,27458276:27461744,27458278:27461840,27458281:27462267,27458283:27462112,27458285:27461694,27458287:27461914,27458289:27461872,27458291:27461572,27458293:27461624,27458295:27461127,27458297:27460609,27458299:27460420,27458301:27459615,27458303:27460228,27458305:27459216,27458307:27459425,27459638:27459916,27462139:27462314,27530981:27538891,27530984:27538862,27530988:27539105,27530992:27539254,27530995:27539416,27530999:27539581,27531003:27539895,27531007:27540261,27531016:27540940,27531021:27541491,27531025:27541343,27531030:2754182', 'assoc_mat': '27419509:carton:4230:27427044,27419511:carton:4230:27427369,27419514:carton:4230:27426969,27419518:carton:4230:27426676,27419521:carton:4230:27426151,27419523:carton:4230:27426592,27419529:carton:4230:27425652,27419531:carton:4230:27425340,27419537:carton:4230:27424946,27419539:carton:4230:27425450,27419543:carton:4230:27424175,27419546:carton:4230:27423885,27419551:carton:4230:27423380,27419556:carton:4230:27423740,27419558:carton:4230:27422720,27419563:carton:4230:27421791,27419567:carton:4230:27420734,27419569:carton:4230:27421191,27419573:carton:4230:27420593,27419601:carton:4230:27420622,27419606:carton:4230:27419811,27421651:carton:4230:27422330,27424393:carton:4230:27424598,27458264:carton:4230:27460732,27458267:carton:4230:27460895,27458270:carton:4230:27461083,27458273:carton:4230:27461311,27458276:carton:4230:27461744,27458278:carton:4230:27461840,27458281:carton:4230:27462267,27458283:carton:4230:27462112,27458285:carton:4230:27461694,27458287:carton:4230:27461914,27458289:carton:4230:27461872,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015643915775535387, 'nb_photo': 2028, 'list_port_cont': '27419796,27420579,27420621,27420718,27421199,27421793,27422326,27422711,27423383,27423730,27423882,27424170,27424591,27425448,27425650,27426157,27426579,27426685,27427041,27459213,27459421,27459614,27459905,27460236,27460414,27460604,27460731,27460885,27461081,27461130,27461309,27461574,27461619,27461702,27461731,27461823,27461865,27461909,27462100,27462266,27462319,27538878,27539090,27539240,27539570,27539896,27540269,27540935,27541336,27542507,27542984,27543632,27543854,27544203,27544425,27544726,27546256,27546322,27546605,27546797,27546929,27547010,27547119,27547456,27548125,27548308,27548730,27549053,27550788,27551578,27552196,27552241,27557730,27557861,27558136,27558676,27558972,27559340,27560252,27560393,27561004,27561462,27561793,27562121,27562392,27563687,27564331,27564556,27564726,27565023,27565445,27565632,27566051,27572149,27572267,27572346,27572401,27572579,27572615,27572687,27572899,27573004,27573072,27573114,27573170,27573308,27573386,27576025,27576597,27579535,27580955,27581923,27583495,2758443', 'assoc_port': '27419509:27427041,27419518:27426685,27419521:27426157,27419523:27426579,27419529:27425650,27419539:27425448,27419543:27424170,27419546:27423882,27419551:27423383,27419556:27423730,27419558:27422711,27419563:27421793,27419567:27420718,27419569:27421199,27419573:27420579,27419601:27420621,27419606:27419796,27421651:27422326,27424393:27424591,27458264:27460731,27458267:27460885,27458270:27461081,27458273:27461309,27458276:27461731,27458278:27461823,27458281:27462266,27458283:27462100,27458285:27461702,27458287:27461909,27458289:27461865,27458291:27461574,27458293:27461619,27458295:27461130,27458297:27460604,27458299:27460414,27458301:27459614,27458303:27460236,27458305:27459213,27458307:27459421,27459638:27459905,27462139:27462319,27530981:27538878,27530988:27539090,27530992:27539240,27530999:27539570,27531003:27539896,27531007:27540269,27531016:27540935,27531025:27541336,27531034:27542507,27531038:27542984,27531048:27543632,27531051:27543854,27531058:27546256,27531065:27544203,27531066:27546322,27531073:2754442', 'assoc_mat': '27419509:metal:4230:27427041,27419518:metal:4230:27426685,27419521:metal:4230:27426157,27419523:metal:4230:27426579,27419529:metal:4230:27425650,27419539:metal:4230:27425448,27419543:metal:4230:27424170,27419546:metal:4230:27423882,27419551:metal:4230:27423383,27419556:metal:4230:27423730,27419558:metal:4230:27422711,27419563:metal:4230:27421793,27419567:metal:4230:27420718,27419569:metal:4230:27421199,27419573:metal:4230:27420579,27419601:metal:4230:27420621,27419606:metal:4230:27419796,27421651:metal:4230:27422326,27424393:metal:4230:27424591,27458264:metal:4230:27460731,27458267:metal:4230:27460885,27458270:metal:4230:27461081,27458273:metal:4230:27461309,27458276:metal:4230:27461731,27458278:metal:4230:27461823,27458281:metal:4230:27462266,27458283:metal:4230:27462100,27458285:metal:4230:27461702,27458287:metal:4230:27461909,27458289:metal:4230:27461865,27458291:metal:4230:27461574,27458293:metal:4230:27461619,27458295:metal:4230:27461130,27458297:metal:4230:27460604,27458299:metal:4230:27460414,27458301:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18504152570739973, 'nb_photo': 320130, 'list_port_cont': '27419810,27420587,27420627,27420735,27421196,27421792,27422328,27422719,27423374,27423735,27423888,27424183,27424592,27424951,27425346,27425445,27425651,27426164,27426588,27426691,27426965,27427034,27427371,27459217,27459423,27459604,27459909,27460227,27460417,27460608,27460733,27460901,27461076,27461133,27461300,27461582,27461621,27461706,27461735,27461836,27461873,27461921,27462110,27462257,27462322,27538870,27538885,27539093,27539249,27539429,27539576,27539891,27540273,27540936,27541345,27541503,27541827,27542521,27543001,27543320,27543629,27543863,27544019,27544215,27544431,27544583,27544721,27546264,27546323,27546599,27546808,27546925,27547013,27547092,27547133,27547464,27548138,27548298,27548735,27549056,27549596,27550786,27551582,27552200,27552251,27553064,27557727,27557858,27558137,27558666,27558975,27559349,27560250,27560397,27561003,27561472,27561796,27562129,27562401,27563126,27563691,27564333,27564569,27564735,27565031,27565444,27565636,27566055,27572063,27572143,27572200,27572263,27572363,2757240', 'assoc_port': '27419509:27427034,27419511:27427371,27419514:27426965,27419518:27426691,27419521:27426164,27419523:27426588,27419529:27425651,27419531:27425346,27419537:27424951,27419539:27425445,27419543:27424183,27419546:27423888,27419551:27423374,27419556:27423735,27419558:27422719,27419563:27421792,27419567:27420735,27419569:27421196,27419573:27420587,27419601:27420627,27419606:27419810,27421651:27422328,27424393:27424592,27458264:27460733,27458267:27460901,27458270:27461076,27458273:27461300,27458276:27461735,27458278:27461836,27458281:27462257,27458283:27462110,27458285:27461706,27458287:27461921,27458289:27461873,27458291:27461582,27458293:27461621,27458295:27461133,27458297:27460608,27458299:27460417,27458301:27459604,27458303:27460227,27458305:27459217,27458307:27459423,27459638:27459909,27462139:27462322,27530981:27538885,27530984:27538870,27530988:27539093,27530992:27539249,27530995:27539429,27530999:27539576,27531003:27539891,27531007:27540273,27531016:27540936,27531021:27541503,27531025:27541345,27531030:2754182', 'assoc_mat': '27419509:papier:4230:27427034,27419511:papier:4230:27427371,27419514:papier:4230:27426965,27419518:papier:4230:27426691,27419521:papier:4230:27426164,27419523:papier:4230:27426588,27419529:papier:4230:27425651,27419531:papier:4230:27425346,27419537:papier:4230:27424951,27419539:papier:4230:27425445,27419543:papier:4230:27424183,27419546:papier:4230:27423888,27419551:papier:4230:27423374,27419556:papier:4230:27423735,27419558:papier:4230:27422719,27419563:papier:4230:27421792,27419567:papier:4230:27420735,27419569:papier:4230:27421196,27419573:papier:4230:27420587,27419601:papier:4230:27420627,27419606:papier:4230:27419810,27421651:papier:4230:27422328,27424393:papier:4230:27424592,27458264:papier:4230:27460733,27458267:papier:4230:27460901,27458270:papier:4230:27461076,27458273:papier:4230:27461300,27458276:papier:4230:27461735,27458278:papier:4230:27461836,27458281:papier:4230:27462257,27458283:papier:4230:27462110,27458285:papier:4230:27461706,27458287:papier:4230:27461921,27458289:papier:4230:27461873,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005226425483397223, 'nb_photo': 2608, 'list_port_cont': '27419812,27420592,27420629,27420727,27421197,27421795,27422327,27422722,27423378,27423738,27423884,27424179,27424584,27424950,27425446,27425646,27426163,27426688,27426964,27427045,27427374,27459211,27459422,27459606,27459914,27460229,27460419,27460614,27460899,27461078,27461126,27461314,27461583,27461612,27461699,27461732,27461835,27461878,27461919,27462104,27462265,27462324,27538868,27538887,27539101,27539251,27539421,27539565,27539894,27540258,27540932,27541334,27541496,27541820,27542522,27542998,27543631,27543865,27544730,27546257,27546328,27546600,27546807,27546927,27547134,27547462,27548140,27548302,27548732,27549049,27549597,27550784,27551570,27552199,27552242,27553054,27557738,27557859,27558131,27558669,27558978,27559350,27560257,27560389,27560995,27561469,27561795,27562127,27562408,27563117,27563701,27564334,27564566,27564733,27565036,27565454,27565628,27566054,27572268,27572359,27572405,27572583,27572614,27572680,27572769,27572886,27573010,27573083,27573117,27573173,27573298,27573376,27576596,2758038', 'assoc_port': '27419509:27427045,27419511:27427374,27419514:27426964,27419518:27426688,27419521:27426163,27419529:27425646,27419537:27424950,27419539:27425446,27419543:27424179,27419546:27423884,27419551:27423378,27419556:27423738,27419558:27422722,27419563:27421795,27419567:27420727,27419569:27421197,27419573:27420592,27419601:27420629,27419606:27419812,27421651:27422327,27424393:27424584,27458267:27460899,27458270:27461078,27458273:27461314,27458276:27461732,27458278:27461835,27458281:27462265,27458283:27462104,27458285:27461699,27458287:27461919,27458289:27461878,27458291:27461583,27458293:27461612,27458295:27461126,27458297:27460614,27458299:27460419,27458301:27459606,27458303:27460229,27458305:27459211,27458307:27459422,27459638:27459914,27462139:27462324,27530981:27538887,27530984:27538868,27530988:27539101,27530992:27539251,27530995:27539421,27530999:27539565,27531003:27539894,27531007:27540258,27531016:27540932,27531021:27541496,27531025:27541334,27531030:27541820,27531034:27542522,27531038:27542998,27531048:2754363', 'assoc_mat': '27419509:pehd:4230:27427045,27419511:pehd:4230:27427374,27419514:pehd:4230:27426964,27419518:pehd:4230:27426688,27419521:pehd:4230:27426163,27419529:pehd:4230:27425646,27419537:pehd:4230:27424950,27419539:pehd:4230:27425446,27419543:pehd:4230:27424179,27419546:pehd:4230:27423884,27419551:pehd:4230:27423378,27419556:pehd:4230:27423738,27419558:pehd:4230:27422722,27419563:pehd:4230:27421795,27419567:pehd:4230:27420727,27419569:pehd:4230:27421197,27419573:pehd:4230:27420592,27419601:pehd:4230:27420629,27419606:pehd:4230:27419812,27421651:pehd:4230:27422327,27424393:pehd:4230:27424584,27458267:pehd:4230:27460899,27458270:pehd:4230:27461078,27458273:pehd:4230:27461314,27458276:pehd:4230:27461732,27458278:pehd:4230:27461835,27458281:pehd:4230:27462265,27458283:pehd:4230:27462104,27458285:pehd:4230:27461699,27458287:pehd:4230:27461919,27458289:pehd:4230:27461878,27458291:pehd:4230:27461583,27458293:pehd:4230:27461612,27458295:pehd:4230:27461126,27458297:pehd:4230:27460614,27458299:pehd:4230:27460419,27458301:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010630832168573186, 'nb_photo': 21067, 'list_port_cont': '27419813,27420596,27420632,27420723,27421185,27421790,27422322,27422712,27423382,27423736,27423887,27424174,27424594,27424941,27425338,27425451,27425641,27426161,27426596,27426689,27426956,27427043,27427375,27459212,27459414,27459610,27459912,27460232,27460413,27460612,27460726,27460896,27461079,27461135,27461304,27461578,27461614,27461705,27461738,27461838,27461879,27461918,27462114,27462262,27462323,27538864,27538884,27539104,27539242,27539427,27539577,27539885,27540265,27540943,27541346,27541501,27541814,27542518,27543000,27543313,27543617,27543862,27544014,27544217,27544430,27544579,27544729,27546267,27546324,27546593,27546809,27546924,27547008,27547096,27547128,27547461,27548136,27548304,27548737,27549051,27549586,27550790,27551575,27552203,27552246,27553060,27557742,27557857,27558141,27558670,27558980,27559346,27560256,27560402,27561008,27561463,27561802,27562128,27562400,27563123,27563690,27564340,27564555,27564731,27565037,27565442,27565637,27566047,27572061,27572138,27572196,27572262,27572355,2757240', 'assoc_port': '27419509:27427043,27419511:27427375,27419514:27426956,27419518:27426689,27419521:27426161,27419523:27426596,27419529:27425641,27419531:27425338,27419537:27424941,27419539:27425451,27419543:27424174,27419546:27423887,27419551:27423382,27419556:27423736,27419558:27422712,27419563:27421790,27419567:27420723,27419569:27421185,27419573:27420596,27419601:27420632,27419606:27419813,27421651:27422322,27424393:27424594,27458264:27460726,27458267:27460896,27458270:27461079,27458273:27461304,27458276:27461738,27458278:27461838,27458281:27462262,27458283:27462114,27458285:27461705,27458287:27461918,27458289:27461879,27458291:27461578,27458293:27461614,27458295:27461135,27458297:27460612,27458299:27460413,27458301:27459610,27458303:27460232,27458305:27459212,27458307:27459414,27459638:27459912,27462139:27462323,27530981:27538884,27530984:27538864,27530988:27539104,27530992:27539242,27530995:27539427,27530999:27539577,27531003:27539885,27531007:27540265,27531016:27540943,27531021:27541501,27531025:27541346,27531030:2754181', 'assoc_mat': '27419509:pet_clair:4230:27427043,27419511:pet_clair:4230:27427375,27419514:pet_clair:4230:27426956,27419518:pet_clair:4230:27426689,27419521:pet_clair:4230:27426161,27419523:pet_clair:4230:27426596,27419529:pet_clair:4230:27425641,27419531:pet_clair:4230:27425338,27419537:pet_clair:4230:27424941,27419539:pet_clair:4230:27425451,27419543:pet_clair:4230:27424174,27419546:pet_clair:4230:27423887,27419551:pet_clair:4230:27423382,27419556:pet_clair:4230:27423736,27419558:pet_clair:4230:27422712,27419563:pet_clair:4230:27421790,27419567:pet_clair:4230:27420723,27419569:pet_clair:4230:27421185,27419573:pet_clair:4230:27420596,27419601:pet_clair:4230:27420632,27419606:pet_clair:4230:27419813,27421651:pet_clair:4230:27422322,27424393:pet_clair:4230:27424594,27458264:pet_clair:4230:27460726,27458267:pet_clair:4230:27460896,27458270:pet_clair:4230:27461079,27458273:pet_clair:4230:27461304,27458276:pet_clair:4230:27461738,27458278:pet_clair:4230:27461838,27458281:pet_clair:4230:27462262,27458283:pet_clair:4230:27462114,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003263674001917912, 'nb_photo': 965, 'list_port_cont': '27420595,27420623,27422718,27423372,27423880,27424942,27425345,27425644,27426152,27427042,27427373,27459214,27459418,27459617,27459913,27460230,27460408,27460600,27460897,27461136,27461573,27461623,27461745,27461876,27461911,27462309,27538857,27538877,27540941,27542515,27543312,27543619,27543869,27544420,27546265,27546334,27546598,27546803,27546917,27547006,27547089,27547123,27547460,27548142,27548312,27551574,27552201,27552244,27557740,27558139,27558674,27558985,27559352,27560258,27561799,27562130,27563121,27564344,27564568,27564727,27565449,27565631,27566057,27572148,27572352,27572406,27572585,27572618,27572763,27572894,27573011,27573077,27573106,27573178,27573306,27579539,27581934,27583821,27584428,27587933,27588745,27588967,27593437,27593970,27594208,27594231,27595201,27595955,27596059,27596389,27596797,27596893,27597528,27599700,27599907,27600894,27601296,27601744,27605097,27605613,27606690,27608702,27610390,27612064,27626203,27690475,27690671,27690869,27691095,27691212,27691671,27692437,27692668,2769274', 'assoc_port': '27419509:27427042,27419511:27427373,27419521:27426152,27419529:27425644,27419531:27425345,27419537:27424942,27419546:27423880,27419551:27423372,27419558:27422718,27419573:27420595,27419601:27420623,27458267:27460897,27458276:27461745,27458287:27461911,27458289:27461876,27458291:27461573,27458293:27461623,27458295:27461136,27458297:27460600,27458299:27460408,27458301:27459617,27458303:27460230,27458305:27459214,27458307:27459418,27459638:27459913,27462139:27462309,27530981:27538877,27530984:27538857,27531016:27540941,27531034:27542515,27531043:27543312,27531048:27543619,27531051:27543869,27531058:27546265,27531066:27546334,27531073:27544420,27531074:27546598,27531082:27546803,27531089:27546917,27531096:27547006,27531103:27547123,27531108:27547089,27531113:27594231,27531117:27547460,27531121:27584428,27531126:27548142,27531130:27548312,27531141:27601744,27531153:27557740,27531155:27551574,27531162:27552201,27531166:27552244,27531168:27558139,27531176:27601296,27531180:27558674,27531184:27558985,27531191:2755935', 'assoc_mat': '27419509:pet_fonce:4230:27427042,27419511:pet_fonce:4230:27427373,27419521:pet_fonce:4230:27426152,27419529:pet_fonce:4230:27425644,27419531:pet_fonce:4230:27425345,27419537:pet_fonce:4230:27424942,27419546:pet_fonce:4230:27423880,27419551:pet_fonce:4230:27423372,27419558:pet_fonce:4230:27422718,27419573:pet_fonce:4230:27420595,27419601:pet_fonce:4230:27420623,27458267:pet_fonce:4230:27460897,27458276:pet_fonce:4230:27461745,27458287:pet_fonce:4230:27461911,27458289:pet_fonce:4230:27461876,27458291:pet_fonce:4230:27461573,27458293:pet_fonce:4230:27461623,27458295:pet_fonce:4230:27461136,27458297:pet_fonce:4230:27460600,27458299:pet_fonce:4230:27460408,27458301:pet_fonce:4230:27459617,27458303:pet_fonce:4230:27460230,27458305:pet_fonce:4230:27459214,27458307:pet_fonce:4230:27459418,27459638:pet_fonce:4230:27459913,27462139:pet_fonce:4230:27462309,27530981:pet_fonce:4230:27538877,27530984:pet_fonce:4230:27538857,27531016:pet_fonce:4230:27540941,27531034:pet_fonce:4230:27542515,27531043:pet_fonce:4230:27543312,2'}), 'main_stat': {'nb_photos': 1580}, 'velours_link': 'https://www.fotonower.com/velours/30124558,30124559,30124560,30124561,30124562,30124563,30124564?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-10', 0.734559377028661),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_10_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.47%', 16760], 'carton': ['carton', '6.44%', 113444], 'metal': ['metal', '0.16%', 2028], 'papier': ['papier', '18.5%', 320130], 'pehd': ['pehd', '0.52%', 2608], 'pet_clair': ['pet_clair', '1.06%', 21067], 'pet_fonce': ['pet_fonce', '0.33%', 965]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_10_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.31user 3.00system 0:15.71elapsed 33%CPU (0avgtext+0avgdata 184460maxresident)k 2488inputs+376outputs (5major+44511minor)pagefaults 0swaps