uk.org.ogsadai.client.dbcreate
Class CreateTestPostgreSQLDB

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

public class CreateTestPostgreSQLDB

extends CreateTestDB

This program will create and populate a PostgreSQL database table called littleblackbook and populate it with 10,000 address entries consisting of a name (First, Surname). Address and telephone number.

The numberOfEntries field may be modified to generate a table 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] [-connectionUrl ConnectionUrl] [-drop] Default Settings: PostgreSQLDriverClass: org.postgresql.Driver PostgreSQLHostName: localhost PostgreSQLPortNumber: 5432 PostgreSQLDatabaseName: ogsadai PostgreSQLUserName: ogsadai PostgreSQLPassword: ogsadai NameOfTableToCreate: littleblackbook NumberOfRowsToCreate: 10000 If the connection URL is provided it will override the hostname, port number and database name settings.

Author:

The OGSA-DAI Project Team

COPYRIGHT_NOTICE

private static final java.lang.String COPYRIGHT_NOTICE

See Also:

Constant Field Values

mDrop

private boolean mDrop

mConnectionUrl

private java.lang.String mConnectionUrl

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.

main

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

Entry point for this program.

Parameters:

args - See class documentation.

setDefaultSettings

protected void setDefaultSettings()

Description copied from class: CreateTestDB

Sets the default settings for the client.

Specified by:

setDefaultSettings in class CreateTestDB

populateDatabase

protected void populateDatabase()
                         throws CreateTestDatabaseException

Description copied from class: CreateTestDB

Populates the test database with the test data.

Specified by:

populateDatabase in class CreateTestDB

CreateTestDatabaseException

setupArguments

protected boolean setupArguments(java.lang.String[] args)

Parses the arguments general to most CreateTestDB clients. This method may be overridden if a client requires special argument parsing.

Overrides:

setupArguments in class CreateTestDB

Parameters:

args - the argument string

Returns:

true if the arguments are parsed correctly, otherwise false

printVariables

protected void printVariables(java.lang.String prefix)

Displays the settings prefixed by the specified string.

Overrides:

printVariables in class CreateTestDB

Parameters:

prefix - the displayed settings begin with "prefix Settings:"

printUsage

protected void printUsage()

Displays the settings prefixed by the specified string.

Overrides:

printUsage in class CreateTestDB