Class ConvertTraceFile

java.lang.Object

org.h2.util.Tool

org.h2.tools.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.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
(package private) static class	ConvertTraceFile.Stat	This class holds statistics about a SQL statement.

Field Summary

Fields

Modifier and Type	Field	Description
private final HashMap<String, ConvertTraceFile.Stat>	stats
private long	timeTotal

Fields inherited from class Tool

out

Constructor Summary

Constructors

Constructor	Description
ConvertTraceFile()

Method Summary

Modifier and Type	Method	Description
private void	addToStats(String sql, int resultCount, long time)
private void	convertFile(String traceFileName, String javaClassName, String script)	Converts a trace file to a Java class file and a script file.
static void	main(String... args)	Options are case sensitive.
private static String	padNumberLeft(long number, int digits)
private static String	removeNewlines(String s)
void	runTool(String... args)	Run the tool with the given output stream and arguments.

Methods inherited from class Tool

isOption, printNoDatabaseFilesFound, setOut, showUsage, showUsageAndThrowUnsupportedOption, throwUnsupportedOption

Methods inherited from class Object

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

Field Details

stats

private final HashMap<String, ConvertTraceFile.Stat> stats

timeTotal

private long timeTotal

Constructor Details

ConvertTraceFile

public ConvertTraceFile()

Method Details

main

public static void main(String... args)
                 throws 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:

SQLException - on failure

runTool

public void runTool(String... args)
             throws 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:

SQLException - on failure

convertFile

private void convertFile(String traceFileName,
 String javaClassName,
 String script)
                  throws IOException

Converts a trace file to a Java class file and a script file.

Throws:

IOException

removeNewlines

private static String removeNewlines(String s)

padNumberLeft

private static String padNumberLeft(long number,
 int digits)

addToStats

private void addToStats(String sql,
 int resultCount,
 long time)