in crashclouseau/models.py [0:0]
def get_bid_chan_by_id(uuidid):
r = (
db.session.query(
UUID.uuid, Signature.signature, Build.buildid, Build.channel, Node.node
)
.select_from(UUID)
.join(Build)
.join(Node)
.join(Signature)
)
r = r.filter(UUID.id == uuidid).first()
if r:
return {
"uuid": r.uuid,
"signature": r.signature,
"buildid": r.buildid.astimezone(pytz.utc),
"channel": r.channel,
"node": r.node,
}
return {}