C# 클래스 SenseNet.ContentRepository.Storage.Data.SqlClient.SqlProvider

상속: DataProvider
파일 보기 프로젝트 열기: maxpavlov/FlexNet

공개 메소드들

메소드 설명
AssertSchemaTimestampAndWriteModificationDate ( long timestamp ) : void
GetLastActivityId ( ) : int
GetNameOfLastNodeWithNameBase ( int parentId, string namebase, string extension ) : string
GetScriptsForDatabaseBackup ( ) : IEnumerable
GetTimestampDataForOneNodeIntegrityCheck ( string path ) : IDataProcedure
GetTimestampDataForRecursiveIntegrityCheck ( string path ) : IDataProcedure
SecureSqlStringValue ( string value ) : string

SQL injection prevention.

SqlProvider ( ) : System

보호된 메소드들

메소드 설명
BreakInheritance ( int nodeId ) : void
CheckScriptInternal ( string commandText ) : void
CopyStagingToBinaryData ( int versionId, int propertyTypeId, int stagingBinaryDataId, string checksum ) : void
CreateBackup ( int backupNumber ) : IndexBackup
CreateDataProcedureInternal ( string commandText ) : IDataProcedure
CreateLoadIndexDocumentCollectionByPathProcedure ( string path ) : IDataProcedure
CreateNodeWriter ( ) : INodeWriter
CreateParameterInternal ( ) : IDbDataParameter
CreateSchemaWriter ( ) : SchemaWriter
CreateTransaction ( ) : ITransactionProvider
DeleteNodeTree ( int nodeId ) : DataOperationResult
DeleteNodeTreePsychical ( int nodeId ) : DataOperationResult
DeleteStagingBinaryData ( int stagingBinaryDataId ) : void
DeleteVersion ( int versionId, NodeData nodeData, int &lastMajorVersionId, int &lastMinorVersionId ) : void
ExplicateGroupMemberships ( ) : void
ExplicateOrganizationUnitMemberships ( IUser user ) : void
GetAppModelScriptPrivate ( IEnumerable paths, bool resolveAll, bool resolveChildren ) : string
GetChildrenIdentfiers ( int nodeId ) : IEnumerable
GetContentListTypesInTree ( string path ) : List
GetIdsOfNodesThatDoNotHaveIndexDocument ( ) : IEnumerable
GetIndexDocumentDataFromReader ( System reader ) : IndexDocumentData
GetLastIndexBackupNumber ( ) : System.Guid
GetNodeVersions ( int nodeId ) : NodeHead.NodeVersion[]
GetPropertyMappingInternal ( PropertyType propType ) : PropertyMapping
GetTreeSize ( string path, bool includeChildren ) : long
GetUserIdByUploadGuid ( System.Guid uploadGuid ) : int
GetVersionNumbers ( int nodeId ) : VersionNumber[]
GetVersionNumbers ( string path ) : VersionNumber[]
HasChild ( int nodeId ) : bool
InitializeStagingBinaryData ( int versionId, int propertyTypeId, string fileName, long fileSize ) : int
InstanceCount ( int nodeTypeIds ) : int
IsCacheableText ( string text ) : bool
KeepOnlyLastIndexBackup ( ) : void
LoadBinaryCacheEntity ( int nodeVersionId, int propertyTypeId ) : BinaryCacheEntity
LoadBinaryFragment ( int binaryPropertyId, long position, int count ) : byte[]
LoadBinaryPropertyValue ( int versionId, int propertyTypeId ) : Stream
LoadChildTypesToAllow ( int sourceNodeId ) : IEnumerable
LoadGroupMembership ( int groupId ) : List
LoadIndexDocumentByVersionId ( IEnumerable versionId ) : IEnumerable
LoadIndexDocumentByVersionId ( int versionId ) : IndexDocumentData
LoadLastBackup ( ) : IndexBackup
LoadMemberships ( ) : List>.Dictionary
LoadNodeHead ( int nodeId ) : NodeHead
LoadNodeHead ( string path ) : NodeHead
LoadNodeHeadByVersionId ( int versionId ) : NodeHead
LoadNodeHeads ( IEnumerable heads ) : IEnumerable
LoadNodes ( NodeBuilder>.Dictionary buildersByVersionId ) : void
LoadSchema ( ) : DataSet
LoadTextPropertyValue ( int versionId, int propertyTypeId ) : string
MoveNodeTree ( int sourceNodeId, int targetNodeId ) : DataOperationResult
NodeCount ( string path ) : int
NodeExistsInDatabase ( string path ) : bool
PersistUploadToken ( UploadToken value ) : void
QueryNodesByPath ( string pathStart, bool orderByPath ) : IEnumerable
QueryNodesByReferenceAndType ( string referenceName, int referredNodeId, int allowedTypeIds ) : IEnumerable
QueryNodesByType ( int nodeTypeIds ) : IEnumerable
QueryNodesByTypeAndPath ( int nodeTypeIds, string pathStart, bool orderByPath ) : IEnumerable
QueryNodesByTypeAndPathAndName ( int nodeTypeIds, string pathStart, bool orderByPath, string name ) : IEnumerable
QueryNodesByTypeAndPathAndProperty ( int nodeTypeIds, string pathStart, bool orderByPath, List properties ) : IEnumerable
RecoverIndexBackup ( string backupFilePath ) : IndexBackup
RemoveBreakInheritance ( int nodeId ) : void
Reset ( ) : void
SaveChunk ( int stagingBinaryDataId, byte bytes, int offset ) : void
SetActiveBackup ( IndexBackup backup, IndexBackup lastBackup ) : void
SetPermission ( SecurityEntry entry ) : void
SetPermission ( int principalId, int nodeId, PermissionType permissionType, bool isInheritable, PermissionValue permissionValue ) : void
StoreBackupStream ( string backupFilePath, IndexBackup backup, IndexBackupProgress progress ) : void
UpdateIndexDocument ( NodeData nodeData, byte indexDocumentBytes ) : void
VersionCount ( string path ) : int

