blob: acba8a9d9d25740b9c2e75f83e8bfcbfc4474ec8 (
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
WHERE c.categoryid = p.categoryid
AND e.packageid = p.packageid
AND e.repoid = ?
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
|
