python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4935' -s datou_current_4935 -M 0 -S 0 -U 95,95,120 import MySQLdb succeeded Import error (python version) ['/Users/moilerat/Documents/Fotonower/install/caffe/distribute/python', '/home/admin/workarea/git/Velours/python/prod', '/home/admin/workarea/install/caffe_cuda8_python3/python', '/home/admin/workarea/install/darknet', '/home/admin/workarea/git/Velours/python', '/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python', '/home/admin/mtr/.credentials', '/home/admin/workarea/install/caffe/python', '/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools', '/home/admin/workarea/git/fotonowerpip', '/home/admin/workarea/install/segment-anything', '/home/admin/workarea/git/pyfvs', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/admin/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages'] process id : 4108558 load datou : 4935 # 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 ! Unexpected type for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? load thcls load pdts Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec no input labels no input values updating current state to 1 we have a portfolio with more photos than limit : 2098>1000 please execute split_portfolio.py -i 23319689 -l 1000 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 4935, datou_cur_ids : ['2954183'] with mtr_portfolio_ids : ['23319689'] and first list_photo_ids : [] new path : /proc/4108558/ Inside batchDatouExec : verbose : 0 # 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 ! List Step Type Loaded in datou : merge_dashboard over limit max, limiting to limit_max 100 list_input_json : {} origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! we have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB time to download the photos : 0.02878403663635254 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:merge_dashboard Mon May 26 14:52:30 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 2022-04-13 10:29:59 0 TODO : Insert select and so on TODO : Insert select and so on to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do TODO : Insert select and so on INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 05:00:14', '2025-05-26 05:14:54', 55, 23319692, 0.02519662063444177, 2948214, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23319692_26-05-2025_11_17_31.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23319693, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23319694, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23319695, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23319696, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23319697, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23319698, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23319699, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23319700, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23319701, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23319702, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23319703, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23319704, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 05:15:04', '2025-05-26 05:29:24', 61, 23319847, 0.04429005484375135, 2948254, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23319847_26-05-2025_05_33_34.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23319848, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23319849, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23319850, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23319851, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23319852, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23319853, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23319854, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23319855, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23319856, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23319857, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23319858, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23319859, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 05:30:04', '2025-05-26 05:44:54', 78, 23320077, 0.03387753435924145, 2948365, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23320077_26-05-2025_11_16_30.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23320078, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23320079, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23320080, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23320081, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23320082, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23320083, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23320084, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23320085, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23320086, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23320087, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23320088, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23320089, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 05:45:04', '2025-05-26 05:59:54', 71, 23325134, 0.04692466993136173, 2951444, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23325134_26-05-2025_11_08_33.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23325376, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23325377, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23325378, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23325379, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23325380, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23325381, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23325382, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23325383, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23325384, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23325385, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23325386, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23325387, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 06:00:04', '2025-05-26 06:14:54', 61, 23320531, 0.05544331765388143, 2948625, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23320531_26-05-2025_11_16_01.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23320532, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23320533, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23320534, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23320535, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23320536, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23320537, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23320538, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23320539, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23320540, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23320541, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23320542, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23320543, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 06:15:04', '2025-05-26 06:29:54', 75, 23321016, 0.0894193868825305, 2948863, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23321016_26-05-2025_11_15_31.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23321017, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23321018, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23321019, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23321020, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23321021, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23321022, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23321023, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23321024, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23321025, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23321026, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23321027, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23321028, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 06:30:04', '2025-05-26 06:44:55', 71, 23325136, 0.022613860282363396, 2951445, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23325136_26-05-2025_11_08_04.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23325339, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23325340, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23325341, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23325342, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23325343, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23325344, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23325345, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23325346, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23325348, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23325349, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23325350, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23325351, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 06:45:04', '2025-05-26 06:58:54', 72, 23321495, -1.0, -1, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23321495_26-05-2025_11_15_01.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23321496, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23321497, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23321498, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23321499, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23321500, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23321501, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23321502, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23321503, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23321504, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23321505, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23321506, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23321507, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 07:00:14', '2025-05-26 07:14:44', 73, 23321641, 0.02985346412270691, 2949196, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23321641_26-05-2025_11_14_03.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23321642, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23321643, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23321644, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23321645, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23321646, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23321647, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23321648, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23321649, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23321650, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23321651, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23321652, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23321653, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 07:15:04', '2025-05-26 07:29:55', 76, 23325138, 0.036139356830812215, 2951446, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23325138_26-05-2025_11_07_32.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23325303, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23325304, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23325305, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23325306, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23325307, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23325308, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23325309, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23325310, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23325311, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23325312, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23325313, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23325314, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 07:30:05', '2025-05-26 07:44:54', 74, 23322061, 0.02602303439189305, 2949486, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23322061_26-05-2025_11_13_31.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23322062, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23322063, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23322064, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23322065, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23322066, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23322067, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23322068, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23322069, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23322070, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23322071, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23322072, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23322073, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 07:45:04', '2025-05-26 07:58:45', 65, 23325141, 0.0429633289857965, 2951447, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23325141_26-05-2025_11_07_04.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23325265, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23325266, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23325267, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23325268, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23325269, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23325270, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23325271, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23325273, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23325274, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23325275, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23325276, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23325277, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 08:00:14', '2025-05-26 08:14:54', 74, 23322562, 0.02768663961105856, 2949854, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23322562_26-05-2025_11_12_32.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23322571, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23322572, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23322573, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23322574, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23322575, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23322576, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23322577, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23322578, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23322579, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23322580, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23322581, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23322583, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 08:15:04', '2025-05-26 08:29:54', 71, 23323551, 0.04185348961256268, 2950540, '-1.0', "{'max_time_prod_two_photos': 0, 'metal': {'hashtag': 'metal', 'sub_port_id': 23323553, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23323554, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23323555, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23323556, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23323557, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23323558, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23323559, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23323560, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23323561, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23323562, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23323563, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23323564, 'pht': 3726}, 'url_report': ''}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 08:30:05', '2025-05-26 08:44:54', 74, 23323111, 0.05436677666639777, 2950232, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23323111_26-05-2025_11_12_00.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23323113, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23323114, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23323115, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23323116, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23323117, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23323118, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23323119, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23323120, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23323121, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23323122, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23323123, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23323124, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 08:45:04', '2025-05-26 08:58:55', 67, 23323520, 0.05594342227950576, 2950535, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23323520_26-05-2025_09_03_29.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23323523, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23323524, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23323525, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23323526, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23323527, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23323528, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23323529, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23323530, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23323531, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23323532, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23323533, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23323534, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 09:30:54', '2025-05-26 09:44:54', 68, 23323923, 0.02269183291199363, 2950727, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23323923_26-05-2025_11_11_30.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 23323924, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23323925, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23323926, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23323927, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23323928, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23323929, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23323930, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23323931, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23323932, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23323933, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23323934, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23323935, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 09:45:04', '2025-05-26 09:59:54', 59, 23324068, 0.0338376396467845, 2950787, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23324068_26-05-2025_11_10_30.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23324069, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23324070, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23324071, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23324072, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23324073, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23324074, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23324075, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23324076, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23324077, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23324078, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23324079, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23324080, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 10:00:03', '2025-05-26 10:14:43', 79, 23324122, 0.019603365584841985, 2950845, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23324122_26-05-2025_11_10_02.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23324124, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23324125, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23324126, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23324127, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23324128, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23324129, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23324130, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23324131, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23324132, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23324133, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23324134, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23324135, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 10:15:14', '2025-05-26 10:29:54', 77, 23324402, 0.017948956951831813, 2951013, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23324402_26-05-2025_11_09_30.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23324404, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23324405, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23324406, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23324407, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23324408, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23324409, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23324410, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23324411, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23324412, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23324413, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23324414, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23324415, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 10:30:03', '2025-05-26 10:44:53', 72, 23324563, 0.012910999500873472, 2951108, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23324563_26-05-2025_11_09_02.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23324565, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23324566, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23324567, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23324568, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23324569, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23324570, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23324571, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23324572, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23324573, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23324574, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23324575, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23324576, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 10:45:03', '2025-05-26 10:58:53', 73, 23325143, 0.0803310808757231, 2951448, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23325143_26-05-2025_11_06_32.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23325151, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23325152, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23325153, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23325154, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23325155, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23325156, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23325157, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23325158, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23325159, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23325160, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23325161, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23325162, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 11:00:14', '2025-05-26 11:14:54', 31, 23325201, 0.052389026009317004, 2951498, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23325201_26-05-2025_11_19_33.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23325203, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23325204, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23325205, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23325206, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23325207, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23325208, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23325209, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23325210, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23325211, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23325212, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23325213, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23325214, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 11:15:04', '2025-05-26 11:29:55', 75, 23325821, 0.04660843160354288, 2951771, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23325821_26-05-2025_11_33_58.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23325843, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23325844, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23325845, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23325846, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23325847, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23325848, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23325849, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23325850, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23325851, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23325852, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23325853, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23325855, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 11:30:04', '2025-05-26 11:44:54', 59, 23326708, 0.04892546956012179, 2952066, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23326708_26-05-2025_11_47_01.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23326719, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23326720, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23326721, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23326722, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23326723, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23326724, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23326725, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23326726, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23326727, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23326728, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23326729, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23326730, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 11:45:04', '2025-05-26 11:58:55', 68, 23327651, 0.0399187429071831, 2952347, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23327651_26-05-2025_12_02_59.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23327665, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23327666, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23327667, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23327668, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23327669, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23327670, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23327671, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23327672, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23327673, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23327674, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23327675, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23327676, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 12:00:14', '2025-05-26 12:12:44', 51, 23328708, 0.04989606730144674, 2952662, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23328708_26-05-2025_13_59_59.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23328751, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23328752, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23328753, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23328754, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23328755, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23328756, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23328757, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23328758, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23328759, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23328760, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23328761, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23328762, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 13:34:43', '2025-05-26 13:43:54', 10, 23335603, 0.04992283243862639, 2953477, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23335603_26-05-2025_13_49_00.pdf', 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23335608, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23335609, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23335611, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23335612, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23335613, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23335615, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23335616, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23335617, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23335619, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23335620, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23335621, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23335623, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 13:47:53', '2025-05-26 13:57:44', 32, 23336428, 0.05095947846647624, 2953526, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23336428_26-05-2025_13_59_00.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23336441, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23336442, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23336443, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23336444, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23336445, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23336446, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23336447, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23336448, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23336449, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23336450, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23336451, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23336452, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 14:00:13', '2025-05-26 14:14:43', 62, 23336675, 0.03821279076052263, 2953614, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23336675_26-05-2025_14_16_28.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23336682, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23336683, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23336684, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23336685, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23336686, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23336687, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23336689, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23336690, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23336691, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23336692, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23336693, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23336694, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 14:15:14', '2025-05-26 14:29:44', 73, 23337140, 0.05430029501819769, 2953738, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23337140_26-05-2025_14_33_00.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23337151, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23337152, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23337153, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23337154, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23337155, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23337156, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23337157, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23337158, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23337159, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23337160, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23337161, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23337162, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 14:30:13', '2025-05-26 14:44:54', 49, 23337584, 0.07232789105174764, 2953870, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23337584_26-05-2025_14_47_00.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23337672, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23337673, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23337674, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23337675, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23337676, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23337677, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23337678, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23337679, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23337680, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23337681, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23337682, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23337683, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1843197, '_______JRM', '2025-05-26 14:45:24', '2025-05-26 14:48:34', 16, 23338342, -1.0, -1, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23338342_26-05-2025_14_48_59.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23338416, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23338417, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23338418, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23338419, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23338420, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23338421, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23338422, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23338423, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23338424, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23338425, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23338426, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23338427, 'pht': 3726}}" ); Inside saveOutput : final : True verbose : 0 ouput is None saving photo_ids in datou_result begin to insert list_values into mtr_datou_result : length of list_values in save_final : 100 time used for this insertion : 0.03484082221984863 time spend for datou_step_exec : 0.6592116355895996 time spend to save output : 0.03531241416931152 total time spend for step 1 : 0.6945240497589111 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 1 set_done_treatment 1.52user 0.74system 0:04.28elapsed 52%CPU (0avgtext+0avgdata 100224maxresident)k 8inputs+112outputs (6major+48859minor)pagefaults 0swaps