1
0

RegionTests.cs 55 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137
  1. /*
  2. * Copyright (c) Contributors, http://opensimulator.org/
  3. * See CONTRIBUTORS.TXT for a full list of copyright holders.
  4. *
  5. * Redistribution and use in source and binary forms, with or without
  6. * modification, are permitted provided that the following conditions are met:
  7. * * Redistributions of source code must retain the above copyright
  8. * notice, this list of conditions and the following disclaimer.
  9. * * Redistributions in binary form must reproduce the above copyright
  10. * notice, this list of conditions and the following disclaimer in the
  11. * documentation and/or other materials provided with the distribution.
  12. * * Neither the name of the OpenSimulator Project nor the
  13. * names of its contributors may be used to endorse or promote products
  14. * derived from this software without specific prior written permission.
  15. *
  16. * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
  17. * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  18. * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  19. * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
  20. * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
  21. * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  22. * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  23. * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  24. * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  25. * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  26. */
  27. using System;
  28. using System.Collections.Generic;
  29. using System.Drawing;
  30. using System.Text;
  31. using log4net.Config;
  32. using NUnit.Framework;
  33. using OpenMetaverse;
  34. using OpenSim.Framework;
  35. using OpenSim.Region.Framework.Interfaces;
  36. using OpenSim.Region.Framework.Scenes;
  37. using OpenSim.Tests.Common;
  38. using log4net;
  39. using System.Reflection;
  40. using System.Data.Common;
  41. // DBMS-specific:
  42. using MySql.Data.MySqlClient;
  43. using OpenSim.Data.MySQL;
  44. using System.Data.SqlClient;
  45. using OpenSim.Data.MSSQL;
  46. using Mono.Data.Sqlite;
  47. using OpenSim.Data.SQLite;
  48. namespace OpenSim.Data.Tests
  49. {
  50. [TestFixture(Description = "Region store tests (SQLite)")]
  51. public class SQLiteRegionTests : RegionTests<SqliteConnection, SQLiteSimulationData>
  52. {
  53. }
  54. [TestFixture(Description = "Region store tests (MySQL)")]
  55. public class MySqlRegionTests : RegionTests<MySqlConnection, MySQLSimulationData>
  56. {
  57. }
  58. [TestFixture(Description = "Region store tests (MS SQL Server)")]
  59. public class MSSQLRegionTests : RegionTests<SqlConnection, MSSQLSimulationData>
  60. {
  61. }
  62. public class RegionTests<TConn, TRegStore> : BasicDataServiceTest<TConn, TRegStore>
  63. where TConn : DbConnection, new()
  64. where TRegStore : class, ISimulationDataStore, new()
  65. {
  66. bool m_rebuildDB;
  67. public ISimulationDataStore db;
  68. public UUID zero = UUID.Zero;
  69. public UUID region1 = UUID.Random();
  70. public UUID region2 = UUID.Random();
  71. public UUID region3 = UUID.Random();
  72. public UUID region4 = UUID.Random();
  73. public UUID prim1 = UUID.Random();
  74. public UUID prim2 = UUID.Random();
  75. public UUID prim3 = UUID.Random();
  76. public UUID prim4 = UUID.Random();
  77. public UUID prim5 = UUID.Random();
  78. public UUID prim6 = UUID.Random();
  79. public UUID item1 = UUID.Random();
  80. public UUID item2 = UUID.Random();
  81. public UUID item3 = UUID.Random();
  82. public static Random random = new Random();
  83. public string itemname1 = "item1";
  84. public uint localID = 1;
  85. public double height1 = 20;
  86. public double height2 = 100;
  87. public RegionTests(string conn, bool rebuild)
  88. : base(conn)
  89. {
  90. m_rebuildDB = rebuild;
  91. }
  92. public RegionTests() : this("", true) { }
  93. public RegionTests(string conn) : this(conn, true) {}
  94. public RegionTests(bool rebuild): this("", rebuild) {}
  95. protected override void InitService(object service)
  96. {
  97. ClearDB();
  98. db = (ISimulationDataStore)service;
  99. db.Initialise(m_connStr);
  100. }
  101. private void ClearDB()
  102. {
  103. string[] reg_tables = new string[] {
  104. "prims", "primshapes", "primitems", "terrain", "land", "landaccesslist", "regionban", "regionsettings"
  105. };
  106. if (m_rebuildDB)
  107. {
  108. DropTables(reg_tables);
  109. ResetMigrations("RegionStore");
  110. }
  111. else
  112. {
  113. ClearTables(reg_tables);
  114. }
  115. }
  116. // Test Plan
  117. // Prims
  118. // - empty test - 001
  119. // - store / retrieve basic prims (most minimal we can make) - 010, 011
  120. // - store / retrieve parts in a scenegroup 012
  121. // - store a prim with complete information for consistency check 013
  122. // - update existing prims, make sure it sticks - 014
  123. // - tests empty inventory - 020
  124. // - add inventory items to prims make - 021
  125. // - retrieves the added item - 022
  126. // - update inventory items to prims - 023
  127. // - remove inventory items make sure it sticks - 024
  128. // - checks if all parameters are persistent - 025
  129. // - adds many items and see if it is handled correctly - 026
  130. [Test]
  131. public void T001_LoadEmpty()
  132. {
  133. TestHelpers.InMethod();
  134. List<SceneObjectGroup> objs = db.LoadObjects(region1);
  135. List<SceneObjectGroup> objs3 = db.LoadObjects(region3);
  136. List<LandData> land = db.LoadLandObjects(region1);
  137. Assert.That(objs.Count, Is.EqualTo(0), "Assert.That(objs.Count, Is.EqualTo(0))");
  138. Assert.That(objs3.Count, Is.EqualTo(0), "Assert.That(objs3.Count, Is.EqualTo(0))");
  139. Assert.That(land.Count, Is.EqualTo(0), "Assert.That(land.Count, Is.EqualTo(0))");
  140. }
  141. // SOG round trips
  142. // * store objects, make sure they save
  143. // * update
  144. [Test]
  145. public void T010_StoreSimpleObject()
  146. {
  147. TestHelpers.InMethod();
  148. SceneObjectGroup sog = NewSOG("object1", prim1, region1);
  149. SceneObjectGroup sog2 = NewSOG("object2", prim2, region1);
  150. // in case the objects don't store
  151. try
  152. {
  153. db.StoreObject(sog, region1);
  154. }
  155. catch (Exception e)
  156. {
  157. m_log.Error(e.ToString());
  158. Assert.Fail();
  159. }
  160. try
  161. {
  162. db.StoreObject(sog2, region1);
  163. }
  164. catch (Exception e)
  165. {
  166. m_log.Error(e.ToString());
  167. Assert.Fail();
  168. }
  169. // This tests the ADO.NET driver
  170. List<SceneObjectGroup> objs = db.LoadObjects(region1);
  171. Assert.That(objs.Count, Is.EqualTo(2), "Assert.That(objs.Count, Is.EqualTo(2))");
  172. }
  173. [Test]
  174. public void T011_ObjectNames()
  175. {
  176. TestHelpers.InMethod();
  177. List<SceneObjectGroup> objs = db.LoadObjects(region1);
  178. foreach (SceneObjectGroup sog in objs)
  179. {
  180. SceneObjectPart p = sog.RootPart;
  181. Assert.That("", Is.Not.EqualTo(p.Name), "Assert.That(\"\", Is.Not.EqualTo(p.Name))");
  182. Assert.That(p.Name, Is.EqualTo(p.Description), "Assert.That(p.Name, Is.EqualTo(p.Description))");
  183. }
  184. }
  185. [Test]
  186. public void T012_SceneParts()
  187. {
  188. TestHelpers.InMethod();
  189. UUID tmp0 = UUID.Random();
  190. UUID tmp1 = UUID.Random();
  191. UUID tmp2 = UUID.Random();
  192. UUID tmp3 = UUID.Random();
  193. UUID newregion = UUID.Random();
  194. SceneObjectPart p1 = NewSOP("SoP 1",tmp1);
  195. SceneObjectPart p2 = NewSOP("SoP 2",tmp2);
  196. SceneObjectPart p3 = NewSOP("SoP 3",tmp3);
  197. SceneObjectGroup sog = NewSOG("Sop 0", tmp0, newregion);
  198. sog.AddPart(p1);
  199. sog.AddPart(p2);
  200. sog.AddPart(p3);
  201. SceneObjectPart[] parts = sog.Parts;
  202. Assert.That(parts.Length,Is.EqualTo(4), "Assert.That(parts.Length,Is.EqualTo(4))");
  203. db.StoreObject(sog, newregion);
  204. List<SceneObjectGroup> sogs = db.LoadObjects(newregion);
  205. Assert.That(sogs.Count,Is.EqualTo(1), "Assert.That(sogs.Count,Is.EqualTo(1))");
  206. SceneObjectGroup newsog = sogs[0];
  207. SceneObjectPart[] newparts = newsog.Parts;
  208. Assert.That(newparts.Length,Is.EqualTo(4), "Assert.That(newparts.Length,Is.EqualTo(4))");
  209. Assert.That(newsog.ContainsPart(tmp0), "Assert.That(newsog.ContainsPart(tmp0))");
  210. Assert.That(newsog.ContainsPart(tmp1), "Assert.That(newsog.ContainsPart(tmp1))");
  211. Assert.That(newsog.ContainsPart(tmp2), "Assert.That(newsog.ContainsPart(tmp2))");
  212. Assert.That(newsog.ContainsPart(tmp3), "Assert.That(newsog.ContainsPart(tmp3))");
  213. }
  214. [Test]
  215. public void T013_DatabasePersistency()
  216. {
  217. TestHelpers.InMethod();
  218. // Sets all ScenePart parameters, stores and retrieves them, then check for consistency with initial data
  219. // The commented Asserts are the ones that are unchangeable (when storing on the database, their "Set" values are ignored
  220. // The ObjectFlags is an exception, if it is entered incorrectly, the object IS REJECTED on the database silently.
  221. UUID creator,uuid = new UUID();
  222. creator = UUID.Random();
  223. uint iserial = (uint)random.Next();
  224. TaskInventoryDictionary dic = new TaskInventoryDictionary();
  225. uint objf = (uint) random.Next();
  226. uuid = prim4;
  227. uint localid = localID+1;
  228. localID = localID + 1;
  229. string name = "Adam West";
  230. byte material = (byte) random.Next(127);
  231. ulong regionh = (ulong)random.NextDouble() * (ulong)random.Next();
  232. int pin = random.Next();
  233. Byte[] partsys = new byte[8];
  234. Byte[] textani = new byte[8];
  235. random.NextBytes(textani);
  236. random.NextBytes(partsys);
  237. DateTime expires = new DateTime(2008, 12, 20);
  238. DateTime rezzed = new DateTime(2009, 07, 15);
  239. Vector3 groupos = new Vector3(random.Next(),random.Next(),random.Next());
  240. Vector3 offset = new Vector3(random.Next(),random.Next(),random.Next());
  241. Quaternion rotoff = new Quaternion(random.Next(),random.Next(),random.Next(),random.Next());
  242. Vector3 velocity = new Vector3(random.Next(),random.Next(),random.Next());
  243. Vector3 angvelo = new Vector3(random.Next(),random.Next(),random.Next());
  244. Vector3 accel = new Vector3(random.Next(),random.Next(),random.Next());
  245. string description = name;
  246. Color color = Color.FromArgb(255, 165, 50, 100);
  247. string text = "All Your Base Are Belong to Us";
  248. string sitname = "SitName";
  249. string touchname = "TouchName";
  250. int linknum = random.Next();
  251. byte clickaction = (byte) random.Next(127);
  252. PrimitiveBaseShape pbshap = new PrimitiveBaseShape();
  253. pbshap = PrimitiveBaseShape.Default;
  254. pbshap.PathBegin = ushort.MaxValue;
  255. pbshap.PathEnd = ushort.MaxValue;
  256. pbshap.ProfileBegin = ushort.MaxValue;
  257. pbshap.ProfileEnd = ushort.MaxValue;
  258. pbshap.ProfileHollow = ushort.MaxValue;
  259. Vector3 scale = new Vector3(random.Next(),random.Next(),random.Next());
  260. RegionInfo regionInfo = new RegionInfo();
  261. regionInfo.RegionID = region3;
  262. regionInfo.RegionLocX = 0;
  263. regionInfo.RegionLocY = 0;
  264. SceneObjectPart sop = new SceneObjectPart();
  265. SceneObjectGroup sog = new SceneObjectGroup(sop);
  266. sop.RegionHandle = regionh;
  267. sop.UUID = uuid;
  268. sop.LocalId = localid;
  269. sop.Shape = pbshap;
  270. sop.GroupPosition = groupos;
  271. sop.RotationOffset = rotoff;
  272. sop.CreatorID = creator;
  273. sop.InventorySerial = iserial;
  274. sop.TaskInventory = dic;
  275. sop.Flags = (PrimFlags)objf;
  276. sop.Name = name;
  277. sop.Material = material;
  278. sop.ScriptAccessPin = pin;
  279. sop.TextureAnimation = textani;
  280. sop.ParticleSystem = partsys;
  281. sop.Expires = expires;
  282. sop.Rezzed = rezzed;
  283. sop.OffsetPosition = offset;
  284. sop.Velocity = velocity;
  285. sop.AngularVelocity = angvelo;
  286. sop.Acceleration = accel;
  287. sop.Description = description;
  288. sop.Color = color;
  289. sop.Text = text;
  290. sop.SitName = sitname;
  291. sop.TouchName = touchname;
  292. sop.LinkNum = linknum;
  293. sop.ClickAction = clickaction;
  294. sop.Scale = scale;
  295. //Tests if local part accepted the parameters:
  296. Assert.That(regionh,Is.EqualTo(sop.RegionHandle), "Assert.That(regionh,Is.EqualTo(sop.RegionHandle))");
  297. Assert.That(localid,Is.EqualTo(sop.LocalId), "Assert.That(localid,Is.EqualTo(sop.LocalId))");
  298. Assert.That(groupos,Is.EqualTo(sop.GroupPosition), "Assert.That(groupos,Is.EqualTo(sop.GroupPosition))");
  299. Assert.That(name,Is.EqualTo(sop.Name), "Assert.That(name,Is.EqualTo(sop.Name))");
  300. Assert.That(rotoff,Is.EqualTo(sop.RotationOffset), "Assert.That(rotoff,Is.EqualTo(sop.RotationOffset))");
  301. Assert.That(uuid,Is.EqualTo(sop.UUID), "Assert.That(uuid,Is.EqualTo(sop.UUID))");
  302. Assert.That(creator,Is.EqualTo(sop.CreatorID), "Assert.That(creator,Is.EqualTo(sop.CreatorID))");
  303. // Modified in-class
  304. // Assert.That(iserial,Is.EqualTo(sop.InventorySerial), "Assert.That(iserial,Is.EqualTo(sop.InventorySerial))");
  305. Assert.That(dic,Is.EqualTo(sop.TaskInventory), "Assert.That(dic,Is.EqualTo(sop.TaskInventory))");
  306. Assert.That(objf, Is.EqualTo((uint)sop.Flags), "Assert.That(objf,Is.EqualTo(sop.Flags))");
  307. Assert.That(name,Is.EqualTo(sop.Name), "Assert.That(name,Is.EqualTo(sop.Name))");
  308. Assert.That(material,Is.EqualTo(sop.Material), "Assert.That(material,Is.EqualTo(sop.Material))");
  309. Assert.That(pin,Is.EqualTo(sop.ScriptAccessPin), "Assert.That(pin,Is.EqualTo(sop.ScriptAccessPin))");
  310. Assert.That(textani,Is.EqualTo(sop.TextureAnimation), "Assert.That(textani,Is.EqualTo(sop.TextureAnimation))");
  311. Assert.That(partsys,Is.EqualTo(sop.ParticleSystem), "Assert.That(partsys,Is.EqualTo(sop.ParticleSystem))");
  312. Assert.That(expires,Is.EqualTo(sop.Expires), "Assert.That(expires,Is.EqualTo(sop.Expires))");
  313. Assert.That(rezzed,Is.EqualTo(sop.Rezzed), "Assert.That(rezzed,Is.EqualTo(sop.Rezzed))");
  314. Assert.That(offset,Is.EqualTo(sop.OffsetPosition), "Assert.That(offset,Is.EqualTo(sop.OffsetPosition))");
  315. Assert.That(velocity,Is.EqualTo(sop.Velocity), "Assert.That(velocity,Is.EqualTo(sop.Velocity))");
  316. Assert.That(angvelo,Is.EqualTo(sop.AngularVelocity), "Assert.That(angvelo,Is.EqualTo(sop.AngularVelocity))");
  317. Assert.That(accel,Is.EqualTo(sop.Acceleration), "Assert.That(accel,Is.EqualTo(sop.Acceleration))");
  318. Assert.That(description,Is.EqualTo(sop.Description), "Assert.That(description,Is.EqualTo(sop.Description))");
  319. Assert.That(color,Is.EqualTo(sop.Color), "Assert.That(color,Is.EqualTo(sop.Color))");
  320. Assert.That(text,Is.EqualTo(sop.Text), "Assert.That(text,Is.EqualTo(sop.Text))");
  321. Assert.That(sitname,Is.EqualTo(sop.SitName), "Assert.That(sitname,Is.EqualTo(sop.SitName))");
  322. Assert.That(touchname,Is.EqualTo(sop.TouchName), "Assert.That(touchname,Is.EqualTo(sop.TouchName))");
  323. Assert.That(linknum,Is.EqualTo(sop.LinkNum), "Assert.That(linknum,Is.EqualTo(sop.LinkNum))");
  324. Assert.That(clickaction,Is.EqualTo(sop.ClickAction), "Assert.That(clickaction,Is.EqualTo(sop.ClickAction))");
  325. Assert.That(scale,Is.EqualTo(sop.Scale), "Assert.That(scale,Is.EqualTo(sop.Scale))");
  326. // This is necessary or object will not be inserted in DB
  327. sop.Flags = PrimFlags.None;
  328. // Inserts group in DB
  329. db.StoreObject(sog,region3);
  330. List<SceneObjectGroup> sogs = db.LoadObjects(region3);
  331. Assert.That(sogs.Count, Is.EqualTo(1), "Assert.That(sogs.Count, Is.EqualTo(1))");
  332. // Makes sure there are no double insertions:
  333. db.StoreObject(sog,region3);
  334. sogs = db.LoadObjects(region3);
  335. Assert.That(sogs.Count, Is.EqualTo(1), "Assert.That(sogs.Count, Is.EqualTo(1))");
  336. // Tests if the parameters were inserted correctly
  337. SceneObjectPart p = sogs[0].RootPart;
  338. Assert.That(regionh,Is.EqualTo(p.RegionHandle), "Assert.That(regionh,Is.EqualTo(p.RegionHandle))");
  339. //Assert.That(localid,Is.EqualTo(p.LocalId), "Assert.That(localid,Is.EqualTo(p.LocalId))");
  340. Assert.That(groupos,Is.EqualTo(p.GroupPosition), "Assert.That(groupos,Is.EqualTo(p.GroupPosition))");
  341. Assert.That(name,Is.EqualTo(p.Name), "Assert.That(name,Is.EqualTo(p.Name))");
  342. Assert.That(rotoff,Is.EqualTo(p.RotationOffset), "Assert.That(rotoff,Is.EqualTo(p.RotationOffset))");
  343. Assert.That(uuid,Is.EqualTo(p.UUID), "Assert.That(uuid,Is.EqualTo(p.UUID))");
  344. Assert.That(creator,Is.EqualTo(p.CreatorID), "Assert.That(creator,Is.EqualTo(p.CreatorID))");
  345. //Assert.That(iserial,Is.EqualTo(p.InventorySerial), "Assert.That(iserial,Is.EqualTo(p.InventorySerial))");
  346. Assert.That(dic,Is.EqualTo(p.TaskInventory), "Assert.That(dic,Is.EqualTo(p.TaskInventory))");
  347. //Assert.That(objf, Is.EqualTo((uint)p.Flags), "Assert.That(objf,Is.EqualTo(p.Flags))");
  348. Assert.That(name,Is.EqualTo(p.Name), "Assert.That(name,Is.EqualTo(p.Name))");
  349. Assert.That(material,Is.EqualTo(p.Material), "Assert.That(material,Is.EqualTo(p.Material))");
  350. Assert.That(pin,Is.EqualTo(p.ScriptAccessPin), "Assert.That(pin,Is.EqualTo(p.ScriptAccessPin))");
  351. Assert.That(textani,Is.EqualTo(p.TextureAnimation), "Assert.That(textani,Is.EqualTo(p.TextureAnimation))");
  352. Assert.That(partsys,Is.EqualTo(p.ParticleSystem), "Assert.That(partsys,Is.EqualTo(p.ParticleSystem))");
  353. //Assert.That(expires,Is.EqualTo(p.Expires), "Assert.That(expires,Is.EqualTo(p.Expires))");
  354. //Assert.That(rezzed,Is.EqualTo(p.Rezzed), "Assert.That(rezzed,Is.EqualTo(p.Rezzed))");
  355. Assert.That(offset,Is.EqualTo(p.OffsetPosition), "Assert.That(offset,Is.EqualTo(p.OffsetPosition))");
  356. Assert.That(velocity,Is.EqualTo(p.Velocity), "Assert.That(velocity,Is.EqualTo(p.Velocity))");
  357. Assert.That(angvelo,Is.EqualTo(p.AngularVelocity), "Assert.That(angvelo,Is.EqualTo(p.AngularVelocity))");
  358. Assert.That(accel,Is.EqualTo(p.Acceleration), "Assert.That(accel,Is.EqualTo(p.Acceleration))");
  359. Assert.That(description,Is.EqualTo(p.Description), "Assert.That(description,Is.EqualTo(p.Description))");
  360. Assert.That(color,Is.EqualTo(p.Color), "Assert.That(color,Is.EqualTo(p.Color))");
  361. Assert.That(text,Is.EqualTo(p.Text), "Assert.That(text,Is.EqualTo(p.Text))");
  362. Assert.That(sitname,Is.EqualTo(p.SitName), "Assert.That(sitname,Is.EqualTo(p.SitName))");
  363. Assert.That(touchname,Is.EqualTo(p.TouchName), "Assert.That(touchname,Is.EqualTo(p.TouchName))");
  364. //Assert.That(linknum,Is.EqualTo(p.LinkNum), "Assert.That(linknum,Is.EqualTo(p.LinkNum))");
  365. Assert.That(clickaction,Is.EqualTo(p.ClickAction), "Assert.That(clickaction,Is.EqualTo(p.ClickAction))");
  366. Assert.That(scale,Is.EqualTo(p.Scale), "Assert.That(scale,Is.EqualTo(p.Scale))");
  367. //Assert.That(updatef,Is.EqualTo(p.UpdateFlag), "Assert.That(updatef,Is.EqualTo(p.UpdateFlag))");
  368. Assert.That(pbshap.PathBegin, Is.EqualTo(p.Shape.PathBegin), "Assert.That(pbshap.PathBegin, Is.EqualTo(p.Shape.PathBegin))");
  369. Assert.That(pbshap.PathEnd, Is.EqualTo(p.Shape.PathEnd), "Assert.That(pbshap.PathEnd, Is.EqualTo(p.Shape.PathEnd))");
  370. Assert.That(pbshap.ProfileBegin, Is.EqualTo(p.Shape.ProfileBegin), "Assert.That(pbshap.ProfileBegin, Is.EqualTo(p.Shape.ProfileBegin))");
  371. Assert.That(pbshap.ProfileEnd, Is.EqualTo(p.Shape.ProfileEnd), "Assert.That(pbshap.ProfileEnd, Is.EqualTo(p.Shape.ProfileEnd))");
  372. Assert.That(pbshap.ProfileHollow, Is.EqualTo(p.Shape.ProfileHollow), "Assert.That(pbshap.ProfileHollow, Is.EqualTo(p.Shape.ProfileHollow))");
  373. }
  374. [Test]
  375. public void T014_UpdateObject()
  376. {
  377. TestHelpers.InMethod();
  378. string text1 = "object1 text";
  379. SceneObjectGroup sog = FindSOG("object1", region1);
  380. sog.RootPart.Text = text1;
  381. db.StoreObject(sog, region1);
  382. sog = FindSOG("object1", region1);
  383. Assert.That(text1, Is.EqualTo(sog.RootPart.Text), "Assert.That(text1, Is.EqualTo(sog.RootPart.Text))");
  384. // Creates random values
  385. UUID creator = new UUID();
  386. creator = UUID.Random();
  387. TaskInventoryDictionary dic = new TaskInventoryDictionary();
  388. localID = localID + 1;
  389. string name = "West Adam";
  390. byte material = (byte) random.Next(127);
  391. ulong regionh = (ulong)random.NextDouble() * (ulong)random.Next();
  392. int pin = random.Next();
  393. Byte[] partsys = new byte[8];
  394. Byte[] textani = new byte[8];
  395. random.NextBytes(textani);
  396. random.NextBytes(partsys);
  397. DateTime expires = new DateTime(2010, 12, 20);
  398. DateTime rezzed = new DateTime(2005, 07, 15);
  399. Vector3 groupos = new Vector3(random.Next(),random.Next(),random.Next());
  400. Vector3 offset = new Vector3(random.Next(),random.Next(),random.Next());
  401. Quaternion rotoff = new Quaternion(random.Next(),random.Next(),random.Next(),random.Next());
  402. Vector3 velocity = new Vector3(random.Next(),random.Next(),random.Next());
  403. Vector3 angvelo = new Vector3(random.Next(),random.Next(),random.Next());
  404. Vector3 accel = new Vector3(random.Next(),random.Next(),random.Next());
  405. string description = name;
  406. Color color = Color.FromArgb(255, 255, 255, 0);
  407. string text = "What You Say?{]\vz~";
  408. string sitname = RandomName();
  409. string touchname = RandomName();
  410. int linknum = random.Next();
  411. byte clickaction = (byte) random.Next(127);
  412. PrimitiveBaseShape pbshap = new PrimitiveBaseShape();
  413. pbshap = PrimitiveBaseShape.Default;
  414. Vector3 scale = new Vector3(random.Next(),random.Next(),random.Next());
  415. // Updates the region with new values
  416. SceneObjectGroup sog2 = FindSOG("Adam West", region3);
  417. Assert.That(sog2,Is.Not.Null);
  418. sog2.RootPart.RegionHandle = regionh;
  419. sog2.RootPart.Shape = pbshap;
  420. sog2.RootPart.GroupPosition = groupos;
  421. sog2.RootPart.RotationOffset = rotoff;
  422. sog2.RootPart.CreatorID = creator;
  423. sog2.RootPart.TaskInventory = dic;
  424. sog2.RootPart.Name = name;
  425. sog2.RootPart.Material = material;
  426. sog2.RootPart.ScriptAccessPin = pin;
  427. sog2.RootPart.TextureAnimation = textani;
  428. sog2.RootPart.ParticleSystem = partsys;
  429. sog2.RootPart.Expires = expires;
  430. sog2.RootPart.Rezzed = rezzed;
  431. sog2.RootPart.OffsetPosition = offset;
  432. sog2.RootPart.Velocity = velocity;
  433. sog2.RootPart.AngularVelocity = angvelo;
  434. sog2.RootPart.Acceleration = accel;
  435. sog2.RootPart.Description = description;
  436. sog2.RootPart.Color = color;
  437. sog2.RootPart.Text = text;
  438. sog2.RootPart.SitName = sitname;
  439. sog2.RootPart.TouchName = touchname;
  440. sog2.RootPart.LinkNum = linknum;
  441. sog2.RootPart.ClickAction = clickaction;
  442. sog2.RootPart.Scale = scale;
  443. db.StoreObject(sog2, region3);
  444. List<SceneObjectGroup> sogs = db.LoadObjects(region3);
  445. Assert.That(sogs.Count, Is.EqualTo(1), "Assert.That(sogs.Count, Is.EqualTo(1))");
  446. SceneObjectGroup retsog = FindSOG("West Adam", region3);
  447. Assert.That(retsog,Is.Not.Null);
  448. SceneObjectPart p = retsog.RootPart;
  449. Assert.That(regionh,Is.EqualTo(p.RegionHandle), "Assert.That(regionh,Is.EqualTo(p.RegionHandle))");
  450. Assert.That(groupos,Is.EqualTo(p.GroupPosition), "Assert.That(groupos,Is.EqualTo(p.GroupPosition))");
  451. Assert.That(name,Is.EqualTo(p.Name), "Assert.That(name,Is.EqualTo(p.Name))");
  452. Assert.That(rotoff,Is.EqualTo(p.RotationOffset), "Assert.That(rotoff,Is.EqualTo(p.RotationOffset))");
  453. Assert.That(creator,Is.EqualTo(p.CreatorID), "Assert.That(creator,Is.EqualTo(p.CreatorID))");
  454. Assert.That(dic,Is.EqualTo(p.TaskInventory), "Assert.That(dic,Is.EqualTo(p.TaskInventory))");
  455. Assert.That(name,Is.EqualTo(p.Name), "Assert.That(name,Is.EqualTo(p.Name))");
  456. Assert.That(material,Is.EqualTo(p.Material), "Assert.That(material,Is.EqualTo(p.Material))");
  457. Assert.That(pin,Is.EqualTo(p.ScriptAccessPin), "Assert.That(pin,Is.EqualTo(p.ScriptAccessPin))");
  458. Assert.That(textani,Is.EqualTo(p.TextureAnimation), "Assert.That(textani,Is.EqualTo(p.TextureAnimation))");
  459. Assert.That(partsys,Is.EqualTo(p.ParticleSystem), "Assert.That(partsys,Is.EqualTo(p.ParticleSystem))");
  460. Assert.That(offset,Is.EqualTo(p.OffsetPosition), "Assert.That(offset,Is.EqualTo(p.OffsetPosition))");
  461. Assert.That(velocity,Is.EqualTo(p.Velocity), "Assert.That(velocity,Is.EqualTo(p.Velocity))");
  462. Assert.That(angvelo,Is.EqualTo(p.AngularVelocity), "Assert.That(angvelo,Is.EqualTo(p.AngularVelocity))");
  463. Assert.That(accel,Is.EqualTo(p.Acceleration), "Assert.That(accel,Is.EqualTo(p.Acceleration))");
  464. Assert.That(description,Is.EqualTo(p.Description), "Assert.That(description,Is.EqualTo(p.Description))");
  465. Assert.That(color,Is.EqualTo(p.Color), "Assert.That(color,Is.EqualTo(p.Color))");
  466. Assert.That(text,Is.EqualTo(p.Text), "Assert.That(text,Is.EqualTo(p.Text))");
  467. Assert.That(sitname,Is.EqualTo(p.SitName), "Assert.That(sitname,Is.EqualTo(p.SitName))");
  468. Assert.That(touchname,Is.EqualTo(p.TouchName), "Assert.That(touchname,Is.EqualTo(p.TouchName))");
  469. Assert.That(clickaction,Is.EqualTo(p.ClickAction), "Assert.That(clickaction,Is.EqualTo(p.ClickAction))");
  470. Assert.That(scale,Is.EqualTo(p.Scale), "Assert.That(scale,Is.EqualTo(p.Scale))");
  471. }
  472. /// <summary>
  473. /// Test storage and retrieval of a scene object with a large number of parts.
  474. /// </summary>
  475. [Test]
  476. public void T015_LargeSceneObjects()
  477. {
  478. TestHelpers.InMethod();
  479. UUID id = UUID.Random();
  480. Dictionary<UUID, SceneObjectPart> mydic = new Dictionary<UUID, SceneObjectPart>();
  481. SceneObjectGroup sog = NewSOG("Test SOG", id, region4);
  482. mydic.Add(sog.RootPart.UUID,sog.RootPart);
  483. for (int i = 0; i < 30; i++)
  484. {
  485. UUID tmp = UUID.Random();
  486. SceneObjectPart sop = NewSOP(("Test SOP " + i.ToString()),tmp);
  487. Vector3 groupos = new Vector3(random.Next(),random.Next(),random.Next());
  488. Vector3 offset = new Vector3(random.Next(),random.Next(),random.Next());
  489. Quaternion rotoff = new Quaternion(random.Next(),random.Next(),random.Next(),random.Next());
  490. Vector3 velocity = new Vector3(random.Next(),random.Next(),random.Next());
  491. Vector3 angvelo = new Vector3(random.Next(),random.Next(),random.Next());
  492. Vector3 accel = new Vector3(random.Next(),random.Next(),random.Next());
  493. sop.GroupPosition = groupos;
  494. sop.RotationOffset = rotoff;
  495. sop.OffsetPosition = offset;
  496. sop.Velocity = velocity;
  497. sop.AngularVelocity = angvelo;
  498. sop.Acceleration = accel;
  499. mydic.Add(tmp,sop);
  500. sog.AddPart(sop);
  501. }
  502. db.StoreObject(sog, region4);
  503. SceneObjectGroup retsog = FindSOG("Test SOG", region4);
  504. SceneObjectPart[] parts = retsog.Parts;
  505. for (int i = 0; i < 30; i++)
  506. {
  507. SceneObjectPart cursop = mydic[parts[i].UUID];
  508. Assert.That(cursop.GroupPosition,Is.EqualTo(parts[i].GroupPosition), "Assert.That(cursop.GroupPosition,Is.EqualTo(parts[i].GroupPosition))");
  509. Assert.That(cursop.RotationOffset,Is.EqualTo(parts[i].RotationOffset), "Assert.That(cursop.RotationOffset,Is.EqualTo(parts[i].RotationOffset))");
  510. Assert.That(cursop.OffsetPosition,Is.EqualTo(parts[i].OffsetPosition), "Assert.That(cursop.OffsetPosition,Is.EqualTo(parts[i].OffsetPosition))");
  511. Assert.That(cursop.Velocity,Is.EqualTo(parts[i].Velocity), "Assert.That(cursop.Velocity,Is.EqualTo(parts[i].Velocity))");
  512. Assert.That(cursop.AngularVelocity,Is.EqualTo(parts[i].AngularVelocity), "Assert.That(cursop.AngularVelocity,Is.EqualTo(parts[i].AngularVelocity))");
  513. Assert.That(cursop.Acceleration,Is.EqualTo(parts[i].Acceleration), "Assert.That(cursop.Acceleration,Is.EqualTo(parts[i].Acceleration))");
  514. }
  515. }
  516. //[Test]
  517. public void T016_RandomSogWithSceneParts()
  518. {
  519. TestHelpers.InMethod();
  520. PropertyScrambler<SceneObjectPart> scrambler =
  521. new PropertyScrambler<SceneObjectPart>()
  522. .DontScramble(x => x.UUID);
  523. UUID tmpSog = UUID.Random();
  524. UUID tmp1 = UUID.Random();
  525. UUID tmp2 = UUID.Random();
  526. UUID tmp3 = UUID.Random();
  527. UUID newregion = UUID.Random();
  528. SceneObjectPart p1 = new SceneObjectPart();
  529. SceneObjectPart p2 = new SceneObjectPart();
  530. SceneObjectPart p3 = new SceneObjectPart();
  531. p1.Shape = PrimitiveBaseShape.Default;
  532. p2.Shape = PrimitiveBaseShape.Default;
  533. p3.Shape = PrimitiveBaseShape.Default;
  534. p1.UUID = tmp1;
  535. p2.UUID = tmp2;
  536. p3.UUID = tmp3;
  537. scrambler.Scramble(p1);
  538. scrambler.Scramble(p2);
  539. scrambler.Scramble(p3);
  540. SceneObjectGroup sog = NewSOG("Sop 0", tmpSog, newregion);
  541. PropertyScrambler<SceneObjectGroup> sogScrambler =
  542. new PropertyScrambler<SceneObjectGroup>()
  543. .DontScramble(x => x.UUID);
  544. sogScrambler.Scramble(sog);
  545. sog.UUID = tmpSog;
  546. sog.AddPart(p1);
  547. sog.AddPart(p2);
  548. sog.AddPart(p3);
  549. SceneObjectPart[] parts = sog.Parts;
  550. Assert.That(parts.Length, Is.EqualTo(4), "Assert.That(parts.Length,Is.EqualTo(4))");
  551. db.StoreObject(sog, newregion);
  552. List<SceneObjectGroup> sogs = db.LoadObjects(newregion);
  553. Assert.That(sogs.Count, Is.EqualTo(1), "Assert.That(sogs.Count,Is.EqualTo(1))");
  554. SceneObjectGroup newsog = sogs[0];
  555. SceneObjectPart[] newparts = newsog.Parts;
  556. Assert.That(newparts.Length, Is.EqualTo(4), "Assert.That(newparts.Length,Is.EqualTo(4))");
  557. Assert.That(newsog, Constraints.PropertyCompareConstraint(sog)
  558. .IgnoreProperty(x=>x.LocalId)
  559. .IgnoreProperty(x=>x.HasGroupChanged)
  560. .IgnoreProperty(x=>x.IsSelected)
  561. .IgnoreProperty(x=>x.RegionHandle)
  562. .IgnoreProperty(x=>x.RegionUUID)
  563. .IgnoreProperty(x=>x.Scene)
  564. .IgnoreProperty(x=>x.Parts)
  565. .IgnoreProperty(x=>x.RootPart));
  566. }
  567. private SceneObjectGroup GetMySOG(string name)
  568. {
  569. SceneObjectGroup sog = FindSOG(name, region1);
  570. if (sog == null)
  571. {
  572. sog = NewSOG(name, prim1, region1);
  573. db.StoreObject(sog, region1);
  574. }
  575. return sog;
  576. }
  577. // NOTE: it is a bad practice to rely on some of the previous tests having been run before.
  578. // If the tests are run manually, one at a time, each starts with full class init (DB cleared).
  579. // Even when all tests are run, NUnit 2.5+ no longer guarantee a specific test order.
  580. // We shouldn't expect to find anything in the DB if we haven't put it there *in the same test*!
  581. [Test]
  582. public void T020_PrimInventoryEmpty()
  583. {
  584. TestHelpers.InMethod();
  585. SceneObjectGroup sog = GetMySOG("object1");
  586. TaskInventoryItem t = sog.GetInventoryItem(sog.RootPart.LocalId, item1);
  587. Assert.That(t, Is.Null);
  588. }
  589. // TODO: Is there any point to call StorePrimInventory on a list, rather than on the prim itself?
  590. private void StoreInventory(SceneObjectGroup sog)
  591. {
  592. List<TaskInventoryItem> list = new List<TaskInventoryItem>();
  593. // TODO: seriously??? this is the way we need to loop to get this?
  594. foreach (UUID uuid in sog.RootPart.Inventory.GetInventoryList())
  595. {
  596. list.Add(sog.GetInventoryItem(sog.RootPart.LocalId, uuid));
  597. }
  598. db.StorePrimInventory(sog.RootPart.UUID, list);
  599. }
  600. [Test]
  601. public void T021_PrimInventoryBasic()
  602. {
  603. TestHelpers.InMethod();
  604. SceneObjectGroup sog = GetMySOG("object1");
  605. InventoryItemBase i = NewItem(item1, zero, zero, itemname1, zero);
  606. Assert.That(sog.AddInventoryItem(zero, sog.RootPart.LocalId, i, zero), Is.True);
  607. TaskInventoryItem t = sog.GetInventoryItem(sog.RootPart.LocalId, item1);
  608. Assert.That(t.Name, Is.EqualTo(itemname1), "Assert.That(t.Name, Is.EqualTo(itemname1))");
  609. StoreInventory(sog);
  610. SceneObjectGroup sog1 = FindSOG("object1", region1);
  611. Assert.That(sog1, Is.Not.Null);
  612. TaskInventoryItem t1 = sog1.GetInventoryItem(sog1.RootPart.LocalId, item1);
  613. Assert.That(t1, Is.Not.Null);
  614. Assert.That(t1.Name, Is.EqualTo(itemname1), "Assert.That(t.Name, Is.EqualTo(itemname1))");
  615. // Updating inventory
  616. t1.Name = "My New Name";
  617. sog1.UpdateInventoryItem(t1);
  618. StoreInventory(sog1);
  619. SceneObjectGroup sog2 = FindSOG("object1", region1);
  620. TaskInventoryItem t2 = sog2.GetInventoryItem(sog2.RootPart.LocalId, item1);
  621. Assert.That(t2.Name, Is.EqualTo("My New Name"), "Assert.That(t.Name, Is.EqualTo(\"My New Name\"))");
  622. // Removing inventory
  623. List<TaskInventoryItem> list = new List<TaskInventoryItem>();
  624. db.StorePrimInventory(prim1, list);
  625. sog = FindSOG("object1", region1);
  626. t = sog.GetInventoryItem(sog.RootPart.LocalId, item1);
  627. Assert.That(t, Is.Null);
  628. }
  629. [Test]
  630. public void T025_PrimInventoryPersistency()
  631. {
  632. TestHelpers.InMethod();
  633. InventoryItemBase i = new InventoryItemBase();
  634. UUID id = UUID.Random();
  635. i.ID = id;
  636. UUID folder = UUID.Random();
  637. i.Folder = folder;
  638. UUID owner = UUID.Random();
  639. i.Owner = owner;
  640. UUID creator = UUID.Random();
  641. i.CreatorId = creator.ToString();
  642. string name = RandomName();
  643. i.Name = name;
  644. i.Description = name;
  645. UUID assetid = UUID.Random();
  646. i.AssetID = assetid;
  647. int invtype = random.Next();
  648. i.InvType = invtype;
  649. uint nextperm = (uint) random.Next();
  650. i.NextPermissions = nextperm;
  651. uint curperm = (uint) random.Next();
  652. i.CurrentPermissions = curperm;
  653. uint baseperm = (uint) random.Next();
  654. i.BasePermissions = baseperm;
  655. uint eoperm = (uint) random.Next();
  656. i.EveryOnePermissions = eoperm;
  657. int assettype = random.Next();
  658. i.AssetType = assettype;
  659. UUID groupid = UUID.Random();
  660. i.GroupID = groupid;
  661. bool groupown = true;
  662. i.GroupOwned = groupown;
  663. int saleprice = random.Next();
  664. i.SalePrice = saleprice;
  665. byte saletype = (byte) random.Next(127);
  666. i.SaleType = saletype;
  667. uint flags = (uint) random.Next();
  668. i.Flags = flags;
  669. int creationd = random.Next();
  670. i.CreationDate = creationd;
  671. SceneObjectGroup sog = GetMySOG("object1");
  672. Assert.That(sog.AddInventoryItem(zero, sog.RootPart.LocalId, i, zero), Is.True);
  673. TaskInventoryItem t = sog.GetInventoryItem(sog.RootPart.LocalId, id);
  674. Assert.That(t.Name, Is.EqualTo(name), "Assert.That(t.Name, Is.EqualTo(name))");
  675. Assert.That(t.AssetID,Is.EqualTo(assetid), "Assert.That(t.AssetID,Is.EqualTo(assetid))");
  676. Assert.That(t.BasePermissions,Is.EqualTo(baseperm), "Assert.That(t.BasePermissions,Is.EqualTo(baseperm))");
  677. Assert.That(t.CreationDate,Is.EqualTo(creationd), "Assert.That(t.CreationDate,Is.EqualTo(creationd))");
  678. Assert.That(t.CreatorID,Is.EqualTo(creator), "Assert.That(t.CreatorID,Is.EqualTo(creator))");
  679. Assert.That(t.Description,Is.EqualTo(name), "Assert.That(t.Description,Is.EqualTo(name))");
  680. Assert.That(t.EveryonePermissions,Is.EqualTo(eoperm), "Assert.That(t.EveryonePermissions,Is.EqualTo(eoperm))");
  681. Assert.That(t.Flags,Is.EqualTo(flags), "Assert.That(t.Flags,Is.EqualTo(flags))");
  682. Assert.That(t.GroupID,Is.EqualTo(sog.RootPart.GroupID), "Assert.That(t.GroupID,Is.EqualTo(sog.RootPart.GroupID))");
  683. // Where is this group permissions??
  684. // Assert.That(t.GroupPermissions,Is.EqualTo(), "Assert.That(t.GroupPermissions,Is.EqualTo())");
  685. Assert.That(t.Type,Is.EqualTo(assettype), "Assert.That(t.Type,Is.EqualTo(assettype))");
  686. Assert.That(t.InvType, Is.EqualTo(invtype), "Assert.That(t.InvType, Is.EqualTo(invtype))");
  687. Assert.That(t.ItemID, Is.EqualTo(id), "Assert.That(t.ItemID, Is.EqualTo(id))");
  688. Assert.That(t.LastOwnerID, Is.EqualTo(sog.RootPart.LastOwnerID), "Assert.That(t.LastOwnerID, Is.EqualTo(sog.RootPart.LastOwnerID))");
  689. Assert.That(t.NextPermissions, Is.EqualTo(nextperm), "Assert.That(t.NextPermissions, Is.EqualTo(nextperm))");
  690. // Ownership changes when you drop an object into an object
  691. // owned by someone else
  692. Assert.That(t.OwnerID,Is.EqualTo(sog.RootPart.OwnerID), "Assert.That(t.OwnerID,Is.EqualTo(sog.RootPart.OwnerID))");
  693. // Assert.That(t.CurrentPermissions, Is.EqualTo(curperm | 16), "Assert.That(t.CurrentPermissions, Is.EqualTo(curperm | 8))");
  694. Assert.That(t.ParentID,Is.EqualTo(sog.RootPart.FolderID), "Assert.That(t.ParentID,Is.EqualTo(sog.RootPart.FolderID))");
  695. Assert.That(t.ParentPartID,Is.EqualTo(sog.RootPart.UUID), "Assert.That(t.ParentPartID,Is.EqualTo(sog.RootPart.UUID))");
  696. }
  697. [Test]
  698. [ExpectedException(typeof(ArgumentException))]
  699. public void T026_PrimInventoryMany()
  700. {
  701. TestHelpers.InMethod();
  702. UUID i1,i2,i3,i4;
  703. i1 = UUID.Random();
  704. i2 = UUID.Random();
  705. i3 = UUID.Random();
  706. i4 = i3;
  707. InventoryItemBase ib1 = NewItem(i1, zero, zero, RandomName(), zero);
  708. InventoryItemBase ib2 = NewItem(i2, zero, zero, RandomName(), zero);
  709. InventoryItemBase ib3 = NewItem(i3, zero, zero, RandomName(), zero);
  710. InventoryItemBase ib4 = NewItem(i4, zero, zero, RandomName(), zero);
  711. SceneObjectGroup sog = FindSOG("object1", region1);
  712. Assert.That(sog.AddInventoryItem(zero, sog.RootPart.LocalId, ib1, zero), Is.True);
  713. Assert.That(sog.AddInventoryItem(zero, sog.RootPart.LocalId, ib2, zero), Is.True);
  714. Assert.That(sog.AddInventoryItem(zero, sog.RootPart.LocalId, ib3, zero), Is.True);
  715. Assert.That(sog.AddInventoryItem(zero, sog.RootPart.LocalId, ib4, zero), Is.True);
  716. TaskInventoryItem t1 = sog.GetInventoryItem(sog.RootPart.LocalId, i1);
  717. Assert.That(t1.Name, Is.EqualTo(ib1.Name), "Assert.That(t1.Name, Is.EqualTo(ib1.Name))");
  718. TaskInventoryItem t2 = sog.GetInventoryItem(sog.RootPart.LocalId, i2);
  719. Assert.That(t2.Name, Is.EqualTo(ib2.Name), "Assert.That(t2.Name, Is.EqualTo(ib2.Name))");
  720. TaskInventoryItem t3 = sog.GetInventoryItem(sog.RootPart.LocalId, i3);
  721. Assert.That(t3.Name, Is.EqualTo(ib3.Name), "Assert.That(t3.Name, Is.EqualTo(ib3.Name))");
  722. TaskInventoryItem t4 = sog.GetInventoryItem(sog.RootPart.LocalId, i4);
  723. Assert.That(t4, Is.Null);
  724. }
  725. [Test]
  726. public void T052_RemoveObject()
  727. {
  728. TestHelpers.InMethod();
  729. db.RemoveObject(prim1, region1);
  730. SceneObjectGroup sog = FindSOG("object1", region1);
  731. Assert.That(sog, Is.Null);
  732. }
  733. [Test]
  734. public void T100_DefaultRegionInfo()
  735. {
  736. TestHelpers.InMethod();
  737. RegionSettings r1 = db.LoadRegionSettings(region1);
  738. Assert.That(r1.RegionUUID, Is.EqualTo(region1), "Assert.That(r1.RegionUUID, Is.EqualTo(region1))");
  739. RegionSettings r2 = db.LoadRegionSettings(region2);
  740. Assert.That(r2.RegionUUID, Is.EqualTo(region2), "Assert.That(r2.RegionUUID, Is.EqualTo(region2))");
  741. }
  742. [Test]
  743. public void T101_UpdateRegionInfo()
  744. {
  745. TestHelpers.InMethod();
  746. int agentlimit = random.Next();
  747. double objectbonus = random.Next();
  748. int maturity = random.Next();
  749. UUID tertex1 = UUID.Random();
  750. UUID tertex2 = UUID.Random();
  751. UUID tertex3 = UUID.Random();
  752. UUID tertex4 = UUID.Random();
  753. double elev1nw = random.Next();
  754. double elev2nw = random.Next();
  755. double elev1ne = random.Next();
  756. double elev2ne = random.Next();
  757. double elev1se = random.Next();
  758. double elev2se = random.Next();
  759. double elev1sw = random.Next();
  760. double elev2sw = random.Next();
  761. double waterh = random.Next();
  762. double terrainraise = random.Next();
  763. double terrainlower = random.Next();
  764. Vector3 sunvector = new Vector3((float)Math.Round(random.NextDouble(),5),(float)Math.Round(random.NextDouble(),5),(float)Math.Round(random.NextDouble(),5));
  765. UUID terimgid = UUID.Random();
  766. double sunpos = random.Next();
  767. UUID cov = UUID.Random();
  768. RegionSettings r1 = db.LoadRegionSettings(region1);
  769. r1.BlockTerraform = true;
  770. r1.BlockFly = true;
  771. r1.AllowDamage = true;
  772. r1.RestrictPushing = true;
  773. r1.AllowLandResell = false;
  774. r1.AllowLandJoinDivide = false;
  775. r1.BlockShowInSearch = true;
  776. r1.AgentLimit = agentlimit;
  777. r1.ObjectBonus = objectbonus;
  778. r1.Maturity = maturity;
  779. r1.DisableScripts = true;
  780. r1.DisableCollisions = true;
  781. r1.DisablePhysics = true;
  782. r1.TerrainTexture1 = tertex1;
  783. r1.TerrainTexture2 = tertex2;
  784. r1.TerrainTexture3 = tertex3;
  785. r1.TerrainTexture4 = tertex4;
  786. r1.Elevation1NW = elev1nw;
  787. r1.Elevation2NW = elev2nw;
  788. r1.Elevation1NE = elev1ne;
  789. r1.Elevation2NE = elev2ne;
  790. r1.Elevation1SE = elev1se;
  791. r1.Elevation2SE = elev2se;
  792. r1.Elevation1SW = elev1sw;
  793. r1.Elevation2SW = elev2sw;
  794. r1.WaterHeight = waterh;
  795. r1.TerrainRaiseLimit = terrainraise;
  796. r1.TerrainLowerLimit = terrainlower;
  797. r1.UseEstateSun = false;
  798. r1.Sandbox = true;
  799. r1.SunVector = sunvector;
  800. r1.TerrainImageID = terimgid;
  801. r1.FixedSun = true;
  802. r1.SunPosition = sunpos;
  803. r1.Covenant = cov;
  804. db.StoreRegionSettings(r1);
  805. RegionSettings r1a = db.LoadRegionSettings(region1);
  806. Assert.That(r1a.RegionUUID, Is.EqualTo(region1), "Assert.That(r1a.RegionUUID, Is.EqualTo(region1))");
  807. Assert.That(r1a.BlockTerraform,Is.True);
  808. Assert.That(r1a.BlockFly,Is.True);
  809. Assert.That(r1a.AllowDamage,Is.True);
  810. Assert.That(r1a.RestrictPushing,Is.True);
  811. Assert.That(r1a.AllowLandResell,Is.False);
  812. Assert.That(r1a.AllowLandJoinDivide,Is.False);
  813. Assert.That(r1a.BlockShowInSearch,Is.True);
  814. Assert.That(r1a.AgentLimit,Is.EqualTo(agentlimit), "Assert.That(r1a.AgentLimit,Is.EqualTo(agentlimit))");
  815. Assert.That(r1a.ObjectBonus,Is.EqualTo(objectbonus), "Assert.That(r1a.ObjectBonus,Is.EqualTo(objectbonus))");
  816. Assert.That(r1a.Maturity,Is.EqualTo(maturity), "Assert.That(r1a.Maturity,Is.EqualTo(maturity))");
  817. Assert.That(r1a.DisableScripts,Is.True);
  818. Assert.That(r1a.DisableCollisions,Is.True);
  819. Assert.That(r1a.DisablePhysics,Is.True);
  820. Assert.That(r1a.TerrainTexture1,Is.EqualTo(tertex1), "Assert.That(r1a.TerrainTexture1,Is.EqualTo(tertex1))");
  821. Assert.That(r1a.TerrainTexture2,Is.EqualTo(tertex2), "Assert.That(r1a.TerrainTexture2,Is.EqualTo(tertex2))");
  822. Assert.That(r1a.TerrainTexture3,Is.EqualTo(tertex3), "Assert.That(r1a.TerrainTexture3,Is.EqualTo(tertex3))");
  823. Assert.That(r1a.TerrainTexture4,Is.EqualTo(tertex4), "Assert.That(r1a.TerrainTexture4,Is.EqualTo(tertex4))");
  824. Assert.That(r1a.Elevation1NW,Is.EqualTo(elev1nw), "Assert.That(r1a.Elevation1NW,Is.EqualTo(elev1nw))");
  825. Assert.That(r1a.Elevation2NW,Is.EqualTo(elev2nw), "Assert.That(r1a.Elevation2NW,Is.EqualTo(elev2nw))");
  826. Assert.That(r1a.Elevation1NE,Is.EqualTo(elev1ne), "Assert.That(r1a.Elevation1NE,Is.EqualTo(elev1ne))");
  827. Assert.That(r1a.Elevation2NE,Is.EqualTo(elev2ne), "Assert.That(r1a.Elevation2NE,Is.EqualTo(elev2ne))");
  828. Assert.That(r1a.Elevation1SE,Is.EqualTo(elev1se), "Assert.That(r1a.Elevation1SE,Is.EqualTo(elev1se))");
  829. Assert.That(r1a.Elevation2SE,Is.EqualTo(elev2se), "Assert.That(r1a.Elevation2SE,Is.EqualTo(elev2se))");
  830. Assert.That(r1a.Elevation1SW,Is.EqualTo(elev1sw), "Assert.That(r1a.Elevation1SW,Is.EqualTo(elev1sw))");
  831. Assert.That(r1a.Elevation2SW,Is.EqualTo(elev2sw), "Assert.That(r1a.Elevation2SW,Is.EqualTo(elev2sw))");
  832. Assert.That(r1a.WaterHeight,Is.EqualTo(waterh), "Assert.That(r1a.WaterHeight,Is.EqualTo(waterh))");
  833. Assert.That(r1a.TerrainRaiseLimit,Is.EqualTo(terrainraise), "Assert.That(r1a.TerrainRaiseLimit,Is.EqualTo(terrainraise))");
  834. Assert.That(r1a.TerrainLowerLimit,Is.EqualTo(terrainlower), "Assert.That(r1a.TerrainLowerLimit,Is.EqualTo(terrainlower))");
  835. Assert.That(r1a.UseEstateSun,Is.False);
  836. Assert.That(r1a.Sandbox,Is.True);
  837. Assert.That(r1a.SunVector,Is.EqualTo(sunvector), "Assert.That(r1a.SunVector,Is.EqualTo(sunvector))");
  838. //Assert.That(r1a.TerrainImageID,Is.EqualTo(terimgid), "Assert.That(r1a.TerrainImageID,Is.EqualTo(terimgid))");
  839. Assert.That(r1a.FixedSun,Is.True);
  840. Assert.That(r1a.SunPosition, Is.EqualTo(sunpos), "Assert.That(r1a.SunPosition, Is.EqualTo(sunpos))");
  841. Assert.That(r1a.Covenant, Is.EqualTo(cov), "Assert.That(r1a.Covenant, Is.EqualTo(cov))");
  842. }
  843. [Test]
  844. public void T300_NoTerrain()
  845. {
  846. TestHelpers.InMethod();
  847. Assert.That(db.LoadTerrain(zero), Is.Null);
  848. Assert.That(db.LoadTerrain(region1), Is.Null);
  849. Assert.That(db.LoadTerrain(region2), Is.Null);
  850. Assert.That(db.LoadTerrain(UUID.Random()), Is.Null);
  851. }
  852. [Test]
  853. public void T301_CreateTerrain()
  854. {
  855. TestHelpers.InMethod();
  856. double[,] t1 = GenTerrain(height1);
  857. db.StoreTerrain(t1, region1);
  858. Assert.That(db.LoadTerrain(zero), Is.Null);
  859. Assert.That(db.LoadTerrain(region1), Is.Not.Null);
  860. Assert.That(db.LoadTerrain(region2), Is.Null);
  861. Assert.That(db.LoadTerrain(UUID.Random()), Is.Null);
  862. }
  863. [Test]
  864. public void T302_FetchTerrain()
  865. {
  866. TestHelpers.InMethod();
  867. double[,] baseterrain1 = GenTerrain(height1);
  868. double[,] baseterrain2 = GenTerrain(height2);
  869. double[,] t1 = db.LoadTerrain(region1);
  870. Assert.That(CompareTerrain(t1, baseterrain1), Is.True);
  871. Assert.That(CompareTerrain(t1, baseterrain2), Is.False);
  872. }
  873. [Test]
  874. public void T303_UpdateTerrain()
  875. {
  876. TestHelpers.InMethod();
  877. double[,] baseterrain1 = GenTerrain(height1);
  878. double[,] baseterrain2 = GenTerrain(height2);
  879. db.StoreTerrain(baseterrain2, region1);
  880. double[,] t1 = db.LoadTerrain(region1);
  881. Assert.That(CompareTerrain(t1, baseterrain1), Is.False);
  882. Assert.That(CompareTerrain(t1, baseterrain2), Is.True);
  883. }
  884. [Test]
  885. public void T400_EmptyLand()
  886. {
  887. TestHelpers.InMethod();
  888. Assert.That(db.LoadLandObjects(zero).Count, Is.EqualTo(0), "Assert.That(db.LoadLandObjects(zero).Count, Is.EqualTo(0))");
  889. Assert.That(db.LoadLandObjects(region1).Count, Is.EqualTo(0), "Assert.That(db.LoadLandObjects(region1).Count, Is.EqualTo(0))");
  890. Assert.That(db.LoadLandObjects(region2).Count, Is.EqualTo(0), "Assert.That(db.LoadLandObjects(region2).Count, Is.EqualTo(0))");
  891. Assert.That(db.LoadLandObjects(UUID.Random()).Count, Is.EqualTo(0), "Assert.That(db.LoadLandObjects(UUID.Random()).Count, Is.EqualTo(0))");
  892. }
  893. // TODO: we should have real land tests, but Land is so
  894. // intermingled with scene that you can't test it without a
  895. // valid scene. That requires some disagregation.
  896. //************************************************************************************//
  897. // Extra private methods
  898. private double[,] GenTerrain(double value)
  899. {
  900. double[,] terret = new double[Constants.RegionSize, Constants.RegionSize];
  901. terret.Initialize();
  902. for (int x = 0; x < Constants.RegionSize; x++)
  903. for (int y = 0; y < Constants.RegionSize; y++)
  904. terret[x,y] = value;
  905. return terret;
  906. }
  907. private bool CompareTerrain(double[,] one, double[,] two)
  908. {
  909. for (int x = 0; x < Constants.RegionSize; x++)
  910. for (int y = 0; y < Constants.RegionSize; y++)
  911. if (one[x,y] != two[x,y])
  912. return false;
  913. return true;
  914. }
  915. private SceneObjectGroup FindSOG(string name, UUID r)
  916. {
  917. List<SceneObjectGroup> objs = db.LoadObjects(r);
  918. foreach (SceneObjectGroup sog in objs)
  919. if (sog.Name == name)
  920. return sog;
  921. return null;
  922. }
  923. // This builds a minimalistic Prim, 1 SOG with 1 root SOP. A
  924. // common failure case is people adding new fields that aren't
  925. // initialized, but have non-null db constraints. We should
  926. // honestly be passing more and more null things in here.
  927. //
  928. // Please note that in Sqlite.BuildPrim there is a commented out inline version
  929. // of this so you can debug and step through the build process and check the fields
  930. //
  931. // Real World Value: Tests for situation where extending a SceneObjectGroup/SceneObjectPart
  932. // causes the application to crash at the database layer because of null values
  933. // in NOT NULL fields
  934. //
  935. private SceneObjectGroup NewSOG(string name, UUID uuid, UUID regionId)
  936. {
  937. RegionInfo regionInfo = new RegionInfo();
  938. regionInfo.RegionID = regionId;
  939. regionInfo.RegionLocX = 0;
  940. regionInfo.RegionLocY = 0;
  941. SceneObjectPart sop = new SceneObjectPart();
  942. sop.Name = name;
  943. sop.Description = name;
  944. sop.Text = RandomName();
  945. sop.SitName = RandomName();
  946. sop.TouchName = RandomName();
  947. sop.UUID = uuid;
  948. sop.Shape = PrimitiveBaseShape.Default;
  949. SceneObjectGroup sog = new SceneObjectGroup(sop);
  950. // sog.SetScene(scene);
  951. return sog;
  952. }
  953. private SceneObjectPart NewSOP(string name, UUID uuid)
  954. {
  955. SceneObjectPart sop = new SceneObjectPart();
  956. sop.Name = name;
  957. sop.Description = name;
  958. sop.Text = RandomName();
  959. sop.SitName = RandomName();
  960. sop.TouchName = RandomName();
  961. sop.UUID = uuid;
  962. sop.Shape = PrimitiveBaseShape.Default;
  963. return sop;
  964. }
  965. // These are copied from the Inventory Item tests
  966. private InventoryItemBase NewItem(UUID id, UUID parent, UUID owner, string name, UUID asset)
  967. {
  968. InventoryItemBase i = new InventoryItemBase();
  969. i.ID = id;
  970. i.Folder = parent;
  971. i.Owner = owner;
  972. i.CreatorId = owner.ToString();
  973. i.Name = name;
  974. i.Description = name;
  975. i.AssetID = asset;
  976. return i;
  977. }
  978. private static string RandomName()
  979. {
  980. StringBuilder name = new StringBuilder();
  981. int size = random.Next(5,12);
  982. char ch ;
  983. for (int i=0; i<size; i++)
  984. {
  985. ch = Convert.ToChar(Convert.ToInt32(Math.Floor(26 * random.NextDouble() + 65))) ;
  986. name.Append(ch);
  987. }
  988. return name.ToString();
  989. }
  990. // private InventoryFolderBase NewFolder(UUID id, UUID parent, UUID owner, string name)
  991. // {
  992. // InventoryFolderBase f = new InventoryFolderBase();
  993. // f.ID = id;
  994. // f.ParentID = parent;
  995. // f.Owner = owner;
  996. // f.Name = name;
  997. // return f;
  998. // }
  999. }
  1000. }