New keyword "Compare Query Results"
还没有人认领这个 Issue。
评估
调研方向
该 issue 未指定任何文件、测试或入口点。先定位现有的查询相关关键字及其测试，然后明确行顺序、行数不匹配、输出格式和断言行为。完成的定义是：比较关键字、错误报告以及视觉差异输出对于相等和不相等的结果都有明确的行为。
由索引模型根据 Issue 内容生成。
描述
The keyword should compare results of two SQL queries and show the difference.
The arguments would be like query_1, query_2 and assert_results_equal (True or False).
If False, there is no assertion - just show print the difference in the RF log.
Both queries must deliver the same columns - same numbers and the same names.
It has to be implemented in the queries themselves.
The output should look like a merged table
- The columns are the same, they're merged (no duplicated cols like Col_A_Query_1 and Col_A_Query_2 - just Col_A).
- The cells with not equal values should get a red background and contain both values like
Value 1 != Value 2. - The column name and the row number with a cell with unequal values shall be highlighted as well.
- And maybe keep them visible during the scrolling (sticky scroll)?
- All other cells with equal values should be either not highlighted at all or get a green background maybe.
Apart from the visual highlighting, there should be an assertion to provide the keyword status and the error message
- The error message should not include all details, but maybe a number of rows and column names? Like this: X rows had differences in cols A, B and C?
The very first check though should be the comparison of row number in results
- If they are unequal, there should be an error message (without details) - and an additional visual output.
- Visually, it would be maybe nice to print both tables aside and highlight rows, which exist in one of the results only - in green and red, like git merge style?
- No further assertions are performed in this case.
- 主要语言
- Python
- 星标
- 179
- 派生
- 178
- PR 合并指标
- 30 天内没有已合并 PR
环境准备
这个项目没有提供开发容器、Dockerfile 或贡献指南，环境需要你自己搭建：先看它的 README，通用步骤见我们的新手贡献指南。
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
MarketSquare/Robotframework-Database-Library 的其他 Issue
-
new_client
难度 3/5 1-2 天 新手友好度 48/100
MarketSquare/Robotframework-Database-Library#260 · 1 条评论 ·
-
docs
难度 2/5 1-3 小时 新手友好度 35/100
-
难度 3/5 1-2 天 新手友好度 52/100
MarketSquare/Robotframework-Database-Library#256 · 4 条评论 ·
-
improvement
难度 5/5 一周以上 新手友好度 45/100
MarketSquare/Robotframework-Database-Library#255 · 2 条评论 ·
-
new_client
难度 4/5 3-5 天 新手友好度 45/100
MarketSquare/Robotframework-Database-Library#195 · 1 个 reaction ·
查看 MarketSquare/Robotframework-Database-Library 的全部 Issue
相似的 Issue
-
难度 1/5 1 小时以内 新手友好度 65/100
521xueweihan/HelloGitHub#4025 ·
-
难度 2/5 1-3 小时 新手友好度 85/100
aws-samples/sample-per-model-bedrock#321 ·
维护者通常 1 天内回复
-
难度 1/5 1-3 小时 新手友好度 68/100
FavioVazquez/showtime#101 ·
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 78/100
koush/ha_scrypted#81 ·
-
难度 2/5 1-3 小时 新手友好度 82/100
google/osv-scanner-action#147 ·