Robot Framework连接MySQL数据库操作

安装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