sqlosure.sql — de.active-group/sqlosure 0.4.0

Structured representation of SQL Link to relational algebra

->sql-expr-app clj

(->sql-expr-app rator rands)

Positional factory function for class sqlosure.sql.sql-expr-app.

->sql-expr-case clj

(->sql-expr-case branches default)

Positional factory function for class sqlosure.sql.sql-expr-case.

->sql-expr-column clj

(->sql-expr-column name)

Positional factory function for class sqlosure.sql.sql-expr-column.

->sql-expr-const clj

(->sql-expr-const type val)

Positional factory function for class sqlosure.sql.sql-expr-const.

->sql-expr-exists clj

(->sql-expr-exists select)

Positional factory function for class sqlosure.sql.sql-expr-exists.

->sql-expr-subquery clj

(->sql-expr-subquery query)

Positional factory function for class sqlosure.sql.sql-expr-subquery.

->sql-expr-tuple clj

(->sql-expr-tuple expressions)

Positional factory function for class sqlosure.sql.sql-expr-tuple.

->sql-operator clj

(->sql-operator name arity)

Positional factory function for class sqlosure.sql.sql-operator.

->sql-select clj

(->sql-select options
              attributes
              nullary?
              tables
              outer-tables
              criteria
              outer-criteria
              group-by
              having
              order-by
              extra)

Positional factory function for class sqlosure.sql.sql-select.

->sql-select-combine clj

(->sql-select-combine op left right)

Positional factory function for class sqlosure.sql.sql-select-combine.

->sql-select-empty clj

(->sql-select-empty)

Positional factory function for class sqlosure.sql.sql-select-empty.

->sql-select-table clj

(->sql-select-table name)

Positional factory function for class sqlosure.sql.sql-select-table.

->sql-table clj

(->sql-table name scheme)

Positional factory function for class sqlosure.sql.sql-table.

<$ clj

<=$ clj

=$ clj

>$ clj

>=$ clj

and$ clj

base-relation clj

(base-relation name scheme & {:keys [universe] :or {universe nil}})

Takes a name and a rel-scheme and returns a relation that can be used as a SQL table.

between$ clj

check-numerical clj

(check-numerical t fail)

check-ordered clj

(check-ordered t fail)

concat$ clj

in$ clj

is-not-null?$ clj

is-null?$ clj

like$ clj

lower$ clj

make-sql-expr-app clj

(make-sql-expr-app rator & rands)

make-sql-expr-case clj

(make-sql-expr-case branches default)

Construct a sql-expr-case record.

branches: access via sqlosure.sql/sql-expr-case-branches default: access via sqlosure.sql/sql-expr-case-default

make-sql-expr-column clj

(make-sql-expr-column name)

Construct a sql-expr-column record.

name: access via sqlosure.sql/sql-expr-column-name

make-sql-expr-const clj

(make-sql-expr-const type val)

Construct a sql-expr-const record.

type: access via sqlosure.sql/sql-expr-const-type val: access via sqlosure.sql/sql-expr-const-val

make-sql-expr-exists clj

(make-sql-expr-exists select)

Construct a sql-expr-exists record.

select: access via sqlosure.sql/sql-expr-exists-select

make-sql-expr-subquery clj

(make-sql-expr-subquery query)

Construct a sql-expr-subquery record.

query: access via sqlosure.sql/sql-expr-subquery-query

make-sql-expr-tuple clj

(make-sql-expr-tuple expressions)

Construct a sql-expr-tuple record.

expressions: access via sqlosure.sql/sql-expr-tuple-expressions

make-sql-operator clj

(make-sql-operator name arity)

Construct a sql-operator record.

name: access via sqlosure.sql/sql-operator-name arity: access via sqlosure.sql/sql-operator-arity

make-sql-select clj

(make-sql-select options
                 attributes
                 nullary?
                 tables
                 outer-tables
                 criteria
                 outer-criteria
                 group-by
                 having
                 order-by
                 extra)

Construct a sql-select record.

options: access via sqlosure.sql/sql-select-options attributes: access via sqlosure.sql/sql-select-attributes nullary?: access via sqlosure.sql/sql-select-nullary? tables: access via sqlosure.sql/sql-select-tables outer-tables: access via sqlosure.sql/sql-select-outer-tables criteria: access via sqlosure.sql/sql-select-criteria outer-criteria: access via sqlosure.sql/sql-select-outer-criteria group-by (set of SQL column names or nil.): access via sqlosure.sql/sql-select-group-by having (List of SQL expressions or nil.): access via sqlosure.sql/sql-select-having order-by: access via sqlosure.sql/sql-select-order-by extra: access via sqlosure.sql/sql-select-extra

