C# Class OpenSim.Data.MySQL.MySQLInventoryData

A MySQL interface for the inventory server

Inheritance: IInventoryDataPlugin

Datei anzeigen Open project: N3X15/VoxelSim

Public Methods

Method	Description
Dispose ( ) : void	Closes this DB provider do nothing
Initialise ( ) : void
Initialise ( string connect ) : void	Initialises Inventory interface Loads and initialises the MySQL storage plugin warns and uses the obsolete mysql_connection.ini if connect string is empty. Check for migration
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	Deletes an inventory folder
deleteInventoryItem ( UUID itemID ) : void	Detele the specified inventory item
fetchActiveGestures ( UUID avatarID ) : List
getFolderHierarchy ( UUID parentID ) : List	See IInventoryDataPlugin
getInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase	Returns a specified inventory folder
getInventoryFolders ( UUID parentID ) : List	Return a list of folders in a users inventory contained within the specified folder. This method is only used in tests - in normal operation the user always have one, and only one, root folder.
getInventoryInFolder ( UUID folderID ) : List	Returns a list of items in a specified folder
getInventoryItem ( UUID itemID ) : InventoryItemBase	Returns a specified inventory item
getUserRootFolder ( UUID user ) : InventoryFolderBase	see InventoryItemBase.getUserRootFolder
getUserRootFolders ( UUID user ) : List	Returns a list of the root folders within a users inventory
moveInventoryFolder ( InventoryFolderBase folder ) : void	Move an inventory folder UPDATE inventoryfolders SET parentFolderID=?parentFolderID WHERE folderID=?folderID
queryInventoryFolder ( UUID folderID ) : InventoryFolderBase
queryInventoryItem ( UUID itemID ) : InventoryItemBase
updateInventoryFolder ( InventoryFolderBase folder ) : void	Updates an inventory folder
updateInventoryItem ( InventoryItemBase item ) : void	Updates the specified inventory item

Protected Methods

Method	Description
deleteItemsInFolder ( UUID folderID ) : void	Delete all item in a folder
deleteOneFolder ( UUID folderID ) : void	Delete a folder from database
getInventoryFolders ( List &folders, UUID parentID ) : void	Append a list of all the child folders of a parent folder
readInventoryFolder ( MySqlDataReader reader ) : InventoryFolderBase	Reads a list of inventory folders returned by a query.

Private Methods

Method	Description
readInventoryItem ( MySqlDataReader reader ) : InventoryItemBase	Reads a one item from an SQL result

Method Details

Dispose() public method

Closes this DB provider

do nothing

public Dispose ( ) : void
return	void

Initialise() public method

public Initialise ( ) : void
return	void

Initialise() public method

Initialises Inventory interface

Loads and initialises the MySQL storage plugin warns and uses the obsolete mysql_connection.ini if connect string is empty. Check for migration

public Initialise ( string connect ) : void
connect	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

Deletes an inventory folder

public deleteInventoryFolder ( UUID folderID ) : void
folderID	UUID
return	void

deleteInventoryItem() public method

Detele the specified inventory item

public deleteInventoryItem ( UUID itemID ) : void
itemID	UUID
return	void

deleteItemsInFolder() protected method

Delete all item in a folder

protected deleteItemsInFolder ( UUID folderID ) : void
folderID	UUID	the folder UUID
return	void

deleteOneFolder() protected method

Delete a folder from database

protected deleteOneFolder ( UUID folderID ) : void
folderID	UUID	the folder UUID
return	void

fetchActiveGestures() public method

public fetchActiveGestures ( UUID avatarID ) : List
avatarID	UUID
return	List

getFolderHierarchy() public method

See IInventoryDataPlugin

public getFolderHierarchy ( UUID parentID ) : List
parentID	UUID
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

Return a list of folders in a users inventory contained within the specified folder. This method is only used in tests - in normal operation the user always have one, and only one, root folder.

public getInventoryFolders ( UUID parentID ) : List
parentID	UUID	The folder to search
return	List

getInventoryFolders() protected method

Append a list of all the child folders of a parent folder

protected getInventoryFolders ( List &folders, UUID parentID ) : void
folders	List	list where folders will be appended
parentID	UUID	ID of parent
return	void

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 ) : InventoryItemBase
itemID	UUID
return	InventoryItemBase

getUserRootFolder() public method

see InventoryItemBase.getUserRootFolder

public getUserRootFolder ( UUID user ) : InventoryFolderBase
user	UUID	The user UUID
return	InventoryFolderBase

getUserRootFolders() public method

Returns a list of the root folders within a users inventory

public getUserRootFolders ( UUID user ) : List
user	UUID	The user whose inventory is to be searched
return	List

moveInventoryFolder() public method

Move an inventory folder

UPDATE inventoryfolders SET parentFolderID=?parentFolderID WHERE folderID=?folderID

public moveInventoryFolder ( InventoryFolderBase folder ) : void
folder	InventoryFolderBase	Folder to move
return	void

queryInventoryFolder() public method

public queryInventoryFolder ( UUID folderID ) : InventoryFolderBase
folderID	UUID
return	InventoryFolderBase

queryInventoryItem() public method

public queryInventoryItem ( UUID itemID ) : InventoryItemBase
itemID	UUID
return	InventoryItemBase

readInventoryFolder() protected static method

Reads a list of inventory folders returned by a query.

protected static readInventoryFolder ( MySqlDataReader reader ) : InventoryFolderBase
reader	MySqlDataReader	A MySQL Data Reader
return	InventoryFolderBase

updateInventoryFolder() public method

Updates an inventory folder

public updateInventoryFolder ( InventoryFolderBase folder ) : void
folder	InventoryFolderBase	Folder to update
return	void

updateInventoryItem() public method

Updates the specified inventory item

public updateInventoryItem ( InventoryItemBase item ) : void
item	InventoryItemBase	Inventory item to update
return	void