Skip to content

[TEST] Assert exact GitHub repository projection and both output streams #10

Open

Description

@jeffreyaven

StackQL tracking: stackql/stackql#551
Priority: LOW
Effort: LOW

Add the exact GitHub projection regression to this provider's existing pytest suite.

Query:
SELECT name, id FROM github.repos.repos
WHERE org = 'stackql' AND name = 'stackql-devel';

Current implementation:

  • provider-dev/test/tier1.yaml defines query cases.
  • provider-dev/test/test_tier1.py evaluates result assertions.
  • ExecRunner in provider-dev/test/conftest.py parses stdout but does not assert empty stderr on success.

Acceptance:

  • Return exactly one row containing name=stackql-devel and id=447890554, with no additional columns or rows.
  • In exec mode, assert complete expected stdout for the selected output format, empty stderr and exit code zero.
  • Extend the runner to expose the process output needed for these assertions.
  • Verify the same exact result through pgwire using the existing harness.
  • Reuse existing credential configuration without embedding secrets.
  • Record provider/engine versions and wire the regression into the appropriate test target.

Implement this in the provider master and publish generated provider changes through the normal registry process if required.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions