org.apache.derbyTesting.perf.clients

Class SingleRecordFiller

java.lang.Object

org.apache.derbyTesting.perf.clients.SingleRecordFiller

All Implemented Interfaces:

DBFiller

public class SingleRecordFiller
extends java.lang.Object
implements DBFiller

Class which generates and populates tables that can be used by SingleRecordSelectClient and SingleRecordUpdateClient. This tables contain rows with an int column (id) and a varchar(100) column (text). The id column is declared as primary key.

Field Summary

Fields

Modifier and Type	Field and Description
private int	dataType The data type of the text column (a constant from java.sql.Types).
private java.lang.String	dataTypeString SQL name of the data type specified by dataType.
private int	numberOfTables The number of tables to distribute the load over.
private static byte[][]	RANDOM_BYTES
private static java.lang.String[]	RANDOM_STRINGS
private int	tableSize The number of rows in each table.
(package private) static int	TEXT_SIZE
private boolean	withNonIndexedColumn Whether or not the table includes an integer column with unique values in random order not backed by an index.
private boolean	withSecIndexColumn Whether or not the table includes an integer column with unique values in random order.

Constructor Summary

Constructors

Constructor and Description
SingleRecordFiller(int records, int tables) Generate a filler that creates the specified number of tables, each of which contains the specified number of records.
SingleRecordFiller(int records, int tables, int type, boolean withSecIndex, boolean withNonIndexed) Generate a filler that creates the specified number of tables, each of which contains the specified number of records.

Method Summary

Modifier and Type	Method and Description
void	fill(java.sql.Connection c) Populate the database with the data needed by a test.
(package private) static java.lang.String	getTableName(int records, int table, int dataType, boolean withSecIndex, boolean withNonIndexed) Get the name of a table generated by this class.
(package private) static byte[]	randomBytes(int seed) Pick a random byte string.
(package private) static java.lang.String	randomString(int seed) Pick a random string.

Methods inherited from class java.lang.Object

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

Field Detail

numberOfTables

private final int numberOfTables

The number of tables to distribute the load over.

tableSize

private final int tableSize

The number of rows in each table.

dataType

private final int dataType

The data type of the text column (a constant from java.sql.Types).

dataTypeString

private final java.lang.String dataTypeString

SQL name of the data type specified by dataType.

withSecIndexColumn

private final boolean withSecIndexColumn

Whether or not the table includes an integer column with unique values in random order. A UNIQUE index will be created for the column.

withNonIndexedColumn

private final boolean withNonIndexedColumn

Whether or not the table includes an integer column with unique values in random order not backed by an index.

TEXT_SIZE

static final int TEXT_SIZE

See Also:

Constant Field Values

RANDOM_STRINGS

private static final java.lang.String[] RANDOM_STRINGS

RANDOM_BYTES

private static final byte[][] RANDOM_BYTES

Constructor Detail

SingleRecordFiller

public SingleRecordFiller(int records,
                          int tables)

Generate a filler that creates the specified number of tables, each of which contains the specified number of records. When this constructor is used, the table only contains two columns: a primary key column (INT) and a text column (VARCHAR(100)).

Parameters:

records - the number of records in each table

tables - the number of tables to create

SingleRecordFiller

public SingleRecordFiller(int records,
                          int tables,
                          int type,
                          boolean withSecIndex,
                          boolean withNonIndexed)

Generate a filler that creates the specified number of tables, each of which contains the specified number of records.

Parameters:

records - the number of records in each table

tables - the number of tables to create

type - which SQL type to store the text as (one of java.sql.Types.VARCHAR, java.sql.Types.BLOB and java.sql.Types.CLOB.

Method Detail

fill

public void fill(java.sql.Connection c)
          throws java.sql.SQLException

Description copied from interface: DBFiller

Populate the database with the data needed by a test.

Specified by:

fill in interface DBFiller

Parameters:

c - the connection to use

Throws:

java.sql.SQLException - if a database error occurs

randomString

static java.lang.String randomString(int seed)

Pick a random string.

Parameters:

seed - a seed used to decide which random string to pick

Returns:

a (somewhat) random string

randomBytes

static byte[] randomBytes(int seed)

Pick a random byte string.

Parameters:

seed - a seed used to decide which random string to pick

Returns:

a (somewhat) random sequence of bytes

getTableName

static java.lang.String getTableName(int records,
                                     int table,
                                     int dataType,
                                     boolean withSecIndex,
                                     boolean withNonIndexed)

Get the name of a table generated by this class.

Parameters:

records - the number of records in the table

table - the number of the table, between 0 (inclusive) and the total number of tables (exclusive)

dataType - the java.sql.Types constant specifying the data type of the text column

Returns:

the name of the table specified by the arguments