Search in sources :

Example 1 with ResourceDatabasePopulator

use of cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator in project today-infrastructure by TAKETODAY.

the class ProgrammaticTxMgmtTests method executeSqlScript.

protected void executeSqlScript(String sqlResourcePath, boolean continueOnError) throws DataAccessException {
    Resource resource = this.applicationContext.getResource(sqlResourcePath);
    new ResourceDatabasePopulator(continueOnError, false, this.sqlScriptEncoding, resource).execute(jdbcTemplate.getDataSource());
}
Also used : ResourceDatabasePopulator(cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator) Resource(cn.taketoday.core.io.Resource)

Example 2 with ResourceDatabasePopulator

use of cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator in project today-infrastructure by TAKETODAY.

the class AbstractTransactionalJUnit4ContextTests method executeSqlScript.

/**
 * Execute the given SQL script.
 * <p>Use with caution outside of a transaction!
 * <p>The script will normally be loaded by classpath.
 * <p><b>Do not use this method to execute DDL if you expect rollback.</b>
 *
 * @param sqlResourcePath the Spring resource path for the SQL script
 * @param continueOnError whether or not to continue without throwing an
 * exception in the event of an error
 * @throws DataAccessException if there is an error executing a statement
 * @see ResourceDatabasePopulator
 * @see #setSqlScriptEncoding
 */
protected void executeSqlScript(String sqlResourcePath, boolean continueOnError) throws DataAccessException {
    DataSource ds = this.jdbcTemplate.getDataSource();
    Assert.state(ds != null, "No DataSource set");
    Assert.state(this.applicationContext != null, "No ApplicationContext set");
    Resource resource = this.applicationContext.getResource(sqlResourcePath);
    new ResourceDatabasePopulator(continueOnError, false, this.sqlScriptEncoding, resource).execute(ds);
}
Also used : ResourceDatabasePopulator(cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator) Resource(cn.taketoday.core.io.Resource) DataSource(javax.sql.DataSource)

Example 3 with ResourceDatabasePopulator

use of cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator in project today-infrastructure by TAKETODAY.

the class SqlScriptsTestExecutionListener method executeSqlScripts.

/**
 * Execute the SQL scripts configured via the supplied {@link Sql @Sql}
 * annotation for the given {@link Sql.ExecutionPhase} and {@link TestContext}.
 * <p>Special care must be taken in order to properly support the configured
 * {@link SqlConfig#transactionMode}.
 *
 * @param sql the {@code @Sql} annotation to parse
 * @param executionPhase the current execution phase
 * @param testContext the current {@code TestContext}
 * @param classLevel {@code true} if {@link Sql @Sql} was declared at the class level
 */
private void executeSqlScripts(Sql sql, Sql.ExecutionPhase executionPhase, TestContext testContext, boolean classLevel) {
    if (executionPhase != sql.executionPhase()) {
        return;
    }
    MergedSqlConfig mergedSqlConfig = new MergedSqlConfig(sql.config(), testContext.getTestClass());
    if (logger.isDebugEnabled()) {
        logger.debug(String.format("Processing %s for execution phase [%s] and test context %s.", mergedSqlConfig, executionPhase, testContext));
    }
    String[] scripts = getScripts(sql, testContext, classLevel);
    scripts = TestContextResourceUtils.convertToClasspathResourcePaths(testContext.getTestClass(), scripts);
    List<Resource> scriptResources = TestContextResourceUtils.convertToResourceList(testContext.getApplicationContext(), scripts);
    for (String stmt : sql.statements()) {
        if (StringUtils.hasText(stmt)) {
            stmt = stmt.trim();
            scriptResources.add(new ByteArrayResource(stmt.getBytes(), "from inlined SQL statement: " + stmt));
        }
    }
    ResourceDatabasePopulator populator = createDatabasePopulator(mergedSqlConfig);
    populator.setScripts(scriptResources.toArray(Resource.EMPTY_ARRAY));
    if (logger.isDebugEnabled()) {
        logger.debug("Executing SQL scripts: " + ObjectUtils.nullSafeToString(scriptResources));
    }
    String dsName = mergedSqlConfig.getDataSource();
    String tmName = mergedSqlConfig.getTransactionManager();
    DataSource dataSource = TestContextTransactionUtils.retrieveDataSource(testContext, dsName);
    PlatformTransactionManager txMgr = TestContextTransactionUtils.retrieveTransactionManager(testContext, tmName);
    boolean newTxRequired = (mergedSqlConfig.getTransactionMode() == SqlConfig.TransactionMode.ISOLATED);
    if (txMgr == null) {
        Assert.state(!newTxRequired, () -> String.format("Failed to execute SQL scripts for test context %s: " + "cannot execute SQL scripts using Transaction Mode " + "[%s] without a PlatformTransactionManager.", testContext, SqlConfig.TransactionMode.ISOLATED));
        Assert.state(dataSource != null, () -> String.format("Failed to execute SQL scripts for test context %s: " + "supply at least a DataSource or PlatformTransactionManager.", testContext));
        // Execute scripts directly against the DataSource
        populator.execute(dataSource);
    } else {
        DataSource dataSourceFromTxMgr = getDataSourceFromTransactionManager(txMgr);
        // Ensure user configured an appropriate DataSource/TransactionManager pair.
        if (dataSource != null && dataSourceFromTxMgr != null && !sameDataSource(dataSource, dataSourceFromTxMgr)) {
            throw new IllegalStateException(String.format("Failed to execute SQL scripts for test context %s: " + "the configured DataSource [%s] (named '%s') is not the one associated with " + "transaction manager [%s] (named '%s').", testContext, dataSource.getClass().getName(), dsName, txMgr.getClass().getName(), tmName));
        }
        if (dataSource == null) {
            dataSource = dataSourceFromTxMgr;
            Assert.state(dataSource != null, () -> String.format("Failed to execute SQL scripts for " + "test context %s: could not obtain DataSource from transaction manager [%s] (named '%s').", testContext, txMgr.getClass().getName(), tmName));
        }
        final DataSource finalDataSource = dataSource;
        int propagation = (newTxRequired ? TransactionDefinition.PROPAGATION_REQUIRES_NEW : TransactionDefinition.PROPAGATION_REQUIRED);
        TransactionAttribute txAttr = TestContextTransactionUtils.createDelegatingTransactionAttribute(testContext, new DefaultTransactionAttribute(propagation));
        new TransactionTemplate(txMgr, txAttr).executeWithoutResult(s -> populator.execute(finalDataSource));
    }
}
Also used : TransactionAttribute(cn.taketoday.transaction.interceptor.TransactionAttribute) DefaultTransactionAttribute(cn.taketoday.transaction.interceptor.DefaultTransactionAttribute) DefaultTransactionAttribute(cn.taketoday.transaction.interceptor.DefaultTransactionAttribute) ResourceDatabasePopulator(cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator) Resource(cn.taketoday.core.io.Resource) ClassPathResource(cn.taketoday.core.io.ClassPathResource) ByteArrayResource(cn.taketoday.core.io.ByteArrayResource) TransactionTemplate(cn.taketoday.transaction.support.TransactionTemplate) ByteArrayResource(cn.taketoday.core.io.ByteArrayResource) PlatformTransactionManager(cn.taketoday.transaction.PlatformTransactionManager) DataSource(javax.sql.DataSource)

