2 files changed, 1043 insertions, 1043 deletions

diff --git a/OpenSim/Tests/Inventory/Properties/AssemblyInfo.cs b/OpenSim/Tests/Inventory/Properties/AssemblyInfo.cs
index dd537a5..cb89a71 100644
--- a/OpenSim/Tests/Inventory/Properties/AssemblyInfo.cs
+++ b/OpenSim/Tests/Inventory/Properties/AssemblyInfo.cs
@@ -1,35 +1,35 @@
-using System.Reflection;

-using System.Runtime.CompilerServices;

-using System.Runtime.InteropServices;

-

-// General Information about an assembly is controlled through the following 

-// set of attributes. Change these attribute values to modify the information

-// associated with an assembly.

-[assembly: AssemblyTitle("Inventory")]

-[assembly: AssemblyDescription("")]

-[assembly: AssemblyConfiguration("")]

-[assembly: AssemblyCompany("Lauridsen")]

-[assembly: AssemblyProduct("Inventory")]

-[assembly: AssemblyCopyright("Copyright © Lauridsen 2007")]

-[assembly: AssemblyTrademark("")]

-[assembly: AssemblyCulture("")]

-

-// Setting ComVisible to false makes the types in this assembly not visible 

-// to COM components.  If you need to access a type in this assembly from 

-// COM, set the ComVisible attribute to true on that type.

-[assembly: ComVisible(false)]

-

-// The following GUID is for the ID of the typelib if this project is exposed to COM

-[assembly: Guid("2330add7-08a2-4f33-9ab8-74894fe7e3dd")]

-

-// Version information for an assembly consists of the following four values:

-//

-//      Major Version

-//      Minor Version 

-//      Build Number

-//      Revision

-//

-// You can specify all the values or you can default the Revision and Build Numbers 

-// by using the '*' as shown below:

-[assembly: AssemblyVersion("1.0.0.0")]

-[assembly: AssemblyFileVersion("1.0.0.0")]

