diff options
author | Adam Frisby | 2008-04-21 07:09:17 +0000 |
---|---|---|
committer | Adam Frisby | 2008-04-21 07:09:17 +0000 |
commit | fef3b3689492dea63693c964bcdbec9f5137eb5e (patch) | |
tree | 7791eef001d85d3e1de863a68f26ff9434d062ca /OpenSim/Data/SQLite | |
parent | * Terrain Module code has been reformatted to comply with guidelines. (diff) | |
download | opensim-SC_OLD-fef3b3689492dea63693c964bcdbec9f5137eb5e.zip opensim-SC_OLD-fef3b3689492dea63693c964bcdbec9f5137eb5e.tar.gz opensim-SC_OLD-fef3b3689492dea63693c964bcdbec9f5137eb5e.tar.bz2 opensim-SC_OLD-fef3b3689492dea63693c964bcdbec9f5137eb5e.tar.xz |
* Optimised using statements and namespace references across entire project (this took a while to run).
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteAssetData.cs | 4 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteInventoryStore.cs | 4 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteManager.cs | 6 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteRegionData.cs | 5 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteUserData.cs | 17 |
5 files changed, 19 insertions, 17 deletions
diff --git a/OpenSim/Data/SQLite/SQLiteAssetData.cs b/OpenSim/Data/SQLite/SQLiteAssetData.cs index 25a127b..2b63d2b 100644 --- a/OpenSim/Data/SQLite/SQLiteAssetData.cs +++ b/OpenSim/Data/SQLite/SQLiteAssetData.cs | |||
@@ -29,9 +29,9 @@ using System; | |||
29 | using System.Data; | 29 | using System.Data; |
30 | using System.Reflection; | 30 | using System.Reflection; |
31 | using libsecondlife; | 31 | using libsecondlife; |
32 | using log4net; | ||
32 | using Mono.Data.SqliteClient; | 33 | using Mono.Data.SqliteClient; |
33 | using OpenSim.Framework; | 34 | using OpenSim.Framework; |
34 | using OpenSim.Framework.Console; | ||
35 | 35 | ||
36 | namespace OpenSim.Data.SQLite | 36 | namespace OpenSim.Data.SQLite |
37 | { | 37 | { |
@@ -40,7 +40,7 @@ namespace OpenSim.Data.SQLite | |||
40 | /// </summary> | 40 | /// </summary> |
41 | public class SQLiteAssetData : AssetDataBase | 41 | public class SQLiteAssetData : AssetDataBase |
42 | { | 42 | { |
43 | private static readonly log4net.ILog m_log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | 43 | private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); |
44 | 44 | ||
45 | /// <summary> | 45 | /// <summary> |
46 | /// The database manager | 46 | /// The database manager |
diff --git a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs index 4ccea59..442ba39 100644 --- a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs +++ b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs | |||
@@ -30,15 +30,15 @@ using System.Collections.Generic; | |||
30 | using System.Data; | 30 | using System.Data; |
31 | using System.Reflection; | 31 | using System.Reflection; |
32 | using libsecondlife; | 32 | using libsecondlife; |
33 | using log4net; | ||
33 | using Mono.Data.SqliteClient; | 34 | using Mono.Data.SqliteClient; |
34 | using OpenSim.Framework; | 35 | using OpenSim.Framework; |
35 | using OpenSim.Framework.Console; | ||
36 | 36 | ||
37 | namespace OpenSim.Data.SQLite | 37 | namespace OpenSim.Data.SQLite |
38 | { | 38 | { |
39 | public class SQLiteInventoryStore : SQLiteUtil, IInventoryData | 39 | public class SQLiteInventoryStore : SQLiteUtil, IInventoryData |
40 | { | 40 | { |
41 | private static readonly log4net.ILog m_log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | 41 | private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); |
42 | 42 | ||
43 | private const string invItemsSelect = "select * from inventoryitems"; | 43 | private const string invItemsSelect = "select * from inventoryitems"; |
44 | private const string invFoldersSelect = "select * from inventoryfolders"; | 44 | private const string invFoldersSelect = "select * from inventoryfolders"; |
diff --git a/OpenSim/Data/SQLite/SQLiteManager.cs b/OpenSim/Data/SQLite/SQLiteManager.cs index c8ba2af..66ce6ab 100644 --- a/OpenSim/Data/SQLite/SQLiteManager.cs +++ b/OpenSim/Data/SQLite/SQLiteManager.cs | |||
@@ -29,15 +29,15 @@ using System; | |||
29 | using System.Collections.Generic; | 29 | using System.Collections.Generic; |
30 | using System.Data; | 30 | using System.Data; |
31 | using System.Data.SQLite; | 31 | using System.Data.SQLite; |
32 | using System.Reflection; | ||
32 | using libsecondlife; | 33 | using libsecondlife; |
33 | using Mono.Data.SqliteClient; | 34 | using log4net; |
34 | using OpenSim.Framework.Console; | ||
35 | 35 | ||
36 | namespace OpenSim.Data.SQLite | 36 | namespace OpenSim.Data.SQLite |
37 | { | 37 | { |
38 | internal class SQLiteManager : SQLiteUtil | 38 | internal class SQLiteManager : SQLiteUtil |
39 | { | 39 | { |
40 | private static readonly log4net.ILog m_log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | 40 | private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); |
41 | 41 | ||
42 | private IDbConnection dbcon; | 42 | private IDbConnection dbcon; |
43 | 43 | ||
diff --git a/OpenSim/Data/SQLite/SQLiteRegionData.cs b/OpenSim/Data/SQLite/SQLiteRegionData.cs index 85617e5..4355033 100644 --- a/OpenSim/Data/SQLite/SQLiteRegionData.cs +++ b/OpenSim/Data/SQLite/SQLiteRegionData.cs | |||
@@ -29,10 +29,11 @@ using System; | |||
29 | using System.Collections.Generic; | 29 | using System.Collections.Generic; |
30 | using System.Data; | 30 | using System.Data; |
31 | using System.IO; | 31 | using System.IO; |
32 | using System.Reflection; | ||
32 | using libsecondlife; | 33 | using libsecondlife; |
34 | using log4net; | ||
33 | using Mono.Data.SqliteClient; | 35 | using Mono.Data.SqliteClient; |
34 | using OpenSim.Framework; | 36 | using OpenSim.Framework; |
35 | using OpenSim.Framework.Console; | ||
36 | using OpenSim.Region.Environment.Interfaces; | 37 | using OpenSim.Region.Environment.Interfaces; |
37 | using OpenSim.Region.Environment.Scenes; | 38 | using OpenSim.Region.Environment.Scenes; |
38 | 39 | ||
@@ -40,7 +41,7 @@ namespace OpenSim.Data.SQLite | |||
40 | { | 41 | { |
41 | public class SQLiteRegionData : IRegionDataStore | 42 | public class SQLiteRegionData : IRegionDataStore |
42 | { | 43 | { |
43 | private static readonly log4net.ILog m_log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | 44 | private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); |
44 | 45 | ||
45 | private const string primSelect = "select * from prims"; | 46 | private const string primSelect = "select * from prims"; |
46 | private const string shapeSelect = "select * from primshapes"; | 47 | private const string shapeSelect = "select * from primshapes"; |
diff --git a/OpenSim/Data/SQLite/SQLiteUserData.cs b/OpenSim/Data/SQLite/SQLiteUserData.cs index 089c9df..97797e0 100644 --- a/OpenSim/Data/SQLite/SQLiteUserData.cs +++ b/OpenSim/Data/SQLite/SQLiteUserData.cs | |||
@@ -28,10 +28,11 @@ | |||
28 | using System; | 28 | using System; |
29 | using System.Collections.Generic; | 29 | using System.Collections.Generic; |
30 | using System.Data; | 30 | using System.Data; |
31 | using System.Reflection; | ||
31 | using libsecondlife; | 32 | using libsecondlife; |
33 | using log4net; | ||
32 | using Mono.Data.SqliteClient; | 34 | using Mono.Data.SqliteClient; |
33 | using OpenSim.Framework; | 35 | using OpenSim.Framework; |
34 | using OpenSim.Framework.Console; | ||
35 | 36 | ||
36 | namespace OpenSim.Data.SQLite | 37 | namespace OpenSim.Data.SQLite |
37 | { | 38 | { |
@@ -40,7 +41,7 @@ namespace OpenSim.Data.SQLite | |||
40 | /// </summary> | 41 | /// </summary> |
41 | public class SQLiteUserData : UserDataBase | 42 | public class SQLiteUserData : UserDataBase |
42 | { | 43 | { |
43 | private static readonly log4net.ILog m_log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | 44 | private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); |
44 | 45 | ||
45 | /// <summary> | 46 | /// <summary> |
46 | /// The database manager | 47 | /// The database manager |
@@ -238,9 +239,9 @@ namespace OpenSim.Data.SQLite | |||
238 | } | 239 | } |
239 | 240 | ||
240 | 241 | ||
241 | override public List<Framework.AvatarPickerAvatar> GeneratePickerResults(LLUUID queryID, string query) | 242 | override public List<AvatarPickerAvatar> GeneratePickerResults(LLUUID queryID, string query) |
242 | { | 243 | { |
243 | List<Framework.AvatarPickerAvatar> returnlist = new List<Framework.AvatarPickerAvatar>(); | 244 | List<AvatarPickerAvatar> returnlist = new List<AvatarPickerAvatar>(); |
244 | string[] querysplit; | 245 | string[] querysplit; |
245 | querysplit = query.Split(' '); | 246 | querysplit = query.Split(' '); |
246 | if (querysplit.Length == 2) | 247 | if (querysplit.Length == 2) |
@@ -254,7 +255,7 @@ namespace OpenSim.Data.SQLite | |||
254 | { | 255 | { |
255 | while (reader.Read()) | 256 | while (reader.Read()) |
256 | { | 257 | { |
257 | Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar(); | 258 | AvatarPickerAvatar user = new AvatarPickerAvatar(); |
258 | user.AvatarID = new LLUUID((string) reader["UUID"]); | 259 | user.AvatarID = new LLUUID((string) reader["UUID"]); |
259 | user.firstName = (string) reader["username"]; | 260 | user.firstName = (string) reader["username"]; |
260 | user.lastName = (string) reader["surname"]; | 261 | user.lastName = (string) reader["surname"]; |
@@ -275,7 +276,7 @@ namespace OpenSim.Data.SQLite | |||
275 | { | 276 | { |
276 | while (reader.Read()) | 277 | while (reader.Read()) |
277 | { | 278 | { |
278 | Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar(); | 279 | AvatarPickerAvatar user = new AvatarPickerAvatar(); |
279 | user.AvatarID = new LLUUID((string) reader["UUID"]); | 280 | user.AvatarID = new LLUUID((string) reader["UUID"]); |
280 | user.firstName = (string) reader["username"]; | 281 | user.firstName = (string) reader["username"]; |
281 | user.lastName = (string) reader["surname"]; | 282 | user.lastName = (string) reader["surname"]; |
@@ -766,7 +767,7 @@ namespace OpenSim.Data.SQLite | |||
766 | 767 | ||
767 | pcmd.ExecuteNonQuery(); | 768 | pcmd.ExecuteNonQuery(); |
768 | } | 769 | } |
769 | catch (System.Exception) | 770 | catch (Exception) |
770 | { | 771 | { |
771 | m_log.Info("[USERS]: users table already exists"); | 772 | m_log.Info("[USERS]: users table already exists"); |
772 | } | 773 | } |
@@ -775,7 +776,7 @@ namespace OpenSim.Data.SQLite | |||
775 | { | 776 | { |
776 | fcmd.ExecuteNonQuery(); | 777 | fcmd.ExecuteNonQuery(); |
777 | } | 778 | } |
778 | catch (System.Exception) | 779 | catch (Exception) |
779 | { | 780 | { |
780 | m_log.Info("[USERS]: userfriends table already exists"); | 781 | m_log.Info("[USERS]: userfriends table already exists"); |
781 | } | 782 | } |