def edit_project():
"""
测试用PUT接口
:return:
"""
# 接收入参
project_id = request.json.get('projectId')
planner_id = request.json.get('plannerId')
project_name = request.json.get('projectName')
if project_id and planner_id and project_name:
sql = 'SELECT * FROM project WHERE project_id = "%i";' % project_id
if db(sql):
update_sql = 'UPDATE project SET planner_id="%i", project_name="%s" WHERE project_id="%i"'\
% (planner_id, project_name, project_id)
status = db(update_sql)
if status:
res = {'msg': '成功', 'status': 1}
else:
res = {'msg': '系统错误', 'status': 500}
else:
res = {'msg': '项目不存在', 'status': 2001}
else:
res = {'msg': '参数错误', 'status': 4001}
return json.dumps(res, ensure_ascii=False)
def add_project():
"""
测试用POST接口
:return:
"""
# 接收入参
planner_id = request.json.get('plannerId')
print(planner_id)
print(type(planner_id))
project_name = request.json.get('projectName')
if project_name and planner_id:
sql = 'SELECT * FROM project WHERE project_name = "%s";' % project_name
if db(sql):
res = {'msg': '项目已存在', 'status': 2001}
else:
insert_sql = 'INSERT INTO project ("planner_id", "project_name") VALUES (%i, "%s")' \
% (planner_id, project_name)
status = db(insert_sql)
if status:
res = {'msg': '成功', 'status': 1}
else:
res = {'msg': '系统错误', 'status': 500}
else:
res = {'msg': '参数错误', 'status': 4001}
return json.dumps(res, ensure_ascii=False)
def delete_project():
"""
测试用DELETE接口
:return:
"""
# 接收入参
project_id = request.json.get('projectId')
if project_id:
sql = 'SELECT * FROM project WHERE project_id = "%i";' % project_id
if db(sql):
delete_sql = 'DELETE FROM project WHERE project_id="%i";' % project_id
status = db(delete_sql)
if status:
res = {'msg': '成功', 'status': 1}
else:
res = {'msg': '系统错误', 'status': 500}
else:
res = {'msg': '项目不存在', 'status': 2001}
else:
res = {'msg': '参数错误', 'status': 4001}
return json.dumps(res, ensure_ascii=False)
def get_phase_info_with_project(project_id):
"""
根据项目ID获取对应项目进度
:param project_id: 项目ID
:return: developer list
{
'phaseId': int,
'name': string,
'startTime' timestamp,
'endTime' timestamp
}
"""
sql = """
SELECT
project_phases.phase_id,
test_plan.plan_name,
project_phases.start_time,
project_phases.end_time
FROM
project
INNER JOIN project_phases ON project_phases.project_id = project.project_id
INNER JOIN test_plan ON project_phases.plan_id = test_plan.plan_id
WHERE
project.project_id = "%s";
""" % project_id
temp = []
result = db(sql)
if result:
print(result)
for i in range(len(result)):
temp.append(
{
'phaseId': result[i][0],
'name': result[i][1],
'startTime': result[i][2],
'endTime': result[i][3]
}
)
return temp
else:
return []
def get_developer_with_project(project_id):
"""
根据项目ID获取与之关联的开发人员列表
:param project_id: 项目ID
:return: developer list
{
'developerId': int,
'name': string,
'developType': string
}
"""
sql = """
SELECT
developer.developer_id,
developer.name,
develop_type.type_name
FROM
developer
INNER JOIN develop_type ON developer.type_id = develop_type.type_id
INNER JOIN develop ON develop.developer_id = developer.developer_id
WHERE
develop.project_id = "%s";
""" % project_id
temp = []
result = db(sql)
if result:
print(result)
for i in range(len(result)):
temp.append(
{
'developerId': result[i][0],
'name': result[i][1],
'developType': result[i][2]
}
)
return temp
else:
return []
def get_project_base_info(project_id):
"""
根据项目ID获取项目基础信息
:param project_id: 项目ID
:return:
{
'projectId': int,
'projectName': string,
'planner': string,
}
"""
sql = """
SELECT
project.project_id,
project.project_name,
planner.name
FROM
project
INNER JOIN planner ON project.planner_id = planner.planner_id
WHERE
project.project_id = "%s";
""" % project_id
temp = {}
# 获取项目基础信息
result = db(sql)
if result:
print(result)
temp = {
'projectId': result[0][0],
'projectName': result[0][1],
'planner': result[0][2],
}
return temp
else:
return []
def get_tester_with_project(project_id):
"""
根据项目ID获取与之关联的测试人员列表
:param project_id: 项目ID
:return: developer list
{
'testerId': int,
'name': string
}
"""
sql = """
SELECT
tester.tester_id,
tester.name
FROM
test
INNER JOIN tester ON test.tester_id = tester.tester_id
WHERE
test.project_id = "%s";
""" % project_id
temp = []
result = db(sql)
if result:
print(result)
for i in range(len(result)):
temp.append(
{
'testerId': result[i][0],
'name': result[i][1],
}
)
return temp
else:
return []