Class dblook

java.lang.Object

org.apache.derby.tools.dblook

public final class dblook
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
private static boolean	appendLogs
private Connection	conn
private static final int	DB2_MAX_NUMBER_OF_TABLES
private static String	ddlFileName
private static PreparedStatement	getColNameFromNumberQuery
private static final String[]	ignorableSchemaNames
private static LocalizedResource	langUtil
private static String	lookLogName
private static HashMap<String,String>	schemaMap
private static String	schemaParam
private static boolean	skipViews
private static String	sourceDBName
private static String	sourceDBUrl
private static boolean	sqlAuthorization
private static String	stmtDelimiter
private static HashMap<String,String>	tableIdToNameMap
private static ArrayList<String>	tableList
private static String	targetSchema
private static boolean	verbose

Constructor Summary

Constructors

Constructor	Description
dblook(String[] args)

Method Summary

Modifier and Type	Method	Description
static String	addQuotes(String name)
static String	addSingleQuotes(String name)
private static boolean	atVersion(Connection conn, int major, int minor)	Return true if we are at 10.6 or later.
static String	expandDoubleQuotes(String name)
private String	extractDBNameFromUrl(String dbUrl)
private int	extractTableNamesFromList(String[] args, int start)
static String	getColNameFromNumber(String tableId, int colNum)
static String	getColumnListFromDescription(String tableId, String description)
private void	go()
private void	initState()
static boolean	isExcludedTable(String tableName)
static boolean	isIgnorableSchema(String schemaName)
private boolean	loadDriver()
private int	loadParam(String[] args, int start)
static String	lookupMessage(String key)
static String	lookupMessage(String key, String[] vals)
static String	lookupSchemaId(String schemaId)
static String	lookupTableId(String tableId)
static void	main(String[] args)
private boolean	parseArgs(String[] args)
private static boolean	partOfWord(String str, int pos, int nameLen, int strLen)
private void	prepForDump()
static String	removeNewlines(String str)
private void	showVariables()
static boolean	stringContainsTargetTable(String str)
static String	stripQuotes(String quotedName)
static String	unExpandDoubleQuotes(String name)	inverse of expandDoubleQuotes
static void	writeVerboseOutput(String key, String value)

Methods inherited from class Object

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

Field Details

DB2_MAX_NUMBER_OF_TABLES

private static final int DB2_MAX_NUMBER_OF_TABLES

See Also:

• Constant Field Values

conn

private Connection conn

getColNameFromNumberQuery

private static PreparedStatement getColNameFromNumberQuery

schemaMap

private static HashMap<String,String> schemaMap

tableIdToNameMap

private static HashMap<String,String> tableIdToNameMap

sourceDBUrl

private static String sourceDBUrl

ddlFileName

private static String ddlFileName

stmtDelimiter

private static String stmtDelimiter

appendLogs

private static boolean appendLogs

tableList

private static ArrayList<String> tableList

schemaParam

private static String schemaParam

targetSchema

private static String targetSchema

skipViews

private static boolean skipViews

verbose

private static boolean verbose

sourceDBName

private static String sourceDBName

lookLogName

private static String lookLogName

langUtil

private static LocalizedResource langUtil

sqlAuthorization

private static boolean sqlAuthorization

ignorableSchemaNames

private static final String[] ignorableSchemaNames

Constructor Details

dblook

public dblook(String[] args)
       throws Exception

Throws:

Exception

Method Details

main

public static void main(String[] args)

initState

private void initState()

parseArgs

private boolean parseArgs(String[] args)

loadParam

private int loadParam(String[] args,
 int start)

loadDriver

private boolean loadDriver()

extractDBNameFromUrl

private String extractDBNameFromUrl(String dbUrl)

extractTableNamesFromList

private int extractTableNamesFromList(String[] args,
 int start)

showVariables

private void showVariables()

go

private void go()
         throws Exception

Throws:

Exception

prepForDump

private void prepForDump()
                  throws Exception

Throws:

Exception

getColumnListFromDescription

public static String getColumnListFromDescription(String tableId,
 String description)
                                           throws SQLException

Throws:

SQLException

getColNameFromNumber

public static String getColNameFromNumber(String tableId,
 int colNum)
                                   throws SQLException

Throws:

SQLException

addQuotes

public static String addQuotes(String name)

addSingleQuotes

public static String addSingleQuotes(String name)

stripQuotes

public static String stripQuotes(String quotedName)

isExcludedTable

public static boolean isExcludedTable(String tableName)

isIgnorableSchema

public static boolean isIgnorableSchema(String schemaName)

stringContainsTargetTable

public static boolean stringContainsTargetTable(String str)

partOfWord

private static boolean partOfWord(String str,
 int pos,
 int nameLen,
 int strLen)

expandDoubleQuotes

public static String expandDoubleQuotes(String name)

unExpandDoubleQuotes

public static String unExpandDoubleQuotes(String name)

inverse of expandDoubleQuotes

lookupSchemaId

public static String lookupSchemaId(String schemaId)

lookupTableId

public static String lookupTableId(String tableId)

writeVerboseOutput

public static void writeVerboseOutput(String key,
 String value)

lookupMessage

public static String lookupMessage(String key)

lookupMessage

public static String lookupMessage(String key,
 String[] vals)

removeNewlines

public static String removeNewlines(String str)

atVersion

private static boolean atVersion(Connection conn,
 int major,
 int minor)
                          throws SQLException

Return true if we are at 10.6 or later.

Throws:

SQLException