Examples of org.apache.derbyTesting.junit.CleanDatabaseTestSetup

org.apache.derbyTesting.junit.CleanDatabaseTestSetup
Test decorator that cleans a database on setUp and tearDown to provide a test with a consistent empty database as a starting point.
Tests can extend to provide a decorator that defines some schema items and then have CleanDatabaseTestSetup automatically clean them up by implementing the decorateSQL method.. As an example: return new CleanDatabaseTestSetup(suite) { protected void decorateSQL(Statement s) throws SQLException { s.execute("CREATE TABLE T (I INT)"); s.execute("CREATE INDEX TI ON T(I)") } };

    public static Test baseSuite(String name) {


        TestSuite suite = new TestSuite(name);
        suite.addTestSuite(LargeDataLocksTest.class);


        return new CleanDatabaseTestSetup(suite) {


            /**
             * Create and populate table
             * @see org.apache.derbyTesting.junit.CleanDatabaseTestSetup#decorateSQL(java.sql.Statement)
             */

View Full Code Here

     * Create a suite of tests.
    */
    public static Test suite()
    {
        Test test = TestConfiguration.embeddedSuite(CreateTableFromQueryTest.class);
        return new CleanDatabaseTestSetup(test) {


            protected void decorateSQL(Statement stmt) throws SQLException
            {
                // create base tables t1 and t2       
                stmt.executeUpdate(

View Full Code Here

        {
            TestSuite encSuite = new TestSuite ("BlobClob4BlobTest:encrypted");
            encSuite.addTestSuite (BlobClob4BlobTest.class);
            suite.addTest(Decorator.encryptedDatabase (encSuite));
        }
        return new CleanDatabaseTestSetup(
                DatabasePropertyTestSetup.setLockTimeouts(suite, 2, 4));
    }

View Full Code Here

  public static Test suite() {
    Properties props = new Properties();


    props.setProperty("derby.language.maxMemoryPerTable", "1");
    return new DatabasePropertyTestSetup(
        new SystemPropertyTestSetup(new CleanDatabaseTestSetup(
        new TestSuite(UpdateCursorTest.class, "UpdateCursorTest")) {


      /**
       * @see org.apache.derbyTesting.junit.CleanDatabaseTestSetup#decorateSQL(java.sql.Statement)
       */

View Full Code Here

      {
          TestSuite suite = new TestSuite(name);


          suite.addTestSuite(ParameterMetaDataJdbc30Test.class);


          return new CleanDatabaseTestSetup(suite) {
      /**
                  * Creates the tables and the stored procedures used in the test
                  * cases.
       *
                  * @exception SQLException if a database error occurs

View Full Code Here


  protected static Test baseSuite(String name) {
          TestSuite suite = new TestSuite(name);
          suite.addTestSuite(ForBitDataTest.class);
          
    return new CleanDatabaseTestSetup(suite) 
          {
                protected void decorateSQL(Statement s) throws SQLException
                {
                    for (int i = 0; i < TABLES.length; i++) {
                          s.execute(TABLES[i]);

View Full Code Here

  /**
   * One set of grant/revoke tests for either client/server or embedded.
   */
  public static Test basesuite() {
    Test basesuite = new TestSuite(GrantRevokeTest.class);
    Test clean = new CleanDatabaseTestSetup(basesuite) {
        protected void decorateSQL(Statement s) throws SQLException {
          s.execute("create schema s1");
          s.execute("create schema s2");
          s.execute("create table s1.t1(c1 int, c2 int, c3 int)");
          s.execute("create table s2.t1(c1 int, c2 int, c3 int)");

View Full Code Here

            TestConfiguration.embeddedSuite(InListMultiProbeTest.class));


        /* Wrap the suite in a CleanDatabaseTestSetup that will create
         * and populate the test table.
         */
        return new CleanDatabaseTestSetup(suite) 
        {
            /**
            * Create and populate the test table.
            */
            protected void decorateSQL(Statement s) throws SQLException

View Full Code Here

      }


  protected static Test baseSuite(String name) {
          TestSuite suite = new TestSuite(name);
          suite.addTestSuite(ForUpdateTest.class);  
    return new CleanDatabaseTestSetup(suite) 
          {
                protected void decorateSQL(Statement s) throws SQLException
                {
                    s.execute("create table t1 ( i int, v varchar(10), d double precision, t time )");
        s.execute("create table t2 ( s smallint, c char(10), r real, ts timestamp )");

View Full Code Here

                (new ProcedureTest
                 ("xtestRollbackStoredProcWhenExecuteUpdateReturnsResults" +
                  "_prepared"));
        }
        }
        return new CleanDatabaseTestSetup(suite) {
            /**
             * Creates the tables and the stored procedures used in the test
             * cases.
             * @exception SQLException if a database error occurs
             */

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.derbyTesting.junit.CleanDatabaseTestSetup

org.apache.derbyTesting.functionTests.tests.derbynet.NetIjTest

org.apache.derbyTesting.functionTests.tests.engine.LockInterruptTest

org.apache.derbyTesting.functionTests.tests.i18n.I18NImportExport

org.apache.derbyTesting.functionTests.tests.jdbc4.ConnectionMethodsTest

org.apache.derbyTesting.functionTests.tests.jdbc4.DataSourceTest

org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest

org.apache.derbyTesting.functionTests.tests.jdbc4.TestDbMetaData

org.apache.derbyTesting.functionTests.tests.jdbcapi.BatchUpdateTest

org.apache.derbyTesting.functionTests.tests.jdbcapi.BlobClob4BlobTest

org.apache.derbyTesting.functionTests.tests.jdbcapi.CacheSessionDataTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.