Java Examples for com.querydsl.core.types.dsl.SimplePath

@Test
public void windowFunctions_manual_paging() {
    Expression<Long> rowNumber = SQLExpressions.rowNumber().over().orderBy(employee.lastname.asc()).as("rn");
    Expression<Object[]> all = Wildcard.all;
    // simple
    System.out.println("#1");
    for (Tuple row : query().from(employee).select(employee.firstname, employee.lastname, rowNumber).fetch()) {
        System.out.println(row);
    }
    System.out.println();
    // with subquery, generic alias
    System.out.println("#2");
    SQLQuery<Tuple> sub = query().from(employee).select(employee.firstname, employee.lastname, rowNumber);
    SimplePath<Tuple> subAlias = Expressions.path(Tuple.class, "s");
    for (Object[] row : query().from(sub.as(subAlias)).select(all).fetch()) {
        System.out.println(Arrays.asList(row));
    }
    System.out.println();
    // with subquery, only row number
    System.out.println("#3");
    SQLQuery<Long> sub2 = query().from(employee).select(rowNumber);
    SimplePath<Long> subAlias2 = Expressions.path(Long.class, "s");
    for (Object[] row : query().from(sub2.as(subAlias2)).select(all).fetch()) {
        System.out.println(Arrays.asList(row));
    }
    System.out.println();
    // with subquery, specific alias
    System.out.println("#4");
    SQLQuery<Tuple> sub3 = query().from(employee).select(employee.firstname, employee.lastname, rowNumber);
    for (Tuple row : query().from(sub3.as(employee2)).select(employee2.firstname, employee2.lastname).fetch()) {
        System.out.println(Arrays.asList(row));
    }
}

// DATAMONGO-761
@Test
public void looksUpKeyForNonPropertyPath() {
    PathBuilder<Address> builder = new PathBuilder<Address>(Address.class, "address");
    SimplePath<Object> firstElementPath = builder.getArray("foo", String[].class).get(0);
    String path = serializer.getKeyForPath(firstElementPath, firstElementPath.getMetadata());
    assertThat(path, is("0"));
}