Add support for new custom row-mapping projections in QueryDSL 2.2.0 [DATAJDBC-12]

[spring-projects-issues]

Thomas Risberg opened DATAJDBC-12 and commented

Add support for new custom row-mapping projections in QueryDSL 2.2.0

https://bugs.launchpad.net/querydsl/+bug/809289

---

No further details from DATAJDBC-12

[spring-projects-issues]

Alex Soto commented

This improvement is already implemented in current version of Spring-Data. Because MappingProjection class extends from ExpressionBase you can use QueryDslJdbcTemplate methods that also accepts Expression as parameter. For example:

public Customer findCustomerById(Long id) {
SQLQuery sqlQuery = template.newSqlQuery().from(qCustomer)
.where(qCustomer.id.eq(id));
return template.queryForObject(sqlQuery,new MappingProjection<Customer>(Customer.class, qCustomer.all()) {

		/**
		 * 
		 */
		private static final long serialVersionUID = 6080677802308908210L;

		@Override
		protected Customer map(Tuple tuple) {
			Customer customer = new Customer();
			customer.setId(tuple.get(qCustomer.id));
			customer.setFirstName(tuple.get(qCustomer.firstName));
			customer.setLastName(tuple.get(qCustomer.lastName).replace(',', '#'));
			return customer;
		}
	});
}

This afternoon I will upload full code in my github.

[spring-projects-issues]

Thomas Risberg commented

Thanks Alex, you're right, works with the current implementation. That was easy