Sage-Bionetworks/Synapse-Repository-Services — pull request #120 by eric-wu (2012-09-19 13:05:51+00:00)
Title: DAO for querying storage usage.

1) Note that this is a release patch. So first of all it includes modifications on DELETE to avoid deadlocks. This change was meant to be an minor improvement. But I noticed today that the data migrator has been running much slower due to deadlocks on insertions into the new storage_location table. There were already deadlocks on the string annotations table. Now it is getting much worse with more deadlocks on the storage location table. The data migrator has been running for 9 hours only 20% done. This prompts me to peel off the changes associated with StorageLocationDAOImpl into a release patch.

2) Storage DTOs get more consistent names. A new DTO StorageLocationDimensionValue to capture the name-value pair as suggested by your last review. Remove one storage usage DTO that is not going to be used.

3) Implement StorageLocationDAO for 3 queries of storage usage.

The remaining part of this feature implementation (i.e. controller/service/manager) will be in a separate change list on the develop branch.