def get_test_cases(self,id=None):
if id is not None: response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_test_cases_exe_filter.format(folder_name=id))
else: response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_test_cases_exe)
r=['[']
users=Api.get_users()
for i, item in enumerate(response):
if i!= len(response)-1:
r.append('{ "id": "%s", "tc_id": "%s", "name": "%s", "executor": "%s", "type": "%s", "status": "%s", "date": "%s", "time": "%s" }, '%(item[0],item[1],item[2],users[item[3]],item[4],item[5],item[6].strftime("%Y-%m-%d"),item[7]))
else:
r.append('{ "id": "%s", "tc_id": "%s", "name": "%s", "executor": "%s", "type": "%s", "status": "%s", "date": "%s", "time": "%s" }'%(item[0],item[1],item[2],users[item[3]],item[4],item[5],item[6].strftime("%Y-%m-%d"),item[7]))
r.append(']')
return ''.join(r)
# @cherrypy.expose()
# def get_test_cases(self,id=None,_=None):
# #http://127.0.0.1:8081/cases/get_test_cases?id=/folder1/subfolder_1/
# response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_test_cases.format(id.split("/")[-2]))
# r=['{"aaData":[']
# users=Api.get_users()
# for i, item in enumerate(response):
# if i!= len(response)-1:
# r.append('{"id":"%s","name":"%s","execution_type":"%s","type":"%s","execution_expected_time":"%s","creation_date":"%s","status":"%s"},'%(item[0],item[5],item[9],item[10],item[3],item[4].strftime("%Y-%m-%d"),item[11]))
# else:
# r.append('{"id":"%s","name":"%s","execution_type":"%s","type":"%s","execution_expected_time":"%s","creation_date":"%s","status":"%s"}'%(item[0],item[5],item[9],item[10],item[3],item[4].strftime("%Y-%m-%d"),item[11]))
# r.append(']}')
# return ''.join(r)
def get_main_content(self):
data={}
user_name="Test Test"
login_time="12:00" #sqlquery_get_login_time
logged_time="58" #now() - login_time
data['user_name']=user_name
data['login_time']=login_time
data['logged_time']=logged_time
response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_project_notes)
users=Api.get_users()
project_notes = []
for i, item in enumerate(response):
temp=[]
temp.append(item[0])
temp.append(item[1])
temp.append(item[2])
temp.append(users[item[5]])
project_notes.append(temp)
data['project_notes']=project_notes
response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_user_notes)
user_notes = []
for i, item in enumerate(response):
temp=[]
temp.append(item[0])
temp.append(item[1])
temp.append(item[3])
user_notes.append(temp)
data['user_notes']=user_notes
return data
def get_defect_content(self,def_id):
users=Api.get_users()
#users=self.get_users()
attachments=[]
attachments_data=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_defect_attachments.format(def_id=def_id))
for i, attachment in enumerate(attachments_data):
attachments.append([attachment[3],attachment[2],attachment[6]])
comments=[]
comments_data=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_defect_comments.format(def_id=def_id))
for i, comment in enumerate(comments_data):
comments.append([comment[0],users[comment[2]],comment[3].strftime("%Y-%m-%d %H:%M"),comment[4]])
linked_test=[]
#linked_test_data=
####### TODO! #######
linked_test_data=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_defect_linked_tests.format(def_id=def_id))
for i, comment in enumerate(linked_test_data):
linked_test.append([comment[0],users[comment[2]],comment[3].strftime("%Y-%m-%d"),comment[1]])
response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_defect_additional_data.format(def_id=def_id))[0]
data={}
data['id']=def_id
data['name']=response[1] if response[1] is not None else ''
data['assign']=users[response[6]]
data['assign_id']=response[6]
data['status']=response[11] if response[11] is not None else ''
data['status_id']=response[5]
data['fix']=users[response[7]]
data['fix_id']=response[7]
data['type']=response[12] if response[12] is not None else ''
data['add_date']=response[3].strftime("%Y-%m-%d")
data['fix_date']='2012-01-01'
data['description']=response[9] if response[9] is not None else ''
data['solution']=response[10] if response[10] is not None else ''
data['comments']=comments
data['linked_test']=linked_test
return data
def get_test_cases(self,_=None):
response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_test_cases_for_iterations)
r=['[']
users=Api.get_users()
for i, item in enumerate(response):
if i!= len(response)-1:
r.append('{ "id": "%s", "name": "%s", "designer": "%s", "execution_expected_time": "%s" }, '%(item[0],item[1],users[item[2]],item[3]))
else:
r.append('{ "id": "%s", "name": "%s", "designer": "%s", "execution_expected_time": "%s" } '%(item[0],item[1],users[item[2]],item[3]))
r.append(']')
return ''.join(r)
def get_defects(self, id=None,_=None):
users=Api.get_users()
response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_defects)
r=['{"aaData":[']
for i, item in enumerate(response):
if i!= len(response)-1:
r.append('{"id":"%s","name":"%s","added_by":"%s","added_at":"%s","type":"%s","status":"%s","assigned_to":"%s","fixed_by":"%s","importance":"%s"},'%(item[0],item[1],users[item[2]],item[3].strftime("%Y-%m-%d"),item[12],item[11],users[item[7]],users[item[8]],item[9]))
#r.append('{"id":"%s","name":"%s","added_by":"%s","added_at":"%s","type":"%s","status":"%s","assigned_to":"%s","fixed_by":"%s","importance":"%s"},'%(item[0],item[1],users[item[2]],item[3].strftime("%Y-%m-%d"),item[12],item[5],users[item[7]],users[item[8]],item[9]))
else:
r.append('{"id":"%s","name":"%s","added_by":"%s","added_at":"%s","type":"%s","status":"%s","assigned_to":"%s","fixed_by":"%s","importance":"%s"}'%(item[0],item[1],users[item[2]],item[3].strftime("%Y-%m-%d"),item[12],item[11],users[item[7]],users[item[8]],item[9]))
#r.append('{"id":"%s","name":"%s","added_by":"%s","added_at":"%s","type":"%s","status":"%s","assigned_to":"%s","fixed_by":"%s","importance":"%s"}'%(item[0],item[1],users[item[2]],item[3].strftime("%Y-%m-%d"),item[12],item[5],users[item[7]],users[item[8]],item[9]))
r.append(']}')
return ''.join(r)
def execute(self,test_id):
data={}
test_case=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_test_case.format(test_id))[0]
steps=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_test_case_steps.format(test_id))
#for step in steps:
print(steps)
data['test_name']=test_case[5]
data['test_exe_type']=test_case[1]-1
data['test_type']=test_case[2]-1
data['test_status']=test_case[7]-1
data['test_exe_time']=test_case[3]
data['test_case_designer']=users=Api.get_users()[test_case[6]]
data['steps']=steps
return self.env.get_template('lab_execute').render(data) #self.get_defect_content(def_id)
def get_test_cases_exe_content(self,id=None):
jenkins=JenkinsApi("http://localhost:8080")
jenkins.build_job('test_job')
response=cherrypy.session.get('project_db_connection').execute_query(sqlquery_get_test_cases_exe_contect.format(tce_id=id))[0]
users=Api.get_users()
data={}
data['tce_id']=response[0]
data['status']=response[22]
data['executor']=users[response[3]]
data['date']=response[4].strftime("%Y-%m-%d")
data['time']=response[5].strftime("%H:%M")
data['period']=response[6] if response[6] is not None else ''
data['folder']=response[24]
data['type']=response[29]
data['expected_time']=response[11]
data['name']=response[13]
data['designer']=users[response[14]]
return data
def test(self, **params):
# {'status': '1', 'is_con_auto': 'false', 'author': 'Jonasz Borys', 'expected_time': '35', 'exe_type': '1', 'test_data': 'id=1', 'type': '1', 'test_cases': '[{"no":0,"id":"4","step_no":"0","description":"Opis testu do wykonania","expected":""},{"no":1,"id":"1","step_no":"1","description":"Wlacz komputer","expected":"Komputer wlaczony"},{"no":2,"id":"2","step_no":"2","description":"Wejdz na fejsa","expected":"Fejs wlaczony"},{"no":3,"id":"3","step_no":"3","description":"Wyloguj sie","expected":"Wylogowany"}]'}
users = Api.get_users(revert=True)
id = int(params["test_data"].split("=")[1])
name = params["name"].replace("\n\t\t", "")
status = params["status"]
is_con_auto = params["is_con_auto"]
author = users[params["author"]]
expected_time = params["expected_time"]
type = params["type"]
exe_type = params["exe_type"]
steps = params["test_cases"]
cherrypy.session.get("project_db_connection").execute_query(
sqlquery_update_test_case.format(
exe_type=exe_type,
type=type,
expected_time=expected_time,
name=name,
author=author,
status=status,
is_con_auto=is_con_auto,
id=id,
),
select=False,
)
for i, step in enumerate(json.loads(steps)):
# no=
# step_id=
# step_name=
# step_no=step['step_no']
# step_description=
# step_expected=step['expected']
cherrypy.session.get("project_db_connection").execute_query(
sqlquery_update_step.format(
step_id=step["id"],
no=step["no"],
step_name=step["name"],
step_description=step["description"],
step_expected=step["expected"],
),
select=False,
)
print("UPDATE")
def preview(self, test_id, mode="edit"): # ,def_id, mode='preview', **params):
# print('test_id')
data = {}
test_case = cherrypy.session.get("project_db_connection").execute_query(sqlquery_get_test_case.format(test_id))[
0
]
steps = cherrypy.session.get("project_db_connection").execute_query(
sqlquery_get_test_case_steps.format(test_id)
)
# for step in steps:
print(steps)
data["test_name"] = test_case[5]
data["test_exe_type"] = test_case[1] - 1
data["test_type"] = test_case[2] - 1
data["test_status"] = test_case[7] - 1
data["test_exe_time"] = test_case[3]
data["test_case_designer"] = users = Api.get_users()[test_case[6]]
data["steps"] = steps
print(data)
return self.env.get_template("repo_edit").render(data)
def get_test_cases_exe_content(self, id=None):
jenkins = JenkinsApi("http://localhost:8080")
jenkins.build_job("test_job")
response = cherrypy.session.get("project_db_connection").execute_query(
sqlquery_get_test_cases_exe_contect.format(tce_id=id)
)[0]
users = Api.get_users()
data = {}
data["tce_id"] = response[0]
data["status"] = response[22]
data["executor"] = users[response[3]]
data["date"] = response[4].strftime("%Y-%m-%d")
data["time"] = response[5].strftime("%H:%M")
data["period"] = response[6] if response[6] is not None else ""
data["folder"] = response[24]
data["type"] = response[29]
data["expected_time"] = response[11]
data["name"] = response[13]
data["designer"] = users[response[14]]
return data
