diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs | 198 |
1 files changed, 99 insertions, 99 deletions
diff --git a/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs index 17e71e1..bee3d04 100644 --- a/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs +++ b/OpenSim/Data/MySQL/Tests/MySQLEstateTest.cs | |||
@@ -1,99 +1,99 @@ | |||
1 | /* | 1 | /* |
2 | * Copyright (c) Contributors, http://opensimulator.org/ | 2 | * Copyright (c) Contributors, http://opensimulator.org/ |
3 | * See CONTRIBUTORS.TXT for a full list of copyright holders. | 3 | * See CONTRIBUTORS.TXT for a full list of copyright holders. |
4 | * | 4 | * |
5 | * Redistribution and use in source and binary forms, with or without | 5 | * Redistribution and use in source and binary forms, with or without |
6 | * modification, are permitted provided that the following conditions are met: | 6 | * modification, are permitted provided that the following conditions are met: |
7 | * * Redistributions of source code must retain the above copyright | 7 | * * Redistributions of source code must retain the above copyright |
8 | * notice, this list of conditions and the following disclaimer. | 8 | * notice, this list of conditions and the following disclaimer. |
9 | * * Redistributions in binary form must reproduce the above copyright | 9 | * * Redistributions in binary form must reproduce the above copyright |
10 | * notice, this list of conditions and the following disclaimer in the | 10 | * notice, this list of conditions and the following disclaimer in the |
11 | * documentation and/or other materials provided with the distribution. | 11 | * documentation and/or other materials provided with the distribution. |
12 | * * Neither the name of the OpenSim Project nor the | 12 | * * Neither the name of the OpenSim Project nor the |
13 | * names of its contributors may be used to endorse or promote products | 13 | * names of its contributors may be used to endorse or promote products |
14 | * derived from this software without specific prior written permission. | 14 | * derived from this software without specific prior written permission. |
15 | * | 15 | * |
16 | * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY | 16 | * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY |
17 | * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | 17 | * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED |
18 | * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE | 18 | * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE |
19 | * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY | 19 | * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY |
20 | * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES | 20 | * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES |
21 | * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; | 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 | 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 | 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 | 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. | 25 | * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
26 | */ | 26 | */ |
27 | 27 | ||
28 | using System; | 28 | using System; |
29 | using System.IO; | 29 | using System.IO; |
30 | using System.Collections.Generic; | 30 | using System.Collections.Generic; |
31 | using NUnit.Framework; | 31 | using NUnit.Framework; |
32 | using NUnit.Framework.SyntaxHelpers; | 32 | using NUnit.Framework.SyntaxHelpers; |
33 | using OpenSim.Framework; | 33 | using OpenSim.Framework; |
34 | using OpenSim.Data.Tests; | 34 | using OpenSim.Data.Tests; |
35 | using OpenSim.Data.MySQL; | 35 | using OpenSim.Data.MySQL; |
36 | using OpenSim.Region.Framework.Scenes; | 36 | using OpenSim.Region.Framework.Scenes; |
37 | using OpenMetaverse; | 37 | using OpenMetaverse; |
38 | 38 | ||
39 | namespace OpenSim.Data.MySQL.Tests | 39 | namespace OpenSim.Data.MySQL.Tests |
40 | { | 40 | { |
41 | [TestFixture] | 41 | [TestFixture] |
42 | public class MySQLEstateTest : BasicEstateTest | 42 | public class MySQLEstateTest : BasicEstateTest |
43 | { | 43 | { |
44 | public string file; | 44 | public string file; |
45 | public MySQLManager database; | 45 | public MySQLManager database; |
46 | public string connect = "Server=localhost;Port=3306;Database=opensim-nunit;User ID=opensim-nunit;Password=opensim-nunit;Pooling=false;"; | 46 | public string connect = "Server=localhost;Port=3306;Database=opensim-nunit;User ID=opensim-nunit;Password=opensim-nunit;Pooling=false;"; |
47 | 47 | ||
48 | [TestFixtureSetUp] | 48 | [TestFixtureSetUp] |
49 | public void Init() | 49 | public void Init() |
50 | { | 50 | { |
51 | SuperInit(); | 51 | SuperInit(); |
52 | // If we manage to connect to the database with the user | 52 | // If we manage to connect to the database with the user |
53 | // and password above it is our test database, and run | 53 | // and password above it is our test database, and run |
54 | // these tests. If anything goes wrong, ignore these | 54 | // these tests. If anything goes wrong, ignore these |
55 | // tests. | 55 | // tests. |
56 | try | 56 | try |
57 | { | 57 | { |
58 | database = new MySQLManager(connect); | 58 | database = new MySQLManager(connect); |
59 | regionDb = new MySQLDataStore(); | 59 | regionDb = new MySQLDataStore(); |
60 | regionDb.Initialise(connect); | 60 | regionDb.Initialise(connect); |
61 | db = new MySQLEstateStore(); | 61 | db = new MySQLEstateStore(); |
62 | db.Initialise(connect); | 62 | db.Initialise(connect); |
63 | } | 63 | } |
64 | catch (Exception e) | 64 | catch (Exception e) |
65 | { | 65 | { |
66 | System.Console.WriteLine("Exception {0}", e); | 66 | System.Console.WriteLine("Exception {0}", e); |
67 | Assert.Ignore(); | 67 | Assert.Ignore(); |
68 | } | 68 | } |
69 | } | 69 | } |
70 | 70 | ||
71 | [TestFixtureTearDown] | 71 | [TestFixtureTearDown] |
72 | public void Cleanup() | 72 | public void Cleanup() |
73 | { | 73 | { |
74 | if (regionDb != null) | 74 | if (regionDb != null) |
75 | { | 75 | { |
76 | regionDb.Dispose(); | 76 | regionDb.Dispose(); |
77 | } | 77 | } |
78 | // if a new table is added, it has to be dropped here | 78 | // if a new table is added, it has to be dropped here |
79 | if (database != null) | 79 | if (database != null) |
80 | { | 80 | { |
81 | database.ExecuteSql("drop table migrations"); | 81 | database.ExecuteSql("drop table migrations"); |
82 | database.ExecuteSql("drop table prims"); | 82 | database.ExecuteSql("drop table prims"); |
83 | database.ExecuteSql("drop table primshapes"); | 83 | database.ExecuteSql("drop table primshapes"); |
84 | database.ExecuteSql("drop table primitems"); | 84 | database.ExecuteSql("drop table primitems"); |
85 | database.ExecuteSql("drop table terrain"); | 85 | database.ExecuteSql("drop table terrain"); |
86 | database.ExecuteSql("drop table land"); | 86 | database.ExecuteSql("drop table land"); |
87 | database.ExecuteSql("drop table landaccesslist"); | 87 | database.ExecuteSql("drop table landaccesslist"); |
88 | database.ExecuteSql("drop table regionban"); | 88 | database.ExecuteSql("drop table regionban"); |
89 | database.ExecuteSql("drop table regionsettings"); | 89 | database.ExecuteSql("drop table regionsettings"); |
90 | database.ExecuteSql("drop table estate_managers"); | 90 | database.ExecuteSql("drop table estate_managers"); |
91 | database.ExecuteSql("drop table estate_groups"); | 91 | database.ExecuteSql("drop table estate_groups"); |
92 | database.ExecuteSql("drop table estate_users"); | 92 | database.ExecuteSql("drop table estate_users"); |
93 | database.ExecuteSql("drop table estateban"); | 93 | database.ExecuteSql("drop table estateban"); |
94 | database.ExecuteSql("drop table estate_settings"); | 94 | database.ExecuteSql("drop table estate_settings"); |
95 | database.ExecuteSql("drop table estate_map"); | 95 | database.ExecuteSql("drop table estate_map"); |
96 | } | 96 | } |
97 | } | 97 | } |
98 | } | 98 | } |
99 | } | 99 | } |