A B C D E F G H I J L M N O P R S T V W

A

AbstractPreparedSqlStatement - Class in de.dbload.jdbc

Create and hold a PreparedStatement.

AbstractPreparedSqlStatement(DbloadContext, TableMetaData, PreparedStatement) - Constructor for class de.dbload.jdbc.AbstractPreparedSqlStatement

Constructor.

addColumn(ColumnMetaData) - Method in class de.dbload.meta.ColumnsMetaData

applyParams(DataRow) - Method in class de.dbload.jdbc.AbstractPreparedSqlStatement

applyParams(DataRow, TableMetaData, JdbcTypeConverter, PreparedStatement) - Static method in class de.dbload.jdbc.PreparedStatementBuilder

Apply some data to the parameters of a JDBC prepared statement.

asMap() - Method in class de.dbload.meta.DataRow

assertExists(DbloadContext, TableMetaData, DataRow) - Static method in class de.dbload.assertion.Assertion

assertExists(DbloadContext, TableMetaData, List<DataRow>) - Static method in class de.dbload.assertion.Assertion

assertExists(DbloadContext, Class<?>) - Static method in class de.dbload.assertion.Assertion

Assertion - Class in de.dbload.assertion

Some assertions...

B

BIT - de.dbload.meta.ColumnMetaData.Type

Bit information.

C

close() - Method in class de.dbload.csv.reader.ResourceDataReader

Close all resources.

close() - Method in class de.dbload.impl.DbloadFileInsert

Close this resource.

close() - Method in class de.dbload.impl.DbloadSqlInsert

close() - Method in class de.dbload.impl.DbloadSqlSelect

close() - Method in class de.dbload.jdbc.AbstractPreparedSqlStatement

Close the statement.

close(Statement) - Static method in class de.dbload.jdbc.JdbcUtils

column(String, ColumnMetaData.Type) - Method in class de.dbload.meta.ColumnsMetaData

COLUMN_DEFINITION - de.dbload.csv.reader.ResourceParser.ParserState

ColumnMetaData - Class in de.dbload.meta

Holds the name and type of a database column.

ColumnMetaData(String, ColumnMetaData.Type) - Constructor for class de.dbload.meta.ColumnMetaData

Constructor

ColumnMetaData.Type - Enum in de.dbload.meta

ColumnsMetaData - Class in de.dbload.meta

Holds the meta data of all columns of a table.

ColumnsMetaData() - Constructor for class de.dbload.meta.ColumnsMetaData

ColumnTypeParser - Class in de.dbload.csv.reader

Find the type of a column.

ColumnTypeParser() - Constructor for class de.dbload.csv.reader.ColumnTypeParser

COMMENT_OR_EMPTY - de.dbload.csv.reader.ResourceParser.ParserState

containsBit(String) - Static method in class de.dbload.csv.reader.ColumnTypeParser

containsDate(String) - Static method in class de.dbload.csv.reader.ColumnTypeParser

convert(ColumnMetaData, String) - Method in class de.dbload.jdbc.DefaultJdbcTypeConverter

convert(ColumnMetaData, String) - Method in interface de.dbload.JdbcTypeConverter

Convert a String value to the associated column type.

createConnection(String) - Static method in class de.dbload.jdbc.connector.JdbcConnector

Creates a JDBC connection.

createConnection(String, String, String) - Static method in class de.dbload.jdbc.connector.JdbcConnector

Creates a JDBC connection.

createDecimalFormatter(Locale) - Static method in class de.dbload.misc.NumberUtils

createSql() - Method in class de.dbload.jdbc.SqlInsertStatementBuilder

Creates an INSERT SQL string like

createSql() - Method in class de.dbload.jdbc.SqlSelectStatementBuilder

Create an SELECT SQL string like

createSql() - Method in interface de.dbload.jdbc.SqlStatementBuilder

Creates a SQL statement.

D

DATA_DEFINITION - de.dbload.csv.reader.ResourceParser.ParserState

DatabasePropertyReader - Class in de.dbload.jdbc.connector

Reads the database properties.

DatabasePropertyReader() - Constructor for class de.dbload.jdbc.connector.DatabasePropertyReader

DataRow - Class in de.dbload.meta

A row of data or a container for key/values.

DataRow() - Constructor for class de.dbload.meta.DataRow

DataRowMatchers - Class in de.dbload.assertion

A hamcrest matcher for DataRow.

DATE - de.dbload.meta.ColumnMetaData.Type

