aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-05-23MySQL Migrations: Minor correcton to Region/Estate splitAlexRa2-6/+12
(some Estate SQL left behind in the Region migration)
2010-05-23MSSQL Migration: CreatorID in InventoryItems changed to VARCHAR(36)AlexRa1-0/+70
Again, the same thing about potentially having non-GUID CreatorID.
2010-05-23Various minor changes in the data testsAlexRa5-16/+18
2010-05-23Further corrections to MS SQL stores (now passes all tests)AlexRa2-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.
2010-05-23Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa4-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.
2010-05-23Unitests: Asset, Estate, Region (the "legacy" one), InventoryAlexRa5-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.
2010-05-23Added MS SQL test conn to INI - only as an example, modify before use!!!AlexRa1-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.
2010-05-23Removed MySql and SQLite-specific asset test filesAlexRa2-156/+0
2010-05-23BasicAssetTest.cs replaced by AssetTests.csAlexRa1-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!
2010-05-23Bugfix in tests (must clear db before migrations, not after)AlexRa3-3/+3
2010-05-23EstateData tests passing on all DBsAlexRa1-28/+2
2010-05-23Corrections in RegionTests.cs. It now fully works!AlexRa1-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.
2010-05-23Minor corrections in BasicDataServiceTest.csAlexRa1-0/+41
(added more functions for cleaning up DB from the derived tests)
2010-05-23MSSQL: added asset_flags, CreatorID to migrationsAlexRa1-0/+6
2010-05-23MSSQLAssetData updated to support [CreatorID], [asset_flags]AlexRa1-5/+11
2010-05-23MSSQLAssetData: fixed some weirdnessAlexRa1-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.
2010-05-23All data tests made DBMS-independentAlexRa10-610/+160
2010-05-23Added generic base classes for testing database servicesAlexRa3-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.
2010-05-20Cleaned up MySql migrations a bit more, got rid of all old-form migration ↵Diva Canto5-32/+8
files. Restored Presence table to its taboo-breaking form.
2010-05-20Revert one of the previous patches' hunks. The new code looked better, butMelanie1-3/+10
was less efficient.
2010-05-20Series of patches to include creator ID in assets.AlexRa1-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>
2010-05-19Scrambled asset type in BasicAssetTest.cs!AlexRa1-9/+10
The asset type wasn't in the list of "DontScramble" fields, so the test assets were stored with randomized type, which caused exception on reading them. Also the scrambler was moved from local var to the class level, so it could be used in the new tests I've added (see the next commit).
2010-05-19MySQLAssetData.cs now supports asset_flags, CreatorIDAlexRa1-5/+7
2010-05-19MySQL: added CreatorID, moved asset_flag to migration scriptAlexRa1-0/+8
2010-05-19SQLite: CreatorID added (and asset_flags moved) to the migration scriptAlexRa1-0/+24
2010-05-19Added CreatorID to SQLite asset dataAlexRa1-15/+27
2010-05-19A bit of harmless refactoring in SQLiteAssetData.csAlexRa1-10/+3
2010-05-19Kind of fixed Melanie's "Exception(sql)" correctionAlexRa1-2/+2
Throwing an Ex. with SQL command in the message looks weird, this is a bit better, but I'm still not sure if that's the proper way to handle. Also, there is a catch one level up, so is this one necessary?
2010-05-19Change appender to deal with line feeds more intelligently.Melanie1-1/+1
Change migration error reporting to not truncate the statement when reporting. It's a bit messier than the old error reporting, but at least one gets an idea of what could be wrong again. And things look a lot neater now.
2010-05-19Clean up output a bitMelanie2-8/+11
2010-05-19Fix the migration message to say "Continuing" again. Remove line feed, whichMelanie1-1/+1
prevented the full message from displaying.
2010-05-19Remove the return that was inserted in the last merge to allowMelanie1-1/+0
migrations to continue in the face of an error
2010-05-19Revert "Allow migration steps to fail again without bringing down the house"Melanie1-1/+1
This reverts commit 167db502593de5f535d8c322005c63ef263940ed.
2010-05-19Allow migration steps to fail again without bringing down the houseMelanie1-1/+1
2010-05-18Make m_log in migrations private. Define new m_log in derived classMelanie2-1/+3
2010-05-18Binary Guids are 16 chars long. Fix parser.Melanie1-1/+1
2010-05-19Some more corrections after MySQL connector updateAlexRa2-2/+3
2010-05-19All (?) MySQL stores fixed to use DBGuid.FromDB()AlexRa5-92/+68
This was needed if we want to update to the latest MySQL connector dll. It automatically converts CHAR(36) to Guids, so getting them as strings no longer works. By using DBGuid.FromDB(), we unlink from any particular storage format of GUIDs, could even make them BINARY(16) if we like. Actually not all MySql units are touched, but the remaining ones don't seem to be affected (they don't read GUIDs from DB)
2010-05-19Added DBGuids.cs (static func DBGuid.FromDB()AlexRa1-0/+44
This DBMS-independent function to be used converting UUIDs from whatever format used in the DB (string/binary/Guid). This is mostly needed for MySQL, as in MSSQL they are always UNIQUEIDENTIFIERs and in SQLite always strings (but would look better if we use it there anyway).
2010-05-18MS SQL migrations converted to the new formatAlexRa77-2008/+2273
2010-05-18Migrations for SQLite converted to new formatAlexRa46-709/+828
2010-05-18Converted MySQL migration history to the new formatAlexRa79-1008/+1228
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-18Added MySqlMigrations.cs (supports stored proc/funcs)AlexRa1-0/+85
Uses MySqlScript class to correctly run proc/func definitions that need delimiter change. Requires MySql.Data.dll 6.2 or later.
2010-05-18Migration.cs supports single-file migration history formatAlexRa1-104/+233
Scans for migration resources in either old-style "scattered" (one file per version) or new-style "integrated" format (single file "Resources/{StoreName}.migrations[.nnn]") with ":VERSION nnn" sections). In the new-style migrations it also recognizes ':GO' separators for parts of the SQL script that must be sent to the server separately. The old-style migrations are loaded each in one piece and don't support the ':GO' feature. Status: TESTED and works fine in all modes!
2010-05-18Massive bugfix in MSSQLEstateData (now works!)AlexRa1-49/+41
2010-05-16MS SQL migrations converted to the new formatAlexRa77-2008/+2273
2010-05-16Migrations for SQLite converted to new formatAlexRa46-709/+828
2010-05-16Converted MySQL migration history to the new formatAlexRa79-1008/+1228
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-16Added MySqlMigrations.cs (supports stored proc/funcs)AlexRa1-0/+85
Uses MySqlScript class to correctly run proc/func definitions that need delimiter change. Requires MySql.Data.dll 6.2 or later.
2010-05-16Migration.cs supports single-file migration history formatAlexRa1-104/+233
Scans for migration resources in either old-style "scattered" (one file per version) or new-style "integrated" format (single file "Resources/{StoreName}.migrations[.nnn]") with ":VERSION nnn" sections). In the new-style migrations it also recognizes ':GO' separators for parts of the SQL script that must be sent to the server separately. The old-style migrations are loaded each in one piece and don't support the ':GO' feature. Status: TESTED and works fine in all modes!