Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
435 views
in Technique[技术] by (71.8m points)

How to limit the size of association in grails?

I have a grails domain class as below :

 class Order {
   String orderId = 'OD' + System.nanoTime().toString()
   Date orderedDate
   String itemName
   List bids;
   static hasMany = [ bids: Bid ;likedUsers: User,]
   static belongsTo =[owner:User]
  }

 class Bid {
  Integer amount
  User bidedUser
     static belongsTo = [Order]
  }
   class User {
     String username
     String password
     String emailId
     List orders
     static hasMany = [orders:Order]
     }

What I am trying to do is , to query for an order with bits with maxResult of 10 as like

 def critObj = Order.createCriteria() 
     critObj.list{
       eq("id" ,1)
       bids {
         maxResult(10) //Trying to fetch only 10 records
        }
    }

How can I load only 10 bits(associations) , is it possible? . Or My design of domain class is wrong?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

I think this should work:

def results = Bid.withCriteria {
    order {
        eq 'id', 1
    }
    projections {
        property 'order'
    }
    maxResults 10
}

But please note that you have to change your Bid domain class to add the relation in the other way from Bid to Order:

class Bid {
    ...
    static belongsTo = [order: Order]
}

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...