sql = """SELECT DISTINCT(b.package), b.version, c.name, su.suite_name
FROM binaries b, files fi, location l, component c, bin_associations ba, suite su
- WHERE b.package=:package
+ WHERE b.package='%(package)s'
AND b.file = fi.id
AND fi.location = l.id
AND l.component = c.id
AND ba.bin=b.id
AND ba.suite = su.id
- AND su.suite_name=:suitename
+ AND su.suite_name=%(suitename)s
ORDER BY b.version DESC"""
- return session.execute(sql, {'package': package, 'suitename': suitename})
+ return session.execute(sql % {'package': package, 'suitename': suitename})
__all__.append('get_binary_from_name_suite')
session = DBConn().session().object_session(self)
# Remove changes_pool_files entries
- for pf in self.poolfiles:
- self.poolfiles.remove(pf)
+ self.poolfiles = []
- # Remove change
- for cf in self.files:
- self.files.remove(cf)
+ # Remove changes_pending_files references
+ self.files = []
# Clear out of queue
self.in_queue = None
session.flush()
- return dsc_component, dsc_location_id, pfs
+ return source, dsc_component, dsc_location_id, pfs
__all__.append('add_dsc_to_db')