Package: dgit
Version: 0.17~exerimental4

dgit by default ssh's to coccia and runs sql runes directly against
the ftpmaster database, to obtain information it needs.  (This
information should be available by some kind of public but secure
service with a reasonable interface, but this is not true right now.)

The database queries, at the time of writing, are these:

        SELECT suite.codename
          FROM suite where suite_name='$isuite' or codename='$isuite';

        SELECT source.version, component.name, files.filename
          FROM source
          JOIN src_associations ON source.id = src_associations.source
          JOIN suite ON suite.id = src_associations.suite
          JOIN dsc_files ON dsc_files.source = source.id
          JOIN files_archive_map ON files_archive_map.file_id = dsc_files.file
          JOIN component ON component.id = files_archive_map.component_id
          JOIN files ON files.id = dsc_files.file
         WHERE ( suite.suite_name='$isuite' OR suite.codename='$isuite' )
           AND source.source='$package'
           AND files.filename LIKE '%.dsc';

(This bug is new in 0.17~experimental4.)

Ian.


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to