make-sql-select-combine clj

(make-sql-select-combine op left right)

Construct a sql-select-combine record.

op: access via sqlosure.sql/sql-select-combine-op left: access via sqlosure.sql/sql-select-combine-left right: access via sqlosure.sql/sql-select-combine-right

make-sql-select-empty clj

(make-sql-select-empty)

Construct a sql-select-empty record.

make-sql-select-table clj

(make-sql-select-table name)

Construct a sql-select-table record.

name: access via sqlosure.sql/sql-select-table-name

make-sql-universe clj

(make-sql-universe)

map->sql-expr-app clj

(map->sql-expr-app m__2330__auto__)

Factory function for class sqlosure.sql.sql-expr-app, taking a map of keywords to field values.

map->sql-expr-case clj

(map->sql-expr-case m__2330__auto__)

Factory function for class sqlosure.sql.sql-expr-case, taking a map of keywords to field values.

map->sql-expr-column clj

(map->sql-expr-column m__2330__auto__)

Factory function for class sqlosure.sql.sql-expr-column, taking a map of keywords to field values.

map->sql-expr-const clj

(map->sql-expr-const m__2330__auto__)

Factory function for class sqlosure.sql.sql-expr-const, taking a map of keywords to field values.

map->sql-expr-exists clj

(map->sql-expr-exists m__2330__auto__)

Factory function for class sqlosure.sql.sql-expr-exists, taking a map of keywords to field values.

map->sql-expr-subquery clj

(map->sql-expr-subquery m__2330__auto__)

Factory function for class sqlosure.sql.sql-expr-subquery, taking a map of keywords to field values.

map->sql-expr-tuple clj

(map->sql-expr-tuple m__2330__auto__)

Factory function for class sqlosure.sql.sql-expr-tuple, taking a map of keywords to field values.

map->sql-operator clj

(map->sql-operator m__2330__auto__)

Factory function for class sqlosure.sql.sql-operator, taking a map of keywords to field values.

map->sql-select clj

(map->sql-select m__2330__auto__)

Factory function for class sqlosure.sql.sql-select, taking a map of keywords to field values.

map->sql-select-combine clj

(map->sql-select-combine m__2330__auto__)

Factory function for class sqlosure.sql.sql-select-combine, taking a map of keywords to field values.

map->sql-select-empty clj

(map->sql-select-empty m__2330__auto__)

Factory function for class sqlosure.sql.sql-select-empty, taking a map of keywords to field values.

map->sql-select-table clj

(map->sql-select-table m__2330__auto__)

Factory function for class sqlosure.sql.sql-select-table, taking a map of keywords to field values.

map->sql-table clj

(map->sql-table m__2330__auto__)

Factory function for class sqlosure.sql.sql-table, taking a map of keywords to field values.

member clj

(member x xs)

