C# Class Zetbox.Server.SchemaManagement.LoggingSchemaProviderAdapter

Inheritance: ISchemaProvider

Mostrar archivo Open project: daszat/zetbox

Public Methods

Method	Description
AlterColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void
BeginTransaction ( ) : void
CheckCheckConstraintExists ( TableRef tblName, string constraintName ) : bool
CheckCheckConstraintPossible ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpressions ) : bool
CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool
CheckColumnContainsValues ( TableRef tblName, string colName ) : bool
CheckColumnExists ( TableRef tblName, string colName ) : bool
CheckDatabaseExists ( string dbName ) : bool
CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool
CheckFKConstraintExists ( TableRef tblName, string fkName ) : bool
CheckFunctionExists ( ProcRef funcName ) : bool
CheckIndexExists ( TableRef tblName, string idxName ) : bool
CheckIndexPossible ( TableRef tblName, string idxName, bool unique, bool clustered ) : bool
CheckPositionColumnValidity ( TableRef tblName, string fkName, string positionColumnName ) : bool
CheckProcedureExists ( ProcRef procName ) : bool
CheckSchemaExists ( string schemaName ) : bool
CheckTableContainsData ( TableRef tblName ) : bool
CheckTableContainsData ( TableRef tblName, IEnumerable discriminatorFilter ) : bool
CheckTableExists ( TableRef tblName ) : bool
CheckTriggerExists ( TriggerRef triggerName ) : bool
CheckViewExists ( TableRef viewName ) : bool
CommitTransaction ( ) : void
CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string discriminatorValue ) : void
CopyFKs ( TableRef srcTblName, string srcColName, TableRef destTblName, string destColName, string srcFKColName ) : void
CountRows ( TableRef tblName ) : long
CreateCheckConstraint ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpressions ) : void
CreateColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void
CreateContinuousSequenceNumberProcedure ( ) : void
CreateDatabase ( string dbName ) : void
CreateEmptyRightsViewUnmaterialized ( TableRef viewName ) : void
CreateFKConstraint ( TableRef tblName, TableRef refTblName, string colName, string constraintName, bool onDeleteCascade ) : void
CreateIndex ( TableRef tblName, string idxName, bool unique, bool clustered ) : void
CreatePositionColumnValidCheckProcedures ( string>.ILookup refSpecs ) : void
CreateRefreshAllRightsProcedure ( List refreshProcNames ) : void
CreateRefreshRightsOnProcedure ( ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights ) : void
CreateRightsViewUnmaterialized ( TableRef viewName, TableRef tblName, TableRef tblNameRights, IList acls ) : void
CreateSchema ( string schemaName ) : void
CreateSequenceNumberProcedure ( ) : void
CreateTable ( TableRef tblName, IEnumerable cols ) : void
CreateTable ( TableRef tblName, bool idAsIdentityColumn ) : void
CreateTable ( TableRef tblName, bool idAsIdentityColumn, bool createPrimaryKey ) : void
CreateUpdateRightsTrigger ( TriggerRef triggerName, TableRef tblName, List tblList, List dependingCols ) : void
DbTypeToNative ( DbType type ) : string
DblinkConnect ( TableRef tblName ) : void
Dispose ( ) : void
DropAllObjects ( ) : void
DropCheckConstraint ( TableRef tblName, string constraintName ) : void
DropColumn ( TableRef tblName, string colName ) : void
DropDatabase ( string dbName ) : void
DropFKConstraint ( TableRef tblName, string constraintName ) : void
DropFunction ( ProcRef funcName ) : void
DropIndex ( TableRef tblName, string idxName ) : void
DropProcedure ( ProcRef procName ) : void
DropSchema ( string schemaName, bool force ) : void
DropTable ( TableRef tblName ) : void
DropTrigger ( TriggerRef triggerName ) : void
DropView ( TableRef viewName ) : void
EnsureInfrastructure ( ) : void
ExecRefreshAllRightsProcedure ( ) : void
ExecRefreshRightsOnProcedure ( ProcRef procName ) : void
ExecuteSqlResource ( Type type, string scriptResourceNameFormat ) : void
GetColumnMaxLength ( TableRef tblName, string colName ) : int
GetFKConstraintNames ( ) : IEnumerable
GetFunctionName ( string schemaName, string funcName ) : ProcRef
GetFunctionNames ( ) : IEnumerable
GetHasColumnDefaultValue ( TableRef tblName, string colName ) : bool
GetIsColumnNullable ( TableRef tblName, string colName ) : bool
GetProcedureDefinition ( ProcRef proc ) : string
GetProcedureName ( string schemaName, string procName ) : ProcRef
GetProcedureNames ( ) : IEnumerable
GetSafeConnectionString ( ) : string
GetSafeConnectionString ( string connectionString ) : string
GetSavedSchema ( ) : string
GetSchemaNames ( ) : IEnumerable
GetTableColumnNames ( TableRef tblName ) : IEnumerable
GetTableColumns ( TableRef tblName ) : IEnumerable
GetTableName ( string schemaName, string tblName ) : TableRef
GetTableNames ( ) : IEnumerable
GetTriggerNames ( ) : IEnumerable
GetViewDefinition ( TableRef view ) : string
GetViewNames ( ) : IEnumerable
InsertFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string fkColName ) : void
LoggingSchemaProviderAdapter ( ISchemaProvider provider ) : System
MapColumnData ( TableRef srcTblName, string srcColNames, TableRef tblName, string colNames, object>.Dictionary mappings ) : void
MigrateFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
NativeToDbType ( string type ) : DbType
Open ( string connectionString ) : void
QuoteIdentifier ( string name ) : string
ReadJoin ( TableRef tblName, IEnumerable colNames, IEnumerable joins ) : IDataReader
ReadTableData ( TableRef tblName, IEnumerable colNames ) : IDataReader
ReadTableData ( string sql ) : IDataReader
RefreshDbStats ( ) : void
RenameColumn ( TableRef tblName, string oldColName, string newColName ) : void
RenameDiscriminatorValue ( TableRef tblName, string oldValue, string newValue ) : void
RenameFKConstraint ( TableRef tblName, string oldConstraintName, TableRef refTblName, string colName, string newConstraintName, bool onDeleteCascade ) : void
RenameIndex ( TableRef tblName, string oldIdxName, string newIdxName ) : void
RenameTable ( TableRef oldTblName, TableRef newTblName ) : void
RepairPositionColumn ( TableRef tblName, string positionColumnName ) : bool
RollbackTransaction ( ) : void
SaveSchema ( string schema ) : void
TruncateTable ( TableRef tblName ) : void
WriteDefaultValue ( TableRef tblName, string colName, object value ) : void
WriteDefaultValue ( TableRef tblName, string colName, object value, IEnumerable discriminatorFilter ) : void
WriteGuidDefaultValue ( TableRef tblName, string colName ) : void
WriteGuidDefaultValue ( TableRef tblName, string colName, IEnumerable discriminatorFilter ) : void
WriteTableData ( TableRef destTbl, IDataReader source, IEnumerable colNames ) : void
WriteTableData ( TableRef destTbl, IEnumerable colNames, IEnumerable values ) : void

