Package org.apache.derby.tools

Class dblook

  • public final class dblook
extends java.lang.Object

    • 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

      • sqlAuthorization

        private static boolean sqlAuthorization

      • ignorableSchemaNames

        private static final java.lang.String[] ignorableSchemaNames

    • Constructor Detail

      • dblook

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

    • 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