C# Class Deveel.Data.Transactions.TransactionConstraintExtensions

Mostrar archivo 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[]