trait QueryStrategy extends AnyRef

Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. QueryStrategy
  2. AnyRef
  3. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Abstract Value Members

  1. abstract def arrayContains(arrayColumnName: String, elementColumnName: String): String

    Predicate which tests if the element referenced by the elementColumnName is in the array from column arrayColumnName

  2. abstract def arrayIntersectionNonEmptyClause(columnName: String, internedParties: Set[Int]): CompositeSql

    An expression resulting to a boolean to check whether:

    An expression resulting to a boolean to check whether:

    • the party set defined by columnName and
    • the party set defined by parties have at least one element in common (eg their intersection is non empty).
    columnName

    the SQL table definition which holds the set of parties

    internedParties

    set of parties (their interned names)

    returns

    the composable SQL

  3. abstract def constBooleanSelect(value: Boolean): String

    Constant boolean to be used in a SELECT clause

  4. abstract def constBooleanWhere(value: Boolean): String

    Constant boolean to be used in a WHERE clause

  5. abstract def isTrue(booleanColumnName: String): String

    Boolean predicate

Concrete Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##: Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. def anyOf(longs: Iterable[Long]): CompositeSql

    ANY SQL clause generation for a number of Long values

  5. def anyOfStrings(strings: Iterable[String]): CompositeSql

    ANY SQL clause generation for a number of Long values

  6. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  7. def booleanOrAggregationFunction: String

    Would be used in column selectors in GROUP BY situations to see whether a boolean column had true Example: getting all groups and see wheter they have someone who had covid: SELECT group_name, booleanOrAggregationFunction(has_covid) GROUP BY group_name;

    Would be used in column selectors in GROUP BY situations to see whether a boolean column had true Example: getting all groups and see wheter they have someone who had covid: SELECT group_name, booleanOrAggregationFunction(has_covid) GROUP BY group_name;

    returns

    the function name

  8. def clone(): AnyRef
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.CloneNotSupportedException]) @native() @IntrinsicCandidate()
  9. def columnEqualityBoolean(column: String, value: String): String

    An expression resulting to a boolean, to check equality between two SQL expressions

    An expression resulting to a boolean, to check equality between two SQL expressions

    returns

    plain SQL which fits the query template

  10. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  11. def equals(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef → Any
  12. final def getClass(): Class[_ <: AnyRef]
    Definition Classes
    AnyRef → Any
    Annotations
    @native() @IntrinsicCandidate()
  13. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native() @IntrinsicCandidate()
  14. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  15. def lastByProxyAggregateFuction(singletonColumn: String, orderingColumn: String): String

    Select a singleton element from some column based on max value of another column

    Select a singleton element from some column based on max value of another column

    singletonColumn

    column whose value should be returned when the orderingColumn hits max

    orderingColumn

    column used for sorting the input rows

    returns

    an sql clause to be composed into the sql query

  16. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  17. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native() @IntrinsicCandidate()
  18. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native() @IntrinsicCandidate()
  19. def offsetIsBetween(nonNullableColumn: String, startExclusive: Offset, endInclusive: Offset): CompositeSql

    Expression for (startExclusive < offset <= endExclusive)

    Expression for (startExclusive < offset <= endExclusive)

    The offset column must only contain valid offsets (no NULL, no Offset.beforeBegin)

  20. def offsetIsGreater(nonNullableColumn: String, startExclusive: Offset): CompositeSql

    Expression for (offset > startExclusive)

    Expression for (offset > startExclusive)

    The offset column must only contain valid offsets (no NULL, no Offset.beforeBegin)

  21. def offsetIsSmallerOrEqual(nonNullableColumn: String, endInclusive: Offset): CompositeSql

    Expression for (offset <= endInclusive)

    Expression for (offset <= endInclusive)

    The offset column must only contain valid offsets (no NULL, no Offset.beforeBegin)

  22. final def synchronized[T0](arg0: => T0): T0
    Definition Classes
    AnyRef
  23. def toString(): String
    Definition Classes
    AnyRef → Any
  24. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  25. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException]) @native()
  26. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])

Deprecated Value Members

  1. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.Throwable]) @Deprecated @Deprecated
    Deprecated

Inherited from AnyRef

Inherited from Any

Ungrouped