[Qa-debsources] patch-tracker DB schema

[Stefano Zacchiroli]

On Thu, Apr 14, 2016 at 11:27:04PM +0200, Orestis Ioannou wrote:
> >> {
> >>     orig.tar.gz: {
> >>         sha1: 'a0ed1456fad61116f868b1855530dbe948e20f06',
> >>         sha256: '0d123be7f51e61c4bf15e5c492b484054be7e90f3081608a5517007bfb1fd128',
> >>         md5: 'c6f698f19f2a2aa07dbb9bbda90a2754',
> >>     },
> >>     debian.tar.gz: {
> >>         sha1: '5e86ecf0671e113b63388dac81dd8d00e00ef298',
> >>         sha256': 'f54ae966a5f580571ae7d9ef5e1df0bd42d63e27cb505b27957351a495bc6288',
> >>         md5: '938512f08422f3509ff36f125f5873ba',
> >>     },
> >>     dsc: {
> >>         sha1: '1f418afaa01464e63cc1ee8a66a05f0848bd155c',
> >>         sha256': 'ac9d57254f7e835bed299926fd51bf6f534597cc3fcc52db01c4bffedae81272',
> >>         md5: '4c31ab7bfc40d3cf49d7811987390357',
> >>     },
> > 
> > As per my comment above, we need to keep open the possibility of having
> > more top-level entries here, but that shouldn't be a problem, as it's a
> > dictionary and the file names are not supposed to collide. OTOH we might
> > want to had an extra field to the inner dictionaries to easily find out
> > which files are the dsc, which the debian tarball, and which form the
> > multiple orig tarballs.
> 
> I don't undestand the extra field you suggest. Maybe an example would do
> it but i can't see what you are trying to explain me :)

Sure:

 {
     orig-foo.tar.gz: {
         sha1: 'a0ed1456fad61116f868b1855530dbe948e20f06',
         sha256: '0d123be7f51e61c4bf15e5c492b484054be7e90f3081608a5517007bfb1fd128',
         md5: 'c6f698f19f2a2aa07dbb9bbda90a2754',
         type: 'orig',
     },
     orig-bar.tar.gz: {
         sha1: 'a0ed1456fad611deadbeef855530dbe948e20f06',
         sha256: '0d123be7f51e61c4bf1deadbeef484054be7e90f3081608a5517007bfb1fd128',
         md5: 'c6f698f1deadbeef7dbb9bbda90a2754',
         type: 'orig',
     },
     debian.tar.gz: {
         sha1: '5e86ecf0671e113b63388dac81dd8d00e00ef298',
         sha256': 'f54ae966a5f580571ae7d9ef5e1df0bd42d63e27cb505b27957351a495bc6288',
         md5: '938512f08422f3509ff36f125f5873ba',
         type: 'debian',
     },
     dsc: {
         sha1: '1f418afaa01464e63cc1ee8a66a05f0848bd155c',
         sha256': 'ac9d57254f7e835bed299926fd51bf6f534597cc3fcc52db01c4bffedae81272',
         md5: '4c31ab7bfc40d3cf49d7811987390357',
         type: 'dsc',
     },

I don't like "type" much, as it's very generic. The right name would
probably be something like "component_type", but it's very long. Take
your pick :)

-- 
Stefano Zacchiroli  . . . . . . .  zack at upsilon.cc . . . . o . . . o . o
Maître de conférences . . . . . http://upsilon.cc/zack . . . o . . . o o
Former Debian Project Leader . . . . . @zacchiro . . . . o o o . . . o .
« the first rule of tautology club is the first rule of tautology club »
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/qa-debsources/attachments/20160415/f712adac/attachment.sig>