C# Class Deveel.Data.Transactions.TransactionConstraintExtensions

ファイルを表示 Open project: deveel/deveeldb

Public Methods

Method Description
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[]

Private Methods

Method Description
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[]

Method Details

AddCheck() public static method

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
return void

AddForeignKey() public static method

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
return void

AddForeignKey() public static method

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
return void

AddForeignKey() public static method

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
return void

AddForeignKey() public static method

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
return void

AddPrimaryKey() public static method

public static AddPrimaryKey ( this transaction, ObjectName tableName, string columns, ConstraintDeferrability deferred, string constraintName ) : void
transaction this
tableName ObjectName
columns string
deferred ConstraintDeferrability
constraintName string
return void

AddPrimaryKey() public static method

public static AddPrimaryKey ( this transaction, ObjectName tableName, string columns, string constraintName ) : void
transaction this
tableName ObjectName
columns string
constraintName string
return void

AddUniqueKey() public static method

public static AddUniqueKey ( this transaction, ObjectName tableName, string columns, ConstraintDeferrability deferred, string constraintName ) : void
transaction this
tableName ObjectName
columns string
deferred ConstraintDeferrability
constraintName string
return void

AddUniqueKey() public static method

public static AddUniqueKey ( this transaction, ObjectName tableName, string columns, string constraintName ) : void
transaction this
tableName ObjectName
columns string
constraintName string
return void

CheckAddConstraintViolations() public static method

public static CheckAddConstraintViolations ( this transaction, ITable table, ConstraintDeferrability deferred ) : void
transaction this
table ITable
deferred ConstraintDeferrability
return void

CheckAddConstraintViolations() public static method

public static CheckAddConstraintViolations ( this transaction, ITable table, int rowIndices, ConstraintDeferrability deferred ) : void
transaction this
table ITable
rowIndices int
deferred ConstraintDeferrability
return void

CheckAllConstraintViolations() public static method

public static CheckAllConstraintViolations ( this transaction, ObjectName tableName ) : void
transaction this
tableName ObjectName
return void

CheckFieldConstraintViolations() public static method

public static CheckFieldConstraintViolations ( this transaction, ITable table, int rowIndices ) : void
transaction this
table ITable
rowIndices int
return void

CheckRemoveConstraintViolations() public static method

public static CheckRemoveConstraintViolations ( this transaction, ITable table, int rowIndices, ConstraintDeferrability deferred ) : void
transaction this
table ITable
rowIndices int
deferred ConstraintDeferrability
return void

DropAllTableConstraints() public static method

public static DropAllTableConstraints ( this transaction, ObjectName tableName ) : void
transaction this
tableName ObjectName
return void

DropTableCheck() public static method

public static DropTableCheck ( this transaction, ObjectName table, string constraintName ) : bool
transaction this
table ObjectName
constraintName string
return bool

DropTableConstraint() public static method

public static DropTableConstraint ( this transaction, ObjectName tableName, string constraintName ) : int
transaction this
tableName ObjectName
constraintName string
return int

DropTableForeignKey() public static method

public static DropTableForeignKey ( this transaction, ObjectName table, string constraintName ) : bool
transaction this
table ObjectName
constraintName string
return bool

DropTablePrimaryKey() public static method

public static DropTablePrimaryKey ( this transaction, ObjectName tableName, string constraintName ) : bool
transaction this
tableName ObjectName
constraintName string
return bool

DropTableUniqueKey() public static method

public static DropTableUniqueKey ( this transaction, ObjectName table, string constraintName ) : bool
transaction this
table ObjectName
constraintName string
return bool

QueryTableCheckExpressions() public static method

public static QueryTableCheckExpressions ( this transaction, ObjectName tableName ) : ConstraintInfo[]
transaction this
tableName ObjectName
return ConstraintInfo[]

QueryTableForeignKeys() public static method

public static QueryTableForeignKeys ( this transaction, ObjectName tableName ) : ConstraintInfo[]
transaction this
tableName ObjectName
return ConstraintInfo[]

QueryTableImportedForeignKeys() public static method

public static QueryTableImportedForeignKeys ( this transaction, ObjectName refTableName ) : ConstraintInfo[]
transaction this
refTableName ObjectName
return ConstraintInfo[]

QueryTablePrimaryKey() public static method

public static QueryTablePrimaryKey ( this transaction, ObjectName tableName ) : ConstraintInfo
transaction this
tableName ObjectName
return ConstraintInfo

QueryTableUniqueKeys() public static method

public static QueryTableUniqueKeys ( this transaction, ObjectName tableName ) : ConstraintInfo[]
transaction this
tableName ObjectName
return ConstraintInfo[]

QueryTablesRelationallyLinkedTo() public static method

public static QueryTablesRelationallyLinkedTo ( this transaction, ObjectName tableName ) : ObjectName[]
transaction this
tableName ObjectName
return ObjectName[]