npm.io
0.1.0 • Published 11 years ago

sqlformatter

Licence
LGPL-2.1
Version
0.1.0
Deps
0
Vulns
0
Weekly
0

Performs formatting of basic SQL statements (DML + query).

Direct conversion in javascript of this hibernate java code from http://grepcode.com/file/repo1.maven.org/maven2/org.hibernate/hibernate-core/4.3.6.Final/org/hibernate/engine/jdbc/internal/BasicFormatterImpl.java#BasicFormatterImpl

Installation

$ npm install sqlformatter

###Examples

var sqlformatter = require('sqlformatter')
var sql = "select * from dual";

console.log(sqlformatter.format(sql));

Output:

 select
     *
 from
     dual

###Tests

To run the test suite, first install the dependancies, then run npm test:

$ npm install
$ npm test

Keywords