aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data
diff options
context:
space:
mode:
authorAlexRa2010-05-06 21:10:01 +0200
committerAlexRa2010-05-23 11:48:02 +0300
commitb1e6e995065371a88c40284d9d504135c83b6f11 (patch)
treea4956557d0bcbbf162ee4203c674b1d5929ce229 /OpenSim/Data
parentBugfix in tests (must clear db before migrations, not after) (diff)
downloadopensim-SC-b1e6e995065371a88c40284d9d504135c83b6f11.zip
opensim-SC-b1e6e995065371a88c40284d9d504135c83b6f11.tar.gz
opensim-SC-b1e6e995065371a88c40284d9d504135c83b6f11.tar.bz2
opensim-SC-b1e6e995065371a88c40284d9d504135c83b6f11.tar.xz
BasicAssetTest.cs replaced by AssetTests.cs
AssetTests: The name has changed to reflect the fact it is no longer a base class, but the complete asset test for all supported databases. The test can also check storing of CreatorID, but the feature is disabled at this commit!
Diffstat (limited to 'OpenSim/Data')
-rw-r--r--OpenSim/Data/Tests/AssetTests.cs161
1 files changed, 161 insertions, 0 deletions
diff --git a/OpenSim/Data/Tests/AssetTests.cs b/OpenSim/Data/Tests/AssetTests.cs
new file mode 100644
index 0000000..acd5449
--- /dev/null
+++ b/OpenSim/Data/Tests/AssetTests.cs
@@ -0,0 +1,161 @@
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 System.Collections.Generic;
30using log4net.Config;
31using NUnit.Framework;
32using NUnit.Framework.Constraints;
33using OpenMetaverse;
34using OpenSim.Framework;
35using System.Data.Common;
36using log4net;
37
38// DBMS-specific:
39using MySql.Data.MySqlClient;
40using OpenSim.Data.MySQL;
41
42using System.Data.SqlClient;
43using OpenSim.Data.MSSQL;
44
45using Mono.Data.Sqlite;
46using OpenSim.Data.SQLite;
47
48namespace OpenSim.Data.Tests
49{
50 [TestFixture(typeof(MySqlConnection), typeof(MySQLAssetData), Description="Basic Asset store tests (MySQL)")]
51 [TestFixture(typeof(SqlConnection), typeof(MSSQLAssetData), Description = "Basic Asset store tests (MS SQL Server)")]
52 [TestFixture(typeof(SqliteConnection), typeof(SQLiteAssetData), Description = "Basic Asset store tests (SQLite)")]
53
54 public class AssetTests<TConn, TAssetData> : BasicDataServiceTest<TConn, TAssetData>
55 where TConn : DbConnection, new()
56 where TAssetData : AssetDataBase, new()
57 {
58 TAssetData m_db;
59
60 const bool COMPARE_CREATOR = false;
61
62 public UUID uuid1 = UUID.Random();
63 public UUID uuid2 = UUID.Random();
64 public UUID uuid3 = UUID.Random();
65
66 public UUID critter1 = COMPARE_CREATOR ? UUID.Random() : UUID.Zero;
67 public UUID critter2 = COMPARE_CREATOR ? UUID.Random() : UUID.Zero;
68 public UUID critter3 = COMPARE_CREATOR ? UUID.Random() : UUID.Zero;
69
70 public byte[] data1 = new byte[100];
71
72 PropertyScrambler<AssetBase> scrambler = new PropertyScrambler<AssetBase>()
73 .DontScramble(x => x.ID)
74 .DontScramble(x => x.Type)
75 .DontScramble(x => x.FullID)
76 .DontScramble(x => x.Metadata.ID)
77 .DontScramble(x => x.Metadata.CreatorID)
78 .DontScramble(x => x.Metadata.ContentType)
79 .DontScramble(x => x.Metadata.FullID)
80 .DontScramble(x => x.Data);
81
82 protected override void InitService(object service)
83 {
84 m_db = (TAssetData)service;
85 m_db.Initialise(m_connStr);
86 }
87
88 [Test]
89 public void T001_LoadEmpty()
90 {
91 Assert.That(m_db.ExistsAsset(uuid1), Is.False);
92 Assert.That(m_db.ExistsAsset(uuid2), Is.False);
93 Assert.That(m_db.ExistsAsset(uuid3), Is.False);
94 }
95
96 [Test]
97 public void T010_StoreReadVerifyAssets()
98 {
99 AssetBase a1 = new AssetBase(uuid1, "asset one", (sbyte)AssetType.Texture, critter1.ToString());
100 AssetBase a2 = new AssetBase(uuid2, "asset two", (sbyte)AssetType.Texture, critter2.ToString());
101 AssetBase a3 = new AssetBase(uuid3, "asset three", (sbyte)AssetType.Texture, critter3.ToString());
102 a1.Data = data1;
103 a2.Data = data1;
104 a3.Data = data1;
105
106 scrambler.Scramble(a1);
107 scrambler.Scramble(a2);
108 scrambler.Scramble(a3);
109
110 m_db.StoreAsset(a1);
111 m_db.StoreAsset(a2);
112 m_db.StoreAsset(a3);
113
114 AssetBase a1a = m_db.GetAsset(uuid1);
115 Assert.That(a1a, Constraints.PropertyCompareConstraint(a1));
116
117 AssetBase a2a = m_db.GetAsset(uuid2);
118 Assert.That(a2a, Constraints.PropertyCompareConstraint(a2));
119
120 AssetBase a3a = m_db.GetAsset(uuid3);
121 Assert.That(a3a, Constraints.PropertyCompareConstraint(a3));
122
123 scrambler.Scramble(a1a);
124 scrambler.Scramble(a2a);
125 scrambler.Scramble(a3a);
126
127 m_db.StoreAsset(a1a);
128 m_db.StoreAsset(a2a);
129 m_db.StoreAsset(a3a);
130
131 AssetBase a1b = m_db.GetAsset(uuid1);
132 Assert.That(a1b, Constraints.PropertyCompareConstraint(a1a));
133
134 AssetBase a2b = m_db.GetAsset(uuid2);
135 Assert.That(a2b, Constraints.PropertyCompareConstraint(a2a));
136
137 AssetBase a3b = m_db.GetAsset(uuid3);
138 Assert.That(a3b, Constraints.PropertyCompareConstraint(a3a));
139
140 Assert.That(m_db.ExistsAsset(uuid1), Is.True);
141 Assert.That(m_db.ExistsAsset(uuid2), Is.True);
142 Assert.That(m_db.ExistsAsset(uuid3), Is.True);
143
144 List<AssetMetadata> metadatas = m_db.FetchAssetMetadataSet(0, 1000);
145
146 Assert.That(metadatas.Count >= 3, "FetchAssetMetadataSet() should have returned at least 3 assets!");
147
148 // It is possible that the Asset table is filled with data, in which case we don't try to find "our"
149 // assets there:
150 if (metadatas.Count < 1000)
151 {
152 AssetMetadata metadata = metadatas.Find(x => x.FullID == uuid1);
153 Assert.That(metadata.Name, Is.EqualTo(a1b.Name));
154 Assert.That(metadata.Description, Is.EqualTo(a1b.Description));
155 Assert.That(metadata.Type, Is.EqualTo(a1b.Type));
156 Assert.That(metadata.Temporary, Is.EqualTo(a1b.Temporary));
157 Assert.That(metadata.FullID, Is.EqualTo(a1b.FullID));
158 }
159 }
160 }
161}