Private Methods

Method	Description
LogExistance ( string type, DboRef dboName, bool result, string spec = "" ) : void
LogExistance ( string type, string name, bool result, string spec = "" ) : void
LogNameFetcher ( string type, IEnumerable result ) : void
LogNameFetcher ( string type, IEnumerable result ) : void
LogNameFetcher ( string type, IEnumerable result ) : void

Method Details

AlterColumn() public method

public AlterColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void
tblName	TableRef
colName	string
type	DbType
size	int
scale	int
isNullable	bool
return	void

BeginTransaction() public method

public BeginTransaction ( ) : void
return	void

CheckCheckConstraintExists() public method

public CheckCheckConstraintExists ( TableRef tblName, string constraintName ) : bool
tblName	TableRef
constraintName	string
return	bool

CheckCheckConstraintPossible() public method

public CheckCheckConstraintPossible ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpressions ) : bool
tblName	TableRef
colName	string
newConstraintName	string
checkExpressions	Dictionary
return	bool

CheckColumnContainsNulls() public method

public CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckColumnContainsValues() public method

public CheckColumnContainsValues ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckColumnExists() public method

public CheckColumnExists ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckDatabaseExists() public method

public CheckDatabaseExists ( string dbName ) : bool
dbName	string
return	bool

CheckFKColumnContainsUniqueValues() public method

public CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckFKConstraintExists() public method

public CheckFKConstraintExists ( TableRef tblName, string fkName ) : bool
tblName	TableRef
fkName	string
return	bool

CheckFunctionExists() public method

public CheckFunctionExists ( ProcRef funcName ) : bool
funcName	ProcRef
return	bool

CheckIndexExists() public method

public CheckIndexExists ( TableRef tblName, string idxName ) : bool
tblName	TableRef
idxName	string
return	bool

CheckIndexPossible() public method

public CheckIndexPossible ( TableRef tblName, string idxName, bool unique, bool clustered ) : bool
tblName	TableRef
idxName	string
unique	bool
clustered	bool
return	bool