date (date without time)

DATE_FORMAT - Static variable in class de.dbload.misc.DateTimeUtils

Konvertierungsformat Oracle-Date-Type to String.

DATE_TIME - de.dbload.meta.ColumnMetaData.Type

date and time

DateTimeUtils - Class in de.dbload.misc

A utility to create date objects.

DateTimeUtils() - Constructor for class de.dbload.misc.DateTimeUtils

Dbload - Class in de.dbload

Entry point for uploading data to the database.

DbloadContext - Interface in de.dbload

Defines JDBC connection and JDBC type converter.

DbloadException - Exception in de.dbload.impl

RuntimeException for some DBLoad problems.

DbloadException() - Constructor for exception de.dbload.impl.DbloadException

DbloadException(Exception) - Constructor for exception de.dbload.impl.DbloadException

DbloadException(String) - Constructor for exception de.dbload.impl.DbloadException

DbloadException(String, Exception) - Constructor for exception de.dbload.impl.DbloadException

DbloadFileInsert - Class in de.dbload.impl

Writes the insert sql script to the file system.

DbloadFileInsert(File, Class<?>) - Constructor for class de.dbload.impl.DbloadFileInsert

Constructor

DbloadFileInsert(File, String) - Constructor for class de.dbload.impl.DbloadFileInsert

Constructor

DbloadSqlInsert - Class in de.dbload.impl

Writes the insert sql script to the database.

DbloadSqlInsert(DbloadContext) - Constructor for class de.dbload.impl.DbloadSqlInsert

Constructor.

DbloadSqlSelect - Class in de.dbload.impl

Executes the sql select script to the database.

DbloadSqlSelect(DbloadContext) - Constructor for class de.dbload.impl.DbloadSqlSelect

Constructor.

de.dbload - package de.dbload

de.dbload.assertion - package de.dbload.assertion

de.dbload.csv.reader - package de.dbload.csv.reader

de.dbload.csv.writer - package de.dbload.csv.writer

de.dbload.impl - package de.dbload.impl

de.dbload.jdbc - package de.dbload.jdbc

de.dbload.jdbc.connector - package de.dbload.jdbc.connector

de.dbload.meta - package de.dbload.meta

de.dbload.misc - package de.dbload.misc

DECIMAL - de.dbload.meta.ColumnMetaData.Type

number with decimals like float, double or BigDecimal

DEFAULT_DECIMAL_FORMAT - Static variable in class de.dbload.misc.NumberUtils

The default format.

DEFAULT_ZERO_FORMAT - Static variable in class de.dbload.misc.NumberUtils

The default format.

DefaultDbloadContext - Class in de.dbload.impl

Holds the database connection.

DefaultDbloadContext(Connection) - Constructor for class de.dbload.impl.DefaultDbloadContext

Constructor.

DefaultDbloadContext(Connection, JdbcTypeConverter) - Constructor for class de.dbload.impl.DefaultDbloadContext

Constructor.

DefaultDbloadImpl - Class in de.dbload.impl

The worker!

DefaultDbloadImpl() - Constructor for class de.dbload.impl.DefaultDbloadImpl

DefaultJdbcTypeConverter - Class in de.dbload.jdbc

Convert a Java type to the associated JDBC type.

DefaultJdbcTypeConverter() - Constructor for class de.dbload.jdbc.DefaultJdbcTypeConverter

Creates a type converter with the default locale.

DefaultJdbcTypeConverter(DecimalFormat) - Constructor for class de.dbload.jdbc.DefaultJdbcTypeConverter

Creates a type converter.

DefaultJdbcTypeConverter(Locale) - Constructor for class de.dbload.jdbc.DefaultJdbcTypeConverter

Creates a type converter with the specified locale.

delete(Connection, String) - Static method in class de.dbload.jdbc.JdbcUtils

describeTo(Description) - Method in class de.dbload.assertion.DataRowMatchers

describeTo(Description) - Method in class de.dbload.assertion.MapContentMatchers

E

endOfFile() - Method in class de.dbload.csv.reader.ResourceDataReader

Reached end of file?

equals(Object) - Method in class de.dbload.meta.DataRow

execute(DataRow) - Method in class de.dbload.impl.DbloadFileInsert

Insert a new row of data.

execute(DataRow) - Method in class de.dbload.impl.DbloadSqlInsert

execute(DataRow) - Method in class de.dbload.impl.DbloadSqlSelect

