apop_text_to_db(1)
command line utility to convert a text file into a database table
Description
APOP_TEXT_TO_DB
NAME
apop_text_to_db - command line utility to convert a text file into a database table
SYNOPSIS
apop_text_to_db [-d delimiters] text_file table_name dbname
DESCRIPTION
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 |