diff options
author | Justin Clark-Casey (justincc) | 2010-04-23 17:17:15 +0100 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2010-04-23 17:17:15 +0100 |
commit | a23bebdc0f106c19de09e54d88eebc6b086fdaab (patch) | |
tree | 5a0141201ae27b796608f0af77f4d9a1e1cd1d19 /OpenSim/Data/SQLiteNG/SQLiteXInventoryData.cs | |
parent | minor: change a comment and replace some magic numbers with the AssetType enum (diff) | |
download | opensim-SC_OLD-a23bebdc0f106c19de09e54d88eebc6b086fdaab.zip opensim-SC_OLD-a23bebdc0f106c19de09e54d88eebc6b086fdaab.tar.gz opensim-SC_OLD-a23bebdc0f106c19de09e54d88eebc6b086fdaab.tar.bz2 opensim-SC_OLD-a23bebdc0f106c19de09e54d88eebc6b086fdaab.tar.xz |
Duplicate OpenSim.Data.SQLite into OpenSim.Data.SQLiteNG. SQLiteNG will shortly be changed to work under mono 2.6 and above
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLiteNG/SQLiteXInventoryData.cs | 155 |
1 files changed, 155 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLiteNG/SQLiteXInventoryData.cs b/OpenSim/Data/SQLiteNG/SQLiteXInventoryData.cs new file mode 100644 index 0000000..a66e0c6 --- /dev/null +++ b/OpenSim/Data/SQLiteNG/SQLiteXInventoryData.cs | |||
@@ -0,0 +1,155 @@ | |||
1 | /* | ||
2 | * Copyright (c) Contributors, http://opensimulator.org/ | ||
3 | * See CONTRIBUTORS.TXT for a full list of copyright holders. | ||
4 | * | ||
5 | * Redistribution and use in source and binary forms, with or without | ||
6 | * modification, are permitted provided that the following conditions are met: | ||
7 | * * Redistributions of source code must retain the above copyright | ||
8 | * notice, this list of conditions and the following disclaimer. | ||
9 | * * Redistributions in binary form must reproduce the above copyright | ||
10 | * notice, this list of conditions and the following disclaimer in the | ||
11 | * documentation and/or other materials provided with the distribution. | ||
12 | * * Neither the name of the OpenSimulator Project nor the | ||
13 | * names of its contributors may be used to endorse or promote products | ||
14 | * derived from this software without specific prior written permission. | ||
15 | * | ||
16 | * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY | ||
17 | * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | ||
18 | * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE | ||
19 | * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY | ||
20 | * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES | ||
21 | * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; | ||
22 | * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND | ||
23 | * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | ||
24 | * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS | ||
25 | * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | ||
26 | */ | ||
27 | |||
28 | using System; | ||
29 | using System.Data; | ||
30 | using System.Reflection; | ||
31 | using System.Collections.Generic; | ||
32 | using Mono.Data.SqliteClient; | ||
33 | using log4net; | ||
34 | using OpenMetaverse; | ||
35 | using OpenSim.Framework; | ||
36 | |||
37 | namespace OpenSim.Data.SQLite | ||
38 | { | ||
39 | /// <summary> | ||
40 | /// A MySQL Interface for the Asset Server | ||
41 | /// </summary> | ||
42 | public class SQLiteXInventoryData : IXInventoryData | ||
43 | { | ||
44 | // private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); | ||
45 | |||
46 | private SQLiteGenericTableHandler<XInventoryFolder> m_Folders; | ||
47 | private SqliteItemHandler m_Items; | ||
48 | |||
49 | public SQLiteXInventoryData(string conn, string realm) | ||
50 | { | ||
51 | m_Folders = new SQLiteGenericTableHandler<XInventoryFolder>( | ||
52 | conn, "inventoryfolders", "InventoryStore"); | ||
53 | m_Items = new SqliteItemHandler( | ||
54 | conn, "inventoryitems", String.Empty); | ||
55 | } | ||
56 | |||
57 | public XInventoryFolder[] GetFolders(string[] fields, string[] vals) | ||
58 | { | ||
59 | return m_Folders.Get(fields, vals); | ||
60 | } | ||
61 | |||
62 | public XInventoryItem[] GetItems(string[] fields, string[] vals) | ||
63 | { | ||
64 | return m_Items.Get(fields, vals); | ||
65 | } | ||
66 | |||
67 | public bool StoreFolder(XInventoryFolder folder) | ||
68 | { | ||
69 | return m_Folders.Store(folder); | ||
70 | } | ||
71 | |||
72 | public bool StoreItem(XInventoryItem item) | ||
73 | { | ||
74 | return m_Items.Store(item); | ||
75 | } | ||
76 | |||
77 | public bool DeleteFolders(string field, string val) | ||
78 | { | ||
79 | return m_Folders.Delete(field, val); | ||
80 | } | ||
81 | |||
82 | public bool DeleteItems(string field, string val) | ||
83 | { | ||
84 | return m_Items.Delete(field, val); | ||
85 | } | ||
86 | |||
87 | public bool MoveItem(string id, string newParent) | ||
88 | { | ||
89 | return m_Items.MoveItem(id, newParent); | ||
90 | } | ||
91 | |||
92 | public XInventoryItem[] GetActiveGestures(UUID principalID) | ||
93 | { | ||
94 | return m_Items.GetActiveGestures(principalID); | ||
95 | } | ||
96 | |||
97 | public int GetAssetPermissions(UUID principalID, UUID assetID) | ||
98 | { | ||
99 | return m_Items.GetAssetPermissions(principalID, assetID); | ||
100 | } | ||
101 | } | ||
102 | |||
103 | public class SqliteItemHandler : SQLiteGenericTableHandler<XInventoryItem> | ||
104 | { | ||
105 | public SqliteItemHandler(string c, string t, string m) : | ||
106 | base(c, t, m) | ||
107 | { | ||
108 | } | ||
109 | |||
110 | public bool MoveItem(string id, string newParent) | ||
111 | { | ||
112 | SqliteCommand cmd = new SqliteCommand(); | ||
113 | |||
114 | cmd.CommandText = String.Format("update {0} set parentFolderID = :ParentFolderID where inventoryID = :InventoryID", m_Realm); | ||
115 | cmd.Parameters.Add(new SqliteParameter(":ParentFolderID", newParent)); | ||
116 | cmd.Parameters.Add(new SqliteParameter(":InventoryID", id)); | ||
117 | |||
118 | return ExecuteNonQuery(cmd, m_Connection) == 0 ? false : true; | ||
119 | } | ||
120 | |||
121 | public XInventoryItem[] GetActiveGestures(UUID principalID) | ||
122 | { | ||
123 | SqliteCommand cmd = new SqliteCommand(); | ||
124 | cmd.CommandText = String.Format("select * from inventoryitems where avatarId = :uuid and assetType = :type and flags = 1", m_Realm); | ||
125 | |||
126 | cmd.Parameters.Add(new SqliteParameter(":uuid", principalID.ToString())); | ||
127 | cmd.Parameters.Add(new SqliteParameter(":type", (int)AssetType.Gesture)); | ||
128 | |||
129 | return DoQuery(cmd); | ||
130 | } | ||
131 | |||
132 | public int GetAssetPermissions(UUID principalID, UUID assetID) | ||
133 | { | ||
134 | SqliteCommand cmd = new SqliteCommand(); | ||
135 | |||
136 | cmd.CommandText = String.Format("select inventoryCurrentPermissions from inventoryitems where avatarID = :PrincipalID and assetID = :AssetID", m_Realm); | ||
137 | cmd.Parameters.Add(new SqliteParameter(":PrincipalID", principalID.ToString())); | ||
138 | cmd.Parameters.Add(new SqliteParameter(":AssetID", assetID.ToString())); | ||
139 | |||
140 | IDataReader reader = ExecuteReader(cmd, m_Connection); | ||
141 | |||
142 | int perms = 0; | ||
143 | |||
144 | while (reader.Read()) | ||
145 | { | ||
146 | perms |= Convert.ToInt32(reader["inventoryCurrentPermissions"]); | ||
147 | } | ||
148 | |||
149 | reader.Close(); | ||
150 | CloseCommand(cmd); | ||
151 | |||
152 | return perms; | ||
153 | } | ||
154 | } | ||
155 | } | ||