npmpackage.info

Gathering detailed insights and metrics for node-sqlparser

Other packages similar to node-sqlparser

node-red-contrib-sqlparser

0.0.7

Parse SQL to JSON

Gathering detailed insights and metrics for node-sqlparser

node-sqlparser

Generic SQL engine for Web and Big-data.

1.0.4

382

JavaScript

10.28 kB

846,068 3

Installations

npm install node-sqlparser

Developer Guide

BETA

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

Pull Requests

Open

0

Total

9

Closed

2

Merged

7

Issues

Open

12

Total

14

Closed

2

Releases

Unable to fetch releases

Contributors

Unable to fetch Contributors

View all 10 contributors

Languages

JavaScript

Makefile

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

Bundlephobia

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

Dev Dependencies

pegjs mocha should

Versions

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.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

3

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

0

Maintained

Determines if the project is "actively maintained".

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Security-Policy

Determines if the project has published a security policy.

0

License

Determines if the project has defined a license.

0

Fuzzing

Determines if the project uses fuzzing.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

SAST

Determines if the project uses static code analysis.

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