def collect_db_cass(jsoncasss):
'''
读取json并执行用例。
'''
# all_tests = json.loads(jsoncasss)
for test in jsoncasss:
if not test:
Logger().error("没有发现测试用例，结束用例执行！")
try:
runner = Runner(test)
yield runner.run_test()
except Exception as e:
# raise e
Logger().error("测试用例[%s]执行失败，失败原因 --> %s" % (test["testname"], e))
def collect_db_cass(jsoncasss):
'''
读取json并执行用例。
'''
# 获取当前用例测试结果的最大版本号
version = get_reports_max_version()
for test in jsoncasss:
if not test:
Logger().error("没有发现测试用例，结束用例执行！")
try:
runner = Runner(test)
yield runner.run_test(version)
except Exception as e:
Logger().error("测试用例[%s]执行失败，失败原因 --> %s" % (test["testname"], e))
def query(sql=""):
"""
ex: 根据sql查询结果
args: sql
return: results
"""
results = []
db = pymysql.connect(**db_config)
cur = db.cursor()
try:
cur.execute(sql) # 执行sql语句
# 获得列名
descs = []
for desc in cur.description:
descs.append(desc[0])
# 构造键值对{"列名":数据}
results = []
for res in cur.fetchall():
row = {}
for i in range(len(descs)):
row[descs[i]] = res[i]
results.append(row)
except Exception as e:
Logger().error("sql语句[%s]执行失败,错误信息为 --> %s" % (sql, e))
raise e
finally:
cur.close()
db.close() # 关闭连接
return results
def jsonfile(filename):
'''
判断导入的json文件格式是否合法
'''
filetype = filename.split(".")
# print(filetype[-1])
if filetype[-1] == "json" and filename.startswith("test"):
return filename
else:
Logger().error("导入的JSON文件格式不正确，请检查JSON格式！")
return None
def collect_file_cass(filename):
'''
读取json并执行用例。
'''
with open(filename, 'r') as f:
all_tests = json.load(f)
# print(all_tests)
for test in all_tests:
if not test:
Logger().error("没有发现测试用例，结束用例执行！")
# try:
runner = Runner(test)
yield runner.run_test()
def excute(sql=""):
'''
ex: 根据sql插入或更新数据
args: sql
return: is_success，true:成功 false:失败
'''
is_success = True
db = pymysql.connect(**db_config)
cur = db.cursor()
try:
cur.execute(sql)
db.commit()
except Exception as e:
db.rollback()
Logger().error("sql语句[%s]执行失败,错误信息为 --> %s" % (sql, e))
is_success = "%s" % e
finally:
cur.close()
db.close()
return is_success
from math import sqrt
from tortoise import fields
from tortoise.models import Model
from app.utils.exceptions import SubZeroKarma
from app.utils.log import Logger
from .chat import Chat
from .db import karma_filters
from .user import User
logger = Logger(__name__)
DEFAULT_KARMA = 50
class UserKarma(Model):
"""
information about (karma) (user) in (chat)
"""
uc_id = fields.IntField(pk=True)
user: fields.ForeignKeyRelation[User] = fields.ForeignKeyField(
'models.User', related_name='karma')
chat: fields.ForeignKeyRelation[Chat] = fields.ForeignKeyField(
'models.Chat', related_name='user_karma')
karma = fields.FloatField(default=DEFAULT_KARMA)
class Meta:
table = 'user_karma'
unique_together = ('user', 'chat')
def __str__(self):
# -*- coding:utf-8 -*-
__author__ = 'snake'
import os, json
from app import bp
from flask import jsonify, request
from app.utils.log import Logger
from app.utils.common import get_current_time
from app.utils.dbfucs import excute
from app.utils.jsonfuc import validate_req_by_file
Logger = Logger()
def _upload_files(file):
"""
上传图片公共方法
:param file: 上传的file文件
:return: True:成功;False失败
"""
try:
upload_path = os.path.join("./app/uploads/",
file.filename) # 注意：没有的文件夹一定要先创建，不然会提示没有该路径
file.save(upload_path)
return True
except:
return False
@bp.route("/uploadtestcase", methods=['POST'])
def uploadtestcase():
file = request.files['file']