org.javasimon.jdbc4

Class SqlNormalizer

java.lang.Object

org.javasimon.jdbc4.SqlNormalizer

public final class SqlNormalizer
extends Object

SqlNormalizer takes SQL statement and replaces parameters with question marks. It is important to realize, that normalizer IS NOT SQL analyzer. It makes as simple replacement as possible (with my coding skill ;-)) to still truly represent the original statement. Normalized statement is merely used to recognize the original one and also to merge the same statements with various arguments. Its primary purpose is to limit count of distinct per-statement Simons. It doesn't suppose to be perfect or proof to all dialects.

Usage is simple, you create normalizer with SQL statement and than you can ask the object for normalizedSql and type via respective getters.

Since:

2.4

Author:

Radovan Sninsky, Richard "Virgo" Richter

Constructor Summary

Constructors

Constructor and Description
SqlNormalizer(List<String> batch) Constructor for batch normalization.
SqlNormalizer(String sql) Creates SQL normalizer and performs the normalization.

Method Summary

Methods

Modifier and Type	Method and Description
String	getNormalizedSql() Returns the normalized SQL.
String	getSql() Returns the original SQL.
String	getType() Returns SQL type which is typically first word of the SQL (insert, select, etc).
String	toString() Returns human readable string describing this SQL normalizer.

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlNormalizer

public SqlNormalizer(String sql)

Creates SQL normalizer and performs the normalization.

Parameters:

sql - SQL to normalize

SqlNormalizer

public SqlNormalizer(List<String> batch)

Constructor for batch normalization. Type of the "statement" will be "batch".

Parameters:

batch - list of statements

Method Detail

getSql

public String getSql()

Returns the original SQL.

Returns:

original SQL

getNormalizedSql

public String getNormalizedSql()

Returns the normalized SQL.

Returns:

normalized SQL

getType

public String getType()

Returns SQL type which is typically first word of the SQL (insert, select, etc). Returns batch for batches.

Returns:

SQL statement type or "batch"

toString

public String toString()

Returns human readable string describing this SQL normalizer.

Overrides:

toString in class Object

Returns:

original SQL, normalized SQL, SQL type