diff options
| -rw-r--r-- | ChangeLog | 7 | ||||
| -rw-r--r-- | Completion/Unix/Command/.distfiles | 1 | ||||
| -rw-r--r-- | Completion/Unix/Command/_sqlite | 50 |
3 files changed, 57 insertions, 1 deletions
diff --git a/ChangeLog b/ChangeLog index add8b4643..fc70c9046 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,3 +1,8 @@ +2012-01-23 Peter Stephenson <pws@csr.com> + + * Ben: 30118: Completion/Unix/Command/_sqlite, + Completion/Unix/Command/.distfiles: new sqlite completion. + 2012-01-22 Peter Stephenson <p.w.stephenson@ntlworld.com> * Ben: 30117 (moved directory): Completion/X/Command/_xclip, @@ -15875,5 +15880,5 @@ ***************************************************** * This is used by the shell to define $ZSH_PATCHLEVEL -* $Revision: 1.5565 $ +* $Revision: 1.5566 $ ***************************************************** diff --git a/Completion/Unix/Command/.distfiles b/Completion/Unix/Command/.distfiles index efc02e87e..e54c6c0d2 100644 --- a/Completion/Unix/Command/.distfiles +++ b/Completion/Unix/Command/.distfiles @@ -200,6 +200,7 @@ _slrn _socket _sort _spamassassin +_sqlite _sqsh _ssh _stgit diff --git a/Completion/Unix/Command/_sqlite b/Completion/Unix/Command/_sqlite new file mode 100644 index 000000000..05027c603 --- /dev/null +++ b/Completion/Unix/Command/_sqlite @@ -0,0 +1,50 @@ +#compdef sqlite sqlite3 + +local ret opt display_opt sqlite3 +local -a options output_modes exclusive dashes + +[[ $service = sqlite3 ]] && sqlite3=true || unset sqlite3 + +# sqlite options require a single hyphen, but +# sqlite3 allows options with one or two +dashes=( '' ) +(( $+sqlite3 )) && dashes+=( - ) + +options=( + '(-init --init)'$^dashes'-init[startup file]:file containing SQLite commands:_files' + $^dashes'-echo[echo commands]' +) + +exclusive=( {,-}-{no,}header ) +options+=( + "($exclusive)"$^dashes'-header[turn headers on]' + "($exclusive)"$^dashes'-noheader[turn headers off]' +) + +output_modes=( column HTML line list ) +(( $+sqlite3 )) && output_modes+=( csv ) +exclusive=( $^dashes-${^output_modes:l} ) +for display_opt in $output_modes ; do + # finagle the description to match the way SQLite's -help formats them + opt=$display_opt:l + [[ $opt = $display_opt ]] && display_opt="'$display_opt'" + options+=( "($exclusive)"$^dashes"-${opt}[set output mode to $display_opt]" ) +done + +options+=( + $^dashes'-separator[set output field separator]:string to separate output fields:' + $^dashes'-nullvalue[set null value string]:string for NULL values:' + '(- :)'$^dashes'-version[show SQLite version]' + '(- :)'$^dashes'-help[show help]' + '1:SQLite database file:_files' + '(- :)2:SQL to run' +) + +(( $+sqlite3 )) && options+=( + $^dashes'-bail[stop after hitting an error]' + '(-*batch -*interactive)'$^dashes'-batch[force batch I/O]' + '(-*batch -*interactive)'$^dashes'-interactive[force interactive I/O]' + $^dashes'-stats[print memory stats before each finalize]' +) + +_arguments $options |