安装robotframework-databaselibrary库
- robotframework-databaselibrary
DatabaseLibrary：https://pypi.python.org/pypi/robotframework-databaselibrary
$ pip install robotframework-databaselibrary- PyMySQL
PyMySQL: https://pypi.python.org/pypi/PyMySQL
> pip install PyMySQL- MySQL-python
Win64安装MySQL-python：http://www.appblog.cn/2018/04/21/Win64安装MySQL-python/
Robot测试脚本
使用关键字对数据库进行操作
- 连接数据库：
Connect to database using custom params
该关键字需要传入2个参数，pymysql、及数据库连接信息(host=’数据库服务器IP’,port=’数据库端口’,user=’数据库登陆用户名’,passwd=’密码’，db=’数据库名’)
-
执行查询语句：
Query -
执行增删改语句：
Execute Sql String -
断开数据库连接：
Disconnect From Database
注意：SQL语句结尾尽量不要用分号，每次连接数据库后都使用断开数据库连接结束
*** Settings ***
Library DatabaseLibrary
Library Collections
*** Test Cases ***
MySQL
Connect to database using custom params pymysql host='127.0.0.1',port=3306,user='root',passwd='******',db='test',charset='UTF8'
# 查询多条
${users} query SELECT * FROM user
${count} Get Length ${users}
: FOR ${i} IN RANGE ${count}
\ log ${i}
\ ${user} Get From Dictionary ${users} ${i}
\ log ${user}
\ ${name} Get From Dictionary ${user} ${2}
# 查询单条
${user} query SELECT * FROM user WHERE username='yezhou'
log ${user[0][2]}
# 查询单条（指定字段）
${name} query SELECT name FROM user WHERE username='yezhou'
log ${name}
# 插入数据
Execute Sql String INSERT INTO user(`username`, `name`, `age`, `birthday`) VALUES('test', '测试', 20, '2000-01-01')
# 更新数据
Execute Sql String UPDATE user SET `name`='你好' WHERE `id`=3
# count查询
${count} query SELECT count(*) FROM user
log ${count}
# 删除数据
Execute Sql String DELETE FROM user WHERE `id`=3
Disconnect From Database
