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_cam6 -j exemple_contaminant_stat -v --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 --date 2025-10' -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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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_cam6" 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 (2384951,2392603,2406369,2406361,2406355,2408595,2412705,2419639,2428101,2436193,2442075,2442775,2450013,2457660,2465475,2468737,2473651,2476955,2484319,2484207,2484295,2484215,2484287,2484273,2484259,2484223,2484255,2493487,2493513,2496809) 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.014850347748988964, 'nb_photo': 20990, 'list_port_cont': '27418494,27419905,27420198,27420393,27420847,27421239,27421568,27422031,27422488,27422808,27423183,27423328,27423953,27424427,27424794,27424843,27425195,27425375,27425737,27425902,27426197,27426750,27427132,27427409,27457808,27458313,27458365,27458411,27458460,27458493,27458700,27458766,27458812,27458866,27458911,27459062,27459245,27459344,27459384,27459684,27459844,27460073,27460185,27460531,27460807,27460847,27461422,27462703,27542757,27543209,27543492,27543734,27543948,27544156,27544511,27544645,27544852,27544954,27545109,27545218,27545494,27545542,27545648,27545798,27545874,27545918,27545961,27546049,27546189,27546408,27546527,27546708,27546845,27546970,27547053,27547237,27547288,27547826,27547887,27548273,27548547,27548667,27549169,27549335,27550086,27550296,27551104,27551920,27552633,27557059,27557118,27557246,27557305,27557386,27557609,27557647,27558217,27558384,27558881,27559132,27559501,27560134,27560654,27560955,27561316,27561750,27562056,27562500,27563173,27563805,27564030,27568543,27569184,2756989', 'assoc_port': '27414921:27418494,27419508:27427132,27419512:27427409,27419515:27426750,27419517:27425902,27419520:27426197,27419524:27425737,27419528:27425375,27419532:27424843,27419536:27425195,27419540:27424427,27419542:27423953,27419547:27423183,27419550:27423328,27419555:27422808,27419559:27422031,27419562:27421568,27419566:27420847,27419571:27421239,27419574:27420393,27419603:27419905,27419605:27420198,27421653:27422488,27424392:27424794,27457115:27457808,27458266:27460847,27458269:27461422,27458272:27460807,27458275:27460531,27458277:27459684,27458280:27459844,27458282:27460185,27458284:27459384,27458286:27459344,27458288:27459062,27458290:27459245,27458292:27458911,27458294:27458866,27458296:27458766,27458298:27458812,27458300:27458493,27458302:27458700,27458304:27458411,27458306:27458460,27458308:27458365,27458309:27458313,27459575:27460073,27462142:27462703,27530982:27542757,27530986:27543209,27530989:27543492,27530993:27543734,27530996:27543948,27531000:27544156,27531004:27578289,27531009:27544511,27531013:2754464', 'assoc_mat': '27414921:autre:4230:27418494,27419508:autre:4230:27427132,27419512:autre:4230:27427409,27419515:autre:4230:27426750,27419517:autre:4230:27425902,27419520:autre:4230:27426197,27419524:autre:4230:27425737,27419528:autre:4230:27425375,27419532:autre:4230:27424843,27419536:autre:4230:27425195,27419540:autre:4230:27424427,27419542:autre:4230:27423953,27419547:autre:4230:27423183,27419550:autre:4230:27423328,27419555:autre:4230:27422808,27419559:autre:4230:27422031,27419562:autre:4230:27421568,27419566:autre:4230:27420847,27419571:autre:4230:27421239,27419574:autre:4230:27420393,27419603:autre:4230:27419905,27419605:autre:4230:27420198,27421653:autre:4230:27422488,27424392:autre:4230:27424794,27457115:autre:4230:27457808,27458266:autre:4230:27460847,27458269:autre:4230:27461422,27458272:autre:4230:27460807,27458275:autre:4230:27460531,27458277:autre:4230:27459684,27458280:autre:4230:27459844,27458282:autre:4230:27460185,27458284:autre:4230:27459384,27458286:autre:4230:27459344,27458288:autre:4230:27459062,27458290:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.055245668813900764, 'nb_photo': 104677, 'list_port_cont': '27418492,27419899,27420199,27420392,27420858,27421246,27421572,27422027,27422499,27422795,27423186,27423341,27423960,27424422,27424789,27424857,27425201,27425391,27425749,27425905,27426204,27426762,27427131,27427398,27457814,27458321,27458362,27458415,27458450,27458497,27458716,27458773,27458804,27458874,27458921,27459055,27459247,27459351,27459386,27459687,27459846,27460066,27460191,27460534,27460809,27460848,27461434,27462717,27542749,27543210,27543504,27543737,27543940,27544161,27544501,27544643,27544850,27544961,27545125,27545206,27545496,27545534,27545649,27545806,27545877,27545921,27545974,27546053,27546198,27546424,27546537,27546705,27546851,27546972,27547052,27547239,27547281,27547820,27547883,27548267,27548541,27548663,27549171,27549334,27550077,27550286,27551120,27551907,27552627,27557071,27557112,27557259,27557314,27557381,27557610,27557662,27558224,27558394,27558876,27559131,27559500,27560127,27560664,27560963,27561324,27561760,27562061,27562493,27563171,27563807,27564037,27568535,27569189,2756990', 'assoc_port': '27414921:27418492,27419508:27427131,27419512:27427398,27419515:27426762,27419517:27425905,27419520:27426204,27419524:27425749,27419528:27425391,27419532:27424857,27419536:27425201,27419540:27424422,27419542:27423960,27419547:27423186,27419550:27423341,27419555:27422795,27419559:27422027,27419562:27421572,27419566:27420858,27419571:27421246,27419574:27420392,27419603:27419899,27419605:27420199,27421653:27422499,27424392:27424789,27457115:27457814,27458266:27460848,27458269:27461434,27458272:27460809,27458275:27460534,27458277:27459687,27458280:27459846,27458282:27460191,27458284:27459386,27458286:27459351,27458288:27459055,27458290:27459247,27458292:27458921,27458294:27458874,27458296:27458773,27458298:27458804,27458300:27458497,27458302:27458716,27458304:27458415,27458306:27458450,27458308:27458362,27458309:27458321,27459575:27460066,27462142:27462717,27530982:27542749,27530986:27543210,27530989:27543504,27530993:27543737,27530996:27543940,27531000:27544161,27531004:27578291,27531009:27544501,27531013:2754464', 'assoc_mat': '27414921:carton:4230:27418492,27419508:carton:4230:27427131,27419512:carton:4230:27427398,27419515:carton:4230:27426762,27419517:carton:4230:27425905,27419520:carton:4230:27426204,27419524:carton:4230:27425749,27419528:carton:4230:27425391,27419532:carton:4230:27424857,27419536:carton:4230:27425201,27419540:carton:4230:27424422,27419542:carton:4230:27423960,27419547:carton:4230:27423186,27419550:carton:4230:27423341,27419555:carton:4230:27422795,27419559:carton:4230:27422027,27419562:carton:4230:27421572,27419566:carton:4230:27420858,27419571:carton:4230:27421246,27419574:carton:4230:27420392,27419603:carton:4230:27419899,27419605:carton:4230:27420199,27421653:carton:4230:27422499,27424392:carton:4230:27424789,27457115:carton:4230:27457814,27458266:carton:4230:27460848,27458269:carton:4230:27461434,27458272:carton:4230:27460809,27458275:carton:4230:27460534,27458277:carton:4230:27459687,27458280:carton:4230:27459846,27458282:carton:4230:27460191,27458284:carton:4230:27459386,27458286:carton:4230:27459351,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012118017193548133, 'nb_photo': 1897, 'list_port_cont': '27419896,27420384,27420841,27422021,27422493,27422792,27423178,27423962,27424419,27424784,27424851,27425192,27425383,27425907,27426201,27427407,27457807,27458324,27458414,27458448,27458491,27458714,27458761,27458803,27458918,27459238,27459339,27459675,27459833,27460187,27460528,27460850,27461432,27462706,27542745,27543196,27543503,27543742,27543939,27544148,27544503,27544649,27544835,27544951,27545118,27545210,27545498,27545537,27545646,27545881,27545922,27545973,27546413,27546534,27546698,27546844,27546965,27547050,27547283,27548257,27548532,27548656,27549156,27549327,27550083,27550293,27551108,27551921,27552634,27557064,27557113,27557298,27557370,27557602,27558218,27558389,27558875,27559130,27559497,27560126,27560655,27560953,27561309,27561752,27562051,27562492,27563797,27564036,27568532,27569187,27569910,27570421,27570831,27570975,27571113,27571201,27571260,27571407,27571494,27571695,27571733,27571779,27571820,27571894,27571951,27576234,27577225,27578293,27579092,27579114,27580691,27581413,27581641,2758246', 'assoc_port': '27419512:27427407,27419517:27425907,27419520:27426201,27419528:27425383,27419532:27424851,27419536:27425192,27419540:27424419,27419542:27423962,27419547:27423178,27419555:27422792,27419559:27422021,27419566:27420841,27419574:27420384,27419603:27419896,27421653:27422493,27424392:27424784,27457115:27457807,27458266:27460850,27458269:27461432,27458275:27460528,27458277:27459675,27458280:27459833,27458282:27460187,27458286:27459339,27458290:27459238,27458292:27458918,27458296:27458761,27458298:27458803,27458300:27458491,27458302:27458714,27458304:27458414,27458306:27458448,27458309:27458324,27462142:27462706,27530982:27542745,27530986:27543196,27530989:27543503,27530993:27543742,27530996:27543939,27531000:27544148,27531004:27578293,27531009:27544503,27531013:27544649,27531018:27544835,27531022:27544951,27531026:27545118,27531031:27545210,27531036:27545498,27531040:27545537,27531044:27545646,27531055:27545922,27531061:27546413,27531062:27545881,27531068:27546534,27531070:27580691,27531076:27546698,27531077:2754597', 'assoc_mat': '27419512:metal:4230:27427407,27419517:metal:4230:27425907,27419520:metal:4230:27426201,27419528:metal:4230:27425383,27419532:metal:4230:27424851,27419536:metal:4230:27425192,27419540:metal:4230:27424419,27419542:metal:4230:27423962,27419547:metal:4230:27423178,27419555:metal:4230:27422792,27419559:metal:4230:27422021,27419566:metal:4230:27420841,27419574:metal:4230:27420384,27419603:metal:4230:27419896,27421653:metal:4230:27422493,27424392:metal:4230:27424784,27457115:metal:4230:27457807,27458266:metal:4230:27460850,27458269:metal:4230:27461432,27458275:metal:4230:27460528,27458277:metal:4230:27459675,27458280:metal:4230:27459833,27458282:metal:4230:27460187,27458286:metal:4230:27459339,27458290:metal:4230:27459238,27458292:metal:4230:27458918,27458296:metal:4230:27458761,27458298:metal:4230:27458803,27458300:metal:4230:27458491,27458302:metal:4230:27458714,27458304:metal:4230:27458414,27458306:metal:4230:27458448,27458309:metal:4230:27458324,27462142:metal:4230:27462706,27530982:metal:4230:27542745,27530986:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2133115153938636, 'nb_photo': 499364, 'list_port_cont': '27418501,27419901,27420206,27420389,27420850,27421242,27421569,27422024,27422485,27422807,27423170,27423336,27423958,27424428,27424787,27424860,27425199,27425386,27425750,27425903,27426206,27426760,27427129,27427411,27457810,27458317,27458363,27458412,27458449,27458483,27458711,27458768,27458811,27458876,27458926,27459051,27459244,27459341,27459387,27459681,27459841,27460078,27460195,27460533,27460812,27460843,27461431,27462719,27542752,27543207,27543493,27543739,27543938,27544158,27544497,27544640,27544849,27544966,27545123,27545219,27545486,27545533,27545652,27545803,27545878,27545923,27545976,27546046,27546202,27546423,27546524,27546697,27546847,27546975,27547054,27547236,27547285,27547827,27547885,27548271,27548544,27548669,27549168,27549330,27550087,27550297,27551117,27551917,27552635,27557067,27557115,27557258,27557304,27557375,27557606,27557660,27558232,27558395,27558879,27559133,27559503,27560133,27560663,27560961,27561322,27561754,27562066,27562495,27563172,27563806,27564029,27568541,27569190,2756989', 'assoc_port': '27414921:27418501,27419508:27427129,27419512:27427411,27419515:27426760,27419517:27425903,27419520:27426206,27419524:27425750,27419528:27425386,27419532:27424860,27419536:27425199,27419540:27424428,27419542:27423958,27419547:27423170,27419550:27423336,27419555:27422807,27419559:27422024,27419562:27421569,27419566:27420850,27419571:27421242,27419574:27420389,27419603:27419901,27419605:27420206,27421653:27422485,27424392:27424787,27457115:27457810,27458266:27460843,27458269:27461431,27458272:27460812,27458275:27460533,27458277:27459681,27458280:27459841,27458282:27460195,27458284:27459387,27458286:27459341,27458288:27459051,27458290:27459244,27458292:27458926,27458294:27458876,27458296:27458768,27458298:27458811,27458300:27458483,27458302:27458711,27458304:27458412,27458306:27458449,27458308:27458363,27458309:27458317,27459575:27460078,27462142:27462719,27530982:27542752,27530986:27543207,27530989:27543493,27530993:27543739,27530996:27543938,27531000:27544158,27531004:27578279,27531009:27544497,27531013:2754464', 'assoc_mat': '27414921:papier:4230:27418501,27419508:papier:4230:27427129,27419512:papier:4230:27427411,27419515:papier:4230:27426760,27419517:papier:4230:27425903,27419520:papier:4230:27426206,27419524:papier:4230:27425750,27419528:papier:4230:27425386,27419532:papier:4230:27424860,27419536:papier:4230:27425199,27419540:papier:4230:27424428,27419542:papier:4230:27423958,27419547:papier:4230:27423170,27419550:papier:4230:27423336,27419555:papier:4230:27422807,27419559:papier:4230:27422024,27419562:papier:4230:27421569,27419566:papier:4230:27420850,27419571:papier:4230:27421242,27419574:papier:4230:27420389,27419603:papier:4230:27419901,27419605:papier:4230:27420206,27421653:papier:4230:27422485,27424392:papier:4230:27424787,27457115:papier:4230:27457810,27458266:papier:4230:27460843,27458269:papier:4230:27461431,27458272:papier:4230:27460812,27458275:papier:4230:27460533,27458277:papier:4230:27459681,27458280:papier:4230:27459841,27458282:papier:4230:27460195,27458284:papier:4230:27459387,27458286:papier:4230:27459341,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004383875942070988, 'nb_photo': 3277, 'list_port_cont': '27418500,27419892,27420382,27420846,27421236,27421575,27422030,27422498,27422797,27423177,27423340,27423963,27424432,27424785,27424859,27425198,27425381,27425746,27425898,27427135,27427400,27457806,27458328,27458369,27458419,27458462,27458492,27458712,27458774,27458814,27458881,27458924,27459057,27459246,27459381,27459690,27459835,27460077,27460526,27460796,27461438,27462718,27542750,27543202,27543495,27543748,27543942,27544151,27544510,27544962,27545126,27545217,27545497,27545538,27545656,27545808,27545885,27546192,27546421,27546536,27546973,27547044,27547234,27547287,27547816,27547880,27548264,27548539,27548671,27549159,27549328,27550082,27550295,27551118,27551919,27552624,27557069,27557121,27557262,27557313,27557384,27557608,27557661,27558231,27558387,27558880,27559139,27559495,27560131,27560665,27560960,27561313,27561764,27562064,27562498,27563163,27563809,27564034,27568536,27569198,27569912,27570419,27570832,27570974,27571118,27571206,27571269,27571505,27571545,27571706,27571739,27571796,27571826,2757190', 'assoc_port': '27414921:27418500,27419508:27427135,27419512:27427400,27419517:27425898,27419524:27425746,27419528:27425381,27419532:27424859,27419536:27425198,27419540:27424432,27419542:27423963,27419547:27423177,27419550:27423340,27419555:27422797,27419559:27422030,27419562:27421575,27419566:27420846,27419571:27421236,27419574:27420382,27419603:27419892,27421653:27422498,27424392:27424785,27457115:27457806,27458269:27461438,27458272:27460796,27458275:27460526,27458277:27459690,27458280:27459835,27458284:27459381,27458288:27459057,27458290:27459246,27458292:27458924,27458294:27458881,27458296:27458774,27458298:27458814,27458300:27458492,27458302:27458712,27458304:27458419,27458306:27458462,27458308:27458369,27458309:27458328,27459575:27460077,27462142:27462718,27530982:27542750,27530986:27543202,27530989:27543495,27530993:27543748,27530996:27543942,27531000:27544151,27531004:27578285,27531009:27544510,27531022:27544962,27531026:27545126,27531031:27545217,27531036:27545497,27531040:27545538,27531044:27545656,27531049:2754580', 'assoc_mat': '27414921:pehd:4230:27418500,27419508:pehd:4230:27427135,27419512:pehd:4230:27427400,27419517:pehd:4230:27425898,27419524:pehd:4230:27425746,27419528:pehd:4230:27425381,27419532:pehd:4230:27424859,27419536:pehd:4230:27425198,27419540:pehd:4230:27424432,27419542:pehd:4230:27423963,27419547:pehd:4230:27423177,27419550:pehd:4230:27423340,27419555:pehd:4230:27422797,27419559:pehd:4230:27422030,27419562:pehd:4230:27421575,27419566:pehd:4230:27420846,27419571:pehd:4230:27421236,27419574:pehd:4230:27420382,27419603:pehd:4230:27419892,27421653:pehd:4230:27422498,27424392:pehd:4230:27424785,27457115:pehd:4230:27457806,27458269:pehd:4230:27461438,27458272:pehd:4230:27460796,27458275:pehd:4230:27460526,27458277:pehd:4230:27459690,27458280:pehd:4230:27459835,27458284:pehd:4230:27459381,27458288:pehd:4230:27459057,27458290:pehd:4230:27459246,27458292:pehd:4230:27458924,27458294:pehd:4230:27458881,27458296:pehd:4230:27458774,27458298:pehd:4230:27458814,27458300:pehd:4230:27458492,27458302:pehd:4230:27458712,27458304:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01093408779020654, 'nb_photo': 21967, 'list_port_cont': '27418497,27419903,27420196,27420381,27420857,27421244,27421574,27422033,27422494,27422800,27423180,27423345,27423961,27424435,27424793,27424853,27425190,27425389,27425735,27425900,27426199,27426756,27427139,27427405,27457815,27458326,27458356,27458424,27458463,27458498,27458709,27458776,27458810,27458868,27458916,27459054,27459252,27459349,27459380,27459692,27459842,27460072,27460199,27460535,27460805,27460855,27461437,27462711,27542748,27543211,27543496,27543744,27543944,27544162,27544508,27544644,27544851,27544968,27545124,27545215,27545491,27545539,27545650,27545800,27545887,27545910,27545969,27546051,27546203,27546416,27546531,27546707,27546848,27546974,27547046,27547232,27547289,27547822,27547881,27548262,27548535,27548670,27549167,27549336,27550088,27550290,27551113,27551916,27552630,27557068,27557120,27557249,27557307,27557379,27557605,27557659,27558227,27558391,27558869,27559143,27559499,27560132,27560659,27560950,27561325,27561765,27562065,27562491,27563169,27563810,27564038,27568538,27569195,2756990', 'assoc_port': '27414921:27418497,27419508:27427139,27419512:27427405,27419515:27426756,27419517:27425900,27419520:27426199,27419524:27425735,27419528:27425389,27419532:27424853,27419536:27425190,27419540:27424435,27419542:27423961,27419547:27423180,27419550:27423345,27419555:27422800,27419559:27422033,27419562:27421574,27419566:27420857,27419571:27421244,27419574:27420381,27419603:27419903,27419605:27420196,27421653:27422494,27424392:27424793,27457115:27457815,27458266:27460855,27458269:27461437,27458272:27460805,27458275:27460535,27458277:27459692,27458280:27459842,27458282:27460199,27458284:27459380,27458286:27459349,27458288:27459054,27458290:27459252,27458292:27458916,27458294:27458868,27458296:27458776,27458298:27458810,27458300:27458498,27458302:27458709,27458304:27458424,27458306:27458463,27458308:27458356,27458309:27458326,27459575:27460072,27462142:27462711,27530982:27542748,27530986:27543211,27530989:27543496,27530993:27543744,27530996:27543944,27531000:27544162,27531004:27578287,27531009:27544508,27531013:2754464', 'assoc_mat': '27414921:pet_clair:4230:27418497,27419508:pet_clair:4230:27427139,27419512:pet_clair:4230:27427405,27419515:pet_clair:4230:27426756,27419517:pet_clair:4230:27425900,27419520:pet_clair:4230:27426199,27419524:pet_clair:4230:27425735,27419528:pet_clair:4230:27425389,27419532:pet_clair:4230:27424853,27419536:pet_clair:4230:27425190,27419540:pet_clair:4230:27424435,27419542:pet_clair:4230:27423961,27419547:pet_clair:4230:27423180,27419550:pet_clair:4230:27423345,27419555:pet_clair:4230:27422800,27419559:pet_clair:4230:27422033,27419562:pet_clair:4230:27421574,27419566:pet_clair:4230:27420857,27419571:pet_clair:4230:27421244,27419574:pet_clair:4230:27420381,27419603:pet_clair:4230:27419903,27419605:pet_clair:4230:27420196,27421653:pet_clair:4230:27422494,27424392:pet_clair:4230:27424793,27457115:pet_clair:4230:27457815,27458266:pet_clair:4230:27460855,27458269:pet_clair:4230:27461437,27458272:pet_clair:4230:27460805,27458275:pet_clair:4230:27460535,27458277:pet_clair:4230:27459692,27458280:pet_clair:4230:27459842,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002487042744103774, 'nb_photo': 1235, 'list_port_cont': '27418502,27419904,27420205,27420854,27421245,27421578,27422032,27422489,27422805,27423185,27423338,27424423,27424790,27425390,27425747,27425909,27426751,27457809,27458325,27458359,27458408,27458461,27458490,27458710,27458775,27458807,27458919,27459249,27459353,27459385,27459685,27459845,27460076,27460200,27460527,27460811,27460845,27461427,27462715,27542754,27543498,27543747,27544163,27544504,27545113,27545493,27545658,27545799,27546041,27546199,27546415,27546530,27546849,27546969,27547240,27547286,27547823,27547875,27548270,27548543,27548658,27549163,27550089,27551911,27552632,27557072,27557119,27557252,27557315,27557383,27557615,27557663,27558230,27558878,27559134,27559498,27560128,27560660,27560958,27561323,27561766,27562060,27562501,27563164,27563804,27568542,27569909,27570430,27570840,27570979,27571110,27571196,27571271,27571372,27571498,27571540,27571708,27571743,27571790,27571831,27571902,27576233,27577229,27578292,27579104,27580703,27582474,27584225,27584335,27584793,27585294,27587228,27587507,2758798', 'assoc_port': '27414921:27418502,27419515:27426751,27419517:27425909,27419524:27425747,27419528:27425390,27419540:27424423,27419547:27423185,27419550:27423338,27419555:27422805,27419559:27422032,27419562:27421578,27419566:27420854,27419571:27421245,27419603:27419904,27419605:27420205,27421653:27422489,27424392:27424790,27457115:27457809,27458266:27460845,27458269:27461427,27458272:27460811,27458275:27460527,27458277:27459685,27458280:27459845,27458282:27460200,27458284:27459385,27458286:27459353,27458290:27459249,27458292:27458919,27458296:27458775,27458298:27458807,27458300:27458490,27458302:27458710,27458304:27458408,27458306:27458461,27458308:27458359,27458309:27458325,27459575:27460076,27462142:27462715,27530982:27542754,27530989:27543498,27530993:27543747,27531000:27544163,27531004:27578292,27531009:27544504,27531026:27545113,27531036:27545493,27531044:27545658,27531049:27545799,27531061:27546415,27531068:27546530,27531070:27580703,27531084:27546849,27531085:27546041,27531093:27590279,27531100:27546969,27531101:2754619', 'assoc_mat': '27414921:pet_fonce:4230:27418502,27419515:pet_fonce:4230:27426751,27419517:pet_fonce:4230:27425909,27419524:pet_fonce:4230:27425747,27419528:pet_fonce:4230:27425390,27419540:pet_fonce:4230:27424423,27419547:pet_fonce:4230:27423185,27419550:pet_fonce:4230:27423338,27419555:pet_fonce:4230:27422805,27419559:pet_fonce:4230:27422032,27419562:pet_fonce:4230:27421578,27419566:pet_fonce:4230:27420854,27419571:pet_fonce:4230:27421245,27419603:pet_fonce:4230:27419904,27419605:pet_fonce:4230:27420205,27421653:pet_fonce:4230:27422489,27424392:pet_fonce:4230:27424790,27457115:pet_fonce:4230:27457809,27458266:pet_fonce:4230:27460845,27458269:pet_fonce:4230:27461427,27458272:pet_fonce:4230:27460811,27458275:pet_fonce:4230:27460527,27458277:pet_fonce:4230:27459685,27458280:pet_fonce:4230:27459845,27458282:pet_fonce:4230:27460200,27458284:pet_fonce:4230:27459385,27458286:pet_fonce:4230:27459353,27458290:pet_fonce:4230:27459249,27458292:pet_fonce:4230:27458919,27458296:pet_fonce:4230:27458775,27458298:pet_fonce:4230:27458807,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(2384951,2392603,2406369,2406361,2406355,2408595,2412705,2419639,2428101,2436193,2442075,2442775,2450013,2457660,2465475,2468737,2473651,2476955,2484319,2484207,2484295,2484215,2484287,2484273,2484259,2484223,2484255,2493487,2493513,2496809)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124973, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418494,27419905,27420198,27420393,27420847,27421239,27421568,27422031,27422488,27422808,27423183,27423328,27423953,27424427,27424794,27424843,27425195,27425375,27425737,27425902,27426197,27426750,27427132,27427409,27457808,27458313,27458365,27458411,27458460,27458493,27458700,27458766,27458812,27458866,27458911,27459062,27459245,27459344,27459384,27459684,27459844,27460073,27460185,27460531,27460807,27460847,27461422,27462703,27542757,27543209,27543492,27543734,27543948,27544156,27544511,27544645,27544852,27544954,27545109,27545218,27545494,27545542,27545648,27545798,27545874,27545918,27545961,27546049,27546189,27546408,27546527,27546708,27546845,27546970,27547053,27547237,27547288,27547826,27547887,27548273,27548547,27548667,27549169,27549335,27550086,27550296,27551104,27551920,27552633,27557059,27557118,27557246,27557305,27557386,27557609,27557647,27558217,27558384,27558881,27559132,27559501,27560134,27560654,27560955,27561316,27561750,27562056,27562500,27563173,27563805,27564030,27568543,27569184,2756989 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124974, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418492,27419899,27420199,27420392,27420858,27421246,27421572,27422027,27422499,27422795,27423186,27423341,27423960,27424422,27424789,27424857,27425201,27425391,27425749,27425905,27426204,27426762,27427131,27427398,27457814,27458321,27458362,27458415,27458450,27458497,27458716,27458773,27458804,27458874,27458921,27459055,27459247,27459351,27459386,27459687,27459846,27460066,27460191,27460534,27460809,27460848,27461434,27462717,27542749,27543210,27543504,27543737,27543940,27544161,27544501,27544643,27544850,27544961,27545125,27545206,27545496,27545534,27545649,27545806,27545877,27545921,27545974,27546053,27546198,27546424,27546537,27546705,27546851,27546972,27547052,27547239,27547281,27547820,27547883,27548267,27548541,27548663,27549171,27549334,27550077,27550286,27551120,27551907,27552627,27557071,27557112,27557259,27557314,27557381,27557610,27557662,27558224,27558394,27558876,27559131,27559500,27560127,27560664,27560963,27561324,27561760,27562061,27562493,27563171,27563807,27564037,27568535,27569189,2756990 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124975, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419896,27420384,27420841,27422021,27422493,27422792,27423178,27423962,27424419,27424784,27424851,27425192,27425383,27425907,27426201,27427407,27457807,27458324,27458414,27458448,27458491,27458714,27458761,27458803,27458918,27459238,27459339,27459675,27459833,27460187,27460528,27460850,27461432,27462706,27542745,27543196,27543503,27543742,27543939,27544148,27544503,27544649,27544835,27544951,27545118,27545210,27545498,27545537,27545646,27545881,27545922,27545973,27546413,27546534,27546698,27546844,27546965,27547050,27547283,27548257,27548532,27548656,27549156,27549327,27550083,27550293,27551108,27551921,27552634,27557064,27557113,27557298,27557370,27557602,27558218,27558389,27558875,27559130,27559497,27560126,27560655,27560953,27561309,27561752,27562051,27562492,27563797,27564036,27568532,27569187,27569910,27570421,27570831,27570975,27571113,27571201,27571260,27571407,27571494,27571695,27571733,27571779,27571820,27571894,27571951,27576234,27577225,27578293,27579092,27579114,27580691,27581413,27581641,2758246 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124976, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418501,27419901,27420206,27420389,27420850,27421242,27421569,27422024,27422485,27422807,27423170,27423336,27423958,27424428,27424787,27424860,27425199,27425386,27425750,27425903,27426206,27426760,27427129,27427411,27457810,27458317,27458363,27458412,27458449,27458483,27458711,27458768,27458811,27458876,27458926,27459051,27459244,27459341,27459387,27459681,27459841,27460078,27460195,27460533,27460812,27460843,27461431,27462719,27542752,27543207,27543493,27543739,27543938,27544158,27544497,27544640,27544849,27544966,27545123,27545219,27545486,27545533,27545652,27545803,27545878,27545923,27545976,27546046,27546202,27546423,27546524,27546697,27546847,27546975,27547054,27547236,27547285,27547827,27547885,27548271,27548544,27548669,27549168,27549330,27550087,27550297,27551117,27551917,27552635,27557067,27557115,27557258,27557304,27557375,27557606,27557660,27558232,27558395,27558879,27559133,27559503,27560133,27560663,27560961,27561322,27561754,27562066,27562495,27563172,27563806,27564029,27568541,27569190,2756989 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124978, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418500,27419892,27420382,27420846,27421236,27421575,27422030,27422498,27422797,27423177,27423340,27423963,27424432,27424785,27424859,27425198,27425381,27425746,27425898,27427135,27427400,27457806,27458328,27458369,27458419,27458462,27458492,27458712,27458774,27458814,27458881,27458924,27459057,27459246,27459381,27459690,27459835,27460077,27460526,27460796,27461438,27462718,27542750,27543202,27543495,27543748,27543942,27544151,27544510,27544962,27545126,27545217,27545497,27545538,27545656,27545808,27545885,27546192,27546421,27546536,27546973,27547044,27547234,27547287,27547816,27547880,27548264,27548539,27548671,27549159,27549328,27550082,27550295,27551118,27551919,27552624,27557069,27557121,27557262,27557313,27557384,27557608,27557661,27558231,27558387,27558880,27559139,27559495,27560131,27560665,27560960,27561313,27561764,27562064,27562498,27563163,27563809,27564034,27568536,27569198,27569912,27570419,27570832,27570974,27571118,27571206,27571269,27571505,27571545,27571706,27571739,27571796,27571826,2757190 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124979, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418497,27419903,27420196,27420381,27420857,27421244,27421574,27422033,27422494,27422800,27423180,27423345,27423961,27424435,27424793,27424853,27425190,27425389,27425735,27425900,27426199,27426756,27427139,27427405,27457815,27458326,27458356,27458424,27458463,27458498,27458709,27458776,27458810,27458868,27458916,27459054,27459252,27459349,27459380,27459692,27459842,27460072,27460199,27460535,27460805,27460855,27461437,27462711,27542748,27543211,27543496,27543744,27543944,27544162,27544508,27544644,27544851,27544968,27545124,27545215,27545491,27545539,27545650,27545800,27545887,27545910,27545969,27546051,27546203,27546416,27546531,27546707,27546848,27546974,27547046,27547232,27547289,27547822,27547881,27548262,27548535,27548670,27549167,27549336,27550088,27550290,27551113,27551916,27552630,27557068,27557120,27557249,27557307,27557379,27557605,27557659,27558227,27558391,27558869,27559143,27559499,27560132,27560659,27560950,27561325,27561765,27562065,27562491,27563169,27563810,27564038,27568538,27569195,2756990 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124980, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418502,27419904,27420205,27420854,27421245,27421578,27422032,27422489,27422805,27423185,27423338,27424423,27424790,27425390,27425747,27425909,27426751,27457809,27458325,27458359,27458408,27458461,27458490,27458710,27458775,27458807,27458919,27459249,27459353,27459385,27459685,27459845,27460076,27460200,27460527,27460811,27460845,27461427,27462715,27542754,27543498,27543747,27544163,27544504,27545113,27545493,27545658,27545799,27546041,27546199,27546415,27546530,27546849,27546969,27547240,27547286,27547823,27547875,27548270,27548543,27548658,27549163,27550089,27551911,27552632,27557072,27557119,27557252,27557315,27557383,27557615,27557663,27558230,27558878,27559134,27559498,27560128,27560660,27560958,27561323,27561766,27562060,27562501,27563164,27563804,27568542,27569909,27570430,27570840,27570979,27571110,27571196,27571271,27571372,27571498,27571540,27571708,27571743,27571790,27571831,27571902,27576233,27577229,27578292,27579104,27580703,27582474,27584225,27584335,27584793,27585294,27587228,27587507,2758798 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124973,30124974,30124975,30124976,30124978,30124979,30124980?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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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 : 202 month : 10 mtr_id : dashboard_places : SCCU_cam6 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_cam6' 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 = 202 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 = 202 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 = 202 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_cam6" 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 (2384951,2392603,2406369,2406361,2406355,2408595,2412705,2419639,2428101,2436193,2442075,2442775,2450013,2457660,2465475,2468737,2473651,2476955,2484319,2484207,2484295,2484215,2484287,2484273,2484259,2484223,2484255,2493487,2493513,2496809) 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.014850347748988964, 'nb_photo': 20990, 'list_port_cont': '27418494,27419905,27420198,27420393,27420847,27421239,27421568,27422031,27422488,27422808,27423183,27423328,27423953,27424427,27424794,27424843,27425195,27425375,27425737,27425902,27426197,27426750,27427132,27427409,27457808,27458313,27458365,27458411,27458460,27458493,27458700,27458766,27458812,27458866,27458911,27459062,27459245,27459344,27459384,27459684,27459844,27460073,27460185,27460531,27460807,27460847,27461422,27462703,27542757,27543209,27543492,27543734,27543948,27544156,27544511,27544645,27544852,27544954,27545109,27545218,27545494,27545542,27545648,27545798,27545874,27545918,27545961,27546049,27546189,27546408,27546527,27546708,27546845,27546970,27547053,27547237,27547288,27547826,27547887,27548273,27548547,27548667,27549169,27549335,27550086,27550296,27551104,27551920,27552633,27557059,27557118,27557246,27557305,27557386,27557609,27557647,27558217,27558384,27558881,27559132,27559501,27560134,27560654,27560955,27561316,27561750,27562056,27562500,27563173,27563805,27564030,27568543,27569184,2756989', 'assoc_port': '27414921:27418494,27419508:27427132,27419512:27427409,27419515:27426750,27419517:27425902,27419520:27426197,27419524:27425737,27419528:27425375,27419532:27424843,27419536:27425195,27419540:27424427,27419542:27423953,27419547:27423183,27419550:27423328,27419555:27422808,27419559:27422031,27419562:27421568,27419566:27420847,27419571:27421239,27419574:27420393,27419603:27419905,27419605:27420198,27421653:27422488,27424392:27424794,27457115:27457808,27458266:27460847,27458269:27461422,27458272:27460807,27458275:27460531,27458277:27459684,27458280:27459844,27458282:27460185,27458284:27459384,27458286:27459344,27458288:27459062,27458290:27459245,27458292:27458911,27458294:27458866,27458296:27458766,27458298:27458812,27458300:27458493,27458302:27458700,27458304:27458411,27458306:27458460,27458308:27458365,27458309:27458313,27459575:27460073,27462142:27462703,27530982:27542757,27530986:27543209,27530989:27543492,27530993:27543734,27530996:27543948,27531000:27544156,27531004:27578289,27531009:27544511,27531013:2754464', 'assoc_mat': '27414921:autre:4230:27418494,27419508:autre:4230:27427132,27419512:autre:4230:27427409,27419515:autre:4230:27426750,27419517:autre:4230:27425902,27419520:autre:4230:27426197,27419524:autre:4230:27425737,27419528:autre:4230:27425375,27419532:autre:4230:27424843,27419536:autre:4230:27425195,27419540:autre:4230:27424427,27419542:autre:4230:27423953,27419547:autre:4230:27423183,27419550:autre:4230:27423328,27419555:autre:4230:27422808,27419559:autre:4230:27422031,27419562:autre:4230:27421568,27419566:autre:4230:27420847,27419571:autre:4230:27421239,27419574:autre:4230:27420393,27419603:autre:4230:27419905,27419605:autre:4230:27420198,27421653:autre:4230:27422488,27424392:autre:4230:27424794,27457115:autre:4230:27457808,27458266:autre:4230:27460847,27458269:autre:4230:27461422,27458272:autre:4230:27460807,27458275:autre:4230:27460531,27458277:autre:4230:27459684,27458280:autre:4230:27459844,27458282:autre:4230:27460185,27458284:autre:4230:27459384,27458286:autre:4230:27459344,27458288:autre:4230:27459062,27458290:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.055245668813900764, 'nb_photo': 104677, 'list_port_cont': '27418492,27419899,27420199,27420392,27420858,27421246,27421572,27422027,27422499,27422795,27423186,27423341,27423960,27424422,27424789,27424857,27425201,27425391,27425749,27425905,27426204,27426762,27427131,27427398,27457814,27458321,27458362,27458415,27458450,27458497,27458716,27458773,27458804,27458874,27458921,27459055,27459247,27459351,27459386,27459687,27459846,27460066,27460191,27460534,27460809,27460848,27461434,27462717,27542749,27543210,27543504,27543737,27543940,27544161,27544501,27544643,27544850,27544961,27545125,27545206,27545496,27545534,27545649,27545806,27545877,27545921,27545974,27546053,27546198,27546424,27546537,27546705,27546851,27546972,27547052,27547239,27547281,27547820,27547883,27548267,27548541,27548663,27549171,27549334,27550077,27550286,27551120,27551907,27552627,27557071,27557112,27557259,27557314,27557381,27557610,27557662,27558224,27558394,27558876,27559131,27559500,27560127,27560664,27560963,27561324,27561760,27562061,27562493,27563171,27563807,27564037,27568535,27569189,2756990', 'assoc_port': '27414921:27418492,27419508:27427131,27419512:27427398,27419515:27426762,27419517:27425905,27419520:27426204,27419524:27425749,27419528:27425391,27419532:27424857,27419536:27425201,27419540:27424422,27419542:27423960,27419547:27423186,27419550:27423341,27419555:27422795,27419559:27422027,27419562:27421572,27419566:27420858,27419571:27421246,27419574:27420392,27419603:27419899,27419605:27420199,27421653:27422499,27424392:27424789,27457115:27457814,27458266:27460848,27458269:27461434,27458272:27460809,27458275:27460534,27458277:27459687,27458280:27459846,27458282:27460191,27458284:27459386,27458286:27459351,27458288:27459055,27458290:27459247,27458292:27458921,27458294:27458874,27458296:27458773,27458298:27458804,27458300:27458497,27458302:27458716,27458304:27458415,27458306:27458450,27458308:27458362,27458309:27458321,27459575:27460066,27462142:27462717,27530982:27542749,27530986:27543210,27530989:27543504,27530993:27543737,27530996:27543940,27531000:27544161,27531004:27578291,27531009:27544501,27531013:2754464', 'assoc_mat': '27414921:carton:4230:27418492,27419508:carton:4230:27427131,27419512:carton:4230:27427398,27419515:carton:4230:27426762,27419517:carton:4230:27425905,27419520:carton:4230:27426204,27419524:carton:4230:27425749,27419528:carton:4230:27425391,27419532:carton:4230:27424857,27419536:carton:4230:27425201,27419540:carton:4230:27424422,27419542:carton:4230:27423960,27419547:carton:4230:27423186,27419550:carton:4230:27423341,27419555:carton:4230:27422795,27419559:carton:4230:27422027,27419562:carton:4230:27421572,27419566:carton:4230:27420858,27419571:carton:4230:27421246,27419574:carton:4230:27420392,27419603:carton:4230:27419899,27419605:carton:4230:27420199,27421653:carton:4230:27422499,27424392:carton:4230:27424789,27457115:carton:4230:27457814,27458266:carton:4230:27460848,27458269:carton:4230:27461434,27458272:carton:4230:27460809,27458275:carton:4230:27460534,27458277:carton:4230:27459687,27458280:carton:4230:27459846,27458282:carton:4230:27460191,27458284:carton:4230:27459386,27458286:carton:4230:27459351,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012118017193548133, 'nb_photo': 1897, 'list_port_cont': '27419896,27420384,27420841,27422021,27422493,27422792,27423178,27423962,27424419,27424784,27424851,27425192,27425383,27425907,27426201,27427407,27457807,27458324,27458414,27458448,27458491,27458714,27458761,27458803,27458918,27459238,27459339,27459675,27459833,27460187,27460528,27460850,27461432,27462706,27542745,27543196,27543503,27543742,27543939,27544148,27544503,27544649,27544835,27544951,27545118,27545210,27545498,27545537,27545646,27545881,27545922,27545973,27546413,27546534,27546698,27546844,27546965,27547050,27547283,27548257,27548532,27548656,27549156,27549327,27550083,27550293,27551108,27551921,27552634,27557064,27557113,27557298,27557370,27557602,27558218,27558389,27558875,27559130,27559497,27560126,27560655,27560953,27561309,27561752,27562051,27562492,27563797,27564036,27568532,27569187,27569910,27570421,27570831,27570975,27571113,27571201,27571260,27571407,27571494,27571695,27571733,27571779,27571820,27571894,27571951,27576234,27577225,27578293,27579092,27579114,27580691,27581413,27581641,2758246', 'assoc_port': '27419512:27427407,27419517:27425907,27419520:27426201,27419528:27425383,27419532:27424851,27419536:27425192,27419540:27424419,27419542:27423962,27419547:27423178,27419555:27422792,27419559:27422021,27419566:27420841,27419574:27420384,27419603:27419896,27421653:27422493,27424392:27424784,27457115:27457807,27458266:27460850,27458269:27461432,27458275:27460528,27458277:27459675,27458280:27459833,27458282:27460187,27458286:27459339,27458290:27459238,27458292:27458918,27458296:27458761,27458298:27458803,27458300:27458491,27458302:27458714,27458304:27458414,27458306:27458448,27458309:27458324,27462142:27462706,27530982:27542745,27530986:27543196,27530989:27543503,27530993:27543742,27530996:27543939,27531000:27544148,27531004:27578293,27531009:27544503,27531013:27544649,27531018:27544835,27531022:27544951,27531026:27545118,27531031:27545210,27531036:27545498,27531040:27545537,27531044:27545646,27531055:27545922,27531061:27546413,27531062:27545881,27531068:27546534,27531070:27580691,27531076:27546698,27531077:2754597', 'assoc_mat': '27419512:metal:4230:27427407,27419517:metal:4230:27425907,27419520:metal:4230:27426201,27419528:metal:4230:27425383,27419532:metal:4230:27424851,27419536:metal:4230:27425192,27419540:metal:4230:27424419,27419542:metal:4230:27423962,27419547:metal:4230:27423178,27419555:metal:4230:27422792,27419559:metal:4230:27422021,27419566:metal:4230:27420841,27419574:metal:4230:27420384,27419603:metal:4230:27419896,27421653:metal:4230:27422493,27424392:metal:4230:27424784,27457115:metal:4230:27457807,27458266:metal:4230:27460850,27458269:metal:4230:27461432,27458275:metal:4230:27460528,27458277:metal:4230:27459675,27458280:metal:4230:27459833,27458282:metal:4230:27460187,27458286:metal:4230:27459339,27458290:metal:4230:27459238,27458292:metal:4230:27458918,27458296:metal:4230:27458761,27458298:metal:4230:27458803,27458300:metal:4230:27458491,27458302:metal:4230:27458714,27458304:metal:4230:27458414,27458306:metal:4230:27458448,27458309:metal:4230:27458324,27462142:metal:4230:27462706,27530982:metal:4230:27542745,27530986:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2133115153938636, 'nb_photo': 499364, 'list_port_cont': '27418501,27419901,27420206,27420389,27420850,27421242,27421569,27422024,27422485,27422807,27423170,27423336,27423958,27424428,27424787,27424860,27425199,27425386,27425750,27425903,27426206,27426760,27427129,27427411,27457810,27458317,27458363,27458412,27458449,27458483,27458711,27458768,27458811,27458876,27458926,27459051,27459244,27459341,27459387,27459681,27459841,27460078,27460195,27460533,27460812,27460843,27461431,27462719,27542752,27543207,27543493,27543739,27543938,27544158,27544497,27544640,27544849,27544966,27545123,27545219,27545486,27545533,27545652,27545803,27545878,27545923,27545976,27546046,27546202,27546423,27546524,27546697,27546847,27546975,27547054,27547236,27547285,27547827,27547885,27548271,27548544,27548669,27549168,27549330,27550087,27550297,27551117,27551917,27552635,27557067,27557115,27557258,27557304,27557375,27557606,27557660,27558232,27558395,27558879,27559133,27559503,27560133,27560663,27560961,27561322,27561754,27562066,27562495,27563172,27563806,27564029,27568541,27569190,2756989', 'assoc_port': '27414921:27418501,27419508:27427129,27419512:27427411,27419515:27426760,27419517:27425903,27419520:27426206,27419524:27425750,27419528:27425386,27419532:27424860,27419536:27425199,27419540:27424428,27419542:27423958,27419547:27423170,27419550:27423336,27419555:27422807,27419559:27422024,27419562:27421569,27419566:27420850,27419571:27421242,27419574:27420389,27419603:27419901,27419605:27420206,27421653:27422485,27424392:27424787,27457115:27457810,27458266:27460843,27458269:27461431,27458272:27460812,27458275:27460533,27458277:27459681,27458280:27459841,27458282:27460195,27458284:27459387,27458286:27459341,27458288:27459051,27458290:27459244,27458292:27458926,27458294:27458876,27458296:27458768,27458298:27458811,27458300:27458483,27458302:27458711,27458304:27458412,27458306:27458449,27458308:27458363,27458309:27458317,27459575:27460078,27462142:27462719,27530982:27542752,27530986:27543207,27530989:27543493,27530993:27543739,27530996:27543938,27531000:27544158,27531004:27578279,27531009:27544497,27531013:2754464', 'assoc_mat': '27414921:papier:4230:27418501,27419508:papier:4230:27427129,27419512:papier:4230:27427411,27419515:papier:4230:27426760,27419517:papier:4230:27425903,27419520:papier:4230:27426206,27419524:papier:4230:27425750,27419528:papier:4230:27425386,27419532:papier:4230:27424860,27419536:papier:4230:27425199,27419540:papier:4230:27424428,27419542:papier:4230:27423958,27419547:papier:4230:27423170,27419550:papier:4230:27423336,27419555:papier:4230:27422807,27419559:papier:4230:27422024,27419562:papier:4230:27421569,27419566:papier:4230:27420850,27419571:papier:4230:27421242,27419574:papier:4230:27420389,27419603:papier:4230:27419901,27419605:papier:4230:27420206,27421653:papier:4230:27422485,27424392:papier:4230:27424787,27457115:papier:4230:27457810,27458266:papier:4230:27460843,27458269:papier:4230:27461431,27458272:papier:4230:27460812,27458275:papier:4230:27460533,27458277:papier:4230:27459681,27458280:papier:4230:27459841,27458282:papier:4230:27460195,27458284:papier:4230:27459387,27458286:papier:4230:27459341,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004383875942070988, 'nb_photo': 3277, 'list_port_cont': '27418500,27419892,27420382,27420846,27421236,27421575,27422030,27422498,27422797,27423177,27423340,27423963,27424432,27424785,27424859,27425198,27425381,27425746,27425898,27427135,27427400,27457806,27458328,27458369,27458419,27458462,27458492,27458712,27458774,27458814,27458881,27458924,27459057,27459246,27459381,27459690,27459835,27460077,27460526,27460796,27461438,27462718,27542750,27543202,27543495,27543748,27543942,27544151,27544510,27544962,27545126,27545217,27545497,27545538,27545656,27545808,27545885,27546192,27546421,27546536,27546973,27547044,27547234,27547287,27547816,27547880,27548264,27548539,27548671,27549159,27549328,27550082,27550295,27551118,27551919,27552624,27557069,27557121,27557262,27557313,27557384,27557608,27557661,27558231,27558387,27558880,27559139,27559495,27560131,27560665,27560960,27561313,27561764,27562064,27562498,27563163,27563809,27564034,27568536,27569198,27569912,27570419,27570832,27570974,27571118,27571206,27571269,27571505,27571545,27571706,27571739,27571796,27571826,2757190', 'assoc_port': '27414921:27418500,27419508:27427135,27419512:27427400,27419517:27425898,27419524:27425746,27419528:27425381,27419532:27424859,27419536:27425198,27419540:27424432,27419542:27423963,27419547:27423177,27419550:27423340,27419555:27422797,27419559:27422030,27419562:27421575,27419566:27420846,27419571:27421236,27419574:27420382,27419603:27419892,27421653:27422498,27424392:27424785,27457115:27457806,27458269:27461438,27458272:27460796,27458275:27460526,27458277:27459690,27458280:27459835,27458284:27459381,27458288:27459057,27458290:27459246,27458292:27458924,27458294:27458881,27458296:27458774,27458298:27458814,27458300:27458492,27458302:27458712,27458304:27458419,27458306:27458462,27458308:27458369,27458309:27458328,27459575:27460077,27462142:27462718,27530982:27542750,27530986:27543202,27530989:27543495,27530993:27543748,27530996:27543942,27531000:27544151,27531004:27578285,27531009:27544510,27531022:27544962,27531026:27545126,27531031:27545217,27531036:27545497,27531040:27545538,27531044:27545656,27531049:2754580', 'assoc_mat': '27414921:pehd:4230:27418500,27419508:pehd:4230:27427135,27419512:pehd:4230:27427400,27419517:pehd:4230:27425898,27419524:pehd:4230:27425746,27419528:pehd:4230:27425381,27419532:pehd:4230:27424859,27419536:pehd:4230:27425198,27419540:pehd:4230:27424432,27419542:pehd:4230:27423963,27419547:pehd:4230:27423177,27419550:pehd:4230:27423340,27419555:pehd:4230:27422797,27419559:pehd:4230:27422030,27419562:pehd:4230:27421575,27419566:pehd:4230:27420846,27419571:pehd:4230:27421236,27419574:pehd:4230:27420382,27419603:pehd:4230:27419892,27421653:pehd:4230:27422498,27424392:pehd:4230:27424785,27457115:pehd:4230:27457806,27458269:pehd:4230:27461438,27458272:pehd:4230:27460796,27458275:pehd:4230:27460526,27458277:pehd:4230:27459690,27458280:pehd:4230:27459835,27458284:pehd:4230:27459381,27458288:pehd:4230:27459057,27458290:pehd:4230:27459246,27458292:pehd:4230:27458924,27458294:pehd:4230:27458881,27458296:pehd:4230:27458774,27458298:pehd:4230:27458814,27458300:pehd:4230:27458492,27458302:pehd:4230:27458712,27458304:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01093408779020654, 'nb_photo': 21967, 'list_port_cont': '27418497,27419903,27420196,27420381,27420857,27421244,27421574,27422033,27422494,27422800,27423180,27423345,27423961,27424435,27424793,27424853,27425190,27425389,27425735,27425900,27426199,27426756,27427139,27427405,27457815,27458326,27458356,27458424,27458463,27458498,27458709,27458776,27458810,27458868,27458916,27459054,27459252,27459349,27459380,27459692,27459842,27460072,27460199,27460535,27460805,27460855,27461437,27462711,27542748,27543211,27543496,27543744,27543944,27544162,27544508,27544644,27544851,27544968,27545124,27545215,27545491,27545539,27545650,27545800,27545887,27545910,27545969,27546051,27546203,27546416,27546531,27546707,27546848,27546974,27547046,27547232,27547289,27547822,27547881,27548262,27548535,27548670,27549167,27549336,27550088,27550290,27551113,27551916,27552630,27557068,27557120,27557249,27557307,27557379,27557605,27557659,27558227,27558391,27558869,27559143,27559499,27560132,27560659,27560950,27561325,27561765,27562065,27562491,27563169,27563810,27564038,27568538,27569195,2756990', 'assoc_port': '27414921:27418497,27419508:27427139,27419512:27427405,27419515:27426756,27419517:27425900,27419520:27426199,27419524:27425735,27419528:27425389,27419532:27424853,27419536:27425190,27419540:27424435,27419542:27423961,27419547:27423180,27419550:27423345,27419555:27422800,27419559:27422033,27419562:27421574,27419566:27420857,27419571:27421244,27419574:27420381,27419603:27419903,27419605:27420196,27421653:27422494,27424392:27424793,27457115:27457815,27458266:27460855,27458269:27461437,27458272:27460805,27458275:27460535,27458277:27459692,27458280:27459842,27458282:27460199,27458284:27459380,27458286:27459349,27458288:27459054,27458290:27459252,27458292:27458916,27458294:27458868,27458296:27458776,27458298:27458810,27458300:27458498,27458302:27458709,27458304:27458424,27458306:27458463,27458308:27458356,27458309:27458326,27459575:27460072,27462142:27462711,27530982:27542748,27530986:27543211,27530989:27543496,27530993:27543744,27530996:27543944,27531000:27544162,27531004:27578287,27531009:27544508,27531013:2754464', 'assoc_mat': '27414921:pet_clair:4230:27418497,27419508:pet_clair:4230:27427139,27419512:pet_clair:4230:27427405,27419515:pet_clair:4230:27426756,27419517:pet_clair:4230:27425900,27419520:pet_clair:4230:27426199,27419524:pet_clair:4230:27425735,27419528:pet_clair:4230:27425389,27419532:pet_clair:4230:27424853,27419536:pet_clair:4230:27425190,27419540:pet_clair:4230:27424435,27419542:pet_clair:4230:27423961,27419547:pet_clair:4230:27423180,27419550:pet_clair:4230:27423345,27419555:pet_clair:4230:27422800,27419559:pet_clair:4230:27422033,27419562:pet_clair:4230:27421574,27419566:pet_clair:4230:27420857,27419571:pet_clair:4230:27421244,27419574:pet_clair:4230:27420381,27419603:pet_clair:4230:27419903,27419605:pet_clair:4230:27420196,27421653:pet_clair:4230:27422494,27424392:pet_clair:4230:27424793,27457115:pet_clair:4230:27457815,27458266:pet_clair:4230:27460855,27458269:pet_clair:4230:27461437,27458272:pet_clair:4230:27460805,27458275:pet_clair:4230:27460535,27458277:pet_clair:4230:27459692,27458280:pet_clair:4230:27459842,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002487042744103774, 'nb_photo': 1235, 'list_port_cont': '27418502,27419904,27420205,27420854,27421245,27421578,27422032,27422489,27422805,27423185,27423338,27424423,27424790,27425390,27425747,27425909,27426751,27457809,27458325,27458359,27458408,27458461,27458490,27458710,27458775,27458807,27458919,27459249,27459353,27459385,27459685,27459845,27460076,27460200,27460527,27460811,27460845,27461427,27462715,27542754,27543498,27543747,27544163,27544504,27545113,27545493,27545658,27545799,27546041,27546199,27546415,27546530,27546849,27546969,27547240,27547286,27547823,27547875,27548270,27548543,27548658,27549163,27550089,27551911,27552632,27557072,27557119,27557252,27557315,27557383,27557615,27557663,27558230,27558878,27559134,27559498,27560128,27560660,27560958,27561323,27561766,27562060,27562501,27563164,27563804,27568542,27569909,27570430,27570840,27570979,27571110,27571196,27571271,27571372,27571498,27571540,27571708,27571743,27571790,27571831,27571902,27576233,27577229,27578292,27579104,27580703,27582474,27584225,27584335,27584793,27585294,27587228,27587507,2758798', 'assoc_port': '27414921:27418502,27419515:27426751,27419517:27425909,27419524:27425747,27419528:27425390,27419540:27424423,27419547:27423185,27419550:27423338,27419555:27422805,27419559:27422032,27419562:27421578,27419566:27420854,27419571:27421245,27419603:27419904,27419605:27420205,27421653:27422489,27424392:27424790,27457115:27457809,27458266:27460845,27458269:27461427,27458272:27460811,27458275:27460527,27458277:27459685,27458280:27459845,27458282:27460200,27458284:27459385,27458286:27459353,27458290:27459249,27458292:27458919,27458296:27458775,27458298:27458807,27458300:27458490,27458302:27458710,27458304:27458408,27458306:27458461,27458308:27458359,27458309:27458325,27459575:27460076,27462142:27462715,27530982:27542754,27530989:27543498,27530993:27543747,27531000:27544163,27531004:27578292,27531009:27544504,27531026:27545113,27531036:27545493,27531044:27545658,27531049:27545799,27531061:27546415,27531068:27546530,27531070:27580703,27531084:27546849,27531085:27546041,27531093:27590279,27531100:27546969,27531101:2754619', 'assoc_mat': '27414921:pet_fonce:4230:27418502,27419515:pet_fonce:4230:27426751,27419517:pet_fonce:4230:27425909,27419524:pet_fonce:4230:27425747,27419528:pet_fonce:4230:27425390,27419540:pet_fonce:4230:27424423,27419547:pet_fonce:4230:27423185,27419550:pet_fonce:4230:27423338,27419555:pet_fonce:4230:27422805,27419559:pet_fonce:4230:27422032,27419562:pet_fonce:4230:27421578,27419566:pet_fonce:4230:27420854,27419571:pet_fonce:4230:27421245,27419603:pet_fonce:4230:27419904,27419605:pet_fonce:4230:27420205,27421653:pet_fonce:4230:27422489,27424392:pet_fonce:4230:27424790,27457115:pet_fonce:4230:27457809,27458266:pet_fonce:4230:27460845,27458269:pet_fonce:4230:27461427,27458272:pet_fonce:4230:27460811,27458275:pet_fonce:4230:27460527,27458277:pet_fonce:4230:27459685,27458280:pet_fonce:4230:27459845,27458282:pet_fonce:4230:27460200,27458284:pet_fonce:4230:27459385,27458286:pet_fonce:4230:27459353,27458290:pet_fonce:4230:27459249,27458292:pet_fonce:4230:27458919,27458296:pet_fonce:4230:27458775,27458298:pet_fonce:4230:27458807,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(2384951,2392603,2406369,2406361,2406355,2408595,2412705,2419639,2428101,2436193,2442075,2442775,2450013,2457660,2465475,2468737,2473651,2476955,2484319,2484207,2484295,2484215,2484287,2484273,2484259,2484223,2484255,2493487,2493513,2496809)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124973, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418494,27419905,27420198,27420393,27420847,27421239,27421568,27422031,27422488,27422808,27423183,27423328,27423953,27424427,27424794,27424843,27425195,27425375,27425737,27425902,27426197,27426750,27427132,27427409,27457808,27458313,27458365,27458411,27458460,27458493,27458700,27458766,27458812,27458866,27458911,27459062,27459245,27459344,27459384,27459684,27459844,27460073,27460185,27460531,27460807,27460847,27461422,27462703,27542757,27543209,27543492,27543734,27543948,27544156,27544511,27544645,27544852,27544954,27545109,27545218,27545494,27545542,27545648,27545798,27545874,27545918,27545961,27546049,27546189,27546408,27546527,27546708,27546845,27546970,27547053,27547237,27547288,27547826,27547887,27548273,27548547,27548667,27549169,27549335,27550086,27550296,27551104,27551920,27552633,27557059,27557118,27557246,27557305,27557386,27557609,27557647,27558217,27558384,27558881,27559132,27559501,27560134,27560654,27560955,27561316,27561750,27562056,27562500,27563173,27563805,27564030,27568543,27569184,2756989 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124974, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418492,27419899,27420199,27420392,27420858,27421246,27421572,27422027,27422499,27422795,27423186,27423341,27423960,27424422,27424789,27424857,27425201,27425391,27425749,27425905,27426204,27426762,27427131,27427398,27457814,27458321,27458362,27458415,27458450,27458497,27458716,27458773,27458804,27458874,27458921,27459055,27459247,27459351,27459386,27459687,27459846,27460066,27460191,27460534,27460809,27460848,27461434,27462717,27542749,27543210,27543504,27543737,27543940,27544161,27544501,27544643,27544850,27544961,27545125,27545206,27545496,27545534,27545649,27545806,27545877,27545921,27545974,27546053,27546198,27546424,27546537,27546705,27546851,27546972,27547052,27547239,27547281,27547820,27547883,27548267,27548541,27548663,27549171,27549334,27550077,27550286,27551120,27551907,27552627,27557071,27557112,27557259,27557314,27557381,27557610,27557662,27558224,27558394,27558876,27559131,27559500,27560127,27560664,27560963,27561324,27561760,27562061,27562493,27563171,27563807,27564037,27568535,27569189,2756990 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124975, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27419896,27420384,27420841,27422021,27422493,27422792,27423178,27423962,27424419,27424784,27424851,27425192,27425383,27425907,27426201,27427407,27457807,27458324,27458414,27458448,27458491,27458714,27458761,27458803,27458918,27459238,27459339,27459675,27459833,27460187,27460528,27460850,27461432,27462706,27542745,27543196,27543503,27543742,27543939,27544148,27544503,27544649,27544835,27544951,27545118,27545210,27545498,27545537,27545646,27545881,27545922,27545973,27546413,27546534,27546698,27546844,27546965,27547050,27547283,27548257,27548532,27548656,27549156,27549327,27550083,27550293,27551108,27551921,27552634,27557064,27557113,27557298,27557370,27557602,27558218,27558389,27558875,27559130,27559497,27560126,27560655,27560953,27561309,27561752,27562051,27562492,27563797,27564036,27568532,27569187,27569910,27570421,27570831,27570975,27571113,27571201,27571260,27571407,27571494,27571695,27571733,27571779,27571820,27571894,27571951,27576234,27577225,27578293,27579092,27579114,27580691,27581413,27581641,2758246 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124976, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418501,27419901,27420206,27420389,27420850,27421242,27421569,27422024,27422485,27422807,27423170,27423336,27423958,27424428,27424787,27424860,27425199,27425386,27425750,27425903,27426206,27426760,27427129,27427411,27457810,27458317,27458363,27458412,27458449,27458483,27458711,27458768,27458811,27458876,27458926,27459051,27459244,27459341,27459387,27459681,27459841,27460078,27460195,27460533,27460812,27460843,27461431,27462719,27542752,27543207,27543493,27543739,27543938,27544158,27544497,27544640,27544849,27544966,27545123,27545219,27545486,27545533,27545652,27545803,27545878,27545923,27545976,27546046,27546202,27546423,27546524,27546697,27546847,27546975,27547054,27547236,27547285,27547827,27547885,27548271,27548544,27548669,27549168,27549330,27550087,27550297,27551117,27551917,27552635,27557067,27557115,27557258,27557304,27557375,27557606,27557660,27558232,27558395,27558879,27559133,27559503,27560133,27560663,27560961,27561322,27561754,27562066,27562495,27563172,27563806,27564029,27568541,27569190,2756989 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124978, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418500,27419892,27420382,27420846,27421236,27421575,27422030,27422498,27422797,27423177,27423340,27423963,27424432,27424785,27424859,27425198,27425381,27425746,27425898,27427135,27427400,27457806,27458328,27458369,27458419,27458462,27458492,27458712,27458774,27458814,27458881,27458924,27459057,27459246,27459381,27459690,27459835,27460077,27460526,27460796,27461438,27462718,27542750,27543202,27543495,27543748,27543942,27544151,27544510,27544962,27545126,27545217,27545497,27545538,27545656,27545808,27545885,27546192,27546421,27546536,27546973,27547044,27547234,27547287,27547816,27547880,27548264,27548539,27548671,27549159,27549328,27550082,27550295,27551118,27551919,27552624,27557069,27557121,27557262,27557313,27557384,27557608,27557661,27558231,27558387,27558880,27559139,27559495,27560131,27560665,27560960,27561313,27561764,27562064,27562498,27563163,27563809,27564034,27568536,27569198,27569912,27570419,27570832,27570974,27571118,27571206,27571269,27571505,27571545,27571706,27571739,27571796,27571826,2757190 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124979, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418497,27419903,27420196,27420381,27420857,27421244,27421574,27422033,27422494,27422800,27423180,27423345,27423961,27424435,27424793,27424853,27425190,27425389,27425735,27425900,27426199,27426756,27427139,27427405,27457815,27458326,27458356,27458424,27458463,27458498,27458709,27458776,27458810,27458868,27458916,27459054,27459252,27459349,27459380,27459692,27459842,27460072,27460199,27460535,27460805,27460855,27461437,27462711,27542748,27543211,27543496,27543744,27543944,27544162,27544508,27544644,27544851,27544968,27545124,27545215,27545491,27545539,27545650,27545800,27545887,27545910,27545969,27546051,27546203,27546416,27546531,27546707,27546848,27546974,27547046,27547232,27547289,27547822,27547881,27548262,27548535,27548670,27549167,27549336,27550088,27550290,27551113,27551916,27552630,27557068,27557120,27557249,27557307,27557379,27557605,27557659,27558227,27558391,27558869,27559143,27559499,27560132,27560659,27560950,27561325,27561765,27562065,27562491,27563169,27563810,27564038,27568538,27569195,2756990 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124980, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (27418502,27419904,27420205,27420854,27421245,27421578,27422032,27422489,27422805,27423185,27423338,27424423,27424790,27425390,27425747,27425909,27426751,27457809,27458325,27458359,27458408,27458461,27458490,27458710,27458775,27458807,27458919,27459249,27459353,27459385,27459685,27459845,27460076,27460200,27460527,27460811,27460845,27461427,27462715,27542754,27543498,27543747,27544163,27544504,27545113,27545493,27545658,27545799,27546041,27546199,27546415,27546530,27546849,27546969,27547240,27547286,27547823,27547875,27548270,27548543,27548658,27549163,27550089,27551911,27552632,27557072,27557119,27557252,27557315,27557383,27557615,27557663,27558230,27558878,27559134,27559498,27560128,27560660,27560958,27561323,27561766,27562060,27562501,27563164,27563804,27568542,27569909,27570430,27570840,27570979,27571110,27571196,27571271,27571372,27571498,27571540,27571708,27571743,27571790,27571831,27571902,27576233,27577229,27578292,27579104,27580703,27582474,27584225,27584335,27584793,27585294,27587228,27587507,2758798 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124973,30124974,30124975,30124976,30124978,30124979,30124980?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=202 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': ((1982,),), 'unwanted_material_monthly_percentage': ((0.7192155042268846,),), 'material_repartition': (('incineration', 1978),), 'material_dict': {'incineration': 1978}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.710983815614649, 2), (datetime.date(2025, 10, 2), 0.6752552952025046, 2), (datetime.date(2025, 10, 3), 0.6645977612790049, 2), (datetime.date(2025, 10, 4), 0.6904684504985127, 3), (datetime.date(2025, 10, 5), 0.7565015518486218, 3), (datetime.date(2025, 10, 6), 0.7414940250009692, 1), (datetime.date(2025, 10, 7), 0.740904363077786, 4), (datetime.date(2025, 10, 8), 0.691300823548385, 3), (datetime.date(2025, 10, 9), 0.6947734083205412, 3), (datetime.date(2025, 10, 10), 0.6988213835581463, 3), (datetime.date(2025, 10, 11), 0.7173439181397687, 3), (datetime.date(2025, 10, 12), 0.8127342611429613, 3), (datetime.date(2025, 10, 13), 0.7812975302014548, 2), (datetime.date(2025, 10, 14), 0.7037307784215855, 3), (datetime.date(2025, 10, 15), 0.6879829245567736, 3), (datetime.date(2025, 10, 16), 0.7081272699967109, 3), (datetime.date(2025, 10, 17), 0.6653127626454333, 2), (datetime.date(2025, 10, 18), 0.6624130325868677, 3), (datetime.date(2025, 10, 19), 0.7590269842363715, 2), (datetime.date(2025, 10, 21), 0.7546249142301543, 3), (datetime.date(2025, 10, 22), 0.7408732980359407, 3), (datetime.date(2025, 10, 23), 0.7044104995913488, 3), (datetime.date(2025, 10, 24), 0.6583847676526724, 4), (datetime.date(2025, 10, 25), 0.6994830131331954, 4), (datetime.date(2025, 10, 26), 0.8329569592295498, 4), (datetime.date(2025, 10, 27), 0.772007336234474, 4), (datetime.date(2025, 10, 28), 0.7499723845237558, 4), (datetime.date(2025, 10, 29), 0.7203541605839462, 4), (datetime.date(2025, 10, 30), 0.6570534141877402, 3), (datetime.date(2025, 10, 31), 0.6191248439837007, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 10, 1), 0.710983815614649, 2), (datetime.date(2025, 10, 2), 0.6752552952025046, 2), (datetime.date(2025, 10, 3), 0.6645977612790049, 2), (datetime.date(2025, 10, 4), 0.6904684504985127, 3), (datetime.date(2025, 10, 5), 0.7565015518486218, 3), (datetime.date(2025, 10, 6), 0.7414940250009692, 1), (datetime.date(2025, 10, 7), 0.740904363077786, 4), (datetime.date(2025, 10, 8), 0.691300823548385, 3), (datetime.date(2025, 10, 9), 0.6947734083205412, 3), (datetime.date(2025, 10, 10), 0.6988213835581463, 3), (datetime.date(2025, 10, 11), 0.7173439181397687, 3), (datetime.date(2025, 10, 12), 0.8127342611429613, 3), (datetime.date(2025, 10, 13), 0.7812975302014548, 2), (datetime.date(2025, 10, 14), 0.7037307784215855, 3), (datetime.date(2025, 10, 15), 0.6879829245567736, 3), (datetime.date(2025, 10, 16), 0.7081272699967109, 3), (datetime.date(2025, 10, 17), 0.6653127626454333, 2), (datetime.date(2025, 10, 18), 0.6624130325868677, 3), (datetime.date(2025, 10, 19), 0.7590269842363715, 2), (datetime.date(2025, 10, 21), 0.7546249142301543, 3), (datetime.date(2025, 10, 22), 0.7408732980359407, 3), (datetime.date(2025, 10, 23), 0.7044104995913488, 3), (datetime.date(2025, 10, 24), 0.6583847676526724, 4), (datetime.date(2025, 10, 25), 0.6994830131331954, 4), (datetime.date(2025, 10, 26), 0.8329569592295498, 4), (datetime.date(2025, 10, 27), 0.772007336234474, 4), (datetime.date(2025, 10, 28), 0.7499723845237558, 4), (datetime.date(2025, 10, 29), 0.7203541605839462, 4), (datetime.date(2025, 10, 30), 0.6570534141877402, 3), (datetime.date(2025, 10, 31), 0.6191248439837007, 2))}, 'quality_array': [['-8.394573344722792', '01102025'], ['-8.450136215630815', '02102025'], ['-8.54350024460537', '03102025'], ['-8.610646206938123', '04102025'], ['-8.520723926780569', '05102025'], ['-8.06573543067761', '06102025'], ['-7.926751597357118', '07102025'], ['-8.441598065780468', '08102025'], ['-8.438337309114285', '09102025'], ['-8.5038115853645', '10102025'], ['-8.482601588623847', '11102025'], ['-8.285899222540928', '12102025'], ['-7.913723392192055', '13102025'], ['-8.103167460359188', '14102025'], ['-8.2400434061512', '15102025'], ['-8.236779521640749', '16102025'], ['-8.224980160867831', '17102025'], ['-8.342632470316623', '18102025'], ['-8.226602909181782', '19102025'], ['-8.173879513209716', '21102025'], ['-8.041380384142407', '22102025'], ['-8.343496299903045', '23102025'], ['-8.458196436233528', '24102025'], ['-8.301676952451361', '25102025'], ['-8.20421111339842', '26102025'], ['-8.044099953924833', '27102025'], ['-7.696345541799944', '28102025'], ['-8.000461902471915', '29102025'], ['-8.399984587512474', '30102025'], ['-8.623405959346659', '31102025']], 'number_of_batch': ((662,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014850347748988964, 'nb_photo': 20990, 'list_port_cont': '27418494,27419905,27420198,27420393,27420847,27421239,27421568,27422031,27422488,27422808,27423183,27423328,27423953,27424427,27424794,27424843,27425195,27425375,27425737,27425902,27426197,27426750,27427132,27427409,27457808,27458313,27458365,27458411,27458460,27458493,27458700,27458766,27458812,27458866,27458911,27459062,27459245,27459344,27459384,27459684,27459844,27460073,27460185,27460531,27460807,27460847,27461422,27462703,27542757,27543209,27543492,27543734,27543948,27544156,27544511,27544645,27544852,27544954,27545109,27545218,27545494,27545542,27545648,27545798,27545874,27545918,27545961,27546049,27546189,27546408,27546527,27546708,27546845,27546970,27547053,27547237,27547288,27547826,27547887,27548273,27548547,27548667,27549169,27549335,27550086,27550296,27551104,27551920,27552633,27557059,27557118,27557246,27557305,27557386,27557609,27557647,27558217,27558384,27558881,27559132,27559501,27560134,27560654,27560955,27561316,27561750,27562056,27562500,27563173,27563805,27564030,27568543,27569184,2756989', 'assoc_port': '27414921:27418494,27419508:27427132,27419512:27427409,27419515:27426750,27419517:27425902,27419520:27426197,27419524:27425737,27419528:27425375,27419532:27424843,27419536:27425195,27419540:27424427,27419542:27423953,27419547:27423183,27419550:27423328,27419555:27422808,27419559:27422031,27419562:27421568,27419566:27420847,27419571:27421239,27419574:27420393,27419603:27419905,27419605:27420198,27421653:27422488,27424392:27424794,27457115:27457808,27458266:27460847,27458269:27461422,27458272:27460807,27458275:27460531,27458277:27459684,27458280:27459844,27458282:27460185,27458284:27459384,27458286:27459344,27458288:27459062,27458290:27459245,27458292:27458911,27458294:27458866,27458296:27458766,27458298:27458812,27458300:27458493,27458302:27458700,27458304:27458411,27458306:27458460,27458308:27458365,27458309:27458313,27459575:27460073,27462142:27462703,27530982:27542757,27530986:27543209,27530989:27543492,27530993:27543734,27530996:27543948,27531000:27544156,27531004:27578289,27531009:27544511,27531013:2754464', 'assoc_mat': '27414921:autre:4230:27418494,27419508:autre:4230:27427132,27419512:autre:4230:27427409,27419515:autre:4230:27426750,27419517:autre:4230:27425902,27419520:autre:4230:27426197,27419524:autre:4230:27425737,27419528:autre:4230:27425375,27419532:autre:4230:27424843,27419536:autre:4230:27425195,27419540:autre:4230:27424427,27419542:autre:4230:27423953,27419547:autre:4230:27423183,27419550:autre:4230:27423328,27419555:autre:4230:27422808,27419559:autre:4230:27422031,27419562:autre:4230:27421568,27419566:autre:4230:27420847,27419571:autre:4230:27421239,27419574:autre:4230:27420393,27419603:autre:4230:27419905,27419605:autre:4230:27420198,27421653:autre:4230:27422488,27424392:autre:4230:27424794,27457115:autre:4230:27457808,27458266:autre:4230:27460847,27458269:autre:4230:27461422,27458272:autre:4230:27460807,27458275:autre:4230:27460531,27458277:autre:4230:27459684,27458280:autre:4230:27459844,27458282:autre:4230:27460185,27458284:autre:4230:27459384,27458286:autre:4230:27459344,27458288:autre:4230:27459062,27458290:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.055245668813900764, 'nb_photo': 104677, 'list_port_cont': '27418492,27419899,27420199,27420392,27420858,27421246,27421572,27422027,27422499,27422795,27423186,27423341,27423960,27424422,27424789,27424857,27425201,27425391,27425749,27425905,27426204,27426762,27427131,27427398,27457814,27458321,27458362,27458415,27458450,27458497,27458716,27458773,27458804,27458874,27458921,27459055,27459247,27459351,27459386,27459687,27459846,27460066,27460191,27460534,27460809,27460848,27461434,27462717,27542749,27543210,27543504,27543737,27543940,27544161,27544501,27544643,27544850,27544961,27545125,27545206,27545496,27545534,27545649,27545806,27545877,27545921,27545974,27546053,27546198,27546424,27546537,27546705,27546851,27546972,27547052,27547239,27547281,27547820,27547883,27548267,27548541,27548663,27549171,27549334,27550077,27550286,27551120,27551907,27552627,27557071,27557112,27557259,27557314,27557381,27557610,27557662,27558224,27558394,27558876,27559131,27559500,27560127,27560664,27560963,27561324,27561760,27562061,27562493,27563171,27563807,27564037,27568535,27569189,2756990', 'assoc_port': '27414921:27418492,27419508:27427131,27419512:27427398,27419515:27426762,27419517:27425905,27419520:27426204,27419524:27425749,27419528:27425391,27419532:27424857,27419536:27425201,27419540:27424422,27419542:27423960,27419547:27423186,27419550:27423341,27419555:27422795,27419559:27422027,27419562:27421572,27419566:27420858,27419571:27421246,27419574:27420392,27419603:27419899,27419605:27420199,27421653:27422499,27424392:27424789,27457115:27457814,27458266:27460848,27458269:27461434,27458272:27460809,27458275:27460534,27458277:27459687,27458280:27459846,27458282:27460191,27458284:27459386,27458286:27459351,27458288:27459055,27458290:27459247,27458292:27458921,27458294:27458874,27458296:27458773,27458298:27458804,27458300:27458497,27458302:27458716,27458304:27458415,27458306:27458450,27458308:27458362,27458309:27458321,27459575:27460066,27462142:27462717,27530982:27542749,27530986:27543210,27530989:27543504,27530993:27543737,27530996:27543940,27531000:27544161,27531004:27578291,27531009:27544501,27531013:2754464', 'assoc_mat': '27414921:carton:4230:27418492,27419508:carton:4230:27427131,27419512:carton:4230:27427398,27419515:carton:4230:27426762,27419517:carton:4230:27425905,27419520:carton:4230:27426204,27419524:carton:4230:27425749,27419528:carton:4230:27425391,27419532:carton:4230:27424857,27419536:carton:4230:27425201,27419540:carton:4230:27424422,27419542:carton:4230:27423960,27419547:carton:4230:27423186,27419550:carton:4230:27423341,27419555:carton:4230:27422795,27419559:carton:4230:27422027,27419562:carton:4230:27421572,27419566:carton:4230:27420858,27419571:carton:4230:27421246,27419574:carton:4230:27420392,27419603:carton:4230:27419899,27419605:carton:4230:27420199,27421653:carton:4230:27422499,27424392:carton:4230:27424789,27457115:carton:4230:27457814,27458266:carton:4230:27460848,27458269:carton:4230:27461434,27458272:carton:4230:27460809,27458275:carton:4230:27460534,27458277:carton:4230:27459687,27458280:carton:4230:27459846,27458282:carton:4230:27460191,27458284:carton:4230:27459386,27458286:carton:4230:27459351,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012118017193548133, 'nb_photo': 1897, 'list_port_cont': '27419896,27420384,27420841,27422021,27422493,27422792,27423178,27423962,27424419,27424784,27424851,27425192,27425383,27425907,27426201,27427407,27457807,27458324,27458414,27458448,27458491,27458714,27458761,27458803,27458918,27459238,27459339,27459675,27459833,27460187,27460528,27460850,27461432,27462706,27542745,27543196,27543503,27543742,27543939,27544148,27544503,27544649,27544835,27544951,27545118,27545210,27545498,27545537,27545646,27545881,27545922,27545973,27546413,27546534,27546698,27546844,27546965,27547050,27547283,27548257,27548532,27548656,27549156,27549327,27550083,27550293,27551108,27551921,27552634,27557064,27557113,27557298,27557370,27557602,27558218,27558389,27558875,27559130,27559497,27560126,27560655,27560953,27561309,27561752,27562051,27562492,27563797,27564036,27568532,27569187,27569910,27570421,27570831,27570975,27571113,27571201,27571260,27571407,27571494,27571695,27571733,27571779,27571820,27571894,27571951,27576234,27577225,27578293,27579092,27579114,27580691,27581413,27581641,2758246', 'assoc_port': '27419512:27427407,27419517:27425907,27419520:27426201,27419528:27425383,27419532:27424851,27419536:27425192,27419540:27424419,27419542:27423962,27419547:27423178,27419555:27422792,27419559:27422021,27419566:27420841,27419574:27420384,27419603:27419896,27421653:27422493,27424392:27424784,27457115:27457807,27458266:27460850,27458269:27461432,27458275:27460528,27458277:27459675,27458280:27459833,27458282:27460187,27458286:27459339,27458290:27459238,27458292:27458918,27458296:27458761,27458298:27458803,27458300:27458491,27458302:27458714,27458304:27458414,27458306:27458448,27458309:27458324,27462142:27462706,27530982:27542745,27530986:27543196,27530989:27543503,27530993:27543742,27530996:27543939,27531000:27544148,27531004:27578293,27531009:27544503,27531013:27544649,27531018:27544835,27531022:27544951,27531026:27545118,27531031:27545210,27531036:27545498,27531040:27545537,27531044:27545646,27531055:27545922,27531061:27546413,27531062:27545881,27531068:27546534,27531070:27580691,27531076:27546698,27531077:2754597', 'assoc_mat': '27419512:metal:4230:27427407,27419517:metal:4230:27425907,27419520:metal:4230:27426201,27419528:metal:4230:27425383,27419532:metal:4230:27424851,27419536:metal:4230:27425192,27419540:metal:4230:27424419,27419542:metal:4230:27423962,27419547:metal:4230:27423178,27419555:metal:4230:27422792,27419559:metal:4230:27422021,27419566:metal:4230:27420841,27419574:metal:4230:27420384,27419603:metal:4230:27419896,27421653:metal:4230:27422493,27424392:metal:4230:27424784,27457115:metal:4230:27457807,27458266:metal:4230:27460850,27458269:metal:4230:27461432,27458275:metal:4230:27460528,27458277:metal:4230:27459675,27458280:metal:4230:27459833,27458282:metal:4230:27460187,27458286:metal:4230:27459339,27458290:metal:4230:27459238,27458292:metal:4230:27458918,27458296:metal:4230:27458761,27458298:metal:4230:27458803,27458300:metal:4230:27458491,27458302:metal:4230:27458714,27458304:metal:4230:27458414,27458306:metal:4230:27458448,27458309:metal:4230:27458324,27462142:metal:4230:27462706,27530982:metal:4230:27542745,27530986:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2133115153938636, 'nb_photo': 499364, 'list_port_cont': '27418501,27419901,27420206,27420389,27420850,27421242,27421569,27422024,27422485,27422807,27423170,27423336,27423958,27424428,27424787,27424860,27425199,27425386,27425750,27425903,27426206,27426760,27427129,27427411,27457810,27458317,27458363,27458412,27458449,27458483,27458711,27458768,27458811,27458876,27458926,27459051,27459244,27459341,27459387,27459681,27459841,27460078,27460195,27460533,27460812,27460843,27461431,27462719,27542752,27543207,27543493,27543739,27543938,27544158,27544497,27544640,27544849,27544966,27545123,27545219,27545486,27545533,27545652,27545803,27545878,27545923,27545976,27546046,27546202,27546423,27546524,27546697,27546847,27546975,27547054,27547236,27547285,27547827,27547885,27548271,27548544,27548669,27549168,27549330,27550087,27550297,27551117,27551917,27552635,27557067,27557115,27557258,27557304,27557375,27557606,27557660,27558232,27558395,27558879,27559133,27559503,27560133,27560663,27560961,27561322,27561754,27562066,27562495,27563172,27563806,27564029,27568541,27569190,2756989', 'assoc_port': '27414921:27418501,27419508:27427129,27419512:27427411,27419515:27426760,27419517:27425903,27419520:27426206,27419524:27425750,27419528:27425386,27419532:27424860,27419536:27425199,27419540:27424428,27419542:27423958,27419547:27423170,27419550:27423336,27419555:27422807,27419559:27422024,27419562:27421569,27419566:27420850,27419571:27421242,27419574:27420389,27419603:27419901,27419605:27420206,27421653:27422485,27424392:27424787,27457115:27457810,27458266:27460843,27458269:27461431,27458272:27460812,27458275:27460533,27458277:27459681,27458280:27459841,27458282:27460195,27458284:27459387,27458286:27459341,27458288:27459051,27458290:27459244,27458292:27458926,27458294:27458876,27458296:27458768,27458298:27458811,27458300:27458483,27458302:27458711,27458304:27458412,27458306:27458449,27458308:27458363,27458309:27458317,27459575:27460078,27462142:27462719,27530982:27542752,27530986:27543207,27530989:27543493,27530993:27543739,27530996:27543938,27531000:27544158,27531004:27578279,27531009:27544497,27531013:2754464', 'assoc_mat': '27414921:papier:4230:27418501,27419508:papier:4230:27427129,27419512:papier:4230:27427411,27419515:papier:4230:27426760,27419517:papier:4230:27425903,27419520:papier:4230:27426206,27419524:papier:4230:27425750,27419528:papier:4230:27425386,27419532:papier:4230:27424860,27419536:papier:4230:27425199,27419540:papier:4230:27424428,27419542:papier:4230:27423958,27419547:papier:4230:27423170,27419550:papier:4230:27423336,27419555:papier:4230:27422807,27419559:papier:4230:27422024,27419562:papier:4230:27421569,27419566:papier:4230:27420850,27419571:papier:4230:27421242,27419574:papier:4230:27420389,27419603:papier:4230:27419901,27419605:papier:4230:27420206,27421653:papier:4230:27422485,27424392:papier:4230:27424787,27457115:papier:4230:27457810,27458266:papier:4230:27460843,27458269:papier:4230:27461431,27458272:papier:4230:27460812,27458275:papier:4230:27460533,27458277:papier:4230:27459681,27458280:papier:4230:27459841,27458282:papier:4230:27460195,27458284:papier:4230:27459387,27458286:papier:4230:27459341,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004383875942070988, 'nb_photo': 3277, 'list_port_cont': '27418500,27419892,27420382,27420846,27421236,27421575,27422030,27422498,27422797,27423177,27423340,27423963,27424432,27424785,27424859,27425198,27425381,27425746,27425898,27427135,27427400,27457806,27458328,27458369,27458419,27458462,27458492,27458712,27458774,27458814,27458881,27458924,27459057,27459246,27459381,27459690,27459835,27460077,27460526,27460796,27461438,27462718,27542750,27543202,27543495,27543748,27543942,27544151,27544510,27544962,27545126,27545217,27545497,27545538,27545656,27545808,27545885,27546192,27546421,27546536,27546973,27547044,27547234,27547287,27547816,27547880,27548264,27548539,27548671,27549159,27549328,27550082,27550295,27551118,27551919,27552624,27557069,27557121,27557262,27557313,27557384,27557608,27557661,27558231,27558387,27558880,27559139,27559495,27560131,27560665,27560960,27561313,27561764,27562064,27562498,27563163,27563809,27564034,27568536,27569198,27569912,27570419,27570832,27570974,27571118,27571206,27571269,27571505,27571545,27571706,27571739,27571796,27571826,2757190', 'assoc_port': '27414921:27418500,27419508:27427135,27419512:27427400,27419517:27425898,27419524:27425746,27419528:27425381,27419532:27424859,27419536:27425198,27419540:27424432,27419542:27423963,27419547:27423177,27419550:27423340,27419555:27422797,27419559:27422030,27419562:27421575,27419566:27420846,27419571:27421236,27419574:27420382,27419603:27419892,27421653:27422498,27424392:27424785,27457115:27457806,27458269:27461438,27458272:27460796,27458275:27460526,27458277:27459690,27458280:27459835,27458284:27459381,27458288:27459057,27458290:27459246,27458292:27458924,27458294:27458881,27458296:27458774,27458298:27458814,27458300:27458492,27458302:27458712,27458304:27458419,27458306:27458462,27458308:27458369,27458309:27458328,27459575:27460077,27462142:27462718,27530982:27542750,27530986:27543202,27530989:27543495,27530993:27543748,27530996:27543942,27531000:27544151,27531004:27578285,27531009:27544510,27531022:27544962,27531026:27545126,27531031:27545217,27531036:27545497,27531040:27545538,27531044:27545656,27531049:2754580', 'assoc_mat': '27414921:pehd:4230:27418500,27419508:pehd:4230:27427135,27419512:pehd:4230:27427400,27419517:pehd:4230:27425898,27419524:pehd:4230:27425746,27419528:pehd:4230:27425381,27419532:pehd:4230:27424859,27419536:pehd:4230:27425198,27419540:pehd:4230:27424432,27419542:pehd:4230:27423963,27419547:pehd:4230:27423177,27419550:pehd:4230:27423340,27419555:pehd:4230:27422797,27419559:pehd:4230:27422030,27419562:pehd:4230:27421575,27419566:pehd:4230:27420846,27419571:pehd:4230:27421236,27419574:pehd:4230:27420382,27419603:pehd:4230:27419892,27421653:pehd:4230:27422498,27424392:pehd:4230:27424785,27457115:pehd:4230:27457806,27458269:pehd:4230:27461438,27458272:pehd:4230:27460796,27458275:pehd:4230:27460526,27458277:pehd:4230:27459690,27458280:pehd:4230:27459835,27458284:pehd:4230:27459381,27458288:pehd:4230:27459057,27458290:pehd:4230:27459246,27458292:pehd:4230:27458924,27458294:pehd:4230:27458881,27458296:pehd:4230:27458774,27458298:pehd:4230:27458814,27458300:pehd:4230:27458492,27458302:pehd:4230:27458712,27458304:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01093408779020654, 'nb_photo': 21967, 'list_port_cont': '27418497,27419903,27420196,27420381,27420857,27421244,27421574,27422033,27422494,27422800,27423180,27423345,27423961,27424435,27424793,27424853,27425190,27425389,27425735,27425900,27426199,27426756,27427139,27427405,27457815,27458326,27458356,27458424,27458463,27458498,27458709,27458776,27458810,27458868,27458916,27459054,27459252,27459349,27459380,27459692,27459842,27460072,27460199,27460535,27460805,27460855,27461437,27462711,27542748,27543211,27543496,27543744,27543944,27544162,27544508,27544644,27544851,27544968,27545124,27545215,27545491,27545539,27545650,27545800,27545887,27545910,27545969,27546051,27546203,27546416,27546531,27546707,27546848,27546974,27547046,27547232,27547289,27547822,27547881,27548262,27548535,27548670,27549167,27549336,27550088,27550290,27551113,27551916,27552630,27557068,27557120,27557249,27557307,27557379,27557605,27557659,27558227,27558391,27558869,27559143,27559499,27560132,27560659,27560950,27561325,27561765,27562065,27562491,27563169,27563810,27564038,27568538,27569195,2756990', 'assoc_port': '27414921:27418497,27419508:27427139,27419512:27427405,27419515:27426756,27419517:27425900,27419520:27426199,27419524:27425735,27419528:27425389,27419532:27424853,27419536:27425190,27419540:27424435,27419542:27423961,27419547:27423180,27419550:27423345,27419555:27422800,27419559:27422033,27419562:27421574,27419566:27420857,27419571:27421244,27419574:27420381,27419603:27419903,27419605:27420196,27421653:27422494,27424392:27424793,27457115:27457815,27458266:27460855,27458269:27461437,27458272:27460805,27458275:27460535,27458277:27459692,27458280:27459842,27458282:27460199,27458284:27459380,27458286:27459349,27458288:27459054,27458290:27459252,27458292:27458916,27458294:27458868,27458296:27458776,27458298:27458810,27458300:27458498,27458302:27458709,27458304:27458424,27458306:27458463,27458308:27458356,27458309:27458326,27459575:27460072,27462142:27462711,27530982:27542748,27530986:27543211,27530989:27543496,27530993:27543744,27530996:27543944,27531000:27544162,27531004:27578287,27531009:27544508,27531013:2754464', 'assoc_mat': '27414921:pet_clair:4230:27418497,27419508:pet_clair:4230:27427139,27419512:pet_clair:4230:27427405,27419515:pet_clair:4230:27426756,27419517:pet_clair:4230:27425900,27419520:pet_clair:4230:27426199,27419524:pet_clair:4230:27425735,27419528:pet_clair:4230:27425389,27419532:pet_clair:4230:27424853,27419536:pet_clair:4230:27425190,27419540:pet_clair:4230:27424435,27419542:pet_clair:4230:27423961,27419547:pet_clair:4230:27423180,27419550:pet_clair:4230:27423345,27419555:pet_clair:4230:27422800,27419559:pet_clair:4230:27422033,27419562:pet_clair:4230:27421574,27419566:pet_clair:4230:27420857,27419571:pet_clair:4230:27421244,27419574:pet_clair:4230:27420381,27419603:pet_clair:4230:27419903,27419605:pet_clair:4230:27420196,27421653:pet_clair:4230:27422494,27424392:pet_clair:4230:27424793,27457115:pet_clair:4230:27457815,27458266:pet_clair:4230:27460855,27458269:pet_clair:4230:27461437,27458272:pet_clair:4230:27460805,27458275:pet_clair:4230:27460535,27458277:pet_clair:4230:27459692,27458280:pet_clair:4230:27459842,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002487042744103774, 'nb_photo': 1235, 'list_port_cont': '27418502,27419904,27420205,27420854,27421245,27421578,27422032,27422489,27422805,27423185,27423338,27424423,27424790,27425390,27425747,27425909,27426751,27457809,27458325,27458359,27458408,27458461,27458490,27458710,27458775,27458807,27458919,27459249,27459353,27459385,27459685,27459845,27460076,27460200,27460527,27460811,27460845,27461427,27462715,27542754,27543498,27543747,27544163,27544504,27545113,27545493,27545658,27545799,27546041,27546199,27546415,27546530,27546849,27546969,27547240,27547286,27547823,27547875,27548270,27548543,27548658,27549163,27550089,27551911,27552632,27557072,27557119,27557252,27557315,27557383,27557615,27557663,27558230,27558878,27559134,27559498,27560128,27560660,27560958,27561323,27561766,27562060,27562501,27563164,27563804,27568542,27569909,27570430,27570840,27570979,27571110,27571196,27571271,27571372,27571498,27571540,27571708,27571743,27571790,27571831,27571902,27576233,27577229,27578292,27579104,27580703,27582474,27584225,27584335,27584793,27585294,27587228,27587507,2758798', 'assoc_port': '27414921:27418502,27419515:27426751,27419517:27425909,27419524:27425747,27419528:27425390,27419540:27424423,27419547:27423185,27419550:27423338,27419555:27422805,27419559:27422032,27419562:27421578,27419566:27420854,27419571:27421245,27419603:27419904,27419605:27420205,27421653:27422489,27424392:27424790,27457115:27457809,27458266:27460845,27458269:27461427,27458272:27460811,27458275:27460527,27458277:27459685,27458280:27459845,27458282:27460200,27458284:27459385,27458286:27459353,27458290:27459249,27458292:27458919,27458296:27458775,27458298:27458807,27458300:27458490,27458302:27458710,27458304:27458408,27458306:27458461,27458308:27458359,27458309:27458325,27459575:27460076,27462142:27462715,27530982:27542754,27530989:27543498,27530993:27543747,27531000:27544163,27531004:27578292,27531009:27544504,27531026:27545113,27531036:27545493,27531044:27545658,27531049:27545799,27531061:27546415,27531068:27546530,27531070:27580703,27531084:27546849,27531085:27546041,27531093:27590279,27531100:27546969,27531101:2754619', 'assoc_mat': '27414921:pet_fonce:4230:27418502,27419515:pet_fonce:4230:27426751,27419517:pet_fonce:4230:27425909,27419524:pet_fonce:4230:27425747,27419528:pet_fonce:4230:27425390,27419540:pet_fonce:4230:27424423,27419547:pet_fonce:4230:27423185,27419550:pet_fonce:4230:27423338,27419555:pet_fonce:4230:27422805,27419559:pet_fonce:4230:27422032,27419562:pet_fonce:4230:27421578,27419566:pet_fonce:4230:27420854,27419571:pet_fonce:4230:27421245,27419603:pet_fonce:4230:27419904,27419605:pet_fonce:4230:27420205,27421653:pet_fonce:4230:27422489,27424392:pet_fonce:4230:27424790,27457115:pet_fonce:4230:27457809,27458266:pet_fonce:4230:27460845,27458269:pet_fonce:4230:27461427,27458272:pet_fonce:4230:27460811,27458275:pet_fonce:4230:27460527,27458277:pet_fonce:4230:27459685,27458280:pet_fonce:4230:27459845,27458282:pet_fonce:4230:27460200,27458284:pet_fonce:4230:27459385,27458286:pet_fonce:4230:27459353,27458290:pet_fonce:4230:27459249,27458292:pet_fonce:4230:27458919,27458296:pet_fonce:4230:27458775,27458298:pet_fonce:4230:27458807,2'}), 'main_stat': {'nb_photos': 1982}, 'velours_link': 'https://www.fotonower.com/velours/30124973,30124974,30124975,30124976,30124978,30124979,30124980?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-10', 0.7192155042268846),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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': ((1982,),), 'unwanted_material_monthly_percentage': ((0.7192155042268846,),), 'material_repartition': (('incineration', 1978),), 'material_dict': {'incineration': 1978}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.710983815614649, 2), (datetime.date(2025, 10, 2), 0.6752552952025046, 2), (datetime.date(2025, 10, 3), 0.6645977612790049, 2), (datetime.date(2025, 10, 4), 0.6904684504985127, 3), (datetime.date(2025, 10, 5), 0.7565015518486218, 3), (datetime.date(2025, 10, 6), 0.7414940250009692, 1), (datetime.date(2025, 10, 7), 0.740904363077786, 4), (datetime.date(2025, 10, 8), 0.691300823548385, 3), (datetime.date(2025, 10, 9), 0.6947734083205412, 3), (datetime.date(2025, 10, 10), 0.6988213835581463, 3), (datetime.date(2025, 10, 11), 0.7173439181397687, 3), (datetime.date(2025, 10, 12), 0.8127342611429613, 3), (datetime.date(2025, 10, 13), 0.7812975302014548, 2), (datetime.date(2025, 10, 14), 0.7037307784215855, 3), (datetime.date(2025, 10, 15), 0.6879829245567736, 3), (datetime.date(2025, 10, 16), 0.7081272699967109, 3), (datetime.date(2025, 10, 17), 0.6653127626454333, 2), (datetime.date(2025, 10, 18), 0.6624130325868677, 3), (datetime.date(2025, 10, 19), 0.7590269842363715, 2), (datetime.date(2025, 10, 21), 0.7546249142301543, 3), (datetime.date(2025, 10, 22), 0.7408732980359407, 3), (datetime.date(2025, 10, 23), 0.7044104995913488, 3), (datetime.date(2025, 10, 24), 0.6583847676526724, 4), (datetime.date(2025, 10, 25), 0.6994830131331954, 4), (datetime.date(2025, 10, 26), 0.8329569592295498, 4), (datetime.date(2025, 10, 27), 0.772007336234474, 4), (datetime.date(2025, 10, 28), 0.7499723845237558, 4), (datetime.date(2025, 10, 29), 0.7203541605839462, 4), (datetime.date(2025, 10, 30), 0.6570534141877402, 3), (datetime.date(2025, 10, 31), 0.6191248439837007, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 10, 1), 0.710983815614649, 2), (datetime.date(2025, 10, 2), 0.6752552952025046, 2), (datetime.date(2025, 10, 3), 0.6645977612790049, 2), (datetime.date(2025, 10, 4), 0.6904684504985127, 3), (datetime.date(2025, 10, 5), 0.7565015518486218, 3), (datetime.date(2025, 10, 6), 0.7414940250009692, 1), (datetime.date(2025, 10, 7), 0.740904363077786, 4), (datetime.date(2025, 10, 8), 0.691300823548385, 3), (datetime.date(2025, 10, 9), 0.6947734083205412, 3), (datetime.date(2025, 10, 10), 0.6988213835581463, 3), (datetime.date(2025, 10, 11), 0.7173439181397687, 3), (datetime.date(2025, 10, 12), 0.8127342611429613, 3), (datetime.date(2025, 10, 13), 0.7812975302014548, 2), (datetime.date(2025, 10, 14), 0.7037307784215855, 3), (datetime.date(2025, 10, 15), 0.6879829245567736, 3), (datetime.date(2025, 10, 16), 0.7081272699967109, 3), (datetime.date(2025, 10, 17), 0.6653127626454333, 2), (datetime.date(2025, 10, 18), 0.6624130325868677, 3), (datetime.date(2025, 10, 19), 0.7590269842363715, 2), (datetime.date(2025, 10, 21), 0.7546249142301543, 3), (datetime.date(2025, 10, 22), 0.7408732980359407, 3), (datetime.date(2025, 10, 23), 0.7044104995913488, 3), (datetime.date(2025, 10, 24), 0.6583847676526724, 4), (datetime.date(2025, 10, 25), 0.6994830131331954, 4), (datetime.date(2025, 10, 26), 0.8329569592295498, 4), (datetime.date(2025, 10, 27), 0.772007336234474, 4), (datetime.date(2025, 10, 28), 0.7499723845237558, 4), (datetime.date(2025, 10, 29), 0.7203541605839462, 4), (datetime.date(2025, 10, 30), 0.6570534141877402, 3), (datetime.date(2025, 10, 31), 0.6191248439837007, 2))}, 'quality_array': [['-8.394573344722792', '01102025'], ['-8.450136215630815', '02102025'], ['-8.54350024460537', '03102025'], ['-8.610646206938123', '04102025'], ['-8.520723926780569', '05102025'], ['-8.06573543067761', '06102025'], ['-7.926751597357118', '07102025'], ['-8.441598065780468', '08102025'], ['-8.438337309114285', '09102025'], ['-8.5038115853645', '10102025'], ['-8.482601588623847', '11102025'], ['-8.285899222540928', '12102025'], ['-7.913723392192055', '13102025'], ['-8.103167460359188', '14102025'], ['-8.2400434061512', '15102025'], ['-8.236779521640749', '16102025'], ['-8.224980160867831', '17102025'], ['-8.342632470316623', '18102025'], ['-8.226602909181782', '19102025'], ['-8.173879513209716', '21102025'], ['-8.041380384142407', '22102025'], ['-8.343496299903045', '23102025'], ['-8.458196436233528', '24102025'], ['-8.301676952451361', '25102025'], ['-8.20421111339842', '26102025'], ['-8.044099953924833', '27102025'], ['-7.696345541799944', '28102025'], ['-8.000461902471915', '29102025'], ['-8.399984587512474', '30102025'], ['-8.623405959346659', '31102025']], 'number_of_batch': ((662,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014850347748988964, 'nb_photo': 20990, 'list_port_cont': '27418494,27419905,27420198,27420393,27420847,27421239,27421568,27422031,27422488,27422808,27423183,27423328,27423953,27424427,27424794,27424843,27425195,27425375,27425737,27425902,27426197,27426750,27427132,27427409,27457808,27458313,27458365,27458411,27458460,27458493,27458700,27458766,27458812,27458866,27458911,27459062,27459245,27459344,27459384,27459684,27459844,27460073,27460185,27460531,27460807,27460847,27461422,27462703,27542757,27543209,27543492,27543734,27543948,27544156,27544511,27544645,27544852,27544954,27545109,27545218,27545494,27545542,27545648,27545798,27545874,27545918,27545961,27546049,27546189,27546408,27546527,27546708,27546845,27546970,27547053,27547237,27547288,27547826,27547887,27548273,27548547,27548667,27549169,27549335,27550086,27550296,27551104,27551920,27552633,27557059,27557118,27557246,27557305,27557386,27557609,27557647,27558217,27558384,27558881,27559132,27559501,27560134,27560654,27560955,27561316,27561750,27562056,27562500,27563173,27563805,27564030,27568543,27569184,2756989', 'assoc_port': '27414921:27418494,27419508:27427132,27419512:27427409,27419515:27426750,27419517:27425902,27419520:27426197,27419524:27425737,27419528:27425375,27419532:27424843,27419536:27425195,27419540:27424427,27419542:27423953,27419547:27423183,27419550:27423328,27419555:27422808,27419559:27422031,27419562:27421568,27419566:27420847,27419571:27421239,27419574:27420393,27419603:27419905,27419605:27420198,27421653:27422488,27424392:27424794,27457115:27457808,27458266:27460847,27458269:27461422,27458272:27460807,27458275:27460531,27458277:27459684,27458280:27459844,27458282:27460185,27458284:27459384,27458286:27459344,27458288:27459062,27458290:27459245,27458292:27458911,27458294:27458866,27458296:27458766,27458298:27458812,27458300:27458493,27458302:27458700,27458304:27458411,27458306:27458460,27458308:27458365,27458309:27458313,27459575:27460073,27462142:27462703,27530982:27542757,27530986:27543209,27530989:27543492,27530993:27543734,27530996:27543948,27531000:27544156,27531004:27578289,27531009:27544511,27531013:2754464', 'assoc_mat': '27414921:autre:4230:27418494,27419508:autre:4230:27427132,27419512:autre:4230:27427409,27419515:autre:4230:27426750,27419517:autre:4230:27425902,27419520:autre:4230:27426197,27419524:autre:4230:27425737,27419528:autre:4230:27425375,27419532:autre:4230:27424843,27419536:autre:4230:27425195,27419540:autre:4230:27424427,27419542:autre:4230:27423953,27419547:autre:4230:27423183,27419550:autre:4230:27423328,27419555:autre:4230:27422808,27419559:autre:4230:27422031,27419562:autre:4230:27421568,27419566:autre:4230:27420847,27419571:autre:4230:27421239,27419574:autre:4230:27420393,27419603:autre:4230:27419905,27419605:autre:4230:27420198,27421653:autre:4230:27422488,27424392:autre:4230:27424794,27457115:autre:4230:27457808,27458266:autre:4230:27460847,27458269:autre:4230:27461422,27458272:autre:4230:27460807,27458275:autre:4230:27460531,27458277:autre:4230:27459684,27458280:autre:4230:27459844,27458282:autre:4230:27460185,27458284:autre:4230:27459384,27458286:autre:4230:27459344,27458288:autre:4230:27459062,27458290:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.055245668813900764, 'nb_photo': 104677, 'list_port_cont': '27418492,27419899,27420199,27420392,27420858,27421246,27421572,27422027,27422499,27422795,27423186,27423341,27423960,27424422,27424789,27424857,27425201,27425391,27425749,27425905,27426204,27426762,27427131,27427398,27457814,27458321,27458362,27458415,27458450,27458497,27458716,27458773,27458804,27458874,27458921,27459055,27459247,27459351,27459386,27459687,27459846,27460066,27460191,27460534,27460809,27460848,27461434,27462717,27542749,27543210,27543504,27543737,27543940,27544161,27544501,27544643,27544850,27544961,27545125,27545206,27545496,27545534,27545649,27545806,27545877,27545921,27545974,27546053,27546198,27546424,27546537,27546705,27546851,27546972,27547052,27547239,27547281,27547820,27547883,27548267,27548541,27548663,27549171,27549334,27550077,27550286,27551120,27551907,27552627,27557071,27557112,27557259,27557314,27557381,27557610,27557662,27558224,27558394,27558876,27559131,27559500,27560127,27560664,27560963,27561324,27561760,27562061,27562493,27563171,27563807,27564037,27568535,27569189,2756990', 'assoc_port': '27414921:27418492,27419508:27427131,27419512:27427398,27419515:27426762,27419517:27425905,27419520:27426204,27419524:27425749,27419528:27425391,27419532:27424857,27419536:27425201,27419540:27424422,27419542:27423960,27419547:27423186,27419550:27423341,27419555:27422795,27419559:27422027,27419562:27421572,27419566:27420858,27419571:27421246,27419574:27420392,27419603:27419899,27419605:27420199,27421653:27422499,27424392:27424789,27457115:27457814,27458266:27460848,27458269:27461434,27458272:27460809,27458275:27460534,27458277:27459687,27458280:27459846,27458282:27460191,27458284:27459386,27458286:27459351,27458288:27459055,27458290:27459247,27458292:27458921,27458294:27458874,27458296:27458773,27458298:27458804,27458300:27458497,27458302:27458716,27458304:27458415,27458306:27458450,27458308:27458362,27458309:27458321,27459575:27460066,27462142:27462717,27530982:27542749,27530986:27543210,27530989:27543504,27530993:27543737,27530996:27543940,27531000:27544161,27531004:27578291,27531009:27544501,27531013:2754464', 'assoc_mat': '27414921:carton:4230:27418492,27419508:carton:4230:27427131,27419512:carton:4230:27427398,27419515:carton:4230:27426762,27419517:carton:4230:27425905,27419520:carton:4230:27426204,27419524:carton:4230:27425749,27419528:carton:4230:27425391,27419532:carton:4230:27424857,27419536:carton:4230:27425201,27419540:carton:4230:27424422,27419542:carton:4230:27423960,27419547:carton:4230:27423186,27419550:carton:4230:27423341,27419555:carton:4230:27422795,27419559:carton:4230:27422027,27419562:carton:4230:27421572,27419566:carton:4230:27420858,27419571:carton:4230:27421246,27419574:carton:4230:27420392,27419603:carton:4230:27419899,27419605:carton:4230:27420199,27421653:carton:4230:27422499,27424392:carton:4230:27424789,27457115:carton:4230:27457814,27458266:carton:4230:27460848,27458269:carton:4230:27461434,27458272:carton:4230:27460809,27458275:carton:4230:27460534,27458277:carton:4230:27459687,27458280:carton:4230:27459846,27458282:carton:4230:27460191,27458284:carton:4230:27459386,27458286:carton:4230:27459351,2745'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012118017193548133, 'nb_photo': 1897, 'list_port_cont': '27419896,27420384,27420841,27422021,27422493,27422792,27423178,27423962,27424419,27424784,27424851,27425192,27425383,27425907,27426201,27427407,27457807,27458324,27458414,27458448,27458491,27458714,27458761,27458803,27458918,27459238,27459339,27459675,27459833,27460187,27460528,27460850,27461432,27462706,27542745,27543196,27543503,27543742,27543939,27544148,27544503,27544649,27544835,27544951,27545118,27545210,27545498,27545537,27545646,27545881,27545922,27545973,27546413,27546534,27546698,27546844,27546965,27547050,27547283,27548257,27548532,27548656,27549156,27549327,27550083,27550293,27551108,27551921,27552634,27557064,27557113,27557298,27557370,27557602,27558218,27558389,27558875,27559130,27559497,27560126,27560655,27560953,27561309,27561752,27562051,27562492,27563797,27564036,27568532,27569187,27569910,27570421,27570831,27570975,27571113,27571201,27571260,27571407,27571494,27571695,27571733,27571779,27571820,27571894,27571951,27576234,27577225,27578293,27579092,27579114,27580691,27581413,27581641,2758246', 'assoc_port': '27419512:27427407,27419517:27425907,27419520:27426201,27419528:27425383,27419532:27424851,27419536:27425192,27419540:27424419,27419542:27423962,27419547:27423178,27419555:27422792,27419559:27422021,27419566:27420841,27419574:27420384,27419603:27419896,27421653:27422493,27424392:27424784,27457115:27457807,27458266:27460850,27458269:27461432,27458275:27460528,27458277:27459675,27458280:27459833,27458282:27460187,27458286:27459339,27458290:27459238,27458292:27458918,27458296:27458761,27458298:27458803,27458300:27458491,27458302:27458714,27458304:27458414,27458306:27458448,27458309:27458324,27462142:27462706,27530982:27542745,27530986:27543196,27530989:27543503,27530993:27543742,27530996:27543939,27531000:27544148,27531004:27578293,27531009:27544503,27531013:27544649,27531018:27544835,27531022:27544951,27531026:27545118,27531031:27545210,27531036:27545498,27531040:27545537,27531044:27545646,27531055:27545922,27531061:27546413,27531062:27545881,27531068:27546534,27531070:27580691,27531076:27546698,27531077:2754597', 'assoc_mat': '27419512:metal:4230:27427407,27419517:metal:4230:27425907,27419520:metal:4230:27426201,27419528:metal:4230:27425383,27419532:metal:4230:27424851,27419536:metal:4230:27425192,27419540:metal:4230:27424419,27419542:metal:4230:27423962,27419547:metal:4230:27423178,27419555:metal:4230:27422792,27419559:metal:4230:27422021,27419566:metal:4230:27420841,27419574:metal:4230:27420384,27419603:metal:4230:27419896,27421653:metal:4230:27422493,27424392:metal:4230:27424784,27457115:metal:4230:27457807,27458266:metal:4230:27460850,27458269:metal:4230:27461432,27458275:metal:4230:27460528,27458277:metal:4230:27459675,27458280:metal:4230:27459833,27458282:metal:4230:27460187,27458286:metal:4230:27459339,27458290:metal:4230:27459238,27458292:metal:4230:27458918,27458296:metal:4230:27458761,27458298:metal:4230:27458803,27458300:metal:4230:27458491,27458302:metal:4230:27458714,27458304:metal:4230:27458414,27458306:metal:4230:27458448,27458309:metal:4230:27458324,27462142:metal:4230:27462706,27530982:metal:4230:27542745,27530986:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2133115153938636, 'nb_photo': 499364, 'list_port_cont': '27418501,27419901,27420206,27420389,27420850,27421242,27421569,27422024,27422485,27422807,27423170,27423336,27423958,27424428,27424787,27424860,27425199,27425386,27425750,27425903,27426206,27426760,27427129,27427411,27457810,27458317,27458363,27458412,27458449,27458483,27458711,27458768,27458811,27458876,27458926,27459051,27459244,27459341,27459387,27459681,27459841,27460078,27460195,27460533,27460812,27460843,27461431,27462719,27542752,27543207,27543493,27543739,27543938,27544158,27544497,27544640,27544849,27544966,27545123,27545219,27545486,27545533,27545652,27545803,27545878,27545923,27545976,27546046,27546202,27546423,27546524,27546697,27546847,27546975,27547054,27547236,27547285,27547827,27547885,27548271,27548544,27548669,27549168,27549330,27550087,27550297,27551117,27551917,27552635,27557067,27557115,27557258,27557304,27557375,27557606,27557660,27558232,27558395,27558879,27559133,27559503,27560133,27560663,27560961,27561322,27561754,27562066,27562495,27563172,27563806,27564029,27568541,27569190,2756989', 'assoc_port': '27414921:27418501,27419508:27427129,27419512:27427411,27419515:27426760,27419517:27425903,27419520:27426206,27419524:27425750,27419528:27425386,27419532:27424860,27419536:27425199,27419540:27424428,27419542:27423958,27419547:27423170,27419550:27423336,27419555:27422807,27419559:27422024,27419562:27421569,27419566:27420850,27419571:27421242,27419574:27420389,27419603:27419901,27419605:27420206,27421653:27422485,27424392:27424787,27457115:27457810,27458266:27460843,27458269:27461431,27458272:27460812,27458275:27460533,27458277:27459681,27458280:27459841,27458282:27460195,27458284:27459387,27458286:27459341,27458288:27459051,27458290:27459244,27458292:27458926,27458294:27458876,27458296:27458768,27458298:27458811,27458300:27458483,27458302:27458711,27458304:27458412,27458306:27458449,27458308:27458363,27458309:27458317,27459575:27460078,27462142:27462719,27530982:27542752,27530986:27543207,27530989:27543493,27530993:27543739,27530996:27543938,27531000:27544158,27531004:27578279,27531009:27544497,27531013:2754464', 'assoc_mat': '27414921:papier:4230:27418501,27419508:papier:4230:27427129,27419512:papier:4230:27427411,27419515:papier:4230:27426760,27419517:papier:4230:27425903,27419520:papier:4230:27426206,27419524:papier:4230:27425750,27419528:papier:4230:27425386,27419532:papier:4230:27424860,27419536:papier:4230:27425199,27419540:papier:4230:27424428,27419542:papier:4230:27423958,27419547:papier:4230:27423170,27419550:papier:4230:27423336,27419555:papier:4230:27422807,27419559:papier:4230:27422024,27419562:papier:4230:27421569,27419566:papier:4230:27420850,27419571:papier:4230:27421242,27419574:papier:4230:27420389,27419603:papier:4230:27419901,27419605:papier:4230:27420206,27421653:papier:4230:27422485,27424392:papier:4230:27424787,27457115:papier:4230:27457810,27458266:papier:4230:27460843,27458269:papier:4230:27461431,27458272:papier:4230:27460812,27458275:papier:4230:27460533,27458277:papier:4230:27459681,27458280:papier:4230:27459841,27458282:papier:4230:27460195,27458284:papier:4230:27459387,27458286:papier:4230:27459341,2745'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004383875942070988, 'nb_photo': 3277, 'list_port_cont': '27418500,27419892,27420382,27420846,27421236,27421575,27422030,27422498,27422797,27423177,27423340,27423963,27424432,27424785,27424859,27425198,27425381,27425746,27425898,27427135,27427400,27457806,27458328,27458369,27458419,27458462,27458492,27458712,27458774,27458814,27458881,27458924,27459057,27459246,27459381,27459690,27459835,27460077,27460526,27460796,27461438,27462718,27542750,27543202,27543495,27543748,27543942,27544151,27544510,27544962,27545126,27545217,27545497,27545538,27545656,27545808,27545885,27546192,27546421,27546536,27546973,27547044,27547234,27547287,27547816,27547880,27548264,27548539,27548671,27549159,27549328,27550082,27550295,27551118,27551919,27552624,27557069,27557121,27557262,27557313,27557384,27557608,27557661,27558231,27558387,27558880,27559139,27559495,27560131,27560665,27560960,27561313,27561764,27562064,27562498,27563163,27563809,27564034,27568536,27569198,27569912,27570419,27570832,27570974,27571118,27571206,27571269,27571505,27571545,27571706,27571739,27571796,27571826,2757190', 'assoc_port': '27414921:27418500,27419508:27427135,27419512:27427400,27419517:27425898,27419524:27425746,27419528:27425381,27419532:27424859,27419536:27425198,27419540:27424432,27419542:27423963,27419547:27423177,27419550:27423340,27419555:27422797,27419559:27422030,27419562:27421575,27419566:27420846,27419571:27421236,27419574:27420382,27419603:27419892,27421653:27422498,27424392:27424785,27457115:27457806,27458269:27461438,27458272:27460796,27458275:27460526,27458277:27459690,27458280:27459835,27458284:27459381,27458288:27459057,27458290:27459246,27458292:27458924,27458294:27458881,27458296:27458774,27458298:27458814,27458300:27458492,27458302:27458712,27458304:27458419,27458306:27458462,27458308:27458369,27458309:27458328,27459575:27460077,27462142:27462718,27530982:27542750,27530986:27543202,27530989:27543495,27530993:27543748,27530996:27543942,27531000:27544151,27531004:27578285,27531009:27544510,27531022:27544962,27531026:27545126,27531031:27545217,27531036:27545497,27531040:27545538,27531044:27545656,27531049:2754580', 'assoc_mat': '27414921:pehd:4230:27418500,27419508:pehd:4230:27427135,27419512:pehd:4230:27427400,27419517:pehd:4230:27425898,27419524:pehd:4230:27425746,27419528:pehd:4230:27425381,27419532:pehd:4230:27424859,27419536:pehd:4230:27425198,27419540:pehd:4230:27424432,27419542:pehd:4230:27423963,27419547:pehd:4230:27423177,27419550:pehd:4230:27423340,27419555:pehd:4230:27422797,27419559:pehd:4230:27422030,27419562:pehd:4230:27421575,27419566:pehd:4230:27420846,27419571:pehd:4230:27421236,27419574:pehd:4230:27420382,27419603:pehd:4230:27419892,27421653:pehd:4230:27422498,27424392:pehd:4230:27424785,27457115:pehd:4230:27457806,27458269:pehd:4230:27461438,27458272:pehd:4230:27460796,27458275:pehd:4230:27460526,27458277:pehd:4230:27459690,27458280:pehd:4230:27459835,27458284:pehd:4230:27459381,27458288:pehd:4230:27459057,27458290:pehd:4230:27459246,27458292:pehd:4230:27458924,27458294:pehd:4230:27458881,27458296:pehd:4230:27458774,27458298:pehd:4230:27458814,27458300:pehd:4230:27458492,27458302:pehd:4230:27458712,27458304:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01093408779020654, 'nb_photo': 21967, 'list_port_cont': '27418497,27419903,27420196,27420381,27420857,27421244,27421574,27422033,27422494,27422800,27423180,27423345,27423961,27424435,27424793,27424853,27425190,27425389,27425735,27425900,27426199,27426756,27427139,27427405,27457815,27458326,27458356,27458424,27458463,27458498,27458709,27458776,27458810,27458868,27458916,27459054,27459252,27459349,27459380,27459692,27459842,27460072,27460199,27460535,27460805,27460855,27461437,27462711,27542748,27543211,27543496,27543744,27543944,27544162,27544508,27544644,27544851,27544968,27545124,27545215,27545491,27545539,27545650,27545800,27545887,27545910,27545969,27546051,27546203,27546416,27546531,27546707,27546848,27546974,27547046,27547232,27547289,27547822,27547881,27548262,27548535,27548670,27549167,27549336,27550088,27550290,27551113,27551916,27552630,27557068,27557120,27557249,27557307,27557379,27557605,27557659,27558227,27558391,27558869,27559143,27559499,27560132,27560659,27560950,27561325,27561765,27562065,27562491,27563169,27563810,27564038,27568538,27569195,2756990', 'assoc_port': '27414921:27418497,27419508:27427139,27419512:27427405,27419515:27426756,27419517:27425900,27419520:27426199,27419524:27425735,27419528:27425389,27419532:27424853,27419536:27425190,27419540:27424435,27419542:27423961,27419547:27423180,27419550:27423345,27419555:27422800,27419559:27422033,27419562:27421574,27419566:27420857,27419571:27421244,27419574:27420381,27419603:27419903,27419605:27420196,27421653:27422494,27424392:27424793,27457115:27457815,27458266:27460855,27458269:27461437,27458272:27460805,27458275:27460535,27458277:27459692,27458280:27459842,27458282:27460199,27458284:27459380,27458286:27459349,27458288:27459054,27458290:27459252,27458292:27458916,27458294:27458868,27458296:27458776,27458298:27458810,27458300:27458498,27458302:27458709,27458304:27458424,27458306:27458463,27458308:27458356,27458309:27458326,27459575:27460072,27462142:27462711,27530982:27542748,27530986:27543211,27530989:27543496,27530993:27543744,27530996:27543944,27531000:27544162,27531004:27578287,27531009:27544508,27531013:2754464', 'assoc_mat': '27414921:pet_clair:4230:27418497,27419508:pet_clair:4230:27427139,27419512:pet_clair:4230:27427405,27419515:pet_clair:4230:27426756,27419517:pet_clair:4230:27425900,27419520:pet_clair:4230:27426199,27419524:pet_clair:4230:27425735,27419528:pet_clair:4230:27425389,27419532:pet_clair:4230:27424853,27419536:pet_clair:4230:27425190,27419540:pet_clair:4230:27424435,27419542:pet_clair:4230:27423961,27419547:pet_clair:4230:27423180,27419550:pet_clair:4230:27423345,27419555:pet_clair:4230:27422800,27419559:pet_clair:4230:27422033,27419562:pet_clair:4230:27421574,27419566:pet_clair:4230:27420857,27419571:pet_clair:4230:27421244,27419574:pet_clair:4230:27420381,27419603:pet_clair:4230:27419903,27419605:pet_clair:4230:27420196,27421653:pet_clair:4230:27422494,27424392:pet_clair:4230:27424793,27457115:pet_clair:4230:27457815,27458266:pet_clair:4230:27460855,27458269:pet_clair:4230:27461437,27458272:pet_clair:4230:27460805,27458275:pet_clair:4230:27460535,27458277:pet_clair:4230:27459692,27458280:pet_clair:4230:27459842,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002487042744103774, 'nb_photo': 1235, 'list_port_cont': '27418502,27419904,27420205,27420854,27421245,27421578,27422032,27422489,27422805,27423185,27423338,27424423,27424790,27425390,27425747,27425909,27426751,27457809,27458325,27458359,27458408,27458461,27458490,27458710,27458775,27458807,27458919,27459249,27459353,27459385,27459685,27459845,27460076,27460200,27460527,27460811,27460845,27461427,27462715,27542754,27543498,27543747,27544163,27544504,27545113,27545493,27545658,27545799,27546041,27546199,27546415,27546530,27546849,27546969,27547240,27547286,27547823,27547875,27548270,27548543,27548658,27549163,27550089,27551911,27552632,27557072,27557119,27557252,27557315,27557383,27557615,27557663,27558230,27558878,27559134,27559498,27560128,27560660,27560958,27561323,27561766,27562060,27562501,27563164,27563804,27568542,27569909,27570430,27570840,27570979,27571110,27571196,27571271,27571372,27571498,27571540,27571708,27571743,27571790,27571831,27571902,27576233,27577229,27578292,27579104,27580703,27582474,27584225,27584335,27584793,27585294,27587228,27587507,2758798', 'assoc_port': '27414921:27418502,27419515:27426751,27419517:27425909,27419524:27425747,27419528:27425390,27419540:27424423,27419547:27423185,27419550:27423338,27419555:27422805,27419559:27422032,27419562:27421578,27419566:27420854,27419571:27421245,27419603:27419904,27419605:27420205,27421653:27422489,27424392:27424790,27457115:27457809,27458266:27460845,27458269:27461427,27458272:27460811,27458275:27460527,27458277:27459685,27458280:27459845,27458282:27460200,27458284:27459385,27458286:27459353,27458290:27459249,27458292:27458919,27458296:27458775,27458298:27458807,27458300:27458490,27458302:27458710,27458304:27458408,27458306:27458461,27458308:27458359,27458309:27458325,27459575:27460076,27462142:27462715,27530982:27542754,27530989:27543498,27530993:27543747,27531000:27544163,27531004:27578292,27531009:27544504,27531026:27545113,27531036:27545493,27531044:27545658,27531049:27545799,27531061:27546415,27531068:27546530,27531070:27580703,27531084:27546849,27531085:27546041,27531093:27590279,27531100:27546969,27531101:2754619', 'assoc_mat': '27414921:pet_fonce:4230:27418502,27419515:pet_fonce:4230:27426751,27419517:pet_fonce:4230:27425909,27419524:pet_fonce:4230:27425747,27419528:pet_fonce:4230:27425390,27419540:pet_fonce:4230:27424423,27419547:pet_fonce:4230:27423185,27419550:pet_fonce:4230:27423338,27419555:pet_fonce:4230:27422805,27419559:pet_fonce:4230:27422032,27419562:pet_fonce:4230:27421578,27419566:pet_fonce:4230:27420854,27419571:pet_fonce:4230:27421245,27419603:pet_fonce:4230:27419904,27419605:pet_fonce:4230:27420205,27421653:pet_fonce:4230:27422489,27424392:pet_fonce:4230:27424790,27457115:pet_fonce:4230:27457809,27458266:pet_fonce:4230:27460845,27458269:pet_fonce:4230:27461427,27458272:pet_fonce:4230:27460811,27458275:pet_fonce:4230:27460527,27458277:pet_fonce:4230:27459685,27458280:pet_fonce:4230:27459845,27458282:pet_fonce:4230:27460200,27458284:pet_fonce:4230:27459385,27458286:pet_fonce:4230:27459353,27458290:pet_fonce:4230:27459249,27458292:pet_fonce:4230:27458919,27458296:pet_fonce:4230:27458775,27458298:pet_fonce:4230:27458807,2'}), 'main_stat': {'nb_photos': 1982}, 'velours_link': 'https://www.fotonower.com/velours/30124973,30124974,30124975,30124976,30124978,30124979,30124980?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-10', 0.7192155042268846),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_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.49%', 20990], 'carton': ['carton', '5.52%', 104677], 'metal': ['metal', '0.12%', 1897], 'papier': ['papier', '21.33%', 499364], 'pehd': ['pehd', '0.44%', 3277], 'pet_clair': ['pet_clair', '1.09%', 21967], 'pet_fonce': ['pet_fonce', '0.25%', 1235]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_10_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.59user 3.16system 0:30.34elapsed 18%CPU (0avgtext+0avgdata 184020maxresident)k 6440inputs+408outputs (16major+48594minor)pagefaults 0swaps