[Qa-debsources] patch-tracker DB schema

[Orestis Ioannou]

> On Mar 12, 2016, at 10:36, Stefano Zacchiroli <zack at debian.org> wrote:
> 
>> On Sat, Mar 12, 2016 at 10:15:06AM +0100, Orestis Ioannou wrote:
>>> On 03/12/2016 09:48 AM, Stefano Zacchiroli wrote:
>>> Finally, don't we need an extra "order" column here? Otherwise how do we
>>> know the order in which patches are applied? (*Some* source package
>>> formats forces an alphabetical ordering---which maintainers then build
>>> upon using 00, 01, 02, etc---but not *all* of them do.)
>> 
>> I was thinking reading the file series to do that on each request like
>> what we do now. But if you prefer adding that info in the DB then yeap
>> we need that column as well.
> 
> Yeah, I think that (= having the info in the DB) would be better and
> also cleaner. That way we will have all the patch metadata in the DB,
> and we will need to access the actual patch files only to render their
> content. And all the parsing will be done at update time.

We will still need to parse each patch to extract the subject, the file deltas, big numbers etc when we present the summary table of each package.