Examples with JPQLCompiler org.datanucleus.query.compiler.JPQLCompiler used on opensource projects

Example 11 with JPQLCompiler

use of org.datanucleus.query.compiler.JPQLCompiler in project tests by datanucleus.

the class JPQLCompilerTest method testFromMemberOfExpression.

/**
 * Tests for from clause with a "MEMBER OF {primary}" expression.
 */
public void testFromMemberOfExpression() {
    JavaQueryCompiler compiler = null;
    QueryCompilation compilation = null;
    try {
        compiler = new JPQLCompiler(nucCtx, nucCtx.getClassLoaderResolver(null), null, Department.class, null, ":param MEMBER OF projects", null, null, null, null, null, null, null);
        compilation = compiler.compile(new HashMap(), null);
    } catch (NucleusException ne) {
        NucleusLogger.QUERY.error("Exception during compile", ne);
        fail("compilation of filter with valid field threw exception : " + ne.getMessage());
    }
    // InvokeExpression{[PrimaryExpression{elements}].contains(ParameterExpression{param})}
    Expression expr = compilation.getExprFilter();
    assertTrue("Invalid type of filter expression", expr instanceof InvokeExpression);
    InvokeExpression invokeExpr = (InvokeExpression) expr;
    assertEquals("Invoke method is incorrect", "contains", invokeExpr.getOperation());
    assertTrue("Invoke left expression is of incorrect type", invokeExpr.getLeft() instanceof PrimaryExpression);
    PrimaryExpression leftExpr = (PrimaryExpression) invokeExpr.getLeft();
    assertEquals("Invoke left expression id is wrong", "projects", leftExpr.getId());
    List args = invokeExpr.getArguments();
    assertNotNull("Number of args is null!", args);
    assertEquals("Incorrect number of args to invoke", 1, args.size());
    assertTrue("Argument is of incorrect type", args.get(0) instanceof ParameterExpression);
    ParameterExpression argExpr = (ParameterExpression) args.get(0);
    assertEquals("Argument param name is incorrect", "param", argExpr.getId());
}

Example 12 with JPQLCompiler

use of org.datanucleus.query.compiler.JPQLCompiler in project tests by datanucleus.

the class JPQLCompilerTest method testUpdateSimple.

/**
 * Test for use of update clause.
 */
public void testUpdateSimple() {
    // Test use of UPDATE clause
    try {
        JPQLCompiler compiler = new JPQLCompiler(nucCtx, nucCtx.getClassLoaderResolver(null), null, Project.class, null, null, null, null, null, null, null, null, "name = \"Sample Name\"");
        QueryCompilation compilation = compiler.compile(null, null);
        Expression[] updateExprs = compilation.getExprUpdate();
        assertNotNull("Update clause is null but shouldnt be", updateExprs);
        assertEquals("Number of update expressions is incorrect", 1, updateExprs.length);
        assertTrue("Update expression is of incorrect type " + updateExprs[0].getClass().getName(), updateExprs[0] instanceof DyadicExpression);
        DyadicExpression updateExpr = (DyadicExpression) updateExprs[0];
        Expression left = updateExpr.getLeft();
        Expression right = updateExpr.getRight();
        Operator op = updateExpr.getOperator();
        assertEquals("Operator in update expression is wrong", op, Expression.OP_EQ);
        assertTrue("Left hand side in update is wrong", left instanceof PrimaryExpression);
        assertTrue("Right hand side in update is wrong", right instanceof Literal);
        PrimaryExpression primExpr = (PrimaryExpression) left;
        assertEquals("Left hand side primary is wrong", "name", primExpr.getId());
        Literal lit = (Literal) right;
        assertEquals("Right hand side literal is wrong", "Sample Name", lit.getLiteral());
    } catch (NucleusUserException ne) {
        fail("Exception thrown in compile of update clause : " + ne.getMessage());
    }
}

Example 13 with JPQLCompiler

use of org.datanucleus.query.compiler.JPQLCompiler in project tests by datanucleus.

the class JPQLCompilerTest method testFilterInvalidField.

/**
 * Test for use of invalid field name in the filter.
 */
public void testFilterInvalidField() {
    // Test use of invalid field in filter
    try {
        JPQLCompiler compiler = new JPQLCompiler(nucCtx, nucCtx.getClassLoaderResolver(null), null, Project.class, null, "illegalField = 2", null, null, null, null, null, null, null);
        compiler.compile(null, null);
        fail("Expected NucleusUserException to be thrown on filter with invalid field, but not thrown");
    } catch (NucleusUserException ne) {
    // Expected
    }
}

