Database update triggers

From within the app, several action trigger a database update. This page gives an overview of all possible updates from withing the app and flowchart for navigation to obtain them.

For each flow chart the API call used is shown.

Read more about the database here

Overview

• As the user open the app an update is triggered after weather data has been fetched from the OpenWeatherMap API, which provides the user with the latest weather information, the information is stored in the weather table.
• If the user chooses to update any of the settings age, gender, height, weight or unit of measure the database table user will be updated.
• When the user chooses to send feedback about the app the information is added to the feedback table

Dashboard

Settings

If the user updates a personal setting from the Settings page.

Feedback

When the user submits feedback about the system.

Onboarding

When the user open the app for the first time he or she is prompter to provide their own physical parameters in order for the models to be individualized to their physical features.

Changes

When changing database structure or API remember the dependencies to the PHP API and the code of the devices using it.

Code:

• Database (on server)
• Java API string (and related classes that implement URL, any or all of these)
• PHP code (on server)
  • ClimAppAPI.php (create new version)
  • DbOperation.php

Documentation:

• Database
  • Generate new ER diagram and add in Database
• Database API
• Visio
  • API calls and parameters
• Database update triggers (this)