Grails Gorm Native Finders Plugin
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.settings
grails-app
lib
scripts
src
test
web-app/WEB-INF
.classpath
.gitignore
.project
GormNativeFindersGrailsPlugin.groovy
LICENSE
README.md
application.properties
plugin.xml

README.md

gorm-native-finders

overview

the plugin allows grails developers to query domain objects using native groovy closures.

examples

    Book.findAll{ book -> book.author.name.lower().like("%dawkins%") && book.state == Book.ACTIVE }
    
    Book.count{ book -> book.author.name.like("%Dawkins%") && book.releaseDate.year() > 2009  }

How the plugin works

Using an AST Transformation, the AST Tree for the closure is retained in the generated class. Later , this AST tree is used in runtime to generate the HQL query.

How to use the plugin

as usual:

	grails install-plugin gorm-native-finders

What currently works

  • mathematical operators: +, -, *, /
  • binary comparison operators: =, >=, <=, <>, !=, like
  • logical operations &&, ||, !
  • Parentheses ( ) that indicates grouping
  • second(...), minute(...), hour(...), day(...), month(...), and year(...)
  • Any function or operator defined by EJB-QL 3.0: substring(), trim(), lower(), upper(), length(), locate(), abs(), sqrt(), bit_length(), mod()
  • str() for converting numeric or temporal values to a readable string
  • Only hibernate datasource is supported.

What is still missing (and hopefully will be added in upcoming releases)

  • Support for multiple datasources
  • spring-data-mapping integration
  • Pagination and sorting
  • improve compilation error reporting.

Version and Compatibility

the plugin is tested with Grails 1.3 and Grails 2

releases notes

0.2

  • add support for HQL functions ( substring(), trim(), lower(), day() ... etc )
  • add count method e.g. Account.count{ account -> account.branch == "London" && account.state == 1 }
  • add support for implicit joins e.g. find { Account account -> account.owner.id.medicareNumber = 123456 }

0.1

  • initial release

issues.

http://jira.grails.org/browse/GPGORMNATIVEFIND