CheckPositionColumnValidity() public method

public CheckPositionColumnValidity ( TableRef tblName, string fkName, string positionColumnName ) : bool
tblName	TableRef
fkName	string
positionColumnName	string
return	bool

CheckProcedureExists() public method

public CheckProcedureExists ( ProcRef procName ) : bool
procName	ProcRef
return	bool

CheckSchemaExists() public method

public CheckSchemaExists ( string schemaName ) : bool
schemaName	string
return	bool

CheckTableContainsData() public method

public CheckTableContainsData ( TableRef tblName ) : bool
tblName	TableRef
return	bool

CheckTableContainsData() public method

public CheckTableContainsData ( TableRef tblName, IEnumerable discriminatorFilter ) : bool
tblName	TableRef
discriminatorFilter	IEnumerable
return	bool

CheckTableExists() public method

public CheckTableExists ( TableRef tblName ) : bool
tblName	TableRef
return	bool

CheckTriggerExists() public method

public CheckTriggerExists ( TriggerRef triggerName ) : bool
triggerName	TriggerRef
return	bool

CheckViewExists() public method

public CheckViewExists ( TableRef viewName ) : bool
viewName	TableRef
return	bool

CommitTransaction() public method

public CommitTransaction ( ) : void
return	void

CopyColumnData() public method

public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
return	void

CopyColumnData() public method

public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string discriminatorValue ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
discriminatorValue	string
return	void

CopyFKs() public method

public CopyFKs ( TableRef srcTblName, string srcColName, TableRef destTblName, string destColName, string srcFKColName ) : void
srcTblName	TableRef
srcColName	string
destTblName	TableRef
destColName	string
srcFKColName	string
return	void

CountRows() public method

public CountRows ( TableRef tblName ) : long
tblName	TableRef
return	long

CreateCheckConstraint() public method

public CreateCheckConstraint ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpressions ) : void
tblName	TableRef
colName	string
newConstraintName	string
checkExpressions	Dictionary
return	void

CreateColumn() public method

public CreateColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void
tblName	TableRef
colName	string
type	DbType
size	int
scale	int
isNullable	bool
return	void

CreateContinuousSequenceNumberProcedure() public method

public CreateContinuousSequenceNumberProcedure ( ) : void
return	void

CreateDatabase() public method

public CreateDatabase ( string dbName ) : void
dbName	string
return	void

CreateEmptyRightsViewUnmaterialized() public method

public CreateEmptyRightsViewUnmaterialized ( TableRef viewName ) : void
viewName	TableRef
return	void

CreateFKConstraint() public method

public CreateFKConstraint ( TableRef tblName, TableRef refTblName, string colName, string constraintName, bool onDeleteCascade ) : void
tblName	TableRef
refTblName	TableRef
colName	string
constraintName	string
onDeleteCascade	bool
return	void

CreateIndex() public method

public CreateIndex ( TableRef tblName, string idxName, bool unique, bool clustered ) : void
tblName	TableRef
idxName	string
unique	bool
clustered	bool
return	void

CreatePositionColumnValidCheckProcedures() public method

public CreatePositionColumnValidCheckProcedures ( string>.ILookup refSpecs ) : void
refSpecs	string>.ILookup
return	void

CreateRefreshAllRightsProcedure() public method

public CreateRefreshAllRightsProcedure ( List refreshProcNames ) : void
refreshProcNames	List
return	void

CreateRefreshRightsOnProcedure() public method

public CreateRefreshRightsOnProcedure ( ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights ) : void
procName	ProcRef
viewUnmaterializedName	TableRef
tblName	TableRef
tblNameRights	TableRef
return	void

CreateRightsViewUnmaterialized() public method

public CreateRightsViewUnmaterialized ( TableRef viewName, TableRef tblName, TableRef tblNameRights, IList acls ) : void
viewName	TableRef
tblName	TableRef
tblNameRights	TableRef
acls	IList
return	void

CreateSchema() public method

public CreateSchema ( string schemaName ) : void
schemaName	string
return	void

CreateSequenceNumberProcedure() public method

public CreateSequenceNumberProcedure ( ) : void
return	void

CreateTable() public method

public CreateTable ( TableRef tblName, IEnumerable cols ) : void
tblName	TableRef
cols	IEnumerable
return	void

CreateTable() public method

public CreateTable ( TableRef tblName, bool idAsIdentityColumn ) : void
tblName	TableRef
idAsIdentityColumn	bool
return	void

CreateTable() public method

