Package com.wisecoders.dbs.schema

Class View

java.lang.Object

com.wisecoders.dbs.diagram.model.AbstractUnit

com.wisecoders.dbs.diagram.model.AbstractTable

com.wisecoders.dbs.schema.View

All Implemented Interfaces:

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

Direct Known Subclasses:

MaterializedView

public class View
extends AbstractTable
implements DbUnit

Database view. The View columns are generated by running the view SQL against the database.

Field Summary

Fields

Modifier and Type	Field	Description
final Folder<Column>	columns
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
View(Schema schema, String name)

Method Summary

Modifier and Type	Method	Description
Column	createColumn(String name, DataType type)
ForeignKey	createRelation(String name)
void	deduceVirtualFks()
Folder<? extends Column>	getAttributes()
TreeUnit	getChildAt(int idx)
int	getChildrenCount()
Column	getColumn(String name)
String	getDbId()
int	getDefaultSyncPriority()
TreeUnit	getParent()
Folder<ForeignKey>	getRelations()
Schema	getSchema()
String	getScript()
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.
boolean	isView()
void	refresh()
boolean	sameAs(AbstractUnit unit, boolean considerRenaming)
void	setScript(String script)

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

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

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

compareTo, fixNull, getByName, getByName, getComment, getCommentNotNull, getCommentTag, getCommentTags, getDefaultKey, getDisplayName, getKey, getName, getParentEntity, getPlainName, getPropertyAddOnFolder, getString, getSyncFolders, getTickId, getTouchId, getUnitProperty, has, is, is, isMarkedForDeletion, isVirtual, markForDeletion, matches, removeUnitProperty, rename, 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, getDisplayName, getEntity, getParentEntity, is, isMarkedForDeletion, markForDeletion, ref, setComment, setCommentTag, setCommentTags

Field Details

schema

public final Schema schema

columns

public final Folder<Column> columns

Constructor Details

View

public View(Schema schema,
 String name)

Method Details

getSchema

public Schema getSchema()

Specified by:

getSchema in interface DbUnit

Specified by:

getSchema in interface Entity

Specified by:

getSchema in class AbstractTable

getAttributes

public Folder<? extends Column> getAttributes()

Specified by:

getAttributes in interface Entity

Specified by:

getAttributes in class AbstractTable

getRelations

public Folder<ForeignKey> getRelations()

Specified by:

getRelations in interface Entity

Specified by:

getRelations in class AbstractTable

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

getSymbolicName

public String getSymbolicName()

Returns the name of the node.

Specified by:

getSymbolicName in interface Unit

Specified by:

getSymbolicName in class AbstractUnit

Returns:

the 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 symbolic icon

getSymbolicGlyph

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

Specified by:

getSymbolicGlyph in class AbstractUnit

getParent

public TreeUnit getParent()

Specified by:

getParent in interface TreeUnit

Specified by:

getParent in class AbstractUnit

getScript

public String getScript()

setScript

public void setScript(String script)

createColumn

public Column createColumn(String name,
 DataType type)

Specified by:

createColumn in class AbstractTable

getColumn

public Column getColumn(String name)

isView

public boolean isView()

Specified by:

isView in interface Entity

Specified by:

isView in class AbstractTable

createRelation

public ForeignKey createRelation(String name)

Specified by:

createRelation in class AbstractTable

deduceVirtualFks

public void deduceVirtualFks()

refresh

public void refresh()

Specified by:

refresh in interface Entity

Specified by:

refresh in class AbstractUnit

sameAs

public boolean sameAs(AbstractUnit unit,
 boolean considerRenaming)

Overrides:

sameAs in class AbstractUnit

getDbId

public String getDbId()

Specified by:

getDbId in interface DbUnit

Specified by:

getDbId in class AbstractTable

getDefaultSyncPriority

public int getDefaultSyncPriority()

Specified by:

getDefaultSyncPriority in interface SyncPrioritizable

Overrides:

getDefaultSyncPriority in class AbstractTable