metabase.util.honeysql — metabase/honeysql-util 1.0.1

* clj

(* & exprs)

Math operator. Interpose * between exprs and wrap in parentheses.

+ clj

(+ & exprs)

Math operator. Interpose + between exprs and wrap in parentheses.

- clj

(- & exprs)

Math operator. Interpose - between exprs and wrap in parentheses.

->boolean clj

(->boolean x)

CAST x to a boolean datatype

->date clj

(->date x)

CAST x to a date.

->datetime clj

(->datetime x)

CAST x to a datetime.

->integer clj

(->integer x)

CAST x to a integer.

->time clj

(->time x)

CAST x to a time datatype

->timestamp clj

(->timestamp x)

CAST x to a timestamp.

->timestamp-with-time-zone clj

(->timestamp-with-time-zone x)

CAST x to a timestamp with time zone.

/ clj

(/ & exprs)

Math operator. Interpose / between exprs and wrap in parentheses.

cast clj

(cast c x)

Generate a statement like cast(x AS c).

concat clj

(concat & exprs)

SQL concat function.

day clj

(day & exprs)

SQL day function.

dec clj

(dec x)

Subtract 1 from x.

floor clj

(floor & exprs)

SQL floor function.

format clj

(format format-str expr)

SQL format function.

hour clj

(hour & exprs)

SQL hour function.

identifier clj

(identifier identifier-type & components)

Inputs: [identifier-type :- IdentifierType & components] Returns: Identifier

Define an identifer of type with components. Prefer this to using keywords for identifiers, as those do not properly handle identifiers with slashes in them.

identifier-type represents the type of identifier in question, which is important context for some drivers, such as BigQuery (which needs to qualify Tables identifiers with their dataset name.)

This function automatically unnests any Identifiers passed as arguments, removes nils, and converts all args to strings.

IdentifierType clj

Schema for valid Identifier types.

inc clj

(inc x)

Add 1 to x.

literal clj

(literal s)

Wrap keyword or string s in single quotes and a HoneySQL raw form.

We'll try to escape single quotes in the literal, unless they're already escaped (either as '' or as \, but this won't handle wacky cases like three single quotes in a row. Don't use literal for things that might be wacky. Only use it for things that are hardcoded.

minute clj

(minute & exprs)

SQL minute function.

mod clj

(mod & exprs)

Math operator. Interpose % between exprs and wrap in parentheses.

month clj

(month & exprs)

SQL month function.

quarter clj

(quarter & exprs)

SQL quarter function.

quoted-cast clj

(quoted-cast c x)

Generate a statement like cast(x AS "c").

Like cast but quotes the type C. This is useful for cases where we deal with user-defined types or other types that may have a space in the name, for example Postgres enum types.

round clj

(round x decimal-places)

SQL round function.

week clj

(week & exprs)

SQL week function.

year clj

(year & exprs)

SQL year function.