Restructure Data Storage - Githubissues

joomla / framework.joomla.org

Application powering the internet home of the Joomla! Framework

https://framework.joomla.org

GNU General Public License v2.0

37 stars 28 forks source link

Restructure Data Storage #15

Closed mbabker closed 7 years ago

mbabker commented 7 years ago

The data storage for the app right now is a bit "goofy"

#__packages database table which holds a list of all of the package releases
#__test_results database table which holds the unit testing report for each release tag
The packages.yml file in the repo which holds various metadata about the packages
Change deltas for test coverage as shown on the individual package pages and included in the package API responses are calculated on the fly

It's time to rethink this a bit. At a minimum...

#__packages should become a #__releases table
packages.yml should be loaded into the database as a new #__packages table
The #__test_results table can either be merged to the proposed #__releases table or kept standalone and the FKs updated
Change deltas should be calculated once and included in the database records

mbabker commented 7 years ago

Data storage refactored. packages.yml at this point basically lets us manage that content from this repo and we can run a CLI script to sync it to the database. #__packages table represents that data. #__releases table has all the release metrics. Change deltas are inexpensive to calculate so left that in the models to handle.