diff options
Diffstat (limited to 'Tools/scripts/installed-ports-by-origin.sh')
| -rwxr-xr-x | Tools/scripts/installed-ports-by-origin.sh | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/Tools/scripts/installed-ports-by-origin.sh b/Tools/scripts/installed-ports-by-origin.sh new file mode 100755 index 000000000000..5d0d4434fbea --- /dev/null +++ b/Tools/scripts/installed-ports-by-origin.sh @@ -0,0 +1,21 @@ +#!/bin/sh + +# Contributed by Ralf van der Enden <tremere@cainites.net> +# Public domain. + +# Print a list of all installed ports by origin with flavour. +# This is similar to pkg info -qoa, but prints a flavour if the +# package has one. + +sqlite3 /var/db/pkg/local.sqlite \ + "select origin || coalesce('@' || ( + select t4.annotation as annotation + from packages t1 + inner join pkg_annotation t2 on t1.id = t2.package_id + inner join annotation t3 on t2.tag_id = t3.annotation_id + and t3.annotation = 'flavor' + inner join annotation t4 on t2.value_id = t4.annotation_id + and t2.tag_id = t3.annotation_id + and t3.annotation = 'flavor' + where t1.origin = t0.origin), '') + from packages t0;" |