Package su.onno.repository

Class RegisterQueryBuilder<T extends AccumulationRecord>

java.lang.Object

su.onno.repository.RegisterQueryBuilder<T>

public class RegisterQueryBuilder<T extends AccumulationRecord>
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	RegisterQueryBuilder.QueryType
static final record	RegisterQueryBuilder.TupleInFilter	A (col1, col2, …) IN ((v1, v2, …), …) predicate over a set of dimension tuples.

Constructor Summary

Constructors

Constructor	Description
RegisterQueryBuilder(RegisterPersistence<T> persistence)

Method Summary

Modifier and Type	Method	Description
RegisterQueryBuilder<T>	at(LocalDateTime pointInTime)
RegisterQueryBuilder<T>	balance()
List<T>	execute()
RegisterQueryBuilder<T>	from(LocalDateTime from)
LocalDateTime	getAtDate()
Map<String,Object>	getFilters()
LocalDateTime	getFromDate()
List<String>	getGroupByFields()
Map<String,Collection<?>>	getInFilters()
RegisterQueryBuilder.QueryType	getQueryType()
LocalDateTime	getToDate()
List<RegisterQueryBuilder.TupleInFilter>	getTupleFilters()
<R> RegisterQueryBuilder<T>	groupBy(Field<T,R> field)
RegisterQueryBuilder<T>	to(LocalDateTime to)
RegisterQueryBuilder<T>	turnover()
<R> RegisterQueryBuilder<T>	where(Field<T,R> field, R value)
<A, B> RegisterQueryBuilder<T>	whereIn(Field<T,A> fieldA, Field<T,B> fieldB, Collection<? extends List<?>> tuples)	Restrict a pair of dimensions to a set of tuples — rendered as (colA, colB) IN ((a1, b1), (a2, b2), …).
<R> RegisterQueryBuilder<T>	whereIn(Field<T,R> field, Collection<R> values)	Restrict one dimension to a set of values — rendered as col IN (…).

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

RegisterQueryBuilder

public RegisterQueryBuilder(RegisterPersistence<T> persistence)

Method Details

balance

public RegisterQueryBuilder<T> balance()

turnover

public RegisterQueryBuilder<T> turnover()

at

public RegisterQueryBuilder<T> at(LocalDateTime pointInTime)

from

public RegisterQueryBuilder<T> from(LocalDateTime from)

to

public RegisterQueryBuilder<T> to(LocalDateTime to)

groupBy

public <R> RegisterQueryBuilder<T> groupBy(Field<T,R> field)

where

public <R> RegisterQueryBuilder<T> where(Field<T,R> field,
 R value)

whereIn

public <R> RegisterQueryBuilder<T> whereIn(Field<T,R> field,
 Collection<R> values)

Restrict one dimension to a set of values — rendered as col IN (…). Lets a caller read balances for exactly the dimension values on a document in a single query instead of fetching the whole slice and filtering in Java. An empty collection matches no rows. Values may be raw column values or Refs (unwrapped to their id).

whereIn

public <A,
B> RegisterQueryBuilder<T> whereIn(Field<T,A> fieldA,
 Field<T,B> fieldB,
 Collection<? extends List<?>> tuples)

Restrict a pair of dimensions to a set of tuples — rendered as (colA, colB) IN ((a1, b1), (a2, b2), …). This is the register-read analog of 1C's Остатки(…, (dimA, dimB) В (…)): fetch balances for exactly a document's (dimA, dimB) pairs in one query. An empty collection matches no rows.

execute

public List<T> execute()

getQueryType

public RegisterQueryBuilder.QueryType getQueryType()

getAtDate

public LocalDateTime getAtDate()

getFromDate

public LocalDateTime getFromDate()

getToDate

public LocalDateTime getToDate()

getGroupByFields

public List<String> getGroupByFields()

getFilters

public Map<String,Object> getFilters()

getInFilters

public Map<String,Collection<?>> getInFilters()

getTupleFilters

public List<RegisterQueryBuilder.TupleInFilter> getTupleFilters()