def get_testcase_id(self, testsuit_name, project): case_id = [] sql = "SELECT testcase_id FROM autotestsuit where name='" + testsuit_name + "' and project='" + project + "'" for id in mysql_connect().execute_sql(sql): case_id.append(id[0]) # print case_id return case_id
def get_userkey_steps(self, project, userkeyname): # if stage=='testsuit': # sql="SELECT keyword_name,step_name,keyword_parameters,project FROM userkey_steps where project ='"+project+"' and status='1' and name ='"+userkeyname+"'" sql = "SELECT keyword_name,keyword_parameters,step_name,project FROM userkey_steps where project ='" + project + "' and status='1' and name ='" + userkeyname + "'" # elif stage=='testcase': # sql="SELECT keyword_name,keyword_parameters,step_name FROM userkey_steps where project =' "+project+"' and status='1'" self.userkey_steps = mysql_connect().execute_sql(sql) # print(self.userkey_steps) return self.userkey_steps
def __init__(self): self.handles = dict() self.controls = dict() self.driver = None self.options = None self.db = mysql_connect()
def get_userkey(self, project): sql = "select name,func_name,func_parameters from keywords where project='" + project + "' and type='user'" for key, funcname in mysql_connect().execute_sql(sql): print(key, funcname) self.userkey.m_set_item(key, funcname) return self.userkey
def get_basickey(self): sql = "select name,func_name,func_parameters from keywords where project='ALL' and type='basic'" for key, funcname in mysql_connect().execute_sql(sql): print(key, funcname) self.basickey.m_set_item(key, funcname) return self.basickey
def get_testcase_steps(self, testcase_id): sql = "select keyword_name,keyword_parameters,step_name,project from autotestcase_step where testcase_id=' " + testcase_id + "' and type='NORMAL' and status='1' order by step_no" self.testcase_steps = mysql_connect().execute_sql(sql) return self.testcase_steps
def get_testsuit_teardown(self, testsuit_name): sql = "select keyword_name,keyword_parameters,step_name,project from autotestsuit_step where name='" + testsuit_name + "'and type='TEARDOWN' and status='1' order by step_no" self.testsuit_teardown = mysql_connect().execute_sql(sql) return self.testsuit_teardown