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

Example 51 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_70.

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

Example 52 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_09.

@Test
public final void test_ResultType_09() throws Exception {
    // SELECT CASE WHEN e.name = 'Java Persistence Query Language' THEN 'Java Persistence Query Language'
    // WHEN 1 + 2 THEN SUBSTRING(e.name, 0, 2)
    // ELSE e.name
    // END
    // FROM Employee e
    IQuery namedQuery = namedQuery("Employee", "employee.case1");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of CASE(...) should have been found", type);
    assertEquals("The wrong type for CASE(...) was retrieved", getType(namedQuery, String.class), type);
}

Example 53 with IType

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

the class AbstractJPQLQueryHelperTest method test_ParameterType_09.

@Test
public final void test_ParameterType_09() throws Exception {
    // select o from Dept o where o.dname in (:dname1, :dname2, :dname3)
    IQuery namedQuery = namedQuery("Dept", "dept.dname");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getParameterType(":dname1");
    assertNotNull("The type of :dname1 should have been found", type);
    assertEquals("The wrong type for :newdate was retrieved", getType(namedQuery, String.class), type);
}

Example 54 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_66.

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

Example 55 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_15.

@Test
public final void test_ResultType_15() throws Exception {
    // SELECT COALESCE(o.number, e.name) FROM Order o, Employee e
    IQuery namedQuery = namedQuery("Order", "order.coalesce3");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of COALESCE(o.number, e.name) should have been found", type);
    assertEquals("The wrong type for COALESCE(o.number, e.name) was retrieved", getType(namedQuery, String.class), type);
}