Grails集成测试不会回滚 [英] Grails Integration Test Does NOT Rollback

问题描述

我从书中学习Grails Grails In Action 并且我试图从示例中运行集成测试。在本书中，它表示每个集成测试功能都应该在每次测试结束时回滚操作。它不回滚每个事务（因为当我完成数据库很脏）。我试图找出原因并找到了一个名为事务性的属性。据称你将这个属性设置为true，它会使测试用例成为事务性的，但它似乎没有改变行为。我已经包含了下面的单元测试代码。

我使用grails 1.3.7并连接到MySql数据库。测试成功运行，它不会回滚。

UserIntegrationTests.groovy：

$我在这个集成测试中做错了什么，它会跳过回滚吗？ b $ b

  package com.grailsinaction 
 
 import framework.TestTools 
 $ b $ class UserIntegrationTests扩展GroovyTestCase {
 static transactional = true 
 
 protected void setUp（）{
 super.setUp（）
} 
 
保护void tearDown（）{
 super。 tearDown（）
} 
 
 testCreateUser（）{
 TestTools.banner（log，testCreateUser（））
 
 def user = new User （userId：joe，密码：secret）
 assertNotNull user.save（）
 assertNotNull user.id 
 $ b $ def findUser = User.get（user.id） 
 assertEquals'joe'，foundUser.userId 
} 
 
 void testSaveAndUpdate（）{
 TestTools.banner（log，testSaveAndUpdate（））
 
 def user = new User（userI d：joe2，密码：secret）
 assertNotNull user.save（）
 
 def foundUser = User.get（user.id）
 foundUser.password =' sesame'
 foundUser.save（）
 
 def editedUser = User.get（user.id）
 assertEquals'sesame'，editedUser.password 
} 
 
 void testSaveThenDelete（）{
 TestTools.banner（log，testSaveThenDelete（））
 
 def user = new User（userId：'joe3'，password：'secret '）
 assertNotNull user.save（）
 
 def foundUser = User.get（user.id）
 foundUser.delete（）
 assertFalse User.exists（foundUser .id）
} 
 
 void testValidation（）{
 TestTools.banner（log，testValidation（））
 
 def user = new User （userId：'chuck-norris'，密码：'tiny'）
 assertFalse user.validate（）
 assertTrue user.hasErrors（）
 
 def errors = user.erro rs 
 assertNotNull错误
 
 errors.allErrors.each {
 log.info（field：$ {it.field}，code = $ {it.code}，rejected = $ {it.rejectedValue}）
} 
} 
} 
  

User.groovy

  package com.grailsinaction 
 
 class User {
字符串userId 
字符串密码
日期日期创建
概要文件概要
 
静态约束= {
 userId（size：3..20， unique：true）
密码（size：6..8，验证者：{password，user  - > 
 return（password！= user.userId）
}）
 dateCreated（）
 profile（可空值：true）
} 
 
 static mapping = {
 profile lazy：false 
} 
 
 static hasMany = [posts：Post] 
} 
  pre> 
 
 
 测试执行日志  
 
 
 测试在8:28 PM开始... 
欢迎使用Grails 1.3.7  -  http://grails.org/ 
根据Apache标准许可证2.0获得许可$ 
 Grails home设置为：C ：\ Users \jmquigley\workspace\apps\Grails\grails-1.3.7 
基本目录：C：\ Users \jmquigley\workspace\samples\lang-grails\\ \\ hubbub 
正在解析依赖项... 
在963ms中解决的依赖项。 
运行脚本C：\ Users \jmquigley\workspace\apps\Grails\grails-1.3.7\scripts\TestApp.groovy 
设置为测试
的环境[groovyc]将1个源文件编译为C：\ Users \jmquigley\workspace\samples\lang-grails\hubbub\target\classes 
 [mkdir]创建目录：C：\ Users \jmquigley\workspace\samples\lang-grails\hubbub\target\test-reports\html 
 [mkdir]创建目录：C：\ Users \jmquigley\workspace \samples\lang-grails\hubbub\target\test-reports\plain 
开始集成测试阶段... 
 [groovyc]将1个源文件编译为C：\ Users \jmquigley\workspace\samples\lang-grails\hubbub\target\classes 
 [groovyc]将1个源文件编译为C：\ Users \jmquigley\workspace\samples\\ \\ lang-grails \hubbub\target\classes 
 [信息] 201 10417 @ 20：28：42,959：grails.spring.BeanBuilder：[RuntimeConfiguration]为环境配置数据源：TEST 
 [groovyc]将1个源文件编译为C：\ Users \ jmquigley \workspace\samples \ lang-grails \hubbub\target\test-classes\integration 
 --------------------------- ---------------------------- 
