python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j exemple_contaminant_stat -v --date_start="2025-12-01" --date_end="2025-12-31" --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : _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 TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Working exemple contaminant stat SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-12-01" AND ded.date <= "2025-12-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 (2685025,2689701,2697181,2703918,2710209,2722873,2722857,2716815,2719445,2725917,2735595,2739029,2742686,2743210,2748550,2754948,2761363,2768175,2774117,2777581,2778144,2782725,2788309,2794689,2799961,2805191,2809662,2810376,2815647,2822677,2829216) 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.014475072819079988, 'nb_photo': 16888, 'list_port_cont': '29034674,29034750,29034897,29034967,29038095,29038479,29039297,29042373,29044301,29050032,29050261,29050515,29050643,29053503,29053521,29085975,29086167,29086399,29086704,29087150,29087690,29092417,29093016,29112996,29113321,29113504,29113863,29114114,29114569,29114984,29115272,29115564,29116076,29116131,29116517,29116565,29116738,29117041,29117329,29117848,29117977,29118289,29118734,29118961,29119380,29124194,29124605,29160077,29160124,29160189,29160221,29160417,29160455,29160549,29160628,29160665,29160769,29160905,29161038,29161078,29161123,29161200,29161322,29161369,29161451,29161479,29161597,29162080,29164446,29165406,29166302,29198291,29198477,29198685,29200459,29200721,29200799,29200915,29201133,29201452,29201634,29201694,29201720,29201834,29201975,29202151,29202247,29202468,29202544,29202693,29202847,29203006,29203190,29203227,29203420,29237766,29237888,29238048,29238088,29238214,29238265,29238393,29238464,29238509,29238562,29238620,29238775,29238923,29238961,29239025,29239109,29239142,29239208,2923935', 'assoc_port': '29034545:29034750,29034546:29034674,29034792:29039297,29034854:29034897,29034951:29034967,29037834:29038479,29037835:29038095,29039887:29044301,29041924:29042373,29043379:29050515,29049662:29050643,29049680:29050261,29049698:29050032,29053189:29053521,29053191:29053503,29085008:29087690,29085011:29087150,29085012:29093016,29085015:29086704,29085036:29086399,29085039:29086167,29085053:29085975,29085065:29092417,29112740:29124605,29112743:29118289,29112746:29118961,29112748:29117977,29112765:29117329,29112771:29117848,29112775:29117041,29112780:29116565,29112784:29116738,29112789:29116517,29112807:29116131,29112826:29116076,29112828:29115564,29112831:29115272,29112832:29114984,29112846:29114569,29112860:29114114,29112862:29113863,29112864:29113504,29112867:29119380,29112869:29112996,29112871:29113321,29118222:29118734,29118225:29124194,29159957:29166302,29159960:29161451,29159963:29161597,29159966:29161369,29159968:29161479,29159971:29161322,29159976:29161123,29159977:29161200,29159981:29161078,29159984:2916103', 'assoc_mat': '29034545:autre:4230:29034750,29034546:autre:4230:29034674,29034792:autre:4230:29039297,29034854:autre:4230:29034897,29034951:autre:4230:29034967,29037834:autre:4230:29038479,29037835:autre:4230:29038095,29039887:autre:4230:29044301,29041924:autre:4230:29042373,29043379:autre:4230:29050515,29049662:autre:4230:29050643,29049680:autre:4230:29050261,29049698:autre:4230:29050032,29053189:autre:4230:29053521,29053191:autre:4230:29053503,29085008:autre:4230:29087690,29085011:autre:4230:29087150,29085012:autre:4230:29093016,29085015:autre:4230:29086704,29085036:autre:4230:29086399,29085039:autre:4230:29086167,29085053:autre:4230:29085975,29085065:autre:4230:29092417,29112740:autre:4230:29124605,29112743:autre:4230:29118289,29112746:autre:4230:29118961,29112748:autre:4230:29117977,29112765:autre:4230:29117329,29112771:autre:4230:29117848,29112775:autre:4230:29117041,29112780:autre:4230:29116565,29112784:autre:4230:29116738,29112789:autre:4230:29116517,29112807:autre:4230:29116131,29112826:autre:4230:29116076,29112828:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.050351798930968514, 'nb_photo': 92421, 'list_port_cont': '29034667,29034740,29034910,29034965,29038099,29038482,29039300,29042358,29044299,29050037,29050260,29050512,29050652,29053508,29053528,29085984,29086175,29086392,29086712,29087161,29087689,29092428,29093020,29112986,29113325,29113499,29113874,29114115,29114575,29114994,29115281,29115552,29116081,29116134,29116507,29116577,29116731,29117049,29117325,29117863,29117978,29118288,29118747,29118964,29119378,29124200,29124606,29160076,29160117,29160196,29160230,29160425,29160464,29160543,29160624,29160657,29160768,29160917,29161051,29161080,29161131,29161211,29161321,29161371,29161447,29161482,29161584,29162096,29164454,29165398,29166313,29198302,29198478,29198689,29200464,29200725,29200813,29200921,29201134,29201456,29201636,29201682,29201733,29201844,29201978,29202137,29202256,29202460,29202548,29202696,29202855,29203010,29203194,29203228,29203415,29237780,29237889,29238052,29238089,29238204,29238264,29238390,29238451,29238521,29238558,29238615,29238780,29238931,29238967,29239040,29239103,29239149,29239215,2923937', 'assoc_port': '29034545:29034740,29034546:29034667,29034792:29039300,29034854:29034910,29034951:29034965,29037834:29038482,29037835:29038099,29039887:29044299,29041924:29042358,29043379:29050512,29049662:29050652,29049680:29050260,29049698:29050037,29053189:29053528,29053191:29053508,29085008:29087689,29085011:29087161,29085012:29093020,29085015:29086712,29085036:29086392,29085039:29086175,29085053:29085984,29085065:29092428,29112740:29124606,29112743:29118288,29112746:29118964,29112748:29117978,29112765:29117325,29112771:29117863,29112775:29117049,29112780:29116577,29112784:29116731,29112789:29116507,29112807:29116134,29112826:29116081,29112828:29115552,29112831:29115281,29112832:29114994,29112846:29114575,29112860:29114115,29112862:29113874,29112864:29113499,29112867:29119378,29112869:29112986,29112871:29113325,29118222:29118747,29118225:29124200,29159957:29166313,29159960:29161447,29159963:29161584,29159966:29161371,29159968:29161482,29159971:29161321,29159976:29161131,29159977:29161211,29159981:29161080,29159984:2916105', 'assoc_mat': '29034545:carton:4230:29034740,29034546:carton:4230:29034667,29034792:carton:4230:29039300,29034854:carton:4230:29034910,29034951:carton:4230:29034965,29037834:carton:4230:29038482,29037835:carton:4230:29038099,29039887:carton:4230:29044299,29041924:carton:4230:29042358,29043379:carton:4230:29050512,29049662:carton:4230:29050652,29049680:carton:4230:29050260,29049698:carton:4230:29050037,29053189:carton:4230:29053528,29053191:carton:4230:29053508,29085008:carton:4230:29087689,29085011:carton:4230:29087161,29085012:carton:4230:29093020,29085015:carton:4230:29086712,29085036:carton:4230:29086392,29085039:carton:4230:29086175,29085053:carton:4230:29085984,29085065:carton:4230:29092428,29112740:carton:4230:29124606,29112743:carton:4230:29118288,29112746:carton:4230:29118964,29112748:carton:4230:29117978,29112765:carton:4230:29117325,29112771:carton:4230:29117863,29112775:carton:4230:29117049,29112780:carton:4230:29116577,29112784:carton:4230:29116731,29112789:carton:4230:29116507,29112807:carton:4230:29116134,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00189595394934949, 'nb_photo': 1895, 'list_port_cont': '29034675,29034738,29034900,29034971,29038085,29038484,29039292,29042372,29044289,29050045,29050252,29050506,29050647,29053507,29053532,29086166,29086395,29086696,29087156,29087675,29092429,29093013,29112984,29113316,29113498,29113868,29114110,29114563,29114987,29115282,29115553,29116078,29116137,29116512,29116574,29116739,29117318,29117854,29118738,29118950,29119370,29160073,29160121,29160179,29160227,29160433,29160553,29160613,29160652,29160763,29160904,29161036,29161079,29161213,29161311,29161363,29161439,29161472,29161596,29162092,29164450,29165404,29166315,29198304,29198475,29198675,29200720,29200811,29200914,29201122,29201449,29201625,29201696,29201724,29201845,29201982,29202140,29202243,29202451,29202683,29202845,29202996,29203192,29203219,29203418,29237765,29237885,29238044,29238079,29238200,29238256,29238381,29238452,29238517,29238557,29238607,29238774,29238922,29238952,29239038,29239214,29239354,29239454,29240102,29266756,29266793,29266829,29266896,29267058,29267060,29267160,29267246,29267316,2926746', 'assoc_port': '29034545:29034738,29034546:29034675,29034792:29039292,29034854:29034900,29034951:29034971,29037834:29038484,29037835:29038085,29039887:29044289,29041924:29042372,29043379:29050506,29049662:29050647,29049680:29050252,29049698:29050045,29053189:29053532,29053191:29053507,29085008:29087675,29085011:29087156,29085012:29093013,29085015:29086696,29085036:29086395,29085039:29086166,29085065:29092429,29112746:29118950,29112765:29117318,29112771:29117854,29112780:29116574,29112784:29116739,29112789:29116512,29112807:29116137,29112826:29116078,29112828:29115553,29112831:29115282,29112832:29114987,29112846:29114563,29112860:29114110,29112862:29113868,29112864:29113498,29112867:29119370,29112869:29112984,29112871:29113316,29118222:29118738,29159957:29166315,29159960:29161439,29159963:29161596,29159966:29161363,29159968:29161472,29159971:29161311,29159977:29161213,29159981:29161079,29159984:29161036,29159986:29160904,29159988:29160763,29159991:29165404,29159992:29160652,29159994:29160613,29159997:29160553,29160001:2916043', 'assoc_mat': '29034545:metal:4230:29034738,29034546:metal:4230:29034675,29034792:metal:4230:29039292,29034854:metal:4230:29034900,29034951:metal:4230:29034971,29037834:metal:4230:29038484,29037835:metal:4230:29038085,29039887:metal:4230:29044289,29041924:metal:4230:29042372,29043379:metal:4230:29050506,29049662:metal:4230:29050647,29049680:metal:4230:29050252,29049698:metal:4230:29050045,29053189:metal:4230:29053532,29053191:metal:4230:29053507,29085008:metal:4230:29087675,29085011:metal:4230:29087156,29085012:metal:4230:29093013,29085015:metal:4230:29086696,29085036:metal:4230:29086395,29085039:metal:4230:29086166,29085065:metal:4230:29092429,29112746:metal:4230:29118950,29112765:metal:4230:29117318,29112771:metal:4230:29117854,29112780:metal:4230:29116574,29112784:metal:4230:29116739,29112789:metal:4230:29116512,29112807:metal:4230:29116137,29112826:metal:4230:29116078,29112828:metal:4230:29115553,29112831:metal:4230:29115282,29112832:metal:4230:29114987,29112846:metal:4230:29114563,29112860:metal:4230:29114110,29112862:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1913526591552004, 'nb_photo': 309268, 'list_port_cont': '29034679,29034737,29034907,29034975,29038096,29038472,29039303,29042366,29044304,29050043,29050262,29050517,29050640,29053511,29053529,29085982,29086165,29086390,29086698,29087165,29087688,29092431,29093029,29112998,29113326,29113505,29113875,29114123,29114579,29114988,29115278,29115563,29116087,29116127,29116518,29116572,29116734,29117047,29117330,29117851,29117966,29118304,29118751,29118957,29119385,29124189,29124598,29160081,29160115,29160192,29160220,29160429,29160465,29160556,29160623,29160673,29160772,29160919,29161048,29161073,29161130,29161212,29161313,29161376,29161435,29161485,29161586,29162083,29164448,29165403,29166308,29198300,29198480,29198687,29200450,29200719,29200802,29200929,29201121,29201450,29201632,29201690,29201729,29201846,29201981,29202150,29202255,29202462,29202545,29202684,29202854,29203005,29203183,29203225,29203422,29237779,29237892,29238040,29238080,29238209,29238259,29238391,29238462,29238518,29238553,29238612,29238782,29238929,29238966,29239033,29239114,29239138,29239217,2923937', 'assoc_port': '29034545:29034737,29034546:29034679,29034792:29039303,29034854:29034907,29034951:29034975,29037834:29038472,29037835:29038096,29039887:29044304,29041924:29042366,29043379:29050517,29049662:29050640,29049680:29050262,29049698:29050043,29053189:29053529,29053191:29053511,29085008:29087688,29085011:29087165,29085012:29093029,29085015:29086698,29085036:29086390,29085039:29086165,29085053:29085982,29085065:29092431,29112740:29124598,29112743:29118304,29112746:29118957,29112748:29117966,29112765:29117330,29112771:29117851,29112775:29117047,29112780:29116572,29112784:29116734,29112789:29116518,29112807:29116127,29112826:29116087,29112828:29115563,29112831:29115278,29112832:29114988,29112846:29114579,29112860:29114123,29112862:29113875,29112864:29113505,29112867:29119385,29112869:29112998,29112871:29113326,29118222:29118751,29118225:29124189,29159957:29166308,29159960:29161435,29159963:29161586,29159966:29161376,29159968:29161485,29159971:29161313,29159976:29161130,29159977:29161212,29159981:29161073,29159984:2916104', 'assoc_mat': '29034545:papier:4230:29034737,29034546:papier:4230:29034679,29034792:papier:4230:29039303,29034854:papier:4230:29034907,29034951:papier:4230:29034975,29037834:papier:4230:29038472,29037835:papier:4230:29038096,29039887:papier:4230:29044304,29041924:papier:4230:29042366,29043379:papier:4230:29050517,29049662:papier:4230:29050640,29049680:papier:4230:29050262,29049698:papier:4230:29050043,29053189:papier:4230:29053529,29053191:papier:4230:29053511,29085008:papier:4230:29087688,29085011:papier:4230:29087165,29085012:papier:4230:29093029,29085015:papier:4230:29086698,29085036:papier:4230:29086390,29085039:papier:4230:29086165,29085053:papier:4230:29085982,29085065:papier:4230:29092431,29112740:papier:4230:29124598,29112743:papier:4230:29118304,29112746:papier:4230:29118957,29112748:papier:4230:29117966,29112765:papier:4230:29117330,29112771:papier:4230:29117851,29112775:papier:4230:29117047,29112780:papier:4230:29116572,29112784:papier:4230:29116734,29112789:papier:4230:29116518,29112807:papier:4230:29116127,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003041286872350902, 'nb_photo': 2003, 'list_port_cont': '29034672,29034752,29038100,29039304,29042370,29044292,29050035,29050516,29050653,29053515,29053533,29085980,29086401,29086710,29087164,29087695,29092430,29093024,29112991,29113331,29113506,29113872,29114120,29114577,29114983,29115280,29115562,29116082,29116146,29116508,29116575,29116736,29117036,29117328,29117971,29118750,29119381,29124197,29124604,29160085,29160122,29160191,29160233,29160432,29160463,29160551,29160627,29160671,29160766,29160914,29161045,29161081,29161136,29161210,29161318,29161450,29161484,29161593,29162098,29164457,29165407,29166317,29198299,29198473,29198681,29200462,29200727,29200804,29200916,29201123,29201458,29201633,29201684,29201728,29201849,29201972,29202147,29202252,29202467,29202546,29202688,29202852,29203004,29203185,29203218,29203421,29237773,29237876,29238039,29238086,29238213,29238266,29238384,29238523,29238555,29238616,29238776,29238925,29238956,29239034,29239150,29239222,29239364,29239471,29239631,29240114,29266757,29266797,29266832,29266906,29267057,29267066,29267155,2926724', 'assoc_port': '29034545:29034752,29034546:29034672,29034792:29039304,29037835:29038100,29039887:29044292,29041924:29042370,29043379:29050516,29049662:29050653,29049698:29050035,29053189:29053533,29053191:29053515,29085008:29087695,29085011:29087164,29085012:29093024,29085015:29086710,29085036:29086401,29085053:29085980,29085065:29092430,29112740:29124604,29112748:29117971,29112765:29117328,29112775:29117036,29112780:29116575,29112784:29116736,29112789:29116508,29112807:29116146,29112826:29116082,29112828:29115562,29112831:29115280,29112832:29114983,29112846:29114577,29112860:29114120,29112862:29113872,29112864:29113506,29112867:29119381,29112869:29112991,29112871:29113331,29118222:29118750,29118225:29124197,29159957:29166317,29159960:29161450,29159963:29161593,29159968:29161484,29159971:29161318,29159976:29161136,29159977:29161210,29159981:29161081,29159984:29161045,29159986:29160914,29159988:29160766,29159991:29165407,29159992:29160671,29159994:29160627,29159997:29160551,29159999:29160463,29160001:29160432,29160003:2916008', 'assoc_mat': '29034545:pehd:4230:29034752,29034546:pehd:4230:29034672,29034792:pehd:4230:29039304,29037835:pehd:4230:29038100,29039887:pehd:4230:29044292,29041924:pehd:4230:29042370,29043379:pehd:4230:29050516,29049662:pehd:4230:29050653,29049698:pehd:4230:29050035,29053189:pehd:4230:29053533,29053191:pehd:4230:29053515,29085008:pehd:4230:29087695,29085011:pehd:4230:29087164,29085012:pehd:4230:29093024,29085015:pehd:4230:29086710,29085036:pehd:4230:29086401,29085053:pehd:4230:29085980,29085065:pehd:4230:29092430,29112740:pehd:4230:29124604,29112748:pehd:4230:29117971,29112765:pehd:4230:29117328,29112775:pehd:4230:29117036,29112780:pehd:4230:29116575,29112784:pehd:4230:29116736,29112789:pehd:4230:29116508,29112807:pehd:4230:29116146,29112826:pehd:4230:29116082,29112828:pehd:4230:29115562,29112831:pehd:4230:29115280,29112832:pehd:4230:29114983,29112846:pehd:4230:29114577,29112860:pehd:4230:29114120,29112862:pehd:4230:29113872,29112864:pehd:4230:29113506,29112867:pehd:4230:29119381,29112869:pehd:4230:29112991,29112871:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01816294898280272, 'nb_photo': 30041, 'list_port_cont': '29034673,29034745,29034904,29034964,29038101,29038477,29039296,29042362,29044295,29050048,29050264,29050518,29050646,29053514,29053526,29085977,29086177,29086396,29086708,29087163,29087691,29092426,29093027,29112999,29113333,29113494,29113880,29114113,29114574,29114992,29115284,29115560,29116090,29116135,29116514,29116578,29116727,29117046,29117332,29117861,29117973,29118303,29118740,29118951,29119377,29124201,29124595,29160080,29160113,29160195,29160225,29160426,29160468,29160552,29160617,29160653,29160767,29160918,29161046,29161088,29161129,29161206,29161320,29161367,29161449,29161483,29161598,29162090,29164455,29165400,29166314,29198303,29198484,29198680,29200460,29200729,29200812,29200923,29201132,29201459,29201622,29201692,29201730,29201837,29201968,29202148,29202258,29202458,29202550,29202695,29202850,29203009,29203191,29203234,29203411,29237777,29237883,29238049,29238081,29238211,29238257,29238387,29238460,29238524,29238556,29238622,29238781,29238932,29238968,29239035,29239110,29239144,29239219,2923936', 'assoc_port': '29034545:29034745,29034546:29034673,29034792:29039296,29034854:29034904,29034951:29034964,29037834:29038477,29037835:29038101,29039887:29044295,29041924:29042362,29043379:29050518,29049662:29050646,29049680:29050264,29049698:29050048,29053189:29053526,29053191:29053514,29085008:29087691,29085011:29087163,29085012:29093027,29085015:29086708,29085036:29086396,29085039:29086177,29085053:29085977,29085065:29092426,29112740:29124595,29112743:29118303,29112746:29118951,29112748:29117973,29112765:29117332,29112771:29117861,29112775:29117046,29112780:29116578,29112784:29116727,29112789:29116514,29112807:29116135,29112826:29116090,29112828:29115560,29112831:29115284,29112832:29114992,29112846:29114574,29112860:29114113,29112862:29113880,29112864:29113494,29112867:29119377,29112869:29112999,29112871:29113333,29118222:29118740,29118225:29124201,29159957:29166314,29159960:29161449,29159963:29161598,29159966:29161367,29159968:29161483,29159971:29161320,29159976:29161129,29159977:29161206,29159981:29161088,29159984:2916104', 'assoc_mat': '29034545:pet_clair:4230:29034745,29034546:pet_clair:4230:29034673,29034792:pet_clair:4230:29039296,29034854:pet_clair:4230:29034904,29034951:pet_clair:4230:29034964,29037834:pet_clair:4230:29038477,29037835:pet_clair:4230:29038101,29039887:pet_clair:4230:29044295,29041924:pet_clair:4230:29042362,29043379:pet_clair:4230:29050518,29049662:pet_clair:4230:29050646,29049680:pet_clair:4230:29050264,29049698:pet_clair:4230:29050048,29053189:pet_clair:4230:29053526,29053191:pet_clair:4230:29053514,29085008:pet_clair:4230:29087691,29085011:pet_clair:4230:29087163,29085012:pet_clair:4230:29093027,29085015:pet_clair:4230:29086708,29085036:pet_clair:4230:29086396,29085039:pet_clair:4230:29086177,29085053:pet_clair:4230:29085977,29085065:pet_clair:4230:29092426,29112740:pet_clair:4230:29124595,29112743:pet_clair:4230:29118303,29112746:pet_clair:4230:29118951,29112748:pet_clair:4230:29117973,29112765:pet_clair:4230:29117332,29112771:pet_clair:4230:29117861,29112775:pet_clair:4230:29117046,29112780:pet_clair:4230:29116578,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026357464249241428, 'nb_photo': 797, 'list_port_cont': '29034678,29034751,29042367,29044303,29050040,29050253,29050513,29050642,29053512,29085986,29086172,29086397,29087160,29087696,29112992,29113502,29113878,29114118,29114578,29114990,29115283,29115556,29116088,29116141,29116509,29116571,29116737,29117042,29117326,29117860,29117969,29118963,29119379,29124601,29160083,29160118,29160185,29160427,29160461,29160557,29160771,29161134,29161208,29161475,29165405,29198307,29198479,29198688,29200457,29200718,29200809,29200927,29201131,29201455,29201688,29201842,29201977,29202254,29203181,29203232,29203410,29237782,29237890,29238047,29238083,29238267,29238386,29238525,29238550,29238611,29238926,29238960,29239036,29239113,29239147,29239212,29239360,29239465,29239638,29266798,29266826,29266908,29267051,29267070,29267263,29267450,29267633,29280707,29282938,29282999,29283207,29283328,29283396,29284034,29298728,29298848,29300006,29300137,29300355,29300451,29300565,29300601,29300774,29300809,29301064,29301172,29301327,29301875,29302158,29302281,29302870,29303026,29303072,2930607', 'assoc_port': '29034545:29034751,29034546:29034678,29039887:29044303,29041924:29042367,29043379:29050513,29049662:29050642,29049680:29050253,29049698:29050040,29053191:29053512,29085008:29087696,29085011:29087160,29085036:29086397,29085039:29086172,29085053:29085986,29112740:29124601,29112746:29118963,29112748:29117969,29112765:29117326,29112771:29117860,29112775:29117042,29112780:29116571,29112784:29116737,29112789:29116509,29112807:29116141,29112826:29116088,29112828:29115556,29112831:29115283,29112832:29114990,29112846:29114578,29112860:29114118,29112862:29113878,29112864:29113502,29112867:29119379,29112869:29112992,29159968:29161475,29159976:29161134,29159977:29161208,29159988:29160771,29159991:29165405,29159997:29160557,29159999:29160461,29160001:29160427,29160003:29160083,29160004:29160185,29160006:29160118,29197827:29203232,29197836:29203181,29197864:29202254,29197879:29198479,29197898:29201977,29197902:29201842,29197943:29201131,29197945:29201688,29197959:29201455,29197973:29200718,29197974:29200809,29197975:2920045', 'assoc_mat': '29034545:pet_fonce:4230:29034751,29034546:pet_fonce:4230:29034678,29039887:pet_fonce:4230:29044303,29041924:pet_fonce:4230:29042367,29043379:pet_fonce:4230:29050513,29049662:pet_fonce:4230:29050642,29049680:pet_fonce:4230:29050253,29049698:pet_fonce:4230:29050040,29053191:pet_fonce:4230:29053512,29085008:pet_fonce:4230:29087696,29085011:pet_fonce:4230:29087160,29085036:pet_fonce:4230:29086397,29085039:pet_fonce:4230:29086172,29085053:pet_fonce:4230:29085986,29112740:pet_fonce:4230:29124601,29112746:pet_fonce:4230:29118963,29112748:pet_fonce:4230:29117969,29112765:pet_fonce:4230:29117326,29112771:pet_fonce:4230:29117860,29112775:pet_fonce:4230:29117042,29112780:pet_fonce:4230:29116571,29112784:pet_fonce:4230:29116737,29112789:pet_fonce:4230:29116509,29112807:pet_fonce:4230:29116141,29112826:pet_fonce:4230:29116088,29112828:pet_fonce:4230:29115556,29112831:pet_fonce:4230:29115283,29112832:pet_fonce:4230:29114990,29112846:pet_fonce:4230:29114578,29112860:pet_fonce:4230:29114118,29112862:pet_fonce:4230:29113878,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(2685025,2689701,2697181,2703918,2710209,2722873,2722857,2716815,2719445,2725917,2735595,2739029,2742686,2743210,2748550,2754948,2761363,2768175,2774117,2777581,2778144,2782725,2788309,2794689,2799961,2805191,2809662,2810376,2815647,2822677,2829216)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124241, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29034674,29034750,29034897,29034967,29038095,29038479,29039297,29042373,29044301,29050032,29050261,29050515,29050643,29053503,29053521,29085975,29086167,29086399,29086704,29087150,29087690,29092417,29093016,29112996,29113321,29113504,29113863,29114114,29114569,29114984,29115272,29115564,29116076,29116131,29116517,29116565,29116738,29117041,29117329,29117848,29117977,29118289,29118734,29118961,29119380,29124194,29124605,29160077,29160124,29160189,29160221,29160417,29160455,29160549,29160628,29160665,29160769,29160905,29161038,29161078,29161123,29161200,29161322,29161369,29161451,29161479,29161597,29162080,29164446,29165406,29166302,29198291,29198477,29198685,29200459,29200721,29200799,29200915,29201133,29201452,29201634,29201694,29201720,29201834,29201975,29202151,29202247,29202468,29202544,29202693,29202847,29203006,29203190,29203227,29203420,29237766,29237888,29238048,29238088,29238214,29238265,29238393,29238464,29238509,29238562,29238620,29238775,29238923,29238961,29239025,29239109,29239142,29239208,2923935 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124242, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29034667,29034740,29034910,29034965,29038099,29038482,29039300,29042358,29044299,29050037,29050260,29050512,29050652,29053508,29053528,29085984,29086175,29086392,29086712,29087161,29087689,29092428,29093020,29112986,29113325,29113499,29113874,29114115,29114575,29114994,29115281,29115552,29116081,29116134,29116507,29116577,29116731,29117049,29117325,29117863,29117978,29118288,29118747,29118964,29119378,29124200,29124606,29160076,29160117,29160196,29160230,29160425,29160464,29160543,29160624,29160657,29160768,29160917,29161051,29161080,29161131,29161211,29161321,29161371,29161447,29161482,29161584,29162096,29164454,29165398,29166313,29198302,29198478,29198689,29200464,29200725,29200813,29200921,29201134,29201456,29201636,29201682,29201733,29201844,29201978,29202137,29202256,29202460,29202548,29202696,29202855,29203010,29203194,29203228,29203415,29237780,29237889,29238052,29238089,29238204,29238264,29238390,29238451,29238521,29238558,29238615,29238780,29238931,29238967,29239040,29239103,29239149,29239215,2923937 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124243, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29034675,29034738,29034900,29034971,29038085,29038484,29039292,29042372,29044289,29050045,29050252,29050506,29050647,29053507,29053532,29086166,29086395,29086696,29087156,29087675,29092429,29093013,29112984,29113316,29113498,29113868,29114110,29114563,29114987,29115282,29115553,29116078,29116137,29116512,29116574,29116739,29117318,29117854,29118738,29118950,29119370,29160073,29160121,29160179,29160227,29160433,29160553,29160613,29160652,29160763,29160904,29161036,29161079,29161213,29161311,29161363,29161439,29161472,29161596,29162092,29164450,29165404,29166315,29198304,29198475,29198675,29200720,29200811,29200914,29201122,29201449,29201625,29201696,29201724,29201845,29201982,29202140,29202243,29202451,29202683,29202845,29202996,29203192,29203219,29203418,29237765,29237885,29238044,29238079,29238200,29238256,29238381,29238452,29238517,29238557,29238607,29238774,29238922,29238952,29239038,29239214,29239354,29239454,29240102,29266756,29266793,29266829,29266896,29267058,29267060,29267160,29267246,29267316,2926746 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124244, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29034679,29034737,29034907,29034975,29038096,29038472,29039303,29042366,29044304,29050043,29050262,29050517,29050640,29053511,29053529,29085982,29086165,29086390,29086698,29087165,29087688,29092431,29093029,29112998,29113326,29113505,29113875,29114123,29114579,29114988,29115278,29115563,29116087,29116127,29116518,29116572,29116734,29117047,29117330,29117851,29117966,29118304,29118751,29118957,29119385,29124189,29124598,29160081,29160115,29160192,29160220,29160429,29160465,29160556,29160623,29160673,29160772,29160919,29161048,29161073,29161130,29161212,29161313,29161376,29161435,29161485,29161586,29162083,29164448,29165403,29166308,29198300,29198480,29198687,29200450,29200719,29200802,29200929,29201121,29201450,29201632,29201690,29201729,29201846,29201981,29202150,29202255,29202462,29202545,29202684,29202854,29203005,29203183,29203225,29203422,29237779,29237892,29238040,29238080,29238209,29238259,29238391,29238462,29238518,29238553,29238612,29238782,29238929,29238966,29239033,29239114,29239138,29239217,2923937 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124246, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29034672,29034752,29038100,29039304,29042370,29044292,29050035,29050516,29050653,29053515,29053533,29085980,29086401,29086710,29087164,29087695,29092430,29093024,29112991,29113331,29113506,29113872,29114120,29114577,29114983,29115280,29115562,29116082,29116146,29116508,29116575,29116736,29117036,29117328,29117971,29118750,29119381,29124197,29124604,29160085,29160122,29160191,29160233,29160432,29160463,29160551,29160627,29160671,29160766,29160914,29161045,29161081,29161136,29161210,29161318,29161450,29161484,29161593,29162098,29164457,29165407,29166317,29198299,29198473,29198681,29200462,29200727,29200804,29200916,29201123,29201458,29201633,29201684,29201728,29201849,29201972,29202147,29202252,29202467,29202546,29202688,29202852,29203004,29203185,29203218,29203421,29237773,29237876,29238039,29238086,29238213,29238266,29238384,29238523,29238555,29238616,29238776,29238925,29238956,29239034,29239150,29239222,29239364,29239471,29239631,29240114,29266757,29266797,29266832,29266906,29267057,29267066,29267155,2926724 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124247, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29034673,29034745,29034904,29034964,29038101,29038477,29039296,29042362,29044295,29050048,29050264,29050518,29050646,29053514,29053526,29085977,29086177,29086396,29086708,29087163,29087691,29092426,29093027,29112999,29113333,29113494,29113880,29114113,29114574,29114992,29115284,29115560,29116090,29116135,29116514,29116578,29116727,29117046,29117332,29117861,29117973,29118303,29118740,29118951,29119377,29124201,29124595,29160080,29160113,29160195,29160225,29160426,29160468,29160552,29160617,29160653,29160767,29160918,29161046,29161088,29161129,29161206,29161320,29161367,29161449,29161483,29161598,29162090,29164455,29165400,29166314,29198303,29198484,29198680,29200460,29200729,29200812,29200923,29201132,29201459,29201622,29201692,29201730,29201837,29201968,29202148,29202258,29202458,29202550,29202695,29202850,29203009,29203191,29203234,29203411,29237777,29237883,29238049,29238081,29238211,29238257,29238387,29238460,29238524,29238556,29238622,29238781,29238932,29238968,29239035,29239110,29239144,29239219,2923936 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124248, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29034678,29034751,29042367,29044303,29050040,29050253,29050513,29050642,29053512,29085986,29086172,29086397,29087160,29087696,29112992,29113502,29113878,29114118,29114578,29114990,29115283,29115556,29116088,29116141,29116509,29116571,29116737,29117042,29117326,29117860,29117969,29118963,29119379,29124601,29160083,29160118,29160185,29160427,29160461,29160557,29160771,29161134,29161208,29161475,29165405,29198307,29198479,29198688,29200457,29200718,29200809,29200927,29201131,29201455,29201688,29201842,29201977,29202254,29203181,29203232,29203410,29237782,29237890,29238047,29238083,29238267,29238386,29238525,29238550,29238611,29238926,29238960,29239036,29239113,29239147,29239212,29239360,29239465,29239638,29266798,29266826,29266908,29267051,29267070,29267263,29267450,29267633,29280707,29282938,29282999,29283207,29283328,29283396,29284034,29298728,29298848,29300006,29300137,29300355,29300451,29300565,29300601,29300774,29300809,29301064,29301172,29301327,29301875,29302158,29302281,29302870,29303026,29303072,2930607 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124241,30124242,30124243,30124244,30124246,30124247,30124248?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 01 mtr_id : dashboard_places : SCCU_cam7 date : 2026-01 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2026-01%') and created_at like '%2026-01%'))); nb_day : (3, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 01 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 01 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%012026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-01-01 : dt_date_just_month_year : 2026-01-15 16:39:56.996397 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-01-01" AND ded.date <= "2026-01-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 (2835823,2842690,2847231,2847811,2853841,2860818,2867427,2872226,2873659,2874678,2875161,2876339,2877689,2879029,2879778) 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.013423397177562047, 'nb_photo': 9154, 'list_port_cont': '29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877', 'assoc_port': '29872026:29874336,29872028:29874447,29872030:29874413,29872032:29874264,29872034:29874351,29872036:29874176,29872037:29874088,29872041:29874158,29872043:29873935,29872045:29874220,29872048:29873891,29872051:29874008,29872056:29873772,29872059:29873724,29872060:29873830,29872063:29873801,29872066:29873473,29872071:29873540,29872072:29873323,29872074:29873432,29872076:29873174,29872078:29873144,29873351:29873571,29874583:29874612,29910018:29915759,29910021:29916009,29910023:29917724,29910026:29916404,29910030:29916078,29910034:29916122,29910038:29915931,29910041:29915539,29910045:29915680,29910050:29915356,29910054:29915234,29910068:29915116,29910075:29914918,29910077:29915187,29910080:29914739,29910083:29914575,29910085:29914491,29910088:29914430,29910090:29914072,29910092:29913997,29910106:29914118,29910120:29913899,29910122:29913576,29912892:29913277,29934942:29937342,29934944:29937497,29934946:29937460,29934949:29937278,29934952:29937372,29934955:29937232,29934957:29936982,29934960:29937051,29934963:2993690', 'assoc_mat': '29872026:autre:4230:29874336,29872028:autre:4230:29874447,29872030:autre:4230:29874413,29872032:autre:4230:29874264,29872034:autre:4230:29874351,29872036:autre:4230:29874176,29872037:autre:4230:29874088,29872041:autre:4230:29874158,29872043:autre:4230:29873935,29872045:autre:4230:29874220,29872048:autre:4230:29873891,29872051:autre:4230:29874008,29872056:autre:4230:29873772,29872059:autre:4230:29873724,29872060:autre:4230:29873830,29872063:autre:4230:29873801,29872066:autre:4230:29873473,29872071:autre:4230:29873540,29872072:autre:4230:29873323,29872074:autre:4230:29873432,29872076:autre:4230:29873174,29872078:autre:4230:29873144,29873351:autre:4230:29873571,29874583:autre:4230:29874612,29910018:autre:4230:29915759,29910021:autre:4230:29916009,29910023:autre:4230:29917724,29910026:autre:4230:29916404,29910030:autre:4230:29916078,29910034:autre:4230:29916122,29910038:autre:4230:29915931,29910041:autre:4230:29915539,29910045:autre:4230:29915680,29910050:autre:4230:29915356,29910054:autre:4230:29915234,29910068:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03526592289250692, 'nb_photo': 44399, 'list_port_cont': '29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878', 'assoc_port': '29872026:29874342,29872028:29874443,29872030:29874406,29872032:29874270,29872034:29874357,29872036:29874173,29872037:29874087,29872041:29874161,29872043:29873937,29872045:29874230,29872048:29873905,29872051:29874014,29872056:29873765,29872059:29873727,29872060:29873838,29872063:29873810,29872066:29873474,29872071:29873549,29872072:29873314,29872074:29873443,29872076:29873173,29872078:29873142,29873351:29873574,29874583:29874621,29910018:29915779,29910021:29916016,29910023:29917732,29910026:29916402,29910030:29916088,29910034:29916135,29910038:29915932,29910041:29915555,29910045:29915681,29910050:29915370,29910054:29915233,29910068:29915113,29910075:29914931,29910077:29915200,29910080:29914756,29910083:29914570,29910085:29914492,29910088:29914435,29910090:29914078,29910092:29914002,29910106:29914115,29910120:29913910,29910122:29913589,29912892:29913268,29934942:29937350,29934944:29937485,29934946:29937462,29934949:29937277,29934952:29937383,29934955:29937236,29934957:29936980,29934960:29937058,29934963:2993691', 'assoc_mat': '29872026:carton:4230:29874342,29872028:carton:4230:29874443,29872030:carton:4230:29874406,29872032:carton:4230:29874270,29872034:carton:4230:29874357,29872036:carton:4230:29874173,29872037:carton:4230:29874087,29872041:carton:4230:29874161,29872043:carton:4230:29873937,29872045:carton:4230:29874230,29872048:carton:4230:29873905,29872051:carton:4230:29874014,29872056:carton:4230:29873765,29872059:carton:4230:29873727,29872060:carton:4230:29873838,29872063:carton:4230:29873810,29872066:carton:4230:29873474,29872071:carton:4230:29873549,29872072:carton:4230:29873314,29872074:carton:4230:29873443,29872076:carton:4230:29873173,29872078:carton:4230:29873142,29873351:carton:4230:29873574,29874583:carton:4230:29874621,29910018:carton:4230:29915779,29910021:carton:4230:29916016,29910023:carton:4230:29917732,29910026:carton:4230:29916402,29910030:carton:4230:29916088,29910034:carton:4230:29916135,29910038:carton:4230:29915932,29910041:carton:4230:29915555,29910045:carton:4230:29915681,29910050:carton:4230:29915370,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013565174591263639, 'nb_photo': 994, 'list_port_cont': '29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047', 'assoc_port': '29872026:29874329,29872030:29874400,29872032:29874261,29872034:29874353,29872036:29874179,29872037:29874089,29872041:29874162,29872043:29873941,29872045:29874222,29872048:29873894,29872051:29874001,29872056:29873759,29872059:29873732,29872060:29873834,29872063:29873796,29872066:29873471,29872071:29873539,29872072:29873325,29872074:29873427,29872076:29873172,29872078:29873134,29874583:29874624,29910026:29916409,29910030:29916094,29910034:29916128,29910038:29915926,29910041:29915547,29910045:29915679,29910050:29915362,29910068:29915105,29910077:29915194,29910080:29914755,29910088:29914405,29910090:29914088,29910092:29913996,29910106:29914120,29910122:29913583,29912892:29913266,29934942:29937352,29934946:29937452,29934949:29937273,29934952:29937379,29934955:29937229,29934957:29936978,29934960:29937052,29934963:29936905,29934965:29936823,29934971:29936689,29934973:29936354,29934975:29936424,29934977:29936467,29934979:29936216,29934981:29936312,29934989:29936101,29934993:29936182,29934995:29935038,29936860:2993709', 'assoc_mat': '29872026:metal:4230:29874329,29872030:metal:4230:29874400,29872032:metal:4230:29874261,29872034:metal:4230:29874353,29872036:metal:4230:29874179,29872037:metal:4230:29874089,29872041:metal:4230:29874162,29872043:metal:4230:29873941,29872045:metal:4230:29874222,29872048:metal:4230:29873894,29872051:metal:4230:29874001,29872056:metal:4230:29873759,29872059:metal:4230:29873732,29872060:metal:4230:29873834,29872063:metal:4230:29873796,29872066:metal:4230:29873471,29872071:metal:4230:29873539,29872072:metal:4230:29873325,29872074:metal:4230:29873427,29872076:metal:4230:29873172,29872078:metal:4230:29873134,29874583:metal:4230:29874624,29910026:metal:4230:29916409,29910030:metal:4230:29916094,29910034:metal:4230:29916128,29910038:metal:4230:29915926,29910041:metal:4230:29915547,29910045:metal:4230:29915679,29910050:metal:4230:29915362,29910068:metal:4230:29915105,29910077:metal:4230:29915194,29910080:metal:4230:29914755,29910088:metal:4230:29914405,29910090:metal:4230:29914088,29910092:metal:4230:29913996,29910106:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1581833534025302, 'nb_photo': 159482, 'list_port_cont': '29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878', 'assoc_port': '29872026:29874331,29872028:29874440,29872030:29874415,29872032:29874268,29872034:29874356,29872036:29874178,29872037:29874085,29872041:29874148,29872043:29873939,29872045:29874228,29872048:29873903,29872051:29874018,29872056:29873768,29872059:29873734,29872060:29873844,29872063:29873806,29872066:29873472,29872071:29873555,29872072:29873328,29872074:29873434,29872076:29873171,29872078:29873146,29873351:29873568,29874583:29874623,29910018:29915773,29910021:29916008,29910023:29917730,29910026:29916415,29910030:29916085,29910034:29916136,29910038:29915930,29910041:29915548,29910045:29915692,29910050:29915366,29910054:29915232,29910068:29915112,29910075:29914930,29910077:29915199,29910080:29914752,29910083:29914576,29910085:29914494,29910088:29914426,29910090:29914089,29910092:29914004,29910106:29914119,29910120:29913901,29910122:29913581,29912892:29913270,29934942:29937349,29934944:29937491,29934946:29937461,29934949:29937274,29934952:29937385,29934955:29937235,29934957:29936981,29934960:29937059,29934963:2993691', 'assoc_mat': '29872026:papier:4230:29874331,29872028:papier:4230:29874440,29872030:papier:4230:29874415,29872032:papier:4230:29874268,29872034:papier:4230:29874356,29872036:papier:4230:29874178,29872037:papier:4230:29874085,29872041:papier:4230:29874148,29872043:papier:4230:29873939,29872045:papier:4230:29874228,29872048:papier:4230:29873903,29872051:papier:4230:29874018,29872056:papier:4230:29873768,29872059:papier:4230:29873734,29872060:papier:4230:29873844,29872063:papier:4230:29873806,29872066:papier:4230:29873472,29872071:papier:4230:29873555,29872072:papier:4230:29873328,29872074:papier:4230:29873434,29872076:papier:4230:29873171,29872078:papier:4230:29873146,29873351:papier:4230:29873568,29874583:papier:4230:29874623,29910018:papier:4230:29915773,29910021:papier:4230:29916008,29910023:papier:4230:29917730,29910026:papier:4230:29916415,29910030:papier:4230:29916085,29910034:papier:4230:29916136,29910038:papier:4230:29915930,29910041:papier:4230:29915548,29910045:papier:4230:29915692,29910050:papier:4230:29915366,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002697407757525186, 'nb_photo': 801, 'list_port_cont': '29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961', 'assoc_port': '29872026:29874345,29872030:29874412,29872034:29874360,29872036:29874174,29872037:29874081,29872043:29873940,29872045:29874234,29872051:29874009,29872060:29873840,29872071:29873552,29872072:29873322,29872074:29873440,29872076:29873178,29872078:29873137,29873351:29873565,29874583:29874628,29910018:29915774,29910038:29915927,29910041:29915553,29910045:29915693,29910050:29915367,29910054:29915231,29910068:29915117,29910075:29914922,29910077:29915196,29910080:29914747,29910083:29914583,29910085:29914493,29910090:29914083,29910106:29914124,29910120:29913911,29910122:29913588,29912892:29913281,29934942:29937353,29934946:29937453,29934949:29937281,29934960:29937060,29934963:29936900,29934965:29936829,29934967:29936803,29934971:29936694,29934973:29936364,29934975:29936435,29934977:29936474,29934979:29936219,29934981:29936326,29934984:29936291,29934986:29936146,29934989:29936105,29934993:29936170,29934995:29935054,29936860:29937087,29941172:29942421,29941175:29942078,29941176:29942263,29941178:29942057,29941193:2994191', 'assoc_mat': '29872026:pehd:4230:29874345,29872030:pehd:4230:29874412,29872034:pehd:4230:29874360,29872036:pehd:4230:29874174,29872037:pehd:4230:29874081,29872043:pehd:4230:29873940,29872045:pehd:4230:29874234,29872051:pehd:4230:29874009,29872060:pehd:4230:29873840,29872071:pehd:4230:29873552,29872072:pehd:4230:29873322,29872074:pehd:4230:29873440,29872076:pehd:4230:29873178,29872078:pehd:4230:29873137,29873351:pehd:4230:29873565,29874583:pehd:4230:29874628,29910018:pehd:4230:29915774,29910038:pehd:4230:29915927,29910041:pehd:4230:29915553,29910045:pehd:4230:29915693,29910050:pehd:4230:29915367,29910054:pehd:4230:29915231,29910068:pehd:4230:29915117,29910075:pehd:4230:29914922,29910077:pehd:4230:29915196,29910080:pehd:4230:29914747,29910083:pehd:4230:29914583,29910085:pehd:4230:29914493,29910090:pehd:4230:29914083,29910106:pehd:4230:29914124,29910120:pehd:4230:29913911,29910122:pehd:4230:29913588,29912892:pehd:4230:29913281,29934942:pehd:4230:29937353,29934946:pehd:4230:29937453,29934949:pehd:4230:29937281,29934960:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.025234946649520116, 'nb_photo': 18815, 'list_port_cont': '29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878', 'assoc_port': '29872026:29874341,29872028:29874451,29872030:29874417,29872032:29874258,29872034:29874362,29872036:29874168,29872037:29874083,29872041:29874150,29872043:29873938,29872045:29874229,29872048:29873901,29872051:29874015,29872056:29873773,29872059:29873728,29872060:29873841,29872063:29873803,29872066:29873467,29872071:29873550,29872072:29873324,29872074:29873438,29872076:29873175,29872078:29873145,29873351:29873569,29874583:29874627,29910018:29915771,29910021:29916005,29910023:29917731,29910026:29916406,29910030:29916091,29910034:29916134,29910038:29915919,29910041:29915551,29910045:29915688,29910050:29915369,29910054:29915235,29910068:29915115,29910075:29914923,29910077:29915197,29910080:29914750,29910083:29914573,29910085:29914490,29910088:29914415,29910090:29914084,29910092:29914001,29910106:29914122,29910120:29913904,29910122:29913580,29912892:29913275,29934942:29937346,29934944:29937498,29934946:29937457,29934949:29937276,29934952:29937389,29934955:29937242,29934957:29936985,29934960:29937049,29934963:2993690', 'assoc_mat': '29872026:pet_clair:4230:29874341,29872028:pet_clair:4230:29874451,29872030:pet_clair:4230:29874417,29872032:pet_clair:4230:29874258,29872034:pet_clair:4230:29874362,29872036:pet_clair:4230:29874168,29872037:pet_clair:4230:29874083,29872041:pet_clair:4230:29874150,29872043:pet_clair:4230:29873938,29872045:pet_clair:4230:29874229,29872048:pet_clair:4230:29873901,29872051:pet_clair:4230:29874015,29872056:pet_clair:4230:29873773,29872059:pet_clair:4230:29873728,29872060:pet_clair:4230:29873841,29872063:pet_clair:4230:29873803,29872066:pet_clair:4230:29873467,29872071:pet_clair:4230:29873550,29872072:pet_clair:4230:29873324,29872074:pet_clair:4230:29873438,29872076:pet_clair:4230:29873175,29872078:pet_clair:4230:29873145,29873351:pet_clair:4230:29873569,29874583:pet_clair:4230:29874627,29910018:pet_clair:4230:29915771,29910021:pet_clair:4230:29916005,29910023:pet_clair:4230:29917731,29910026:pet_clair:4230:29916406,29910030:pet_clair:4230:29916091,29910034:pet_clair:4230:29916134,29910038:pet_clair:4230:29915919,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022120623708903344, 'nb_photo': 356, 'list_port_cont': '29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188', 'assoc_port': '29872026:29874332,29872028:29874453,29872030:29874414,29872034:29874361,29872036:29874175,29872037:29874086,29872048:29873900,29872059:29873733,29872063:29873804,29872066:29873477,29872071:29873554,29872072:29873318,29872076:29873180,29874583:29874626,29910018:29915778,29910021:29916004,29910023:29917733,29910026:29916412,29910030:29916087,29910034:29916132,29910038:29915920,29910041:29915550,29910045:29915685,29910068:29915114,29910075:29914932,29910077:29915203,29910080:29914759,29910083:29914582,29910085:29914483,29910088:29914413,29910090:29914085,29910106:29914127,29910120:29913906,29910122:29913585,29934942:29937351,29934944:29937487,29934946:29937449,29934949:29937279,29934952:29937388,29934963:29936908,29934965:29936828,29934967:29936800,29934969:29936513,29934971:29936690,29934973:29936362,29934975:29936437,29934977:29936476,29934979:29936213,29934981:29936325,29934984:29936280,29934986:29936143,29934993:29936181,29936860:29937083,29941175:29942082,29941180:29941954,29941182:29941844,29941193:2994191', 'assoc_mat': '29872026:pet_fonce:4230:29874332,29872028:pet_fonce:4230:29874453,29872030:pet_fonce:4230:29874414,29872034:pet_fonce:4230:29874361,29872036:pet_fonce:4230:29874175,29872037:pet_fonce:4230:29874086,29872048:pet_fonce:4230:29873900,29872059:pet_fonce:4230:29873733,29872063:pet_fonce:4230:29873804,29872066:pet_fonce:4230:29873477,29872071:pet_fonce:4230:29873554,29872072:pet_fonce:4230:29873318,29872076:pet_fonce:4230:29873180,29874583:pet_fonce:4230:29874626,29910018:pet_fonce:4230:29915778,29910021:pet_fonce:4230:29916004,29910023:pet_fonce:4230:29917733,29910026:pet_fonce:4230:29916412,29910030:pet_fonce:4230:29916087,29910034:pet_fonce:4230:29916132,29910038:pet_fonce:4230:29915920,29910041:pet_fonce:4230:29915550,29910045:pet_fonce:4230:29915685,29910068:pet_fonce:4230:29915114,29910075:pet_fonce:4230:29914932,29910077:pet_fonce:4230:29915203,29910080:pet_fonce:4230:29914759,29910083:pet_fonce:4230:29914582,29910085:pet_fonce:4230:29914483,29910088:pet_fonce:4230:29914413,29910090:pet_fonce:4230:29914085,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(2835823,2842690,2847231,2847811,2853841,2860818,2867427,2872226,2873659,2874678,2875161,2876339,2877689,2879029,2879778)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124540, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124541, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124542, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124543, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124544, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124545, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124546, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours : https://www.fotonower.com/velours/30124540,30124541,30124542,30124543,30124544,30124545,30124546?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2026-01-01' and date <= '2026-01-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1119,),), 'unwanted_material_monthly_percentage': ((0.7758193549607412,),), 'material_repartition': (('incineration', 1119),), 'material_dict': {'incineration': 1119}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7332273718998051, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7332273718998051, 2))}, 'quality_array': [['-7.1461397154465045', '01012026'], ['-6.790631642374837', '02012026'], ['-6.950659734975454', '03012026'], ['-6.932661919079431', '04012026'], ['-6.4842697940755265', '05012026'], ['-6.141143744328462', '06012026'], ['-6.687664593091492', '07012026'], ['-6.913470589711381', '08012026'], ['-7.3127044487476045', '09012026'], ['-7.270751854397152', '10012026'], ['-6.829435540902781', '11012026'], ['-7.10091400510139', '12012026'], ['-7.2419920685407755', '13012026'], ['-7.425190751008745', '14012026'], ['-7.116445008722284', '15012026']], 'number_of_batch': ((347,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013423397177562047, 'nb_photo': 9154, 'list_port_cont': '29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877', 'assoc_port': '29872026:29874336,29872028:29874447,29872030:29874413,29872032:29874264,29872034:29874351,29872036:29874176,29872037:29874088,29872041:29874158,29872043:29873935,29872045:29874220,29872048:29873891,29872051:29874008,29872056:29873772,29872059:29873724,29872060:29873830,29872063:29873801,29872066:29873473,29872071:29873540,29872072:29873323,29872074:29873432,29872076:29873174,29872078:29873144,29873351:29873571,29874583:29874612,29910018:29915759,29910021:29916009,29910023:29917724,29910026:29916404,29910030:29916078,29910034:29916122,29910038:29915931,29910041:29915539,29910045:29915680,29910050:29915356,29910054:29915234,29910068:29915116,29910075:29914918,29910077:29915187,29910080:29914739,29910083:29914575,29910085:29914491,29910088:29914430,29910090:29914072,29910092:29913997,29910106:29914118,29910120:29913899,29910122:29913576,29912892:29913277,29934942:29937342,29934944:29937497,29934946:29937460,29934949:29937278,29934952:29937372,29934955:29937232,29934957:29936982,29934960:29937051,29934963:2993690', 'assoc_mat': '29872026:autre:4230:29874336,29872028:autre:4230:29874447,29872030:autre:4230:29874413,29872032:autre:4230:29874264,29872034:autre:4230:29874351,29872036:autre:4230:29874176,29872037:autre:4230:29874088,29872041:autre:4230:29874158,29872043:autre:4230:29873935,29872045:autre:4230:29874220,29872048:autre:4230:29873891,29872051:autre:4230:29874008,29872056:autre:4230:29873772,29872059:autre:4230:29873724,29872060:autre:4230:29873830,29872063:autre:4230:29873801,29872066:autre:4230:29873473,29872071:autre:4230:29873540,29872072:autre:4230:29873323,29872074:autre:4230:29873432,29872076:autre:4230:29873174,29872078:autre:4230:29873144,29873351:autre:4230:29873571,29874583:autre:4230:29874612,29910018:autre:4230:29915759,29910021:autre:4230:29916009,29910023:autre:4230:29917724,29910026:autre:4230:29916404,29910030:autre:4230:29916078,29910034:autre:4230:29916122,29910038:autre:4230:29915931,29910041:autre:4230:29915539,29910045:autre:4230:29915680,29910050:autre:4230:29915356,29910054:autre:4230:29915234,29910068:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03526592289250692, 'nb_photo': 44399, 'list_port_cont': '29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878', 'assoc_port': '29872026:29874342,29872028:29874443,29872030:29874406,29872032:29874270,29872034:29874357,29872036:29874173,29872037:29874087,29872041:29874161,29872043:29873937,29872045:29874230,29872048:29873905,29872051:29874014,29872056:29873765,29872059:29873727,29872060:29873838,29872063:29873810,29872066:29873474,29872071:29873549,29872072:29873314,29872074:29873443,29872076:29873173,29872078:29873142,29873351:29873574,29874583:29874621,29910018:29915779,29910021:29916016,29910023:29917732,29910026:29916402,29910030:29916088,29910034:29916135,29910038:29915932,29910041:29915555,29910045:29915681,29910050:29915370,29910054:29915233,29910068:29915113,29910075:29914931,29910077:29915200,29910080:29914756,29910083:29914570,29910085:29914492,29910088:29914435,29910090:29914078,29910092:29914002,29910106:29914115,29910120:29913910,29910122:29913589,29912892:29913268,29934942:29937350,29934944:29937485,29934946:29937462,29934949:29937277,29934952:29937383,29934955:29937236,29934957:29936980,29934960:29937058,29934963:2993691', 'assoc_mat': '29872026:carton:4230:29874342,29872028:carton:4230:29874443,29872030:carton:4230:29874406,29872032:carton:4230:29874270,29872034:carton:4230:29874357,29872036:carton:4230:29874173,29872037:carton:4230:29874087,29872041:carton:4230:29874161,29872043:carton:4230:29873937,29872045:carton:4230:29874230,29872048:carton:4230:29873905,29872051:carton:4230:29874014,29872056:carton:4230:29873765,29872059:carton:4230:29873727,29872060:carton:4230:29873838,29872063:carton:4230:29873810,29872066:carton:4230:29873474,29872071:carton:4230:29873549,29872072:carton:4230:29873314,29872074:carton:4230:29873443,29872076:carton:4230:29873173,29872078:carton:4230:29873142,29873351:carton:4230:29873574,29874583:carton:4230:29874621,29910018:carton:4230:29915779,29910021:carton:4230:29916016,29910023:carton:4230:29917732,29910026:carton:4230:29916402,29910030:carton:4230:29916088,29910034:carton:4230:29916135,29910038:carton:4230:29915932,29910041:carton:4230:29915555,29910045:carton:4230:29915681,29910050:carton:4230:29915370,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013565174591263639, 'nb_photo': 994, 'list_port_cont': '29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047', 'assoc_port': '29872026:29874329,29872030:29874400,29872032:29874261,29872034:29874353,29872036:29874179,29872037:29874089,29872041:29874162,29872043:29873941,29872045:29874222,29872048:29873894,29872051:29874001,29872056:29873759,29872059:29873732,29872060:29873834,29872063:29873796,29872066:29873471,29872071:29873539,29872072:29873325,29872074:29873427,29872076:29873172,29872078:29873134,29874583:29874624,29910026:29916409,29910030:29916094,29910034:29916128,29910038:29915926,29910041:29915547,29910045:29915679,29910050:29915362,29910068:29915105,29910077:29915194,29910080:29914755,29910088:29914405,29910090:29914088,29910092:29913996,29910106:29914120,29910122:29913583,29912892:29913266,29934942:29937352,29934946:29937452,29934949:29937273,29934952:29937379,29934955:29937229,29934957:29936978,29934960:29937052,29934963:29936905,29934965:29936823,29934971:29936689,29934973:29936354,29934975:29936424,29934977:29936467,29934979:29936216,29934981:29936312,29934989:29936101,29934993:29936182,29934995:29935038,29936860:2993709', 'assoc_mat': '29872026:metal:4230:29874329,29872030:metal:4230:29874400,29872032:metal:4230:29874261,29872034:metal:4230:29874353,29872036:metal:4230:29874179,29872037:metal:4230:29874089,29872041:metal:4230:29874162,29872043:metal:4230:29873941,29872045:metal:4230:29874222,29872048:metal:4230:29873894,29872051:metal:4230:29874001,29872056:metal:4230:29873759,29872059:metal:4230:29873732,29872060:metal:4230:29873834,29872063:metal:4230:29873796,29872066:metal:4230:29873471,29872071:metal:4230:29873539,29872072:metal:4230:29873325,29872074:metal:4230:29873427,29872076:metal:4230:29873172,29872078:metal:4230:29873134,29874583:metal:4230:29874624,29910026:metal:4230:29916409,29910030:metal:4230:29916094,29910034:metal:4230:29916128,29910038:metal:4230:29915926,29910041:metal:4230:29915547,29910045:metal:4230:29915679,29910050:metal:4230:29915362,29910068:metal:4230:29915105,29910077:metal:4230:29915194,29910080:metal:4230:29914755,29910088:metal:4230:29914405,29910090:metal:4230:29914088,29910092:metal:4230:29913996,29910106:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1581833534025302, 'nb_photo': 159482, 'list_port_cont': '29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878', 'assoc_port': '29872026:29874331,29872028:29874440,29872030:29874415,29872032:29874268,29872034:29874356,29872036:29874178,29872037:29874085,29872041:29874148,29872043:29873939,29872045:29874228,29872048:29873903,29872051:29874018,29872056:29873768,29872059:29873734,29872060:29873844,29872063:29873806,29872066:29873472,29872071:29873555,29872072:29873328,29872074:29873434,29872076:29873171,29872078:29873146,29873351:29873568,29874583:29874623,29910018:29915773,29910021:29916008,29910023:29917730,29910026:29916415,29910030:29916085,29910034:29916136,29910038:29915930,29910041:29915548,29910045:29915692,29910050:29915366,29910054:29915232,29910068:29915112,29910075:29914930,29910077:29915199,29910080:29914752,29910083:29914576,29910085:29914494,29910088:29914426,29910090:29914089,29910092:29914004,29910106:29914119,29910120:29913901,29910122:29913581,29912892:29913270,29934942:29937349,29934944:29937491,29934946:29937461,29934949:29937274,29934952:29937385,29934955:29937235,29934957:29936981,29934960:29937059,29934963:2993691', 'assoc_mat': '29872026:papier:4230:29874331,29872028:papier:4230:29874440,29872030:papier:4230:29874415,29872032:papier:4230:29874268,29872034:papier:4230:29874356,29872036:papier:4230:29874178,29872037:papier:4230:29874085,29872041:papier:4230:29874148,29872043:papier:4230:29873939,29872045:papier:4230:29874228,29872048:papier:4230:29873903,29872051:papier:4230:29874018,29872056:papier:4230:29873768,29872059:papier:4230:29873734,29872060:papier:4230:29873844,29872063:papier:4230:29873806,29872066:papier:4230:29873472,29872071:papier:4230:29873555,29872072:papier:4230:29873328,29872074:papier:4230:29873434,29872076:papier:4230:29873171,29872078:papier:4230:29873146,29873351:papier:4230:29873568,29874583:papier:4230:29874623,29910018:papier:4230:29915773,29910021:papier:4230:29916008,29910023:papier:4230:29917730,29910026:papier:4230:29916415,29910030:papier:4230:29916085,29910034:papier:4230:29916136,29910038:papier:4230:29915930,29910041:papier:4230:29915548,29910045:papier:4230:29915692,29910050:papier:4230:29915366,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002697407757525186, 'nb_photo': 801, 'list_port_cont': '29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961', 'assoc_port': '29872026:29874345,29872030:29874412,29872034:29874360,29872036:29874174,29872037:29874081,29872043:29873940,29872045:29874234,29872051:29874009,29872060:29873840,29872071:29873552,29872072:29873322,29872074:29873440,29872076:29873178,29872078:29873137,29873351:29873565,29874583:29874628,29910018:29915774,29910038:29915927,29910041:29915553,29910045:29915693,29910050:29915367,29910054:29915231,29910068:29915117,29910075:29914922,29910077:29915196,29910080:29914747,29910083:29914583,29910085:29914493,29910090:29914083,29910106:29914124,29910120:29913911,29910122:29913588,29912892:29913281,29934942:29937353,29934946:29937453,29934949:29937281,29934960:29937060,29934963:29936900,29934965:29936829,29934967:29936803,29934971:29936694,29934973:29936364,29934975:29936435,29934977:29936474,29934979:29936219,29934981:29936326,29934984:29936291,29934986:29936146,29934989:29936105,29934993:29936170,29934995:29935054,29936860:29937087,29941172:29942421,29941175:29942078,29941176:29942263,29941178:29942057,29941193:2994191', 'assoc_mat': '29872026:pehd:4230:29874345,29872030:pehd:4230:29874412,29872034:pehd:4230:29874360,29872036:pehd:4230:29874174,29872037:pehd:4230:29874081,29872043:pehd:4230:29873940,29872045:pehd:4230:29874234,29872051:pehd:4230:29874009,29872060:pehd:4230:29873840,29872071:pehd:4230:29873552,29872072:pehd:4230:29873322,29872074:pehd:4230:29873440,29872076:pehd:4230:29873178,29872078:pehd:4230:29873137,29873351:pehd:4230:29873565,29874583:pehd:4230:29874628,29910018:pehd:4230:29915774,29910038:pehd:4230:29915927,29910041:pehd:4230:29915553,29910045:pehd:4230:29915693,29910050:pehd:4230:29915367,29910054:pehd:4230:29915231,29910068:pehd:4230:29915117,29910075:pehd:4230:29914922,29910077:pehd:4230:29915196,29910080:pehd:4230:29914747,29910083:pehd:4230:29914583,29910085:pehd:4230:29914493,29910090:pehd:4230:29914083,29910106:pehd:4230:29914124,29910120:pehd:4230:29913911,29910122:pehd:4230:29913588,29912892:pehd:4230:29913281,29934942:pehd:4230:29937353,29934946:pehd:4230:29937453,29934949:pehd:4230:29937281,29934960:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.025234946649520116, 'nb_photo': 18815, 'list_port_cont': '29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878', 'assoc_port': '29872026:29874341,29872028:29874451,29872030:29874417,29872032:29874258,29872034:29874362,29872036:29874168,29872037:29874083,29872041:29874150,29872043:29873938,29872045:29874229,29872048:29873901,29872051:29874015,29872056:29873773,29872059:29873728,29872060:29873841,29872063:29873803,29872066:29873467,29872071:29873550,29872072:29873324,29872074:29873438,29872076:29873175,29872078:29873145,29873351:29873569,29874583:29874627,29910018:29915771,29910021:29916005,29910023:29917731,29910026:29916406,29910030:29916091,29910034:29916134,29910038:29915919,29910041:29915551,29910045:29915688,29910050:29915369,29910054:29915235,29910068:29915115,29910075:29914923,29910077:29915197,29910080:29914750,29910083:29914573,29910085:29914490,29910088:29914415,29910090:29914084,29910092:29914001,29910106:29914122,29910120:29913904,29910122:29913580,29912892:29913275,29934942:29937346,29934944:29937498,29934946:29937457,29934949:29937276,29934952:29937389,29934955:29937242,29934957:29936985,29934960:29937049,29934963:2993690', 'assoc_mat': '29872026:pet_clair:4230:29874341,29872028:pet_clair:4230:29874451,29872030:pet_clair:4230:29874417,29872032:pet_clair:4230:29874258,29872034:pet_clair:4230:29874362,29872036:pet_clair:4230:29874168,29872037:pet_clair:4230:29874083,29872041:pet_clair:4230:29874150,29872043:pet_clair:4230:29873938,29872045:pet_clair:4230:29874229,29872048:pet_clair:4230:29873901,29872051:pet_clair:4230:29874015,29872056:pet_clair:4230:29873773,29872059:pet_clair:4230:29873728,29872060:pet_clair:4230:29873841,29872063:pet_clair:4230:29873803,29872066:pet_clair:4230:29873467,29872071:pet_clair:4230:29873550,29872072:pet_clair:4230:29873324,29872074:pet_clair:4230:29873438,29872076:pet_clair:4230:29873175,29872078:pet_clair:4230:29873145,29873351:pet_clair:4230:29873569,29874583:pet_clair:4230:29874627,29910018:pet_clair:4230:29915771,29910021:pet_clair:4230:29916005,29910023:pet_clair:4230:29917731,29910026:pet_clair:4230:29916406,29910030:pet_clair:4230:29916091,29910034:pet_clair:4230:29916134,29910038:pet_clair:4230:29915919,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022120623708903344, 'nb_photo': 356, 'list_port_cont': '29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188', 'assoc_port': '29872026:29874332,29872028:29874453,29872030:29874414,29872034:29874361,29872036:29874175,29872037:29874086,29872048:29873900,29872059:29873733,29872063:29873804,29872066:29873477,29872071:29873554,29872072:29873318,29872076:29873180,29874583:29874626,29910018:29915778,29910021:29916004,29910023:29917733,29910026:29916412,29910030:29916087,29910034:29916132,29910038:29915920,29910041:29915550,29910045:29915685,29910068:29915114,29910075:29914932,29910077:29915203,29910080:29914759,29910083:29914582,29910085:29914483,29910088:29914413,29910090:29914085,29910106:29914127,29910120:29913906,29910122:29913585,29934942:29937351,29934944:29937487,29934946:29937449,29934949:29937279,29934952:29937388,29934963:29936908,29934965:29936828,29934967:29936800,29934969:29936513,29934971:29936690,29934973:29936362,29934975:29936437,29934977:29936476,29934979:29936213,29934981:29936325,29934984:29936280,29934986:29936143,29934993:29936181,29936860:29937083,29941175:29942082,29941180:29941954,29941182:29941844,29941193:2994191', 'assoc_mat': '29872026:pet_fonce:4230:29874332,29872028:pet_fonce:4230:29874453,29872030:pet_fonce:4230:29874414,29872034:pet_fonce:4230:29874361,29872036:pet_fonce:4230:29874175,29872037:pet_fonce:4230:29874086,29872048:pet_fonce:4230:29873900,29872059:pet_fonce:4230:29873733,29872063:pet_fonce:4230:29873804,29872066:pet_fonce:4230:29873477,29872071:pet_fonce:4230:29873554,29872072:pet_fonce:4230:29873318,29872076:pet_fonce:4230:29873180,29874583:pet_fonce:4230:29874626,29910018:pet_fonce:4230:29915778,29910021:pet_fonce:4230:29916004,29910023:pet_fonce:4230:29917733,29910026:pet_fonce:4230:29916412,29910030:pet_fonce:4230:29916087,29910034:pet_fonce:4230:29916132,29910038:pet_fonce:4230:29915920,29910041:pet_fonce:4230:29915550,29910045:pet_fonce:4230:29915685,29910068:pet_fonce:4230:29915114,29910075:pet_fonce:4230:29914932,29910077:pet_fonce:4230:29915203,29910080:pet_fonce:4230:29914759,29910083:pet_fonce:4230:29914582,29910085:pet_fonce:4230:29914483,29910088:pet_fonce:4230:29914413,29910090:pet_fonce:4230:29914085,2'}), 'main_stat': {'nb_photos': 1119}, 'velours_link': 'https://www.fotonower.com/velours/30124540,30124541,30124542,30124543,30124544,30124545,30124546?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.7758193549607412),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1119,),), 'unwanted_material_monthly_percentage': ((0.7758193549607412,),), 'material_repartition': (('incineration', 1119),), 'material_dict': {'incineration': 1119}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7332273718998051, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7332273718998051, 2))}, 'quality_array': [['-7.1461397154465045', '01012026'], ['-6.790631642374837', '02012026'], ['-6.950659734975454', '03012026'], ['-6.932661919079431', '04012026'], ['-6.4842697940755265', '05012026'], ['-6.141143744328462', '06012026'], ['-6.687664593091492', '07012026'], ['-6.913470589711381', '08012026'], ['-7.3127044487476045', '09012026'], ['-7.270751854397152', '10012026'], ['-6.829435540902781', '11012026'], ['-7.10091400510139', '12012026'], ['-7.2419920685407755', '13012026'], ['-7.425190751008745', '14012026'], ['-7.116445008722284', '15012026']], 'number_of_batch': ((347,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013423397177562047, 'nb_photo': 9154, 'list_port_cont': '29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877', 'assoc_port': '29872026:29874336,29872028:29874447,29872030:29874413,29872032:29874264,29872034:29874351,29872036:29874176,29872037:29874088,29872041:29874158,29872043:29873935,29872045:29874220,29872048:29873891,29872051:29874008,29872056:29873772,29872059:29873724,29872060:29873830,29872063:29873801,29872066:29873473,29872071:29873540,29872072:29873323,29872074:29873432,29872076:29873174,29872078:29873144,29873351:29873571,29874583:29874612,29910018:29915759,29910021:29916009,29910023:29917724,29910026:29916404,29910030:29916078,29910034:29916122,29910038:29915931,29910041:29915539,29910045:29915680,29910050:29915356,29910054:29915234,29910068:29915116,29910075:29914918,29910077:29915187,29910080:29914739,29910083:29914575,29910085:29914491,29910088:29914430,29910090:29914072,29910092:29913997,29910106:29914118,29910120:29913899,29910122:29913576,29912892:29913277,29934942:29937342,29934944:29937497,29934946:29937460,29934949:29937278,29934952:29937372,29934955:29937232,29934957:29936982,29934960:29937051,29934963:2993690', 'assoc_mat': '29872026:autre:4230:29874336,29872028:autre:4230:29874447,29872030:autre:4230:29874413,29872032:autre:4230:29874264,29872034:autre:4230:29874351,29872036:autre:4230:29874176,29872037:autre:4230:29874088,29872041:autre:4230:29874158,29872043:autre:4230:29873935,29872045:autre:4230:29874220,29872048:autre:4230:29873891,29872051:autre:4230:29874008,29872056:autre:4230:29873772,29872059:autre:4230:29873724,29872060:autre:4230:29873830,29872063:autre:4230:29873801,29872066:autre:4230:29873473,29872071:autre:4230:29873540,29872072:autre:4230:29873323,29872074:autre:4230:29873432,29872076:autre:4230:29873174,29872078:autre:4230:29873144,29873351:autre:4230:29873571,29874583:autre:4230:29874612,29910018:autre:4230:29915759,29910021:autre:4230:29916009,29910023:autre:4230:29917724,29910026:autre:4230:29916404,29910030:autre:4230:29916078,29910034:autre:4230:29916122,29910038:autre:4230:29915931,29910041:autre:4230:29915539,29910045:autre:4230:29915680,29910050:autre:4230:29915356,29910054:autre:4230:29915234,29910068:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03526592289250692, 'nb_photo': 44399, 'list_port_cont': '29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878', 'assoc_port': '29872026:29874342,29872028:29874443,29872030:29874406,29872032:29874270,29872034:29874357,29872036:29874173,29872037:29874087,29872041:29874161,29872043:29873937,29872045:29874230,29872048:29873905,29872051:29874014,29872056:29873765,29872059:29873727,29872060:29873838,29872063:29873810,29872066:29873474,29872071:29873549,29872072:29873314,29872074:29873443,29872076:29873173,29872078:29873142,29873351:29873574,29874583:29874621,29910018:29915779,29910021:29916016,29910023:29917732,29910026:29916402,29910030:29916088,29910034:29916135,29910038:29915932,29910041:29915555,29910045:29915681,29910050:29915370,29910054:29915233,29910068:29915113,29910075:29914931,29910077:29915200,29910080:29914756,29910083:29914570,29910085:29914492,29910088:29914435,29910090:29914078,29910092:29914002,29910106:29914115,29910120:29913910,29910122:29913589,29912892:29913268,29934942:29937350,29934944:29937485,29934946:29937462,29934949:29937277,29934952:29937383,29934955:29937236,29934957:29936980,29934960:29937058,29934963:2993691', 'assoc_mat': '29872026:carton:4230:29874342,29872028:carton:4230:29874443,29872030:carton:4230:29874406,29872032:carton:4230:29874270,29872034:carton:4230:29874357,29872036:carton:4230:29874173,29872037:carton:4230:29874087,29872041:carton:4230:29874161,29872043:carton:4230:29873937,29872045:carton:4230:29874230,29872048:carton:4230:29873905,29872051:carton:4230:29874014,29872056:carton:4230:29873765,29872059:carton:4230:29873727,29872060:carton:4230:29873838,29872063:carton:4230:29873810,29872066:carton:4230:29873474,29872071:carton:4230:29873549,29872072:carton:4230:29873314,29872074:carton:4230:29873443,29872076:carton:4230:29873173,29872078:carton:4230:29873142,29873351:carton:4230:29873574,29874583:carton:4230:29874621,29910018:carton:4230:29915779,29910021:carton:4230:29916016,29910023:carton:4230:29917732,29910026:carton:4230:29916402,29910030:carton:4230:29916088,29910034:carton:4230:29916135,29910038:carton:4230:29915932,29910041:carton:4230:29915555,29910045:carton:4230:29915681,29910050:carton:4230:29915370,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013565174591263639, 'nb_photo': 994, 'list_port_cont': '29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047', 'assoc_port': '29872026:29874329,29872030:29874400,29872032:29874261,29872034:29874353,29872036:29874179,29872037:29874089,29872041:29874162,29872043:29873941,29872045:29874222,29872048:29873894,29872051:29874001,29872056:29873759,29872059:29873732,29872060:29873834,29872063:29873796,29872066:29873471,29872071:29873539,29872072:29873325,29872074:29873427,29872076:29873172,29872078:29873134,29874583:29874624,29910026:29916409,29910030:29916094,29910034:29916128,29910038:29915926,29910041:29915547,29910045:29915679,29910050:29915362,29910068:29915105,29910077:29915194,29910080:29914755,29910088:29914405,29910090:29914088,29910092:29913996,29910106:29914120,29910122:29913583,29912892:29913266,29934942:29937352,29934946:29937452,29934949:29937273,29934952:29937379,29934955:29937229,29934957:29936978,29934960:29937052,29934963:29936905,29934965:29936823,29934971:29936689,29934973:29936354,29934975:29936424,29934977:29936467,29934979:29936216,29934981:29936312,29934989:29936101,29934993:29936182,29934995:29935038,29936860:2993709', 'assoc_mat': '29872026:metal:4230:29874329,29872030:metal:4230:29874400,29872032:metal:4230:29874261,29872034:metal:4230:29874353,29872036:metal:4230:29874179,29872037:metal:4230:29874089,29872041:metal:4230:29874162,29872043:metal:4230:29873941,29872045:metal:4230:29874222,29872048:metal:4230:29873894,29872051:metal:4230:29874001,29872056:metal:4230:29873759,29872059:metal:4230:29873732,29872060:metal:4230:29873834,29872063:metal:4230:29873796,29872066:metal:4230:29873471,29872071:metal:4230:29873539,29872072:metal:4230:29873325,29872074:metal:4230:29873427,29872076:metal:4230:29873172,29872078:metal:4230:29873134,29874583:metal:4230:29874624,29910026:metal:4230:29916409,29910030:metal:4230:29916094,29910034:metal:4230:29916128,29910038:metal:4230:29915926,29910041:metal:4230:29915547,29910045:metal:4230:29915679,29910050:metal:4230:29915362,29910068:metal:4230:29915105,29910077:metal:4230:29915194,29910080:metal:4230:29914755,29910088:metal:4230:29914405,29910090:metal:4230:29914088,29910092:metal:4230:29913996,29910106:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1581833534025302, 'nb_photo': 159482, 'list_port_cont': '29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878', 'assoc_port': '29872026:29874331,29872028:29874440,29872030:29874415,29872032:29874268,29872034:29874356,29872036:29874178,29872037:29874085,29872041:29874148,29872043:29873939,29872045:29874228,29872048:29873903,29872051:29874018,29872056:29873768,29872059:29873734,29872060:29873844,29872063:29873806,29872066:29873472,29872071:29873555,29872072:29873328,29872074:29873434,29872076:29873171,29872078:29873146,29873351:29873568,29874583:29874623,29910018:29915773,29910021:29916008,29910023:29917730,29910026:29916415,29910030:29916085,29910034:29916136,29910038:29915930,29910041:29915548,29910045:29915692,29910050:29915366,29910054:29915232,29910068:29915112,29910075:29914930,29910077:29915199,29910080:29914752,29910083:29914576,29910085:29914494,29910088:29914426,29910090:29914089,29910092:29914004,29910106:29914119,29910120:29913901,29910122:29913581,29912892:29913270,29934942:29937349,29934944:29937491,29934946:29937461,29934949:29937274,29934952:29937385,29934955:29937235,29934957:29936981,29934960:29937059,29934963:2993691', 'assoc_mat': '29872026:papier:4230:29874331,29872028:papier:4230:29874440,29872030:papier:4230:29874415,29872032:papier:4230:29874268,29872034:papier:4230:29874356,29872036:papier:4230:29874178,29872037:papier:4230:29874085,29872041:papier:4230:29874148,29872043:papier:4230:29873939,29872045:papier:4230:29874228,29872048:papier:4230:29873903,29872051:papier:4230:29874018,29872056:papier:4230:29873768,29872059:papier:4230:29873734,29872060:papier:4230:29873844,29872063:papier:4230:29873806,29872066:papier:4230:29873472,29872071:papier:4230:29873555,29872072:papier:4230:29873328,29872074:papier:4230:29873434,29872076:papier:4230:29873171,29872078:papier:4230:29873146,29873351:papier:4230:29873568,29874583:papier:4230:29874623,29910018:papier:4230:29915773,29910021:papier:4230:29916008,29910023:papier:4230:29917730,29910026:papier:4230:29916415,29910030:papier:4230:29916085,29910034:papier:4230:29916136,29910038:papier:4230:29915930,29910041:papier:4230:29915548,29910045:papier:4230:29915692,29910050:papier:4230:29915366,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002697407757525186, 'nb_photo': 801, 'list_port_cont': '29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961', 'assoc_port': '29872026:29874345,29872030:29874412,29872034:29874360,29872036:29874174,29872037:29874081,29872043:29873940,29872045:29874234,29872051:29874009,29872060:29873840,29872071:29873552,29872072:29873322,29872074:29873440,29872076:29873178,29872078:29873137,29873351:29873565,29874583:29874628,29910018:29915774,29910038:29915927,29910041:29915553,29910045:29915693,29910050:29915367,29910054:29915231,29910068:29915117,29910075:29914922,29910077:29915196,29910080:29914747,29910083:29914583,29910085:29914493,29910090:29914083,29910106:29914124,29910120:29913911,29910122:29913588,29912892:29913281,29934942:29937353,29934946:29937453,29934949:29937281,29934960:29937060,29934963:29936900,29934965:29936829,29934967:29936803,29934971:29936694,29934973:29936364,29934975:29936435,29934977:29936474,29934979:29936219,29934981:29936326,29934984:29936291,29934986:29936146,29934989:29936105,29934993:29936170,29934995:29935054,29936860:29937087,29941172:29942421,29941175:29942078,29941176:29942263,29941178:29942057,29941193:2994191', 'assoc_mat': '29872026:pehd:4230:29874345,29872030:pehd:4230:29874412,29872034:pehd:4230:29874360,29872036:pehd:4230:29874174,29872037:pehd:4230:29874081,29872043:pehd:4230:29873940,29872045:pehd:4230:29874234,29872051:pehd:4230:29874009,29872060:pehd:4230:29873840,29872071:pehd:4230:29873552,29872072:pehd:4230:29873322,29872074:pehd:4230:29873440,29872076:pehd:4230:29873178,29872078:pehd:4230:29873137,29873351:pehd:4230:29873565,29874583:pehd:4230:29874628,29910018:pehd:4230:29915774,29910038:pehd:4230:29915927,29910041:pehd:4230:29915553,29910045:pehd:4230:29915693,29910050:pehd:4230:29915367,29910054:pehd:4230:29915231,29910068:pehd:4230:29915117,29910075:pehd:4230:29914922,29910077:pehd:4230:29915196,29910080:pehd:4230:29914747,29910083:pehd:4230:29914583,29910085:pehd:4230:29914493,29910090:pehd:4230:29914083,29910106:pehd:4230:29914124,29910120:pehd:4230:29913911,29910122:pehd:4230:29913588,29912892:pehd:4230:29913281,29934942:pehd:4230:29937353,29934946:pehd:4230:29937453,29934949:pehd:4230:29937281,29934960:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.025234946649520116, 'nb_photo': 18815, 'list_port_cont': '29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878', 'assoc_port': '29872026:29874341,29872028:29874451,29872030:29874417,29872032:29874258,29872034:29874362,29872036:29874168,29872037:29874083,29872041:29874150,29872043:29873938,29872045:29874229,29872048:29873901,29872051:29874015,29872056:29873773,29872059:29873728,29872060:29873841,29872063:29873803,29872066:29873467,29872071:29873550,29872072:29873324,29872074:29873438,29872076:29873175,29872078:29873145,29873351:29873569,29874583:29874627,29910018:29915771,29910021:29916005,29910023:29917731,29910026:29916406,29910030:29916091,29910034:29916134,29910038:29915919,29910041:29915551,29910045:29915688,29910050:29915369,29910054:29915235,29910068:29915115,29910075:29914923,29910077:29915197,29910080:29914750,29910083:29914573,29910085:29914490,29910088:29914415,29910090:29914084,29910092:29914001,29910106:29914122,29910120:29913904,29910122:29913580,29912892:29913275,29934942:29937346,29934944:29937498,29934946:29937457,29934949:29937276,29934952:29937389,29934955:29937242,29934957:29936985,29934960:29937049,29934963:2993690', 'assoc_mat': '29872026:pet_clair:4230:29874341,29872028:pet_clair:4230:29874451,29872030:pet_clair:4230:29874417,29872032:pet_clair:4230:29874258,29872034:pet_clair:4230:29874362,29872036:pet_clair:4230:29874168,29872037:pet_clair:4230:29874083,29872041:pet_clair:4230:29874150,29872043:pet_clair:4230:29873938,29872045:pet_clair:4230:29874229,29872048:pet_clair:4230:29873901,29872051:pet_clair:4230:29874015,29872056:pet_clair:4230:29873773,29872059:pet_clair:4230:29873728,29872060:pet_clair:4230:29873841,29872063:pet_clair:4230:29873803,29872066:pet_clair:4230:29873467,29872071:pet_clair:4230:29873550,29872072:pet_clair:4230:29873324,29872074:pet_clair:4230:29873438,29872076:pet_clair:4230:29873175,29872078:pet_clair:4230:29873145,29873351:pet_clair:4230:29873569,29874583:pet_clair:4230:29874627,29910018:pet_clair:4230:29915771,29910021:pet_clair:4230:29916005,29910023:pet_clair:4230:29917731,29910026:pet_clair:4230:29916406,29910030:pet_clair:4230:29916091,29910034:pet_clair:4230:29916134,29910038:pet_clair:4230:29915919,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022120623708903344, 'nb_photo': 356, 'list_port_cont': '29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188', 'assoc_port': '29872026:29874332,29872028:29874453,29872030:29874414,29872034:29874361,29872036:29874175,29872037:29874086,29872048:29873900,29872059:29873733,29872063:29873804,29872066:29873477,29872071:29873554,29872072:29873318,29872076:29873180,29874583:29874626,29910018:29915778,29910021:29916004,29910023:29917733,29910026:29916412,29910030:29916087,29910034:29916132,29910038:29915920,29910041:29915550,29910045:29915685,29910068:29915114,29910075:29914932,29910077:29915203,29910080:29914759,29910083:29914582,29910085:29914483,29910088:29914413,29910090:29914085,29910106:29914127,29910120:29913906,29910122:29913585,29934942:29937351,29934944:29937487,29934946:29937449,29934949:29937279,29934952:29937388,29934963:29936908,29934965:29936828,29934967:29936800,29934969:29936513,29934971:29936690,29934973:29936362,29934975:29936437,29934977:29936476,29934979:29936213,29934981:29936325,29934984:29936280,29934986:29936143,29934993:29936181,29936860:29937083,29941175:29942082,29941180:29941954,29941182:29941844,29941193:2994191', 'assoc_mat': '29872026:pet_fonce:4230:29874332,29872028:pet_fonce:4230:29874453,29872030:pet_fonce:4230:29874414,29872034:pet_fonce:4230:29874361,29872036:pet_fonce:4230:29874175,29872037:pet_fonce:4230:29874086,29872048:pet_fonce:4230:29873900,29872059:pet_fonce:4230:29873733,29872063:pet_fonce:4230:29873804,29872066:pet_fonce:4230:29873477,29872071:pet_fonce:4230:29873554,29872072:pet_fonce:4230:29873318,29872076:pet_fonce:4230:29873180,29874583:pet_fonce:4230:29874626,29910018:pet_fonce:4230:29915778,29910021:pet_fonce:4230:29916004,29910023:pet_fonce:4230:29917733,29910026:pet_fonce:4230:29916412,29910030:pet_fonce:4230:29916087,29910034:pet_fonce:4230:29916132,29910038:pet_fonce:4230:29915920,29910041:pet_fonce:4230:29915550,29910045:pet_fonce:4230:29915685,29910068:pet_fonce:4230:29915114,29910075:pet_fonce:4230:29914932,29910077:pet_fonce:4230:29915203,29910080:pet_fonce:4230:29914759,29910083:pet_fonce:4230:29914582,29910085:pet_fonce:4230:29914483,29910088:pet_fonce:4230:29914413,29910090:pet_fonce:4230:29914085,2'}), 'main_stat': {'nb_photos': 1119}, 'velours_link': 'https://www.fotonower.com/velours/30124540,30124541,30124542,30124543,30124544,30124545,30124546?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.7758193549607412),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_01_annee_2026.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.34%', 9154], 'carton': ['carton', '3.53%', 44399], 'metal': ['metal', '0.14%', 994], 'papier': ['papier', '15.82%', 159482], 'pehd': ['pehd', '0.27%', 801], 'pet_clair': ['pet_clair', '2.52%', 18815], 'pet_fonce': ['pet_fonce', '0.22%', 356]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_01_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.26user 2.97system 0:14.82elapsed 35%CPU (0avgtext+0avgdata 183464maxresident)k 28864inputs+384outputs (137major+33323minor)pagefaults 0swaps