CODEWITHSUNDEEP
hibernategrailsgrails-orm
spock99
spock99

Reputation: 1184

How to write this Grails GORM Hibernate query

New to GORM, can't figure how to do this query. Here are my domain classes (minus unnecessary info):

User {...} //domain object (from springsecurity)

BasicProfile {
   User user
   static hasMany = [applicants:Applicant]
}

Applicant {
   static belongsTo = BasicProfile
   int applicantNumber
}

My BasicProfile will always have 1 or 2 Applicants. Right now I'm using a hasMany, though I may switch to having an applicant1 and applicant2 in the BasicProfile at a later time.

What I am trying to get in pseudo sql:

select the applicant object from a BasicProfile where the applicantNumber = 1 and BasicProfile.user.id == springSecurityService.principal.id

Basically I'm trying to get back one of the Applicant objects from the BasicProfile, given the session user and an applicantNumber.

Upvotes: 1

Views: 240

Answers (2)

dmahapatro
dmahapatro

Reputation: 50275

How about this?

User user = User.load(springSecurityService.principal.id)
def applicant = BasicProfile.findByUser(user)
                            .applicants?.find{it.applicantNumber == 1}

Inspired by Burt's answer and using dynamicFinders.

Upvotes: 2

user800014
user800014

Reputation:

You can try:

User user = User.get(...) //get's the user instance
BasicProfile.createCriteria().get {
  eq('user', user)
  applicants {
    eq('applicantNumber', 1) //filter by applicantNumber
  }
}

Upvotes: 1

Related Questions