test/groovy/org/codehaus/groovy/grails/orm/hibernate/ExecuteUpdateTests.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 ExecuteUpdateTests extends AbstractGrailsHibernateTests {
   9
  10     protected void onSetUp() {
  11         gcl.parseClass '''
  12 class Customer {
  13     Long id
  14     Long version
  15     String name
  16 }
  17 '''
  18     }
  19
  20     void testExecuteUpdate() {
  21         def custClass = ga.getDomainClass("Customer").clazz
  22
  23         assert custClass.newInstance(name:"Fred").save()
  24         assert custClass.newInstance(name:"Bob").save()
  25         assert custClass.newInstance(name:"Ginger").save()
  26
  27         assertEquals 3, custClass.count()
  28
  29         custClass.executeUpdate("delete from Customer")
  30
  31         assertEquals 0, custClass.count()
  32     }
  33
  34     void testExecuteUpdatePositionalParams() {
  35       def custClass = ga.getDomainClass("Customer").clazz
  36
  37         assert custClass.newInstance(name:"Fred").save()
  38         assert custClass.newInstance(name:"Bob").save()
  39         assert custClass.newInstance(name:"Ginger").save()
  40
  41         assertEquals 3, custClass.count()
  42
  43         custClass.executeUpdate("delete from Customer c where c.name=?", ['Fred'])
  44
  45         assertEquals 2, custClass.count()
  46     }
  47
  48     void testExecuteUpdateOrdinalParams() {
  49       def custClass = ga.getDomainClass("Customer").clazz
  50
  51         assert custClass.newInstance(name:"Fred").save()
  52         assert custClass.newInstance(name:"Bob").save()
  53         assert custClass.newInstance(name:"Ginger").save()
  54
  55         assertEquals 3, custClass.count()
  56
  57         custClass.executeUpdate("delete from Customer c where c.name=:name", [name:'Fred'])
  58
  59         assertEquals 2, custClass.count()
  60     }
  61
  62
  63 }