uk.org.ogsadai.client.dbcreate2
Class CreateTestPostgreSQLDB

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

public class CreateTestPostgreSQLDB

extends CreateTestDB

This program will create and populate three PostgreSQL database tables called example_{destination,traveller,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.CreateTestPostgreSQLDB [-driverclass PostgreSQLDriverClass] [-host PostgreSQLHostName] [-port PostgreSQLPortNumber] [-database PostgreSQLDatabaseName] [-username PostgreSQLUserName] [-password PostgreSQLPassword] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: PostgreSQLDriverClass: org.postgresql.Driver PostgreSQLHostName: localhost PostgreSQLPortNumber: 5432 PostgreSQLDatabaseName: ogsadai PostgreSQLUserName: ogsadai PostgreSQLPassword: ogsadai PrefixOfTablesToCreate: example_ NumberOfRowsToCreate: 40000

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

CreateTestPostgreSQLDB(java.lang.String[] args)
Creates and populates a PostgreSQL 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 tablename) 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

CreateTestPostgreSQLDB

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

Creates and populates a PostgreSQL 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 tablename)
                          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

tablename - 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