비공개 메소드들

메소드 설명
CreateIdXmlForNodeInfoBatchLoad ( NodeBuilder>.Dictionary builders ) : string
CreateIdXmlForReferencePropertyUpdate ( IEnumerable values ) : string
CreateReadCommand ( IndexBackup backup ) : IDataProcedure
CreateWriteCommand ( IndexBackup backup ) : SqlProcedure
GetBackupFromReader ( System.Data.SqlClient.SqlDataReader reader ) : IndexBackup
GetColumnIndex ( DataType dataType, int mapping, int &page ) : int
GetNoBackupException ( ) : Exception
GetNodeAttributeName ( string propertyName ) : string
GetNodeAttributeType ( string propertyName ) : DataType
GetPermissionCacheKey ( int principalID, int nodeID, PermissionType type ) : string
InitializeNewStream ( IndexBackup backup ) : void
LoadLastModifiersGroupId ( ) : int
LoadNodeHead ( int nodeId, string path, int versionId ) : NodeHead
SetBreakInheritanceFlag ( int nodeId, bool @break ) : void

메소드 상세

AssertSchemaTimestampAndWriteModificationDate() 공개 메소드

public AssertSchemaTimestampAndWriteModificationDate ( long timestamp ) : void
timestamp long
리턴 void

BreakInheritance() 보호된 메소드

protected BreakInheritance ( int nodeId ) : void
nodeId int
리턴 void

CheckScriptInternal() 보호된 메소드

protected CheckScriptInternal ( string commandText ) : void
commandText string
리턴 void

CopyStagingToBinaryData() 보호된 메소드

protected CopyStagingToBinaryData ( int versionId, int propertyTypeId, int stagingBinaryDataId, string checksum ) : void
versionId int
propertyTypeId int
stagingBinaryDataId int
checksum string
리턴 void

CreateBackup() 보호된 메소드

protected CreateBackup ( int backupNumber ) : IndexBackup
backupNumber int
리턴 IndexBackup

CreateDataProcedureInternal() 보호된 메소드

protected CreateDataProcedureInternal ( string commandText ) : IDataProcedure
commandText string
리턴 IDataProcedure

CreateLoadIndexDocumentCollectionByPathProcedure() 보호된 메소드

protected CreateLoadIndexDocumentCollectionByPathProcedure ( string path ) : IDataProcedure
path string
리턴 IDataProcedure

CreateNodeWriter() 보호된 메소드