Example 14 with JPQLCompiler

use of org.datanucleus.query.compiler.JPQLCompiler in project tests by datanucleus.

the class JPQLCompilerTest method testFilterComparison.

/**
 * Tests for simple field-literal comparison in filter.
 */
public void testFilterComparison() {
    JavaQueryCompiler compiler = null;
    QueryCompilation compilation = null;
    try {
        compiler = new JPQLCompiler(nucCtx, nucCtx.getClassLoaderResolver(null), null, Project.class, null, "budget = 2", null, null, null, null, null, null, null);
        compilation = compiler.compile(new HashMap(), null);
    } catch (NucleusException ne) {
        NucleusLogger.QUERY.error("Exception during compile", ne);
        fail("compilation of filter with valid field threw exception : " + ne.getMessage());
    }
    Expression expr = compilation.getExprFilter();
    assertTrue("Compiled expression should have been DyadicExpression but wasnt", expr instanceof DyadicExpression);
    DyadicExpression dyExpr = (DyadicExpression) expr;
    assertTrue("Compiled left expression should be PrimaryExpression but isnt", dyExpr.getLeft() instanceof PrimaryExpression);
    assertTrue("Compiled right expression should be Literal but isnt", dyExpr.getRight() instanceof Literal);
    assertEquals("Operator between left and right is incorrect", Expression.OP_EQ, dyExpr.getOperator());
    PrimaryExpression leftExpr1 = (PrimaryExpression) dyExpr.getLeft();
    assertEquals("Compiled left expression has incorrect number of tuples", 1, leftExpr1.getTuples().size());
    assertEquals("Compiled left expression 'id' is incorrect", "budget", leftExpr1.getId());
    Literal rightExpr1 = (Literal) dyExpr.getRight();
    assertTrue("Compiled right expression literal is of incorrect type", rightExpr1.getLiteral() instanceof Long);
    assertEquals("Compiled right expression literal has incorrect value", 2, ((Long) rightExpr1.getLiteral()).longValue());
    try {
        compiler = new JPQLCompiler(nucCtx, nucCtx.getClassLoaderResolver(null), null, Project.class, null, "100.0 > budget", null, null, null, null, null, null, null);
    } catch (NucleusException ne) {
        NucleusLogger.QUERY.error("Exception during compile", ne);
        fail("compilation of filter with valid field threw exception : " + ne.getMessage());
    }
    compilation = compiler.compile(new HashMap(), null);
    expr = compilation.getExprFilter();
    assertTrue("Compiled expression should have been DyadicExpression but wasnt", expr instanceof DyadicExpression);
    dyExpr = (DyadicExpression) expr;
    assertTrue("Compiled right expression should be PrimaryExpression but isnt", dyExpr.getRight() instanceof PrimaryExpression);
    assertTrue("Compiled left expression should be Literal but isnt", dyExpr.getLeft() instanceof Literal);
    assertEquals("Operator between left and right is incorrect", Expression.OP_GT, dyExpr.getOperator());
    PrimaryExpression rightExpr2 = (PrimaryExpression) dyExpr.getRight();
    assertEquals("Compiled left expression has incorrect number of tuples", 1, rightExpr2.getTuples().size());
    assertEquals("Compiled left expression 'id' is incorrect", "budget", rightExpr2.getId());
    Literal leftExpr2 = (Literal) dyExpr.getLeft();
    // TODO Why BigDecimal and not Double??
    assertTrue("Compiled right expression literal is of incorrect type", leftExpr2.getLiteral() instanceof BigDecimal);
    assertEquals("Compiled right expression literal has incorrect value", 100.0, ((BigDecimal) leftExpr2.getLiteral()).longValue(), 0.1);
}

Example 15 with JPQLCompiler

use of org.datanucleus.query.compiler.JPQLCompiler in project tests by datanucleus.

the class JPQLCompilerTest method testFromInExpressionErroneousPrimary.

/**
 * Tests for from clause with an "IN(...) alias" expression with an invalid primary.
 */
public void testFromInExpressionErroneousPrimary() {
    JavaQueryCompiler compiler = null;
    try {
        compiler = new JPQLCompiler(nucCtx, nucCtx.getClassLoaderResolver(null), Department.class.getName() + " d," + "IN(d.products) n", null, null, null, null, null, null, null, null, null, null);
        compiler.compile(new HashMap(), null);
        fail("Was expecting QueryCompilerSyntaxException but compilation worked");
    } catch (QueryCompilerSyntaxException qcse) {
    // Expected
    }
}