Installations
npm install node-sqlparserDeveloper Guide
Typescript
No
Module System
CommonJS
Min. Node Version
>=0.8.0
Node Version
8.9.0
NPM Version
5.5.1
Score
82.5
Supply Chain
88.6
Quality
75.4
Maintenance
100
Vulnerability
80.9
License
Releases
Unable to fetch releases
Contributors
Unable to fetch Contributors
Languages
JavaScript (99.87%)
Makefile (0.13%)
Developer
alibaba
Download Statistics
Total Downloads
846,068
Last Day
282
Last Week
2,493
Last Month
17,810
Last Year
301,033
GitHub Statistics
382 Stars
21 Commits
117 Forks
47 Watching
2 Branches
10 Contributors
Bundle Size
47.39 kB
Minified
10.28 kB
Minified + Gzipped
Maintainers
Package Meta Information
Latest Version
1.0.4
Package Id
node-sqlparser@1.0.4
Size
29.25 kB
NPM Version
5.5.1
Node Version
8.9.0
Publised On
12 Jul 2018
Total Downloads
Cumulative downloads
Total Downloads
846,068
Last day
-51.3%
282
Compared to previous day
Last week
-5.5%
2,493
Compared to previous week
Last month
-90.3%
17,810
Compared to previous month
Last year
229.2%
301,033
Compared to previous year
Daily Downloads
Weekly Downloads
Monthly Downloads
Yearly Downloads
node-sqlparser
======
node-sqlparser, write in javascript
Install
NodeJS Version 0.8.0+
npm install node-sqlparser
Introduction
for the test , type the command:
make test
Usage
static function
1var sql = 'select * from tablea where field1 = 0'; 2var parse = require('node-sqlparser').parse; 3var stringify = require('node-sqlparser').stringify; 4var astObj = parse(sql); 5 6var sqlstr = stringify(astObj);
using ast
var AST = require('node-sqlparser');
var ast = new AST();
ast.parse(sql);
ast.stringify();
Acknowledgements
- PegJS : http://pegjs.majda.cz/
- NodeJS : http://nodejs.org/
- BigQuery : https://developers.google.com/bigquery/docs/query-reference
- PL/SQL : http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/fundamentals.htm#autoId0
- MySQL : http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html
- Impala : https://github.com/cloudera/impala/blob/master/fe/src/main/cup/sql-parser.y
- PgSQL : http://www.postgresql.org/docs/9.2/interactive/sql-syntax.html
- ql.io : http://ql.io
No vulnerabilities found.
Reason
no binaries found in the repo
Reason
0 existing vulnerabilities detected
Reason
Found 5/16 approved changesets -- score normalized to 3
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
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
Reason
license file not detected
Details
- Warn: project does not have a license file
Reason
project is not fuzzed
Details
- Warn: no fuzzer integrations found
Reason
branch protection not enabled on development/release branches
Details
- Warn: branch protection not enabled for branch 'master'
Reason
SAST tool is not run on all commits -- score normalized to 0
Details
- Warn: 0 commits out of 11 are checked with a SAST tool
Score
3
/10
Last Scanned on 2024-12-23
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