gentoobrowse-api/service/sql/maintenance/ebuildUpdate.sql


1
2
3
4
5
6
7
8
9
10

UPDATE gentoobrowse.ebuilds e SET
	slot = ?,
	license = ?,
	moddate = ?
FROM gentoobrowse.packages p, gentoobrowse.categories c, gentoobrowse.repos r
WHERE c.categoryid = p.categoryid
AND r.name = ?
AND c.name = ?
AND p.name = ?
AND e.version = ?