sqlingvo.core — sqlingvo 0.9.31

as clj/s

(as expr alias & [columns])

Parse expr and return an expr with and AS clause using alias.

asc clj/s

(asc expr)

Parse expr and return an ORDER BY expr using ascending order.

ast clj/s

(ast stmt)

Returns the abstract syntax tree of stmt.

cascade clj/s

(cascade condition)

Add a CASCADE clause to an SQL statement.

chain-state clj/s

(chain-state body)

check clj/s

(check expr)

Add a CHECK clause to an SQL statement.

column clj/s

(column name type & {:as options})

Add a column to stmt.

columns clj/s

(columns table)

Returns the columns of table.

compose clj/s

(compose stmt & body)

Compose multiple SQL statements.

concurrently clj/s

(concurrently condition)

Add a CONCURRENTLY clause to a SQL statement.

continue-identity clj/s

(continue-identity condition)

Add a CONTINUE IDENTITY clause to an SQL statement.

copy clj/s

(copy db table columns & body)

Build a COPY statement.

Examples:

(copy db :country [] (from :stdin))

(copy db :country [] (from "/usr1/proj/bray/sql/country_data"))

create-schema clj/s

(create-schema db schema & body)

Build a CREATE SCHEMA statement.

create-table clj/s

(create-table db table & body)

Build a CREATE TABLE statement.

create-type clj/s

(create-type db type & body)

Build a CREATE TYPE sql statement.

db clj/s

(db spec & [opts])

Return a new database for spec.

db? clj/s

(db? x)

Return true if x is a database, otherwise false.

delete clj/s

(delete db table & body)

Build a DELETE statement.

Examples:

(delete db :continents)

