Add support for preconditions
还没有人认领这个 Issue。
评估
调研方向
No files, tests, or entry points are named in the issue. Start by resolving how precondition queries should be expressed and whether a false result is a no-op or a failure; done means the agreed behavior is implemented for SQL Runner playbooks and verified for both described use cases.
由索引模型根据 Issue 内容生成。
描述
Use case 1
Imagine that:
- You have a process landing new data in Redshift roughly every 40-60 minutes
- You want to kick off a SQL Runner playbook as soon as the new data has arrived
- The playbook has a non-trivial runlength whether or not there is new data
- You want the playbook to complete as soon as possible
Use case 2
Imagine that:
- You want to upgrade a Redshift table by adding some columns
- You only want to perform the upgrade if the table is v0.5.0 and the table is empty
Solution
We could add a new feature to SQL Runner: playbook preconditions: for the playbook steps to be executed, all of the precondition queries must return TRUE. If any of them return FALSE, then the playbook doesn't run (a "no-op", or possibly a "failure").
Open question: whether it's a bit fiddly constructing the preconditions SQL queries to return TRUE/FALSE - it might be easier to add a syntax to compare the resultset with what's expected.
- 主要语言
- Go
- 星标
- 81
- 派生
- 15
- PR 合并指标
- 30 天内没有已合并 PR
环境准备
这个项目没有提供开发容器、Dockerfile 或贡献指南，环境需要你自己搭建：先看它的 README，通用步骤见我们的新手贡献指南。
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
snowplow/sql-runner 的其他 Issue
-
难度 4/5 3-5 天 新手友好度 45/100
snowplow/sql-runner#218 · 1 条评论 ·
-
难度 5/5 一周以上 新手友好度 25/100
snowplow/sql-runner#194 ·
-
难度 4/5 3-5 天 新手友好度 35/100
snowplow/sql-runner#193 · 1 条评论 ·
-
bug
难度 4/5 3-5 天 新手友好度 25/100
snowplow/sql-runner#186 ·
-
难度 4/5 3-5 天 新手友好度 35/100
snowplow/sql-runner#185 ·
查看 snowplow/sql-runner 的全部 Issue
相似的 Issue
-
难度 1/5 1 小时以内 新手友好度 72/100
slavakurilyak/awesome-ai-agents#845 ·
维护者通常 1 天内回复
-
bug
难度 2/5 1-3 小时 新手友好度 68/100
维护者通常 3 天内回复
-
难度 2/5 1-3 小时 新手友好度 85/100
-
难度 2/5 1-3 小时 新手友好度 74/100
JakeChampion/lang#13132 ·
维护者通常 1 天内回复
-
[BUG] deploy.restart_policy without condition drops the restart policy可能已有人在做 @akshat-lakhera 今天认领。 未关闭
难度 2/5 1-3 小时 新手友好度 82/100
docker/compose#14383 · 1 条评论 ·
维护者通常 1 天内回复