Modifier and Type	Class and Description
pack-priv static class	Main.TableFormat Helper to produce table-formatted output of a JDBC resultset.

Field Summary

Modifier and Type	Field and Description
private static boolean	batchMode
private final Connection	conn
private boolean	connected
private static final String	EXPORT_PROMPT
private static final String	EXPORT_USAGE
private final BufferedReader	input
private String	lastSqlQuery

Constructor Summary

Access	Constructor and Description
public	Main(Connection conn, BufferedReader input)

Method Summary

Modifier and Type	Method and Description
public void	consoleDump(ResultSet resultSet, PrintStream printStream) Prints the ResultSet `resultSet` in a format suitable for the terminal console given by `printStream`.
private void	executeExport(String cmd) Parse the `cmd` to handle command line flags of the form: "export [-d delimiter] [-t table] pathToCsv".
private void	executeStatement(String sql)
private void	exportCsvAndSchema(CharSequence sqlQuery, String csvFileName, String schemaFileName, Exporter exporter) Runs the given`sqlQuery` and exports the CSV to `csvFileName`.
private static boolean	hasPassword(File f)
public static void	main(String[] args)
private void	printExportHelp()
private void	prompt()
private void	prompt(String content)
private String	readInput()
private void	sayHello(String version)
public static void	setBatchMode(boolean batchMode)
private void	start(String[] commands)
pack-priv static List<String>	tokenize(String s)

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

Field Detail

batchMode	back to summary
private static boolean batchMode

conn	back to summary
private final Connection conn

connected	back to summary
private boolean connected

EXPORT_PROMPT	back to summary
private static final String EXPORT_PROMPT

EXPORT_USAGE	back to summary
private static final String EXPORT_USAGE

input	back to summary
private final BufferedReader input

lastSqlQuery	back to summary
private String lastSqlQuery

Constructor Detail

Main	back to summary
public Main(Connection conn, BufferedReader input)

Method Detail

consoleDump	back to summary
public void consoleDump(ResultSet resultSet, PrintStream printStream) throws SQLException Prints the ResultSet `resultSet` in a format suitable for the terminal console given by `printStream`.

executeExport back to summary

executeExport	back to summary
private void executeExport(String cmd) throws SQLException, IOException Parse the `cmd` to handle command line flags of the form: "export [-d delimiter] [-t table] pathToCsv". For example: export -d , -t License License.csv The `-d ,` option changes the delimiter character to a comma instead of the default semicolon. The `-t License` option dumps the `License` table using the SQL statement "SELECT * FROM [License]".

private void executeExport(String cmd) throws SQLException, IOException

Parse the cmd to handle command line flags of the form: "export [-d delimiter] [-t table] pathToCsv". For example:

export -d , -t License License.csv

The -d , option changes the delimiter character to a comma instead of the default semicolon. The -t License option dumps the License table using the SQL statement "SELECT * FROM [License]".

executeStatement	back to summary
private void executeStatement(String sql) throws SQLException

exportCsvAndSchema	back to summary
private void exportCsvAndSchema(CharSequence sqlQuery, String csvFileName, String schemaFileName, Exporter exporter) throws SQLException, IOException Runs the given`sqlQuery` and exports the CSV to `csvFileName`. and the BigQuery schema to `schemaFileName` (if given). Uses the given `exporter` to perform the actual CSV and schema export operations.

hasPassword	back to summary
private static boolean hasPassword(File f) throws IOException

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

printExportHelp	back to summary
private void printExportHelp()

prompt	back to summary
private void prompt()

prompt	back to summary
private void prompt(String content)

readInput	back to summary
private String readInput()

sayHello	back to summary
private void sayHello(String version)

setBatchMode	back to summary
public static void setBatchMode(boolean batchMode)

start	back to summary
private void start(String[] commands)

tokenize	back to summary
pack-priv static List<String> tokenize(String s) throws IOException

net.ucanaccess.console back to summary

pack-priv Class Main.TableFormat

Class Inheritance

extends Object

java.lang.Object
net.ucanaccess.console.Main.TableFormat

Helper to produce table-formatted output of a JDBC resultset.

Author: Markus Spann

Field Summary

Modifier and Type	Field and Description
private final List<String>	colNames
private final List<Integer>	colTypes
private final List<Integer>	colWidths
private static final int	MAX_COL_WIDTH
pack-priv static final List<Integer>	NUMERIC_JDBC_TYPES
private final List<List<String>>	records

Constructor Summary

Access	Constructor and Description
pack-priv	TableFormat(ResultSet resultSet)
pack-priv	TableFormat(ResultSet resultSet, int maxRows)

Method Summary

Modifier and Type	Method and Description
pack-priv static boolean	isNumericJdbcType(int type)
pack-priv String	joinWithLen(CharSequence delim, List<String> elems)
pack-priv static String	leftPad(String str, int width)
pack-priv void	output(PrintStream printStream)
pack-priv static String	repeat(String str, int count)
pack-priv static String	rightPad(String str, int width)

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

Field Detail

colNames	back to summary
private final List<String> colNames

colTypes	back to summary
private final List<Integer> colTypes

colWidths	back to summary
private final List<Integer> colWidths

MAX_COL_WIDTH	back to summary
private static final int MAX_COL_WIDTH

NUMERIC_JDBC_TYPES	back to summary
pack-priv static final List<Integer> NUMERIC_JDBC_TYPES

records	back to summary
private final List<List<String>> records

Constructor Detail

TableFormat	back to summary
pack-priv TableFormat(ResultSet resultSet) throws SQLException

TableFormat	back to summary
pack-priv TableFormat(ResultSet resultSet, int maxRows) throws SQLException

Method Detail

isNumericJdbcType	back to summary
pack-priv static boolean isNumericJdbcType(int type)

joinWithLen	back to summary
pack-priv String joinWithLen(CharSequence delim, List<String> elems)

leftPad	back to summary
pack-priv static String leftPad(String str, int width)

output	back to summary
pack-priv void output(PrintStream printStream)

repeat	back to summary
pack-priv static String repeat(String str, int count)

rightPad	back to summary
pack-priv static String rightPad(String str, int width)

public Class Main

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

pack-priv Class Main.TableFormat

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail