C# Класс Deveel.Data.Transactions.TransactionConstraintExtensions

Показать файл Открыть проект

Открытые методы

Метод Описание
AddCheck ( this transaction, ObjectName tableName, SqlExpression expression, ConstraintDeferrability deferrability, string constraintName ) : void
AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, ConstraintDeferrability deferred, String constraintName ) : void
AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, ForeignKeyAction deleteRule, ForeignKeyAction updateRule, ConstraintDeferrability deferred, String constraintName ) : void
AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, ForeignKeyAction deleteRule, ForeignKeyAction updateRule, String constraintName ) : void
AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, String constraintName ) : void
AddPrimaryKey ( this transaction, ObjectName tableName, string columns, ConstraintDeferrability deferred, string constraintName ) : void
AddPrimaryKey ( this transaction, ObjectName tableName, string columns, string constraintName ) : void
AddUniqueKey ( this transaction, ObjectName tableName, string columns, ConstraintDeferrability deferred, string constraintName ) : void
AddUniqueKey ( this transaction, ObjectName tableName, string columns, string constraintName ) : void
CheckAddConstraintViolations ( this transaction, ITable table, ConstraintDeferrability deferred ) : void
CheckAddConstraintViolations ( this transaction, ITable table, int rowIndices, ConstraintDeferrability deferred ) : void
CheckAllConstraintViolations ( this transaction, ObjectName tableName ) : void
CheckFieldConstraintViolations ( this transaction, ITable table, int rowIndices ) : void
CheckRemoveConstraintViolations ( this transaction, ITable table, int rowIndices, ConstraintDeferrability deferred ) : void
DropAllTableConstraints ( this transaction, ObjectName tableName ) : void
DropTableCheck ( this transaction, ObjectName table, string constraintName ) : bool
DropTableConstraint ( this transaction, ObjectName tableName, string constraintName ) : int
DropTableForeignKey ( this transaction, ObjectName table, string constraintName ) : bool
DropTablePrimaryKey ( this transaction, ObjectName tableName, string constraintName ) : bool
DropTableUniqueKey ( this transaction, ObjectName table, string constraintName ) : bool
QueryTableCheckExpressions ( this transaction, ObjectName tableName ) : ConstraintInfo[]
QueryTableForeignKeys ( this transaction, ObjectName tableName ) : ConstraintInfo[]
QueryTableImportedForeignKeys ( this transaction, ObjectName refTableName ) : ConstraintInfo[]
QueryTablePrimaryKey ( this transaction, ObjectName tableName ) : ConstraintInfo
QueryTableUniqueKeys ( this transaction, ObjectName tableName ) : ConstraintInfo[]
QueryTablesRelationallyLinkedTo ( this transaction, ObjectName tableName ) : ObjectName[]

Приватные методы

Метод Описание
IsUniqueColumns ( ITable table, int rindex, string cols, bool nullsAllowed ) : bool
MakeUniqueConstraintName ( string constraintName, SqlNumber uniqueId ) : string
RowCountOfReferenceTable ( this transaction, int rowIndex, ObjectName table1, string cols1, ObjectName table2, String cols2, bool checkSourceTableKey ) : int
ToColumns ( ITable table, IEnumerable cols ) : String[]

Описание методов

AddCheck() публичный статический Метод

public static AddCheck ( this transaction, ObjectName tableName, SqlExpression expression, ConstraintDeferrability deferrability, string constraintName ) : void
transaction this
tableName ObjectName
expression Deveel.Data.Sql.Expressions.SqlExpression
deferrability ConstraintDeferrability
constraintName string
Результат void

AddForeignKey() публичный статический Метод

public static AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, ConstraintDeferrability deferred, String constraintName ) : void
transaction this
table ObjectName
columns string
refTable ObjectName
refColumns string
deferred ConstraintDeferrability
constraintName String
Результат void

AddForeignKey() публичный статический Метод

public static AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, ForeignKeyAction deleteRule, ForeignKeyAction updateRule, ConstraintDeferrability deferred, String constraintName ) : void
transaction this
table ObjectName
columns string
refTable ObjectName
refColumns string
deleteRule ForeignKeyAction
updateRule ForeignKeyAction
deferred ConstraintDeferrability
constraintName String
Результат void

AddForeignKey() публичный статический Метод

public static AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, ForeignKeyAction deleteRule, ForeignKeyAction updateRule, String constraintName ) : void
transaction this
table ObjectName
columns string
refTable ObjectName
refColumns string
deleteRule ForeignKeyAction
updateRule ForeignKeyAction
constraintName String
Результат void

AddForeignKey() публичный статический Метод

public static AddForeignKey ( this transaction, ObjectName table, string columns, ObjectName refTable, string refColumns, String constraintName ) : void
transaction this
table ObjectName
columns string
refTable ObjectName
refColumns string
constraintName String
Результат void

