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 / IfNull.java @ 44198

History | View | Annotate | Download (1.75 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.Code.Constant;
7
import org.gvsig.expressionevaluator.ExpressionBuilder;
8
import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_IFNULL;
9
import org.gvsig.expressionevaluator.ExpressionBuilder.Function;
10
import static org.gvsig.expressionevaluator.ExpressionBuilder.OPERATOR_IS;
11
import org.gvsig.expressionevaluator.ExpressionBuilder.Value;
12
import org.gvsig.expressionevaluator.Formatter;
13
import org.gvsig.fmap.dal.SQLBuilder;
14

    
15
/**
16
 *
17
 * @author jjdelcerro
18
 */
19
class IfNull implements Formatter<Value> {
20

    
21
    private final Formatter<Value> formatter;
22
    private final SQLBuilder builder;
23
    
24
    public IfNull(SQLBuilder builder, Formatter<Value> formatter) {
25
        this.builder = builder;
26
        this.formatter = formatter;
27
    }
28
    
29
    @Override
30
    public boolean canApply(Value value) {
31
        if (value instanceof Function) {
32
            if (value instanceof ExpressionBuilder.Function) {
33
                return StringUtils.equalsIgnoreCase(FUNCTION_IFNULL, ((Function) value).name());
34
            }
35
        }
36
        return false;
37
    }
38

    
39
    @Override
40
    public String format(Value function) {
41
            List<Value> parameters = ((Function) function).parameters();
42
            String p1 = parameters.get(0).toString(formatter);
43
            String p2 = parameters.get(1).toString(formatter);
44
            String p3 = parameters.get(2).toString(formatter);
45
            String r = MessageFormat.format(
46
                    "NVL2({0}, {1}, {2})",
47
                    p1,
48
                    p3,
49
                    p2
50
            );
51
            return r;
52
    }
53
    
54
}