Thank you kindly, TLaukkan (Timmil) for a patch that:

* Fixed and added athursv's BasicEstateTest * Added MySQLEstateTest * Added SQLiteEstateTest
author: Charles Krinke 2009-02-09 22:07:27 +0000
committer: Charles Krinke 2009-02-09 22:07:27 +0000
commit: 29f54db90a07a51be5ca33f9edb972e1922f51a9 (patch)
tree: acd547246baca6047ebc0c1e46b222a71cdc34b3 /OpenSim/Data
parent: oops, missing file from last patch set (diff)
download: opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.zip
opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.tar.gz
opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.tar.bz2
opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.tar.xz
3 files changed, 318 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs
new file mode 100644
index 0000000..17e71e1
--- /dev/null
+++ b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs
@@ -0,0 +1,99 @@
+/*
+ * Copyright (c) Contributors, http://opensimulator.org/
+ * See CONTRIBUTORS.TXT for a full list of copyright holders.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *     * Redistributions of source code must retain the above copyright
+ *       notice, this list of conditions and the following disclaimer.
+ *     * Redistributions in binary form must reproduce the above copyright
+ *       notice, this list of conditions and the following disclaimer in the
+ *       documentation and/or other materials provided with the distribution.
+ *     * Neither the name of the OpenSim Project nor the
+ *       names of its contributors may be used to endorse or promote products
+ *       derived from this software without specific prior written permission.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
+ * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
+ * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
+ * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
+ * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+ * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+ * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+ * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
+ * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ */
+using System;
+using System.IO;
+using System.Collections.Generic;
+using NUnit.Framework;
+using NUnit.Framework.SyntaxHelpers;
+using OpenSim.Framework;
+using OpenSim.Data.Tests;
+using OpenSim.Data.MySQL;
+using OpenSim.Region.Framework.Scenes;
+using OpenMetaverse;
+namespace OpenSim.Data.MySQL.Tests
+{
+    [TestFixture]
+    public class MySQLEstateTest : BasicEstateTest
+    {
+        public string file;
+        public MySQLManager database;
+        public string connect = "Server=localhost;Port=3306;Database=opensim-nunit;User ID=opensim-nunit;Password=opensim-nunit;Pooling=false;";
+        
+        [TestFixtureSetUp]
+        public void Init()
+        {
+            SuperInit();
+            // If we manage to connect to the database with the user
+            // and password above it is our test database, and run
+            // these tests.  If anything goes wrong, ignore these
+            // tests.
+            try 
+            {
+                database = new MySQLManager(connect);
+                regionDb = new MySQLDataStore();
+                regionDb.Initialise(connect);
+                db = new MySQLEstateStore();
+                db.Initialise(connect);
+            } 
+            catch (Exception e)
+            {
+                System.Console.WriteLine("Exception {0}", e);
+                Assert.Ignore();
+            }
+        }
+        [TestFixtureTearDown]
+        public void Cleanup()
+        {
+            if (regionDb != null)
+            {
+                regionDb.Dispose();
+            }
+            // if a new table is added, it has to be dropped here
+            if (database != null)
+            {
+                database.ExecuteSql("drop table migrations");
+                database.ExecuteSql("drop table prims");
+                database.ExecuteSql("drop table primshapes");
+                database.ExecuteSql("drop table primitems");
+                database.ExecuteSql("drop table terrain");
+                database.ExecuteSql("drop table land");
+                database.ExecuteSql("drop table landaccesslist");
+                database.ExecuteSql("drop table regionban");
+                database.ExecuteSql("drop table regionsettings");
+                database.ExecuteSql("drop table estate_managers");
+                database.ExecuteSql("drop table estate_groups");
+                database.ExecuteSql("drop table estate_users");
+                database.ExecuteSql("drop table estateban");
+                database.ExecuteSql("drop table estate_settings");
+                database.ExecuteSql("drop table estate_map");
+            }
+        }
+    }
+}
diff --git a/OpenSim/Data/SQLite/Tests/SQLiteEstateTest.cs b/OpenSim/Data/SQLite/Tests/SQLiteEstateTest.cs
new file mode 100644
index 0000000..8f27b65
--- /dev/null
+++ b/OpenSim/Data/SQLite/Tests/SQLiteEstateTest.cs
@@ -0,0 +1,65 @@
+/*
+ * Copyright (c) Contributors, http://opensimulator.org/
+ * See CONTRIBUTORS.TXT for a full list of copyright holders.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *     * Redistributions of source code must retain the above copyright
+ *       notice, this list of conditions and the following disclaimer.
+ *     * Redistributions in binary form must reproduce the above copyright
+ *       notice, this list of conditions and the following disclaimer in the
+ *       documentation and/or other materials provided with the distribution.
+ *     * Neither the name of the OpenSim Project nor the
+ *       names of its contributors may be used to endorse or promote products
+ *       derived from this software without specific prior written permission.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
+ * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
+ * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
+ * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
+ * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+ * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+ * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+ * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
+ * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ */
+using System;
+using System.IO;
+using System.Collections.Generic;
+using NUnit.Framework;
+using NUnit.Framework.SyntaxHelpers;
+using OpenSim.Framework;
+using OpenSim.Data.Tests;
+using OpenSim.Data.SQLite;
+using OpenSim.Region.Framework.Scenes;
+using OpenMetaverse;
+namespace OpenSim.Data.SQLite.Tests
+{
+    [TestFixture]
+    public class SQLiteEstateTest : BasicEstateTest
+    {
+        public string file = "regiontest.db";
+        public string connect;
+        
+        [TestFixtureSetUp]
+        public void Init()
+        {
+            SuperInit();
+            file = Path.GetTempFileName() + ".db";
+            connect = "URI=file:" + file + ",version=3";
+            db = new SQLiteEstateStore();
+            db.Initialise(connect);
+            regionDb = new SQLiteRegionData();
+            regionDb.Initialise(connect);
+        }
+        [TestFixtureTearDown]
+        public void Cleanup()
+        {
+            regionDb.Dispose();
+        }
+    }
+}
diff --git a/OpenSim/Data/Tests/BasicEstateTest.cs b/OpenSim/Data/Tests/BasicEstateTest.cs
new file mode 100644
index 0000000..ef15150
--- /dev/null
+++ b/OpenSim/Data/Tests/BasicEstateTest.cs
@@ -0,0 +1,154 @@
+/*
+ * Copyright (c) Contributors, http://opensimulator.org/
+ * See CONTRIBUTORS.TXT for a full list of copyright holders.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *     * Redistributions of source code must retain the above copyright
+ *       notice, this list of conditions and the following disclaimer.
+ *     * Redistributions in binary form must reproduce the above copyright
+ *       notice, this list of conditions and the following disclaimer in the
+ *       documentation and/or other materials provided with the distribution.
+ *     * Neither the name of the OpenSim Project nor the
+ *       names of its contributors may be used to endorse or promote products
+ *       derived from this software without specific prior written permission.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
+ * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
+ * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
+ * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
+ * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+ * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+ * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+ * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
+ * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ */
+using System;
+using System.Collections.Generic;
+using System.Drawing;
+using System.Text;
+using NUnit.Framework;
+using NUnit.Framework.SyntaxHelpers;
+using OpenSim.Framework;
+using OpenSim.Data;
+using OpenMetaverse;
+using OpenSim.Region.Framework.Interfaces;
+namespace OpenSim.Data.Tests
+{
+    public class BasicEstateTest
+    {
+        public IEstateDataStore db;
+        public IRegionDataStore regionDb;
+        public UUID prim1;
+        public static Random random;
+        
+        public void SuperInit()
+        {
+            try
+            {
+                log4net.Config.XmlConfigurator.Configure();
+            }
+            catch (Exception)
+            {
+                // I don't care, just leave log4net off
+            }
+            prim1 = UUID.Random();
+            random = new Random();
+        }
+        
+        [Test]
+        public void T010_StoreEstateSettings()
+        {
+            // Initializing field values. Avoid randomness. For checking ranges use different parameter sets
+            // for mix and max values. If you use random values the tests are not _repeatable_.
+            string estateName = "test-estate";
+            uint parentEstateID = 2;
+            float billableFactor = 3;
+            int priceMeter = 4;
+            int redirectGridX = 5;
+            int redirectGridY = 6;
+            bool useGlobalTime = true;
+            bool fixedSun = true;
+            double sunPosition = 7;
+            bool allowVoice = true;
+            bool allowDirectTeleport = true;
+            bool denyAnonymous = true;
+            bool denyIdentified = true;
+            bool denyTransacted = true;
+            bool abuseEmailtoEstateOwner = true;
+            bool blockDwell = true;
+            bool estateskipScripts = true;
+            bool taxFree = true;
+            bool publicAccess = true;
+            string abuseMail = "test-email@nowhere.com";
+            UUID estateOwner = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed7");
+            bool denyMinors = (random.NextDouble() > 0.5)? true : false;
+            // Lets choose random region ID
+            UUID regionId = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed7");
+            // Letting estate store generate rows to database for us
+            EstateSettings es = db.LoadEstateSettings(regionId);
+            // Setting field values to the on demand create settings object.
+            es.EstateName = estateName;
+            es.ParentEstateID = parentEstateID;
+            es.BillableFactor = billableFactor;
+            es.PricePerMeter = priceMeter;
+            es.RedirectGridX = redirectGridX;
+            es.RedirectGridY = redirectGridY;
+            es.UseGlobalTime = useGlobalTime;
+            es.FixedSun = fixedSun;
+            es.SunPosition = sunPosition;
+            es.AllowVoice = allowVoice;
+            es.AllowDirectTeleport = allowDirectTeleport;
+            es.DenyAnonymous = denyAnonymous;
+            es.DenyIdentified = denyIdentified;
+            es.DenyTransacted = denyTransacted;
+            es.AbuseEmailToEstateOwner = abuseEmailtoEstateOwner;
+            es.BlockDwell = blockDwell;
+            es.EstateSkipScripts = estateskipScripts;
+            es.TaxFree = taxFree;
+            es.PublicAccess = publicAccess;
+            es.AbuseEmail = abuseMail;
+            es.EstateOwner = estateOwner;
+            es.DenyMinors = denyMinors;
+            // Saving settings.
+            db.StoreEstateSettings(es);
+            // Loading settings to another instance variable.
+            EstateSettings nes = db.LoadEstateSettings(regionId);
+            // Checking that loaded values are correct.
+            Assert.That(estateName, Is.EqualTo(nes.EstateName));
+            Assert.That(parentEstateID, Is.EqualTo(nes.ParentEstateID));
+            Assert.That(billableFactor, Is.EqualTo(nes.BillableFactor));
+            Assert.That(priceMeter, Is.EqualTo(nes.PricePerMeter));
+            Assert.That(redirectGridX, Is.EqualTo(nes.RedirectGridX));
+            Assert.That(redirectGridY, Is.EqualTo(nes.RedirectGridY));
+            Assert.That(useGlobalTime, Is.EqualTo(nes.UseGlobalTime));
+            Assert.That(fixedSun, Is.EqualTo(nes.FixedSun));
+            Assert.That(sunPosition, Is.EqualTo(nes.SunPosition));
+            Assert.That(allowVoice, Is.EqualTo(nes.AllowVoice));
+            Assert.That(allowDirectTeleport, Is.EqualTo(nes.AllowDirectTeleport));
+            Assert.That(denyAnonymous, Is.EqualTo(nes.DenyAnonymous));
+            Assert.That(denyIdentified, Is.EqualTo(nes.DenyIdentified));
+            Assert.That(denyTransacted, Is.EqualTo(nes.DenyTransacted));
+            Assert.That(abuseEmailtoEstateOwner, Is.EqualTo(nes.AbuseEmailToEstateOwner));
+            Assert.That(blockDwell, Is.EqualTo(nes.BlockDwell));
+            Assert.That(estateskipScripts, Is.EqualTo(nes.EstateSkipScripts));
+            Assert.That(taxFree, Is.EqualTo(nes.TaxFree));
+            Assert.That(publicAccess, Is.EqualTo(nes.PublicAccess));
+            Assert.That(abuseMail, Is.EqualTo(nes.AbuseEmail));
+            Assert.That(estateOwner, Is.EqualTo(nes.EstateOwner));
+            Assert.That(denyMinors, Is.EqualTo(nes.DenyMinors));
+        }
+        
+    }
+}
author	Charles Krinke	2009-02-09 22:07:27 +0000
committer	Charles Krinke	2009-02-09 22:07:27 +0000
commit	29f54db90a07a51be5ca33f9edb972e1922f51a9 (patch)
tree	acd547246baca6047ebc0c1e46b222a71cdc34b3 /OpenSim/Data
parent	oops, missing file from last patch set (diff)
download	opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.zip opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.tar.gz opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.tar.bz2 opensim-SC-29f54db90a07a51be5ca33f9edb972e1922f51a9.tar.xz

