Revision 9348
Added by Aaron Marcuse-Kubitza over 11 years ago
| db.sh | ||
|---|---|---|
| 18 | 18 |
alias mk_schema_esc='declare schema_esc; mk_esc_name schema' |
| 19 | 19 |
alias mk_table_esc='declare table_esc; mk_esc_name table' |
| 20 | 20 |
|
| 21 |
# export func usage: export_func() { ...; mk_select; ... }
|
|
| 22 |
# caller usage: {query=... | table=... [cols=...] [filter=...]} export_func
|
|
| 23 |
# cmd line usage: [limit=...] caller |
|
| 21 | 24 |
alias mk_select='mk_table_esc |
| 22 | 25 |
declare query="$(rtrim "${query:-SELECT ${cols:-*} ${cols:+
|
| 23 | 26 |
}FROM $table_esc |
| ... | ... | |
| 80 | 83 |
} |
| 81 | 84 |
|
| 82 | 85 |
mysql_export() # does not support CSV |
| 86 |
# caller usage: {query=... | table=... [cols=...] [filter=...]} mysql_export
|
|
| 87 |
# cmd line usage: [limit=...] caller |
|
| 83 | 88 |
{
|
| 84 | 89 |
echo_func |
| 85 | 90 |
mk_select |
Also available in: Unified diff
inputs/GBIF/raw_occurrence_record/run table.tsv/make() and functions used by it: added usage comments for cmd line usage, caller usage, and declaring function usage