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-03' -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-03 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (5, 31) 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-03-01" AND ded.date <= "2025-03-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 (1641154,1641379,1643792,1646909,1650539,1653390,1656907,1660067,1661845,1664134,1668385,1671932,1674573,1678158,1679831,1680087,1681711,1682884,1684044,1685098,1687706,1689508,1690085,1693211,1696704,1699462,1703442,1707142,1709522,1710025,1713041) 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.01565037234336822, 'nb_photo': 20670, 'list_port_cont': '20944335,20945208,20945867,20946181,20946282,20946988,20947181,20947572,20947864,20948430,20948750,20949064,20949288,20949568,20949821,20950153,20950876,20951153,20951676,20952191,20952269,20952596,20953091,20953566,20954252,20954327,20954561,20954822,20955021,20955143,20955354,20955425,20955606,20955668,20955852,20955956,20956198,20956347,20956465,20956596,20956756,20956829,20956998,20957173,20957301,20957391,20957580,20992686,20994183,20994277,20994460,20994561,20994727,20994944,20995130,20995400,20995469,20995527,20995998,20996119,20996219,20996322,20996812,20996852,20997031,20997352,20997428,20997531,20998018,20998167,20999183,21025940,21026111,21032059,21033462,21052397,21052855,21053535,21055025,21055458,21057440,21058492,21078473,21078719,21079010,21079065,21079486,21079922,21080263,21080446,21080793,21081022,21081438,21081670,21087415,21089205,21103722,21104273,21105144,21106893,21107578,21108553,21108991,21109568,21110341,21110453,21111676,21111742,21112107,21112648,21113664,21114232,21114937,2111534', 'assoc_port': '20943975:20946181,20943976:20944335,20944756:20945208,20945561:20945867,20946202:20946282,20946648:20946988,20947070:20947181,20947411:20947572,20947731:20947864,20948247:20948430,20948675:20948750,20949001:20949064,20949180:20949288,20949475:20949568,20949742:20949821,20950039:20950153,20950382:20952191,20950735:20950876,20951082:20951153,20951512:20951676,20952014:20952269,20952419:20952596,20952778:20953091,20953465:20953566,20954160:20954327,20954161:20954252,20954514:20954561,20954798:20954822,20954933:20955021,20955120:20955143,20955264:20955354,20955413:20955425,20955517:20955606,20955657:20955668,20955762:20955852,20955903:20955956,20956148:20956198,20956254:20956347,20956406:20956465,20956552:20956596,20956664:20956756,20956813:20956829,20956952:20956998,20957086:20957173,20957251:20957301,20957384:20957391,20957518:20957580,20979333:20992686,20993497:20998018,20993498:20999183,20993500:20998167,20993502:20997531,20993504:20997428,20993506:20997352,20993508:20997031,20993510:20996812,20993512:2099621', 'assoc_mat': '20943975:autre:4230:20946181,20943976:autre:4230:20944335,20944756:autre:4230:20945208,20945561:autre:4230:20945867,20946202:autre:4230:20946282,20946648:autre:4230:20946988,20947070:autre:4230:20947181,20947411:autre:4230:20947572,20947731:autre:4230:20947864,20948247:autre:4230:20948430,20948675:autre:4230:20948750,20949001:autre:4230:20949064,20949180:autre:4230:20949288,20949475:autre:4230:20949568,20949742:autre:4230:20949821,20950039:autre:4230:20950153,20950382:autre:4230:20952191,20950735:autre:4230:20950876,20951082:autre:4230:20951153,20951512:autre:4230:20951676,20952014:autre:4230:20952269,20952419:autre:4230:20952596,20952778:autre:4230:20953091,20953465:autre:4230:20953566,20954160:autre:4230:20954327,20954161:autre:4230:20954252,20954514:autre:4230:20954561,20954798:autre:4230:20954822,20954933:autre:4230:20955021,20955120:autre:4230:20955143,20955264:autre:4230:20955354,20955413:autre:4230:20955425,20955517:autre:4230:20955606,20955657:autre:4230:20955668,20955762:autre:4230:20955852,20955903:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05264432026709546, 'nb_photo': 93570, 'list_port_cont': '20944345,20945195,20945873,20946167,20946285,20946998,20947179,20947578,20947861,20948425,20948753,20949054,20949281,20949575,20949817,20950155,20950877,20951161,20951683,20952194,20952268,20952587,20953096,20953553,20954259,20954328,20954562,20954823,20955033,20955139,20955366,20955426,20955607,20955669,20955857,20955961,20956208,20956353,20956467,20956608,20956755,20956821,20957003,20957176,20957308,20957397,20957574,20992682,20994186,20994287,20994467,20994567,20994735,20994951,20995129,20995398,20995460,20995533,20995997,20996135,20996215,20996324,20996815,20996855,20997041,20997356,20997434,20997532,20998027,20998182,20999185,21025933,21026119,21032073,21033466,21052394,21052849,21053530,21055016,21055460,21057447,21058497,21078483,21078734,21079014,21079069,21079477,21079925,21080267,21080460,21080807,21081026,21081454,21081668,21087417,21089203,21103727,21104264,21105150,21106905,21107588,21108567,21108984,21109567,21110339,21110465,21111687,21111737,21112114,21112656,21113660,21114236,21114934,2111533', 'assoc_port': '20943975:20946167,20943976:20944345,20944756:20945195,20945561:20945873,20946202:20946285,20946648:20946998,20947070:20947179,20947411:20947578,20947731:20947861,20948247:20948425,20948675:20948753,20949001:20949054,20949180:20949281,20949475:20949575,20949742:20949817,20950039:20950155,20950382:20952194,20950735:20950877,20951082:20951161,20951512:20951683,20952014:20952268,20952419:20952587,20952778:20953096,20953465:20953553,20954160:20954328,20954161:20954259,20954514:20954562,20954798:20954823,20954933:20955033,20955120:20955139,20955264:20955366,20955413:20955426,20955517:20955607,20955657:20955669,20955762:20955857,20955903:20955961,20956148:20956208,20956254:20956353,20956406:20956467,20956552:20956608,20956664:20956755,20956813:20956821,20956952:20957003,20957086:20957176,20957251:20957308,20957384:20957397,20957518:20957574,20979333:20992682,20993497:20998027,20993498:20999185,20993500:20998182,20993502:20997532,20993504:20997434,20993506:20997356,20993508:20997041,20993510:20996815,20993512:2099621', 'assoc_mat': '20943975:carton:4230:20946167,20943976:carton:4230:20944345,20944756:carton:4230:20945195,20945561:carton:4230:20945873,20946202:carton:4230:20946285,20946648:carton:4230:20946998,20947070:carton:4230:20947179,20947411:carton:4230:20947578,20947731:carton:4230:20947861,20948247:carton:4230:20948425,20948675:carton:4230:20948753,20949001:carton:4230:20949054,20949180:carton:4230:20949281,20949475:carton:4230:20949575,20949742:carton:4230:20949817,20950039:carton:4230:20950155,20950382:carton:4230:20952194,20950735:carton:4230:20950877,20951082:carton:4230:20951161,20951512:carton:4230:20951683,20952014:carton:4230:20952268,20952419:carton:4230:20952587,20952778:carton:4230:20953096,20953465:carton:4230:20953553,20954160:carton:4230:20954328,20954161:carton:4230:20954259,20954514:carton:4230:20954562,20954798:carton:4230:20954823,20954933:carton:4230:20955033,20955120:carton:4230:20955139,20955264:carton:4230:20955366,20955413:carton:4230:20955426,20955517:carton:4230:20955607,20955657:carton:4230:20955669,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011995744372984287, 'nb_photo': 1703, 'list_port_cont': '20944340,20945193,20945878,20946168,20946284,20946995,20947857,20948417,20948749,20949061,20949279,20949569,20950147,20951669,20952201,20952267,20952580,20953086,20953560,20954256,20954330,20954566,20955358,20955420,20955674,20955855,20955966,20956205,20956337,20956601,20956763,20956825,20957181,20957399,20957573,20992675,20994459,20994559,20994945,20995399,20995468,20995529,20996132,20996317,20996856,20997346,20997420,20997516,20998168,20999177,21025938,21026106,21032063,21052387,21052848,21053524,21055012,21055464,21057445,21058487,21079006,21080261,21080445,21080803,21081024,21081439,21081664,21087407,21104271,21106898,21107587,21108569,21108983,21109576,21110455,21111677,21111744,21112102,21112658,21113661,21114237,21114935,21115331,21115705,21115976,21116364,21121388,21128630,21129664,21130471,21162419,21163907,21166069,21166243,21166461,21166510,21166544,21166739,21166873,21167155,21167259,21167361,21167486,21167838,21167977,21168096,21168347,21168488,21168541,21168770,21168941,21169059,21169108,2116923', 'assoc_port': '20943975:20946168,20943976:20944340,20944756:20945193,20945561:20945878,20946202:20946284,20946648:20946995,20947731:20947857,20948247:20948417,20948675:20948749,20949001:20949061,20949180:20949279,20949475:20949569,20950039:20950147,20950382:20952201,20951512:20951669,20952014:20952267,20952419:20952580,20952778:20953086,20953465:20953560,20954160:20954330,20954161:20954256,20954514:20954566,20955264:20955358,20955413:20955420,20955657:20955674,20955762:20955855,20955903:20955966,20956148:20956205,20956254:20956337,20956552:20956601,20956664:20956763,20956813:20956825,20957086:20957181,20957384:20957399,20957518:20957573,20979333:20992675,20993498:20999177,20993500:20998168,20993502:20997516,20993504:20997420,20993506:20997346,20993514:20996317,20993516:20996856,20993519:20995529,20993523:20996132,20993525:20994945,20993526:20995468,20993527:20995399,20993528:20994459,20993530:20994559,21009641:21026106,21025092:21025938,21027585:21079006,21027591:21121388,21027595:21080261,21027597:21080445,21027599:2108080', 'assoc_mat': '20943975:metal:4230:20946168,20943976:metal:4230:20944340,20944756:metal:4230:20945193,20945561:metal:4230:20945878,20946202:metal:4230:20946284,20946648:metal:4230:20946995,20947731:metal:4230:20947857,20948247:metal:4230:20948417,20948675:metal:4230:20948749,20949001:metal:4230:20949061,20949180:metal:4230:20949279,20949475:metal:4230:20949569,20950039:metal:4230:20950147,20950382:metal:4230:20952201,20951512:metal:4230:20951669,20952014:metal:4230:20952267,20952419:metal:4230:20952580,20952778:metal:4230:20953086,20953465:metal:4230:20953560,20954160:metal:4230:20954330,20954161:metal:4230:20954256,20954514:metal:4230:20954566,20955264:metal:4230:20955358,20955413:metal:4230:20955420,20955657:metal:4230:20955674,20955762:metal:4230:20955855,20955903:metal:4230:20955966,20956148:metal:4230:20956205,20956254:metal:4230:20956337,20956552:metal:4230:20956601,20956664:metal:4230:20956763,20956813:metal:4230:20956825,20957086:metal:4230:20957181,20957384:metal:4230:20957399,20957518:metal:4230:20957573,20979333:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2062599065700527, 'nb_photo': 423052, 'list_port_cont': '20944348,20945209,20945872,20946177,20946277,20946993,20947180,20947582,20947865,20948429,20948755,20949058,20949277,20949574,20949822,20950159,20950870,20951165,20951681,20952190,20952261,20952584,20953100,20953564,20954262,20954338,20954573,20954820,20955029,20955132,20955368,20955419,20955602,20955676,20955858,20955955,20956199,20956348,20956455,20956612,20956761,20956820,20957005,20957175,20957307,20957405,20957579,20992684,20994189,20994286,20994466,20994570,20994737,20994939,20995123,20995393,20995461,20995537,20996007,20996131,20996218,20996320,20996818,20996847,20997042,20997355,20997432,20997527,20998015,20998179,20999189,21025942,21026120,21032064,21033458,21052398,21052847,21053534,21055027,21055465,21057434,21058503,21078481,21078729,21079019,21079071,21079484,21079923,21080272,21080456,21080796,21081029,21081452,21081655,21087420,21089202,21103725,21104276,21105147,21106907,21107584,21108563,21108989,21109574,21110342,21110464,21111683,21111747,21112104,21112659,21113652,21114231,21114939,2111533', 'assoc_port': '20943975:20946177,20943976:20944348,20944756:20945209,20945561:20945872,20946202:20946277,20946648:20946993,20947070:20947180,20947411:20947582,20947731:20947865,20948247:20948429,20948675:20948755,20949001:20949058,20949180:20949277,20949475:20949574,20949742:20949822,20950039:20950159,20950382:20952190,20950735:20950870,20951082:20951165,20951512:20951681,20952014:20952261,20952419:20952584,20952778:20953100,20953465:20953564,20954160:20954338,20954161:20954262,20954514:20954573,20954798:20954820,20954933:20955029,20955120:20955132,20955264:20955368,20955413:20955419,20955517:20955602,20955657:20955676,20955762:20955858,20955903:20955955,20956148:20956199,20956254:20956348,20956406:20956455,20956552:20956612,20956664:20956761,20956813:20956820,20956952:20957005,20957086:20957175,20957251:20957307,20957384:20957405,20957518:20957579,20979333:20992684,20993497:20998015,20993498:20999189,20993500:20998179,20993502:20997527,20993504:20997432,20993506:20997355,20993508:20997042,20993510:20996818,20993512:2099621', 'assoc_mat': '20943975:papier:4230:20946177,20943976:papier:4230:20944348,20944756:papier:4230:20945209,20945561:papier:4230:20945872,20946202:papier:4230:20946277,20946648:papier:4230:20946993,20947070:papier:4230:20947180,20947411:papier:4230:20947582,20947731:papier:4230:20947865,20948247:papier:4230:20948429,20948675:papier:4230:20948755,20949001:papier:4230:20949058,20949180:papier:4230:20949277,20949475:papier:4230:20949574,20949742:papier:4230:20949822,20950039:papier:4230:20950159,20950382:papier:4230:20952190,20950735:papier:4230:20950870,20951082:papier:4230:20951165,20951512:papier:4230:20951681,20952014:papier:4230:20952261,20952419:papier:4230:20952584,20952778:papier:4230:20953100,20953465:papier:4230:20953564,20954160:papier:4230:20954338,20954161:papier:4230:20954262,20954514:papier:4230:20954573,20954798:papier:4230:20954820,20954933:papier:4230:20955029,20955120:papier:4230:20955132,20955264:papier:4230:20955368,20955413:papier:4230:20955419,20955517:papier:4230:20955602,20955657:papier:4230:20955676,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0045914755933246145, 'nb_photo': 2731, 'list_port_cont': '20944350,20945204,20945870,20946182,20946283,20947002,20947581,20947870,20948419,20948764,20949063,20949286,20949573,20949818,20950152,20950867,20951168,20951678,20952197,20952271,20952595,20953093,20953561,20954329,20955035,20955359,20955424,20955848,20955965,20956204,20956350,20956461,20956753,20956833,20957183,20957305,20957567,20992673,20994573,20994942,20995386,20995471,20995535,20996134,20996319,20996858,20997357,21025943,21026116,21032074,21052396,21052857,21055020,21055463,21057448,21058499,21078733,21079016,21080265,21080808,21081455,21081658,21087422,21089206,21103729,21104274,21105141,21106906,21107586,21108559,21108979,21109579,21110345,21110460,21111672,21111746,21112113,21112660,21113665,21114936,21115343,21115487,21115713,21116367,21121387,21128627,21129654,21130479,21162429,21163908,21165891,21166084,21166245,21166458,21166504,21166550,21166733,21166877,21167163,21167364,21167494,21167840,21167989,21168091,21168335,21168544,21168776,21168846,21168952,21169061,21169096,21169233,21169987,2117018', 'assoc_port': '20943975:20946182,20943976:20944350,20944756:20945204,20945561:20945870,20946202:20946283,20946648:20947002,20947411:20947581,20947731:20947870,20948247:20948419,20948675:20948764,20949001:20949063,20949180:20949286,20949475:20949573,20949742:20949818,20950039:20950152,20950382:20952197,20950735:20950867,20951082:20951168,20951512:20951678,20952014:20952271,20952419:20952595,20952778:20953093,20953465:20953561,20954160:20954329,20954933:20955035,20955264:20955359,20955413:20955424,20955762:20955848,20955903:20955965,20956148:20956204,20956254:20956350,20956406:20956461,20956664:20956753,20956813:20956833,20957086:20957183,20957251:20957305,20957518:20957567,20979333:20992673,20993506:20997357,20993514:20996319,20993516:20996858,20993519:20995535,20993523:20996134,20993525:20994942,20993526:20995471,20993527:20995386,20993530:20994573,21009641:21026116,21025092:21025943,21027583:21078733,21027585:21079016,21027591:21121387,21027595:21080265,21027599:21080808,21027603:21081455,21027605:21081658,21027607:2105546', 'assoc_mat': '20943975:pehd:4230:20946182,20943976:pehd:4230:20944350,20944756:pehd:4230:20945204,20945561:pehd:4230:20945870,20946202:pehd:4230:20946283,20946648:pehd:4230:20947002,20947411:pehd:4230:20947581,20947731:pehd:4230:20947870,20948247:pehd:4230:20948419,20948675:pehd:4230:20948764,20949001:pehd:4230:20949063,20949180:pehd:4230:20949286,20949475:pehd:4230:20949573,20949742:pehd:4230:20949818,20950039:pehd:4230:20950152,20950382:pehd:4230:20952197,20950735:pehd:4230:20950867,20951082:pehd:4230:20951168,20951512:pehd:4230:20951678,20952014:pehd:4230:20952271,20952419:pehd:4230:20952595,20952778:pehd:4230:20953093,20953465:pehd:4230:20953561,20954160:pehd:4230:20954329,20954933:pehd:4230:20955035,20955264:pehd:4230:20955359,20955413:pehd:4230:20955424,20955762:pehd:4230:20955848,20955903:pehd:4230:20955965,20956148:pehd:4230:20956204,20956254:pehd:4230:20956350,20956406:pehd:4230:20956461,20956664:pehd:4230:20956753,20956813:pehd:4230:20956833,20957086:pehd:4230:20957183,20957251:pehd:4230:20957305,20957518:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014956224677621586, 'nb_photo': 24603, 'list_port_cont': '20944341,20945207,20945866,20946176,20946278,20946994,20947184,20947576,20947873,20948432,20948760,20949060,20949287,20949572,20949819,20950157,20950878,20951169,20951674,20952195,20952272,20952597,20953099,20953562,20954260,20954332,20954563,20954818,20955027,20955130,20955367,20955434,20955613,20955667,20955861,20955962,20956209,20956342,20956459,20956603,20956762,20956823,20957010,20957174,20957310,20957406,20957581,20992683,20994188,20994288,20994463,20994572,20994734,20994950,20995126,20995396,20995472,20995539,20996006,20996133,20996216,20996326,20996819,20996853,20997045,20997347,20997431,20997520,20998026,20998177,20999188,21025929,21026118,21032066,21033461,21052393,21052858,21053533,21055021,21055462,21057442,21058500,21078482,21078730,21079018,21079078,21079481,21079928,21080273,21080457,21080805,21081030,21081444,21081663,21087418,21089197,21103719,21104269,21105149,21106904,21107582,21108568,21108980,21109581,21110333,21110467,21111688,21111748,21112111,21112662,21113666,21114240,21114928,2111534', 'assoc_port': '20943975:20946176,20943976:20944341,20944756:20945207,20945561:20945866,20946202:20946278,20946648:20946994,20947070:20947184,20947411:20947576,20947731:20947873,20948247:20948432,20948675:20948760,20949001:20949060,20949180:20949287,20949475:20949572,20949742:20949819,20950039:20950157,20950382:20952195,20950735:20950878,20951082:20951169,20951512:20951674,20952014:20952272,20952419:20952597,20952778:20953099,20953465:20953562,20954160:20954332,20954161:20954260,20954514:20954563,20954798:20954818,20954933:20955027,20955120:20955130,20955264:20955367,20955413:20955434,20955517:20955613,20955657:20955667,20955762:20955861,20955903:20955962,20956148:20956209,20956254:20956342,20956406:20956459,20956552:20956603,20956664:20956762,20956813:20956823,20956952:20957010,20957086:20957174,20957251:20957310,20957384:20957406,20957518:20957581,20979333:20992683,20993497:20998026,20993498:20999188,20993500:20998177,20993502:20997520,20993504:20997431,20993506:20997347,20993508:20997045,20993510:20996819,20993512:2099621', 'assoc_mat': '20943975:pet_clair:4230:20946176,20943976:pet_clair:4230:20944341,20944756:pet_clair:4230:20945207,20945561:pet_clair:4230:20945866,20946202:pet_clair:4230:20946278,20946648:pet_clair:4230:20946994,20947070:pet_clair:4230:20947184,20947411:pet_clair:4230:20947576,20947731:pet_clair:4230:20947873,20948247:pet_clair:4230:20948432,20948675:pet_clair:4230:20948760,20949001:pet_clair:4230:20949060,20949180:pet_clair:4230:20949287,20949475:pet_clair:4230:20949572,20949742:pet_clair:4230:20949819,20950039:pet_clair:4230:20950157,20950382:pet_clair:4230:20952195,20950735:pet_clair:4230:20950878,20951082:pet_clair:4230:20951169,20951512:pet_clair:4230:20951674,20952014:pet_clair:4230:20952272,20952419:pet_clair:4230:20952597,20952778:pet_clair:4230:20953099,20953465:pet_clair:4230:20953562,20954160:pet_clair:4230:20954332,20954161:pet_clair:4230:20954260,20954514:pet_clair:4230:20954563,20954798:pet_clair:4230:20954818,20954933:pet_clair:4230:20955027,20955120:pet_clair:4230:20955130,20955264:pet_clair:4230:20955367,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002962719796122446, 'nb_photo': 1319, 'list_port_cont': '20945205,20946183,20946274,20948427,20948762,20949062,20949565,20949808,20950151,20950873,20951167,20951682,20952198,20952270,20953101,20953554,20954568,20955433,20955599,20955849,20956351,20956462,20956607,20956759,20956832,20957008,20957180,20957398,20994281,20994569,20994728,20994947,20995121,20995473,20996129,20996321,20996848,21026108,21052392,21052856,21057449,21058502,21078477,21079021,21079075,21080268,21080809,21081033,21081451,21081662,21087421,21089201,21103721,21104278,21105143,21106897,21107591,21108560,21108985,21109578,21110347,21111743,21112109,21112652,21113667,21114229,21115987,21116376,21129658,21130480,21163914,21166085,21166255,21166464,21166511,21166881,21167162,21167270,21167353,21167843,21167990,21168339,21168535,21168769,21168940,21169069,21169229,21169996,21173704,21175462,21177487,21180889,21181847,21182807,21184040,21184343,21186345,21187772,21190823,21191704,21192801,21192961,21193410,21193543,21193924,21194139,21213208,21213317,21213432,21213522,21213561,21213660,21213802,2121391', 'assoc_port': '20943975:20946183,20944756:20945205,20946202:20946274,20948247:20948427,20948675:20948762,20949001:20949062,20949475:20949565,20949742:20949808,20950039:20950151,20950382:20952198,20950735:20950873,20951082:20951167,20951512:20951682,20952014:20952270,20952778:20953101,20953465:20953554,20954514:20954568,20955413:20955433,20955517:20955599,20955762:20955849,20956254:20956351,20956406:20956462,20956552:20956607,20956664:20956759,20956813:20956832,20956952:20957008,20957086:20957180,20957384:20957398,20993514:20996321,20993516:20996848,20993523:20996129,20993525:20994947,20993526:20995473,20993529:20994728,20993530:20994569,20994209:20994281,20995011:20995121,21009641:21026108,21027581:21078477,21027585:21079021,21027587:21079075,21027595:21080268,21027599:21080809,21027601:21081033,21027603:21081451,21027605:21081662,21027609:21057449,21027610:21058502,21027614:21052856,21027615:21052392,21084490:21115987,21084491:21116376,21084495:21114229,21084498:21112109,21084499:21112652,21084501:21113667,21084502:2111034', 'assoc_mat': '20943975:pet_fonce:4230:20946183,20944756:pet_fonce:4230:20945205,20946202:pet_fonce:4230:20946274,20948247:pet_fonce:4230:20948427,20948675:pet_fonce:4230:20948762,20949001:pet_fonce:4230:20949062,20949475:pet_fonce:4230:20949565,20949742:pet_fonce:4230:20949808,20950039:pet_fonce:4230:20950151,20950382:pet_fonce:4230:20952198,20950735:pet_fonce:4230:20950873,20951082:pet_fonce:4230:20951167,20951512:pet_fonce:4230:20951682,20952014:pet_fonce:4230:20952270,20952778:pet_fonce:4230:20953101,20953465:pet_fonce:4230:20953554,20954514:pet_fonce:4230:20954568,20955413:pet_fonce:4230:20955433,20955517:pet_fonce:4230:20955599,20955762:pet_fonce:4230:20955849,20956254:pet_fonce:4230:20956351,20956406:pet_fonce:4230:20956462,20956552:pet_fonce:4230:20956607,20956664:pet_fonce:4230:20956759,20956813:pet_fonce:4230:20956832,20956952:pet_fonce:4230:20957008,20957086:pet_fonce:4230:20957180,20957384:pet_fonce:4230:20957398,20993514:pet_fonce:4230:20996321,20993516:pet_fonce:4230:20996848,20993523:pet_fonce:4230:20996129,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(1641154,1641379,1643792,1646909,1650539,1653390,1656907,1660067,1661845,1664134,1668385,1671932,1674573,1678158,1679831,1680087,1681711,1682884,1684044,1685098,1687706,1689508,1690085,1693211,1696704,1699462,1703442,1707142,1709522,1710025,1713041)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124855, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944335,20945208,20945867,20946181,20946282,20946988,20947181,20947572,20947864,20948430,20948750,20949064,20949288,20949568,20949821,20950153,20950876,20951153,20951676,20952191,20952269,20952596,20953091,20953566,20954252,20954327,20954561,20954822,20955021,20955143,20955354,20955425,20955606,20955668,20955852,20955956,20956198,20956347,20956465,20956596,20956756,20956829,20956998,20957173,20957301,20957391,20957580,20992686,20994183,20994277,20994460,20994561,20994727,20994944,20995130,20995400,20995469,20995527,20995998,20996119,20996219,20996322,20996812,20996852,20997031,20997352,20997428,20997531,20998018,20998167,20999183,21025940,21026111,21032059,21033462,21052397,21052855,21053535,21055025,21055458,21057440,21058492,21078473,21078719,21079010,21079065,21079486,21079922,21080263,21080446,21080793,21081022,21081438,21081670,21087415,21089205,21103722,21104273,21105144,21106893,21107578,21108553,21108991,21109568,21110341,21110453,21111676,21111742,21112107,21112648,21113664,21114232,21114937,2111534 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124856, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944345,20945195,20945873,20946167,20946285,20946998,20947179,20947578,20947861,20948425,20948753,20949054,20949281,20949575,20949817,20950155,20950877,20951161,20951683,20952194,20952268,20952587,20953096,20953553,20954259,20954328,20954562,20954823,20955033,20955139,20955366,20955426,20955607,20955669,20955857,20955961,20956208,20956353,20956467,20956608,20956755,20956821,20957003,20957176,20957308,20957397,20957574,20992682,20994186,20994287,20994467,20994567,20994735,20994951,20995129,20995398,20995460,20995533,20995997,20996135,20996215,20996324,20996815,20996855,20997041,20997356,20997434,20997532,20998027,20998182,20999185,21025933,21026119,21032073,21033466,21052394,21052849,21053530,21055016,21055460,21057447,21058497,21078483,21078734,21079014,21079069,21079477,21079925,21080267,21080460,21080807,21081026,21081454,21081668,21087417,21089203,21103727,21104264,21105150,21106905,21107588,21108567,21108984,21109567,21110339,21110465,21111687,21111737,21112114,21112656,21113660,21114236,21114934,2111533 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124857, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944340,20945193,20945878,20946168,20946284,20946995,20947857,20948417,20948749,20949061,20949279,20949569,20950147,20951669,20952201,20952267,20952580,20953086,20953560,20954256,20954330,20954566,20955358,20955420,20955674,20955855,20955966,20956205,20956337,20956601,20956763,20956825,20957181,20957399,20957573,20992675,20994459,20994559,20994945,20995399,20995468,20995529,20996132,20996317,20996856,20997346,20997420,20997516,20998168,20999177,21025938,21026106,21032063,21052387,21052848,21053524,21055012,21055464,21057445,21058487,21079006,21080261,21080445,21080803,21081024,21081439,21081664,21087407,21104271,21106898,21107587,21108569,21108983,21109576,21110455,21111677,21111744,21112102,21112658,21113661,21114237,21114935,21115331,21115705,21115976,21116364,21121388,21128630,21129664,21130471,21162419,21163907,21166069,21166243,21166461,21166510,21166544,21166739,21166873,21167155,21167259,21167361,21167486,21167838,21167977,21168096,21168347,21168488,21168541,21168770,21168941,21169059,21169108,2116923 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124858, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944348,20945209,20945872,20946177,20946277,20946993,20947180,20947582,20947865,20948429,20948755,20949058,20949277,20949574,20949822,20950159,20950870,20951165,20951681,20952190,20952261,20952584,20953100,20953564,20954262,20954338,20954573,20954820,20955029,20955132,20955368,20955419,20955602,20955676,20955858,20955955,20956199,20956348,20956455,20956612,20956761,20956820,20957005,20957175,20957307,20957405,20957579,20992684,20994189,20994286,20994466,20994570,20994737,20994939,20995123,20995393,20995461,20995537,20996007,20996131,20996218,20996320,20996818,20996847,20997042,20997355,20997432,20997527,20998015,20998179,20999189,21025942,21026120,21032064,21033458,21052398,21052847,21053534,21055027,21055465,21057434,21058503,21078481,21078729,21079019,21079071,21079484,21079923,21080272,21080456,21080796,21081029,21081452,21081655,21087420,21089202,21103725,21104276,21105147,21106907,21107584,21108563,21108989,21109574,21110342,21110464,21111683,21111747,21112104,21112659,21113652,21114231,21114939,2111533 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124859, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944350,20945204,20945870,20946182,20946283,20947002,20947581,20947870,20948419,20948764,20949063,20949286,20949573,20949818,20950152,20950867,20951168,20951678,20952197,20952271,20952595,20953093,20953561,20954329,20955035,20955359,20955424,20955848,20955965,20956204,20956350,20956461,20956753,20956833,20957183,20957305,20957567,20992673,20994573,20994942,20995386,20995471,20995535,20996134,20996319,20996858,20997357,21025943,21026116,21032074,21052396,21052857,21055020,21055463,21057448,21058499,21078733,21079016,21080265,21080808,21081455,21081658,21087422,21089206,21103729,21104274,21105141,21106906,21107586,21108559,21108979,21109579,21110345,21110460,21111672,21111746,21112113,21112660,21113665,21114936,21115343,21115487,21115713,21116367,21121387,21128627,21129654,21130479,21162429,21163908,21165891,21166084,21166245,21166458,21166504,21166550,21166733,21166877,21167163,21167364,21167494,21167840,21167989,21168091,21168335,21168544,21168776,21168846,21168952,21169061,21169096,21169233,21169987,2117018 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124860, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944341,20945207,20945866,20946176,20946278,20946994,20947184,20947576,20947873,20948432,20948760,20949060,20949287,20949572,20949819,20950157,20950878,20951169,20951674,20952195,20952272,20952597,20953099,20953562,20954260,20954332,20954563,20954818,20955027,20955130,20955367,20955434,20955613,20955667,20955861,20955962,20956209,20956342,20956459,20956603,20956762,20956823,20957010,20957174,20957310,20957406,20957581,20992683,20994188,20994288,20994463,20994572,20994734,20994950,20995126,20995396,20995472,20995539,20996006,20996133,20996216,20996326,20996819,20996853,20997045,20997347,20997431,20997520,20998026,20998177,20999188,21025929,21026118,21032066,21033461,21052393,21052858,21053533,21055021,21055462,21057442,21058500,21078482,21078730,21079018,21079078,21079481,21079928,21080273,21080457,21080805,21081030,21081444,21081663,21087418,21089197,21103719,21104269,21105149,21106904,21107582,21108568,21108980,21109581,21110333,21110467,21111688,21111748,21112111,21112662,21113666,21114240,21114928,2111534 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124861, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20945205,20946183,20946274,20948427,20948762,20949062,20949565,20949808,20950151,20950873,20951167,20951682,20952198,20952270,20953101,20953554,20954568,20955433,20955599,20955849,20956351,20956462,20956607,20956759,20956832,20957008,20957180,20957398,20994281,20994569,20994728,20994947,20995121,20995473,20996129,20996321,20996848,21026108,21052392,21052856,21057449,21058502,21078477,21079021,21079075,21080268,21080809,21081033,21081451,21081662,21087421,21089201,21103721,21104278,21105143,21106897,21107591,21108560,21108985,21109578,21110347,21111743,21112109,21112652,21113667,21114229,21115987,21116376,21129658,21130480,21163914,21166085,21166255,21166464,21166511,21166881,21167162,21167270,21167353,21167843,21167990,21168339,21168535,21168769,21168940,21169069,21169229,21169996,21173704,21175462,21177487,21180889,21181847,21182807,21184040,21184343,21186345,21187772,21190823,21191704,21192801,21192961,21193410,21193543,21193924,21194139,21213208,21213317,21213432,21213522,21213561,21213660,21213802,2121391 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124855,30124856,30124857,30124858,30124859,30124860,30124861?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce Fonction SLA_MENSUEL nb_day : (5, 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 : 03 mtr_id : dashboard_places : SCCU_cam6 date : 2025-03 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-03%') and created_at like '%2025-03%'))); nb_day : (5, 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) = 03 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), 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) = 03 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%032025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-03-01 : dt_date_just_month_year : 2025-03-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "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-03-01" AND ded.date <= "2025-03-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 (1641154,1641379,1643792,1646909,1650539,1653390,1656907,1660067,1661845,1664134,1668385,1671932,1674573,1678158,1679831,1680087,1681711,1682884,1684044,1685098,1687706,1689508,1690085,1693211,1696704,1699462,1703442,1707142,1709522,1710025,1713041) 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.01565037234336822, 'nb_photo': 20670, 'list_port_cont': '20944335,20945208,20945867,20946181,20946282,20946988,20947181,20947572,20947864,20948430,20948750,20949064,20949288,20949568,20949821,20950153,20950876,20951153,20951676,20952191,20952269,20952596,20953091,20953566,20954252,20954327,20954561,20954822,20955021,20955143,20955354,20955425,20955606,20955668,20955852,20955956,20956198,20956347,20956465,20956596,20956756,20956829,20956998,20957173,20957301,20957391,20957580,20992686,20994183,20994277,20994460,20994561,20994727,20994944,20995130,20995400,20995469,20995527,20995998,20996119,20996219,20996322,20996812,20996852,20997031,20997352,20997428,20997531,20998018,20998167,20999183,21025940,21026111,21032059,21033462,21052397,21052855,21053535,21055025,21055458,21057440,21058492,21078473,21078719,21079010,21079065,21079486,21079922,21080263,21080446,21080793,21081022,21081438,21081670,21087415,21089205,21103722,21104273,21105144,21106893,21107578,21108553,21108991,21109568,21110341,21110453,21111676,21111742,21112107,21112648,21113664,21114232,21114937,2111534', 'assoc_port': '20943975:20946181,20943976:20944335,20944756:20945208,20945561:20945867,20946202:20946282,20946648:20946988,20947070:20947181,20947411:20947572,20947731:20947864,20948247:20948430,20948675:20948750,20949001:20949064,20949180:20949288,20949475:20949568,20949742:20949821,20950039:20950153,20950382:20952191,20950735:20950876,20951082:20951153,20951512:20951676,20952014:20952269,20952419:20952596,20952778:20953091,20953465:20953566,20954160:20954327,20954161:20954252,20954514:20954561,20954798:20954822,20954933:20955021,20955120:20955143,20955264:20955354,20955413:20955425,20955517:20955606,20955657:20955668,20955762:20955852,20955903:20955956,20956148:20956198,20956254:20956347,20956406:20956465,20956552:20956596,20956664:20956756,20956813:20956829,20956952:20956998,20957086:20957173,20957251:20957301,20957384:20957391,20957518:20957580,20979333:20992686,20993497:20998018,20993498:20999183,20993500:20998167,20993502:20997531,20993504:20997428,20993506:20997352,20993508:20997031,20993510:20996812,20993512:2099621', 'assoc_mat': '20943975:autre:4230:20946181,20943976:autre:4230:20944335,20944756:autre:4230:20945208,20945561:autre:4230:20945867,20946202:autre:4230:20946282,20946648:autre:4230:20946988,20947070:autre:4230:20947181,20947411:autre:4230:20947572,20947731:autre:4230:20947864,20948247:autre:4230:20948430,20948675:autre:4230:20948750,20949001:autre:4230:20949064,20949180:autre:4230:20949288,20949475:autre:4230:20949568,20949742:autre:4230:20949821,20950039:autre:4230:20950153,20950382:autre:4230:20952191,20950735:autre:4230:20950876,20951082:autre:4230:20951153,20951512:autre:4230:20951676,20952014:autre:4230:20952269,20952419:autre:4230:20952596,20952778:autre:4230:20953091,20953465:autre:4230:20953566,20954160:autre:4230:20954327,20954161:autre:4230:20954252,20954514:autre:4230:20954561,20954798:autre:4230:20954822,20954933:autre:4230:20955021,20955120:autre:4230:20955143,20955264:autre:4230:20955354,20955413:autre:4230:20955425,20955517:autre:4230:20955606,20955657:autre:4230:20955668,20955762:autre:4230:20955852,20955903:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05264432026709546, 'nb_photo': 93570, 'list_port_cont': '20944345,20945195,20945873,20946167,20946285,20946998,20947179,20947578,20947861,20948425,20948753,20949054,20949281,20949575,20949817,20950155,20950877,20951161,20951683,20952194,20952268,20952587,20953096,20953553,20954259,20954328,20954562,20954823,20955033,20955139,20955366,20955426,20955607,20955669,20955857,20955961,20956208,20956353,20956467,20956608,20956755,20956821,20957003,20957176,20957308,20957397,20957574,20992682,20994186,20994287,20994467,20994567,20994735,20994951,20995129,20995398,20995460,20995533,20995997,20996135,20996215,20996324,20996815,20996855,20997041,20997356,20997434,20997532,20998027,20998182,20999185,21025933,21026119,21032073,21033466,21052394,21052849,21053530,21055016,21055460,21057447,21058497,21078483,21078734,21079014,21079069,21079477,21079925,21080267,21080460,21080807,21081026,21081454,21081668,21087417,21089203,21103727,21104264,21105150,21106905,21107588,21108567,21108984,21109567,21110339,21110465,21111687,21111737,21112114,21112656,21113660,21114236,21114934,2111533', 'assoc_port': '20943975:20946167,20943976:20944345,20944756:20945195,20945561:20945873,20946202:20946285,20946648:20946998,20947070:20947179,20947411:20947578,20947731:20947861,20948247:20948425,20948675:20948753,20949001:20949054,20949180:20949281,20949475:20949575,20949742:20949817,20950039:20950155,20950382:20952194,20950735:20950877,20951082:20951161,20951512:20951683,20952014:20952268,20952419:20952587,20952778:20953096,20953465:20953553,20954160:20954328,20954161:20954259,20954514:20954562,20954798:20954823,20954933:20955033,20955120:20955139,20955264:20955366,20955413:20955426,20955517:20955607,20955657:20955669,20955762:20955857,20955903:20955961,20956148:20956208,20956254:20956353,20956406:20956467,20956552:20956608,20956664:20956755,20956813:20956821,20956952:20957003,20957086:20957176,20957251:20957308,20957384:20957397,20957518:20957574,20979333:20992682,20993497:20998027,20993498:20999185,20993500:20998182,20993502:20997532,20993504:20997434,20993506:20997356,20993508:20997041,20993510:20996815,20993512:2099621', 'assoc_mat': '20943975:carton:4230:20946167,20943976:carton:4230:20944345,20944756:carton:4230:20945195,20945561:carton:4230:20945873,20946202:carton:4230:20946285,20946648:carton:4230:20946998,20947070:carton:4230:20947179,20947411:carton:4230:20947578,20947731:carton:4230:20947861,20948247:carton:4230:20948425,20948675:carton:4230:20948753,20949001:carton:4230:20949054,20949180:carton:4230:20949281,20949475:carton:4230:20949575,20949742:carton:4230:20949817,20950039:carton:4230:20950155,20950382:carton:4230:20952194,20950735:carton:4230:20950877,20951082:carton:4230:20951161,20951512:carton:4230:20951683,20952014:carton:4230:20952268,20952419:carton:4230:20952587,20952778:carton:4230:20953096,20953465:carton:4230:20953553,20954160:carton:4230:20954328,20954161:carton:4230:20954259,20954514:carton:4230:20954562,20954798:carton:4230:20954823,20954933:carton:4230:20955033,20955120:carton:4230:20955139,20955264:carton:4230:20955366,20955413:carton:4230:20955426,20955517:carton:4230:20955607,20955657:carton:4230:20955669,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011995744372984287, 'nb_photo': 1703, 'list_port_cont': '20944340,20945193,20945878,20946168,20946284,20946995,20947857,20948417,20948749,20949061,20949279,20949569,20950147,20951669,20952201,20952267,20952580,20953086,20953560,20954256,20954330,20954566,20955358,20955420,20955674,20955855,20955966,20956205,20956337,20956601,20956763,20956825,20957181,20957399,20957573,20992675,20994459,20994559,20994945,20995399,20995468,20995529,20996132,20996317,20996856,20997346,20997420,20997516,20998168,20999177,21025938,21026106,21032063,21052387,21052848,21053524,21055012,21055464,21057445,21058487,21079006,21080261,21080445,21080803,21081024,21081439,21081664,21087407,21104271,21106898,21107587,21108569,21108983,21109576,21110455,21111677,21111744,21112102,21112658,21113661,21114237,21114935,21115331,21115705,21115976,21116364,21121388,21128630,21129664,21130471,21162419,21163907,21166069,21166243,21166461,21166510,21166544,21166739,21166873,21167155,21167259,21167361,21167486,21167838,21167977,21168096,21168347,21168488,21168541,21168770,21168941,21169059,21169108,2116923', 'assoc_port': '20943975:20946168,20943976:20944340,20944756:20945193,20945561:20945878,20946202:20946284,20946648:20946995,20947731:20947857,20948247:20948417,20948675:20948749,20949001:20949061,20949180:20949279,20949475:20949569,20950039:20950147,20950382:20952201,20951512:20951669,20952014:20952267,20952419:20952580,20952778:20953086,20953465:20953560,20954160:20954330,20954161:20954256,20954514:20954566,20955264:20955358,20955413:20955420,20955657:20955674,20955762:20955855,20955903:20955966,20956148:20956205,20956254:20956337,20956552:20956601,20956664:20956763,20956813:20956825,20957086:20957181,20957384:20957399,20957518:20957573,20979333:20992675,20993498:20999177,20993500:20998168,20993502:20997516,20993504:20997420,20993506:20997346,20993514:20996317,20993516:20996856,20993519:20995529,20993523:20996132,20993525:20994945,20993526:20995468,20993527:20995399,20993528:20994459,20993530:20994559,21009641:21026106,21025092:21025938,21027585:21079006,21027591:21121388,21027595:21080261,21027597:21080445,21027599:2108080', 'assoc_mat': '20943975:metal:4230:20946168,20943976:metal:4230:20944340,20944756:metal:4230:20945193,20945561:metal:4230:20945878,20946202:metal:4230:20946284,20946648:metal:4230:20946995,20947731:metal:4230:20947857,20948247:metal:4230:20948417,20948675:metal:4230:20948749,20949001:metal:4230:20949061,20949180:metal:4230:20949279,20949475:metal:4230:20949569,20950039:metal:4230:20950147,20950382:metal:4230:20952201,20951512:metal:4230:20951669,20952014:metal:4230:20952267,20952419:metal:4230:20952580,20952778:metal:4230:20953086,20953465:metal:4230:20953560,20954160:metal:4230:20954330,20954161:metal:4230:20954256,20954514:metal:4230:20954566,20955264:metal:4230:20955358,20955413:metal:4230:20955420,20955657:metal:4230:20955674,20955762:metal:4230:20955855,20955903:metal:4230:20955966,20956148:metal:4230:20956205,20956254:metal:4230:20956337,20956552:metal:4230:20956601,20956664:metal:4230:20956763,20956813:metal:4230:20956825,20957086:metal:4230:20957181,20957384:metal:4230:20957399,20957518:metal:4230:20957573,20979333:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2062599065700527, 'nb_photo': 423052, 'list_port_cont': '20944348,20945209,20945872,20946177,20946277,20946993,20947180,20947582,20947865,20948429,20948755,20949058,20949277,20949574,20949822,20950159,20950870,20951165,20951681,20952190,20952261,20952584,20953100,20953564,20954262,20954338,20954573,20954820,20955029,20955132,20955368,20955419,20955602,20955676,20955858,20955955,20956199,20956348,20956455,20956612,20956761,20956820,20957005,20957175,20957307,20957405,20957579,20992684,20994189,20994286,20994466,20994570,20994737,20994939,20995123,20995393,20995461,20995537,20996007,20996131,20996218,20996320,20996818,20996847,20997042,20997355,20997432,20997527,20998015,20998179,20999189,21025942,21026120,21032064,21033458,21052398,21052847,21053534,21055027,21055465,21057434,21058503,21078481,21078729,21079019,21079071,21079484,21079923,21080272,21080456,21080796,21081029,21081452,21081655,21087420,21089202,21103725,21104276,21105147,21106907,21107584,21108563,21108989,21109574,21110342,21110464,21111683,21111747,21112104,21112659,21113652,21114231,21114939,2111533', 'assoc_port': '20943975:20946177,20943976:20944348,20944756:20945209,20945561:20945872,20946202:20946277,20946648:20946993,20947070:20947180,20947411:20947582,20947731:20947865,20948247:20948429,20948675:20948755,20949001:20949058,20949180:20949277,20949475:20949574,20949742:20949822,20950039:20950159,20950382:20952190,20950735:20950870,20951082:20951165,20951512:20951681,20952014:20952261,20952419:20952584,20952778:20953100,20953465:20953564,20954160:20954338,20954161:20954262,20954514:20954573,20954798:20954820,20954933:20955029,20955120:20955132,20955264:20955368,20955413:20955419,20955517:20955602,20955657:20955676,20955762:20955858,20955903:20955955,20956148:20956199,20956254:20956348,20956406:20956455,20956552:20956612,20956664:20956761,20956813:20956820,20956952:20957005,20957086:20957175,20957251:20957307,20957384:20957405,20957518:20957579,20979333:20992684,20993497:20998015,20993498:20999189,20993500:20998179,20993502:20997527,20993504:20997432,20993506:20997355,20993508:20997042,20993510:20996818,20993512:2099621', 'assoc_mat': '20943975:papier:4230:20946177,20943976:papier:4230:20944348,20944756:papier:4230:20945209,20945561:papier:4230:20945872,20946202:papier:4230:20946277,20946648:papier:4230:20946993,20947070:papier:4230:20947180,20947411:papier:4230:20947582,20947731:papier:4230:20947865,20948247:papier:4230:20948429,20948675:papier:4230:20948755,20949001:papier:4230:20949058,20949180:papier:4230:20949277,20949475:papier:4230:20949574,20949742:papier:4230:20949822,20950039:papier:4230:20950159,20950382:papier:4230:20952190,20950735:papier:4230:20950870,20951082:papier:4230:20951165,20951512:papier:4230:20951681,20952014:papier:4230:20952261,20952419:papier:4230:20952584,20952778:papier:4230:20953100,20953465:papier:4230:20953564,20954160:papier:4230:20954338,20954161:papier:4230:20954262,20954514:papier:4230:20954573,20954798:papier:4230:20954820,20954933:papier:4230:20955029,20955120:papier:4230:20955132,20955264:papier:4230:20955368,20955413:papier:4230:20955419,20955517:papier:4230:20955602,20955657:papier:4230:20955676,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0045914755933246145, 'nb_photo': 2731, 'list_port_cont': '20944350,20945204,20945870,20946182,20946283,20947002,20947581,20947870,20948419,20948764,20949063,20949286,20949573,20949818,20950152,20950867,20951168,20951678,20952197,20952271,20952595,20953093,20953561,20954329,20955035,20955359,20955424,20955848,20955965,20956204,20956350,20956461,20956753,20956833,20957183,20957305,20957567,20992673,20994573,20994942,20995386,20995471,20995535,20996134,20996319,20996858,20997357,21025943,21026116,21032074,21052396,21052857,21055020,21055463,21057448,21058499,21078733,21079016,21080265,21080808,21081455,21081658,21087422,21089206,21103729,21104274,21105141,21106906,21107586,21108559,21108979,21109579,21110345,21110460,21111672,21111746,21112113,21112660,21113665,21114936,21115343,21115487,21115713,21116367,21121387,21128627,21129654,21130479,21162429,21163908,21165891,21166084,21166245,21166458,21166504,21166550,21166733,21166877,21167163,21167364,21167494,21167840,21167989,21168091,21168335,21168544,21168776,21168846,21168952,21169061,21169096,21169233,21169987,2117018', 'assoc_port': '20943975:20946182,20943976:20944350,20944756:20945204,20945561:20945870,20946202:20946283,20946648:20947002,20947411:20947581,20947731:20947870,20948247:20948419,20948675:20948764,20949001:20949063,20949180:20949286,20949475:20949573,20949742:20949818,20950039:20950152,20950382:20952197,20950735:20950867,20951082:20951168,20951512:20951678,20952014:20952271,20952419:20952595,20952778:20953093,20953465:20953561,20954160:20954329,20954933:20955035,20955264:20955359,20955413:20955424,20955762:20955848,20955903:20955965,20956148:20956204,20956254:20956350,20956406:20956461,20956664:20956753,20956813:20956833,20957086:20957183,20957251:20957305,20957518:20957567,20979333:20992673,20993506:20997357,20993514:20996319,20993516:20996858,20993519:20995535,20993523:20996134,20993525:20994942,20993526:20995471,20993527:20995386,20993530:20994573,21009641:21026116,21025092:21025943,21027583:21078733,21027585:21079016,21027591:21121387,21027595:21080265,21027599:21080808,21027603:21081455,21027605:21081658,21027607:2105546', 'assoc_mat': '20943975:pehd:4230:20946182,20943976:pehd:4230:20944350,20944756:pehd:4230:20945204,20945561:pehd:4230:20945870,20946202:pehd:4230:20946283,20946648:pehd:4230:20947002,20947411:pehd:4230:20947581,20947731:pehd:4230:20947870,20948247:pehd:4230:20948419,20948675:pehd:4230:20948764,20949001:pehd:4230:20949063,20949180:pehd:4230:20949286,20949475:pehd:4230:20949573,20949742:pehd:4230:20949818,20950039:pehd:4230:20950152,20950382:pehd:4230:20952197,20950735:pehd:4230:20950867,20951082:pehd:4230:20951168,20951512:pehd:4230:20951678,20952014:pehd:4230:20952271,20952419:pehd:4230:20952595,20952778:pehd:4230:20953093,20953465:pehd:4230:20953561,20954160:pehd:4230:20954329,20954933:pehd:4230:20955035,20955264:pehd:4230:20955359,20955413:pehd:4230:20955424,20955762:pehd:4230:20955848,20955903:pehd:4230:20955965,20956148:pehd:4230:20956204,20956254:pehd:4230:20956350,20956406:pehd:4230:20956461,20956664:pehd:4230:20956753,20956813:pehd:4230:20956833,20957086:pehd:4230:20957183,20957251:pehd:4230:20957305,20957518:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014956224677621586, 'nb_photo': 24603, 'list_port_cont': '20944341,20945207,20945866,20946176,20946278,20946994,20947184,20947576,20947873,20948432,20948760,20949060,20949287,20949572,20949819,20950157,20950878,20951169,20951674,20952195,20952272,20952597,20953099,20953562,20954260,20954332,20954563,20954818,20955027,20955130,20955367,20955434,20955613,20955667,20955861,20955962,20956209,20956342,20956459,20956603,20956762,20956823,20957010,20957174,20957310,20957406,20957581,20992683,20994188,20994288,20994463,20994572,20994734,20994950,20995126,20995396,20995472,20995539,20996006,20996133,20996216,20996326,20996819,20996853,20997045,20997347,20997431,20997520,20998026,20998177,20999188,21025929,21026118,21032066,21033461,21052393,21052858,21053533,21055021,21055462,21057442,21058500,21078482,21078730,21079018,21079078,21079481,21079928,21080273,21080457,21080805,21081030,21081444,21081663,21087418,21089197,21103719,21104269,21105149,21106904,21107582,21108568,21108980,21109581,21110333,21110467,21111688,21111748,21112111,21112662,21113666,21114240,21114928,2111534', 'assoc_port': '20943975:20946176,20943976:20944341,20944756:20945207,20945561:20945866,20946202:20946278,20946648:20946994,20947070:20947184,20947411:20947576,20947731:20947873,20948247:20948432,20948675:20948760,20949001:20949060,20949180:20949287,20949475:20949572,20949742:20949819,20950039:20950157,20950382:20952195,20950735:20950878,20951082:20951169,20951512:20951674,20952014:20952272,20952419:20952597,20952778:20953099,20953465:20953562,20954160:20954332,20954161:20954260,20954514:20954563,20954798:20954818,20954933:20955027,20955120:20955130,20955264:20955367,20955413:20955434,20955517:20955613,20955657:20955667,20955762:20955861,20955903:20955962,20956148:20956209,20956254:20956342,20956406:20956459,20956552:20956603,20956664:20956762,20956813:20956823,20956952:20957010,20957086:20957174,20957251:20957310,20957384:20957406,20957518:20957581,20979333:20992683,20993497:20998026,20993498:20999188,20993500:20998177,20993502:20997520,20993504:20997431,20993506:20997347,20993508:20997045,20993510:20996819,20993512:2099621', 'assoc_mat': '20943975:pet_clair:4230:20946176,20943976:pet_clair:4230:20944341,20944756:pet_clair:4230:20945207,20945561:pet_clair:4230:20945866,20946202:pet_clair:4230:20946278,20946648:pet_clair:4230:20946994,20947070:pet_clair:4230:20947184,20947411:pet_clair:4230:20947576,20947731:pet_clair:4230:20947873,20948247:pet_clair:4230:20948432,20948675:pet_clair:4230:20948760,20949001:pet_clair:4230:20949060,20949180:pet_clair:4230:20949287,20949475:pet_clair:4230:20949572,20949742:pet_clair:4230:20949819,20950039:pet_clair:4230:20950157,20950382:pet_clair:4230:20952195,20950735:pet_clair:4230:20950878,20951082:pet_clair:4230:20951169,20951512:pet_clair:4230:20951674,20952014:pet_clair:4230:20952272,20952419:pet_clair:4230:20952597,20952778:pet_clair:4230:20953099,20953465:pet_clair:4230:20953562,20954160:pet_clair:4230:20954332,20954161:pet_clair:4230:20954260,20954514:pet_clair:4230:20954563,20954798:pet_clair:4230:20954818,20954933:pet_clair:4230:20955027,20955120:pet_clair:4230:20955130,20955264:pet_clair:4230:20955367,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002962719796122446, 'nb_photo': 1319, 'list_port_cont': '20945205,20946183,20946274,20948427,20948762,20949062,20949565,20949808,20950151,20950873,20951167,20951682,20952198,20952270,20953101,20953554,20954568,20955433,20955599,20955849,20956351,20956462,20956607,20956759,20956832,20957008,20957180,20957398,20994281,20994569,20994728,20994947,20995121,20995473,20996129,20996321,20996848,21026108,21052392,21052856,21057449,21058502,21078477,21079021,21079075,21080268,21080809,21081033,21081451,21081662,21087421,21089201,21103721,21104278,21105143,21106897,21107591,21108560,21108985,21109578,21110347,21111743,21112109,21112652,21113667,21114229,21115987,21116376,21129658,21130480,21163914,21166085,21166255,21166464,21166511,21166881,21167162,21167270,21167353,21167843,21167990,21168339,21168535,21168769,21168940,21169069,21169229,21169996,21173704,21175462,21177487,21180889,21181847,21182807,21184040,21184343,21186345,21187772,21190823,21191704,21192801,21192961,21193410,21193543,21193924,21194139,21213208,21213317,21213432,21213522,21213561,21213660,21213802,2121391', 'assoc_port': '20943975:20946183,20944756:20945205,20946202:20946274,20948247:20948427,20948675:20948762,20949001:20949062,20949475:20949565,20949742:20949808,20950039:20950151,20950382:20952198,20950735:20950873,20951082:20951167,20951512:20951682,20952014:20952270,20952778:20953101,20953465:20953554,20954514:20954568,20955413:20955433,20955517:20955599,20955762:20955849,20956254:20956351,20956406:20956462,20956552:20956607,20956664:20956759,20956813:20956832,20956952:20957008,20957086:20957180,20957384:20957398,20993514:20996321,20993516:20996848,20993523:20996129,20993525:20994947,20993526:20995473,20993529:20994728,20993530:20994569,20994209:20994281,20995011:20995121,21009641:21026108,21027581:21078477,21027585:21079021,21027587:21079075,21027595:21080268,21027599:21080809,21027601:21081033,21027603:21081451,21027605:21081662,21027609:21057449,21027610:21058502,21027614:21052856,21027615:21052392,21084490:21115987,21084491:21116376,21084495:21114229,21084498:21112109,21084499:21112652,21084501:21113667,21084502:2111034', 'assoc_mat': '20943975:pet_fonce:4230:20946183,20944756:pet_fonce:4230:20945205,20946202:pet_fonce:4230:20946274,20948247:pet_fonce:4230:20948427,20948675:pet_fonce:4230:20948762,20949001:pet_fonce:4230:20949062,20949475:pet_fonce:4230:20949565,20949742:pet_fonce:4230:20949808,20950039:pet_fonce:4230:20950151,20950382:pet_fonce:4230:20952198,20950735:pet_fonce:4230:20950873,20951082:pet_fonce:4230:20951167,20951512:pet_fonce:4230:20951682,20952014:pet_fonce:4230:20952270,20952778:pet_fonce:4230:20953101,20953465:pet_fonce:4230:20953554,20954514:pet_fonce:4230:20954568,20955413:pet_fonce:4230:20955433,20955517:pet_fonce:4230:20955599,20955762:pet_fonce:4230:20955849,20956254:pet_fonce:4230:20956351,20956406:pet_fonce:4230:20956462,20956552:pet_fonce:4230:20956607,20956664:pet_fonce:4230:20956759,20956813:pet_fonce:4230:20956832,20956952:pet_fonce:4230:20957008,20957086:pet_fonce:4230:20957180,20957384:pet_fonce:4230:20957398,20993514:pet_fonce:4230:20996321,20993516:pet_fonce:4230:20996848,20993523:pet_fonce:4230:20996129,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(1641154,1641379,1643792,1646909,1650539,1653390,1656907,1660067,1661845,1664134,1668385,1671932,1674573,1678158,1679831,1680087,1681711,1682884,1684044,1685098,1687706,1689508,1690085,1693211,1696704,1699462,1703442,1707142,1709522,1710025,1713041)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124855, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944335,20945208,20945867,20946181,20946282,20946988,20947181,20947572,20947864,20948430,20948750,20949064,20949288,20949568,20949821,20950153,20950876,20951153,20951676,20952191,20952269,20952596,20953091,20953566,20954252,20954327,20954561,20954822,20955021,20955143,20955354,20955425,20955606,20955668,20955852,20955956,20956198,20956347,20956465,20956596,20956756,20956829,20956998,20957173,20957301,20957391,20957580,20992686,20994183,20994277,20994460,20994561,20994727,20994944,20995130,20995400,20995469,20995527,20995998,20996119,20996219,20996322,20996812,20996852,20997031,20997352,20997428,20997531,20998018,20998167,20999183,21025940,21026111,21032059,21033462,21052397,21052855,21053535,21055025,21055458,21057440,21058492,21078473,21078719,21079010,21079065,21079486,21079922,21080263,21080446,21080793,21081022,21081438,21081670,21087415,21089205,21103722,21104273,21105144,21106893,21107578,21108553,21108991,21109568,21110341,21110453,21111676,21111742,21112107,21112648,21113664,21114232,21114937,2111534 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124856, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944345,20945195,20945873,20946167,20946285,20946998,20947179,20947578,20947861,20948425,20948753,20949054,20949281,20949575,20949817,20950155,20950877,20951161,20951683,20952194,20952268,20952587,20953096,20953553,20954259,20954328,20954562,20954823,20955033,20955139,20955366,20955426,20955607,20955669,20955857,20955961,20956208,20956353,20956467,20956608,20956755,20956821,20957003,20957176,20957308,20957397,20957574,20992682,20994186,20994287,20994467,20994567,20994735,20994951,20995129,20995398,20995460,20995533,20995997,20996135,20996215,20996324,20996815,20996855,20997041,20997356,20997434,20997532,20998027,20998182,20999185,21025933,21026119,21032073,21033466,21052394,21052849,21053530,21055016,21055460,21057447,21058497,21078483,21078734,21079014,21079069,21079477,21079925,21080267,21080460,21080807,21081026,21081454,21081668,21087417,21089203,21103727,21104264,21105150,21106905,21107588,21108567,21108984,21109567,21110339,21110465,21111687,21111737,21112114,21112656,21113660,21114236,21114934,2111533 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124857, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944340,20945193,20945878,20946168,20946284,20946995,20947857,20948417,20948749,20949061,20949279,20949569,20950147,20951669,20952201,20952267,20952580,20953086,20953560,20954256,20954330,20954566,20955358,20955420,20955674,20955855,20955966,20956205,20956337,20956601,20956763,20956825,20957181,20957399,20957573,20992675,20994459,20994559,20994945,20995399,20995468,20995529,20996132,20996317,20996856,20997346,20997420,20997516,20998168,20999177,21025938,21026106,21032063,21052387,21052848,21053524,21055012,21055464,21057445,21058487,21079006,21080261,21080445,21080803,21081024,21081439,21081664,21087407,21104271,21106898,21107587,21108569,21108983,21109576,21110455,21111677,21111744,21112102,21112658,21113661,21114237,21114935,21115331,21115705,21115976,21116364,21121388,21128630,21129664,21130471,21162419,21163907,21166069,21166243,21166461,21166510,21166544,21166739,21166873,21167155,21167259,21167361,21167486,21167838,21167977,21168096,21168347,21168488,21168541,21168770,21168941,21169059,21169108,2116923 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124858, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944348,20945209,20945872,20946177,20946277,20946993,20947180,20947582,20947865,20948429,20948755,20949058,20949277,20949574,20949822,20950159,20950870,20951165,20951681,20952190,20952261,20952584,20953100,20953564,20954262,20954338,20954573,20954820,20955029,20955132,20955368,20955419,20955602,20955676,20955858,20955955,20956199,20956348,20956455,20956612,20956761,20956820,20957005,20957175,20957307,20957405,20957579,20992684,20994189,20994286,20994466,20994570,20994737,20994939,20995123,20995393,20995461,20995537,20996007,20996131,20996218,20996320,20996818,20996847,20997042,20997355,20997432,20997527,20998015,20998179,20999189,21025942,21026120,21032064,21033458,21052398,21052847,21053534,21055027,21055465,21057434,21058503,21078481,21078729,21079019,21079071,21079484,21079923,21080272,21080456,21080796,21081029,21081452,21081655,21087420,21089202,21103725,21104276,21105147,21106907,21107584,21108563,21108989,21109574,21110342,21110464,21111683,21111747,21112104,21112659,21113652,21114231,21114939,2111533 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124859, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944350,20945204,20945870,20946182,20946283,20947002,20947581,20947870,20948419,20948764,20949063,20949286,20949573,20949818,20950152,20950867,20951168,20951678,20952197,20952271,20952595,20953093,20953561,20954329,20955035,20955359,20955424,20955848,20955965,20956204,20956350,20956461,20956753,20956833,20957183,20957305,20957567,20992673,20994573,20994942,20995386,20995471,20995535,20996134,20996319,20996858,20997357,21025943,21026116,21032074,21052396,21052857,21055020,21055463,21057448,21058499,21078733,21079016,21080265,21080808,21081455,21081658,21087422,21089206,21103729,21104274,21105141,21106906,21107586,21108559,21108979,21109579,21110345,21110460,21111672,21111746,21112113,21112660,21113665,21114936,21115343,21115487,21115713,21116367,21121387,21128627,21129654,21130479,21162429,21163908,21165891,21166084,21166245,21166458,21166504,21166550,21166733,21166877,21167163,21167364,21167494,21167840,21167989,21168091,21168335,21168544,21168776,21168846,21168952,21169061,21169096,21169233,21169987,2117018 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124860, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20944341,20945207,20945866,20946176,20946278,20946994,20947184,20947576,20947873,20948432,20948760,20949060,20949287,20949572,20949819,20950157,20950878,20951169,20951674,20952195,20952272,20952597,20953099,20953562,20954260,20954332,20954563,20954818,20955027,20955130,20955367,20955434,20955613,20955667,20955861,20955962,20956209,20956342,20956459,20956603,20956762,20956823,20957010,20957174,20957310,20957406,20957581,20992683,20994188,20994288,20994463,20994572,20994734,20994950,20995126,20995396,20995472,20995539,20996006,20996133,20996216,20996326,20996819,20996853,20997045,20997347,20997431,20997520,20998026,20998177,20999188,21025929,21026118,21032066,21033461,21052393,21052858,21053533,21055021,21055462,21057442,21058500,21078482,21078730,21079018,21079078,21079481,21079928,21080273,21080457,21080805,21081030,21081444,21081663,21087418,21089197,21103719,21104269,21105149,21106904,21107582,21108568,21108980,21109581,21110333,21110467,21111688,21111748,21112111,21112662,21113666,21114240,21114928,2111534 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124861, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (20945205,20946183,20946274,20948427,20948762,20949062,20949565,20949808,20950151,20950873,20951167,20951682,20952198,20952270,20953101,20953554,20954568,20955433,20955599,20955849,20956351,20956462,20956607,20956759,20956832,20957008,20957180,20957398,20994281,20994569,20994728,20994947,20995121,20995473,20996129,20996321,20996848,21026108,21052392,21052856,21057449,21058502,21078477,21079021,21079075,21080268,21080809,21081033,21081451,21081662,21087421,21089201,21103721,21104278,21105143,21106897,21107591,21108560,21108985,21109578,21110347,21111743,21112109,21112652,21113667,21114229,21115987,21116376,21129658,21130480,21163914,21166085,21166255,21166464,21166511,21166881,21167162,21167270,21167353,21167843,21167990,21168339,21168535,21168769,21168940,21169069,21169229,21169996,21173704,21175462,21177487,21180889,21181847,21182807,21184040,21184343,21186345,21187772,21190823,21191704,21192801,21192961,21193410,21193543,21193924,21194139,21213208,21213317,21213432,21213522,21213561,21213660,21213802,2121391 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124855,30124856,30124857,30124858,30124859,30124860,30124861?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-03-01' and date <= '2025-03-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2026,),), 'unwanted_material_monthly_percentage': ((0.7416304404041119,),), 'material_repartition': (('incineration', 2023),), 'material_dict': {'incineration': 2023}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.6857134084744704, 3), (datetime.date(2025, 3, 2), 0.7934075275961978, 4), (datetime.date(2025, 3, 3), 0.8099739888471582, 1), (datetime.date(2025, 3, 4), 0.7989417012729665, 3), (datetime.date(2025, 3, 5), 0.7200210319734466, 3), (datetime.date(2025, 3, 6), 0.6880138605909244, 4), (datetime.date(2025, 3, 7), 0.7048142847185289, 3), (datetime.date(2025, 3, 8), 0.7169299522629912, 4), (datetime.date(2025, 3, 9), 0.7793667198952321, 3), (datetime.date(2025, 3, 10), 0.7981423632291635, 4), (datetime.date(2025, 3, 11), 0.7513666131952011, 3), (datetime.date(2025, 3, 12), 0.743756959509658, 3), (datetime.date(2025, 3, 13), 0.781261046322333, 2), (datetime.date(2025, 3, 14), 0.7663960879177117, 2), (datetime.date(2025, 3, 15), 0.8165399604765395, 3), (datetime.date(2025, 3, 16), 0.8785023935596942, 3), (datetime.date(2025, 3, 17), 0.8395084292137448, 4), (datetime.date(2025, 3, 18), 0.8107446485788271, 4), (datetime.date(2025, 3, 19), 0.7895581364377858, 4), (datetime.date(2025, 3, 20), 0.7974876113155737, 1), (datetime.date(2025, 3, 21), 0.7094723339315028, 3), (datetime.date(2025, 3, 22), 0.604217264321833, 3), (datetime.date(2025, 3, 23), 0.7282629200682558, 3), (datetime.date(2025, 3, 24), 0.7148733916055675, 3), (datetime.date(2025, 3, 25), 0.6708753021521078, 3), (datetime.date(2025, 3, 26), 0.6591169650060783, 3), (datetime.date(2025, 3, 27), 0.6328882373528713, 2), (datetime.date(2025, 3, 28), 0.6403054846111227, 3), (datetime.date(2025, 3, 29), 0.6052394979469434, 3), (datetime.date(2025, 3, 30), 0.7647525801689626, 3), (datetime.date(2025, 3, 31), 0.7259604930373134, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 3, 1), 0.6857134084744704, 3), (datetime.date(2025, 3, 2), 0.7934075275961978, 4), (datetime.date(2025, 3, 3), 0.8099739888471582, 1), (datetime.date(2025, 3, 4), 0.7989417012729665, 3), (datetime.date(2025, 3, 5), 0.7200210319734466, 3), (datetime.date(2025, 3, 6), 0.6880138605909244, 4), (datetime.date(2025, 3, 7), 0.7048142847185289, 3), (datetime.date(2025, 3, 8), 0.7169299522629912, 4), (datetime.date(2025, 3, 9), 0.7793667198952321, 3), (datetime.date(2025, 3, 10), 0.7981423632291635, 4), (datetime.date(2025, 3, 11), 0.7513666131952011, 3), (datetime.date(2025, 3, 12), 0.743756959509658, 3), (datetime.date(2025, 3, 13), 0.781261046322333, 2), (datetime.date(2025, 3, 14), 0.7663960879177117, 2), (datetime.date(2025, 3, 15), 0.8165399604765395, 3), (datetime.date(2025, 3, 16), 0.8785023935596942, 3), (datetime.date(2025, 3, 17), 0.8395084292137448, 4), (datetime.date(2025, 3, 18), 0.8107446485788271, 4), (datetime.date(2025, 3, 19), 0.7895581364377858, 4), (datetime.date(2025, 3, 20), 0.7974876113155737, 1), (datetime.date(2025, 3, 21), 0.7094723339315028, 3), (datetime.date(2025, 3, 22), 0.604217264321833, 3), (datetime.date(2025, 3, 23), 0.7282629200682558, 3), (datetime.date(2025, 3, 24), 0.7148733916055675, 3), (datetime.date(2025, 3, 25), 0.6708753021521078, 3), (datetime.date(2025, 3, 26), 0.6591169650060783, 3), (datetime.date(2025, 3, 27), 0.6328882373528713, 2), (datetime.date(2025, 3, 28), 0.6403054846111227, 3), (datetime.date(2025, 3, 29), 0.6052394979469434, 3), (datetime.date(2025, 3, 30), 0.7647525801689626, 3), (datetime.date(2025, 3, 31), 0.7259604930373134, 3))}, 'quality_array': [['-8.086436822420586', '01032025'], ['-7.912199778826317', '02032025'], ['-6.978871753750138', '03032025'], ['-7.269106700030987', '04032025'], ['-8.023871273809982', '05032025'], ['-8.162470556834805', '06032025'], ['-8.280080161266953', '07032025'], ['-8.206093313373136', '08032025'], ['-7.958456555667886', '09032025'], ['-7.2010722967359175', '10032025'], ['-7.399816333205332', '11032025'], ['-7.816237227482906', '12032025'], ['-7.838215675120718', '13032025'], ['-7.990097485376734', '14032025'], ['-7.766866527441575', '15032025'], ['-7.3039563850987435', '16032025'], ['-7.241677746496107', '17032025'], ['-7.327043771836063', '18032025'], ['-7.045926583763243', '19032025'], ['-7.505138807800111', '20032025'], ['-8.051941658958881', '21032025'], ['-8.711306689907437', '22032025'], ['-8.506491409637787', '23032025'], ['-8.104074710566278', '24032025'], ['-8.482851166152367', '25032025'], ['-8.559210456042663', '26032025'], ['-8.502828260773883', '27032025'], ['-8.505296640224879', '28032025'], ['-8.665858680599179', '29032025'], ['-8.302352084895844', '30032025'], ['-7.985968522688852', '31032025']], 'number_of_batch': ((719,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01565037234336822, 'nb_photo': 20670, 'list_port_cont': '20944335,20945208,20945867,20946181,20946282,20946988,20947181,20947572,20947864,20948430,20948750,20949064,20949288,20949568,20949821,20950153,20950876,20951153,20951676,20952191,20952269,20952596,20953091,20953566,20954252,20954327,20954561,20954822,20955021,20955143,20955354,20955425,20955606,20955668,20955852,20955956,20956198,20956347,20956465,20956596,20956756,20956829,20956998,20957173,20957301,20957391,20957580,20992686,20994183,20994277,20994460,20994561,20994727,20994944,20995130,20995400,20995469,20995527,20995998,20996119,20996219,20996322,20996812,20996852,20997031,20997352,20997428,20997531,20998018,20998167,20999183,21025940,21026111,21032059,21033462,21052397,21052855,21053535,21055025,21055458,21057440,21058492,21078473,21078719,21079010,21079065,21079486,21079922,21080263,21080446,21080793,21081022,21081438,21081670,21087415,21089205,21103722,21104273,21105144,21106893,21107578,21108553,21108991,21109568,21110341,21110453,21111676,21111742,21112107,21112648,21113664,21114232,21114937,2111534', 'assoc_port': '20943975:20946181,20943976:20944335,20944756:20945208,20945561:20945867,20946202:20946282,20946648:20946988,20947070:20947181,20947411:20947572,20947731:20947864,20948247:20948430,20948675:20948750,20949001:20949064,20949180:20949288,20949475:20949568,20949742:20949821,20950039:20950153,20950382:20952191,20950735:20950876,20951082:20951153,20951512:20951676,20952014:20952269,20952419:20952596,20952778:20953091,20953465:20953566,20954160:20954327,20954161:20954252,20954514:20954561,20954798:20954822,20954933:20955021,20955120:20955143,20955264:20955354,20955413:20955425,20955517:20955606,20955657:20955668,20955762:20955852,20955903:20955956,20956148:20956198,20956254:20956347,20956406:20956465,20956552:20956596,20956664:20956756,20956813:20956829,20956952:20956998,20957086:20957173,20957251:20957301,20957384:20957391,20957518:20957580,20979333:20992686,20993497:20998018,20993498:20999183,20993500:20998167,20993502:20997531,20993504:20997428,20993506:20997352,20993508:20997031,20993510:20996812,20993512:2099621', 'assoc_mat': '20943975:autre:4230:20946181,20943976:autre:4230:20944335,20944756:autre:4230:20945208,20945561:autre:4230:20945867,20946202:autre:4230:20946282,20946648:autre:4230:20946988,20947070:autre:4230:20947181,20947411:autre:4230:20947572,20947731:autre:4230:20947864,20948247:autre:4230:20948430,20948675:autre:4230:20948750,20949001:autre:4230:20949064,20949180:autre:4230:20949288,20949475:autre:4230:20949568,20949742:autre:4230:20949821,20950039:autre:4230:20950153,20950382:autre:4230:20952191,20950735:autre:4230:20950876,20951082:autre:4230:20951153,20951512:autre:4230:20951676,20952014:autre:4230:20952269,20952419:autre:4230:20952596,20952778:autre:4230:20953091,20953465:autre:4230:20953566,20954160:autre:4230:20954327,20954161:autre:4230:20954252,20954514:autre:4230:20954561,20954798:autre:4230:20954822,20954933:autre:4230:20955021,20955120:autre:4230:20955143,20955264:autre:4230:20955354,20955413:autre:4230:20955425,20955517:autre:4230:20955606,20955657:autre:4230:20955668,20955762:autre:4230:20955852,20955903:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05264432026709546, 'nb_photo': 93570, 'list_port_cont': '20944345,20945195,20945873,20946167,20946285,20946998,20947179,20947578,20947861,20948425,20948753,20949054,20949281,20949575,20949817,20950155,20950877,20951161,20951683,20952194,20952268,20952587,20953096,20953553,20954259,20954328,20954562,20954823,20955033,20955139,20955366,20955426,20955607,20955669,20955857,20955961,20956208,20956353,20956467,20956608,20956755,20956821,20957003,20957176,20957308,20957397,20957574,20992682,20994186,20994287,20994467,20994567,20994735,20994951,20995129,20995398,20995460,20995533,20995997,20996135,20996215,20996324,20996815,20996855,20997041,20997356,20997434,20997532,20998027,20998182,20999185,21025933,21026119,21032073,21033466,21052394,21052849,21053530,21055016,21055460,21057447,21058497,21078483,21078734,21079014,21079069,21079477,21079925,21080267,21080460,21080807,21081026,21081454,21081668,21087417,21089203,21103727,21104264,21105150,21106905,21107588,21108567,21108984,21109567,21110339,21110465,21111687,21111737,21112114,21112656,21113660,21114236,21114934,2111533', 'assoc_port': '20943975:20946167,20943976:20944345,20944756:20945195,20945561:20945873,20946202:20946285,20946648:20946998,20947070:20947179,20947411:20947578,20947731:20947861,20948247:20948425,20948675:20948753,20949001:20949054,20949180:20949281,20949475:20949575,20949742:20949817,20950039:20950155,20950382:20952194,20950735:20950877,20951082:20951161,20951512:20951683,20952014:20952268,20952419:20952587,20952778:20953096,20953465:20953553,20954160:20954328,20954161:20954259,20954514:20954562,20954798:20954823,20954933:20955033,20955120:20955139,20955264:20955366,20955413:20955426,20955517:20955607,20955657:20955669,20955762:20955857,20955903:20955961,20956148:20956208,20956254:20956353,20956406:20956467,20956552:20956608,20956664:20956755,20956813:20956821,20956952:20957003,20957086:20957176,20957251:20957308,20957384:20957397,20957518:20957574,20979333:20992682,20993497:20998027,20993498:20999185,20993500:20998182,20993502:20997532,20993504:20997434,20993506:20997356,20993508:20997041,20993510:20996815,20993512:2099621', 'assoc_mat': '20943975:carton:4230:20946167,20943976:carton:4230:20944345,20944756:carton:4230:20945195,20945561:carton:4230:20945873,20946202:carton:4230:20946285,20946648:carton:4230:20946998,20947070:carton:4230:20947179,20947411:carton:4230:20947578,20947731:carton:4230:20947861,20948247:carton:4230:20948425,20948675:carton:4230:20948753,20949001:carton:4230:20949054,20949180:carton:4230:20949281,20949475:carton:4230:20949575,20949742:carton:4230:20949817,20950039:carton:4230:20950155,20950382:carton:4230:20952194,20950735:carton:4230:20950877,20951082:carton:4230:20951161,20951512:carton:4230:20951683,20952014:carton:4230:20952268,20952419:carton:4230:20952587,20952778:carton:4230:20953096,20953465:carton:4230:20953553,20954160:carton:4230:20954328,20954161:carton:4230:20954259,20954514:carton:4230:20954562,20954798:carton:4230:20954823,20954933:carton:4230:20955033,20955120:carton:4230:20955139,20955264:carton:4230:20955366,20955413:carton:4230:20955426,20955517:carton:4230:20955607,20955657:carton:4230:20955669,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011995744372984287, 'nb_photo': 1703, 'list_port_cont': '20944340,20945193,20945878,20946168,20946284,20946995,20947857,20948417,20948749,20949061,20949279,20949569,20950147,20951669,20952201,20952267,20952580,20953086,20953560,20954256,20954330,20954566,20955358,20955420,20955674,20955855,20955966,20956205,20956337,20956601,20956763,20956825,20957181,20957399,20957573,20992675,20994459,20994559,20994945,20995399,20995468,20995529,20996132,20996317,20996856,20997346,20997420,20997516,20998168,20999177,21025938,21026106,21032063,21052387,21052848,21053524,21055012,21055464,21057445,21058487,21079006,21080261,21080445,21080803,21081024,21081439,21081664,21087407,21104271,21106898,21107587,21108569,21108983,21109576,21110455,21111677,21111744,21112102,21112658,21113661,21114237,21114935,21115331,21115705,21115976,21116364,21121388,21128630,21129664,21130471,21162419,21163907,21166069,21166243,21166461,21166510,21166544,21166739,21166873,21167155,21167259,21167361,21167486,21167838,21167977,21168096,21168347,21168488,21168541,21168770,21168941,21169059,21169108,2116923', 'assoc_port': '20943975:20946168,20943976:20944340,20944756:20945193,20945561:20945878,20946202:20946284,20946648:20946995,20947731:20947857,20948247:20948417,20948675:20948749,20949001:20949061,20949180:20949279,20949475:20949569,20950039:20950147,20950382:20952201,20951512:20951669,20952014:20952267,20952419:20952580,20952778:20953086,20953465:20953560,20954160:20954330,20954161:20954256,20954514:20954566,20955264:20955358,20955413:20955420,20955657:20955674,20955762:20955855,20955903:20955966,20956148:20956205,20956254:20956337,20956552:20956601,20956664:20956763,20956813:20956825,20957086:20957181,20957384:20957399,20957518:20957573,20979333:20992675,20993498:20999177,20993500:20998168,20993502:20997516,20993504:20997420,20993506:20997346,20993514:20996317,20993516:20996856,20993519:20995529,20993523:20996132,20993525:20994945,20993526:20995468,20993527:20995399,20993528:20994459,20993530:20994559,21009641:21026106,21025092:21025938,21027585:21079006,21027591:21121388,21027595:21080261,21027597:21080445,21027599:2108080', 'assoc_mat': '20943975:metal:4230:20946168,20943976:metal:4230:20944340,20944756:metal:4230:20945193,20945561:metal:4230:20945878,20946202:metal:4230:20946284,20946648:metal:4230:20946995,20947731:metal:4230:20947857,20948247:metal:4230:20948417,20948675:metal:4230:20948749,20949001:metal:4230:20949061,20949180:metal:4230:20949279,20949475:metal:4230:20949569,20950039:metal:4230:20950147,20950382:metal:4230:20952201,20951512:metal:4230:20951669,20952014:metal:4230:20952267,20952419:metal:4230:20952580,20952778:metal:4230:20953086,20953465:metal:4230:20953560,20954160:metal:4230:20954330,20954161:metal:4230:20954256,20954514:metal:4230:20954566,20955264:metal:4230:20955358,20955413:metal:4230:20955420,20955657:metal:4230:20955674,20955762:metal:4230:20955855,20955903:metal:4230:20955966,20956148:metal:4230:20956205,20956254:metal:4230:20956337,20956552:metal:4230:20956601,20956664:metal:4230:20956763,20956813:metal:4230:20956825,20957086:metal:4230:20957181,20957384:metal:4230:20957399,20957518:metal:4230:20957573,20979333:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2062599065700527, 'nb_photo': 423052, 'list_port_cont': '20944348,20945209,20945872,20946177,20946277,20946993,20947180,20947582,20947865,20948429,20948755,20949058,20949277,20949574,20949822,20950159,20950870,20951165,20951681,20952190,20952261,20952584,20953100,20953564,20954262,20954338,20954573,20954820,20955029,20955132,20955368,20955419,20955602,20955676,20955858,20955955,20956199,20956348,20956455,20956612,20956761,20956820,20957005,20957175,20957307,20957405,20957579,20992684,20994189,20994286,20994466,20994570,20994737,20994939,20995123,20995393,20995461,20995537,20996007,20996131,20996218,20996320,20996818,20996847,20997042,20997355,20997432,20997527,20998015,20998179,20999189,21025942,21026120,21032064,21033458,21052398,21052847,21053534,21055027,21055465,21057434,21058503,21078481,21078729,21079019,21079071,21079484,21079923,21080272,21080456,21080796,21081029,21081452,21081655,21087420,21089202,21103725,21104276,21105147,21106907,21107584,21108563,21108989,21109574,21110342,21110464,21111683,21111747,21112104,21112659,21113652,21114231,21114939,2111533', 'assoc_port': '20943975:20946177,20943976:20944348,20944756:20945209,20945561:20945872,20946202:20946277,20946648:20946993,20947070:20947180,20947411:20947582,20947731:20947865,20948247:20948429,20948675:20948755,20949001:20949058,20949180:20949277,20949475:20949574,20949742:20949822,20950039:20950159,20950382:20952190,20950735:20950870,20951082:20951165,20951512:20951681,20952014:20952261,20952419:20952584,20952778:20953100,20953465:20953564,20954160:20954338,20954161:20954262,20954514:20954573,20954798:20954820,20954933:20955029,20955120:20955132,20955264:20955368,20955413:20955419,20955517:20955602,20955657:20955676,20955762:20955858,20955903:20955955,20956148:20956199,20956254:20956348,20956406:20956455,20956552:20956612,20956664:20956761,20956813:20956820,20956952:20957005,20957086:20957175,20957251:20957307,20957384:20957405,20957518:20957579,20979333:20992684,20993497:20998015,20993498:20999189,20993500:20998179,20993502:20997527,20993504:20997432,20993506:20997355,20993508:20997042,20993510:20996818,20993512:2099621', 'assoc_mat': '20943975:papier:4230:20946177,20943976:papier:4230:20944348,20944756:papier:4230:20945209,20945561:papier:4230:20945872,20946202:papier:4230:20946277,20946648:papier:4230:20946993,20947070:papier:4230:20947180,20947411:papier:4230:20947582,20947731:papier:4230:20947865,20948247:papier:4230:20948429,20948675:papier:4230:20948755,20949001:papier:4230:20949058,20949180:papier:4230:20949277,20949475:papier:4230:20949574,20949742:papier:4230:20949822,20950039:papier:4230:20950159,20950382:papier:4230:20952190,20950735:papier:4230:20950870,20951082:papier:4230:20951165,20951512:papier:4230:20951681,20952014:papier:4230:20952261,20952419:papier:4230:20952584,20952778:papier:4230:20953100,20953465:papier:4230:20953564,20954160:papier:4230:20954338,20954161:papier:4230:20954262,20954514:papier:4230:20954573,20954798:papier:4230:20954820,20954933:papier:4230:20955029,20955120:papier:4230:20955132,20955264:papier:4230:20955368,20955413:papier:4230:20955419,20955517:papier:4230:20955602,20955657:papier:4230:20955676,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0045914755933246145, 'nb_photo': 2731, 'list_port_cont': '20944350,20945204,20945870,20946182,20946283,20947002,20947581,20947870,20948419,20948764,20949063,20949286,20949573,20949818,20950152,20950867,20951168,20951678,20952197,20952271,20952595,20953093,20953561,20954329,20955035,20955359,20955424,20955848,20955965,20956204,20956350,20956461,20956753,20956833,20957183,20957305,20957567,20992673,20994573,20994942,20995386,20995471,20995535,20996134,20996319,20996858,20997357,21025943,21026116,21032074,21052396,21052857,21055020,21055463,21057448,21058499,21078733,21079016,21080265,21080808,21081455,21081658,21087422,21089206,21103729,21104274,21105141,21106906,21107586,21108559,21108979,21109579,21110345,21110460,21111672,21111746,21112113,21112660,21113665,21114936,21115343,21115487,21115713,21116367,21121387,21128627,21129654,21130479,21162429,21163908,21165891,21166084,21166245,21166458,21166504,21166550,21166733,21166877,21167163,21167364,21167494,21167840,21167989,21168091,21168335,21168544,21168776,21168846,21168952,21169061,21169096,21169233,21169987,2117018', 'assoc_port': '20943975:20946182,20943976:20944350,20944756:20945204,20945561:20945870,20946202:20946283,20946648:20947002,20947411:20947581,20947731:20947870,20948247:20948419,20948675:20948764,20949001:20949063,20949180:20949286,20949475:20949573,20949742:20949818,20950039:20950152,20950382:20952197,20950735:20950867,20951082:20951168,20951512:20951678,20952014:20952271,20952419:20952595,20952778:20953093,20953465:20953561,20954160:20954329,20954933:20955035,20955264:20955359,20955413:20955424,20955762:20955848,20955903:20955965,20956148:20956204,20956254:20956350,20956406:20956461,20956664:20956753,20956813:20956833,20957086:20957183,20957251:20957305,20957518:20957567,20979333:20992673,20993506:20997357,20993514:20996319,20993516:20996858,20993519:20995535,20993523:20996134,20993525:20994942,20993526:20995471,20993527:20995386,20993530:20994573,21009641:21026116,21025092:21025943,21027583:21078733,21027585:21079016,21027591:21121387,21027595:21080265,21027599:21080808,21027603:21081455,21027605:21081658,21027607:2105546', 'assoc_mat': '20943975:pehd:4230:20946182,20943976:pehd:4230:20944350,20944756:pehd:4230:20945204,20945561:pehd:4230:20945870,20946202:pehd:4230:20946283,20946648:pehd:4230:20947002,20947411:pehd:4230:20947581,20947731:pehd:4230:20947870,20948247:pehd:4230:20948419,20948675:pehd:4230:20948764,20949001:pehd:4230:20949063,20949180:pehd:4230:20949286,20949475:pehd:4230:20949573,20949742:pehd:4230:20949818,20950039:pehd:4230:20950152,20950382:pehd:4230:20952197,20950735:pehd:4230:20950867,20951082:pehd:4230:20951168,20951512:pehd:4230:20951678,20952014:pehd:4230:20952271,20952419:pehd:4230:20952595,20952778:pehd:4230:20953093,20953465:pehd:4230:20953561,20954160:pehd:4230:20954329,20954933:pehd:4230:20955035,20955264:pehd:4230:20955359,20955413:pehd:4230:20955424,20955762:pehd:4230:20955848,20955903:pehd:4230:20955965,20956148:pehd:4230:20956204,20956254:pehd:4230:20956350,20956406:pehd:4230:20956461,20956664:pehd:4230:20956753,20956813:pehd:4230:20956833,20957086:pehd:4230:20957183,20957251:pehd:4230:20957305,20957518:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014956224677621586, 'nb_photo': 24603, 'list_port_cont': '20944341,20945207,20945866,20946176,20946278,20946994,20947184,20947576,20947873,20948432,20948760,20949060,20949287,20949572,20949819,20950157,20950878,20951169,20951674,20952195,20952272,20952597,20953099,20953562,20954260,20954332,20954563,20954818,20955027,20955130,20955367,20955434,20955613,20955667,20955861,20955962,20956209,20956342,20956459,20956603,20956762,20956823,20957010,20957174,20957310,20957406,20957581,20992683,20994188,20994288,20994463,20994572,20994734,20994950,20995126,20995396,20995472,20995539,20996006,20996133,20996216,20996326,20996819,20996853,20997045,20997347,20997431,20997520,20998026,20998177,20999188,21025929,21026118,21032066,21033461,21052393,21052858,21053533,21055021,21055462,21057442,21058500,21078482,21078730,21079018,21079078,21079481,21079928,21080273,21080457,21080805,21081030,21081444,21081663,21087418,21089197,21103719,21104269,21105149,21106904,21107582,21108568,21108980,21109581,21110333,21110467,21111688,21111748,21112111,21112662,21113666,21114240,21114928,2111534', 'assoc_port': '20943975:20946176,20943976:20944341,20944756:20945207,20945561:20945866,20946202:20946278,20946648:20946994,20947070:20947184,20947411:20947576,20947731:20947873,20948247:20948432,20948675:20948760,20949001:20949060,20949180:20949287,20949475:20949572,20949742:20949819,20950039:20950157,20950382:20952195,20950735:20950878,20951082:20951169,20951512:20951674,20952014:20952272,20952419:20952597,20952778:20953099,20953465:20953562,20954160:20954332,20954161:20954260,20954514:20954563,20954798:20954818,20954933:20955027,20955120:20955130,20955264:20955367,20955413:20955434,20955517:20955613,20955657:20955667,20955762:20955861,20955903:20955962,20956148:20956209,20956254:20956342,20956406:20956459,20956552:20956603,20956664:20956762,20956813:20956823,20956952:20957010,20957086:20957174,20957251:20957310,20957384:20957406,20957518:20957581,20979333:20992683,20993497:20998026,20993498:20999188,20993500:20998177,20993502:20997520,20993504:20997431,20993506:20997347,20993508:20997045,20993510:20996819,20993512:2099621', 'assoc_mat': '20943975:pet_clair:4230:20946176,20943976:pet_clair:4230:20944341,20944756:pet_clair:4230:20945207,20945561:pet_clair:4230:20945866,20946202:pet_clair:4230:20946278,20946648:pet_clair:4230:20946994,20947070:pet_clair:4230:20947184,20947411:pet_clair:4230:20947576,20947731:pet_clair:4230:20947873,20948247:pet_clair:4230:20948432,20948675:pet_clair:4230:20948760,20949001:pet_clair:4230:20949060,20949180:pet_clair:4230:20949287,20949475:pet_clair:4230:20949572,20949742:pet_clair:4230:20949819,20950039:pet_clair:4230:20950157,20950382:pet_clair:4230:20952195,20950735:pet_clair:4230:20950878,20951082:pet_clair:4230:20951169,20951512:pet_clair:4230:20951674,20952014:pet_clair:4230:20952272,20952419:pet_clair:4230:20952597,20952778:pet_clair:4230:20953099,20953465:pet_clair:4230:20953562,20954160:pet_clair:4230:20954332,20954161:pet_clair:4230:20954260,20954514:pet_clair:4230:20954563,20954798:pet_clair:4230:20954818,20954933:pet_clair:4230:20955027,20955120:pet_clair:4230:20955130,20955264:pet_clair:4230:20955367,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002962719796122446, 'nb_photo': 1319, 'list_port_cont': '20945205,20946183,20946274,20948427,20948762,20949062,20949565,20949808,20950151,20950873,20951167,20951682,20952198,20952270,20953101,20953554,20954568,20955433,20955599,20955849,20956351,20956462,20956607,20956759,20956832,20957008,20957180,20957398,20994281,20994569,20994728,20994947,20995121,20995473,20996129,20996321,20996848,21026108,21052392,21052856,21057449,21058502,21078477,21079021,21079075,21080268,21080809,21081033,21081451,21081662,21087421,21089201,21103721,21104278,21105143,21106897,21107591,21108560,21108985,21109578,21110347,21111743,21112109,21112652,21113667,21114229,21115987,21116376,21129658,21130480,21163914,21166085,21166255,21166464,21166511,21166881,21167162,21167270,21167353,21167843,21167990,21168339,21168535,21168769,21168940,21169069,21169229,21169996,21173704,21175462,21177487,21180889,21181847,21182807,21184040,21184343,21186345,21187772,21190823,21191704,21192801,21192961,21193410,21193543,21193924,21194139,21213208,21213317,21213432,21213522,21213561,21213660,21213802,2121391', 'assoc_port': '20943975:20946183,20944756:20945205,20946202:20946274,20948247:20948427,20948675:20948762,20949001:20949062,20949475:20949565,20949742:20949808,20950039:20950151,20950382:20952198,20950735:20950873,20951082:20951167,20951512:20951682,20952014:20952270,20952778:20953101,20953465:20953554,20954514:20954568,20955413:20955433,20955517:20955599,20955762:20955849,20956254:20956351,20956406:20956462,20956552:20956607,20956664:20956759,20956813:20956832,20956952:20957008,20957086:20957180,20957384:20957398,20993514:20996321,20993516:20996848,20993523:20996129,20993525:20994947,20993526:20995473,20993529:20994728,20993530:20994569,20994209:20994281,20995011:20995121,21009641:21026108,21027581:21078477,21027585:21079021,21027587:21079075,21027595:21080268,21027599:21080809,21027601:21081033,21027603:21081451,21027605:21081662,21027609:21057449,21027610:21058502,21027614:21052856,21027615:21052392,21084490:21115987,21084491:21116376,21084495:21114229,21084498:21112109,21084499:21112652,21084501:21113667,21084502:2111034', 'assoc_mat': '20943975:pet_fonce:4230:20946183,20944756:pet_fonce:4230:20945205,20946202:pet_fonce:4230:20946274,20948247:pet_fonce:4230:20948427,20948675:pet_fonce:4230:20948762,20949001:pet_fonce:4230:20949062,20949475:pet_fonce:4230:20949565,20949742:pet_fonce:4230:20949808,20950039:pet_fonce:4230:20950151,20950382:pet_fonce:4230:20952198,20950735:pet_fonce:4230:20950873,20951082:pet_fonce:4230:20951167,20951512:pet_fonce:4230:20951682,20952014:pet_fonce:4230:20952270,20952778:pet_fonce:4230:20953101,20953465:pet_fonce:4230:20953554,20954514:pet_fonce:4230:20954568,20955413:pet_fonce:4230:20955433,20955517:pet_fonce:4230:20955599,20955762:pet_fonce:4230:20955849,20956254:pet_fonce:4230:20956351,20956406:pet_fonce:4230:20956462,20956552:pet_fonce:4230:20956607,20956664:pet_fonce:4230:20956759,20956813:pet_fonce:4230:20956832,20956952:pet_fonce:4230:20957008,20957086:pet_fonce:4230:20957180,20957384:pet_fonce:4230:20957398,20993514:pet_fonce:4230:20996321,20993516:pet_fonce:4230:20996848,20993523:pet_fonce:4230:20996129,2'}), 'main_stat': {'nb_photos': 2026}, 'velours_link': 'https://www.fotonower.com/velours/30124855,30124856,30124857,30124858,30124859,30124860,30124861?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-03', 0.7416304404041119),)]} 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': ((2026,),), 'unwanted_material_monthly_percentage': ((0.7416304404041119,),), 'material_repartition': (('incineration', 2023),), 'material_dict': {'incineration': 2023}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.6857134084744704, 3), (datetime.date(2025, 3, 2), 0.7934075275961978, 4), (datetime.date(2025, 3, 3), 0.8099739888471582, 1), (datetime.date(2025, 3, 4), 0.7989417012729665, 3), (datetime.date(2025, 3, 5), 0.7200210319734466, 3), (datetime.date(2025, 3, 6), 0.6880138605909244, 4), (datetime.date(2025, 3, 7), 0.7048142847185289, 3), (datetime.date(2025, 3, 8), 0.7169299522629912, 4), (datetime.date(2025, 3, 9), 0.7793667198952321, 3), (datetime.date(2025, 3, 10), 0.7981423632291635, 4), (datetime.date(2025, 3, 11), 0.7513666131952011, 3), (datetime.date(2025, 3, 12), 0.743756959509658, 3), (datetime.date(2025, 3, 13), 0.781261046322333, 2), (datetime.date(2025, 3, 14), 0.7663960879177117, 2), (datetime.date(2025, 3, 15), 0.8165399604765395, 3), (datetime.date(2025, 3, 16), 0.8785023935596942, 3), (datetime.date(2025, 3, 17), 0.8395084292137448, 4), (datetime.date(2025, 3, 18), 0.8107446485788271, 4), (datetime.date(2025, 3, 19), 0.7895581364377858, 4), (datetime.date(2025, 3, 20), 0.7974876113155737, 1), (datetime.date(2025, 3, 21), 0.7094723339315028, 3), (datetime.date(2025, 3, 22), 0.604217264321833, 3), (datetime.date(2025, 3, 23), 0.7282629200682558, 3), (datetime.date(2025, 3, 24), 0.7148733916055675, 3), (datetime.date(2025, 3, 25), 0.6708753021521078, 3), (datetime.date(2025, 3, 26), 0.6591169650060783, 3), (datetime.date(2025, 3, 27), 0.6328882373528713, 2), (datetime.date(2025, 3, 28), 0.6403054846111227, 3), (datetime.date(2025, 3, 29), 0.6052394979469434, 3), (datetime.date(2025, 3, 30), 0.7647525801689626, 3), (datetime.date(2025, 3, 31), 0.7259604930373134, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 3, 1), 0.6857134084744704, 3), (datetime.date(2025, 3, 2), 0.7934075275961978, 4), (datetime.date(2025, 3, 3), 0.8099739888471582, 1), (datetime.date(2025, 3, 4), 0.7989417012729665, 3), (datetime.date(2025, 3, 5), 0.7200210319734466, 3), (datetime.date(2025, 3, 6), 0.6880138605909244, 4), (datetime.date(2025, 3, 7), 0.7048142847185289, 3), (datetime.date(2025, 3, 8), 0.7169299522629912, 4), (datetime.date(2025, 3, 9), 0.7793667198952321, 3), (datetime.date(2025, 3, 10), 0.7981423632291635, 4), (datetime.date(2025, 3, 11), 0.7513666131952011, 3), (datetime.date(2025, 3, 12), 0.743756959509658, 3), (datetime.date(2025, 3, 13), 0.781261046322333, 2), (datetime.date(2025, 3, 14), 0.7663960879177117, 2), (datetime.date(2025, 3, 15), 0.8165399604765395, 3), (datetime.date(2025, 3, 16), 0.8785023935596942, 3), (datetime.date(2025, 3, 17), 0.8395084292137448, 4), (datetime.date(2025, 3, 18), 0.8107446485788271, 4), (datetime.date(2025, 3, 19), 0.7895581364377858, 4), (datetime.date(2025, 3, 20), 0.7974876113155737, 1), (datetime.date(2025, 3, 21), 0.7094723339315028, 3), (datetime.date(2025, 3, 22), 0.604217264321833, 3), (datetime.date(2025, 3, 23), 0.7282629200682558, 3), (datetime.date(2025, 3, 24), 0.7148733916055675, 3), (datetime.date(2025, 3, 25), 0.6708753021521078, 3), (datetime.date(2025, 3, 26), 0.6591169650060783, 3), (datetime.date(2025, 3, 27), 0.6328882373528713, 2), (datetime.date(2025, 3, 28), 0.6403054846111227, 3), (datetime.date(2025, 3, 29), 0.6052394979469434, 3), (datetime.date(2025, 3, 30), 0.7647525801689626, 3), (datetime.date(2025, 3, 31), 0.7259604930373134, 3))}, 'quality_array': [['-8.086436822420586', '01032025'], ['-7.912199778826317', '02032025'], ['-6.978871753750138', '03032025'], ['-7.269106700030987', '04032025'], ['-8.023871273809982', '05032025'], ['-8.162470556834805', '06032025'], ['-8.280080161266953', '07032025'], ['-8.206093313373136', '08032025'], ['-7.958456555667886', '09032025'], ['-7.2010722967359175', '10032025'], ['-7.399816333205332', '11032025'], ['-7.816237227482906', '12032025'], ['-7.838215675120718', '13032025'], ['-7.990097485376734', '14032025'], ['-7.766866527441575', '15032025'], ['-7.3039563850987435', '16032025'], ['-7.241677746496107', '17032025'], ['-7.327043771836063', '18032025'], ['-7.045926583763243', '19032025'], ['-7.505138807800111', '20032025'], ['-8.051941658958881', '21032025'], ['-8.711306689907437', '22032025'], ['-8.506491409637787', '23032025'], ['-8.104074710566278', '24032025'], ['-8.482851166152367', '25032025'], ['-8.559210456042663', '26032025'], ['-8.502828260773883', '27032025'], ['-8.505296640224879', '28032025'], ['-8.665858680599179', '29032025'], ['-8.302352084895844', '30032025'], ['-7.985968522688852', '31032025']], 'number_of_batch': ((719,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01565037234336822, 'nb_photo': 20670, 'list_port_cont': '20944335,20945208,20945867,20946181,20946282,20946988,20947181,20947572,20947864,20948430,20948750,20949064,20949288,20949568,20949821,20950153,20950876,20951153,20951676,20952191,20952269,20952596,20953091,20953566,20954252,20954327,20954561,20954822,20955021,20955143,20955354,20955425,20955606,20955668,20955852,20955956,20956198,20956347,20956465,20956596,20956756,20956829,20956998,20957173,20957301,20957391,20957580,20992686,20994183,20994277,20994460,20994561,20994727,20994944,20995130,20995400,20995469,20995527,20995998,20996119,20996219,20996322,20996812,20996852,20997031,20997352,20997428,20997531,20998018,20998167,20999183,21025940,21026111,21032059,21033462,21052397,21052855,21053535,21055025,21055458,21057440,21058492,21078473,21078719,21079010,21079065,21079486,21079922,21080263,21080446,21080793,21081022,21081438,21081670,21087415,21089205,21103722,21104273,21105144,21106893,21107578,21108553,21108991,21109568,21110341,21110453,21111676,21111742,21112107,21112648,21113664,21114232,21114937,2111534', 'assoc_port': '20943975:20946181,20943976:20944335,20944756:20945208,20945561:20945867,20946202:20946282,20946648:20946988,20947070:20947181,20947411:20947572,20947731:20947864,20948247:20948430,20948675:20948750,20949001:20949064,20949180:20949288,20949475:20949568,20949742:20949821,20950039:20950153,20950382:20952191,20950735:20950876,20951082:20951153,20951512:20951676,20952014:20952269,20952419:20952596,20952778:20953091,20953465:20953566,20954160:20954327,20954161:20954252,20954514:20954561,20954798:20954822,20954933:20955021,20955120:20955143,20955264:20955354,20955413:20955425,20955517:20955606,20955657:20955668,20955762:20955852,20955903:20955956,20956148:20956198,20956254:20956347,20956406:20956465,20956552:20956596,20956664:20956756,20956813:20956829,20956952:20956998,20957086:20957173,20957251:20957301,20957384:20957391,20957518:20957580,20979333:20992686,20993497:20998018,20993498:20999183,20993500:20998167,20993502:20997531,20993504:20997428,20993506:20997352,20993508:20997031,20993510:20996812,20993512:2099621', 'assoc_mat': '20943975:autre:4230:20946181,20943976:autre:4230:20944335,20944756:autre:4230:20945208,20945561:autre:4230:20945867,20946202:autre:4230:20946282,20946648:autre:4230:20946988,20947070:autre:4230:20947181,20947411:autre:4230:20947572,20947731:autre:4230:20947864,20948247:autre:4230:20948430,20948675:autre:4230:20948750,20949001:autre:4230:20949064,20949180:autre:4230:20949288,20949475:autre:4230:20949568,20949742:autre:4230:20949821,20950039:autre:4230:20950153,20950382:autre:4230:20952191,20950735:autre:4230:20950876,20951082:autre:4230:20951153,20951512:autre:4230:20951676,20952014:autre:4230:20952269,20952419:autre:4230:20952596,20952778:autre:4230:20953091,20953465:autre:4230:20953566,20954160:autre:4230:20954327,20954161:autre:4230:20954252,20954514:autre:4230:20954561,20954798:autre:4230:20954822,20954933:autre:4230:20955021,20955120:autre:4230:20955143,20955264:autre:4230:20955354,20955413:autre:4230:20955425,20955517:autre:4230:20955606,20955657:autre:4230:20955668,20955762:autre:4230:20955852,20955903:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05264432026709546, 'nb_photo': 93570, 'list_port_cont': '20944345,20945195,20945873,20946167,20946285,20946998,20947179,20947578,20947861,20948425,20948753,20949054,20949281,20949575,20949817,20950155,20950877,20951161,20951683,20952194,20952268,20952587,20953096,20953553,20954259,20954328,20954562,20954823,20955033,20955139,20955366,20955426,20955607,20955669,20955857,20955961,20956208,20956353,20956467,20956608,20956755,20956821,20957003,20957176,20957308,20957397,20957574,20992682,20994186,20994287,20994467,20994567,20994735,20994951,20995129,20995398,20995460,20995533,20995997,20996135,20996215,20996324,20996815,20996855,20997041,20997356,20997434,20997532,20998027,20998182,20999185,21025933,21026119,21032073,21033466,21052394,21052849,21053530,21055016,21055460,21057447,21058497,21078483,21078734,21079014,21079069,21079477,21079925,21080267,21080460,21080807,21081026,21081454,21081668,21087417,21089203,21103727,21104264,21105150,21106905,21107588,21108567,21108984,21109567,21110339,21110465,21111687,21111737,21112114,21112656,21113660,21114236,21114934,2111533', 'assoc_port': '20943975:20946167,20943976:20944345,20944756:20945195,20945561:20945873,20946202:20946285,20946648:20946998,20947070:20947179,20947411:20947578,20947731:20947861,20948247:20948425,20948675:20948753,20949001:20949054,20949180:20949281,20949475:20949575,20949742:20949817,20950039:20950155,20950382:20952194,20950735:20950877,20951082:20951161,20951512:20951683,20952014:20952268,20952419:20952587,20952778:20953096,20953465:20953553,20954160:20954328,20954161:20954259,20954514:20954562,20954798:20954823,20954933:20955033,20955120:20955139,20955264:20955366,20955413:20955426,20955517:20955607,20955657:20955669,20955762:20955857,20955903:20955961,20956148:20956208,20956254:20956353,20956406:20956467,20956552:20956608,20956664:20956755,20956813:20956821,20956952:20957003,20957086:20957176,20957251:20957308,20957384:20957397,20957518:20957574,20979333:20992682,20993497:20998027,20993498:20999185,20993500:20998182,20993502:20997532,20993504:20997434,20993506:20997356,20993508:20997041,20993510:20996815,20993512:2099621', 'assoc_mat': '20943975:carton:4230:20946167,20943976:carton:4230:20944345,20944756:carton:4230:20945195,20945561:carton:4230:20945873,20946202:carton:4230:20946285,20946648:carton:4230:20946998,20947070:carton:4230:20947179,20947411:carton:4230:20947578,20947731:carton:4230:20947861,20948247:carton:4230:20948425,20948675:carton:4230:20948753,20949001:carton:4230:20949054,20949180:carton:4230:20949281,20949475:carton:4230:20949575,20949742:carton:4230:20949817,20950039:carton:4230:20950155,20950382:carton:4230:20952194,20950735:carton:4230:20950877,20951082:carton:4230:20951161,20951512:carton:4230:20951683,20952014:carton:4230:20952268,20952419:carton:4230:20952587,20952778:carton:4230:20953096,20953465:carton:4230:20953553,20954160:carton:4230:20954328,20954161:carton:4230:20954259,20954514:carton:4230:20954562,20954798:carton:4230:20954823,20954933:carton:4230:20955033,20955120:carton:4230:20955139,20955264:carton:4230:20955366,20955413:carton:4230:20955426,20955517:carton:4230:20955607,20955657:carton:4230:20955669,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011995744372984287, 'nb_photo': 1703, 'list_port_cont': '20944340,20945193,20945878,20946168,20946284,20946995,20947857,20948417,20948749,20949061,20949279,20949569,20950147,20951669,20952201,20952267,20952580,20953086,20953560,20954256,20954330,20954566,20955358,20955420,20955674,20955855,20955966,20956205,20956337,20956601,20956763,20956825,20957181,20957399,20957573,20992675,20994459,20994559,20994945,20995399,20995468,20995529,20996132,20996317,20996856,20997346,20997420,20997516,20998168,20999177,21025938,21026106,21032063,21052387,21052848,21053524,21055012,21055464,21057445,21058487,21079006,21080261,21080445,21080803,21081024,21081439,21081664,21087407,21104271,21106898,21107587,21108569,21108983,21109576,21110455,21111677,21111744,21112102,21112658,21113661,21114237,21114935,21115331,21115705,21115976,21116364,21121388,21128630,21129664,21130471,21162419,21163907,21166069,21166243,21166461,21166510,21166544,21166739,21166873,21167155,21167259,21167361,21167486,21167838,21167977,21168096,21168347,21168488,21168541,21168770,21168941,21169059,21169108,2116923', 'assoc_port': '20943975:20946168,20943976:20944340,20944756:20945193,20945561:20945878,20946202:20946284,20946648:20946995,20947731:20947857,20948247:20948417,20948675:20948749,20949001:20949061,20949180:20949279,20949475:20949569,20950039:20950147,20950382:20952201,20951512:20951669,20952014:20952267,20952419:20952580,20952778:20953086,20953465:20953560,20954160:20954330,20954161:20954256,20954514:20954566,20955264:20955358,20955413:20955420,20955657:20955674,20955762:20955855,20955903:20955966,20956148:20956205,20956254:20956337,20956552:20956601,20956664:20956763,20956813:20956825,20957086:20957181,20957384:20957399,20957518:20957573,20979333:20992675,20993498:20999177,20993500:20998168,20993502:20997516,20993504:20997420,20993506:20997346,20993514:20996317,20993516:20996856,20993519:20995529,20993523:20996132,20993525:20994945,20993526:20995468,20993527:20995399,20993528:20994459,20993530:20994559,21009641:21026106,21025092:21025938,21027585:21079006,21027591:21121388,21027595:21080261,21027597:21080445,21027599:2108080', 'assoc_mat': '20943975:metal:4230:20946168,20943976:metal:4230:20944340,20944756:metal:4230:20945193,20945561:metal:4230:20945878,20946202:metal:4230:20946284,20946648:metal:4230:20946995,20947731:metal:4230:20947857,20948247:metal:4230:20948417,20948675:metal:4230:20948749,20949001:metal:4230:20949061,20949180:metal:4230:20949279,20949475:metal:4230:20949569,20950039:metal:4230:20950147,20950382:metal:4230:20952201,20951512:metal:4230:20951669,20952014:metal:4230:20952267,20952419:metal:4230:20952580,20952778:metal:4230:20953086,20953465:metal:4230:20953560,20954160:metal:4230:20954330,20954161:metal:4230:20954256,20954514:metal:4230:20954566,20955264:metal:4230:20955358,20955413:metal:4230:20955420,20955657:metal:4230:20955674,20955762:metal:4230:20955855,20955903:metal:4230:20955966,20956148:metal:4230:20956205,20956254:metal:4230:20956337,20956552:metal:4230:20956601,20956664:metal:4230:20956763,20956813:metal:4230:20956825,20957086:metal:4230:20957181,20957384:metal:4230:20957399,20957518:metal:4230:20957573,20979333:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2062599065700527, 'nb_photo': 423052, 'list_port_cont': '20944348,20945209,20945872,20946177,20946277,20946993,20947180,20947582,20947865,20948429,20948755,20949058,20949277,20949574,20949822,20950159,20950870,20951165,20951681,20952190,20952261,20952584,20953100,20953564,20954262,20954338,20954573,20954820,20955029,20955132,20955368,20955419,20955602,20955676,20955858,20955955,20956199,20956348,20956455,20956612,20956761,20956820,20957005,20957175,20957307,20957405,20957579,20992684,20994189,20994286,20994466,20994570,20994737,20994939,20995123,20995393,20995461,20995537,20996007,20996131,20996218,20996320,20996818,20996847,20997042,20997355,20997432,20997527,20998015,20998179,20999189,21025942,21026120,21032064,21033458,21052398,21052847,21053534,21055027,21055465,21057434,21058503,21078481,21078729,21079019,21079071,21079484,21079923,21080272,21080456,21080796,21081029,21081452,21081655,21087420,21089202,21103725,21104276,21105147,21106907,21107584,21108563,21108989,21109574,21110342,21110464,21111683,21111747,21112104,21112659,21113652,21114231,21114939,2111533', 'assoc_port': '20943975:20946177,20943976:20944348,20944756:20945209,20945561:20945872,20946202:20946277,20946648:20946993,20947070:20947180,20947411:20947582,20947731:20947865,20948247:20948429,20948675:20948755,20949001:20949058,20949180:20949277,20949475:20949574,20949742:20949822,20950039:20950159,20950382:20952190,20950735:20950870,20951082:20951165,20951512:20951681,20952014:20952261,20952419:20952584,20952778:20953100,20953465:20953564,20954160:20954338,20954161:20954262,20954514:20954573,20954798:20954820,20954933:20955029,20955120:20955132,20955264:20955368,20955413:20955419,20955517:20955602,20955657:20955676,20955762:20955858,20955903:20955955,20956148:20956199,20956254:20956348,20956406:20956455,20956552:20956612,20956664:20956761,20956813:20956820,20956952:20957005,20957086:20957175,20957251:20957307,20957384:20957405,20957518:20957579,20979333:20992684,20993497:20998015,20993498:20999189,20993500:20998179,20993502:20997527,20993504:20997432,20993506:20997355,20993508:20997042,20993510:20996818,20993512:2099621', 'assoc_mat': '20943975:papier:4230:20946177,20943976:papier:4230:20944348,20944756:papier:4230:20945209,20945561:papier:4230:20945872,20946202:papier:4230:20946277,20946648:papier:4230:20946993,20947070:papier:4230:20947180,20947411:papier:4230:20947582,20947731:papier:4230:20947865,20948247:papier:4230:20948429,20948675:papier:4230:20948755,20949001:papier:4230:20949058,20949180:papier:4230:20949277,20949475:papier:4230:20949574,20949742:papier:4230:20949822,20950039:papier:4230:20950159,20950382:papier:4230:20952190,20950735:papier:4230:20950870,20951082:papier:4230:20951165,20951512:papier:4230:20951681,20952014:papier:4230:20952261,20952419:papier:4230:20952584,20952778:papier:4230:20953100,20953465:papier:4230:20953564,20954160:papier:4230:20954338,20954161:papier:4230:20954262,20954514:papier:4230:20954573,20954798:papier:4230:20954820,20954933:papier:4230:20955029,20955120:papier:4230:20955132,20955264:papier:4230:20955368,20955413:papier:4230:20955419,20955517:papier:4230:20955602,20955657:papier:4230:20955676,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0045914755933246145, 'nb_photo': 2731, 'list_port_cont': '20944350,20945204,20945870,20946182,20946283,20947002,20947581,20947870,20948419,20948764,20949063,20949286,20949573,20949818,20950152,20950867,20951168,20951678,20952197,20952271,20952595,20953093,20953561,20954329,20955035,20955359,20955424,20955848,20955965,20956204,20956350,20956461,20956753,20956833,20957183,20957305,20957567,20992673,20994573,20994942,20995386,20995471,20995535,20996134,20996319,20996858,20997357,21025943,21026116,21032074,21052396,21052857,21055020,21055463,21057448,21058499,21078733,21079016,21080265,21080808,21081455,21081658,21087422,21089206,21103729,21104274,21105141,21106906,21107586,21108559,21108979,21109579,21110345,21110460,21111672,21111746,21112113,21112660,21113665,21114936,21115343,21115487,21115713,21116367,21121387,21128627,21129654,21130479,21162429,21163908,21165891,21166084,21166245,21166458,21166504,21166550,21166733,21166877,21167163,21167364,21167494,21167840,21167989,21168091,21168335,21168544,21168776,21168846,21168952,21169061,21169096,21169233,21169987,2117018', 'assoc_port': '20943975:20946182,20943976:20944350,20944756:20945204,20945561:20945870,20946202:20946283,20946648:20947002,20947411:20947581,20947731:20947870,20948247:20948419,20948675:20948764,20949001:20949063,20949180:20949286,20949475:20949573,20949742:20949818,20950039:20950152,20950382:20952197,20950735:20950867,20951082:20951168,20951512:20951678,20952014:20952271,20952419:20952595,20952778:20953093,20953465:20953561,20954160:20954329,20954933:20955035,20955264:20955359,20955413:20955424,20955762:20955848,20955903:20955965,20956148:20956204,20956254:20956350,20956406:20956461,20956664:20956753,20956813:20956833,20957086:20957183,20957251:20957305,20957518:20957567,20979333:20992673,20993506:20997357,20993514:20996319,20993516:20996858,20993519:20995535,20993523:20996134,20993525:20994942,20993526:20995471,20993527:20995386,20993530:20994573,21009641:21026116,21025092:21025943,21027583:21078733,21027585:21079016,21027591:21121387,21027595:21080265,21027599:21080808,21027603:21081455,21027605:21081658,21027607:2105546', 'assoc_mat': '20943975:pehd:4230:20946182,20943976:pehd:4230:20944350,20944756:pehd:4230:20945204,20945561:pehd:4230:20945870,20946202:pehd:4230:20946283,20946648:pehd:4230:20947002,20947411:pehd:4230:20947581,20947731:pehd:4230:20947870,20948247:pehd:4230:20948419,20948675:pehd:4230:20948764,20949001:pehd:4230:20949063,20949180:pehd:4230:20949286,20949475:pehd:4230:20949573,20949742:pehd:4230:20949818,20950039:pehd:4230:20950152,20950382:pehd:4230:20952197,20950735:pehd:4230:20950867,20951082:pehd:4230:20951168,20951512:pehd:4230:20951678,20952014:pehd:4230:20952271,20952419:pehd:4230:20952595,20952778:pehd:4230:20953093,20953465:pehd:4230:20953561,20954160:pehd:4230:20954329,20954933:pehd:4230:20955035,20955264:pehd:4230:20955359,20955413:pehd:4230:20955424,20955762:pehd:4230:20955848,20955903:pehd:4230:20955965,20956148:pehd:4230:20956204,20956254:pehd:4230:20956350,20956406:pehd:4230:20956461,20956664:pehd:4230:20956753,20956813:pehd:4230:20956833,20957086:pehd:4230:20957183,20957251:pehd:4230:20957305,20957518:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014956224677621586, 'nb_photo': 24603, 'list_port_cont': '20944341,20945207,20945866,20946176,20946278,20946994,20947184,20947576,20947873,20948432,20948760,20949060,20949287,20949572,20949819,20950157,20950878,20951169,20951674,20952195,20952272,20952597,20953099,20953562,20954260,20954332,20954563,20954818,20955027,20955130,20955367,20955434,20955613,20955667,20955861,20955962,20956209,20956342,20956459,20956603,20956762,20956823,20957010,20957174,20957310,20957406,20957581,20992683,20994188,20994288,20994463,20994572,20994734,20994950,20995126,20995396,20995472,20995539,20996006,20996133,20996216,20996326,20996819,20996853,20997045,20997347,20997431,20997520,20998026,20998177,20999188,21025929,21026118,21032066,21033461,21052393,21052858,21053533,21055021,21055462,21057442,21058500,21078482,21078730,21079018,21079078,21079481,21079928,21080273,21080457,21080805,21081030,21081444,21081663,21087418,21089197,21103719,21104269,21105149,21106904,21107582,21108568,21108980,21109581,21110333,21110467,21111688,21111748,21112111,21112662,21113666,21114240,21114928,2111534', 'assoc_port': '20943975:20946176,20943976:20944341,20944756:20945207,20945561:20945866,20946202:20946278,20946648:20946994,20947070:20947184,20947411:20947576,20947731:20947873,20948247:20948432,20948675:20948760,20949001:20949060,20949180:20949287,20949475:20949572,20949742:20949819,20950039:20950157,20950382:20952195,20950735:20950878,20951082:20951169,20951512:20951674,20952014:20952272,20952419:20952597,20952778:20953099,20953465:20953562,20954160:20954332,20954161:20954260,20954514:20954563,20954798:20954818,20954933:20955027,20955120:20955130,20955264:20955367,20955413:20955434,20955517:20955613,20955657:20955667,20955762:20955861,20955903:20955962,20956148:20956209,20956254:20956342,20956406:20956459,20956552:20956603,20956664:20956762,20956813:20956823,20956952:20957010,20957086:20957174,20957251:20957310,20957384:20957406,20957518:20957581,20979333:20992683,20993497:20998026,20993498:20999188,20993500:20998177,20993502:20997520,20993504:20997431,20993506:20997347,20993508:20997045,20993510:20996819,20993512:2099621', 'assoc_mat': '20943975:pet_clair:4230:20946176,20943976:pet_clair:4230:20944341,20944756:pet_clair:4230:20945207,20945561:pet_clair:4230:20945866,20946202:pet_clair:4230:20946278,20946648:pet_clair:4230:20946994,20947070:pet_clair:4230:20947184,20947411:pet_clair:4230:20947576,20947731:pet_clair:4230:20947873,20948247:pet_clair:4230:20948432,20948675:pet_clair:4230:20948760,20949001:pet_clair:4230:20949060,20949180:pet_clair:4230:20949287,20949475:pet_clair:4230:20949572,20949742:pet_clair:4230:20949819,20950039:pet_clair:4230:20950157,20950382:pet_clair:4230:20952195,20950735:pet_clair:4230:20950878,20951082:pet_clair:4230:20951169,20951512:pet_clair:4230:20951674,20952014:pet_clair:4230:20952272,20952419:pet_clair:4230:20952597,20952778:pet_clair:4230:20953099,20953465:pet_clair:4230:20953562,20954160:pet_clair:4230:20954332,20954161:pet_clair:4230:20954260,20954514:pet_clair:4230:20954563,20954798:pet_clair:4230:20954818,20954933:pet_clair:4230:20955027,20955120:pet_clair:4230:20955130,20955264:pet_clair:4230:20955367,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002962719796122446, 'nb_photo': 1319, 'list_port_cont': '20945205,20946183,20946274,20948427,20948762,20949062,20949565,20949808,20950151,20950873,20951167,20951682,20952198,20952270,20953101,20953554,20954568,20955433,20955599,20955849,20956351,20956462,20956607,20956759,20956832,20957008,20957180,20957398,20994281,20994569,20994728,20994947,20995121,20995473,20996129,20996321,20996848,21026108,21052392,21052856,21057449,21058502,21078477,21079021,21079075,21080268,21080809,21081033,21081451,21081662,21087421,21089201,21103721,21104278,21105143,21106897,21107591,21108560,21108985,21109578,21110347,21111743,21112109,21112652,21113667,21114229,21115987,21116376,21129658,21130480,21163914,21166085,21166255,21166464,21166511,21166881,21167162,21167270,21167353,21167843,21167990,21168339,21168535,21168769,21168940,21169069,21169229,21169996,21173704,21175462,21177487,21180889,21181847,21182807,21184040,21184343,21186345,21187772,21190823,21191704,21192801,21192961,21193410,21193543,21193924,21194139,21213208,21213317,21213432,21213522,21213561,21213660,21213802,2121391', 'assoc_port': '20943975:20946183,20944756:20945205,20946202:20946274,20948247:20948427,20948675:20948762,20949001:20949062,20949475:20949565,20949742:20949808,20950039:20950151,20950382:20952198,20950735:20950873,20951082:20951167,20951512:20951682,20952014:20952270,20952778:20953101,20953465:20953554,20954514:20954568,20955413:20955433,20955517:20955599,20955762:20955849,20956254:20956351,20956406:20956462,20956552:20956607,20956664:20956759,20956813:20956832,20956952:20957008,20957086:20957180,20957384:20957398,20993514:20996321,20993516:20996848,20993523:20996129,20993525:20994947,20993526:20995473,20993529:20994728,20993530:20994569,20994209:20994281,20995011:20995121,21009641:21026108,21027581:21078477,21027585:21079021,21027587:21079075,21027595:21080268,21027599:21080809,21027601:21081033,21027603:21081451,21027605:21081662,21027609:21057449,21027610:21058502,21027614:21052856,21027615:21052392,21084490:21115987,21084491:21116376,21084495:21114229,21084498:21112109,21084499:21112652,21084501:21113667,21084502:2111034', 'assoc_mat': '20943975:pet_fonce:4230:20946183,20944756:pet_fonce:4230:20945205,20946202:pet_fonce:4230:20946274,20948247:pet_fonce:4230:20948427,20948675:pet_fonce:4230:20948762,20949001:pet_fonce:4230:20949062,20949475:pet_fonce:4230:20949565,20949742:pet_fonce:4230:20949808,20950039:pet_fonce:4230:20950151,20950382:pet_fonce:4230:20952198,20950735:pet_fonce:4230:20950873,20951082:pet_fonce:4230:20951167,20951512:pet_fonce:4230:20951682,20952014:pet_fonce:4230:20952270,20952778:pet_fonce:4230:20953101,20953465:pet_fonce:4230:20953554,20954514:pet_fonce:4230:20954568,20955413:pet_fonce:4230:20955433,20955517:pet_fonce:4230:20955599,20955762:pet_fonce:4230:20955849,20956254:pet_fonce:4230:20956351,20956406:pet_fonce:4230:20956462,20956552:pet_fonce:4230:20956607,20956664:pet_fonce:4230:20956759,20956813:pet_fonce:4230:20956832,20956952:pet_fonce:4230:20957008,20957086:pet_fonce:4230:20957180,20957384:pet_fonce:4230:20957398,20993514:pet_fonce:4230:20996321,20993516:pet_fonce:4230:20996848,20993523:pet_fonce:4230:20996129,2'}), 'main_stat': {'nb_photos': 2026}, 'velours_link': 'https://www.fotonower.com/velours/30124855,30124856,30124857,30124858,30124859,30124860,30124861?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-03', 0.7416304404041119),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_03_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.57%', 20670], 'carton': ['carton', '5.26%', 93570], 'metal': ['metal', '0.12%', 1703], 'papier': ['papier', '20.63%', 423052], 'pehd': ['pehd', '0.46%', 2731], 'pet_clair': ['pet_clair', '1.5%', 24603], 'pet_fonce': ['pet_fonce', '0.3%', 1319]}} 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_03_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.40user 2.48system 0:17.89elapsed 27%CPU (0avgtext+0avgdata 184256maxresident)k 7256inputs+384outputs (27major+48417minor)pagefaults 0swaps