diff options
| author | Zach DeCook <zach.decook@bettercarpeople.com> | 2024-09-03 11:22:56 -0400 |
|---|---|---|
| committer | Zach DeCook <zach.decook@bettercarpeople.com> | 2024-09-03 11:22:56 -0400 |
| commit | ed45f26f1c87ac9a27436288b67af66a8abb20ed (patch) | |
| tree | e1b96a60b99c9d6be44584e45ca20fadab9d7e31 /.local | |
| parent | 906901169301965ff050c415a505086325a9a795 (diff) | |
| download | dotfiles-ed45f26f1c87ac9a27436288b67af66a8abb20ed.tar.gz | |
csv2*: minor changes
Diffstat (limited to '.local')
| -rwxr-xr-x | .local/bin/csv2INSERT.sh | 2 | ||||
| -rwxr-xr-x | .local/bin/csv2sql.sh | 4 |
2 files changed, 5 insertions, 1 deletions
diff --git a/.local/bin/csv2INSERT.sh b/.local/bin/csv2INSERT.sh index 1e20a67..efeb31b 100755 --- a/.local/bin/csv2INSERT.sh +++ b/.local/bin/csv2INSERT.sh @@ -1,6 +1,6 @@ #!/bin/sh read line -echo "INSERT INTO $1 ($line) VALUES" +echo "INSERT IGNORE INTO $1 ($line) VALUES" csv2sql.sh | head -c -2 echo ";" diff --git a/.local/bin/csv2sql.sh b/.local/bin/csv2sql.sh index 7f4a8d5..f080f36 100755 --- a/.local/bin/csv2sql.sh +++ b/.local/bin/csv2sql.sh @@ -3,6 +3,10 @@ tr , "\t" | sed 's/\t\([^"\t]\+\)/\t"\1"/g' | sed 's/\([^"\t]\+\)\t/"\1"\t/g' | +# Switch CSV " escaping to SQL escaping +sed 's/""/\\"/g' | +#sed 's/\\r/\\\\r/g' | +#sed 's/\\n/\\\\n/g' | # replace empty with null, sed 's/\t\t/\tnull\t/g' | sed 's/\t\t/\tnull\t/g' | |