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 [Wed, 19 Dec 2012 01:29:03 +0000 (17:29 -0800)]
CSPACE-5678: Updated Ant and Maven configs to no longer create and deploy artifacts that now get created and deployed by the new csmake tool from the App layer's configuration.
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.
Aron Roberts [Fri, 7 Dec 2012 02:41:46 +0000 (18:41 -0800)]
CSPACE-5727: Event listener now successfully acquires a list of related CollectionObject / Cataloging records and the computed current location for each. Added trivial method useful when debugging JDBC results to JDBCTools class.
Patrick Schmitz [Thu, 6 Dec 2012 20:17:48 +0000 (12:17 -0800)]
CSPACE-5375 Fixed typo that caused unequal relations to be seen as equal, precluding replacement. Removed related cruft left over from earlier refactoring.
Aron Roberts [Thu, 6 Dec 2012 04:02:05 +0000 (20:02 -0800)]
CSPACE-5727: Added resources directory for listener, to store database function to obtain computed current location. Added pseudocode and initial code to check for existence of this function.
Aron Roberts [Thu, 6 Dec 2012 02:27:23 +0000 (18:27 -0800)]
CSPACE-5727: Removing vestigates of attempt to install computeCurrentLocation function via 'ant create_nuxeo_db'. This likely won't work, because PostgreSQL checks for the existence of the tables (relations) in the function before creating or replacing the function, and when we run ant_create_nuxeo_db during build, those tables haven't necessarily been created.
Aron Roberts [Thu, 6 Dec 2012 00:33:00 +0000 (16:33 -0800)]
CSPACE-5727: Added resource directory for storing CollectionObject-related SQL code. Initial pass at pseudocode for updating the non-normalized lastIdentifiedLocation field in CollectionObject records via an event listener, using a SQL function to obtain the value to go into that field.
Aron Roberts [Tue, 4 Dec 2012 19:38:45 +0000 (11:38 -0800)]
CSPACE-5727: Initial directory structure for an 'update object location on move' event listener. Cloned from the 'delete relations on soft delete' event listener, and still needs updates in several files to reflect the new module/package name.
Aron Roberts [Mon, 3 Dec 2012 20:48:41 +0000 (12:48 -0800)]
CSPACE-4796: Remove post-init check that effectively blocked the default 'reader' database account in PostgreSQL from obtaining read-only access to extension schemas.