kontrol-db-core/net.futureset.kontroldb.dsl/ModelChangesBuilder

ModelChangesBuilder

data class ModelChangesBuilder(val changes: MutableList<ModelChange> = mutableListOf()) : Builder<ModelChangesBuilder, List<ModelChange>> (source)

Constructors

ModelChangesBuilder

constructor(changes: MutableList<ModelChange> = mutableListOf())

Properties

changes

val changes: MutableList<ModelChange>

Functions

addColumnsTo

fun ModelChangesBuilder.addColumnsTo(tableName: String, lambda: AddColumns.AddColumnsBuilder.() -> Unit): AddColumns

Add columns to a table

addForeignKey

fun ModelChangesBuilder.addForeignKey(constraintName: String, lambda: AddForeignKey.AddForeignKeyBuilder.() -> Unit): AddForeignKey

addNotNull

fun ModelChangesBuilder.addNotNull(lambda: AddNotNull.AddNotNullBuilder.() -> Unit): AddNotNull

addPrimaryKey

fun ModelChangesBuilder.addPrimaryKey(constraintName: String, lambda: AddPrimaryKey.AddPrimaryKeyBuilder.() -> Unit): AddPrimaryKey

applyDsvToTable

fun ModelChangesBuilder.applyDsvToTable(lambda: ApplyDsvToTable.ApplyDsvToTableBuilder.() -> Unit): ApplyDsvToTable

Load a delimiter separated file into a table

build

open override fun build(): List<ModelChange>

createIndex

fun ModelChangesBuilder.createIndex(indexName: String, lambda: CreateIndex.CreateIndexBuilder.() -> Unit): CreateIndex

Create an index

createProcedure

fun ModelChangesBuilder.createProcedure(name: String, lambda: CreateProcedure.CreateProcedureBuilder.() -> Unit): CreateProcedure

Create a stored procedure

createRole

fun ModelChangesBuilder.createRole(roleName: String): CreateRole

Create a database role

createSequence

fun ModelChangesBuilder.createSequence(name: String, lambda: CreateSequence.CreateSequenceBuilder.() -> Unit): CreateSequence

Create a sequence

createTable

fun ModelChangesBuilder.createTable(tableName: String, lambda: CreateTable.CreateTableBuilder.() -> Unit): CreateTable

Create a table

fun ModelChangesBuilder.createTable(table: Table, lambda: CreateTable.CreateTableBuilder.() -> Unit): CreateTable

createView

fun ModelChangesBuilder.createView(viewName: String, lambda: CreateView.CreateViewBuilder.() -> Unit): ModelChangesBuilder

Create a view

deleteRowsFrom

fun ModelChangesBuilder.deleteRowsFrom(tableName: String, block: DeleteRows.DeleteRowsBuilder.() -> Unit): DeleteRows

dropColumnsFrom

fun ModelChangesBuilder.dropColumnsFrom(tableName: String, lambda: DropColumns.DropColumnsBuilder.() -> Unit): DropColumns

dropIndexIfExists

fun ModelChangesBuilder.dropIndexIfExists(name: String, lambda: DropIndexBuilder.() -> Unit)

dropProcedureIfExists

fun ModelChangesBuilder.dropProcedureIfExists(name: String, lambda: SchemaObjectBuilder.() -> Unit = {})

Drop procedure if exists

dropRole

fun ModelChangesBuilder.dropRole(roleName: String): DropRole

Drop a database role

dropSequenceIfExists

fun ModelChangesBuilder.dropSequenceIfExists(name: String, lambda: SchemaObjectBuilder.() -> Unit = {})

Drop sequence if exists

dropTable

fun ModelChangesBuilder.dropTable(table: Table): DropTable

fun ModelChangesBuilder.dropTable(tableName: String, lambda: DropTable.DropTableBuilder.() -> Unit = {}): DropTable

Drop a table

dropTableIfExists

fun ModelChangesBuilder.dropTableIfExists(name: String, lambda: SchemaObjectBuilder.() -> Unit = {})

dropViewIfExists

fun ModelChangesBuilder.dropViewIfExists(name: String, lambda: SchemaObjectBuilder.() -> Unit = {})

exportData

fun ModelChangesBuilder.exportData(lambda: ExportQueryBuilder.() -> Unit): ModelChangesBuilder

grantPermissions

fun ModelChangesBuilder.grantPermissions(permission: String, vararg permissions: String, lambda: ChangePermissions.ChangePermissionsBuilder.() -> Unit): ChangePermissions

insertOrUpdateRowsOf

fun ModelChangesBuilder.insertOrUpdateRowsOf(name: String, block: InsertOrUpdateRow.InsertOrUpdateRowBuilder.() -> Unit): InsertOrUpdateRow

insertRowsInto

fun ModelChangesBuilder.insertRowsInto(tableName: String, block: InsertRows.InsertRowsBuilder.() -> Unit): InsertRows

onlyIfDatabase

fun ModelChange.onlyIfDatabase(dbPredicate: (String) -> Boolean): DatabaseConditionalChange

For onlyIfDatabase

renameColumn

fun ModelChangesBuilder.renameColumn(tableName: String, lambda: RenameColumn.RenameColumnBuilder.() -> Unit = {}): RenameColumn

renameTable

fun ModelChangesBuilder.renameTable(fromTableName: String, toTableName: String, lambda: RenameTable.RenameTableBuilder.() -> Unit = {}): RenameTable

revokePermissions

fun ModelChangesBuilder.revokePermissions(permission: String, vararg permissions: String, lambda: ChangePermissions.ChangePermissionsBuilder.() -> Unit): ChangePermissions

scriptComment

fun ModelChangesBuilder.scriptComment(comment: String): ModelChangesBuilder

Generate a comment in SQL script

select

fun ModelChangesBuilder.select(lambda: SelectQuery.SelectQueryBuilder.() -> Unit): ModelChangesBuilder

updateRowsOf

fun ModelChangesBuilder.updateRowsOf(tableName: String, block: UpdateRows.UpdateRowsBuilder.() -> Unit): UpdateRows