(delete db :continents (where '(= :id 1)))

delimiter clj/s

(delimiter delimiter)

Add a DELIMITER clause to an SQL statement.

desc clj/s

(desc expr)

Parse expr and return an ORDER BY expr using descending order.

distinct clj/s

(distinct exprs & {:keys [on]})

Parse exprs and return a DISTINCT clause.

do-constraint clj/s

(do-constraint constraint)

Add a DO CONSTRAINT clause to a SQL statement.

do-nothing clj/s

(do-nothing)

Add a DO NOTHING clause to a SQL statement.

do-update clj/s

(do-update expr)

Add a DO UPDATE clause to a SQL statement.

drop-materialized-view clj/s

(drop-materialized-view db view & body)

Build a DROP MATERIALIZED VIEW statement.

Examples:

(drop-materialized-view db :order-summary)

drop-schema clj/s

(drop-schema db schemas & body)

Build a DROP SCHEMA statement.

Examples:

(drop-schema db [:my-schema])

drop-table clj/s

(drop-table db tables & body)

Build a DROP TABLE statement.

Examples:

(drop-table db [:continents])

(drop-table db [:continents :countries])

drop-type clj/s

(drop-type db types & body)

Build a DROP TYPE statement.

Examples:

(drop-type db [:mood])

(drop-table db [:my-schema.mood])

encoding clj/s

(encoding encoding)

Add a ENCODING clause to an SQL statement.

enum clj/s

(enum labels)

Returns the enum ast.

except clj/s

(except & args)

Build an EXCEPT statement.

Examples:

(except (select db [1]) (select db [2]))

(except {:all true} (select db [1]) (select db [2]))

excluded-keyword clj/s

(excluded-keyword k)

Returns the keyword k, prefixed with "EXCLUDED.".

excluded-keyword? clj/s

(excluded-keyword? k)

Returns true if the keyword k is prefixed with "EXCLUDED.", otherwise false.

excluded-kw-map clj/s

(excluded-kw-map ks)

Returns a map of EXCLUDED ks indexed by ks.

explain clj/s

(explain db stmt & [opts])

Return an EXPLAIN statement for stmt. opts can be a map with the following key/value pairs:

• :analyze boolean
• :buffers boolean
• :costs boolean
• :format :json, :text, :yaml, :xml
• :timing boolean
• :verbose boolean

Examples:

(explain db (select db [:*] (from :foo)))

(explain db (select db [:*] (from :foo)) {:analyze true})

from clj/s

(from & from)

Add a FROM clause to an SQL statement. The from forms can be one or more tables, :stdin, a filename or an other sub query.

Examples:

(select db [:*] (from :continents))

(select db [:*] (from :continents :countries) (where '(= :continents.id :continent-id)))

(select db [:*] (from (as (select [1 2 3]) :x)))

(copy db :country [] (from :stdin))

(copy db :country [] (from "/usr1/proj/bray/sql/country_data"))

group-by clj/s

(group-by & exprs)

Add a GROUP BY clause to an SQL statement.

having clj/s

(having condition & [combine])

Add a HAVING clause to an SQL statement.

Examples:

(select db [:city '(max :temp-lo)] (from :weather) (group-by :city) (having '(< (max :temp-lo) 40)))

if-exists clj/s

(if-exists condition)

Add a IF EXISTS clause to an SQL statement.

if-not-exists clj/s

(if-not-exists condition)

Add a IF EXISTS clause to an SQL statement.

inherits clj/s

(inherits & tables)

Add an INHERITS clause to an SQL statement.

inline-str clj/s

(inline-str s)

Compile s as an inline string, instead of a prepared statement parameter.

WARNING: You have to make sure the string s is safe against SQL injection attacks yourself.

insert clj/s

(insert db table columns & body)

Build a INSERT statement.

intersect clj/s

(intersect & args)

Build an INTERSECT statement.

Examples:

(intersect (select db [1]) (select db [2]))

(intersect {:all true} (select db [1]) (select db [2]))

join clj/s

(join from condition & {:keys [type outer pk]})

Add a JOIN clause to a statement.

Examples:

(select db [:*] (from :countries) (join :continents '(using :id)))

(select db [:*] (from :continents) (join :countries.continent-id :continents.id))

(select db [:*] (from :countries) (join :continents '(on (= :continents.id :countries.continent-id))))

like clj/s

(like table & {:as opts})

Add a LIKE clause to an SQL statement.

limit clj/s

(limit expr)

Add a LIMIT clause to an SQL statement.

nulls clj/s

(nulls expr where)

Parse expr and return an NULLS FIRST/LAST expr.

offset clj/s

(offset expr)

Add a OFFSET clause to an SQL statement.

on-conflict clj/s

(on-conflict target & body)

Add a ON CONFLICT clause to a SQL statement.

on-conflict-on-constraint clj/s

(on-conflict-on-constraint target & body)

Add a ON CONFLICT ON CONSTRAINT clause to a SQL statement.

order-by clj/s

(order-by & exprs)

Add a ORDER BY clause to an SQL statement.

primary-key clj/s

(primary-key & keys)

Add a PRIMARY KEY clause to a table.

refresh-materialized-view clj/s

(refresh-materialized-view db view & body)

Build a REFRESH MATERIALIZED VIEW statement.

Examples:

(refresh-materialized-view db :order-summary)

restart-identity clj/s

(restart-identity condition)

Add a RESTART IDENTITY clause to an SQL statement.

restrict clj/s

(restrict condition)

Add a RESTRICT clause to an SQL statement.

returning clj/s

(returning & exprs)

Add a RETURNING clause to an SQL statement.

Examples:

(insert db :distributors [] (values [{:did 106 :dname "XYZ Widgets"}]) (returning :*))

(update db :films {:kind "Dramatic"} (where '(= :kind "Drama")) (returning :*))

select clj/s

(select db exprs & body)

Build a SELECT statement.

Examples:

(select db [1])

(select db [:*] (from :continents))

(select db [:id :name] (from :continents))

sql clj/s

(sql stmt)

Compile stmt into a clojure.java.jdbc compatible vector.

table clj/s

(table name & body)

Make a new table and return it's AST.

temporary clj/s

(temporary condition)

Add a TEMPORARY clause to an SQL statement.

truncate clj/s

(truncate db tables & body)

Build a TRUNCATE statement.

Examples:

(truncate db [:continents])

(truncate db [:continents :countries])

union clj/s

(union & args)

Build a UNION statement.

Examples:

(union (select db [1]) (select db [2]))

(union {:all true} (select db [1]) (select db [2]))

update clj/s

(update db table row & body)

Build a UPDATE statement.

Examples:

(update db :films {:kind "Dramatic"} (where '(= :kind "Drama")))

values clj/s

(values vals)

(values db vals)

Return a VALUES statement or clause.

Examples:

(values db [[1 "one"] [2 "two"] [3 "three"]])

(insert db :distributors [] (values [{:did 106 :dname "XYZ Widgets"}]))

where clj/s

(where condition & [combine])

Add a WHERE clause to an SQL statement.

Examples:

(select db [1] (where '(in 1 (1 2 3))))

(select db [*] (from :continents) (where '(= :name "Europe")))

(delete db :continents (where '(= :id 1)))

window clj/s

(window & exprs)

Add a WINDOW clause to an SQL statement.

with clj/s

(with db bindings query)

Build a WITH (common table expressions) query.

with-data clj/s

(with-data data?)

Add a WITH [NO] DATA clause to a SQL statement.