Gesundheit - Concise SQL generation for node.js
===============================================
.. image:: https://secure.travis-ci.org/BetSmartMedia/gesundheit.png?branch=master
:target: http://travis-ci.org/BetSmartMedia/gesundheit
Gesundheit generates SQL using a sugary API for managing the abstract syntax
tree of a statement. After building your statement programmatically, gesundheit
can compile it to a string or execute it against your database for you, using
proper bound parameters and allowing for streaming of results.
Here's a quick example to illustrate::
select = require('./lib').select
assert = require('assert')
query = select('chairs', ['chair_type', 'size'])
.where({chair_type: 'recliner', weight: {lt: 25}})
assert.deepEqual(query.compile(), [
'SELECT chairs.chair_type, chairs.size FROM chairs WHERE chairs.chair_type = ? AND chairs.weight < ?',
['recliner', 25]
])
query.execute(console.log)
See `the documentation `_ for more
thorough examples showing different query types, joins, query execution and more.
Install
-------
In addition to the usual ``npm install gesundheit``, you will need to install
the driver for your database. Driver support is provided by `any-db
`_, which currently works with the ``pg``,
``mysql``, and ``sqlite3`` database drivers.
License
-------
MIT
Author
-------
Stephen Sugden