protected CreateNodeWriter ( ) : INodeWriter
리턴 INodeWriter

CreateParameterInternal() 보호된 메소드

protected CreateParameterInternal ( ) : IDbDataParameter
리턴 IDbDataParameter

CreateSchemaWriter() 보호된 메소드

protected CreateSchemaWriter ( ) : SchemaWriter
리턴 SenseNet.ContentRepository.Storage.Schema.SchemaWriter

CreateTransaction() 보호된 메소드

protected CreateTransaction ( ) : ITransactionProvider
리턴 ITransactionProvider

DeleteNodeTree() 보호된 메소드

protected DeleteNodeTree ( int nodeId ) : DataOperationResult
nodeId int
리턴 DataOperationResult

DeleteNodeTreePsychical() 보호된 메소드

protected DeleteNodeTreePsychical ( int nodeId ) : DataOperationResult
nodeId int
리턴 DataOperationResult

DeleteStagingBinaryData() 보호된 메소드

protected DeleteStagingBinaryData ( int stagingBinaryDataId ) : void
stagingBinaryDataId int
리턴 void

DeleteVersion() 보호된 메소드

protected DeleteVersion ( int versionId, NodeData nodeData, int &lastMajorVersionId, int &lastMinorVersionId ) : void
versionId int
nodeData NodeData
lastMajorVersionId int
lastMinorVersionId int
리턴 void

ExplicateGroupMemberships() 보호된 메소드

protected ExplicateGroupMemberships ( ) : void
리턴 void

ExplicateOrganizationUnitMemberships() 보호된 메소드

protected ExplicateOrganizationUnitMemberships ( IUser user ) : void
user IUser
리턴 void

GetAppModelScriptPrivate() 보호된 메소드

protected GetAppModelScriptPrivate ( IEnumerable paths, bool resolveAll, bool resolveChildren ) : string
paths IEnumerable
resolveAll bool
resolveChildren bool
리턴 string

GetChildrenIdentfiers() 보호된 메소드

protected GetChildrenIdentfiers ( int nodeId ) : IEnumerable
nodeId int
리턴 IEnumerable

GetContentListTypesInTree() 보호된 메소드

protected GetContentListTypesInTree ( string path ) : List
path string
리턴 List

GetIdsOfNodesThatDoNotHaveIndexDocument() 보호된 메소드

protected GetIdsOfNodesThatDoNotHaveIndexDocument ( ) : IEnumerable
리턴 IEnumerable

GetIndexDocumentDataFromReader() 보호된 메소드

protected GetIndexDocumentDataFromReader ( System reader ) : IndexDocumentData
reader System
리턴 IndexDocumentData

GetLastActivityId() 공개 메소드

public GetLastActivityId ( ) : int
리턴 int

GetLastIndexBackupNumber() 보호된 메소드

protected GetLastIndexBackupNumber ( ) : System.Guid
리턴 System.Guid

GetNameOfLastNodeWithNameBase() 공개 메소드

public GetNameOfLastNodeWithNameBase ( int parentId, string namebase, string extension ) : string
parentId int
namebase string
extension string
리턴 string

GetNodeVersions() 보호된 메소드

protected GetNodeVersions ( int nodeId ) : NodeHead.NodeVersion[]
nodeId int
리턴 NodeHead.NodeVersion[]

GetPropertyMappingInternal() 보호된 메소드

protected GetPropertyMappingInternal ( PropertyType propType ) : PropertyMapping
propType SenseNet.ContentRepository.Storage.Schema.PropertyType
리턴 PropertyMapping

GetScriptsForDatabaseBackup() 공개 메소드

public GetScriptsForDatabaseBackup ( ) : IEnumerable
리턴 IEnumerable

GetTimestampDataForOneNodeIntegrityCheck() 공개 메소드

public GetTimestampDataForOneNodeIntegrityCheck ( string path ) : IDataProcedure
path string
리턴 IDataProcedure

GetTimestampDataForRecursiveIntegrityCheck() 공개 메소드

public GetTimestampDataForRecursiveIntegrityCheck ( string path ) : IDataProcedure
path string
리턴 IDataProcedure

GetTreeSize() 보호된 메소드

protected GetTreeSize ( string path, bool includeChildren ) : long
path string
includeChildren bool
리턴 long

