Package com.wisecoders.dbs.schema

Class Schema

java.lang.Object

com.wisecoders.dbs.diagram.model.AbstractUnit

com.wisecoders.dbs.schema.Schema

All Implemented Interfaces:

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

public final class Schema
extends AbstractUnit
implements DbUnit, SyncPrioritizable

A schema in the database.

Field Summary

Fields

Modifier and Type	Field	Description
final ArrayList<Folder<?>>	children
final Folder<Function>	functions
final Folder<MaterializedView>	materializedViews
final NameFinder	nameFinder
static final String	PK_COLUMN
static final String	PK_TABLE
final Folder<Procedure>	procedures
final Project	project
final Folder<Rule>	rules
final Folder<Sequence>	sequences
final Folder<Table>	tables
final Folder<Trigger>	triggers
final Folder<UserDataType>	userDataTypes
final Folder<View>	views

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
Schema(Project project, String name, String catalogName)	Public constructor

Method Summary

Modifier and Type	Method	Description
Table	cloneTable(Table original, boolean moveImportedFks)
int	compareTo(AbstractUnit unit)
Function	createFunction(String name)
MaterializedView	createMaterializedView(String name)
Procedure	createProcedure(String name)
Rule	createRule(String name)
Rule	createRule(String name, Table table)
Sequence	createSequence(String name)
Table	createTable(String name)
Trigger	createTrigger(String name)
Trigger	createTrigger(String name, AbstractTable table)
UserDataType	createUserDataType(String name)
View	createView(String name)
List<VirtualForeignKeySuggestion>	generateVirtualForeignKeysWhenReferredIsNotPrimaryKey(boolean preSelect, boolean referredIsPk, String pkPattern, String fkPattern)
AbstractUnit	get(String unitName, Class cls)
String	getCatalogName()
String	getCatalogName(SchemaMapping mapping)
TreeUnit	getChildAt(int idx)
int	getChildrenCount()
String	getDbId()
int	getDefaultSyncPriority()
EntityIterable	getEntities()
AbstractTable	getEntity()
int	getForeignKeyCount()
Index	getIndexByName(String name)
MaterializedView	getMaterializedView(String name)
String	getMDCatalog()
String	getMDSchema()
String	getNameWithCatalog()
String	getOptions()
AbstractUnit	getOrCreate(String unitName, Class cls)
Function	getOrCreateFunction(String functionName)
MaterializedView	getOrCreateMaterializedView(String tableName)
Procedure	getOrCreateProcedure(String procedureName)
Sequence	getOrCreateSequence(String sequenceName)
Table	getOrCreateTable(String tableName)
Trigger	getOrCreateTrigger(String procedureName)
UserDataType	getOrCreateUserDataType(String sequenceName)
View	getOrCreateView(String tableName)
Folder	getParent()
String	getPostScript()
String	getPreScript()
int	getRelationCount()
Schema	getSchema()
String	getSpecificationOptions()
com.wisecoders.dbs.sys.fx.glyph.Glyph	getSymbolicGlyph()
String	getSymbolicIcon()
String	getSymbolicName()
Folder[]	getSyncFolders()
int	getSyncPriority()
Table	getTable(String name)
AbstractTable	getTableOrViewOrMatViewOrUDT(String name)
UserDataType	getUserDataType(String typeName)
View	getView(String name)
boolean	hasEntities()
boolean	isInUse()
String	ref()
void	refresh()
void	setCatalogName(String catalogName)
void	setOptions(String options)
boolean	setPostScript(String preScript)
boolean	setPreScript(String preScript)
void	setSpecificationOptions(String specificationOptions)
void	setSyncPriority(int syncPriority)
String	toString()

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

fixNull, getByName, getByName, getComment, getCommentNotNull, getCommentTag, getCommentTags, getDefaultKey, getDisplayName, 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

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.Unit

getComment, getCommentTag, getCommentTags, getDisplayName, getParentEntity, is, isMarkedForDeletion, markForDeletion, setComment, setCommentTag, setCommentTags

Field Details

project

public final Project project

tables

public final Folder<Table> tables

userDataTypes

public final Folder<UserDataType> userDataTypes

views

public final Folder<View> views

materializedViews

public final Folder<MaterializedView> materializedViews

sequences

public final Folder<Sequence> sequences

procedures

public final Folder<Procedure> procedures

functions

public final Folder<Function> functions

triggers

public final Folder<Trigger> triggers

rules

public final Folder<Rule> rules

children

public final ArrayList<Folder<?>> children

nameFinder

public final NameFinder nameFinder

PK_TABLE

public static final String PK_TABLE

See Also:

• Constant Field Values

PK_COLUMN

public static final String PK_COLUMN

See Also:

• Constant Field Values

Constructor Details

Schema

public Schema(Project project,
 String name,
 String catalogName)

Public constructor

Parameters:

project - it belongs to

name - of the schema

