简介

基于之前的 react+unittest+flask 的接口自动化平台开发经验，和趟过的坑，我重新开发了这个接口自动化平台。
平台前端采用的 antd+dva+umi 的 antd-pro 模板，结合平台业务设计开发。后端采用的 flask+sqlalchemy+Blueprint，结构化更加清晰，ORM 的数据库操作更加稳定。自动化脚本的执行部分，我采用的是扩展性和针对性更强的 jmeter。
demo

框架

功能点

• 批量导入 har 包生成接口用例
• 接口用例分组树形展示
• 用例编辑失焦自动保存
• 用例编写提供快捷调试模块
• 支持多类型参数，json + 文本两种校验
• 支持同一个项目中接口参数传递
• 提供即时任务 + 每日定时任务两种任务集
• 全局 cookie 管理，全局默认参数，全局请求头设置
• 可编排的用例执行顺序
• 测试报告、简要性能结果图表化展示
• 定时任务执行结果图表化展示，持续监控
• 首页展示系统全局概要信息
• docker 一键部署，启动自动同步更新

组件

首页

项目管理

定时任务列表

新建任务

新建用例 && 调试

即时任务报告

定时任务报告

安装

前提：

• 一个已经在跑的 MySQL 数据库
• 有个 IAT 库已经导入项目 sql （ db 文件在 IAT/server/db_sql/IAT.sql 先新建一个数据库名字为 IAT，在导入上面 sql 即可。）

有特殊网络要求的，可以 download 代码编译部署。如果服务器能连上外网，可以直接通过我已经封装的 docker 镜像安装。

方法 1：Docker 镜像安装

• 我的镜像中开启了 ssh 服务，你可以通过挂载宿主机的一个端口来登录容器，默认账号为：root，密码为：root
• 前端我挂载的是 8089，看个人需要设置
• 命令行末尾参数，需要指定已经配置好的 MySQL

docker 命令安装

已知 Centos 安装的容器会有异常，建议使用其他系统。
优化了原来的容器时区问题，已经启动了的同学也不必担心，把原来的容器停止后，再创建个新的即可，数据是取得数据库，不会变。

# docker run --env PATH=/root/apache-jmeter-5.0/bin:$PATH -t -i -d -p 8089:80 -p 9022:22 --name=iat6 ownerworld/iat:0.0.6 /bin/start.sh "root:root@127.0.0.1:3306"

方法 2：编译安装

这种需要你有一定的运维基础和开发经验。默认你已有 node 和 python 环境。

下载代码

$ git clone https://github.com/t880216t/IAT.git

安装前端依赖

$ cnpm i

打包前端

$ npm run build

生成的 dist 文件夹便是前端部署文件

后端

服务端代码在 server 文件夹中，用的 python flask 框架不需要打包，建议用 gunicorn 启动。(确保你已经在 server 文件夹中)

$ pip install -r requirements.txt
$ gunicorn -w4 -b 0.0.0.0:5000 run:app

"""
Django settings for HttpRunnerManager project.

Generated by ''django-admin startproject'' using Django 1.11.7.

For more information on this file, see
https://docs.djangoproject.com/en/1.11/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/1.11/ref/settings/
"""
from __future__ import absolute_import, unicode_literals

import os

# Build paths inside the project like this: os.path.join(BASE_DIR, ...)
import djcelery
from django.conf.global_settings import SESSION_COOKIE_AGE

BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/1.11/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = ''=w+1if4no=o&6!la#5j)3wsu%k@$)6bf+@3=i0h!5)h9h)$*s7''

# SECURITY WARNING: don''t run with debug turned on in production!

DEBUG = False
# DEBUG = True

ALLOWED_HOSTS = [''*'']

# Application definition

INSTALLED_APPS = [
    ''django.contrib.admin'',
    ''django.contrib.auth'',
    ''django.contrib.contenttypes'',
    ''django.contrib.sessions'',
    ''django.contrib.messages'',
    ''django.contrib.staticfiles'',
    ''ApiManager'',
    ''djcelery'',
]

MIDDLEWARE = [
    ''django.middleware.security.SecurityMiddleware'',
    ''django.contrib.sessions.middleware.SessionMiddleware'',
    ''django.middleware.common.CommonMiddleware'',
    # ''django.middleware.csrf.CsrfViewMiddleware'',
    ''django.contrib.auth.middleware.AuthenticationMiddleware'',
    ''django.contrib.messages.middleware.MessageMiddleware'',
    ''django.middleware.clickjacking.XFrameOptionsMiddleware'',
]

