def POST(self):
d_a = db_action()
module = web.input('api_add_module')
module_name = make_module_name(module.api_add_module)
api = web.input('api_add_name')
method = web.input('api_http_method')
url = web.input('api_add_url')
cmt = web.input('api_add_cmt')
parameters = web.input('parameter_list')
parameter_string = parameters.parameter_list
parameter_string = """test_case_name#""" + parameter_string
max_id = d_a.get_max_id()
max_specific_module_id = d_a.get_max_specific_module_id(
module.api_add_module)
wanted_id = make_id_key(max_id)
wanted_max_specific_module_id = make_module_id(max_specific_module_id)
wanted_table_name = make_table_name(module_name,
wanted_max_specific_module_id)
sql_string = make_insert_sql(module.api_add_module, module_name,
api.api_add_name, method.api_http_method,
url.api_add_url, cmt.api_add_cmt,
wanted_id, wanted_max_specific_module_id,
wanted_table_name)
d_a.sql_execution(sql_string)
create_api_table_sql_string = make_create_table_sql(
wanted_table_name, parameter_string)
d_a.sql_execution(create_api_table_sql_string)
return web.seeother('/show_apis')
def POST(self):
d_a = db_action()
i = web.input()
test_plan_id = i.test_plan_id
test_result_history_map = d_a.get_test_result_history_of_test_pan(
test_plan_id)
return get_test_result_history_html(test_result_history_map)
def POST(self):
d_a = db_action()
i = web.input(tc_id_whole=[])
active_case_str = ""
selected_test_plan_id = i.test_plan_id
active_case_string_list = i.tc_id_whole
# print active_case_string_list
# print len(active_case_string_list)
if len(active_case_string_list) == 0:
active_case_str += "0"
else:
for m in range(0, len(active_case_string_list)):
if m < len(active_case_string_list) - 1:
active_case_str += active_case_string_list[m] + "#"
else:
active_case_str += active_case_string_list[m]
# print active_case_str
# print selected_test_plan_id
d_a.update_active_case_string_to_test_plan(selected_test_plan_id,
active_case_str)
runner = run_test_case_utility(selected_test_plan_id)
t = time.time()
time_flag = str(int(t))
test_report = runner.RUN()
d_a.add_new_record_to_test_report(selected_test_plan_id, time_flag,
test_report)
return web.seeother('/show_test_plan')
def RUN(self):
d_a = db_action()
base_url = d_a.get_base_url_by_test_plan_id(self.test_plan_id)
active_case_list = d_a.get_active_case_list_by_test_plan_id(
self.test_plan_id)
# print base_url
report = ""
for test_case in active_case_list:
test_case_info = d_a.get_test_case_info_by_table_name(test_case[0])
api_url = test_case_info[0][0]
http_method = test_case_info[0][1]
# print api_url
# print http_method
parameter = d_a.get_test_case_parameter_from_table_by_id(
test_case[0], test_case[1])
parameter_name_list = parameter[0]
parameter_value_list = parameter[1]
response_string = self.http_utility(base_url, api_url, http_method,
parameter_name_list,
parameter_value_list)
report += make_test_report_string(base_url, api_url, http_method,
parameter_name_list,
parameter_value_list,
response_string)
return report
def POST(self):
i = web.input('c_id')
j = web.input('a_id')
# print i.c_id
# print j.a_id
d_a = db_action()
d_a.delete_case_by_api_and_id(j.a_id, i.c_id)
return get_test_case_filter_html_string()
def POST(self):
d_a = db_action()
module = web.input('module_list')
api = web.input('api_list')
result_set = d_a.get_apis_by_module_id(module.module_list)
if api.api_list == 'default':
# print "test flag"
return get_module_filted_html_string(module.module_list,
result_set)
else:
return get_api_filter_html_string(module.module_list, result_set,
api.api_list)
def POST(self):
i = web.input()
name = i.name_add_test_plan
base_url = i.base_url_add_test_plan
module_id = i.module_add_test_plan
owner = i.owner_add_test_plan
# print name
# print base_url
# print module_id
# print owner
d_a = db_action()
d_a.add_new_test_plan(name, base_url, module_id, owner)
return web.seeother('/show_test_plan')
def POST(self):
i = web.input()
api_id = i.a_id
case_id = i.c_id
d_a = db_action()
# print api_id
# print case_id
l = d_a.get_specific_test_case(api_id, case_id)
test_case_info = l[0]
col_name_list = l[1]
test_case = l[2]
# print test_case_info
# print col_name_list
# print test_case
return get_edit_case_page_html_string(api_id, case_id, col_name_list,
test_case, test_case_info)
def POST(self):
l = web.input()
parameter_name_list = []
parameter_value_list = []
for element in l:
parameter_name_list.append(element)
parameter_value_list.append(l[element])
d_a = db_action()
wanted_id = d_a.get_max_id_from_specific_table(selected_interface_id)
# print wanted_id
# print parameter_name_list
# print parameter_value_list
d_a.insert_test_case_into_specific_table(selected_interface_id,
parameter_name_list,
parameter_value_list,
str(wanted_id))
return get_test_case_filter_html_string()
def POST(self):
i = web.input()
a_id = i.a_id
c_id = i.c_id
parameter_name_list = []
parameter_value_list = []
for element in i:
if element != 'a_id' and element != 'c_id':
parameter_name_list.append(element)
parameter_value_list.append(i[element])
# print parameter_name_list
# print parameter_value_list
# print a_id
# print c_id
d_a = db_action()
d_a.update_test_case_specific_table(a_id, c_id, parameter_name_list,
parameter_value_list)
return get_test_case_filter_html_string()
def POST(self):
i = web.input()
module_id = i.module_id
test_plan_id = i.test_plan_id
d_a = db_action()
active_test_case = d_a.get_active_case_string(test_plan_id)
test_plan_name = d_a.get_test_plan_name_by_id(test_plan_id)
if active_test_case == '0':
case_string = []
case_string_1 = []
case_string_2 = []
tb_name_list = d_a.get_table_name_list_by_module_id(module_id)
for tb_name in tb_name_list:
tc_id_list = d_a.get_test_case_list(tb_name[0])
for tc_id in tc_id_list:
case_element_string = tb_name[0] + ":" + tc_id[0]
case_string_1.append(case_element_string)
case_string_2.append(tc_id[1])
case_string.append(case_string_1)
case_string.append(case_string_2)
return get_case_list_by_default(test_plan_id, test_plan_name[0][0],
case_string)
else:
active_test_case_list = active_test_case.split("#")
case_string = []
case_string_1 = []
case_string_2 = []
tb_name_list = d_a.get_table_name_list_by_module_id(module_id)
for tb_name in tb_name_list:
tc_id_list = d_a.get_test_case_list(tb_name[0])
for tc_id in tc_id_list:
case_element_string = tb_name[0] + ":" + tc_id[0]
case_string_1.append(case_element_string)
case_string_2.append(tc_id[1])
case_string.append(case_string_1)
case_string.append(case_string_2)
# print active_test_case_list
return get_active_case_list(test_plan_id, test_plan_name[0][0],
case_string, active_test_case_list)
def GET(self):
d_a = db_action()
result_set = d_a.get_all_api_list()
return get_no_filted_html_string(result_set)
def POST(self):
i = web.input()
test_report_recod_id = i.test_report_recod_id
d_a = db_action()
test_report = d_a.get_test_report_string(test_report_recod_id)
return test_report[0][0]
def POST(self):
i = web.input('r_id')
# print i.r_id
d_a = db_action()
d_a.change_api_status(i.r_id)
return web.seeother('/show_apis')
def POST(self):
d_a = db_action()
i = web.input('module')
result_set = d_a.get_api_list_by_module_id(i.module)
return post_selected_api_list_html_string(result_set)
def GET(self):
d_a = db_action()
test_plan_list = d_a.get_test_plan_list()
return show_all_test_plan_html_string(test_plan_list)
def POST(self):
i = web.input()
test_plan_id = i.test_plan_id
d_a = db_action()
d_a.delete_test_plan(test_plan_id)
return web.seeother('/show_test_plan')
