SQL : Intuitive way for count(*)

[Samppa Saarela]

Using count(*) in searches is a very common case but in querydsl it's still quite unintuitive. Could there be a shortcut for it?

E.g.

query.list(query.all().count());

or

query.list(SQLCommonQuery.ALL.count());

[Samppa Saarela (samppa-saarela)]

Wildcard can now be used through Wildcard class:

@Test
public void wildcardAll() {
    expectedQuery = "select * from EMPLOYEE2 e";
    query().from(employee).uniqueResult(Wildcard.all);
}

@Test
public void countAll() {
    expectedQuery = "select count(*) as rowCount from EMPLOYEE2 e";
    PNumber<Long> rowCount = new PNumber<Long>(Long.class, "rowCount");
    query().from(employee).uniqueResult(Wildcard.count().as(rowCount));
}

[Timo Westkämper (timo-westkamper)]

Released in 1.9.6