Now might be the time to retire it, specifically
because it's almost always outdated.
The idea is that sqlports can generate something
very close, not quite identical because of some
insanity, but I have some sqlite3 script that does
the trick.
So, probably store the result in the portslist
subpackage, so that you don't need any sqlite parts
to use it, and have the actual generating script
(along with some other scripts) in sqlports (or
sqlports-compact) proper.
Right now I have some shell that creates
almost the same thing..
e.g.,
#! /bin/sh
{
echo 'select fullpkgname,fullpkgpath,'
echo '(case prefix when "/usr/local" THEN "" else prefix end),'
echo 'comment,descr,maintainer,categories,'
echo 'lib_depends,build_depends,run_depends,'
echo '(case 1 when fullpkgpath in (select fullpkgpath from onlyforarch) then
only_for_archs else (case 1 when fullpkgpath in (select fullpkgpath from
notforarch) then "!"||not_for_archs else "any" end) end),'
echo '(case lower(PERMIT_PACKAGE_CDROM) when "yes" then "y" else "n" end),'
echo '(case lower(PERMIT_PACKAGE_FTP) when "yes" then "y" else "n" end),'
echo '(case lower(PERMIT_DISTFILES_FTP) when "yes" then "y" else "n" end)'
echo ' from ports where fullpkgpath in (select distinct canonical from paths)
order by fullpkgpath'; } \
|sqlite3 /usr/local/share/sqlports
main differences:
- full set of pkgpaths from the ports tree, not just what's in subdir
- depends are not sorted and not stripped of :patch/:configure
apart from that it's pretty close...
(this is a proof of concept, it probably ought to be based on sqlports-compact
but it's not that difficult to adjust)
