001/*
002 * (C) Copyright 2006-2012 Nuxeo SA (http://nuxeo.com/) and others.
003 *
004 * Licensed under the Apache License, Version 2.0 (the "License");
005 * you may not use this file except in compliance with the License.
006 * You may obtain a copy of the License at
007 *
008 *     http://www.apache.org/licenses/LICENSE-2.0
009 *
010 * Unless required by applicable law or agreed to in writing, software
011 * distributed under the License is distributed on an "AS IS" BASIS,
012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013 * See the License for the specific language governing permissions and
014 * limitations under the License.
015 *
016 * Contributors:
017 *     Arnaud Kervern <akervern@nuxeo.com>
018 */
019
020package org.nuxeo.ecm.directory.sql.filter;
021
022import org.nuxeo.ecm.core.storage.sql.jdbc.db.Column;
023import org.nuxeo.ecm.directory.DirectoryException;
024
025import java.sql.PreparedStatement;
026import java.sql.SQLException;
027import java.util.Calendar;
028
029/**
030 * Make a BETWEEN SQL predicate
031 *
032 * @since 5.7
033 */
034public class SQLBetweenFilter extends SQLComplexFilter {
035
036    private Calendar from;
037
038    private Calendar to;
039
040    public SQLBetweenFilter(Calendar from, Calendar to) {
041        super("BETWEEN");
042        this.from = from;
043        this.to = to;
044    }
045
046    @Override
047    public int doSetFieldValue(PreparedStatement ps, int index, Column column) throws SQLException {
048        column.setToPreparedStatement(ps, index, from);
049        column.setToPreparedStatement(ps, index + 1, to);
050        return index + 2;
051    }
052
053    @Override
054    public String getRightSide() {
055        return "? AND ?";
056    }
057}