运行4个集成测试... 
运行测试com.grailsinaction.UserIntegrationTests ... 
  - 从testCreateUser输出 -  
 [INFO] 20110417 @ 20：28：46,897：groovy.util.GroovyTestCase：测试用例：testCreateUser（）
  - 从testSaveAndUpdate -  
 [INFO] 20110417 @ 20：28：47,534：groovy.util.GroovyTestCase：测试用例：testSaveAndUpdate（）
  - 从testSaveThenDelete  -  
输出[INFO] 20110417 @ 20 ：28：47,568：groovy.util.GroovyTestCase：测试用例：testSaveThenDelete（）
  - 从testValidation输出 -  
 [INFO] 20110417 @ 20：28：47,642：groovy.util.GroovyTestCase：Test案例：testValidation（）
 [INFO] 20110417 @ 20：28：47,66 8：groovy.util.GroovyTestCase：字段：密码，代码= size.toosmall，被拒绝=小
空
 PASSED 
 1173ms完成测试... 
 ---- -------------------------------------------------- -  
测试通过：4 
测试失败：0 
 ----------------------------- -------------------------- 
 [junitreport]正在处理C：\ Users \jmquigley\workspace\samples\ lang-grails \hubbub\target\test-reports\TESTS-TestSuites.xml to C：\Users\JMQUIG~1\AppData\Local\Temp\\\
ull90011239 
 [junitreport ]加载样式表C：\ Users \jmquigley\workspace\apps\Grails\grails-1.3.7\lib\junit-frames.xsl 
 [junitreport]转换时间：415ms 
 [junitreport]删除：C：\ Users \JMQUIG〜1 \AppData\Local\Temp\\\
ull90011239 
测试已通过 - 在target \test-reports中查看报告
应用程序上下文关闭... 
应用程序上下文关闭。 
 
处理完成退出码0 
  
 
 
解决方案
测试（和服务）在默认情况下是事务性的，所以您通常只在 false 时指定静态事务性 。如果你没有指定方言，它可能是自动检测MySQL，但是这些表是使用可能是MyISAM的默认引擎创建的。 MyISAM表不是事务性的。请确保在使用MySQL时指定InnoDB方言，例如 
 
 
  test {
 dataSource {
 dialect = org.hibernate.dialect.MySQLInnoDBDialect 
 driverClassName ='com.mysql.jdbc.Driver'
 username ='...'
 password ='...'
 url ='...'
 dbCreate ='update'
} 
} 
  
 
 $ b $如果你在所有的环境中使用MySQL，你可以将它移动到顶层，例如
  dataSource {
 pooled = true 
 dialect = org.hibernate.dialect.MySQLInnoDBDialect 
 driverClassName ='com.mysql.jdbc.Driver'
} 
  
 
I'm learning grails from the book "Grails In Action" and I'm trying to run integration tests from the examples.  In the book it says that each integration test function should roll back its operations as each test finishes.  It is NOT rolling back each transaction (as when I finish the database is dirty).  I tried to find out why and found found a property called "transactional".  Allegedly you set this property to true and it will make the test case transactional, but it doesn't appear to change the behavior.  I have included the code for the unit tests below.


I'm using grails 1.3.7 and connecting to a MySql database.  The tests run successfully, it just doesn't rollback.  Am I doing something wrong in this integration test that it skips the rollback?

UserIntegrationTests.groovy:
package com.grailsinaction

import framework.TestTools

class UserIntegrationTests extends GroovyTestCase {
    static transactional = true

    protected void setUp() {
        super.setUp()
    }

    protected void tearDown() {
        super.tearDown()
    }

    void testCreateUser() {
        TestTools.banner(log, "testCreateUser()")

        def user = new User(userId:"joe", password:"secret")
        assertNotNull user.save()
        assertNotNull user.id

        def foundUser = User.get(user.id)
        assertEquals 'joe', foundUser.userId
    }

    void testSaveAndUpdate() {
        TestTools.banner(log, "testSaveAndUpdate()")

        def user = new User(userId:"joe2", password:"secret")
        assertNotNull user.save()

        def foundUser = User.get(user.id)
        foundUser.password = 'sesame'
        foundUser.save()

        def editedUser = User.get(user.id)
        assertEquals 'sesame', editedUser.password
    }

    void testSaveThenDelete() {
        TestTools.banner(log, "testSaveThenDelete()")

        def user = new User(userId: 'joe3', password: 'secret')
        assertNotNull user.save()

        def foundUser = User.get(user.id)
        foundUser.delete()
        assertFalse User.exists(foundUser.id)
    }

