From d4bb430f78d9a70137957c8fe42de8fa620597ef Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Fri, 19 Oct 2007 20:28:18 +0000 Subject: get rid of all the ^M line endings --- OpenSim/Tests/Inventory/Properties/AssemblyInfo.cs | 70 +- OpenSim/Tests/Inventory/TestInventory.cs | 2016 ++++++++++---------- 2 files changed, 1043 insertions(+), 1043 deletions(-) (limited to 'OpenSim/Tests') 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; - } - - /// - /// Test that we can insert a root folder - /// - [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"); - } - - /// - /// Make sure that all folders reported as root folders are root folders - /// - [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 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); - } - - /// - /// Test of folder hierarchy - /// - [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 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); - } - - /// - /// Test of folder hierarchy, and deletion - /// - [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 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"); - } - - /// - /// Folder update - /// - [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); - } - - /// - /// Test that we can insert a root folder - /// - [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); - } - - /// - /// Test that we can insert a root folder - /// - [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); - } - - - /// - /// Test that we can insert a root folder - /// - [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); - - } - - /// - /// Test that we can update items - /// - [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); - } - - - /// - /// Test that we can insert a root folder - /// - [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 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; + } + + /// + /// Test that we can insert a root folder + /// + [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"); + } + + /// + /// Make sure that all folders reported as root folders are root folders + /// + [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 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); + } + + /// + /// Test of folder hierarchy + /// + [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 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); + } + + /// + /// Test of folder hierarchy, and deletion + /// + [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 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"); + } + + /// + /// Folder update + /// + [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); + } + + /// + /// Test that we can insert a root folder + /// + [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); + } + + /// + /// Test that we can insert a root folder + /// + [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); + } + + + /// + /// Test that we can insert a root folder + /// + [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); + + } + + /// + /// Test that we can update items + /// + [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); + } + + + /// + /// Test that we can insert a root folder + /// + [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 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); + } + } +} -- cgit v1.1