datumbazo.core — datumbazo 0.14.0

as clj

(as expr alias & [columns])

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

asc clj

(asc expr)

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

ast clj

(ast stmt)

Returns the abstract syntax tree of stmt.

auto-commit? clj

(auto-commit? db)

Returns true if the current database connection is in auto commit mode, otherwise false.

belongs-to clj

(belongs-to db batch source target & [opts])

cascade clj

(cascade condition)

Add a CASCADE clause to an SQL statement.

chain-state clj

(chain-state body)

check clj

(check expr)

Add a CHECK clause to an SQL statement.

column clj

(column name type & {:as options})

Add a column to stmt.

columns clj

(columns table)

Returns the columns of table.

compose clj

(compose stmt & body)

Compose multiple SQL statements.

concurrently clj

(concurrently condition)

Add a CONCURRENTLY clause to a SQL statement.

connect clj

(connect db & [opts])

Connect to db using opts.

connected? clj

(connected? db)

Returns true if db is connected, otherwise false.

connection clj

(connection db)

Return the current connection to db.

continue-identity clj

(continue-identity condition)

Add a CONTINUE IDENTITY clause to an SQL statement.

copy clj

(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"))

count-all clj

(count-all db table)

Count all rows in the database table.

create-materialized-view clj

(create-materialized-view db view columns & body)

Build a CREATE MATERIALIZED VIEW statement.

Examples:

(sql/create-materialized-view db :pseudo-source [:key :value] (sql/values [["a" 1] ["a" 2] ["a" 3] ["a" 4] ["b" 5] ["c" 6] ["c" 7]]))

create-schema clj

(create-schema db schema & body)

Build a CREATE SCHEMA statement.

create-table clj

(create-table db table & body)

Build a CREATE TABLE statement.

create-type clj

(create-type db type & body)

Build a CREATE TYPE sql statement.

db clj

(db spec & [opts])

Return a new database from spec.

db? clj

(db? x)

Return true if x is a database, otherwise false.

deftable clj macro

(deftable table-name doc & body)

Define a database table.

delete clj

(delete db table & body)

Build a DELETE statement.

Examples:

(delete db :continents)

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

delimiter clj

(delimiter delimiter)

Add a DELIMITER clause to an SQL statement.

desc clj

(desc expr)

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

disconnect clj

(disconnect db & [opts])

Disconnect from db.

distinct clj

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

Parse exprs and return a DISTINCT clause.

do-constraint clj

(do-constraint constraint)

Add a DO CONSTRAINT clause to a SQL statement.

do-nothing clj

(do-nothing)

Add a DO NOTHING clause to a SQL statement.

do-update clj

(do-update expr)

Add a DO UPDATE clause to a SQL statement.

drop-materialized-view clj

(drop-materialized-view db view & body)

Build a DROP MATERIALIZED VIEW statement.

Examples:

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

drop-schema clj

(drop-schema db schemas & body)

Build a DROP SCHEMA statement.

Examples:

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

drop-table clj

(drop-table db tables & body)

Build a DROP TABLE statement.

Examples:

(drop-table db [:continents])

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

drop-type clj

(drop-type db types & body)

Build a DROP TYPE statement.

Examples:

(drop-type db [:mood])

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

drop-view clj

(drop-view db view & body)

Build a DROP VIEW statement.

Examples:

(drop-view db :order-summary)

encoding clj

(encoding encoding)

Add a ENCODING clause to an SQL statement.

enum clj

(enum labels)

Returns the enum ast.

except clj

(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

(excluded-keyword k)

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

excluded-keyword? clj

(excluded-keyword? k)

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

excluded-kw-map clj

(excluded-kw-map ks)

Returns a map of EXCLUDED ks indexed by ks.

execute clj

(execute stmt & [opts])

Execute stmt against a database.

explain clj

(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

(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

(group-by & exprs)

Add a GROUP BY clause to an SQL statement.

has-and-belongs-to-many clj

(has-and-belongs-to-many db batch source target & [opts])

has-many clj

(has-many db batch source target & [opts])

has-one clj

(has-one db batch source target & [opts])

having clj

(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

(if-exists condition)

Add a IF EXISTS clause to an SQL statement.

if-not-exists clj

(if-not-exists condition)

Add a IF EXISTS clause to an SQL statement.

inherits clj

(inherits & tables)

Add an INHERITS clause to an SQL statement.

inline-str clj

(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

(insert db table columns & body)

Build a INSERT statement.

intersect clj

(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

(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

(like table & {:as opts})

Add a LIKE clause to an SQL statement.

limit clj

(limit expr)

Add a LIMIT clause to an SQL statement.

make-instance clj multimethod

Make a new instance of class using attrs.

make-instances clj

(make-instances db class records)

Convert all records into instances of class.

nulls clj

(nulls expr where)

Parse expr and return an NULLS FIRST/LAST expr.

offset clj

(offset expr)

Add a OFFSET clause to an SQL statement.

on-conflict clj

(on-conflict target & body)

Add a ON CONFLICT clause to a SQL statement.

on-conflict-on-constraint clj

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

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

or-replace clj

(or-replace condition)

Add an OR REPLACE clause to an SQL statement.

order-by clj

(order-by & exprs)

Add a ORDER BY clause to an SQL statement.

page-info clj

(page-info db target & [params])

Returns the page info for query and params.

paginate clj

(paginate page & [limit per-page])

Add LIMIT and OFFSET clauses to query calculated from page and per-page.

prepare clj

(prepare db sql & [opts])

Return a prepared statement for sql.

primary-key clj

(primary-key & keys)

Add a PRIMARY KEY clause to a table.

print-explain clj

(print-explain query)

Print the execution plan of query.

refresh-materialized-view clj

(refresh-materialized-view db view & body)

Build a REFRESH MATERIALIZED VIEW statement.

Examples:

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

restart-identity clj

(restart-identity condition)

Add a RESTART IDENTITY clause to an SQL statement.

restrict clj

(restrict condition)

Add a RESTRICT clause to an SQL statement.

returning clj

(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 :*))

rollback! clj

(rollback! db & [savepoint])

run clj

select clj

(select db exprs & body)

Build a SELECT statement.

Examples:

(select db [1])

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

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

set-auto-commit! clj

(set-auto-commit! db auto-commit)

set-savepoint! clj

(set-savepoint! db & [name])

Set a savepoint on the current connection.

sql clj

(sql stmt)

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

sql-str clj

(sql-str stmt)

Prepare stmt using the database and return the raw SQL as a string.

table clj

(table name & body)

Make a new table.

temporary clj

(temporary condition)

Add a TEMPORARY clause to an SQL statement.

transact clj

(transact db f & [opts])

Run f within a database transaction on db.

truncate clj

(truncate db tables & body)

Build a TRUNCATE statement.

Examples:

(truncate db [:continents])

(truncate db [:continents :countries])

union clj

(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

(update db table row & body)

Build a UPDATE statement.

Examples:

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

values clj

(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

(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

(window & exprs)

Add a WINDOW clause to an SQL statement.

with clj

(with db bindings query)

Build a WITH (common table expressions) query.

with-connection clj macro

(with-connection [db-sym db & [opts]] & body)

Open a database connection, bind the connected db to db-sym, evaluate body and close the connection again.

with-data clj

(with-data data?)

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

with-db clj macro

(with-db [db-sym config & [opts]] & body)

Start a database component using config bind it to db-sym, evaluate body and close the database connection again.

with-rollback clj macro

(with-rollback [db-sym db] & body)

Start a transaction, evaluate body and rollback.

with-savepoint clj macro

(with-savepoint [db-sym db opts] & body)

Start a transaction, evaluate body and rollback.

with-transaction clj macro

(with-transaction [db-sym db & [opts]] & body)

Start a new db transaction, bind db to db-sym and evaluate body within the transaction.