Apache Derby Tools 10.17.1.0 · org.apache.derby.tools.dblook

Field Summary

Modifier and Type	Field and 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

Access	Constructor and Description
public	dblook(String[] args)

Method Summary

Modifier and Type	Method and Description
public static String	addQuotes(String name)
public 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.
public static String	expandDoubleQuotes(String name)
private String	extractDBNameFromUrl(String dbUrl)
private int	extractTableNamesFromList(String[] args, int start)
public static String	getColNameFromNumber(String tableId, int colNum)
public static String	getColumnListFromDescription(String tableId, String description)
private void	go()
private void	initState()
public static boolean	isExcludedTable(String tableName)
public static boolean	isIgnorableSchema(String schemaName)
private boolean	loadDriver()
private int	loadParam(String[] args, int start)
public static String	lookupMessage(String key)
public static String	lookupMessage(String key, String[] vals)
public static String	lookupSchemaId(String schemaId)
public static String	lookupTableId(String tableId)
public 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()
public static String	removeNewlines(String str)
private void	showVariables()
public static boolean	stringContainsTargetTable(String str)
public static String	stripQuotes(String quotedName)
public static String	unExpandDoubleQuotes(String name) inverse of expandDoubleQuotes
public static void	writeVerboseOutput(String key, String value)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

appendLogs	back to summary
private static boolean appendLogs

conn	back to summary
private Connection conn

DB2_MAX_NUMBER_OF_TABLES	back to summary
private static final int DB2_MAX_NUMBER_OF_TABLES

ddlFileName	back to summary
private static String ddlFileName

getColNameFromNumberQuery	back to summary
private static PreparedStatement getColNameFromNumberQuery

ignorableSchemaNames	back to summary
private static final String[] ignorableSchemaNames

langUtil	back to summary
private static LocalizedResource langUtil

lookLogName	back to summary
private static String lookLogName

schemaMap	back to summary
private static HashMap<String, String> schemaMap

schemaParam	back to summary
private static String schemaParam

skipViews	back to summary
private static boolean skipViews

sourceDBName	back to summary
private static String sourceDBName

sourceDBUrl	back to summary
private static String sourceDBUrl

sqlAuthorization	back to summary
private static boolean sqlAuthorization

stmtDelimiter	back to summary
private static String stmtDelimiter

tableIdToNameMap	back to summary
private static HashMap<String, String> tableIdToNameMap

tableList	back to summary
private static ArrayList<String> tableList

targetSchema	back to summary
private static String targetSchema

verbose	back to summary
private static boolean verbose

Constructor Detail

dblook	back to summary
public dblook(String[] args) throws Exception

Method Detail

addQuotes	back to summary
public static String addQuotes(String name)

addSingleQuotes	back to summary
public static String addSingleQuotes(String name)

atVersion	back to summary
private static boolean atVersion(Connection conn, int major, int minor) throws SQLException Return true if we are at 10.6 or later.

expandDoubleQuotes	back to summary
public static String expandDoubleQuotes(String name)

extractDBNameFromUrl	back to summary
private String extractDBNameFromUrl(String dbUrl)

extractTableNamesFromList	back to summary
private int extractTableNamesFromList(String[] args, int start)

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

getColumnListFromDescription	back to summary
public static String getColumnListFromDescription(String tableId, String description) throws SQLException

go	back to summary
private void go() throws Exception

initState	back to summary
private void initState()

isExcludedTable	back to summary
public static boolean isExcludedTable(String tableName)

isIgnorableSchema	back to summary
public static boolean isIgnorableSchema(String schemaName)

loadDriver	back to summary
private boolean loadDriver()

loadParam	back to summary
private int loadParam(String[] args, int start)

lookupMessage	back to summary
public static String lookupMessage(String key)

lookupMessage	back to summary
public static String lookupMessage(String key, String[] vals)

lookupSchemaId	back to summary
public static String lookupSchemaId(String schemaId)

lookupTableId	back to summary
public static String lookupTableId(String tableId)

main	back to summary
public static void main(String[] args)

parseArgs	back to summary
private boolean parseArgs(String[] args)

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

prepForDump	back to summary
private void prepForDump() throws Exception

removeNewlines	back to summary
public static String removeNewlines(String str)

showVariables	back to summary
private void showVariables()

stringContainsTargetTable	back to summary
public static boolean stringContainsTargetTable(String str)

stripQuotes	back to summary
public static String stripQuotes(String quotedName)

unExpandDoubleQuotes	back to summary
public static String unExpandDoubleQuotes(String name) inverse of expandDoubleQuotes

writeVerboseOutput	back to summary
public static void writeVerboseOutput(String key, String value)

public final Class dblook

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail