From 21685bf304246caa2b155bf6510ba51b19f603fa Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Thu, 9 Aug 2007 18:06:26 +0000
Subject: make MonoSqliteDataStore compile with new objects now the fun begins
 of connecting all the dots

---
 .../MonoSqliteDataStore.cs                         | 46 +++++++++++-----------
 1 file changed, 23 insertions(+), 23 deletions(-)

(limited to 'OpenSim')

diff --git a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
index 9d0a043..6400d29 100644
--- a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
+++ b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
@@ -117,8 +117,7 @@ namespace OpenSim.DataStore.MonoSqliteStorage
         private Dictionary<string, DbType> createShapeDataDefs()
         {
             Dictionary<string, DbType> data = new Dictionary<string, DbType>();
-            data.Add("id", DbType.Int32);
-            data.Add("prim_id", DbType.Int32);
+            data.Add("UUID", DbType.String);
             // shape is an enum
             data.Add("Shape", DbType.Int32);
             // vectors
@@ -215,32 +214,33 @@ namespace OpenSim.DataStore.MonoSqliteStorage
             da.DeleteCommand = delete;
         }
 
-        private void StoreSceneObject(SceneObject obj)
+        private void setupShapeCommands(SqliteDataAdapter da, SqliteConnection conn)
         {
+            Dictionary<string, DbType> shapeDataDefs = createShapeDataDefs();
             
-        }
+            da.InsertCommand = createInsertCommand("primshapes", shapeDataDefs);
+            da.InsertCommand.Connection = conn;
 
-        public void StoreObject(AllNewSceneObjectPart2 obj)
-        {
-            // TODO: Serializing code
-            DataTable prims = ds.Tables["prims"];
-            DataTable shapes = ds.Tables["shapes"];
-            
-           
+            da.UpdateCommand = createUpdateCommand("primshapes", "UUID=:UUID", shapeDataDefs);
+            da.UpdateCommand.Connection = conn;
             
+            SqliteCommand delete = new SqliteCommand("delete from primshapes where UUID = :UUID");
+            delete.Parameters.Add(createSqliteParameter("UUID", DbType.String));
+            delete.Connection = conn;
+            da.DeleteCommand = delete;
         }
-        
-        private void fillPrimRow(DataRow row, Primitive prim) 
+
+        private void fillPrimRow(DataRow row, SceneObjectPart prim) 
         {
             row["UUID"] = prim.UUID;
             row["CreationDate"] = prim.CreationDate;
-            row["Name"] = prim.Name;
-            row["PositionX"] = prim.Pos.X;
-            row["PositionY"] = prim.Pos.Y;
-            row["PositionZ"] = prim.Pos.Z;
+            row["Name"] = prim.PartName;
+            row["PositionX"] = prim.OffsetPosition.X;
+            row["PositionY"] = prim.OffsetPosition.Y;
+            row["PositionZ"] = prim.OffsetPosition.Z;
         }
 
-        private void addPrim(Primitive prim)
+        private void addPrim(SceneObjectPart prim)
         {
             DataTable prims = ds.Tables["prims"];
             DataTable shapes = ds.Tables["shapes"];
@@ -248,16 +248,16 @@ namespace OpenSim.DataStore.MonoSqliteStorage
             DataRow row = prims.Rows.Find(prim.UUID);
             if (row == null) {
                 row = prims.NewRow();
-                fillPrimRow(row, prim);
+                // fillPrimRow(row, prim);
                 prims.Rows.Add(row);
             } else {
                 fillPrimRow(row, prim);
             }
         }
 
-        public void StoreObject(SceneObject obj)
+        public void StoreObject(SceneObjectGroup obj)
         {
-            foreach (Primitive prim in obj.Children.Values)
+            foreach (SceneObjectPart prim in obj.Children.Values)
             {
                 addPrim(prim);
             }
@@ -272,9 +272,9 @@ namespace OpenSim.DataStore.MonoSqliteStorage
             // TODO: remove code
         }
 
-        public List<SceneObject> LoadObjects()
+        public List<SceneObjectGroup> LoadObjects()
         {
-            List<SceneObject> retvals = new List<SceneObject>();
+            List<SceneObjectGroup> retvals = new List<SceneObjectGroup>();
 
             MainLog.Instance.Verbose("DATASTORE", "Sqlite - LoadObjects found " + " objects");
 
-- 
cgit v1.1