nepalez / query_builder Goto Github PK

Convert wiki to gitbook

When using the #order modifier, it generates a CQL query like this:

SELECT * FROM test_keyspace.notifications ORDER BY (user_id DESC)

But this generates syntax error in CQL 3.3 as it does not expecting ORDER BY user_id DESC instead.

Support chunks like "ORDER BY name, age"

I don't see anything, but I wanted to ask first: is there any way to generate statements with parameters (either positional or named) with QueryBuilder?

I'm thinking something like

query = QueryBuilder::CQL.keyspace("foo").table("bar")
  .select
  .where(id: cql_parameter(:id))
# query.to_s would now be "SELECT * FROM foo.bar WHERE id: :id"
driver.execute(query, arguments: {id: 1})

This would allow us to easily cache prepared statements...

Allow writing CQL chunks like: "SET roles = {'admin'} + roles", SET roles = roles - ['admin'] etc.
This should be done via cql_add and cql_diff (maybe cql_remove) functions.