Package org.h2.tools

Class ConvertTraceFile


  • public class ConvertTraceFile
    extends Tool
    Converts a .trace.db file to a SQL script and Java source code. SQL statement statistics are listed as well.
    • Field Detail

      • timeTotal

        private long timeTotal
    • Constructor Detail

      • ConvertTraceFile

        public ConvertTraceFile()
    • Method Detail

      • main

        public static void main​(java.lang.String... args)
                         throws java.sql.SQLException
        Options are case sensitive.
        Supported options
        [-help] or [-?] Print the list of options
        [-traceFile <file>] The trace file name (default: test.trace.db)
        [-script <file>] The script file name (default: test.sql)
        [-javaClass <file>] The Java directory and class file name (default: Test)
        Parameters:
        args - the command line arguments
        Throws:
        java.sql.SQLException - on failure
      • runTool

        public void runTool​(java.lang.String... args)
                     throws java.sql.SQLException
        Description copied from class: Tool
        Run the tool with the given output stream and arguments.
        Specified by:
        runTool in class Tool
        Parameters:
        args - the argument list
        Throws:
        java.sql.SQLException - on failure
      • convertFile

        private void convertFile​(java.lang.String traceFileName,
                                 java.lang.String javaClassName,
                                 java.lang.String script)
                          throws java.io.IOException
        Converts a trace file to a Java class file and a script file.
        Throws:
        java.io.IOException
      • removeNewlines

        private static java.lang.String removeNewlines​(java.lang.String s)
      • padNumberLeft

        private static java.lang.String padNumberLeft​(long number,
                                                      int digits)
      • addToStats

        private void addToStats​(java.lang.String sql,
                                int resultCount,
                                long time)