rf连接mysql数据库_RF框架-RED-mysql数据库的自动化测试

使用RF框架做mysql数据库的测试，首先要安装下面两个库：

1.pip install robotframework-databaselibrary

2.pip install PyMySQL

然后开始编写case脚本

*** Settings ***

Library DatabaseLibrary

*** Test Cases ***

mysql

Connect To Database Using Custom Params pymysql database='jmeter', user='root', password='123456', host='127.0.0.1', port=3306,charset='utf8'

${b} Query select tps from jmeter01 where time<218

${c} Row Count select tps from jmeter01 where time<218

${d} Evaluate random.randint(0, ${c}-1) random

log ${b[${d}][0]}

运行下，看结果：