MIDDLEWARE_CLASSES = [
    ''dwebsocket.middleware.WebSocketMiddleware''
]

ROOT_URLCONF = ''HttpRunnerManager.urls''

TEMPLATES = [
    {
        ''BACKEND'': ''django.template.backends.django.DjangoTemplates'',
        ''DIRS'': [os.path.join(BASE_DIR, ''templates'')],
        ''APP_DIRS'': True,
        ''OPTIONS'': {
            ''context_processors'': [
                ''django.template.context_processors.debug'',
                ''django.template.context_processors.request'',
                ''django.contrib.auth.context_processors.auth'',
                ''django.contrib.messages.context_processors.messages'',
            ],
        },
    },
]

WSGI_APPLICATION = ''HttpRunnerManager.wsgi.application''


# Password validation
# https://docs.djangoproject.com/en/1.11/ref/settings/#auth-password-validators

AUTH_PASSWORD_VALIDATORS = [
    {
        ''NAME'': ''django.contrib.auth.password_validation.UserAttributeSimilarityValidator'',
    },
    {
        ''NAME'': ''django.contrib.auth.password_validation.MinimumLengthValidator'',
    },
    {
        ''NAME'': ''django.contrib.auth.password_validation.CommonPasswordValidator'',
    },
    {
        ''NAME'': ''django.contrib.auth.password_validation.NumericPasswordValidator'',
    },
]

# Internationalization
# https://docs.djangoproject.com/en/1.11/topics/i18n/

LANGUAGE_CODE = ''zh-Hans''

TIME_ZONE = ''Asia/Shanghai''

USE_I18N = True

USE_L10N = True

USE_TZ = False

# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/1.11/howto/static-files/

if DEBUG:
    DATABASES = {
        ''default'': {
            ''ENGINE'': ''django.db.backends.mysql'',
            ''NAME'': ''HttpRunner'',  # 新建数据库名
            ''USER'': ''root'',  # 数据库登录名
            ''PASSWORD'': ''123456'',  # 数据库登录密码
            ''HOST'': ''192.168.1.254'',  # 数据库所在服务器ip地址
            ''PORT'': ''3306'',  # 监听端口 默认3306即可
        }
    }
    STATICFILES_DIRS = (
        os.path.join(BASE_DIR, ''static''),  # 静态文件额外目录
    )
else:
    DATABASES = {
        ''default'': {
            ''ENGINE'': ''django.db.backends.mysql'',
            ''NAME'': ''HttpRunner'',  # 新建数据库名
            ''USER'': ''root'',  # 数据库登录名
            ''PASSWORD'': ''123456'',  # 数据库登录密码
            ''HOST'': ''192.168.1.254'',  # 数据库所在服务器ip地址
            ''PORT'': ''3306'',  # 监听端口 默认3306即可
        }
    }
    STATIC_ROOT = os.path.join(BASE_DIR, ''static'')

STATIC_URL = ''/static/''

STATICFILES_FINDERS = (
    ''django.contrib.staticfiles.finders.FileSystemFinder'',
    ''django.contrib.staticfiles.finders.AppDirectoriesFinder''
)

SESSION_COOKIE_AGE = 300 * 60

djcelery.setup_loader()
CELERY_ENABLE_UTC = True
CELERY_TIMEZONE = ''Asia/Shanghai''
BROKER_URL = ''amqp://guest:guest3@192.168.91.45:5672//'' if DEBUG else ''amqp://guest:guest@192.168.1.254:5672//''
CELERYBEAT_SCHEDULER = ''djcelery.schedulers.DatabaseScheduler''
CELERY_RESULT_BACKEND = ''djcelery.backends.database:DatabaseBackend''
CELERY_ACCEPT_CONTENT = [''application/json'']
CELERY_TASK_SERIALIZER = ''json''
CELERY_RESULT_SERIALIZER = ''json''

CELERY_TASK_RESULT_EXPIRES = 7200  # celery任务执行结果的超时时间，
CELERYD_CONCURRENCY = 1 if DEBUG else 10 # celery worker的并发数 也是命令行-c指定的数目 根据服务器配置实际更改 一般25即可
CELERYD_MAX_TASKS_PER_CHILD = 100  # 每个worker执行了多少任务就会死掉，我建议数量可以大一些，比如200


