open-humans icon indicating copy to clipboard operation
open-humans copied to clipboard

Make DataRequestProject.request_sources_access array of self-referential foreign keys

Open mldulaney opened this issue 6 years ago • 1 comments

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

mldulaney avatar Jan 25 '19 23:01 mldulaney

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.

mldulaney avatar Jan 25 '19 23:01 mldulaney