java.lang.Object
inet.ipaddr.format.util.sql.MySQLTranslator
- All Implemented Interfaces:
IPAddressSQLTranslator
- Author:
- sfoley
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionboundSeparatorCount
(StringBuilder builder, String expression, char separator, int separatorCount) Produces an SQL condition that evaluates to true when "expression" has at most a certain number of a given char within, appending the condition to the given string builder.matchSeparatorCount
(StringBuilder builder, String expression, char separator, int separatorCount) Produces an SQL condition that evaluates to true when "expression" has exactly a certain number of a given char within, appending the condition to the given string builder.matchString
(StringBuilder builder, String expression, String match) Produces an SQL condition that evaluates to true when the given expression matches the given String, appending the condition to the given string builder.matchSubString
(StringBuilder builder, String expression, char separator, int separatorCount, String match) Produces an SQL condition that evaluates to true when the given expression matches a substring obtained from the given expression, appending the condition to the given string builder.void
setNetwork
(String networkString) Called with the network section, taken from an IP address or IP address section, that is being matched, for logging or debugging purposes.
-
Constructor Details
-
MySQLTranslator
public MySQLTranslator()
-
-
Method Details
-
setNetwork
Description copied from interface:IPAddressSQLTranslator
Called with the network section, taken from an IP address or IP address section, that is being matched, for logging or debugging purposes.- Specified by:
setNetwork
in interfaceIPAddressSQLTranslator
- Parameters:
networkString
-
-
matchString
Description copied from interface:IPAddressSQLTranslator
Produces an SQL condition that evaluates to true when the given expression matches the given String, appending the condition to the given string builder.- Specified by:
matchString
in interfaceIPAddressSQLTranslator
- Parameters:
builder
-expression
- the expressionmatch
- the String to match with the expression- Returns:
- builder with the condition appended
-
matchSubString
public StringBuilder matchSubString(StringBuilder builder, String expression, char separator, int separatorCount, String match) Description copied from interface:IPAddressSQLTranslator
Produces an SQL condition that evaluates to true when the given expression matches a substring obtained from the given expression, appending the condition to the given string builder.- Specified by:
matchSubString
in interfaceIPAddressSQLTranslator
- Parameters:
builder
-expression
- the expressionmatch
- the String to match with a substring of the expression, the substring being the substring taken from "expression" prior to the separatorCount appearance of the given separator char. If there are not that many appearances of the separator char, then the substring is all of the String expression.- Returns:
- builder with the condition appended
-
matchSeparatorCount
public StringBuilder matchSeparatorCount(StringBuilder builder, String expression, char separator, int separatorCount) Description copied from interface:IPAddressSQLTranslator
Produces an SQL condition that evaluates to true when "expression" has exactly a certain number of a given char within, appending the condition to the given string builder.- Specified by:
matchSeparatorCount
in interfaceIPAddressSQLTranslator
- Parameters:
builder
-expression
- the expression which must contain the indicated count of the indicated separator charseparator
- the separator charseparatorCount
- the count to match- Returns:
- builder with the condition appended
-
boundSeparatorCount
public StringBuilder boundSeparatorCount(StringBuilder builder, String expression, char separator, int separatorCount) Description copied from interface:IPAddressSQLTranslator
Produces an SQL condition that evaluates to true when "expression" has at most a certain number of a given char within, appending the condition to the given string builder.- Specified by:
boundSeparatorCount
in interfaceIPAddressSQLTranslator
- Parameters:
builder
-expression
- the expression which must contain at most the indicated count of the indicated separator charseparator
- the separator charseparatorCount
- the count to match- Returns:
- builder with the condition appended
-