Package com.vladmihalcea.sql

Class SQLStatementCountValidator

java.lang.Object

com.vladmihalcea.sql.SQLStatementCountValidator

public class SQLStatementCountValidator
extends Object

SQLStatementCountValidator - Validates recorded statements count. First you execute some operations against your database and then you check how many statements were executed. This is a useful tool against the "N+1" problem or suboptimal DML statements.

Author:

Vlad Mihalcea

Method Summary

Modifier and Type	Method	Description
static void	assertDeleteCount(long expectedDeleteCount)	Assert delete statement count
static void	assertDeleteCount(String message, long expectedDeleteCount)	Assert delete statement count
static void	assertInsertCount(long expectedInsertCount)	Assert insert statement count
static void	assertInsertCount(String message, long expectedInsertCount)	Assert insert statement count
static void	assertSelectCount(long expectedSelectCount)	Assert select statement count
static void	assertSelectCount(String message, long expectedSelectCount)	Assert select statement count
static void	assertUpdateCount(long expectedUpdateCount)	Assert update statement count
static void	assertUpdateCount(String message, long expectedUpdateCount)	Assert update statement count
static void	reset()	Reset the statement recorder

Methods inherited from class java.lang.Object

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

Method Detail

reset

public static void reset()

Reset the statement recorder

assertSelectCount

public static void assertSelectCount(long expectedSelectCount)

Assert select statement count

Parameters:

expectedSelectCount - expected select statement count

assertSelectCount

public static void assertSelectCount(String message,
                                     long expectedSelectCount)

Assert select statement count

Parameters:

message - explaining the reason of expectedSelectCount

expectedSelectCount - expected select statement count

assertInsertCount

public static void assertInsertCount(long expectedInsertCount)

Assert insert statement count

Parameters:

expectedInsertCount - expected insert statement count

assertInsertCount

public static void assertInsertCount(String message,
                                     long expectedInsertCount)

Assert insert statement count

Parameters:

message - explaining the reason of expectedInsertCount

expectedInsertCount - expected insert statement count

assertUpdateCount

public static void assertUpdateCount(long expectedUpdateCount)

Assert update statement count

Parameters:

expectedUpdateCount - expected update statement count

assertUpdateCount

public static void assertUpdateCount(String message,
                                     long expectedUpdateCount)

Assert update statement count

Parameters:

message - explaining the reason of expectedUpdateCount

expectedUpdateCount - expected update statement count

assertDeleteCount

public static void assertDeleteCount(long expectedDeleteCount)

Assert delete statement count

Parameters:

expectedDeleteCount - expected delete statement count

assertDeleteCount

public static void assertDeleteCount(String message,
                                     long expectedDeleteCount)

Assert delete statement count

Parameters:

message - explaining the reason of expectedDeleteCount

expectedDeleteCount - expected delete statement count