Revision 46011
| trunk/org.gvsig.desktop/org.gvsig.desktop.library/org.gvsig.expressionevaluator/org.gvsig.expressionevaluator.lib/org.gvsig.expressionevaluator.lib.impl/src/test/java/org/gvsig/expresionevaluator/impl/TestGrammarCompiler.java | ||
|---|---|---|
| 264 | 264 |
|
| 265 | 265 |
Code code = compiler.compileExpression(source); |
| 266 | 266 |
link(code); |
| 267 |
assertEquals("CASE((\"software\" LIKE '%gvSIG%'), 'gvSIG', 'Other')", code.toString());
|
|
| 267 |
assertEquals("CASE WHEN (\"software\" LIKE '%gvSIG%') THEN 'gvSIG' ELSE 'Other' END", code.toString());
|
|
| 268 | 268 |
} |
| 269 | 269 |
|
| 270 | 270 |
public void testCase1() {
|
| ... | ... | |
| 274 | 274 |
|
| 275 | 275 |
Code code = compiler.compileExpression(source); |
| 276 | 276 |
link(code); |
| 277 |
assertEquals("CASE((\"software\" LIKE '%gvSIG%'), 'gvSIG', 'Other')", code.toString());
|
|
| 277 |
assertEquals("CASE WHEN (\"software\" LIKE '%gvSIG%') THEN 'gvSIG' ELSE 'Other' END", code.toString());
|
|
| 278 | 278 |
} |
| 279 | 279 |
|
| 280 | 280 |
public void testCase2() {
|
| ... | ... | |
| 284 | 284 |
|
| 285 | 285 |
Code code = compiler.compileExpression(source); |
| 286 | 286 |
link(code); |
| 287 |
assertEquals("CASE(((\"Field_1\" >= 75) AND (\"Field_1\" <= 79)), ((\"Field_1\" >= 80) AND (\"Field_1\" <= 84)), 100, 110)", code.toString());
|
|
| 287 |
assertEquals("CASE WHEN ((\"Field_1\" >= 75) AND (\"Field_1\" <= 79)) THEN 100 WHEN ((\"Field_1\" >= 80) AND (\"Field_1\" <= 84)) THEN 110 END", code.toString());
|
|
| 288 | 288 |
} |
| 289 | 289 |
|
| 290 | 290 |
public void testCase3() {
|
| ... | ... | |
| 294 | 294 |
|
| 295 | 295 |
Code code = compiler.compileExpression(source); |
| 296 | 296 |
link(code); |
| 297 |
assertEquals("CASE(((\"Field_1\" >= 75) AND (\"Field_1\" <= 79)), ((\"Field_1\" >= 80) AND (\"Field_1\" <= 84)), 100, 110, 120)", code.toString());
|
|
| 297 |
assertEquals("CASE WHEN ((\"Field_1\" >= 75) AND (\"Field_1\" <= 79)) THEN 100 WHEN ((\"Field_1\" >= 80) AND (\"Field_1\" <= 84)) THEN 110 ELSE 120 END", code.toString());
|
|
| 298 | 298 |
} |
| 299 | 299 |
|
| 300 |
public void testCase3b() {
|
|
| 301 |
String source = "CASE WHEN Field_1 >= 75 AND Field_1 <=79 THEN 100; WHEN Field_1 >=80 AND Field_1 <=84 THEN 110; ELSE 120; END CASE"; // ;) |
|
| 302 |
|
|
| 303 |
Compiler compiler = createCompiler(); |
|
| 304 |
Code code = compiler.compileExpression(source); |
|
| 305 |
link(code); |
|
| 306 |
assertEquals("CASE WHEN ((\"Field_1\" >= 75) AND (\"Field_1\" <= 79)) THEN 100 WHEN ((\"Field_1\" >= 80) AND (\"Field_1\" <= 84)) THEN 110 ELSE 120 END", code.toString());
|
|
| 307 |
code = compiler.compileExpression(code.toString()); |
|
| 308 |
link(code); |
|
| 309 |
assertEquals("CASE WHEN ((\"Field_1\" >= 75) AND (\"Field_1\" <= 79)) THEN 100 WHEN ((\"Field_1\" >= 80) AND (\"Field_1\" <= 84)) THEN 110 ELSE 120 END", code.toString());
|
|
| 310 |
} |
|
| 311 |
|
|
| 300 | 312 |
public void testDef1() {
|
| 301 | 313 |
String source = "CREATE PROCEDURE test1 AS BEGIN print('Hola'); END PROCEDURE";
|
| 302 | 314 |
|
Also available in: Unified diff