Examples of CaseExpression

com.puppetlabs.geppetto.pp.CaseExpression
A representation of the model object 'Case Expression'.
The following features are supported:
- {@link com.puppetlabs.geppetto.pp.CaseExpression#getSwitchExpr Switch Expr}
- {@link com.puppetlabs.geppetto.pp.CaseExpression#getCases Cases}
@see com.puppetlabs.geppetto.pp.PPPackage#getCaseExpression() @model @generated
com.salesforce.phoenix.expression.CaseExpression
CASE/WHEN expression implementation @author jtaylor @since 0.1
net.sf.jsqlparser.expression.CaseExpression
a.vcu.edu/db2help/db2s0/frame3.htm#casexp http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/commands/@ebt-link;pt=5954?target=%25N%15_52628_START_RESTART_N%25 @author Havard Rast Blok
org.apache.phoenix.expression.CaseExpression
CASE/WHEN expression implementation @since 0.1
org.datanucleus.store.rdbms.sql.expression.CaseExpression
Expression representing the SQL construct
```
CASE WHEN expr1 THEN val1 WHEN expr2 THEN val2 ELSE valN END
```
.
org.eclipse.persistence.jpa.jpql.parser.CaseExpression

BNF: general_case_expression ::= CASE when_clause {when_clause}* ELSE scalar_expression END or
BNF: simple_case_expression ::= CASE case_operand simple_when_clause {simple_when_clause}* ELSE scalar_expression END
@version 2.4.2 @since 2.3 @author Pascal Filion
org.teiid.query.sql.symbol.CaseExpression

Examples of org.eclipse.persistence.jpa.jpql.parser.CaseExpression


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      CaseExpression expression = stateObject.getExpression();


      // 'CASE'
      appendIdentifier((expression != null) ? expression.getActualCaseIdentifier() : CASE, CASE);


      if (shouldOutput(expression) || expression.hasSpaceAfterCase()) {
        writer.append(SPACE);
      }


      // Case operand
      if (stateObject.hasCaseOperand()) {
        stateObject.getCaseOperand().accept(this);


        if (shouldOutput(expression) || expression.hasSpaceAfterCaseOperand()) {
          writer.append(SPACE);
        }
      }


      // WHEN clauses
      if (stateObject.hasItems()) {
        toStringChildren(stateObject, false);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterWhenClauses()) {
        writer.append(SPACE);
      }


      // 'ELSE'
      if (shouldOutput(expression) || expression.hasElse()) {
        appendIdentifier((expression != null) ? expression.getActualElseIdentifier() : ELSE, ELSE);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterElse()) {
        writer.append(SPACE);
      }


      // Else expression
      if (stateObject.hasElse()) {
        stateObject.getElse().accept(this);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterElseExpression()) {
        writer.append(SPACE);
      }


      // END
      if (shouldOutput(expression) || expression.hasEnd()) {
        appendIdentifier((expression != null) ? expression.getActualEndIdentifier() : END, END);
      }
    }
  }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.CaseExpression


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      CaseExpression expression = stateObject.getExpression();


      // 'CASE'
      appendIdentifier((expression != null) ? expression.getActualCaseIdentifier() : CASE, CASE);


      if (shouldOutput(expression) || expression.hasSpaceAfterCase()) {
        writer.append(SPACE);
      }


      // Case operand
      if (stateObject.hasCaseOperand()) {
        stateObject.getCaseOperand().accept(this);


        if (shouldOutput(expression) || expression.hasSpaceAfterCaseOperand()) {
          writer.append(SPACE);
        }
      }


      // WHEN clauses
      if (stateObject.hasItems()) {
        toStringChildren(stateObject, false);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterWhenClauses()) {
        writer.append(SPACE);
      }


      // 'ELSE'
      if (shouldOutput(expression) || expression.hasElse()) {
        appendIdentifier((expression != null) ? expression.getActualElseIdentifier() : ELSE, ELSE);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterElse()) {
        writer.append(SPACE);
      }


      // Else expression
      if (stateObject.hasElse()) {
        stateObject.getElse().accept(this);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterElseExpression()) {
        writer.append(SPACE);
      }


      // END
      if (shouldOutput(expression) || expression.hasEnd()) {
        appendIdentifier((expression != null) ? expression.getActualEndIdentifier() : END, END);
      }
    }
  }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.CaseExpression


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      CaseExpression expression = stateObject.getExpression();


      // 'CASE'
      appendIdentifier((expression != null) ? expression.getActualCaseIdentifier() : CASE, CASE);


      if (shouldOutput(expression) || expression.hasSpaceAfterCase()) {
        writer.append(SPACE);
      }


      // Case operand
      if (stateObject.hasCaseOperand()) {
        stateObject.getCaseOperand().accept(this);


        if (shouldOutput(expression) || expression.hasSpaceAfterCaseOperand()) {
          writer.append(SPACE);
        }
      }


      // WHEN clauses
      if (stateObject.hasItems()) {
        toStringChildren(stateObject, false);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterWhenClauses()) {
        writer.append(SPACE);
      }


      // 'ELSE'
      if (shouldOutput(expression) || expression.hasElse()) {
        appendIdentifier((expression != null) ? expression.getActualElseIdentifier() : ELSE, ELSE);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterElse()) {
        writer.append(SPACE);
      }


      // Else expression
      if (stateObject.hasElse()) {
        stateObject.getElse().accept(this);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterElseExpression()) {
        writer.append(SPACE);
      }


      // END
      if (shouldOutput(expression) || expression.hasEnd()) {
        appendIdentifier((expression != null) ? expression.getActualEndIdentifier() : END, END);
      }
    }
  }

