groovy grails构建测试数据（buildtestdata插件）如何创建多对多

Question

使用Grails 2.2.4。和build-test-data:2.0.5。我在使用conf-bootstrap.groovy在DB中添加多对多实例时失败了。使用MySQL作为数据库。

以下是简化的域类：

class Reseller {
String resellerName
static hasMany = [addresses: Address]

}

而且

class Address {
String address1 
static hasMany = [resellers: Reseller]
static belongsTo = [Reseller]   

这导致运行时在MySQL中创建...

（下面是一个简单的ER图，因为我无法从MySQL工作台图中发布图像）

reseller==>1到many==>reseller_address<==many到1<==address

如果不存在address(idbigint(20)NOT NULL AUTO_INCREMENT，versionbigint(20)NOT NULL，address1varchar(255)NOT NULL，主键(id))则创建表(address))Engine=innoDB DEFAULT charset=utf8 AUTO_INCREMENT=1；

如果不存在reseller(idbigint(20)不为空AUTO_INCREMENT，versionbigint(20)不为空，reseller_namevarchar(255)不为空，主键(id))则创建表(id)；

如果不存在则创建表reseller_address(address_idbigint(20)不为空，reseller_idbigint(20)不为空，主键(reseller_id，address_id)，键fk3f39fb15cb44906f(reseller_id)，键

更改表reseller_address添加约束fk3f39fb1541937ea5外键(address_id)引用address(id)，添加约束fk3f39fb15cb44906f外键(reseller_id)引用reseller(id)；

下面是bootstrap.groovy：

    import grails.buildtestdata.mixin.Build
import manytomany.*

class BootStrap {

    def init = { servletContext ->
        Address ad1 = Address.build()
        Reseller rs1 = Reseller.build()

        //comment out next line to run and see tables being built.
        rs1.addToAddresses(address: ad1) //does not work.  see error below                      
    }
    def destroy = {
    }
}

上面的结果是下面的错误。这还会导致MySQL中DB中的表为零。我可以看到它们被创建，然后它们在下面的错误处消失。

    | Running Grails application
Hibernate: insert into address (version, address1) values (?, ?)
Hibernate: insert into reseller (version, reseller_name) values (?, ?)
| Error 2013-11-13 17:37:01,543 [localhost-startStop-1] ERROR hibernate.AssertionFailure  - an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
Message: null id in manytomany.Address entry (don't flush the Session after an exception occurs)
    Line | Method
->>  334 | innerRun  in java.util.concurrent.FutureTask$Sync
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|    166 | run       in java.util.concurrent.FutureTask
|   1145 | runWorker in java.util.concurrent.ThreadPoolExecutor
|    615 | run       in java.util.concurrent.ThreadPoolExecutor$Worker
^    724 | run . . . in java.lang.Thread
| Error 2013-11-13 17:37:01,628 [localhost-startStop-1] ERROR context.GrailsContextLoader  - Error initializing the application: null id in manytomany.Address entry (don't flush the Session after an exception occurs)
Message: null id in manytomany.Address entry (don't flush the Session after an exception occurs)
    Line | Method
->>  334 | innerRun  in java.util.concurrent.FutureTask$Sync
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|    166 | run       in java.util.concurrent.FutureTask
|   1145 | runWorker in java.util.concurrent.ThreadPoolExecutor
|    615 | run       in java.util.concurrent.ThreadPoolExecutor$Worker
^    724 | run . . . in java.lang.Thread

Answer 1

试试看，您可以通过.build(...)将您的关联传递给父类：

def init = { servletContext ->
    Address ad1 = Address.build()
    Reseller rs1 = Reseller.build(addresses:[ad1])
} 

文档：https://github.com/tednaleid/build-test-data/wiki/samplecode