diff --git a/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs new file mode 100644 index 0000000..17e71e1 --- /dev/null +++ b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs
@@ -0,0 +1,99 @@
	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 OpenSim 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
	28	using System;
	29	using System.IO;
	30	using System.Collections.Generic;
	31	using NUnit.Framework;
	32	using NUnit.Framework.SyntaxHelpers;
	33	using OpenSim.Framework;
	34	using OpenSim.Data.Tests;
	35	using OpenSim.Data.MySQL;
	36	using OpenSim.Region.Framework.Scenes;
	37	using OpenMetaverse;
	38
	39	namespace OpenSim.Data.MySQL.Tests
	40	{
	41	[TestFixture]
	42	public class MySQLEstateTest : BasicEstateTest
	43	{
	44	public string file;
	45	public MySQLManager database;
	46	public string connect = "Server=localhost;Port=3306;Database=opensim-nunit;User ID=opensim-nunit;Password=opensim-nunit;Pooling=false;";
	47
	48	[TestFixtureSetUp]
	49	public void Init()
	50	{
	51	SuperInit();
	52	// If we manage to connect to the database with the user
	53	// and password above it is our test database, and run
	54	// these tests. If anything goes wrong, ignore these
	55	// tests.
	56	try
	57	{
	58	database = new MySQLManager(connect);
	59	regionDb = new MySQLDataStore();
	60	regionDb.Initialise(connect);
	61	db = new MySQLEstateStore();
	62	db.Initialise(connect);
	63	}
	64	catch (Exception e)
	65	{
	66	System.Console.WriteLine("Exception {0}", e);
	67	Assert.Ignore();
	68	}
	69	}
	70
	71	[TestFixtureTearDown]
	72	public void Cleanup()
	73	{
	74	if (regionDb != null)
	75	{
	76	regionDb.Dispose();
	77	}
	78	// if a new table is added, it has to be dropped here
	79	if (database != null)
	80	{
	81	database.ExecuteSql("drop table migrations");
	82	database.ExecuteSql("drop table prims");
	83	database.ExecuteSql("drop table primshapes");
	84	database.ExecuteSql("drop table primitems");
	85	database.ExecuteSql("drop table terrain");
	86	database.ExecuteSql("drop table land");
	87	database.ExecuteSql("drop table landaccesslist");
	88	database.ExecuteSql("drop table regionban");
	89	database.ExecuteSql("drop table regionsettings");
	90	database.ExecuteSql("drop table estate_managers");
	91	database.ExecuteSql("drop table estate_groups");
	92	database.ExecuteSql("drop table estate_users");
	93	database.ExecuteSql("drop table estateban");
	94	database.ExecuteSql("drop table estate_settings");
	95	database.ExecuteSql("drop table estate_map");
	96	}
	97	}
	98	}
	99	}


