Package com.wisecoders.dbs.schema

Class Table

java.lang.Object

com.wisecoders.dbs.diagram.model.AbstractUnit

com.wisecoders.dbs.diagram.model.AbstractTable

com.wisecoders.dbs.schema.Table

All Implemented Interfaces:

SyncPrioritizable, Entity, TreeUnit, Unit, DbUnit, Comparable<AbstractUnit>

public final class Table
extends AbstractTable
implements DbUnit

A database table.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	Table.TableType	The type of the table in database

Field Summary

Fields

Modifier and Type	Field	Description
final Folder<Column>	columns
final Folder<Constraint>	constraints
final Folder<ForeignKey>	foreignKeys
final Folder<Index>	indexes
final Schema	schema

Fields inherited from class com.wisecoders.dbs.diagram.model.AbstractTable

importedRelations, triggers

Fields inherited from interface com.wisecoders.dbs.dbms.sync.engine.nodes.SyncPrioritizable

CHANGE, COMMENT, CREATE_CLUSTERED_INDEX, CREATE_COLUMNS, CREATE_CONSTRAINT, CREATE_FOREIGN_KEY, CREATE_FUNCTIONS, CREATE_INDEX, CREATE_PLSQL, CREATE_SCHEMA, CREATE_SEQUENCES, CREATE_TABLES, CREATE_TRIGGERS, CREATE_USER_DATA_TYPES, CREATE_VIEWS, DROP, DROP_CONSTRAINT, DROP_FOREIGN_KEY, DROP_LAST, DROP_PLSQL, DROP_VIEW, FINAL, NO_PRIORITY, RENAME

Constructor Summary

Constructors

Constructor	Description
Table(Schema schema, String name)	Public constructor, uses:

Method Summary

Modifier and Type	Method	Description
boolean	columnIsPk(Column column)
Column	createColumn(String name, DataType type)
Column	createColumn(String name, DataType type, int length)
Column	createColumn(String name, DataType type, AttributeSpec spec)
Column	createColumn(String columnName, String dataTypeName)
Constraint	createConstraint(String name)
Index	createIndex(String name)
Index	createPrimaryKey(String name)
ForeignKey	createRelation(String name)
Folder<Column>	getAttributes()
TreeUnit	getChildAt(int idx)
int	getChildrenCount()
String	getDbId()
String	getDisplayName(Diagram diagram)
int	getGeneratorOrder()
int	getGeneratorRowsCount()
Index	getIndexByType(IndexType type)
Folder<Index>	getIndexes()
Index	getIndexFittingColumns(List<Column> onColumns)
String	getOptions()
TreeUnit	getParent()
Index	getPkOrUniqueIndexContaining(List<Column> attributes, boolean exactMatch)
String	getPostScript()
String	getPreScript()
Index	getPrimaryKey()
Index	getPrimaryKeyOrUniqueIndex()
Folder<ForeignKey>	getRelations()
long	getRowCount()
Schema	getSchema()
String	getSpecificationOptions()
com.wisecoders.dbs.sys.fx.glyph.Glyph	getSymbolicGlyph()
String	getSymbolicIcon()	Returns the symbolic icon to be used in the tree node.
String	getSymbolicName()	Returns the name of the node.
Folder[]	getSyncFolders()
GeneratorTable	getTableGenerator()
Table.TableType	getType()
boolean	hasFkOrRef()
boolean	hasOneColumnPk()
boolean	isView()
void	merge(Table target)
void	presetColumnOrder()
void	refresh()
void	removeDuplicateIndexes()
void	setGeneratorOrder(int generatorOrder)
void	setGeneratorRowsCount(int rows)
boolean	setOptions(String options)
boolean	setPostScript(String preScript)
boolean	setPreScript(String preScript)
void	setRowCount(long rowCount)
boolean	setSpecificationOptions(String options)
void	setType(Table.TableType type)

Methods inherited from class com.wisecoders.dbs.diagram.model.AbstractTable

getChildEntityByPath, getColumnByNameOrPath, getDefaultSyncPriority, getEntity, getImportedRelations, getNameWithSchemaName, getSyncPriority, isChildEntity, isChildEntityArray, isReferredInString, ref, setSyncPriority

Methods inherited from class com.wisecoders.dbs.diagram.model.AbstractUnit

compareTo, fixNull, getByName, getByName, getComment, getCommentNotNull, getCommentTag, getCommentTags, getDefaultKey, getKey, getName, getParentEntity, getPlainName, getPropertyAddOnFolder, getString, getTickId, getTouchId, getUnitProperty, has, is, is, isMarkedForDeletion, isVirtual, markForDeletion, matches, removeUnitProperty, rename, sameAs, sameAs, setComment, setCommentTag, setCommentTags, setTouchId, setUnitProperty, setVirtual, toString

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.wisecoders.dbs.diagram.model.Entity

getName, isVirtual, rename

Methods inherited from interface com.wisecoders.dbs.diagram.model.TreeUnit

getByName, getTickId, getTouchId, getUnitProperty, setTouchId

Methods inherited from interface com.wisecoders.dbs.diagram.model.Unit

