Annotation of /trunk/AssetServer/Extensions/OpenSimMySQL/OpenSimMySQLInventory.cs
Parent Directory
| 
Revision Log
Revision 70 - (view) (download)
| 1 : | jhurliman | 63 | /* |
| 2 : | * Copyright (c) 2008 Intel Corporation | ||
| 3 : | * All rights reserved. | ||
| 4 : | * Redistribution and use in source and binary forms, with or without | ||
| 5 : | * modification, are permitted provided that the following conditions | ||
| 6 : | * are met: | ||
| 7 : | * | ||
| 8 : | * -- Redistributions of source code must retain the above copyright | ||
| 9 : | * notice, this list of conditions and the following disclaimer. | ||
| 10 : | * -- Redistributions in binary form must reproduce the above copyright | ||
| 11 : | * notice, this list of conditions and the following disclaimer in the | ||
| 12 : | * documentation and/or other materials provided with the distribution. | ||
| 13 : | * -- Neither the name of the Intel Corporation nor the names of its | ||
| 14 : | * contributors may be used to endorse or promote products derived from | ||
| 15 : | * this software without specific prior written permission. | ||
| 16 : | * | ||
| 17 : | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS | ||
| 18 : | * ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT | ||
| 19 : | * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A | ||
| 20 : | * PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE INTEL OR ITS | ||
| 21 : | * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, | ||
| 22 : | * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, | ||
| 23 : | * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR | ||
| 24 : | * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF | ||
| 25 : | * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING | ||
| 26 : | * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS | ||
| 27 : | * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | ||
| 28 : | */ | ||
| 29 : | |||
| 30 : | using System; | ||
| 31 : | using System.Collections.Generic; | ||
| 32 : | using System.Net; | ||
| 33 : | using System.Data; | ||
| 34 : | using MySql.Data.MySqlClient; | ||
| 35 : | using ExtensionLoader; | ||
| 36 : | using ExtensionLoader.Config; | ||
| 37 : | using OpenMetaverse; | ||
| 38 : | using OpenMetaverse.StructuredData; | ||
| 39 : | |||
| 40 : | namespace AssetServer.Extensions | ||
| 41 : | { | ||
| 42 : | public class OpenSimMySQLInventory : IExtension<AssetServer>, IInventoryProvider | ||
| 43 : | { | ||
| 44 : | const string EXTENSION_NAME = "OpenSimMySQLInventory"; // Used in metrics reporting | ||
| 45 : | |||
| 46 : | AssetServer server; | ||
| 47 : | |||
| 48 : | public OpenSimMySQLInventory() | ||
| 49 : | { | ||
| 50 : | } | ||
| 51 : | |||
| 52 : | #region Required Interfaces | ||
| 53 : | |||
| 54 : | public void Start(AssetServer server) | ||
| 55 : | { | ||
| 56 : | this.server = server; | ||
| 57 : | |||
| 58 : | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) | ||
| 59 : | { | ||
| 60 : | try | ||
| 61 : | { | ||
| 62 : | dbConnection.Open(); | ||
| 63 : | Logger.Log.Info("Connected to MySQL inventory backend: " + dbConnection.ServerVersion); | ||
| 64 : | } | ||
| 65 : | catch (MySqlException ex) | ||
| 66 : | { | ||
| 67 : | Logger.Log.Error("Connection to MySQL inventory backend failed: " + ex.Message); | ||
| 68 : | } | ||
| 69 : | } | ||
| 70 : | } | ||
| 71 : | |||
| 72 : | public void Stop() | ||
| 73 : | { | ||
| 74 : | } | ||
| 75 : | |||
| 76 : | jhurliman | 70 | public BackendResponse TryFetchItem(Uri owner, UUID itemID, out InventoryItem item) |
| 77 : | jhurliman | 63 | { |
| 78 : | item = null; | ||
| 79 : | jhurliman | 70 | BackendResponse ret; |
| 80 : | jhurliman | 63 | |
| 81 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 82 : | jhurliman | 63 | { |
| 83 : | jhurliman | 69 | IDataReader reader; |
| 84 : | |||
| 85 : | try | ||
| 86 : | jhurliman | 63 | { |
| 87 : | jhurliman | 69 | dbConnection.Open(); |
| 88 : | jhurliman | 63 | |
| 89 : | jhurliman | 69 | IDbCommand command = dbConnection.CreateCommand(); |
| 90 : | command.CommandText = String.Format("SELECT assetID,assetType,inventoryName,inventoryDescription,inventoryNextPermissions," + | ||
| 91 : | "inventoryCurrentPermissions,invType,creatorID,inventoryBasePermissions,inventoryEveryOnePermissions,salePrice,saleType," + | ||
| 92 : | "creationDate,groupID,groupOwned,flags,avatarID,parentFolderID,inventoryGroupPermissions FROM inventoryitems WHERE inventoryID='{0}'", | ||
| 93 : | itemID.ToString()); | ||
| 94 : | reader = command.ExecuteReader(); | ||
| 95 : | |||
| 96 : | if (reader.Read()) | ||
| 97 : | jhurliman | 63 | { |
| 98 : | jhurliman | 69 | item = new InventoryItem(); |
| 99 : | item.ID = itemID; | ||
| 100 : | item.AssetID = UUID.Parse(reader.GetString(0)); | ||
| 101 : | item.AssetType = reader.GetInt32(1); | ||
| 102 : | item.Name = reader.GetString(2); | ||
| 103 : | item.Description = reader.GetString(3); | ||
| 104 : | item.NextPermissions = (uint)reader.GetInt32(4); | ||
| 105 : | item.CurrentPermissions = (uint)reader.GetInt32(5); | ||
| 106 : | item.InvType = reader.GetInt32(6); | ||
| 107 : | item.Creator = UUID.Parse(reader.GetString(7)); | ||
| 108 : | item.BasePermissions = (uint)reader.GetInt32(8); | ||
| 109 : | item.EveryOnePermissions = (uint)reader.GetInt32(9); | ||
| 110 : | item.SalePrice = reader.GetInt32(10); | ||
| 111 : | item.SaleType = reader.GetByte(11); | ||
| 112 : | item.CreationDate = reader.GetInt32(12); | ||
| 113 : | item.GroupID = UUID.Parse(reader.GetString(13)); | ||
| 114 : | item.GroupOwned = reader.GetBoolean(14); | ||
| 115 : | item.Flags = (uint)reader.GetInt32(15); | ||
| 116 : | item.Owner = UUID.Parse(reader.GetString(16)); | ||
| 117 : | item.Folder = UUID.Parse(reader.GetString(17)); | ||
| 118 : | item.GroupPermissions = (uint)reader.GetInt32(18); | ||
| 119 : | jhurliman | 63 | |
| 120 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 121 : | jhurliman | 63 | } |
| 122 : | jhurliman | 69 | else |
| 123 : | jhurliman | 63 | { |
| 124 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 125 : | jhurliman | 63 | } |
| 126 : | } | ||
| 127 : | jhurliman | 69 | catch (MySqlException ex) |
| 128 : | { | ||
| 129 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 130 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 131 : | jhurliman | 69 | } |
| 132 : | jhurliman | 63 | } |
| 133 : | |||
| 134 : | jhurliman | 69 | server.MetricsProvider.LogInventoryFetch(EXTENSION_NAME, ret, owner, itemID, false, DateTime.Now); |
| 135 : | jhurliman | 63 | return ret; |
| 136 : | } | ||
| 137 : | |||
| 138 : | jhurliman | 70 | public BackendResponse TryFetchFolder(Uri owner, UUID folderID, out InventoryFolder folder) |
| 139 : | jhurliman | 63 | { |
| 140 : | folder = null; | ||
| 141 : | jhurliman | 70 | BackendResponse ret; |
| 142 : | jhurliman | 63 | |
| 143 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 144 : | jhurliman | 63 | { |
| 145 : | jhurliman | 69 | IDataReader reader; |
| 146 : | |||
| 147 : | try | ||
| 148 : | jhurliman | 63 | { |
| 149 : | jhurliman | 69 | dbConnection.Open(); |
| 150 : | jhurliman | 63 | |
| 151 : | jhurliman | 69 | IDbCommand command = dbConnection.CreateCommand(); |
| 152 : | command.CommandText = String.Format("SELECT folderName,type,version,agentID,parentFolderID FROM inventoryfolders WHERE folderID='{0}'", | ||
| 153 : | folderID.ToString()); | ||
| 154 : | reader = command.ExecuteReader(); | ||
| 155 : | |||
| 156 : | if (reader.Read()) | ||
| 157 : | jhurliman | 63 | { |
| 158 : | jhurliman | 69 | folder = new InventoryFolder(); |
| 159 : | folder.Children = null; // This call only returns data for the folder itself, no children data | ||
| 160 : | folder.ID = folderID; | ||
| 161 : | folder.Name = reader.GetString(0); | ||
| 162 : | folder.Type = reader.GetInt16(1); | ||
| 163 : | folder.Version = (ushort)reader.GetInt16(2); | ||
| 164 : | folder.Owner = UUID.Parse(reader.GetString(3)); | ||
| 165 : | folder.ParentID = UUID.Parse(reader.GetString(4)); | ||
| 166 : | jhurliman | 63 | |
| 167 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 168 : | jhurliman | 63 | } |
| 169 : | jhurliman | 69 | else |
| 170 : | jhurliman | 63 | { |
| 171 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 172 : | jhurliman | 63 | } |
| 173 : | } | ||
| 174 : | jhurliman | 69 | catch (MySqlException ex) |
| 175 : | { | ||
| 176 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 177 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 178 : | jhurliman | 69 | } |
| 179 : | jhurliman | 63 | } |
| 180 : | |||
| 181 : | jhurliman | 69 | server.MetricsProvider.LogInventoryFetch(EXTENSION_NAME, ret, owner, folderID, true, DateTime.Now); |
| 182 : | jhurliman | 63 | return ret; |
| 183 : | } | ||
| 184 : | |||
| 185 : | jhurliman | 70 | public BackendResponse TryFetchFolderContents(Uri owner, UUID folderID, out InventoryCollection contents) |
| 186 : | jhurliman | 63 | { |
| 187 : | contents = null; | ||
| 188 : | jhurliman | 70 | BackendResponse ret; |
| 189 : | jhurliman | 63 | |
| 190 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 191 : | jhurliman | 63 | { |
| 192 : | jhurliman | 69 | IDataReader reader; |
| 193 : | |||
| 194 : | try | ||
| 195 : | jhurliman | 63 | { |
| 196 : | jhurliman | 69 | dbConnection.Open(); |
| 197 : | jhurliman | 63 | |
| 198 : | jhurliman | 69 | contents = new InventoryCollection(); |
| 199 : | jhurliman | 63 | |
| 200 : | jhurliman | 69 | #region Folder retrieval |
| 201 : | jhurliman | 63 | |
| 202 : | jhurliman | 69 | IDbCommand command = dbConnection.CreateCommand(); |
| 203 : | command.CommandText = String.Format("SELECT folderName,type,version,agentID,folderID FROM inventoryfolders WHERE parentFolderID='{0}'", | ||
| 204 : | folderID.ToString()); | ||
| 205 : | reader = command.ExecuteReader(); | ||
| 206 : | jhurliman | 63 | |
| 207 : | jhurliman | 69 | contents.Folders = new Dictionary<UUID, InventoryFolder>(); |
| 208 : | jhurliman | 63 | |
| 209 : | jhurliman | 69 | while (reader.Read()) |
| 210 : | { | ||
| 211 : | InventoryFolder folder = new InventoryFolder(); | ||
| 212 : | folder.ParentID = folderID; | ||
| 213 : | folder.Children = null; // This call doesn't do recursion | ||
| 214 : | folder.Name = reader.GetString(0); | ||
| 215 : | folder.Type = reader.GetInt16(1); | ||
| 216 : | folder.Version = (ushort)reader.GetInt16(2); | ||
| 217 : | folder.Owner = UUID.Parse(reader.GetString(3)); | ||
| 218 : | folder.ID = UUID.Parse(reader.GetString(4)); | ||
| 219 : | jhurliman | 63 | |
| 220 : | jhurliman | 69 | contents.Folders.Add(folder.ID, folder); |
| 221 : | contents.UserID = folder.Owner; | ||
| 222 : | } | ||
| 223 : | jhurliman | 63 | |
| 224 : | jhurliman | 69 | reader.Close(); |
| 225 : | jhurliman | 63 | |
| 226 : | jhurliman | 69 | #endregion Folder retrieval |
| 227 : | jhurliman | 63 | |
| 228 : | jhurliman | 69 | #region Item retrieval |
| 229 : | jhurliman | 63 | |
| 230 : | jhurliman | 69 | command = dbConnection.CreateCommand(); |
| 231 : | command.CommandText = String.Format("SELECT assetID,assetType,inventoryName,inventoryDescription,inventoryNextPermissions," + | ||
| 232 : | "inventoryCurrentPermissions,invType,creatorID,inventoryBasePermissions,inventoryEveryOnePermissions,salePrice,saleType," + | ||
| 233 : | "creationDate,groupID,groupOwned,flags,avatarID,inventoryID,inventoryGroupPermissions FROM inventoryitems WHERE parentFolderID='{0}'", | ||
| 234 : | folderID.ToString()); | ||
| 235 : | reader = command.ExecuteReader(); | ||
| 236 : | jhurliman | 63 | |
| 237 : | jhurliman | 69 | contents.Items = new Dictionary<UUID, InventoryItem>(); |
| 238 : | jhurliman | 63 | |
| 239 : | jhurliman | 69 | while (reader.Read()) |
| 240 : | { | ||
| 241 : | InventoryItem item = new InventoryItem(); | ||
| 242 : | item.Folder = folderID; | ||
| 243 : | item.AssetID = UUID.Parse(reader.GetString(0)); | ||
| 244 : | item.AssetType = reader.GetInt32(1); | ||
| 245 : | item.Name = reader.GetString(2); | ||
| 246 : | item.Description = reader.GetString(3); | ||
| 247 : | item.NextPermissions = (uint)reader.GetInt32(4); | ||
| 248 : | item.CurrentPermissions = (uint)reader.GetInt32(5); | ||
| 249 : | item.InvType = reader.GetInt32(6); | ||
| 250 : | item.Creator = UUID.Parse(reader.GetString(7)); | ||
| 251 : | item.BasePermissions = (uint)reader.GetInt32(8); | ||
| 252 : | item.EveryOnePermissions = (uint)reader.GetInt32(9); | ||
| 253 : | item.SalePrice = reader.GetInt32(10); | ||
| 254 : | item.SaleType = reader.GetByte(11); | ||
| 255 : | item.CreationDate = reader.GetInt32(12); | ||
| 256 : | item.GroupID = UUID.Parse(reader.GetString(13)); | ||
| 257 : | item.GroupOwned = reader.GetBoolean(14); | ||
| 258 : | item.Flags = (uint)reader.GetInt32(15); | ||
| 259 : | item.Owner = UUID.Parse(reader.GetString(16)); | ||
| 260 : | item.ID = UUID.Parse(reader.GetString(17)); | ||
| 261 : | item.GroupPermissions = (uint)reader.GetInt32(18); | ||
| 262 : | jhurliman | 63 | |
| 263 : | jhurliman | 69 | contents.Items.Add(item.ID, item); |
| 264 : | contents.UserID = item.Owner; | ||
| 265 : | } | ||
| 266 : | jhurliman | 63 | |
| 267 : | jhurliman | 69 | #endregion Item retrieval |
| 268 : | jhurliman | 63 | |
| 269 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 270 : | jhurliman | 63 | } |
| 271 : | jhurliman | 69 | catch (MySqlException ex) |
| 272 : | { | ||
| 273 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 274 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 275 : | jhurliman | 69 | } |
| 276 : | jhurliman | 63 | } |
| 277 : | |||
| 278 : | jhurliman | 69 | server.MetricsProvider.LogInventoryFetchFolderContents(EXTENSION_NAME, ret, owner, folderID, DateTime.Now); |
| 279 : | jhurliman | 63 | return ret; |
| 280 : | } | ||
| 281 : | |||
| 282 : | jhurliman | 70 | public BackendResponse TryFetchFolderList(Uri owner, out List<InventoryFolder> folders) |
| 283 : | jhurliman | 63 | { |
| 284 : | folders = null; | ||
| 285 : | jhurliman | 70 | BackendResponse ret; |
| 286 : | jhurliman | 63 | UUID ownerID; |
| 287 : | |||
| 288 : | jhurliman | 69 | if (Utils.TryGetOpenSimUUID(owner, out ownerID)) |
| 289 : | jhurliman | 63 | { |
| 290 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 291 : | jhurliman | 63 | { |
| 292 : | jhurliman | 69 | IDataReader reader; |
| 293 : | |||
| 294 : | try | ||
| 295 : | jhurliman | 63 | { |
| 296 : | jhurliman | 69 | dbConnection.Open(); |
| 297 : | folders = new List<InventoryFolder>(); | ||
| 298 : | jhurliman | 63 | |
| 299 : | jhurliman | 69 | IDbCommand command = dbConnection.CreateCommand(); |
| 300 : | command.CommandText = String.Format("SELECT folderName,type,version,folderID,parentFolderID FROM inventoryfolders WHERE agentID='{0}'", | ||
| 301 : | ownerID.ToString()); | ||
| 302 : | reader = command.ExecuteReader(); | ||
| 303 : | |||
| 304 : | while (reader.Read()) | ||
| 305 : | jhurliman | 63 | { |
| 306 : | jhurliman | 69 | InventoryFolder folder = new InventoryFolder(); |
| 307 : | folder.Owner = ownerID; | ||
| 308 : | folder.Children = null; // This call does not create a folder hierarchy | ||
| 309 : | folder.Name = reader.GetString(0); | ||
| 310 : | folder.Type = reader.GetInt16(1); | ||
| 311 : | folder.Version = (ushort)reader.GetInt16(2); | ||
| 312 : | folder.ID = UUID.Parse(reader.GetString(3)); | ||
| 313 : | folder.ParentID = UUID.Parse(reader.GetString(4)); | ||
| 314 : | jhurliman | 63 | |
| 315 : | jhurliman | 69 | folders.Add(folder); |
| 316 : | jhurliman | 63 | } |
| 317 : | jhurliman | 69 | |
| 318 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 319 : | jhurliman | 63 | } |
| 320 : | jhurliman | 69 | catch (MySqlException ex) |
| 321 : | { | ||
| 322 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 323 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 324 : | jhurliman | 69 | } |
| 325 : | jhurliman | 63 | } |
| 326 : | } | ||
| 327 : | else | ||
| 328 : | { | ||
| 329 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 330 : | jhurliman | 63 | } |
| 331 : | |||
| 332 : | jhurliman | 69 | server.MetricsProvider.LogInventoryFetchFolderList(EXTENSION_NAME, ret, owner, DateTime.Now); |
| 333 : | jhurliman | 63 | return ret; |
| 334 : | } | ||
| 335 : | |||
| 336 : | jhurliman | 70 | public BackendResponse TryFetchInventory(Uri owner, out InventoryCollection inventory) |
| 337 : | jhurliman | 63 | { |
| 338 : | inventory = null; | ||
| 339 : | jhurliman | 70 | BackendResponse ret; |
| 340 : | jhurliman | 63 | List<InventoryFolder> folders; |
| 341 : | UUID ownerID; | ||
| 342 : | |||
| 343 : | jhurliman | 69 | ret = TryFetchFolderList(owner, out folders); |
| 344 : | jhurliman | 63 | |
| 345 : | jhurliman | 70 | if (ret == BackendResponse.Success) |
| 346 : | jhurliman | 63 | { |
| 347 : | // Add the retrieved folders to the inventory collection | ||
| 348 : | inventory = new InventoryCollection(); | ||
| 349 : | inventory.Folders = new Dictionary<UUID, InventoryFolder>(folders.Count); | ||
| 350 : | foreach (InventoryFolder folder in folders) | ||
| 351 : | inventory.Folders[folder.ID] = folder; | ||
| 352 : | |||
| 353 : | // Fetch inventory items | ||
| 354 : | jhurliman | 66 | if (Utils.TryGetOpenSimUUID(owner, out ownerID)) |
| 355 : | jhurliman | 63 | { |
| 356 : | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) | ||
| 357 : | { | ||
| 358 : | IDataReader reader; | ||
| 359 : | |||
| 360 : | try | ||
| 361 : | { | ||
| 362 : | dbConnection.Open(); | ||
| 363 : | |||
| 364 : | IDbCommand command = dbConnection.CreateCommand(); | ||
| 365 : | command.CommandText = String.Format("SELECT assetID,assetType,inventoryName,inventoryDescription,inventoryNextPermissions," + | ||
| 366 : | "inventoryCurrentPermissions,invType,creatorID,inventoryBasePermissions,inventoryEveryOnePermissions,salePrice,saleType," + | ||
| 367 : | "creationDate,groupID,groupOwned,flags,inventoryID,parentFolderID,inventoryGroupPermissions FROM inventoryitems WHERE " + | ||
| 368 : | "avatarID='{0}'", ownerID.ToString()); | ||
| 369 : | reader = command.ExecuteReader(); | ||
| 370 : | |||
| 371 : | inventory.UserID = ownerID; | ||
| 372 : | inventory.Items = new Dictionary<UUID, InventoryItem>(); | ||
| 373 : | |||
| 374 : | while (reader.Read()) | ||
| 375 : | { | ||
| 376 : | InventoryItem item = new InventoryItem(); | ||
| 377 : | item.Owner = ownerID; | ||
| 378 : | item.AssetID = UUID.Parse(reader.GetString(0)); | ||
| 379 : | item.AssetType = reader.GetInt32(1); | ||
| 380 : | item.Name = reader.GetString(2); | ||
| 381 : | item.Description = reader.GetString(3); | ||
| 382 : | item.NextPermissions = (uint)reader.GetInt32(4); | ||
| 383 : | item.CurrentPermissions = (uint)reader.GetInt32(5); | ||
| 384 : | item.InvType = reader.GetInt32(6); | ||
| 385 : | item.Creator = UUID.Parse(reader.GetString(7)); | ||
| 386 : | item.BasePermissions = (uint)reader.GetInt32(8); | ||
| 387 : | item.EveryOnePermissions = (uint)reader.GetInt32(9); | ||
| 388 : | item.SalePrice = reader.GetInt32(10); | ||
| 389 : | item.SaleType = reader.GetByte(11); | ||
| 390 : | item.CreationDate = reader.GetInt32(12); | ||
| 391 : | item.GroupID = UUID.Parse(reader.GetString(13)); | ||
| 392 : | item.GroupOwned = reader.GetBoolean(14); | ||
| 393 : | item.Flags = (uint)reader.GetInt32(15); | ||
| 394 : | item.ID = UUID.Parse(reader.GetString(16)); | ||
| 395 : | item.Folder = UUID.Parse(reader.GetString(17)); | ||
| 396 : | item.GroupPermissions = (uint)reader.GetInt32(18); | ||
| 397 : | |||
| 398 : | inventory.Items.Add(item.ID, item); | ||
| 399 : | } | ||
| 400 : | |||
| 401 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 402 : | jhurliman | 63 | } |
| 403 : | catch (MySqlException ex) | ||
| 404 : | { | ||
| 405 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 406 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 407 : | jhurliman | 63 | } |
| 408 : | } | ||
| 409 : | } | ||
| 410 : | else | ||
| 411 : | { | ||
| 412 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 413 : | jhurliman | 63 | } |
| 414 : | } | ||
| 415 : | |||
| 416 : | jhurliman | 69 | server.MetricsProvider.LogInventoryFetchInventory(EXTENSION_NAME, ret, owner, DateTime.Now); |
| 417 : | jhurliman | 63 | return ret; |
| 418 : | } | ||
| 419 : | |||
| 420 : | jhurliman | 70 | public BackendResponse TryFetchActiveGestures(Uri owner, out List<InventoryItem> gestures) |
| 421 : | jhurliman | 63 | { |
| 422 : | gestures = null; | ||
| 423 : | jhurliman | 70 | BackendResponse ret; |
| 424 : | jhurliman | 63 | UUID ownerID; |
| 425 : | |||
| 426 : | jhurliman | 69 | if (Utils.TryGetOpenSimUUID(owner, out ownerID)) |
| 427 : | jhurliman | 63 | { |
| 428 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 429 : | jhurliman | 63 | { |
| 430 : | jhurliman | 69 | IDataReader reader; |
| 431 : | |||
| 432 : | try | ||
| 433 : | jhurliman | 63 | { |
| 434 : | jhurliman | 69 | dbConnection.Open(); |
| 435 : | jhurliman | 63 | |
| 436 : | jhurliman | 69 | MySqlCommand command = new MySqlCommand("SELECT assetID,inventoryName,inventoryDescription,inventoryNextPermissions," + |
| 437 : | "inventoryCurrentPermissions,invType,creatorID,inventoryBasePermissions,inventoryEveryOnePermissions,salePrice,saleType," + | ||
| 438 : | "creationDate,groupID,groupOwned,inventoryID,parentFolderID,inventoryGroupPermissions FROM inventoryitems WHERE " + | ||
| 439 : | "avatarId=?uuid AND assetType=?type AND flags=1", dbConnection); | ||
| 440 : | command.Parameters.AddWithValue("?uuid", ownerID.ToString()); | ||
| 441 : | command.Parameters.AddWithValue("?type", (int)AssetType.Gesture); | ||
| 442 : | reader = command.ExecuteReader(); | ||
| 443 : | |||
| 444 : | while (reader.Read()) | ||
| 445 : | jhurliman | 63 | { |
| 446 : | jhurliman | 69 | InventoryItem item = new InventoryItem(); |
| 447 : | item.Owner = ownerID; | ||
| 448 : | item.AssetType = (int)AssetType.Gesture; | ||
| 449 : | item.Flags = (uint)1; | ||
| 450 : | item.AssetID = UUID.Parse(reader.GetString(0)); | ||
| 451 : | item.Name = reader.GetString(1); | ||
| 452 : | item.Description = reader.GetString(2); | ||
| 453 : | item.NextPermissions = (uint)reader.GetInt32(3); | ||
| 454 : | item.CurrentPermissions = (uint)reader.GetInt32(4); | ||
| 455 : | item.InvType = reader.GetInt32(5); | ||
| 456 : | item.Creator = UUID.Parse(reader.GetString(6)); | ||
| 457 : | item.BasePermissions = (uint)reader.GetInt32(7); | ||
| 458 : | item.EveryOnePermissions = (uint)reader.GetInt32(8); | ||
| 459 : | item.SalePrice = reader.GetInt32(9); | ||
| 460 : | item.SaleType = reader.GetByte(10); | ||
| 461 : | item.CreationDate = reader.GetInt32(11); | ||
| 462 : | item.GroupID = UUID.Parse(reader.GetString(12)); | ||
| 463 : | item.GroupOwned = reader.GetBoolean(13); | ||
| 464 : | item.ID = UUID.Parse(reader.GetString(14)); | ||
| 465 : | item.Folder = UUID.Parse(reader.GetString(15)); | ||
| 466 : | item.GroupPermissions = (uint)reader.GetInt32(16); | ||
| 467 : | jhurliman | 63 | |
| 468 : | jhurliman | 69 | gestures.Add(item); |
| 469 : | jhurliman | 63 | } |
| 470 : | jhurliman | 69 | |
| 471 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 472 : | jhurliman | 63 | } |
| 473 : | jhurliman | 69 | catch (MySqlException ex) |
| 474 : | { | ||
| 475 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 476 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 477 : | jhurliman | 69 | } |
| 478 : | jhurliman | 63 | } |
| 479 : | } | ||
| 480 : | else | ||
| 481 : | { | ||
| 482 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 483 : | jhurliman | 63 | } |
| 484 : | |||
| 485 : | jhurliman | 69 | server.MetricsProvider.LogInventoryFetchActiveGestures(EXTENSION_NAME, ret, owner, DateTime.Now); |
| 486 : | jhurliman | 63 | return ret; |
| 487 : | } | ||
| 488 : | |||
| 489 : | jhurliman | 70 | public BackendResponse TryCreateItem(Uri owner, InventoryItem item) |
| 490 : | jhurliman | 63 | { |
| 491 : | jhurliman | 70 | BackendResponse ret; |
| 492 : | jhurliman | 63 | |
| 493 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 494 : | jhurliman | 63 | { |
| 495 : | jhurliman | 69 | try |
| 496 : | jhurliman | 63 | { |
| 497 : | jhurliman | 69 | dbConnection.Open(); |
| 498 : | jhurliman | 63 | |
| 499 : | jhurliman | 69 | MySqlCommand command = new MySqlCommand( |
| 500 : | "REPLACE INTO inventoryitems (assetID,assetType,inventoryName,inventoryDescription,inventoryNextPermissions," + | ||
| 501 : | "inventoryCurrentPermissions,invType,creatorID,inventoryBasePermissions,inventoryEveryOnePermissions,salePrice,saleType," + | ||
| 502 : | "creationDate,groupID,groupOwned,flags,inventoryID,avatarID,parentFolderID,inventoryGroupPermissions) VALUES " + | ||
| 503 : | jhurliman | 63 | |
| 504 : | jhurliman | 69 | "(?assetID,?assetType,?inventoryName,?inventoryDescription,?inventoryNextPermissions,?inventoryCurrentPermissions,?invType," + |
| 505 : | "?creatorID,?inventoryBasePermissions,?inventoryEveryOnePermissions,?salePrice,?saleType,?creationDate,?groupID,?groupOwned," + | ||
| 506 : | "?flags,?inventoryID,?avatarID,?parentFolderID,?inventoryGroupPermissions)", dbConnection); | ||
| 507 : | jhurliman | 63 | |
| 508 : | jhurliman | 69 | command.Parameters.AddWithValue("?assetID", item.AssetID.ToString()); |
| 509 : | command.Parameters.AddWithValue("?assetType", item.AssetType); | ||
| 510 : | command.Parameters.AddWithValue("?inventoryName", item.Name); | ||
| 511 : | command.Parameters.AddWithValue("?inventoryDescription", item.Description); | ||
| 512 : | command.Parameters.AddWithValue("?inventoryNextPermissions", item.NextPermissions); | ||
| 513 : | command.Parameters.AddWithValue("?inventoryCurrentPermissions", item.CurrentPermissions); | ||
| 514 : | command.Parameters.AddWithValue("?invType", item.InvType); | ||
| 515 : | command.Parameters.AddWithValue("?creatorID", item.Creator.ToString()); | ||
| 516 : | command.Parameters.AddWithValue("?inventoryBasePermissions", item.BasePermissions); | ||
| 517 : | command.Parameters.AddWithValue("?inventoryEveryOnePermissions", item.EveryOnePermissions); | ||
| 518 : | command.Parameters.AddWithValue("?salePrice", item.SalePrice); | ||
| 519 : | command.Parameters.AddWithValue("?saleType", item.SaleType); | ||
| 520 : | command.Parameters.AddWithValue("?creationDate", item.CreationDate); | ||
| 521 : | command.Parameters.AddWithValue("?groupID", item.GroupID.ToString()); | ||
| 522 : | command.Parameters.AddWithValue("?groupOwned", item.GroupOwned); | ||
| 523 : | command.Parameters.AddWithValue("?flags", item.Flags); | ||
| 524 : | command.Parameters.AddWithValue("?inventoryID", item.ID); | ||
| 525 : | command.Parameters.AddWithValue("?avatarID", item.Owner); | ||
| 526 : | command.Parameters.AddWithValue("?parentFolderID", item.Folder); | ||
| 527 : | command.Parameters.AddWithValue("?inventoryGroupPermissions", item.GroupPermissions); | ||
| 528 : | jhurliman | 66 | |
| 529 : | jhurliman | 69 | int rowsAffected = command.ExecuteNonQuery(); |
| 530 : | if (rowsAffected == 1) | ||
| 531 : | { | ||
| 532 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 533 : | jhurliman | 63 | } |
| 534 : | jhurliman | 69 | else if (rowsAffected == 2) |
| 535 : | jhurliman | 66 | { |
| 536 : | jhurliman | 69 | Logger.Log.Info("Replaced inventory item " + item.ID.ToString()); |
| 537 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 538 : | jhurliman | 69 | } |
| 539 : | else | ||
| 540 : | { | ||
| 541 : | Logger.Log.ErrorFormat("MySQL REPLACE query affected {0} rows", rowsAffected); | ||
| 542 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 543 : | jhurliman | 66 | } |
| 544 : | jhurliman | 63 | } |
| 545 : | jhurliman | 69 | catch (MySqlException ex) |
| 546 : | { | ||
| 547 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 548 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 549 : | jhurliman | 69 | } |
| 550 : | jhurliman | 63 | } |
| 551 : | |||
| 552 : | jhurliman | 69 | server.MetricsProvider.LogInventoryCreate(EXTENSION_NAME, ret, owner, false, DateTime.Now); |
| 553 : | jhurliman | 63 | return ret; |
| 554 : | } | ||
| 555 : | |||
| 556 : | jhurliman | 70 | public BackendResponse TryCreateFolder(Uri owner, InventoryFolder folder) |
| 557 : | jhurliman | 63 | { |
| 558 : | jhurliman | 70 | BackendResponse ret; |
| 559 : | jhurliman | 63 | |
| 560 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 561 : | jhurliman | 63 | { |
| 562 : | jhurliman | 69 | try |
| 563 : | jhurliman | 63 | { |
| 564 : | jhurliman | 69 | dbConnection.Open(); |
| 565 : | jhurliman | 63 | |
| 566 : | jhurliman | 69 | MySqlCommand command = new MySqlCommand( |
| 567 : | "REPLACE INTO inventoryfolders (folderName,type,version,folderID,agentID,parentFolderID) VALUES " + | ||
| 568 : | "(?folderName,?type,?version,?folderID,?agentID,?parentFolderID)", dbConnection); | ||
| 569 : | jhurliman | 63 | |
| 570 : | jhurliman | 69 | command.Parameters.AddWithValue("?folderName", folder.Name); |
| 571 : | command.Parameters.AddWithValue("?type", folder.Type); | ||
| 572 : | command.Parameters.AddWithValue("?version", folder.Version); | ||
| 573 : | command.Parameters.AddWithValue("?folderID", folder.ID); | ||
| 574 : | command.Parameters.AddWithValue("?agentID", folder.Owner); | ||
| 575 : | command.Parameters.AddWithValue("?parentFolderID", folder.ParentID); | ||
| 576 : | jhurliman | 63 | |
| 577 : | jhurliman | 69 | int rowsAffected = command.ExecuteNonQuery(); |
| 578 : | if (rowsAffected == 1) | ||
| 579 : | { | ||
| 580 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 581 : | jhurliman | 63 | } |
| 582 : | jhurliman | 69 | else if (rowsAffected == 2) |
| 583 : | jhurliman | 66 | { |
| 584 : | jhurliman | 69 | Logger.Log.Info("Replaced inventory folder " + folder.ID.ToString()); |
| 585 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 586 : | jhurliman | 69 | } |
| 587 : | else | ||
| 588 : | { | ||
| 589 : | Logger.Log.ErrorFormat("MySQL REPLACE query affected {0} rows", rowsAffected); | ||
| 590 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 591 : | jhurliman | 66 | } |
| 592 : | jhurliman | 63 | } |
| 593 : | jhurliman | 69 | catch (MySqlException ex) |
| 594 : | { | ||
| 595 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 596 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 597 : | jhurliman | 69 | } |
| 598 : | jhurliman | 63 | } |
| 599 : | |||
| 600 : | jhurliman | 69 | server.MetricsProvider.LogInventoryCreate(EXTENSION_NAME, ret, owner, true, DateTime.Now); |
| 601 : | jhurliman | 63 | return ret; |
| 602 : | } | ||
| 603 : | |||
| 604 : | jhurliman | 70 | public BackendResponse TryCreateInventory(Uri owner, InventoryFolder rootFolder) |
| 605 : | jhurliman | 63 | { |
| 606 : | jhurliman | 69 | return TryCreateFolder(owner, rootFolder); |
| 607 : | jhurliman | 63 | } |
| 608 : | |||
| 609 : | jhurliman | 70 | public BackendResponse TryDeleteItem(Uri owner, UUID itemID) |
| 610 : | jhurliman | 63 | { |
| 611 : | jhurliman | 70 | BackendResponse ret; |
| 612 : | jhurliman | 63 | UUID ownerID; |
| 613 : | |||
| 614 : | jhurliman | 66 | if (Utils.TryGetOpenSimUUID(owner, out ownerID)) |
| 615 : | jhurliman | 63 | { |
| 616 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 617 : | jhurliman | 63 | { |
| 618 : | jhurliman | 69 | try |
| 619 : | jhurliman | 63 | { |
| 620 : | jhurliman | 69 | dbConnection.Open(); |
| 621 : | jhurliman | 63 | |
| 622 : | jhurliman | 69 | MySqlCommand command = new MySqlCommand( |
| 623 : | "DELETE FROM inventoryitems WHERE inventoryID=?inventoryID AND avatarID=?avatarID", dbConnection); | ||
| 624 : | jhurliman | 63 | |
| 625 : | jhurliman | 69 | command.Parameters.AddWithValue("?inventoryID", itemID.ToString()); |
| 626 : | command.Parameters.AddWithValue("?avatarID", ownerID.ToString()); | ||
| 627 : | jhurliman | 63 | |
| 628 : | jhurliman | 69 | int rowsAffected = command.ExecuteNonQuery(); |
| 629 : | if (rowsAffected == 1) | ||
| 630 : | { | ||
| 631 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 632 : | jhurliman | 63 | } |
| 633 : | jhurliman | 69 | else |
| 634 : | jhurliman | 63 | { |
| 635 : | jhurliman | 69 | Logger.Log.ErrorFormat("MySQL DELETE query affected {0} rows", rowsAffected); |
| 636 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 637 : | jhurliman | 63 | } |
| 638 : | } | ||
| 639 : | jhurliman | 69 | catch (MySqlException ex) |
| 640 : | { | ||
| 641 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 642 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 643 : | jhurliman | 69 | } |
| 644 : | jhurliman | 63 | } |
| 645 : | } | ||
| 646 : | else | ||
| 647 : | { | ||
| 648 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 649 : | jhurliman | 63 | } |
| 650 : | |||
| 651 : | jhurliman | 69 | server.MetricsProvider.LogInventoryDelete(EXTENSION_NAME, ret, owner, itemID, false, DateTime.Now); |
| 652 : | jhurliman | 63 | return ret; |
| 653 : | } | ||
| 654 : | |||
| 655 : | jhurliman | 70 | public BackendResponse TryDeleteFolder(Uri owner, UUID folderID) |
| 656 : | jhurliman | 63 | { |
| 657 : | jhurliman | 70 | BackendResponse ret; |
| 658 : | jhurliman | 63 | UUID ownerID; |
| 659 : | |||
| 660 : | jhurliman | 66 | if (Utils.TryGetOpenSimUUID(owner, out ownerID)) |
| 661 : | jhurliman | 63 | { |
| 662 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 663 : | jhurliman | 63 | { |
| 664 : | jhurliman | 69 | try |
| 665 : | jhurliman | 63 | { |
| 666 : | jhurliman | 69 | dbConnection.Open(); |
| 667 : | jhurliman | 63 | |
| 668 : | jhurliman | 69 | MySqlCommand command = new MySqlCommand( |
| 669 : | "DELETE FROM inventoryfolders WHERE folderID=?folderID AND agentID=?agentID", dbConnection); | ||
| 670 : | jhurliman | 63 | |
| 671 : | jhurliman | 69 | command.Parameters.AddWithValue("?folderID", folderID.ToString()); |
| 672 : | command.Parameters.AddWithValue("?agentID", ownerID.ToString()); | ||
| 673 : | jhurliman | 63 | |
| 674 : | jhurliman | 69 | int rowsAffected = command.ExecuteNonQuery(); |
| 675 : | if (rowsAffected == 1) | ||
| 676 : | { | ||
| 677 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 678 : | jhurliman | 63 | } |
| 679 : | jhurliman | 69 | else |
| 680 : | jhurliman | 63 | { |
| 681 : | jhurliman | 69 | Logger.Log.ErrorFormat("MySQL DELETE query affected {0} rows", rowsAffected); |
| 682 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 683 : | jhurliman | 63 | } |
| 684 : | } | ||
| 685 : | jhurliman | 69 | catch (MySqlException ex) |
| 686 : | { | ||
| 687 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 688 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 689 : | jhurliman | 69 | } |
| 690 : | jhurliman | 63 | } |
| 691 : | } | ||
| 692 : | else | ||
| 693 : | { | ||
| 694 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 695 : | jhurliman | 63 | } |
| 696 : | |||
| 697 : | jhurliman | 69 | server.MetricsProvider.LogInventoryDelete(EXTENSION_NAME, ret, owner, folderID, true, DateTime.Now); |
| 698 : | jhurliman | 63 | return ret; |
| 699 : | } | ||
| 700 : | |||
| 701 : | jhurliman | 70 | public BackendResponse TryPurgeFolder(Uri owner, UUID folderID) |
| 702 : | jhurliman | 63 | { |
| 703 : | jhurliman | 70 | BackendResponse ret; |
| 704 : | jhurliman | 63 | UUID ownerID; |
| 705 : | |||
| 706 : | jhurliman | 66 | if (Utils.TryGetOpenSimUUID(owner, out ownerID)) |
| 707 : | jhurliman | 63 | { |
| 708 : | jhurliman | 69 | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) |
| 709 : | jhurliman | 63 | { |
| 710 : | jhurliman | 69 | try |
| 711 : | jhurliman | 63 | { |
| 712 : | jhurliman | 69 | dbConnection.Open(); |
| 713 : | jhurliman | 63 | |
| 714 : | jhurliman | 69 | #region Delete items |
| 715 : | jhurliman | 63 | |
| 716 : | jhurliman | 69 | MySqlCommand command = new MySqlCommand( |
| 717 : | "DELETE FROM inventoryitems WHERE parentFolderID=?parentFolderID AND avatarID=?avatarID", dbConnection); | ||
| 718 : | jhurliman | 63 | |
| 719 : | jhurliman | 69 | command.Parameters.AddWithValue("?parentFolderID", folderID.ToString()); |
| 720 : | command.Parameters.AddWithValue("?avatarID", ownerID.ToString()); | ||
| 721 : | jhurliman | 63 | |
| 722 : | jhurliman | 69 | int rowsAffected = command.ExecuteNonQuery(); |
| 723 : | jhurliman | 63 | |
| 724 : | jhurliman | 69 | #endregion Delete items |
| 725 : | jhurliman | 63 | |
| 726 : | jhurliman | 69 | #region Delete folders |
| 727 : | jhurliman | 63 | |
| 728 : | jhurliman | 69 | command = new MySqlCommand( |
| 729 : | "DELETE FROM inventoryfolders WHERE parentFolderID=?parentFolderID AND agentID=?agentID", dbConnection); | ||
| 730 : | jhurliman | 63 | |
| 731 : | jhurliman | 69 | command.Parameters.AddWithValue("?parentFolderID", folderID.ToString()); |
| 732 : | command.Parameters.AddWithValue("?agentID", ownerID.ToString()); | ||
| 733 : | jhurliman | 63 | |
| 734 : | jhurliman | 69 | rowsAffected += command.ExecuteNonQuery(); |
| 735 : | jhurliman | 63 | |
| 736 : | jhurliman | 69 | #endregion Delete folders |
| 737 : | jhurliman | 63 | |
| 738 : | jhurliman | 69 | Logger.Log.DebugFormat("Deleted {0} inventory objects from MySQL in a folder purge", rowsAffected); |
| 739 : | jhurliman | 63 | |
| 740 : | jhurliman | 70 | ret = BackendResponse.Success; |
| 741 : | jhurliman | 63 | } |
| 742 : | jhurliman | 69 | catch (MySqlException ex) |
| 743 : | { | ||
| 744 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 745 : | jhurliman | 70 | ret = BackendResponse.Failure; |
| 746 : | jhurliman | 69 | } |
| 747 : | jhurliman | 63 | } |
| 748 : | } | ||
| 749 : | else | ||
| 750 : | { | ||
| 751 : | jhurliman | 70 | ret = BackendResponse.NotFound; |
| 752 : | jhurliman | 63 | } |
| 753 : | |||
| 754 : | jhurliman | 69 | server.MetricsProvider.LogInventoryPurgeFolder(EXTENSION_NAME, ret, owner, folderID, DateTime.Now); |
| 755 : | jhurliman | 63 | return ret; |
| 756 : | } | ||
| 757 : | |||
| 758 : | jhurliman | 69 | public int ForEach(Action<Metadata> action, int start, int count) |
| 759 : | jhurliman | 63 | { |
| 760 : | int rowCount = 0; | ||
| 761 : | |||
| 762 : | using (MySqlConnection dbConnection = new MySqlConnection(DBConnString.GetConnectionString(server.ConfigFile))) | ||
| 763 : | { | ||
| 764 : | MySqlDataReader reader; | ||
| 765 : | |||
| 766 : | try | ||
| 767 : | { | ||
| 768 : | dbConnection.Open(); | ||
| 769 : | |||
| 770 : | MySqlCommand command = dbConnection.CreateCommand(); | ||
| 771 : | command.CommandText = String.Format("SELECT name,description,assetType,temporary,data,id FROM assets LIMIT {0}, {1}", | ||
| 772 : | start, count); | ||
| 773 : | reader = command.ExecuteReader(); | ||
| 774 : | } | ||
| 775 : | catch (MySqlException ex) | ||
| 776 : | { | ||
| 777 : | Logger.Log.Error("Connection to MySQL backend failed: " + ex.Message); | ||
| 778 : | return 0; | ||
| 779 : | } | ||
| 780 : | |||
| 781 : | while (reader.Read()) | ||
| 782 : | { | ||
| 783 : | Metadata metadata = new Metadata(); | ||
| 784 : | metadata.CreationDate = OpenMetaverse.Utils.Epoch; | ||
| 785 : | metadata.Description = reader.GetString(1); | ||
| 786 : | metadata.ID = UUID.Parse(reader.GetString(5)); | ||
| 787 : | metadata.Name = reader.GetString(0); | ||
| 788 : | metadata.SHA1 = OpenMetaverse.Utils.SHA1((byte[])reader.GetValue(4)); | ||
| 789 : | metadata.Temporary = reader.GetBoolean(3); | ||
| 790 : | metadata.ContentType = Utils.SLAssetTypeToContentType(reader.GetInt32(2)); | ||
| 791 : | |||
| 792 : | jhurliman | 69 | action(metadata); |
| 793 : | ++rowCount; | ||
| 794 : | jhurliman | 63 | } |
| 795 : | |||
| 796 : | reader.Close(); | ||
| 797 : | } | ||
| 798 : | |||
| 799 : | return rowCount; | ||
| 800 : | } | ||
| 801 : | |||
| 802 : | #endregion Required Interfaces | ||
| 803 : | } | ||
| 804 : | } |
| ViewVC Help | |
| Powered by ViewVC 1.0.0 |
