数据库其他操作关键字
关键字 | 使用描述 |
Check If Exists In Database | 检查数据库查询是否有返回结果,如果有返回结果,则用例执行成功,否则执行失败,示例:
Check If Exists In Database | SELECT * FROM city WHERE NAME='beijing' OR NAME='shanghai' |
|
Check If Not Exists In Database | 检查数据库查询是否有返回结果,如果有返回结果,则用例执行失败,否则执行成功,示例:
Check If Not Exists In Database | SELECT * FROM city WHERE NAME='beijing' and NAME='shanghai' |
|
Delete All Rows From Table | 删除数据库中某张表中的全部数据,示例:
Delete All Rows From Table | World |
|
Description | 描述数据库的查询结果,示例:
@{result} | Description | SELECT * FROM city WHERE NAME='beijing' or NAME='shanghai' | Log Many | @{result} | |
|
Row Count | 统计sql查询返回的记录数,示例:
${rowCount} | Row Count | SELECT * FROM city WHERE NAME='beijing' or NAME='shanghai' | Log | ${rowCount} | |
|
Row Count Is 0 | 检查sql查询返回的记录数是否为0,示例:
Row Count Is 0 | SELECT * FROM city WHERE NAME='beijing' or NAME='shanghai' |
|
Row Count Is Equal To X | 检查sql查询返回的记录数是否等于某个值,示例:
Row Count Is Equal To X | SELECT * FROM city WHERE NAME='beijing' or NAME='shanghai' | 1 |
|
Row Count Is Greater Than X | 检查sql查询返回的记录数是否大于某个值,示例:
Row Count Is Greater Than X | SELECT * FROM city WHERE NAME='beijing' or NAME='shanghai' | 1 |
|
Row Count Is Less Than X | 检查sql查询返回的记录数是否小于某个值,示例:
Row Count Is Less Than X | SELECT * FROM city WHERE NAME='beijing' or NAME='shanghai' | 1 |
|
Table Must Exist | 判断数据库中表是否存在,示例:
|
【原文归作者所有,欢迎转载,但是保留版权,并且转载时,需要注明出处】