{"id":7742933,"name":"stackql/stackql-assert","ecosystem":"actions","description":"Run StackQL query to test and audit your infrastructure.","homepage":null,"licenses":"mit","normalized_licenses":["MIT"],"repository_url":"https://github.com/stackql/stackql-assert","keywords_array":[],"namespace":"stackql","versions_count":11,"first_release_published_at":"2023-02-19T13:32:28.000Z","latest_release_published_at":"2026-03-15T07:55:23.000Z","latest_release_number":"v2.3.1","last_synced_at":"2026-04-28T12:03:42.513Z","created_at":"2023-05-17T08:43:16.946Z","updated_at":"2026-04-28T13:14:27.758Z","registry_url":"https://github.com/stackql/stackql-assert","install_command":null,"documentation_url":null,"metadata":{"name":"stackql-assert","description":"Run StackQL query to test and audit your infrastructure.","author":"Yuncheng Yang, StackQL Studios","inputs":{"test_query":{"description":"StackQL query to execute (supply either test_query or test_query_file_path)","required":false},"test_query_file_path":{"description":"StackQL query file to execute (supply either test_query or test_query_file_path)","required":false},"data_file_path":{"description":"Path to data file to pass to the StackQL query preprocessor (JSON or Jsonnet file)","required":false},"vars":{"description":"Comma delimited list of variables to pass to the StackQL query preprocessor (supported with Jsonnet config blocks or Jsonnet data files only)","required":false},"expected_rows":{"description":"Expected number of rows from executing test query","required":false},"expected_results_str":{"description":"Expected result (as a JSON string) from executing test query, overrides expected_results_file_path","required":false},"expected_results_file_path":{"description":"JSON file with the expected result","required":false},"auth_obj_path":{"description":"Path of JSON file that stores StackQL AUTH string (only required when using non-standard environment variable names)","required":false},"auth_str":{"description":"StackQL AUTH string (only required when using non-standard environment variable names)","required":false}},"runs":{"using":"composite","steps":[{"name":"Setup StackQL","uses":"stackql/setup-stackql@v2","with":{"use_wrapper":true}},{"name":"Execute StackQL Command","id":"exec-query","uses":"stackql/stackql-exec@v2","with":{"query":"${{ inputs.test_query }}","query_file_path":"${{ inputs.test_query_file_path }}","data_file_path":"${{ inputs.data_file_path }}","vars":"${{ inputs.vars }}","auth_obj_path":"${{ inputs.auth_obj_path }}","auth_str":"${{ inputs.auth_str }}","dry_run":false}},{"name":"Check Results","uses":"actions/github-script@v8","with":{"script":"const path = require('path');\nconst assertPath = path.join(process.env.GITHUB_ACTION_PATH, 'lib', 'assert.js')\nconst {assertResult} = require(assertPath)\nassertResult(core)\n"},"env":{"RESULT":"${{ steps.exec-query.outputs.stackql-query-results }}","EXPECTED_RESULTS_STR":"${{ inputs.expected_results_str }}","EXPECTED_RESULTS_FILE_PATH":"${{ inputs.expected_results_file_path }}","EXPECTED_ROWS":"${{ inputs.expected_rows }}"}}]},"branding":{"icon":"terminal","color":"blue"},"default_branch":"main","path":null},"repo_metadata":{"id":94314560,"uuid":"598581015","full_name":"stackql/stackql-assert","owner":"stackql","description":"Runs a unit test with a command, comparing the expected output with the actual output.","archived":false,"fork":false,"pushed_at":"2026-03-15T07:58:01.000Z","size":167,"stargazers_count":6,"open_issues_count":0,"forks_count":0,"subscribers_count":2,"default_branch":"main","last_synced_at":"2026-03-23T05:26:35.014Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":null,"language":"JavaScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"mit","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/stackql.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null}},"created_at":"2023-02-07T12:05:42.000Z","updated_at":"2026-03-15T07:55:28.000Z","dependencies_parsed_at":null,"dependency_job_id":"11d1cd39-5ea9-49ad-8195-246250c8a7fa","html_url":"https://github.com/stackql/stackql-assert","commit_stats":null,"previous_names":[],"tags_count":11,"template":false,"template_full_name":null,"purl":"pkg:github/stackql/stackql-assert","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stackql%2Fstackql-assert","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stackql%2Fstackql-assert/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stackql%2Fstackql-assert/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stackql%2Fstackql-assert/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/stackql","download_url":"https://codeload.github.com/stackql/stackql-assert/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stackql%2Fstackql-assert/sbom","scorecard":{"id":845444,"data":{"date":"2025-08-11","repo":{"name":"github.com/stackql/stackql-assert","commit":"e3c02b2e0fe067b3b86302929ddf13a339ec5bd9"},"scorecard":{"version":"v5.2.1-40-gf6ed084d","commit":"f6ed084d17c9236477efd66e5b258b9d4cc7b389"},"score":3.3,"checks":[{"name":"Packaging","score":-1,"reason":"packaging workflow not detected","details":["Warn: no GitHub/GitLab publishing workflow detected."],"documentation":{"short":"Determines if the project is published as a package that others can easily download, install, easily update, and uninstall.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#packaging"}},{"name":"Binary-Artifacts","score":10,"reason":"no binaries found in the repo","details":null,"documentation":{"short":"Determines if the project has generated executable (binary) artifacts in the source repository.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#binary-artifacts"}},{"name":"Dangerous-Workflow","score":10,"reason":"no dangerous workflow patterns detected","details":null,"documentation":{"short":"Determines if the project's GitHub Action workflows avoid dangerous patterns.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#dangerous-workflow"}},{"name":"Code-Review","score":0,"reason":"Found 0/4 approved changesets -- score normalized to 0","details":null,"documentation":{"short":"Determines if the project requires human code review before pull requests (aka merge requests) are merged.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#code-review"}},{"name":"Maintained","score":0,"reason":"0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0","details":null,"documentation":{"short":"Determines if the project is \"actively maintained\".","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#maintained"}},{"name":"Pinned-Dependencies","score":4,"reason":"dependency not pinned by hash detected -- score normalized to 4","details":["Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/npm-test.yml:10: update your workflow using https://app.stepsecurity.io/secureworkflow/stackql/stackql-assert/npm-test.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/npm-test.yml:12: update your workflow using https://app.stepsecurity.io/secureworkflow/stackql/stackql-assert/npm-test.yml/main?enable=pin","Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/stackql-assert-test.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/stackql/stackql-assert/stackql-assert-test.yml/main?enable=pin","Warn: third-party GitHubAction not pinned by hash: .github/workflows/stackql-assert-test.yml:24: update your workflow using https://app.stepsecurity.io/secureworkflow/stackql/stackql-assert/stackql-assert-test.yml/main?enable=pin","Info:   0 out of   3 GitHub-owned GitHubAction dependencies pinned","Info:   0 out of   1 third-party GitHubAction dependencies pinned","Info:   1 out of   1 npmCommand dependencies pinned"],"documentation":{"short":"Determines if the project has declared and pinned the dependencies of its build process.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#pinned-dependencies"}},{"name":"Token-Permissions","score":0,"reason":"detected GitHub workflow tokens with excessive permissions","details":["Warn: no topLevel permission defined: .github/workflows/npm-test.yml:1","Warn: no topLevel permission defined: .github/workflows/stackql-assert-test.yml:1","Info: no jobLevel write permissions found"],"documentation":{"short":"Determines if the project's workflows follow the principle of least privilege.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#token-permissions"}},{"name":"CII-Best-Practices","score":0,"reason":"no effort to earn an OpenSSF best practices badge detected","details":null,"documentation":{"short":"Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#cii-best-practices"}},{"name":"Fuzzing","score":0,"reason":"project is not fuzzed","details":["Warn: no fuzzer integrations found"],"documentation":{"short":"Determines if the project uses fuzzing.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#fuzzing"}},{"name":"License","score":10,"reason":"license file detected","details":["Info: project has a license file: LICENSE:0","Info: FSF or OSI recognized license: MIT License: LICENSE:0"],"documentation":{"short":"Determines if the project has defined a license.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#license"}},{"name":"Signed-Releases","score":-1,"reason":"no releases found","details":null,"documentation":{"short":"Determines if the project cryptographically signs release artifacts.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#signed-releases"}},{"name":"Branch-Protection","score":-1,"reason":"internal error: error during branchesHandler.setup: internal error: githubv4.Query: Resource not accessible by integration","details":null,"documentation":{"short":"Determines if the default and release branches are protected with GitHub's branch protection settings.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#branch-protection"}},{"name":"Security-Policy","score":0,"reason":"security policy file not detected","details":["Warn: no security policy file detected","Warn: no security file to analyze","Warn: no security file to analyze","Warn: no security file to analyze"],"documentation":{"short":"Determines if the project has published a security policy.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#security-policy"}},{"name":"SAST","score":0,"reason":"SAST tool is not run on all commits -- score normalized to 0","details":["Warn: 0 commits out of 30 are checked with a SAST tool"],"documentation":{"short":"Determines if the project uses static code analysis.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#sast"}},{"name":"Vulnerabilities","score":3,"reason":"7 existing vulnerabilities detected","details":["Warn: Project is vulnerable to: GHSA-968p-4wvh-cqc8","Warn: Project is vulnerable to: GHSA-67hx-6x53-jw92","Warn: Project is vulnerable to: GHSA-v6h2-p8h4-qcjw","Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg","Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275","Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv","Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw"],"documentation":{"short":"Determines if the project has open, known unfixed vulnerabilities.","url":"https://github.com/ossf/scorecard/blob/f6ed084d17c9236477efd66e5b258b9d4cc7b389/docs/checks.md#vulnerabilities"}}]},"last_synced_at":"2025-08-23T21:19:41.583Z","repository_id":94314560,"created_at":"2025-08-23T21:19:41.583Z","updated_at":"2025-08-23T21:19:41.583Z"},"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":32379629,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-04-28T11:25:28.583Z","status":"ssl_error","status_checked_at":"2026-04-28T11:25:05.435Z","response_time":56,"last_error":"SSL_connect returned=1 errno=0 peeraddr=140.82.121.5:443 state=error: unexpected eof while reading","robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":false,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"},"tags":[]},"repo_metadata_updated_at":"2026-04-28T13:14:27.758Z","dependent_packages_count":0,"downloads":null,"downloads_period":null,"dependent_repos_count":1,"rankings":{"downloads":null,"dependent_repos_count":24.753604816986215,"dependent_packages_count":0.0,"stargazers_count":15.598161939470764,"forks_count":35.11012517826018,"docker_downloads_count":null,"average":18.86547298367929},"purl":"pkg:githubactions/stackql/stackql-assert","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/actions/stackql/stackql-assert","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/actions/stackql/stackql-assert","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/actions/stackql/stackql-assert/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2024-11-21T05:23:31.112Z","issues_count":12,"pull_requests_count":26,"avg_time_to_close_issue":5469706.916666667,"avg_time_to_close_pull_request":646599.1923076923,"issues_closed_count":12,"pull_requests_closed_count":26,"pull_request_authors_count":2,"issue_authors_count":2,"avg_comments_per_issue":0.5833333333333334,"avg_comments_per_pull_request":0.07692307692307693,"merged_pull_requests_count":23,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":5,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":3180097.6,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":5,"past_year_pull_request_authors_count":1,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":0.0,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":5,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/stackql%2Fstackql-assert/issues","maintainers":[{"login":"yunchengyang515","count":27,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/yunchengyang515"},{"login":"jeffreyaven","count":11,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/jeffreyaven"}],"active_maintainers":[{"login":"jeffreyaven","count":5,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/jeffreyaven"}]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/stackql%2Fstackql-assert/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/stackql%2Fstackql-assert/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/stackql%2Fstackql-assert/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/stackql%2Fstackql-assert/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/github%20actions/packages/stackql%2Fstackql-assert/codemeta","maintainers":[]}