From 44989288d6b2f1761dbd11d02154836b02cf0801 Mon Sep 17 00:00:00 2001
From: Adam Frisby
Date: Wed, 11 Apr 2007 06:42:07 +0000
Subject: Well, it *appears* to compile. Initial SQLite Local Storage module
(supports saving, deletion and update of prims, but does not yet load them.)
---
.../OpenSim.Storage.LocalStorageSQLite.csproj | 65 ++++++++
.../Properties/AssemblyInfo.cs | 35 +++++
.../SQLiteLocalStorage.cs | 171 +++++++++++++++++++++
.../bin/Debug/Db4objects.Db4o.dll | Bin 0 -> 593408 bytes
.../bin/Debug/OpenSim.Framework.Console.dll | Bin 0 -> 20480 bytes
.../bin/Debug/OpenSim.Framework.Console.pdb | Bin 0 -> 15872 bytes
.../bin/Debug/OpenSim.Framework.dll | Bin 0 -> 40960 bytes
.../bin/Debug/OpenSim.Framework.pdb | Bin 0 -> 60928 bytes
.../Debug/OpenSim.Storage.LocalStorageSQLite.dll | Bin 0 -> 20480 bytes
.../Debug/OpenSim.Storage.LocalStorageSQLite.pdb | Bin 0 -> 13824 bytes
.../bin/Debug/System.Data.SQLite.DLL | Bin 0 -> 568832 bytes
.../bin/Debug/libsecondlife.dll | Bin 0 -> 2338816 bytes
.../bin/System.Data.SQLite.DLL | Bin 0 -> 568832 bytes
.../bin/libsecondlife.dll | Bin 0 -> 2338816 bytes
.../Debug/OpenSim.Storage.LocalStorageSQLite.dll | Bin 0 -> 20480 bytes
.../Debug/OpenSim.Storage.LocalStorageSQLite.pdb | Bin 0 -> 13824 bytes
....Storage.LocalStorageSQLite.csproj.FileList.txt | 12 ++
17 files changed, 283 insertions(+)
create mode 100644 OpenSim.Storage.LocalStorageSQLite/OpenSim.Storage.LocalStorageSQLite.csproj
create mode 100644 OpenSim.Storage.LocalStorageSQLite/Properties/AssemblyInfo.cs
create mode 100644 OpenSim.Storage.LocalStorageSQLite/SQLiteLocalStorage.cs
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/Db4objects.Db4o.dll
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.dll
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.pdb
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.dll
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.pdb
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.dll
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.pdb
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/System.Data.SQLite.DLL
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/Debug/libsecondlife.dll
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/System.Data.SQLite.DLL
create mode 100644 OpenSim.Storage.LocalStorageSQLite/bin/libsecondlife.dll
create mode 100644 OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.dll
create mode 100644 OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.pdb
create mode 100644 OpenSim.Storage.LocalStorageSQLite/obj/OpenSim.Storage.LocalStorageSQLite.csproj.FileList.txt
(limited to 'OpenSim.Storage.LocalStorageSQLite')
diff --git a/OpenSim.Storage.LocalStorageSQLite/OpenSim.Storage.LocalStorageSQLite.csproj b/OpenSim.Storage.LocalStorageSQLite/OpenSim.Storage.LocalStorageSQLite.csproj
new file mode 100644
index 0000000..615ea58
--- /dev/null
+++ b/OpenSim.Storage.LocalStorageSQLite/OpenSim.Storage.LocalStorageSQLite.csproj
@@ -0,0 +1,65 @@
+
+
+ Debug
+ AnyCPU
+ 8.0.50727
+ 2.0
+ {2D49BA72-FF23-41EF-987C-0D6643FBE727}
+ Library
+ Properties
+ OpenSim.Storage.LocalStorageSQLite
+ OpenSim.Storage.LocalStorageSQLite
+
+
+ true
+ full
+ false
+ bin\Debug\
+ DEBUG;TRACE
+ prompt
+ 4
+
+
+ pdbonly
+ true
+ bin\Release\
+ TRACE
+ prompt
+ 4
+
+
+
+ False
+ bin\libsecondlife.dll
+
+
+
+
+ False
+ bin\System.Data.SQLite.DLL
+
+
+
+
+
+
+
+
+
+ {A7CD0630-0000-0000-0000-000000000000}
+ OpenSim.Framework.Console
+
+
+ {8ACA2445-0000-0000-0000-000000000000}
+ OpenSim.Framework
+
+
+
+
+
\ No newline at end of file
diff --git a/OpenSim.Storage.LocalStorageSQLite/Properties/AssemblyInfo.cs b/OpenSim.Storage.LocalStorageSQLite/Properties/AssemblyInfo.cs
new file mode 100644
index 0000000..fe81f8a
--- /dev/null
+++ b/OpenSim.Storage.LocalStorageSQLite/Properties/AssemblyInfo.cs
@@ -0,0 +1,35 @@
+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// General Information about an assembly is controlled through the following
+// set of attributes. Change these attribute values to modify the information
+// associated with an assembly.
+[assembly: AssemblyTitle("OpenSim.Storage.LocalStorageSQLite")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("")]
+[assembly: AssemblyProduct("OpenSim.Storage.LocalStorageSQLite")]
+[assembly: AssemblyCopyright("Copyright © 2007")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// Setting ComVisible to false makes the types in this assembly not visible
+// to COM components. If you need to access a type in this assembly from
+// COM, set the ComVisible attribute to true on that type.
+[assembly: ComVisible(false)]
+
+// The following GUID is for the ID of the typelib if this project is exposed to COM
+[assembly: Guid("ecd6e0c1-7909-413e-9e3f-659678ac3bc3")]
+
+// Version information for an assembly consists of the following four values:
+//
+// Major Version
+// Minor Version
+// Build Number
+// Revision
+//
+// You can specify all the values or you can default the Revision and Build Numbers
+// by using the '*' as shown below:
+[assembly: AssemblyVersion("1.0.0.*")]
+[assembly: AssemblyFileVersion("1.0.0.*")]
diff --git a/OpenSim.Storage.LocalStorageSQLite/SQLiteLocalStorage.cs b/OpenSim.Storage.LocalStorageSQLite/SQLiteLocalStorage.cs
new file mode 100644
index 0000000..4ccc8a2
--- /dev/null
+++ b/OpenSim.Storage.LocalStorageSQLite/SQLiteLocalStorage.cs
@@ -0,0 +1,171 @@
+/*
+* Copyright (c) OpenSim project, http://sim.opensecondlife.org/
+*
+* Redistribution and use in source and binary forms, with or without
+* modification, are permitted provided that the following conditions are met:
+* * Redistributions of source code must retain the above copyright
+* notice, this list of conditions and the following disclaimer.
+* * Redistributions in binary form must reproduce the above copyright
+* notice, this list of conditions and the following disclaimer in the
+* documentation and/or other materials provided with the distribution.
+* * Neither the name of the nor the
+* names of its contributors may be used to endorse or promote products
+* derived from this software without specific prior written permission.
+*
+* THIS SOFTWARE IS PROVIDED BY ``AS IS'' AND ANY
+* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
+* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+* DISCLAIMED. IN NO EVENT SHALL BE LIABLE FOR ANY
+* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
+* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
+* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+*
+*/
+
+// SQLite Support
+// A bad idea, but the IRC people told me to!
+
+using System;
+using System.Collections.Generic;
+using System.Data;
+using System.Data.SQLite;
+using libsecondlife;
+using OpenSim.Framework.Interfaces;
+using OpenSim.Framework.Assets;
+using OpenSim.Framework.Terrain;
+
+namespace OpenSim.Storage.LocalStorageSQLite
+{
+ public class SQLiteLocalStorage : ILocalStorage
+ {
+ IDbConnection db;
+
+ public SQLiteLocalStorage()
+ {
+ try
+ {
+ string connectionstring = "URI=file:localsim.db";
+ db = (IDbConnection)new SQLiteConnection(connectionstring);
+ db.Open();
+ }
+ catch (Exception e)
+ {
+ db.Close();
+ OpenSim.Framework.Console.MainConsole.Instance.WriteLine("SQLiteLocalStorage :Constructor - Exception occured");
+ OpenSim.Framework.Console.MainConsole.Instance.WriteLine(e.ToString());
+ }
+ }
+
+ public void StorePrim(PrimData prim)
+ {
+ IDbCommand cmd = db.CreateCommand();
+
+ //SECURITY WARNING:
+ // These parameters wont produce SQL injections since they are all integer based, however.
+ // if inserting strings such as name or description, you will need to use appropriate
+ // measures to prevent SQL injection (although the value of SQL injection in this is limited).
+
+ string sql = "REPLACE INTO prim (OwnerID,PCode,PathBegin,PathEnd,PathScaleX,PathScaleY,PathShearX,PathShearY,PathSkew,ProfileBegin,ProfileEnd,Scale,PathCurve,ProfileCurve,ParentID,ProfileHollow,PathRadiusOffset,PathRevolutions,PathTaperX,PathTaperY,PathTwist,PathTwistBegin,Texture,CreationDate,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,Position,Rotation,LocalID,FullID) ";
+ sql += "VALUES (";
+ sql += "\"" + prim.OwnerID.ToStringHyphenated() + "\","; // KILL ME NOW!
+ sql += "\"" + prim.PCode.ToString() + "\",";
+ sql += "\"" + prim.PathBegin.ToString() + "\",";
+ sql += "\"" + prim.PathEnd.ToString() + "\",";
+ sql += "\"" + prim.PathScaleX.ToString() + "\",";
+ sql += "\"" + prim.PathScaleY.ToString() + "\",";
+ sql += "\"" + prim.PathShearX.ToString() + "\",";
+ sql += "\"" + prim.PathShearY.ToString() + "\",";
+ sql += "\"" + prim.PathSkew.ToString() + "\",";
+ sql += "\"" + prim.ProfileBegin.ToString() + "\",";
+ sql += "\"" + prim.ProfileEnd.ToString() + "\",";
+ sql += "\"" + prim.Scale.ToString() + "\",";
+ sql += "\"" + prim.PathCurve.ToString() + "\",";
+ sql += "\"" + prim.ProfileCurve.ToString() + "\",";
+ sql += "\"" + prim.ParentID.ToString() + "\",";
+ sql += "\"" + prim.ProfileHollow.ToString() + "\",";
+ sql += "\"" + prim.PathRadiusOffset.ToString() + "\",";
+ sql += "\"" + prim.PathRevolutions.ToString() + "\",";
+ sql += "\"" + prim.PathTaperX.ToString() + "\",";
+ sql += "\"" + prim.PathTaperY.ToString() + "\",";
+ sql += "\"" + prim.PathTwist.ToString() + "\",";
+ sql += "\"" + prim.PathTwistBegin.ToString() + "\",";
+ sql += "\"" + prim.Texture.ToString() + "\",";
+ sql += "\"" + prim.CreationDate.ToString() + "\",";
+ sql += "\"" + prim.OwnerMask.ToString() + "\",";
+ sql += "\"" + prim.NextOwnerMask.ToString() + "\",";
+ sql += "\"" + prim.GroupMask.ToString() + "\",";
+ sql += "\"" + prim.EveryoneMask.ToString() + "\",";
+ sql += "\"" + prim.BaseMask.ToString() + "\",";
+ sql += "\"" + prim.Position.ToString() + "\",";
+ sql += "\"" + prim.Rotation.ToString() + "\",";
+ sql += "\"" + prim.LocalID.ToString() + "\",";
+ sql += "\"" + prim.FullID.ToString() + "\")";
+
+ cmd.CommandText = sql;
+
+ try
+ {
+ cmd.ExecuteNonQuery();
+ }
+ catch (Exception e)
+ {
+ OpenSim.Framework.Console.MainConsole.Instance.WriteLine("SQLiteLocalStorage :StorePrim - Exception occured");
+ OpenSim.Framework.Console.MainConsole.Instance.WriteLine(e.ToString());
+ }
+
+ cmd.Dispose();
+ cmd = null;
+ }
+
+ public void RemovePrim(LLUUID primID)
+ {
+ IDbCommand cmd = db.CreateCommand();
+
+ //SECURITY WARNING:
+ // These parameters wont produce SQL injections since they are all integer based, however.
+ // if inserting strings such as name or description, you will need to use appropriate
+ // measures to prevent SQL injection (although the value of SQL injection in this is limited).
+
+ string sql = "DELETE FROM prim WHERE FullID = \"" + primID.ToStringHyphenated() + "\"";
+
+ cmd.CommandText = sql;
+
+ try
+ {
+ cmd.ExecuteNonQuery();
+ }
+ catch (Exception e)
+ {
+ OpenSim.Framework.Console.MainConsole.Instance.WriteLine("SQLiteLocalStorage :RemovePrim - Exception occured");
+ OpenSim.Framework.Console.MainConsole.Instance.WriteLine(e.ToString());
+ }
+
+ cmd.Dispose();
+ cmd = null;
+ }
+
+ public void LoadPrimitives(ILocalStorageReceiver receiver)
+ {
+
+ }
+
+ public float[] LoadWorld()
+ {
+ return new float[65536];
+ }
+
+ public void SaveMap(float[] heightmap)
+ {
+
+ }
+
+ public void ShutDown()
+ {
+ db.Close();
+ db = null;
+ }
+ }
+}
\ No newline at end of file
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/Db4objects.Db4o.dll b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/Db4objects.Db4o.dll
new file mode 100644
index 0000000..be976a1
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/Db4objects.Db4o.dll differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.dll b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.dll
new file mode 100644
index 0000000..eff4853
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.dll differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.pdb b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.pdb
new file mode 100644
index 0000000..aeea334
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.Console.pdb differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.dll b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.dll
new file mode 100644
index 0000000..6e84c97
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.dll differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.pdb b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.pdb
new file mode 100644
index 0000000..b6bade2
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Framework.pdb differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.dll b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.dll
new file mode 100644
index 0000000..374ebf1
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.dll differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.pdb b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.pdb
new file mode 100644
index 0000000..f2e9d8d
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/OpenSim.Storage.LocalStorageSQLite.pdb differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/System.Data.SQLite.DLL b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/System.Data.SQLite.DLL
new file mode 100644
index 0000000..70d84e7
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/System.Data.SQLite.DLL differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/Debug/libsecondlife.dll b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/libsecondlife.dll
new file mode 100644
index 0000000..89d692a
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/Debug/libsecondlife.dll differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/System.Data.SQLite.DLL b/OpenSim.Storage.LocalStorageSQLite/bin/System.Data.SQLite.DLL
new file mode 100644
index 0000000..70d84e7
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/System.Data.SQLite.DLL differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/bin/libsecondlife.dll b/OpenSim.Storage.LocalStorageSQLite/bin/libsecondlife.dll
new file mode 100644
index 0000000..89d692a
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/bin/libsecondlife.dll differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.dll b/OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.dll
new file mode 100644
index 0000000..374ebf1
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.dll differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.pdb b/OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.pdb
new file mode 100644
index 0000000..f2e9d8d
Binary files /dev/null and b/OpenSim.Storage.LocalStorageSQLite/obj/Debug/OpenSim.Storage.LocalStorageSQLite.pdb differ
diff --git a/OpenSim.Storage.LocalStorageSQLite/obj/OpenSim.Storage.LocalStorageSQLite.csproj.FileList.txt b/OpenSim.Storage.LocalStorageSQLite/obj/OpenSim.Storage.LocalStorageSQLite.csproj.FileList.txt
new file mode 100644
index 0000000..1f52df8
--- /dev/null
+++ b/OpenSim.Storage.LocalStorageSQLite/obj/OpenSim.Storage.LocalStorageSQLite.csproj.FileList.txt
@@ -0,0 +1,12 @@
+obj\Debug\ResolveAssemblyReference.cache
+bin\Debug\OpenSim.Storage.LocalStorageSQLite.dll
+bin\Debug\OpenSim.Storage.LocalStorageSQLite.pdb
+bin\Debug\libsecondlife.dll
+bin\Debug\OpenSim.Framework.Console.dll
+bin\Debug\OpenSim.Framework.dll
+bin\Debug\System.Data.SQLite.DLL
+bin\Debug\Db4objects.Db4o.dll
+bin\Debug\OpenSim.Framework.pdb
+bin\Debug\OpenSim.Framework.Console.pdb
+obj\Debug\OpenSim.Storage.LocalStorageSQLite.dll
+obj\Debug\OpenSim.Storage.LocalStorageSQLite.pdb
--
cgit v1.1