1 | public class HSQLCaseFragment extends CaseFragment {↵ | | 1 | public class MckoiCaseFragment extends CaseFragment {↵
|
|
2 | public String toFragmentString() {↵ | | 2 | public String toFragmentString() {↵
|
3 | StringBuffer buf = new StringBuffer( cases.size() * 15 + 10 );↵ | | 3 | StringBuffer buf = new StringBuffer( cases.size() * 15 + 10 );↵
|
4 | StringBuffer buf2 = new StringBuffer( cases.size() );↵ | | 4 | StringBuffer buf2= new StringBuffer( cases.size() );↵
|
|
5 | Iterator iter = cases.entrySet().iterator();↵ | | 5 | Iterator iter = cases.entrySet().iterator();↵
|
6 | while ( iter.hasNext() ) {↵ | | 6 | while ( iter.hasNext() ) {↵
|
7 | Map.Entry me = (Map.Entry) iter.next();↵ | | 7 | Map.Entry me = (Map.Entry) iter.next();↵
|
8 | buf.append(" casewhen(")↵ | | 8 | buf.append(" if(")↵
|
9 | .append( me.getKey() )↵ | | 9 | .append( me.getKey() )↵
|
10 | .append(" is not null")↵ | | 10 | .append(" is not null")↵
|
11 | .append(", ")↵ | | 11 | .append(", ")↵
|
12 | .append( me.getValue() )↵ | | 12 | .append( me.getValue() )↵
|
13 | .append(", ");↵ | | 13 | .append(", ");↵
|
14 | buf2.append(")");↵ | | 14 | buf2.append(")");↵
|
15 | }↵ | | 15 | }↵
|
|
16 | buf.append("-1"); //null caused some problems↵ | | 16 | buf.append("null");↵
|
17 | buf.append( buf2.toString() );↵ | | 17 | buf.append(buf2);↵
|
18 | if ( returnColumnName!=null ) {↵ | | 18 | if (returnColumnName!=null) {↵
|
19 | buf.append(" as ")↵ | | 19 | buf.append(" as ")↵
|
20 | .append(returnColumnName);↵ | | 20 | .append(returnColumnName);↵
|
21 | }↵ | | 21 | }↵
|
|
22 | return buf.toString() | | 22 | return buf.toString()
|