suricatta.dsl — funcool/suricatta 1.3.1

Sql building dsl

*datatypes* clj

Datatypes translation map

add-column clj multimethod

alter-column clj

(alter-column step name & [{:keys [type default null length] :as opts}])

alter-sequence clj

(alter-sequence seqname restart)

alter-table clj

(alter-table name)

Creates new and empty alter table expression.

and clj

(and & conditions)

Logican operator and.

create-index clj

(create-index indexname)

create-sequence clj

(create-sequence seqname)

create-table clj

(create-table name)

cross-join clj

(cross-join step tlike)

delete clj

(delete t)

drop-column clj

(drop-column step name & [type])

Drop column from alter table step.

drop-index clj

(drop-index indexname)

drop-sequence clj

(drop-sequence seqname)

(drop-sequence seqname ifexists)

drop-table clj

(drop-table t)

Drop table statement constructor.

exists clj

(exists q)

Create an exists condition.

f clj

(f v)

Create a field instance, specialized on create function like field instance.

field clj

(field v)

(field v alias)

Create a field instance.

for-update clj

(for-update q & fields)

from clj

(from f & tables)

Creates from clause.

full-outer-join clj

(full-outer-join step tlike)

group-by clj

(group-by q & fields)

having clj

(having q & clauses)

Create having clause with variable number of conditions (that are implicitly combined with and logical operator).

ICondition clj protocol

-condition clj

(-condition _)

Condition constructor

IDeferred clj protocol

Protocol mainly defined for uniform unwrapping deferred queries.

-unwrap clj

(-unwrap _)

Unwrap the object

IField clj protocol

-field clj

(-field _)

Field constructor.

IName clj protocol

-name clj

(-name _)

Name constructor (mainly used with CTE)

insert-into clj

(insert-into t)

insert-values clj

(insert-values t values)

ISortField clj protocol

-sort-field clj

(-sort-field _)

Sort field constructor

ITable clj protocol

-table clj

(-table _)

Table constructor.

ITableCoerce clj protocol

-as-table clj

(-as-table _ params)

Table coersion.

IVal clj protocol

-val clj

(-val _)

Val constructor

join clj

(join q t)

Create join clause.

left-outer-join clj

(left-outer-join step tlike)

limit clj

(limit q num)

Creates limit clause.

name clj

(name v)

not clj

(not c)

Negate a condition.

not-exists clj

(not-exists q)

Create a not-exists condition.

offset clj

(offset q num)

Creates offset clause.

on clj multimethod

or clj

(or & conditions)

Logican operator or.

order-by clj

(order-by q & clauses)

returning clj

(returning t & fields)

right-outer-join clj

(right-outer-join step tlike)

row clj macro

(row & values)

select clj

(select & fields)

Start select statement.

select-count clj

(select-count)

select-distinct clj

(select-distinct & fields)

Start select statement.

select-from clj

(select-from t)

Helper for create select * from <table> statement directly (without specify fields)

select-one clj

(select-one)

select-zero clj

(select-zero)

set clj

(set t kv)

(set t k v)

Attach values to the UPDATE statement.

table clj

(table v)

(table v alias)

Create a table instance.

to-table clj

(to-table texp talias & params)

Coerce querypart to table expression.

truncate clj

(truncate t)

typed-field clj

(typed-field data type)

union clj

(union & clauses)

union-all clj

(union-all & clauses)

update clj

(update t)

Returns empty UPDATE statement.

val clj

(val v)

values clj

(values & rows)

where clj

(where q & clauses)

Create where clause with variable number of conditions (that are implicitly combined with and logical operator).

with clj

(with & tables)

Create a WITH clause

with-fields clj

(with-fields n & fields)

Add a list of fields to this name to make this name a DerivedColumnList.