Package com.randomnoun.common.db

Class DatabaseReader

java.lang.Object

com.randomnoun.common.db.DatabaseReader

Direct Known Subclasses:

MysqlDatabaseReader

public abstract class DatabaseReader
extends Object

Container class for database metadata.

Rewrite of DatabaseTO to be marginally more structured

Contains methods for populating metadata from the data dictionaries of Oracle and MySQL, for the purposes of whatever it is that I'm doing at the time. NB: does not set default values for oracle

Field Summary

Fields

Modifier and Type	Field	Description
protected DatabaseTO	db
DataSource	ds
org.springframework.jdbc.core.JdbcTemplate	jt

Constructor Summary

Constructors

Constructor	Description
DatabaseReader(DataSource dataSource)	Database metadata container.

Method Summary

Modifier and Type	Method	Description
TableColumnTO	getColumn(DatabaseTO db, String identifier)
SchemaTO	getSchema(String schemaName)
abstract SchemaTO	readSchema(String schemaName)

Methods inherited from class java.lang.Object

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

Field Details

db

protected DatabaseTO db

ds

public DataSource ds

jt

public org.springframework.jdbc.core.JdbcTemplate jt

Constructor Details

DatabaseReader

public DatabaseReader(DataSource dataSource)

Database metadata container. Will load reference data on demand

Method Details

getSchema

public SchemaTO getSchema(String schemaName)

readSchema

public abstract SchemaTO readSchema(String schemaName)

getColumn

public TableColumnTO getColumn(DatabaseTO db,
 String identifier)