# 发送邮件
EMAIL_HOST = ''smtp.exmail.qq.com''
EMAIL_PORT = 465
EMAIL_USR_SSL = True
EMAIL_SUBJECT_PREFIX = ''测试部''
EMAIL_HOST_USER = ''notic@test.com''  # 自己的邮箱
EMAIL_HOST_PASSWORD = "fadfadfdn8hf7AXc"  # 我的邮箱密码

EMAIL_SEND_USERNAME = ''notic@test.com''  # 定时任务报告发送邮箱，支持163,qq,sina,企业qq邮箱等，注意需要开通smtp服务
EMAIL_SEND_PASSWORD = ''Frfadfadfhf7AXc''     # 邮箱密码

LOGGING = {
    ''version'': 1,
    ''disable_existing_loggers'': True,
    ''formatters'': {
        ''standard'': {
            ''format'': ''%(asctime)s [%(name)s:%(lineno)d] [%(module)s:%(funcName)s] [%(levelname)s]- %(message)s''}
        # 日志格式
    },
    ''filters'': {
    },
    ''handlers'': {
        ''mail_admins'': {
            ''level'': ''ERROR'',
            ''class'': ''django.utils.log.AdminEmailHandler'',
            ''include_html'': True,
        },
        ''default'': {
            ''level'': ''DEBUG'',
            ''class'': ''logging.handlers.RotatingFileHandler'',
            ''filename'': os.path.join(BASE_DIR, ''logs/all.log''),
            ''maxBytes'': 1024 * 1024 * 100,
            ''backupCount'': 5,
            ''formatter'': ''standard'',
        },
        ''console'': {
            ''level'': ''DEBUG'',
            ''class'': ''logging.StreamHandler'',
            ''formatter'': ''standard''
        },
        ''request_handler'': {
            ''level'': ''DEBUG'',
            ''class'': ''logging.handlers.RotatingFileHandler'',
            ''filename'': os.path.join(BASE_DIR, ''logs/script.log''),
            ''maxBytes'': 1024 * 1024 * 100,
            ''backupCount'': 5,
            ''formatter'': ''standard'',
        },
        ''scprits_handler'': {
            ''level'': ''DEBUG'',
            ''class'': ''logging.handlers.RotatingFileHandler'',
            ''filename'': os.path.join(BASE_DIR, ''logs/script.log''),
            ''maxBytes'': 1024 * 1024 * 100,
            ''backupCount'': 5,
            ''formatter'': ''standard'',
        },
    },
    ''loggers'': {
        ''django'': {
            ''handlers'': [''default'', ''console''],
            ''level'': ''INFO'',
            ''propagate'': True
        },
        ''HttpRunnerManager.app'': {
            ''handlers'': [''default'', ''console''],
            ''level'': ''DEBUG'',
            ''propagate'': True
        },
        ''django.request'': {
            ''handlers'': [''request_handler''],
            ''level'': ''DEBUG'',
            ''propagate'': True
        },
        ''HttpRunnerManager'': {
            ''handlers'': [''scprits_handler'', ''console''],
            ''level'': ''DEBUG'',
            ''propagate'': True
        },
        ''scripts'': {
            ''handlers'': [''scprits_handler'', ''console''],
            ''level'': ''DEBUG'',
            ''propagate'': True
        },
    }
}

#生成数据迁移脚本
python manage.py makemigrations ApiManager
#应用到db生成数据表
python manage.py migrate

python manage.py createsuperuser

[root@gitlab configs]# cat ini_hrm.ini 
[uwsgi]
socket = 127.0.0.1:9092
#socket = 127.0.0.1:3031
stats = 127.0.0.1:9193
chdir = /root/TestProject/HttpRunnerManager
wsgi-file = /root/TestProject/HttpRunnerManager/HttpRunnerManager/wsgi.py
# module = Joyo.settings
virtualenv = /root/.envs/hrm
pidfile = /root/TestProject/running/uwsgi_hrm.pid
touch-reload = /root/TestProject/running/uwsgi_hrm.pid
# py-auto-reload = 1
buffer-size = 32768
processes = 1
workers=2
# threads = 2
daemonize = /root/TestProject/logs/uwsgi_hrm.log

import pymysql
pymysql.install_as_MySQLdb()