[Toaster] final Toaster database schema changes

[Damian, Alexandru]

Hi David,

This is correct, I will make these changes as soon as possible. In addition
to this, I have another very minor set of changes regarding list of files
in an image.

For image-total-size I would go with no 1, although no 3 is an option, if
anything else files.
What I plan now - searching for an easy way to do this. What I'm thinking
now - compute the actual sum of sizes for all files, since I'm gathering a
complete list of files anyhow. I'll see how that works.


Thank you for looking into this.

Alex


On Wed, Mar 5, 2014 at 11:11 PM, Reyna, David <david.reyna at windriver.com>wrote:

>  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
>
>



-- 
Alex Damian
Yocto Project
SSG / OTC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.yoctoproject.org/pipermail/toaster/attachments/20140306/7882c257/attachment.html>