View Full Code Here

Examples of org.teiid.query.sql.symbol.CaseExpression

    public void testGetWhenExpression() {
        helpTestWhenExpressions(example(3), 3);
    }


    public void testSetWhen() {
        CaseExpression caseExpr = example(4);
        // Both are nulls
        try {
            caseExpr.setWhen(null, null);
            fail("Setting WHEN and THEN to null should have failed."); //$NON-NLS-1$
        } catch (IllegalArgumentException e) {
            // There should be no side-effects of an illegal argument
            helpTestWhenExpressions(caseExpr, 4);
            helpTestThenExpressions(caseExpr, 4);
        }
        try {
            caseExpr.setWhen(getWhenExpressions(2), null);
            fail("Setting THEN to null should have failed."); //$NON-NLS-1$
        } catch (IllegalArgumentException e) {
            // There should be no side-effects of an illegal argument
            helpTestWhenExpressions(caseExpr, 4);
            helpTestThenExpressions(caseExpr, 4);
        }
        try {
            caseExpr.setWhen(null, getThenExpressions(2));
            fail("Setting WHEN to null should have failed."); //$NON-NLS-1$
        } catch (IllegalArgumentException e) {
            // There should be no side-effects of an illegal argument
            helpTestWhenExpressions(caseExpr, 4);
            helpTestThenExpressions(caseExpr, 4);
        }
        try {
            caseExpr.setWhen(getWhenExpressions(0), getThenExpressions(0));
            fail("Setting WHEN and THEN to empty lists should have failed."); //$NON-NLS-1$
        } catch (IllegalArgumentException e) {
            // There should be no side-effects of an illegal argument
            helpTestWhenExpressions(caseExpr, 4);
            helpTestThenExpressions(caseExpr, 4);
        }
        caseExpr.setWhen(TestSearchedCaseExpression.getWhenCriteria(3), getThenExpressions(3));
        caseExpr.setWhen(getWhenExpressions(3), TestSearchedCaseExpression.getWhenCriteria(3));
        ArrayList whens = new ArrayList();
        whens.add(new Constant("abc")); //$NON-NLS-1$
        whens.add(new Constant("xyz")); //$NON-NLS-1$
        ArrayList thens = new ArrayList();
        thens.add(new Constant(new Integer(20000)));
        thens.add(new Constant(new Integer(30000)));
        caseExpr.setWhen(whens, thens);
        assertEquals(2, caseExpr.getWhenCount());
        assertEquals(new Constant("abc"), caseExpr.getWhenExpression(0)); //$NON-NLS-1$
        assertEquals(new Constant("xyz"), caseExpr.getWhenExpression(1)); //$NON-NLS-1$
        assertEquals(new Constant(new Integer(20000)), caseExpr.getThenExpression(0));
        assertEquals(new Constant(new Integer(30000)), caseExpr.getThenExpression(1));
    }

View Full Code Here

Examples of org.teiid.query.sql.symbol.CaseExpression

        assertEquals(new Constant(new Integer(20000)), caseExpr.getThenExpression(0));
        assertEquals(new Constant(new Integer(30000)), caseExpr.getThenExpression(1));
    }


    public void testIsResolved() {
        CaseExpression expr = example(3);
        assertFalse(expr.isResolved());
        ElementSymbol x = (ElementSymbol)expr.getExpression();
        x.setType(String.class);
        x.setMetadataID("metadataID"); //$NON-NLS-1$
        expr.setType(Integer.class);
        assertTrue(expr.isResolved());
    }

