使用RF框架做mysql數(shù)據(jù)庫的測試，首先要安裝下面兩個庫：
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'
$ Query select tps from jmeter01 where time<218
${c} Row Count select tps from jmeter01 where time<218
$u0z1t8os Evaluate random.randint(0, ${c}-1) random
log ${b[$u0z1t8os][0]}
運行下，看結(jié)果：
