queryize.js
A no-frills chainable/fluent interface for constructing mutable MySQL queries with data binding/escapement.
Installation
NPM: npm install queryize
Usage
In Node or another CommonJS environment:
var queryize = ;var query = ;
var select = select;var query = ;
Visit queryizejs.com for documentation.
Examples
var select = select;var q = ; //q.query contains SELECT u.id, p.hash FROM users u INNER JOIN passwords p ON (u.id = p.user_id) WHERE u.email = ?//q.data contains ['user@example.com']
var queryize = ;var q = ; //q.query contains INSERT INTO users SET u.name = ?, u.email = ?//q.data contains ['John Doe', 'user@example.com']
var queryize = ;var q = ; //q.query contains UPDATE users SET u.name = ?, u.email = ? WHERE u.id = ?//q.data contains ['John Doe', 'user@example.com', 1]
var queryize = ;var q = ; //q.query contains DELETE FROM users WHERE u.id = ?//q.data contains ['John Doe', 'user@example.com', 1]
Running Unit Tests
From inside the repository root, run npm install
to install the node-tap dependency.
Run npm test
to execute the complete test suite.