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

Example 91 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ParameterType_08.

@Test
public final void test_ParameterType_08() 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.getParameterType(":string1");
    assertNotNull("The type of :string1 should have been found", type);
    assertEquals("The wrong type for :string1 was retrieved", getType(namedQuery, String.class), type);
}

Example 92 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ResultType_77.

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

Example 93 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ParameterType_23.

@Test
public final void test_ParameterType_23() throws Exception {
    // Select Distinct Object(p) from Product p where (p.quantity > (500 + :int1)) AND (p.partNumber IS NULL))
    IQuery namedQuery = namedQuery("Product", "product.int1");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getParameterType(":int1");
    assertNotNull("The type of :dept should have been found", type);
    assertEquals("The wrong type for :dept was retrieved", getType(namedQuery, Integer.class), type);
}

Example 94 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ResultType_03.

@Test
public final void test_ResultType_03() throws Exception {
    // SELECT ABS(p.id) FROM Project p
    IQuery namedQuery = namedQuery("Project", "project.abs");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of ABS(p.id) should have been found", type);
    assertEquals("The wrong type for ABS(p.id) was retrieved", getType(namedQuery, Float.class), type);
}

Example 95 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ResultType_16.

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