Add loading tests which will require user input
The loading process has several things which can go wrong, notably the user has provided data which is not already in the database. To help maintain database integrity we need to inform the user of these data, and allow them to make the decision of how to process them going forward. This feature will design the tests and interface for the user to respond to these features.
Blueprint information
- Status:
- Started
- Approver:
- None
- Priority:
- Medium
- Drafter:
- Neil Davis
- Direction:
- Approved
- Assignee:
- Neil Davis
- Definition:
- Approved
- Series goal:
- None
- Implementation:
- Started
- Milestone target:
- None
- Started by
- Neil Davis
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Step 1 is to identify the tests which need to be added.
1 Spatial Grid is not in database
2 Temporal Grid is not in database
3 Temporal Metric does not match a value already in the database
4 Spatial Locations do not all match with those already in database
5 Temporal locations do not all match those already in database
6 Variables do not match those already in the database
7 ?? Similar project name already exists in the database
Step 2 Revamp the loading structure
1 Load data into temporary tables & try to add data to data tables, throwing checking the tests listed in step 1. If any of these tests fail, create failure report which includes names of the temporary tables where the data resides, and which tests failed. (Should we load the data which can be loaded?
2 Create interface for the user to address the tests which failed. (needs to provide sane default values)
3 Create interface to complete loading of the data and remove the temporary tables