DbSchema/com.wisecoders.dbs.schema/Schema

Schema

class Schema(val project: Project, name: String, catalogName: String?) : AbstractUnit, DbUnit, SyncPrioritizable

A schema in the database.

Constructors

constructor(project: Project, name: String, catalogName: String?)

Types

object Companion

Properties

var catalogName: String?

open override val children: List<TreeUnit>

open override var comment: String?

val commentNotNull: String

open override var commentTags: Map<String, String>

defaultSyncPriority

open override var defaultSyncPriority: Int

val entities: Iterable<AbstractTable>

foreignKeyCount

val foreignKeyCount: Int

val functions: Folder<Function>

var isInUse: Boolean

isMarkedForDeletion

open override val isMarkedForDeletion: Boolean

open override var isVirtual: Boolean

open var key: String

materializedViews

val materializedViews: Folder<MaterializedView>

val mDCatalog: String?

val mDSchema: String?

open override var mutatedAt: Long

open override var name: String

val nameFinder: NameFinder

nameWithCatalog

val nameWithCatalog: String

var options: String?

open override val parent: Folder<*>

var postScript: String?

var preScript: String?

var priorName: String?

val procedures: Folder<Procedure>

val project: Project

val relationCount: Int

val rules: Folder<Rule>

val sequences: Folder<Sequence>

specificationOptions

var specificationOptions: String?

open override val symbolicName: String

open var syncFolders: List<List<AbstractUnit>>

open override var syncPriority: Int

val tables: Folder<Table>

val triggers: Folder<Trigger>

val userDataTypes: Folder<UserDataType>

val views: Folder<View>

Functions

fun cloneTable(original: Table, moveIncomingFks: Boolean): Table

open operator override fun compareTo(other: AbstractUnit): Int

fun createFunction(name: String): Function

createMaterializedView

fun createMaterializedView(name: String): MaterializedView

createProcedure

fun createProcedure(name: String): Procedure

fun createRule(name: String): Rule

fun createRule(name: String, table: Table?): Rule

fun createSequence(name: String): Sequence

fun createTable(name: String): Table

fun createTrigger(name: String): Trigger

fun createTrigger(name: String, table: AbstractTable?): Trigger

createUserDataType

fun createUserDataType(name: String): UserDataType

fun createView(name: String): View

findVirtualForeignKeys

fun findVirtualForeignKeys(preSelect: Boolean, referredIsPk: Boolean, pkPattern: String?, fkPattern: String?): List<VirtualForeignKeySuggestion>

fun get(unitName: String?, cls: Class<*>): AbstractUnit?

open override fun getByName(name: String): TreeUnit?

fun getCatalogName(mapping: SchemaMapping?): String?

open override fun getDbId(): String

open override fun getDisplayName(diagram: Diagram): String

open override fun getIcon(): ERROR CLASS: Symbol not found for Icon

fun getIndexByName(name: String?): Index?

getMaterializedView

fun getMaterializedView(name: String): MaterializedView?

fun getOrCreate(unitName: String, cls: Class<*>): AbstractUnit?

getOrCreateMaterializedView

fun getOrCreateMaterializedView(tableName: String): MaterializedView

getOrCreateTable

fun getOrCreateTable(tableName: String): Table

getOrCreateView

fun getOrCreateView(tableName: String): View

getPropertyAddOnFolder

fun getPropertyAddOnFolder(name: String?): PropertyAddOnFolder?

open override fun getSchema(): Schema

fun getTable(name: String): Table?

getTableOrMatView

fun getTableOrMatView(name: String): AbstractTable?

getTableOrViewMatView

fun getTableOrViewMatView(name: String): AbstractTable?

getTableOrViewOrMatViewOrUDT

fun getTableOrViewOrMatViewOrUDT(name: String): Entity?

getUserDataType

fun getUserDataType(typeName: String): UserDataType?

fun getView(name: String): View?

fun hasEntities(): Boolean

markForDeletion

open override fun markForDeletion()

Call this method to mark a unit (table, column) to be deleted. It can be called from any thread. The effective deletion is done by calling project.refresh() or schema.refresh() on JavaFX GUI thread.

fun matches(unit: AbstractUnit?): Boolean

open override fun ref(): String

open override fun refresh()

fun rename(newName: String): Boolean

fun sameAs(unit: AbstractUnit): Boolean

open fun sameAs(unit: AbstractUnit, considerRenaming: Boolean): Boolean

open override fun setCommentTag(key: String, value: String?)

open override fun toString(): String