Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.db / org.gvsig.fmap.dal.db.h2 / src / main / java / org / gvsig / fmap / dal / store / h2 / expressionbuilderformatter / ILike.java @ 44304

History | View | Annotate | Download (1.42 KB)

1
package org.gvsig.fmap.dal.store.h2.expressionbuilderformatter;
2

    
3
import java.text.MessageFormat;
4
import java.util.List;
5
import org.apache.commons.lang3.StringUtils;
6
import org.gvsig.expressionevaluator.ExpressionBuilder;
7
import org.gvsig.expressionevaluator.ExpressionBuilder.Function;
8
import org.gvsig.expressionevaluator.ExpressionBuilder.Value;
9
import org.gvsig.expressionevaluator.Formatter;
10
import org.gvsig.fmap.dal.SQLBuilder;
11

    
12
/**
13
 *
14
 * @author jjdelcerro
15
 */
16
public class ILike implements Formatter<Value> {
17
    
18
    private final SQLBuilder sqlbuilder;
19
    private final Formatter<Value> formatter;
20
    
21
    public ILike(SQLBuilder sqlbuilder, Formatter<Value> formatter) {
22
        this.sqlbuilder = sqlbuilder;
23
        this.formatter = formatter;
24
    }
25
    @Override
26
    public boolean canApply(ExpressionBuilder.Value value) {
27
        if (value instanceof ExpressionBuilder.BinaryOperator) {
28
            return StringUtils.equalsIgnoreCase(ExpressionBuilder.OPERATOR_ILIKE, ((ExpressionBuilder.BinaryOperator) value).name());
29
        }
30
        return false;
31
    }
32

    
33
    @Override
34
    public String format(Value value) {
35
        ExpressionBuilder.BinaryOperator operator = (ExpressionBuilder.BinaryOperator) value;
36
        String p1 = operator.left().toString(formatter);
37
        String p2 = operator.right().toString(formatter);
38
        String r = MessageFormat.format("(lcase({0}) like lcase({1}))", p1, p2);
39
        return r;
40
    }
41
    
42
}