open-humans
open-humans copied to clipboard
Make DataRequestProject.request_sources_access array of self-referential foreign keys
General Checkups
- [*] Have you checked that there isn't already an existing issue that describes what you report below?
- [*] Have you checked that there isn't already an open pull requests for this issue/update/change?
Description
Currently, request_sources_access is an array of charfields. By making this an array of foreignkey(DataRequestProject), we can simplify both populating this array throughout and also then use pure ORM queries against it.
This requires the following steps: Change model Make changes to python files make (two) changes to html templates
Related Issue(s)
This blocks #782
This will also require asome sort of custom sql to go through all instances of DataRequestProject and DataRequestProjectMember to replace strings with the foreign key references.