From 87d99ee2a24f7fc8a4ad3c11327395997cf0d42f Mon Sep 17 00:00:00 2001
From: Tleiades Hax
Date: Wed, 10 Oct 2007 17:00:29 +0000
Subject: Added unit tests, based on nunit for the IInventoryData
---
OpenSim/Tests/Inventory/TestInventory.cs | 980 +++++++++++++++++++++++++++++++
1 file changed, 980 insertions(+)
create mode 100644 OpenSim/Tests/Inventory/TestInventory.cs
(limited to 'OpenSim/Tests/Inventory/TestInventory.cs')
diff --git a/OpenSim/Tests/Inventory/TestInventory.cs b/OpenSim/Tests/Inventory/TestInventory.cs
new file mode 100644
index 0000000..067f114
--- /dev/null
+++ b/OpenSim/Tests/Inventory/TestInventory.cs
@@ -0,0 +1,980 @@
+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