GetUserIdByUploadGuid() 보호된 메소드

protected GetUserIdByUploadGuid ( System.Guid uploadGuid ) : int
uploadGuid System.Guid
리턴 int

GetVersionNumbers() 보호된 메소드

protected GetVersionNumbers ( int nodeId ) : VersionNumber[]
nodeId int
리턴 VersionNumber[]

GetVersionNumbers() 보호된 메소드

protected GetVersionNumbers ( string path ) : VersionNumber[]
path string
리턴 VersionNumber[]

HasChild() 보호된 메소드

protected HasChild ( int nodeId ) : bool
nodeId int
리턴 bool

InitializeStagingBinaryData() 보호된 메소드

protected InitializeStagingBinaryData ( int versionId, int propertyTypeId, string fileName, long fileSize ) : int
versionId int
propertyTypeId int
fileName string
fileSize long
리턴 int

InstanceCount() 보호된 메소드

protected InstanceCount ( int nodeTypeIds ) : int
nodeTypeIds int
리턴 int

IsCacheableText() 보호된 메소드

protected IsCacheableText ( string text ) : bool
text string
리턴 bool

KeepOnlyLastIndexBackup() 보호된 메소드

protected KeepOnlyLastIndexBackup ( ) : void
리턴 void

LoadBinaryCacheEntity() 보호된 메소드

protected LoadBinaryCacheEntity ( int nodeVersionId, int propertyTypeId ) : BinaryCacheEntity
nodeVersionId int
propertyTypeId int
리턴 BinaryCacheEntity

LoadBinaryFragment() 보호된 메소드

protected LoadBinaryFragment ( int binaryPropertyId, long position, int count ) : byte[]
binaryPropertyId int
position long
count int
리턴 byte[]

LoadBinaryPropertyValue() 보호된 메소드

protected LoadBinaryPropertyValue ( int versionId, int propertyTypeId ) : Stream
versionId int
propertyTypeId int
리턴 Stream

LoadChildTypesToAllow() 보호된 메소드

protected LoadChildTypesToAllow ( int sourceNodeId ) : IEnumerable
sourceNodeId int
리턴 IEnumerable

LoadGroupMembership() 보호된 메소드

protected LoadGroupMembership ( int groupId ) : List
groupId int
리턴 List

LoadIndexDocumentByVersionId() 보호된 메소드

protected LoadIndexDocumentByVersionId ( IEnumerable versionId ) : IEnumerable
versionId IEnumerable
리턴 IEnumerable

LoadIndexDocumentByVersionId() 보호된 메소드

protected LoadIndexDocumentByVersionId ( int versionId ) : IndexDocumentData
versionId int
리턴 IndexDocumentData

LoadLastBackup() 보호된 메소드

protected LoadLastBackup ( ) : IndexBackup
리턴 IndexBackup

LoadMemberships() 보호된 메소드

protected LoadMemberships ( ) : List>.Dictionary
리턴 List>.Dictionary

LoadNodeHead() 보호된 메소드

protected LoadNodeHead ( int nodeId ) : NodeHead
nodeId int
리턴 NodeHead

LoadNodeHead() 보호된 메소드

protected LoadNodeHead ( string path ) : NodeHead
path string
리턴 NodeHead

LoadNodeHeadByVersionId() 보호된 메소드

protected LoadNodeHeadByVersionId ( int versionId ) : NodeHead
versionId int
리턴 NodeHead

LoadNodeHeads() 보호된 메소드

protected LoadNodeHeads ( IEnumerable heads ) : IEnumerable
heads IEnumerable
리턴 IEnumerable

LoadNodes() 보호된 메소드

protected LoadNodes ( NodeBuilder>.Dictionary buildersByVersionId ) : void
buildersByVersionId NodeBuilder>.Dictionary
리턴 void

LoadSchema() 보호된 메소드

protected LoadSchema ( ) : DataSet
리턴 System.Data.DataSet

LoadTextPropertyValue() 보호된 메소드

protected LoadTextPropertyValue ( int versionId, int propertyTypeId ) : string
versionId int
propertyTypeId int
리턴 string

MoveNodeTree() 보호된 메소드

protected MoveNodeTree ( int sourceNodeId, int targetNodeId ) : DataOperationResult
sourceNodeId int
targetNodeId int
리턴 DataOperationResult

