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'))