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.
(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:
All value filters work on nested fields:
parent.child = 'foo'
Trailing options can be any of:
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>
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |