|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.objectweb.cjdbc.scenario.tools.util.QueryGenerator
This class defines a QueryGenerator
Field Summary | |
private double |
createDropRatio
|
(package private) double |
insertUpdateRatio
|
(package private) java.lang.Integer |
maxUniqueId
|
(package private) double |
orderByRatio
|
(package private) java.util.Random |
rand
|
(package private) double |
readWriteRatio
|
(package private) DatabaseSchema |
schema
|
private double |
schemaUpdateRatio
|
(package private) java.util.ArrayList |
tables
|
(package private) int |
tableSize
|
(package private) double |
writeDeleteRatio
|
Constructor Summary | |
QueryGenerator(java.sql.Connection connection)
Creates a new QueryGenerator object |
|
QueryGenerator(DatabaseSchema schema)
Creates a new QueryGenerator object |
Method Summary | |
java.lang.String |
generateCreateQuery()
|
java.lang.String |
generateDelete()
Generate a delete query |
java.lang.String |
generateDropQuery()
|
java.lang.String |
generateInsert()
Generate an insert query |
private java.lang.String |
generateOrderBy(DatabaseTable table)
Generate order by statement of a read query |
java.lang.String |
generateQuery()
Main query generator method. |
java.lang.String |
generateReadQuery()
Generate a read query |
java.lang.String |
generateSchemaUpdateQuery()
|
java.lang.String |
generateSelectQuery()
Generate a select query |
java.lang.String |
generateUpdate()
Generate an update query |
java.lang.String |
generateWriteQuery()
Generate a write query. |
double |
getCreateDropRatio()
Returns the createDropRatio value. |
double |
getInsertUpdateRatio()
Returns the insertUpdateRatio value. |
private int |
getMaxUniqueId()
|
private int |
getNextMaxUniqueId()
|
double |
getOrderByRatio()
Returns the orderByRatio value. |
private DatabaseColumn |
getRandomColumn(DatabaseTable table,
boolean allowUnique)
|
private DatabaseColumn |
getRandomNonUniqueColumn(DatabaseTable table)
|
private java.lang.String |
getRandomString(int size)
|
private java.lang.String |
getRandomTable()
|
private java.lang.String |
getRandomType()
|
private java.lang.String |
getRandomValue(DatabaseColumn column)
|
double |
getReadWriteRatio()
Returns the readWriteRatio value. |
private java.lang.String |
getRelation(DatabaseTable table,
boolean useLowerAndGreater)
|
double |
getSchemaUpdateRatio()
Returns the schemaUpdateRatio value. |
private DatabaseTable |
getTable()
|
double |
getWriteDeleteRatio()
Returns the writeDeleteRatio value. |
static void |
main(java.lang.String[] args)
Test application |
private boolean |
nextIsInRatio(double ratio)
|
void |
setCreateDropRatio(double createDropRatio)
Sets the createDropRatio value. |
void |
setInsertUpdateRatio(double insertUpdateRatio)
Sets the insertUpdateRatio value. |
void |
setOrderByRatio(double orderByRatio)
Sets the orderByRatio value. |
void |
setReadWriteRatio(double readWriteRatio)
Sets the readWriteRatio value. |
void |
setSchemaUpdateRatio(double schemaUpdateRatio)
Sets the schemaUpdateRatio value. |
void |
setWriteDeleteRatio(double writeDeleteRatio)
Sets the writeDeleteRatio value. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
java.lang.Integer maxUniqueId
java.util.Random rand
double readWriteRatio
double writeDeleteRatio
double insertUpdateRatio
double orderByRatio
DatabaseSchema schema
java.util.ArrayList tables
int tableSize
private double schemaUpdateRatio
private double createDropRatio
Constructor Detail |
public QueryGenerator(DatabaseSchema schema)
QueryGenerator
object
public QueryGenerator(java.sql.Connection connection) throws java.sql.SQLException
QueryGenerator
object
connection
- used to retrieve the schema
java.sql.SQLException
- if fails to retrieve the schema with the given
connectionMethod Detail |
public static void main(java.lang.String[] args) throws java.lang.Exception
args
- not needed
java.lang.Exception
- yes!public final java.lang.String generateReadQuery()
public final java.lang.String generateSelectQuery()
private java.lang.String generateOrderBy(DatabaseTable table)
table
- target sql table of the read query
private java.lang.String getRelation(DatabaseTable table, boolean useLowerAndGreater)
private int getMaxUniqueId()
private int getNextMaxUniqueId()
private DatabaseTable getTable()
public final java.lang.String generateWriteQuery()
public final java.lang.String generateSchemaUpdateQuery()
public final java.lang.String generateCreateQuery()
public final java.lang.String generateDropQuery()
private boolean nextIsInRatio(double ratio)
public final java.lang.String generateDelete()
public final java.lang.String generateUpdate()
private DatabaseColumn getRandomNonUniqueColumn(DatabaseTable table)
private DatabaseColumn getRandomColumn(DatabaseTable table, boolean allowUnique)
public final java.lang.String generateInsert()
private final java.lang.String getRandomValue(DatabaseColumn column)
private final java.lang.String getRandomString(int size)
private final java.lang.String getRandomType()
private java.lang.String getRandomTable()
public final double getReadWriteRatio()
public final void setReadWriteRatio(double readWriteRatio)
readWriteRatio
- The readWriteRatio to set.public final java.lang.String generateQuery()
public final double getInsertUpdateRatio()
public final void setInsertUpdateRatio(double insertUpdateRatio)
insertUpdateRatio
- The insertUpdateRatio to set.public final double getOrderByRatio()
public final void setOrderByRatio(double orderByRatio)
orderByRatio
- The orderByRatio to set.public final double getWriteDeleteRatio()
public final void setWriteDeleteRatio(double writeDeleteRatio)
writeDeleteRatio
- The writeDeleteRatio to set.public double getCreateDropRatio()
public void setCreateDropRatio(double createDropRatio)
createDropRatio
- The createDropRatio to set.public double getSchemaUpdateRatio()
public void setSchemaUpdateRatio(double schemaUpdateRatio)
schemaUpdateRatio
- The schemaUpdateRatio to set.
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |