in crashclouseau/models.py [0:0]
def get_two_last(buildid, channel, product):
qs = (
db.session.query(Build.buildid, Build.version, Node.node)
.select_from(Build)
.filter(
Build.buildid <= buildid,
Build.product == product,
Build.channel == channel,
)
)
qs = qs.join(Node).order_by(Build.buildid.desc()).limit(2)
res = [
{
"buildid": utils.get_buildid(q.buildid),
"revision": q.node,
"version": q.version,
}
for q in qs
]
if len(res) == 2:
x = res[0]
res[0] = res[1]
res[1] = x
return res