+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// General Information about an assembly is controlled through the following 
+// set of attributes. Change these attribute values to modify the information
+// associated with an assembly.
+[assembly: AssemblyTitle("Inventory")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("Lauridsen")]
+[assembly: AssemblyProduct("Inventory")]
+[assembly: AssemblyCopyright("Copyright © Lauridsen 2007")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// Setting ComVisible to false makes the types in this assembly not visible 
+// to COM components.  If you need to access a type in this assembly from 
+// COM, set the ComVisible attribute to true on that type.
+[assembly: ComVisible(false)]
+
+// The following GUID is for the ID of the typelib if this project is exposed to COM
+[assembly: Guid("2330add7-08a2-4f33-9ab8-74894fe7e3dd")]
+
+// Version information for an assembly consists of the following four values:
+//
+//      Major Version
+//      Minor Version 
+//      Build Number
+//      Revision
+//
+// You can specify all the values or you can default the Revision and Build Numbers 
+// by using the '*' as shown below:
+[assembly: AssemblyVersion("1.0.0.0")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
diff --git a/OpenSim/Tests/Inventory/TestInventory.cs b/OpenSim/Tests/Inventory/TestInventory.cs
index 7f1ded8..f9a791f 100644
--- a/OpenSim/Tests/Inventory/TestInventory.cs
+++ b/OpenSim/Tests/Inventory/TestInventory.cs
@@ -1,1008 +1,1008 @@
-/*

-* Copyright (c) Contributors, http://opensimulator.org/

-* See CONTRIBUTORS.TXT for a full list of copyright holders.

-*

-* Redistribution and use in source and binary forms, with or without

-* modification, are permitted provided that the following conditions are met:

-*     * Redistributions of source code must retain the above copyright

-*       notice, this list of conditions and the following disclaimer.

-*     * Redistributions in binary form must reproduce the above copyright

-*       notice, this list of conditions and the following disclaimer in the

-*       documentation and/or other materials provided with the distribution.

-*     * Neither the name of the OpenSim Project nor the

-*       names of its contributors may be used to endorse or promote products

-*       derived from this software without specific prior written permission.

-*

-* THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS AS IS AND ANY

-* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

-* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE

-* DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY

-* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES

-* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;

-* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND

-* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT

-* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

-* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

-* 

-*/

-

-using System;

-using System.Collections.Generic;

-using System.Text;

-using NUnit.Framework;

-

-using libsecondlife;

-using OpenSim.Framework.Types;

-using OpenSim.Framework.Data;

-using OpenSim.Framework.Data.SQLite;

-using OpenSim.Framework.Data.MySQL;

-using OpenSim.Framework.Console;

-

-namespace OpenSim.Test.Inventory

-{

-    [TestFixture]

-    public class TestInventory

-    {

-        IInventoryData _dbPlugin;

-        LLUUID _agent_1_id;

-        public static LLUUID LibraryFolderRootUuid = new LLUUID("5926de2a-c2d7-4c11-ac4e-74512ffeb6d1");

-

-        Random _rnd = new Random((int)DateTime.Now.Ticks);

-

-        [TestFixtureSetUp]

-        public void SetupInventoryTest()

-        {

-

-            _agent_1_id = LLUUID.Random();

-

-            MainLog.Instance = new LogBase("UnitTest.log", "TEST", null, true);

-//            _dbPlugin = new SQLiteInventoryStore();

-            _dbPlugin = new MySQLInventoryData();

-            _dbPlugin.Initialise();

-        }

-

-        [TestFixtureTearDown]

-        public void TeardownInventoryTest()

-        {

-            _dbPlugin.Close();

-        }

-

-        private bool AreFoldersIdentical(InventoryFolderBase a, InventoryFolderBase b)

-        {

-            if (a.agentID != b.agentID) return false;

-            if (a.folderID != b.folderID) return false;

-            if (a.name != b.name) return false;

-            if (a.parentID != b.parentID) return false;

-            if (a.type != b.type) return false;

-            if (a.version != b.version) return false;

-            return true;

-        }

-

-        private bool AreItemsIdentical(InventoryItemBase a, InventoryItemBase b)

-        {

-            if (a.assetID != b.assetID) return false;

-            if (a.assetType != b.assetType) return false;

-            if (a.avatarID != b.avatarID) return false;

-            if (a.creatorsID != b.creatorsID) return false;

-            if (a.inventoryBasePermissions != b.inventoryBasePermissions) return false;

-            if (a.inventoryCurrentPermissions != b.inventoryCurrentPermissions) return false;

-            if (a.inventoryEveryOnePermissions != b.inventoryEveryOnePermissions) return false;

-            if (a.inventoryNextPermissions != b.inventoryNextPermissions) return false;

-            if (a.inventoryID != b.inventoryID) return false;

-            if (a.inventoryDescription != b.inventoryDescription) return false;

-            if (a.inventoryName != b.inventoryName) return false;

-            if (a.invType != b.invType) return false;

-            if (a.parentFolderID != b.parentFolderID) return false;

-            return true;

-        }

-        

-        /// <summary>

-        /// Test that we can insert a root folder

-        /// </summary>

-        [Test]

-        public void T01_SetupRootFolder()

-        {

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryFolderBase f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsNotNull(f, "Failed to get existing folder");

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            // Test that we only get the root folder, based on it's id, i.e. any other gui will not find the folder

-            f = _dbPlugin.getInventoryFolder(LLUUID.Zero);

-            Assert.IsNull(f, "get folder returned a folder, but shouldn't find one");

-

-            f = _dbPlugin.getInventoryFolder(LLUUID.Random());

-            Assert.IsNull(f, "get folder returned a folder, but shouldn't find one");

-

-            // test that we can delete the folder

-

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-            f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsNull(f, "get folder returned a folder, but it should have been deleted");

-        }

-

-        /// <summary>

-        /// Make sure that all folders reported as root folders are root folders

-        /// </summary>

-        [Test]

-        public void T02_TestRootFolder()

-        {

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            List<InventoryFolderBase> folders = _dbPlugin.getUserRootFolders(_agent_1_id);

-            Assert.IsNotNull(folders, "Failed to get rootfolders for user");

-

-            bool foundRoot = false;

-            foreach(InventoryFolderBase f in folders) {

-

-                // a root folder has a zero valued LLUUID

-                Assert.AreEqual(f.parentID, LLUUID.Zero, "non root folder returned");

-

-

-                if(f.agentID == root.agentID)

-                {

-                    // we cannot have two different user specific root folders

-                    Assert.IsFalse(foundRoot, "Two different user specific root folders returned");

-

-                    Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-                    foundRoot = false;

-                }

-            }

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-        }

-

-        /// <summary>

-        /// Test of folder hierarchy

-        /// </summary>

-        [Test]

-        public void T03_TestRootFolder()

-        {

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            List<InventoryFolderBase> folders = _dbPlugin.getInventoryFolders(_agent_1_id);

-            Assert.IsNotNull(folders, "null was returned, but an empty list of subfolders were expected");

-            Assert.IsEmpty(folders, "non empty collection was returned, even though the list of sub-folders should be empty");

-

-            InventoryFolderBase child1 = new InventoryFolderBase();

-            child1.agentID = _agent_1_id;

-            child1.folderID = LLUUID.Random();

-            child1.name = "Child 1";

-            child1.parentID = root.folderID;

-            child1.type = 3;

-            child1.version = 3;

-            _dbPlugin.addInventoryFolder(child1);

-

-            InventoryFolderBase child2 = new InventoryFolderBase();

-            child2.agentID = _agent_1_id;

-            child2.folderID = LLUUID.Random();

-            child2.name = "Child 2";

-            child2.parentID = root.folderID;

-            child2.type = 4;

-            child2.version = 4;

-            _dbPlugin.addInventoryFolder(child2);

-

-            folders = _dbPlugin.getInventoryFolders(_agent_1_id);

-            Assert.IsNotNull(folders, "null was returned, but an empty list of subfolders were expected");

-            Assert.AreEqual(folders.Count, 2, "two children were reported as inserted into the root folder");

-

-            bool foundChild1 = false;

-            bool foundChild2 = false;

-

-            foreach (InventoryFolderBase f in folders)

-            {

-                if (f.folderID == child1.folderID)

-                {

-                    Assert.IsTrue(AreFoldersIdentical(child1, f), "Difference between stored and retrieved folder data");

-                    foundChild1 = true;

-                }

-                else if (f.folderID == child2.folderID)

-                {

-                    Assert.IsTrue(AreFoldersIdentical(child2, f), "Difference between stored and retrieved folder data");

-                    foundChild2 = true;

-                }

-                else

-                {

-                    Assert.Fail("found unknown child folder");

-                }

-            }

-

-            if (foundChild1 == false || foundChild2 == false)

-            {

-                Assert.Fail("one of the two child folders was not returned");

-            }

-

-            _dbPlugin.deleteInventoryFolder(child2.folderID);

-            _dbPlugin.deleteInventoryFolder(child1.folderID);

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-        }

-

-        /// <summary>

-        /// Test of folder hierarchy, and deletion

-        /// </summary>

-        [Test]

-        public void T04_TestRootFolder()

-        {

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryFolderBase child1 = new InventoryFolderBase();

-            child1.agentID = _agent_1_id;

-            child1.folderID = LLUUID.Random();

-            child1.name = "Child 1";

-            child1.parentID = root.folderID;

-            child1.type = 3;

-            child1.version = 3;

-            _dbPlugin.addInventoryFolder(child1);

-

-            InventoryFolderBase child2 = new InventoryFolderBase();

-            child2.agentID = _agent_1_id;

-            child2.folderID = LLUUID.Random();

-            child2.name = "Child 2";

-            child2.parentID = root.folderID;

-            child2.type = 4;

-            child2.version = 4;

-            _dbPlugin.addInventoryFolder(child2);

-

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-

-            List<InventoryFolderBase> folders = _dbPlugin.getInventoryFolders(_agent_1_id);

-            Assert.IsNotNull(folders, "null was returned, but an empty list of subfolders were expected");

-            Assert.IsEmpty(folders, "non empty collection was returned, even though the list of sub-folders should be empty");

-

-            InventoryFolderBase f = _dbPlugin.getInventoryFolder(_agent_1_id);

-            Assert.IsNull(f, "Folder was returned, even though is has been deleted");

-

-            f = _dbPlugin.getInventoryFolder(child1.folderID);

-            Assert.IsNull(f, "Folder was returned, even though is has been deleted");

-

-            f = _dbPlugin.getInventoryFolder(child2.folderID);

-            Assert.IsNull(f, "Folder was returned, even though is has been deleted");

-        }

-

-        /// <summary>

-        /// Folder update

-        /// </summary>

-        [Test]

-        public void T05_UpdateFolder()

-        {

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryFolderBase f = _dbPlugin.getInventoryFolder(_agent_1_id);

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            root.agentID = LLUUID.Random();

-            _dbPlugin.updateInventoryFolder(root);

-            f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            root.folderID = LLUUID.Random();

-            _dbPlugin.updateInventoryFolder(root);

-            f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            root.name = "Root folder 2";

-            _dbPlugin.updateInventoryFolder(root);

-            f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            root.parentID = LLUUID.Random();

-            _dbPlugin.updateInventoryFolder(root);

-            f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            root.type = (short)(root.type + 1);

-            _dbPlugin.updateInventoryFolder(root);

-            f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            root.version = (ushort)(root.version + 1);

-            _dbPlugin.updateInventoryFolder(root);

-            f = _dbPlugin.getInventoryFolder(root.folderID);

-            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");

-

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-            _dbPlugin.deleteInventoryFolder(root.folderID);

-        }

-

-        /// <summary>

-        /// Test that we can insert a root folder

-        /// </summary>

-        [Test]

-        public void T06_SetupInventoryWithItems()

-        {

-

-            // Setup inventory

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryFolderBase child1 = new InventoryFolderBase();

-            child1.agentID = _agent_1_id;

-            child1.folderID = LLUUID.Random();

-            child1.name = "Child 1";

-            child1.parentID = root.folderID;

-            child1.type = 3;

-            child1.version = 3;

-            _dbPlugin.addInventoryFolder(child1);

-

-            InventoryFolderBase child1Child = new InventoryFolderBase();

-            child1Child.agentID = _agent_1_id;

-            child1Child.folderID = LLUUID.Random();

-            child1Child.name = "Child 1 child";

-            child1Child.parentID = child1.folderID;

-            child1Child.type = 4;

-            child1Child.version = 4;

-            _dbPlugin.addInventoryFolder(child1Child);

-

-            InventoryFolderBase child2 = new InventoryFolderBase();

-            child2.agentID = _agent_1_id;

-            child2.folderID = LLUUID.Random();

-            child2.name = "Child 2";

-            child2.parentID = root.folderID;

-            child2.type = 5;

-            child2.version = 5;

-            _dbPlugin.addInventoryFolder(child2);

-

-            InventoryFolderBase child2Child = new InventoryFolderBase();

-            child2Child.agentID = _agent_1_id;

-            child2Child.folderID = LLUUID.Random();

-            child2Child.name = "Child 2 child";

-            child2Child.parentID = child2.folderID;

-            child2Child.type = 6;

-            child2Child.version = 6;

-            _dbPlugin.addInventoryFolder(child2Child);

-

-            InventoryItemBase rootItem = new InventoryItemBase();

-            rootItem.assetID = LLUUID.Random();

-            rootItem.assetType = _rnd.Next(1, 1000);

-            rootItem.avatarID = _agent_1_id;

-            rootItem.creatorsID = LLUUID.Random();

-            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1,1000000);

-            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryID = LLUUID.Random();

-            rootItem.inventoryDescription = "Root item, Description";

-            rootItem.inventoryName = "Root item";

-            rootItem.invType = _rnd.Next(1, 1000);

-            rootItem.parentFolderID = root.folderID;

-            _dbPlugin.addInventoryItem(rootItem);

-

-            InventoryItemBase child1Item = new InventoryItemBase();

-            child1Item.assetID = LLUUID.Random();

-            child1Item.assetType = _rnd.Next(1, 1000);

-            child1Item.avatarID = _agent_1_id;

-            child1Item.creatorsID = LLUUID.Random();

-            child1Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryID = LLUUID.Random();

-            child1Item.inventoryDescription = "child1 item, Description";

-            child1Item.inventoryName = "child1 item";

-            child1Item.invType = _rnd.Next(1, 1000);

-            child1Item.parentFolderID = child1.folderID;

-            _dbPlugin.addInventoryItem(child1Item);

-

-            InventoryItemBase child1ChildItem = new InventoryItemBase();

-            child1ChildItem.assetID = LLUUID.Random();

-            child1ChildItem.assetType = _rnd.Next(1, 1000);

-            child1ChildItem.avatarID = _agent_1_id;

-            child1ChildItem.creatorsID = LLUUID.Random();

-            child1ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryID = LLUUID.Random();

-            child1ChildItem.inventoryDescription = "child1Child item, Description";

-            child1ChildItem.inventoryName = "child1Child item";

-            child1ChildItem.invType = _rnd.Next(1, 1000);

-            child1ChildItem.parentFolderID = child1Child.folderID;

-            _dbPlugin.addInventoryItem(child1ChildItem);

-

-            InventoryItemBase child2Item = new InventoryItemBase();

-            child2Item.assetID = LLUUID.Random();

-            child2Item.assetType = _rnd.Next(1, 1000);

-            child2Item.avatarID = _agent_1_id;

-            child2Item.creatorsID = LLUUID.Random();

-            child2Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryID = LLUUID.Random();

-            child2Item.inventoryDescription = "child2 item, Description";

-            child2Item.inventoryName = "child2 item";

-            child2Item.invType = _rnd.Next(1, 1000);

-            child2Item.parentFolderID = child2.folderID;

-            _dbPlugin.addInventoryItem(child2Item);

-

-            InventoryItemBase child2ChildItem = new InventoryItemBase();

-            child2ChildItem.assetID = LLUUID.Random();

-            child2ChildItem.assetType = _rnd.Next(1, 1000);

-            child2ChildItem.avatarID = _agent_1_id;

-            child2ChildItem.creatorsID = LLUUID.Random();

-            child2ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryID = LLUUID.Random();

-            child2ChildItem.inventoryDescription = "child2Child item, Description";

-            child2ChildItem.inventoryName = "child2Child item";

-            child2ChildItem.invType = _rnd.Next(1, 1000);

-            child2ChildItem.parentFolderID = child2Child.folderID;

-            _dbPlugin.addInventoryItem(child2ChildItem);

-

-            // test read of items

-

-            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            item = _dbPlugin.getInventoryItem(child1Item.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(child1Item, item));

-

-            item = _dbPlugin.getInventoryItem(child1ChildItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(child1ChildItem, item));

-

-            item = _dbPlugin.getInventoryItem(child2Item.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(child2Item, item));

-

-            item = _dbPlugin.getInventoryItem(child2ChildItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(child2ChildItem, item));

-

-            _dbPlugin.deleteInventoryItem(rootItem.inventoryID);

-            _dbPlugin.deleteInventoryItem(child1Item.inventoryID);

-            _dbPlugin.deleteInventoryItem(child1ChildItem.inventoryID);

-            _dbPlugin.deleteInventoryItem(child2Item.inventoryID);

-            _dbPlugin.deleteInventoryItem(child2ChildItem.inventoryID);

-        }

-

-        /// <summary>

-        /// Test that we can insert a root folder

-        /// </summary>

-        [Test]

-        public void T07_DeleteInventoryWithItems()

-        {

-

-            // Setup inventory

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryFolderBase child1 = new InventoryFolderBase();

-            child1.agentID = _agent_1_id;

-            child1.folderID = LLUUID.Random();

-            child1.name = "Child 1";

-            child1.parentID = root.folderID;

-            child1.type = 3;

-            child1.version = 3;

-            _dbPlugin.addInventoryFolder(child1);

-

-            InventoryFolderBase child1Child = new InventoryFolderBase();

-            child1Child.agentID = _agent_1_id;

-            child1Child.folderID = LLUUID.Random();

-            child1Child.name = "Child 1 child";

-            child1Child.parentID = child1.folderID;

-            child1Child.type = 4;

-            child1Child.version = 4;

-            _dbPlugin.addInventoryFolder(child1Child);

-

-            InventoryFolderBase child2 = new InventoryFolderBase();

-            child2.agentID = _agent_1_id;

-            child2.folderID = LLUUID.Random();

-            child2.name = "Child 2";

-            child2.parentID = root.folderID;

-            child2.type = 5;

-            child2.version = 5;

-            _dbPlugin.addInventoryFolder(child2);

-

-            InventoryFolderBase child2Child = new InventoryFolderBase();

-            child2Child.agentID = _agent_1_id;

-            child2Child.folderID = LLUUID.Random();

-            child2Child.name = "Child 2 child";

-            child2Child.parentID = child2.folderID;

-            child2Child.type = 6;

-            child2Child.version = 6;

-            _dbPlugin.addInventoryFolder(child2Child);

-

-            InventoryItemBase rootItem = new InventoryItemBase();

-            rootItem.assetID = LLUUID.Random();

-            rootItem.assetType = _rnd.Next(1, 1000);

-            rootItem.avatarID = _agent_1_id;

-            rootItem.creatorsID = LLUUID.Random();

-            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryID = LLUUID.Random();

-            rootItem.inventoryDescription = "Root item, Description";

-            rootItem.inventoryName = "Root item";

-            rootItem.invType = _rnd.Next(1, 1000);

-            rootItem.parentFolderID = root.folderID;

-            _dbPlugin.addInventoryItem(rootItem);

-

-            InventoryItemBase child1Item = new InventoryItemBase();

-            child1Item.assetID = LLUUID.Random();

-            child1Item.assetType = _rnd.Next(1, 1000);

-            child1Item.avatarID = _agent_1_id;

-            child1Item.creatorsID = LLUUID.Random();

-            child1Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryID = LLUUID.Random();

-            child1Item.inventoryDescription = "child1 item, Description";

-            child1Item.inventoryName = "child1 item";

-            child1Item.invType = _rnd.Next(1, 1000);

-            child1Item.parentFolderID = child1.folderID;

-            _dbPlugin.addInventoryItem(child1Item);

-

-            InventoryItemBase child1ChildItem = new InventoryItemBase();

-            child1ChildItem.assetID = LLUUID.Random();

-            child1ChildItem.assetType = _rnd.Next(1, 1000);

-            child1ChildItem.avatarID = _agent_1_id;

-            child1ChildItem.creatorsID = LLUUID.Random();

-            child1ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryID = LLUUID.Random();

-            child1ChildItem.inventoryDescription = "child1Child item, Description";

-            child1ChildItem.inventoryName = "child1Child item";

-            child1ChildItem.invType = _rnd.Next(1, 1000);

-            child1ChildItem.parentFolderID = child1Child.folderID;

-            _dbPlugin.addInventoryItem(child1ChildItem);

-

-            InventoryItemBase child2Item = new InventoryItemBase();

-            child2Item.assetID = LLUUID.Random();

-            child2Item.assetType = _rnd.Next(1, 1000);

-            child2Item.avatarID = _agent_1_id;

-            child2Item.creatorsID = LLUUID.Random();

-            child2Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryID = LLUUID.Random();

-            child2Item.inventoryDescription = "child2 item, Description";

-            child2Item.inventoryName = "child2 item";

-            child2Item.invType = _rnd.Next(1, 1000);

-            child2Item.parentFolderID = child2.folderID;

-            _dbPlugin.addInventoryItem(child2Item);

-

-            InventoryItemBase child2ChildItem = new InventoryItemBase();

-            child2ChildItem.assetID = LLUUID.Random();

-            child2ChildItem.assetType = _rnd.Next(1, 1000);

-            child2ChildItem.avatarID = _agent_1_id;

-            child2ChildItem.creatorsID = LLUUID.Random();

-            child2ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryID = LLUUID.Random();

-            child2ChildItem.inventoryDescription = "child2Child item, Description";

-            child2ChildItem.inventoryName = "child2Child item";

-            child2ChildItem.invType = _rnd.Next(1, 1000);

-            child2ChildItem.parentFolderID = child2Child.folderID;

-            _dbPlugin.addInventoryItem(child2ChildItem);

-

-            // test deletetion of items

-

-            _dbPlugin.deleteInventoryItem(rootItem.inventoryID);

-            _dbPlugin.deleteInventoryItem(child1Item.inventoryID);

-            _dbPlugin.deleteInventoryItem(child1ChildItem.inventoryID);

-            _dbPlugin.deleteInventoryItem(child2Item.inventoryID);

-            _dbPlugin.deleteInventoryItem(child2ChildItem.inventoryID);

-

-            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child1Item.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child1ChildItem.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child2Item.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child2ChildItem.inventoryID);

-            Assert.IsNull(item);

-

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-        }

-

-

-        /// <summary>

-        /// Test that we can insert a root folder

-        /// </summary>

-        [Test]

-        public void T08_DeleteInventoryWithItems()

-        {

-

-            // Setup inventory

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryFolderBase child1 = new InventoryFolderBase();

-            child1.agentID = _agent_1_id;

-            child1.folderID = LLUUID.Random();

-            child1.name = "Child 1";

-            child1.parentID = root.folderID;

-            child1.type = 3;

-            child1.version = 3;

-            _dbPlugin.addInventoryFolder(child1);

-

-            InventoryFolderBase child1Child = new InventoryFolderBase();

-            child1Child.agentID = _agent_1_id;

-            child1Child.folderID = LLUUID.Random();

-            child1Child.name = "Child 1 child";

-            child1Child.parentID = child1.folderID;

-            child1Child.type = 4;

-            child1Child.version = 4;

-            _dbPlugin.addInventoryFolder(child1Child);

-

-            InventoryFolderBase child2 = new InventoryFolderBase();

-            child2.agentID = _agent_1_id;

-            child2.folderID = LLUUID.Random();

-            child2.name = "Child 2";

-            child2.parentID = root.folderID;

-            child2.type = 5;

-            child2.version = 5;

-            _dbPlugin.addInventoryFolder(child2);

-

-            InventoryFolderBase child2Child = new InventoryFolderBase();

-            child2Child.agentID = _agent_1_id;

-            child2Child.folderID = LLUUID.Random();

-            child2Child.name = "Child 2 child";

-            child2Child.parentID = child2.folderID;

-            child2Child.type = 6;

-            child2Child.version = 6;

-            _dbPlugin.addInventoryFolder(child2Child);

-

-            InventoryItemBase rootItem = new InventoryItemBase();

-            rootItem.assetID = LLUUID.Random();

-            rootItem.assetType = _rnd.Next(1, 1000);

-            rootItem.avatarID = _agent_1_id;

-            rootItem.creatorsID = LLUUID.Random();

-            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryID = LLUUID.Random();

-            rootItem.inventoryDescription = "Root item, Description";

-            rootItem.inventoryName = "Root item";

-            rootItem.invType = _rnd.Next(1, 1000);

-            rootItem.parentFolderID = root.folderID;

-            _dbPlugin.addInventoryItem(rootItem);

-

-            InventoryItemBase child1Item = new InventoryItemBase();

-            child1Item.assetID = LLUUID.Random();

-            child1Item.assetType = _rnd.Next(1, 1000);

-            child1Item.avatarID = _agent_1_id;

-            child1Item.creatorsID = LLUUID.Random();

-            child1Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child1Item.inventoryID = LLUUID.Random();

-            child1Item.inventoryDescription = "child1 item, Description";

-            child1Item.inventoryName = "child1 item";

-            child1Item.invType = _rnd.Next(1, 1000);

-            child1Item.parentFolderID = child1.folderID;

-            _dbPlugin.addInventoryItem(child1Item);

-

-            InventoryItemBase child1ChildItem = new InventoryItemBase();

-            child1ChildItem.assetID = LLUUID.Random();

-            child1ChildItem.assetType = _rnd.Next(1, 1000);

-            child1ChildItem.avatarID = _agent_1_id;

-            child1ChildItem.creatorsID = LLUUID.Random();

-            child1ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child1ChildItem.inventoryID = LLUUID.Random();

-            child1ChildItem.inventoryDescription = "child1Child item, Description";

-            child1ChildItem.inventoryName = "child1Child item";

-            child1ChildItem.invType = _rnd.Next(1, 1000);

-            child1ChildItem.parentFolderID = child1Child.folderID;

-            _dbPlugin.addInventoryItem(child1ChildItem);

-

-            InventoryItemBase child2Item = new InventoryItemBase();

-            child2Item.assetID = LLUUID.Random();

-            child2Item.assetType = _rnd.Next(1, 1000);

-            child2Item.avatarID = _agent_1_id;

-            child2Item.creatorsID = LLUUID.Random();

-            child2Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child2Item.inventoryID = LLUUID.Random();

-            child2Item.inventoryDescription = "child2 item, Description";

-            child2Item.inventoryName = "child2 item";

-            child2Item.invType = _rnd.Next(1, 1000);

-            child2Item.parentFolderID = child2.folderID;

-            _dbPlugin.addInventoryItem(child2Item);

-

-            InventoryItemBase child2ChildItem = new InventoryItemBase();

-            child2ChildItem.assetID = LLUUID.Random();

-            child2ChildItem.assetType = _rnd.Next(1, 1000);

-            child2ChildItem.avatarID = _agent_1_id;

-            child2ChildItem.creatorsID = LLUUID.Random();

-            child2ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            child2ChildItem.inventoryID = LLUUID.Random();

-            child2ChildItem.inventoryDescription = "child2Child item, Description";

-            child2ChildItem.inventoryName = "child2Child item";

-            child2ChildItem.invType = _rnd.Next(1, 1000);

-            child2ChildItem.parentFolderID = child2Child.folderID;

-            _dbPlugin.addInventoryItem(child2ChildItem);

-

-            // test deletetion of items

-

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-

-            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child1Item.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child1ChildItem.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child2Item.inventoryID);

-            Assert.IsNull(item);

-

-            item = _dbPlugin.getInventoryItem(child2ChildItem.inventoryID);

-            Assert.IsNull(item);

-

-        }

-

-        /// <summary>

-        /// Test that we can update items

-        /// </summary>

-        [Test]

-        public void T09_UpdateItem()

-        {

-

-            // Setup inventory

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryItemBase rootItem = new InventoryItemBase();

-            rootItem.assetID = LLUUID.Random();

-            rootItem.assetType = _rnd.Next(1, 1000);

-            rootItem.avatarID = _agent_1_id;

-            rootItem.creatorsID = LLUUID.Random();

-            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            rootItem.inventoryID = LLUUID.Random();

-            rootItem.inventoryDescription = "Root item, Description";

-            rootItem.inventoryName = "Root item";

-            rootItem.invType = _rnd.Next(1, 1000);

-            rootItem.parentFolderID = root.folderID;

-            _dbPlugin.addInventoryItem(rootItem);

-

-            rootItem.assetID = LLUUID.Random();

-            _dbPlugin.updateInventoryItem(rootItem);

-            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.assetType = rootItem.assetType+1;

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.avatarID = LLUUID.Random();

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.creatorsID = LLUUID.Random();

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.inventoryBasePermissions = rootItem.inventoryBasePermissions+1;

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.inventoryCurrentPermissions = rootItem.inventoryCurrentPermissions+1;

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.inventoryDescription = "New description";

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.inventoryEveryOnePermissions = rootItem.inventoryEveryOnePermissions+1;

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.inventoryName = "New name";

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.inventoryNextPermissions = rootItem.inventoryNextPermissions+1;

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.invType = rootItem.invType+1;

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            rootItem.parentFolderID = LLUUID.Zero;

-            _dbPlugin.updateInventoryItem(rootItem);

-            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);

-            Assert.IsTrue(AreItemsIdentical(rootItem, item));

-

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-            _dbPlugin.deleteInventoryItem(rootItem.inventoryID);

-        }

