public class CreateTCDatabase
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
private java.lang.String |
CHECK_DB_EXISTS_STMT
MySQL statement for checking if DB exists
|
private java.lang.String |
CREATE_DATABASE_STMT
MySQL statement for checking for creating database
|
private java.lang.String |
DROP_DATABASE_STMT
MySQL statement for checking for dropping database
|
protected java.sql.Connection |
mConnection
Maintains the connection to the database over the lifetime of
this instance.
|
private java.lang.String |
mDatabaseAbsolutePath
Stores the absolute path to the mysql home directory
|
private java.lang.String |
mDatabaseHost
Stores the database host name
|
private java.lang.String |
mDatabaseName
Stores the database name
|
private java.lang.String |
mDriver
Stores the driver string
|
private LogManager |
mLogger
The default logger.
|
private java.lang.String |
mPassword
Stores the MySQL password
|
private java.lang.String |
mUrl
Stores the database url
|
private java.lang.String |
mUsername
Stores the user name
|
Constructor and Description |
---|
CreateTCDatabase(java.lang.String driver,
java.lang.String url,
java.lang.String username,
java.lang.String password,
java.lang.String host)
Creates a JDBCTC instance .
|
Modifier and Type | Method and Description |
---|---|
boolean |
checkIfDatabaseExists(java.lang.String databaseName)
Checks if the given database exists
|
boolean |
createDatabase(java.lang.String databaseName)
Creates data base
|
boolean |
deleteDatabase(java.lang.String databaseName)
Deletes the database
|
java.lang.String |
getDatabaseName(java.lang.String dbURL)
Returns the database name from the database url string
|
boolean |
initializeDatabase(java.lang.String databaseName,
java.lang.String fileName)
Initialize the database with given .sql file
|
private LogManager mLogger
protected java.sql.Connection mConnection
private java.lang.String CHECK_DB_EXISTS_STMT
private java.lang.String DROP_DATABASE_STMT
private java.lang.String CREATE_DATABASE_STMT
private java.lang.String mDriver
private java.lang.String mUrl
private java.lang.String mUsername
private java.lang.String mPassword
private java.lang.String mDatabaseName
private java.lang.String mDatabaseHost
private java.lang.String mDatabaseAbsolutePath
public CreateTCDatabase(java.lang.String driver, java.lang.String url, java.lang.String username, java.lang.String password, java.lang.String host) throws java.lang.ClassNotFoundException, java.sql.SQLException
driver
- the Database driverurl
- the Database urlusername
- the Database user namepassword
- the Database user passwordjava.lang.ClassNotFoundException
- if it fails to load the driverjava.sql.SQLException
public java.lang.String getDatabaseName(java.lang.String dbURL)
dbURL
- the database url stringpublic boolean checkIfDatabaseExists(java.lang.String databaseName) throws java.sql.SQLException
databaseName
- the database namejava.sql.SQLException
public boolean deleteDatabase(java.lang.String databaseName) throws java.sql.SQLException
databaseName
- the databasejava.sql.SQLException
public boolean createDatabase(java.lang.String databaseName) throws java.sql.SQLException
databaseName
- the database namejava.sql.SQLException
public boolean initializeDatabase(java.lang.String databaseName, java.lang.String fileName)
databaseName
- the database namefileName
- the file name