biocore / biocore/microsetta-private-api
Vioscreen state transforms
- Dominant language
- Python
- Stars
- 6
- Forks
- 18
- PR merge metrics
- No merged PRs in 30d
Description
The raw vioscreen FFQ data come down from the Viocare API in structured JSON objects. Each aspect of the FFQ (food components, percent energy, etc) is structured somewhat differently. One of the key steps in the process of formally representing the FFQ data in the microsetta database is to transform these “raw” representations, into forms that are suitable for SQL table structures. This issue is scoped to cover the process of transforming these JSON objects into to-be-defined Model objects.
The specific models that should be created are:
- [ ] `VioscreenUser`
- [ ] `VioscreenSession`
- [ ] `VioscreenDietaryScores`
- [ ] `VioscreenFoodComponents`
- [ ] `VioscreenFoodConsumption`
- [ ] `VioscreenMPEDs`
- [ ] `VioscreenPercentEnergy`
- [ ] `VioscreenSupplements`
- [ ] `VioscreenEatingPatterns`
- [ ] `VioscreenFFQ` (a composite model reflecting the individual pieces)
Contributor guide
No contributing guide indexed for this repository
Research direction
The issue names no files, tests, or entry points. Start by locating the Viocare API raw JSON handling and the project's existing SQL model conventions, then map each listed representation to a model and define the composite VioscreenFFQ. Done means all listed models are specified and the raw objects can be represented in the database.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- backend, database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100