-

-

-        /// <summary>

-        /// Test that we can insert a root folder

-        /// </summary>

-        [Test]

-        public void T10_GetListOfItemsInFolder()

-        {

-

-            // Setup inventory

-            InventoryFolderBase root = new InventoryFolderBase();

-            root.agentID = _agent_1_id;

-            root.folderID = _agent_1_id;

-            root.name = "Root folder";

-            root.parentID = LLUUID.Zero;

-            root.type = 2;

-            root.version = 2;

-            _dbPlugin.addInventoryFolder(root);

-

-            InventoryFolderBase child1 = new InventoryFolderBase();

-            child1.agentID = _agent_1_id;

-            child1.folderID = LLUUID.Random();

-            child1.name = "Child 1";

-            child1.parentID = root.folderID;

-            child1.type = 3;

-            child1.version = 3;

-            _dbPlugin.addInventoryFolder(child1);

-

-            InventoryFolderBase child1Child = new InventoryFolderBase();

-            child1Child.agentID = _agent_1_id;

-            child1Child.folderID = LLUUID.Random();

-            child1Child.name = "Child 1 child";

-            child1Child.parentID = child1.folderID;

-            child1Child.type = 4;

-            child1Child.version = 4;

-            _dbPlugin.addInventoryFolder(child1Child);

-

-

-            InventoryItemBase item1 = new InventoryItemBase();

-            item1.assetID = LLUUID.Random();

-            item1.assetType = _rnd.Next(1, 1000);

-            item1.avatarID = _agent_1_id;

-            item1.creatorsID = LLUUID.Random();

-            item1.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            item1.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            item1.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            item1.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            item1.inventoryID = LLUUID.Random();

-            item1.inventoryDescription = "Item 1, description";

-            item1.inventoryName = "Item 1";

-            item1.invType = _rnd.Next(1, 1000);

-            item1.parentFolderID = child1Child.folderID;

-            _dbPlugin.addInventoryItem(item1);

-

-            InventoryItemBase item2 = new InventoryItemBase();

-            item2.assetID = LLUUID.Random();

-            item2.assetType = _rnd.Next(1, 1000);

-            item2.avatarID = _agent_1_id;

-            item2.creatorsID = LLUUID.Random();

-            item2.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);

