lib/sh/db.sh: mysql_ANSI: fixed comment

lib/sh/db.sh: pg_dump(): support dumping entire cluster, and cluster users

lib/sh/db.sh: pg_cmd(): added $as_root switch

lib/sh/db.sh pg_dump(), bin/pg_dump_vegbien: --format=plain: removed comment that this is the plain format, because this is now self-documenting

lib/sh/db.sh pg_dump(), bin/pg_dump_vegbien: --format: use the long form of the formats to make the code self-documenting

fix: lib/PostgreSQL-MySQL.csv: preserve schema assignments by translating `SET search_path` to `USE`

bugfix: lib/runscripts/import.run: all(): also need to propagate $rm to import()

bugfix: lib/sh/util.sh: local_array/export_array: do need -a because that it's an array is apparently not autodetected by the () on Mac

lib/sql_gen.py: map_expr(): documented that unlike bin/repl SQL identifier handling, this does simplify the resulting expression

lib/sql_gen.py: map_expr(): documented that this is a special case of bin/repl SQL identifier handling which does not handle entire source files

bin/repl, lib/sql_gen.py Expression transforming: documented that this can also be done in Postgres with expression substitution (wiki.vegpath.org/Postgres_queries#expression-substitution)

bugfix: lib/runscripts/table.run: table_make_install(): need to ignore skip_table() errexit

lib/sh/util.sh: import_vars: documented that vars already set will not be overwritten

fix: lib/common.Makefile: $(nice): use an increment of +10 instead of +5 because +5 still leaves the shell sluggish

lib/common.Makefile: added $(nice) and use it everywhere its definition is used

fix: lib/sql_io.py: put_table(): don't warn if can't create pkey, because this just indicates that a set-returning function was used. this should get rid of the last of the confusing benign warnings in the test output.

fix: lib/sql.py: flatten(): don't warn if can't create pkey, because this just indicates that a set-returning function was used

lib/sql.py: run_query_into() added add_pkey_warn param to support turning off "could not create unique index" warnings, which are sometimes benign (eg. when using set-returning functions with column-based import)

lib/sh/util.sh: removed end_try_subshell, which now does the same thing as end_try

fix: lib/sh/archives.sh: unzip(): support -p option, which pipes extracted data to stdout

added lib/runscripts/extract_header.run

fix: lib/sh/make.sh: direct the user to use begin_target instead of set_make_vars (set_make_vars is now used by begin_target)

fix: lib/runscripts/util.run: to_top_file(): handle $_remake properly, without requiring deferred_check_target_exists to set to_file()'s flags

bugfix: lib/sh/util.sh: die(): usage: documented that if msg uses $(...), save_e is needed

bugfix: lib/sh/util.sh: already_exists_msg(): need to save_e, because new $(mk_hint) call resets $?

lib/sh/util.sh: die(): always errexit even if $e = 0, because die always indicates an error

lib/sh/util.sh: added rethrow!(), which always errexits, even if $e = 0

lib/sh/util.sh: rethrow(): also work in situations where $e is not set

lib/sh/util.sh: rethrow: made it a function since there is now no need for it to be an alias

lib/sh/util.sh: rethrow: removed `test "$e" != 0` since errexit only does anything if $e != 0

lib/sh/util.sh: removed separate rethrow_exit*, rethrow_subshell*, since they now do the same thing as rethrow*

lib/sh/util.sh: rethrow*!: use new errexit, which works in functions and subshells

lib/sh/util.sh: added errexit(), used in place of (exit "$1") because a bug in bash prevents subshells from triggering errexit

lib/sh/util.sh: added bool!()

fix: lib/sh/util.sh: redir(): need to indent before invoking an external command (not just in command__exec(), but for all redir() calls)

lib/sh/make.sh: with_rm(): documented that it only works inside a runscript target that starts w/ begin_target

*{.sh,run}: runscript targets: use begin_target instead of echo_func so the target name is properly echoed. note that this requires using with_rm so that $rm is properly progagated to applicable invoked targets. (previously, $rm was progagated to all invoked targets. note that with_rm only works inside a runscript target that starts with begin_target.)

lib/sh/make.sh: self_make(): renamed to with_rm() for clarity, since this is used only to progagate $rm, and does not also invoke a command with the same name as the current function, as the name might suggest

lib/runscripts/util.run: support conventional main() method as well as `all` target

bugfix: lib/sh/sync.sh: don't unintentionally rsync-ignore explicitly-specified files

lib/sh/util.sh: filesystem: added is_*(), could_be_*()

lib/sh/util.sh: added contains_match()

lib/sh/util.sh: added ends_with()

bugfix: lib/common.Makefile: $(add*): need to wrap w/ $(wildcard) to prevent "targets don't exist" error, because svn 1.7 does not suppress this error even with --force

bugfix: lib/runscripts/table.run: schema/make calls: need to use `make schema` instead because old-style datasources don't have a top-level runscript (the absence of this identifies them as old-style so inputs/input.Makefile works correctly)

bugfix: lib/sh/util.sh: DON'T do `shopt -s lastpipe` because this causes a segfault on Linux in stderr_matches(). (it also isn't supported on Mac.) use @PIPESTATUS instead. note that we do not currently need lastpipe, since we use @PIPESTATUS (which actually provides more functionality for our purposes).

fix: lib/sh/util.sh: echo_func(): file/line #: display with regular color because the lighter color actually draws attention to rather than away from the faded text

lib/sh/util.sh: added plain()

