squeal
v0.4.1
Published
Create your SQL more easily.
Downloads
18
Readme
squeal - Create your SQL like a boss.
Synopsis
var squeal = require('squeal')
// Returns an object which has various methods.
// Only requires 'pk' and 'name' to be provided.
var account = squeal({
pk : 'id',
name : 'account',
ro : [ 'id', 'inserted', 'updated' ],
rw : [ 'username', 'email', 'password' ],
})
// do a regular select (with no where clause)
var stmt = account.sel()
console.log('sql=' + stmt.sql)
// -> SELECT id, inserted, updated, username, email, password FROM account;
// select just 'id' and 'username' where 'email = "[email protected]"'
var stmt = account.sel({
where : {
email : '[email protected]',
},
})
console.log('sql=' + stmt.sql)
// -> SELECT id, username FROM account WHERE email = $1
console.log('sql=' + stmt.vals)
// -> '[email protected]'
Fragments of SQL
Squeal can also help you construct bigger SQL statements such as when you are joining tables, though squeal doesn't actually do this for you (since you know your data better than it does). For example, if joining a item table with an account table.
AUTHOR
Written by Andrew Chilton:
(Ends)