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)") } };

                    new UpdatableResultSetTest("xTestInsertRowAfterCommit"));
            clientSuite.addTest(
                    new UpdatableResultSetTest("xTestInsertRowAfterCommit"));
        }
        
        suite.addTest(new CleanDatabaseTestSetup(embeddedSuite));
        suite.addTest(TestConfiguration.clientServerDecorator(
                new CleanDatabaseTestSetup(clientSuite)));


        // DERBY-177: The internal transaction that tries to compile the
        // trigger in testDeleteRowWithDeleteTrigger gets a lock timeout
        // because the main transaction has an exclusive lock on the trigger
        // statement. It does not fail, because the compilation is retried in

View Full Code Here

        if (JDBC.vmSupportsJSR169())
            return new TestSuite("GrantRevokeDDLTest"); // return empty suite;
                //test uses triggers and procedures that use DriverManager.
        TestSuite suite = new TestSuite(GrantRevokeDDLTest.class, "GrantRevokeDDL Test");
      Test test = new SupportFilesSetup(suite);
      test = new CleanDatabaseTestSetup(test);
      test = DatabasePropertyTestSetup.builtinAuthentication(
        test, users, "grantrevokeddl");
        test = TestConfiguration.sqlAuthorizationDecorator(test);
        
        return test;

View Full Code Here

    public static Test suite()
    {
        TestSuite suite = new TestSuite("GROUP BY expression tests");
        suite.addTestSuite(GroupByExpressionTest.class);
        
        TestSetup wrapper = 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

    
    
    
    private static Test basesuite() {
        Test basesuite = new TestSuite(ProcedureInTriggerTest.class);
        Test clean = new CleanDatabaseTestSetup(basesuite) {
        protected void decorateSQL(Statement s) throws SQLException {
            s.execute("create table t1 (i int primary key, b char(15))");
            s.execute("create table t2 (x integer, y integer)");
            s.execute("create procedure proc_no_sql() parameter style java language java NO SQL external name 'org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest.zeroArg'");
            s.execute("create procedure proc_contains_sql() parameter style java language java CONTAINS SQL external name 'org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest.getConnectionProc'");

View Full Code Here

    }
    
    protected static Test baseSuite(String name) {
        TestSuite suite = new TestSuite(name);
        suite.addTestSuite(BatchUpdateTest.class);
        return new CleanDatabaseTestSetup(
                DatabasePropertyTestSetup.setLockTimeouts(suite, 2, 4)) 
        {
            /**
             * Creates the tables used in the test cases.
             * @exception SQLException if a database error occurs

View Full Code Here

        // perform checks tests.
        suite.addTest(Checks.suite());


        suite.addTestSuite(OperationsTester.class);
                
        return new CleanDatabaseTestSetup(suite);
    }

View Full Code Here

   */
  public static Test suite() {
      
      TestSuite suite = new TestSuite("CollationTest");


        suite.addTest(new CleanDatabaseTestSetup(
                new CollationTest("testDefaultCollation")));
        suite.addTest(collatedSuite("en", "testEnglishCollation"));
        suite.addTest(collatedSuite("no", "testNorwayCollation"));
        suite.addTest(collatedSuite("pl", "testPolishCollation"));
        return suite;

View Full Code Here

    public static Test suite()
    {
        TestSuite suite = (TestSuite)
            TestConfiguration.embeddedSuite(CaseExpressionTest.class);


        return new CleanDatabaseTestSetup(suite) {
            /**
             * Creates the table used in the test cases.
             */
            protected void decorateSQL(Statement s) throws SQLException {
                SQLUtilities.createAndPopulateAllDataTypesTable(s);

View Full Code Here

        public static Test baseSuite(String name) {


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


        return new CleanDatabaseTestSetup(suite) {


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

View Full Code Here

        if (!usingDerbyNet()) {
            suite.addTest
                (new CallableTest("xtestRegUserDefOutParameterError"));
        }


        return new CleanDatabaseTestSetup(suite) 
        {
            /**
            * Creates the tables and the stored procedures used in the test
            * cases.
            * @throws SQLException

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.