result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 4, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 29.998970985412598, 'nb_balles_papier': 4e-05, 'begin_time_port': 'image_10052025_00_45_04_010156m0.jpg 1e-05 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 4e-05 Missing time_diff : 2107751014 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 1, 1: 3, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.99998188018799, 'nb_balles_papier': 4e-05, 'begin_time_port': 'image_10052025_00_48_04_010153m0.jpg 5e-05 for time 1, id_amount 1 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 4e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 4, 2: 1, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 48.99998998641968, 'nb_balles_papier': 5e-05, 'begin_time_port': 'image_10052025_00_49_05_010149m0.jpg 9e-05 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 5e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 5, 2: 1, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.99998879432678, 'nb_balles_papier': 6e-05, 'begin_time_port': 'image_10052025_00_50_04_010147m0.jpg 0.00014000000000000001 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 6e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 4, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 30.00000500679016, 'nb_balles_papier': 4e-05, 'begin_time_port': 'image_10052025_00_51_24_010133m0.jpg 0.0002 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 4e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 6, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.998990058898926, 'nb_balles_papier': 6e-05, 'begin_time_port': 'image_10052025_00_52_04_010138m0.jpg 0.00024 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 6e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 3, 2: 2, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.999993085861206, 'nb_balles_papier': 5e-05, 'begin_time_port': 'image_10052025_00_53_04_010144m0.jpg 0.00030000000000000014 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 5e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 3, 2: 1, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 30.00000500679016, 'nb_balles_papier': 4e-05, 'begin_time_port': 'image_10052025_00_54_24_010138m0.jpg 0.00035000000000000027 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 4e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751014 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751014 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 2, 1: 3, 2: 1, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.999983072280884, 'nb_balles_papier': 6e-05, 'begin_time_port': 'image_10052025_00_55_04_010154m0.jpg 0.00039000000000000037 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 6e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 4, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.999995946884155, 'nb_balles_papier': 4e-05, 'begin_time_port': 'image_10052025_00_56_04_010139m0.jpg 0.00045000000000000053 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 4e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 5, 2: 1, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.99999499320984, 'nb_balles_papier': 6e-05, 'begin_time_port': 'image_10052025_00_57_04_010141m0.jpg 0.0004900000000000006 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 6e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 4, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 49.99897003173828, 'nb_balles_papier': 4e-05, 'begin_time_port': 'image_10052025_00_58_04_010156m0.jpg 0.0005500000000000008 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 4e-05 Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751016 : jrm should be duplicate or empty carpet ! Missing time_diff : 2107751015 : jrm should be duplicate or empty carpet ! result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 4, 2: 1, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 40.99991798400879, 'nb_balles_papier': 5e-05, 'begin_time_port': 'image_10052025_00_59_13_010219m0.jpg 0.0005900000000000009 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 5e-05 ERROR missing amount info ERROR missing amount info result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 0, 'nb_balles_papier': 0, 'begin_time_port': 'image'} Production hashtag (incorrect ponderation at 20-10-18) : 0 ERROR missing amount info ERROR missing amount info ERROR missing amount info result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 19.99998688697815, 'nb_balles_papier': 0, 'begin_time_port': 'image_10052025_01_31_03_10147.jpg'} Production hashtag (incorrect ponderation at 20-10-18) : 0 ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 30.001017093658447, 'nb_balles_papier': 0, 'begin_time_port': 'image_10052025_01_32_03_9130.jpg'} Production hashtag (incorrect ponderation at 20-10-18) : 0 ERROR missing amount info ERROR missing amount info result_one_balle_Type_JRM:{'day': '10052025', 'map_nb_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 0, 'nb_balles_papier': 0, 'begin_time_port': 'image'} Production hashtag (incorrect ponderation at 20-10-18) : 0 We have rejected 4 photos because of the batch_size condition ! NUMBER BATCH list_of_portfolios_to_create : 27 {22850376: [{'mtr_photo_id': 1357334445, 'mtr_portfolio_id': 22850376, 'datou_current_id': 2814910}, We expect two at most portfolio with same photos and datou_carac_id : 2 Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! {22850704: [{'mtr_photo_id': 1357337396, 'mtr_portfolio_id': 22850704, 'datou_current_id': 2814935}, We expect two at most portfolio with same photos and datou_carac_id : 2 Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! {22851294: [{'mtr_photo_id': 1357339030, 'mtr_portfolio_id': 22851294, 'datou_current_id': 2814995}, We expect two at most portfolio with same photos and datou_carac_id : 2 Still a lot to verify ! Still a lot to verify ! {22851181: [{'mtr_photo_id': 1357339353, 'mtr_portfolio_id': 22851181, 'datou_current_id': 2814991}, We expect two at most portfolio with same photos and datou_carac_id : 2 Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! Still a lot to verify ! list_same_port_ids : [] https://marlene.fotonower.com/api/v1/secured/portfolio/new?name=JRM_diff_batch__10052025_01_30_44_010141&access_token=3e00c8f3e5af383c48e3c68940ba6fe7 Still a lot to verify ! list_same_port_ids : [] https://marlene.fotonower.com/api/v1/secured/portfolio/new?name=JRM_diff_batch__10052025_01_31_03_010147&access_token=3e00c8f3e5af383c48e3c68940ba6fe7 Still a lot to verify ! list_same_port_ids : [] https://marlene.fotonower.com/api/v1/secured/portfolio/new?name=JRM_diff_batch__10052025_01_32_03_009130&access_token=3e00c8f3e5af383c48e3c68940ba6fe7 Still a lot to verify ! list_same_port_ids : [] https://marlene.fotonower.com/api/v1/secured/portfolio/new?name=JRM_diff_batch__10052025_01_33_33_010142&access_token=3e00c8f3e5af383c48e3c68940ba6fe7 error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850376 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850294 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850295 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850377 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850378 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850452 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850534 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850535 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850536 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850704 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850629 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850922 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850815 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850816 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850817 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850923 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850870 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22850924 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851294 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851178 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851181 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851074 AND mptpi.`type`=3726 To do error result not float, to be checked, testing the next We don't need to reset the datou_current for this portfolio, que ce soit dans le cas ou il est fini (et found_correct devrait etre vrai, ou dans le cas ou il n'est pas fini, mais du coup on le retrouvera et mettra simplement à jour) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851075 AND mptpi.`type`=3726 To do There was a bug due to new port without datou_current_id # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851488 AND mptpi.`type`=3726 To do There was a bug due to new port without datou_current_id # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851489 AND mptpi.`type`=3726 To do There was a bug due to new port without datou_current_id # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851490 AND mptpi.`type`=3726 To do There was a bug due to new port without datou_current_id # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 ! WARNING : type of output 2 of step 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 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`=22851491 AND mptpi.`type`=3726 To do elapsed_time : count_nb_balles_and_create_portfolio 28.176867246627808 # DISPLAY ALL COLLECTED DATA : {'10052025': {'nb_upload': 206, 'nb_taggue_class': 191, 'nb_taggue_densite': 191}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1357345054, 1357345053, 1357345050, 1357345012, 1357345010, 1357345007, 1357345004, 1357344840, 1357344838, 1357344835, 1357344807, 1357344804, 1357341510, 1357340354, 1357340302, 1357340264, 1357340239, 1357340193, 1357340165, 1357340080, 1357340052, 1357340027, 1357340000, 1357339489, 1357339462, 1357339436, 1357339409, 1357339385, 1357339353, 1357339074, 1357339070, 1357339065, 1357339061, 1357339047, 1357339043, 1357339039, 1357339036, 1357339033, 1357339030, 1357339012, 1357339010, 1357339008, 1357339004, 1357338965, 1357338963, 1357338960, 1357338957, 1357338954, 1357338843, 1357338813, 1357338787, 1357338767, 1357338763, 1357338759, 1357338383, 1357338381, 1357338379, 1357338377, 1357338200, 1357338177, 1357338153, 1357338126, 1357338097, 1357338020, 1357337752, 1357337727, 1357337696, 1357337668, 1357337657, 1357337569, 1357337565, 1357337563, 1357337560, 1357337519, 1357337466, 1357337464, 1357337459, 1357337447, 1357337415, 1357337403, 1357337401, 1357337398, 1357337396, 1357337368, 1357337366, 1357337364, 1357337362, 1357337154, 1357337128, 1357337105, 1357337077, 1357336960, 1357336945, 1357336922, 1357336899, 1357336870, 1357336837, 1357336620, 1357336592, 1357336558] Looping around the photos to save general results len do output : 1 /22848512Didn'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 ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357345054', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357345053', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357345050', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357345012', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357345010', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357345007', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357345004', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357344840', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357344838', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357344835', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357344807', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357344804', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357341510', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340354', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340302', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340264', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340239', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340193', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340165', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340080', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340052', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340027', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357340000', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339489', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339462', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339436', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339409', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339385', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339353', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339074', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339070', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339065', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339061', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339047', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339043', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339039', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339036', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339033', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339030', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339012', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339010', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339008', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357339004', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338965', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338963', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338960', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338957', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338954', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338843', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338813', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338787', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338767', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338763', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338759', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338383', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338381', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338379', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338377', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338200', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338177', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338153', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338126', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338097', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357338020', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337752', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337727', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337696', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337668', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337657', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337569', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337565', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337563', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337560', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337519', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337466', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337464', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337459', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337447', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337415', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337403', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337401', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337398', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337396', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337368', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337366', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337364', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337362', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337154', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337128', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337105', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357337077', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336960', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336945', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336922', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336899', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336870', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336837', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336620', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336592', None, None, None, None, None, '2815036') ('4883', None, None, None, None, None, None, None, '2815036') ('4883', '22848512', '1357336558', None, None, None, None, None, '2815036') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 101 time used for this insertion : 0.7877514362335205 save_final save missing photos in datou_result : time spend for datou_step_exec : 28.33201837539673 time spend to save output : 0.7886736392974854 total time spend for step 1 : 29.120692014694214 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.63system 0:30.66elapsed 6%CPU (0avgtext+0avgdata 100792maxresident)k 0inputs+392outputs (7major+49463minor)pagefaults 0swaps