On Sat, Feb 01, 2020 at 07:10:40PM -0800, Andrew Hewus Fresh wrote:
> After the most recent simplification of portgen's port finding code, I
> think we can stop using sqlports and instead look to see if any
> $PORTSDIR/*/$PKGSTEM exist without a significant loss of functionality.
> We currently look for any FullPkgPath that matches the PKGSTEM in
> sqlports.
> I'm not aware of any module ports where that stem isn't the
> same as the directory name, and if there are, is that worth needing to
> install sqlports and p5-DBD-SQLite?
Turns out, I can ask what those are. Not sure it's still worth it, but
since there are some where we'd find a port that does exist, maybe we
should leave it.
$ cat portgen-diff-stems.sql
SELECT PKGSTEM, _Paths.FullPkgPath
FROM _Paths
JOIN _Ports ON _Paths.PkgPath = _Ports.FullPkgPath
WHERE _Paths.FullPkgPath NOT LIKE '%/' || PKGSTEM
AND _Paths.Id = _Paths.PkgPath
AND ( PKGSTEM LIKE 'p5-%'
OR PKGSTEM LIKE 'py-%'
OR PKGSTEM LIKE 'ruby-%'
)
ORDER BY _Paths.FullPkgPath;
$ sqlite3 /usr/local/share/sqlports < portgen-diff-stems.sql
py-capstone|devel/capstone/python
py-keystone|devel/keystone/python
p5-CursesWidgets|devel/p5-Curses-Widgets
py-pudb|devel/pudb
py-jaraco-functoolsjaraco.functools|devel/py-jaraco-functools
py-setuptools-git|devel/py-setuptools_git
py-zc-lockfilezc.lockfile|devel/py-zc-lockfile
py-game|devel/pygame
py-pysvn|devel/pysvn
py-pyusb|devel/pyusb
py-cython|lang/cython
py-lpsolve|math/lpsolve/python
p5-Business-CreditCard|misc/p5-CreditCard
p5-Mon|net/mon/client
p5-Monitoring-Plugin|net/nagios/p5-Nagios-Plugin
p5-Zonemaster-engine|net/p5-Zonemaster/engine
p5-Zonemaster-LDNS|net/p5-Zonemaster/ldns
p5-Net-SSLeay|security/p5-Net_SSLeay
py-yara|security/yara/python
py-libvirt|sysutils/libvirt-python
p5-Template-GD|textproc/p5-Template-Plugin-GD
p5-librdf|textproc/redland-bindings
p5-HTML-CalendarMonthSimple|www/p5-HTML-Calendar-Month-Simple
p5-Mojolicious|www/p5-Mojo
p5-Perlbal|www/perlbal
py-wstools|www/py-wtools
py-dbus|x11/dbus-python
--
andrew - http://afresh1.com
People who invent random theories which only defend the vendor must have
been beaten as children. Beaten with sticks.
At least, that's my theory.
-- Theo De Raadt
