Grails

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.1
• Fix Version/s: 1.2-M4
• Component/s: Persistence, Plugins
• Labels:

  None

Add enhancement for something like:

def selectedList = [1, 2, 3]
Book.executeUpdate("delete Book b where b.id in ( :list )", list: selectedList)

This might be accomplished by changing:

metaClass.static.executeUpdate = {String query, Map argMap ->
    template.execute(  { session ->
            Query queryObject = session.createQuery(query)
            SessionFactoryUtils.applyTransactionTimeout(queryObject, template.sessionFactory);
            for (entry in argMap) {
>              entry.value instanceof List ? queryObject.setParameterList(entry.key, entry.value) :
>                      queryObject.setParameter(entry.key, entry.value)
            }
            queryObject.executeUpdate()
          } as HibernateCallback
         , true);
}

• Assignee:

  Graeme Rocher

  Reporter:

  Benjamin R. Doerr

• Created:

  23/Oct/09 11:46 AM

  Updated:

  09/Feb/10 6:02 PM

  Resolved:

  27/Oct/09 10:01 AM