11

Is there a way to return the full details of a joined entity instead of a link? In the example below I want to also return the details of the product, if I have list of 100 purchases, it would avoid having to make 100 calls to get the product details.

The repositories for Product, User and Purchase entities are all created using spring-data-jpa

{
  "_embedded" : {
    "purchase" : [ {
      "_links" : {
        "product" : {
          "href" : "http://localhost:8080/webapp/purchase/1/product"
        },
        "user" : {
          "href" : "http://localhost:8080/webapp/purchase/1/user"
        }
      },
      "purchasedOn" : "2014-02-23",
      "amount" : 1
    } ]
  }
}

Entities and Repositories;

@Entity
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, targetEntity = Purchase.class, orphanRemoval = true)
    @JoinColumn(name = "user_id", updatable = false)
    private List<Purchase> purchases = new ArrayList<>();

}

@Entity
public class Product {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    private String name;

}

@Entity
public class Purchase implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    Long id;

    @ManyToOne
    @JoinColumn(name = "user_id", referencedColumnName = "id")
    private User user;

    @ManyToOne(fetch = FetchType.EAGER, targetEntity = Product.class)
    @JoinColumn(name = "product_id", referencedColumnName = "id")
    private Product product;

    @Column(name = "purchase_date")
    private Date purchaseDate;

    private Integer amount;

}

@Repository
public interface PurchaseRepository extends JpaRepository<Purchase, Long> {}
wenic
  • 1,169
  • 2
  • 14
  • 23

3 Answers3

2

It would seems there is already a New Feature request for this functionality;

https://jira.springsource.org/browse/DATAREST-221

https://jira.springsource.org/browse/DATAREST-243

I'll leave the question open until the feature has been implemented.

wenic
  • 1,169
  • 2
  • 14
  • 23
0

Yes.

You can use something like a TypedQuery.

So you would create a Plain Old Java Object (POJO) which holds all the columns (fields) you need. You then use a TypeQuery to get all the fields from the database and return in a custom result set (i.e. your POJO or a collection of your POJO).

Here is a an example:

TypedQuery<BookExport> q = (TypedQuery<SOME_POJO>) entityManager.createQuery(
    "select new SOME_PJOP(a.field1, a.field2, a.field2) " +
    "from SOME_ENTITY AS a",
    SOME_POJO.class);

UPDATE

It looks like you have related entities already. Assuming you are using "Eager Loading", all you need to do is perform a simple query in your repository implementation. Eager Loading means JPA will automatically select the related attributes.If you are using Jersey to serialize the result in JSON, it by default, will serialize of the fields of the result set.

Here is an example from a JPA project I recently completed. The scheme is simple. I have a "Book" entity. Each "Book" has a related "Author". Each "Author" has a first and last name. If you select a "Book" the JPA query also select the Author's first and last name. I believe that is analogous to what you are trying to accomplish:

@Override
@Transactional
public Object findOne(Serializable id) {
    Query q = entityManager.createQuery("select a from Book a where a.id = ?1");
    q.setParameter(1, id);
    return q.getSingleResult();
}

The input id is simply the Book key (a number like 105).

Hope that helps :)

bluish
  • 26,356
  • 27
  • 122
  • 180
lorinpa
  • 556
  • 1
  • 5
  • 6
  • thanks, i've included the entities. i'll take a look, but i'm not sure if making custom result set will work with spring data rest, as it uses the JpaRepositories to build and expose the json resources. I'll give it a try later. – wenic Feb 24 '14 at 09:20
  • Thank you for the update. What I don't see is you repository implementation. That's where you would implement a concrete query to the database. I'll update my answer to give you an example. You are very close. You'll be able to get it done :) – lorinpa Feb 24 '14 at 12:55
  • that's it, there is no concrete implementation. I'm using spring-data-jpa, so by just creating an interface that extends the JpaRepository, I get a full crud repository for my entity. – wenic Feb 24 '14 at 17:11
  • And it is simple to add an implementation. Feel free to review my project on github. Might help you: https://github.com/lorinpa/book-site-jpa . Repository implemention for Book is here https://github.com/lorinpa/book-site-jpa/blob/dev-1.0/src/main/java/org/pa/repository/BooksRepositoryImpl.java Good Luck – lorinpa Feb 24 '14 at 17:34
  • thanks, i understand how to do this with an implementation and controllers, but I trying to use spring-data-rest and spring-data-jpa, to create a simple crud webapp to a datastore which should map and create these for you. – wenic Feb 25 '14 at 09:50
0

You can write projecton to get the details. For example PurchaseProjection can be written as.

    @Projection(name="purchaseProduction",types={Purchase.class})
    interface PurchaseProjection{
       public User getUser();
        public Product getProduct();
        public Long getAmount();
      }

You can access the result using http://localhost:8080/webapp/purchase?projection=purchaseProduction

Abhinay
  • 464
  • 5
  • 13