3 files changed, 12 insertions, 0 deletions
diff --git a/gentoobrowse-api/service/portageimpl.cpp b/gentoobrowse-api/service/portageimpl.cpp
index ac83557..bb8a215 100644
--- a/gentoobrowse-api/service/portageimpl.cpp
+++ b/gentoobrowse-api/service/portageimpl.cpp
@@ -40,6 +40,7 @@
 #include <sql/portage/getNewsRecent.sql.h>
 #include <sql/portage/getRepository.sql.h>
 #include <sql/portage/getRepositories.sql.h>
+#include <sql/portage/getPackageUrls.sql.h>
 
 namespace Gentoo {
 namespace Service {
@@ -174,6 +175,12 @@ Portage::getUserTrackedRecentVersions(Ice::Int userid, Ice::Int limit, const Ice
 	return fetchCache<Gentoo::Ebuilds>(sql::portage::getUserTrackedRecentVersions, 30, userid, limit);
 }
 
+Gentoo::StringList
+Portage::getPackageUrls(Ice::Int id, const Ice::Current &)
+{
+	return fetchCache<Gentoo::StringList>(sql::portage::getPackageUrls, 30, id);
+}
+
 Gentoo::Categories
 Portage::getCategoriesWithRecentAdditions(Ice::Int syncs, const Ice::Current &)
 {
diff --git a/gentoobrowse-api/service/portageimpl.h b/gentoobrowse-api/service/portageimpl.h
index b27f2a0..be8742a 100644
--- a/gentoobrowse-api/service/portageimpl.h
+++ b/gentoobrowse-api/service/portageimpl.h
@@ -38,6 +38,7 @@ class DLL_PUBLIC Portage : public Gentoo::Portage, IceTray::AbstractCachingDatab
 		Gentoo::Uses getPackageUses(Ice::Int id, const Ice::Current &) override;
 		Gentoo::Packages getUserTrackedPackages(Ice::Int userid, const Ice::Current &) override;
 		Gentoo::Ebuilds getUserTrackedRecentVersions(Ice::Int userid, Ice::Int limit, const Ice::Current &) override;
+		Gentoo::StringList getPackageUrls(Ice::Int id, const Ice::Current &) override;
 
 		Gentoo::UsePtr getUse(const std::string &, const Ice::Current &) override;
 		Gentoo::Uses getGlobalUses(const Ice::Current &) override;
diff --git a/gentoobrowse-api/service/sql/portage/getPackageUrls.sql b/gentoobrowse-api/service/sql/portage/getPackageUrls.sql
new file mode 100644
index 0000000..109b0d9
--- /dev/null
+++ b/gentoobrowse-api/service/sql/portage/getPackageUrls.sql
@@ -0,0 +1,4 @@
+SELECT url
+FROM gentoobrowse.package_urls
+WHERE packageid = ?
+ORDER BY url