Package com.pyranid

Class StatementLog

java.lang.Object

com.pyranid.StatementLog

All Implemented Interfaces:

Serializable

public class StatementLog
extends Object
implements Serializable

A collection of SQL statement execution diagnostics.

Created via builder, for example

 StatementLog statementLog = StatementLog.forSql("SELECT * FROM car WHERE id=?").parameters(singletonList(123)).build();
 

Since:

1.0.0

Author:

Mark Allen

See Also:

• Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	StatementLog.Builder	Builder for StatementLog instances.

Method Summary

Modifier and Type	Method	Description
Optional<Integer>	batchSize()	The size of the batch operation.
Optional<Long>	connectionAcquisitionTime()	How long did it take to acquire a Connection from the DataSource, in nanoseconds?
boolean	equals(Object object)
Optional<Exception>	exception()	The exception that occurred during SQL statement execution.
Optional<Long>	executionTime()	How long did it take to execute the SQL statement, in nanoseconds?
static StatementLog.Builder	forSql(String sql)	Creates a StatementLog builder for the given sql.
int	hashCode()
List<Object>	parameters()	The parameters bound to the SQL statement that was executed.
Optional<Long>	preparationTime()	How long did it take to bind data to the PreparedStatement, in nanoseconds?
Optional<Long>	resultSetMappingTime()	How long did it take to extract data from the ResultSet, in nanoseconds?
String	sql()	The SQL statement that was executed.
Optional<StatementMetadata>	statementMetadata()	The metadata associated with this SQL statement.
String	toString()
Long	totalTime()	How long did it take to perform the database operation in total?

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Method Details

toString

public String toString()

Overrides:

toString in class Object

equals

public boolean equals(Object object)

Overrides:

equals in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object

forSql

public static StatementLog.Builder forSql(String sql)

Creates a StatementLog builder for the given sql.

Parameters:

sql - the SQL statement

Returns:

a StatementLog builder

connectionAcquisitionTime

public Optional<Long> connectionAcquisitionTime()

How long did it take to acquire a Connection from the DataSource, in nanoseconds?

Returns:

how long it took to acquire a Connection, if available

preparationTime

public Optional<Long> preparationTime()

How long did it take to bind data to the PreparedStatement, in nanoseconds?

Returns:

how long it took to bind data to the PreparedStatement, if available

executionTime

public Optional<Long> executionTime()

How long did it take to execute the SQL statement, in nanoseconds?

Returns:

how long it took to execute the SQL statement, if available

resultSetMappingTime

public Optional<Long> resultSetMappingTime()

How long did it take to extract data from the ResultSet, in nanoseconds?

Returns:

how long it took to extract data from the ResultSet, if available

totalTime

public Long totalTime()

How long did it take to perform the database operation in total?

This is the sum of connectionAcquisitionTime() + preparationTime() + executionTime() + resultSetMappingTime().

Returns:

how long the database operation took in total

sql

public String sql()

The SQL statement that was executed.

Returns:

the SQL statement that was executed.

parameters

public List<Object> parameters()

The parameters bound to the SQL statement that was executed.

Returns:

the parameters bound to the SQL statement that was executed, or an empty List if none

batchSize

public Optional<Integer> batchSize()

The size of the batch operation.

Returns:

how many records were processed as part of the batch operation, if available

exception

public Optional<Exception> exception()

The exception that occurred during SQL statement execution.

Returns:

the exception that occurred during SQL statement execution, if available

statementMetadata

public Optional<StatementMetadata> statementMetadata()

The metadata associated with this SQL statement.

Returns:

he metadata associated with this SQL statement, if available