Patrick Schmitz [Mon, 14 Jan 2013 19:57:41 +0000 (11:57 -0800)]
CSPACE-5740 Added support to turn off starting Wildcard behavior for partial Tern matching (authority auto-complete). Added a section to lifesci tenant delta (commented out) that shows how to enable this new behavior. Note that current default behavior is unchanged.
Patrick Schmitz [Mon, 14 Jan 2013 17:27:07 +0000 (09:27 -0800)]
CSPACE-5771 Allow admins to mark a tenant to be createdDisabled. This minimizes resources devoted to the tenant, and it will remain disabled until this setting is altered and the system restarted (the webapp reloaded). Permissions are created, as this cannot currently be done incrementally.
Aron Roberts [Sat, 12 Jan 2013 01:34:46 +0000 (17:34 -0800)]
CSPACE-5728: Revert change to AbstractMultiPartCollectionSpaceResourceImpl.java; despite NetBeans IDE warning about not finding method signature in this case (perhaps due to JAX-RS annotations?) in ResourceBase, current call compiles and runs fine. Comment out 'no context' test group in XmlReplay-based tests of the batch job; see warning comment on top of that test group for the limited circumstances in which that test group should be run.
Aron Roberts [Sat, 12 Jan 2013 00:25:13 +0000 (16:25 -0800)]
CSPACE-5728: Refactoring to make it easier to override and extend, via subclasses, the updating of values in CollectionObject records, from values retrieved from the most recent Movement record.
Aron Roberts [Fri, 11 Jan 2013 04:03:00 +0000 (20:03 -0800)]
CSPACE-5728: UpdateObjectLocationBatchJob now supports a 'no context' invocation mode, which updates the computed current location value in all active CollectionObject records.
Aron Roberts [Thu, 10 Jan 2013 00:23:26 +0000 (16:23 -0800)]
CSPACE-5728: Added single- and list-mode batch tests to XmlReplay master, at least for now. Added convenience methods to get list CSIDs and parameters from the batch invocation context.
Aron Roberts [Wed, 9 Jan 2013 23:39:10 +0000 (15:39 -0800)]
CSPACE-5728: Initial steps toward supporting list-mode invocation of the batch job to update computedCurrentLocation values. List CSIDs aren't currently appearing in the invocation context; to be investigated.
Aron Roberts [Wed, 9 Jan 2013 21:29:22 +0000 (13:29 -0800)]
CSPACE-5728: De-duplicate related Movement records being processed to find computed current location, regardless of the directionality of their relations. Lots of miscellaneous cleanup.
Aron Roberts [Wed, 9 Jan 2013 20:20:03 +0000 (12:20 -0800)]
CSPACE-5728: First successful top-to-bottom run of the single CSID batch job to update computed current location. Uses JDOM, not dom4j, to get field value. XmlReplay test validation is also now more strict.
Aron Roberts [Tue, 8 Jan 2013 22:45:20 +0000 (14:45 -0800)]
CSPACE-5728: Add test for reverse direction of Movement-CollectionObject relation. One test commented out, as it requires an upcoming code change to support this direction.
Aron Roberts [Tue, 8 Jan 2013 22:31:28 +0000 (14:31 -0800)]
CSPACE-5728: Updated XmlReplay-based tests to verify that correct computedCurrentLocation value is present in CollectionObject record, following invocation of batch job.
Aron Roberts [Tue, 8 Jan 2013 20:58:47 +0000 (12:58 -0800)]
CSPACE-5728: Tests now successfully create related records. First pass at obtaining the computed current location value from the related Movement record with the most recent location date; as yet untested.
Aron Roberts [Fri, 4 Jan 2013 23:00:44 +0000 (15:00 -0800)]
CSPACE-5728: Added abstract class on top of batch invocable interface, based largely on Ray's work in creating such a class for the UC Berkeley Botanical Garden implementation.
Aron Roberts [Thu, 3 Jan 2013 21:10:39 +0000 (13:10 -0800)]
CSPACE-5765: Remove misleading comment. Currently, we can't safely drop the id_generators table on each system startup, because that would lose state information about the last ID generated by each ID Generator.
Patrick Schmitz [Thu, 20 Dec 2012 23:30:07 +0000 (15:30 -0800)]
CSPACE-5782 Replace DataSource getConnection with DriverManager.getConnection(), since former uses connection pool and so does not reflect changes to setUrl.
Richard Millet [Fri, 14 Dec 2012 20:18:04 +0000 (12:18 -0800)]
CSPACE-4979: Move method getDatabaseName() which returns the database name for a given tenant bindings repo domain from ConfigUtils to JDBCTools class.
Patrick Schmitz [Fri, 14 Dec 2012 19:33:40 +0000 (11:33 -0800)]
CSPACE-5761 Added support to create databases as needed for repos on init. Sets up users, etc. Tested on Postgres, NOT TESTED on MySQL (but draws on the commands from the existing sql scripts, so should work).
Aron Roberts [Fri, 14 Dec 2012 01:49:04 +0000 (17:49 -0800)]
CSPACE-5727: Further steps to make this event listener/handler more easily extensible for implementers who just want to set additional field values, like a movable storage location (crate) value.
Patrick Schmitz [Thu, 13 Dec 2012 20:23:39 +0000 (12:23 -0800)]
CSPACE-5657 Completed work on auth and AuthZImport work to handle new perms, roles, associations, etc. Special cased the assignment of tenants to the tenantManager, so it only sits in (pseudo)tenant 0. Web service and perms work now. Need to develop regression tests, and the new web app that provides a UI on this. Also need to consider getting the tenantManager password from the environment, when building it. In any case, need to be able to update the password.
Aron Roberts [Thu, 13 Dec 2012 01:40:38 +0000 (17:40 -0800)]
CSPACE-5727: Refactored into abstract and implementation methods for easier extensibility; e.g. for updating moveable locations (crates or equivalent) for some implementers.
Aron Roberts [Wed, 12 Dec 2012 21:49:19 +0000 (13:49 -0800)]
CSPACE-5727: Basic Movement record changes are working again, after adding handling of relation record events. Relation addition is also working to update computed current locations, but relation deletion (via the UI) is not.
Aron Roberts [Wed, 12 Dec 2012 19:26:11 +0000 (11:26 -0800)]
CSPACE-5727: First pass at integrating events pertaining to Relation records into the event handler that updates computed current locations. (This code is not yet tested.)
Aron Roberts [Wed, 12 Dec 2012 02:37:09 +0000 (18:37 -0800)]
CSPACE-5727: Current locations for CollectionObjects are now also re-computed when the lifecycle state of related Movement records are transitioned in any manner, including to/from the 'soft deleted' state.
Aron Roberts [Wed, 12 Dec 2012 01:45:29 +0000 (17:45 -0800)]
CSPACE-5727: Cleaned up comments throughout. Log a success message indicating how many CollectionObject records had their computed current locations updated.
Aron Roberts [Wed, 12 Dec 2012 01:24:21 +0000 (17:24 -0800)]
CSPACE-5727: Get the computed current location from all relevant CollectionObject/Movement relations, whether the CollectionObject and Movement are, respectively, the subject or object of those relations.
Aron Roberts [Wed, 12 Dec 2012 00:01:11 +0000 (16:01 -0800)]
CSPACE-5727: First fully working version, using NXQL query and post-processing of returned Relation records to get current location. SQL queries, whether invoking a stored function or simply executing the same query directly, don't yet see the current state of the database when the event handler is invoked, so can't see the updated location date on a just-updated and saved Movement record.
Aron Roberts [Sat, 8 Dec 2012 01:48:29 +0000 (17:48 -0800)]
CSPACE-5727: Split off loop to update each CollectionObject requiring updating, following the check for records that require such updates. Inserted additional debug statements based on suggestions from Richard and Ray to track down an issue where the stored function is returning a stale value when run via JDBC from within the event listener; this value is only updated on a subsequent update of any kind to a relevant movement record.
Patrick Schmitz [Fri, 7 Dec 2012 18:22:22 +0000 (10:22 -0800)]
CSPACE-5657 Added support in DB and services for disabled tenants. This is first step, but works as far as it goes. Only control is directly through DB. To upgrade existing tenants, must just add a boolean column to the tenants table in cspace DB. See delta on the account.sql for the specifics.