def get_request_data(self, row):
col = Define_variables.get_request_data()
data = self.open_excel.get_cell_value(row, int(col))
if data == '':
return None
else:
return data
def get_token_data(self, row):
col = Define_variables.get_token()
token = self.open_excel.get_cell_value(row, int(col))
if token == '':
return None
else:
return token
def get_expect_data(self, row):
col = Define_variables.get_expected_result()
expect = self.open_excel.get_cell_value(row, int(col))
if expect == '':
return None
else:
return expect
def get_is_header(self, row):
col = Define_variables.get_headers()
headers = self.open_excel.get_cell_value(row, int(col))
if headers == 'yes':
return 'headers'
else:
return None
def get_depend_field(self, row):
col = Define_variables.get_field_depend()
data = self.open_excel.get_cell_value(row, int(col))
if data == "":
return None
else:
return data
def is_depend(self, row):
col = Define_variables.get_relyid()
depend_case_id = self.open_excel.get_cell_value(row, int(col))
if depend_case_id == '':
return None
else:
return depend_case_id
def get_depend_key(self, row):
col = Define_variables.get_data_depend()
depend_key = self.open_excel.get_cell_value(row, int(col))
if depend_key == '':
return None
else:
return depend_key
def get_is_run(self, row):
flag = None
col = Define_variables.get_run()
run_model = self.open_excel.get_cell_value(row, int(col))
if run_model == 'YES':
flag = True
else:
flag = False
return flag
def write_result(self, row, value):
col = Define_variables.get_actual_result()
self.open_excel.write_value(row, int(col), value)
def get_actual_data(self, row):
col = Define_variables.get_actual_result()
actual = self.open_excel.get_cell_value(row, int(col))
return actual
def get_is_name(self, row):
col = Define_variables.get_name()
name = self.open_excel.get_cell_value(row, int(col))
return name
def get_is_id(self, row):
col = Define_variables.get_id()
id = self.open_excel.get_cell_value(row, int(col))
return id
def get_request_url(self, row):
col = Define_variables.get_url()
request_url = self.open_excel.get_cell_value(row, int(col))
return request_url
def get_request_method(self, row):
col = Define_variables.get_run_way()
request_method = self.open_excel.get_cell_value(row, int(col))
return request_method