3 from sqlalchemy import or_
7 from daklib.dbconn import DBConn, DBSource, Suite, DSCFile, PoolFile
8 from dakweb.webregister import QueryRegister
10 @bottle.route('/dsc_in_suite/<suite>/<source>')
11 def dsc_in_suite(suite=None, source=None):
13 Find all dsc files for a given source package name in a given suite.
15 suite and source must be supplied
18 return bottle.HTTPError(503, 'Suite not specified.')
20 return bottle.HTTPError(503, 'Source package not specified.')
22 s = DBConn().session()
23 q = s.query(DSCFile).join(PoolFile)
24 q = q.join(DBSource).join(Suite, DBSource.suites)
25 q = q.filter(or_(Suite.suite_name == suite, Suite.codename == suite))
26 q = q.filter(DBSource.source == source)
27 q = q.filter(PoolFile.filename.endswith('.dsc'))
30 ret.append({'version': p.source.version,
31 'component': p.poolfile.component.component_name,
32 'filename': p.poolfile.filename})
34 return json.dumps(ret)
36 QueryRegister().register_path('/dsc_in_suite', dsc_in_suite)