Uses of Interface
group.worldstandard.pudel.api.database.QueryBuilder

Packages that use QueryBuilder

Package	Description
group.worldstandard.pudel.api.database	Plugin data persistence and database management API.

Uses of QueryBuilder in group.worldstandard.pudel.api.database

Methods in group.worldstandard.pudel.api.database that return QueryBuilder

Modifier and Type	Method	Description
QueryBuilder<T>	QueryBuilder.limit(int limit)	Limit the number of results.
QueryBuilder<T>	QueryBuilder.offset(int offset)	Skip a number of results.
QueryBuilder<T>	QueryBuilder.orderBy(String column, boolean ascending)	Add ordering.
default QueryBuilder<T>	QueryBuilder.orderByAsc(String column)	Add ascending ordering.
default QueryBuilder<T>	QueryBuilder.orderByDesc(String column)	Add descending ordering.
QueryBuilder<T>	PluginRepository.query()	Create a query builder for more complex queries.
QueryBuilder<T>	QueryBuilder.where(String column, Object value)	Add an equality condition (column = value).
QueryBuilder<T>	QueryBuilder.whereBetween(String column, Object start, Object end)	Add a BETWEEN condition (column BETWEEN start AND end).
QueryBuilder<T>	QueryBuilder.whereGreaterThan(String column, Object value)	Add a greater-than condition (column > value).
QueryBuilder<T>	QueryBuilder.whereGreaterThanOrEqual(String column, Object value)	Add a greater-than-or-equal condition (column >= value).
QueryBuilder<T>	QueryBuilder.whereILike(String column, String pattern)	Add a case-insensitive LIKE condition.
QueryBuilder<T>	QueryBuilder.whereIn(String column, List<?> values)	Add an IN condition (column IN (values)).
QueryBuilder<T>	QueryBuilder.whereLessThan(String column, Object value)	Add a less-than condition (column < value).
QueryBuilder<T>	QueryBuilder.whereLessThanOrEqual(String column, Object value)	Add a less-than-or-equal condition (column <= value).
QueryBuilder<T>	QueryBuilder.whereLike(String column, String pattern)	Add a LIKE condition for pattern matching.
QueryBuilder<T>	QueryBuilder.whereNot(String column, Object value)	Add a not-equal condition (column !
QueryBuilder<T>	QueryBuilder.whereNotIn(String column, List<?> values)	Add a NOT IN condition.
QueryBuilder<T>	QueryBuilder.whereNotNull(String column)	Add an IS NOT NULL condition.
QueryBuilder<T>	QueryBuilder.whereNull(String column)	Add an IS NULL condition.