blob: f5a42c53cc000d060b00416676f3147f1ff6116b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- libdbpp:no-cursor
UPDATE gentoobrowse.ebuilds e SET
slot = ?,
license = ?,
moddate = ?
FROM gentoobrowse.packages p, gentoobrowse.categories c, gentoobrowse.repos r
WHERE c.categoryid = p.categoryid
AND e.packageid = p.packageid
AND r.name = ?
AND c.name = ?
AND p.name = ?
AND e.version = ?
RETURNING ebuildid, NOT EXISTS (
SELECT FROM gentoobrowse.ebuilds ve
WHERE ve.packageid = e.packageid
AND ve.versioninst > e.versioninst
), e.packageid
|