View Full Code Here

Examples of org.teiid.query.sql.symbol.CaseExpression

    public void testGetThenExpression() {
        helpTestThenExpressions(example(3), 3);
    }


    public void testGetElseExpression() {
        CaseExpression expr = example(3);
        assertEquals(new Constant(new Integer(9999)), expr.getElseExpression());
    }

View Full Code Here

Examples of org.teiid.query.sql.symbol.CaseExpression

        CaseExpression expr = example(3);
        assertEquals(new Constant(new Integer(9999)), expr.getElseExpression());
    }


    public void testSetElseExpression() {
        CaseExpression expr = example(3);
        expr.setElseExpression(new Constant(new Integer(1000)));
        assertEquals(new Constant(new Integer(1000)), expr.getElseExpression());
        expr.setElseExpression(null);
        assertNull(expr.getElseExpression());
    }

View Full Code Here

Examples of org.teiid.query.sql.symbol.CaseExpression

        expr.setElseExpression(null);
        assertNull(expr.getElseExpression());
    }


    public void testGetType() {
        CaseExpression expr = example(4);
        assertNull(expr.getType());
        expr.setType(Integer.class);
        assertEquals(Integer.class, expr.getType());
    }

View Full Code Here

Examples of org.teiid.query.sql.symbol.CaseExpression

        expr.setType(Integer.class);
        assertEquals(Integer.class, expr.getType());
    }


    public void testSetType() {
        CaseExpression expr = example(4);
        expr.setType(DataTypeManager.DefaultDataClasses.BIG_DECIMAL);
        assertEquals(DataTypeManager.DefaultDataClasses.BIG_DECIMAL, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.BIG_INTEGER);
        assertEquals(DataTypeManager.DefaultDataClasses.BIG_INTEGER, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.BLOB);
        assertEquals(DataTypeManager.DefaultDataClasses.BLOB, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.BOOLEAN);
        assertEquals(DataTypeManager.DefaultDataClasses.BOOLEAN, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.BYTE);
        assertEquals(DataTypeManager.DefaultDataClasses.BYTE, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.CHAR);
        assertEquals(DataTypeManager.DefaultDataClasses.CHAR, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.CLOB);
        assertEquals(DataTypeManager.DefaultDataClasses.CLOB, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.DATE);
        assertEquals(DataTypeManager.DefaultDataClasses.DATE, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.DOUBLE);
        assertEquals(DataTypeManager.DefaultDataClasses.DOUBLE, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.FLOAT);
        assertEquals(DataTypeManager.DefaultDataClasses.FLOAT, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.INTEGER);
        assertEquals(DataTypeManager.DefaultDataClasses.INTEGER, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.LONG);
        assertEquals(DataTypeManager.DefaultDataClasses.LONG, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.NULL);
        assertEquals(DataTypeManager.DefaultDataClasses.NULL, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.OBJECT);
        assertEquals(DataTypeManager.DefaultDataClasses.OBJECT, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.SHORT);
        assertEquals(DataTypeManager.DefaultDataClasses.SHORT, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.STRING);
        assertEquals(DataTypeManager.DefaultDataClasses.STRING, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.TIME);
        assertEquals(DataTypeManager.DefaultDataClasses.TIME, expr.getType());
        expr.setType(DataTypeManager.DefaultDataClasses.TIMESTAMP);
        assertEquals(DataTypeManager.DefaultDataClasses.TIMESTAMP, expr.getType());
        expr.setType(null);
        assertNull(expr.getType());
    }

View Full Code Here

Examples of org.teiid.query.sql.symbol.CaseExpression

        expr.setType(null);
        assertNull(expr.getType());
    }


    public void testEquals() {
        CaseExpression sc1 = example(3);
        assertTrue(sc1.equals(sc1));
        assertTrue(sc1.equals(sc1.clone()));
        assertTrue(sc1.clone().equals(sc1));
        assertTrue(sc1.equals(example(3)));
        
        CaseExpression sc2 = example(4);
        
        assertFalse(sc1.equals(sc2));
        assertFalse(sc2.equals(sc1));
        
        CaseExpression sc3 = example(3);
        sc3.setElseExpression(new ElementSymbol("y")); //$NON-NLS-1$
        assertFalse(sc1.equals(sc3));
        assertFalse(sc3.equals(sc1));
        
        CaseExpression sc4 = example(3);
        sc4.setExpression(new ElementSymbol("y")); //$NON-NLS-1$
        assertFalse(sc1.equals(sc4));
        assertFalse(sc4.equals(sc1));
    }

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.