net.sf.javagimmicks.sql.testing.DerbyDbTestRule Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of gimmicks-jdbc-testing Show documentation

Utilities for testing JDBC based classes with a temporary Hypersonic SQL Database

There is a newer version: 0.99-alpha1

Show newest version

package net.sf.javagimmicks.sql.testing;

import java.io.File;
import java.net.MalformedURLException;

import org.apache.commons.dbcp.BasicDataSource;
import org.apache.derby.jdbc.EmbeddedDriver;
import org.junit.rules.TestRule;

/**
 * A JUnit {@link TestRule} that creates a temporary file-based derby database
 * during test execution and wraps a Commons-DBCP {@link BasicDataSource} around
 * it.
 * 
 * The developer can influence the temporary folder, where the database should
 * be created and/or can provide initial configuration logic for the used
 * {@link BasicDataSource} via a {@link DataSourceConfigurator}.
 * 

 * Usage example:
 * 
 * 
 * public class DerbyDbTestRuleTest
 * {
 * 
 *    @Rule
 *    public DerbyDbTestRule _db = new DerbyDbTestRule();
 * 
 *    @Test
 *    public void test() throws SQLException
 *    {
 *       final Connection connection = _db.getConnection();
 *       assertNotNull(connection);
 * 
 *       // Do some DB operations
 * 
 *       conneciton.close();
 *    }
 * }
 * 
 */
public class DerbyDbTestRule extends AbstractDbTestRule
{
   /**
    * Creates a new instance using the given {@link DataSourceConfigurator} and
    * {@link File folder} for the internal database.
    * 
    * @param configurator
    *           a {@link DataSourceConfigurator} for performing custom
    *           configuration logic on the internal {@link BasicDataSource}
    * @param dbFolder
    *           the temporary folder where the database should be set up
    */
   public DerbyDbTestRule(final DataSourceConfigurator configurator, final File dbFolder)
   {
      super(configurator, dbFolder);
   }

   /**
    * Creates a new instance using the given {@link DataSourceConfigurator} for
    * the internal database.
    * 
    * @param configurator
    *           a {@link DataSourceConfigurator} for performing custom
    *           configuration logic on the internal {@link BasicDataSource}
    */
   public DerbyDbTestRule(final DataSourceConfigurator configurator)
   {
      super(configurator);
   }

   /**
    * Creates a new instance using the given {@link File folder} for the
    * internal database.
    * 
    * @param dbFolder
    *           the temporary folder where the database should be set up
    */
   public DerbyDbTestRule(final File dbFolder)
   {
      super(dbFolder);
   }

   /**
    * Creates a new instance with no special configuration.
    */
   public DerbyDbTestRule()
   {
      super();
   }

   @Override
   protected void configureDatasource(final BasicDataSource dataSource, final File tempFolder)
         throws MalformedURLException
   {
      dataSource.setDriverClassName(EmbeddedDriver.class.getName());
      dataSource.setUrl(buildJdbcUrl(tempFolder));
      // dataSource.setUsername("sa");
      // dataSource.setPassword("sa");
   }

   private static String buildJdbcUrl(final File tempFolder) throws MalformedURLException
   {
      final StringBuilder url = new StringBuilder("jdbc:derby:");

      if (System.getProperty("os.name").toLowerCase().startsWith("windows"))
      {
         url.append(tempFolder.toURI().toURL().toString().substring(6));
      }
      else
      {
         url.append(tempFolder.toURI().toURL().toString().substring(5));
      }

      url.append(NAME_TEST_DB).append(";create=true");

      return url.toString();
   }
}