Toddler is a library for building queries that can be programmatically manipulated and are simple data structures. Those queries can be turned into SQL or CQL for sending to SQL databases or Cassandra.
Load toddler in:
var toddler = require("toddler");
Create a query (there are a few ways to do this):
var q = new toddler.Query();
Now qualify it:
q.select("foo", "bar").from("zip").where(toddler.lt("pop", "?")).limit(12);
And generate some CQL:
console.log(q.cql()); => "select foo, bar from zip where pop < ? limit 12"
Queries are stored internally as mori (read: immutable) data structures, so it's trivial to serialise and deserialise queries. Bottom line: you can avoid hardcoding queries as strings, and instead build composable, serialisable datastructures to represent them instead.
You can generate an insert statement using the same syntax:
var insert = toddler.insert("foo", "bar", "baz"). into("quux"). values("?", "hey", toddler.raw("dateOf(now())")); console.log(insert.cql()); => "insert into quux (foo, bar, baz) values (?, ?, dateOf(now()))"
Note that the "hey" has disappeared from the values; instead it will appear in the "binds":
console.log(insert.binds()); => ["?", "hey"]
Delete statements are fairly simple:
var delete = toddler.query().delete().from("tree"). where(toddler.eq("fruit", toddler.bind("banana"))); console.log(delete.cql()); => "delete from tree where fruit = ?"
You can retrieve any bind values the same way as shown above.
More docs coming soon; for now just check out the tests.
This is likely to be unstable for a while as I put all the bits and pieces together into a more coherent whole.
(c) kd 2015 - present