org.evomaster.clientJava.controller.internal.db

Class SelectHeuristics

java.lang.Object

org.evomaster.clientJava.controller.internal.db.SelectHeuristics

public class SelectHeuristics
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
static String	UNNAMED_TABLE

Constructor Summary

Constructors

Constructor and Description
SelectHeuristics()

Method Summary

Modifier and Type	Method and Description
static String	addFieldsToSelect(String select) The constraints in the WHERE clause might reference fields that are not retrieved in the SELECT.
static double	computeDistance(String select, QueryResult data)
static Map<String,Set<String>>	getReadDataFields(String select)
static Map<String,String>	getTableAliases(net.sf.jsqlparser.statement.select.Select select) Workaround to JDBC limitations: it does not provide any API to query meta-data on table aliases!!! ad-hoc solutions for each possible imaginable DB are not scalable.
static String	removeConstraints(String select)
static String	removeOperations(String select) For example, when we have "select count(*)" we are not interested in the count, but the actual involved fields, so we want to transform it into "select *" by removing the count() operation.

Methods inherited from class java.lang.Object

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

Field Detail

UNNAMED_TABLE

public static final String UNNAMED_TABLE

See Also:

Constant Field Values

Constructor Detail

SelectHeuristics

public SelectHeuristics()

Method Detail

getReadDataFields

public static Map<String,Set<String>> getReadDataFields(String select)

Returns:

addFieldsToSelect

public static String addFieldsToSelect(String select)

The constraints in the WHERE clause might reference fields that are not retrieved in the SELECT. Therefore, we need to add them, otherwise it would not be possible to calculate any heuristics

Parameters:

select - the string containing the SQL SELECT command

Returns:

the modified SQL SELECT

removeOperations

public static String removeOperations(String select)

For example, when we have "select count(*)" we are not interested in the count, but the actual involved fields, so we want to transform it into "select *" by removing the count() operation.

Parameters:

select -

Returns:

removeConstraints

public static String removeConstraints(String select)

computeDistance

public static double computeDistance(String select,
                                     QueryResult data)

getTableAliases

public static Map<String,String> getTableAliases(net.sf.jsqlparser.statement.select.Select select)

Workaround to JDBC limitations: it does not provide any API to query meta-data on table aliases!!! ad-hoc solutions for each possible imaginable DB are not scalable. So, we just try to do some best effort to cover most cases

Parameters:

select - the string containing the SQL SELECT command

Returns:

map from alias to table name