test/groovy/org/codehaus/groovy/grails/orm/hibernate/ManyToManyTests.groovy

   1 package org.codehaus.groovy.grails.orm.hibernate;
   2
   3 import org.codehaus.groovy.grails.commons.*
   4
   5 class ManyToManyTests extends AbstractGrailsHibernateTests {
   6
   7         void testManyToManyDomain() {
   8                 def authorDomain = ga.getDomainClass("Author")
   9                 def bookDomain = ga.getDomainClass("Book")
  10
  11
  12                 def books = authorDomain?.getPropertyByName("books")
  13                 def authors = bookDomain?.getPropertyByName("authors")
  14
  15                 assert books?.isManyToMany()
  16                 assert authors?.isManyToMany()
  17                 assert !books?.isOneToMany()
  18                 assert !authors?.isOneToMany()
  19         }
  20         void testManyToManyMapping() {
  21                 def authorClass = ga.getDomainClass("Author")
  22                 def bookClass = ga.getDomainClass("Book")
  23                 def a = authorClass.newInstance()
  24
  25                 a.addToBooks(bookClass.newInstance())
  26                 a.save(true)
  27
  28                 a = null
  29
  30                 assertEquals 1, bookClass.clazz.list().size()
  31
  32                 def b = bookClass.clazz.get(1)
  33                 assert b
  34                 assert b.authors
  35
  36                 a = authorClass.clazz.get(1)
  37                 assert a
  38                 assert a.books
  39
  40                 assertEquals b, a.books.find { it.id == 1}
  41                 this.session.flush()
  42
  43                 this.session.evict(a)
  44                 this.session.evict(b)
  45
  46                 a = authorClass.clazz.get(1)
  47                 assert a
  48                 assert a.books
  49
  50                 b = bookClass.clazz.get(1)
  51                 assert b
  52                 assert b.authors
  53         }
  54
  55         void onSetUp() {
  56                 this.gcl.parseClass('''
  57 class Book {
  58         Long id
  59         Long version
  60         Set authors
  61         def belongsTo = Author
  62         def hasMany = [authors:Author]
  63 }
  64 class Author {
  65         Long id
  66         Long version
  67         Set books
  68         def hasMany = [books:Book]
  69 }
  70 class ApplicationDataSource {
  71            boolean pooling = true
  72            boolean logSql = true
  73            String dbCreate = "create-drop" // one of 'create', 'create-drop','update'
  74            String url = "jdbc:hsqldb:mem:testDB"
  75            String driverClassName = "org.hsqldb.jdbcDriver"
  76            String username = "sa"
  77            String password = ""
  78 }
  79 '''
  80                 )
  81         }
  82
  83         void onTearDown() {
  84
  85         }
  86 }