execute(DataRow) - Method in class de.dbload.jdbc.AbstractPreparedSqlStatement

Execute the SQL statement with the given parameters (data).

execute(DataRow) - Method in class de.dbload.jdbc.PreparedSqlInsertStatement

execute(DataRow) - Method in class de.dbload.jdbc.PreparedSqlSelectStatement

F

findMetaData(Connection, String) - Static method in class de.dbload.jdbc.JdbcUtils

findType(String) - Static method in class de.dbload.csv.reader.ColumnTypeParser

Find the column type.

G

get(int) - Method in class de.dbload.meta.ColumnsMetaData

get(String) - Method in class de.dbload.meta.DataRow

getColumnName() - Method in class de.dbload.meta.ColumnMetaData

Column name

getColumnNames() - Method in class de.dbload.meta.ColumnsMetaData

Collects all column names and returns them as an ArrayList.

getColumns() - Method in class de.dbload.csv.reader.ResourceParser

The column description.

getColumns() - Method in class de.dbload.meta.TableMetaData

getColumnType() - Method in class de.dbload.meta.ColumnMetaData

Column type

getConnection() - Method in interface de.dbload.DbloadContext

Returns a JDBC connection.

getConnection() - Method in class de.dbload.impl.DefaultDbloadContext

getDatabaseUrl(Properties) - Method in class de.dbload.jdbc.connector.DatabasePropertyReader

Get the database url.

getDataRow() - Method in class de.dbload.csv.reader.ResourceParser

The data for a table row.

getJavaSqlType() - Method in enum de.dbload.meta.ColumnMetaData.Type

getJdbcTypeConverter() - Method in interface de.dbload.DbloadContext

Returns a JDBC type converter

getJdbcTypeConverter() - Method in class de.dbload.impl.DefaultDbloadContext

getPreparedStatement() - Method in class de.dbload.jdbc.AbstractPreparedSqlStatement

The prepared SQL statement.

getResultRowCounter() - Method in class de.dbload.impl.DbloadSqlSelect

getResultSet() - Method in class de.dbload.jdbc.PreparedSqlSelectStatement

Returns the result set.

getSeconds() - Method in class de.dbload.misc.StopWatch

getTableName() - Method in class de.dbload.csv.reader.ResourceParser

The name of the current table.

getTableName() - Method in class de.dbload.meta.TableMetaData

getTime() - Method in class de.dbload.misc.StopWatch

H

hasAllEntries(DataRow) - Static method in class de.dbload.assertion.DataRowMatchers

Creates a DataRow matcher.

hasAllEntries(Map<T, V>) - Static method in class de.dbload.assertion.MapContentMatchers

hasEntry(T, Matcher<V>) - Static method in class de.dbload.assertion.MapContentMatchers

hasEntry(T, V) - Static method in class de.dbload.assertion.MapContentMatchers

hashCode() - Method in class de.dbload.meta.DataRow

hasKey(T) - Static method in class de.dbload.assertion.MapContentMatchers

hasResultSet() - Method in class de.dbload.jdbc.PreparedSqlSelectStatement

Returns the execution result.

I

INTEGER - de.dbload.meta.ColumnMetaData.Type

number with no decimals like byte, short, int

isExecutionResult() - Method in class de.dbload.jdbc.PreparedSqlInsertStatement

Returns the execution result.

iterator() - Method in class de.dbload.meta.ColumnsMetaData

J

JdbcConnector - Class in de.dbload.jdbc.connector

Creates a JDBC connection.

JdbcConnector() - Constructor for class de.dbload.jdbc.connector.JdbcConnector

JdbcTypeConverter - Interface in de.dbload

Type converter utility.

JdbcUtils - Class in de.dbload.jdbc

Jdbc Utilities.

JdbcUtils() - Constructor for class de.dbload.jdbc.JdbcUtils

L

LONG - de.dbload.meta.ColumnMetaData.Type

A big integer type.

M

MapContentMatchers<T,V> - Class in de.dbload.assertion

Matchers that examine the contents of a Map.

matchesSafely(DataRow) - Method in class de.dbload.assertion.DataRowMatchers

matchesSafely(Map<? super T, ? super V>) - Method in class de.dbload.assertion.MapContentMatchers

N

newDataRow(DataRow) - Method in interface de.dbload.csv.reader.ResourceReaderCallback

Inspected a new DataRow for the last finded table.

newTableMetaData(TableMetaData) - Method in interface de.dbload.csv.reader.ResourceReaderCallback

