test/groovy/org/codehaus/groovy/grails/orm/hibernate/FindByMethodTests.groovy

   1 /**
   2  * @author Graeme Rocher
   3  * @since 1.0
   4  *
   5  * Created: Nov 28, 2007
   6  */
   7 package org.codehaus.groovy.grails.orm.hibernate
   8 class FindByMethodTests extends AbstractGrailsHibernateTests {
   9
  10     protected void onSetUp() {
  11         gcl.parseClass '''
  12 class Book {
  13     Long id
  14     Long version
  15     String title
  16     Date releaseDate
  17     static constraints  = {
  18         releaseDate(nullable:true)
  19     }
  20 }
  21 class User {
  22     Long id
  23     Long version
  24     String firstName
  25 }
  26 '''
  27     }
  28
  29
  30     void testNullParameters() {
  31         def bookClass = ga.getDomainClass("Book").clazz
  32
  33         assert bookClass.newInstance(title:"The Stand").save()
  34
  35         assert bookClass.findByReleaseDate(null)
  36         assert bookClass.findByTitleAndReleaseDate("The Stand", null)
  37
  38     }
  39
  40     void testFindByIsNotNull() {
  41         def userClass = ga.getDomainClass("User").clazz
  42
  43         userClass.newInstance(firstName:"Bob").save()
  44         userClass.newInstance(firstName:"Jerry").save()
  45         userClass.newInstance(firstName:"Fred").save(flush:true)
  46
  47         def users = userClass.findAllByFirstNameIsNotNull()
  48         users = userClass.findAllByFirstNameIsNotNull()
  49
  50         assertEquals 3, users.size()
  51     }
  52
  53 }