in crashclouseau/models.py [0:0]
def get_buildids(no_score=False):
bids = (
db.session.query(
UUID.id, Build.product, Build.channel, Build.buildid, Build.version
)
.select_from(UUID)
.join(Build)
)
bids = (
bids.filter(UUID.useless.is_(no_score), UUID.analyzed.is_(True))
.distinct(Build.product, Build.channel, Build.buildid)
.order_by(Build.buildid.desc())
)
res = {}
for bid in bids:
b = utils.get_buildid(bid.buildid)
if bid.product in res:
r = res[bid.product]
if bid.channel in r:
r[bid.channel].append([b, bid.version])
else:
r[bid.channel] = [[b, bid.version]]
else:
res[bid.product] = {bid.channel: [[b, bid.version]]}
return res