Gathering detailed insights and metrics for sql-summary
Gathering detailed insights and metrics for sql-summary
Installations
npm install sql-summaryReleases
Unable to fetch releases
Developer
elastic
Developer Guide
BETA
Module System
CommonJS
Min. Node Version
Typescript Support
No
Node Version
10.6.0
NPM Version
6.2.0
Statistics
5 Stars
12 Commits
2 Forks
13 Watching
3 Branches
78 Contributors
Updated on 07 Oct 2024
Languages
JavaScript (100%)
Total Downloads
Cumulative downloads
Total Downloads
51,295,267
Last day
-1.2%
56,025
Compared to previous day
Last week
3.5%
306,825
Compared to previous week
Last month
0.5%
1,306,489
Compared to previous month
Last year
20.4%
14,949,241
Compared to previous year
Daily Downloads
Weekly Downloads
Monthly Downloads
Yearly Downloads
Dev Dependencies
1
Versions
sql-summary
Summarize any SQL query.
This JavaScript module will analyse an SQL query and return a very brief summary string containing:
- Main verb used (
SELECT,INSERT,UPDATEetc.) - Potentially the type operated on (
TABLE,DATABASEetc.) - The name of the primary table or database operated on
For example, if given the following SQL query:
1SELECT col1, col2 FROM table_name WHERE id=1The following summary string is produced:
1SELECT FROM table_name
Installation
npm install sql-summary
Usage
1var sqlSummary = require('sql-summary') 2 3var query = 'UPDATE table_name SET col1=1, col2=2 WHERE id=1' 4 5console.log('Running query:', sqlSummary(query)) // => 'Running query: UPDATE table_name' 6db.query(query, function (err, result) { 7 // ... 8})
Use-cases
- In a web-server log output the type of queries used without going into too much details about each query
- Group similar queries operating on the same tables
License
No vulnerabilities found.
Reason
no binaries found in the repo
Reason
no dangerous workflow patterns detected
Reason
0 existing vulnerabilities detected
Reason
license file detected
Details
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: MIT License: LICENSE:0
Reason
security policy file detected
Details
- Info: security policy file detected: github.com/elastic/.github/SECURITY.md:1
- Info: Found linked content: github.com/elastic/.github/SECURITY.md:1
- Info: Found disclosure, vulnerability, and/or timelines in security policy: github.com/elastic/.github/SECURITY.md:1
- Info: Found text in security policy: github.com/elastic/.github/SECURITY.md:1
Reason
branch protection is not maximal on development and all release branches
Details
- Info: 'allow deletion' disabled on branch 'master'
- Info: 'force pushes' disabled on branch 'master'
- Warn: 'branch protection settings apply to administrators' is disabled on branch 'master'
- Warn: 'stale review dismissal' is disabled on branch 'master'
- Warn: required approving review count is 1 on branch 'master'
- Warn: codeowners review is not required on branch 'master'
- Warn: 'last push approval' is disabled on branch 'master'
- Warn: no status checks found to merge onto branch 'master'
- Info: PRs are required in order to make changes on branch 'master'
Reason
Found 1/12 approved changesets -- score normalized to 0
Reason
detected GitHub workflow tokens with excessive permissions
Details
- Warn: no topLevel permission defined: .github/workflows/test.yml:1
- Info: no jobLevel write permissions found
Reason
dependency not pinned by hash detected -- score normalized to 0
Details
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/test.yml:17: update your workflow using https://app.stepsecurity.io/secureworkflow/elastic/sql-summary/test.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/test.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/elastic/sql-summary/test.yml/master?enable=pin
- Warn: npmCommand not pinned by hash: .github/workflows/test.yml:22
- Info: 0 out of 2 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 1 npmCommand dependencies pinned
Reason
0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Reason
no effort to earn an OpenSSF best practices badge detected
Reason
project is not fuzzed
Details
- Warn: no fuzzer integrations found
Reason
SAST tool is not run on all commits -- score normalized to 0
Details
- Warn: 0 commits out of 1 are checked with a SAST tool
Score
4.5
/10
Last Scanned on 2024-11-25
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.
Learn More