yum-packages

#!/bin/zsh

setopt extendedglob
yum=/var/cache/yum

function die { echo 1>&2 $*; exit 1 }

function release_number {
    local release=$1 outVarName=$2
    zmodload zsh/regex
    [[ $release -regex-match '([[:digit:]]+)' ]] || return 1
    integer -g "$outVarName=$MATCH"
}

release_number "$(< /etc/redhat-release)" relno ||
die "Can't find redht release number"

if [[ -d $yum/$CPUTYPE/$relno ]]; then
    repodir=$yum/$CPUTYPE/$relno
    dbfile=\*primary.'(xml.gz.)#'sqlite
elif [[ -d $yum/fedora ]]; then
    repodir=$yum
    dbfile=\*primary.sqlite
else
    repodir=$yum
    dbfile=primary.xml.gz.sqlite
fi
repos=($repodir/^*debuginfo/$~dbfile)

function usage {
    cat 1>&2 <<EOF
Usage: ${0:t} [-A] [-s] [-o colName,..] pkgPattern...

Search package directly from yum sqlite db.
Options:
  -A              AND search for pkgPatterns. (Default is OR)
  -s              search from summary.
  -o colName      output column selection. eg. '-o name,version'
  -d              list databases and exit.
EOF
    exit
}
zparseopts -D h=o_help s=opt_s A=opt_AND d=o_listdb \
    -AND=opt_AND \
    o:=opt_output_fields

if (($#o_help)); then
    usage
fi

if (($#o_listdb)); then
    (($#repos)) || exit 1
    # output as assocarray(typeset -A) suitable format.
    for db in $repos; do
	# reponame dbfile
	print ${${db#$repodir/}/\/*/} $db
    done
    exit
fi

column=name
if [[ -n $opt_s ]]; then
    column=summary
fi

WHERE=''
if ((ARGC)); then
    where=()
    integer i
    local name value
    for arg in $argv; do
	if [[ $arg == *=* ]]; then
	    i=$arg[(ri)=]
	    name=$arg[1,$i-1]
	    value=$arg[$i+1,-1]
	    where+=("$name glob ${(qq)value}")
	else
	    where+=("$column glob '$arg'")
	fi
    done
    if (($#opt_AND)); then
	WHERE="WHERE ${(j/ AND /)where}"
    else
	WHERE="WHERE ${(j/ OR /)where}"
    fi
fi

nltab=$'\n\t'

for db in $repos; do
    # repo=${${db#/var/cache/yum/}%/$dbfile}
    repo=${${db#/var/cache/yum/}:h}
    if (($#opt_output_fields)); then
	sql="select ${(j/,/)opt_output_fields[2,-1]}"
	sql+=" from packages $WHERE order by name"
    else
	sql='select name, version, release, '${(qqq)repo}
	sql+=', '${(qqq)nltab}' || summary from packages '$WHERE' order by name'
    fi
    [[ -n $DEBUG ]] && print -r sql=$sql
    sqlite3 -separator $'\t' $db $sql
done