From 0c03a48fb2060eda4d288e2d2ca4e650ce000b4b Mon Sep 17 00:00:00 2001 From: Mike Mazur Date: Wed, 4 Feb 2009 00:01:36 +0000 Subject: - add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of it - trim trailing whitespace --- OpenSim/Data/MSSQL/MSSQLAssetData.cs | 40 +++++++++++----------- OpenSim/Data/MySQL/MySQLAssetData.cs | 34 +++++++++---------- OpenSim/Data/NHibernate/NHibernateAssetData.cs | 6 ++-- OpenSim/Data/SQLite/SQLiteAssetData.cs | 46 +++++++++++++------------- OpenSim/Data/Tests/BasicAssetTest.cs | 20 +++++------ 5 files changed, 73 insertions(+), 73 deletions(-) (limited to 'OpenSim/Data') diff --git a/OpenSim/Data/MSSQL/MSSQLAssetData.cs b/OpenSim/Data/MSSQL/MSSQLAssetData.cs index 3eaae12..425e233 100644 --- a/OpenSim/Data/MSSQL/MSSQLAssetData.cs +++ b/OpenSim/Data/MSSQL/MSSQLAssetData.cs @@ -132,12 +132,12 @@ namespace OpenSim.Data.MSSQL { AssetBase asset = new AssetBase(); // Region Main - asset.FullID = new UUID((string)reader["id"]); - asset.Name = (string)reader["name"]; - asset.Description = (string)reader["description"]; - asset.Type = Convert.ToSByte(reader["assetType"]); - asset.Local = Convert.ToBoolean(reader["local"]); - asset.Temporary = Convert.ToBoolean(reader["temporary"]); + asset.Metadata.FullID = new UUID((string)reader["id"]); + asset.Metadata.Name = (string)reader["name"]; + asset.Metadata.Description = (string)reader["description"]; + asset.Metadata.Type = Convert.ToSByte(reader["assetType"]); + asset.Metadata.Local = Convert.ToBoolean(reader["local"]); + asset.Metadata.Temporary = Convert.ToBoolean(reader["temporary"]); asset.Data = (byte[])reader["data"]; return asset; } @@ -152,7 +152,7 @@ namespace OpenSim.Data.MSSQL /// the asset override public void CreateAsset(AssetBase asset) { - if (ExistsAsset(asset.FullID)) + if (ExistsAsset(asset.Metadata.FullID)) { return; } @@ -163,12 +163,12 @@ namespace OpenSim.Data.MSSQL "(@id, @name, @description, @assetType, @local, @temporary, @create_time, @access_time, @data)")) { int now = (int)((System.DateTime.Now.Ticks - TicksToEpoch) / 10000000); - command.Parameters.Add(database.CreateParameter("id", asset.FullID)); - command.Parameters.Add(database.CreateParameter("name", asset.Name)); - command.Parameters.Add(database.CreateParameter("description", asset.Description)); - command.Parameters.Add(database.CreateParameter("assetType", asset.Type)); - command.Parameters.Add(database.CreateParameter("local", asset.Local)); - command.Parameters.Add(database.CreateParameter("temporary", asset.Temporary)); + command.Parameters.Add(database.CreateParameter("id", asset.Metadata.FullID)); + command.Parameters.Add(database.CreateParameter("name", asset.Metadata.Name)); + command.Parameters.Add(database.CreateParameter("description", asset.Metadata.Description)); + command.Parameters.Add(database.CreateParameter("assetType", asset.Metadata.Type)); + command.Parameters.Add(database.CreateParameter("local", asset.Metadata.Local)); + command.Parameters.Add(database.CreateParameter("temporary", asset.Metadata.Temporary)); command.Parameters.Add(database.CreateParameter("access_time", now)); command.Parameters.Add(database.CreateParameter("create_time", now)); command.Parameters.Add(database.CreateParameter("data", asset.Data)); @@ -192,14 +192,14 @@ namespace OpenSim.Data.MSSQL "data = @data where " + "id = @keyId;")) { - command.Parameters.Add(database.CreateParameter("id", asset.FullID)); - command.Parameters.Add(database.CreateParameter("name", asset.Name)); - command.Parameters.Add(database.CreateParameter("description", asset.Description)); - command.Parameters.Add(database.CreateParameter("assetType", asset.Type)); - command.Parameters.Add(database.CreateParameter("local", asset.Local)); - command.Parameters.Add(database.CreateParameter("temporary", asset.Temporary)); + command.Parameters.Add(database.CreateParameter("id", asset.Metadata.FullID)); + command.Parameters.Add(database.CreateParameter("name", asset.Metadata.Name)); + command.Parameters.Add(database.CreateParameter("description", asset.Metadata.Description)); + command.Parameters.Add(database.CreateParameter("assetType", asset.Metadata.Type)); + command.Parameters.Add(database.CreateParameter("local", asset.Metadata.Local)); + command.Parameters.Add(database.CreateParameter("temporary", asset.Metadata.Temporary)); command.Parameters.Add(database.CreateParameter("data", asset.Data)); - command.Parameters.Add(database.CreateParameter("@keyId", asset.FullID)); + command.Parameters.Add(database.CreateParameter("@keyId", asset.Metadata.FullID)); try { diff --git a/OpenSim/Data/MySQL/MySQLAssetData.cs b/OpenSim/Data/MySQL/MySQLAssetData.cs index 3ff2a1a..823fa78 100644 --- a/OpenSim/Data/MySQL/MySQLAssetData.cs +++ b/OpenSim/Data/MySQL/MySQLAssetData.cs @@ -139,18 +139,18 @@ namespace OpenSim.Data.MySQL { asset = new AssetBase(); asset.Data = (byte[]) dbReader["data"]; - asset.Description = (string) dbReader["description"]; - asset.FullID = assetID; + asset.Metadata.Description = (string) dbReader["description"]; + asset.Metadata.FullID = assetID; try { - asset.Local = (bool)dbReader["local"]; + asset.Metadata.Local = (bool)dbReader["local"]; } catch (System.InvalidCastException) { - asset.Local = false; + asset.Metadata.Local = false; } - asset.Name = (string) dbReader["name"]; - asset.Type = (sbyte) dbReader["assetType"]; + asset.Metadata.Name = (string) dbReader["name"]; + asset.Metadata.Type = (sbyte) dbReader["assetType"]; } dbReader.Close(); cmd.Dispose(); @@ -178,8 +178,8 @@ namespace OpenSim.Data.MySQL { lock (_dbConnection) { - //m_log.Info("[ASSET DB]: Creating Asset " + Util.ToRawUuidString(asset.FullID)); - if (ExistsAsset(asset.FullID)) + //m_log.Info("[ASSET DB]: Creating Asset " + Util.ToRawUuidString(asset.Metadata.FullID)); + if (ExistsAsset(asset.Metadata.FullID)) { //m_log.Info("[ASSET DB]: Asset exists already, ignoring."); return; @@ -200,12 +200,12 @@ namespace OpenSim.Data.MySQL { // create unix epoch time int now = (int)((System.DateTime.Now.Ticks - TicksToEpoch) / 10000000); - cmd.Parameters.AddWithValue("?id", asset.FullID.ToString()); - cmd.Parameters.AddWithValue("?name", asset.Name); - cmd.Parameters.AddWithValue("?description", asset.Description); - cmd.Parameters.AddWithValue("?assetType", asset.Type); - cmd.Parameters.AddWithValue("?local", asset.Local); - cmd.Parameters.AddWithValue("?temporary", asset.Temporary); + cmd.Parameters.AddWithValue("?id", asset.Metadata.ID); + cmd.Parameters.AddWithValue("?name", asset.Metadata.Name); + cmd.Parameters.AddWithValue("?description", asset.Metadata.Description); + cmd.Parameters.AddWithValue("?assetType", asset.Metadata.Type); + cmd.Parameters.AddWithValue("?local", asset.Metadata.Local); + cmd.Parameters.AddWithValue("?temporary", asset.Metadata.Temporary); cmd.Parameters.AddWithValue("?create_time", now); cmd.Parameters.AddWithValue("?access_time", now); cmd.Parameters.AddWithValue("?data", asset.Data); @@ -218,7 +218,7 @@ namespace OpenSim.Data.MySQL m_log.ErrorFormat( "[ASSETS DB]: " + "MySql failure creating asset {0} with name {1}" + Environment.NewLine + e.ToString() - + Environment.NewLine + "Attempting reconnection", asset.FullID, asset.Name); + + Environment.NewLine + "Attempting reconnection", asset.Metadata.FullID, asset.Metadata.Name); _dbConnection.Reconnect(); } } @@ -241,7 +241,7 @@ namespace OpenSim.Data.MySQL { // create unix epoch time int now = (int)((System.DateTime.Now.Ticks - TicksToEpoch) / 10000000); - cmd.Parameters.AddWithValue("?id", asset.FullID.ToString()); + cmd.Parameters.AddWithValue("?id", asset.Metadata.ID); cmd.Parameters.AddWithValue("?access_time", now); cmd.ExecuteNonQuery(); cmd.Dispose(); @@ -252,7 +252,7 @@ namespace OpenSim.Data.MySQL m_log.ErrorFormat( "[ASSETS DB]: " + "MySql failure updating access_time for asset {0} with name {1}" + Environment.NewLine + e.ToString() - + Environment.NewLine + "Attempting reconnection", asset.FullID, asset.Name); + + Environment.NewLine + "Attempting reconnection", asset.Metadata.FullID, asset.Metadata.Name); _dbConnection.Reconnect(); } } diff --git a/OpenSim/Data/NHibernate/NHibernateAssetData.cs b/OpenSim/Data/NHibernate/NHibernateAssetData.cs index fab39b1..d0046c6 100644 --- a/OpenSim/Data/NHibernate/NHibernateAssetData.cs +++ b/OpenSim/Data/NHibernate/NHibernateAssetData.cs @@ -69,7 +69,7 @@ namespace OpenSim.Data.NHibernate private void Save(AssetBase asset) { - AssetBase temp = (AssetBase)manager.Load(typeof(AssetBase), asset.FullID); + AssetBase temp = (AssetBase)manager.Load(typeof(AssetBase), asset.Metadata.FullID); if (temp == null) { manager.Save(asset); @@ -78,13 +78,13 @@ namespace OpenSim.Data.NHibernate override public void CreateAsset(AssetBase asset) { - m_log.InfoFormat("[NHIBERNATE] inserting asset {0}", asset.FullID); + m_log.InfoFormat("[NHIBERNATE] inserting asset {0}", asset.Metadata.FullID); Save(asset); } override public void UpdateAsset(AssetBase asset) { - m_log.InfoFormat("[NHIBERNATE] updating asset {0}", asset.FullID); + m_log.InfoFormat("[NHIBERNATE] updating asset {0}", asset.Metadata.FullID); manager.Update(asset); } diff --git a/OpenSim/Data/SQLite/SQLiteAssetData.cs b/OpenSim/Data/SQLite/SQLiteAssetData.cs index 30ba642..d28956f 100644 --- a/OpenSim/Data/SQLite/SQLiteAssetData.cs +++ b/OpenSim/Data/SQLite/SQLiteAssetData.cs @@ -125,8 +125,8 @@ namespace OpenSim.Data.SQLite /// Asset Base override public void CreateAsset(AssetBase asset) { - //m_log.Info("[ASSET DB]: Creating Asset " + Util.ToRawUuidString(asset.FullID)); - if (ExistsAsset(asset.FullID)) + //m_log.Info("[ASSET DB]: Creating Asset " + Util.ToRawUuidString(asset.Metadata.FullID)); + if (ExistsAsset(asset.Metadata.FullID)) { //m_log.Info("[ASSET DB]: Asset exists already, ignoring."); } @@ -136,12 +136,12 @@ namespace OpenSim.Data.SQLite { using (SqliteCommand cmd = new SqliteCommand(InsertAssetSQL, m_conn)) { - cmd.Parameters.Add(new SqliteParameter(":UUID", Util.ToRawUuidString(asset.FullID))); - cmd.Parameters.Add(new SqliteParameter(":Name", asset.Name)); - cmd.Parameters.Add(new SqliteParameter(":Description", asset.Description)); - cmd.Parameters.Add(new SqliteParameter(":Type", asset.Type)); - cmd.Parameters.Add(new SqliteParameter(":Local", asset.Local)); - cmd.Parameters.Add(new SqliteParameter(":Temporary", asset.Temporary)); + cmd.Parameters.Add(new SqliteParameter(":UUID", Util.ToRawUuidString(asset.Metadata.FullID))); + cmd.Parameters.Add(new SqliteParameter(":Name", asset.Metadata.Name)); + cmd.Parameters.Add(new SqliteParameter(":Description", asset.Metadata.Description)); + cmd.Parameters.Add(new SqliteParameter(":Type", asset.Metadata.Type)); + cmd.Parameters.Add(new SqliteParameter(":Local", asset.Metadata.Local)); + cmd.Parameters.Add(new SqliteParameter(":Temporary", asset.Metadata.Temporary)); cmd.Parameters.Add(new SqliteParameter(":Data", asset.Data)); cmd.ExecuteNonQuery(); @@ -162,12 +162,12 @@ namespace OpenSim.Data.SQLite { using (SqliteCommand cmd = new SqliteCommand(UpdateAssetSQL, m_conn)) { - cmd.Parameters.Add(new SqliteParameter(":UUID", Util.ToRawUuidString(asset.FullID))); - cmd.Parameters.Add(new SqliteParameter(":Name", asset.Name)); - cmd.Parameters.Add(new SqliteParameter(":Description", asset.Description)); - cmd.Parameters.Add(new SqliteParameter(":Type", asset.Type)); - cmd.Parameters.Add(new SqliteParameter(":Local", asset.Local)); - cmd.Parameters.Add(new SqliteParameter(":Temporary", asset.Temporary)); + cmd.Parameters.Add(new SqliteParameter(":UUID", Util.ToRawUuidString(asset.Metadata.FullID))); + cmd.Parameters.Add(new SqliteParameter(":Name", asset.Metadata.Name)); + cmd.Parameters.Add(new SqliteParameter(":Description", asset.Metadata.Description)); + cmd.Parameters.Add(new SqliteParameter(":Type", asset.Metadata.Type)); + cmd.Parameters.Add(new SqliteParameter(":Local", asset.Metadata.Local)); + cmd.Parameters.Add(new SqliteParameter(":Temporary", asset.Metadata.Temporary)); cmd.Parameters.Add(new SqliteParameter(":Data", asset.Data)); cmd.ExecuteNonQuery(); @@ -181,14 +181,14 @@ namespace OpenSim.Data.SQLite /// private static void LogAssetLoad(AssetBase asset) { - string temporary = asset.Temporary ? "Temporary" : "Stored"; - string local = asset.Local ? "Local" : "Remote"; + string temporary = asset.Metadata.Temporary ? "Temporary" : "Stored"; + string local = asset.Metadata.Local ? "Local" : "Remote"; int assetLength = (asset.Data != null) ? asset.Data.Length : 0; m_log.Info("[ASSET DB]: " + string.Format("Loaded {6} {5} Asset: [{0}][{3}] \"{1}\":{2} ({7} bytes)", - asset.FullID, asset.Name, asset.Description, asset.Type, + asset.Metadata.FullID, asset.Metadata.Name, asset.Metadata.Description, asset.Metadata.Type, temporary, local, assetLength)); } @@ -246,12 +246,12 @@ namespace OpenSim.Data.SQLite // back out. Not enough time to figure it out yet. AssetBase asset = new AssetBase(); - asset.FullID = new UUID((String) row["UUID"]); - asset.Name = (String) row["Name"]; - asset.Description = (String) row["Description"]; - asset.Type = Convert.ToSByte(row["Type"]); - asset.Local = Convert.ToBoolean(row["Local"]); - asset.Temporary = Convert.ToBoolean(row["Temporary"]); + asset.Metadata.FullID = new UUID((String) row["UUID"]); + asset.Metadata.Name = (String) row["Name"]; + asset.Metadata.Description = (String) row["Description"]; + asset.Metadata.Type = Convert.ToSByte(row["Type"]); + asset.Metadata.Local = Convert.ToBoolean(row["Local"]); + asset.Metadata.Temporary = Convert.ToBoolean(row["Temporary"]); asset.Data = (byte[]) row["Data"]; return asset; } diff --git a/OpenSim/Data/Tests/BasicAssetTest.cs b/OpenSim/Data/Tests/BasicAssetTest.cs index 6546472..5993f96 100644 --- a/OpenSim/Data/Tests/BasicAssetTest.cs +++ b/OpenSim/Data/Tests/BasicAssetTest.cs @@ -61,7 +61,7 @@ namespace OpenSim.Data.Tests asset1 = new byte[100]; asset1.Initialize(); } - + [Test] public void T001_LoadEmpty() { @@ -69,7 +69,7 @@ namespace OpenSim.Data.Tests Assert.That(db.ExistsAsset(uuid2), Is.False); Assert.That(db.ExistsAsset(uuid3), Is.False); } - + [Test] public void T010_StoreSimpleAsset() { @@ -79,22 +79,22 @@ namespace OpenSim.Data.Tests a1.Data = asset1; a2.Data = asset1; a3.Data = asset1; - + db.CreateAsset(a1); db.CreateAsset(a2); db.CreateAsset(a3); AssetBase a1a = db.FetchAsset(uuid1); - Assert.That(a1.ID, Is.EqualTo(a1a.ID)); - Assert.That(a1.Name, Is.EqualTo(a1a.Name)); + Assert.That(a1.Metadata.ID, Is.EqualTo(a1a.Metadata.ID)); + Assert.That(a1.Metadata.Name, Is.EqualTo(a1a.Metadata.Name)); AssetBase a2a = db.FetchAsset(uuid2); - Assert.That(a2.ID, Is.EqualTo(a2a.ID)); - Assert.That(a2.Name, Is.EqualTo(a2a.Name)); + Assert.That(a2.Metadata.ID, Is.EqualTo(a2a.Metadata.ID)); + Assert.That(a2.Metadata.Name, Is.EqualTo(a2a.Metadata.Name)); AssetBase a3a = db.FetchAsset(uuid3); - Assert.That(a3.ID, Is.EqualTo(a3a.ID)); - Assert.That(a3.Name, Is.EqualTo(a3a.Name)); + Assert.That(a3.Metadata.ID, Is.EqualTo(a3a.Metadata.ID)); + Assert.That(a3.Metadata.Name, Is.EqualTo(a3a.Metadata.Name)); } [Test] @@ -117,4 +117,4 @@ namespace OpenSim.Data.Tests // Assert.That(db.ExistsAsset(uuid3), Is.False); // } } -} \ No newline at end of file +} -- cgit v1.1