因为目前要测试的数据库都是MySQL,所以需要安装RF的相应library
命令行分别输入以下命令,回车即可
pip install PyMySQL
pip install robotframework-databaselibrary
DB获取商家手机号
[Arguments] ${shopname}
[Documentation] 在运行窗口中,先执行pip install PyMySQL \ \ \ \ 再执行
... pip install robotframework-databaselibrary
Connect To Database Using Custom Params pymysql database='lianshang', user='${sqluser}', password='${sqlpwd}', host='${sqlurl}', port=3306,charset='utf8'
${b} Query select cus.mobile from crm_users cus \ join \ crm_shopinfo cs on cus.id=cs.id where \ \ cs.shop_name like '%${shopname}%'
LOG 此商家的手机号=${b}嘿嘿
${b} Evaluate "${b}".split("'") modules=re
${sellermoble} Set Variable ${b[1]}
log 此商家的手机号=${sellermoble}嘿嘿
Set Global Variable ${sellermoble}