org.apache.derby.tools
Class dblook

java.lang.Object
  org.apache.derby.tools.dblook

public class dblook

extends java.lang.Object

Field Summary

protected static boolean	appendLogs
static int	DB2_MAX_NUMBER_OF_TABLES
protected static java.lang.String	ddlFileName
static java.lang.String[]	ignorableSchemaNames
protected static java.util.HashMap	schemaMap
protected static java.lang.String	schemaParam
protected static boolean	skipViews
protected static java.lang.String	sourceDBUrl
protected static java.lang.String	stmtDelimiter
protected static java.util.HashMap	tableIdToNameMap
protected static java.util.ArrayList	tableList
protected static java.lang.String	targetSchema
protected static boolean	verbose

Constructor Summary

dblook(java.lang.String[] args)

Method Summary

static java.lang.String	addQuotes(java.lang.String name)
static java.lang.String	expandDoubleQuotes(java.lang.String name)
protected java.lang.String	extractDBNameFromUrl(java.lang.String dbUrl)
static java.lang.String	getColNameFromNumber(java.lang.String tableId, int colNum)
static java.lang.String	getColumnListFromDescription(java.lang.String tableId, java.lang.String description)
static boolean	isExcludedTable(java.lang.String tableName)
static boolean	isIgnorableSchema(java.lang.String schemaName)
static java.lang.String	lookupMessage(java.lang.String key)
static java.lang.String	lookupMessage(java.lang.String key, java.lang.String[] vals)
static java.lang.String	lookupSchemaId(java.lang.String schemaId)
static java.lang.String	lookupTableId(java.lang.String tableId)
static void	main(java.lang.String[] args)
static java.lang.String	removeNewlines(java.lang.String str)
static boolean	stringContainsTargetTable(java.lang.String str)
static java.lang.String	stripQuotes(java.lang.String quotedName)
static void	writeVerboseOutput(java.lang.String key, java.lang.String value)

Methods inherited from class java.lang.Object

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

Field Detail

DB2_MAX_NUMBER_OF_TABLES

public static final int DB2_MAX_NUMBER_OF_TABLES

See Also:

Constant Field Values

schemaMap

protected static java.util.HashMap schemaMap

tableIdToNameMap

protected static java.util.HashMap tableIdToNameMap

sourceDBUrl

protected static java.lang.String sourceDBUrl

ddlFileName

protected static java.lang.String ddlFileName

stmtDelimiter

protected static java.lang.String stmtDelimiter

appendLogs

protected static boolean appendLogs

tableList

protected static java.util.ArrayList tableList

schemaParam

protected static java.lang.String schemaParam

targetSchema

protected static java.lang.String targetSchema

skipViews

protected static boolean skipViews

verbose

protected static boolean verbose

ignorableSchemaNames

public static final java.lang.String[] ignorableSchemaNames

Constructor Detail

dblook

public dblook(java.lang.String[] args)
       throws java.lang.Exception

Method Detail

main

public static void main(java.lang.String[] args)

extractDBNameFromUrl

protected java.lang.String extractDBNameFromUrl(java.lang.String dbUrl)

getColumnListFromDescription

public static java.lang.String getColumnListFromDescription(java.lang.String tableId,
                                                            java.lang.String description)
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getColNameFromNumber

public static java.lang.String getColNameFromNumber(java.lang.String tableId,
                                                    int colNum)
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

addQuotes

public static java.lang.String addQuotes(java.lang.String name)

stripQuotes

public static java.lang.String stripQuotes(java.lang.String quotedName)

isExcludedTable

public static boolean isExcludedTable(java.lang.String tableName)

isIgnorableSchema

public static boolean isIgnorableSchema(java.lang.String schemaName)

stringContainsTargetTable

public static boolean stringContainsTargetTable(java.lang.String str)

expandDoubleQuotes

public static java.lang.String expandDoubleQuotes(java.lang.String name)

lookupSchemaId

public static java.lang.String lookupSchemaId(java.lang.String schemaId)

lookupTableId

public static java.lang.String lookupTableId(java.lang.String tableId)

writeVerboseOutput

public static void writeVerboseOutput(java.lang.String key,
                                      java.lang.String value)

lookupMessage

public static java.lang.String lookupMessage(java.lang.String key)

lookupMessage

public static java.lang.String lookupMessage(java.lang.String key,
                                             java.lang.String[] vals)

removeNewlines

public static java.lang.String removeNewlines(java.lang.String str)