6 things you need to know about GORM 6

6 things you need to
know about GORM 6
Álvaro Sánchez-Mariscal
@alvaro_sanchez

About me
— Coming from Madrid
!
— Developer since 2001 (Java / Spring stack).
— Grails fanboy since v0.4.
— Working @ OCI since 2015: Groovy, Grails & Micronaut!
— Father since 2017!
"
@alvaro_sanchez

1. GORM without Grails /
Spring Boot / Micronaut
@alvaro_sanchez

build.gradle
dependencies {
compile 'org.codehaus.groovy:groovy:2.5.0'
compile "org.grails:grails-datastore-gorm-hibernate5:6.1.9.RELEASE"
compile 'org.hibernate:hibernate-validator:6.0.2.Final'
compileOnly 'org.glassfish.web:el-impl:2.2.1-b05'
runtime 'org.glassfish:javax.el:3.0.1-b08'
runtime "com.h2database:h2:1.4.192"
runtime "org.apache.tomcat:tomcat-jdbc:8.5.0"
runtime "org.apache.tomcat.embed:tomcat-embed-logging-log4j:8.5.0"
runtime "org.slf4j:slf4j-api:1.7.10"
runtime "ch.qos.logback:logback-classic:1.2.3"
testCompile "org.spockframework:spock-core:1.1-groovy-2.4"
}
@alvaro_sanchez

2. Data Services
@alvaro_sanchez

Data Services
Auto-generated persistence logic from interfaces and
abstract classes
@Service(Book)
interface BookService {
Book getBook(Serializable id)
}
@alvaro_sanchez

Advantages
— Type safety.
— Signatures statically compiled.
— Testing
— Since they are interfaces, can be easily tested with
Spock mocks.
@alvaro_sanchez

Advantages
— Performance.
— No runtime proxies, eveything is compile-time.
— Transaction management.
— Methods are wrapped in a transaction (read-only
for read operations).
@alvaro_sanchez

Abstract classes support
@Service(Book)
abstract class BookService {
abstract Book getBook(Serializable id)
abstract Author getAuthor(Serializable id)
Book updateBook(Serializable id, Serializable authorId) {
Book book = getBook(id)
if(book != null) {
Author author = getAuthor(authorId)
if(author == null) throw new IllegalArgumentException("Author does not exist")
book.author = author
book.save()
}
return book
}
}
@alvaro_sanchez

Pagination support
Data service:
@Service(Book)
List<Book> findBooks(String title, Map args)
}
Usage:
List<Book> books = bookService.findBooks(
"The Stand",
[offset:10, max:10, sort:'title', order:'desc']
)
@alvaro_sanchez

"Dynamic ﬁnder"-like queries
Just that they are statically compiled!
@Service(Book)
List<Book> findByTitleAndPublishDateGreaterThan(String title, Date publishDate)
}
@alvaro_sanchez

Where queries
@Service(Book)
@Where({ title ==~ pattern && releaseDate > fromDate })
Book searchBooks(String pattern, Date fromDate)
}
@alvaro_sanchez

Query joins
@Service(Book)
@Join('author')
Book find(String title)
@Join(value='author', type=LEFT)
Book findAnother(String title)
}
@alvaro_sanchez

HQL queries
@Service(Book)
@Query("from ${Book book} where ${book.title} like $pattern")
Book searchByTitle(String pattern)
}
@alvaro_sanchez

Projections
@Service(Book)
Date findBookReleaseDate(String title)
List<Date> findBookReleaseDate(String publisher)
@Query("select $b.releaseDate from ${Book b} where $b.publisher = $publisher order by $b.releaseDate")
List<Date> findBookReleaseDatesHql(String publisher)
}
@alvaro_sanchez

3. Unit testing
@alvaro_sanchez

Unit testing
class ClubSpec extends Specification {
@Shared @AutoCleanup HibernateDatastore hibernateDatastore
void setupSpec() { hibernateDatastore = new HibernateDatastore(Club) }
@Rollback
void "it can persist clubs"() {
when:
new Club(name: "Real Madrid").save(flush: true)
then:
Club.count() == old(Club.count()) + 1
}
}
@alvaro_sanchez

4. Multiple datasources
@alvaro_sanchez

application.yml
dataSource:
dbCreate: create-drop
url: "jdbc:h2:mem:laliga"
dataSources:
premier:
dbCreate: create-drop
url: "jdbc:h2:mem:premier"
@alvaro_sanchez

Domain class
class Club {
static mapping = {
datasource ConnectionSource.ALL
}
String name
String stadium
}
@alvaro_sanchez

Data source namespace
Club.premier.findByName("Liverpool")
//...
Club rma = new Club(name: "Real Madrid")
club.save() // Default data source
@alvaro_sanchez

5. Multi-Tenancy
@alvaro_sanchez

Modes
— DATABASE: a separate database with a separate
connection pool is used to store each tenants data.
— SCHEMA: the same database, but different schemas are
used to store each tenants data.
— DISCRIMINATOR - The same database is used with a
discriminator used to partition and isolate data.
@alvaro_sanchez

AST Transformations
— @CurrentTenant: resolve the current tenant for the
context of a class or method.
— @Tenant: use a speciﬁc tenant for the context of a
class or method
— @WithoutTenant: execute logic without a speciﬁc
tenant (using the default connection)
@alvaro_sanchez

AST Transformations
@CurrentTenant // resolve the current tenant for every method
class TeamService {
@WithoutTenant // execute the countPlayers method without a tenant id
int countPlayers() {
Player.count()
}
@Tenant({"another"}) // use the tenant id "another" for all GORM logic within the method
List<Team> allTwoTeams() {
Team.list()
}
List<Team> listTeams() {
Team.list(max:10)
}
@Transactional
void addTeam(String name) {
new Team(name:name).save(flush:true)
}
}
@alvaro_sanchez

Conﬁguration
grails:
gorm:
multiTenancy:
mode: DATABASE
tenantResolverClass: org.grails.datastore.mapping.multitenancy.web.SubDomainTenantResolver
@alvaro_sanchez

Domain classes
class Book implements MultiTenant<Book> {
String title
}
@alvaro_sanchez

Querying
List<Book> books = withCurrent {
Book.list()
}
//...
List<Book> books = withId("otherTenant") {
Book.list()
}
@alvaro_sanchez

Domain class
class Club implements RxMongoEntity<Club> {
ObjectId id
String name
String stadium
}
@alvaro_sanchez

GORM operations
new Book(title:"The Stand")
.save() // Returns an rx.Observable<Book>
.subscribe { Book it ->
// If you don't subscribe, it won't be executed
println "ID = ${book.id}"
}
@alvaro_sanchez

Q & A
Álvaro Sánchez-Mariscal
@alvaro_sanchez

6 things you need to know about GORM 6

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to 6 things you need to know about GORM 6

Similar to 6 things you need to know about GORM 6 (20)

More from Alvaro Sanchez-Mariscal

More from Alvaro Sanchez-Mariscal (20)

Recently uploaded

Recently uploaded (20)

6 things you need to know about GORM 6