getComment, getCommentTag, getCommentTags, getEntity, getParentEntity, is, isMarkedForDeletion, markForDeletion, ref, setComment, setCommentTag, setCommentTags

Field Details

schema

public final Schema schema

columns

public final Folder<Column> columns

foreignKeys

public final Folder<ForeignKey> foreignKeys

indexes

public final Folder<Index> indexes

constraints

public final Folder<Constraint> constraints

Constructor Details

Table

public Table(Schema schema,
 String name)

Public constructor, uses:

Parameters:

schema - it belongs to

name - is the name of the Entity

Method Details

getDisplayName

public String getDisplayName(Diagram diagram)

Specified by:

getDisplayName in interface Unit

Overrides:

getDisplayName in class AbstractUnit

getAttributes

public Folder<Column> getAttributes()

Specified by:

getAttributes in interface Entity

Specified by:

getAttributes in class AbstractTable

getSyncFolders

public Folder[] getSyncFolders()

Overrides:

getSyncFolders in class AbstractUnit

getSymbolicName

public String getSymbolicName()

Returns the name of the node.

Specified by:

getSymbolicName in interface Unit

Specified by:

getSymbolicName in class AbstractUnit

Returns:

the unit symbolic name

getSymbolicIcon

public String getSymbolicIcon()

Returns the symbolic icon to be used in the tree node.

Specified by:

getSymbolicIcon in class AbstractUnit

Returns:

the unit icon

getSymbolicGlyph

public com.wisecoders.dbs.sys.fx.glyph.Glyph getSymbolicGlyph()

Specified by:

getSymbolicGlyph in class AbstractUnit

getRelations

public Folder<ForeignKey> getRelations()

Specified by:

getRelations in interface Entity

Specified by:

getRelations in class AbstractTable

getIndexes

public Folder<Index> getIndexes()

getChildrenCount

public int getChildrenCount()

Specified by:

getChildrenCount in interface TreeUnit

Overrides:

getChildrenCount in class AbstractUnit

getChildAt

public TreeUnit getChildAt(int idx)

Specified by:

getChildAt in interface TreeUnit

Overrides:

getChildAt in class AbstractUnit

getPrimaryKey

public Index getPrimaryKey()

getIndexByType

public Index getIndexByType(IndexType type)

presetColumnOrder

public void presetColumnOrder()

getPrimaryKeyOrUniqueIndex

public Index getPrimaryKeyOrUniqueIndex()

getIndexFittingColumns

public Index getIndexFittingColumns(List<Column> onColumns)

getType

public Table.TableType getType()

setType

public void setType(Table.TableType type)

refresh

public void refresh()

Specified by:

refresh in interface Entity

Specified by:

refresh in class AbstractUnit

getParent

public TreeUnit getParent()

Specified by:

getParent in interface TreeUnit

Specified by:

getParent in class AbstractUnit

getSchema

public Schema getSchema()

Specified by:

getSchema in interface DbUnit

Specified by:

getSchema in interface Entity

Specified by:

getSchema in class AbstractTable

createColumn

public Column createColumn(String columnName,
 String dataTypeName)

createColumn

public Column createColumn(String name,
 DataType type,
 int length)

createColumn

public Column createColumn(String name,
 DataType type)

Specified by:

createColumn in class AbstractTable

createColumn

public Column createColumn(String name,
 DataType type,
 AttributeSpec spec)

createRelation

public ForeignKey createRelation(String name)

Specified by:

createRelation in class AbstractTable

createPrimaryKey

public Index createPrimaryKey(String name)

createIndex

public Index createIndex(String name)

createConstraint

public Constraint createConstraint(String name)

isView

public boolean isView()

Specified by:

isView in interface Entity

Specified by:

isView in class AbstractTable

getOptions

public String getOptions()

setOptions

public boolean setOptions(String options)

getSpecificationOptions

public String getSpecificationOptions()

setSpecificationOptions

public boolean setSpecificationOptions(String options)

merge

public void merge(Table target)

getGeneratorRowsCount

public int getGeneratorRowsCount()

setGeneratorRowsCount

public void setGeneratorRowsCount(int rows)

getGeneratorOrder

public int getGeneratorOrder()

setGeneratorOrder

public void setGeneratorOrder(int generatorOrder)

hasFkOrRef

public boolean hasFkOrRef()

setRowCount

public void setRowCount(long rowCount)

getRowCount

public long getRowCount()

hasOneColumnPk

public boolean hasOneColumnPk()

Overrides:

hasOneColumnPk in class AbstractTable

getDbId

public String getDbId()

Specified by:

getDbId in interface DbUnit

Specified by:

getDbId in class AbstractTable

setPreScript

public boolean setPreScript(String preScript)

getPreScript

public String getPreScript()

setPostScript

public boolean setPostScript(String preScript)

getPostScript

public String getPostScript()

getPkOrUniqueIndexContaining

public Index getPkOrUniqueIndexContaining(List<Column> attributes,
 boolean exactMatch)

columnIsPk

public boolean columnIsPk(Column column)

getTableGenerator

public GeneratorTable getTableGenerator()

removeDuplicateIndexes

public void removeDuplicateIndexes()