catalogName - from Jdbc

Method Details

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

getSyncFolders

public Folder[] getSyncFolders()

Overrides:

getSyncFolders in class AbstractUnit

getEntity

public AbstractTable getEntity()

Specified by:

getEntity in interface Unit

getCatalogName

public String getCatalogName()

getCatalogName

public String getCatalogName(SchemaMapping mapping)

getNameWithCatalog

public String getNameWithCatalog()

getMDCatalog

public String getMDCatalog()

getMDSchema

public String getMDSchema()

getTable

public Table getTable(String name)

getOrCreateTable

public Table getOrCreateTable(String tableName)

getOrCreateView

public View getOrCreateView(String tableName)

getOrCreateMaterializedView

public MaterializedView getOrCreateMaterializedView(String tableName)

getOrCreateSequence

public Sequence getOrCreateSequence(String sequenceName)

getOrCreateUserDataType

public UserDataType getOrCreateUserDataType(String sequenceName)

getOrCreateFunction

public Function getOrCreateFunction(String functionName)

getOrCreateProcedure

public Procedure getOrCreateProcedure(String procedureName)

getOrCreateTrigger

public Trigger getOrCreateTrigger(String procedureName)

getOrCreate

public AbstractUnit getOrCreate(String unitName,
 Class cls)

get

public AbstractUnit get(String unitName,
 Class cls)

getView

public View getView(String name)

getMaterializedView

public MaterializedView getMaterializedView(String name)

getUserDataType

public UserDataType getUserDataType(String typeName)

getTableOrViewOrMatViewOrUDT

public AbstractTable getTableOrViewOrMatViewOrUDT(String name)

getIndexByName

public Index getIndexByName(String name)

refresh

public void refresh()

Specified by:

refresh in class AbstractUnit

getSymbolicName

public String getSymbolicName()

Specified by:

getSymbolicName in interface Unit

Specified by:

getSymbolicName in class AbstractUnit

Returns:

the name to be used

getSymbolicIcon

public String getSymbolicIcon()

Specified by:

getSymbolicIcon in class AbstractUnit

Returns:

the icon to be used in tree pane

getSymbolicGlyph

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

Specified by:

getSymbolicGlyph in class AbstractUnit

getParent

public Folder getParent()

Specified by:

getParent in interface TreeUnit

Specified by:

getParent in class AbstractUnit

createTable

public Table createTable(String name)

createUserDataType

public UserDataType createUserDataType(String name)

createView

public View createView(String name)

createMaterializedView

public MaterializedView createMaterializedView(String name)

createSequence

public Sequence createSequence(String name)

createProcedure

public Procedure createProcedure(String name)

createRule

public Rule createRule(String name)

createRule

public Rule createRule(String name,
 Table table)

createFunction

public Function createFunction(String name)

createTrigger

public Trigger createTrigger(String name)

createTrigger

public Trigger createTrigger(String name,
 AbstractTable table)

getEntities

public EntityIterable getEntities()

hasEntities

public boolean hasEntities()

getRelationCount

public int getRelationCount()

getForeignKeyCount

public int getForeignKeyCount()

generateVirtualForeignKeysWhenReferredIsNotPrimaryKey

public List<VirtualForeignKeySuggestion> generateVirtualForeignKeysWhenReferredIsNotPrimaryKey(boolean preSelect,
 boolean referredIsPk,
 String pkPattern,
 String fkPattern)

getDbId

public String getDbId()

Specified by:

getDbId in interface DbUnit

getSchema

public Schema getSchema()

Specified by:

getSchema in interface DbUnit

getSpecificationOptions

public String getSpecificationOptions()

getOptions

public String getOptions()

setSpecificationOptions

public void setSpecificationOptions(String specificationOptions)

setOptions

public void setOptions(String options)

compareTo

public int compareTo(AbstractUnit unit)

Specified by:

compareTo in interface Comparable<AbstractUnit>

Overrides:

compareTo in class AbstractUnit

setCatalogName

public void setCatalogName(String catalogName)

toString

public String toString()

Overrides:

toString in class AbstractUnit

setPreScript

public boolean setPreScript(String preScript)

getPreScript

public String getPreScript()

setPostScript

public boolean setPostScript(String preScript)

getPostScript

public String getPostScript()

ref

public String ref()

Specified by:

ref in interface Unit

Overrides:

ref in class AbstractUnit

isInUse

public boolean isInUse()

setSyncPriority

public void setSyncPriority(int syncPriority)

Specified by:

setSyncPriority in interface SyncPrioritizable

getSyncPriority

public int getSyncPriority()

Specified by:

getSyncPriority in interface SyncPrioritizable

getDefaultSyncPriority

public int getDefaultSyncPriority()

Specified by:

getDefaultSyncPriority in interface SyncPrioritizable

cloneTable

public Table cloneTable(Table original,
 boolean moveImportedFks)