diff --git a/OpenSim/Data/SQLite/Tests/SQLiteEstateTest.cs b/OpenSim/Data/SQLite/Tests/SQLiteEstateTest.cs new file mode 100644 index 0000000..8f27b65 --- /dev/null +++ b/OpenSim/Data/SQLite/Tests/SQLiteEstateTest.cs
@@ -0,0 +1,65 @@
	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 OpenSim 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
	28	using System;
	29	using System.IO;
	30	using System.Collections.Generic;
	31	using NUnit.Framework;
	32	using NUnit.Framework.SyntaxHelpers;
	33	using OpenSim.Framework;
	34	using OpenSim.Data.Tests;
	35	using OpenSim.Data.SQLite;
	36	using OpenSim.Region.Framework.Scenes;
	37	using OpenMetaverse;
	38
	39	namespace OpenSim.Data.SQLite.Tests
	40	{
	41	[TestFixture]
	42	public class SQLiteEstateTest : BasicEstateTest
	43	{
	44	public string file = "regiontest.db";
	45	public string connect;
	46
	47	[TestFixtureSetUp]
	48	public void Init()
	49	{
	50	SuperInit();
	51	file = Path.GetTempFileName() + ".db";
	52	connect = "URI=file:" + file + ",version=3";
	53	db = new SQLiteEstateStore();
	54	db.Initialise(connect);
	55	regionDb = new SQLiteRegionData();
	56	regionDb.Initialise(connect);
	57	}
	58
	59	[TestFixtureTearDown]
	60	public void Cleanup()
	61	{
	62	regionDb.Dispose();
	63	}
	64	}
	65	}


