From b043423080d496434881254104cd4a401c60d2ae Mon Sep 17 00:00:00 2001 From: "j-h.choi" Date: Mon, 11 Jun 2018 15:12:56 +0900 Subject: [PATCH] [Tizen.NET] Change the dotnet value name Change-Id: Id1d349020be3346d229481c7ae01734cf7290125 --- job_add_dotnet_launching_performance_test.py | 40 ++++++++++++++-------------- 1 file changed, 20 insertions(+), 20 deletions(-) diff --git a/job_add_dotnet_launching_performance_test.py b/job_add_dotnet_launching_performance_test.py index c66f6a1..3a03453 100644 --- a/job_add_dotnet_launching_performance_test.py +++ b/job_add_dotnet_launching_performance_test.py @@ -103,14 +103,14 @@ def main(): snapshot_name = snapshot_sp[len(snapshot_sp) - 1] repository = TEST_DATA['repository'] device_name = TEST_DATA['device_name'] - profile = TEST_DATA['profile'] - target = TEST_DATA['target'] + profile_name = TEST_DATA['profile_name'] + target_name = TEST_DATA['target_name'] print("snapshot_name : " + snapshot_name) print("repository : " + repository) print("device_name : " + device_name) - print("profile : " + profile) - print("target : " + target) + print("profile_name : " + profile_name) + print("target_name : " + target_name) # sql = 'UNLOCK TABLES;'; # mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], sql) @@ -127,26 +127,26 @@ def main(): print "[Write] build_snapshot id =", build_snapshot_id - # insert launching_performance_profile - MYSQL['query']['insert_launching_performance_profile'] = "INSERT INTO launching_performance_profile (build_project_id, profile_name) SELECT 1, '%s' FROM DUAL WHERE NOT EXISTS ( SELECT * FROM launching_performance_profile WHERE profile_name='%s' );" % (profile, profile) - mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['insert_launching_performance_profile']) + # insert launching_performance_profile_name + MYSQL['query']['insert_launching_performance_profile_name'] = "INSERT INTO launching_performance_profile_name (build_project_id, profile_name) SELECT 1, '%s' FROM DUAL WHERE NOT EXISTS ( SELECT * FROM launching_performance_profile_name WHERE profile_name='%s' );" % (profile_name, profile_name) + mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['insert_launching_performance_profile_name']) - # get launching_performance_profile_id - MYSQL['query']['select_launching_performance_profile'] = "SELECT id FROM launching_performance_profile WHERE profile_name='%s'" % (profile) - mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['select_launching_performance_profile']) - launching_performance_profile_id = MYSQL['cursor'].fetchone()['id'] - print "[Write] launching_performance_profile id =", launching_performance_profile_id + # get launching_performance_profile_name_id + MYSQL['query']['select_launching_performance_profile_name'] = "SELECT id FROM launching_performance_profile_name WHERE profile_name='%s'" % (profile_name) + mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['select_launching_performance_profile_name']) + launching_performance_profile_name_id = MYSQL['cursor'].fetchone()['id'] + print "[Write] launching_performance_profile_name id =", launching_performance_profile_name_id - # insert launching_performance_target - MYSQL['query']['insert_launching_performance_target'] = "INSERT INTO launching_performance_target (build_project_id, target_name) SELECT 1, '%s' FROM DUAL WHERE NOT EXISTS ( SELECT * FROM launching_performance_target WHERE target_name='%s' );" % (target, target) - mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['insert_launching_performance_target']) + # insert launching_performance_target_name + MYSQL['query']['insert_launching_performance_target_name'] = "INSERT INTO launching_performance_target_name (build_project_id, target_name) SELECT 1, '%s' FROM DUAL WHERE NOT EXISTS ( SELECT * FROM launching_performance_target_name WHERE target_name='%s' );" % (target_name, target_name) + mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['insert_launching_performance_target_name']) - # get launching_performance_target_id - MYSQL['query']['select_launching_performance_target'] = "SELECT id FROM launching_performance_target WHERE target_name='%s'" % (target) - mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['select_launching_performance_target']) - launching_performance_target_id = MYSQL['cursor'].fetchone()['id'] - print "[Write] launching_performance_target id =", launching_performance_target_id + # get launching_performance_target_name_id + MYSQL['query']['select_launching_performance_target_name'] = "SELECT id FROM launching_performance_target_name WHERE target_name='%s'" % (target_name) + mysql_excute_query(MYSQL['connection'], MYSQL['cursor'], MYSQL['query']['select_launching_performance_target_name']) + launching_performance_target_name_id = MYSQL['cursor'].fetchone()['id'] + print "[Write] launching_performance_target_name id =", launching_performance_target_name_id # insert build_image -- 2.7.4