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 : 3117913
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 : 2502>1000
please execute split_portfolio.py -i 27909733 -l 1000
size over we load limit photo not treated
list_input_json: {}
Current got : datou_id : 4935, datou_cur_ids : ['3961876'] with mtr_portfolio_ids : ['27909733'] and first list_photo_ids : []
new path :  /proc/3117913/
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.047559499740600586
About to test input to load 
Calling datou_exec

Inside datou_exec : verbose : 0
number of steps :  1
step1:merge_dashboard
Wed Oct 29 20:32: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
to do
to do
to do
to do
TODO : Insert select and so on
Catched exception !
Connect or reconnect !
Catched exception !
Connect or reconnect !

        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
(2478875, '_______JRM',
'2025-10-29 09:47:03', '2025-10-29 09:58:03',
54, 27919524,
-1.0, -1,
'-1.0', "{'max_time_prod_two_photos': 0}"
);

        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
(2478875, '_______JRM',
'2025-10-29 10:00:14', '2025-10-29 10:14:54',
66, 27919529,
-1.0, -1,
'-1.0', "{'max_time_prod_two_photos': 0}"
);

        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
(2478875, '_______JRM',
'2025-10-29 10:15:14', '2025-10-29 10:29:44',
75, 27919533,
-1.0, -1,
'-1.0', "{'max_time_prod_two_photos': 0}"
);

        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
(2478875, '_______JRM',
'2025-10-29 10:30:14', '2025-10-29 10:38:34',
29, 27919538,
-1.0, -1,
'-1.0', "{'max_time_prod_two_photos': 0}"
);

        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
(2478875, '_______JRM',
'2025-10-29 10:51:24', '2025-10-29 10:59:54',
40, 27919544,
-1.0, -1,
'-1.0', "{'max_time_prod_two_photos': 0}"
);

        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
(2478875, '_______JRM',
'2025-10-29 11:00:04', '2025-10-29 11:14:43',
75, 27919548,
-1.0, -1,
'-1.0', "{'max_time_prod_two_photos': 0}"
);

        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
(2478875, '_______JRM',
'2025-10-29 11:15:14', '2025-10-29 11:29:54',
75, 27916491,
-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_P27916491_29-10-2025_20_02_00.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27916680, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27916681, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27916682, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27916683, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27916684, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27916685, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27916686, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27916687, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27916688, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27916689, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27916690, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27916691, '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
(2478875, '_______JRM',
'2025-10-29 11:30:13', '2025-10-29 11:44:54',
60, 27916492,
-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_P27916492_29-10-2025_19_01_31.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 27916594, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27916596, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27916597, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27916598, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27916599, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27916600, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27916602, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27916603, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27916604, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27916605, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27916607, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27916608, '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
(2478875, '_______JRM',
'2025-10-29 11:45:04', '2025-10-29 11:59:55',
80, 27916505,
-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_P27916505_29-10-2025_19_01_33.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27916587, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27916588, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27916589, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27916590, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27916591, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27916592, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27916593, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27916595, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27916601, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27916606, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27916609, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27916610, '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
(2478875, '_______JRM',
'2025-10-29 12:00:15', '2025-10-29 12:11:15',
45, 27916518,
-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_P27916518_29-10-2025_19_01_16.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27916556, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27916557, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27916558, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27916559, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27916560, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27916562, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27916563, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27916564, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27916565, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27916566, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27916567, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27916568, '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
(2478875, '_______JRM',
'2025-10-29 13:51:14', '2025-10-29 13:58:55',
48, 27916519,
-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_P27916519_29-10-2025_19_01_02.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27916530, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27916531, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27916532, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27916533, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27916534, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27916535, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27916536, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27916537, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27916538, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27916539, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27916540, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27916541, '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
(2478875, '_______JRM',
'2025-10-29 14:00:14', '2025-10-29 14:14:44',
90, 27913667,
-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_P27913667_29-10-2025_19_00_33.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 27914127, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27914128, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27914129, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27914130, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27914131, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27914132, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27914133, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27914134, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27914135, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27914136, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27914137, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27914138, '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
(2478875, '_______JRM',
'2025-10-29 14:15:04', '2025-10-29 14:29:54',
86, 27913674,
-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_P27913674_29-10-2025_18_06_01.pdf', 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27914087, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27914088, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27914090, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27914091, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27914092, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27914093, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27914094, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27914096, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27914097, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27914098, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27914100, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27914101, '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
(2478875, '_______JRM',
'2025-10-29 14:30:14', '2025-10-29 14:44:54',
83, 27913676,
-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_P27913676_29-10-2025_18_04_32.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27913961, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27913962, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27913963, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27913964, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27913965, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27913966, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27913967, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27913968, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27913969, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27913970, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27913971, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27913972, '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
(2478875, '_______JRM',
'2025-10-29 14:45:04', '2025-10-29 14:59:54',
41, 27913679,
-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_P27913679_29-10-2025_18_04_00.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27913902, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27913903, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27913904, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27913905, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27913906, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27913907, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27913908, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27913909, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27913910, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27913911, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27913912, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27913913, '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
(2478875, '_______JRM',
'2025-10-29 15:00:04', '2025-10-29 15:14:44',
52, 27913681,
-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_P27913681_29-10-2025_18_03_01.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27913776, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27913777, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27913778, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27913779, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27913780, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27913781, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27913782, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27913783, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27913784, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27913785, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27913786, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27913787, '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
(2478875, '_______JRM',
'2025-10-29 15:15:14', '2025-10-29 15:29:54',
82, 27913683,
-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_P27913683_29-10-2025_18_03_32.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27913836, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27913837, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27913838, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27913839, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27913840, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27913841, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27913842, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27913843, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27913844, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27913845, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27913846, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27913847, '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
(2478875, '_______JRM',
'2025-10-29 15:30:04', '2025-10-29 15:41:24',
53, 27913685,
-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_P27913685_29-10-2025_18_02_31.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27913750, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27913751, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27913752, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27913753, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27913754, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27913755, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27913756, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27913757, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27913758, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27913759, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27913760, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27913761, '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
(2478875, '_______JRM',
'2025-10-29 15:50:34', '2025-10-29 15:59:55',
43, 27913688,
-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_P27913688_29-10-2025_18_02_03.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 27913692, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27913693, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27913694, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27913695, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27913696, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27913697, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27913698, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27913699, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27913700, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27913701, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27913702, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27913703, '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
(2478875, '_______JRM',
'2025-10-29 16:00:05', '2025-10-29 16:14:54',
83, 27910286,
-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_P27910286_29-10-2025_17_00_57.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27910313, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27910314, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27910315, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27910316, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27910317, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27910318, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27910319, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27910320, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27910321, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27910322, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27910323, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27910324, '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
(2478875, '_______JRM',
'2025-10-29 16:15:35', '2025-10-29 16:29:45',
76, 27909969,
0.08467262785168884, 3960170,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27909969_29-10-2025_16_43_30.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27909988, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27909989, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27909990, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27909991, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27909992, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27909993, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27909994, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27909995, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27909996, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27909997, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27909998, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27909999, '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
(2478875, '_______JRM',
'2025-10-29 16:30:05', '2025-10-29 16:44:54',
70, 27909831,
0.0683213945083424, 3960160,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27909831_29-10-2025_16_50_30.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27909850, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27909851, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27909852, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27909853, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27909854, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27909855, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27909856, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27909857, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27909858, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27909859, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27909860, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27909861, '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
(2478875, '_______JRM',
'2025-10-29 16:45:05', '2025-10-29 16:59:54',
83, 27910478,
0.08615497834677964, 3960266,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27910478_29-10-2025_17_04_59.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 27910621, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27910622, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27910623, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27910624, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27910625, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27910626, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27910627, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27910628, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27910629, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27910630, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27910631, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27910632, '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
(2478875, '_______JRM',
'2025-10-29 17:00:04', '2025-10-29 17:14:24',
81, 27911283,
0.062256139692875676, 3960456,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27911283_29-10-2025_17_18_58.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27911364, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27911365, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27911366, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27911367, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27911368, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27911369, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27911370, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27911371, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27911372, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27911373, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27911374, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27911375, '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
(2478875, '_______JRM',
'2025-10-29 17:15:03', '2025-10-29 17:28:54',
72, 27912109,
0.05975999916530395, 3960689,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27912109_29-10-2025_17_54_57.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 27912129, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27912130, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27912131, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27912132, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27912133, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27912134, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27912135, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27912136, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27912137, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27912138, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27912139, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27912140, '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
(2478875, '_______JRM',
'2025-10-29 18:01:34', '2025-10-29 18:14:54',
74, 27913988,
0.047484922931884124, 3961083,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27913988_29-10-2025_18_19_31.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27913992, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27913993, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27913994, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27913995, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27913996, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27913997, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27913998, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27913999, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27914000, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27914001, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27914002, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27914003, '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
(2478875, '_______JRM',
'2025-10-29 18:15:05', '2025-10-29 18:29:54',
65, 27914554,
0.03137513362402374, 3961142,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27914554_29-10-2025_18_35_01.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27914597, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27914598, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27914599, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27914600, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27914601, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27914602, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27914603, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27914604, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27914605, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27914606, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27914607, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27914608, '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
(2478875, '_______JRM',
'2025-10-29 18:30:04', '2025-10-29 18:44:55',
79, 27915142,
0.0463705624951984, 3961221,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27915142_29-10-2025_18_49_00.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27915181, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27915182, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27915183, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27915184, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27915185, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27915186, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27915187, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27915188, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27915189, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27915190, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27915191, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27915192, '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
(2478875, '_______JRM',
'2025-10-29 18:45:04', '2025-10-29 18:59:44',
66, 27915993,
0.06391968600618841, 3961322,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27915993_29-10-2025_19_04_57.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27916010, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27916011, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27916012, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27916013, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27916014, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27916015, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27916016, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27916018, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27916019, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27916020, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27916021, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27916022, '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
(2478875, '_______JRM',
'2025-10-29 19:00:05', '2025-10-29 19:14:54',
86, 27916767,
0.04151591212020925, 3961401,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27916767_29-10-2025_19_20_59.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27916828, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27916829, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27916830, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27916831, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27916832, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27916833, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27916834, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27916835, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27916836, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27916837, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27916838, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27916839, '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
(2478875, '_______JRM',
'2025-10-29 19:15:04', '2025-10-29 19:29:24',
19, 27917681,
0.05502125820267316, 3961482,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27917681_29-10-2025_19_34_59.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 27917725, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27917726, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27917727, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27917728, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27917729, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27917730, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27917731, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27917732, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27917733, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27917734, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27917735, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27917736, '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
(2478875, '_______JRM',
'2025-10-29 19:32:04', '2025-10-29 19:44:04',
49, 27918277,
0.05015660394706419, 3961551,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27918277_29-10-2025_19_48_58.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27918335, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27918336, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27918337, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27918338, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27918339, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27918340, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27918341, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27918343, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27918344, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27918345, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27918346, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27918347, '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
(2478875, '_______JRM',
'2025-10-29 19:45:04', '2025-10-29 19:59:54',
71, 27918976,
0.03588407251174897, 3961621,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27918976_29-10-2025_20_04_59.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27919018, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27919019, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27919020, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27919021, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27919022, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27919023, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27919024, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27919025, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27919026, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27919027, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27919028, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27919029, '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
(2478875, '_______JRM',
'2025-10-29 20:00:05', '2025-10-29 20:14:45',
65, 27919626,
0.06592251818323581, 3961716,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27919626_29-10-2025_20_18_59.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27919634, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27919635, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27919636, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27919637, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27919638, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27919639, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27919640, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27919641, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27919642, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27919643, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27919644, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27919645, '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
(2478875, '_______JRM',
'2025-10-29 20:15:04', '2025-10-29 20:28:24',
78, 27920623,
0.060016470218394506, 3961807,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27920623_29-10-2025_20_30_59.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 27920632, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 27920633, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 27920634, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 27920635, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 27920636, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 27920637, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 27920638, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 27920639, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 27920640, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 27920641, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 27920642, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 27920643, '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.025646209716796875

time spend for datou_step_exec : 0.7582488059997559
time spend to save output : 0.02602100372314453
total time spend for step 1 : 0.7842698097229004

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.04user 0.60system 0:05.23elapsed 31%CPU (0avgtext+0avgdata 100468maxresident)k
0inputs+104outputs (1major+48443minor)pagefaults 0swaps