修改在 Spring Data REST 投影后面生成的 SQL 查询 [英] Modify SQL query generated behind Spring Data REST projections

问题描述

如何在 SELECT 中只保留需要的列以进行 Spring Data Rest Projections?

EDIT : How to Keep only needed columns in SELECT for Spring Data Rest Projections?

Spring Data Rest Projections 适用于获取生成的链接的列的子集，但在后面生成的查询仍然包含所有列.

Spring Data Rest Projections are good for getting a subset of columns for links which are generated, but the Query that gets generated in behind still has all columns in it.

如何在 SQL 查询中只有那些在投影中的列的情况下创建投影

How can Projections be created where also SQL queries have only those columns in SELECT which are in Projection

推荐答案

我不知道为什么文档中缺少它，但是这个 spring 示例(来自 spring)表明您可以使用投影作为 @ 的返回类型询问.所以你可以这样做:

I don't know why it's missing from the docs, but this spring sample (from spring) shows that you can use projections as the return type for a @Query. So you can do:

public interface ActionId {
    String getId(); 
}

@Query("select a.id as id from Action a where a.type = :type")
public List<ActionId> findByType(@Param("type") String type);

现在不必使用构造函数表达式，您可以更简洁地选择所需的列，然后返回一个对象.我希望可以将投影应用于域对象本身，因此您仍然可以仅返回 id 字段的操作"，但现在看起来不可能-

Now instead of having to use constructor expressions, you can more succinctly just select the columns you want, and return an object. I wish that projections could be applied to the domain object itself, so you could still return an "Action" with just the id field, but that doesn't look possible now-

ref:https://github.com/spring-projects/spring-data-examples/blob/master/jpa/example/src/main/java/example/springdata/jpa/projections/CustomerRepository.java

这篇关于修改在 Spring Data REST 投影后面生成的 SQL 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！