C# Class Zetbox.Server.SchemaManagement.LoggingSchemaProviderAdapter

Inheritance: ISchemaProvider
显示文件 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