fx.repo.pg — io.github.parencat/fx 0.1.5

->column-name clj

(->column-name entity field-name)

Add quoting for table name if field spec include :wrap flag

->pg-interval clj

(->pg-interval duration)

Takes a Duration instance and converts it into a PGInterval instance where the interval is created as a number of seconds.

->pgobject clj

(->pgobject x)

Transforms Clojure data to a PGobject that contains the data as JSON. PGObject type defaults to jsonb but can be changed via metadata key :pgtype

<-pg-interval clj

(<-pg-interval interval)

Takes a PGInterval instance and converts it into a Duration instance. Ignore sub-second units.

<-pgobject clj

(<-pgobject v)

Transform PGobject containing json or jsonb value to Clojure data.

coerce-nested-records clj

(coerce-nested-records entity record)

Nested records returned as JSON. This function will use nested entity spec to coerce record fields

column-name? clj

entity-columns clj

(entity-columns entity)

Collect columns names as keywords

entity-select-query clj

(entity-select-query entity fields nested)

Build the main entity SQL query as HoneySQL DSL

field-params? clj

get-refs-list clj

(get-refs-list entity nested)

Returns the list of ref fields. nest param is used to control which fields are required

lift-value clj

(lift-value x)

Wraps vector or map with :lift operator to store them as json

nested-params? clj

pg-delete! clj

(pg-delete! database entity {:keys [where] :as params})

Delete record from database

pg-find! clj

(pg-find! database entity {:keys [fields where nested] :as params})

Get single record from the database

pg-find-all! clj

(pg-find-all! database
              entity
              {:keys [fields where order-by limit offset nested] :as params})

Return multiple records from the database

pg-save! clj

(pg-save! database entity data)

Save record in database

pg-save-all! clj

(pg-save-all! database entity data)

Save records in database

pg-update! clj

(pg-update! database entity data {:keys [where] :as params})

Update record in database

prep-data clj

(prep-data entity data)

Builds a list of columns names and respective values based on the field schema

prep-data-map clj

(prep-data-map entity data)

prep-join-query clj

(prep-join-query {:keys [entity ref table-name ref-key ref-name nested]})

Returns a SQL query vector to join rows from the referenced table

prep-json-query clj

(prep-json-query {:keys [ref table-name ref-name join-query]})

Takes the join query for nested tables and wraps it with SQL query to convert nested records into JSON

prep-value clj

(prep-value field-schema v)

simple-val-or-nested-entity? clj

(simple-val-or-nested-entity? field-schema)

Predicate function to check if field spec refers to a simple data type or json field or mandatory dependency entity

where-clause clj

(where-clause where-clauses eq-clauses)

wrap-coalesce clj

(wrap-coalesce query)

Wrap query with coalesce expression