-            item2.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);

-            item2.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);

-            item2.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);

-            item2.inventoryID = LLUUID.Random();

-            item2.inventoryDescription = "Item 1, description";

-            item2.inventoryName = "Item 1";

-            item2.invType = _rnd.Next(1, 1000);

-            item2.parentFolderID = child1Child.folderID;

-            _dbPlugin.addInventoryItem(item2);

-

-            List<InventoryItemBase> items = _dbPlugin.getInventoryInFolder(child1Child.folderID);

-            Assert.IsNotNull(items);

-            Assert.IsNotEmpty(items);

-

-            bool foundItem1 = false;

-            bool foundItem2 = false;

-

-            foreach (InventoryItemBase i in items)

-            {

-                if (i.inventoryID == item1.inventoryID)

-                {

-                    foundItem1 = true;

-                    Assert.IsTrue(AreItemsIdentical(item1, i));

-                }

-                else if (i.inventoryID == item2.inventoryID)

-                {

-                    foundItem2 = true;

-                    Assert.IsTrue(AreItemsIdentical(item2, i));

-                }

-                else

-                {

-                    Assert.Fail("Unknown inventory item found");

-                }

-            }

-

-            Assert.IsTrue(foundItem1 && foundItem2, "not all items were returned");

-            _dbPlugin.deleteInventoryFolder(_agent_1_id);

