uk.org.ogsadai.client.dbcreate2
Class CreateTestMySQLDB

java.lang.Object
  |
  +--uk.org.ogsadai.client.dbcreate2.CreateTestDB
        |
        +--uk.org.ogsadai.client.dbcreate2.CreateTestMySQLDB

public class CreateTestMySQLDB

extends CreateTestDB

This program will populate three tables in a MySQL database called example_{traveller,destination,booking} and populate them with a total of 40,000 entries.

The rows field may be modified to generate tables with any desired number of rows. The nth row in each possible database will be identical across each one which has at least n rows (assuming Random is implemented the same on all Java jdks).

Usage: java uk.org.ogsadai.client.dbcreate.CreateTestMySQLDB [-driverclass MySQLDriverClass] [-host MySQLHostName] [-port MySQLPortNumber] [-database MySQLDatabaseName] [-username MySQLUserName] [-password MySQLPassword] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: MySQLDriverClass: org.gjt.mm.mysql.Driver MySQLHostName: localhost MySQLDatabaseName: ogsadai MySQLUserName: ogsadai MySQLPassword: ogsadai PrefixOfTablesToCreate: example_ NumberOfRowsToCreate: 40000 MySQLRootUserName: root MySQLRootPassword:

Author:

The OGSA-DAI Project Team

Field Summary

private static java.lang.String

COPYRIGHT_NOTICE

Fields inherited from class uk.org.ogsadai.client.dbcreate2.CreateTestDB

mBookingTable, mData, mDatabase, mDBMS, mDestinationTable, mDriver, mHost, mNumberOfBookings, mNumberOfDestinations, mNumberOfTravellers, mPassword, mPort, mRows, mSizeOfBlob, mTablePrefix, mTravellerTable, mUsername

Constructor Summary

CreateTestMySQLDB(java.lang.String[] args)
Creates and populates a MySQL test database table according to the specified settings or the default settings if no arguments are used.

Method Summary

protected void	dropTableIfExists(java.sql.Connection connection, java.lang.String table) Drops the specified table.
protected java.sql.Connection	getConnection() Returns a java.sql.Connection data resource.
protected java.lang.String	getCreateDestinationTableStatement() Constructs the statement for creating a destination table.
static void	main(java.lang.String[] args)
protected void	setDefaultSettings() Sets the default settings for the client.

Methods inherited from class uk.org.ogsadai.client.dbcreate2.CreateTestDB

createBookingTable, createDestinationTable, createTravellerTable, getCreateBookingTableStatement, getCreateTravellerTableStatement, loadDriver, populateDatabase, printUsage, printVariables, setupArguments

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COPYRIGHT_NOTICE

private static final java.lang.String COPYRIGHT_NOTICE

See Also:

Constant Field Values

Constructor Detail

CreateTestMySQLDB

public CreateTestMySQLDB(java.lang.String[] args)

Creates and populates a MySQL test database table according to the specified settings or the default settings if no arguments are used.

Parameters:

args - arguments passed to the main method.

Method Detail

main

public static void main(java.lang.String[] args)

setDefaultSettings

protected void setDefaultSettings()

Description copied from class: CreateTestDB

Sets the default settings for the client.

Specified by:

setDefaultSettings in class CreateTestDB

getConnection

protected java.sql.Connection getConnection()
                                     throws java.sql.SQLException

Description copied from class: CreateTestDB

Returns a java.sql.Connection data resource.

Specified by:

getConnection in class CreateTestDB

Returns:

Connection

Throws:

java.sql.SQLException

dropTableIfExists

protected void dropTableIfExists(java.sql.Connection connection,
                                 java.lang.String table)
                          throws java.sql.SQLException

Description copied from class: CreateTestDB

Drops the specified table. Note: This method must not throw an error if the table does not exist.

Specified by:

dropTableIfExists in class CreateTestDB

Parameters:

connection - a connection to the data resource

table - the name of the table to be created

Throws:

java.sql.SQLException

getCreateDestinationTableStatement

protected java.lang.String getCreateDestinationTableStatement()

Description copied from class: CreateTestDB

Constructs the statement for creating a destination table. Subclasses can override this method if the statement differs.

Overrides:

getCreateDestinationTableStatement in class CreateTestDB

Returns:

String a create table statement