qbits.hayt.dsl — cc.qbits/hayt 4.0.2

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

alter-column-family clj deprecated

alter-columnfamily clj

(alter-columnfamily columnfamily & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#alterTableStmt

Takes a columnfamiliy identifier and additional clause arguments:

• alter-column
• add-column
• alter-column
• rename-column
• drop-column
• with

alter-keyspace clj

(alter-keyspace keyspace & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#alterKeyspaceStmt

Takes a keyspace identifier and a with clause.

alter-table clj

(alter-table table & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#alterTableStmt

Takes a table identifier and additional clause arguments:

• alter-column
• add-column
• alter-column
• rename-column
• drop-column
• with

alter-type clj

(alter-type type & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#alterTypeStmt

alter-user clj

(alter-user user & clauses)

Takes clauses:

• password
• superuser (defaults to false)

batch clj

(batch & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#batchStmt

Takes hayt queries optional clauses:

• queries
• using
• counter
• logged

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

create-index clj

(create-index table name & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#createIndexStmt

Takes a table identifier and additional clause arguments:

• index-column
• index-name
• custom
• on (overwrites table id)

create-keyspace clj

(create-keyspace keyspace & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#createKeyspaceStmt

Takes a keyspace identifier and clauses:

• with

create-table clj

(create-table table & clauses)

Takes a table identifier and additional clause arguments:

• column-definitions
• with

create-trigger clj

(create-trigger trigger table using)

http://cassandra.apache.org/doc/old/CQL-3.0.html#createTriggerStmt

create-type clj

(create-type type & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#createTypeStmt

create-user clj

(create-user user & clauses)

Takes clauses:

• password
• superuser (defaults to false)

custom clj

(custom)

(custom x)

Clause: Sets CUSTOM status on create-index query

delete clj

(delete table & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#deleteStmt

Takes a table identifier and additional clause arguments:

• columns (defaults to *)
• using
• where
• only-if

drop-column clj

(drop-column id)

Clause: Takes a column Identifier

drop-columnfamily clj

(drop-columnfamily cf & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#dropTableStmt

Takes a column family identifier and additional clauses:

• if-exists

drop-index clj

(drop-index index & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#dropIndexStmt

Takes an index identifier and additional clauses:

• if-exists

drop-keyspace clj

(drop-keyspace keyspace & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#dropKeyspaceStmt

Takes a keyspace identifier and additional clauses:

• if-exists

drop-table clj

(drop-table table & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#dropTableStmt

Takes a table identifier and additional clauses:

• if-exists

drop-trigger clj

(drop-trigger trigger table)

http://cassandra.apache.org/doc/old/CQL-3.0.html#dropTriggerStmt

Takes a trigger identifier and a table identifier

drop-type clj

(drop-type type & clauses)

http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlRefDropType.html

Takes a type identifier and additional clauses:

• if-exists

drop-user clj

(drop-user user & clauses)

Takes a user identifier

• if-exists

grant clj

(grant perm & clauses)

Takes clauses:

• resource
• user

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

insert clj

(insert table & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#insertStmt

Takes a table identifier and additional clause arguments:

• values
• using
• if-exists

limit clj

(limit n)

Clause: Sets LIMIT, takes a numeric value

list-perm clj

(list-perm & clauses)

Takes clauses:

• perm (defaults to ALL if not supplied)
• user
• resource
• recursive (defaults to true)

list-users clj

(list-users)

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

revoke clj

(revoke perm & clauses)

Takes clauses:

• resource
• user

select clj

(select table & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#selectStmt

Takes a table identifier and additional clause arguments:

• columns (defaults to *)
• where
• order-by
• limit
• only-if

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

truncate clj

(truncate table)

http://cassandra.apache.org/doc/old/CQL-3.0.html#truncateStmt

Takes a table identifier.

update clj

(update table & clauses)

http://cassandra.apache.org/doc/old/CQL-3.0.html#updateStmt

Takes a table identifier and additional clause arguments:

• using
• set-columns
• where
• only-if
• if-exists

use-keyspace clj

(use-keyspace keyspace)

http://cassandra.apache.org/doc/old/CQL-3.0.html#useStmt

Takes a keyspace identifier

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)