aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLAssetData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Add more information to warnings logged when asset names and descriptions ↵Justin Clark-Casey (justincc)2013-02-271-2/+6
| | | | | | | have to be truncated for database storage On balance, I still think this is useful because asset names and descriptions can sometimes be helpful in determining what things are. Even though they are never subsequently (inventory names/descriptions are always used instead).
* Consistently use using() to make sure we dispose of used MySqlCommands where ↵Justin Clark-Casey (justincc)2012-04-301-88/+92
| | | | this is not already being done.
* In the asset service, check that an asset exists before attempting to store it.Justin Clark-Casey (justincc)2011-08-171-2/+7
|
* Pull up Assembly of the MySQL classes as a protected property, so that it ↵Diva Canto2011-03-081-4/+6
| | | | can be overwritten in subclasses. That way extensions can decide in which assembly migration resources should be looked up. This is just a refactor -- no functional changes whatsoever.
* Re-enabled asset last access time logging in MySQLJohn Hurliman2010-09-111-3/+0
|
* MySQLAssetData.cs now supports asset_flags, CreatorIDAlexRa2010-05-191-5/+7
|
* Some more corrections after MySQL connector updateAlexRa2010-05-191-1/+2
|
* * Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto2010-05-091-2/+3
| | | | | | stored in regionsettings. Upon generation of a new tile image, the old one is deleted. Tested for SQLite and MySql standalone. * Fixed small bug with map search where the local sim regions weren't found.
* Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie2010-05-091-0/+18
| | | | asset deletion in robust handler.
* Add a field asset_flags and a corresponding enum to the asset database. ThisMelanie2010-05-091-3/+5
| | | | | | | CHANGES THE ASSET SERVER PROTOCOL and means you CAN NOT MIX PRIOR VERSIONS WITH LATER ONES. It may also eat your babies, yada, yada, yada. The usual cautions for migrations to the assets table apply. Coding: Can not guarantee nut free.
* Changed asset CreatorID to a stringJohn Hurliman2010-02-221-1/+1
|
* * Adds CreatorID to asset metadata. This is just the plumbing to support ↵John Hurliman2010-02-221-1/+1
| | | | CreatorID, it doesn't modify database backends or OAR files to support storing/loading it
* Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim2010-02-051-197/+158
| | | | This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
* Changing the AssetBase constructors to avoid initializing assets with an ↵John Hurliman2009-11-051-4/+1
| | | | unknown asset type, and log an error if it ever does happen
* Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman2009-11-021-47/+55
| | | | the grid server after running for several hours
* Changing Scene.ForEachClient to use the synchronous for loop instead of ↵John Hurliman2009-10-251-3/+0
| | | | | | | | | | Parallel. This is quite possibly the source of some deadlocking, and at the very least the synchronous version gives better stack traces * Lock the LLUDPClient RTO math * Add a helper function for backing off the RTO, and follow the optional advice in RFC 2988 to clear existing SRTT and RTTVAR values during a backoff * Removing the unused PrimitiveBaseShape.SculptImage parameter * Improved performance of SceneObjectPart instantiation * ZeroMesher now drops SculptData bytes like Meshmerizer, to allow the texture data to be GCed * Improved typecasting speed in MySQLLegacyRegionData.BuildShape() * Improved the instantiation of PrimitiveBaseShape
* * 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!