aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLInventoryData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2013-10-12Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira1-106/+106
* Added PostGreSQL support * Added MySQL/MySQLXGroupData.cs * PostgreSQL data access implementation * PostgreSQL dll binarie and RegionStore.migrations * Migrations Scripts from MSSQL to POSTGRES * Postgres SQL Type fixes * Postgres SQL Connection string * Data type issues * more fixes * tests and +tests * UUID x string - FIGHT! * Fixed PG types to internal csharp types * More data type fix (PostgreSQL fields are case sensitive) :( * more field case sensitive fixes * changed the migration files to be case sensitive for fields. * fixed fields case * finished converting, now search for hidden bugs. * some more fixes * bool type fixed * more case fixes; * creatorID case fixed * case fields fixed * fixed default now() for TMStamp fields with don't allow nulls. * fix case sensitve for Region name and Estate name * fixed case for names for search * fix class name Error * Bug fixed on select and migrations * Un-Reverting my change due to Postgres issue with the ILIKE function * Fixed some issued for Diva Distro * Fixes for integration with Diva Distro * Added System.Core to prebuild.xml for PG project * Configured to make DIff for Push to OpenSim Project * Diffs only to PostgreSQL mods.
2012-03-06Updates to MSSQL store for 0.7.3 to include:Chris Hart1-1/+1
* Telehub support * Bugfix to Friends lookups * Updates to Creator fields to store up to 255 characters for HG item creator storage
2010-05-23Further corrections to MS SQL stores (now passes all tests)AlexRa1-19/+32
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-21Apply http://opensimulator.org/mantis/view.php?id=4724Justin Clark-Casey (justincc)1-2/+2
Tweak to update appearance calls Fix for deleting inventory items from a folder. Thanks StrawberryFride!
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride1-103/+103
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman1-0/+2
the grid server after running for several hours
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-2/+0
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)
2009-10-01Formatting cleanup.Jeff Ames1-2/+2
2009-07-24* minor: spacing adjustment to retrigger pandaJustin Clarke Casey1-2/+1
2009-07-24* Extend mssql name string size checking to create/update folderJustin Clarke Casey1-3/+18
2009-07-24* Extend inventory name and description length checks to UpdateItem for mssqlJustin Clarke Casey1-2/+20
2009-07-24* Correct minor bug where item description bounded string was not actually ↵Justin Clarke Casey1-1/+2
being used in the previous patches.
2009-07-24* Apply http://opensimulator.org/mantis/view.php?id=3902Justin Clarke Casey1-2/+13
* Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-04-08* Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey1-13/+14
as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
2009-03-31Thank you, StrawberryFride, for a patch that adds offline inventoryMelanie Thielker1-2/+15
functionality to the MSSQL module. Fixes Mantis #3370
2009-03-23Committing partial work on passing folders across instances. This may crash.Melanie Thielker1-0/+5
2009-03-21Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker1-0/+5
MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
2009-03-09* Apply http://opensimulator.org/mantis/view.php?id=3280Justin Clarke Casey1-42/+43
* Some small syntax and refactoring tweaks for asset and inventory MSSQL * This means the MSSQL db plugin now requires SQL Server 2005
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-11/+11
* Changes varchar(36) columns to UUID type in MSSQL - this will be much more efficient * ===As always, please, please backup your database before applying this patch=== * Thanks Ruud Lathrop (for the patch) and StrawberryFride (for the review)
2009-02-12* optimized usings.lbsa711-1/+1
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-85/+2
2008-11-14Mantis #2618Melanie Thielker1-2/+4
Thank you, StrawberryFride, for a patch that adds group permission support to MSSQL. Contains a migration, back up your database.
2008-09-29* Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey1-4/+26
* Updated MSSQL to reflect resend changes * Added the new columns in prims table. * Created a implementation for getting gestures. * Remove configurable table names for user. * Thanks Ruud Lathorp
2008-09-24Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz1-0/+5
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.
2008-09-14Mantis #2124Melanie Thielker1-393/+425
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-24/+24
* 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.
2008-07-31Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur1-7/+13
PluginLoader. Fix issue 1871.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-187/+170
Many issues with handling connections in MSSQL, have rearchitected to ensure that connections are always opened and closed in a timely fashion & disposed of cleanly, and removed unnecessary lock statements. SQL Server performance seems to have improved considerably as a result, and various timeout errors seem to have been fixed.
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-5/+33
kerunix_Flan!
2008-06-06MSSQL Inventory Fix. Patch by Kyle and Chris from G2mingchen1-82/+89
2008-06-05Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke1-1/+1
I have detected a bug of conversion data type in OpenSim.Data.MSSQL.MSSQLInventoryData.addInventoryItem(InventoryItemBase item) in the GroupOwned field. My sollution is to change the flield to bit in the table. In the readInventoryItem(IDataReader reader) change too item.Flags = (uint) reader["flags"]; to item.Flags = Convert.ToUInt32(reader["flags"]); Now Inventory runs fine.
2008-05-28actually user the database_connect string for mysql. Sean Dague1-8/+0
This means you can run all the OpenSim grid services without needing a mysql_connection.ini
2008-05-16Formatting cleanup.Jeff Ames1-8/+8
2008-05-06De-tabify source.Jeff Ames1-7/+6
2008-05-01* In ur code. Making it static.Adam Frisby1-2/+2
* Converted a bunch of functions to static functions.
2008-04-30* Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey1-3/+23
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)
2008-04-23allow for Inventory database source to be specified in mainSean Dague1-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.
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-2/+3
(this took a while to run).
2008-04-08further refactor and rename of InventoryFolderBase propertiesSean Dague1-3/+3
to reflect what they really are.
2008-04-07more refactoring, this time on InventoryFolderBaseSean Dague1-25/+25
* wrap attributes in properties * clean up names a little bit * clean up name styles
2008-04-07Refactor InventoryItemBase to do the following:Sean Dague1-41/+41
* wrap fields as Properties * rename some fields/properties to more sensible names * set style to PropName to match more standard C# approach
2008-04-02fix ups to include OpenSim.Framework explicit includes (theySean Dague1-0/+1
were implicitly included before). Everything builds again. Now off to testing.
2008-04-02attempt to fix up all refernces to new directory structureSean Dague1-1/+1
2008-04-02whole lot more movingSean Dague1-0/+0
2008-03-28* Send full inventory folder skeleton to standalone client logins rather ↵Justin Clarke Casey1-6/+2
than just the root child folders * This may resolve some current problems with non root child folders on standalone installations. * A fix for the same problem in grid mode will come soon.
2008-03-28* fixed pk_violation on rename for MSSQLInventoryDatalbsa711-0/+6
("le fix le plus ugly for le problem trés dumb")
2008-03-18Formatting cleanup.Jeff Ames1-29/+27
2008-02-05Converted logging to use log4net.Jeff Ames1-16/+18
Changed LogBase to ConsoleBase, which handles console I/O. This is mostly an in-place conversion, so lots of refactoring can still be done.
2008-01-05Fix for typo in updateInventoryItem in MSSQLInventoryData.cs (thanks Grumly!)Brian McBee1-1/+1