Locates the first element of xs that is equal to x. If such an element exists, the rest of xs starting with that element is returned. Otherwise, the result is false (Scheme's member function).

minus$ clj

new-sql-select clj

(new-sql-select)

Create a new, empty sql-select.

not$ clj

op-* clj

op-+ clj

op-- clj

op-< clj

op-<= clj

op-<> clj

op-= clj

op-> clj

op->= clj

op-and clj

op-asg clj

op-avg clj

op-between clj

op-bit-and clj

op-bit-not clj

op-bit-or clj

op-bit-xor clj

op-cat clj

op-concat clj

op-count clj

op-count-all clj

op-div clj

op-in clj

op-length clj

op-like clj

op-lower clj

op-max clj

op-min clj

op-mod clj

op-not clj

op-not-null? clj

op-null? clj

op-or clj

op-std-dev clj

op-std-dev-p clj

op-sum clj

op-upper clj

op-var clj

op-var-p clj

or$ clj

plus$ clj

really-make-sql-expr-app clj

(really-make-sql-expr-app rator rands)

Construct a sql-expr-app record.

rator: access via sqlosure.sql/sql-expr-app-rator rands: access via sqlosure.sql/sql-expr-app-rands

really-make-sql-table clj

(really-make-sql-table name scheme)

Construct a sql-table record.

name: access via sqlosure.sql/sql-table-name scheme: access via sqlosure.sql/sql-table-scheme

sql-combine-op? clj

(sql-combine-op? k)

Is a key a sql-combine-op?

sql-expr-app-rands clj

(sql-expr-app-rands rec__2313__auto__)

(sql-expr-app-rands data__2314__auto__ v__2315__auto__)

Lens for the rands field from a [[sql-expr-app]] record. See sqlosure.sql/really-make-sql-expr-app.

sql-expr-app-rator clj

(sql-expr-app-rator rec__2313__auto__)

(sql-expr-app-rator data__2314__auto__ v__2315__auto__)

Lens for the rator field from a [[sql-expr-app]] record. See sqlosure.sql/really-make-sql-expr-app.

sql-expr-app? clj

(sql-expr-app? thing)

Is object a sql-expr-app record? See sqlosure.sql/really-make-sql-expr-app.

sql-expr-case-branches clj

(sql-expr-case-branches rec__2313__auto__)

(sql-expr-case-branches data__2314__auto__ v__2315__auto__)

Lens for the branches field from a [[sql-expr-case]] record. See sqlosure.sql/make-sql-expr-case.

sql-expr-case-default clj

(sql-expr-case-default rec__2313__auto__)

(sql-expr-case-default data__2314__auto__ v__2315__auto__)

Lens for the default field from a [[sql-expr-case]] record. See sqlosure.sql/make-sql-expr-case.

sql-expr-case? clj

(sql-expr-case? thing)

Is object a sql-expr-case record? See sqlosure.sql/make-sql-expr-case.

sql-expr-column-name clj

(sql-expr-column-name rec__2313__auto__)

(sql-expr-column-name data__2314__auto__ v__2315__auto__)

Lens for the name field from a [[sql-expr-column]] record. See sqlosure.sql/make-sql-expr-column.

sql-expr-column? clj

(sql-expr-column? thing)

Is object a sql-expr-column record? See sqlosure.sql/make-sql-expr-column.

sql-expr-const-type clj

(sql-expr-const-type rec__2313__auto__)

(sql-expr-const-type data__2314__auto__ v__2315__auto__)

Lens for the type field from a [[sql-expr-const]] record. See sqlosure.sql/make-sql-expr-const.

sql-expr-const-val clj

(sql-expr-const-val rec__2313__auto__)

(sql-expr-const-val data__2314__auto__ v__2315__auto__)

Lens for the val field from a [[sql-expr-const]] record. See sqlosure.sql/make-sql-expr-const.

sql-expr-const? clj

(sql-expr-const? thing)

Is object a sql-expr-const record? See sqlosure.sql/make-sql-expr-const.

sql-expr-exists-select clj

(sql-expr-exists-select rec__2313__auto__)

(sql-expr-exists-select data__2314__auto__ v__2315__auto__)

Lens for the select field from a [[sql-expr-exists]] record. See sqlosure.sql/make-sql-expr-exists.

sql-expr-exists? clj

(sql-expr-exists? thing)

Is object a sql-expr-exists record? See sqlosure.sql/make-sql-expr-exists.

sql-expr-subquery-query clj

(sql-expr-subquery-query rec__2313__auto__)

(sql-expr-subquery-query data__2314__auto__ v__2315__auto__)

Lens for the query field from a [[sql-expr-subquery]] record. See sqlosure.sql/make-sql-expr-subquery.

sql-expr-subquery? clj

(sql-expr-subquery? thing)

Is object a sql-expr-subquery record? See sqlosure.sql/make-sql-expr-subquery.

sql-expr-tuple-expressions clj

(sql-expr-tuple-expressions rec__2313__auto__)

(sql-expr-tuple-expressions data__2314__auto__ v__2315__auto__)

Lens for the expressions field from a [[sql-expr-tuple]] record. See sqlosure.sql/make-sql-expr-tuple.

sql-expr-tuple? clj

(sql-expr-tuple? thing)

Is object a sql-expr-tuple record? See sqlosure.sql/make-sql-expr-tuple.

sql-operator-arity clj

(sql-operator-arity rec__2313__auto__)

(sql-operator-arity data__2314__auto__ v__2315__auto__)

Lens for the arity field from a [[sql-operator]] record. See sqlosure.sql/make-sql-operator.

sql-operator-name clj

(sql-operator-name rec__2313__auto__)

(sql-operator-name data__2314__auto__ v__2315__auto__)

Lens for the name field from a [[sql-operator]] record. See sqlosure.sql/make-sql-operator.

sql-operator? clj

(sql-operator? thing)

Is object a sql-operator record? See sqlosure.sql/make-sql-operator.

sql-order? clj

(sql-order? k)

Is a key a sql-order?

sql-select-attributes clj

(sql-select-attributes rec__2313__auto__)

(sql-select-attributes data__2314__auto__ v__2315__auto__)

Lens for the attributes field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-combine-left clj

(sql-select-combine-left rec__2313__auto__)

(sql-select-combine-left data__2314__auto__ v__2315__auto__)

Lens for the left field from a [[sql-select-combine]] record. See sqlosure.sql/make-sql-select-combine.

sql-select-combine-op clj

(sql-select-combine-op rec__2313__auto__)

(sql-select-combine-op data__2314__auto__ v__2315__auto__)

Lens for the op field from a [[sql-select-combine]] record. See sqlosure.sql/make-sql-select-combine.

sql-select-combine-right clj

(sql-select-combine-right rec__2313__auto__)

(sql-select-combine-right data__2314__auto__ v__2315__auto__)

Lens for the right field from a [[sql-select-combine]] record. See sqlosure.sql/make-sql-select-combine.

sql-select-combine? clj

(sql-select-combine? thing)

Is object a sql-select-combine record? See sqlosure.sql/make-sql-select-combine.

sql-select-criteria clj

(sql-select-criteria rec__2313__auto__)

(sql-select-criteria data__2314__auto__ v__2315__auto__)

Lens for the criteria field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-empty? clj

(sql-select-empty? thing)

Is object a sql-select-empty record? See sqlosure.sql/make-sql-select-empty.

sql-select-extra clj

(sql-select-extra rec__2313__auto__)

(sql-select-extra data__2314__auto__ v__2315__auto__)

Lens for the extra field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-group-by clj

(sql-select-group-by rec__2313__auto__)

(sql-select-group-by data__2314__auto__ v__2315__auto__)

Lens for the group-by field (set of SQL column names or nil.) from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-having clj

(sql-select-having rec__2313__auto__)

(sql-select-having data__2314__auto__ v__2315__auto__)

Lens for the having field (List of SQL expressions or nil.) from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-nullary? clj

(sql-select-nullary? rec__2313__auto__)

(sql-select-nullary? data__2314__auto__ v__2315__auto__)

Lens for the nullary? field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-options clj

(sql-select-options rec__2313__auto__)

(sql-select-options data__2314__auto__ v__2315__auto__)

Lens for the options field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-order-by clj

(sql-select-order-by rec__2313__auto__)

(sql-select-order-by data__2314__auto__ v__2315__auto__)

Lens for the order-by field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-outer-criteria clj

(sql-select-outer-criteria rec__2313__auto__)

(sql-select-outer-criteria data__2314__auto__ v__2315__auto__)

Lens for the outer-criteria field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-outer-tables clj

(sql-select-outer-tables rec__2313__auto__)

(sql-select-outer-tables data__2314__auto__ v__2315__auto__)

Lens for the outer-tables field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select-table-name clj

(sql-select-table-name rec__2313__auto__)

(sql-select-table-name data__2314__auto__ v__2315__auto__)

Lens for the name field from a [[sql-select-table]] record. See sqlosure.sql/make-sql-select-table.

sql-select-table? clj

(sql-select-table? thing)

Is object a sql-select-table record? See sqlosure.sql/make-sql-select-table.

sql-select-tables clj

(sql-select-tables rec__2313__auto__)

(sql-select-tables data__2314__auto__ v__2315__auto__)

Lens for the tables field from a [[sql-select]] record. See sqlosure.sql/make-sql-select.

sql-select? clj

(sql-select? thing)

Is object a sql-select record? See sqlosure.sql/make-sql-select.

sql-table-name clj

(sql-table-name rec__2313__auto__)

(sql-table-name data__2314__auto__ v__2315__auto__)

Lens for the name field from a [[sql-table]] record. See sqlosure.sql/really-make-sql-table.

sql-table-scheme clj

(sql-table-scheme rec__2313__auto__)

(sql-table-scheme data__2314__auto__ v__2315__auto__)

Lens for the scheme field from a [[sql-table]] record. See sqlosure.sql/really-make-sql-table.

sql-table? clj

(sql-table? thing)

Is object a sql-table record? See sqlosure.sql/really-make-sql-table.

sql-universe clj

the-sql-null clj

the-sql-select-empty clj

upper$ clj