From a0305888bcc7cd2e97f14c5e7893d151a5b9de7b Mon Sep 17 00:00:00 2001 From: Adam Frisby Date: Thu, 31 May 2007 14:05:19 +0000 Subject: * Yet more inventory shelling * Very initial MySQL work done * Refactored some of the MySQL code - functions which are passed a reader are no longer getX() but now readX(). --- .../OpenGrid.Framework.Data.MySQL/MySQLGridData.cs | 6 ++-- .../MySQLInventoryData.cs | 30 ++++++++++++++++++-- .../OpenGrid.Framework.Data.MySQL/MySQLManager.cs | 32 ++++++++++++++++++++-- .../OpenGrid.Framework.Data.MySQL/MySQLUserData.cs | 6 ++-- 4 files changed, 63 insertions(+), 11 deletions(-) (limited to 'OpenGridServices/OpenGrid.Framework.Data.MySQL') diff --git a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs index 5006aaf..e047c6d 100644 --- a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs +++ b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs @@ -62,7 +62,7 @@ namespace OpenGrid.Framework.Data.MySQL List rows = new List(); - while ((row = database.getSimRow(reader)) != null) + while ((row = database.readSimRow(reader)) != null) { rows.Add(row); } @@ -98,7 +98,7 @@ namespace OpenGrid.Framework.Data.MySQL System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE regionHandle = ?handle", param); System.Data.IDataReader reader = result.ExecuteReader(); - SimProfileData row = database.getSimRow(reader); + SimProfileData row = database.readSimRow(reader); reader.Close(); result.Dispose(); @@ -130,7 +130,7 @@ namespace OpenGrid.Framework.Data.MySQL System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE uuid = ?uuid", param); System.Data.IDataReader reader = result.ExecuteReader(); - SimProfileData row = database.getSimRow(reader); + SimProfileData row = database.readSimRow(reader); reader.Close(); result.Dispose(); diff --git a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLInventoryData.cs b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLInventoryData.cs index 8950458..72c0139 100644 --- a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLInventoryData.cs +++ b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLInventoryData.cs @@ -1,10 +1,11 @@ using System; using System.Collections.Generic; using System.Text; +using libsecondlife; namespace OpenGrid.Framework.Data.MySQL { - class MySQLInventoryData + class MySQLInventoryData : IInventoryData { public MySQLManager database; @@ -23,7 +24,7 @@ namespace OpenGrid.Framework.Data.MySQL public string getName() { - return "MySQL Logdata Interface"; + return "MySQL Inventory Data Interface"; } public void Close() @@ -35,5 +36,30 @@ namespace OpenGrid.Framework.Data.MySQL { return "0.1"; } + + public List getInventoryInFolder(LLUUID folderID) + { + return null; + } + + public List getUserRootFolders(LLUUID user) + { + return null; + } + + public List getInventoryFolders(LLUUID parentID) + { + return null; + } + + public InventoryItemBase getInventoryItem(LLUUID item) + { + return null; + } + + public InventoryFolderBase getInventoryFolder(LLUUID folder) + { + return null; + } } } diff --git a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs index 2eaa158..ef2e02e 100644 --- a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs +++ b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLManager.cs @@ -137,7 +137,7 @@ namespace OpenGrid.Framework.Data.MySQL } } - public SimProfileData getSimRow(IDataReader reader) + public SimProfileData readSimRow(IDataReader reader) { SimProfileData retval = new SimProfileData(); @@ -199,7 +199,7 @@ namespace OpenGrid.Framework.Data.MySQL return retval; } - public UserAgentData getAgentRow(IDataReader reader) + public UserAgentData readAgentRow(IDataReader reader) { UserAgentData retval = new UserAgentData(); @@ -231,7 +231,7 @@ namespace OpenGrid.Framework.Data.MySQL return retval; } - public UserProfileData getUserRow(IDataReader reader) + public UserProfileData readUserRow(IDataReader reader) { UserProfileData retval = new UserProfileData(); @@ -277,6 +277,32 @@ namespace OpenGrid.Framework.Data.MySQL return retval; } + public List readInventoryInFolder(IDataReader reader) + { + List rows = new List(); + + while(reader.Read()) + { + try + { + InventoryFolderBase retval = new InventoryFolderBase(); + + retval.agentID = new libsecondlife.LLUUID((string)reader["agentID"]); + retval.parentID = new libsecondlife.LLUUID((string)reader["parentFolderID"]); + retval.folderID = new libsecondlife.LLUUID((string)reader["folderID"]); + retval.name = (string)reader["folderName"]; + + rows.Add(retval); + } + catch (Exception e) + { + Console.WriteLine(e.ToString()); + } + } + + return rows; + } + public bool insertLogRow(string serverDaemon, string target, string methodCall, string arguments, int priority, string logMessage) { string sql = "INSERT INTO logs (`target`, `server`, `method`, `arguments`, `priority`, `message`) VALUES "; diff --git a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLUserData.cs b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLUserData.cs index 6f3cad6..4a7276c 100644 --- a/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLUserData.cs +++ b/OpenGridServices/OpenGrid.Framework.Data.MySQL/MySQLUserData.cs @@ -41,7 +41,7 @@ namespace OpenGrid.Framework.Data.MySQL System.Data.IDbCommand result = database.Query("SELECT * FROM users WHERE username = ?first AND lastname = ?second", param); System.Data.IDataReader reader = result.ExecuteReader(); - UserProfileData row = database.getUserRow(reader); + UserProfileData row = database.readUserRow(reader); reader.Close(); result.Dispose(); @@ -69,7 +69,7 @@ namespace OpenGrid.Framework.Data.MySQL System.Data.IDbCommand result = database.Query("SELECT * FROM users WHERE UUID = ?uuid", param); System.Data.IDataReader reader = result.ExecuteReader(); - UserProfileData row = database.getUserRow(reader); + UserProfileData row = database.readUserRow(reader); reader.Close(); result.Dispose(); @@ -108,7 +108,7 @@ namespace OpenGrid.Framework.Data.MySQL System.Data.IDbCommand result = database.Query("SELECT * FROM agents WHERE UUID = ?uuid", param); System.Data.IDataReader reader = result.ExecuteReader(); - UserAgentData row = database.getAgentRow(reader); + UserAgentData row = database.readAgentRow(reader); reader.Close(); result.Dispose(); -- cgit v1.1