NodeCount() 보호된 메소드

protected NodeCount ( string path ) : int
path string
리턴 int

NodeExistsInDatabase() 보호된 메소드

protected NodeExistsInDatabase ( string path ) : bool
path string
리턴 bool

PersistUploadToken() 보호된 메소드

protected PersistUploadToken ( UploadToken value ) : void
value SenseNet.ContentRepository.Storage.ApplicationMessaging.UploadToken
리턴 void

QueryNodesByPath() 보호된 메소드

protected QueryNodesByPath ( string pathStart, bool orderByPath ) : IEnumerable
pathStart string
orderByPath bool
리턴 IEnumerable

QueryNodesByReferenceAndType() 보호된 메소드

protected QueryNodesByReferenceAndType ( string referenceName, int referredNodeId, int allowedTypeIds ) : IEnumerable
referenceName string
referredNodeId int
allowedTypeIds int
리턴 IEnumerable

QueryNodesByType() 보호된 메소드

protected QueryNodesByType ( int nodeTypeIds ) : IEnumerable
nodeTypeIds int
리턴 IEnumerable

QueryNodesByTypeAndPath() 보호된 메소드

protected QueryNodesByTypeAndPath ( int nodeTypeIds, string pathStart, bool orderByPath ) : IEnumerable
nodeTypeIds int
pathStart string
orderByPath bool
리턴 IEnumerable

QueryNodesByTypeAndPathAndName() 보호된 메소드

protected QueryNodesByTypeAndPathAndName ( int nodeTypeIds, string pathStart, bool orderByPath, string name ) : IEnumerable
nodeTypeIds int
pathStart string
orderByPath bool
name string
리턴 IEnumerable

QueryNodesByTypeAndPathAndProperty() 보호된 메소드

protected QueryNodesByTypeAndPathAndProperty ( int nodeTypeIds, string pathStart, bool orderByPath, List properties ) : IEnumerable
nodeTypeIds int
pathStart string
orderByPath bool
properties List
리턴 IEnumerable

RecoverIndexBackup() 보호된 메소드

protected RecoverIndexBackup ( string backupFilePath ) : IndexBackup
backupFilePath string
리턴 IndexBackup

RemoveBreakInheritance() 보호된 메소드

protected RemoveBreakInheritance ( int nodeId ) : void
nodeId int
리턴 void

Reset() 보호된 메소드

protected Reset ( ) : void
리턴 void

SaveChunk() 보호된 메소드

protected SaveChunk ( int stagingBinaryDataId, byte bytes, int offset ) : void
stagingBinaryDataId int
bytes byte
offset int
리턴 void

SecureSqlStringValue() 공개 정적인 메소드

SQL injection prevention.
public static SecureSqlStringValue ( string value ) : string
value string String value that will changed to.
리턴 string

SetActiveBackup() 보호된 메소드

protected SetActiveBackup ( IndexBackup backup, IndexBackup lastBackup ) : void
backup IndexBackup
lastBackup IndexBackup
리턴 void

SetPermission() 보호된 메소드

protected SetPermission ( SecurityEntry entry ) : void
entry SenseNet.ContentRepository.Storage.Security.SecurityEntry
리턴 void

SetPermission() 보호된 메소드

protected SetPermission ( int principalId, int nodeId, PermissionType permissionType, bool isInheritable, PermissionValue permissionValue ) : void
principalId int
nodeId int
permissionType SenseNet.ContentRepository.Storage.Schema.PermissionType
isInheritable bool
permissionValue PermissionValue
리턴 void

SqlProvider() 공개 메소드

public SqlProvider ( ) : System
리턴 System

StoreBackupStream() 보호된 메소드

protected StoreBackupStream ( string backupFilePath, IndexBackup backup, IndexBackupProgress progress ) : void
backupFilePath string
backup IndexBackup
progress IndexBackupProgress
리턴 void

UpdateIndexDocument() 보호된 메소드

protected UpdateIndexDocument ( NodeData nodeData, byte indexDocumentBytes ) : void
nodeData NodeData
indexDocumentBytes byte
리턴 void

VersionCount() 보호된 메소드

protected VersionCount ( string path ) : int
path string
리턴 int