Completion function for sqsh

["Pete Hollobon" <pete@hollobon.com>]

Hi,

This is a completion function for sqsh (http://www.sqsh.org/), a nice
replacement for Sybase isql.

Pete

_sqsh

#compdef sqsh

_sybase_server() {
    local interfaces

    if [[ -n "$opt_args[-I]" ]]; then
        interfaces=${(e)~opt_args[-I]:Q}
    elif [[ -n "$opt_args[-y]" ]]; then
        interfaces=${(e)~opt_args[-y]:Q}/interfaces
    else
        interfaces=$SYBASE/interfaces
    fi

    [[ -f $interfaces ]] && compadd ${${(f)"$(<$interfaces)"}:#[[:space:]#]*}
}

_arguments : \
    '-A[Adjust TDS packet size (512)]:packet size (bytes):(512 1024
1536 2048)' \
    '-B[Turn off file buffering on startup]' \
    '-C[Send sql statment to server]:sql' \
    '-D[Change database context on startup]:database' \
    '-E[Replace default editor (vi)]:editor' \
    '-H[Set the client hostname]:reported hostname' \
    '-I[Alternate interfaces file]:interface file:_files' \
    '-J[Client character set]:charset' \
    '*-L[Set the value of a given variable]:variable=value' \
    '-P[Sybase password (NULL)]:password' \
    '-S[Name of Sybase server (\$DSQUERY)]:_sybase_server' \
    '-U[Name of Sybase user]:username' \
    '-X[Enable client password encryption]' \
    '-a[Max. # of errors before abort]:number' \
    '-b[Suppress banner message on startup]' \
    '*-c[Alias for the ''go'' command]:go alias' \
    '-d[Min. severity level to display]:severity level (0-22)' \
    '-e[Echo batch prior to executing]' \
    '-f[Min. severity level for failure]:failure severity' \
    '-h[Disable headers and footers]' \
    '-i[Read input from file]:_files' \
    '-k[Specify alternate keywords file]:_files' \
    '-l[Set debugging level]' \
    '-m[Set display mode (normal)]:display style:(horiz vert bcp html
meta pretty none)' \
    '-n[Set chained transaction mode]:chained transaction mode:(on off)' \
    '-o[Direct all output to file]:_files' \
    '-p[Display performance stats]' \
    '-r[Specify name of .sqshrc]:_files' \
    '-s[Alternate column separator (\t)]:column separator' \
    '-t[Filter batches through program]:filter program:_files -g "*(*)"' \
    '-v[Display current version and exit]' \
    '-w[Adjust result display width]:number' \
    '-y[Override value of $SYBASE]:_directories' \
    '-z[Alternate display language]:language' \