C# Class SenseNet.ContentRepository.Storage.Data.SqlClient.SqlProvider

Inheritance: DataProvider

Afficher le fichier Open project: maxpavlov/FlexNet

Méthodes publiques

Méthode	Description
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

Méthodes protégées

Méthode	Description
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

Private Methods

Méthode	Description
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

Method Details

AssertSchemaTimestampAndWriteModificationDate() public méthode

public AssertSchemaTimestampAndWriteModificationDate ( long timestamp ) : void
timestamp	long
Résultat	void

BreakInheritance() protected méthode

protected BreakInheritance ( int nodeId ) : void
nodeId	int
Résultat	void

CheckScriptInternal() protected méthode

protected CheckScriptInternal ( string commandText ) : void
commandText	string
Résultat	void

CopyStagingToBinaryData() protected méthode

protected CopyStagingToBinaryData ( int versionId, int propertyTypeId, int stagingBinaryDataId, string checksum ) : void
versionId	int
propertyTypeId	int
stagingBinaryDataId	int
checksum	string
Résultat	void

CreateBackup() protected méthode

protected CreateBackup ( int backupNumber ) : IndexBackup
backupNumber	int
Résultat	IndexBackup

CreateDataProcedureInternal() protected méthode

protected CreateDataProcedureInternal ( string commandText ) : IDataProcedure
commandText	string
Résultat	IDataProcedure

CreateLoadIndexDocumentCollectionByPathProcedure() protected méthode

protected CreateLoadIndexDocumentCollectionByPathProcedure ( string path ) : IDataProcedure
path	string
Résultat	IDataProcedure

CreateNodeWriter() protected méthode

protected CreateNodeWriter ( ) : INodeWriter
Résultat	INodeWriter

CreateParameterInternal() protected méthode

protected CreateParameterInternal ( ) : IDbDataParameter
Résultat	IDbDataParameter

CreateSchemaWriter() protected méthode

protected CreateSchemaWriter ( ) : SchemaWriter
Résultat	SenseNet.ContentRepository.Storage.Schema.SchemaWriter

CreateTransaction() protected méthode

protected CreateTransaction ( ) : ITransactionProvider
Résultat	ITransactionProvider

DeleteNodeTree() protected méthode

protected DeleteNodeTree ( int nodeId ) : DataOperationResult
nodeId	int
Résultat	DataOperationResult

DeleteNodeTreePsychical() protected méthode

protected DeleteNodeTreePsychical ( int nodeId ) : DataOperationResult
nodeId	int
Résultat	DataOperationResult

DeleteStagingBinaryData() protected méthode

protected DeleteStagingBinaryData ( int stagingBinaryDataId ) : void
stagingBinaryDataId	int
Résultat	void

DeleteVersion() protected méthode

protected DeleteVersion ( int versionId, NodeData nodeData, int &lastMajorVersionId, int &lastMinorVersionId ) : void
versionId	int
nodeData	NodeData
lastMajorVersionId	int
lastMinorVersionId	int
Résultat	void

ExplicateGroupMemberships() protected méthode

protected ExplicateGroupMemberships ( ) : void
Résultat	void

ExplicateOrganizationUnitMemberships() protected méthode

protected ExplicateOrganizationUnitMemberships ( IUser user ) : void
user	IUser
Résultat	void

GetAppModelScriptPrivate() protected méthode

protected GetAppModelScriptPrivate ( IEnumerable paths, bool resolveAll, bool resolveChildren ) : string
paths	IEnumerable
resolveAll	bool
resolveChildren	bool
Résultat	string

GetChildrenIdentfiers() protected méthode

protected GetChildrenIdentfiers ( int nodeId ) : IEnumerable
nodeId	int
Résultat	IEnumerable

GetContentListTypesInTree() protected méthode

protected GetContentListTypesInTree ( string path ) : List
path	string
Résultat	List

GetIdsOfNodesThatDoNotHaveIndexDocument() protected méthode

protected GetIdsOfNodesThatDoNotHaveIndexDocument ( ) : IEnumerable
Résultat	IEnumerable

GetIndexDocumentDataFromReader() protected méthode

protected GetIndexDocumentDataFromReader ( System reader ) : IndexDocumentData
reader	System
Résultat	IndexDocumentData

GetLastActivityId() public méthode

public GetLastActivityId ( ) : int
Résultat	int

GetLastIndexBackupNumber() protected méthode

protected GetLastIndexBackupNumber ( ) : System.Guid
Résultat	System.Guid

GetNameOfLastNodeWithNameBase() public méthode

public GetNameOfLastNodeWithNameBase ( int parentId, string namebase, string extension ) : string
parentId	int
namebase	string
extension	string
Résultat	string

