honey.sql.pg-ops
(source)Register all the PostgreSQL JSON/JSONB operators
and provide convenient Clojure names for those ops.
In addition, provide names for the PostgreSQL
regex operators as well.
For the eleven that cannot be written directly as
symbols, use mnemonic names: hash for #, at for @,
and tilde for ~.
For the six of those that cannot be written as
keywords, invoke the `keyword` function instead.
Those latter eight (`at>`, `<at`, `at?`, `atat`,
`tilde`, `tilde*`, `!tilde`, and `!tilde*`) are
the only ones that should really be needed in the
DSL. The other names are provided for completeness.
`regex` and `iregex` are provided as aliases for the
regex operators `tilde` and `tilde*` respectively.
`!regex` and `!iregex` are provided as aliases for the
regex operators `!tilde` and `!tilde*` respectively.
For more info about this library see:
https://cljdoc.org/d/com.github.seancorfield/honeysql/2.5.1103/doc/getting-started| Public Variable | Short Description |
|---|---|
| !iregex (clj) | |
| !regex (clj) | |
| !tilde (clj) | The case-sensitive regex unmatch operator. |
| !tilde* (clj) | The case-insensitive regex unmatch operator. |
| - (clj) | The - operator: - text value: deletes a key (and its value) from a JSON object, or matching string value(s) from a JSON array - int value: deletes the array element with specified index (negative integers count from the end). |
| -> (clj) | The -> operator for accessing nested JSON(B) values as JSON(B). |
| ->> (clj) | The ->> operator - like -> but returns the value as text instead of a JSON object. |
| <at (clj) | The <@ operator - is the first JSON value contained in the second?. |
| ? (clj) | The ? operator - does the text string exist as a top-level key or array element within the JSON value?. |
| ?& (clj) | The ?& operator - do all of the strings in the text array exist as top-level keys or array elements?. |
| ?| (clj) | The ?| operator - do any of the strings in the text array exist as top-level keys or array elements?. |
| at> (clj) | The @> operator - does the first JSON value contain the second?. |
| at? (clj) | The @? operator - does JSON path return any item for the specified JSON value?. |
| atat (clj) | The @@ operator - returns the result of a JSON path predicate check for the specified JSON value. |
| hash- (clj) | The #- operator - deletes the field or array element at the specified path, where path elements can be either field keys or array indexes. |
| hash> (clj) | The #> operator extracts JSON sub-object at the specified path. |
| hash>> (clj) | The #>> operator - like hash> but returns the value as text instead of JSON object. |
| iregex (clj) | |
| regex (clj) | |
| tilde (clj) | The case-sensitive regex match operator. |
| tilde* (clj) | The case-insensitive regex match operator. |
| || (clj) | The || operator - concatenates two jsonb values (arrays or objects; anything else treated as 1-element array). |