-        }

-    }

-}

+/*
+* Copyright (c) Contributors, http://opensimulator.org/
+* See CONTRIBUTORS.TXT for a full list of copyright holders.
+*
+* Redistribution and use in source and binary forms, with or without
+* modification, are permitted provided that the following conditions are met:
+*     * Redistributions of source code must retain the above copyright
+*       notice, this list of conditions and the following disclaimer.
+*     * Redistributions in binary form must reproduce the above copyright
+*       notice, this list of conditions and the following disclaimer in the
+*       documentation and/or other materials provided with the distribution.
+*     * Neither the name of the OpenSim Project nor the
+*       names of its contributors may be used to endorse or promote products
+*       derived from this software without specific prior written permission.
+*
+* THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS AS IS AND ANY
+* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
+* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+* DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
+* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
+* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
+* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+* 
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using NUnit.Framework;
+
+using libsecondlife;
+using OpenSim.Framework.Types;
+using OpenSim.Framework.Data;
+using OpenSim.Framework.Data.SQLite;
+using OpenSim.Framework.Data.MySQL;
+using OpenSim.Framework.Console;
+
+namespace OpenSim.Test.Inventory
+{
+    [TestFixture]
+    public class TestInventory
+    {
+        IInventoryData _dbPlugin;
+        LLUUID _agent_1_id;
+        public static LLUUID LibraryFolderRootUuid = new LLUUID("5926de2a-c2d7-4c11-ac4e-74512ffeb6d1");
+
+        Random _rnd = new Random((int)DateTime.Now.Ticks);
+
+        [TestFixtureSetUp]
+        public void SetupInventoryTest()
+        {
+
+            _agent_1_id = LLUUID.Random();
+
+            MainLog.Instance = new LogBase("UnitTest.log", "TEST", null, true);
+//            _dbPlugin = new SQLiteInventoryStore();
+            _dbPlugin = new MySQLInventoryData();
+            _dbPlugin.Initialise();
+        }
+
+        [TestFixtureTearDown]
+        public void TeardownInventoryTest()
+        {
+            _dbPlugin.Close();
+        }
+
+        private bool AreFoldersIdentical(InventoryFolderBase a, InventoryFolderBase b)
+        {
+            if (a.agentID != b.agentID) return false;
+            if (a.folderID != b.folderID) return false;
+            if (a.name != b.name) return false;
+            if (a.parentID != b.parentID) return false;
+            if (a.type != b.type) return false;
+            if (a.version != b.version) return false;
+            return true;
+        }
+
+        private bool AreItemsIdentical(InventoryItemBase a, InventoryItemBase b)
+        {
+            if (a.assetID != b.assetID) return false;
+            if (a.assetType != b.assetType) return false;
+            if (a.avatarID != b.avatarID) return false;
+            if (a.creatorsID != b.creatorsID) return false;
+            if (a.inventoryBasePermissions != b.inventoryBasePermissions) return false;
+            if (a.inventoryCurrentPermissions != b.inventoryCurrentPermissions) return false;
+            if (a.inventoryEveryOnePermissions != b.inventoryEveryOnePermissions) return false;
+            if (a.inventoryNextPermissions != b.inventoryNextPermissions) return false;
+            if (a.inventoryID != b.inventoryID) return false;
+            if (a.inventoryDescription != b.inventoryDescription) return false;
+            if (a.inventoryName != b.inventoryName) return false;
+            if (a.invType != b.invType) return false;
+            if (a.parentFolderID != b.parentFolderID) return false;
+            return true;
+        }
+        
+        /// <summary>
+        /// Test that we can insert a root folder
+        /// </summary>
+        [Test]
+        public void T01_SetupRootFolder()
+        {
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryFolderBase f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsNotNull(f, "Failed to get existing folder");
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            // Test that we only get the root folder, based on it's id, i.e. any other gui will not find the folder
+            f = _dbPlugin.getInventoryFolder(LLUUID.Zero);
+            Assert.IsNull(f, "get folder returned a folder, but shouldn't find one");
+
+            f = _dbPlugin.getInventoryFolder(LLUUID.Random());
+            Assert.IsNull(f, "get folder returned a folder, but shouldn't find one");
+
+            // test that we can delete the folder
+
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+            f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsNull(f, "get folder returned a folder, but it should have been deleted");
+        }
+
+        /// <summary>
+        /// Make sure that all folders reported as root folders are root folders
+        /// </summary>
+        [Test]
+        public void T02_TestRootFolder()
+        {
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            List<InventoryFolderBase> folders = _dbPlugin.getUserRootFolders(_agent_1_id);
+            Assert.IsNotNull(folders, "Failed to get rootfolders for user");
+
+            bool foundRoot = false;
+            foreach(InventoryFolderBase f in folders) {
+
+                // a root folder has a zero valued LLUUID
+                Assert.AreEqual(f.parentID, LLUUID.Zero, "non root folder returned");
+
+
+                if(f.agentID == root.agentID)
+                {
+                    // we cannot have two different user specific root folders
+                    Assert.IsFalse(foundRoot, "Two different user specific root folders returned");
+
+                    Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+                    foundRoot = false;
+                }
+            }
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+        }
+
+        /// <summary>
+        /// Test of folder hierarchy
+        /// </summary>
+        [Test]
+        public void T03_TestRootFolder()
+        {
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            List<InventoryFolderBase> folders = _dbPlugin.getInventoryFolders(_agent_1_id);
+            Assert.IsNotNull(folders, "null was returned, but an empty list of subfolders were expected");
+            Assert.IsEmpty(folders, "non empty collection was returned, even though the list of sub-folders should be empty");
+
+            InventoryFolderBase child1 = new InventoryFolderBase();
+            child1.agentID = _agent_1_id;
+            child1.folderID = LLUUID.Random();
+            child1.name = "Child 1";
+            child1.parentID = root.folderID;
+            child1.type = 3;
+            child1.version = 3;
+            _dbPlugin.addInventoryFolder(child1);
+
+            InventoryFolderBase child2 = new InventoryFolderBase();
+            child2.agentID = _agent_1_id;
+            child2.folderID = LLUUID.Random();
+            child2.name = "Child 2";
+            child2.parentID = root.folderID;
+            child2.type = 4;
+            child2.version = 4;
+            _dbPlugin.addInventoryFolder(child2);
+
+            folders = _dbPlugin.getInventoryFolders(_agent_1_id);
+            Assert.IsNotNull(folders, "null was returned, but an empty list of subfolders were expected");
+            Assert.AreEqual(folders.Count, 2, "two children were reported as inserted into the root folder");
+
+            bool foundChild1 = false;
+            bool foundChild2 = false;
+
+            foreach (InventoryFolderBase f in folders)
+            {
+                if (f.folderID == child1.folderID)
+                {
+                    Assert.IsTrue(AreFoldersIdentical(child1, f), "Difference between stored and retrieved folder data");
+                    foundChild1 = true;
+                }
+                else if (f.folderID == child2.folderID)
+                {
+                    Assert.IsTrue(AreFoldersIdentical(child2, f), "Difference between stored and retrieved folder data");
+                    foundChild2 = true;
+                }
+                else
+                {
+                    Assert.Fail("found unknown child folder");
+                }
+            }
+
+            if (foundChild1 == false || foundChild2 == false)
+            {
+                Assert.Fail("one of the two child folders was not returned");
+            }
+
+            _dbPlugin.deleteInventoryFolder(child2.folderID);
+            _dbPlugin.deleteInventoryFolder(child1.folderID);
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+        }
+
+        /// <summary>
+        /// Test of folder hierarchy, and deletion
+        /// </summary>
+        [Test]
+        public void T04_TestRootFolder()
+        {
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryFolderBase child1 = new InventoryFolderBase();
+            child1.agentID = _agent_1_id;
+            child1.folderID = LLUUID.Random();
+            child1.name = "Child 1";
+            child1.parentID = root.folderID;
+            child1.type = 3;
+            child1.version = 3;
+            _dbPlugin.addInventoryFolder(child1);
+
+            InventoryFolderBase child2 = new InventoryFolderBase();
+            child2.agentID = _agent_1_id;
+            child2.folderID = LLUUID.Random();
+            child2.name = "Child 2";
+            child2.parentID = root.folderID;
+            child2.type = 4;
+            child2.version = 4;
+            _dbPlugin.addInventoryFolder(child2);
+
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+
+            List<InventoryFolderBase> folders = _dbPlugin.getInventoryFolders(_agent_1_id);
+            Assert.IsNotNull(folders, "null was returned, but an empty list of subfolders were expected");
+            Assert.IsEmpty(folders, "non empty collection was returned, even though the list of sub-folders should be empty");
+
+            InventoryFolderBase f = _dbPlugin.getInventoryFolder(_agent_1_id);
+            Assert.IsNull(f, "Folder was returned, even though is has been deleted");
+
+            f = _dbPlugin.getInventoryFolder(child1.folderID);
+            Assert.IsNull(f, "Folder was returned, even though is has been deleted");
+
+            f = _dbPlugin.getInventoryFolder(child2.folderID);
+            Assert.IsNull(f, "Folder was returned, even though is has been deleted");
+        }
+
+        /// <summary>
+        /// Folder update
+        /// </summary>
+        [Test]
+        public void T05_UpdateFolder()
+        {
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryFolderBase f = _dbPlugin.getInventoryFolder(_agent_1_id);
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            root.agentID = LLUUID.Random();
+            _dbPlugin.updateInventoryFolder(root);
+            f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            root.folderID = LLUUID.Random();
+            _dbPlugin.updateInventoryFolder(root);
+            f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            root.name = "Root folder 2";
+            _dbPlugin.updateInventoryFolder(root);
+            f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            root.parentID = LLUUID.Random();
+            _dbPlugin.updateInventoryFolder(root);
+            f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            root.type = (short)(root.type + 1);
+            _dbPlugin.updateInventoryFolder(root);
+            f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            root.version = (ushort)(root.version + 1);
+            _dbPlugin.updateInventoryFolder(root);
+            f = _dbPlugin.getInventoryFolder(root.folderID);
+            Assert.IsTrue(AreFoldersIdentical(root, f), "Difference between stored and retrieved folder data");
+
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+            _dbPlugin.deleteInventoryFolder(root.folderID);
+        }
+
+        /// <summary>
+        /// Test that we can insert a root folder
+        /// </summary>
+        [Test]
+        public void T06_SetupInventoryWithItems()
+        {
+
+            // Setup inventory
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryFolderBase child1 = new InventoryFolderBase();
+            child1.agentID = _agent_1_id;
+            child1.folderID = LLUUID.Random();
+            child1.name = "Child 1";
+            child1.parentID = root.folderID;
+            child1.type = 3;
+            child1.version = 3;
+            _dbPlugin.addInventoryFolder(child1);
+
+            InventoryFolderBase child1Child = new InventoryFolderBase();
+            child1Child.agentID = _agent_1_id;
+            child1Child.folderID = LLUUID.Random();
+            child1Child.name = "Child 1 child";
+            child1Child.parentID = child1.folderID;
+            child1Child.type = 4;
+            child1Child.version = 4;
+            _dbPlugin.addInventoryFolder(child1Child);
+
+            InventoryFolderBase child2 = new InventoryFolderBase();
+            child2.agentID = _agent_1_id;
+            child2.folderID = LLUUID.Random();
+            child2.name = "Child 2";
+            child2.parentID = root.folderID;
+            child2.type = 5;
+            child2.version = 5;
+            _dbPlugin.addInventoryFolder(child2);
+
+            InventoryFolderBase child2Child = new InventoryFolderBase();
+            child2Child.agentID = _agent_1_id;
+            child2Child.folderID = LLUUID.Random();
+            child2Child.name = "Child 2 child";
+            child2Child.parentID = child2.folderID;
+            child2Child.type = 6;
+            child2Child.version = 6;
+            _dbPlugin.addInventoryFolder(child2Child);
+
+            InventoryItemBase rootItem = new InventoryItemBase();
+            rootItem.assetID = LLUUID.Random();
+            rootItem.assetType = _rnd.Next(1, 1000);
+            rootItem.avatarID = _agent_1_id;
+            rootItem.creatorsID = LLUUID.Random();
+            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1,1000000);
+            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryID = LLUUID.Random();
+            rootItem.inventoryDescription = "Root item, Description";
+            rootItem.inventoryName = "Root item";
+            rootItem.invType = _rnd.Next(1, 1000);
+            rootItem.parentFolderID = root.folderID;
+            _dbPlugin.addInventoryItem(rootItem);
+
+            InventoryItemBase child1Item = new InventoryItemBase();
+            child1Item.assetID = LLUUID.Random();
+            child1Item.assetType = _rnd.Next(1, 1000);
+            child1Item.avatarID = _agent_1_id;
+            child1Item.creatorsID = LLUUID.Random();
+            child1Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryID = LLUUID.Random();
+            child1Item.inventoryDescription = "child1 item, Description";
+            child1Item.inventoryName = "child1 item";
+            child1Item.invType = _rnd.Next(1, 1000);
+            child1Item.parentFolderID = child1.folderID;
+            _dbPlugin.addInventoryItem(child1Item);
+
+            InventoryItemBase child1ChildItem = new InventoryItemBase();
+            child1ChildItem.assetID = LLUUID.Random();
+            child1ChildItem.assetType = _rnd.Next(1, 1000);
+            child1ChildItem.avatarID = _agent_1_id;
+            child1ChildItem.creatorsID = LLUUID.Random();
+            child1ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryID = LLUUID.Random();
+            child1ChildItem.inventoryDescription = "child1Child item, Description";
+            child1ChildItem.inventoryName = "child1Child item";
+            child1ChildItem.invType = _rnd.Next(1, 1000);
+            child1ChildItem.parentFolderID = child1Child.folderID;
+            _dbPlugin.addInventoryItem(child1ChildItem);
+
+            InventoryItemBase child2Item = new InventoryItemBase();
+            child2Item.assetID = LLUUID.Random();
+            child2Item.assetType = _rnd.Next(1, 1000);
+            child2Item.avatarID = _agent_1_id;
+            child2Item.creatorsID = LLUUID.Random();
+            child2Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryID = LLUUID.Random();
+            child2Item.inventoryDescription = "child2 item, Description";
+            child2Item.inventoryName = "child2 item";
+            child2Item.invType = _rnd.Next(1, 1000);
+            child2Item.parentFolderID = child2.folderID;
+            _dbPlugin.addInventoryItem(child2Item);
+
+            InventoryItemBase child2ChildItem = new InventoryItemBase();
+            child2ChildItem.assetID = LLUUID.Random();
+            child2ChildItem.assetType = _rnd.Next(1, 1000);
+            child2ChildItem.avatarID = _agent_1_id;
+            child2ChildItem.creatorsID = LLUUID.Random();
+            child2ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryID = LLUUID.Random();
+            child2ChildItem.inventoryDescription = "child2Child item, Description";
+            child2ChildItem.inventoryName = "child2Child item";
+            child2ChildItem.invType = _rnd.Next(1, 1000);
+            child2ChildItem.parentFolderID = child2Child.folderID;
+            _dbPlugin.addInventoryItem(child2ChildItem);
+
+            // test read of items
+
+            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            item = _dbPlugin.getInventoryItem(child1Item.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(child1Item, item));
+
+            item = _dbPlugin.getInventoryItem(child1ChildItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(child1ChildItem, item));
+
+            item = _dbPlugin.getInventoryItem(child2Item.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(child2Item, item));
+
+            item = _dbPlugin.getInventoryItem(child2ChildItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(child2ChildItem, item));
+
+            _dbPlugin.deleteInventoryItem(rootItem.inventoryID);
+            _dbPlugin.deleteInventoryItem(child1Item.inventoryID);
+            _dbPlugin.deleteInventoryItem(child1ChildItem.inventoryID);
+            _dbPlugin.deleteInventoryItem(child2Item.inventoryID);
+            _dbPlugin.deleteInventoryItem(child2ChildItem.inventoryID);
+        }
+
+        /// <summary>
+        /// Test that we can insert a root folder
+        /// </summary>
+        [Test]
+        public void T07_DeleteInventoryWithItems()
+        {
+
+            // Setup inventory
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryFolderBase child1 = new InventoryFolderBase();
+            child1.agentID = _agent_1_id;
+            child1.folderID = LLUUID.Random();
+            child1.name = "Child 1";
+            child1.parentID = root.folderID;
+            child1.type = 3;
+            child1.version = 3;
+            _dbPlugin.addInventoryFolder(child1);
+
+            InventoryFolderBase child1Child = new InventoryFolderBase();
+            child1Child.agentID = _agent_1_id;
+            child1Child.folderID = LLUUID.Random();
+            child1Child.name = "Child 1 child";
+            child1Child.parentID = child1.folderID;
+            child1Child.type = 4;
+            child1Child.version = 4;
+            _dbPlugin.addInventoryFolder(child1Child);
+
+            InventoryFolderBase child2 = new InventoryFolderBase();
+            child2.agentID = _agent_1_id;
+            child2.folderID = LLUUID.Random();
+            child2.name = "Child 2";
+            child2.parentID = root.folderID;
+            child2.type = 5;
+            child2.version = 5;
+            _dbPlugin.addInventoryFolder(child2);
+
+            InventoryFolderBase child2Child = new InventoryFolderBase();
+            child2Child.agentID = _agent_1_id;
+            child2Child.folderID = LLUUID.Random();
+            child2Child.name = "Child 2 child";
+            child2Child.parentID = child2.folderID;
+            child2Child.type = 6;
+            child2Child.version = 6;
+            _dbPlugin.addInventoryFolder(child2Child);
+
+            InventoryItemBase rootItem = new InventoryItemBase();
+            rootItem.assetID = LLUUID.Random();
+            rootItem.assetType = _rnd.Next(1, 1000);
+            rootItem.avatarID = _agent_1_id;
+            rootItem.creatorsID = LLUUID.Random();
+            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryID = LLUUID.Random();
+            rootItem.inventoryDescription = "Root item, Description";
+            rootItem.inventoryName = "Root item";
+            rootItem.invType = _rnd.Next(1, 1000);
+            rootItem.parentFolderID = root.folderID;
+            _dbPlugin.addInventoryItem(rootItem);
+
+            InventoryItemBase child1Item = new InventoryItemBase();
+            child1Item.assetID = LLUUID.Random();
+            child1Item.assetType = _rnd.Next(1, 1000);
+            child1Item.avatarID = _agent_1_id;
+            child1Item.creatorsID = LLUUID.Random();
+            child1Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryID = LLUUID.Random();
+            child1Item.inventoryDescription = "child1 item, Description";
+            child1Item.inventoryName = "child1 item";
+            child1Item.invType = _rnd.Next(1, 1000);
+            child1Item.parentFolderID = child1.folderID;
+            _dbPlugin.addInventoryItem(child1Item);
+
+            InventoryItemBase child1ChildItem = new InventoryItemBase();
+            child1ChildItem.assetID = LLUUID.Random();
+            child1ChildItem.assetType = _rnd.Next(1, 1000);
+            child1ChildItem.avatarID = _agent_1_id;
+            child1ChildItem.creatorsID = LLUUID.Random();
+            child1ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryID = LLUUID.Random();
+            child1ChildItem.inventoryDescription = "child1Child item, Description";
+            child1ChildItem.inventoryName = "child1Child item";
+            child1ChildItem.invType = _rnd.Next(1, 1000);
+            child1ChildItem.parentFolderID = child1Child.folderID;
+            _dbPlugin.addInventoryItem(child1ChildItem);
+
+            InventoryItemBase child2Item = new InventoryItemBase();
+            child2Item.assetID = LLUUID.Random();
+            child2Item.assetType = _rnd.Next(1, 1000);
+            child2Item.avatarID = _agent_1_id;
+            child2Item.creatorsID = LLUUID.Random();
+            child2Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryID = LLUUID.Random();
+            child2Item.inventoryDescription = "child2 item, Description";
+            child2Item.inventoryName = "child2 item";
+            child2Item.invType = _rnd.Next(1, 1000);
+            child2Item.parentFolderID = child2.folderID;
+            _dbPlugin.addInventoryItem(child2Item);
+
+            InventoryItemBase child2ChildItem = new InventoryItemBase();
+            child2ChildItem.assetID = LLUUID.Random();
+            child2ChildItem.assetType = _rnd.Next(1, 1000);
+            child2ChildItem.avatarID = _agent_1_id;
+            child2ChildItem.creatorsID = LLUUID.Random();
+            child2ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryID = LLUUID.Random();
+            child2ChildItem.inventoryDescription = "child2Child item, Description";
+            child2ChildItem.inventoryName = "child2Child item";
+            child2ChildItem.invType = _rnd.Next(1, 1000);
+            child2ChildItem.parentFolderID = child2Child.folderID;
+            _dbPlugin.addInventoryItem(child2ChildItem);
+
+            // test deletetion of items
+
+            _dbPlugin.deleteInventoryItem(rootItem.inventoryID);
+            _dbPlugin.deleteInventoryItem(child1Item.inventoryID);
+            _dbPlugin.deleteInventoryItem(child1ChildItem.inventoryID);
+            _dbPlugin.deleteInventoryItem(child2Item.inventoryID);
+            _dbPlugin.deleteInventoryItem(child2ChildItem.inventoryID);
+
+            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child1Item.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child1ChildItem.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child2Item.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child2ChildItem.inventoryID);
+            Assert.IsNull(item);
+
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+        }
+
+
+        /// <summary>
+        /// Test that we can insert a root folder
+        /// </summary>
+        [Test]
+        public void T08_DeleteInventoryWithItems()
+        {
+
+            // Setup inventory
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryFolderBase child1 = new InventoryFolderBase();
+            child1.agentID = _agent_1_id;
+            child1.folderID = LLUUID.Random();
+            child1.name = "Child 1";
+            child1.parentID = root.folderID;
+            child1.type = 3;
+            child1.version = 3;
+            _dbPlugin.addInventoryFolder(child1);
+
+            InventoryFolderBase child1Child = new InventoryFolderBase();
+            child1Child.agentID = _agent_1_id;
+            child1Child.folderID = LLUUID.Random();
+            child1Child.name = "Child 1 child";
+            child1Child.parentID = child1.folderID;
+            child1Child.type = 4;
+            child1Child.version = 4;
+            _dbPlugin.addInventoryFolder(child1Child);
+
+            InventoryFolderBase child2 = new InventoryFolderBase();
+            child2.agentID = _agent_1_id;
+            child2.folderID = LLUUID.Random();
+            child2.name = "Child 2";
+            child2.parentID = root.folderID;
+            child2.type = 5;
+            child2.version = 5;
+            _dbPlugin.addInventoryFolder(child2);
+
+            InventoryFolderBase child2Child = new InventoryFolderBase();
+            child2Child.agentID = _agent_1_id;
+            child2Child.folderID = LLUUID.Random();
+            child2Child.name = "Child 2 child";
+            child2Child.parentID = child2.folderID;
+            child2Child.type = 6;
+            child2Child.version = 6;
+            _dbPlugin.addInventoryFolder(child2Child);
+
+            InventoryItemBase rootItem = new InventoryItemBase();
+            rootItem.assetID = LLUUID.Random();
+            rootItem.assetType = _rnd.Next(1, 1000);
+            rootItem.avatarID = _agent_1_id;
+            rootItem.creatorsID = LLUUID.Random();
+            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryID = LLUUID.Random();
+            rootItem.inventoryDescription = "Root item, Description";
+            rootItem.inventoryName = "Root item";
+            rootItem.invType = _rnd.Next(1, 1000);
+            rootItem.parentFolderID = root.folderID;
+            _dbPlugin.addInventoryItem(rootItem);
+
+            InventoryItemBase child1Item = new InventoryItemBase();
+            child1Item.assetID = LLUUID.Random();
+            child1Item.assetType = _rnd.Next(1, 1000);
+            child1Item.avatarID = _agent_1_id;
+            child1Item.creatorsID = LLUUID.Random();
+            child1Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child1Item.inventoryID = LLUUID.Random();
+            child1Item.inventoryDescription = "child1 item, Description";
+            child1Item.inventoryName = "child1 item";
+            child1Item.invType = _rnd.Next(1, 1000);
+            child1Item.parentFolderID = child1.folderID;
+            _dbPlugin.addInventoryItem(child1Item);
+
+            InventoryItemBase child1ChildItem = new InventoryItemBase();
+            child1ChildItem.assetID = LLUUID.Random();
+            child1ChildItem.assetType = _rnd.Next(1, 1000);
+            child1ChildItem.avatarID = _agent_1_id;
+            child1ChildItem.creatorsID = LLUUID.Random();
+            child1ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child1ChildItem.inventoryID = LLUUID.Random();
+            child1ChildItem.inventoryDescription = "child1Child item, Description";
+            child1ChildItem.inventoryName = "child1Child item";
+            child1ChildItem.invType = _rnd.Next(1, 1000);
+            child1ChildItem.parentFolderID = child1Child.folderID;
+            _dbPlugin.addInventoryItem(child1ChildItem);
+
+            InventoryItemBase child2Item = new InventoryItemBase();
+            child2Item.assetID = LLUUID.Random();
+            child2Item.assetType = _rnd.Next(1, 1000);
+            child2Item.avatarID = _agent_1_id;
+            child2Item.creatorsID = LLUUID.Random();
+            child2Item.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child2Item.inventoryID = LLUUID.Random();
+            child2Item.inventoryDescription = "child2 item, Description";
+            child2Item.inventoryName = "child2 item";
+            child2Item.invType = _rnd.Next(1, 1000);
+            child2Item.parentFolderID = child2.folderID;
+            _dbPlugin.addInventoryItem(child2Item);
+
+            InventoryItemBase child2ChildItem = new InventoryItemBase();
+            child2ChildItem.assetID = LLUUID.Random();
+            child2ChildItem.assetType = _rnd.Next(1, 1000);
+            child2ChildItem.avatarID = _agent_1_id;
+            child2ChildItem.creatorsID = LLUUID.Random();
+            child2ChildItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            child2ChildItem.inventoryID = LLUUID.Random();
+            child2ChildItem.inventoryDescription = "child2Child item, Description";
+            child2ChildItem.inventoryName = "child2Child item";
+            child2ChildItem.invType = _rnd.Next(1, 1000);
+            child2ChildItem.parentFolderID = child2Child.folderID;
+            _dbPlugin.addInventoryItem(child2ChildItem);
+
+            // test deletetion of items
+
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+
+            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child1Item.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child1ChildItem.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child2Item.inventoryID);
+            Assert.IsNull(item);
+
+            item = _dbPlugin.getInventoryItem(child2ChildItem.inventoryID);
+            Assert.IsNull(item);
+
+        }
+
+        /// <summary>
+        /// Test that we can update items
+        /// </summary>
+        [Test]
+        public void T09_UpdateItem()
+        {
+
+            // Setup inventory
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryItemBase rootItem = new InventoryItemBase();
+            rootItem.assetID = LLUUID.Random();
+            rootItem.assetType = _rnd.Next(1, 1000);
+            rootItem.avatarID = _agent_1_id;
+            rootItem.creatorsID = LLUUID.Random();
+            rootItem.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            rootItem.inventoryID = LLUUID.Random();
+            rootItem.inventoryDescription = "Root item, Description";
+            rootItem.inventoryName = "Root item";
+            rootItem.invType = _rnd.Next(1, 1000);
+            rootItem.parentFolderID = root.folderID;
+            _dbPlugin.addInventoryItem(rootItem);
+
+            rootItem.assetID = LLUUID.Random();
+            _dbPlugin.updateInventoryItem(rootItem);
+            InventoryItemBase item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.assetType = rootItem.assetType+1;
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.avatarID = LLUUID.Random();
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.creatorsID = LLUUID.Random();
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.inventoryBasePermissions = rootItem.inventoryBasePermissions+1;
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.inventoryCurrentPermissions = rootItem.inventoryCurrentPermissions+1;
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.inventoryDescription = "New description";
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.inventoryEveryOnePermissions = rootItem.inventoryEveryOnePermissions+1;
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.inventoryName = "New name";
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.inventoryNextPermissions = rootItem.inventoryNextPermissions+1;
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.invType = rootItem.invType+1;
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            rootItem.parentFolderID = LLUUID.Zero;
+            _dbPlugin.updateInventoryItem(rootItem);
+            item = _dbPlugin.getInventoryItem(rootItem.inventoryID);
+            Assert.IsTrue(AreItemsIdentical(rootItem, item));
+
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+            _dbPlugin.deleteInventoryItem(rootItem.inventoryID);
+        }
+
+
+        /// <summary>
+        /// Test that we can insert a root folder
+        /// </summary>
+        [Test]
+        public void T10_GetListOfItemsInFolder()
+        {
+
+            // Setup inventory
+            InventoryFolderBase root = new InventoryFolderBase();
+            root.agentID = _agent_1_id;
+            root.folderID = _agent_1_id;
+            root.name = "Root folder";
+            root.parentID = LLUUID.Zero;
+            root.type = 2;
+            root.version = 2;
+            _dbPlugin.addInventoryFolder(root);
+
+            InventoryFolderBase child1 = new InventoryFolderBase();
+            child1.agentID = _agent_1_id;
+            child1.folderID = LLUUID.Random();
+            child1.name = "Child 1";
+            child1.parentID = root.folderID;
+            child1.type = 3;
+            child1.version = 3;
+            _dbPlugin.addInventoryFolder(child1);
+
+            InventoryFolderBase child1Child = new InventoryFolderBase();
+            child1Child.agentID = _agent_1_id;
+            child1Child.folderID = LLUUID.Random();
+            child1Child.name = "Child 1 child";
+            child1Child.parentID = child1.folderID;
+            child1Child.type = 4;
+            child1Child.version = 4;
+            _dbPlugin.addInventoryFolder(child1Child);
+
+
+            InventoryItemBase item1 = new InventoryItemBase();
+            item1.assetID = LLUUID.Random();
+            item1.assetType = _rnd.Next(1, 1000);
+            item1.avatarID = _agent_1_id;
+            item1.creatorsID = LLUUID.Random();
+            item1.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            item1.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            item1.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            item1.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            item1.inventoryID = LLUUID.Random();
+            item1.inventoryDescription = "Item 1, description";
+            item1.inventoryName = "Item 1";
+            item1.invType = _rnd.Next(1, 1000);
+            item1.parentFolderID = child1Child.folderID;
+            _dbPlugin.addInventoryItem(item1);
+
+            InventoryItemBase item2 = new InventoryItemBase();
+            item2.assetID = LLUUID.Random();
+            item2.assetType = _rnd.Next(1, 1000);
+            item2.avatarID = _agent_1_id;
+            item2.creatorsID = LLUUID.Random();
+            item2.inventoryBasePermissions = (uint)_rnd.Next(1, 1000000);
+            item2.inventoryCurrentPermissions = (uint)_rnd.Next(1, 1000000);
+            item2.inventoryEveryOnePermissions = (uint)_rnd.Next(1, 1000000);
+            item2.inventoryNextPermissions = (uint)_rnd.Next(1, 1000000);
+            item2.inventoryID = LLUUID.Random();
+            item2.inventoryDescription = "Item 1, description";
+            item2.inventoryName = "Item 1";
+            item2.invType = _rnd.Next(1, 1000);
+            item2.parentFolderID = child1Child.folderID;
+            _dbPlugin.addInventoryItem(item2);
+
+            List<InventoryItemBase> items = _dbPlugin.getInventoryInFolder(child1Child.folderID);
+            Assert.IsNotNull(items);
+            Assert.IsNotEmpty(items);
+
+            bool foundItem1 = false;
+            bool foundItem2 = false;
+
+            foreach (InventoryItemBase i in items)
+            {
+                if (i.inventoryID == item1.inventoryID)
+                {
+                    foundItem1 = true;
+                    Assert.IsTrue(AreItemsIdentical(item1, i));
+                }
+                else if (i.inventoryID == item2.inventoryID)
+                {
+                    foundItem2 = true;
+                    Assert.IsTrue(AreItemsIdentical(item2, i));
+                }
+                else
+                {
+                    Assert.Fail("Unknown inventory item found");
+                }
+            }
+
+            Assert.IsTrue(foundItem1 && foundItem2, "not all items were returned");
+            _dbPlugin.deleteInventoryFolder(_agent_1_id);
+        }
+    }
+}