qbits.hayt.dsl.clause — cc.qbits/hayt 4.1.0

add-column clj

(add-column identifier type)

Clause: takes a table identifier and a column type

allow-filtering clj

(allow-filtering)

(allow-filtering value)

Clause: sets ALLOW FILTERING on select queries, defaults to true is used without a value

alter-column clj

(alter-column identifier type)

Clause: takes a table identifier and a column type

column-definitions clj

(column-definitions column-definitions)

Clause: Takes a map of columns definitions (keys are identifiers , values, types), to be used with create-table.

columns clj

(columns & columns)

Clause: takes columns identifiers ex: (columns :foo "bar" :baz)

counter clj

(counter)

(counter value)

Clause: Sets COUNTER attribute on BATCH queries

custom clj

(custom)

(custom x)

Clause: Sets CUSTOM status on create-index query

drop-column clj

(drop-column id)

Clause: Takes a column Identifier

group-by clj

(group-by & columns)

Clause: expects 1 or more columns. ex: (group-by col1 col2)

if-exists clj

(if-exists)

(if-exists b)

Clause: Apply only if the target exists

if-not-exists clj

(if-not-exists)

(if-not-exists b)

DEPRECATED use (if-exists false) Clause: Apply only if the row does not exist

index-name clj

(index-name value)

Clause: Takes an index identifier

limit clj

(limit n)

Clause: Sets LIMIT, takes a numeric value

logged clj

(logged)

(logged value)

Clause: Sets LOGGED/UNLOGGED attribute on BATCH queries

only-if clj

(only-if args)

Clause: takes a map or a vector of pairs (same as where) to compose the if clause of a update/delete query

only-if' clj

(only-if' & args)

Clause: takes a map or a vector of pairs (same as where) to compose the if clause of a update/delete query

order-by clj

(order-by & columns)

Clause: takes vectors of 2 elements, where the first is the column identifier and the second is the ordering as keyword. ex: (order-by [:asc :desc])

password clj

(password value)

Clause: To be used with alter-user and create-user, sets password

perm clj

(perm value)

Clause: Sets permission to be listed with list-perm

queries clj

(queries & queries)

Clause: takes hayt queries to be executed during a batch operation.

recursive clj

(recursive)

(recursive value)

Clause: Sets recusivity on list-perm (LIST PERMISSION) queries

rename-column clj

(rename-column old-name new-name)

Clause: rename from old-name to new-name

resource clj

(resource value)

Clause: Sets resource to be modified/used with grant or list-perm

set-columns clj

(set-columns values)

(set-columns x y & more)

Clause: Takes a map of columns to be updated

superuser clj

(superuser)

(superuser value)

Clause: To be used with alter-user and create-user, sets superuser status

user clj

(user value)

Clause: Sets user to be modified/used with grant or list-perm

using clj

(using opts)

(using x y & more)

Clause: Sets USING, takes keyword/value pairs for :timestamp and :ttl

values clj

(values values)

(values x y & more)

Clause: Takes a map of columns to be inserted

where clj

(where args)

Clause: takes a map or a vector of pairs to compose the where clause of a select/update/delete query

where' clj

(where' & args)

Same as where but for people who prefer unrolled args

where1 clj

(where1 args)

(where1 x y & more)

backward compatible with hayt 1.0 and 2.0 betas

with clj

(with values)

(with x y & more)

Clause: compiles to a CQL with clause (possibly nested maps)