forked from grails/grails
/
ExecuteUpdateTests.groovy
62 lines (45 loc) · 1.62 KB
/
ExecuteUpdateTests.groovy
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
/**
* @author Graeme Rocher
* @since 1.0
*
* Created: Nov 28, 2007
*/
package org.codehaus.groovy.grails.orm.hibernate
class ExecuteUpdateTests extends AbstractGrailsHibernateTests {
protected void onSetUp() {
gcl.parseClass '''
class Customer {
Long id
Long version
String name
}
'''
}
void testExecuteUpdate() {
def custClass = ga.getDomainClass("Customer").clazz
assert custClass.newInstance(name:"Fred").save()
assert custClass.newInstance(name:"Bob").save()
assert custClass.newInstance(name:"Ginger").save()
assertEquals 3, custClass.count()
custClass.executeUpdate("delete from Customer")
assertEquals 0, custClass.count()
}
void testExecuteUpdatePositionalParams() {
def custClass = ga.getDomainClass("Customer").clazz
assert custClass.newInstance(name:"Fred").save()
assert custClass.newInstance(name:"Bob").save()
assert custClass.newInstance(name:"Ginger").save()
assertEquals 3, custClass.count()
custClass.executeUpdate("delete from Customer c where c.name=?", ['Fred'])
assertEquals 2, custClass.count()
}
void testExecuteUpdateOrdinalParams() {
def custClass = ga.getDomainClass("Customer").clazz
assert custClass.newInstance(name:"Fred").save()
assert custClass.newInstance(name:"Bob").save()
assert custClass.newInstance(name:"Ginger").save()
assertEquals 3, custClass.count()
custClass.executeUpdate("delete from Customer c where c.name=:name", [name:'Fred'])
assertEquals 2, custClass.count()
}
}