sqlosure.query-comprehension — de.active-group/sqlosure 0.4.0

! clj

(! rel name)

! selects an attribute from a relation.

Example: (! t "id") corresponds to SQL "t.id".

assert-alist clj

(assert-alist caller coll)

distinct! clj

divide clj

(divide prod1 prod2)

embed clj

(embed q)

Embed a RA query into the current query.

get-query clj

(get-query prod)

group clj

(group & colrefs)

Group by specified seq of column references [rel name].

group-refs clj

(group-refs & refs)

Group by specified seq of attribute references (qc/! rel name).

intersect clj

(intersect prod1 prod2)

make-relation clj

(make-relation alias scheme)

Construct a Relation record.

alias (The current alias.): access via sqlosure.query-comprehension/relation-alias scheme (The current relation-scheme.): access via sqlosure.query-comprehension/relation-scheme

order clj

(order alist)

order takes an alist of [[attribute-ref :descending/:ascending] to order the result by this attribute.

Example: (monadic [t (embed t-table)] (order [[(! t "foo") :ascending]]) (project {"foo" (! t "foo")}))

The corresponding SQL statemant would be "SELECT foo FROM t ORDER BY foo ASC".

outer clj

(outer q)

Embed a RA query as an outer query into the current query.

project clj

(project alist)

Project some columns of the current query. Returns the resulting state.

Example: (monadic [t (<- embed t-table)] (project [["foo" (! t "foo")] ["bar" (! t "bar")]])

The corresponding SQL statemant would be "SELECT foo, bar FROM t".

Relation clj

relation-alias clj

(relation-alias rec__2313__auto__)

(relation-alias data__2314__auto__ v__2315__auto__)

Lens for the alias field (The current alias.) from a Relation record. See sqlosure.query-comprehension/make-relation.

relation-scheme clj

(relation-scheme rec__2313__auto__)

(relation-scheme data__2314__auto__ v__2315__auto__)

Lens for the scheme field (The current relation-scheme.) from a Relation record. See sqlosure.query-comprehension/make-relation.

relation? clj

(relation? thing)

Is object a Relation record? See sqlosure.query-comprehension/make-relation.

restrict clj

(restrict expr)

Restrict the current query by a condition.

expr -> query(nil)

Note this doesn't return anything.

restrict-outer clj

(restrict-outer expr)

Restrict outer part of the current query by a condition.

expr -> query(nil)

Note: this is a monadic action that doesn't return anything.

restricted clj

(restricted rel expr)

Restrict the current query by a condition. Returns the resulting state.

Example: (monadic [t (<- embed t-table)] (restricted t ($<= (! t "id") ($integer 1))

The corresponding SQL statement would be "SELECT <all cols of t> FROM t WHERE id <= 1"

relation expr -> query(relation).

subtract clj

(subtract prod1 prod2)

top clj

(top n)

(top offset n)

top is used to define queries that return a cerain number of entries. When called with one argument n, top constructs a query that only returns the first n elements. Whan called with two arguments offset and n, top constructs a query that returns the first n elements with an offset of offset.

union clj

(union p1 & prods)