python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/API/TestApiRouteJs/routeTestState/apiTestRoute.py -d /home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/ -f /home/admin/workarea/git/API//TestApiRouteJs/routeTestState/jsonFile/ -u https://marlene.fotonower.com/ -v -i /home/admin/workarea/git/API/TestApiRouteJs/routeTestState/list_test.json ' -s Test_Route_marlene -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Ceci est un script de test api (test route) Access successful. 0%| | 0/37 [00:00 excluded value = param_json excluded value = list_steps JSON TEST : OK Status OK : 200 : 429 ms : api/v1/datou/search?limit=1 #https://marlene.fotonower.com/api/v1/datou/steps {'param': ['?limit=1'], 'json': 'api_v1_datou_steps.json', 'exclude_paths': ["[93]['nb_input']", "[93]['nb_output']"]} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_datou_steps.json' mode='r' encoding='UTF-8'> excluded value = [93]['nb_input'] excluded value = [93]['nb_output'] JSON TEST : NOT OK {'values_changed': {"root[18]['nb_output']": {'new_value': 2, 'old_value': 1}, "root[106]['nb_input']": {'new_value': 5, 'old_value': 4} Loading...: 54%|█████▍ | 20/37 [01:40<01:42, 6.04s/it] Loading...: 57%|█████▋ | 21/37 [01:40<01:30, 5.67s/it] Loading...: 57%|█████▋ | 21/37 [02:01<01:30, 5.67s/it] Loading...: 59%|█████▉ | 22/37 [02:01<02:23, 9.54s/it] Loading...: 59%|█████▉ | 22/37 [02:01<02:23, 9.54s/it] Loading...: 62%|██████▏ | 23/37 [02:01<01:38, 7.04s/it] Loading...: 62%|██████▏ | 23/37 [02:02<01:38, 7.04s/it] Loading...: 65%|██████▍ | 24/37 [02:02<01:07, 5.17s/it] Loading...: 65%|██████▍ | 24/37 [02:02<01:07, 5.17s/it] Loading...: 68%|██████▊ | 25/37 [02:02<00:45, 3.78s/it] Loading...: 68%|██████▊ | 25/37 [02:02<00:45, 3.78s/it] Loading...: 70%|███████ | 26/37 [02:02<00:30, 2.77s/it] Loading...: 70%|███████ | 26/37 [02:53<00:30, 2.77s/it] Loading...: 73%|███████▎ | 27/37 [02:53<02:47, 16.74s/it] Loading...: 73%|███████▎ | 27/37 [02:53<02:47, 16.74s/it] Loading...: 76%|███████▌ | 28/37 [02:53<02:30, 16.74s/it] Loading...: 78%|███████▊ | 29/37 [02:53<01:13, 9.19s/it] Loading...: 78%|███████▊ | 29/37 [02:53<01:13, 9.19s/it] Loading...: 81%|████████ | 30/37 [02:53<00:49, 7.02s/it] Loading...: 81%|████████ | 30/37 [02:54<00:49, 7.02s/it] Loading...: 84%|████████▍ | 31/37 [02:54<00:31, 5.26s/it] Loading...: 84%|████████▍ | 31/37 [02:54<00:31, 5.26s/it] Loading...: 86%|████████▋ | 32/37 [02:54<00:19, 3.93s/it] Loading...: 86%|████████▋ | 32/37 [03:01<00:19, 3.93s/it] Loading...: 89%|████████▉ | 33/37 [03:01<00:19, 4.87s/it] Loading...: 89%|████████▉ | 33/37 [03:02<00:19, 4.87s/it] Loading...: 92%|█████████▏| 34/37 [03:02<00:10, 3.56s/it] Loading...: 92%|█████████▏| 34/37 [03:02<00:10, 3.56s/it] Loading...: 95%|█████████▍| 35/37 [03:02<00:07, 3.56s/it] Loading...: 97%|█████████▋| 36/37 [03:02<00:02, 2.04s/it]Status OK : 200 : 299 ms : api/v1/portfolio/search/remove?search_id=0&portfolio_id=545450 #https://marlene.fotonower.com/api/v1/secured/portfolio/load/545450 {'param': ['?search_id=5', '&portfolio_id=545450'], 'json': 'api_v1_secured_portfolio_load_545450.json'} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_secured_portfolio_load_545450.json' mode='r' encoding='UTF-8'> JSON TEST : OK Status OK : 200 : 62 ms : api/v1/secured/portfolio/load/545450?search_id=5&portfolio_id=545450 #https://marlene.fotonower.com/api/v1/user {'param': ['?limit=1', '&key=22', '&user=0'], 'json': 'api_v1_user.json', 'exclude_paths': ["['technical_referent']", "['user']", "['aux_data']['default_price_sell']", "['technical_referent']", "['default_license_type']", "['actions']['classification_actions']"]} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_user.json' mode='r' encoding='UTF-8'> excluded value = ['technical_referent'] excluded value = ['user'] excluded value = ['aux_data']['default_price_sell'] excluded value = ['technical_referent'] excluded value = ['default_license_type'] excluded value = ['actions']['classification_actions'] JSON TEST : OK Status OK : 200 : 318 ms : api/v1/user?limit=1&key=22&user=0 #https://marlene.fotonower.com/api/v1/photo {'param': ['?photo_id=460728'], 'json': 'api_v1_photo.json'} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_photo.json' mode='r' encoding='UTF-8'> JSON TEST : OK Status OK : 200 : 500 ms : api/v1/photo?photo_id=460728 #https://marlene.fotonower.com/api/v1/portfolio/associatedsearch {'param': ['?mtr_portfolio_id=3201720'], 'json': 'api_v1_portfolio_associatedsearch.json'} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_portfolio_associatedsearch.json' mode='r' encoding='UTF-8'> Status OK : 200 : 764 ms : api/v1/portfolio/associatedsearch?mtr_portfolio_id=3201720 #https://marlene.fotonower.com/api/v1/secured/portfolio/featured {'param': ['?limit=1'], 'json': 'api_v1_secured_portfolio_featured.json', 'excludes_paths': ["['aux']['counter_license']"]} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_secured_portfolio_featured.json' mode='r' encoding='UTF-8'> JSON TEST : OK Status OK : 200 : 213 ms : api/v1/secured/portfolio/featured?limit=1 #https://marlene.fotonower.com/api/v1/user/photo/hd {'param': ['?'], 'json': 'api_v1_user_photo_hd.json'} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_user_photo_hd.json' mode='r' encoding='UTF-8'> JSON TEST : OK Status OK : 200 : 267 ms : api/v1/user/photo/hd? #https://marlene.fotonower.com/api/v1/manual {'param': ['?keyword=test', '&limit=1'], 'json': 'api_v1_manual.json'} <_io.Text Loading...: 97%|█████████▋| 36/37 [03:03<00:02, 2.04s/it] Loading...: 100%|██████████| 37/37 [03:03<00:00, 1.79s/it] {'param': ['?'], 'json': 'api_v1_datou_result_list.json', 'exclude_paths': ["['datou_current_ids']"]} <_io.TextIOWrapper name='/home/admin/workarea/git/API/TestApiRouteJs/routeTestState/jsonFile/api_v1_datou_result_list.json' mode='r' encoding='UTF-8'> excluded value = ['datou_current_ids'] JSON TEST : OK Status OK : 200 : 998 ms : api/v1/datou/result/list? data_root_result : {'endpoint_success': [{'url': 'api/v1/secured/datou/result/list?token=390a55a434f90465efc1381ca5048589&limit=1', 'status': 200}, {'url': 'api/v1/datou/search?limit=1', 'status': 'JSON OK'}, {'url': 'api/v1/datou/current?', 'status': 'JSON OK'}, {'url': 'api/v1/datou/done?limit=1', 'status': 'JSON OK'}, {'url': 'api/v1/datou/result?limit=1', 'status': 'JSON OK'}, {'url': 'api/v1/secured/datou/result?token=390a55a434f90465efc1381ca5048589&limit=1', 'status': 'JSON OK'}, {'url': 'api/v1/thcls?limit=2&keyword=Toureiffel_15_SVMPP', 'status': 'JSON OK'}, {'url': 'api/v1/thcl?keyword=test&limit=1', 'status': 200}, {'url': 'api/v1/thcl/377?', 'status': 'JSON OK'}, {'url': 'api/v1/velours/crop/modify/search?hashtag_type=375', 'status': 'JSON OK'}, {'url': 'api/v1/photo/list?', 'status': 'JSON OK'}, {'url': 'api/v1/secured/photo?token=390a55a434f90465efc1381ca5048589&limit=1&portfolio_id=545450', 'status': 'JSON OK'}, {'url': 'api/v1/photo/onerrorload/list?type_error=test', 'status': 'JSON OK'}, {'url': 'api/v1/portfolio/load/545450?limit=1', 'status': 'JSON OK'}, {'url': 'api/v1/portfolio/search?limit=1&keyword=crop_detect_varroa_31087', 'status': 'JSON OK'}, {'url': 'api/v1/portfolio/search/associate?search_id=0&portfolio_id=545450', 'status': 'JSON OK'}, {'url': 'api/v1/portfolio/search/remove?search_id=0&portfolio_id=545450', 'status': 'JSON OK'}, {'url': 'api/v1/secured/portfolio/load/545450?search_id=5&portfolio_id=545450', 'status': 'JSON OK'}, {'url': 'api/v1/user?limit=1&key=22&user=0', 'status': 'JSON OK'}, {'url': 'api/v1/photo?photo_id=460728', 'status': 'JSON OK'}, {'url': 'api/v1/portfolio/associatedsearch?mtr_portfolio_id=3201720', 'status': 200}, {'url': 'api/v1/secured/portfolio/featured?limit=1', 'status': 'JSON OK'}, {'url': 'api/v1/user/photo/hd?', 'status': 'JSON OK'}, {'url': 'api/v1/manual?keyword=test&limit=1', 'status': 200}, {'url': 'api/v1/manual/pbname=test&limit=1', 'status': 200}, {'url': 'api/v1/velours/bucket?', 'status': 'JSON OK'}, {'url': 'api/v1/secured/velours/features?', 'status': 'JSON OK'}, {'url': 'api/v1/velours/features?', 'status': 'JSON OK'}, {'url': 'api/v1/velours/tree?', 'status': 'JSON OK'}, {'url': 'api/v1/velours/trees?', 'status': 'JSON OK'}, {'url': 'api/v1/admin/servers?limit=1', 'status': 'JSON OK'}, {'url': 'api/v1/sqlprocess/all?', 'status': 200}, {'url': 'api/v1/token/verify?', 'status': 'JSON OK'}, {'url': 'api/v1/imt/getCategories?', 'status': 'JSON OK'}, {'url': 'api/v1/datou/result/list?', 'status': 'JSON OK'}], 'endpoint_fail': [{'url': 'api/v1/datou/steps?limit=1', 'status': 'JSON NOTOK'}, {'url': 'api/v1/search/all?limit=1', 'status': 'JSON NOTOK'}], 'endpoint_warning': [], 'endpoint_timeout': [{'url': 'api/v1/portfolio/search?limit=1&keyword=crop_detect_varroa_31087', 'status': 'Time_out'}]} /home/admin/workarea/git/API/TestApiRouteJs/routeTestState/apiTestRoute.py refs/heads/master_b0c227a326d64e1e679b499ea38fb8b37af8b117 SQL :INSERT INTO MTRAdmin.monitor_sys (name, type, server, version_code, result_str, result_bool, lien , test_group ,test_name) VALUES ('Test_api','2','marlene','refs/heads/master_b0c227a326d64e1e679b499ea38fb8b37af8b117','{"api/v1/datou/steps?limit=1": "fail", "api/v1/search/all?limit=1": "fail"}','0','http://marlene.fotonower-preprod.com/job/2025/April/25042025/Test_Route_marlene/','marlene','route'); ##########result_test_route######### { "endpoint_fail": [ { "status": "JSON NOTOK", "url": "api/v1/datou/steps?limit=1" }, { "status": "JSON NOTOK", "url": "api/v1/search/all?limit=1" } ], "endpoint_success": [ { "status": 200, "url": "api/v1/secured/datou/result/list?token=390a55a434f90465efc1381ca5048589&limit=1" }, { "status": "JSON OK", "url": "api/v1/datou/search?limit=1" }, { "status": "JSON OK", "url": "api/v1/datou/current?" }, { "status": "JSON OK", "url": "api/v1/datou/done?limit=1" }, { "status": "JSON OK", "url": "api/v1/datou/result?limit=1" }, { "status": "JSON OK", "url": "api/v1/secured/datou/result?token=390a55a434f90465efc1381ca5048589&limit=1" }, { "status": "JSON OK", "url": "api/v1/thcls?limit=2&keyword=Toureiffel_15_SVMPP" }, { "status": 200, "url": "api/v1/thcl?keyword=test&limit=1" }, { "status": "JSON OK", "url": "api/v1/thcl/377?" }, { "status": "JSON OK", "url": "api/v1/velours/crop/modify/search?hashtag_type=375" }, { "status": "JSON OK", "url": "api/v1/photo/list?" }, { "status": "JSON OK", "url": "api/v1/secured/photo?token=390a55a434f90465efc1381ca5048589&limit=1&portfolio_id=545450" }, { "status": "JSON OK", "url": "api/v1/photo/onerrorload/list?type_error=test" }, { "status": "JSON OK", "url": "api/v1/portfolio/load/545450?limit=1" }, { "status": "JSON OK", "url": "api/v1/portfolio/search?limit=1&keyword=crop_detect_varroa_31087" }, { "status": "JSON OK", "url": "api/v1/portfolio/search/associate?search_id=0&portfolio_id=545450" }, { "status": "JSON OK", "url": "api/v1/portfolio/search/remove?search_id=0&portfolio_id=545450" }, { "status": "JSON OK", "url": "api/v1/secured/portfolio/load/545450?search_id=5&portfolio_id=545450" }, { "status": "JSON OK", "url": "api/v1/user?limit=1&key=22&user=0" }, { "status": "JSON OK", "url": "api/v1/photo?photo_id=460728" }, { "status": 200, "url": "api/v1/portfolio/associatedsearch?mtr_portfolio_id=3201720" }, { "status": "JSON OK", "url": "api/v1/secured/portfolio/featured?limit=1" }, { "status": "JSON OK", "url": "api/v1/user/photo/hd?" }, { "status": 200, "url": "api/v1/manual?keyword=test&limit=1" }, { "status": 200, "url": "api/v1/manual/pbname=test&limit=1" }, { "status": "JSON OK", "url": "api/v1/velours/bucket?" }, { "status": "JSON OK", "url": "api/v1/secured/velours/features?" }, { "status": "JSON OK", "url": "api/v1/velours/features?" }, { "status": "JSON OK", "url": "api/v1/velours/tree?" }, { "status": "JSON OK", "url": "api/v1/velours/trees?" }, { "status": "JSON OK", "url": "api/v1/admin/servers?limit=1" }, { "status": 200, "url": "api/v1/sqlprocess/all?" }, { "status": "JSON OK", "url": "api/v1/token/verify?" }, { "status": "JSON OK", "url": "api/v1/imt/getCategories?" }, { "status": "JSON OK", "url": "api/v1/datou/result/list?" } ], "endpoint_timeout": [ { "status": "Time_out", "url": "api/v1/portfolio/search?limit=1&keyword=crop_detect_varroa_31087" } ], "endpoint_warning": [] } #######end_result_ test_route####### Status 200 : 36 Status 400 : 0 Status 404 : 0 Status 403 : 0 Status 500 : 0 Json Test OK: 29 Json Test NOT OK : 2 Status Time_out : 1 0.59user 0.44system 3:04.92elapsed 0%CPU (0avgtext+0avgdata 50932maxresident)k 15520inputs+176outputs (82major+12187minor)pagefaults 0swaps