aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (follow)
Commit message (Collapse)AuthorAgeFilesLines
* add mysql support for media on a primJustin Clark-Casey (justincc)2010-07-262-3/+14
|
* relocate serialization code from SQLiteRegionData to MoapModule using load ↵Justin Clark-Casey (justincc)2010-07-261-53/+2
| | | | | | | | | | and save events. This is better modularity. It also allows MoapModule to be replaced with some other media module that may behave completely differently in the future. Remaining non-modularity: PrimitiveBaseShape needs explicit Media and MediaRaw fields. MediaRaw is required in order to shuttle the pre-serialization data back and forth from the database layer. The database also needs to know about MediaRaw though not about Media. IMO, it would be extremely nice to remove these hard codings but this is a bridge too far at the present time.
* Put a wrapper around the media texture region serializationJustin Clark-Casey (justincc)2010-07-261-15/+43
| | | | | | THIS WILL BREAK EXISTING MEDIA TEXTURE PERSISTENCE. Please delete your existing sqlite databases if you are experimenting with this branch. This wrapper will make it easier to maintain compatibility if the media texture data evolves. This will also make it easier to store non-sl media texture data.
* add missing regionstore migration file for new fields. D'oh!Justin Clark-Casey (justincc)2010-07-151-0/+6
| | | | this should enable persistence now
* fix bug where prim persistence would fail if media had never been setJustin Clark-Casey (justincc)2010-07-141-6/+9
|
* fix problem persisting when only one face had a media textureJustin Clark-Casey (justincc)2010-07-121-2/+8
|
* Implement media texture persistence over server restarts for sqliteJustin Clark-Casey (justincc)2010-07-011-4/+32
| | | | This is currently persisting media as an OSDArray serialized to LLSD XML.
* Same patch as before but for SQLite.Diva Canto2010-06-271-0/+8
|
* Added checks to XInventory DB layer to truncate names and descriptions.Diva Canto2010-06-271-1/+9
|
* minor: fix spelling mistake interupt -> interrupt in migrationsJustin Clark-Casey (justincc)2010-06-251-6/+3
| | | | This is for mantis 4783
* Revert "This is a HACK! Downright nasty. For some reason, the devs of the mysql"Melanie2010-06-191-7/+0
| | | | | | Didn't do what it said on the package! This reverts commit 8643db3ef0c4dca709d85fc37240a18fd9049520.
* This is a HACK! Downright nasty. For some reason, the devs of the mysqlMelanie2010-06-191-0/+7
| | | | | connector have decided that their vision of timeouts is the only valid one. This uses reflection to show them the finger. Please test.
* Revert "Set command timeout to infinity on migrations"Melanie2010-06-171-1/+0
| | | | This reverts commit 51d30fd34a950e0cd71d61ce0666a6d1e90bf233.
* Set command timeout to infinity on migrationsMelanie2010-06-171-0/+1
|
* * Deleted duplicated migration that was failing anyway.Diva Canto2010-06-141-2/+0
| | | | * Added an error message in initial estate owner creation that makes it clear what needs to happen.
* Add the BEGIN; I had missedMelanie2010-06-091-0/+1
|
* Re-add Migration version 32, which apparently got dropped completely.Melanie2010-06-091-0/+72
|
* Changed XInventoryData's CreatorID to a string.Diva Canto2010-06-081-1/+1
|
* * Changed CreatorIDs consistently to varchar(128)Diva Canto2010-06-087-53/+62
| | | | | * Deleted redundant migration for assets in SQLite * Rewrote XInventory migrations in SQLite in the new style
* Add a migration to adjust types in the WL table. The new connector likes thatMelanie2010-06-081-0/+6
| | | | better
* get TestSaveIarV0_1() working again by setting up an ↵Justin Clark-Casey (justincc)2010-06-042-3/+2
| | | | | | OpenSim.Data.Null.UserAuthenticationData plugin additional tweaks to get this working properly
* remove estate stuff in sqlite region migrations since this also exists in ↵Justin Clark-Casey (justincc)2010-06-041-54/+1
| | | | | | estate migrations, change Sandbox to sandbox in sqlite region migrations re-enabling the sqlite data tests revealed these errors!
* add sqlite database back to database testsJustin Clark-Casey (justincc)2010-06-042-2/+2
| | | | | this appears to be okay even though we reuse it between runs without deleting it first. size of the database appears not to be changing though that could be deceptive
* Fix bug where prim items were not loaded in the new sqlite database handlerJustin Clark-Casey (justincc)2010-06-041-27/+39
| | | | This addresses mantis http://opensimulator.org/mantis/view.php?id=4739
* Merge branch 'unitests'Melanie2010-05-2634-1198/+1147
|\ | | | | | | Signed-off-by: Melanie <melanie@t-data.com>
| * Minor correction to AssetTests.csAlexRa2010-05-261-3/+3
| | | | | | | | (forgot to change test descriptions, has no effect on running the tests)
| * Ensured that tests are skipped for wrong conn string, also m_log chngAlexRa2010-05-231-2/+23
| | | | | | | | | | | | | | | | | | | | The base test class now tries to connect to DB, ignores all tests in the class if unable to. Also m_log changed to instance field (which in this case shouldn't cause any problems), to avoid having to define it separately in each derived class. Here I touched things that I don't understand well (using log4net), so please review this commit.
| * Removed (unused?) empty SQL files from MSSQL resource dirAlexRa2010-05-239-0/+0
| | | | | | | | | | | | There was a whole bunch of these SQL files, all empty and apparently unused. Removing them is just a clean-up, if anybody has a reason for these files to be there, feel free to revert.
| * MySQL Migrations: Minor correcton to Region/Estate splitAlexRa2010-05-232-6/+12
| | | | | | | | (some Estate SQL left behind in the Region migration)
| * MSSQL Migration: CreatorID in InventoryItems changed to VARCHAR(36)AlexRa2010-05-231-0/+70
| | | | | | | | Again, the same thing about potentially having non-GUID CreatorID.
| * Various minor changes in the data testsAlexRa2010-05-235-16/+18
| |
| * Further corrections to MS SQL stores (now passes all tests)AlexRa2010-05-232-89/+49
| | | | | | | | | | | | | | | | | | | | | | Besides, AssetData is slightly optimized to StoreAsset in one request ("IF EXISTS() UPDATE ... ELSE INSERT ...") The main change in the MS SQL Inventory implem. is that it now return empty list (or whatever) when called with UUID.Zero, which is consistent with how the code for other DBs work. I did no changes at all in XInventory, as there is no test set for them.
| * Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa2010-05-234-103/+157
| | | | | | | | | | | | | | | | | | | | | | | | ok, so the estate stores now want their own migration files, but as it happened the SQL definition were inside the Region migrations. It seems better/cleaner to keep each 'store' separately updatable. WARNING: any editing in the middle of the migration scripts (as opposite to just appending to them) has the potential of messing up updates of existing databases. As far as I can see, this one is (probably) safe, the worst that could happen is the EstateStore migration silently fail if the estate the tables are already there.
| * Unitests: Asset, Estate, Region (the "legacy" one), InventoryAlexRa2010-05-235-173/+137
| | | | | | | | | | | | | | | | The tests have been modified to work under NUnit 2.4.6 (the one currently used in the project). They will also work with NUnit 2.5+ as is, but will look better if you #define NUNIT25 for them.
| * Added MS SQL test conn to INI - only as an example, modify before use!!!AlexRa2010-05-231-4/+21
| | | | | | | | | | | | | | NOTE that this INI file is currently loaded as a embedded RESOURCE, which is weird and has a disadvantage of having to rebuild the Tests whenever the conn strings are changed. The only reason is that I couldn't figure out a reliable way to put this INI into the correct dir at runtime. If somebody can do it, that would be cool.
| * Removed MySql and SQLite-specific asset test filesAlexRa2010-05-232-156/+0
| |
| * BasicAssetTest.cs replaced by AssetTests.csAlexRa2010-05-231-0/+161
| | | | | | | | | | | | | | | | AssetTests: The name has changed to reflect the fact it is no longer a base class, but the complete asset test for all supported databases. The test can also check storing of CreatorID, but the feature is disabled at this commit!
| * Bugfix in tests (must clear db before migrations, not after)AlexRa2010-05-233-3/+3
| |
| * EstateData tests passing on all DBsAlexRa2010-05-231-28/+2
| |
| * Corrections in RegionTests.cs. It now fully works!AlexRa2010-05-231-48/+75
| | | | | | | | | | | | | | | | | | The problem was that some tests relied on prior tests to leave the DB in a particular state, but the test class cleared the DB every time. The affected tests have been merged into one to remove the dependencies. tested on all 3 Dbs, all tests green.
| * Minor corrections in BasicDataServiceTest.csAlexRa2010-05-231-0/+41
| | | | | | | | | | (added more functions for cleaning up DB from the derived tests)
| * MSSQL: added asset_flags, CreatorID to migrationsAlexRa2010-05-231-0/+6
| |
| * MSSQLAssetData updated to support [CreatorID], [asset_flags]AlexRa2010-05-231-5/+11
| |
| * MSSQLAssetData: fixed some weirdnessAlexRa2010-05-231-7/+12
| | | | | | | | | | | | | | | | Fixed unfinished SQL in FetchAssetMetadataSet, fixed SQL in UpdateAsset (must not modify ID). NOT tested! But apparently shouldn't work worse than the previous version, esp. the FetchMetadata thing.
| * All data tests made DBMS-independentAlexRa2010-05-2310-610/+160
| |
| * Added generic base classes for testing database servicesAlexRa2010-05-233-0/+241
| | | | | | | | | | | | | | | | | | | | These are some generic classes that simplify writing tests for any of the data connectors and databases. Among other things, configuring the connection strings is done once, in a separate resource file. Tests based on the new BasicDataServiceTest class require NUnit 2.5 or better.
* | The 8th migration statement in AssetStore.migrations didn't look right.Diva Canto2010-05-231-1/+1
|/
* Cleaned up MySql migrations a bit more, got rid of all old-form migration ↵Diva Canto2010-05-205-32/+8
| | | | files. Restored Presence table to its taboo-breaking form.
* Revert one of the previous patches' hunks. The new code looked better, butMelanie2010-05-201-3/+10
| | | | was less efficient.
* Series of patches to include creator ID in assets.AlexRa2010-05-201-4/+35
| | | | | | | | | | | | | | Contains a migration. SQLite: May contain nuts. The SQLite migration copies the entire asset table. Be prepared for quite a wait. Don't interrupt it. Back up your assets db. BasicAssetTest checks CreatorID storage, new test for weird CreatorID (now also checks that non-GUID or empty CreatorID gets stored correctly) Signed-off-by: Melanie <melanie@t-data.com>