public CreateTable ( TableRef tblName, bool idAsIdentityColumn, bool createPrimaryKey ) : void
tblName	TableRef
idAsIdentityColumn	bool
createPrimaryKey	bool
return	void

CreateUpdateRightsTrigger() public method

public CreateUpdateRightsTrigger ( TriggerRef triggerName, TableRef tblName, List tblList, List dependingCols ) : void
triggerName	TriggerRef
tblName	TableRef
tblList	List
dependingCols	List
return	void

DbTypeToNative() public method

public DbTypeToNative ( DbType type ) : string
type	DbType
return	string

DblinkConnect() public method

public DblinkConnect ( TableRef tblName ) : void
tblName	TableRef
return	void

Dispose() public method

public Dispose ( ) : void
return	void

DropAllObjects() public method

public DropAllObjects ( ) : void
return	void

DropCheckConstraint() public method

public DropCheckConstraint ( TableRef tblName, string constraintName ) : void
tblName	TableRef
constraintName	string
return	void

DropColumn() public method

public DropColumn ( TableRef tblName, string colName ) : void
tblName	TableRef
colName	string
return	void

DropDatabase() public method

public DropDatabase ( string dbName ) : void
dbName	string
return	void

DropFKConstraint() public method

public DropFKConstraint ( TableRef tblName, string constraintName ) : void
tblName	TableRef
constraintName	string
return	void

DropFunction() public method

public DropFunction ( ProcRef funcName ) : void
funcName	ProcRef
return	void

DropIndex() public method

public DropIndex ( TableRef tblName, string idxName ) : void
tblName	TableRef
idxName	string
return	void

DropProcedure() public method

public DropProcedure ( ProcRef procName ) : void
procName	ProcRef
return	void

DropSchema() public method

public DropSchema ( string schemaName, bool force ) : void
schemaName	string
force	bool
return	void

DropTable() public method

public DropTable ( TableRef tblName ) : void
tblName	TableRef
return	void

DropTrigger() public method

public DropTrigger ( TriggerRef triggerName ) : void
triggerName	TriggerRef
return	void

DropView() public method

public DropView ( TableRef viewName ) : void
viewName	TableRef
return	void

EnsureInfrastructure() public method

public EnsureInfrastructure ( ) : void
return	void

ExecRefreshAllRightsProcedure() public method

public ExecRefreshAllRightsProcedure ( ) : void
return	void

ExecRefreshRightsOnProcedure() public method

public ExecRefreshRightsOnProcedure ( ProcRef procName ) : void
procName	ProcRef
return	void

ExecuteSqlResource() public method

public ExecuteSqlResource ( Type type, string scriptResourceNameFormat ) : void
type	System.Type
scriptResourceNameFormat	string
return	void

GetColumnMaxLength() public method

public GetColumnMaxLength ( TableRef tblName, string colName ) : int
tblName	TableRef
colName	string
return	int

GetFKConstraintNames() public method

public GetFKConstraintNames ( ) : IEnumerable
return	IEnumerable

GetFunctionName() public method

public GetFunctionName ( string schemaName, string funcName ) : ProcRef
schemaName	string
funcName	string
return	ProcRef

GetFunctionNames() public method

public GetFunctionNames ( ) : IEnumerable
return	IEnumerable

GetHasColumnDefaultValue() public method

public GetHasColumnDefaultValue ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

GetIsColumnNullable() public method

public GetIsColumnNullable ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

GetProcedureDefinition() public method

public GetProcedureDefinition ( ProcRef proc ) : string
proc	ProcRef
return	string

GetProcedureName() public method

public GetProcedureName ( string schemaName, string procName ) : ProcRef
schemaName	string
procName	string
return	ProcRef

GetProcedureNames() public method

public GetProcedureNames ( ) : IEnumerable
return	IEnumerable

GetSafeConnectionString() public method

public GetSafeConnectionString ( ) : string
return	string

GetSafeConnectionString() public method

public GetSafeConnectionString ( string connectionString ) : string
connectionString	string
return	string

GetSavedSchema() public method

public GetSavedSchema ( ) : string
return	string

GetSchemaNames() public method

public GetSchemaNames ( ) : IEnumerable
return	IEnumerable

GetTableColumnNames() public method

public GetTableColumnNames ( TableRef tblName ) : IEnumerable
tblName	TableRef
return	IEnumerable

GetTableColumns() public method

public GetTableColumns ( TableRef tblName ) : IEnumerable
tblName	TableRef
return	IEnumerable

GetTableName() public method

public GetTableName ( string schemaName, string tblName ) : TableRef
schemaName	string
tblName	string
return	TableRef

GetTableNames() public method

