Package org.apache.derby.tools
Class dblook
- java.lang.Object
-
- org.apache.derby.tools.dblook
-
public final class dblook extends java.lang.Object
-
-
Field Summary
Fields Modifier and Type Field Description private static boolean
appendLogs
private java.sql.Connection
conn
private static int
DB2_MAX_NUMBER_OF_TABLES
private static java.lang.String
ddlFileName
private static java.sql.PreparedStatement
getColNameFromNumberQuery
private static java.lang.String[]
ignorableSchemaNames
private static LocalizedResource
langUtil
private static java.lang.String
lookLogName
private static java.util.HashMap<java.lang.String,java.lang.String>
schemaMap
private static java.lang.String
schemaParam
private static boolean
skipViews
private static java.lang.String
sourceDBName
private static java.lang.String
sourceDBUrl
private static boolean
sqlAuthorization
private static java.lang.String
stmtDelimiter
private static java.util.HashMap<java.lang.String,java.lang.String>
tableIdToNameMap
private static java.util.ArrayList<java.lang.String>
tableList
private static java.lang.String
targetSchema
private static boolean
verbose
-
Constructor Summary
Constructors Constructor Description dblook(java.lang.String[] args)
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description static java.lang.String
addQuotes(java.lang.String name)
static java.lang.String
addSingleQuotes(java.lang.String name)
private static boolean
atVersion(java.sql.Connection conn, int major, int minor)
Return true if we are at 10.6 or later.static java.lang.String
expandDoubleQuotes(java.lang.String name)
private java.lang.String
extractDBNameFromUrl(java.lang.String dbUrl)
private int
extractTableNamesFromList(java.lang.String[] args, int start)
static java.lang.String
getColNameFromNumber(java.lang.String tableId, int colNum)
static java.lang.String
getColumnListFromDescription(java.lang.String tableId, java.lang.String description)
private void
go()
private void
initState()
static boolean
isExcludedTable(java.lang.String tableName)
static boolean
isIgnorableSchema(java.lang.String schemaName)
private boolean
loadDriver()
private int
loadParam(java.lang.String[] args, int start)
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)
private boolean
parseArgs(java.lang.String[] args)
private static boolean
partOfWord(java.lang.String str, int pos, int nameLen, int strLen)
private void
prepForDump()
static java.lang.String
removeNewlines(java.lang.String str)
private void
showVariables()
static boolean
stringContainsTargetTable(java.lang.String str)
static java.lang.String
stripQuotes(java.lang.String quotedName)
static java.lang.String
unExpandDoubleQuotes(java.lang.String name)
inverse of expandDoubleQuotesstatic void
writeVerboseOutput(java.lang.String key, java.lang.String value)
-
-
-
Field Detail
-
DB2_MAX_NUMBER_OF_TABLES
private static final int DB2_MAX_NUMBER_OF_TABLES
- See Also:
- Constant Field Values
-
conn
private java.sql.Connection conn
-
getColNameFromNumberQuery
private static java.sql.PreparedStatement getColNameFromNumberQuery
-
schemaMap
private static java.util.HashMap<java.lang.String,java.lang.String> schemaMap
-
tableIdToNameMap
private static java.util.HashMap<java.lang.String,java.lang.String> tableIdToNameMap
-
sourceDBUrl
private static java.lang.String sourceDBUrl
-
ddlFileName
private static java.lang.String ddlFileName
-
stmtDelimiter
private static java.lang.String stmtDelimiter
-
appendLogs
private static boolean appendLogs
-
tableList
private static java.util.ArrayList<java.lang.String> tableList
-
schemaParam
private static java.lang.String schemaParam
-
targetSchema
private static java.lang.String targetSchema
-
skipViews
private static boolean skipViews
-
verbose
private static boolean verbose
-
sourceDBName
private static java.lang.String sourceDBName
-
lookLogName
private static java.lang.String lookLogName
-
langUtil
private static LocalizedResource langUtil
-
sqlAuthorization
private static boolean sqlAuthorization
-
ignorableSchemaNames
private static final java.lang.String[] ignorableSchemaNames
-
-
Method Detail
-
main
public static void main(java.lang.String[] args)
-
initState
private void initState()
-
parseArgs
private boolean parseArgs(java.lang.String[] args)
-
loadParam
private int loadParam(java.lang.String[] args, int start)
-
loadDriver
private boolean loadDriver()
-
extractDBNameFromUrl
private java.lang.String extractDBNameFromUrl(java.lang.String dbUrl)
-
extractTableNamesFromList
private int extractTableNamesFromList(java.lang.String[] args, int start)
-
showVariables
private void showVariables()
-
go
private void go() throws java.lang.Exception
- Throws:
java.lang.Exception
-
prepForDump
private void prepForDump() throws java.lang.Exception
- Throws:
java.lang.Exception
-
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)
-
addSingleQuotes
public static java.lang.String addSingleQuotes(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)
-
partOfWord
private static boolean partOfWord(java.lang.String str, int pos, int nameLen, int strLen)
-
expandDoubleQuotes
public static java.lang.String expandDoubleQuotes(java.lang.String name)
-
unExpandDoubleQuotes
public static java.lang.String unExpandDoubleQuotes(java.lang.String name)
inverse of expandDoubleQuotes
-
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)
-
atVersion
private static boolean atVersion(java.sql.Connection conn, int major, int minor) throws java.sql.SQLException
Return true if we are at 10.6 or later.- Throws:
java.sql.SQLException
-
-