Package lu.kbra.pclib.db.utils

Class DatabaseScanner

java.lang.Object

lu.kbra.pclib.db.utils.DatabaseScanner

All Implemented Interfaces:

TreeStringConvertible, MapConvertible

public class DatabaseScanner
extends Object
implements TreeStringConvertible

Constructor Summary

Constructors

Constructor	Description
DatabaseScanner(Database database)
DatabaseScanner(Database database, Map<String,Object> hints)

Method Summary

Modifier and Type	Method	Description
ViewColumnStructure	buildColumn(SQLQueryable<?> parent, SQLQueryable<?> table, Map<String,Object> columnMap)
ViewOrderStructure	buildOrderBy(SQLQueryable<?> self, Map<String,Object> orderBy)
ViewTableStructure	buildTable(SQLQueryable<?> parent, Map<String,Object> tableMap)
ViewCommonTableExpressionStructure	buildWith(SQLQueryable<?> parent, Map<String,Object> viewWithTable)
ColumnData[]	computeColumnsFor(SQLQueryable<?> table, SQLQueryableStructure tableStructure, Class<? extends DatabaseEntry> entryClazz)
String	computeDefaultValue(SQLQueryable<?> table, ColumnData columnData)
String	computeExpression(SQLQueryable<?> table, Optional<ColumnData> columnData, String input)
void	doScan()
protected Field	findField(Class<?> type, String name)
protected Field[]	getAllFields(Class<?> type)
<T extends DatabaseEntry> Class<T>	getEntryType(Class<? extends SQLQueryable<?>> tableClass)
<T extends DatabaseEntry> Field	getFieldFor(Class<T> entryClazz, String sqlName)
List<ForeignKeyData>	getForeignKeys(SQLQueryableStructure structure)
SQLQueryable<?>	getInstanceFor(Class<? extends SQLQueryable<?>> foreignQueryable, String refTableName)
SQLQueryable<?>	getInstanceFor(Class<? extends SQLQueryable<?>> foreignQueryable, String refTableName, boolean includeSyn)
String	getReferencedColumnName(SQLQueryable<?> table, ColumnData columnData, SQLQueryableStructure foreignStructure)
SQLQueryableStructure	getStructureFor(Class<? extends SQLQueryable<?>> foreignQueryable, String refTableName)
SQLQueryableStructure	getStructureFor(Class<? extends SQLQueryable<?>> foreignQueryable, String refTableName, boolean includeSyn)
<B extends SQLQueryable<T>, T extends DatabaseEntry> DatabaseScanner	register(B instance)
<B extends SQLQueryable<T>, T extends DatabaseEntry> DatabaseScanner	register(B instance, Map<String,Object> queryableHints, Map<String,Object> entryHints)
void	registerSimpleNames(Class<? extends SQLQueryable<?>> tableClazz, Map<String,Object> queryableHints, SQLQueryableStructure tableStructure)
void	resolveMissingJoinConditions(List<ViewTableStructure> tables)
TableStructure	scanSelfTableStructure(AbstractDBTable<?> instance, Map<String,Object> customHints, Class<? extends AbstractDBTable<?>> tableClazz, Map<String,Object> customEntryHints)
ViewStructure	scanSelfViewStructure(AbstractDBView<? extends DatabaseEntry> instance, Map<String,Object> customHints, Class<? extends AbstractDBView<? extends DatabaseEntry>> viewClazz, Map<String,Object> customEntryHints)
<T extends DatabaseEntry> void	scanTableLinks(SQLQueryable<T> instance)
void	scanViewLinks(AbstractDBView<? extends DatabaseEntry> instance)
List<Field>	sortFields(Field[] fields)
Map<String,Object>	toMap()
String	toString()

Methods inherited from class java.lang.Object

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

Methods inherited from interface lu.kbra.pclib.db.domain.table.TreeStringConvertible

toTreeString

Constructor Details

DatabaseScanner

public DatabaseScanner(Database database)

DatabaseScanner

public DatabaseScanner(Database database,
 Map<String,Object> hints)

