aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/Tests/EstateTests.cs
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/Tests/EstateTests.cs')
-rw-r--r--OpenSim/Data/Tests/EstateTests.cs521
1 files changed, 521 insertions, 0 deletions
diff --git a/OpenSim/Data/Tests/EstateTests.cs b/OpenSim/Data/Tests/EstateTests.cs
new file mode 100644
index 0000000..cf3f2b4
--- /dev/null
+++ b/OpenSim/Data/Tests/EstateTests.cs
@@ -0,0 +1,521 @@
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
28using System;
29using log4net.Config;
30using NUnit.Framework;
31using OpenMetaverse;
32using OpenSim.Framework;
33using OpenSim.Region.Framework.Interfaces;
34using OpenSim.Tests.Common;
35using System.Text;
36using log4net;
37using System.Reflection;
38using System.Data.Common;
39
40// DBMS-specific:
41using MySql.Data.MySqlClient;
42using OpenSim.Data.MySQL;
43
44using Mono.Data.Sqlite;
45using OpenSim.Data.SQLite;
46
47namespace OpenSim.Data.Tests
48{
49 [TestFixture(Description = "Estate store tests (SQLite)")]
50 public class SQLiteEstateTests : EstateTests<SqliteConnection, SQLiteEstateStore>
51 {
52 }
53
54 [TestFixture(Description = "Estate store tests (MySQL)")]
55 public class MySqlEstateTests : EstateTests<MySqlConnection, MySQLEstateStore>
56 {
57 }
58
59 public class EstateTests<TConn, TEstateStore> : BasicDataServiceTest<TConn, TEstateStore>
60 where TConn : DbConnection, new()
61 where TEstateStore : class, IEstateDataStore, new()
62 {
63 public IEstateDataStore db;
64
65 public static UUID REGION_ID = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed7");
66
67 public static UUID USER_ID_1 = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed1");
68 public static UUID USER_ID_2 = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed2");
69
70 public static UUID MANAGER_ID_1 = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed3");
71 public static UUID MANAGER_ID_2 = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed4");
72
73 public static UUID GROUP_ID_1 = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed5");
74 public static UUID GROUP_ID_2 = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed6");
75
76 protected override void InitService(object service)
77 {
78 ClearDB();
79 db = (IEstateDataStore)service;
80 db.Initialise(m_connStr);
81 }
82
83 private void ClearDB()
84 {
85 // if a new table is added, it has to be dropped here
86 DropTables(
87 "estate_managers",
88 "estate_groups",
89 "estate_users",
90 "estateban",
91 "estate_settings",
92 "estate_map"
93 );
94 ResetMigrations("EstateStore");
95 }
96
97 #region 0Tests
98
99 [Test]
100 public void T010_EstateSettingsSimpleStorage_MinimumParameterSet()
101 {
102 TestHelpers.InMethod();
103
104 EstateSettingsSimpleStorage(
105 REGION_ID,
106 DataTestUtil.STRING_MIN,
107 DataTestUtil.UNSIGNED_INTEGER_MIN,
108 DataTestUtil.FLOAT_MIN,
109 DataTestUtil.INTEGER_MIN,
110 DataTestUtil.INTEGER_MIN,
111 DataTestUtil.INTEGER_MIN,
112 DataTestUtil.BOOLEAN_MIN,
113 DataTestUtil.BOOLEAN_MIN,
114 DataTestUtil.DOUBLE_MIN,
115 DataTestUtil.BOOLEAN_MIN,
116 DataTestUtil.BOOLEAN_MIN,
117 DataTestUtil.BOOLEAN_MIN,
118 DataTestUtil.BOOLEAN_MIN,
119 DataTestUtil.BOOLEAN_MIN,
120 DataTestUtil.BOOLEAN_MIN,
121 DataTestUtil.BOOLEAN_MIN,
122 DataTestUtil.BOOLEAN_MIN,
123 DataTestUtil.BOOLEAN_MIN,
124 DataTestUtil.BOOLEAN_MIN,
125 DataTestUtil.BOOLEAN_MIN,
126 DataTestUtil.BOOLEAN_MIN,
127 DataTestUtil.STRING_MIN,
128 DataTestUtil.UUID_MIN
129 );
130 }
131
132 [Test]
133 public void T011_EstateSettingsSimpleStorage_MaximumParameterSet()
134 {
135 TestHelpers.InMethod();
136
137 EstateSettingsSimpleStorage(
138 REGION_ID,
139 DataTestUtil.STRING_MAX(64),
140 DataTestUtil.UNSIGNED_INTEGER_MAX,
141 DataTestUtil.FLOAT_MAX,
142 DataTestUtil.INTEGER_MAX,
143 DataTestUtil.INTEGER_MAX,
144 DataTestUtil.INTEGER_MAX,
145 DataTestUtil.BOOLEAN_MAX,
146 DataTestUtil.BOOLEAN_MAX,
147 DataTestUtil.DOUBLE_MAX,
148 DataTestUtil.BOOLEAN_MAX,
149 DataTestUtil.BOOLEAN_MAX,
150 DataTestUtil.BOOLEAN_MAX,
151 DataTestUtil.BOOLEAN_MAX,
152 DataTestUtil.BOOLEAN_MAX,
153 DataTestUtil.BOOLEAN_MAX,
154 DataTestUtil.BOOLEAN_MAX,
155 DataTestUtil.BOOLEAN_MAX,
156 DataTestUtil.BOOLEAN_MAX,
157 DataTestUtil.BOOLEAN_MAX,
158 DataTestUtil.BOOLEAN_MAX,
159 DataTestUtil.BOOLEAN_MAX,
160 DataTestUtil.STRING_MAX(255),
161 DataTestUtil.UUID_MAX
162 );
163 }
164
165 [Test]
166 public void T012_EstateSettingsSimpleStorage_AccurateParameterSet()
167 {
168 TestHelpers.InMethod();
169
170 EstateSettingsSimpleStorage(
171 REGION_ID,
172 DataTestUtil.STRING_MAX(1),
173 DataTestUtil.UNSIGNED_INTEGER_MIN,
174 DataTestUtil.FLOAT_ACCURATE,
175 DataTestUtil.INTEGER_MIN,
176 DataTestUtil.INTEGER_MIN,
177 DataTestUtil.INTEGER_MIN,
178 DataTestUtil.BOOLEAN_MIN,
179 DataTestUtil.BOOLEAN_MIN,
180 DataTestUtil.DOUBLE_ACCURATE,
181 DataTestUtil.BOOLEAN_MIN,
182 DataTestUtil.BOOLEAN_MIN,
183 DataTestUtil.BOOLEAN_MIN,
184 DataTestUtil.BOOLEAN_MIN,
185 DataTestUtil.BOOLEAN_MIN,
186 DataTestUtil.BOOLEAN_MIN,
187 DataTestUtil.BOOLEAN_MIN,
188 DataTestUtil.BOOLEAN_MIN,
189 DataTestUtil.BOOLEAN_MIN,
190 DataTestUtil.BOOLEAN_MIN,
191 DataTestUtil.BOOLEAN_MIN,
192 DataTestUtil.BOOLEAN_MIN,
193 DataTestUtil.STRING_MAX(1),
194 DataTestUtil.UUID_MIN
195 );
196 }
197
198 [Test]
199 public void T012_EstateSettingsRandomStorage()
200 {
201 TestHelpers.InMethod();
202
203 // Letting estate store generate rows to database for us
204 EstateSettings originalSettings = db.LoadEstateSettings(REGION_ID, true);
205 new PropertyScrambler<EstateSettings>()
206 .DontScramble(x=>x.EstateID)
207 .Scramble(originalSettings);
208
209 // Saving settings.
210 db.StoreEstateSettings(originalSettings);
211
212 // Loading settings to another instance variable.
213 EstateSettings loadedSettings = db.LoadEstateSettings(REGION_ID, true);
214
215 // Checking that loaded values are correct.
216 Assert.That(loadedSettings, Constraints.PropertyCompareConstraint(originalSettings));
217 }
218
219 [Test]
220 public void T020_EstateSettingsManagerList()
221 {
222 TestHelpers.InMethod();
223
224 // Letting estate store generate rows to database for us
225 EstateSettings originalSettings = db.LoadEstateSettings(REGION_ID, true);
226
227 originalSettings.EstateManagers = new UUID[] { MANAGER_ID_1, MANAGER_ID_2 };
228
229 // Saving settings.
230 db.StoreEstateSettings(originalSettings);
231
232 // Loading settings to another instance variable.
233 EstateSettings loadedSettings = db.LoadEstateSettings(REGION_ID, true);
234
235 Assert.AreEqual(2, loadedSettings.EstateManagers.Length);
236 Assert.AreEqual(MANAGER_ID_1, loadedSettings.EstateManagers[0]);
237 Assert.AreEqual(MANAGER_ID_2, loadedSettings.EstateManagers[1]);
238 }
239
240 [Test]
241 public void T021_EstateSettingsUserList()
242 {
243 TestHelpers.InMethod();
244
245 // Letting estate store generate rows to database for us
246 EstateSettings originalSettings = db.LoadEstateSettings(REGION_ID, true);
247
248 originalSettings.EstateAccess = new UUID[] { USER_ID_1, USER_ID_2 };
249
250 // Saving settings.
251 db.StoreEstateSettings(originalSettings);
252
253 // Loading settings to another instance variable.
254 EstateSettings loadedSettings = db.LoadEstateSettings(REGION_ID, true);
255
256 Assert.AreEqual(2, loadedSettings.EstateAccess.Length);
257 Assert.AreEqual(USER_ID_1, loadedSettings.EstateAccess[0]);
258 Assert.AreEqual(USER_ID_2, loadedSettings.EstateAccess[1]);
259 }
260
261 [Test]
262 public void T022_EstateSettingsGroupList()
263 {
264 TestHelpers.InMethod();
265
266 // Letting estate store generate rows to database for us
267 EstateSettings originalSettings = db.LoadEstateSettings(REGION_ID, true);
268
269 originalSettings.EstateGroups = new UUID[] { GROUP_ID_1, GROUP_ID_2 };
270
271 // Saving settings.
272 db.StoreEstateSettings(originalSettings);
273
274 // Loading settings to another instance variable.
275 EstateSettings loadedSettings = db.LoadEstateSettings(REGION_ID, true);
276
277 Assert.AreEqual(2, loadedSettings.EstateAccess.Length);
278 Assert.AreEqual(GROUP_ID_1, loadedSettings.EstateGroups[0]);
279 Assert.AreEqual(GROUP_ID_2, loadedSettings.EstateGroups[1]);
280 }
281
282 [Test]
283 public void T022_EstateSettingsBanList()
284 {
285 TestHelpers.InMethod();
286
287 // Letting estate store generate rows to database for us
288 EstateSettings originalSettings = db.LoadEstateSettings(REGION_ID, true);
289
290 EstateBan estateBan1 = new EstateBan();
291 estateBan1.BannedUserID = DataTestUtil.UUID_MIN;
292
293 EstateBan estateBan2 = new EstateBan();
294 estateBan2.BannedUserID = DataTestUtil.UUID_MAX;
295
296 originalSettings.EstateBans = new EstateBan[] { estateBan1, estateBan2 };
297
298 // Saving settings.
299 db.StoreEstateSettings(originalSettings);
300
301 // Loading settings to another instance variable.
302 EstateSettings loadedSettings = db.LoadEstateSettings(REGION_ID, true);
303
304 Assert.AreEqual(2, loadedSettings.EstateBans.Length);
305 Assert.AreEqual(DataTestUtil.UUID_MIN, loadedSettings.EstateBans[0].BannedUserID);
306
307 Assert.AreEqual(DataTestUtil.UUID_MAX, loadedSettings.EstateBans[1].BannedUserID);
308
309 }
310
311 #endregion
312
313 #region Parametrizable Test Implementations
314
315 private void EstateSettingsSimpleStorage(
316 UUID regionId,
317 string estateName,
318 uint parentEstateID,
319 float billableFactor,
320 int pricePerMeter,
321 int redirectGridX,
322 int redirectGridY,
323 bool useGlobalTime,
324 bool fixedSun,
325 double sunPosition,
326 bool allowVoice,
327 bool allowDirectTeleport,
328 bool resetHomeOnTeleport,
329 bool denyAnonymous,
330 bool denyIdentified,
331 bool denyTransacted,
332 bool denyMinors,
333 bool abuseEmailToEstateOwner,
334 bool blockDwell,
335 bool estateSkipScripts,
336 bool taxFree,
337 bool publicAccess,
338 string abuseEmail,
339 UUID estateOwner
340 )
341 {
342
343 // Letting estate store generate rows to database for us
344 EstateSettings originalSettings = db.LoadEstateSettings(regionId, true);
345
346 SetEstateSettings(originalSettings,
347 estateName,
348 parentEstateID,
349 billableFactor,
350 pricePerMeter,
351 redirectGridX,
352 redirectGridY,
353 useGlobalTime,
354 fixedSun,
355 sunPosition,
356 allowVoice,
357 allowDirectTeleport,
358 resetHomeOnTeleport,
359 denyAnonymous,
360 denyIdentified,
361 denyTransacted,
362 denyMinors,
363 abuseEmailToEstateOwner,
364 blockDwell,
365 estateSkipScripts,
366 taxFree,
367 publicAccess,
368 abuseEmail,
369 estateOwner
370 );
371
372 // Saving settings.
373 db.StoreEstateSettings(originalSettings);
374
375 // Loading settings to another instance variable.
376 EstateSettings loadedSettings = db.LoadEstateSettings(regionId, true);
377
378 // Checking that loaded values are correct.
379 ValidateEstateSettings(loadedSettings,
380 estateName,
381 parentEstateID,
382 billableFactor,
383 pricePerMeter,
384 redirectGridX,
385 redirectGridY,
386 useGlobalTime,
387 fixedSun,
388 sunPosition,
389 allowVoice,
390 allowDirectTeleport,
391 resetHomeOnTeleport,
392 denyAnonymous,
393 denyIdentified,
394 denyTransacted,
395 denyMinors,
396 abuseEmailToEstateOwner,
397 blockDwell,
398 estateSkipScripts,
399 taxFree,
400 publicAccess,
401 abuseEmail,
402 estateOwner
403 );
404
405 }
406
407 #endregion
408
409 #region EstateSetting Initialization and Validation Methods
410
411 private void SetEstateSettings(
412 EstateSettings estateSettings,
413 string estateName,
414 uint parentEstateID,
415 float billableFactor,
416 int pricePerMeter,
417 int redirectGridX,
418 int redirectGridY,
419 bool useGlobalTime,
420 bool fixedSun,
421 double sunPosition,
422 bool allowVoice,
423 bool allowDirectTeleport,
424 bool resetHomeOnTeleport,
425 bool denyAnonymous,
426 bool denyIdentified,
427 bool denyTransacted,
428 bool denyMinors,
429 bool abuseEmailToEstateOwner,
430 bool blockDwell,
431 bool estateSkipScripts,
432 bool taxFree,
433 bool publicAccess,
434 string abuseEmail,
435 UUID estateOwner
436 )
437 {
438 estateSettings.EstateName = estateName;
439 estateSettings.ParentEstateID = parentEstateID;
440 estateSettings.BillableFactor = billableFactor;
441 estateSettings.PricePerMeter = pricePerMeter;
442 estateSettings.RedirectGridX = redirectGridX;
443 estateSettings.RedirectGridY = redirectGridY;
444 estateSettings.UseGlobalTime = useGlobalTime;
445 estateSettings.FixedSun = fixedSun;
446 estateSettings.SunPosition = sunPosition;
447 estateSettings.AllowVoice = allowVoice;
448 estateSettings.AllowDirectTeleport = allowDirectTeleport;
449 estateSettings.ResetHomeOnTeleport = resetHomeOnTeleport;
450 estateSettings.DenyAnonymous = denyAnonymous;
451 estateSettings.DenyIdentified = denyIdentified;
452 estateSettings.DenyTransacted = denyTransacted;
453 estateSettings.DenyMinors = denyMinors;
454 estateSettings.AbuseEmailToEstateOwner = abuseEmailToEstateOwner;
455 estateSettings.BlockDwell = blockDwell;
456 estateSettings.EstateSkipScripts = estateSkipScripts;
457 estateSettings.TaxFree = taxFree;
458 estateSettings.PublicAccess = publicAccess;
459 estateSettings.AbuseEmail = abuseEmail;
460 estateSettings.EstateOwner = estateOwner;
461 }
462
463 private void ValidateEstateSettings(
464 EstateSettings estateSettings,
465 string estateName,
466 uint parentEstateID,
467 float billableFactor,
468 int pricePerMeter,
469 int redirectGridX,
470 int redirectGridY,
471 bool useGlobalTime,
472 bool fixedSun,
473 double sunPosition,
474 bool allowVoice,
475 bool allowDirectTeleport,
476 bool resetHomeOnTeleport,
477 bool denyAnonymous,
478 bool denyIdentified,
479 bool denyTransacted,
480 bool denyMinors,
481 bool abuseEmailToEstateOwner,
482 bool blockDwell,
483 bool estateSkipScripts,
484 bool taxFree,
485 bool publicAccess,
486 string abuseEmail,
487 UUID estateOwner
488 )
489 {
490 Assert.AreEqual(estateName, estateSettings.EstateName);
491 Assert.AreEqual(parentEstateID, estateSettings.ParentEstateID);
492
493 DataTestUtil.AssertFloatEqualsWithTolerance(billableFactor, estateSettings.BillableFactor);
494
495 Assert.AreEqual(pricePerMeter, estateSettings.PricePerMeter);
496 Assert.AreEqual(redirectGridX, estateSettings.RedirectGridX);
497 Assert.AreEqual(redirectGridY, estateSettings.RedirectGridY);
498 Assert.AreEqual(useGlobalTime, estateSettings.UseGlobalTime);
499 Assert.AreEqual(fixedSun, estateSettings.FixedSun);
500
501 DataTestUtil.AssertDoubleEqualsWithTolerance(sunPosition, estateSettings.SunPosition);
502
503 Assert.AreEqual(allowVoice, estateSettings.AllowVoice);
504 Assert.AreEqual(allowDirectTeleport, estateSettings.AllowDirectTeleport);
505 Assert.AreEqual(resetHomeOnTeleport, estateSettings.ResetHomeOnTeleport);
506 Assert.AreEqual(denyAnonymous, estateSettings.DenyAnonymous);
507 Assert.AreEqual(denyIdentified, estateSettings.DenyIdentified);
508 Assert.AreEqual(denyTransacted, estateSettings.DenyTransacted);
509 Assert.AreEqual(denyMinors, estateSettings.DenyMinors);
510 Assert.AreEqual(abuseEmailToEstateOwner, estateSettings.AbuseEmailToEstateOwner);
511 Assert.AreEqual(blockDwell, estateSettings.BlockDwell);
512 Assert.AreEqual(estateSkipScripts, estateSettings.EstateSkipScripts);
513 Assert.AreEqual(taxFree, estateSettings.TaxFree);
514 Assert.AreEqual(publicAccess, estateSettings.PublicAccess);
515 Assert.AreEqual(abuseEmail, estateSettings.AbuseEmail);
516 Assert.AreEqual(estateOwner, estateSettings.EstateOwner);
517 }
518
519 #endregion
520 }
521} \ No newline at end of file
generated by cgit v1.1 at 2025-01-28 19:53:35 +0000