object PostgresQueryStrategy extends QueryStrategy
- Alphabetic
- By Inheritance
- PostgresQueryStrategy
- 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
- def anyOf(longs: Iterable[Long]): CompositeSql
ANY SQL clause generation for a number of Long values
ANY SQL clause generation for a number of Long values
- Definition Classes
- PostgresQueryStrategy → QueryStrategy
- def anyOfStrings(strings: Iterable[String]): CompositeSql
ANY SQL clause generation for a number of Long values
ANY SQL clause generation for a number of Long values
- Definition Classes
- PostgresQueryStrategy → QueryStrategy
- def arrayContains(arrayColumnName: String, elementColumnName: String): String
Predicate which tests if the element referenced by the
elementColumnNameis in the array from columnarrayColumnNamePredicate which tests if the element referenced by the
elementColumnNameis in the array from columnarrayColumnName- Definition Classes
- PostgresQueryStrategy → QueryStrategy
- 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
- Definition Classes
- PostgresQueryStrategy → QueryStrategy
- 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
- Definition Classes
- QueryStrategy
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @native() @IntrinsicCandidate()
- 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
- Definition Classes
- QueryStrategy
- def constBooleanSelect(value: Boolean): String
Constant boolean to be used in a SELECT clause
Constant boolean to be used in a SELECT clause
- Definition Classes
- PostgresQueryStrategy → QueryStrategy
- def constBooleanWhere(value: Boolean): String
Constant boolean to be used in a WHERE clause
Constant boolean to be used in a WHERE clause
- Definition Classes
- PostgresQueryStrategy → QueryStrategy
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @native() @IntrinsicCandidate()
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native() @IntrinsicCandidate()
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- def isTrue(booleanColumnName: String): String
Boolean predicate
Boolean predicate
- Definition Classes
- PostgresQueryStrategy → QueryStrategy
- 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
- Definition Classes
- QueryStrategy
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @IntrinsicCandidate()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @IntrinsicCandidate()
- 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)
- Definition Classes
- QueryStrategy
- 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)
- Definition Classes
- QueryStrategy
- 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)
- Definition Classes
- QueryStrategy
- 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])