Liking cljdoc? Tell your friends :D
Clojure only.

exoscale.vinyl.sql

Small facade for vinyl to perform simple SQL queries. See list-query for syntax details.

Small facade for vinyl to perform simple SQL queries. See `list-query`
for syntax details.
raw docstring

list-queryclj

(list-query store q)
(list-query store q opts)

Acts as exoscale.vinyl.store/list-query but accepts strings queries written in a subset of SQL.

Queries take the following form:

 SELECT * FROM <record-type> <filters> <options>

No field selection can be done, queries must start with 'SELECT *'. Record types are not checked at query parsing time.

Supported filters:

  • field comparisons: field = value, field != value, field starts with 'prefix'
  • field presence test: field is null, field is not null
  • field set membership: field in ( 1, 2, 3)
  • integer comparisons: field > val, field < val, field >= val, field <= val
  • logical operations: field = v1 or vield = v2 and state = 'disabled'
  • grouping: (field = v1 or field = v2)
  • group negation: !(field = v1 or field = v2)

All value filters work on nested fields:

parent.child = 'foo'

Trailing options can be any of:

  • LIMIT <number>
  • SKIP <number>
Acts as `exoscale.vinyl.store/list-query` but accepts strings queries
written in a subset of SQL.

Queries take the following form:

     SELECT * FROM <record-type> <filters> <options>

No field selection can be done, queries **must** start with 'SELECT *'.
Record types are not checked at query parsing time.

Supported filters:

- field comparisons: field = value, field != value, field starts with 'prefix'
- field presence test: field is null, field is not null
- field set membership: field in ( 1, 2, 3)
- integer comparisons: field > val, field < val, field >= val, field <= val
- logical operations: field = v1 or vield = v2 and state = 'disabled'
- grouping: (field = v1 or field = v2)
- group negation: !(field = v1 or field = v2)

All value filters work on nested fields:

  parent.child = 'foo'

Trailing options can be any of:

- LIMIT <number>
- SKIP <number>
raw docstring

cljdoc is a website building & hosting documentation for Clojure/Script libraries

× close