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 | 44198 | jjdelcerro | 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 | } |