X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dakweb%2Fqueries%2Fsource.py;h=957cb0cc7c9169ae1189d672204c83c516ab8b04;hb=80108bebf0307acfc27d586e6faffe193199b14b;hp=d65283f60d1480e624606573a291e0af1be4c6e8;hpb=7db3402aa3615137ec7eb58bd3ba7ac662381d0f;p=dak.git diff --git a/dakweb/queries/source.py b/dakweb/queries/source.py old mode 100644 new mode 100755 index d65283f6..957cb0cc --- a/dakweb/queries/source.py +++ b/dakweb/queries/source.py @@ -1,4 +1,10 @@ -#!/usr/bin/python +""" Queries related to source packages + +@contact: Debian FTPMaster +@copyright: 2014 Mark Hymers +@copyright: 2014 Joerg Jaspert +@license: GNU General Public License version 2 or later +""" from sqlalchemy import or_ import bottle @@ -7,12 +13,28 @@ import json from daklib.dbconn import DBConn, DBSource, Suite, DSCFile, PoolFile from dakweb.webregister import QueryRegister + @bottle.route('/dsc_in_suite//') def dsc_in_suite(suite=None, source=None): """ Find all dsc files for a given source package name in a given suite. - suite and source must be supplied + @since: December 2014 + + @type suite: string + @param suite: Name of the suite. + @see: L{I{suites}} on how to receive a list of valid suites. + + @type source: string + @param source: Source package to query for. + + @rtype: list of dictionaries + @return: Dictionaries made out of + - version + - component + - filename + - filesize + - sha256sum """ if suite is None: return bottle.HTTPError(503, 'Suite not specified.') @@ -27,11 +49,74 @@ def dsc_in_suite(suite=None, source=None): q = q.filter(PoolFile.filename.endswith('.dsc')) ret = [] for p in q: - ret.append({'version': p.source.version, + ret.append({'version': p.source.version, 'component': p.poolfile.component.component_name, - 'filename': p.poolfile.filename}) + 'filename': p.poolfile.filename, + 'filesize': p.poolfile.filesize, + 'sha256sum': p.poolfile.sha256sum}) + + s.close() return json.dumps(ret) QueryRegister().register_path('/dsc_in_suite', dsc_in_suite) + +@bottle.route('/sources_in_suite/') +def sources_in_suite(suite=None): + """ + Returns all source packages and their versions in a given suite. + + @since: December 2014 + + @type suite: string + @param suite: Name of the suite. + @see: L{I{suites}} on how to receive a list of valid suites. + + @rtype: list of dictionaries + @return: Dictionaries made out of + - source + - version + """ + if suite is None: + return bottle.HTTPError(503, 'Suite not specified.') + + s = DBConn().session() + q = s.query(DBSource).join(Suite, DBSource.suites) + q = q.filter(or_(Suite.suite_name == suite, Suite.codename == suite)) + ret = [] + for p in q: + ret.append({'source': p.source, + 'version': p.version}) + + s.close() + + return json.dumps(ret) + +QueryRegister().register_path('/sources_in_suite', sources_in_suite) + + +@bottle.route('/all_sources') +def all_sources(): + """ + Returns all source packages and their versions known to the archive + (this includes NEW). + + @rtype: list of dictionaries + @return: Dictionaries made out of + - source + - version + """ + + s = DBConn().session() + q = s.query(DBSource) + ret = [] + for p in q: + ret.append({'source': p.source, + 'version': p.version}) + + s.close() + + return json.dumps(ret) + +QueryRegister().register_path('/all_sources', all_sources)