C# Class OpenSim.Data.MSSQL.MSSQLInventoryData

A MSSQL interface for the inventory server
Inheritance: IInventoryDataPlugin
Afficher le fichier Open project: openmetaversefoundation/fortis-opensim

Méthodes publiques

Méthode Description
Dispose ( ) : void

Closes this DB provider

Initialise ( string connectionString ) : void

Loads and initialises the MSSQL inventory storage interface

addInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void

Creates a new inventory folder

addInventoryItem ( OpenSim.Framework.InventoryItemBase item ) : void

Adds a specified item to the database

deleteInventoryFolder ( UUID folderID ) : void

Delete an inventory folder

deleteInventoryItem ( UUID itemID ) : void

Delete an item in inventory database

fetchActiveGestures ( UUID avatarID ) : List

Returns all activated gesture-items in the inventory of the specified avatar.

getFolderHierarchy ( UUID parentID ) : List

Returns all child folders in the hierarchy from the parent folder and down. Does not return the parent folder itself.

getInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase

Returns a specified inventory folder

getInventoryFolders ( UUID parentID ) : List

Returns a list of folders in a users inventory contained within the specified folder

getInventoryInFolder ( UUID folderID ) : List

Returns a list of items in a specified folder

getInventoryItem ( UUID itemID ) : OpenSim.Framework.InventoryItemBase

Returns a specified inventory item

getUserRootFolder ( UUID user ) : OpenSim.Framework.InventoryFolderBase

see InventoryItemBase.getUserRootFolder

getUserRootFolders ( UUID user ) : List

Returns a list of the root folders within a users inventory

moveInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void

Updates an inventory folder

queryInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase
queryInventoryItem ( UUID itemID ) : OpenSim.Framework.InventoryItemBase
updateInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void

Updates an inventory folder

updateInventoryItem ( OpenSim.Framework.InventoryItemBase item ) : void

Updates the specified inventory item

Méthodes protégées

Méthode Description
readInventoryFolder ( System.Data.SqlClient.SqlDataReader reader ) : OpenSim.Framework.InventoryFolderBase

Reads a list of inventory folders returned by a query.

Private Methods

Méthode Description
DeleteItemsInFolder ( UUID folderID, SqlConnection connection ) : void

Delete an item in inventory database

DeleteOneFolder ( UUID folderID, SqlConnection connection ) : void

Delete a folder in inventory databasae

Initialise ( ) : void
getFolderHierarchy ( UUID parentID, SqlCommand command ) : List

Gets the folder hierarchy in a loop.

getInventoryFolders ( SqlCommand command ) : List

Gets the inventory folders.

getInventoryFolders ( UUID parentID, UUID user ) : List

Gets the inventory folders.

readInventoryItem ( IDataRecord reader ) : OpenSim.Framework.InventoryItemBase

Reads a one item from an SQL result

Method Details

Dispose() public méthode

Closes this DB provider
public Dispose ( ) : void
Résultat void

Initialise() public méthode

Loads and initialises the MSSQL inventory storage interface
public Initialise ( string connectionString ) : void
connectionString string connect string
Résultat void

addInventoryFolder() public méthode

Creates a new inventory folder
public addInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void
folder OpenSim.Framework.InventoryFolderBase Folder to create
Résultat void

addInventoryItem() public méthode

Adds a specified item to the database
public addInventoryItem ( OpenSim.Framework.InventoryItemBase item ) : void
item OpenSim.Framework.InventoryItemBase The inventory item
Résultat void

deleteInventoryFolder() public méthode

Delete an inventory folder
public deleteInventoryFolder ( UUID folderID ) : void
folderID UUID Id of folder to delete
Résultat void

deleteInventoryItem() public méthode

Delete an item in inventory database
public deleteInventoryItem ( UUID itemID ) : void
itemID UUID the item UUID
Résultat void

fetchActiveGestures() public méthode

Returns all activated gesture-items in the inventory of the specified avatar.
public fetchActiveGestures ( UUID avatarID ) : List
avatarID UUID The of the avatar
Résultat List

getFolderHierarchy() public méthode

Returns all child folders in the hierarchy from the parent folder and down. Does not return the parent folder itself.
public getFolderHierarchy ( UUID parentID ) : List
parentID UUID The folder to get subfolders for
Résultat List

getInventoryFolder() public méthode

Returns a specified inventory folder
public getInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase
folderID UUID The folder to return
Résultat OpenSim.Framework.InventoryFolderBase

getInventoryFolders() public méthode

Returns a list of folders in a users inventory contained within the specified folder
public getInventoryFolders ( UUID parentID ) : List
parentID UUID The folder to search
Résultat List

getInventoryInFolder() public méthode

Returns a list of items in a specified folder
public getInventoryInFolder ( UUID folderID ) : List
folderID UUID The folder to search
Résultat List

getInventoryItem() public méthode

Returns a specified inventory item
public getInventoryItem ( UUID itemID ) : OpenSim.Framework.InventoryItemBase
itemID UUID The item ID
Résultat OpenSim.Framework.InventoryItemBase

getUserRootFolder() public méthode

see InventoryItemBase.getUserRootFolder
public getUserRootFolder ( UUID user ) : OpenSim.Framework.InventoryFolderBase
user UUID the User UUID
Résultat OpenSim.Framework.InventoryFolderBase

getUserRootFolders() public méthode

Returns a list of the root folders within a users inventory
public getUserRootFolders ( UUID user ) : List
user UUID The user whos inventory is to be searched
Résultat List

moveInventoryFolder() public méthode

Updates an inventory folder
public moveInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void
folder OpenSim.Framework.InventoryFolderBase Folder to update
Résultat void

queryInventoryFolder() public méthode

public queryInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase
folderID UUID
Résultat OpenSim.Framework.InventoryFolderBase

queryInventoryItem() public méthode

public queryInventoryItem ( UUID itemID ) : OpenSim.Framework.InventoryItemBase
itemID UUID
Résultat OpenSim.Framework.InventoryItemBase

readInventoryFolder() protected static méthode

Reads a list of inventory folders returned by a query.
protected static readInventoryFolder ( System.Data.SqlClient.SqlDataReader reader ) : OpenSim.Framework.InventoryFolderBase
reader System.Data.SqlClient.SqlDataReader A MSSQL Data Reader
Résultat OpenSim.Framework.InventoryFolderBase

updateInventoryFolder() public méthode

Updates an inventory folder
public updateInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void
folder OpenSim.Framework.InventoryFolderBase Folder to update
Résultat void

updateInventoryItem() public méthode

Updates the specified inventory item
public updateInventoryItem ( OpenSim.Framework.InventoryItemBase item ) : void
item OpenSim.Framework.InventoryItemBase Inventory item to update
Résultat void