aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLInventoryData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim2010-02-051-511/+336
| | | | This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
* * Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master2010-02-051-2/+2
| | | | properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null
* Formatting cleanup. Add copyright headers.Jeff Ames2010-01-041-3/+3
|
* Prevent the creation of duplicate inventory folders in the case of a loginMelanie2010-01-011-1/+1
| | | | database issue. Now the login will instaead fail later.
* * Implements OSSL function: osGetSimulatorMemory - returns the current ↵Adam Frisby2009-12-131-0/+3
| | | | | | | | amount of memory allocated to the simulator process (Moderate Threat Level). * Cleans redundant information out of the Simulator Version. Versions now look like: "OpenSimulator 0.6.9(dev) Unix/Mono" * [Minor] additional log info for MySQLInventoryData
* * Implements SQL Rollback support to Inventory Service for quicker backup ↵Adam Frisby2009-11-231-0/+154
| | | | | | | | | | restoration. * Can optionally replace the OpenGridMode committed earlier. * Will create a series of incrementing restore SQL files, one per user, in folders listed per-day. * For MySql Section of InventoryService INI: rollback = "true" rollbackdir = "/absolute/path/to/rollback/storage/dir"
* * Adds a modicum of additional checking to the Inventory Service (MySQL only)Adam Frisby2009-11-231-5/+22
| | | | | * Enable "opengridmode=true" in your Inventory Connector (where the mysql connection strings are) to enable if you are running a 'wide-open-grid'. * More comprehensive rollback support being implemented, should be available later today.
* Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman2009-11-021-166/+169
| | | | the grid server after running for several hours
* * MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman2009-10-041-169/+166
| | | | | | 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-6/+6
|
* Add copyright headers. Formatting cleanup. Fix a compiler warning.Jeff Ames2009-08-171-1/+1
|
* * Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis2009-08-161-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
* Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis2009-08-161-5/+6
|
* * Apply asset and inventory name and description bound checks to MySQLJustin Clarke Casey2009-07-241-3/+24
|
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-011-1/+1
| | | | LICENSE.txt.
* now that creatorID is no longer a strict UUID, and the column can still be NULL,Sean Dague2009-05-081-1/+10
| | | | | | we lost protection from NULL strings. This puts some protection in for that case. This may address many of the inventory issues that are being seen intermitently.
* * Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey2009-04-081-7/+5
| | | | | | | | | as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
* Committing partial work on passing folders across instances. This may crash.Melanie Thielker2009-03-231-0/+5
|
* MYSQL Only: Make items given while offline appear in inventory withoutMelanie Thielker2009-03-221-0/+9
| | | | | | the need to clear cache.
* Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker2009-03-211-0/+5
| | | | | | | MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
* * optimized usings.lbsa712009-02-121-1/+1
|
* Add group permissions to agent inventory.Melanie Thielker2008-11-141-2/+4
| | | | | | | | | | Contains a migration. May contain nuts. Please back up your inventory data store. This revision changes the interface version!! No older regions can connect to these new UGAIM, and the new regions can't connect to the old UGAIM. Fixes a long-standing issue of permissions loss Currently persisted on MySQL only.
* make inventory item listing more robust. It turns out that a bad itemSean Dague2008-11-131-8/+28
| | | | | | | | | | | | | (one that won't parse right) will prevent all other items in that folder to load when inventory is requested. This is very careful to no longer add inventory items that return as null to the hash table for getInventoryInFolder, as well as be more careful parsing UUIDs for fields that aren't marked not null in MySQL. The net result, you may see previously missing inventory items return after this checkin. Folders probably need to be hardened in the same way, but I'm out of time for today.
* Update svn properties. Minor formatting cleanup. Fix a compiler warning. ↵Jeff Ames2008-09-281-2/+2
| | | | Fix a UUID vs null comparison.
* Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz2008-09-241-0/+36
| | | | | | | | | Active gestures are sent as part of the login-response. Added fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and NHibernate. Using the empty ones won't cause errors, but doesn't provide persistence either, of course.
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-061-27/+27
| | | | | | | * 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 pre-Migration upgrade pathsSean Dague2008-08-271-92/+0
|
* Formatting cleanup.Jeff Ames2008-08-181-9/+9
|
* Minor formatting cleanup.Jeff Ames2008-08-121-1/+1
|
* Mantis#1903. Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-08-101-5/+108
| | | | | | | | | patch attached replaces the tree walk algorithm used to build the folder hierarchy with a single database query. That is, we replace 1 database query per folder with 1 query for the root folder's properties and 1 query to retrieve the entire collection of folders for a user.
* Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur2008-07-311-7/+13
| | | | | | PluginLoader. Fix issue 1871.
* Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-07-031-0/+24
| | | | | | | 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.
* Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames2008-06-261-17/+40
| | | | kerunix_Flan!
* Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames2008-06-261-2/+29
| | | | files. Thanks kerunix_Flan!
* Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames2008-06-131-1/+1
| | | | hard-coded port numbers.
* Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague2008-06-121-1/+1
| | | | | | | | | and no schema. It should also work with a non up to date schema as well. Btw, meetings in which I can get code done are the right kind of meetings.
* this, in theory, adds migration support to mysql for all Sean Dague2008-06-121-4/+30
| | | | | | | | data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
* Update svn properties. Formatting cleanup.Jeff Ames2008-05-301-1/+1
|
* actually user the database_connect string for mysql. Sean Dague2008-05-281-20/+19
| | | | | | | This means you can run all the OpenSim grid services without needing a mysql_connection.ini
* Formatting cleanup.Jeff Ames2008-05-161-12/+12
|
* De-tabify source.Jeff Ames2008-05-061-1/+1
|
* * Refactor: Remove the unused userID parameter that was being passed into ↵Justin Clarke Casey2008-05-011-56/+7
| | | | | | | | almost every inventory method * This allows lots of redundant inventory methods with only slightly different names to be eliminated.
* * In ur code. Making it static.Adam Frisby2008-05-011-2/+2
| | | | | * Converted a bunch of functions to static functions.
* * Add more class cast exceptions to mysql read inventory item to cover all ↵Justin Clarke Casey2008-05-011-3/+26
| | | | | | | | new fields - not just those I think are initially failing. * This is more likely to allow existing mysql databases to work temporarily, if the previous revision doesn't work
* * Insert temporary cast exception catching code to deal with mantis 1099 - ↵Justin Clarke Casey2008-05-011-3/+29
| | | | mysql inventoryitems table problem
* * Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey2008-04-301-4/+8
| | | | | | | | | database adapter * I don't use mssql so this may not work, corrections (in the form of patches) are welcome. * Unlike mysql, mssql requires manual updating of existing tables here (which should mean just adding the new fields manually)
* * Actually enable the inventory upgrade sql if appropriateJustin Clarke Casey2008-04-301-6/+7
|
* * Long awaited patch from A_Biondi Mantis 923. Kept alive by Melanie. ↵Teravus Ovares2008-04-301-4/+17
| | | | | | | Thanks A_Biondi and Melanie! * This builds but might not work. JustinCC will examine.. it may work out of the box.
* allow for Inventory database source to be specified in mainSean Dague2008-04-231-0/+6
| | | | | | | | configs. This works with sqlite and nhibernate backends, and stays with default seperate ini files for mysql and mssql until someone writes those.
* * Implement proper emptying of trashcan on standaloneJustin Clarke Casey2008-04-231-1/+1
| | | | | | | * On standalone, folders (and their items) should now be persistently deleted on trash emptying, as well as immediate child items * An implementation for grid mode will follow.