使用rf做数据库的增删改查操作可以定义关键字,方便后续使用
关键字如下:
一、sql_查
1 [Arguments] ${host} ${port} ${user} ${passwd} ${db} ${sql}
2 Connect To Database Using Custom Params pymysql host='${host}', port=${port}, user='${user}', passwd='${passwd}', db='${db}',charset='utf8'
3 ${return} Query ${sql}
4 Disconnect From Database
5 [Return] ${return}
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5COxMTM5EjZ4ImNwETMkRjZyYzXyETM1cTMxEzLchDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
二、sql_增删改查
[Arguments] ${host} ${port} ${user} ${passwd} ${db} ${sql}
Connect To Database Using Custom Params pymysql host='${host}', port=${port}, user='${user}', passwd='${passwd}', db='${db}',charset='utf8' #host='${host}', port=${port}, user='${user}', passwd='${passwd}', db='${db}',charset='utf8'
${return} Execute Sql String ${sql}
Disconnect From Database
三、使用