bugfix: lib/sql_io.py: put_table(): is_literals: `return sql.value(cur): need to use sql.value_or_none() instead to support multi-row functions, such as _split() used in specimens data`

lib/runscripts/util.run: on_exit(): documented that users can also override gateway()/fallback() to perform other commands (or no commands) after the script is read

bugfix: lib/sh/db.sh: pg_table_exists(): need ! to negate boolean result

fix: lib/runscripts/table.run: table_make_install(): need to inform the user when it skips installing a table, because this is often unexpected

fix: lib/runscripts/util.run: run_args_cmd(): need to indent the output of the target that it's running

lib/runscripts/table.run: removed no longer used datasrc_make_install()

fix: lib/sh/util.sh: fade(): use medium gray instead of light gray because it fades on white and black backgrounds

lib/sh/util.sh: echo_func(): fade the file/line # to avoid distracting from the function call in the default log output

lib/sh/util.sh: added fade()

lib/sh/util.sh: highlight_msg(): renamed to highlight_log_msg() to clarify that this contains log++-specific functionality

lib/sh/util.sh: moved terminal formatting commands to own section

lib/sh/util.sh: highlight_msg(): moved formatting code into separate format() function

lib/sh/util.sh: dp(): renamed to ps() to corresponding with pv/pf

lib/sh/make.sh: echo_target: use `log-- echo_func`, which now puts the target name first but also provides much-needed indentation

lib/sh/util.sh: echo_func(): put file/line # after function call instead of before so the function name is listed first

lib/sh/util.sh: echo_func(): usage: removed no longer used/implemented minor=1 switch. use log++ instead.

lib/runscripts/datasrc_dir.run: import(): use new schema/make, schema/rm

lib/runscripts/table.run: load_data(): use the much simpler `schema/make` run target, rather than outsourcing to the legacy Makefile via the convoluted datasrc_make_install()/table_make_install()

lib/runscripts/datasrc_dir.run: added schema/rm(), schema/make()

lib/sh/util.sh: ignore_err_msg(): usage: added $ignore_e param from stderr_matches()

lib/runscripts/table.run: psql: always include ; at end of statement

fix: lib/sh/db.sh: pg_cmd(): hide PGPASSWORD at the normal verbosity so that the value of it doesn't appear in any log files

lib/sh/util.sh: log_hint(): renamed to log_err_hint() for clarity, because this applies only to hints for errors

bugfix: lib/sh/util.sh: log_hint!(): use log_err instead of log_info because hints as used here are attached to (possibly benign) errors. for other uses, use mk_hint().

fix: lib/sh/util.sh: highlight_msg(): don't ' '-pad already-formatted text

lib/sh/util.sh: manual terminal escape sequences: use highlight_msg() instead

lib/sh/util.sh: highlight_msg(): auto-add padding around text if there is a background

lib/sh/util.sh: highlight_msg(): use $format itself as the $highlight boolean

lib/sh/util.sh: highlight_msg(): split apart the testing of $format and can_highlight_msg

lib/sh/util.sh: added has_bg()

bugfix: lib/sh/util.sh: highlight_msg(): need to reset any existing formatting before applying new formatting

lib/sh/util.sh: added mk_hint() and use it in log_hint!()

lib/sh/util.sh: bg_cmd(): also log the command being run

fix: lib/sh/util.sh: need `function` before functions that have an alias with the same name

lib/sh/util.sh: log!(): use new log:()

lib/sh/util.sh: added log:(), which sets an explicit log_level. this also simplifies log+().

lib/sh/util.sh: log+(): set log_level before PS4 so that the PS4 expr doesn't also need to add to log_level

lib/sh/util.sh: removed no longer needed log+ alias (which had been renamed from clog+)

lib/sh/util.sh: clog*: renamed to log* for clarity (possible now that log* is no longer used for function-local log_level setting)

: local setting of log_level: use log_local instead of relying on the log aliases, so that these aliases can instead be used for wrapping commands (the more common use case)

bugfix: lib/sh/util.sh: verbosity_compat alias: need to use `declare verbosity="$verbosity"` instead of `declare verbosity`, which would just clear $verbosity

bugfix: lib/sh/util.sh: verbosity_min alias: need to use `declare verbosity="$verbosity"` instead of log_local now that verbosity is not one of the vars changed by log++

lib/sh/util.sh: log+(): use easier-to-understand log_local instead of prefix-assignments to limit assignments to the invoked command

lib/sh/util.sh: log+(): use easier-to-understand log_local instead of prefix-assignments to limit assignments to the invoked command

: use clog instead of "log*"

bugfix: lib/sh/util.sh: log+(): removed spurious ; between setting of PS4 and log_level, which was causing erratic mismatches between PS4 and log_level. (the ; caused $PS4 to be set in the caller when invoked via one of the clog* aliases, rather than being passed as a command-specific env var.)

lib/sh/util.sh: $verbosity: stay constant at what the user set it to instead of changing in tandem with $log_level, to facilitate debugging verbosity/log_level-related issues

lib/sh/util.sh: log+(): usage: use aliases instead of ""-ed function names

lib/sh/util.sh: log_err(): use red background for better visibility of errors, in the same way that lib/exc.py print_ex() does for column-based import

bugfix: lib/sh/util.sh: removed echo_func in functions used by log++, to avoid spurious highlighted output

lib/sh/util.sh: added missing clog+ alias

bugfix: lib/sh/util.sh: log_hint(): use the standard log_fd and log_info() format, not err_fd and log_err() format, for hint messages