[Toaster] final Toaster database schema changes

[Reyna, David]

Hi Alex,

As per our meeting this morning, there are two final schema changes we need, which I will summarize here for completeness.

1) "image-total-size field"

As per DaveL's email thread with you, he needs the image-total-size field for such calculations as "Size over total (%)". The old field ("Target. file_size") was replaced with the new Target_Image_File  table, but was incorrect in any case (as well as being empty) for this purpose.

It is our understanding that this value should be the sum of all of the packages included in the target (once we fix the missing cached package issue). We have three proposed solutions for providing this value:

  (a) Option 1 is to add an "image-total-size" field to the Target table, computed once at the data collection phase. While the data value does exist virtually in the database, this choice would save any re-computation later.

  (b) Option 2 is to always compute this value dynamically when the view is served. This would allow us to avoid an extra (perhaps redundant) table member, at the cost of repeated computation with each page serve.

  (c) Option 3 is to compute the value dynamically in the view if not yet defined, but then add it to the database so that subsequent lookups will be instant. This middle solution removes the computation time from the data collection phase and moves it to the view phase.

What is your choice?

2) "License Manifest file name"

As per our email thread, you are going to add this.

I think that this is all.
- David

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.yoctoproject.org/pipermail/toaster/attachments/20140305/d077d264/attachment.html>