TestDatabaseCreator (SeqWare 1.1.2 API)

java.lang.Object
- io.seqware.metadb.util.TestDatabaseCreator

Direct Known Subclasses:

BasicTestDatabaseCreator, ExtendedTestDatabaseCreator
```
public class TestDatabaseCreator
extends Object
```
This class handles basic database creation.

Version:

$Id: $Id

Author:

boconnor

Constructor Summary

Constructors
Constructor and Description

TestDatabaseCreator()

Constructors
Constructor and Description
`TestDatabaseCreator()`

Method Summary

Methods
Modifier and Type	Method and Description
`protected void`	`basicResetDatabaseWithUsers()` Unfortunately, postgres does not allow the straight dropdb and createdb when tomcat is used (perhaps we leave open a connection)
`protected void`	`basicResetDatabaseWithUsers(boolean loadTestingData)` Unfortunately, postgres does not allow the straight dropdb and createdb when tomcat is used (perhaps we leave open a connection)
`void`	`createDatabase()` createDatabase.
`void`	`createDatabase(boolean loadTestingData)` createDatabase.
`void`	`dropDatabase()` dropDatabase.
`void`	`dropDatabaseWithUsers()` Drop a database schema even when users are connected to it
`protected String`	`getDEFAULT_DB_HOST()`
`protected static String`	`getPOSTGRE_DB()`
`protected String`	`getPOSTGRE_PASSWORD()`
`protected String`	`getPOSTGRE_USER()`
`protected String`	`getSEQWARE_DB()`
`protected String`	`getSEQWARE_PASSWORD()`
`protected String`	`getSEQWARE_USER()`
`static void`	`markDatabaseChanged()` markDatabaseChanged.
`<T> T`	`runQuery(org.apache.commons.dbutils.ResultSetHandler<T> h, String query, boolean update, Object... params)` Convenient method to run a query against the test database, avoids unclosed connections.
`<T> T`	`runQuery(org.apache.commons.dbutils.ResultSetHandler<T> h, String query, Object... params)` Convenient method to run a query against the test database, avoids unclosed connections.
`int`	`runUpdate(String query, Object... params)` Run an insert, update, or delete

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - TestDatabaseCreator
```
public TestDatabaseCreator()
```
- Method Detail
  - getDEFAULT_DB_HOST
```
protected String getDEFAULT_DB_HOST()
```
    Returns:
    the DEFAULT_DB_HOST
  - createDatabase
```
public void createDatabase()
                    throws SQLException
```
    createDatabase.
    
    Throws:
    
    SQLException - if any.
  - createDatabase
```
public void createDatabase(boolean loadTestingData)
                    throws SQLException
```
    createDatabase.
    
    Parameters:
    loadTestingData - load the provided testing data
    
    Throws:
    
    SQLException - if any.
  - runQuery
```
public <T> T runQuery(org.apache.commons.dbutils.ResultSetHandler<T> h,
             String query,
             Object... params)
```
    Convenient method to run a query against the test database, avoids unclosed connections.
    
    Type Parameters:
    T -
    Parameters:
    h -
    query -
    params -
    
    Returns:
  - runUpdate
```
public int runUpdate(String query,
            Object... params)
```
    Run an insert, update, or delete
    
    Parameters:
    query -
    params -
    
    Returns:
  - runQuery
```
public <T> T runQuery(org.apache.commons.dbutils.ResultSetHandler<T> h,
             String query,
             boolean update,
             Object... params)
```
    Convenient method to run a query against the test database, avoids unclosed connections.
    
    Type Parameters:
    T -
    Parameters:
    h -
    query -
    update -
    params -
    
    Returns:
  - dropDatabase
```
public void dropDatabase()
                  throws SQLException
```
    dropDatabase.
    
    Throws:
    
    SQLException - if any.
  - dropDatabaseWithUsers
```
public void dropDatabaseWithUsers()
                           throws SQLException
```
    Drop a database schema even when users are connected to it
    
    Throws:
    
    SQLException - if any.
  - markDatabaseChanged
```
public static void markDatabaseChanged()
```
    markDatabaseChanged.
  - getPOSTGRE_DB
```
protected static String getPOSTGRE_DB()
```
    Returns:
    the POSTGRE_DB
  - getSEQWARE_DB
```
protected String getSEQWARE_DB()
```
    Returns:
    the SEQWARE_DB
  - getPOSTGRE_USER
```
protected String getPOSTGRE_USER()
```
    Returns:
    the POSTGRE_USER
  - getPOSTGRE_PASSWORD
```
protected String getPOSTGRE_PASSWORD()
```
    Returns:
    the POSTGRE_PASSWORD
  - getSEQWARE_USER
```
protected String getSEQWARE_USER()
```
    Returns:
    the SEQWARE_USER
  - getSEQWARE_PASSWORD
```
protected String getSEQWARE_PASSWORD()
```
    Returns:
    the SEQWARE_PASSWORD
  - basicResetDatabaseWithUsers
```
protected void basicResetDatabaseWithUsers()
```
    Unfortunately, postgres does not allow the straight dropdb and createdb when tomcat is used (perhaps we leave open a connection)
  - basicResetDatabaseWithUsers
```
protected void basicResetDatabaseWithUsers(boolean loadTestingData)
```
    Unfortunately, postgres does not allow the straight dropdb and createdb when tomcat is used (perhaps we leave open a connection)
    
    Parameters:
    loadTestingData -

Class TestDatabaseCreator

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

TestDatabaseCreator

Method Detail

getDEFAULT_DB_HOST

createDatabase

createDatabase

runQuery

runUpdate

runQuery

dropDatabase

dropDatabaseWithUsers

markDatabaseChanged

getPOSTGRE_DB

getSEQWARE_DB

getPOSTGRE_USER

getPOSTGRE_PASSWORD

getSEQWARE_USER

getSEQWARE_PASSWORD

basicResetDatabaseWithUsers

basicResetDatabaseWithUsers