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

Example 11 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ParameterType_13.

@Test
public final void test_ParameterType_13() throws Exception {
    // DELETE FROM Employee e WHERE e.department = :dept
    IQuery namedQuery = namedQuery("Employee", "employee.delete.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);
}

Example 12 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ParameterType_25.

@Test
public final void test_ParameterType_25() throws Exception {
    // SELECT e FROM Employee e WHERE EXISTS (SELECT p FROM Project p JOIN p.employees emp WHERE emp = e AND p.name = :name)
    IQuery namedQuery = namedQuery("Employee", "employee.subquery1");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getParameterType(":name");
    assertNotNull("The type of :name should have been found", type);
    assertEquals("The wrong type for :name was retrieved", getType(namedQuery, String.class), type);
}

Example 13 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ResultType_38.

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

Example 14 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ParameterType_15.

@Test
public final void test_ParameterType_15() throws Exception {
    // SELECT e FROM Employee e WHERE e.name IN :type
    IQuery namedQuery = namedQuery("Employee", "employee.in");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getParameterType(":type");
    assertNotNull("The type of :type should have been found", type);
    assertEquals("The wrong type for :type was retrieved", getType(namedQuery, Collection.class), type);
}

Example 15 with IQuery

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

the class AbstractJPQLQueryHelperTest method test_ResultType_56.

@Test
public final void test_ResultType_56() throws Exception {
    // select Dept.floorNumber from Dept Dept
    IQuery namedQuery = namedQuery("Dept", "dept.floorNumber");
    AbstractJPQLQueryHelper helper = buildQueryHelper(namedQuery);
    IType type = helper.getResultType();
    assertNotNull("The type of Dept.floorNumber should have been found", type);
    assertEquals("The wrong type for Dept.floorNumber was retrieved", getType(namedQuery, Integer.class), type);
}