object QueryStrategy
- Alphabetic
- By Inheritance
- QueryStrategy
- AnyRef
- Any
- Hide All
- Show All
- Public
- Protected
Value Members
- final def !=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def ##: Int
- Definition Classes
- AnyRef → Any
- final def ==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- 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
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @IntrinsicCandidate() @native()
- def constBooleanSelect(value: Boolean): String
Constant boolean to be used in a SELECT clause
- def constBooleanWhere(value: Boolean): String
Constant boolean to be used in a WHERE clause
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- def eventSeqIdIsGreater(nonNullableColumn: String, limitO: Option[Long]): CompositeSql
Expression for
(eventSeqId > limit)
Expression for
(eventSeqId > limit)
The column must only contain valid integers (no NULLs)
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @IntrinsicCandidate() @native()
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @IntrinsicCandidate() @native()
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- 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
- def limitClause(limit: Option[Int]): CompositeSql
This populates the following part of the query: SELECT ...
This populates the following part of the query: SELECT ... WHERE ... ORDER BY ... [THIS PART]
- limit
optional limit
- returns
the composable SQL
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @IntrinsicCandidate() @native()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @IntrinsicCandidate() @native()
- def offsetIsBetween(nonNullableColumn: String, startInclusive: Offset, endInclusive: Offset): CompositeSql
Expression for
(startInclusive <= offset <= endExclusive)
Expression for
(startInclusive <= offset <= endExclusive)
The offset column must only contain valid offsets (no NULLs)
- def offsetIsGreater(nonNullableColumn: String, startExclusive: Option[Offset]): CompositeSql
Expression for
(offset > startExclusive)
Expression for
(offset > startExclusive)
The offset column must only contain valid offsets (no NULLs)
- def offsetIsLessOrEqual(nonNullableColumn: String, endInclusiveO: Option[Offset]): CompositeSql
Expression for
(offset <= endInclusive)
Expression for
(offset <= endInclusive)
The offset column must only contain valid offsets (no NULLs)
- final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- def toString(): String
- Definition Classes
- AnyRef → Any
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])