diff --git a/OpenSim/Data/Tests/BasicEstateTest.cs b/OpenSim/Data/Tests/BasicEstateTest.cs new file mode 100644 index 0000000..ef15150 --- /dev/null +++ b/OpenSim/Data/Tests/BasicEstateTest.cs
@@ -0,0 +1,154 @@
	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 OpenSim 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
	28	using System;
	29	using System.Collections.Generic;
	30	using System.Drawing;
	31	using System.Text;
	32	using NUnit.Framework;
	33	using NUnit.Framework.SyntaxHelpers;
	34	using OpenSim.Framework;
	35	using OpenSim.Data;
	36	using OpenMetaverse;
	37	using OpenSim.Region.Framework.Interfaces;
	38
	39	namespace OpenSim.Data.Tests
	40	{
	41	public class BasicEstateTest
	42	{
	43	public IEstateDataStore db;
	44	public IRegionDataStore regionDb;
	45	public UUID prim1;
	46	public static Random random;
	47
	48	public void SuperInit()
	49	{
	50	try
	51	{
	52	log4net.Config.XmlConfigurator.Configure();
	53	}
	54	catch (Exception)
	55	{
	56	// I don't care, just leave log4net off
	57	}
	58	prim1 = UUID.Random();
	59	random = new Random();
	60
	61	}
	62
	63	[Test]
	64	public void T010_StoreEstateSettings()
	65	{
	66	// Initializing field values. Avoid randomness. For checking ranges use different parameter sets
	67	// for mix and max values. If you use random values the tests are not _repeatable_.
	68	string estateName = "test-estate";
	69	uint parentEstateID = 2;
	70	float billableFactor = 3;
	71	int priceMeter = 4;
	72	int redirectGridX = 5;
	73	int redirectGridY = 6;
	74	bool useGlobalTime = true;
	75	bool fixedSun = true;
	76	double sunPosition = 7;
	77	bool allowVoice = true;
	78	bool allowDirectTeleport = true;
	79	bool denyAnonymous = true;
	80	bool denyIdentified = true;
	81	bool denyTransacted = true;
	82	bool abuseEmailtoEstateOwner = true;
	83	bool blockDwell = true;
	84	bool estateskipScripts = true;
	85	bool taxFree = true;
	86	bool publicAccess = true;
	87	string abuseMail = "test-email@nowhere.com";
	88	UUID estateOwner = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed7");
	89	bool denyMinors = (random.NextDouble() > 0.5)? true : false;
	90
	91	// Lets choose random region ID
	92	UUID regionId = new UUID("250d214e-1c7e-4f9b-a488-87c5e53feed7");
	93
	94	// Letting estate store generate rows to database for us
	95	EstateSettings es = db.LoadEstateSettings(regionId);
	96
	97	// Setting field values to the on demand create settings object.
	98	es.EstateName = estateName;
	99	es.ParentEstateID = parentEstateID;
	100	es.BillableFactor = billableFactor;
	101	es.PricePerMeter = priceMeter;
	102	es.RedirectGridX = redirectGridX;
	103	es.RedirectGridY = redirectGridY;
	104	es.UseGlobalTime = useGlobalTime;
	105	es.FixedSun = fixedSun;
	106	es.SunPosition = sunPosition;
	107	es.AllowVoice = allowVoice;
	108	es.AllowDirectTeleport = allowDirectTeleport;
	109	es.DenyAnonymous = denyAnonymous;
	110	es.DenyIdentified = denyIdentified;
	111	es.DenyTransacted = denyTransacted;
	112	es.AbuseEmailToEstateOwner = abuseEmailtoEstateOwner;
	113	es.BlockDwell = blockDwell;
	114	es.EstateSkipScripts = estateskipScripts;
	115	es.TaxFree = taxFree;
	116	es.PublicAccess = publicAccess;
	117	es.AbuseEmail = abuseMail;
	118	es.EstateOwner = estateOwner;
	119	es.DenyMinors = denyMinors;
	120
	121	// Saving settings.
	122	db.StoreEstateSettings(es);
	123
	124	// Loading settings to another instance variable.
	125	EstateSettings nes = db.LoadEstateSettings(regionId);
	126
	127	// Checking that loaded values are correct.
	128	Assert.That(estateName, Is.EqualTo(nes.EstateName));
	129	Assert.That(parentEstateID, Is.EqualTo(nes.ParentEstateID));
	130	Assert.That(billableFactor, Is.EqualTo(nes.BillableFactor));
	131	Assert.That(priceMeter, Is.EqualTo(nes.PricePerMeter));
	132	Assert.That(redirectGridX, Is.EqualTo(nes.RedirectGridX));
	133	Assert.That(redirectGridY, Is.EqualTo(nes.RedirectGridY));
	134	Assert.That(useGlobalTime, Is.EqualTo(nes.UseGlobalTime));
	135	Assert.That(fixedSun, Is.EqualTo(nes.FixedSun));
	136	Assert.That(sunPosition, Is.EqualTo(nes.SunPosition));
	137	Assert.That(allowVoice, Is.EqualTo(nes.AllowVoice));
	138	Assert.That(allowDirectTeleport, Is.EqualTo(nes.AllowDirectTeleport));
	139	Assert.That(denyAnonymous, Is.EqualTo(nes.DenyAnonymous));
	140	Assert.That(denyIdentified, Is.EqualTo(nes.DenyIdentified));
	141	Assert.That(denyTransacted, Is.EqualTo(nes.DenyTransacted));
	142	Assert.That(abuseEmailtoEstateOwner, Is.EqualTo(nes.AbuseEmailToEstateOwner));
	143	Assert.That(blockDwell, Is.EqualTo(nes.BlockDwell));
	144	Assert.That(estateskipScripts, Is.EqualTo(nes.EstateSkipScripts));
	145	Assert.That(taxFree, Is.EqualTo(nes.TaxFree));
	146	Assert.That(publicAccess, Is.EqualTo(nes.PublicAccess));
	147	Assert.That(abuseMail, Is.EqualTo(nes.AbuseEmail));
	148	Assert.That(estateOwner, Is.EqualTo(nes.EstateOwner));
	149	Assert.That(denyMinors, Is.EqualTo(nes.DenyMinors));
	150
	151	}
	152
	153	}
	154	}