public class ColumnReference
extends java.lang.Object
Basically, it lets you write a query like this:
table.selectWhere(column("foo").isEqualTo("Bar"));
In that example, column() is a static method that returns a ColumnReference for a column named "foo". The method isEqualTo(), is implemented on ColumnReference in a way that it can be applied to potentially, multiple column types, although in this case, it only makes sense for CategoryColumns since the argument is a string.
When selectWhere() isExecuted, it supplies the table to the ColumnReference. The ColumnReference uses the table and columnName to get access to the right column, and then fulfils its role by ensuring that the filtering "isEqualTo("Bar") is applied to all the cells in the column.
| Constructor and Description |
|---|
ColumnReference(java.lang.String column) |
public Filter isNotMissing()
public Filter isMissing()
public Filter isEqualTo(int value)
public Filter isEqualTo(ColumnReference reference)
public Filter isBetween(int low, int high)
public Filter isBetween(java.time.LocalDate low, java.time.LocalDate high)
public Filter isEqualTo(float value)
public Filter isEqualTo(java.time.LocalTime value)
public Filter isEqualTo(java.time.LocalDate value)
public Filter isEqualTo(java.lang.String value)
public Filter isNotEqualTo(java.lang.String value)
public Filter isGreaterThan(int value)
public Filter isIn(java.lang.String... strings)
public Filter isIn(int... ints)
public Filter isLessThan(int value)
public Filter isLessThanOrEqualTo(int value)
public Filter isGreaterThanOrEqualTo(int value)
public Filter isGreaterThan(float value)
public Filter isLessThan(float value)
public Filter isLessThanOrEqualTo(float value)
public Filter isGreaterThanOrEqualTo(float value)
public java.lang.String getColumnName()
public Filter isMidnight()
public Filter isNoon()
public Filter isBeforeNoon()
public Filter isAfterNoon()
public Filter isBefore(java.time.LocalTime value)
public Filter isBefore(java.time.LocalDateTime value)
public Filter isAfter(java.time.LocalTime value)
public Filter isSunday()
public Filter isMonday()
public Filter isTuesday()
public Filter isWednesday()
public Filter isThursday()
public Filter isFriday()
public Filter isSaturday()
public Filter isInJanuary()
public Filter isInFebruary()
public Filter isInMarch()
public Filter isInApril()
public Filter isInMay()
public Filter isInJune()
public Filter isInJuly()
public Filter isInAugust()
public Filter isInSeptember()
public Filter isInOctober()
public Filter isInNovember()
public Filter isInDecember()
public Filter isInQ1()
public Filter isInQ2()
public Filter isInQ3()
public Filter isInQ4()
public Filter isFirstDayOfMonth()
public Filter isLastDayOfMonth()
public Filter isInYear(int year)
public Filter isBefore(java.time.LocalDate date)
public Filter isAfter(java.time.LocalDate date)
public Filter isUpperCase()
public Filter isLowerCase()
public Filter isAlpha()
public Filter isAlphaNumeric()
public Filter isNumeric()
public Filter isEmpty()
public Filter isLongerThan(int length)
public Filter isShorterThan(int length)
public Filter hasLengthEqualTo(int length)
public Filter equalToIgnoringCase(java.lang.String string)
public Filter startsWith(java.lang.String string)
public Filter endsWith(java.lang.String string)
public Filter contains(java.lang.String string)
public Filter matchesRegex(java.lang.String string)
public Filter isTrue()
public Filter isFalse()