Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Introduce TAP notebooks for SQL-centric quality assurance #44

Open
4 of 6 tasks
shah opened this issue Oct 1, 2024 · 0 comments
Open
4 of 6 tasks

Introduce TAP notebooks for SQL-centric quality assurance #44

shah opened this issue Oct 1, 2024 · 0 comments

Comments

@shah
Copy link
Contributor

shah commented Oct 1, 2024

surveilr needs sophisticated and deterministically reproducible quality assurance for DDL, DML, and DQL plus data stored in RSSDs. Implement the following:

  • a TestSuiteNotebook TypeScript base class allowing SQL-based test cases to be defined easily in subclasses
  • a Test Anything Protocol (TAP) SQL generator that can take TestSuiteNotebook subclasses and generate SQL which, when executed, emits a TAP report
  • ability to store the TAP SQL tests assurance code_notebook table.
  • ability to store the TAP SQL results / reports in uniform_resource to be queried as evidence
  • Create TAP SQL test cases and reporting view tap.sql example in SQL (without generator)
  • Create TAP SQL test cases and reporting view tap.sql.ts example in TypeScript which generates SQL
shah added a commit that referenced this issue Oct 1, 2024
shah added a commit that referenced this issue Oct 1, 2024
shah added a commit that referenced this issue Oct 1, 2024
shah added a commit that referenced this issue Oct 2, 2024
shah added a commit that referenced this issue Oct 2, 2024
shah added a commit that referenced this issue Oct 3, 2024
jobyjames1 added a commit to jobyjames1/www.surveilr.com that referenced this issue Oct 8, 2024
pradeepcdlm added a commit that referenced this issue Oct 8, 2024
feat: add tap test in infra and info assurance patterns #44
dittybijil added a commit to dittybijil/www.surveilr.com that referenced this issue Oct 8, 2024
dittybijil added a commit to dittybijil/www.surveilr.com that referenced this issue Oct 9, 2024
pradeepcdlm added a commit that referenced this issue Oct 9, 2024
feat: add tap test in pattern #44
dittybijil added a commit to dittybijil/www.surveilr.com that referenced this issue Oct 11, 2024
pradeepcdlm added a commit that referenced this issue Oct 11, 2024
chore: update unit test using tap in direct messaging service #44
dittybijil added a commit to dittybijil/www.surveilr.com that referenced this issue Oct 17, 2024
…iew to pass in a list of table names and/or views to avoid code duplication surveilr#44
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant