net.sf.jailer.util

Class SqlUtil

java.lang.Object

net.sf.jailer.util.SqlUtil

public class SqlUtil
extends Object

Some utility methods.

Author:

Ralf Wisser

Field Summary

Fields

Modifier and Type	Field and Description
static List<String>	JAILER_MH_TABLES List of all jailer tables (upper case).
static List<String>	JAILER_TABLES List of all jailer tables (upper case).
static String	LETTERS_AND_DIGITS
static Map<Integer,String>	SQL_TYPE Maps SQL types from Types to clear text types.

Constructor Summary

Constructors

Constructor and Description
SqlUtil()

Method Summary

Methods

Modifier and Type	Method and Description
static int	getColumnType(ResultSet resultSet, ResultSetMetaData resultSetMetaData, int i, Map<Integer,Integer> typeCache) Gets type of column from result-set.
static int	getColumnType(ResultSet resultSet, ResultSetMetaData resultSetMetaData, String columnName, Map<String,Integer> typeCache) Gets type of column from result-set.
static String	mappedSchema(Map<String,String> schemaMapping, String tableName) Replaces schema of qualified table name according to a schema-map.
static Set<Table>	readTableList(CsvFile tableFile, DataModel dataModel, Map<String,String> sourceSchemaMapping) Reads a table-list from CSV-file.
static String	replaceAlias(String condition, String alias) Replaces the alias T with given alias in a SQL-condition.
static String	replaceAliases(String condition, String aliasA, String aliasB) Replaces the aliases A and B with given aliases in a SQL-condition.
static String	resolvePseudoColumns(String condition, int today, int birthdayOfSubject, boolean reversed, boolean inDeleteMode) Resolves the pseudo-columns in a restriction condition.
static String	resolvePseudoColumns(String condition, String entityAAlias, String entityBAlias, int today, int birthdayOfSubject, boolean inDeleteMode) Resolves the pseudo-columns in a restriction condition.
static String	resolvePseudoColumns(String condition, String entityAAlias, String entityBAlias, int today, int birthdayOfSubject, String birthdayColumnName, boolean inDeleteMode) Resolves the pseudo-columns in a restriction condition.
static String	reversRestrictionCondition(String condition) Change alias A to B and B to A in a SQL-condition.
static String	splitDMLStatement(String sql, int maxLength) Splits a DML statement into several lines with limited length.

Methods inherited from class java.lang.Object

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

Field Detail

JAILER_TABLES

public static final List<String> JAILER_TABLES

List of all jailer tables (upper case).

JAILER_MH_TABLES

public static final List<String> JAILER_MH_TABLES

List of all jailer tables (upper case).

LETTERS_AND_DIGITS

public static final String LETTERS_AND_DIGITS

See Also:

Constant Field Values

SQL_TYPE

public static final Map<Integer,String> SQL_TYPE

Maps SQL types from Types to clear text types.

Constructor Detail

SqlUtil

public SqlUtil()

Method Detail

reversRestrictionCondition

public static String reversRestrictionCondition(String condition)

Change alias A to B and B to A in a SQL-condition.

Parameters:

condition - the condition

Returns:

condition with revered aliases

replaceAliases

public static String replaceAliases(String condition,
                    String aliasA,
                    String aliasB)

Replaces the aliases A and B with given aliases in a SQL-condition.

Parameters:

condition - the condition

aliasA - alias for A

aliasB - alias for B

Returns:

condition with replaced aliases

replaceAlias

public static String replaceAlias(String condition,
                  String alias)

Replaces the alias T with given alias in a SQL-condition.

Parameters:

condition - the condition

alias - alias for T

Returns:

condition with replaced aliases

resolvePseudoColumns

public static String resolvePseudoColumns(String condition,
                          String entityAAlias,
                          String entityBAlias,
                          int today,
                          int birthdayOfSubject,
                          boolean inDeleteMode)

Resolves the pseudo-columns in a restriction condition.

Parameters:

condition - the condition

entityAAlias - alias for entity table joined with A

entityBAlias - alias for entity table joined with B

birthdayOfSubject - birthday of subject

today - today

inDeleteMode -

resolvePseudoColumns

public static String resolvePseudoColumns(String condition,
                          String entityAAlias,
                          String entityBAlias,
                          int today,
                          int birthdayOfSubject,
                          String birthdayColumnName,
                          boolean inDeleteMode)

Resolves the pseudo-columns in a restriction condition.

Parameters:

condition - the condition

entityAAlias - alias for entity table joined with A

entityBAlias - alias for entity table joined with B

birthdayOfSubject - birthday of subject

today - today

birthdayColumnName - name of the column which holds the birthday of an entity ('birthday' or 'orig_birthday')

inDeleteMode -

resolvePseudoColumns

public static String resolvePseudoColumns(String condition,
                          int today,
                          int birthdayOfSubject,
                          boolean reversed,
                          boolean inDeleteMode)

Resolves the pseudo-columns in a restriction condition.

Parameters:

condition - the condition

birthdayOfSubject - birthday of subject

today - today

reversed -

inDeleteMode -

readTableList

public static Set<Table> readTableList(CsvFile tableFile,
                       DataModel dataModel,
                       Map<String,String> sourceSchemaMapping)

Reads a table-list from CSV-file.

Parameters:

dataModel - to get tables from

tableFile - the file containing the list

Returns:

set of tables, empty list if file contains no tables

mappedSchema

public static String mappedSchema(Map<String,String> schemaMapping,
                  String tableName)

Replaces schema of qualified table name according to a schema-map.

Parameters:

schemaMapping - the mapping

tableName - the table name

Returns:

table name with replaced schema

getColumnType

public static int getColumnType(ResultSet resultSet,
                ResultSetMetaData resultSetMetaData,
                int i,
                Map<Integer,Integer> typeCache)
                         throws SQLException

Gets type of column from result-set.

Parameters:

resultSet - result-set

i - column index

typeCache - for caching types

Returns:

type according to Types

Throws:

SQLException

getColumnType

public static int getColumnType(ResultSet resultSet,
                ResultSetMetaData resultSetMetaData,
                String columnName,
                Map<String,Integer> typeCache)
                         throws SQLException

Gets type of column from result-set.

Parameters:

resultSet - result-set

columnName - column name

typeCache - for caching types

Returns:

object

Throws:

SQLException

splitDMLStatement

public static String splitDMLStatement(String sql,
                       int maxLength)

Splits a DML statement into several lines with limited length.

Parameters:

sql - the DML statement

maxLength - maximum line length

Returns:

DML statement with line breaks