SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=22810785 AND mptpi.`type`=3726 To do This function is not protected ! # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 13596 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11881 final have less inputs used (1) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11881 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13625 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 11884 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 3 of step 11884 have datatype=6 WARNING : type of output 1 of step 13596 doesn't seem to be define in the database( WARNING : type of input 3 of step 11881 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 0 of step 13625 have datatype=18 WARNING : type of output 1 of step 13625 doesn't seem to be define in the database( WARNING : type of input 5 of step 11884 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=22811272 AND mptpi.`type`=3726 To do elapsed_time : count_nb_balles_and_create_portfolio 0.7568843364715576 # DISPLAY ALL COLLECTED DATA : {'09052025': {'nb_upload': 441, 'nb_taggue_class': 427, 'nb_taggue_densite': 427}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1357126443, 1357126441, 1357126438, 1357126423, 1357126145, 1357126086, 1357126035, 1357125999, 1357125972, 1357125947, 1357125943, 1357125941, 1357125939, 1357125937, 1357125935, 1357125907, 1357125904, 1357125901, 1357125847, 1357125731, 1357125696, 1357125693, 1357125692, 1357125691, 1357125690, 1357125688, 1357125647, 1357125646, 1357125645, 1357125643, 1357125616, 1357125615, 1357125613, 1357125611, 1357125582, 1357125580, 1357125578, 1357125576, 1357125539, 1357125537, 1357125535, 1357125533, 1357125502, 1357125499, 1357125498, 1357125497, 1357125495, 1357125446, 1357125444, 1357125442, 1357125406, 1357125405, 1357125404, 1357125402, 1357125359, 1357125356, 1357125353, 1357125350, 1357125347, 1357125308, 1357125304, 1357125300, 1357125276, 1357125271, 1357125269, 1357125266, 1357125263, 1357125261, 1357125222, 1357125218, 1357125216, 1357125214, 1357125212, 1357125209, 1357125174, 1357125172, 1357125170, 1357125135, 1357125132, 1357125129, 1357125127, 1357125122, 1357125076, 1357125075, 1357125072, 1357125069, 1357125066, 1357125064, 1357125032, 1357125030, 1357125028, 1357125026, 1357125023, 1357124985, 1357124981, 1357124977, 1357124974, 1357124971, 1357124968, 1357124939] Looping around the photos to save general results len do output : 1 /22807051Didn't retrieve data . before output type Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357126443', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357126441', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357126438', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357126423', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357126145', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357126086', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357126035', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125999', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125972', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125947', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125943', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125941', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125939', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125937', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125935', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125907', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125904', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125901', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125847', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125731', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125696', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125693', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125692', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125691', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125690', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125688', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125647', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125646', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125645', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125643', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125616', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125615', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125613', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125611', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125582', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125580', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125578', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125576', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125539', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125537', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125535', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125533', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125502', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125499', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125498', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125497', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125495', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125446', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125444', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125442', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125406', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125405', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125404', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125402', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125359', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125356', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125353', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125350', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125347', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125308', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125304', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125300', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125276', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125271', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125269', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125266', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125263', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125261', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125222', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125218', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125216', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125214', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125212', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125209', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125174', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125172', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125170', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125135', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125132', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125129', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125127', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125122', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125076', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125075', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125072', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125069', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125066', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125064', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125032', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125030', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125028', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125026', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357125023', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357124985', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357124981', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357124977', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357124974', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357124971', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357124968', None, None, None, None, None, '2810395') ('4876', None, None, None, None, None, None, None, '2810395') ('4876', '22807051', '1357124939', None, None, None, None, None, '2810395') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 101 time used for this insertion : 0.024842500686645508 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.9676692485809326 time spend to save output : 0.02565932273864746 total time spend for step 1 : 0.9933285713195801 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.23user 0.92system 0:04.83elapsed 44%CPU (0avgtext+0avgdata 102272maxresident)k 8inputs+88outputs (3major+49523minor)pagefaults 0swaps