OpenHumans / open-humans

Powering openhumans.org
https://www.openhumans.org/
MIT License
73 stars 22 forks source link

Make DataRequestProject.request_sources_access array of self-referential foreign keys #964

Open mldulaney opened 5 years ago

mldulaney commented 5 years ago

General Checkups

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 commented 5 years ago

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.