Example 4 with ResourceDatabasePopulator

use of cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator in project today-framework by TAKETODAY.

the class EmbeddedDatabaseFactoryBeanTests method testFactoryBeanLifecycle.

@Test
public void testFactoryBeanLifecycle() throws Exception {
    EmbeddedDatabaseFactoryBean bean = new EmbeddedDatabaseFactoryBean();
    ResourceDatabasePopulator populator = new ResourceDatabasePopulator(resource("db-schema.sql"), resource("db-test-data.sql"));
    bean.setDatabasePopulator(populator);
    bean.afterPropertiesSet();
    DataSource ds = bean.getObject();
    JdbcTemplate template = new JdbcTemplate(ds);
    assertThat(template.queryForObject("select NAME from T_TEST", String.class)).isEqualTo("Keith");
    bean.destroy();
}
Also used : ResourceDatabasePopulator(cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator) JdbcTemplate(cn.taketoday.jdbc.core.JdbcTemplate) DataSource(javax.sql.DataSource) Test(org.junit.jupiter.api.Test)

Example 5 with ResourceDatabasePopulator

use of cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator in project today-framework by TAKETODAY.

the class AbstractTransactionalTestNGContextTests method executeSqlScript.

/**
 * Execute the given SQL script.
 * <p>Use with caution outside of a transaction!
 * <p>The script will normally be loaded by classpath.
 * <p><b>Do not use this method to execute DDL if you expect rollback.</b>
 *
 * @param sqlResourcePath the resource path for the SQL script
 * @param continueOnError whether or not to continue without throwing an
 * exception in the event of an error
 * @throws DataAccessException if there is an error executing a statement
 * @see ResourceDatabasePopulator
 * @see #setSqlScriptEncoding
 */
protected void executeSqlScript(String sqlResourcePath, boolean continueOnError) throws DataAccessException {
    DataSource ds = this.jdbcTemplate.getDataSource();
    Assert.state(ds != null, "No DataSource set");
    Assert.state(this.applicationContext != null, "No ApplicationContext available");
    Resource resource = this.applicationContext.getResource(sqlResourcePath);
    new ResourceDatabasePopulator(continueOnError, false, this.sqlScriptEncoding, resource).execute(ds);
}
Also used : ResourceDatabasePopulator(cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator) Resource(cn.taketoday.core.io.Resource) DataSource(javax.sql.DataSource)

Aggregations

ResourceDatabasePopulator (cn.taketoday.jdbc.datasource.init.ResourceDatabasePopulator)18 Resource (cn.taketoday.core.io.Resource)12 DataSource (javax.sql.DataSource)8 ClassPathResource (cn.taketoday.core.io.ClassPathResource)4 Test (org.junit.jupiter.api.Test)4 ByteArrayResource (cn.taketoday.core.io.ByteArrayResource)2 JdbcTemplate (cn.taketoday.jdbc.core.JdbcTemplate)2 NonNull (cn.taketoday.lang.NonNull)2 PlatformTransactionManager (cn.taketoday.transaction.PlatformTransactionManager)2 Transactional (cn.taketoday.transaction.annotation.Transactional)2 DefaultTransactionAttribute (cn.taketoday.transaction.interceptor.DefaultTransactionAttribute)2 TransactionAttribute (cn.taketoday.transaction.interceptor.TransactionAttribute)2 TransactionTemplate (cn.taketoday.transaction.support.TransactionTemplate)2