AddPrimaryKey() публичный статический Метод

public static AddPrimaryKey ( this transaction, ObjectName tableName, string columns, ConstraintDeferrability deferred, string constraintName ) : void
transaction this
tableName ObjectName
columns string
deferred ConstraintDeferrability
constraintName string
Результат void

AddPrimaryKey() публичный статический Метод

public static AddPrimaryKey ( this transaction, ObjectName tableName, string columns, string constraintName ) : void
transaction this
tableName ObjectName
columns string
constraintName string
Результат void

AddUniqueKey() публичный статический Метод

public static AddUniqueKey ( this transaction, ObjectName tableName, string columns, ConstraintDeferrability deferred, string constraintName ) : void
transaction this
tableName ObjectName
columns string
deferred ConstraintDeferrability
constraintName string
Результат void

AddUniqueKey() публичный статический Метод

public static AddUniqueKey ( this transaction, ObjectName tableName, string columns, string constraintName ) : void
transaction this
tableName ObjectName
columns string
constraintName string
Результат void

CheckAddConstraintViolations() публичный статический Метод

public static CheckAddConstraintViolations ( this transaction, ITable table, ConstraintDeferrability deferred ) : void
transaction this
table ITable
deferred ConstraintDeferrability
Результат void

CheckAddConstraintViolations() публичный статический Метод

public static CheckAddConstraintViolations ( this transaction, ITable table, int rowIndices, ConstraintDeferrability deferred ) : void
transaction this
table ITable
rowIndices int
deferred ConstraintDeferrability
Результат void

CheckAllConstraintViolations() публичный статический Метод

public static CheckAllConstraintViolations ( this transaction, ObjectName tableName ) : void
transaction this
tableName ObjectName
Результат void

CheckFieldConstraintViolations() публичный статический Метод

public static CheckFieldConstraintViolations ( this transaction, ITable table, int rowIndices ) : void
transaction this
table ITable
rowIndices int
Результат void

CheckRemoveConstraintViolations() публичный статический Метод

public static CheckRemoveConstraintViolations ( this transaction, ITable table, int rowIndices, ConstraintDeferrability deferred ) : void
transaction this
table ITable
rowIndices int
deferred ConstraintDeferrability
Результат void

DropAllTableConstraints() публичный статический Метод

public static DropAllTableConstraints ( this transaction, ObjectName tableName ) : void
transaction this
tableName ObjectName
Результат void

DropTableCheck() публичный статический Метод

public static DropTableCheck ( this transaction, ObjectName table, string constraintName ) : bool
transaction this
table ObjectName
constraintName string
Результат bool

DropTableConstraint() публичный статический Метод

public static DropTableConstraint ( this transaction, ObjectName tableName, string constraintName ) : int
transaction this
tableName ObjectName
constraintName string
Результат int

DropTableForeignKey() публичный статический Метод

public static DropTableForeignKey ( this transaction, ObjectName table, string constraintName ) : bool
transaction this
table ObjectName
constraintName string
Результат bool

DropTablePrimaryKey() публичный статический Метод

public static DropTablePrimaryKey ( this transaction, ObjectName tableName, string constraintName ) : bool
transaction this
tableName ObjectName
constraintName string
Результат bool

DropTableUniqueKey() публичный статический Метод

public static DropTableUniqueKey ( this transaction, ObjectName table, string constraintName ) : bool
transaction this
table ObjectName
constraintName string
Результат bool

QueryTableCheckExpressions() публичный статический Метод

public static QueryTableCheckExpressions ( this transaction, ObjectName tableName ) : ConstraintInfo[]
transaction this
tableName ObjectName
Результат ConstraintInfo[]

QueryTableForeignKeys() публичный статический Метод

public static QueryTableForeignKeys ( this transaction, ObjectName tableName ) : ConstraintInfo[]
transaction this
tableName ObjectName
Результат ConstraintInfo[]

QueryTableImportedForeignKeys() публичный статический Метод

public static QueryTableImportedForeignKeys ( this transaction, ObjectName refTableName ) : ConstraintInfo[]
transaction this
refTableName ObjectName
Результат ConstraintInfo[]

QueryTablePrimaryKey() публичный статический Метод

public static QueryTablePrimaryKey ( this transaction, ObjectName tableName ) : ConstraintInfo
transaction this
tableName ObjectName
Результат ConstraintInfo

QueryTableUniqueKeys() публичный статический Метод

public static QueryTableUniqueKeys ( this transaction, ObjectName tableName ) : ConstraintInfo[]
transaction this
tableName ObjectName
Результат ConstraintInfo[]

QueryTablesRelationallyLinkedTo() публичный статический Метод

public static QueryTablesRelationallyLinkedTo ( this transaction, ObjectName tableName ) : ObjectName[]
transaction this
tableName ObjectName
Результат ObjectName[]