C# Class OpenSim.Data.MySQL.MySQLInventoryData

A MySQL interface for the inventory server
Inheritance: IInventoryDataPlugin
Mostrar archivo 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