gentoobrowse-api/service/sql/portage/findPackage.sql


1
2
3
4
5
6

-- libdbpp:no-cursor
SELECT p.packageid, p.categoryid, p.name, p.description, p.summary, p.firstseen, p.maintainer, p.maintainername, p.herd
FROM gentoobrowse.packages p, gentoobrowse.categories c
WHERE c.categoryid = p.categoryid
AND c.name = ?
AND p.name = ?