Create your SQL more easily.
JavaScript
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
test
.gitignore
.travis.yml
LICENSE
README.md
package.json
squeal.js

README.md

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 = "john@doe.org"'
var stmt = account.sel({
  where : {
    email : 'john@doe.org',
  },
})
console.log('sql=' + stmt.sql)
// -> SELECT id, username FROM account WHERE email = $1
console.log('sql=' + stmt.vals)
// -> 'john@doe.org'

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)