net.sf.jailer.modelbuilder

Class JDBCMetaDataBasedModelElementFinder

java.lang.Object

net.sf.jailer.modelbuilder.JDBCMetaDataBasedModelElementFinder

All Implemented Interfaces:

ModelElementFinder

public class JDBCMetaDataBasedModelElementFinder
extends Object
implements ModelElementFinder

Finds associations and tables by analyzing the JDBC meta data.

Author:

Ralf Wisser

Constructor Summary

Constructors

Constructor and Description
JDBCMetaDataBasedModelElementFinder()

Method Summary

Methods

Modifier and Type	Method and Description
Collection<Association>	findAssociations(DataModel dataModel, Map<Association,String[]> namingSuggestion, Session session, ExecutionContext executionContext) Finds associations by reading the databases meta-data.
List<Column>	findColumns(Table table, Session session, ExecutionContext executionContext) Finds the Columns of a given Table.
Set<Table>	findTables(Session session, ExecutionContext executionContext) Finds all tables in DB schema.
static ResultSet	getColumns(Session session, DatabaseMetaData metaData, String schemaPattern, String tableNamePattern, String columnNamePattern) Calls DatabaseMetaData.getColumns(String, String, String, String).
static String	getDefaultSchema(Session session, String userName) Gets default schema of DB.
static List<String>	getSchemas(Session session, String userName) Finds all non-empty schemas in DB.
String	toString() Gets description.

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCMetaDataBasedModelElementFinder

public JDBCMetaDataBasedModelElementFinder()

Method Detail

findAssociations

public Collection<Association> findAssociations(DataModel dataModel,
                                       Map<Association,String[]> namingSuggestion,
                                       Session session,
                                       ExecutionContext executionContext)
                                         throws Exception

Finds associations by reading the databases meta-data.

Specified by:

findAssociations in interface ModelElementFinder

Parameters:

session - the statement executor for executing SQL-statements

dataModel - model containing already known elements

namingSuggestion - to put naming suggestions for associations into

Returns:

found associations

Throws:

Exception - on each error

findTables

public Set<Table> findTables(Session session,
                    ExecutionContext executionContext)
                      throws Exception

Finds all tables in DB schema.

Specified by:

findTables in interface ModelElementFinder

Parameters:

session - the statement executor for executing SQL-statements

Returns:

a set of Tables

Throws:

Exception - on each error

getColumns

public static ResultSet getColumns(Session session,
                   DatabaseMetaData metaData,
                   String schemaPattern,
                   String tableNamePattern,
                   String columnNamePattern)
                            throws SQLException

Calls DatabaseMetaData.getColumns(String, String, String, String). Uses schemaPattern as catalogPattern on MySQL.

Throws:

SQLException

getSchemas

public static List<String> getSchemas(Session session,
                      String userName)

Finds all non-empty schemas in DB.

Parameters:

session - the statement executor for executing SQL-statements

userName - schema with this name may be empty

getDefaultSchema

public static String getDefaultSchema(Session session,
                      String userName)

Gets default schema of DB.

Parameters:

session - the statement executor for executing SQL-statements

userName - schema with this name may be empty

findColumns

public List<Column> findColumns(Table table,
                       Session session,
                       ExecutionContext executionContext)
                         throws Exception

Finds the Columns of a given Table.

Specified by:

findColumns in interface ModelElementFinder

Parameters:

table - the table

session - the statement executor for executing SQL-statements

Throws:

Exception - on each error

toString

public String toString()

Gets description.

Overrides:

toString in class Object