GetNodeVersions() protected méthode

protected GetNodeVersions ( int nodeId ) : NodeHead.NodeVersion[]
nodeId	int
Résultat	NodeHead.NodeVersion[]

GetPropertyMappingInternal() protected méthode

protected GetPropertyMappingInternal ( PropertyType propType ) : PropertyMapping
propType	SenseNet.ContentRepository.Storage.Schema.PropertyType
Résultat	PropertyMapping

GetScriptsForDatabaseBackup() public méthode

public GetScriptsForDatabaseBackup ( ) : IEnumerable
Résultat	IEnumerable

GetTimestampDataForOneNodeIntegrityCheck() public méthode

public GetTimestampDataForOneNodeIntegrityCheck ( string path ) : IDataProcedure
path	string
Résultat	IDataProcedure

GetTimestampDataForRecursiveIntegrityCheck() public méthode

public GetTimestampDataForRecursiveIntegrityCheck ( string path ) : IDataProcedure
path	string
Résultat	IDataProcedure

GetTreeSize() protected méthode

protected GetTreeSize ( string path, bool includeChildren ) : long
path	string
includeChildren	bool
Résultat	long

GetUserIdByUploadGuid() protected méthode

protected GetUserIdByUploadGuid ( System.Guid uploadGuid ) : int
uploadGuid	System.Guid
Résultat	int

GetVersionNumbers() protected méthode

protected GetVersionNumbers ( int nodeId ) : VersionNumber[]
nodeId	int
Résultat	VersionNumber[]

GetVersionNumbers() protected méthode

protected GetVersionNumbers ( string path ) : VersionNumber[]
path	string
Résultat	VersionNumber[]

HasChild() protected méthode

protected HasChild ( int nodeId ) : bool
nodeId	int
Résultat	bool

InitializeStagingBinaryData() protected méthode

protected InitializeStagingBinaryData ( int versionId, int propertyTypeId, string fileName, long fileSize ) : int
versionId	int
propertyTypeId	int
fileName	string
fileSize	long
Résultat	int

InstanceCount() protected méthode

protected InstanceCount ( int nodeTypeIds ) : int
nodeTypeIds	int
Résultat	int

IsCacheableText() protected méthode

protected IsCacheableText ( string text ) : bool
text	string
Résultat	bool

KeepOnlyLastIndexBackup() protected méthode

protected KeepOnlyLastIndexBackup ( ) : void
Résultat	void

LoadBinaryCacheEntity() protected méthode

protected LoadBinaryCacheEntity ( int nodeVersionId, int propertyTypeId ) : BinaryCacheEntity
nodeVersionId	int
propertyTypeId	int
Résultat	BinaryCacheEntity

LoadBinaryFragment() protected méthode

protected LoadBinaryFragment ( int binaryPropertyId, long position, int count ) : byte[]
binaryPropertyId	int
position	long
count	int
Résultat	byte[]

LoadBinaryPropertyValue() protected méthode

protected LoadBinaryPropertyValue ( int versionId, int propertyTypeId ) : Stream
versionId	int
propertyTypeId	int
Résultat	Stream

LoadChildTypesToAllow() protected méthode

protected LoadChildTypesToAllow ( int sourceNodeId ) : IEnumerable
sourceNodeId	int
Résultat	IEnumerable

LoadGroupMembership() protected méthode

protected LoadGroupMembership ( int groupId ) : List
groupId	int
Résultat	List

LoadIndexDocumentByVersionId() protected méthode

protected LoadIndexDocumentByVersionId ( IEnumerable versionId ) : IEnumerable
versionId	IEnumerable
Résultat	IEnumerable

LoadIndexDocumentByVersionId() protected méthode

protected LoadIndexDocumentByVersionId ( int versionId ) : IndexDocumentData
versionId	int
Résultat	IndexDocumentData

LoadLastBackup() protected méthode

protected LoadLastBackup ( ) : IndexBackup
Résultat	IndexBackup

LoadMemberships() protected méthode

protected LoadMemberships ( ) : List>.Dictionary
Résultat	List>.Dictionary

LoadNodeHead() protected méthode

protected LoadNodeHead ( int nodeId ) : NodeHead
nodeId	int
Résultat	NodeHead

LoadNodeHead() protected méthode

protected LoadNodeHead ( string path ) : NodeHead
path	string
Résultat	NodeHead

LoadNodeHeadByVersionId() protected méthode

protected LoadNodeHeadByVersionId ( int versionId ) : NodeHead
versionId	int
Résultat	NodeHead

LoadNodeHeads() protected méthode

