add DeleteAsset

this also moves commit points around a bit for debuging, though 
this will change back now the MW has worked out synchronization

1 files changed, 14 insertions, 10 deletions

diff --git a/OpenSim/Framework/Data.SQLite/SQLiteAssetData.cs b/OpenSim/Framework/Data.SQLite/SQLiteAssetData.cs
index f50cc03..aef9350 100644
--- a/OpenSim/Framework/Data.SQLite/SQLiteAssetData.cs
+++ b/OpenSim/Framework/Data.SQLite/SQLiteAssetData.cs
@@ -121,11 +121,8 @@ namespace OpenSim.Framework.Data.SQLite
             {
                 fillAssetRow(row, asset);
             }
-            if (ds.HasChanges()) {
-                DataSet changed = ds.GetChanges();
-                da.Update(changed, "assets");
-                ds.AcceptChanges();
-            }
+            da.Update(ds, "assets");
+            ds.AcceptChanges();
         }
 
         public bool ExistsAsset(LLUUID uuid)
@@ -133,15 +130,22 @@ namespace OpenSim.Framework.Data.SQLite
             DataRow row = ds.Tables["assets"].Rows.Find(uuid);
             return (row != null);
         }
+
+        public void DeleteAsset(LLUUID uuid)
+        {
+            DataRow row = ds.Tables["assets"].Rows.Find(uuid);
+            if (row != null) {
+                row.Delete();
+            }
+            da.Update(ds, "assets");
+            ds.AcceptChanges();
+        }
         
         public void CommitAssets() // force a sync to the database
         {
             MainLog.Instance.Verbose("AssetStorage", "Attempting commit");
-            if (ds.HasChanges()) {
-                DataSet changed = ds.GetChanges();
-                da.Update(changed, "assets");
-                ds.AcceptChanges();
-            }
+            // da.Update(ds, "assets");
+            // ds.AcceptChanges();
         }
         
         /***********************************************************************