Examples with IQuery org.eclipse.persistence.jpa.jpql.tools.spi.IQuery used on opensource projects

Example 36 with IQuery

use of org.eclipse.persistence.jpa.jpql.tools.spi.IQuery in project eclipselink by eclipse-ee4j.

the class AbstractJPQLQueryHelperTest method test_ResultType_33.

@Test
public final void test_ResultType_33() throws Exception {
    // SELECT KEY(k) FROM Alias a JOIN a.ids k
    IQuery namedQuery = namedQuery("Alias", "alias.key1");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of KEY(k) should have been found", type);
    assertEquals("The wrong type for KEY(k) was retrieved", getType(namedQuery, String.class), type);
}

Example 37 with IQuery

use of org.eclipse.persistence.jpa.jpql.tools.spi.IQuery in project eclipselink by eclipse-ee4j.

the class AbstractJPQLQueryHelperTest method test_ResultType_14.

@Test
public final void test_ResultType_14() throws Exception {
    // SELECT COALESCE(o.totalPrice, SQRT(o.realPrice)) FROM Order o
    IQuery namedQuery = namedQuery("Order", "order.coalesce2");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of COALESCE(o.totalPrice, SQRT(o.realPrice)) should have been found", type);
    assertEquals("The wrong type for COALESCE(o.totalPrice, SQRT(o.realPrice)) was retrieved", getType(namedQuery, Double.class), type);
}

Example 38 with IQuery

use of org.eclipse.persistence.jpa.jpql.tools.spi.IQuery in project eclipselink by eclipse-ee4j.

the class AbstractJPQLQueryHelperTest method test_ResultType_24.

@Test
public final void test_ResultType_24() throws Exception {
    // DELETE FROM Employee e WHERE e.department = :dept
    IQuery namedQuery = namedQuery("Employee", "employee.delete.dept");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The object type should have been returned", type);
    assertEquals("The wrong type was retrieved", getType(namedQuery, Object.class), type);
}

Example 39 with IQuery

use of org.eclipse.persistence.jpa.jpql.tools.spi.IQuery in project eclipselink by eclipse-ee4j.

the class AbstractJPQLQueryHelperTest method test_ResultType_65.

@Test
public final void test_ResultType_65() throws Exception {
    // SELECT AVG(e.salary) - 2E2 FROM Employee e
    IQuery namedQuery = namedQuery("Employee", "employee.substraction2");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of AVG(salary) / 2E2 should have been found", type);
    assertEquals("The wrong type for AVG(salary) / 2E2 was retrieved", getType(namedQuery, Double.class), type);
}

Example 40 with IQuery

use of org.eclipse.persistence.jpa.jpql.tools.spi.IQuery in project eclipselink by eclipse-ee4j.

the class AbstractJPQLQueryHelperTest method test_ParameterType_17.

@Test
public final void test_ParameterType_17() throws Exception {
    // SELECT e FROM Employee e WHERE e.salary = (SELECT MAX(e.salary) FROM Employee a WHERE a.department = :dept)
    IQuery namedQuery = namedQuery("Employee", "employee.dept");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getParameterType(":dept");
    assertNotNull("The type of :dept should have been found", type);
    assertEquals("The wrong type for :dept was retrieved", getType(namedQuery, String.class), type);
}