APIdia Launch Partner
Top Inners Fields Constructors Methods
net.ucanaccess.converters

public final Class SQLConverter

extends Object
Class Inheritance
Annotations
@SuppressWarnings:PMD.FieldDeclarationsShouldBeAtStartOfClass, PMD.UnnecessaryFullyQualifiedName
Imports
io.github.spannm.jackcess.TableBuilder, net.ucanaccess.exception.InvalidCreateStatementException, net.ucanaccess.jdbc.NormalizedSQL, .UcanaccessConnection, java.sql.Connection, .SQLException, .Statement, java.util.*, java.util.regex.Matcher, .Pattern, java.util.stream.Collectors

Nested and Inner Type Summary

Modifier and TypeClass and Description
public static enum
SQLConverter.DDLType

public static class
SQLConverter.Patterns

Field Summary

Modifier and TypeField and Description
private static final Set<String>
ALREADY_ESCAPED_IDENTIFIERS

private static final Set<String>
APOSTROPHISED_NAMES

private static final String
BACKTICK

private static final String
BIG_BANG

public static final String
DATE_ACCESS_FORMAT

public static final String
DATE_FORMAT

private static final String
DELETE_ALL

private static boolean
dualUsedAsTableName

private static final Set<String>
ESCAPED_IDENTIFIERS

public static final String
HHMMSS_ACCESS_FORMAT

public static final String
HHMMSS_FORMAT

private static final Map<String, String>
IDENTIFIERS_CONTAINING_KEYWORD

private static final List<String>
KEYWORDS_LIST

private static final String
NAME_PAT

private static final int
NAME_PAT_STEP

private static final String
PARAMETERS

private static final Pattern
PAT_KEYWORD_ALIAS

private static final List<String>
PROCEDURE_KEYWORDS

private static boolean
supportsAccessLike

private static final String
UNION

private static final List<String>
WHITE_SPACED_TABLE_NAMES

private static final Set<String>
WORKAROUND_FUNCTIONS

Constructor Summary

AccessConstructor and Description
private
SQLConverter()

Method Summary

Modifier and TypeMethod and Description
pack-priv static void
addWAFunctionName(String name)

pack-priv static void
addWhiteSpacedTableNames(String input)

private static void
aliases(String sql, NormalizedSQL nsql)

public static int
asUnsigned(byte a)

public static String
basicEscapingIdentifier(String name)

public static boolean
checkDDL(String sql)

public static String
checkLang(String name, Connection conn)

public static String
checkLang(String name, Connection conn, boolean quote)

public static void
cleanEscaped()

private static String
clearDefaultsCreateStatement(String sql)

public static String
completeEscaping(String escaped, boolean quote)

public static String
completeEscaping(String escaped)

public static String
convertAccessDate(String sql)

public static String
convertAddColumn(String tableName, String columnName, String typeDeclaration)

private static String
convertCreateTable(String inputSql, Map<String, String> types2Convert)

public static String
convertCreateTable(String sql)

private static String
convertDeleteAll(String sql)

private static String
convertDigit(String sql)

public static String
convertFormula(String sql)

private static String
convertFormula0(String sql)

private static String
convertIdentifiers(String sql)

private static String
convertLike(String sql)

private static String
convertLike(String conditionField, String closePar, String not, String likeContent)

private static String
convertOwnerAccess(String sql)

private static String
convertPartIdentifiers(String sql)

public static String
convertPowOperator(String sql)

private static String
convertQuotedAliases(String sql, NormalizedSQL nsql)

private static String
convertResidualSql(String sql)

public static NormalizedSQL
convertSQL(String sql, boolean creatingQuery)

public static NormalizedSQL
convertSQL(String inputSql, UcanaccessConnection conn, boolean creatingQuery)

public static NormalizedSQL
convertSQL(String sql)

public static NormalizedSQL
convertSQL(String sql, UcanaccessConnection conn)

private static String
convertSQLTokens(String sql)

private static String
convertToLikeCondition(String likeContent)

pack-priv static String
convertToRegexMatches(String likeContent)

private static String
convertTypeDeclaration(String typeDecl)

private static String
convertUnion(String sql)

private static String
convertXescaped(String sqlc)

private static String
convertYesNo(String sql)

public static boolean
couldNeedDefault(String typeDeclaration)

private static String
escape(String sql)

public static String
escapeIdentifier(String name, Connection conn)

public static String
escapeIdentifier(String name)

private static String
escapeKeywordIdentifier(String escaped, boolean quote)

private static int
firstOperandIndex(String sql, int i)

public static String
getDDLDefault(String ddlf)

public static SQLConverter.DDLType
getDDLType(String s)

private static int[]
getDoubleQuoteGroup(String s)

public static Set<String>
getFormulaDependencies(String formula)

public static List<String>
getParameters(String s)

public static String
getPreparedStatement(String qtxt, List<String> l)

private static int[]
getQuoteGroup(String s)

public static boolean
hasIdentity(String sql)

private static String
hsqlEscape(String escaped, boolean quote)

pack-priv static boolean
isDualUsedAsTableName()

public static boolean
isListedAsKeyword(String s)

public static boolean
isSupportsAccessLike()

public static boolean
isXescaped(String identifier)

public static String
preEscapingIdentifier(String name)

public static String
preprocess(String sql, Object key)

public static String
procedureEscapingIdentifier(String name)

public static String
removeParameters(String qtxt)

private static String
replaceAposNames(String sql)

private static String
replaceBacktick(String sql)

private static String
replaceDigitStartingIdentifiers(String sql)

private static String
replaceDistinctRow(String sql)

private static String
replaceExclamationPoints(String sql)

private static String
replaceWhiteSpacedTableNames0(String sql)

private static String
replaceWhiteSpacedTables(String sql)

private static String
replaceWhiteSpacedTables(String sql, String character)

private static String
replaceWorkAroundFunctions(String sql)

public static String
restoreWorkAroundFunctions(String sql)

private static int
secondOperandIndex(String sql, int i)

pack-priv static void
setDualUsedAsTableName(boolean dualUsedAsTableName)

public static void
setSupportsAccessLike(boolean supportsAccessLike)

pack-priv static String

Returns:

the translated SQL string using the POWER function.
translateAccessPowerOperators(String
the SQL string containing MS Access power operators.
sql)

Translates MS Access SQL expressions using the '^' (power) operator into the standard SQL POWER(base, exponent) function.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait