grails.gorm.tests.CriteriaBuilderSpec.groovy Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of grace-datastore-gorm-tck Show documentation
Show all versions of grace-datastore-gorm-tck Show documentation
Grace Data : Grace Datastore Gorm Tck
package grails.gorm.tests
import spock.lang.Ignore
/**
* Abstract base test for criteria queries. Subclasses should do the necessary setup to configure GORM
*/
class CriteriaBuilderSpec extends GormDatastoreSpec {
void "Test count distinct projection"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save()
}
new TestEntity(name:"Chuck", age: age-1, child:new ChildEntity(name:"Chuckie")).save()
5 == ChildEntity.count()
def criteria = TestEntity.createCriteria()
when:
def result = criteria.get {
projections {
countDistinct "age"
}
}
then:
result == 4
}
@Ignore // ignored this test because the id() projection does not actually exist in GORM for Hibernate
void "Test id projection"() {
given:
def entity = new TestEntity(name:"Bob", age: 44, child:new ChildEntity(name:"Child")).save(flush:true)
when:
def result = TestEntity.createCriteria().get {
projections { id() }
idEq entity.id
}
then:
result != null
result == entity.id
}
void "Test idEq method"() {
given:
def entity = new TestEntity(name:"Bob", age: 44, child:new ChildEntity(name:"Child")).save(flush:true)
when:
def result = TestEntity.createCriteria().get { idEq entity.id }
then:
result != null
result.name == 'Bob'
}
void "Test disjunction query"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each { new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save() }
def criteria = TestEntity.createCriteria()
when:
def results = criteria.list {
or {
like('name', 'B%')
eq('age', 41)
}
}
then:
3 == results.size()
}
void "Test conjunction query"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each { new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save() }
def criteria = TestEntity.createCriteria()
when:
def results = criteria.list {
and {
like('name', 'B%')
eq('age', 40)
}
}
then:
1 == results.size()
}
void "Test list() query"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child: new ChildEntity(name:"$it Child")).save()
}
def criteria = TestEntity.createCriteria()
when:
def results = criteria.list {
like('name', 'B%')
}
then:
2 == results.size()
when:
criteria = TestEntity.createCriteria()
results = criteria.list {
like('name', 'B%')
maxResults 1
}
then:
1 == results.size()
}
void "Test count()"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save()
}
def criteria = TestEntity.createCriteria()
when:
def result = criteria.count {
like('name', 'B%')
}
then:
2 == result
}
void "Test obtain a single result"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save()
}
def criteria = TestEntity.createCriteria()
when:
def result = criteria.get {
eq('name', 'Bob')
}
then:
result != null
"Bob" == result.name
}
void "Test order by a property name"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save()
}
def criteria = TestEntity.createCriteria()
when:
def results = criteria.list {
like('name', 'B%')
order "age"
}
then:
"Bob" == results[0].name
"Barney" == results[1].name
when:
criteria = TestEntity.createCriteria()
results = criteria.list {
like('name', 'B%')
order "age", "desc"
}
then:
"Barney" == results[0].name
"Bob" == results[1].name
}
void "Test get minimum value with projection"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save()
}
Thread.sleep 500
def criteria = TestEntity.createCriteria()
when:
def result = criteria.get {
projections {
min "age"
}
}
then:
40 == result
when:
criteria = TestEntity.createCriteria()
result = criteria.get {
projections {
max "age"
}
}
then:
43 == result
when:
criteria = TestEntity.createCriteria()
def results = criteria.list {
projections {
max "age"
min "age"
}
}.flatten()
then:
2 == results.size()
43 == results[0]
40 == results[1]
[43, 40] == results
}
void "Test obtain property value using projection"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save()
}
def criteria = TestEntity.createCriteria()
when:
def results = criteria.list {
projections {
property "age"
}
}
then:
[40, 41, 42, 43] == results.sort()
}
void "Test obtain association entity using property projection"() {
given:
def age = 40
["Bob", "Fred", "Barney", "Frank"].each {
new TestEntity(name:it, age: age++, child:new ChildEntity(name:"$it Child")).save()
}
4 == ChildEntity.count()
def criteria = TestEntity.createCriteria()
when:
def results = criteria.list {
projections {
property "child"
}
}
then:
results.find { it.name == "Bob Child"}
results.find { it.name == "Fred Child"}
results.find { it.name == "Barney Child"}
results.find { it.name == "Frank Child"}
}
}