C# Class OpenSim.Data.MSSQL.MSSQLInventoryData

A MSSQL interface for the inventory server
Inheritance: IInventoryDataPlugin
Datei anzeigen Open project: openmetaversefoundation/fortis-opensim

Public Methods

Method 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

Protected Methods

Method Description
readInventoryFolder ( System.Data.SqlClient.SqlDataReader reader ) : OpenSim.Framework.InventoryFolderBase

Reads a list of inventory folders returned by a query.

Private Methods

Method 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 method

Closes this DB provider
public Dispose ( ) : void
return void

Initialise() public method

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

addInventoryFolder() public method

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

addInventoryItem() public method

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

deleteInventoryFolder() public method

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

deleteInventoryItem() public method

Delete an item in inventory database
public deleteInventoryItem ( UUID itemID ) : void
itemID UUID the item UUID
return void

fetchActiveGestures() public method

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

getFolderHierarchy() public method

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
return List

getInventoryFolder() public method

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

getInventoryFolders() public method

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
return List

getInventoryInFolder() public method

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

getInventoryItem() public method

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

getUserRootFolder() public method

see InventoryItemBase.getUserRootFolder
public getUserRootFolder ( UUID user ) : OpenSim.Framework.InventoryFolderBase
user UUID the User UUID
return OpenSim.Framework.InventoryFolderBase

getUserRootFolders() public method

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
return List

moveInventoryFolder() public method

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

queryInventoryFolder() public method

public queryInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase
folderID UUID
return OpenSim.Framework.InventoryFolderBase

queryInventoryItem() public method

public queryInventoryItem ( UUID itemID ) : OpenSim.Framework.InventoryItemBase
itemID UUID
return OpenSim.Framework.InventoryItemBase

readInventoryFolder() protected static method

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
return OpenSim.Framework.InventoryFolderBase

updateInventoryFolder() public method

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

updateInventoryItem() public method

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