Inspected a new TableMetaData description.

newTableMetaData(TableMetaData) - Method in class de.dbload.impl.DbloadFileInsert

Set the current table name.

newTableMetaData(TableMetaData) - Method in class de.dbload.impl.DbloadSqlInsert

newTableMetaData(TableMetaData) - Method in class de.dbload.impl.DbloadSqlSelect

NumberUtils - Class in de.dbload.misc

NumberUtils() - Constructor for class de.dbload.misc.NumberUtils

O

open() - Method in class de.dbload.csv.reader.ResourceDataReader

Opens the resource.

ORACLE_DATE_FORMAT - Static variable in class de.dbload.misc.DateTimeUtils

Konvertierungsformat String to Oracle-Date-Type

P

parse(int, String) - Method in class de.dbload.csv.reader.ResourceParser

Reads the table definition

parseColumnMetaData(String) - Static method in class de.dbload.csv.reader.ColumnTypeParser

Creates column meta data from a column description.

parseColumnsMetaData(List<String>) - Static method in class de.dbload.csv.reader.ColumnTypeParser

Find name and type of a column description.

PreparedSqlInsertStatement - Class in de.dbload.jdbc

Holds a prepared INSERT statement.

PreparedSqlInsertStatement(DbloadContext, TableMetaData) - Constructor for class de.dbload.jdbc.PreparedSqlInsertStatement

PreparedSqlSelectStatement - Class in de.dbload.jdbc

Holds a prepared SELECT statement.

PreparedSqlSelectStatement(DbloadContext, TableMetaData) - Constructor for class de.dbload.jdbc.PreparedSqlSelectStatement

PreparedStatementBuilder - Class in de.dbload.jdbc

Creates a PreparedStatement by DefaultDbloadContext and TableMetaData.

PreparedStatementBuilder() - Constructor for class de.dbload.jdbc.PreparedStatementBuilder

prepareStatement(DbloadContext, SqlStatementBuilder) - Static method in class de.dbload.jdbc.PreparedStatementBuilder

Creates a PreparedStatement.

put(String, String) - Method in class de.dbload.meta.DataRow

R

read() - Method in class de.dbload.jdbc.connector.DatabasePropertyReader

Read the properties from the default file /db.properties

read(DbloadContext, Class<?>) - Static method in class de.dbload.Dbload

Start upload.

read(DbloadContext, Class<?>, String) - Static method in class de.dbload.Dbload

Start upload.

read(String) - Method in class de.dbload.jdbc.connector.DatabasePropertyReader

Read the properties.

read(Connection, File) - Static method in class de.dbload.Dbload

Read the data from a file and put it to the database.s

read(Connection, Class<?>) - Static method in class de.dbload.Dbload

Start upload

read(Connection, Class<?>, String) - Static method in class de.dbload.Dbload

Start upload

readColumnNames(String) - Method in class de.dbload.csv.reader.ResourceParser

Read the column definition

readFromClasspathResource(DbloadContext, Class<?>) - Method in class de.dbload.impl.DefaultDbloadImpl

Start upload.

readFromClasspathResource(DbloadContext, Class<?>, String) - Method in class de.dbload.impl.DefaultDbloadImpl

Start upload.

readFromFile(DbloadContext, File) - Method in class de.dbload.impl.DefaultDbloadImpl

Start upload.

readLine() - Method in class de.dbload.csv.reader.ResourceDataReader

Read one line of the resource.

readRow(List<String>, int, String) - Method in class de.dbload.csv.reader.ResourceParser

Reading a line of data.

readTableDefinition(String) - Method in class de.dbload.csv.reader.ResourceParser

Read the table definition

ResourceDataReader - Class in de.dbload.csv.reader

Reads the data resource.

ResourceDataReader(InputStream) - Constructor for class de.dbload.csv.reader.ResourceDataReader

Constructor.

ResourceParser - Class in de.dbload.csv.reader

Read a resource.

ResourceParser() - Constructor for class de.dbload.csv.reader.ResourceParser

ResourceParser.ParserState - Enum in de.dbload.csv.reader

ResourceReader - Class in de.dbload.csv.reader

Some class to do something.

ResourceReader() - Constructor for class de.dbload.csv.reader.ResourceReader

ResourceReaderCallback - Interface in de.dbload.csv.reader

Gives informations about the current parsing state.

ResourceWriter - Class in de.dbload.csv.writer

Write some SQL results to a .dat file.

