def post(self):
testcase_id, case_group_id, testcase_add_run, testcase_update_run \
= request_get_values('testcase_id', 'case_group_id', 'testcase_add_run', 'testcase_update_run')
testcase = TestCases.query.get(testcase_id)
print('TestCaseRunForm: ', request.form)
if testcase_update_run:
testcase.name, testcase.url, testcase.data, testcase.method \
= request_get_values('name', 'url', 'data', 'method')
if testcase_add_run:
testcase = NullObject()
testcase.name, testcase.url, testcase.data, testcase.method, request_headers_id, \
testcase.regist_variable, testcase.regular \
= request_get_values('name', 'url', 'data', 'method', 'request_headers', 'regist_variable', 'regular')
testcase.testcase_request_header = RequestHeaders.query.get(
request_headers_id)
testcase_results = []
testcase_result, regist_variable_value = to_execute_testcase(testcase)
# print('regist_variable_value', regist_variable_value)
testcase_results.extend([
'【%s】' % testcase.name, testcase_result, '【正则匹配的值】',
regist_variable_value
])
testcase_results_html = '<br>'.join(testcase_results)
# print('TestCaseRun testcase_results_html', testcase_results_html.encode('utf-8').decode('gbk'))
FrontLogs('执行测试用例 name: %s ' % testcase.name).add_to_front_log()
return json.dumps({'testcase_result': testcase_results_html})
def post(self):
page= request_get_values('page')
testcase_scene_id = request.args.get('testcase_scene_id')
testcase_scene = TestCaseScene.query.get(testcase_scene_id)
testcase_scene.name, testcase_scene.group_id, testcase_scene.description = request_get_values('name', 'case_group', 'description')
db.session.commit()
FrontLogs('编辑测试场景 name： %s 成功' % testcase_scene.name).add_to_front_log()
return redirect(url_for('testcase_scene_blueprint.testcase_scene_testcase_list', page=page))
def get(self):
user_id = session.get('user_id')
variable_id, name, testcase_id, regist_variable = request_get_values(
'variable_id', 'name', 'testcase_id', 'regist_variable')
print('VariableUpdateValidata: %s, %s, %s, %s' %
(variable_id, name, testcase_id, regist_variable))
if variable_id:
variables = Variables.query.filter(
Variables.id != variable_id, Variables.name == name,
Variables.user_id == user_id).count()
if variables != 0:
return jsonify(False)
else:
return jsonify(True)
else:
testcase = TestCases.query.get(testcase_id)
var = Variables.query.filter(
Variables.name == testcase.regist_variable).first()
print('VariableUpdateValidata var: ', var)
if var:
variable = Variables.query.filter(
Variables.id != var.id, Variables.name == regist_variable,
Variables.user_id == user_id).count()
else:
variable = Variables.query.filter(
Variables.name == regist_variable,
Variables.user_id == user_id).count()
if variable != 0:
return jsonify(False)
else:
return jsonify(True)
def get(self):
user_id = session.get('user_id')
old_sql_regist_variable, testcase_id = request_get_values(
'old_sql_regist_variable', 'testcase_id')
print('OldSqlVariableUpdateValidata:', old_sql_regist_variable,
testcase_id)
testcase = TestCases.query.get(testcase_id)
if not old_sql_regist_variable:
return jsonify(True)
var = Variables.query.filter(
Variables.name == testcase.old_sql_regist_variable).first()
# print('OldSqlVariableUpdateValidata var:', var, var.id)
if var:
variable = Variables.query.filter(
Variables.id != var.id,
Variables.name == old_sql_regist_variable,
Variables.user_id == user_id).count()
else:
variable = Variables.query.filter(
Variables.name == old_sql_regist_variable,
Variables.user_id == user_id).count()
if variable != 0:
return jsonify(False)
else:
return jsonify(True)
def post(self):
page, job_id, name, description, triggers, cron, is_start, mail_id= request_get_values(
'page', 'job_id', 'name', 'description', 'triggers', 'cron', 'is_start', 'email')
testcases = request.form.getlist('testcase')
testcase_scenes = request.form.getlist('testcase_scene')
print('JobUpdate post:', testcases, testcase_scenes, is_start)
if len(testcases) > 0:
testcases = ','.join(testcases)+','
else:
testcases = ''
if len(testcase_scenes) > 0:
testcase_scenes = ','.join(testcase_scenes)+','
else:
testcase_scenes = ''
job = Job.query.get(job_id)
old_cron = job.cron
job.name = name
job.testcases = testcases
job.testcase_scenes = testcase_scenes
job.description = description
job.triggers = triggers
job.cron = cron
job.is_start = is_start
job.mail_id = mail_id
db.session.commit()
print('old_cron cron:', old_cron, cron)
if old_cron == cron:
scheduler_job(job)
else:
scheduler_job(job, cron_change=1)
FrontLogs('编辑任务 name 成功: %s ' % name).add_to_front_log()
return redirect(url_for('job_blueprint.job_list', page=page))
def post(self, id=-1):
name, description = request_get_values('name', 'description')
case_group_update_sql = 'update case_group set name=?,description=? where id=?'
cdb().opeat_db(case_group_update_sql, (name, description, id))
FrontLogs('编辑测试用例分组 name:%s 成功' % name).add_to_front_log()
# app.logger.info('message:update case_group success, name: %s' % name)
return redirect(url_for('case_group_blueprint.case_group_list'))
def get(self):
job_id, is_start = request_get_values('job_id', 'is_start')
job = Job.query.get(job_id)
job.is_start = is_start
db.session.commit()
scheduler_job(job)
return 'OK'
def get(self, id=-1):
user_id = session.get('user_id')
user = User.query.get(user_id)
page = request_get_values('page')
mysqls = Mysql.query.filter(Mysql.user_id == user_id).all()
for mysql in mysqls:
mysql.name = AnalysisParams().analysis_params(mysql.name)
testcase_scene_id = request.args.get('testcase_scene_id', None)
scene_page = request.args.get('scene_page')
print('UpdateTestCase get:testcase_scene_id ', testcase_scene_id)
testcase = TestCases.query.filter(TestCases.id == id).first()
print('testcase.group_id:', testcase.group_id)
# 获取测试用例分组的列表
case_groups = user.user_case_groups
case_group_id_before = testcase.group_id
request_headers_id_before = testcase.request_headers_id
request_headerses = user.user_request_headers
print('testcase:', testcase)
print('case_groups :', case_groups)
print('request_headerses:', request_headerses)
FrontLogs('进入编辑测试用例 id: %s 页面' % id).add_to_front_log()
return render_template(
'test_case/test_case_search.html',
item=testcase,
case_groups=case_groups,
request_headers_id_before=request_headers_id_before,
case_group_id_before=case_group_id_before,
request_headerses=request_headerses,
testcase_scene_id=testcase_scene_id,
scene_page=scene_page,
page=page,
mysqls=mysqls)
def get(self):
username = request_get_values('username')
user_count = User.query.filter(User.username == username).count()
if user_count != 0:
return jsonify(False)
else:
return jsonify(True)
def get(self):
mysql_id = request_get_values('mysql_id')
mysql = Mysql.query.get(mysql_id)
db.session.delete(mysql)
db.session.commit()
FrontLogs('删除mysql配置 name: %s 成功' % mysql.name).add_to_front_log()
return redirect(url_for('mysql_blueprint.mysql_list'))
def get(self):
user_id = session.get('user_id')
user = User.query.get(user_id)
page= request_get_values('page')
case_groups = user.user_case_groups
FrontLogs('进入测试场景添加页面').add_to_front_log()
return render_template('testcase_scene/testcase_scene_add.html', case_groups=case_groups, page=page)
def get(self):
page, testcase_id = request_get_values('page', 'testcase_id')
testcase_self = TestCases.query.get(testcase_id)
timestr = str(datetime.datetime.now().strftime('%Y%m%d%H%M%S'))
name = testcase_self.name + timestr
db.session.add(
TestCases(
name,
testcase_self.url,
testcase_self.data,
testcase_self.regist_variable,
testcase_self.regular,
testcase_self.method,
testcase_self.group_id,
testcase_self.request_headers_id,
hope_result=testcase_self.hope_result,
user_id=testcase_self.user_id,
old_sql=testcase_self.old_sql,
new_sql=testcase_self.old_sql,
old_sql_regist_variable=testcase_self.old_sql_regist_variable,
new_sql_regist_variable=testcase_self.new_sql_regist_variable,
old_sql_hope_result=testcase_self.old_sql_hope_result,
new_sql_hope_result=testcase_self.new_sql_hope_result,
old_sql_id=testcase_self.old_sql_id,
new_sql_id=testcase_self.new_sql_id))
db.session.commit()
FrontLogs('复制测试用例 name: %s 为模板成功' %
testcase_self.name).add_to_front_log()
return redirect(url_for('testcase_blueprint.test_case_list',
page=page))
def post(self, id=-1):
name, value, description = request_get_values('name', 'value',
'description')
variable_update_sql = 'update variables set name=?,value=?,description=? where id=?'
cdb().opeat_db(variable_update_sql, (name, value, description, id))
# app.logger.info('message:update variables success, name: %s' % name)
FrontLogs('编辑全局变量 name: %s 成功' % name).add_to_front_log()
return redirect(url_for('variables_blueprint.variable_list'))
def post(self):
user_id = session.get('user_id')
page, name, group_id, description = request_get_values('page', 'name', 'case_group', 'description')
testcase_scene = TestCaseScene(name, group_id, description, user_id=user_id)
db.session.add(testcase_scene)
db.session.commit()
FrontLogs('添加测试场景 name： %s 成功' % testcase_scene.name).add_to_front_log()
return redirect(url_for('testcase_scene_blueprint.testcase_scene_testcase_list', page=page))
def get(self):
user_id = session.get('user_id')
name, mail_id = request_get_values('name', 'mail_id')
mail = Mail.query.filter(Mail.id != mail_id, Mail.name == name, Mail.user_id == user_id).count()
if mail != 0:
return jsonify(False)
else:
return jsonify(True)
def get(self):
user_id = session.get('user_id')
name, testcase_id = request_get_values('name', 'testcase_id')
testcase = TestCases.query.filter(TestCases.id != testcase_id).filter(
TestCases.name == name, TestCases.user_id == user_id).count()
if testcase != 0:
return jsonify(False)
else:
return jsonify(True)
def post(self):
username, password = request_get_values('username', 'password')
user = User(username, password)
db.session.add(user)
db.session.commit()
new_user = User.query.filter(User.username == username).first().id
add_pre_data_go(new_user)
FrontLogs('添加用户 name : %s 成功 ' % username).add_to_front_log()
return redirect(url_for('login_blueprint.login'))
def post(self):
user_id = session.get('user_id')
name, subject, to_user_list, email_method = request_get_values(
'name', 'subject', 'to_user_list', 'email_method')
mail = Mail(name, subject, user_id, to_user_list, email_method)
db.session.add(mail)
db.session.commit()
FrontLogs('添加邮件配置 name: %s 成功' % name).add_to_front_log()
return redirect(url_for('mail_blueprint.mail_list'))
def post(self):
user_id = session.get('user_id')
name, ip, port, user, password, db_name, description = request_get_values(
'name', 'ip', 'port', 'user', 'password', 'db_name', 'description')
mysql = Mysql(name, ip, port, user, password, db_name, description,
user_id)
db.session.add(mysql)
db.session.commit()
FrontLogs('添加mysql配置 name: %s 成功' % name).add_to_front_log()
return redirect(url_for('mysql_blueprint.mysql_list'))
def post(self):
user_id =session.get('user_id')
testcases, testcase_scenes, description = request_get_values('testcases', 'testcase_scenes', 'description')
print('JobAdd: ', testcases, type(testcases), eval(testcases), type(eval(testcases)), testcase_scenes)
job = Job(testcases, testcase_scenes, description, user_id)
db.session.add(job)
db.session.commit()
FrontLogs('添加任务 name 成功: %s ' % job.name).add_to_front_log()
# app.logger.info('message:insert into SchedulerJobs success, name: %s' % name)
return json.dumps({"job_id": str(job.id)})
def get(self):
scene_page, testcase_scene_id = request_get_values('scene_page', 'testcase_scene_id')
testcase_scene = TestCaseScene.query.get(testcase_scene_id)
timestr = str(datetime.datetime.now().strftime('%Y%m%d%H%M%S'))
name = testcase_scene.name + timestr
testcase_scene_copy = TestCaseScene(name, description=testcase_scene.description, user_id=testcase_scene.user_id)
db.session.add(testcase_scene_copy)
db.session.commit()
FrontLogs('复制测试场景 name： %s 成功' % testcase_scene.name).add_to_front_log()
return redirect(url_for('testcase_scene_blueprint.testcase_scene_testcase_list', page=scene_page))
def get(self):
user_id = session.get('user_id')
name, mysql_id = request_get_values('name', 'mysql_id')
print('MysqlNameUpdateValidate:', name, mysql_id)
mysql = Mysql.query.filter(Mysql.id != mysql_id, Mysql.name == name,
Mysql.user_id == user_id).count()
if mysql != 0:
return jsonify(False)
else:
return jsonify(True)
def get(self):
user_id = session.get('user_id')
name, case_group_id = request_get_values('name', 'case_group_id')
case_group = CaseGroup.query.filter(
CaseGroup.id != case_group_id, CaseGroup.name == name,
CaseGroup.user_id == user_id).count()
if case_group != 0:
return jsonify(False)
else:
return jsonify(True)
def post(self):
user_id = session.get('user_id')
name, description = request_get_values('name', 'description')
FrontLogs('开始添加测试用例分组 name: %s ' % name).add_to_front_log()
case_group = CaseGroup(name, description, user_id)
db.session.add(case_group)
db.session.commit()
FrontLogs('开始添加测试用例分组 name: %s 成功' % name).add_to_front_log()
# app.logger.info('message:insert into case_group success, name: %s' % name)
return redirect(url_for('case_group_blueprint.case_group_list'))
def get(self):
user_id = session.get('user_id')
user = User.query.get(user_id)
page= request_get_values('page')
print('TestCaseSceneUpdate page: ', page)
case_groups = user.user_case_groups
testcase_scene_id = request.args.get('testcase_scene_id')
testcase_scene = TestCaseScene.query.get(testcase_scene_id)
FrontLogs('进入编辑测试场景 name： %s 页面' % testcase_scene.name).add_to_front_log()
return render_template('testcase_scene/testcase_scene_update.html', testcase_scene=testcase_scene,
case_groups=case_groups, page=page)
def get(self):
user_id = session.get('user_id')
name, request_headers_id = request_get_values('name', 'case_group_id')
request_headers = RequestHeaders.query.filter(
RequestHeaders.id != request_headers_id,
RequestHeaders.name == name,
RequestHeaders.user_id == user_id).count()
if request_headers != 0:
return jsonify(False)
else:
return jsonify(True)
def post(self):
username, password = request_get_values('username', 'password')
print('username:'******'user'].find_one({'username': '******'}).get('password')
print('pwd:', pwd)
if username == 'moadmin' and password == pwd:
session['username'] = '******'
return redirect(url_for('zz_blueprint.zz_list'))
else:
flash('账号密码错误')
return redirect(url_for('login_blueprint.login'))
def get(self):
page, job_id = request_get_values('page', 'job_id')
job = Job.query.get(job_id)
job.is_start = 0
db.session.commit()
scheduler_job(job)
db.session.delete(job)
db.session.commit()
FrontLogs('删除测试任务 name: %s 成功' % job.name).add_to_front_log()
# app.logger.info('message:delete testcases success, id: %s' % id)
return redirect(url_for('job_blueprint.job_list', page=page))
def post(self):
user_id = session.get('user_id')
value = request.form.get('value').replace(' ', '').replace(
'\n', '').replace('\r', '')
name, description = request_get_values('name', 'description')
request_headers = RequestHeaders(name, value, description, user_id)
db.session.add(request_headers)
db.session.commit()
FrontLogs('添加请求头部 name: %s 成功' % name).add_to_front_log()
# app.logger.info('message:insert into request_headers success, name: %s' % name)
return redirect(
url_for('request_headers_blueprint.request_headers_list'))
def post(self):
mail_id, name, subject, to_user_list, email_method = request_get_values(
'mail_id', 'name', 'subject', 'to_user_list', 'email_method')
print('MailUpdate post:', to_user_list.split(','))
mail = Mail.query.get(mail_id)
mail.name = name
mail.subject = subject
mail.to_user_list = to_user_list
mail.email_method =email_method
db.session.commit()
FrontLogs('编辑邮件配置 name: %s 成功' % name).add_to_front_log()
return redirect(url_for('mail_blueprint.mail_list'))
