ru.curs.celesta.dbutils.term.RangeTerm Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of celesta-core Show documentation

The newest version!

package ru.curs.celesta.dbutils.term;


import ru.curs.celesta.dbutils.QueryBuildingHelper;
import ru.curs.celesta.dbutils.filter.Range;
import ru.curs.celesta.dbutils.stmt.ParameterSetter;

import java.util.List;

/**
 * 'Setrange' filter term with 'from.. to' values.
 */
public final class RangeTerm extends WhereTerm {
    // unquoted column name
    private final String fieldName;
    private final Range filter;

    public RangeTerm(String fieldName, Range filter) {
        this.fieldName = fieldName;
        this.filter = filter;
    }

    @Override
    public String getWhere() {
        return String.format("(\"%s\" between ? and ?)", fieldName);
    }

    @Override
    public void programParams(List program, QueryBuildingHelper queryBuildingHelper) {
        program.add(ParameterSetter.createForValueFrom(filter, queryBuildingHelper));
        program.add(ParameterSetter.createForValueTo(filter, queryBuildingHelper));
    }
}