aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLAssetData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * Replaced (possibly broken?) math for calculating the unix timestamp in ↵John Hurliman2009-10-141-5/+5
| | | | | | | MySQLAssetData with Utils.DateTimeToUnixTime() * Disabled UpdateAccessTime() function since it was only writing zeros anyways. This gave me a significant performance improvement for startup times and avatar logins in standalone mode * Load attachments asynchronously so avatars with lots of attachments don't have to race the timeout clock to login
* * Continued work on the new LLUDP implementation. Appears to be functioning, ↵John Hurliman2009-10-061-4/+2
| | | | | | | | although not everything is reimplemented yet * Replaced logic in ThreadTracker with a call to System.Diagnostics that does the same thing * Added Util.StringToBytes256() and Util.StringToBytes1024() to clamp output at byte[256] and byte[1024], respectively * Fixed formatting for a MySQLAssetData error logging line
* * MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman2009-10-041-54/+48
| | | | | | Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
* Formatting cleanup.Jeff Ames2009-10-011-1/+1
|
* Fix issue where conversion of temporary boolean variable fails on MySQLArthur Valadares2009-08-211-2/+2
|
* * Switching IAssetData to follow the new naming schema, removing the ↵Kunnis2009-08-191-11/+2
| | | | separate insert and update methods.
* * Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis2009-08-161-8/+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
* Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis2009-08-161-0/+1
|
* * Apply asset and inventory name and description bound checks to MySQLJustin Clarke Casey2009-07-241-2/+16
|
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-011-1/+1
| | | | LICENSE.txt.
* * Some more experimental work on distributed assets. Nothing hotwired yet.lbsa712009-04-131-17/+19
| | | | | | | | | * 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)
* * Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey2009-04-091-1/+1
| | | | | | | | anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
* Implemented FetchAssetMetadataSet in DB backends.Mike Mazur2009-03-091-0/+51
| | | | | | | | | | | | | This method fetches metadata for a subset of the entries in the assets database. This functionality is used in the ForEach calls in the asset storage providers in AssetInventoryServer. With this implemented, frontends such as the BrowseFrontend should now work. - MySQL: implemented, sanity tested - SQLite: implemented, sanity tested - MSSQL: implemented, not tested - NHibernate: not implemented
* - remove the Metadata property from AssetBase and return all previousMike Mazur2009-02-171-17/+17
| | | | | | | | | properties as before - prefix private variables with m_ in AssetBase.cs - related to Mantis #3122, as mentioned in https://lists.berlios.de/pipermail/opensim-dev/2009-February/005088.html - all services will likely need to be upgraded after this commit
* * optimized usings.lbsa712009-02-121-7/+5
|
* - add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur2009-02-041-17/+17
| | | | | - trim trailing whitespace
* Rename IAssetProviderPlugin to IAssetDataPlugin aligning with the other data ↵Mike Mazur2009-02-031-1/+1
| | | | plugins.
* Slight cleanup of docs, removing trailing whitespace.Mike Mazur2009-01-281-6/+5
|
* Avoid an invalid cast on legacy dataMelanie Thielker2009-01-181-1/+8
|
* Update the MySQL connector to 5.2.5. Fixes Mantids#2673. Thanks for the ↵Homer Horwitz2008-12-221-1/+1
| | | | hint, jhurliman.
* add create_time and access_time to asset db for mysql, as wellSean Dague2008-11-061-2/+46
| | | | | | | | | | | | as the code to update these at the appropriate time. This isn't surfaced in AssetBase yet. Change the replace into to an insert into for asset create. Assets are not supposed to be updatable, and the replace into is more expensive. From: Sean Dague <sdague@gmail.com>
* let the asset tests run on MySQL. Interesting difference here, theSean Dague2008-09-241-1/+1
| | | | | | | sqlite driver can handle .Data = Null, the mysql driver can not. We should decide which is the right behavior and adjust code for it.
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-061-3/+3
| | | | | | | * This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
* remove the legacy pre-Migration database upgrade pathsSean Dague2008-08-271-42/+0
|
* Formatting cleanup.Jeff Ames2008-08-181-4/+4
|
* Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur2008-07-311-1/+1
| | | | | | PluginLoader. Fix issue 1871.
* Thanks, sempuki, for a patch that moves all grid plugins to new PluginLoader ↵Mike Mazur2008-07-181-0/+1
| | | | (issue 1763).
* * remove unused CommitAssets() hook for nowJustin Clarke Casey2008-07-071-7/+0
|
* Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-07-031-0/+6
| | | | | | | patch attached to check for timeouts on mysql connections *before* operations occur that are likely to timeout. if timeout occurs or the connections is down, it is reconnected before the operation fails.
* * Drop InvType from the assets table since it is no longer usedJustin Clarke Casey2008-07-021-5/+3
| | | | | | | | * Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
* * Fix for http://opensimulator.org/mantis/view.php?id=1512Justin Clarke Casey2008-06-291-1/+1
| | | | | | | * Introduce experimental wait timeout checking to mysql region datastore code * This should mean that if the mysql connection has timed out, we should automatically reconnect and not fail or drop queries on region database manipulations
* last round of warning squashing. calling it a day now.Dr Scofield2008-06-271-10/+10
|
* Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke2008-06-271-1/+3
| | | | | | | | | | Currently module loading is done ad-hoc. I propose creating a simple loader class that leverages Mono.Addins (and perhaps the new .NET addins when they become available in mono). Attached is a basic patch for review that compiles into HEAD, but doesn't yet replace any existing ad-hoc loaders.
* Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames2008-06-261-19/+42
| | | | kerunix_Flan!
* Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames2008-06-261-1/+36
| | | | files. Thanks kerunix_Flan!
* the beginning of the great id format migration. This makesSean Dague2008-06-161-6/+4
| | | | | | | | | asset uuids no longer binary. I've tested this migration a few times, and it seems working in all the scenarios I've found but it wouldn't hurt to backup your asset db before running this as it does touch a very sensitive part of our content system.
* this, in theory, adds migration support to mysql for all Sean Dague2008-06-121-34/+50
| | | | | | | | data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
* Formatting cleanup, minor refactoring, svn properties.Jeff Ames2008-06-041-5/+5
|
* * Duh, actually returning from the CreateAsset method once we know the asset ↵Justin Clarke Casey2008-05-311-0/+1
| | | | exists would be better than carrying on
* * Remove the mysql logging noise I accidentally left in a few commits agoJustin Clarke Casey2008-05-311-2/+2
|
* * Change MySQL to check whether an asset already exists before inserting it ↵Justin Clarke Casey2008-05-311-1/+40
| | | | into the database
* Formatting cleanup.Jeff Ames2008-05-161-5/+5
|
* More formatting cleanup.Jeff Ames2008-05-141-2/+5
|
* * Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey2008-05-011-3/+3
| | | | | | | | settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code
* in theory, let you pass the mysql connection string into theSean Dague2008-04-241-1/+7
| | | | | | | | mysql manager class. This could use some testing of inventory and asset services. Once this is prooved out, I'll do it for mssql as well.
* changes to allow asset_source to be specified in the opensim.iniSean Dague2008-04-231-0/+7
| | | | | | | | this will work for sqlite and nhibernate, but will be ignored for mysql and mssql (reverting to their ini files) until someone writes that bit.
* * Optimised using statements and namespace references across entire project ↵Adam Frisby2008-04-211-2/+3
| | | | (this took a while to run).
* fix ups to include OpenSim.Framework explicit includes (theySean Dague2008-04-021-0/+1
| | | | | | | were implicitly included before). Everything builds again. Now off to testing.
* attempt to fix up all refernces to new directory structureSean Dague2008-04-021-1/+1
|
* whole lot more movingSean Dague2008-04-021-0/+198