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

Example 81 with IType

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

the class AbstractJPQLQueryHelperTest method test_ParameterType_12.

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

Example 82 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_57.

@Test
public final void test_ResultType_57() throws Exception {
    // SELECT c from Customer c where c.home.city IN :city
    IQuery namedQuery = namedQuery("Customer", "customer.city");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of c should have been found", type);
    assertEquals("The wrong type for c was retrieved", getType(namedQuery, "jpql.query.Customer"), type);
}

Example 83 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_58.

@Test
public final void test_ResultType_58() throws Exception {
    // SELECT DISTINCT p From Product p where p.shelfLife.soldDate NOT BETWEEN :date1 AND :newdate
    IQuery namedQuery = namedQuery("Product", "product.date");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of p should have been found", type);
    assertEquals("The wrong type for p was retrieved", getType(namedQuery, "jpql.query.Product"), type);
}

Example 84 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_63.

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

Example 85 with IType

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

the class AbstractJPQLQueryHelperTest method test_ResultType_21.

@Test
public final void test_ResultType_21() throws Exception {
    // select count(c) FROM Customer c JOIN c.aliases a GROUP BY a.alias HAVING a.alias = SUBSTRING(:string1, :int1, :int2)
    IQuery namedQuery = namedQuery("Customer", "customer.substring");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of count(c) should have been found", type);
    assertEquals("The wrong type for count(c) was retrieved", getType(namedQuery, Long.class), type);
}