Method Details

register

public <B extends SQLQueryable<T>,
T extends DatabaseEntry>
DatabaseScanner register(B instance)

register

public <B extends SQLQueryable<T>,
T extends DatabaseEntry>
DatabaseScanner register(B instance,
 Map<String,Object> queryableHints,
 Map<String,Object> entryHints)

doScan

public void doScan()

resolveMissingJoinConditions

public void resolveMissingJoinConditions(List<ViewTableStructure> tables)

getForeignKeys

public List<ForeignKeyData> getForeignKeys(SQLQueryableStructure structure)

scanTableLinks

public <T extends DatabaseEntry> void scanTableLinks(SQLQueryable<T> instance)

getStructureFor

public SQLQueryableStructure getStructureFor(Class<? extends SQLQueryable<?>> foreignQueryable,
 String refTableName)

getStructureFor

public SQLQueryableStructure getStructureFor(Class<? extends SQLQueryable<?>> foreignQueryable,
 String refTableName,
 boolean includeSyn)

getInstanceFor

public SQLQueryable<?> getInstanceFor(Class<? extends SQLQueryable<?>> foreignQueryable,
 String refTableName)

getInstanceFor

public SQLQueryable<?> getInstanceFor(Class<? extends SQLQueryable<?>> foreignQueryable,
 String refTableName,
 boolean includeSyn)

getReferencedColumnName

public String getReferencedColumnName(SQLQueryable<?> table,
 ColumnData columnData,
 SQLQueryableStructure foreignStructure)

scanSelfTableStructure

public TableStructure scanSelfTableStructure(AbstractDBTable<?> instance,
 Map<String,Object> customHints,
 Class<? extends AbstractDBTable<?>> tableClazz,
 Map<String,Object> customEntryHints)

registerSimpleNames

public void registerSimpleNames(Class<? extends SQLQueryable<?>> tableClazz,
 Map<String,Object> queryableHints,
 SQLQueryableStructure tableStructure)

scanSelfViewStructure

public ViewStructure scanSelfViewStructure(AbstractDBView<? extends DatabaseEntry> instance,
 Map<String,Object> customHints,
 Class<? extends AbstractDBView<? extends DatabaseEntry>> viewClazz,
 Map<String,Object> customEntryHints)

scanViewLinks

public void scanViewLinks(AbstractDBView<? extends DatabaseEntry> instance)

buildWith

public ViewCommonTableExpressionStructure buildWith(SQLQueryable<?> parent,
 Map<String,Object> viewWithTable)

buildOrderBy

public ViewOrderStructure buildOrderBy(SQLQueryable<?> self,
 Map<String,Object> orderBy)

buildColumn

public ViewColumnStructure buildColumn(SQLQueryable<?> parent,
 SQLQueryable<?> table,
 Map<String,Object> columnMap)

buildTable

public ViewTableStructure buildTable(SQLQueryable<?> parent,
 Map<String,Object> tableMap)

computeColumnsFor

public ColumnData[] computeColumnsFor(SQLQueryable<?> table,
 SQLQueryableStructure tableStructure,
 Class<? extends DatabaseEntry> entryClazz)

computeDefaultValue

public String computeDefaultValue(SQLQueryable<?> table,
 ColumnData columnData)

computeExpression

public String computeExpression(SQLQueryable<?> table,
 Optional<ColumnData> columnData,
 String input)

getFieldFor

public <T extends DatabaseEntry> Field getFieldFor(Class<T> entryClazz,
 String sqlName)

findField

protected Field findField(Class<?> type,
 String name)
                   throws NoSuchFieldException

Throws:

NoSuchFieldException

getAllFields

protected Field[] getAllFields(Class<?> type)

sortFields

public List<Field> sortFields(Field[] fields)

getEntryType

public <T extends DatabaseEntry> Class<T> getEntryType(Class<? extends SQLQueryable<?>> tableClass)

toString

public String toString()

Overrides:

toString in class Object

toMap

public Map<String,Object> toMap()

Specified by:

toMap in interface MapConvertible