aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey2008-11-101-4/+3
| | | | | | | | RootPart and adding the part separately * Make RootPart read only
* Work in progress on SECS stuff. Have been holding it off until after 0.6 ↵Tedd Hansen2008-11-081-2/+2
| | | | release. Still messy as hell and doesn't really work yet. Will undergo dramatic changes. AND MOST IMPORTANTLY: Will be conformed to work in coop with todays DNE and XEngine, hopefully one day providing a common interface for all components.
* add some null protection on emailSean Dague2008-11-041-1/+2
| | | | | From: Sean Dague <sdague@gmail.com>
* implement email field for MySQL and SQLiteSean Dague2008-11-042-0/+8
| | | | | From: Sean Dague <sdague@gmail.com>
* Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz2008-11-011-1/+21
| | | | | | | | | | | | | | on-/offline updates, calling cards for friends. This adds methods in the DB layer and changes the MessagingServer, so a full update (incl. UGAIM) is necessary to get it working. Older regions shouldn't break, nor should older UGAIM break newer regions, but friends/presence will only work with all concerned parts (UGAIM, source region and destination region) at this revision (or later). I added the DB code for MSSQL, too, but couldn't test that. BEWARE: May contain bugs.
* - Includes consistency test for new and updated objects, asSean Dague2008-10-301-13/+4
| | | | | | | some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Mid-work, trying to fix region part insertion and retrievalSean Dague2008-10-301-8/+34
| | | | | | | | SQLite reports System NUll Reference, but works, inside LoadItems, on SQLiteRegionData.cs From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2008-10-182-0/+13
| | | | | | | | Add rezzing time to objects. Add Object return and traffic fields to land database. Add plumbing for auto return. Implement auto return. Contains a migration. May contain nuts.
* Update svn properties, minor formatting cleanup.Jeff Ames2008-10-171-2/+2
|
* - Enforced no user or agent with UUID 0 on agent DB insertionSean Dague2008-10-161-0/+4
|
* - Makes MySQL reject inserting UUID 0Sean Dague2008-10-151-0/+35
| | | | | | | | | | - Makes SQLite mimick MySQL default behavior on first and last name already on db: it does not insert the new record. - Added tests for UUID 0 and for new UUID with existing first and last name.
* move from index based to exists strategy hereSean Dague2008-10-141-10/+36
|
* Merge commit 'arthur/master'Sean Dague2008-10-141-4/+10
|
* Add the missing bits for the new region-search:Homer Horwitz2008-10-031-0/+12
| | | | | | | | | | | | | | | | - Added lookup in the data-layer - MySQL works - SQLite doesn't have a grid-db, so it won't work there - I added MSSQL-code to the best of my knowledge; but I don't know MSSQL :-) - Added the plumbing up to OGS1GridServices. This speaks with the grid-server via XMLRPC. - Modified MapSearchModule to use the new data. It's backward compatible; if used with an old grid-server, it just returns one found region instead of a list. - Refactored a bit. Note: This updates data, grid-server and region code. No new files.
* fix the sqlite break. There were two issue here:Sean Dague2008-10-031-1/+2
| | | | | | | | | | | 1. type issues on column create in ado.net 2. not setting a field in the ado.net row translates into explicitely setting it to null in sqlite land (because it can't read the defaults stanzas out of the database) Things should work again after this.
* Add database persistence for material settingMelanie Thielker2008-10-032-0/+11
|
* add delete prim tests. Found and fixed bugs where regionSean Dague2008-10-011-1/+1
| | | | | | | | is not respected by sqlite or mysql drivers so that deleting and object in a region actually deletes that object from any region.
* add a test for updating region settings and fix a bug in uuidSean Dague2008-09-291-1/+1
| | | | | | translation in sqlite uncovered by this test.
* * Patch from JHurlimanTeravus Ovares2008-09-262-11/+11
| | | | | | | | | * Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
* Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz2008-09-241-0/+19
| | | | | | | | | 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.
* remove a bunch of out of date inline ALTER table commands that would onlySean Dague2008-09-241-84/+17
| | | | | | confuse people.
* couple of minor test cleanups to see if this gets us past the bamboo humpSean Dague2008-09-231-8/+0
|
* Small formatting cleanup, before chi11ken notices. Me bad.Homer Horwitz2008-09-193-20/+39
|
* convert to using proper .net tempfiles, should have done thisSean Dague2008-09-194-4/+13
| | | | | | initially.
* Add a db.Dispose before calling Delete on the SQLite database.Homer Horwitz2008-09-184-1/+5
| | | | | | | On Windows, you are not able to delete a file while there is still a handle to it open.
* - Add Dispose method to IRegionDataStoreHomer Horwitz2008-09-184-10/+97
| | | | | | | | - Add necessary dummy Dispose-methods where they are missing - Implement the SQLite Dispose-methods (currently only used for unit tests, in the next commit)
* * Updates the SQLite region database to support the same properties that the ↵Teravus Ovares2008-09-182-0/+180
| | | | | | | MySQL version does for the table, prims. * If this causes any unit tests to fail, the tests need to be updated.
* Adding currentLookAt to useragents table in SQLite. This complements theHomer Horwitz2008-09-172-0/+15
| | | | | | MySQL change from http://opensimulator.org/mantis/view.php?id=2073
* Added some terrain tests, and found a fun race condition in the sqliteSean Dague2008-09-162-16/+16
| | | | | | terrain driver in the process, which is now fixed. yay for unit tests!
* Mantis #904: Thanks jonc, for a patch that adds "useragents" table toHomer Horwitz2008-09-162-67/+84
| | | | | | | SQLite and stores the logout position in standalone mode. Note: This adds a migration for SQLite, so do your runprebuild
* Update svn properties, minor formatting cleanup, fix a compiler warning.Jeff Ames2008-09-151-3/+6
|
* Mantis #2124Melanie Thielker2008-09-141-0/+19
| | | | | | | Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
* * Adds regiondata and estatedata persistence in Sqlite. This commit is ↵Teravus Ovares2008-09-131-0/+3
| | | | actually an assist. 99% of the work was already done by Melanie.
* Formatting cleanup.Jeff Ames2008-09-131-1/+1
|
* * Fixes SQLite load crash. Teravus Ovares2008-09-131-2/+3
| | | | | | | * added primary key to regionsettings table in the cached table * initialized the data adapter. * Still untested fully, so watch out!
* Add region settings support to SQLite (untested!)Melanie Thielker2008-09-131-1/+183
|
* wrap log4net configure in try block so that it will run if you don't have aSean Dague2008-09-131-1/+5
| | | | | | | | .config (which no one does). Dropping in the .config lets you see that debug messages, which is handy while writing tests and figuring out why things don't behave like you would guess.
* 2 more InventoryItem tests, plus see if I can leave the log4netSean Dague2008-09-131-0/+2
| | | | | | configure in there to help me get debug messages while developing.
* * Patch http://opensimulator.org/mantis/view.php?id=2163Justin Clarke Casey2008-09-122-0/+12
| | | | | | | | * Add prim ClickAction persistence to SQLite * This will require a prebuild * Thanks nlin!
* move the actual [Test] methods for databases to OpenSim.Data.TestsSean Dague2008-09-123-167/+9
| | | | | | | classes. This did mean loosing 1 unit test that was actually testing an sqlite function directly instead of the interface.
* be more clever and move the bulk of the db tests for inventory intoSean Dague2008-09-121-140/+3
| | | | | | | | | | | OpenSim.Data.Tests, then subclass with custom init bits for sqlite. As I've only been testing the plugin interfaces anyway, this should make it very easy to write only a little bit of code to use these tests for other databases. It will also give us the framework for definining the datastore behavior and making sure that all the databases do the same thing.
* more inventory folder testsSean Dague2008-09-111-10/+55
|
* add some folder create and list testsSean Dague2008-09-111-1/+40
|
* added simple add / exists folder checkSean Dague2008-09-111-0/+41
|
* add a few more SQLite Asset tests.Sean Dague2008-09-111-3/+31
|
* added very basic stubs for User and Inventory db creates and emptySean Dague2008-09-102-0/+146
| | | | | | calls to make sure they worked
* fix typo in name of test dbSean Dague2008-09-101-1/+1
|
* add basic sniff tests for SQLite Asset store. Initializes a db,Sean Dague2008-09-101-0/+91
| | | | | | | | stores an asset, fetches that asset, make sure it has the name we gave it. All simple stuff, but should catch the more egregious breaks.
* add a simple update attribute test for SOG & SQLiteSean Dague2008-09-101-2/+22
|
* added in a few more testsSean Dague2008-09-101-6/+40
|