def batch_operate(self, *args, user):
try:
for item in args:
# for i in range(2,item['Sheet'])
for n in item:
for i in range(2, item[n].__len__()):
result = test_case.query.filter_by(
id=item[n][i][1]).first()
apis = ApiMangerOperate().get_list({"type": "id"})
api_id = ListOperate().get_item(apis, item[n][i][4], 0)
if result:
result.case_name = item[n][i][2]
result.parameter = JsonOperate().parameter_to_json(
item[n][i][5])
result.result = item[n][i][6]
result.validation_type = item[n][i][7]
result.mark = item[n][i][8]
result.api_id = api_id
result.updater = user
result.update_time = datetime.datetime.now()
db.session.flush()
else:
db.session.add(
test_case(
case_name=item[n][i][2],
parameter=JsonOperate().parameter_to_json(
item[n][i][5]),
result=item[n][i][6],
validation_type=item[n][i][7],
mark=item[n][i][8],
api_id=api_id,
creater=user))
db.session.commit()
db.session.close()
return {"message": True}
except Exception as e:
db.session.close()
return {"message": str(e)}
def add_case(self, *args):
global admin
try:
for item in args:
if item.case_name is not None:
api_id = ApiMangerOperate().get_id(item.servi_name)
admin = test_case(
case_name=item.case_name,
parameter=JsonOperate().parameter_to_json(
item.parameter),
result=item.result,
validation_type=item.validation_type,
mark=item.mark,
api_id=api_id,
creater=item.user)
db.session.add(admin)
db.session.commit()
db.session.close()
return {"message": True}
except Exception as e:
db.session.close()
return {"message": str(e)}
item[n][i][5])
result.result = item[n][i][6]
result.validation_type = item[n][i][7]
result.mark = item[n][i][8]
result.api_id = api_id
result.updater = user
result.update_time = datetime.datetime.now()
db.session.flush()
else:
db.session.add(
test_case(
case_name=item[n][i][2],
parameter=JsonOperate().parameter_to_json(
item[n][i][5]),
result=item[n][i][6],
validation_type=item[n][i][7],
mark=item[n][i][8],
api_id=api_id,
creater=user))
db.session.commit()
db.session.close()
return {"message": True}
except Exception as e:
db.session.close()
return {"message": str(e)}
if __name__ == '__main__':
test_case().get_all()