apop_text_to_db - command line utility to convert a text file into a database
table
apop_text_to_db [
-d delimiters]
text_file table_name
dbname
If the input text file name is a single dash, -, then read from STDIN. Input
must be plain ASCII or UTF-8.
- -d
- the single-character delimiters to use, e.g., -d
" ," or -d "\t" (which you will almost
certainly have to write as -d "\\t") (default:
"|,\t", meaning that any of a pipe, comma, or tab will delimit
separate entries)
- -nc
- data does not include column names
-
-n regex
- case-insensitive regular expression indicating Null values
(default: NaN)
- -m
- use a MySQL database (default: SQLite)
- -f
- fixed width field ends: -f"3,8,12,17"
(first char is one, not zero)
- -u
- mysql username
- -p
- mysql password
- -r
- data includes row names
- -v
- verbosity
- -N
- a comma-separated list of column names:
-N"apple,banana,carrot,durian"
- -en
- if table exists, do nothing and exit
- -ed
- if table exists, retain the table, delete all data, refill
with the new data (i.e., call 'delete * from your_table')
- -eo
- if table exists, overwrite the table from scratch (deleting
the previous table entirely)
- -ea
- if table exists, append new data to the existing table
- -h
- display this help and exit