[Qa-debsources] patch-tracker DB schema

[Orestis Ioannou]

Hello again :)

I am attaching a migration script that covers (i hope) what was
previously discussed  and another file that can serve as a first draft
for the json spec.

Here some thoughts as we

Looking at the policy I understood that the checksums in the .dsc are
included in the .changes. So i guess we will only parse that one right ?

Another thing i understood is that for source 3.0 packages there are
always 3 checksums:

- orig.tar.gz
- debian.tar.gz
- dsc

plus all the checksums of the debs. I covered in the spec the ability to
add the checksums of the debs as well although I am not entirely sure
they are needed. Well I am not sure how can anyone use them.

I felt that files is not really representative for an MD5 hash but if
you prefer files to be coherent with the .changes then i would change this.

I think an index on checksums would be useful. What do you think?

I thinks that's all :)

Cheers,

Orestis
-------------- next part --------------
A .changes file from the debian policy

Checksums-Sha1:
    1f418afaa01464e63cc1ee8a66a05f0848bd155c 1276 example_1.0-1.dsc
    a0ed1456fad61116f868b1855530dbe948e20f06 171602 example_1.0.orig.tar.gz
    5e86ecf0671e113b63388dac81dd8d00e00ef298 6137 example_1.0-1.debian.tar.gz
    71a0ff7da0faaf608481195f9cf30974b142c183 548402 example_1.0-1_i386.deb
Checksums-Sha256:
    ac9d57254f7e835bed299926fd51bf6f534597cc3fcc52db01c4bffedae81272 1276 example_1.0-1.dsc
    0d123be7f51e61c4bf15e5c492b484054be7e90f3081608a5517007bfb1fd128 171602 example_1.0.orig.tar.gz
    f54ae966a5f580571ae7d9ef5e1df0bd42d63e27cb505b27957351a495bc6288 6137 example_1.0-1.debian.tar.gz
    3bec05c03974fdecd11d020fc2e8250de8404867a8a2ce865160c250eb723664 548402 example_1.0-1_i386.deb
Files:
    4c31ab7bfc40d3cf49d7811987390357 1428 text extra example_1.0-1.dsc
    c6f698f19f2a2aa07dbb9bbda90a2754 571925 text extra example_1.0.orig.tar.gz
    938512f08422f3509ff36f125f5873ba 6220 text extra example_1.0-1.debian.tar.gz
    7c98fe853b3bbb47a00e5cd129b6cb56 703542 text extra example_1.0-1_i386.deb


Proposed informal json spec:

{
    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',
    },
    i386deb: {
        sha1: '71a0ff7da0faaf608481195f9cf30974b142c183',
        sha256': '3bec05c03974fdecd11d020fc2e8250de8404867a8a2ce865160c250eb723664',
        md5: '7c98fe853b3bbb47a00e5cd129b6cb56',
    },
}
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 011-to-012.sql
Type: application/sql
Size: 931 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/qa-debsources/attachments/20160319/07cff128/attachment.bin>