From a583d8ad70daad8c755c2f43e2f2af7bc5b7ee4d Mon Sep 17 00:00:00 2001 From: Charles Krinke Date: Sat, 14 Feb 2009 19:47:02 +0000 Subject: Thank you kindly, TLaukkan (Tommil) for a patch that: * Created value object for EstateRegionLink for storing the estate region relationship. * Refactored slightly NHibernateManager and NHibernateXXXXData implementations for accesing nhibernate generated ID on insert. ** Changed NHibernateManager.Save method name to Insert as it does Insert. ** Changed NHibernateManager.Save return value object as ID can be both UUID and uint currently. ** Changed NHibernateManager.Load method Id parameter to object as it can be both UUID and uint. * Created NHibernateEstateData implementation. This is the actual estate storage. * Created NHibernate mapping files for both EstateSettings and EstateRegionLink * Created MigrationSyntaxDifferences.txt files to write notes about differences in migration scripts between different databases. * Created estate storage migration scripts for all four databases. * Created estate unit test classes for all four databases. * Updated one missing field to BasicEstateTest.cs * Tested NHibernate unit tests with NUnit GUI. Asset databases fail but that is not related to this patch. * Tested build with both Visual Studio and nant. * Executed build tests with nant succesfully. --- OpenSim/Data/NHibernate/NHibernateEstateData.cs | 161 ++++++++++++++++++++++++ 1 file changed, 161 insertions(+) create mode 100644 OpenSim/Data/NHibernate/NHibernateEstateData.cs (limited to 'OpenSim/Data/NHibernate/NHibernateEstateData.cs') diff --git a/OpenSim/Data/NHibernate/NHibernateEstateData.cs b/OpenSim/Data/NHibernate/NHibernateEstateData.cs new file mode 100644 index 0000000..59896dd --- /dev/null +++ b/OpenSim/Data/NHibernate/NHibernateEstateData.cs @@ -0,0 +1,161 @@ +/* + * 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.Reflection; +using log4net; +using OpenMetaverse; +using OpenSim.Framework; +using OpenSim.Region.Framework.Interfaces; +using NHibernate; +using NHibernate.Criterion; +using System.Collections; +using System; + +namespace OpenSim.Data.NHibernate +{ + /// + /// A User storage interface for the DB4o database system + /// + public class NHibernateEstateData : IEstateDataStore + { + + #region Fields + + private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); + + public NHibernateManager manager; + + public string Name + { + get { return "NHibernateEstateData"; } + } + + public string Version + { + get { return "0.1"; } + } + + #endregion + + #region Startup and shutdown. + + public void Initialise() + { + m_log.Info("[NHIBERNATE]: " + Name + " cannot be default-initialized!"); + throw new PluginNotInitialisedException(Name); + } + + public void Initialise(string connect) + { + + m_log.InfoFormat("[NHIBERNATE] Initializing " + Name + "."); + manager = new NHibernateManager(connect, "EstateStore"); + } + + public void Dispose() { } + + #endregion + + #region IEstateDataStore Members + + public EstateSettings LoadEstateSettings(UUID regionID) + { + EstateRegionLink link = LoadEstateRegionLink(regionID); + + // Ensure that estate settings exist for the link + if (link != null) + { + if (manager.Load(typeof(EstateSettings), link.EstateID) == null) + { + // Delete broken link + manager.Delete(link); + link = null; + } + } + + // If estate link does not exist create estate settings and link it to region. + if (link == null) + { + EstateSettings estateSettings = new EstateSettings(); + //estateSettings.EstateOwner = UUID.Random(); + //estateSettings.BlockDwell = false; + object identifier = manager.Insert(estateSettings); + + if (identifier == null) + { + // Saving failed. Error is logged in the manager. + return null; + } + + uint estateID = (uint)identifier; + link = new EstateRegionLink(); + link.EstateRegionLinkID = UUID.Random(); + link.RegionID = regionID; + link.EstateID = estateID; + manager.Insert(link); + } + + // Load estate settings according to the existing or created link. + return (EstateSettings)manager.Load(typeof(EstateSettings), link.EstateID); + } + + public void StoreEstateSettings(EstateSettings estateSettings) + { + // Estates are always updated when stored. + // Insert is always done via. load method as with the current API + // this is explicitly the only way to create region link. + manager.Update(estateSettings); + } + + #endregion + + #region Private Utility Methods + private EstateRegionLink LoadEstateRegionLink(UUID regionID) + { + ICriteria criteria = manager.GetSession().CreateCriteria(typeof(EstateRegionLink)); + criteria.Add(Expression.Eq("RegionID", regionID)); + IList links = criteria.List(); + + // Fail fast if more than one estate links exist + if (links.Count > 1) + { + m_log.Error("[NHIBERNATE]: Region had more than one estate linked: " + regionID); + throw new Exception("[NHIBERNATE]: Region had more than one estate linked: " + regionID); + } + + if (links.Count == 1) + { + return (EstateRegionLink)links[0]; + } + else + { + return null; + } + } + #endregion + } +} -- cgit v1.1