protected LoadNodeHeads ( IEnumerable heads ) : IEnumerable
heads	IEnumerable
Résultat	IEnumerable

LoadNodes() protected méthode

protected LoadNodes ( NodeBuilder>.Dictionary buildersByVersionId ) : void
buildersByVersionId	NodeBuilder>.Dictionary
Résultat	void

LoadSchema() protected méthode

protected LoadSchema ( ) : DataSet
Résultat	System.Data.DataSet

LoadTextPropertyValue() protected méthode

protected LoadTextPropertyValue ( int versionId, int propertyTypeId ) : string
versionId	int
propertyTypeId	int
Résultat	string

MoveNodeTree() protected méthode

protected MoveNodeTree ( int sourceNodeId, int targetNodeId ) : DataOperationResult
sourceNodeId	int
targetNodeId	int
Résultat	DataOperationResult

NodeCount() protected méthode

protected NodeCount ( string path ) : int
path	string
Résultat	int

NodeExistsInDatabase() protected méthode

protected NodeExistsInDatabase ( string path ) : bool
path	string
Résultat	bool

PersistUploadToken() protected méthode

protected PersistUploadToken ( UploadToken value ) : void
value	SenseNet.ContentRepository.Storage.ApplicationMessaging.UploadToken
Résultat	void

QueryNodesByPath() protected méthode

protected QueryNodesByPath ( string pathStart, bool orderByPath ) : IEnumerable
pathStart	string
orderByPath	bool
Résultat	IEnumerable

QueryNodesByReferenceAndType() protected méthode

protected QueryNodesByReferenceAndType ( string referenceName, int referredNodeId, int allowedTypeIds ) : IEnumerable
referenceName	string
referredNodeId	int
allowedTypeIds	int
Résultat	IEnumerable

QueryNodesByType() protected méthode

protected QueryNodesByType ( int nodeTypeIds ) : IEnumerable
nodeTypeIds	int
Résultat	IEnumerable

QueryNodesByTypeAndPath() protected méthode

protected QueryNodesByTypeAndPath ( int nodeTypeIds, string pathStart, bool orderByPath ) : IEnumerable
nodeTypeIds	int
pathStart	string
orderByPath	bool
Résultat	IEnumerable

QueryNodesByTypeAndPathAndName() protected méthode

protected QueryNodesByTypeAndPathAndName ( int nodeTypeIds, string pathStart, bool orderByPath, string name ) : IEnumerable
nodeTypeIds	int
pathStart	string
orderByPath	bool
name	string
Résultat	IEnumerable

QueryNodesByTypeAndPathAndProperty() protected méthode

protected QueryNodesByTypeAndPathAndProperty ( int nodeTypeIds, string pathStart, bool orderByPath, List properties ) : IEnumerable
nodeTypeIds	int
pathStart	string
orderByPath	bool
properties	List
Résultat	IEnumerable

RecoverIndexBackup() protected méthode

protected RecoverIndexBackup ( string backupFilePath ) : IndexBackup
backupFilePath	string
Résultat	IndexBackup

RemoveBreakInheritance() protected méthode

protected RemoveBreakInheritance ( int nodeId ) : void
nodeId	int
Résultat	void

Reset() protected méthode

protected Reset ( ) : void
Résultat	void

SaveChunk() protected méthode

protected SaveChunk ( int stagingBinaryDataId, byte bytes, int offset ) : void
stagingBinaryDataId	int
bytes	byte
offset	int
Résultat	void

SecureSqlStringValue() public static méthode

SQL injection prevention.

public static SecureSqlStringValue ( string value ) : string
value	string	String value that will changed to.
Résultat	string

SetActiveBackup() protected méthode

protected SetActiveBackup ( IndexBackup backup, IndexBackup lastBackup ) : void
backup	IndexBackup
lastBackup	IndexBackup
Résultat	void

SetPermission() protected méthode

protected SetPermission ( SecurityEntry entry ) : void
entry	SenseNet.ContentRepository.Storage.Security.SecurityEntry
Résultat	void

SetPermission() protected méthode

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
Résultat	void

SqlProvider() public méthode

public SqlProvider ( ) : System
Résultat	System

StoreBackupStream() protected méthode

protected StoreBackupStream ( string backupFilePath, IndexBackup backup, IndexBackupProgress progress ) : void
backupFilePath	string
backup	IndexBackup
progress	IndexBackupProgress
Résultat	void

UpdateIndexDocument() protected méthode

protected UpdateIndexDocument ( NodeData nodeData, byte indexDocumentBytes ) : void
nodeData	NodeData
indexDocumentBytes	byte
Résultat	void

VersionCount() protected méthode

protected VersionCount ( string path ) : int
path	string
Résultat	int