java.lang.Object
- org.springframework.test.context.support.AbstractTestExecutionListener
- - org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener

All Implemented Interfaces:
Ordered, TestExecutionListener
```
public class SqlScriptsTestExecutionListener
extends AbstractTestExecutionListener
```
TestExecutionListener that provides support for executing SQL scripts and inlined statements configured via the @Sql annotation.
Scripts and inlined statements will be executed before or after execution of the corresponding test method, depending on the configured value of the executionPhase flag.
Scripts and inlined statements will be executed without a transaction, within an existing Spring-managed transaction, or within an isolated transaction, depending on the configured value of SqlConfig.transactionMode() and the presence of a transaction manager.
Script Resources
For details on default script detection and how script resource locations are interpreted, see Sql.scripts().
Required Spring Beans
A PlatformTransactionManagerand a DataSource, just a PlatformTransactionManager, or just a DataSource must be defined as beans in the Spring ApplicationContext for the corresponding test. Consult the javadocs for SqlConfig.transactionMode(), SqlConfig.transactionManager(), SqlConfig.dataSource(), TestContextTransactionUtils.retrieveDataSource(org.springframework.test.context.TestContext, java.lang.String), and TestContextTransactionUtils.retrieveTransactionManager(org.springframework.test.context.TestContext, java.lang.String) for details on permissible configuration constellations and on the algorithms used to locate these beans.
Since:
4.1
Author:
Sam Brannen
See Also:
Sql, SqlConfig, SqlGroup, TestContextTransactionUtils, TransactionalTestExecutionListener, ResourceDatabasePopulator, ScriptUtils

Field Summary
- Fields inherited from interface org.springframework.core.Ordered
  HIGHEST_PRECEDENCE, LOWEST_PRECEDENCE

Constructor Summary
Constructors
Constructor Description
SqlScriptsTestExecutionListener()

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`afterTestMethod(TestContext testContext)`	Execute SQL scripts configured via `@Sql` for the supplied `TestContext`after the current test method.
`void`	`beforeTestMethod(TestContext testContext)`	Execute SQL scripts configured via `@Sql` for the supplied `TestContext`before the current test method.
`int`	`getOrder()`	Returns `5000`.

Methods inherited from class org.springframework.test.context.support.AbstractTestExecutionListener
afterTestClass, beforeTestClass, prepareTestInstance

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - SqlScriptsTestExecutionListener
```
public SqlScriptsTestExecutionListener()
```
- Method Detail
  - getOrder
```
public final int getOrder()
```
    Returns 5000.
    Specified by:
    getOrder in interface Ordered
    Overrides:
    getOrder in class AbstractTestExecutionListener
    Returns:
    the order value
    See Also:
    Ordered.HIGHEST_PRECEDENCE, Ordered.LOWEST_PRECEDENCE
  - beforeTestMethod
```
public void beforeTestMethod(TestContext testContext)
                      throws Exception
```
    Execute SQL scripts configured via @Sql for the supplied TestContextbefore the current test method.
    Specified by:
    beforeTestMethod in interface TestExecutionListener
    Overrides:
    beforeTestMethod in class AbstractTestExecutionListener
    Parameters:
    testContext - the test context in which the test method will be executed; never null
    Throws:
    Exception - allows any exception to propagate
  - afterTestMethod
```
public void afterTestMethod(TestContext testContext)
                     throws Exception
```
    Execute SQL scripts configured via @Sql for the supplied TestContextafter the current test method.
    Specified by:
    afterTestMethod in interface TestExecutionListener
    Overrides:
    afterTestMethod in class AbstractTestExecutionListener
    Parameters:
    testContext - the test context in which the test method was executed; never null
    Throws:
    Exception - allows any exception to propagate

Class SqlScriptsTestExecutionListener

Script Resources

Required Spring Beans

Field Summary

Fields inherited from interface org.springframework.core.Ordered

Constructor Summary

Method Summary

Methods inherited from class org.springframework.test.context.support.AbstractTestExecutionListener

Methods inherited from class java.lang.Object

Constructor Detail

SqlScriptsTestExecutionListener

Method Detail

getOrder

beforeTestMethod

afterTestMethod