ResourceWriter(File) - Constructor for class de.dbload.csv.writer.ResourceWriter

ResourceWriter(Path) - Constructor for class de.dbload.csv.writer.ResourceWriter

S

setTypedValue(PreparedStatement, int, ColumnMetaData, Object) - Method in class de.dbload.jdbc.DefaultJdbcTypeConverter

setTypedValue(PreparedStatement, int, ColumnMetaData, Object) - Method in interface de.dbload.JdbcTypeConverter

Calls the appropriate PreparedStatement#setXxx typed setter.

size() - Method in class de.dbload.meta.ColumnsMetaData

size() - Method in class de.dbload.meta.DataRow

SqlInsertStatementBuilder - Class in de.dbload.jdbc

Creates a INSERT SQL string like

SqlInsertStatementBuilder(TableMetaData) - Constructor for class de.dbload.jdbc.SqlInsertStatementBuilder

SqlSelectStatementBuilder - Class in de.dbload.jdbc

Creates a SELECT SQL string like

SqlSelectStatementBuilder(TableMetaData) - Constructor for class de.dbload.jdbc.SqlSelectStatementBuilder

Constructor.

SqlStatementBuilder - Interface in de.dbload.jdbc

Defines a method to create SQL statements.

start() - Method in class de.dbload.misc.StopWatch

start(ResourceDataReader, ResourceReaderCallback) - Method in class de.dbload.csv.reader.ResourceReader

Start file parsing.

start(Connection, String, boolean) - Method in class de.dbload.csv.writer.ResourceWriter

stop() - Method in class de.dbload.misc.StopWatch

StopWatch - Class in de.dbload.misc

A stop watch to measure some things.

StopWatch() - Constructor for class de.dbload.misc.StopWatch

T

TABLE_DEFINITION - de.dbload.csv.reader.ResourceParser.ParserState

TableMetaData - Class in de.dbload.meta

Holds the database table meta data.

TableMetaData(String, ColumnsMetaData) - Constructor for class de.dbload.meta.TableMetaData

Constructor

TIME - de.dbload.meta.ColumnMetaData.Type

time (time without date)

toDateJodaTime(Timestamp) - Static method in class de.dbload.misc.DateTimeUtils

Convert a JDBC Timestamp object to a Joda DateTime object.

toJodaDateTime(String) - Static method in class de.dbload.misc.DateTimeUtils

Creates a Joda DateTime object.

toLong(DateTime) - Static method in class de.dbload.misc.DateTimeUtils

Returns the milliseconds of DateTime.

toNumber(String) - Static method in class de.dbload.misc.NumberUtils

toNumber(String, DecimalFormat) - Static method in class de.dbload.misc.NumberUtils

toNumber(String, Locale) - Static method in class de.dbload.misc.NumberUtils

toString() - Method in class de.dbload.impl.DbloadSqlInsert

toString() - Method in class de.dbload.jdbc.AbstractPreparedSqlStatement

toString() - Method in class de.dbload.meta.ColumnMetaData

toString() - Method in class de.dbload.meta.ColumnsMetaData

toString() - Method in class de.dbload.meta.DataRow

toTableMetaData(ResultSetMetaData) - Static method in class de.dbload.jdbc.JdbcUtils

Create the dbload meta data of a ResultSetMetaData.

toTimestamp(DateTime) - Static method in class de.dbload.misc.DateTimeUtils

Returns the SQL Timestamp for a Joda DateTime object.

V

valueOf(int) - Static method in enum de.dbload.meta.ColumnMetaData.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum de.dbload.csv.reader.ResourceParser.ParserState

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum de.dbload.meta.ColumnMetaData.Type

Returns the enum constant of this type with the specified name.

values() - Static method in enum de.dbload.csv.reader.ResourceParser.ParserState

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum de.dbload.meta.ColumnMetaData.Type

Returns an array containing the constants of this enum type, in the order they are declared.

VARCHAR - de.dbload.meta.ColumnMetaData.Type

W

write(Connection, File, String[]) - Static method in class de.dbload.Dbload

Export all tables to a file.

write(Connection, File, List<String>) - Static method in class de.dbload.Dbload

Export all tables to a file.

writeToFile(DbloadContext, File, String[]) - Method in class de.dbload.impl.DefaultDbloadImpl

Export all tables to a file.

writeToFile(DbloadContext, File, List<String>) - Method in class de.dbload.impl.DefaultDbloadImpl

Export all tables to a file.

A B C D E F G H I J L M N O P R S T V W