    void testValidation() {
        TestTools.banner(log, "testValidation()")

        def user = new User(userId: 'chuck-norris', password: 'tiny')
        assertFalse user.validate()
        assertTrue user.hasErrors()

        def errors = user.errors
        assertNotNull errors

        errors.allErrors.each {
            log.info("field: ${it.field}, code=${it.code}, rejected=${it.rejectedValue}")
        }
    }
}
User.groovy
package com.grailsinaction

class User {
    String userId
    String password
    Date dateCreated
    Profile profile

    static constraints = {
        userId(size: 3..20, unique: true)
        password(size: 6..8, validator: {password, user ->
            return (password != user.userId)
        })
        dateCreated()
        profile(nullable: true)
    }

    static mapping = {
        profile lazy: false
    }

    static hasMany = [posts : Post]
}
Test Execution Log
Testing started at 8:28 PM ...
Welcome to Grails 1.3.7 - http://grails.org/
Licensed under Apache Standard License 2.0
Grails home is set to: C:\Users\jmquigley\workspace\apps\Grails\grails-1.3.7
Base Directory: C:\Users\jmquigley\workspace\samples\lang-grails\hubbub
Resolving dependencies...
Dependencies resolved in 963ms.
Running script C:\Users\jmquigley\workspace\apps\Grails\grails-1.3.7\scripts\TestApp.groovy
Environment set to test
  [groovyc] Compiling 1 source file to C:\Users\jmquigley\workspace\samples\lang-grails\hubbub\target\classes
    [mkdir] Created dir: C:\Users\jmquigley\workspace\samples\lang-grails\hubbub\target\test-reports\html
    [mkdir] Created dir: C:\Users\jmquigley\workspace\samples\lang-grails\hubbub\target\test-reports\plain
Starting integration test phase ...
  [groovyc] Compiling 1 source file to C:\Users\jmquigley\workspace\samples\lang-grails\hubbub\target\classes
  [groovyc] Compiling 1 source file to C:\Users\jmquigley\workspace\samples\lang-grails\hubbub\target\classes
[INFO ]20110417@20:28:42,959:grails.spring.BeanBuilder: [RuntimeConfiguration] Configuring data source for environment: TEST
  [groovyc] Compiling 1 source file to C:\Users\jmquigley\workspace\samples\lang-grails\hubbub\target\test-classes\integration
-------------------------------------------------------
Running 4 integration tests...
Running test com.grailsinaction.UserIntegrationTests...
--Output from testCreateUser--
[INFO ]20110417@20:28:46,897:groovy.util.GroovyTestCase: Test Case: testCreateUser()
--Output from testSaveAndUpdate--
[INFO ]20110417@20:28:47,534:groovy.util.GroovyTestCase: Test Case: testSaveAndUpdate()
--Output from testSaveThenDelete--
[INFO ]20110417@20:28:47,568:groovy.util.GroovyTestCase: Test Case: testSaveThenDelete()
--Output from testValidation--
[INFO ]20110417@20:28:47,642:groovy.util.GroovyTestCase: Test Case: testValidation()
[INFO ]20110417@20:28:47,668:groovy.util.GroovyTestCase: field: password, code=size.toosmall, rejected=tiny
null
PASSED
Tests Completed in 1173ms ...
-------------------------------------------------------
Tests passed: 4
Tests failed: 0
-------------------------------------------------------
[junitreport] Processing C:\Users\jmquigley\workspace\samples\lang-grails\hubbub\target\test-reports\TESTS-TestSuites.xml to C:\Users\JMQUIG~1\AppData\Local\Temp\null90011239
[junitreport] Loading stylesheet C:\Users\jmquigley\workspace\apps\Grails\grails-1.3.7\lib\junit-frames.xsl
[junitreport] Transform time: 415ms
[junitreport] Deleting: C:\Users\JMQUIG~1\AppData\Local\Temp\null90011239
Tests PASSED - view reports in target\test-reports
Application context shutting down...
Application context shutdown.

Process finished with exit code 0

解决方案
Tests (and services) are transactional by default so you only typically specify the static transactional property when it's false. If you haven't specified the Dialect it's probably auto-detecting MySQL but then the tables are created using the default engine which is probably MyISAM. MyISAM tables which are not transactional. Be sure to specify the InnoDB dialect whenever you use MySQL, e.g.
test {
   dataSource {
      dialect= org.hibernate.dialect.MySQLInnoDBDialect
      driverClassName = 'com.mysql.jdbc.Driver'
      username = '...'
      password = '...'
      url = '...'
      dbCreate = 'update'
   }
}
or if you're using MySQL for all environments, you can move it to the top-level, e.g.
dataSource {
   pooled = true
   dialect = org.hibernate.dialect.MySQLInnoDBDialect
   driverClassName = 'com.mysql.jdbc.Driver'
}


                        
这篇关于Grails集成测试不会回滚的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！