org.evomaster.client.java.controller.api.dto.database.execution

Class SqlExecutionsDto

java.lang.Object

org.evomaster.client.java.controller.api.dto.database.execution.SqlExecutionsDto

public class SqlExecutionsDto
extends Object

Each time a SQL command is executed, we keep track of which tables and columns are involved. All the following Maps are in the form: from Table Name (key) to Column Name sets (value). The value "*" means all columns in the table. Note: we keep track of what the SUT tried to execute on the database, but not the result, eg, a DELETE might have deleted nothing if its WHERE clause was not satisfied.

Field Summary

Fields

Modifier and Type	Field and Description
Set<String>	deletedData Names of tables on which DELETE was applied
Map<String,Set<String>>	failedWhere Every time there is a WHERE clause which "failed" (ie, resulted in false), we keep track of which tables/columns where involved in determining the result of the WHERE.
Map<String,Set<String>>	insertedData What tables/columns were tried to be newly created with INSERT
int	numberOfSqlCommands The total Number of SQL commands (e.g., SELECT and UPDATE) executed
Map<String,Set<String>>	queriedData What was tried to be retrieved in a SELECT.
List<SqlExecutionLogDto>	sqlExecutionLogDtoList log of a list of sql commands that were executed
int	sqlParseFailureCount The number of SQL command that could not be parsed
Map<String,Set<String>>	updatedData What tables/columns were tried to be updated in UPDATE

Constructor Summary

Constructors

Constructor and Description
SqlExecutionsDto()

Method Summary

Methods inherited from class java.lang.Object

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

Field Detail

queriedData

public Map<String,Set<String>> queriedData

What was tried to be retrieved in a SELECT. Something like "select x from Foo" would give info on "Foo->{x}". However, at times, what is returned is not directly the content of a column, but rather some computations on it. For example, in "select avg(x) from Foo", we would still be just interested in the info that the data in "Foo->{x}" was used to compute the result. Note: this does NOT include what was used in the WHERE clauses. For example, "select a,b from Foo where c>0" would give info just for "Foo->{a,b}"

updatedData

public Map<String,Set<String>> updatedData

What tables/columns were tried to be updated in UPDATE

insertedData

public Map<String,Set<String>> insertedData

What tables/columns were tried to be newly created with INSERT

deletedData

public Set<String> deletedData

Names of tables on which DELETE was applied

failedWhere

public Map<String,Set<String>> failedWhere

Every time there is a WHERE clause which "failed" (ie, resulted in false), we keep track of which tables/columns where involved in determining the result of the WHERE. If there is no WHERE, but still no data was returned, we consider it as a failed WHERE

numberOfSqlCommands

public int numberOfSqlCommands

The total Number of SQL commands (e.g., SELECT and UPDATE) executed

sqlParseFailureCount

public int sqlParseFailureCount

The number of SQL command that could not be parsed

sqlExecutionLogDtoList

public List<SqlExecutionLogDto> sqlExecutionLogDtoList

log of a list of sql commands that were executed

Constructor Detail

SqlExecutionsDto

public SqlExecutionsDto()