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
