From ea16221c1b7d7879f5d33c53bdd209803b90ed0d Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 9 Apr 2008 02:08:07 +0000
Subject: NHibernate Inventory getting close, except for some of the complex
 folder queries.

---
 OpenSim/Data/NHibernate/Migration/SqliteInventory.pl | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'OpenSim/Data/NHibernate/Migration')

diff --git a/OpenSim/Data/NHibernate/Migration/SqliteInventory.pl b/OpenSim/Data/NHibernate/Migration/SqliteInventory.pl
index d8698f4..c59cbce 100755
--- a/OpenSim/Data/NHibernate/Migration/SqliteInventory.pl
+++ b/OpenSim/Data/NHibernate/Migration/SqliteInventory.pl
@@ -25,15 +25,19 @@ my $items = "INSERT INTO InventoryItems(ID, AssetID, AssetType, InvType, Folder,
 my $folders = "INSERT INTO InventoryFolders(ID, Name, Owner, ParentID, Type, Version) ";
 
 open(SQLITE, "sqlite3 inventoryStore.db .dump |") or die "can't open the database for migration";
+open(WRITE,"| sqlite3 Inventory.db");
 
 while(my $line = <SQLITE>) {
     $line =~ s/([0-9a-f]{8})([0-9a-f]{4})([0-9a-f]{4})([0-9a-f]{4})([0-9a-f]{12})/$1-$2-$3-$4-$5/g;
     if($line =~ s/(INSERT INTO "inventoryitems")/$items/) {
         print $line;
+        print WRITE $line;
     }
     if($line =~ s/(INSERT INTO "inventoryfolders")/$folders/) {
         print $line;
-    }
-    
+        print WRITE $line;
+    }    
 }
 
+close(WRITE);
+close(SQLITE);
-- 
cgit v1.1