phoenix.db — honeysql-phoenix 0.2.1

*default-db* clj

avatica clj

(avatica spec)

Create an avatica jdbc driver spec.

:url Full url of avatica server (or phoenix query server), e.g.: http://127.0.0.1:8765 :serialization Serialization protocol to communicate with server, json or protobuf.

For more options, please see: https://calcite.apache.org/avatica/docs/client_reference.html

db* clj

(db* table)

(db* table db)

Return db spec, or set db sepc of a table.

defdb clj macro

(defdb db-name spec)

Define a db spec and set it as default.

deftable clj macro

(deftable table & forms)

Define a table with dynamic columns.

exec clj

(exec sqlmap & {:as opts})

Render sqlmap as sql string, then execute it. See also: exec-raw.

exec-raw clj

(exec-raw query & {:keys [db] :as opts})

Execute raw sql, either in query (select) or update mode. In the query mode, options such as :row-fn, :result-fn could be supplied to transform queried result, return seq of rows. E.g.:

(exec-raw ["SELECT * FROM user WHERE username = ? LIMIT ?" "jack" 1] :db my-db :row-fn identity)

While in update mode, return seq of number of rows affected. Phoenix does not yet support generated keys in update mode.

See also jdbc/query, jdbc/execute!.

phoenix clj

(phoenix spec)

Create an phoenix jdbc driver spec.

:zk-quorum Zookeeper quorum url, including port, default 127.0.0.1:2181 :zk-parent Zookeeper parent, default /hbase :principal Kerberos principal, optional :keytab Kerberos keytab, optional

See Phoenix FAQ.

Table clj

table* clj

(table* table)

(table* table name)

Return table name, or set table name.

table? clj

(table? table)

Test if it is a table instance.

types* clj

(types* table)

(types* table types)

(types* table k v & types)

Return column type map, or set column types of a table.