Querying ManyToOne relationship with Panache

[lordofthejars]

I have a one-to-many/many-to-one relationship, and I want to query all many relationships using the parent ID.

@Entity
public class Subcategory extends PanacheEntity  {

    public String name;

    @JsonIgnore
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "categoryId", nullable = false)
    public Category category;

    public Subcategory() {
    }

    public Subcategory(final String name) {
        this.name = name;
    }

    public static List<Subcategory> findByCategoryId(Long id) {
        Category category = new Category();
        category.id = id;
        return Subcategory.list("category", category);
    }

    @Override
    public String toString() {
        return "Subcategory [id=" + id + ", name=" + name + "]";
    }
}

Is this correct? I know I could use a native query, but I prefer an easy way, using the Panache method.

Thank you.

[quarkus-bot[bot]]

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

[FroMage]

I think it's more:

    public static List<Subcategory> findByCategoryId(Long id) {
        Category category = Category.findById(id);
        return category.subcategories; // or however is named the inverse relation field
    }

[lordofthejars]

But with this approach, we are running two queries; in the one I did, it was only one. So, it is more performant and better for the database.

[FroMage]

Ah, probably.

[joni1692]

you can use

public static List<Subcategory> findByCategoryId(Long id) {
    return Subcategory.list("category.id", id);
}