Examples of DBSetup

org.jboss.test.cluster.ejb3.common.unit.DBSetup
A TestSetup that starts hypersonic before the testcase with a tcp listening port at 1701. @author Scott.Stark@jboss.org @version $Revison:$
org.rhq.core.db.setup.DBSetup
Performs XML parsing of the database schema and data files and sets up the database accordingly. This has the ability to not only set up the database, but also to purge the database of the schemas and data.
org.rhq.helpers.perftest.support.dbsetup.DbSetup
This class is a utility wrapper around the actual {@link DBSetup} and {@link DBUpgrader} classes defined in therhq-core-dbutils module. @author Lukas Krejci

Examples of org.jboss.test.cluster.ejb3.common.unit.DBSetup

                               "clusteredsession-ds.xml, clusteredsession-xpc-scoped.jar");


      suite.addTest(t1);


      // Create an initializer for the test suite
      DBSetup wrapper = new DBSetup(suite);
      return wrapper;     
   }

View Full Code Here

Examples of org.jboss.test.cluster.ejb3.common.unit.DBSetup

                               "clusteredsession-ds.xml, clusteredsession-xpc.jar");


      suite.addTest(t1);


      // Create an initializer for the test suite
      DBSetup wrapper = new DBSetup(suite);
      return wrapper;     
   }

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

            return;
        } else {
            conn.close();
        }


        DBSetup dbsetup = new DBSetup(getTestDatabaseConnectionUrl(db), getTestDatabaseConnectionUsername(db),
            getTestDatabaseConnectionPassword(db), false);


        try {
            dbsetup.setup("small-dbsetup.xml");


            conn = getConnection(db);
            DatabaseType dbtype = DatabaseTypeFactory.getDatabaseType(conn);


            assert dbtype.checkTableExists(conn, "TEST_SMALL");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "ID");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYLONG");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBIGDEC");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYLONGVARCHAR");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYDOUBLE");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBOOLEAN");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBYTES");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYVARCHAR2");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYCLOB");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBLOB");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYCHAR");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYSMALLINT");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYTIMESTAMP");


            ResultSet results = conn.prepareCall("SELECT MYVARCHAR2 FROM TEST_SMALL").executeQuery();
            results.next();
            assert "abc-myvarchar2".equals(results.getString("MYVARCHAR2"));
            results.close();
        } finally {
            try {
                dbsetup.uninstall("small-dbsetup.xml");
            } catch (Exception e) {
                System.err.println("Cannot uninstall the test schema");
            }
        }

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

            return;
        } else {
            conn.close();
        }


        DBSetup dbsetup = new DBSetup(getTestDatabaseConnectionUrl(db), getTestDatabaseConnectionUsername(db),
            getTestDatabaseConnectionPassword(db), false);


        dbsetup.setup("small-dbsetup.xml");


        DatabaseType dbtype;


        // get the connection, make sure the setup worked, and then uninstall the schema
        try {
            conn = getConnection(db);
            dbtype = DatabaseTypeFactory.getDatabaseType(conn);
            assert dbtype.checkTableExists(conn, "TEST_SMALL");
        } finally {
            dbsetup.uninstall("small-dbsetup.xml");
        }


        // make sure the uninstall worked
        try {
            boolean result = dbtype.checkTableExists(conn, "TEST_SMALL");

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

            return;
        } else {
            conn.close();
        }


        DBSetup dbsetup = new DBSetup(getTestDatabaseConnectionUrl(db), getTestDatabaseConnectionUsername(db),
            getTestDatabaseConnectionPassword(db), false);


        try {
            dbsetup.setup("small-dbsetup.xml");


            conn = getConnection(db);
            DatabaseType dbtype = DatabaseTypeFactory.getDatabaseType(conn);


            assert dbtype.checkTableExists(conn, "TEST_SMALL");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "ID");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYLONG");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBIGDEC");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYLONGVARCHAR");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYDOUBLE");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBOOLEAN");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBYTES");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYVARCHAR2");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYCLOB");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYBLOB");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYCHAR");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYSMALLINT");
            assert dbtype.checkColumnExists(conn, "TEST_SMALL", "MYTIMESTAMP");


            ResultSet results = conn.prepareCall("SELECT MYVARCHAR2 FROM TEST_SMALL").executeQuery();
            results.next();
            assert "abc-myvarchar2".equals(results.getString("MYVARCHAR2"));
            results.close();
        } finally {
            try {
                dbsetup.uninstall("small-dbsetup.xml");
            } catch (Exception e) {
                System.err.println("Cannot uninstall the test schema");
            }
        }

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

        conn = getConnection(db);
        if (conn == null) {
            return;
        }


        DBSetup dbsetup = new DBSetup(getTestDatabaseConnectionUrl(db), getTestDatabaseConnectionUsername(db),
            getTestDatabaseConnectionPassword(db), false);


        dbsetup.setup("small-dbsetup.xml");


        DatabaseType dbtype;


        // get the connection, make sure the setup worked, and then uninstall the schema
        try {
            conn = getConnection(db);
            dbtype = DatabaseTypeFactory.getDatabaseType(conn);
            assert dbtype.checkTableExists(conn, "TEST_SMALL");
        } finally {
            dbsetup.uninstall("small-dbsetup.xml");
        }


        // make sure the uninstall worked
        try {
            boolean result = dbtype.checkTableExists(conn, "TEST_SMALL");

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

            // extract the dbsetup files which are located in the dbutils jar
            String dbsetupSchemaXmlFile = extractDatabaseXmlFile("db-schema-combined.xml", props, serverDetails, logDir);
            String dbsetupDataXmlFile = extractDatabaseXmlFile("db-data-combined.xml", props, serverDetails, logDir);


            // first uninstall any old existing schema, then create the tables then insert the data
            DBSetup dbsetup = new DBSetup(dbUrl, userName, password);
            dbsetup.uninstall(dbsetupSchemaXmlFile);
            dbsetup.setup(dbsetupSchemaXmlFile);
            dbsetup.setup(dbsetupDataXmlFile, null, true, false);
        } catch (Exception e) {
            LOG.fatal("Cannot install the database schema - the server will not run properly.", e);
            throw e;
        }
    }

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

                old_sysprops.put(env_var.getKey(), old_value);
            }
        }


        try {
            DBSetup dbs = new DBSetup(jdbcUrl, jdbcUser, jdbcPassword);


            if (uninstall) {
                dbs.uninstall(xmlFile.getAbsolutePath());
            } else if (exportXml) {
                dbs.export(xmlFile.getAbsolutePath());
            } else if (table == null) {
                dbs.setup(xmlFile.getAbsolutePath());
            } else {
                dbs.setup(xmlFile.getAbsolutePath(), table, dataOnly, doDelete);
            }
        } catch (Exception e) {
            throw new BuildException(e);
        } finally {
            // revert back to the old system properties

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

        DBReset dbReset = new DBReset();
        dbReset.performDBReset(DB_TYPE_MAPPING, DB_URL, DB_NAME, USERNAME, ADMIN_USERNAME, ADMIN_PASSWORD);
    }


    private void installSchemaAndData(String jonVersion) throws Exception {
        DBSetup dbsetup = new DBSetup(DB_URL, USERNAME, PASSWORD);
        File schemaFile = getSchemaFile(jonVersion);
        dbsetup.setup(schemaFile.getAbsolutePath());
        File dataFile = getDataFile(jonVersion);
        dbsetup.setup(dataFile.getAbsolutePath());
    }

View Full Code Here

Examples of org.rhq.core.db.setup.DBSetup

            dataFileResourcePath = "db-data-combined.xml";
        }


        TestDatasourceConfiguration testDs = getTestDatasourceConfiguration();
        
        DBSetup dbsetup = new DBSetup(testDs.connectionUrl, testDs.userName, testDs.password);
        dbsetup.setup(schemaFileResourcePath);
        dbsetup.setup(dataFileResourcePath);
    }

View Full Code Here

0 1

TOP

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.