aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-02-13* SQLite match code casing with regionsettings table field casing (what's ↵Teravus Ovares (Dan Olivares)1-1/+1
with the upper case S in Sandbox while the rest is lower case 0.o) * It's doubtful that this will have any effect on mantis http://opensimulator.org/mantis/view.php?id=4577 . Sqlite 3 is required, Sqlite 2 was reported.
2010-02-13* This is an attempt to resolve mantis 4437 by using SqliteAdapter type ↵Teravus Ovares (Dan Olivares)1-11/+100
statements instead of blanket SQL statements. The hope is that this makes SQLite work on Linux/Mono again. Re: http://opensimulator.org/mantis/view.php?id=4437 * Added a 'Create Update Statement' method that takes two fields for a primary key * Added an Update and Delete command for parcels and land access list table rows.
2010-02-03minor: remove some mono compiler warningsJustin Clark-Casey (justincc)3-6/+3
2010-01-05Add the port of the XInventoryService for the new Sqlite frameworkMelanie1-0/+156
2010-01-04Sqlite framework and generic handler. They compile. More I cannot say.Melanie2-0/+336
2009-12-06Getting rid of the dead field RootInventoryFolderId on UserProfileData, It's ↵Kunnis1-2/+5
not even stored in mysql. Signed-off-by: Melanie <melanie@t-data.com>
2009-11-12minor: remove some mono compiler warningsJustin Clark-Casey (justincc)1-16/+16
2009-11-05Changing the AssetBase constructors to avoid initializing assets with an ↵John Hurliman1-4/+5
unknown asset type, and log an error if it ever does happen
2009-11-02Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman1-4/+4
2009-10-02* Creates Util.UTF8 and switches some references of Encoding.UTF8 to ↵John Hurliman1-5/+9
Util.UTF8 (not all references were switched since not all OpenSim libraries reference OpenSim.Framework) * Shrinks the largest in-memory object, the LLRAW.HeightmapLookupValue struct (only used for exporting to LLRAW terrain files), to the minimum possible size. This seems to have the odd side effect of cutting the size of the two double[256,256] terrain objects in half. Possibly an alignment optimization?
2009-10-02reducing region DB log spamdr scofield (aka dirk husemann)1-1/+1
2009-10-02- cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)1-6/+6
- adding LandDataSerializer to OAR mechanics
2009-10-01Switched log level of an annoying message in SQLite to Debug, and commented ↵Diva Canto1-2/+2
it too.
2009-10-01Formatting cleanup.Jeff Ames1-1/+1
2009-09-16SceneObjectGroup cleanup. Removes the default constructor and unnecessary ↵John Hurliman1-2/+1
null checks on m_rootPart
2009-08-19Fixes GetItem and GetFolder for SQLite. Turns out some methods were no-op in ↵Diva Canto1-2/+2
SQlite. Fixes most grief in http://opensimulator.org/mantis/view.php?id=4035 http://opensimulator.org/mantis/view.php?id=4027
2009-08-19Fixing a spot I missed in assets. Switching Grid to the new naming schema ↵Kunnis1-8/+2
with Store/Get
2009-08-19* Switching IAssetData to follow the new naming schema, removing the ↵Kunnis1-28/+19
separate insert and update methods.
2009-08-17Add copyright headers. Formatting cleanup. Fix a compiler warning.Jeff Ames1-1/+1
2009-08-16* Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis1-1/+1
parameter from MySQL/MySQLInventoryData.cs * Fixed a bug in SQLite/SQLiteAssetData.cs that was causing a NRE when updating an asset. * Improved the BasicAssetTest.cs to do full create/update/get testing * Improved the BasicInventoryTest.cs to do full create/update/get of both a folder and an item * Moved the null ref tests to the start of the PropertyCompareConstraint.cs, so that it doesn't throw when passing in a null item
2009-08-16* Modified SQLite/SQLiteInventoryStore.cs to not throw if the inventory row ↵Kunnis2-18/+14
does not exist, to match the mysql behavior. * Modified SQLite/SQLiteRegionData.cs to only persist temporary items following the same rules mysql uses. * Added another ignore to the inventory test that was missing. * Added a few more ignores to the RegionTest that the first version of my test were missing. * Added ignoring the root Folder ID, which is set by the inventory system. * Added several improvements to the PropertyCompareConstraint: Protection against infinite loops, added IComparable<T> (for UUID) and moved IComparable before the property matching. * Fixed a bug where I was saving the inside of the ignore expression instead of the outside of it.
2009-08-09Formatting cleanup.Jeff Ames1-1/+1
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-9/+9
256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol
2009-08-06skip sqlite tests on z linux, as sqlite doesn't work right on the platformSean Dague5-13/+13
2009-07-25* Updates libOMV to version 0.7.0Teravus Ovares1-2/+2
* Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
2009-07-10* Added a user friendly message to the sqlite regionsettings saver giving ↵Teravus Ovares1-1/+17
them troubleshooting options and telling them to restart the simulator. This situation, hopefully is temporary and generates an exception when sqlite users first start OpenSimulator because of an unexpected condition in the database layer. Restart and all is well. * Added a user friendly message to the 'No IInventoryService available' condition with troubleshooting options.
2009-06-19more type clean fixes for mono 2.4.2Sean Dague1-8/+8
2009-06-18mono 2.4.2 seems a little more type strict, fix some sqlite tests to passSean Dague1-2/+2
2009-06-10Thank you kindly, BlueWall, for a patch that solves:Charles Krinke1-9/+9
SQLite error on creating user.
2009-06-10Formatting cleanup.Jeff Ames1-4/+4
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames14-14/+14
LICENSE.txt.
2009-05-25* Upped version number to 0.6.5lbsa711-2/+2
2009-05-15* Change default sqlite asset db back to Asset.db instead of AssetStorage.dbJustin Clarke Casey1-2/+2
* This inconsistency has actually existed for some time but only the recent change brought it to light * In the past, the default in ConfigurationLoader took precedence over the one in SQLiteAssetData
2009-05-07* Consistently use dashed uuid format for sqlite region data, as was ↵Justin Clarke Casey2-38/+114
previously done for sqlite inventory data. * This revision contains a data migration. Please backup your sqlite region db as a precaution before using this code * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
2009-04-29* minor: remove some mono compiler warningsJustin Clarke Casey1-5/+0
2009-04-25Thanks, Ewe Loon for a patch thatHomer Horwitz2-15/+278
provides persistent AvatarAppearance for SQLite. Fixes Mantis #3296.
2009-04-24silly C# not letting me use a File.Exists test for a directory. Don'tSean Dague5-5/+5
you know a directory is just a special kind of file on Linux.
2009-04-24change power linux detection method, the previous method only workedSean Dague5-10/+10
with interactive logins, not under panda.
2009-04-13* Some more experimental work on distributed assets. Nothing hotwired yet.lbsa711-1/+1
* Introduced preprocess step in FetchAsset (Might revert this later) * Some minor CCC * Added actual implementation of GetUserProfile( uri ) and the corresponding handler to OGS1. * Introduced non-functioning GetUserUri( userProfile) awaiting user server wireup (this might move elsewhere)
2009-04-10* Apply http://opensimulator.org/mantis/view.php?id=3439Justin Clarke Casey3-11/+11
* This corrects problems seen on some SQLite systems where the migration fails because the two argument substr() isn't implemented * Thanks RemedyTomm!
2009-04-09* minor: correct some documentation in SQLiteAssetData.csJustin Clarke Casey1-8/+2
2009-04-09* Change SQLite asset UUID to dashed format to be consistentJustin Clarke Casey2-6/+13
* Remaining inconsistent uuids (non dashed) are in region store for sqlite and mysql * Migration of these will happen at a later date, unless someone else wants to do it
2009-04-09* Change UUIDs in SQLite user db to dashed format to match representations ↵Justin Clarke Casey3-11/+22
elsewhere
2009-04-09* Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey1-8/+29
anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
2009-04-09* Migrate UUID representations in SQLite inventory store to dashed formatJustin Clarke Casey2-28/+42
* This makes the representation consistent with that most commonly used in the other supported database layers
2009-04-09* Moved the DatabaseTestAttribute to Test.Common, and thus included ref to ↵lbsa715-0/+5
that in all db tests. *phew*
2009-04-09* Added custom DatabaseTestAttribute to help separating unit tests from ↵lbsa715-5/+5
component tests.
2009-04-08SQLite doesn't work on ppc64, so ignore these tests if we areSean Dague5-0/+30
on this platform
2009-04-08* Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey1-4/+4
as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
2009-04-05Adding migrations for MySQL and SQLite for removing the "old" cloud image.Homer Horwitz1-0/+1
The new one already in the Library will be reinserted automatically. Fixes Mantis #964