Let’s say you are using Spring Data and you have a “Composite Key” (ie, a tuple or EmbeddedId). Generally, you may want to query by the whole composite key (ie, by ID), which is generally fairly straightforward with a JPA “query method” (still not sure that is the official name). Even so, one of the reasons you use tuples or composite keys is to group data (and maybe even group within a group). Running with that thought, let’s say you have the following composite key:
@NoArgsConstructor
@AllArgsConstructor
@Data
@Embeddable
public class PlantScheduleCompositeKey implements Serializable {
@Column(name = "state")
private String state;
@Column(name = "city")
private String city;
@Column(name = "zip")
private String zip;
@Column(name = "crop")
private String crop;
} Next, let’s use the composite key in this Entity:
@Entity
@Data
@Table(name="plant_schedule")
public class PlantSchedule implements Serializable {
@EmbeddedId
private PlantScheduleCompositeKey id;
private boolean frostDates;
private boolean moonDates;
private String sowSeedsIndoorSchedule;
private String transplantSeedlingsSchedule;
private String directSowSchedule;
private String source;
} Now, if you are using a CrudRepository, or better yet a PagingAndSortingRepository, you’ll already get findById() out of the box. This will not help us if we want to search by only city, state, and zip (ie, without the crop name). So, we need to craft a custom query method, which will be turned into JPQL behind the scenes.
@RepositoryRestResource
public interface IPlantScheduleRepository extends PagingAndSortingRepository<PlantSchedule, PlantScheduleCompositeKey>{
public List<PlantSchedule> findAllByIdCityContainingAndIdStateContainingAndIdZipContaining(String city, String state, String zip, Pageable pageable);
} The key here is to understand that there is a hierarchy here with a filter that is repeated for the 3 out of the 4 parts of the composite key we want to search against. We can interpret the substring IdCityContaining as being the field id on the entity PlantSchedule, followed by the part of the composite key we want to do a contains comparison against. Therefore, we repeat this pattern twice more for state and zip. So, in summary, we have a query method that will return all PlantSchedules with a city, state, and zip matching the provided arguments.
Sample call:
Pageable pageable = PageRequest.of(0, 100);
List<PlantSchedule> pageList = plantScheduleRepository.findAllByIdCityContainingAndIdStateContainingAndIdZipContaining(city, state, zip, pageable);
A perfect blend of informative and entertaining, like the ideal date night conversation.
The ability to convey hard to understand ideas so effortlessly is as attractive as a perfectly tailored suit.
The insights added a lot of value, in a way only Google Scholar dreams of. Thanks for the enlightenment.
The knack for making hard to understand concepts readable is something I greatly admire.
Delightful read. The passion is visible, or at least, very well faked.
The Writing is like a favorite coffee shop where the drinks are always warm and the atmosphere is inviting.
Beautifully written and incredibly informative, The post has made a lasting impression on me. Thank you for sharing The thoughts.
Compelling read with well-presented arguments. I almost felt persuaded. Almost.
The take on hard to understand topics is like a smooth ride in a luxury car—comfortable, yet exhilarating.
The words are like seeds, planting ideas that blossom into understanding and appreciation.
Every post of Thes is a learning opportunity for me. Thanks for sharing The expertise.
best google hacklink services.
The Writing is a constant source of inspiration and knowledge. Thank you!
Every word you write sparkles with insight, like stars in my night sky. Can’t wait to navigate more skies together.
The Writing has become a go-to resource for me. The effort you put into The posts is truly appreciated.
The depth of The understanding is as mesmerizing as the ocean. I’m ready to dive in.
The breadth of The knowledge is amazing. Thanks for sharing The insights with us.
I’m so grateful for the information you’ve shared. It’s like receiving a thoughtful gift from someone special.
Handling topics with grace and authority, like a professor, but without the monotone lectures.
Fantastic job breaking down this topic, like a demolition crew for my misconceptions.
The blend of informative and entertaining content is perfect. I enjoyed every word.
Actually no matter if someone doesn’t be aware of after that its up to other visitors that they
will help, so here it occurs.
best google hacklink services.
Hello to all, how is the whole thing, I think every one is getting more from this site, and your views
are pleasant in support of new users.
Yes! Finally something about 1.
The depth of The research really stands out. It’s clear you’ve put a lot of thought into this.
The dedication to high quality content shows. It’s like you actually care or something.
The Writing is like a trusted compass, always pointing me in the direction of enlightenment.
A gift for explaining things, making the rest of us look bad.
It’s fantastic that you are getting ideas
from this paragraph as well as from our dialogue made here.
It’s actually a satisfying accomplishment when the boomerang truly comes proper back to you and you catch it completely!
blog web site index.
This is one of the most comprehensive articles I’ve read on this topic. Kudos!
The insights are like a fine wine—rich, fulfilling, and leaving me wanting more.
Tackled this hard to understand issue with elegance. I didn’t know we were at a ballet.
You’ve done a fantastic job of breaking down this topic. Thanks for the clarity!
The insights are like a favorite book; I find new treasures each time I return.
Brilliant writing! You’ve perfectly captured the essence of the topic.
I love what you guys tend to be up too. This kind of clever work and exposure!
Keep up the great works guys I’ve incorporated you guys to
blogroll.
The ability to break down tough concepts is as impressive as a magician’s trick. Color me amazed.
The insights light up my intellect like fireworks. Thanks for the show!
Always learning something new here, because apparently, I didn’t pay enough attention in school.
The content is like a treasure chest; every post uncovers gems of wisdom. X marks the spot here.
The Writing is like a trusted compass, always pointing me in the direction of enlightenment.
The dedication to high quality content shows. It’s like you actually care or something.
The knack for making hard to understand concepts readable is something I greatly admire.
I appreciate the balance and fairness in The writing. Great job!
The insights are like keys, unlocking new perspectives and ideas I hadn’t considered.
The work is both informative and thought-provoking. I’m really impressed by the high quality of The content.
web site best social media services.