apop_text_to_db1
Command line utility to convert a text file into a database table
Usage
apop_text_to_db [-d
delimiters]
text_file
table_name
dbname
Overview
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
Releases
6 releases since Debian 8 (Jessie); the text changed 5 times.