How should I use the @NamedEntityGraph annotation with the Panache module in Quarkus?

[zyp461476492]

I understand that I can use the following code to use the defined @NamedEntityGraph, but how can I simplify it using Panache?

useless code

I saw code like this, but it cannot run and throws an exception.

final List<Batch> b = Batch.findAll(Sort.descending("creationDate"))
  withHint(QueryHints.HINT_FETCHGRAPH, Panache.getEntityManager().getEntityGraph("withLobs"))
page(Page.of(pagination.page - 1, pagination.limit)).list();

it will throw "Hints not supported yet" exception

and i find code like this:

/**
* io.quarkus.hibernate.reactive.panache.common.runtime.CommonPanacheQueryImpl.java
**/
public void withHint(String hintName, Object value) {
        if (hints == null) {
            hints = new HashMap<>();
        }
        hints.put(hintName, value);
        throw new UnsupportedOperationException("Hints not supported yet");
    }

Example code with hibernate

User

@Entity
@NamedEntityGraphs(
        value = {
                @NamedEntityGraph(
                        name = "user-with-roles",
                        attributeNodes = {
                                @NamedAttributeNode(value = "roles")
                        }
                )}
)
@NamedQueries(
        value = {
                @NamedQuery(name = "user-with-roles", query = "select u from User u left join u.roles r")
        }
)
public class User extends PanacheEntityBase {

    @Id
    @UuidGenerator
    @Column(length = 64, nullable = false)
    public String id;

    @Column(length = 256, nullable = false)
    public String userName;

    @Column(length = 256, nullable = false)
    public String password;

    @BatchSize(size = 100)
    @ManyToMany
    @JoinTable(
            joinColumns = @JoinColumn(name = "userId", referencedColumnName = "id"),
            inverseJoinColumns = @JoinColumn(name = "roleId", referencedColumnName = "id"),
            indexes = {@Index(name = "uniqueuUserRole", columnList = "userId, roleId", unique = true)}
    )
    public List<Role> roles;

}

Role

@Entity
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
@RegisterForReflection
public class Role extends PanacheEntityBase {

    @Id
    @UuidGenerator
    @Column(length = 64, nullable = false)
    public String id;

    @Column(length = 256, nullable = false)
    public String roleName;

    @Column(length = 256, nullable = false)
    public String role;

}

query with EntityGraph

public Uni<List<User>> findUserEntityGraph() {
        return Panache.getSession().onItem()
                .transformToUni(session -> {
                    EntityGraph<User> entityGraph = session.getEntityGraph(User.class, "user-with-roles");
                    var query = session.getFactory().getCriteriaBuilder().createQuery(User.class);
                    Root<User> root = query.from(User.class);
                    query.select(root);
                   var query1 = session.createQuery(query);
                   query1.setPlan(entityGraph);
                   query1.setFirstResult(0);
                   query1.setMaxResults(10);
                  return query1.getResultList();
                });

    }

[quarkus-bot[bot]]

/cc @FroMage (panache), @loicmathieu (panache)