public GetTableNames ( ) : IEnumerable
return	IEnumerable

GetTriggerNames() public method

public GetTriggerNames ( ) : IEnumerable
return	IEnumerable

GetViewDefinition() public method

public GetViewDefinition ( TableRef view ) : string
view	TableRef
return	string

GetViewNames() public method

public GetViewNames ( ) : IEnumerable
return	IEnumerable

InsertFKs() public method

public InsertFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string fkColName ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
fkColName	string
return	void

LoggingSchemaProviderAdapter() public method

public LoggingSchemaProviderAdapter ( ISchemaProvider provider ) : System
provider	ISchemaProvider
return	System

MapColumnData() public method

public MapColumnData ( TableRef srcTblName, string srcColNames, TableRef tblName, string colNames, object>.Dictionary mappings ) : void
srcTblName	TableRef
srcColNames	string
tblName	TableRef
colNames	string
mappings	object>.Dictionary
return	void

MigrateFKs() public method

public MigrateFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
return	void

NativeToDbType() public method

public NativeToDbType ( string type ) : DbType
type	string
return	DbType

Open() public method

public Open ( string connectionString ) : void
connectionString	string
return	void

QuoteIdentifier() public method

public QuoteIdentifier ( string name ) : string
name	string
return	string

ReadJoin() public method

public ReadJoin ( TableRef tblName, IEnumerable colNames, IEnumerable joins ) : IDataReader
tblName	TableRef
colNames	IEnumerable
joins	IEnumerable
return	IDataReader

ReadTableData() public method

public ReadTableData ( TableRef tblName, IEnumerable colNames ) : IDataReader
tblName	TableRef
colNames	IEnumerable
return	IDataReader

ReadTableData() public method

public ReadTableData ( string sql ) : IDataReader
sql	string
return	IDataReader

RefreshDbStats() public method

public RefreshDbStats ( ) : void
return	void

RenameColumn() public method

public RenameColumn ( TableRef tblName, string oldColName, string newColName ) : void
tblName	TableRef
oldColName	string
newColName	string
return	void

RenameDiscriminatorValue() public method

public RenameDiscriminatorValue ( TableRef tblName, string oldValue, string newValue ) : void
tblName	TableRef
oldValue	string
newValue	string
return	void

RenameFKConstraint() public method

public RenameFKConstraint ( TableRef tblName, string oldConstraintName, TableRef refTblName, string colName, string newConstraintName, bool onDeleteCascade ) : void
tblName	TableRef
oldConstraintName	string
refTblName	TableRef
colName	string
newConstraintName	string
onDeleteCascade	bool
return	void

RenameIndex() public method

public RenameIndex ( TableRef tblName, string oldIdxName, string newIdxName ) : void
tblName	TableRef
oldIdxName	string
newIdxName	string
return	void

RenameTable() public method

public RenameTable ( TableRef oldTblName, TableRef newTblName ) : void
oldTblName	TableRef
newTblName	TableRef
return	void

RepairPositionColumn() public method

public RepairPositionColumn ( TableRef tblName, string positionColumnName ) : bool
tblName	TableRef
positionColumnName	string
return	bool

RollbackTransaction() public method

public RollbackTransaction ( ) : void
return	void

SaveSchema() public method

public SaveSchema ( string schema ) : void
schema	string
return	void

TruncateTable() public method

public TruncateTable ( TableRef tblName ) : void
tblName	TableRef
return	void

WriteDefaultValue() public method

public WriteDefaultValue ( TableRef tblName, string colName, object value ) : void
tblName	TableRef
colName	string
value	object
return	void

WriteDefaultValue() public method

public WriteDefaultValue ( TableRef tblName, string colName, object value, IEnumerable discriminatorFilter ) : void
tblName	TableRef
colName	string
value	object
discriminatorFilter	IEnumerable
return	void

WriteGuidDefaultValue() public method

public WriteGuidDefaultValue ( TableRef tblName, string colName ) : void
tblName	TableRef
colName	string
return	void

WriteGuidDefaultValue() public method

public WriteGuidDefaultValue ( TableRef tblName, string colName, IEnumerable discriminatorFilter ) : void
tblName	TableRef
colName	string
discriminatorFilter	IEnumerable
return	void

WriteTableData() public method

public WriteTableData ( TableRef destTbl, IDataReader source, IEnumerable colNames ) : void
destTbl	TableRef
source	IDataReader
colNames	IEnumerable
return	void

WriteTableData() public method

public WriteTableData ( TableRef destTbl, IEnumerable colNames, IEnumerable values ) : void
destTbl	TableRef
colNames	IEnumerable
values	IEnumerable
return	void