On Sat, Nov 10, 2018 at 08:00:02PM +0100, Marc Espie wrote:
> Now might be the time to retire it, specifically
> because it's almost always outdated.
Removing it is probably the only I'll be motivated to
learn the sql way. :-) No objections from me.
.... Ken
>
> 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)
>
