yage
fec8c5e560
introduce --verbosity flag rather than mixed logging settings; correct color misnaming to ANSI convention; added sanity-check; simplified hello-world; created FZF_USER_INPUT to replace the confusing FZF_HEAD and FZF_TAIL swap INFO for DEBUG v3-to-v4 upgrade docs bring some much-needed tender love and care to the scwrypts runner improved i/o handling on the run executable means this is no longer relevant FINALLY fix the weird cases for zsh/read builtin (particularly around reading one character from tty/pipe/file); also gave a --force-user-input flag in case you want to require user input on a yn prompt update ZLE plugin so it no more make errors FZF_(HEAD|TAIL) refactor to FZF_USER_INPUT plugins/kubectl migration from v3 to v4 plugins/ci migration from v3 to v4 refactor py/lib into python-scwrypts subproject verbosity is stupid lets call it log-level fix bug with virtualenv loading mergedeep to slow so I made my options dict shallow hokay first iteration of python-dudes is ready circleci configuration for python builds npm package for scwrypts 3.9.1 initial build/test steps for nodejs go go ok ok fix output ok ok finalize publish steps
42 lines
1020 B
Bash
Executable File
42 lines
1020 B
Bash
Executable File
#!/bin/zsh
|
|
use db/postgres
|
|
#####################################################################
|
|
|
|
MAIN() {
|
|
WARNING " \nthis function is in a beta state\n "
|
|
local _PASS _ARGS=()
|
|
POSTGRES__SET_LOGIN_ARGS $@
|
|
|
|
local INPUT_FILE="$FILENAME"
|
|
|
|
local SQL_DIR="$SCWRYPTS_DATA_PATH/sql"
|
|
[ ! -d $SQL_DIR ] && mkdir -p $SQL_DIR
|
|
|
|
cd $SQL_DIR
|
|
|
|
[[ $(ls "*.sql" 2>&1 | wc -l) -eq 0 ]] && {
|
|
ERROR "you haven't made any SQL commands yet"
|
|
REMINDER "add '.sql' files here: '$SQL_DIR/'"
|
|
return 1
|
|
}
|
|
|
|
[ ! $INPUT_FILE ] && INPUT_FILE=$(FZF 'select a sql file to run')
|
|
[ ! $INPUT_FILE ] && ABORT
|
|
|
|
[ ! -f "$INPUT_FILE" ] && FAIL 2 "no such sql file '$SQL_DIR/$INPUT_FILE'"
|
|
|
|
STATUS "loading '$INPUT_FILE' preview..."
|
|
LESS "$INPUT_FILE"
|
|
|
|
STATUS "login : $_USER@$_HOST:$_PORT/$_NAME"
|
|
STATUS "command : '$INPUT_FILE'"
|
|
|
|
yN 'run this command?' || ABORT
|
|
|
|
STATUS "running '$INPUT_FILE'"
|
|
|
|
PSQL < $INPUT_FILE \
|
|
&& SUCCESS "finished running '$INPUT_FILE'" \
|
|
|| FAIL 3 "something went wrong running '$INPUT_FILE' (see above)"
|
|
}
|