RF-数据库操作

使用 DatabaseLibrary 库做准备

安装数据库驱动

• pip install pymysql

安装 DatabaseLibrary

• pip install -U robotframework-databaselibrary

*** Settings ***
Library    DatabaseLibrary

*** Test Cases ***
case01
    Connect To Database    dbapiModuleName=pymysql    dbName=test    dbUsername=root
    ...    dbPassword=root    dbHost=localhost    dbPort=3307    
    Disconnect From Database

DatabaseLibrary 库执行SQL语句

关键字

• Execute Sql Script
• Execute Sql String
• Query
• Delete All Rows From Table

*** Comments ***
这里是注释

*** Settings ***
Library    DatabaseLibrary

*** Test Cases ***
case01
    Connect To Database    dbapiModuleName=pymysql    dbName=test    dbUsername=root
    ...    dbPassword=root    dbHost=localhost    dbPort=3307  
    Execute Sql Script    demo.sql
    Disconnec