编写脚本前分析项目架构
需求:python脚本实现【添加发布会信息】的接口测试,以邮件形式发送测试报告
1.新建一个case目录,存放测试用例
2.新建一个config目录,存放配置信息和读取配置信息
3.新建一个db_fixture目录,初始化数据
4.新建report目录,用来存放生成的测试报告
5.run_main.py文件,执行接口测试脚本
(一般还会新建一个common目录,存放一些公共方法,例如读取excel方法等)
编写脚本
1.config部分
(1)db_config.ini 数据库配置信息(此处需注意,这里的数据库需要与实际项目的数据库一致)
# coding:utf-8
# 数据库配置信息
[mysqlconf]
host = 47.xx.xxx.xx
port = 3306
user = root
password = 123456
db = guest
(2) readDbConfig.py 读取数据库信息,封装清除数据和插入数据的方法,以便进行初始化数据的操作
#coding:utf-8
from pymysql import connect,cursors
from pymysql.err import OperationalError
import os
import configparser
# ================读取db_config.ini文件设置=================
cur_path = os.path.dirname(os.path.realpath(__file__))
configPath = os.path.join(cur_path,"db_config.ini")
cf = configparser.ConfigParser()
cf.read(configPath,encoding='UTF-8')
host = cf.get("mysqlconf","host")
port = cf.get("mysqlconf","port")
db = cf.get("mysqlconf","db")
user = cf.get("mysqlconf","user")
password = cf.get("mysqlconf","password")
# ================封装MySQL基本操作=================
class DB:
def __init__(self):
try:
# 连接数据库
self.conn = connect(
host = host,
user = user,
password = password,
db = db,
charset = "utf8mb4",
cursorclass = cursors.DictCursor
)
except OperationalError as e:
print("Mysql Error %d:%s"%(e.args[0],e.args[1]))
# 清除表数据
def clear(self,tabel_name):
real_sql = "delete from "+ tabel_name +";"
with self.conn.cursor() as cursor:
cursor.execute("SET FOREIGN_KEY_CHECKS = 0;")
cursor.execute(real_sql)
self.conn.commit()
# 插入表数据
def insert