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 : 3629733 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 : 3109>1000 please execute split_portfolio.py -i 23145313 -l 1000 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 4935, datou_cur_ids : ['2912650'] with mtr_portfolio_ids : ['23145313'] and first list_photo_ids : [] new path : /proc/3629733/ 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.04308962821960449 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:merge_dashboard Tue May 20 19:40: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 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 (1831061, '_______JRM', '2025-05-20 11:30:05', '2025-05-20 11:44:54', 65, 23164754, -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_P23164754_20-05-2025_11_48_58.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 23164782, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23164783, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23164784, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23164785, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23164786, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23164787, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23164788, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23164789, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23164790, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23164791, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23164792, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23164793, '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 (1831061, '_______JRM', '2025-05-20 11:45:04', '2025-05-20 11:58:55', 72, 23165157, -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_P23165157_20-05-2025_12_02_59.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 23165186, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23165187, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23165188, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23165189, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23165190, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23165191, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23165192, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23165193, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23165194, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23165195, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23165196, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23165197, '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 (1831061, '_______JRM', '2025-05-20 12:00:14', '2025-05-20 12:10:34', 27, 23165759, -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_P23165759_20-05-2025_12_32_58.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23165772, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23165773, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23165774, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23165775, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23165776, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23165777, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23165778, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23165779, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23165780, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23165781, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23165782, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23165783, '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 (1831061, '_______JRM', '2025-05-20 13:31:34', '2025-05-20 13:44:55', 34, 23167273, 0.07629793076491675, 2908296, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23167273_20-05-2025_13_47_00.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23167275, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23167276, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23167277, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23167278, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23167279, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23167280, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23167281, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23167282, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23167283, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23167284, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23167285, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23167286, '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 (1831061, '_______JRM', '2025-05-20 13:45:05', '2025-05-20 13:59:44', 45, 23167439, 0.03112771591305777, 2908332, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23167439_20-05-2025_14_02_58.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23167447, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23167448, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23167449, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23167450, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23167451, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23167452, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23167453, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23167454, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23167455, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23167456, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23167457, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23167458, '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 (1831061, '_______JRM', '2025-05-20 14:00:25', '2025-05-20 14:14:54', 64, 23167741, 0.07085660695325034, 2908437, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23167741_20-05-2025_14_19_00.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 23167753, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23167754, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23167755, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23167756, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23167757, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23167758, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23167759, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23167760, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23167761, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23167762, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23167763, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23167764, '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 (1831061, '_______JRM', '2025-05-20 14:15:04', '2025-05-20 14:29:54', 14, 23168087, -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_P23168087_20-05-2025_14_32_58.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23168102, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23168103, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23168104, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23168105, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23168106, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23168107, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23168108, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23168109, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23168110, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23168111, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23168112, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23168113, '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 (1831061, '_______JRM', '2025-05-20 14:30:05', '2025-05-20 14:44:54', 69, 23168481, 0.05252275629814615, 2908729, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23168481_20-05-2025_14_46_57.pdf', 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23168506, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23168507, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23168508, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23168509, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23168510, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23168511, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23168512, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23168513, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23168514, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23168515, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23168516, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23168517, '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 (1831061, '_______JRM', '2025-05-20 14:45:04', '2025-05-20 14:58:55', 66, 23169091, 0.025853195334364174, 2908865, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23169091_20-05-2025_15_03_51.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23169154, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23169155, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23169156, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23169157, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23169158, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23169159, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23169160, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23169161, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23169162, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23169163, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23169164, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23169165, '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 (1831061, '_______JRM', '2025-05-20 15:00:14', '2025-05-20 15:14:54', 48, 23169661, 0.005815628526557648, 2908984, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23169661_20-05-2025_15_16_59.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23169708, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23169709, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23169710, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23169711, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23169712, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23169713, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23169714, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23169715, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23169716, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23169717, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23169718, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23169719, '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 (1831061, '_______JRM', '2025-05-20 15:15:04', '2025-05-20 15:29:34', 64, 23170312, 0.040050094900843006, 2909121, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23170312_20-05-2025_15_32_57.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23170338, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23170339, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23170340, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23170341, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23170342, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23170343, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23170344, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23170345, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23170346, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23170347, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23170348, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23170349, '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 (1831061, '_______JRM', '2025-05-20 15:30:34', '2025-05-20 15:44:43', 52, 23170903, 0.03579794795997358, 2909396, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23170903_20-05-2025_15_47_02.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23170918, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23170919, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23170921, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23170922, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23170923, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23170924, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23170925, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23170926, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23170927, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23170928, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23170929, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23170930, '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 (1831061, '_______JRM', '2025-05-20 15:45:24', '2025-05-20 15:58:44', 46, 23171365, 0.0875963054302207, 2909625, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23171365_20-05-2025_16_03_28.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23171408, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23171409, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23171410, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23171411, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23171412, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23171413, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23171414, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23171415, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23171416, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23171417, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23171418, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23171419, '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 (1831061, '_______JRM', '2025-05-20 16:00:14', '2025-05-20 16:14:54', 73, 23171907, 0.04990430845625334, 2909911, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23171907_20-05-2025_16_17_31.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23171914, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23171915, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23171916, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23171917, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23171918, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23171919, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23171920, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23171921, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23171922, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23171923, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23171924, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23171925, '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 (1831061, '_______JRM', '2025-05-20 16:15:05', '2025-05-20 16:29:55', 69, 23172384, 0.030550474541386385, 2910152, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23172384_20-05-2025_16_33_00.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23172386, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23172387, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23172388, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23172389, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23172390, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23172391, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23172392, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23172393, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23172394, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23172395, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23172396, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23172397, '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 (1831061, '_______JRM', '2025-05-20 16:30:05', '2025-05-20 16:44:55', 77, 23172892, 0.050730504299807085, 2910381, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23172892_20-05-2025_16_48_58.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23172926, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23172927, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23172928, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23172929, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23172930, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23172931, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23172932, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23172933, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23172934, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23172935, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23172936, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23172937, '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 (1831061, '_______JRM', '2025-05-20 16:45:04', '2025-05-20 16:54:45', 46, 23173620, 0.05151332490559475, 2910696, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23173620_20-05-2025_17_19_02.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23173644, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23173645, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23173646, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23173647, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23173648, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23173649, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23173650, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23173651, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23173652, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23173653, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23173654, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23173655, '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 (1831061, '_______JRM', '2025-05-20 17:16:03', '2025-05-20 17:29:44', 66, 23174737, 0.04309823981506795, 2911106, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23174737_20-05-2025_17_33_01.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23174760, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23174761, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23174762, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23174763, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23174764, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23174765, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23174766, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23174767, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23174768, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23174769, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23174770, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23174771, '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 (1831061, '_______JRM', '2025-05-20 18:06:34', '2025-05-20 18:14:54', 34, 23175640, 0.060889767675871294, 2911407, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23175640_20-05-2025_18_16_58.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 23175665, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23175666, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23175667, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23175668, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23175669, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23175670, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23175671, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23175672, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23175673, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23175674, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23175675, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23175676, '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 (1831061, '_______JRM', '2025-05-20 18:15:04', '2025-05-20 18:29:54', 65, 23175778, 0.04438887297061909, 2911435, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23175778_20-05-2025_18_32_59.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23175803, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23175804, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23175805, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23175806, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23175807, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23175808, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23175809, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23175810, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23175811, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23175812, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23175813, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23175814, '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 (1831061, '_______JRM', '2025-05-20 18:30:05', '2025-05-20 18:44:54', 62, 23176118, 0.03337843011197686, 2911550, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23176118_20-05-2025_18_46_59.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 23176189, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23176190, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23176191, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23176192, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23176193, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23176194, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23176195, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23176196, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23176197, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23176198, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23176199, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23176200, '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 (1831061, '_______JRM', '2025-05-20 18:45:45', '2025-05-20 18:59:53', 60, 23176567, 0.030126740607880845, 2911706, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23176567_20-05-2025_19_02_58.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23176574, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23176575, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23176576, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23176577, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23176578, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23176579, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23176580, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23176581, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23176582, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23176583, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23176584, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23176585, '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 (1831061, '_______JRM', '2025-05-20 19:00:03', '2025-05-20 19:14:44', 71, 23177023, 0.0867599035472849, 2911902, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23177023_20-05-2025_19_19_00.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23177050, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23177051, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23177052, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23177053, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23177054, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23177055, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23177056, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23177057, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23177058, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23177059, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23177060, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23177061, '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 (1831061, '_______JRM', '2025-05-20 19:17:14', '2025-05-20 19:29:53', 57, 23177719, 0.022383935129632205, 2912232, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23177719_20-05-2025_19_33_02.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23177771, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23177772, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23177773, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23177774, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23177775, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23177776, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23177777, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23177778, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23177779, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23177780, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23177781, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23177782, '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 (1831061, '_______JRM', '2025-05-20 19:30:03', '2025-05-20 19:37:43', 33, 23178323, -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_P23178323_20-05-2025_19_38_59.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23178343, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23178344, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23178345, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23178346, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23178347, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23178348, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23178349, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23178350, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23178351, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23178352, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23178353, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23178354, '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.031172513961791992 time spend for datou_step_exec : 1.0203824043273926 time spend to save output : 0.031676530838012695 total time spend for step 1 : 1.0520589351654053 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.56user 0.76system 0:06.00elapsed 38%CPU (0avgtext+0avgdata 99280maxresident)k 0inputs+168outputs (0major+48887minor)pagefaults 0swaps