aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2007-08-24attempted fix for .NET issue with the databaseSean Dague1-6/+6
2007-08-23Add region to dbSean Dague1-48/+50
2007-08-23I think this fixes blob save/load issues (though I'm still not convinced this Sean Dague1-20/+26
will handle > 8k textures yet). Need MW to test to see if this gets rid of his issue. There is commented code left in here for now until we know it is fixed
2007-08-23grouping of functions to make the overall logic easier to grasp for people,Sean Dague1-349/+394
and start to show how this can be super classed with some common elements.
2007-08-23fix typoSean Dague1-5/+1
2007-08-22setup test tables function which lets us make sure that everythingSean Dague1-111/+28
we are going to ask for from the database is actually there. This will let us bail early with a useful error message, instead of late with a hard to understand one. Do some other cleanups to get rid of debug input I put in
2007-08-22Bit of refactoring of the sqlite storage code to build the Sean Dague1-50/+187
data definition in ado.net objects up front. This makes auto generating the sql commands work a lot more reliably.
2007-08-21auto create sqlite database if it doesn't exist. This works, but needs someSean Dague1-85/+161
cleaning up prior to release. However this should make it easy for people to start using sqlite storage.
2007-08-20The regionUUID is now being passed to the datastore calls.MW1-3/+3
2007-08-19Sqlite datastore should now save the textures and extraparams data (used by ↵MW1-38/+100
sculpties) correctly. [Really need to add a ExtraParams field to the sqlite database though, but for now I have combined their data so that we don't lose backward compatibility, know a couple of people have been using the datastore already]. Now have a rough day/night cycle (the movement of the sun needs to be made smoother but for now it is better than we had I think). Added dalien's patch (issue 294) for saving and loading prims to a xml file (think he will be modifying these to be import/export functions and maybe writing a xml datastore for backups). Some preliminary work on task inventory (ie object's/prim's inventory). Added place holder data for AvatarProperties (ie a avatar's profile). Should we store this sort of data on the user server or have another server for it (a normal webserver should work). Added a few more method to IClientAPI. Sure there is something I'm forgeting.
2007-08-16Had to rename Rotation in SceneObjectGroup to GroupRotation to stop conflict ↵MW1-1/+18
with Rotation in entitybase (couldn't override as they are different types (LL vs Axiom) and didn't want to add new). When you take prims into inventory (or delete them), they should now be removed from the prim datastore, so they no longer reappear in-world when you restart opensim.
2007-08-16* Introduced IScriptHost as an interface to fetching object data from scripts.lbsa711-2/+2
* This meant introducing AbsolutePosition on all objects (since SimChat wants that)
2007-08-14Start of Inventory service, currently only (partially) functional in ↵MW1-1/+1
standalone mode and using sqlite). In standalone mode, if you have account authenticate turned on (setting in opensim.ini) then when you create a new account, a set of inventory is created for that account and stored in database (currently only a set of empty folders). Then during login the database is search for that set and sent to the client in the login response. More functions will be added soon, like creating new folders (and a bit later items) from the client inventory window.
2007-08-13Partial Linking of prim groups should work (its partial as currently only ↵MW1-18/+34
the root prim of the child group will actually get linked, working on linking the rest now). Multiple prim groups are now stored in the sqlite database and are reloaded correctly.
2007-08-11Added a new column (SceneGroupID) to sqlite3 table (sqlite3-prims.sql) so ↵MW1-5/+8
that we can tell what prims belong to the same SceneObjectGroup. If sdague has a different method in mind when he gets back then he can change it then.
2007-08-10Some cleaning up and removed a few old files no longer in use.MW1-3/+4
Temporary have had to rename the OpenSim.DataStore.MonoSqlite project to OpenSim.DataStore.MonoSqlite1, as I'm not sure what was done to stop the old project name being included in the VS2005 solution. Also some config changes: OpenSim now has a INI (OpenSim.ini) file that it will read some config settings from (if the ini file exists). Added Mono.Data.SqliteClient.dll so that we can use the same code for sqlite on Windows and mono/linux. (from what I can tell Mono class libraries have a MIT license so there should be no problems with us including this dll). So now to get the basic prim storage working , you need to first create the sqlite database file from the sqlite3-prims.sql in share directory. Then in the OpenSim.ini file, change the storage_plugin so it points to OpenSim.DataStore.MonoSqlite1.dll (storage_plugin = OpenSim.DataStore.MonoSqlite1.dll). Then in your region.xml files change the DataStore value so it is the name of your database file (at the moment you need a different sqlite3 database file for each region).
2007-08-10Removed a piece of debug codeMW1-9/+0
2007-08-10Made a few changes so that once we enable the sqlite data store (simple line ↵MW1-8/+41
change in OpenSimMain), then basic ( with a few limits at moment) prim database backup will work.
2007-08-09Couldn't leave this one alone. Data is now flowing both ways inSean Dague1-72/+79
sqlite *but* isn't being added back to the scene on load because some information (like rootpart) isn't currently exposed enough to save/restore, and I don't want to change the SceneObjectGroup definition without MW around to discuss. A couple of minor changes on the object interface for SceneObjectGroup and tweaks to this class, and we have persistant prims again.
2007-08-09comment out load from sqlite as this blows up on object creation right now.Sean Dague1-11/+14
must run away on vacation. See you all in a week and change.
2007-08-09completely untest load prims from db code. Testing shortlySean Dague1-0/+16
2007-08-09utility functions to convert from rows to new objects. untestedSean Dague1-0/+87
2007-08-09added GroupPositionSean Dague1-1/+13
2007-08-09build update clauses correctlySean Dague1-1/+6
2007-08-09some more typos about wrong table for shapesSean Dague1-3/+3
2007-08-09use correct table name for shapesSean Dague1-1/+1
2007-08-09pull out some uneeded attributes, and setup keys on primshapes datasetSean Dague1-3/+3
2007-08-09prim.Shape -> primshapes tableSean Dague1-3/+35
2007-08-09prim object -> prims table codeSean Dague1-7/+52
2007-08-09make MonoSqliteDataStore compile with new objectsSean Dague1-23/+23
now the fun begins of connecting all the dots
2007-08-09Start defining prim shape definition. Officially bed time nowSean Dague1-7/+45
2007-08-09decrease insanity level significantly by factoring all the columns intoSean Dague1-102/+46
a Dictionary, and programatically building up sql commands for our dataset. Prims done, prim shapes next
2007-08-09intermediate checkin of code that compiles before I do somethingSean Dague1-4/+87
stupid and nuke all this work.
2007-08-09Commit in the changes for all the parameter bindings for primsSean Dague1-2/+38
2007-08-08sigh, Data ... not Date. I'm dumbSean Dague1-0/+0
2007-08-08name changes in MonoSqliteData storeSean Dague1-2/+2
2007-08-08rename to MonoSqliteDataStoreSean Dague1-0/+0
2007-08-08moving to new namespace as this is mono onlySean Dague1-0/+0
2007-08-08This chunk of code actually properly saves out some parameters ofSean Dague1-6/+9
current objects to disk, and does updates on those objects usefully. It is now functional enough to mean that moving to new objects is just lots of plug and chug.
2007-08-08databits are actually flowing to diskSean Dague1-34/+50
2007-08-07starting to push some of the actual sql commands to get this to disk. Sean Dague1-5/+52
Not working yet.
2007-08-07actually transfer some data to the row definition. Going to hookSean Dague1-3/+21
this up to the sim in my env now to make sure we're getting data flow in a reasonable way at this point.
2007-08-07actually get sqlite stuff to compile. This isn't connected to theSean Dague1-21/+5
main prebuild yet. Going to attempt to get some tracing on current SceneObjects first
2007-08-07some more sqlite stuff. Checking in to get it to another computerSean Dague1-1/+30
to do a bit more live hacking on data flow
2007-08-06adding shell of SqliteDataStoreSean Dague1-0/+116