net.sf.jailer.util

Class Quoting

java.lang.Object

net.sf.jailer.util.Quoting

public class Quoting
extends java.lang.Object

Quotes and un-quotes SQL identifier in a DBMS specific way.

Author:

Ralf Wisser

Field Summary

Fields

Modifier and Type	Field and Description
static java.util.HashSet<java.lang.String>	UCSQL2003KEYWORDS

Constructor Summary

Constructors

Constructor and Description
Quoting(Session session) Constructor.

Method Summary

Modifier and Type	Method and Description
static boolean	equalsIgnoreQuotingAndCase(java.lang.String a, java.lang.String b) Compares a String to another String, ignoring case considerations and quoting.
static Quoting	getQuoting(Session session) Gets the Quoting for a given session.
static boolean	isPotentialIdentifierQuote(char c)
boolean	isQuoted(java.lang.String identifier) Checks if an identifier is quoted.
java.lang.String	normalizeCase(java.lang.String identifier)
static java.lang.String	normalizeIdentifier(java.lang.String identifier) Normalizes an identifier.
java.lang.String	quote(java.lang.String identifier) Quotes an identifier.
java.lang.String	requote(java.lang.String identifier) Quotes an identifier only if it is already quoted (potentially with a different quoting-string).
java.lang.String	requote(java.lang.String identifier, boolean force) Quotes an identifier only if it is already quoted (potentially with a different quoting-string).
void	setIdentifierQuoteString(java.lang.String identifierQuoteString) Sets the identifierQuoteString
static java.lang.String	staticUnquote(java.lang.String identifier) Remove quotes from identifier.
java.lang.String	unquote(java.lang.String identifier) Remove quotes from identifier.
static java.lang.String	unquotedTableName(Table t, ExecutionContext executionContext) Gets unquoted qualified table name.

Methods inherited from class java.lang.Object

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

Field Detail

UCSQL2003KEYWORDS

public static final java.util.HashSet<java.lang.String> UCSQL2003KEYWORDS

Constructor Detail

Quoting

public Quoting(Session session)
        throws java.sql.SQLException

Constructor.

Parameters:

session - the database session

Throws:

java.sql.SQLException

Method Detail

getQuoting

public static Quoting getQuoting(Session session)
                          throws java.sql.SQLException

Gets the Quoting for a given session.

Parameters:

session - the database session

Throws:

java.sql.SQLException

quote

public java.lang.String quote(java.lang.String identifier)

Quotes an identifier.

Parameters:

identifier - the identifier

Returns:

quoted identifier

isQuoted

public boolean isQuoted(java.lang.String identifier)

Checks if an identifier is quoted.

Parameters:

identifier - the identifier

Returns:

true if identifier is quoted

unquote

public java.lang.String unquote(java.lang.String identifier)

Remove quotes from identifier.

Parameters:

identifier - the identifier

Returns:

identifier without quotes

staticUnquote

public static java.lang.String staticUnquote(java.lang.String identifier)

Remove quotes from identifier.

Parameters:

identifier - the identifier

Returns:

identifier without quotes

requote

public java.lang.String requote(java.lang.String identifier)

Quotes an identifier only if it is already quoted (potentially with a different quoting-string).

Parameters:

identifier - the identifier

Returns:

quoted identifier

requote

public java.lang.String requote(java.lang.String identifier,
                                boolean force)

Quotes an identifier only if it is already quoted (potentially with a different quoting-string).

Parameters:

identifier - the identifier

Returns:

quoted identifier

unquotedTableName

public static java.lang.String unquotedTableName(Table t,
                                                 ExecutionContext executionContext)

Gets unquoted qualified table name.

Parameters:

t - the table

Returns:

unquoted qualified name of t

isPotentialIdentifierQuote

public static boolean isPotentialIdentifierQuote(char c)

setIdentifierQuoteString

public void setIdentifierQuoteString(java.lang.String identifierQuoteString)

Sets the identifierQuoteString

Parameters:

identifierQuoteString -

normalizeIdentifier

public static java.lang.String normalizeIdentifier(java.lang.String identifier)

Normalizes an identifier. normalizeIdentifier(a).equals(normalizeIdentifier(b)) iff a and b identify the same thing

Parameters:

identifier - the identifier

Returns:

normalize identifier

normalizeCase

public java.lang.String normalizeCase(java.lang.String identifier)

equalsIgnoreQuotingAndCase

public static boolean equalsIgnoreQuotingAndCase(java.lang.String a,
                                                 java.lang.String b)

Compares a String to another String, ignoring case considerations and quoting.

Parameters:

a - first String

b - second String

Returns:

true if a equals b