Selecto v0.3.14

Selecto.Subfilter.SQL.AnyAllBuilder (Selecto v0.3.14)

Builds ANY and ALL subqueries for subfilters.

These strategies are useful for more complex comparisons against a set of values returned by a subquery.

example-sql-any

 Example SQL (ANY) 

release_year > ANY (
  SELECT year
  FROM special_release_years
)

example-sql-all

 Example SQL (ALL) 

rating > ALL (
  SELECT rating
  FROM competing_films
)

Link to this section Summary

Functions

generate(type, spec, join_resolution, registry)

Generate ANY or ALL subquery SQL for a given subfilter.

Link to this section Functions

Link to this function

generate(type, spec, join_resolution, registry)

@spec generate(
  :any | :all,
  Selecto.Subfilter.Spec.t(),
  Selecto.Subfilter.JoinPathResolver.JoinResolution.t(),
  any()
) :: {:ok, String.t(), [any()]} | {:error, Selecto.Subfilter.Error.t()}

Generate ANY or ALL subquery SQL for a given subfilter.